Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:3 [ "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=1550&$filter=(StandardStatus eq 'Active') and City eq 'Hamilton'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=1550&$filter=(StandardStatus eq 'Active') and City eq 'Hamilton'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=1550&$filter=(StandardStatus eq 'Active') and City eq 'Hamilton'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=1550&$filter=(StandardStatus eq 'Active') and City eq 'Hamilton'&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2862 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2855 +post_id: "539452" +post_author: 1 +"ListingKey": "X12478891" +"ListingId": "X12478891" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-22T19:35:48Z" +"RFModificationTimestamp": "2026-03-15T04:27:04Z" +"ListPrice": 2500.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2328.0 +"City": "Hamilton" +"PostalCode": "L8M 1K1" +"UnparsedAddress": "663 Main Street E, Hamilton, ON L8M 1K1" +"Coordinates": array:2 [ …2] +"Latitude": 43.2488 +"Longitude": -79.8435499 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXP REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "This prime 2,300+ sq ft commercial retail space is located in the heart of Downtown Hamilton, offering exceptional visibility on a high-traffic street with strong daily footfall and drive by exposure. Positioned in a rapidly growing urban corridor surrounded by ongoing redevelopment, this property presents an outstanding opportunity for a business seeking a high-profile location with built-in credibility. Previously occupied by a successful business that was located here for over 30 years, the space carries a legacy of stability and community presence, making it ideal for retailers, showrooms, service-based operators, boutique brands, or professional users looking to establish themselves in a vibrant commercial setting. The property includes two dedicated parking spots, a rare advantage in the downtown core, and sits among a mix of established neighbourhood amenities, new developments, and an expanding residential base that continues to fuel demand for local services. With its historic past and modern growth potential, this location offers the perfect balance between character, convenience, and high exposure for a long-term business footprint in one of Hamilton's most active commercial areas." +"BuildingAreaUnits": "Square Feet" +"CityRegion": "St. Clair" +"Cooling": "Yes" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-03-09T03:06:53.018889+00:00" +"CrossStreet": "Main St E & Fairleigh" +"Directions": "Main St E" +"ExpirationDate": "2026-05-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-10-23" +"MainOfficeKey": "285400" +"MajorChangeTimestamp": "2025-12-22T19:35:48Z" +"MlsStatus": "Price Change" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-10-23T18:12:02Z" +"OriginalListPrice": 2600.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3172532" +"PhotosChangeTimestamp": "2025-10-23T18:12:02Z" +"PreviousListPrice": 2600.0 +"PriceChangeTimestamp": "2025-12-22T19:35:48Z" +"SecurityFeatures": array:1 [ …1] +"ShowingRequirements": array:3 [ …3] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "Main" +"StreetNumber": "663" +"StreetSuffix": "Street" +"TaxAnnualAmount": "8100.0" +"TaxYear": "2024" +"TransactionBrokerCompensation": "Half Month Rent" +"TransactionType": "For Lease" +"Utilities": "Available" +"Zoning": "C2" +"DDFYN": true +"Water": "Municipal" +"LotType": "Building" +"TaxType": "Annual" +"HeatType": "Electric Forced Air" +"LotDepth": 80.0 +"LotWidth": 30.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12478891')" +"GarageType": "None" +"RetailArea": 2328.0 +"PropertyUse": "Retail" +"RentalItems": "Hot water heater Tank" +"HoldoverDays": 180 +"HeatTypeMulti": array:1 [ …1] +"ListPriceUnit": "Month" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8M 1K1, CA" +"ContractStatus": "Available" +"PossessionDate": "2025-11-01" +"PossessionType": "Immediate" +"PriorMlsStatus": "New" +"RetailAreaCode": "Sq Ft" +"MediaChangeTimestamp": "2025-10-23T18:12:02Z" +"MaximumRentalMonthsTerm": 48 +"MinimumRentalTermMonths": 12 +"SystemModificationTimestamp": "2025-12-22T19:35:48.798862Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:7 [ …7] +"ID": "539452" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2857 +post_id: "520166" +post_author: 1 +"ListingKey": "X12496752" +"ListingId": "X12496752" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-17T14:46:16Z" +"RFModificationTimestamp": "2026-02-07T16:09:46Z" +"ListPrice": 399999.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8E 0K3" +"UnparsedAddress": "125 Shoreview Place 638, Hamilton, ON L8E 0K3" +"Coordinates": array:2 [ …2] +"Latitude": 43.2390543 +"Longitude": -79.7197856 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CHASE REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover modern lakeside living in this stunning 1-bedroom, 1-bathroom condo featuring expansive floor-to-ceiling windows and an oversized balcony perfect for relaxing or entertaining. The bright, open-concept layout is completely carpet-free with a sleek modern design throughout and includes in-suite laundry for added convenience. Enjoy premium building amenities including a party room, rooftop patio with stunning lakeside views, and a fully equipped exercise room. This unit comes with owned parking and a locker, plus plenty of visitor parking. Efficient geothermal heating and central air for year-round comfort. Don't miss this incredible opportunity to own a contemporary condo in a desirable lakeside location!" +"ArchitecturalStyle": "Apartment" +"AssociationAmenities": array:5 [ …5] +"AssociationFee": "467.35" +"AssociationFeeIncludes": array:5 [ …5] +"Basement": array:1 [ …1] +"CityRegion": "Lakeshore" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2026-02-07T13:39:25.467883+00:00" +"CrossStreet": "Millen Rd to Shoreview Pl" +"Directions": "Millen Rd to Shoreview Pl, Left on Shoreview, Last Entrance on Right" +"Disclosures": array:1 [ …1] +"ExpirationDate": "2026-05-29" +"GarageYN": true +"Inclusions": "Fridge, Stove, Range Hood/Microwave, Dishwasher, Washer, Dryer. Option to purchase furnished." +"InteriorFeatures": "Carpet Free" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-10-31" +"LotSizeSource": "MPAC" +"MainOfficeKey": "248800" +"MajorChangeTimestamp": "2025-10-31T17:47:53Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-10-31T17:47:53Z" +"OriginalListPrice": 399999.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3192512" +"ParcelNumber": "185891333" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2025-10-31T19:06:23Z" +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Shoreview" +"StreetNumber": "125" +"StreetSuffix": "Place" +"TaxAnnualAmount": "3051.6" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% +HST" +"TransactionType": "For Sale" +"UnitNumber": "638" +"WaterBodyName": "Lake Ontario" +"WaterfrontFeatures": "Beach Front" +"WaterfrontYN": true +"DDFYN": true +"Locker": "Owned" +"Exposure": "North East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12496752')" +"Shoreline": array:1 [ …1] +"WaterView": array:1 [ …1] +"ElevatorYN": true +"GarageType": "Underground" +"HeatSource": "Ground Source" +"RollNumber": "251800304020219" +"SurveyType": "Unknown" +"Waterfront": array:1 [ …1] +"BalconyType": "Open" +"DockingType": array:1 [ …1] +"RentalItems": "None" +"HoldoverDays": 60 +"LegalStories": "6" +"ParkingSpot1": "Underground Space #301" +"ParkingType1": "Owned" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"WaterBodyType": "Lake" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8E 0K3, CA" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"CondoCorpNumber": 589 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "500-599" +"RoomsAboveGrade": 4 +"AccessToProperty": array:1 [ …1] +"AlternativePower": array:1 [ …1] +"EnsuiteLaundryYN": true +"SquareFootSource": "LBO Provided" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 1 +"KitchensAboveGrade": 1 +"ShorelineAllowance": "None" +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Lockbox located at 101 Shoreview Pl - in Lobby" +"WaterfrontAccessory": array:1 [ …1] +"LegalApartmentNumber": "638" +"MediaChangeTimestamp": "2025-10-31T19:06:23Z" +"PropertyManagementCompany": "Wilson Blanchard" +"SystemModificationTimestamp": "2025-12-17T14:46:16.611179Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:46 [ …46] +"ID": "520166" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2854 +post_id: "532882" +post_author: 1 +"ListingKey": "X12633560" +"ListingId": "X12633560" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-15T15:15:34Z" +"RFModificationTimestamp": "2026-02-28T01:18:16Z" +"ListPrice": 1950.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3100.0 +"City": "Hamilton" +"PostalCode": "L8L 2V5" +"UnparsedAddress": "18 Barton Street E, Hamilton, ON L8L 2V5" +"Coordinates": array:2 [ …2] +"Latitude": 43.2637456 +"Longitude": -79.8651045 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE STATE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 18 Barton Street East - a beautifull main-floor commercial space at the high-traffic corner of James St. N. and Barton St. E. This turnkey unit is ideal for a salon, wellness clinic, RMT, chiropractor, nail bar, or other personal care business. Featuring approx. 800 sq.ft. of stunning interior space, in-suite laundry, and basement storage. The building blends historic charm with modern amenities. Located just steps from some of the city's trendiest shops and restaurants, this space offers maximum visibility in a vibrant, high-foot-traffic area." +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ …1] +"CityRegion": "Beasley" +"CommunityFeatures": "Public Transit" +"Cooling": "No" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-02-27T02:30:27.309554+00:00" +"CrossStreet": "James St N. & Barton St. E." +"Directions": "James St. N. East on Barton" +"ExpirationDate": "2026-06-15" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-15" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "288000" +"MajorChangeTimestamp": "2025-12-15T15:15:34Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-12-15T15:15:34Z" +"OriginalListPrice": 1950.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3350456" +"ParcelNumber": "171610050" +"PhotosChangeTimestamp": "2025-12-15T15:15:34Z" +"SecurityFeatures": array:1 [ …1] +"Sewer": "Sanitary+Storm" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "Barton" +"StreetNumber": "18" +"StreetSuffix": "Street" +"TaxAnnualAmount": "7743.59" +"TaxLegalDescription": "PT LT 11-12 PL 181 AS IN HL23644, T/W INTEREST IN VM264501; CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "1/2 Month's Rent + HST" +"TransactionType": "For Lease" +"Utilities": "Yes" +"Zoning": "H" +"Rail": "No" +"DDFYN": true +"Water": "Municipal" +"LotType": "Lot" +"TaxType": "Annual" +"HeatType": "Gas Forced Air Open" +"LotDepth": 90.0 +"LotShape": "Rectangular" +"LotWidth": 18.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12633560')" +"GarageType": "None" +"RetailArea": 980.0 +"RollNumber": "251802015655430" +"PropertyUse": "Multi-Use" +"ElevatorType": "None" +"HoldoverDays": 60 +"HeatTypeMulti": array:1 [ …1] +"ListPriceUnit": "Net Lease" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8L 2V5, CA" +"ContractStatus": "Available" +"FreestandingYN": true +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"RetailAreaCode": "Sq Ft" +"PossessionDetails": "Flexible" +"MediaChangeTimestamp": "2025-12-15T15:15:34Z" +"MaximumRentalMonthsTerm": 60 +"MinimumRentalTermMonths": 36 +"SystemModificationTimestamp": "2025-12-15T15:15:35.033136Z" +"Media": array:27 [ …27] +"ID": "532882" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2858 +post_id: "528308" +post_author: 1 +"ListingKey": "X12614468" +"ListingId": "X12614468" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-10T01:01:48Z" +"RFModificationTimestamp": "2026-02-11T04:20:49Z" +"ListPrice": 799999.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8L 4X8" +"UnparsedAddress": "575 Mary Street, Hamilton, ON L8L 4X8" +"Coordinates": array:2 [ …2] +"Latitude": 43.2722078 +"Longitude": -79.856884 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CENTURY 21 HERITAGE GROUP LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 575 Mary Street, a stunningly unique property steps from the water's edge in the north end of Hamilton, where a tight-knit family transformed a house into a home during the quiet of Covid lockdowns. Step inside this fully renovated gem, seamlessly blending modern comforts with warm, inviting spaces, all crafted by a talented Hamilton native and international artist. The artistic flair captivates, merging the natural light of the outdoors with glass, cement, and crisp whites throughout. At the heart of the home is a stunning kitchen featuring floor-to-ceiling cabinetry, a four-seater waterfall quartz island, and very likely the most interesting matching Italian porcelain flooring and backsplash combo you have ever seen. The front porch, drenched in light from two skylights, is perfect for sipping morning coffee while enjoying the sunrise. On the opposite side of the house, cozy evenings come alive by the newly installed wood-burning fireplace, which warms the all-season backyard patio designed for both entertaining and relaxing after a long day. This home also features an innovative and massive office space seamlessly integrated into the main bedroom, ideal for remote work or midnight inspiration. With HUE smart lights throughout, you can easily set the perfect mood for any occasion. In the last four years, recent upgrades include Neal installed roof coverings, a high-efficiency furnace, all new flooring, windows, all siding, main floor powder room, brand-new kitchen and laundry appliances. This means you can move in and enjoy modern living! With three spacious bedrooms plus an office, this home provides ample space for families, guests, or your creative pursuits. Plus, convenience is key with two included parking spaces and an upgraded fast-charging EV connection port already installed. Come fall in love with this art piece of a home. A space ready for some new dreamers and creative spirits!" +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ …2] +"CityRegion": "North End" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-02-07T17:44:49.493563+00:00" +"CrossStreet": "Mary St. and Brock St." +"DirectionFaces": "West" +"Directions": "Burlington St. E. to Mary St." +"Exclusions": "None." +"ExpirationDate": "2026-06-05" +"ExteriorFeatures": "Porch Enclosed,Porch" +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"Inclusions": "Fridge, stove, dishwasher, washer, and dryer." +"InteriorFeatures": "Water Heater,Other" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-09" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "248500" +"MajorChangeTimestamp": "2025-12-10T01:01:48Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-12-10T01:01:48Z" +"OriginalListPrice": 799999.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3348180" +"ParcelNumber": "171550215" +"ParkingFeatures": "Front Yard Parking,Private Double" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-12-10T01:01:48Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Mary" +"StreetNumber": "575" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3390.0" +"TaxLegalDescription": "PT LT 44 OR 81 NATHANIEL HUGHSON SURVEY (UNREGISTERED) W/S MARY ST BTN BURLINGTON ST & BROCK ST AS IN CD481453; CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% +HST" +"TransactionType": "For Sale" +"View": array:1 [ …1] +"VirtualTourURLBranded": "https://iframe.videodelivery.net/e60499a5b6ac0e7fdab37cf01d2c3d51" +"VirtualTourURLBranded2": "https://my.matterport.com/show/?m=ms84GXX4mg Z" +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=ms84GXX4mg Z" +"VirtualTourURLUnbranded2": "https://iframe.videodelivery.net/6f86174062b86615fe67c0fe20d7a24e" +"Zoning": "D" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Available" +"HeatType": "Forced Air" +"LotDepth": 120.0 +"LotShape": "Rectangular" +"LotWidth": 20.0 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12614468')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251802016605960" +"SurveyType": "Unknown" +"Waterfront": array:1 [ …1] +"Winterized": "Fully" +"ElectricYNA": "Yes" +"RentalItems": "Water heater." +"HoldoverDays": 120 +"LaundryLevel": "Main Level" +"TelephoneYNA": "Available" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8L 4X8, CA" +"ApproximateAge": "100+" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-01-09" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1500-2000" +"MortgageComment": "Seller to discharge mortgage." +"RoomsAboveGrade": 8 +"ParcelOfTiedLand": "No" +"PropertyFeatures": array:6 [ …6] +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Broker Bay/LBO. Please remove shoes, leave card, turn off lights, lock all doors." +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"MediaChangeTimestamp": "2025-12-10T01:01:48Z" +"SystemModificationTimestamp": "2025-12-10T01:01:48.667708Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:50 [ …50] +"ID": "528308" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2856 +post_id: "527062" +post_author: 1 +"ListingKey": "X12609296" +"ListingId": "X12609296" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-08T21:23:02Z" +"RFModificationTimestamp": "2026-02-27T04:54:53Z" +"ListPrice": 23.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1555.0 +"City": "Hamilton" +"PostalCode": "L8R 2L4" +"UnparsedAddress": "297 James Street N, Hamilton, ON L8R 2L4" +"Coordinates": array:2 [ …2] +"Latitude": 43.3382023 +"Longitude": -79.8903385 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLLIERS" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Your business belongs on James Street North - Hamilton's thriving arts and culture corridor. This 1,555 sq. ft. retail space offers prime frontaage, strong foot traffic, and proximity to the newly renovated TD Coliseum, just a short walk from the GO Station via the upcoming pedestrian pathway. Surrounded by independent restaurants, boutiques, and creative businesses, it's an ideal home for a boutique retailer, cafe or service-based concept ready to tap into the neighbourhood's energy. Make your mark where Hamilton comes to life." +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ …1] +"CityRegion": "Central" +"Cooling": "Yes" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-02-27T04:07:05.260115+00:00" +"CrossStreet": "James St N & Colbourne" +"Directions": "James St N & Colbourne" +"ExpirationDate": "2026-06-08" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-08" +"MainOfficeKey": "336800" +"MajorChangeTimestamp": "2025-12-08T15:06:50Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-12-08T15:06:50Z" +"OriginalListPrice": 23.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3329670" +"ParcelNumber": "171600191" +"PhotosChangeTimestamp": "2025-12-08T15:06:50Z" +"SecurityFeatures": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "James" +"StreetNumber": "297" +"StreetSuffix": "Street" +"TaxAnnualAmount": "10.03" +"TaxLegalDescription": "PT LT 2 BLK 1 PL 127 AS IN VM78045 CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "3.5% 1st Year, 2% Thereafter" +"TransactionType": "For Lease" +"Utilities": "Available" +"Zoning": "H" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unit" +"TaxType": "TMI" +"HeatType": "Gas Forced Air Open" +"LotDepth": 120.0 +"LotWidth": 26.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12609296')" +"GarageType": "None" +"RetailArea": 1555.0 +"RollNumber": "251802012656600" +"PropertyUse": "Retail" +"HoldoverDays": 90 +"HeatTypeMulti": array:1 [ …1] +"ListPriceUnit": "Sq Ft Net" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8R 2L4, CA" +"ContractStatus": "Available" +"FreestandingYN": true +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"RetailAreaCode": "Sq Ft" +"PossessionDetails": "Immediate" +"MediaChangeTimestamp": "2025-12-08T15:06:50Z" +"MaximumRentalMonthsTerm": 120 +"MinimumRentalTermMonths": 60 +"SystemModificationTimestamp": "2025-12-08T21:23:02.334431Z" +"Media": array:7 [ …7] +"ID": "527062" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2849 +post_id: "526522" +post_author: 1 +"ListingKey": "X12609290" +"ListingId": "X12609290" +"PropertyType": "Commercial Lease" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-08T15:06:16Z" +"RFModificationTimestamp": "2026-02-07T20:29:15Z" +"ListPrice": 23.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 271.0 +"LivingArea": 0 +"BuildingAreaTotal": 1555.0 +"City": "Hamilton" +"PostalCode": "L8R 2L4" +"UnparsedAddress": "297 James Street N, Hamilton, ON L8R 2L4" +"Coordinates": array:2 [ …2] +"Latitude": 43.3382023 +"Longitude": -79.8903385 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLLIERS" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Your business belongs on James Street North Hamilton's thriving arts and culture corridor. This 1,555 sq. ft. retail space offers prime frontage, strong foot traffic, and proximity to the newly renovated TD Coliseum, just a short walk from the GO station via the upcoming pedestrian walkway. Surrounded by independent restaurants, boutiques and creative businesses, it's an ideal home for a bouqitue retailer, cafe or service-based concept ready to tap into the neighbourhood's energy. Make your mark where Hamilton comes to life." +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ …1] +"CityRegion": "Central" +"Cooling": "Yes" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-02-07T19:05:30.852759+00:00" +"CrossStreet": "James St N & Colbourne" +"Directions": "James St N & Colbourne" +"ExpirationDate": "2026-06-08" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-08" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "336800" +"MajorChangeTimestamp": "2025-12-08T15:06:16Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-12-08T15:06:16Z" +"OriginalListPrice": 23.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3329342" +"ParcelNumber": "171600191" +"PhotosChangeTimestamp": "2025-12-08T15:06:16Z" +"SecurityFeatures": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "James" +"StreetNumber": "297" +"StreetSuffix": "Street" +"TaxAnnualAmount": "10.03" +"TaxLegalDescription": "PT LT 2 BLK 1 PL 127 AS IN VM78045 CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "3.5% 1st Year, 2% Thereafter" +"TransactionType": "For Lease" +"Utilities": "Available" +"Zoning": "H" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unit" +"TaxType": "TMI" +"HeatType": "Gas Forced Air Open" +"LotDepth": 120.0 +"LotShape": "Rectangular" +"LotWidth": 26.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12609290')" +"GarageType": "None" +"RollNumber": "251802012656600" +"PropertyUse": "Office" +"ElevatorType": "None" +"HoldoverDays": 90 +"HeatTypeMulti": array:1 [ …1] +"ListPriceUnit": "Sq Ft Net" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8R 2L4, CA" +"ContractStatus": "Available" +"FreestandingYN": true +"PossessionDate": "2025-12-08" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"LotSizeAreaUnits": "Square Meters" +"PossessionDetails": "Immediate" +"OfficeApartmentArea": 1555.0 +"MediaChangeTimestamp": "2025-12-08T15:06:16Z" +"MaximumRentalMonthsTerm": 120 +"MinimumRentalTermMonths": 60 +"OfficeApartmentAreaUnit": "Sq Ft" +"SystemModificationTimestamp": "2025-12-08T15:06:16.284511Z" +"Media": array:7 [ …7] +"ID": "526522" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2847 +post_id: "524957" +post_author: 1 +"ListingKey": "X12599404" +"ListingId": "X12599404" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-03T21:54:44Z" +"RFModificationTimestamp": "2026-02-01T00:18:42Z" +"ListPrice": 1829990.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9K 0K3" +"UnparsedAddress": "467 Klein Circle, Hamilton, ON L9K 0K3" +"Coordinates": array:2 [ …2] +"Latitude": 43.2125013 +"Longitude": -79.9480402 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE MACRO REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "A rare opportunity to own a 3,329 sq. ft. luxury residence on an exclusive pie-shaped lot in the prestigious Meadowlands of Ancaster. To be built by a well-known, long-standing local builder, this executive 4-bed, 3.5-bath home offers an elevated living experience reserved for those who refuse to compromise on quality, space, or style. From the moment you arrive, the full brick exterior and architectural presence set a tone of modern sophistication. Inside, every detail is thoughtfully curated from the quartz countertops, elegant oak stairs, and a beautifully designed kitchen complete with a walk-in pantry, ideal for gourmet cooking and stylish entertaining. Each bedroom features its own private bathroom, giving your family and guests the comfort of boutique-hotel living. The covered rear porch extends your luxury outdoors, creating a stunning space for year-round enjoyment while taking full advantage of the oversized lot. Set within the Meadowlands, this home offers schools, scenic parks, trails, shopping, dining, and effortless connections to HWY 403, the LINC, and transit. Closings are scheduled for 2026, and discerning buyers still have the opportunity to select colours, finishes, and specifications allowing for a personalized, designer-level build. Opportunities like this are extremely limited. Premium pie-shaped lots paired with luxury new construction rarely become available and they never last. Secure this one before it's gone." +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ …2] +"CityRegion": "Meadowlands" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "None" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2026-01-31T22:45:06.993245+00:00" +"CrossStreet": "RYMAL AND SPRINGBROOK" +"DirectionFaces": "South" +"Directions": "RYMAL TO NORTH ON SPRINGBROOK, WEST ON SHARP TO KLEIN CIRCLE" +"ExpirationDate": "2026-06-30" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"InteriorFeatures": "None" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-02" +"MainOfficeKey": "311200" +"MajorChangeTimestamp": "2025-12-03T21:54:44Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-12-03T21:54:44Z" +"OriginalListPrice": 1829990.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3325294" +"ParcelNumber": "175656225" +"ParkingFeatures": "Private Double" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-12-03T21:54:44Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Klein" +"StreetNumber": "467" +"StreetSuffix": "Circle" +"TaxLegalDescription": "LOT 44, PLAN 62M1292 SUBJECT TO AN EASEMENT IN GROSS AS IN WE1672595" +"TaxYear": "2025" +"TransactionBrokerCompensation": "$20,000 + HST" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 135.06 +"LotWidth": 36.8 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12599404')" +"GarageType": "Attached" +"HeatSource": "Gas" +"SurveyType": "None" +"HoldoverDays": 120 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L9K 0K3, CA" +"ApproximateAge": "New" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "90+ days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 2 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "3000-3500" +"RoomsAboveGrade": 8 +"ParcelOfTiedLand": "No" +"PossessionDetails": "To be built" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 5 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"MediaChangeTimestamp": "2025-12-03T21:54:44Z" +"SystemModificationTimestamp": "2025-12-03T21:54:44.877885Z" +"Media": array:3 [ …3] +"ID": "524957" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2859 +post_id: "519660" +post_author: 1 +"ListingKey": "X12599068" +"ListingId": "X12599068" +"PropertyType": "Residential Lease" +"PropertySubType": "Fourplex" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-03T20:45:33Z" +"RFModificationTimestamp": "2026-02-01T00:18:42Z" +"ListPrice": 1900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8N 1S7" +"UnparsedAddress": "133 Stinson Street 1, Hamilton, ON L8N 1S7" +"Coordinates": array:2 [ …2] +"Latitude": 43.2484479 +"Longitude": -79.8558055 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Keller Williams Edge Realty" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this spacious and beautifully updated 1-bedroom, 1-bath main floor apartment, offering comfort, convenience, and classic charm. Perfectly situated in a highly walkable area, this home provides effortless access to parks, trails, shopping, schools, the hospital, recreation centre, restaurants, the downtown core, and a variety of local amenities. Interior Highlights: Bright & Spacious Layout: High ceilings, a generous bedroom, and a large, sun-filled family room retain the timeless character of the home. Modern Updates Throughout: Fresh tile flooring in the hallways, kitchen, and bathroom, paired with new vinyl plank flooring in the bedroom and family room. Brand-New Kitchen: Equipped with new appliances, including a full-size fridge, stove, microwave, dishwasher, and the added convenience of in-unit laundry (washer/dryer). This thoughtfully renovated unit offers a perfect blend of modern comfort and original charm-move-in ready and ideal for comfortable everyday living. Book your showing today and experience all this beautiful unit has to offer." +"ArchitecturalStyle": "3-Storey" +"Basement": array:1 [ …1] +"CityRegion": "Stinson" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "None" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-01-31T22:52:38.904919+00:00" +"CrossStreet": "Victoria and Stinson" +"DirectionFaces": "South" +"Directions": "MAIN ST E/VICTORIA AVE/STINSON ST" +"ExpirationDate": "2026-07-31" +"FoundationDetails": array:2 [ …2] +"Furnished": "Unfurnished" +"Inclusions": "Dishwasher, Refrigerator, Stove, Washer & Dryer" +"InteriorFeatures": "Primary Bedroom - Main Floor,Separate Hydro Meter" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Oakville, Milton & District Real Estate Board" +"ListingContractDate": "2025-12-03" +"LotSizeSource": "MPAC" +"MainOfficeKey": "578200" +"MajorChangeTimestamp": "2025-12-03T20:45:33Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-12-03T20:45:33Z" +"OriginalListPrice": 1900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3329534" +"ParcelNumber": "171760035" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-12-03T20:45:33Z" +"PoolFeatures": "None" +"RentIncludes": array:5 [ …5] +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Stinson" +"StreetNumber": "133" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "1/2 months Rent" +"TransactionType": "For Lease" +"UnitNumber": "1" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 82.33 +"LotWidth": 30.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12599068')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251803020605980" +"SurveyType": "None" +"HoldoverDays": 90 +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8N 1S7, CA" +"ApproximateAge": "100+" +"ContractStatus": "Available" +"PossessionDate": "2026-02-01" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"DenFamilyroomYN": true +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 3 +"LeaseAgreementYN": true +"LotSizeAreaUnits": "Acres" +"PaymentFrequency": "Monthly" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 1 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"WashroomsType1Level": "Flat" +"MediaChangeTimestamp": "2025-12-03T20:45:33Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"SystemModificationTimestamp": "2025-12-03T20:45:33.480439Z" +"Media": array:36 [ …36] +"ID": "519660" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2860 +post_id: "538387" +post_author: 1 +"ListingKey": "X12597854" +"ListingId": "X12597854" +"PropertyType": "Commercial Sale" +"PropertySubType": "Industrial" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-03T17:07:17Z" +"RFModificationTimestamp": "2026-02-01T00:18:40Z" +"ListPrice": 8500000.0 +"BathroomsTotalInteger": 6.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 41154.0 +"City": "Hamilton" +"PostalCode": "L8E 3X8" +"UnparsedAddress": "504 Kenora Avenue, Hamilton, ON L8E 3X8" +"Coordinates": array:2 [ …2] +"Latitude": 43.2458398 +"Longitude": -79.7621286 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLLIERS" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Opportunity to acquire a 41,154 SF industrial building near the junction of the QEW, Red Hill Pkwy. The property is situated on a corner lot with great visibility. It includes 31,332 SF of warehouse space, 9,832 SF of office space over two (2) floors, seven (7) dock level doors, and one (1) drive-in door. Building was previously used as a refrigerated warehouse and distribution, with some space being heavily insulated with 32' clear and currently used as a bottling facility." +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Nashdale" +"CoListOfficeName": "COLLIERS" +"CoListOfficePhone": "416-777-2200" +"Cooling": "Partial" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-01-31T23:14:22.962298+00:00" +"CrossStreet": "Kenora Avenue/Nash road North" +"Directions": "Kenora Avenue/Nash road North" +"ExpirationDate": "2026-06-02" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-02" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "336800" +"MajorChangeTimestamp": "2025-12-03T17:07:17Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-12-03T17:07:17Z" +"OriginalListPrice": 8500000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3325716" +"ParcelNumber": "175660026" +"PhotosChangeTimestamp": "2025-12-03T17:07:17Z" +"SecurityFeatures": array:1 [ …1] +"Sewer": "Sanitary+Storm" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Kenora" +"StreetNumber": "504" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "76246.08" +"TaxLegalDescription": "PT LT 27, CON SALTFLEET, PART 12, 13, 62R6188; HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% of sale price" +"TransactionType": "For Sale" +"Utilities": "Yes" +"Zoning": "M6" +"Rail": "No" +"DDFYN": true +"Water": "Municipal" +"LotType": "Lot" +"TaxType": "Annual" +"HeatType": "Gas Forced Air Open" +"LotDepth": 239.98 +"LotShape": "Irregular" +"LotWidth": 200.6 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12597854')" +"GarageType": "None" +"RollNumber": "251805048105665" +"PropertyUse": "Free Standing" +"HoldoverDays": 180 +"HeatTypeMulti": array:1 [ …1] +"ListPriceUnit": "For Sale" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8E 3X8, CA" +"ContractStatus": "Available" +"FreestandingYN": true +"HSTApplication": array:1 [ …1] +"IndustrialArea": 31322.0 +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 6 +"ClearHeightFeet": 23 +"PossessionDetails": "Immediate" +"IndustrialAreaCode": "Sq Ft" +"OfficeApartmentArea": 9832.0 +"MediaChangeTimestamp": "2025-12-03T17:07:17Z" +"OfficeApartmentAreaUnit": "Sq Ft" +"TruckLevelShippingDoors": 7 +"DriveInLevelShippingDoors": 1 +"SystemModificationTimestamp": "2025-12-03T17:07:17.993788Z" +"Media": array:25 [ …25] +"ID": "538387" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2861 +post_id: "555506" +post_author: 1 +"ListingKey": "X12597852" +"ListingId": "X12597852" +"PropertyType": "Commercial Lease" +"PropertySubType": "Industrial" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-03T17:06:37Z" +"RFModificationTimestamp": "2026-02-01T00:18:40Z" +"ListPrice": 11.5 +"BathroomsTotalInteger": 6.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 1.53 +"LivingArea": 0 +"BuildingAreaTotal": 41154.0 +"City": "Hamilton" +"PostalCode": "L8E 3X8" +"UnparsedAddress": "504 Kenora Avenue, Hamilton, ON L8E 3X8" +"Coordinates": array:2 [ …2] +"Latitude": 43.2458398 +"Longitude": -79.7621286 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLLIERS" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Opportunity to lease a 41,154 SF industrial building near the junction of the QEW, Red Hill Pkwy, and Centennial Pkwy. The property is situated on a corner lot with great visibility. It includes 31,322 SF of warehouse space, 9,832 SF of office space over two (2) floors, seven (7) dock level doors, and one (1) drive-in door. Building was previously used as a refrigerated warehouse and distribution, with some space being heavily insulated with 23' clear and currently used as a bottling facility." +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Nashdale" +"CoListOfficeName": "COLLIERS" +"CoListOfficePhone": "416-777-2200" +"Cooling": "Partial" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-01-31T23:14:34.094719+00:00" +"CrossStreet": "Kenora Avenue/Nash Road North" +"Directions": "Kenora Avenue/Nash Road North" +"ExpirationDate": "2026-06-02" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-02" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "336800" +"MajorChangeTimestamp": "2025-12-03T17:06:37Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-12-03T17:06:37Z" +"OriginalListPrice": 11.5 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3325608" +"ParcelNumber": "175660026" +"PhotosChangeTimestamp": "2025-12-03T17:06:37Z" +"SecurityFeatures": array:1 [ …1] +"Sewer": "Sanitary+Storm" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Kenora" +"StreetNumber": "504" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "3.25" +"TaxLegalDescription": "PT LT 27, CON 1 SALTLFEET, PART 12, 13, 62R6188; HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "4% first yr's net rent and 2% thereafter" +"TransactionType": "For Lease" +"Utilities": "Yes" +"Zoning": "M6" +"Rail": "No" +"DDFYN": true +"Water": "Municipal" +"LotType": "Lot" +"TaxType": "TMI" +"HeatType": "Gas Forced Air Open" +"LotDepth": 239.98 +"LotShape": "Irregular" +"LotWidth": 200.6 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12597852')" +"GarageType": "Outside/Surface" +"RollNumber": "251805048105665" +"PropertyUse": "Free Standing" +"ElevatorType": "None" +"HoldoverDays": 180 +"HeatTypeMulti": array:1 [ …1] +"ListPriceUnit": "Sq Ft Net" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8E 3X8, CA" +"ContractStatus": "Available" +"FreestandingYN": true +"IndustrialArea": 31322.0 +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 6 +"ClearHeightFeet": 23 +"LotSizeAreaUnits": "Acres" +"PossessionDetails": "Immediate" +"IndustrialAreaCode": "Sq Ft" +"OfficeApartmentArea": 9832.0 +"MediaChangeTimestamp": "2025-12-03T17:06:37Z" +"MaximumRentalMonthsTerm": 120 +"MinimumRentalTermMonths": 60 +"OfficeApartmentAreaUnit": "Sq Ft" +"TruckLevelShippingDoors": 7 +"DriveInLevelShippingDoors": 1 +"SystemModificationTimestamp": "2025-12-03T17:06:38.217564Z" +"Media": array:25 [ …25] +"ID": "555506" } ] +success: true +page_size: 10 +page_count: 160 +count: 1598 +after_key: "" } "RF Response Time" => "0.26 seconds" ] "RF Cache Key: 80ca79a7cff76527304a69f6f0e95bec9dca86ffa6da957e79bce0edeee3d670" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3054 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4264 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12478891" +"ListingId": "X12478891" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-22T19:35:48Z" +"RFModificationTimestamp": "2026-03-15T04:27:04Z" +"ListPrice": 2500.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2328.0 +"City": "Hamilton" +"PostalCode": "L8M 1K1" +"UnparsedAddress": "663 Main Street E, Hamilton, ON L8M 1K1" +"Coordinates": array:2 [ …2] +"Latitude": 43.2488 +"Longitude": -79.8435499 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXP REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "This prime 2,300+ sq ft commercial retail space is located in the heart of Downtown Hamilton, offering exceptional visibility on a high-traffic street with strong daily footfall and drive by exposure. Positioned in a rapidly growing urban corridor surrounded by ongoing redevelopment, this property presents an outstanding opportunity for a business seeking a high-profile location with built-in credibility. Previously occupied by a successful business that was located here for over 30 years, the space carries a legacy of stability and community presence, making it ideal for retailers, showrooms, service-based operators, boutique brands, or professional users looking to establish themselves in a vibrant commercial setting. The property includes two dedicated parking spots, a rare advantage in the downtown core, and sits among a mix of established neighbourhood amenities, new developments, and an expanding residential base that continues to fuel demand for local services. With its historic past and modern growth potential, this location offers the perfect balance between character, convenience, and high exposure for a long-term business footprint in one of Hamilton's most active commercial areas." +"BuildingAreaUnits": "Square Feet" +"CityRegion": "St. Clair" +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-03-09T03:06:53.018889+00:00" +"CrossStreet": "Main St E & Fairleigh" +"Directions": "Main St E" +"ExpirationDate": "2026-05-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-10-23" +"MainOfficeKey": "285400" +"MajorChangeTimestamp": "2025-12-22T19:35:48Z" +"MlsStatus": "Price Change" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-10-23T18:12:02Z" +"OriginalListPrice": 2600.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3172532" +"PhotosChangeTimestamp": "2025-10-23T18:12:02Z" +"PreviousListPrice": 2600.0 +"PriceChangeTimestamp": "2025-12-22T19:35:48Z" +"SecurityFeatures": array:1 [ …1] +"ShowingRequirements": array:3 [ …3] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "Main" +"StreetNumber": "663" +"StreetSuffix": "Street" +"TaxAnnualAmount": "8100.0" +"TaxYear": "2024" +"TransactionBrokerCompensation": "Half Month Rent" +"TransactionType": "For Lease" +"Utilities": array:1 [ …1] +"Zoning": "C2" +"DDFYN": true +"Water": "Municipal" +"LotType": "Building" +"TaxType": "Annual" +"HeatType": "Electric Forced Air" +"LotDepth": 80.0 +"LotWidth": 30.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12478891')" +"GarageType": "None" +"RetailArea": 2328.0 +"PropertyUse": "Retail" +"RentalItems": "Hot water heater Tank" +"HoldoverDays": 180 +"HeatTypeMulti": array:1 [ …1] +"ListPriceUnit": "Month" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8M 1K1, CA" +"ContractStatus": "Available" +"PossessionDate": "2025-11-01" +"PossessionType": "Immediate" +"PriorMlsStatus": "New" +"RetailAreaCode": "Sq Ft" +"MediaChangeTimestamp": "2025-10-23T18:12:02Z" +"MaximumRentalMonthsTerm": 48 +"MinimumRentalTermMonths": 12 +"SystemModificationTimestamp": "2025-12-22T19:35:48.798862Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:7 [ …7] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4265 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12496752" +"ListingId": "X12496752" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-17T14:46:16Z" +"RFModificationTimestamp": "2026-02-07T16:09:46Z" +"ListPrice": 399999.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8E 0K3" +"UnparsedAddress": "125 Shoreview Place 638, Hamilton, ON L8E 0K3" +"Coordinates": array:2 [ …2] +"Latitude": 43.2390543 +"Longitude": -79.7197856 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CHASE REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover modern lakeside living in this stunning 1-bedroom, 1-bathroom condo featuring expansive floor-to-ceiling windows and an oversized balcony perfect for relaxing or entertaining. The bright, open-concept layout is completely carpet-free with a sleek modern design throughout and includes in-suite laundry for added convenience. Enjoy premium building amenities including a party room, rooftop patio with stunning lakeside views, and a fully equipped exercise room. This unit comes with owned parking and a locker, plus plenty of visitor parking. Efficient geothermal heating and central air for year-round comfort. Don't miss this incredible opportunity to own a contemporary condo in a desirable lakeside location!" +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": array:5 [ …5] +"AssociationFee": "467.35" +"AssociationFeeIncludes": array:5 [ …5] +"Basement": array:1 [ …1] +"CityRegion": "Lakeshore" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2026-02-07T13:39:25.467883+00:00" +"CrossStreet": "Millen Rd to Shoreview Pl" +"Directions": "Millen Rd to Shoreview Pl, Left on Shoreview, Last Entrance on Right" +"Disclosures": array:1 [ …1] +"ExpirationDate": "2026-05-29" +"GarageYN": true +"Inclusions": "Fridge, Stove, Range Hood/Microwave, Dishwasher, Washer, Dryer. Option to purchase furnished." +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-10-31" +"LotSizeSource": "MPAC" +"MainOfficeKey": "248800" +"MajorChangeTimestamp": "2025-10-31T17:47:53Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-10-31T17:47:53Z" +"OriginalListPrice": 399999.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3192512" +"ParcelNumber": "185891333" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2025-10-31T19:06:23Z" +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Shoreview" +"StreetNumber": "125" +"StreetSuffix": "Place" +"TaxAnnualAmount": "3051.6" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% +HST" +"TransactionType": "For Sale" +"UnitNumber": "638" +"WaterBodyName": "Lake Ontario" +"WaterfrontFeatures": array:1 [ …1] +"WaterfrontYN": true +"DDFYN": true +"Locker": "Owned" +"Exposure": "North East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12496752')" +"Shoreline": array:1 [ …1] +"WaterView": array:1 [ …1] +"ElevatorYN": true +"GarageType": "Underground" +"HeatSource": "Ground Source" +"RollNumber": "251800304020219" +"SurveyType": "Unknown" +"Waterfront": array:1 [ …1] +"BalconyType": "Open" +"DockingType": array:1 [ …1] +"RentalItems": "None" +"HoldoverDays": 60 +"LegalStories": "6" +"ParkingSpot1": "Underground Space #301" +"ParkingType1": "Owned" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"WaterBodyType": "Lake" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8E 0K3, CA" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"CondoCorpNumber": 589 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "500-599" +"RoomsAboveGrade": 4 +"AccessToProperty": array:1 [ …1] +"AlternativePower": array:1 [ …1] +"EnsuiteLaundryYN": true +"SquareFootSource": "LBO Provided" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 1 +"KitchensAboveGrade": 1 +"ShorelineAllowance": "None" +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Lockbox located at 101 Shoreview Pl - in Lobby" +"WaterfrontAccessory": array:1 [ …1] +"LegalApartmentNumber": "638" +"MediaChangeTimestamp": "2025-10-31T19:06:23Z" +"PropertyManagementCompany": "Wilson Blanchard" +"SystemModificationTimestamp": "2025-12-17T14:46:16.611179Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:46 [ …46] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4268 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12633560" +"ListingId": "X12633560" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-15T15:15:34Z" +"RFModificationTimestamp": "2026-02-28T01:18:16Z" +"ListPrice": 1950.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3100.0 +"City": "Hamilton" +"PostalCode": "L8L 2V5" +"UnparsedAddress": "18 Barton Street E, Hamilton, ON L8L 2V5" +"Coordinates": array:2 [ …2] +"Latitude": 43.2637456 +"Longitude": -79.8651045 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE STATE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 18 Barton Street East - a beautifull main-floor commercial space at the high-traffic corner of James St. N. and Barton St. E. This turnkey unit is ideal for a salon, wellness clinic, RMT, chiropractor, nail bar, or other personal care business. Featuring approx. 800 sq.ft. of stunning interior space, in-suite laundry, and basement storage. The building blends historic charm with modern amenities. Located just steps from some of the city's trendiest shops and restaurants, this space offers maximum visibility in a vibrant, high-foot-traffic area." +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ …1] +"CityRegion": "Beasley" +"CommunityFeatures": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-02-27T02:30:27.309554+00:00" +"CrossStreet": "James St N. & Barton St. E." +"Directions": "James St. N. East on Barton" +"ExpirationDate": "2026-06-15" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-15" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "288000" +"MajorChangeTimestamp": "2025-12-15T15:15:34Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-12-15T15:15:34Z" +"OriginalListPrice": 1950.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3350456" +"ParcelNumber": "171610050" +"PhotosChangeTimestamp": "2025-12-15T15:15:34Z" +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "Barton" +"StreetNumber": "18" +"StreetSuffix": "Street" +"TaxAnnualAmount": "7743.59" +"TaxLegalDescription": "PT LT 11-12 PL 181 AS IN HL23644, T/W INTEREST IN VM264501; CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "1/2 Month's Rent + HST" +"TransactionType": "For Lease" +"Utilities": array:1 [ …1] +"Zoning": "H" +"Rail": "No" +"DDFYN": true +"Water": "Municipal" +"LotType": "Lot" +"TaxType": "Annual" +"HeatType": "Gas Forced Air Open" +"LotDepth": 90.0 +"LotShape": "Rectangular" +"LotWidth": 18.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12633560')" +"GarageType": "None" +"RetailArea": 980.0 +"RollNumber": "251802015655430" +"PropertyUse": "Multi-Use" +"ElevatorType": "None" +"HoldoverDays": 60 +"HeatTypeMulti": array:1 [ …1] +"ListPriceUnit": "Net Lease" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8L 2V5, CA" +"ContractStatus": "Available" +"FreestandingYN": true +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"RetailAreaCode": "Sq Ft" +"PossessionDetails": "Flexible" +"MediaChangeTimestamp": "2025-12-15T15:15:34Z" +"MaximumRentalMonthsTerm": 60 +"MinimumRentalTermMonths": 36 +"SystemModificationTimestamp": "2025-12-15T15:15:35.033136Z" +"Media": array:27 [ …27] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4267 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12614468" +"ListingId": "X12614468" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-10T01:01:48Z" +"RFModificationTimestamp": "2026-02-11T04:20:49Z" +"ListPrice": 799999.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8L 4X8" +"UnparsedAddress": "575 Mary Street, Hamilton, ON L8L 4X8" +"Coordinates": array:2 [ …2] +"Latitude": 43.2722078 +"Longitude": -79.856884 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CENTURY 21 HERITAGE GROUP LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 575 Mary Street, a stunningly unique property steps from the water's edge in the north end of Hamilton, where a tight-knit family transformed a house into a home during the quiet of Covid lockdowns. Step inside this fully renovated gem, seamlessly blending modern comforts with warm, inviting spaces, all crafted by a talented Hamilton native and international artist. The artistic flair captivates, merging the natural light of the outdoors with glass, cement, and crisp whites throughout. At the heart of the home is a stunning kitchen featuring floor-to-ceiling cabinetry, a four-seater waterfall quartz island, and very likely the most interesting matching Italian porcelain flooring and backsplash combo you have ever seen. The front porch, drenched in light from two skylights, is perfect for sipping morning coffee while enjoying the sunrise. On the opposite side of the house, cozy evenings come alive by the newly installed wood-burning fireplace, which warms the all-season backyard patio designed for both entertaining and relaxing after a long day. This home also features an innovative and massive office space seamlessly integrated into the main bedroom, ideal for remote work or midnight inspiration. With HUE smart lights throughout, you can easily set the perfect mood for any occasion. In the last four years, recent upgrades include Neal installed roof coverings, a high-efficiency furnace, all new flooring, windows, all siding, main floor powder room, brand-new kitchen and laundry appliances. This means you can move in and enjoy modern living! With three spacious bedrooms plus an office, this home provides ample space for families, guests, or your creative pursuits. Plus, convenience is key with two included parking spaces and an upgraded fast-charging EV connection port already installed. Come fall in love with this art piece of a home. A space ready for some new dreamers and creative spirits!" +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CityRegion": "North End" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-02-07T17:44:49.493563+00:00" +"CrossStreet": "Mary St. and Brock St." +"DirectionFaces": "West" +"Directions": "Burlington St. E. to Mary St." +"Exclusions": "None." +"ExpirationDate": "2026-06-05" +"ExteriorFeatures": array:2 [ …2] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"Inclusions": "Fridge, stove, dishwasher, washer, and dryer." +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-09" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "248500" +"MajorChangeTimestamp": "2025-12-10T01:01:48Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-12-10T01:01:48Z" +"OriginalListPrice": 799999.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3348180" +"ParcelNumber": "171550215" +"ParkingFeatures": array:2 [ …2] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-12-10T01:01:48Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Mary" +"StreetNumber": "575" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3390.0" +"TaxLegalDescription": "PT LT 44 OR 81 NATHANIEL HUGHSON SURVEY (UNREGISTERED) W/S MARY ST BTN BURLINGTON ST & BROCK ST AS IN CD481453; CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% +HST" +"TransactionType": "For Sale" +"View": array:1 [ …1] +"VirtualTourURLBranded": "https://iframe.videodelivery.net/e60499a5b6ac0e7fdab37cf01d2c3d51" +"VirtualTourURLBranded2": "https://my.matterport.com/show/?m=ms84GXX4mg Z" +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=ms84GXX4mg Z" +"VirtualTourURLUnbranded2": "https://iframe.videodelivery.net/6f86174062b86615fe67c0fe20d7a24e" +"Zoning": "D" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Available" +"HeatType": "Forced Air" +"LotDepth": 120.0 +"LotShape": "Rectangular" +"LotWidth": 20.0 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12614468')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251802016605960" +"SurveyType": "Unknown" +"Waterfront": array:1 [ …1] +"Winterized": "Fully" +"ElectricYNA": "Yes" +"RentalItems": "Water heater." +"HoldoverDays": 120 +"LaundryLevel": "Main Level" +"TelephoneYNA": "Available" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8L 4X8, CA" +"ApproximateAge": "100+" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-01-09" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1500-2000" +"MortgageComment": "Seller to discharge mortgage." +"RoomsAboveGrade": 8 +"ParcelOfTiedLand": "No" +"PropertyFeatures": array:6 [ …6] +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Broker Bay/LBO. Please remove shoes, leave card, turn off lights, lock all doors." +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"MediaChangeTimestamp": "2025-12-10T01:01:48Z" +"SystemModificationTimestamp": "2025-12-10T01:01:48.667708Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:50 [ …50] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4266 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12609296" +"ListingId": "X12609296" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-08T21:23:02Z" +"RFModificationTimestamp": "2026-02-27T04:54:53Z" +"ListPrice": 23.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1555.0 +"City": "Hamilton" +"PostalCode": "L8R 2L4" +"UnparsedAddress": "297 James Street N, Hamilton, ON L8R 2L4" +"Coordinates": array:2 [ …2] +"Latitude": 43.3382023 +"Longitude": -79.8903385 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLLIERS" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Your business belongs on James Street North - Hamilton's thriving arts and culture corridor. This 1,555 sq. ft. retail space offers prime frontaage, strong foot traffic, and proximity to the newly renovated TD Coliseum, just a short walk from the GO Station via the upcoming pedestrian pathway. Surrounded by independent restaurants, boutiques, and creative businesses, it's an ideal home for a boutique retailer, cafe or service-based concept ready to tap into the neighbourhood's energy. Make your mark where Hamilton comes to life." +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ …1] +"CityRegion": "Central" +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-02-27T04:07:05.260115+00:00" +"CrossStreet": "James St N & Colbourne" +"Directions": "James St N & Colbourne" +"ExpirationDate": "2026-06-08" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-08" +"MainOfficeKey": "336800" +"MajorChangeTimestamp": "2025-12-08T15:06:50Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-12-08T15:06:50Z" +"OriginalListPrice": 23.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3329670" +"ParcelNumber": "171600191" +"PhotosChangeTimestamp": "2025-12-08T15:06:50Z" +"SecurityFeatures": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "James" +"StreetNumber": "297" +"StreetSuffix": "Street" +"TaxAnnualAmount": "10.03" +"TaxLegalDescription": "PT LT 2 BLK 1 PL 127 AS IN VM78045 CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "3.5% 1st Year, 2% Thereafter" +"TransactionType": "For Lease" +"Utilities": array:1 [ …1] +"Zoning": "H" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unit" +"TaxType": "TMI" +"HeatType": "Gas Forced Air Open" +"LotDepth": 120.0 +"LotWidth": 26.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12609296')" +"GarageType": "None" +"RetailArea": 1555.0 +"RollNumber": "251802012656600" +"PropertyUse": "Retail" +"HoldoverDays": 90 +"HeatTypeMulti": array:1 [ …1] +"ListPriceUnit": "Sq Ft Net" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8R 2L4, CA" +"ContractStatus": "Available" +"FreestandingYN": true +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"RetailAreaCode": "Sq Ft" +"PossessionDetails": "Immediate" +"MediaChangeTimestamp": "2025-12-08T15:06:50Z" +"MaximumRentalMonthsTerm": 120 +"MinimumRentalTermMonths": 60 +"SystemModificationTimestamp": "2025-12-08T21:23:02.334431Z" +"Media": array:7 [ …7] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4263 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12609290" +"ListingId": "X12609290" +"PropertyType": "Commercial Lease" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-08T15:06:16Z" +"RFModificationTimestamp": "2026-02-07T20:29:15Z" +"ListPrice": 23.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 271.0 +"LivingArea": 0 +"BuildingAreaTotal": 1555.0 +"City": "Hamilton" +"PostalCode": "L8R 2L4" +"UnparsedAddress": "297 James Street N, Hamilton, ON L8R 2L4" +"Coordinates": array:2 [ …2] +"Latitude": 43.3382023 +"Longitude": -79.8903385 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLLIERS" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Your business belongs on James Street North Hamilton's thriving arts and culture corridor. This 1,555 sq. ft. retail space offers prime frontage, strong foot traffic, and proximity to the newly renovated TD Coliseum, just a short walk from the GO station via the upcoming pedestrian walkway. Surrounded by independent restaurants, boutiques and creative businesses, it's an ideal home for a bouqitue retailer, cafe or service-based concept ready to tap into the neighbourhood's energy. Make your mark where Hamilton comes to life." +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ …1] +"CityRegion": "Central" +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-02-07T19:05:30.852759+00:00" +"CrossStreet": "James St N & Colbourne" +"Directions": "James St N & Colbourne" +"ExpirationDate": "2026-06-08" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-08" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "336800" +"MajorChangeTimestamp": "2025-12-08T15:06:16Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-12-08T15:06:16Z" +"OriginalListPrice": 23.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3329342" +"ParcelNumber": "171600191" +"PhotosChangeTimestamp": "2025-12-08T15:06:16Z" +"SecurityFeatures": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "James" +"StreetNumber": "297" +"StreetSuffix": "Street" +"TaxAnnualAmount": "10.03" +"TaxLegalDescription": "PT LT 2 BLK 1 PL 127 AS IN VM78045 CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "3.5% 1st Year, 2% Thereafter" +"TransactionType": "For Lease" +"Utilities": array:1 [ …1] +"Zoning": "H" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unit" +"TaxType": "TMI" +"HeatType": "Gas Forced Air Open" +"LotDepth": 120.0 +"LotShape": "Rectangular" +"LotWidth": 26.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12609290')" +"GarageType": "None" +"RollNumber": "251802012656600" +"PropertyUse": "Office" +"ElevatorType": "None" +"HoldoverDays": 90 +"HeatTypeMulti": array:1 [ …1] +"ListPriceUnit": "Sq Ft Net" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8R 2L4, CA" +"ContractStatus": "Available" +"FreestandingYN": true +"PossessionDate": "2025-12-08" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"LotSizeAreaUnits": "Square Meters" +"PossessionDetails": "Immediate" +"OfficeApartmentArea": 1555.0 +"MediaChangeTimestamp": "2025-12-08T15:06:16Z" +"MaximumRentalMonthsTerm": 120 +"MinimumRentalTermMonths": 60 +"OfficeApartmentAreaUnit": "Sq Ft" +"SystemModificationTimestamp": "2025-12-08T15:06:16.284511Z" +"Media": array:7 [ …7] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4262 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12599404" +"ListingId": "X12599404" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-03T21:54:44Z" +"RFModificationTimestamp": "2026-02-01T00:18:42Z" +"ListPrice": 1829990.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9K 0K3" +"UnparsedAddress": "467 Klein Circle, Hamilton, ON L9K 0K3" +"Coordinates": array:2 [ …2] +"Latitude": 43.2125013 +"Longitude": -79.9480402 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE MACRO REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "A rare opportunity to own a 3,329 sq. ft. luxury residence on an exclusive pie-shaped lot in the prestigious Meadowlands of Ancaster. To be built by a well-known, long-standing local builder, this executive 4-bed, 3.5-bath home offers an elevated living experience reserved for those who refuse to compromise on quality, space, or style. From the moment you arrive, the full brick exterior and architectural presence set a tone of modern sophistication. Inside, every detail is thoughtfully curated from the quartz countertops, elegant oak stairs, and a beautifully designed kitchen complete with a walk-in pantry, ideal for gourmet cooking and stylish entertaining. Each bedroom features its own private bathroom, giving your family and guests the comfort of boutique-hotel living. The covered rear porch extends your luxury outdoors, creating a stunning space for year-round enjoyment while taking full advantage of the oversized lot. Set within the Meadowlands, this home offers schools, scenic parks, trails, shopping, dining, and effortless connections to HWY 403, the LINC, and transit. Closings are scheduled for 2026, and discerning buyers still have the opportunity to select colours, finishes, and specifications allowing for a personalized, designer-level build. Opportunities like this are extremely limited. Premium pie-shaped lots paired with luxury new construction rarely become available and they never last. Secure this one before it's gone." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CityRegion": "Meadowlands" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2026-01-31T22:45:06.993245+00:00" +"CrossStreet": "RYMAL AND SPRINGBROOK" +"DirectionFaces": "South" +"Directions": "RYMAL TO NORTH ON SPRINGBROOK, WEST ON SHARP TO KLEIN CIRCLE" +"ExpirationDate": "2026-06-30" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-02" +"MainOfficeKey": "311200" +"MajorChangeTimestamp": "2025-12-03T21:54:44Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-12-03T21:54:44Z" +"OriginalListPrice": 1829990.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3325294" +"ParcelNumber": "175656225" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-12-03T21:54:44Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Klein" +"StreetNumber": "467" +"StreetSuffix": "Circle" +"TaxLegalDescription": "LOT 44, PLAN 62M1292 SUBJECT TO AN EASEMENT IN GROSS AS IN WE1672595" +"TaxYear": "2025" +"TransactionBrokerCompensation": "$20,000 + HST" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 135.06 +"LotWidth": 36.8 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12599404')" +"GarageType": "Attached" +"HeatSource": "Gas" +"SurveyType": "None" +"HoldoverDays": 120 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L9K 0K3, CA" +"ApproximateAge": "New" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "90+ days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 2 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "3000-3500" +"RoomsAboveGrade": 8 +"ParcelOfTiedLand": "No" +"PossessionDetails": "To be built" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 5 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"MediaChangeTimestamp": "2025-12-03T21:54:44Z" +"SystemModificationTimestamp": "2025-12-03T21:54:44.877885Z" +"Media": array:3 [ …3] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4261 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12599068" +"ListingId": "X12599068" +"PropertyType": "Residential Lease" +"PropertySubType": "Fourplex" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-03T20:45:33Z" +"RFModificationTimestamp": "2026-02-01T00:18:42Z" +"ListPrice": 1900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8N 1S7" +"UnparsedAddress": "133 Stinson Street 1, Hamilton, ON L8N 1S7" +"Coordinates": array:2 [ …2] +"Latitude": 43.2484479 +"Longitude": -79.8558055 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Keller Williams Edge Realty" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this spacious and beautifully updated 1-bedroom, 1-bath main floor apartment, offering comfort, convenience, and classic charm. Perfectly situated in a highly walkable area, this home provides effortless access to parks, trails, shopping, schools, the hospital, recreation centre, restaurants, the downtown core, and a variety of local amenities. Interior Highlights: Bright & Spacious Layout: High ceilings, a generous bedroom, and a large, sun-filled family room retain the timeless character of the home. Modern Updates Throughout: Fresh tile flooring in the hallways, kitchen, and bathroom, paired with new vinyl plank flooring in the bedroom and family room. Brand-New Kitchen: Equipped with new appliances, including a full-size fridge, stove, microwave, dishwasher, and the added convenience of in-unit laundry (washer/dryer). This thoughtfully renovated unit offers a perfect blend of modern comfort and original charm-move-in ready and ideal for comfortable everyday living. Book your showing today and experience all this beautiful unit has to offer." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"CityRegion": "Stinson" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-01-31T22:52:38.904919+00:00" +"CrossStreet": "Victoria and Stinson" +"DirectionFaces": "South" +"Directions": "MAIN ST E/VICTORIA AVE/STINSON ST" +"ExpirationDate": "2026-07-31" +"FoundationDetails": array:2 [ …2] +"Furnished": "Unfurnished" +"Inclusions": "Dishwasher, Refrigerator, Stove, Washer & Dryer" +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Oakville, Milton & District Real Estate Board" +"ListingContractDate": "2025-12-03" +"LotSizeSource": "MPAC" +"MainOfficeKey": "578200" +"MajorChangeTimestamp": "2025-12-03T20:45:33Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-12-03T20:45:33Z" +"OriginalListPrice": 1900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3329534" +"ParcelNumber": "171760035" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-12-03T20:45:33Z" +"PoolFeatures": array:1 [ …1] +"RentIncludes": array:5 [ …5] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Stinson" +"StreetNumber": "133" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "1/2 months Rent" +"TransactionType": "For Lease" +"UnitNumber": "1" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 82.33 +"LotWidth": 30.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12599068')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251803020605980" +"SurveyType": "None" +"HoldoverDays": 90 +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8N 1S7, CA" +"ApproximateAge": "100+" +"ContractStatus": "Available" +"PossessionDate": "2026-02-01" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"DenFamilyroomYN": true +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 3 +"LeaseAgreementYN": true +"LotSizeAreaUnits": "Acres" +"PaymentFrequency": "Monthly" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 1 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"WashroomsType1Level": "Flat" +"MediaChangeTimestamp": "2025-12-03T20:45:33Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"SystemModificationTimestamp": "2025-12-03T20:45:33.480439Z" +"Media": array:36 [ …36] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4260 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12597854" +"ListingId": "X12597854" +"PropertyType": "Commercial Sale" +"PropertySubType": "Industrial" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-03T17:07:17Z" +"RFModificationTimestamp": "2026-02-01T00:18:40Z" +"ListPrice": 8500000.0 +"BathroomsTotalInteger": 6.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 41154.0 +"City": "Hamilton" +"PostalCode": "L8E 3X8" +"UnparsedAddress": "504 Kenora Avenue, Hamilton, ON L8E 3X8" +"Coordinates": array:2 [ …2] +"Latitude": 43.2458398 +"Longitude": -79.7621286 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLLIERS" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Opportunity to acquire a 41,154 SF industrial building near the junction of the QEW, Red Hill Pkwy. The property is situated on a corner lot with great visibility. It includes 31,332 SF of warehouse space, 9,832 SF of office space over two (2) floors, seven (7) dock level doors, and one (1) drive-in door. Building was previously used as a refrigerated warehouse and distribution, with some space being heavily insulated with 32' clear and currently used as a bottling facility." +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Nashdale" +"CoListOfficeName": "COLLIERS" +"CoListOfficePhone": "416-777-2200" +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-01-31T23:14:22.962298+00:00" +"CrossStreet": "Kenora Avenue/Nash road North" +"Directions": "Kenora Avenue/Nash road North" +"ExpirationDate": "2026-06-02" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-02" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "336800" +"MajorChangeTimestamp": "2025-12-03T17:07:17Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-12-03T17:07:17Z" +"OriginalListPrice": 8500000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3325716" +"ParcelNumber": "175660026" +"PhotosChangeTimestamp": "2025-12-03T17:07:17Z" +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Kenora" +"StreetNumber": "504" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "76246.08" +"TaxLegalDescription": "PT LT 27, CON SALTFLEET, PART 12, 13, 62R6188; HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% of sale price" +"TransactionType": "For Sale" +"Utilities": array:1 [ …1] +"Zoning": "M6" +"Rail": "No" +"DDFYN": true +"Water": "Municipal" +"LotType": "Lot" +"TaxType": "Annual" +"HeatType": "Gas Forced Air Open" +"LotDepth": 239.98 +"LotShape": "Irregular" +"LotWidth": 200.6 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12597854')" +"GarageType": "None" +"RollNumber": "251805048105665" +"PropertyUse": "Free Standing" +"HoldoverDays": 180 +"HeatTypeMulti": array:1 [ …1] +"ListPriceUnit": "For Sale" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8E 3X8, CA" +"ContractStatus": "Available" +"FreestandingYN": true +"HSTApplication": array:1 [ …1] +"IndustrialArea": 31322.0 +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 6 +"ClearHeightFeet": 23 +"PossessionDetails": "Immediate" +"IndustrialAreaCode": "Sq Ft" +"OfficeApartmentArea": 9832.0 +"MediaChangeTimestamp": "2025-12-03T17:07:17Z" +"OfficeApartmentAreaUnit": "Sq Ft" +"TruckLevelShippingDoors": 7 +"DriveInLevelShippingDoors": 1 +"SystemModificationTimestamp": "2025-12-03T17:07:17.993788Z" +"Media": array:25 [ …25] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4259 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12597852" +"ListingId": "X12597852" +"PropertyType": "Commercial Lease" +"PropertySubType": "Industrial" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-03T17:06:37Z" +"RFModificationTimestamp": "2026-02-01T00:18:40Z" +"ListPrice": 11.5 +"BathroomsTotalInteger": 6.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 1.53 +"LivingArea": 0 +"BuildingAreaTotal": 41154.0 +"City": "Hamilton" +"PostalCode": "L8E 3X8" +"UnparsedAddress": "504 Kenora Avenue, Hamilton, ON L8E 3X8" +"Coordinates": array:2 [ …2] +"Latitude": 43.2458398 +"Longitude": -79.7621286 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLLIERS" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Opportunity to lease a 41,154 SF industrial building near the junction of the QEW, Red Hill Pkwy, and Centennial Pkwy. The property is situated on a corner lot with great visibility. It includes 31,322 SF of warehouse space, 9,832 SF of office space over two (2) floors, seven (7) dock level doors, and one (1) drive-in door. Building was previously used as a refrigerated warehouse and distribution, with some space being heavily insulated with 23' clear and currently used as a bottling facility." +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Nashdale" +"CoListOfficeName": "COLLIERS" +"CoListOfficePhone": "416-777-2200" +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-01-31T23:14:34.094719+00:00" +"CrossStreet": "Kenora Avenue/Nash Road North" +"Directions": "Kenora Avenue/Nash Road North" +"ExpirationDate": "2026-06-02" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-02" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "336800" +"MajorChangeTimestamp": "2025-12-03T17:06:37Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-12-03T17:06:37Z" +"OriginalListPrice": 11.5 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3325608" +"ParcelNumber": "175660026" +"PhotosChangeTimestamp": "2025-12-03T17:06:37Z" +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Kenora" +"StreetNumber": "504" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "3.25" +"TaxLegalDescription": "PT LT 27, CON 1 SALTLFEET, PART 12, 13, 62R6188; HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "4% first yr's net rent and 2% thereafter" +"TransactionType": "For Lease" +"Utilities": array:1 [ …1] +"Zoning": "M6" +"Rail": "No" +"DDFYN": true +"Water": "Municipal" +"LotType": "Lot" +"TaxType": "TMI" +"HeatType": "Gas Forced Air Open" +"LotDepth": 239.98 +"LotShape": "Irregular" +"LotWidth": 200.6 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12597852')" +"GarageType": "Outside/Surface" +"RollNumber": "251805048105665" +"PropertyUse": "Free Standing" +"ElevatorType": "None" +"HoldoverDays": 180 +"HeatTypeMulti": array:1 [ …1] +"ListPriceUnit": "Sq Ft Net" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8E 3X8, CA" +"ContractStatus": "Available" +"FreestandingYN": true +"IndustrialArea": 31322.0 +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 6 +"ClearHeightFeet": 23 +"LotSizeAreaUnits": "Acres" +"PossessionDetails": "Immediate" +"IndustrialAreaCode": "Sq Ft" +"OfficeApartmentArea": 9832.0 +"MediaChangeTimestamp": "2025-12-03T17:06:37Z" +"MaximumRentalMonthsTerm": 120 +"MinimumRentalTermMonths": 60 +"OfficeApartmentAreaUnit": "Sq Ft" +"TruckLevelShippingDoors": 7 +"DriveInLevelShippingDoors": 1 +"SystemModificationTimestamp": "2025-12-03T17:06:38.217564Z" +"Media": array:25 [ …25] } ] +success: true +page_size: 10 +page_count: 160 +count: 1598 +after_key: "" } ] "RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4252 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4083 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13062566" +"ListingId": "X13062566" +"PropertyType": "Residential" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-03T12:24:24Z" +"RFModificationTimestamp": "2026-05-03T12:28:18Z" +"ListPrice": 699000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Georgian Bluffs" +"PostalCode": "N0H 1S0" +"UnparsedAddress": "301 Telford Trail 1, Georgian Bluffs, ON N0H 1S0" +"Coordinates": array:2 [ …2] +"Latitude": 44.6690284 +"Longitude": -80.9287005 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Century 21 Millennium Inc." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome To 301 Telford Trail, Located In The Prestigious Cobble Beach Golf Resort. This Beautifully Updated End Unit Bungaloft Townhouse Is Perfectly Positioned To Capture Breathtaking Views Of Georgian Bay & The Surrounding Ravine. Enjoy Outdoor Living On The Expansive Composite Terrace Featuring A Sleek Glass Railing & Convenient Stair Access To The Yard. Inside, Vaulted Ceilings In Both The Foyer & Living Room Create An Immediate Sense Of Light & Space. A Separate Dining Room W/Elegant French Doors Provides The Perfect Setting For Entertaining. The Gourmet Kitchen Boasts A Large Centre Island, Granite Countertops, High-End Stainless Steel Appliance & Abundant Storage - Ideal For Any Chef. Relax In The Light-Filled Living Room Complete W/A Cozy Gas Fireplace & Walk-Out To The Terrace. The Spacious Loft Area Features A Bright Family Room Overlooking The Foyer & Living Room, Perfect For A Work-From-Home Office Or Relaxing Retreat. A 2nd Bedroom & 4-Piece Bath Provide An Ideal Space For Guests. The Finished Lower Level Is Designed For Entertaining & Extended Family, Featuring A 3rd Bedroom, 3 Piece Bath, Games Room, Family Room With Electric Fireplace, Wet Bar & Wine Fridge & A Generous Storage Room W/Epoxy Floors. A Walk-Out Leads Directly To The Backyard Adding Convenience & Outdoor Enjoyment. Additional Highlights Include A 1.5 Car Garage, Fully Drywalled, Epoxy Floors, Workbench & Lots Of Storage Plus 2 Car Parking On The Private Driveway. All Four Bathrooms Have Been Stylishly Renovated, Offering Comfort & Luxury Throughout. With Two Family Rooms-One Upstairs & One Down & The Added Bonus Of Being An End Unit, This Home Is Filled W/Light, Space & Thoughtful Design. Cobble Beach Amenities Include: Golf Course*Golf Simulator*Driving Range*Private Beach Club W/Firepits & Watercraft Storage*Outdoor Pool & Hot Tub*Day Dock*US Open-Style Tennis Courts*Bocce Ball*Beach Volleyball*Fitness Facility*Trails*Cross Country Skiing*Snowshoeing*Restaurant*Patio*Spa." +"ArchitecturalStyle": array:1 [ …1] +"AssociationFee": "699.3" +"AssociationFeeIncludes": array:1 [ …1] +"Basement": array:1 [ …1] +"CityRegion": "Georgian Bluffs" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Grey County" +"CoveredSpaces": "1.5" +"CreationDate": "2026-04-30T15:00:25.480310+00:00" +"CrossStreet": "Cobble Beach Drive/Telford Trail" +"Directions": "Grey Road 1 To Cobble Beach Drive, 2nd Left Onto Telford Trail" +"Disclosures": array:1 [ …1] +"ExpirationDate": "2026-10-31" +"ExteriorFeatures": array:5 [ …5] +"FireplaceFeatures": array:4 [ …4] +"FireplaceYN": true +"FireplacesTotal": "2" +"GarageYN": true +"Inclusions": "Side/Side Refrigerator, Island Vent, Induction Cook Top, B/I Double Ovens, B/I Microwave, Basement Wine Fridge, Washer, Dryer, Garage Door Opener, Remote And Keypad (Seller's Have Never Used It), Garage Workbench, California Shutters, Smoke Detectors, Carbon Monoxide Detector" +"InteriorFeatures": array:5 [ …5] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "One Point Association of REALTORS" +"ListingContractDate": "2026-04-30" +"LotSizeSource": "MPAC" +"MainOfficeKey": "550900" +"MajorChangeTimestamp": "2026-04-30T14:40:16Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-30T14:40:16Z" +"OriginalListPrice": 699000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3383208" +"ParcelNumber": "378920001" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "3.5" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-30T14:40:16Z" +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Telford" +"StreetNumber": "301" +"StreetSuffix": "Trail" +"TaxAnnualAmount": "4883.0" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2+HST" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://youtu.be/DClmk PY8Uu E" +"VirtualTourURLBranded2": "https://youtu.be/DClmk PY8Uu E" +"WaterBodyName": "Georgian Bay" +"WaterfrontFeatures": array:2 [ …2] +"WaterfrontYN": true +"DDFYN": true +"Locker": "None" +"Exposure": "West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13062566')" +"Shoreline": array:1 [ …1] +"WaterView": array:1 [ …1] +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "420358002035003" +"SurveyType": "None" +"Waterfront": array:1 [ …1] +"BalconyType": "Terrace" +"DockingType": array:1 [ …1] +"RentalItems": "Gas Hot Water Heater" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"LegalStories": "1" +"ParkingType1": "Owned" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"UnderContract": array:1 [ …1] +"WaterBodyType": "Bay" +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"CondoCorpNumber": 92 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1600-1799" +"RoomsAboveGrade": 10 +"RoomsBelowGrade": 4 +"WaterFrontageFt": "0" +"AccessToProperty": array:2 [ …2] +"AlternativePower": array:1 [ …1] +"PropertyFeatures": array:6 [ …6] +"SquareFootSource": "MPAC" +"PossessionDetails": "Speak To LA" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"ShorelineAllowance": "Not Owned" +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Upper" +"WashroomsType4Level": "Lower" +"WaterfrontAccessory": array:1 [ …1] +"LegalApartmentNumber": "301" +"MediaChangeTimestamp": "2026-04-30T14:40:16Z" +"PropertyManagementCompany": "Your Home Property Management" +"SystemModificationTimestamp": "2026-05-03T12:24:33.854384Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:48 [ …48] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4084 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W13065942" +"ListingId": "W13065942" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-03T12:22:21Z" +"RFModificationTimestamp": "2026-05-03T12:28:18Z" +"ListPrice": 1265000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Caledon" +"PostalCode": "L7C 1C9" +"UnparsedAddress": "174 Royal Valley Drive, Caledon, ON L7C 1C9" +"Coordinates": array:2 [ …2] +"Latitude": 43.7457695 +"Longitude": -79.8352545 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE REAL ESTATE SERVICES LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Beautifully updated detached family home in the quiet, sought-after community of Valleywood within a single-entry enclave, close to parks, top-rated schools, walking trails, and everyday amenities. Located in a family-friendly neighbourhood with municipal cameras and nearby emergency services and offering approx. 2,800 sq ft of total finished living space. This fully upgraded home features new engineered hardwood flooring on the main and upper levels, fresh paint throughout, and modern lighting. The renovated kitchen is a standout with custom soft-close cabinetry, quartz countertops and backsplash, a spacious island, and new LG stainless steel appliances including a gas stove and built-in electric oven. The main floor offers seamless flow for family living and entertaining, while upstairs features 3 bright bedrooms, including a primary suite with 5-piece ensuite, and an updated main bathroom. The fully finished basement adds flexibility with an additional bedroom, den, fireplace, and kitchen rough-in - ideal for in-law suite potential or future rental income. Enjoy a private backyard with pergola, swing set, and a new hot tub (installed October 2025, negotiable with purchase). Additional features include a metal roof, new patio door, parking for up to 6 vehicles, EV charger rough-in in the garage (currently connected to hot tub), central vacuum (as-is), and HVAC serviced Fall 2025. A turnkey, fully upgraded home in one of Calendon's most desirable communities - don't miss this opportunity!" +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"CityRegion": "Rural Caledon" +"CoListOfficeName": "ROYAL LEPAGE REAL ESTATE SERVICES LTD." +"CoListOfficePhone": "416-487-4311" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Peel" +"CoveredSpaces": "2.0" +"CreationDate": "2026-05-01T00:46:12.666562+00:00" +"CrossStreet": "Valleywood Blvd & Royal Valley Dr" +"DirectionFaces": "West" +"Directions": "Hwy 410 to Valleywood Blvd, west to Royal Valley Dr" +"Exclusions": "Bar fridge, chest freezer in basement, portable dehumidifier, safe in laundry room. *Hot Tub (purchased Oct 2025) is negotiable*" +"ExpirationDate": "2026-09-30" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "All existing light fixtures, all window blinds curtains rods and drapery, all existing appliances (other than those listed as exclusions), garage door opener, gazebo and swing set in backyard" +"InteriorFeatures": array:5 [ …5] +"RFTransactionType": "For Sale" …86 } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4085 …131} 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4086 …154} 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4087 …122} ] +success: true +page_size: 5 +page_count: 9578 +count: 47886 +after_key: "" } ] ]