These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract.
I acknowledge I can only access these forms as a ComFree customer under contract.
These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract and in partnership with Zubic Law.
I acknowledge I can only access these forms as a ComFree customer under contract.
These forms are provided to ComFree’s Unrepresented Sellers as part of their Mere Posting ComFree Listing Contract and in partnership with Imperium LLP – Rocky Kim.
I acknowledge I can only access these forms as a ComFree customer under contract.
1. Purchase Your Package
2. We Ship Your ‘For Sale’ Sign
3. Book Your VR Tour
4. Complete Listing Input Forms
5. We Make Your Listing Live
6. Get Support 7 Days a Week
7. iSOLD!
array:1 [ "RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=12&$skip=154884&$filter=(PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24508 +items: array:12 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24659 +post_id: "1429781" +post_author: 1 +"ListingKey": "29763504" +"ListingId": "40830878" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-29T12:00:08Z" +"RFModificationTimestamp": "2026-06-29T12:06:22Z" +"ListPrice": 899900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1206.0 +"BuildingAreaTotal": 0 +"City": "Cambridge" +"PostalCode": "N3C1A2" +"UnparsedAddress": "19 GUELPH Avenue Unit# 303, Cambridge, Ontario N3C1A2" +"Coordinates": array:2 [ 0 => -80.3109157 1 => 43.4322935 ] +"Latitude": 43.4322935 +"Longitude": -80.3109157 +"YearBuilt": 2020 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Experience elevated riverside living at Riverbank Lofts in the heart of historic Hespeler. Suite 303 is a rare bungalow style luxury loft offering exceptional space, privacy, and character within one of Cambridge's most sought after locations. Perfectly positioned along the beautiful Speed River and just minutes from Highway 401, this high-end residence blends historic industrial charm with sophisticated modern living. Featuring soaring ceilings, oversized windows, exposed beams, and authentic architectural details, the suite offers an expansive open-concept layout designed for both comfortable everyday living and elegant entertaining. Large principal rooms, refined finishes, and stunning river surroundings create a truly unique urban retreat.A standout feature of this suite is the incredibly rare parking and storage package, including a private 1.5-car garage, an additional owned outdoor parking space, and a dedicated storage unit - an exceptional combination rarely found in loft living.Residents enjoy an impressive collection of boutique-style amenities, including a fully equipped fitness centre, bike storage room, dog wash station, and multiple resident lounges designed for relaxing, entertaining, and socializing. Riverbank Lofts offers a truly walkable lifestyle steps to scenic river trails, cafés, restaurants, boutique shopping, and the charm of downtown Hespeler, while still providing quick and convenient access to Highway 401 for commuters. Garage #1 and out door spot 20. (id:62650)" +"Appliances": array:8 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Window Coverings" 6 => "Garage door opener" 7 => "Microwave Built-in" ] +"AssociationFee": "579.01" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:2 [ 0 => "Landscaping" 1 => "Property Management" ] +"Basement": array:1 [ 0 => "None" ] +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-16T03:20:27.307870+00:00" +"Directions": "401 to Townline Road, left on River road which turns into Queen Street, Turn right on Guelph Ave and then into Riverbank Lofts." +"ExteriorFeatures": array:1 [ 0 => "Stone" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1914716" +"ListOfficeKey": "274404" +"LivingAreaUnits": "square feet" +"LotFeatures": array:5 [ 0 => "Southern exposure" 1 => "Conservation/green belt" 2 => "Balcony" 3 => "Paved driveway" 4 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:2 [ 0 => "Detached Garage" 1 => "Open" ] +"PhotosChangeTimestamp": "2026-05-16T02:50:25Z" +"PhotosCount": 40 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-29T11:52:13Z" +"StreetName": "GUELPH" +"StreetNumber": "19" +"StreetSuffix": "Avenue" +"SubdivisionName": "43 - Hillcrest/Forbes Park" +"TaxAnnualAmount": "5432.65" +"View": "River view" +"VirtualTourURLUnbranded": "https://paulreibelphotography.hd.pics/19-Guelph-Ave-8" +"WaterBodyName": "Speed River" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:8 [ 0 => array:11 [ "RoomKey" => "1671008108" "RoomType" => "Laundry room" "ListingId" => "40830878" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29763504" "RoomLength" => null "RoomDimensions" => "5'5'' x 9'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-29T11:52:13.04Z" ] 1 => array:11 [ "RoomKey" => "1671008109" "RoomType" => "4pc Bathroom" "ListingId" => "40830878" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29763504" "RoomLength" => null "RoomDimensions" => "4'11'' x 10'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-29T11:52:13.04Z" ] 2 => array:11 [ "RoomKey" => "1671008110" "RoomType" => "Bedroom" "ListingId" => "40830878" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29763504" "RoomLength" => null "RoomDimensions" => "9'10'' x 13'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-29T11:52:13.04Z" ] 3 => array:11 [ "RoomKey" => "1671008111" "RoomType" => "Full bathroom" "ListingId" => "40830878" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29763504" "RoomLength" => null "RoomDimensions" => "7'1'' x 9'7''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-29T11:52:13.04Z" ] 4 => array:11 [ "RoomKey" => "1671008112" "RoomType" => "Primary Bedroom" "ListingId" => "40830878" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29763504" "RoomLength" => null "RoomDimensions" => "15'4'' x 16'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-29T11:52:13.04Z" ] 5 => array:11 [ "RoomKey" => "1671008113" "RoomType" => "Dining room" "ListingId" => "40830878" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29763504" "RoomLength" => null "RoomDimensions" => "12'1'' x 16'11''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-29T11:52:13.04Z" ] 6 => array:11 [ "RoomKey" => "1671008114" "RoomType" => "Kitchen" "ListingId" => "40830878" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29763504" "RoomLength" => null "RoomDimensions" => "7'6'' x 14'7''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-29T11:52:13.04Z" ] 7 => array:11 [ "RoomKey" => "1671008115" "RoomType" => "Living room" "ListingId" => "40830878" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29763504" "RoomLength" => null "RoomDimensions" => "16'5'' x 17'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-29T11:52:13.04Z" ] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29763504/19-guelph-avenue-unit-303-cambridge" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "Apartment" ] +"CommonInterest": "Condo/Strata" +"GeocodeManualYN": true +"BuildingFeatures": array:1 [ 0 => "Exercise Centre" ] +"ZoningDescription": "C1RM2" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 0 +"WaterfrontFeatures": array:1 [ 0 => "Waterfront on river" ] +"AboveGradeFinishedArea": 1206 +"OriginalEntryTimestamp": "2026-05-16T02:50:24.33Z" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1224102" +"ListOfficeNationalAssociationId": "1254957" +"Media": array:40 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "29763504_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/65dfca446718390222ccfc957b7ff9f4.webp" "MediaSize" => 152764 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-65dfca446718390222ccfc957b7ff9f4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Riverside building featuring a stone facade and multiple windows" "PreferredPhotoYN" => true "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "29763504_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/7131dd54b9f71648f0c6b3c3a66671f9.webp" "MediaSize" => 89789 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-7131dd54b9f71648f0c6b3c3a66671f9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "29763504_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/f73725b9fd87f57ae3d2deb4d61d0d9a.webp" "MediaSize" => 110966 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-f73725b9fd87f57ae3d2deb4d61d0d9a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Open-concept living space featuring exposed wood beam ceilings, dark wood-finish flooring, a white kitchen with stainless steel appliances, a kitchen island with seating, and tall windows with dark dr" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "29763504_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/3cc971c546e57ab99a4d2f78d954fb66.webp" "MediaSize" => 94517 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-3cc971c546e57ab99a4d2f78d954fb66.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Open-concept living space featuring exposed wood beam ceilings, dark wood-finish flooring, and industrial-style ductwork" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "29763504_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/be1c2a66c9a6ae28bc89452c10e79997.webp" "MediaSize" => 74475 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-be1c2a66c9a6ae28bc89452c10e79997.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen featuring white shaker-style cabinetry, stainless steel appliances, and a subway tile backsplash" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "29763504_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/e386b60d093a25eb9ab67990efa836a4.webp" "MediaSize" => 69229 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-e386b60d093a25eb9ab67990efa836a4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Modern kitchen featuring white shaker cabinetry, stainless steel appliances, a white subway tile backsplash, and light-colored countertops" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "29763504_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/304881f4e8bffed33312ab908413ed7a.webp" "MediaSize" => 79273 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-304881f4e8bffed33312ab908413ed7a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen island featuring dark wood cabinetry, brushed nickel hardware, and a light-toned countertop" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "29763504_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/a57f643024b648fd913ecc0ff14dfc1b.webp" "MediaSize" => 86976 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-a57f643024b648fd913ecc0ff14dfc1b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Open-concept kitchen featuring an oversized island with ample storage, stainless steel appliances, exposed wood beam ceilings, and sleek white cabinetry with subway tile backsplash" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "29763504_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/e2a1f4f481ed9d582b3eadcd9197e23a.webp" "MediaSize" => 79306 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-e2a1f4f481ed9d582b3eadcd9197e23a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Open-concept living area featuring exposed wood beam ceilings, dark wood-finish flooring, and a modern light fixture" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "29763504_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/df1a4ef2ab37bb5ae7afb9c2d5ac4043.webp" "MediaSize" => 80533 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-df1a4ef2ab37bb5ae7afb9c2d5ac4043.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Open-concept living space featuring exposed wood beam ceilings, dark wood-finish flooring, a kitchen island with seating, a white subway tile backsplash, and stainless steel appliances" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "29763504_4890_11" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/009d40547fda363bee0695feda667b10.webp" "MediaSize" => 66572 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-009d40547fda363bee0695feda667b10.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Exposed wooden ceiling beams complimenting dark wood-finish flooring" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "29763504_4890_12" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/d46e8f6dcc4ba244cf5d1741ff046e61.webp" "MediaSize" => 106252 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-d46e8f6dcc4ba244cf5d1741ff046e61.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Open-concept living space featuring exposed wood beam ceilings, large black-framed windows, and dark wood-finish flooring" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "29763504_4890_13" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/734cf99c6a6b24acd5f1697eff97fe25.webp" "MediaSize" => 63515 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-734cf99c6a6b24acd5f1697eff97fe25.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bathroom featuring a white vanity with an integrated sink and chrome fixtures, framed by a rectangular mirror" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 13 => array:13 [ "Order" => 14 "MediaKey" => "29763504_4890_14" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/e67dd176b2337471d994b017f74bf7ab.webp" "MediaSize" => 80836 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-e67dd176b2337471d994b017f74bf7ab.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bright interior space featuring high ceilings, dark wood-finish flooring, white walls, built-in shelving, and white double doors with matte black hardware" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 14 => array:13 [ "Order" => 15 "MediaKey" => "29763504_4890_15" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/9b8bdc6c460eb6bcfbf3800103854697.webp" "MediaSize" => 66963 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-9b8bdc6c460eb6bcfbf3800103854697.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Dark wood-finish flooring with a light area rug" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 15 => array:13 [ "Order" => 16 "MediaKey" => "29763504_4890_16" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/0ed359c530dff979d1347691764ed1f9.webp" "MediaSize" => 87178 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-0ed359c530dff979d1347691764ed1f9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Hardwood-finish flooring featuring a white interior door with matte black hardware" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 16 => array:13 [ "Order" => 17 "MediaKey" => "29763504_4890_17" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/bca87227ceae7fbefbc1a101d9a48d9e.webp" "MediaSize" => 70627 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-bca87227ceae7fbefbc1a101d9a48d9e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Hardwood-finish flooring throughout, complemented by a modern brass light fixture and large black-framed windows" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 17 => array:13 [ "Order" => 18 "MediaKey" => "29763504_4890_18" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/a495c187d99fdb7982ad5ef25883eb93.webp" "MediaSize" => 103758 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-a495c187d99fdb7982ad5ef25883eb93.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Open-concept living area featuring high exposed wood beam ceilings and dark wood-finish flooring" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 18 => array:13 [ "Order" => 19 "MediaKey" => "29763504_4890_19" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/747aba85ee2f6a406f9ee103b15a85f5.webp" "MediaSize" => 102406 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-747aba85ee2f6a406f9ee103b15a85f5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Spacious kitchen island with seating, dark wood-finish flooring, and exposed timber ceiling beams" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 19 => array:13 [ "Order" => 20 "MediaKey" => "29763504_4890_20" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/483675306d953d40f44e4397119d390a.webp" "MediaSize" => 55294 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-483675306d953d40f44e4397119d390a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Interior space featuring a visible structural wood beam, multiple paneled doors with black hardware, wood-finish flooring, and a contemporary ceiling light fixture" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 20 => array:13 [ "Order" => 21 "MediaKey" => "29763504_4890_21" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/32a0f23e5ea113c0e3a2458048c1c82e.webp" "MediaSize" => 67109 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-32a0f23e5ea113c0e3a2458048c1c82e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "High ceilings featuring exposed wood beams and industrial-style lighting" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 21 => array:13 [ "Order" => 22 "MediaKey" => "29763504_4890_22" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/0c849d033a103bf1e6f3196afb467a64.webp" "MediaSize" => 65418 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-0c849d033a103bf1e6f3196afb467a64.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bedroom featuring two white paneled doors with matte black hardware, exposed ductwork, a large window with white curtains, and a prominent wooden beam" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 22 => array:13 [ "Order" => 23 "MediaKey" => "29763504_4890_23" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/cd26759f465c584b09a29f0b212133bf.webp" "MediaSize" => 63316 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-cd26759f465c584b09a29f0b212133bf.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bedroom featuring high ceilings, exposed ductwork, and a ceiling fan with integrated lighting" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 23 => array:13 [ "Order" => 24 "MediaKey" => "29763504_4890_24" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/7fe9417f8f75e23c08e94fb56024c310.webp" "MediaSize" => 47467 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-7fe9417f8f75e23c08e94fb56024c310.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bathroom featuring a double vanity with integrated sinks, white cabinetry, and polished chrome hardware" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 24 => array:13 [ "Order" => 25 "MediaKey" => "29763504_4890_25" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/723c28da7722c5f14faef2a2b6bcaacb.webp" "MediaSize" => 44716 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-723c28da7722c5f14faef2a2b6bcaacb.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Double vanity with integrated sinks and white countertops" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 25 => array:13 [ "Order" => 26 "MediaKey" => "29763504_4890_26" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/b07d4986ca7281c15c43636070af79fe.webp" "MediaSize" => 57369 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-b07d4986ca7281c15c43636070af79fe.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Shower enclosure with a glass door, white subway tile surround, and a decorative mosaic tile accent" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 26 => array:13 [ "Order" => 27 "MediaKey" => "29763504_4890_27" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/679d77327bf0372d2572491f1e0541ad.webp" "MediaSize" => 63812 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-679d77327bf0372d2572491f1e0541ad.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Dedicated laundry area featuring stacked washer and dryer units" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 27 => array:13 [ "Order" => 28 "MediaKey" => "29763504_4890_28" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/513bc512ada7f1ecba12af5910cb362d.webp" "MediaSize" => 89687 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-513bc512ada7f1ecba12af5910cb362d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Lobby area featuring wood-finish flooring, a decorative wood partition, recessed lighting, and a mail center" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 28 => array:13 [ "Order" => 29 "MediaKey" => "29763504_4890_29" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/03f126642b7aba7723e7f2c832f6bee7.webp" "MediaSize" => 87756 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-03f126642b7aba7723e7f2c832f6bee7.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Fitness center with wood-paneled accent wall, exposed ductwork, recessed lighting, and mirrored wall" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 29 => array:13 [ "Order" => 30 "MediaKey" => "29763504_4890_30" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/1cbfd12c4678c157100a5d9320297aef.webp" "MediaSize" => 93777 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-1cbfd12c4678c157100a5d9320297aef.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Spacious interior featuring large windows with dark trim, light-colored walls, patterned flooring, and recessed ceiling lighting" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 30 => array:13 [ "Order" => 31 "MediaKey" => "29763504_4890_31" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/9caa453951e034ca1b27e4df6f0dfdb0.webp" "MediaSize" => 82433 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-9caa453951e034ca1b27e4df6f0dfdb0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Dedicated bike storage area featuring multiple vertical racks" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 31 => array:13 [ "Order" => 32 "MediaKey" => "29763504_4890_32" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/26620137d60294f655380c1993daf05a.webp" "MediaSize" => 84394 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-26620137d60294f655380c1993daf05a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Paved parking area featuring striped parking spaces and a wood-sided structure with a concrete foundation" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 32 => array:13 [ "Order" => 33 "MediaKey" => "29763504_4890_33" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/85192a99ed38fb229a8353b8c56a014c.webp" "MediaSize" => 106398 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-85192a99ed38fb229a8353b8c56a014c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Row of garages featuring vertical wood siding and light-colored paneled garage doors" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 33 => array:13 [ "Order" => 34 "MediaKey" => "29763504_4890_34" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/bf74b6cd7f0f4e0c06554839ad48f926.webp" "MediaSize" => 93182 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-bf74b6cd7f0f4e0c06554839ad48f926.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Garage interior featuring a distinctive epoxy floor, hexagonal ceiling lighting, and extensive built-in cabinetry" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 34 => array:13 [ "Order" => 35 "MediaKey" => "29763504_4890_35" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/f73a34065845ec8b43bd59d0751e65b8.webp" "MediaSize" => 172188 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-f73a34065845ec8b43bd59d0751e65b8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Modern multi-story building featuring extensive windows, a flat roofline, multiple balconies, and an integrated parking structure" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 35 => array:13 [ "Order" => 36 "MediaKey" => "29763504_4890_36" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/a65f95505e842b78ecad69348772a6c8.webp" "MediaSize" => 113463 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-a65f95505e842b78ecad69348772a6c8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Aerial perspective showcasing a river, a bridge, and surrounding urban and green spaces" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 36 => array:13 [ "Order" => 37 "MediaKey" => "29763504_4890_37" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/f8354c2e92678feab149a99fb1940612.webp" "MediaSize" => 122154 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-f8354c2e92678feab149a99fb1940612.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Stone facade building with multiple window openings bordering a waterway featuring a dam and river" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 37 => array:13 [ "Order" => 38 "MediaKey" => "29763504_4890_38" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/9cef16c1a997c7e9b7631770f17f4e7f.webp" "MediaSize" => 63471 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-9cef16c1a997c7e9b7631770f17f4e7f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Wood-finish door with a black frame and matte black hardware, featuring a modern unit number plate" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 38 => array:13 [ "Order" => 39 "MediaKey" => "29763504_4890_39" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/c34d3c1f4d191268688049cc961b3b93.webp" "MediaSize" => 45664 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-c34d3c1f4d191268688049cc961b3b93.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] 39 => array:13 [ "Order" => 40 "MediaKey" => "29763504_4890_40" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29763504/3744b69afbda971bc2ba1403d76eaa1d.webp" "MediaSize" => 105627 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29763504/thumbnail-3744b69afbda971bc2ba1403d76eaa1d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Historic masonry building featuring multiple window bays, an adjacent pedestrian bridge, and a riverfront setting" "PreferredPhotoYN" => false "ResourceRecordId" => "40830878" "ResourceRecordKey" => "29763504" "ModificationTimestamp" => "2026-05-16T02:50:24.35Z" ] ] +"DaysOnMarket": 47 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29763504')" +"ID": "1429781" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24482 +post_id: "1430449" +post_author: 1 +"ListingKey": "29763144" +"ListingId": "40830877" +"PropertyType": "Farm" +"PropertySubType": "Agriculture" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-29T19:40:04Z" +"RFModificationTimestamp": "2026-06-29T19:43:46Z" +"ListPrice": 2090000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 10.03 +"LivingArea": 2119.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8N2Z7" +"UnparsedAddress": "10 HUISMAN Lane, Hamilton, Ontario L8N2Z7" +"Coordinates": array:2 [ 0 => -79.9408374 1 => 43.3661059 ] +"Latitude": 43.3661059 +"Longitude": -79.9408374 +"YearBuilt": 1968 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Set on approximately 10 acres in the heart of desirable Flamborough, this distinguished country estate offers a rare blend of refined rural living and a fully equipped equestrian facility. The four-bedroom bungalow is thoughtfully positioned to take in the surrounding pastoral landscape, offering privacy, comfort, and an authentic countryside lifestyle. Purpose-built for the discerning equestrian, the property showcases an impressive 70' x 110' indoor riding arena complete with four box stalls, a heated tack room, and wash stall. Complementing the indoor facilities are a 200' x 85' outdoor riding arena, 70' x 65' lunging paddock, and four well-maintained paddocks designed for efficient rotational grazing. A 25' x 40' detached garage/workshop further enhances the functionality of the estate. The land offers a harmonious balance of open, usable acreage and naturalized areas, providing both operational flexibility and exceptional privacy. This is a turnkey opportunity for equestrian professionals, hobby farm enthusiasts, or those seeking a true rural estate lifestyle. The property is subject to A2 (Agricultural) zoning with portions designated under P8 (Conservation/Hazard Land) overlay. A2 zoning support rural residential and agricultural/equestrian uses, while P8- regulated areas are environmentally protected and not available for development. Ideally located within easy reach of Waterdown, Ancaster, and Hamilton, and offering convenient access to Highway 403 and the QEW, this estate delivers an exceptional balance of country seclusion and commuter accessibility. (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Dishwasher" 2 => "Stove" 3 => "Dryer" 4 => "Hood Fan" 5 => "Garage door opener" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Crawl space" ] +"Cooling": array:1 [ 0 => "None" ] +"CreationDate": "2026-05-16T01:35:00.666863+00:00" +"Directions": "Hamilton Drive (Centre Rd) north from Waterdown, east on Huisman Lane" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Stucco" ] +"Fencing": array:1 [ 0 => "Partially fenced" ] +"FireplaceFeatures": array:1 [ 0 => "Insert" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"Heating": array:2 [ 0 => "Forced air" 1 => "Propane" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1524719" +"ListOfficeKey": "288925" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Sump Pump" ] +"LotSizeDimensions": "10.03" +"ParkingFeatures": array:1 [ 0 => "Detached Garage" ] +"PhotosChangeTimestamp": "2026-05-20T16:21:20Z" +"PhotosCount": 40 +"PoolFeatures": array:1 [ 0 => "Above ground pool" ] +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-29T19:33:34Z" +"Stories": "1.0" +"StreetName": "HUISMAN" +"StreetNumber": "10" +"StreetSuffix": "Lane" +"SubdivisionName": "044 - Flamborough East" +"TaxAnnualAmount": "5481.95" +"Utilities": array:1 [ 0 => "Electricity" ] +"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/videos/019e273e-1c1d-70a0-b5d0-71cda8b63ef8" +"WaterSource": array:1 [ 0 => "Drilled Well" ] +"Rooms": array:12 [ 0 => array:11 [ "RoomKey" => "1671398177" "RoomType" => "Porch" "ListingId" => "40830877" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29763144" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-29T19:33:34.29Z" ] 1 => array:11 [ "RoomKey" => "1671398178" "RoomType" => "Laundry room" "ListingId" => "40830877" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29763144" "RoomLength" => null "RoomDimensions" => "10'5'' x 10'3''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-29T19:33:34.29Z" ] 2 => array:11 [ "RoomKey" => "1671398179" "RoomType" => "4pc Bathroom" "ListingId" => "40830877" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29763144" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-29T19:33:34.29Z" ] 3 => array:11 [ "RoomKey" => "1671398180" "RoomType" => "Bedroom" "ListingId" => "40830877" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29763144" "RoomLength" => null "RoomDimensions" => "10'6'' x 10'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-29T19:33:34.29Z" ] 4 => array:11 [ "RoomKey" => "1671398181" …10 ] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29763144/10-huisman-lane-hamilton" +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "A2, P8" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 737.0 +"AboveGradeFinishedArea": 2119 +"OriginalEntryTimestamp": "2026-05-16T00:31:38.31Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1063960" +"ListOfficeNationalAssociationId": "1372539" +"Media": array:40 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] ] +"DaysOnMarket": 47 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29763144')" +"ID": "1430449" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24647 +post_id: "1429511" +post_author: 1 +"ListingKey": "29762742" +"ListingId": "40830875" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T16:30:18Z" +"RFModificationTimestamp": "2026-06-02T16:33:29Z" +"ListPrice": 438900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 1.7 +"LivingArea": 955.0 +"BuildingAreaTotal": 0 +"City": "Ingersoll" +"PostalCode": "N5C1C4" +"UnparsedAddress": "46 CANTERBURY Street Unit# 307, Ingersoll, Ontario N5C1C4" +"Coordinates": array:2 [ 0 => -80.8780626 1 => 43.0355035 ] +"Latitude": 43.0355035 +"Longitude": -80.8780626 +"YearBuilt": 2007 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Bright and well-maintained 2-bedroom condominium overlooking beautiful Smith Pond Park in one of Ingersoll’s most desirable retirement-oriented communities. This thoughtfully designed unit offers peaceful pond views, in-suite laundry, a functional gallery-style kitchen, and high-efficiency in-unit mechanicals for comfortable, low-maintenance living. Enjoy low condo fees, quiet surroundings, and easy access to walking paths, nature, and everyday amenities. A rare opportunity to own in a highly sought-after building where units are seldom offered for sale. (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Stove" 4 => "Dryer" 5 => "Microwave" ] +"AssociationFee": "396.02" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:3 [ 0 => "Landscaping" 1 => "Water" 2 => "Insurance" ] +"Basement": array:1 [ 0 => "None" ] +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-16T01:05:55.912064+00:00" +"Directions": "Between Thames and Wellington" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2150268" +"ListOfficeKey": "86262" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Conservation/green belt" 1 => "Balcony" ] +"LotSizeDimensions": "1.7" +"ParkingFeatures": array:1 [ 0 => "Visitor Parking" ] +"PhotosChangeTimestamp": "2026-05-15T23:01:14Z" +"PhotosCount": 20 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:22:47Z" +"Stories": "1.0" +"StreetName": "CANTERBURY" +"StreetNumber": "46" +"StreetSuffix": "Street" +"SubdivisionName": "Ingersoll - South" +"TaxAnnualAmount": "2684" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:6 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29762742/46-canterbury-street-unit-307-ingersoll" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "Apartment" ] +"CommonInterest": "Condo/Strata" +"GeocodeManualYN": true +"BuildingFeatures": array:1 [ 0 => "Party Room" ] +"SecurityFeatures": array:1 [ 0 => "Security system" ] +"ZoningDescription": "R2" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 0 +"AboveGradeFinishedArea": 955 +"OriginalEntryTimestamp": "2026-05-15T23:01:14.15Z" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Builder" +"ListAgentNationalAssociationId": "1401011" +"ListOfficeNationalAssociationId": "1004415" +"Media": array:20 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] ] +"DaysOnMarket": 47 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29762742')" +"ID": "1429511" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24504 +post_id: "1444659" +post_author: 1 +"ListingKey": "29782102" +"ListingId": "40830870" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T16:30:31Z" +"RFModificationTimestamp": "2026-06-02T16:32:02Z" +"ListPrice": 1000000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2100.0 +"BuildingAreaTotal": 0 +"City": "Port Rowan" +"PostalCode": "N0E1M0" +"UnparsedAddress": "44 OLD CUT Boulevard, Port Rowan, Ontario N0E1M0" +"Coordinates": array:2 [ 0 => -80.3996426 1 => 42.5856285 ] +"Latitude": 42.5856285 +"Longitude": -80.3996426 +"YearBuilt": 1987 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Experience the ultimate waterfront lifestyle at 44 Old Cut Boulevard, situated on a rare double-wide lot in the heart of prestigious Long Point. This fully winterized, year-round cottage has been meticulously renovated throughout, offering a perfect blend of modern comfort and coastal charm. The main floor features a bright, open-concept living and dining area anchored by a stunning stone fireplace, 4 bedrooms, 2 modern bathrooms, and a dedicated laundry room. The chef’s kitchen is a showstopper, boasting sleek white cabinetry, granite countertops, a matching backsplash, and five new appliances. High-end, luxury waterproof flooring flows throughout the main level, freshly painted, new light fixtures. Relax in the all-season sunroom or step through sliding doors to a large covered deck, perfect for enjoying southwest sunsets and outdoor dining. Retreat to the prodigious second-floor great room, where massive windows frame panoramic nature views and flood the massive space with natural light. Outdoor enthusiasts will prize the covered boat well, backyard fire pit, and direct water access for fishing and boating. Additional highlights include a 1.5-car garage/workshop, a paved 3-car driveway, and updated mechanicals including a high-efficiency furnace/AC and new water pump. Located just steps from Long Point Provincial Park trails and beaches, this is the perfect place to call home. (id:62650)" +"Appliances": array:6 [ 0 => "Refrigerator" 1 => "Water softener" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Window Coverings" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Crawl space" ] +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-21T17:21:10.873361+00:00" +"Directions": "Erie Blvd. turn left on Old Cut, Rogers Ave. and Old Cut Blvd." +"ExteriorFeatures": array:1 [ 0 => "Aluminum siding" ] +"FireplaceFeatures": array:2 [ 0 => "Propane" 1 => "Other - See remarks" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:4 [ 0 => "Baseboard heaters" 1 => "Forced air" 2 => "Electric" 3 => "Propane" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1741120" +"ListOfficeKey": "54929" +"LivingAreaUnits": "square feet" +"LotFeatures": array:4 [ 0 => "Cul-de-sac" 1 => "Ravine" 2 => "Conservation/green belt" 3 => "Paved driveway" ] +"NumberOfUnitsTotal": "1" +"ParkingFeatures": array:1 [ 0 => "Detached Garage" ] +"PhotosChangeTimestamp": "2026-05-21T13:31:26Z" +"PhotosCount": 50 +"Sewer": array:1 [ 0 => "Holding Tank" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:22:48Z" +"Stories": "1.5" +"StreetName": "OLD CUT" +"StreetNumber": "44" +"StreetSuffix": "Boulevard" +"SubdivisionName": "Port Rowan" +"TaxAnnualAmount": "6531" +"View": "Direct Water View" +"VirtualTourURLUnbranded": "https://youriguide.com/44_old_cut_blvd_port_rowan_on/" +"WaterBodyName": "East Lake" +"WaterSource": array:2 [ 0 => "Sand point" 1 => "Well" ] +"Rooms": array:13 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29782102/44-old-cut-boulevard-port-rowan" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "LP" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 0 +"WaterfrontFeatures": array:1 [ 0 => "Waterfront on canal" ] +"FrontageLengthNumeric": 120.0 +"AboveGradeFinishedArea": 2100 +"OriginalEntryTimestamp": "2026-05-21T13:31:26.46Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1179133" +"ListOfficeNationalAssociationId": "1003534" +"Media": array:50 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] 44 => array:13 [ …13] 45 => array:13 [ …13] 46 => array:13 [ …13] 47 => array:13 [ …13] 48 => array:13 [ …13] 49 => array:13 [ …13] ] +"DaysOnMarket": 42 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29782102')" +"ID": "1444659" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24494 +post_id: "1429384" +post_author: 1 +"ListingKey": "29762135" +"ListingId": "40830863" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T16:30:18Z" +"RFModificationTimestamp": "2026-06-02T16:33:41Z" +"ListPrice": 579700.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1020.0 +"BuildingAreaTotal": 0 +"City": "Milton" +"PostalCode": "L9T0B5" +"UnparsedAddress": "1479 MAPLE Avenue Unit# 102, Milton, Ontario L9T0B5" +"Coordinates": array:2 [ 0 => -79.8599265 1 => 43.5375623 ] +"Latitude": 43.5375623 +"Longitude": -79.8599265 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 1479 Maple Avenue, where condo living meets the feel of your own private retreat. This rarely offered 2-bedroom, 2-bathroom suite boasts over 1,000 square feet of stylish, carpet-free living with direct walk-out access to green space, no elevators, no stairs, just effortless indoor-outdoor living. Perfect for pet owners, young families, or downsizers, enjoy the convenience of stepping right outside from your kitchen to open green space, ideal for morning coffee, kids at play, or your furry companion. Plus, no direct neighbours looking in means added privacy you don't often find in condo living. Inside, you'll find new laminate flooring throughout, updated bathrooms with modern vanities and flooring, and new window coverings that complete the fresh, move-in-ready feel. Love to entertain? BBQ with ease just steps from your door, or take advantage of the spacious party room located right across the green space. Stay active with access to the building gym, and enjoy the convenience of ample visitor parking, your own dedicated parking space, and a private locker. This is the one buyers wait for, easy living, exceptional layout, and a lifestyle upgrade all in one. Don't miss it! (id:62650)" +"AssociationFee": "600.39" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:1 [ 0 => "Parking" ] +"Basement": array:1 [ 0 => "None" ] +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-16T01:26:32.502727+00:00" +"ExteriorFeatures": array:1 [ 0 => "Stucco" ] +"Heating": array:1 [ 0 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1895531" +"ListOfficeKey": "277682" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Balcony" ] +"ParkingFeatures": array:2 [ 0 => "Underground" 1 => "None" ] +"PhotosChangeTimestamp": "2026-05-15T21:32:06Z" +"PhotosCount": 50 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:22:51Z" +"Stories": "1.0" +"StreetName": "MAPLE" +"StreetNumber": "1479" +"StreetSuffix": "Avenue" +"SubdivisionName": "1029 - DE Dempsey" +"TaxAnnualAmount": "2667.98" +"VirtualTourURLUnbranded": "https://kurtis-oliveira-photography.aryeo.com/videos/019dd479-60e0-7315-a04c-1d460960051b" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:7 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29762135/1479-maple-avenue-unit-102-milton" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "Apartment" ] +"CommonInterest": "Condo/Strata" +"GeocodeManualYN": true +"BuildingFeatures": array:2 [ 0 => "Exercise Centre" 1 => "Party Room" ] +"ZoningDescription": "RMD1*35" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 0 +"AboveGradeFinishedArea": 1020 +"OriginalEntryTimestamp": "2026-05-15T21:32:05.9Z" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1214153" +"ListOfficeNationalAssociationId": "1286675" +"Media": array:50 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] 44 => array:13 [ …13] 45 => array:13 [ …13] 46 => array:13 [ …13] 47 => array:13 [ …13] 48 => array:13 [ …13] 49 => array:13 [ …13] ] +"DaysOnMarket": 47 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29762135')" +"ID": "1429384" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24643 +post_id: "1451055" +post_author: 1 +"ListingKey": "29793661" +"ListingId": "40830856" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-09T12:00:56Z" +"RFModificationTimestamp": "2026-06-09T12:01:37Z" +"ListPrice": 224900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 544.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8N2V4" +"UnparsedAddress": "137 EMERALD Street S Unit# 28, Hamilton, Ontario L8N2V4" +"Coordinates": array:2 [ 0 => -79.8557051 1 => 43.2488707 ] +"Latitude": 43.2488707 +"Longitude": -79.8557051 +"YearBuilt": 1953 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Rare opportunity to live close to the Hamilton core, with exceptionally affordable monthly living costs of approximately $500/month! Discover the incredible value in this updated, spacious one bedroom suite nestled within a charming 3rd floor unit in a quaint, 36 unit, cooperative building. The renovated, bright, kitchen is cheerful and functional while the generous room sizes offer true comfort, including a bedroom, large enough to accommodate a king size bed. The renovated four-piece bathroom features a newly glazed tub and decorative, stylish, tile accents. . Storage is abundant with three closets and an included locker. Step outside and you are minutes from the escarpment rail trail, public transit & easy commuting with quick access to the 403, GO station, McMaster University, Mohawk College, major hospitals, and minutes from downtown and the trendy James Street district. This is a truly unique opportunity to enjoy a convenient, community oriented lifestyle at an exceptionally affordable price point in one of Hamilton’s original, stately, neighborhoods. Please note: co-op guidelines apply - traditional mortgages not permitted, no rentals, pets are restricted, no smoking is permitted. Buyer acceptance by the board is required. (id:62783)" +"Appliances": array:2 [ 0 => "Refrigerator" 1 => "Stove" ] +"AssociationFee": "390.21" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:5 [ 0 => "Cable TV" 1 => "Heat" 2 => "Water" 3 => "Insurance" 4 => "Parking" ] +"Basement": array:1 [ 0 => "None" ] +"Cooling": array:1 [ 0 => "Window air conditioner" ] +"CreationDate": "2026-05-22T21:41:47.903938+00:00" +"Directions": "From Stinson Street Go North on Emerald St S. From Main St, Go South." +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:2 [ 0 => "Radiant heat" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2023429" +"ListOfficeKey": "283153" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Paved driveway" ] +"ParkingFeatures": array:1 [ 0 => "Open" ] +"PhotosChangeTimestamp": "2026-05-22T21:12:49Z" +"PhotosCount": 23 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-09T11:50:51Z" +"Stories": "1.0" +"StreetDirSuffix": "South" +"StreetName": "EMERALD" +"StreetNumber": "137" +"StreetSuffix": "Street" +"SubdivisionName": "143 - Stinson" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:5 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29793661/137-emerald-street-s-unit-28-hamilton" +"StructureType": array:1 [ 0 => "Apartment" ] +"GeocodeManualYN": true +"ZoningDescription": "E" +"BedroomsAboveGrade": 1 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 102.0 +"AboveGradeFinishedArea": 544 +"OriginalEntryTimestamp": "2026-05-22T21:10:36.04Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Owner" +"ListAgentNationalAssociationId": "1303240" +"ListOfficeNationalAssociationId": "1325050" +"Media": array:23 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] ] +"DaysOnMarket": 40 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29793661')" +"ID": "1451055" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24642 +post_id: "1437285" +post_author: 1 +"ListingKey": "29772285" +"ListingId": "40830853" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-28T20:20:05Z" +"RFModificationTimestamp": "2026-06-28T20:27:32Z" +"ListPrice": 899900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2876.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8G5C4" +"UnparsedAddress": "15 GABRIELE Court, Hamilton, Ontario L8G5C4" +"Coordinates": array:2 [ 0 => -79.7755162 1 => 43.2143913 ] +"Latitude": 43.2143913 +"Longitude": -79.7755162 +"YearBuilt": 1989 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Stunning 3+1 bedroom home with in-law suite tucked away on a quiet court, featuring approximately 2,775 sq. ft. of finished living space. From the moment you step inside, you’ll appreciate the pride of ownership and value of this home. The main floor features a skylight in the foyer, hardwood flooring in the living and dining rooms, and an eat-in kitchen overlooking the family room with a cozy gas fireplace. California shutters are featured throughout the home, adding elegance and style. A beautiful staircase leads to the upper level where the spacious primary bedroom includes its own ensuite bathroom. Part of the garage has been converted into a private office with heating and a separate entrance, perfect for working from home or a home-based business. Office can be easily converted back to full garage. The fully finished basement includes an in-law suite and a sauna, providing excellent potential for extended family living and relaxation. Walk out from the kitchen to a deck overlooking the fully fenced backyard complete with a custom shed with hydro and plenty of outdoor space to enjoy. Conveniently located close to all amenities with quick highway access. (id:62650)" +"Appliances": array:8 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Central Vacuum" 3 => "Range - Gas" 4 => "Dishwasher" 5 => "Dryer" 6 => "Hood Fan" 7 => "Garage door opener" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-19T23:35:58.998685+00:00" +"Directions": "King St E to Greenhill Ave, Right on Gabriele" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1524176" +"ListOfficeKey": "55026" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Cul-de-sac" 1 => "Skylight" 2 => "In-Law Suite" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-19T20:11:19Z" +"PhotosCount": 39 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-28T20:14:50Z" +"Stories": "2.0" +"StreetName": "GABRIELE" +"StreetNumber": "15" +"StreetSuffix": "Court" +"SubdivisionName": "283 - Gershome" +"TaxAnnualAmount": "6692.19" +"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/361541" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:19 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] 15 => array:11 [ …11] 16 => array:11 [ …11] 17 => array:11 [ …11] 18 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29772285/15-gabriele-court-hamilton" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "1638859" +"CommonInterest": "Freehold" +"CoListOfficeKey": "291472" +"GeocodeManualYN": true +"ZoningDescription": "C" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 38.0 +"AboveGradeFinishedArea": 1888 +"BelowGradeFinishedArea": 988 +"OriginalEntryTimestamp": "2026-05-19T20:11:18.91Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1064403" +"ListOfficeNationalAssociationId": "1003694" +"CoListAgentNationalAssociationId": "1164549" +"CoListOfficeNationalAssociationId": "1398404" +"Media": array:39 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] ] +"DaysOnMarket": 43 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29772285')" +"ID": "1437285" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24625 +post_id: "1429418" +post_author: 1 +"ListingKey": "29763145" +"ListingId": "40830852" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T16:30:18Z" +"RFModificationTimestamp": "2026-06-02T16:33:29Z" +"ListPrice": 629000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1130.0 +"BuildingAreaTotal": 0 +"City": "Caledonia" +"PostalCode": "N3W2H2" +"UnparsedAddress": "67 HADDINGTON Street Unit# 208, Caledonia, Ontario N3W2H2" +"Coordinates": array:2 [ 0 => -79.9550185 1 => 43.0634828 ] +"Latitude": 43.0634828 +"Longitude": -79.9550185 +"YearBuilt": 2017 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Rarely offered corner unit in Harrison Flats. This bright 2-bedroom, 2-bath condo offers carefree living in one of Caledonia’s most sought-after buildings—ideal for downsizers, professionals, and couples alike. This South facing suite is filled with natural light showcasing beautiful sunrises and afternoon sun, enhanced by oversized windows and fitted with shutters throughout. Enjoy year-round use of the “coveted” covered corner balcony—perfect for relaxing, reading, or taking in the sounds of birds chirping on the quiet side of the building. Enjoy the vibrant community across the street, including the arena, events centre, library, park, and baseball diamond. The spacious primary bedroom features a 3-piece ensuite and two closets, while the generous second bedroom also includes a walk-in closet. All closets are outfitted with shelving to suit your storage needs. Additional highlights include a full-size washer/dryer combo in a large in-suite laundry room with extra storage, one above-ground exclusive use parking space. Building amenities include party room, common BBQ area, bike racks, and visitor parking. Conveniently located for commuters to Hamilton, Burlington, Toronto, Kitchener, and Niagara. Move in and enjoy elegant, low-maintenance living in a welcoming, established community. (id:62650)" +"Appliances": array:3 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Microwave Built-in" ] +"AssociationFee": "528.76" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:6 [ 0 => "Landscaping" 1 => "Property Management" 2 => "Heat" 3 => "Water" 4 => "Insurance" 5 => "Parking" ] +"Basement": array:1 [ 0 => "None" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-16T01:05:02.433713+00:00" +"Directions": "South on Highway 6/Upper James to Argyle St South, East on Haddington St" +"ExteriorFeatures": array:2 [ 0 => "Stone" 1 => "Vinyl siding" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2013227" +"ListOfficeKey": "55061" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Southern exposure" 1 => "Balcony" ] +"ParkingFeatures": array:1 [ 0 => "Open" ] +"PhotosChangeTimestamp": "2026-05-16T00:50:42Z" +"PhotosCount": 29 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:22:53Z" +"Stories": "1.0" +"StreetName": "HADDINGTON" +"StreetNumber": "67" +"StreetSuffix": "Street" +"SubdivisionName": "633 - Caledonia South East" +"TaxAnnualAmount": "3359" +"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/sites/67-haddington-st-208-caledonia-on-n3w-2h2-24905846/branded" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:8 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29763145/67-haddington-street-unit-208-caledonia" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "Apartment" ] +"CommonInterest": "Condo/Strata" +"GeocodeManualYN": true +"BuildingFeatures": array:1 [ 0 => "Party Room" ] +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "D, R1" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 0 +"AboveGradeFinishedArea": 1130 +"OriginalEntryTimestamp": "2026-05-16T00:31:38.99Z" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1294732" +"ListOfficeNationalAssociationId": "1003659" +"Media": array:29 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] ] +"DaysOnMarket": 47 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29763145')" +"ID": "1429418" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24509 +post_id: "1430516" +post_author: 1 +"ListingKey": "29763793" +"ListingId": "40830846" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T16:30:18Z" +"RFModificationTimestamp": "2026-06-02T16:33:27Z" +"ListPrice": 249900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 897.0 +"BuildingAreaTotal": 0 +"City": "Kitchener" +"PostalCode": "N2M4N6" +"UnparsedAddress": "4 AVALON Place Unit# 105, Kitchener, Ontario N2M4N6" +"Coordinates": array:2 [ 0 => -80.489806 1 => 43.4274208 ] +"Latitude": 43.4274208 +"Longitude": -80.489806 +"YearBuilt": 1978 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "ATTENTION FIRST-TIME BUYERS & DOWNSIZERS! Here’s your opportunity to get into the market with this beautifully maintained, move-in-ready 2-bedroom condo located in the highly desirable Forest Hill community. Tucked away on a private dead-end street, this bright and inviting unit offers comfort, convenience, and exceptional value. Pride of ownership is evident throughout this freshly painted, carpet-free home featuring stylish laminate flooring and a functional layout designed for easy living. The unit offers 2 spacious bedrooms, an updated 4-piece bathroom, a practical galley kitchen, dedicated dining area, and a warm, welcoming living room perfect for relaxing or entertaining. Enjoy the convenience of a walkout from the living room to your ground-level patio—ideal for easy grocery drop-offs, outdoor enjoyment, and added accessibility. Additional features include dedicated parking, storage locker, and convenient on-site laundry facilities within the building. Located just minutes from parks, shopping, public transit, and major highways, this fantastic Kitchener location puts everything you need right at your doorstep. Affordable, updated, and move-in ready—this is the perfect place to start, simplify, or invest. Opportunities like this don’t last long—book your private showing today! (id:62650)" +"Appliances": array:4 [ 0 => "Refrigerator" 1 => "Water softener" 2 => "Stove" 3 => "Hood Fan" ] +"AssociationFee": "788.21" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:3 [ 0 => "Water" 1 => "Insurance" 2 => "Parking" ] +"Basement": array:1 [ 0 => "None" ] +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"Cooling": array:1 [ 0 => "Window air conditioner" ] +"CreationDate": "2026-05-16T13:55:29.940458+00:00" +"Directions": "Homer Watson Blvd to Sterling Ave S to Avalon Place" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"Heating": array:2 [ 0 => "Baseboard heaters" 1 => "Electric" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1750161" +"ListOfficeKey": "283896" +"LivingAreaUnits": "square feet" +"LotFeatures": array:5 [ 0 => "Cul-de-sac" 1 => "Conservation/green belt" 2 => "Balcony" 3 => "Paved driveway" 4 => "Laundry- Coin operated" ] +"ParkingFeatures": array:1 [ 0 => "None" ] +"PhotosChangeTimestamp": "2026-05-16T11:59:41Z" +"PhotosCount": 24 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:22:54Z" +"Stories": "1.0" +"StreetName": "AVALON" +"StreetNumber": "4" +"StreetSuffix": "Place" +"SubdivisionName": "325 - Forest Hill" +"TaxAnnualAmount": "1574" +"VirtualTourURLUnbranded": "https://youriguide.com/105_4_avalon_pl_kitchener_on/" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:6 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29763793/4-avalon-place-unit-105-kitchener" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "Apartment" ] +"CommonInterest": "Condo/Strata" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Security system" ] +"ZoningDescription": "R2" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 0.0 +"AboveGradeFinishedArea": 897 +"OriginalEntryTimestamp": "2026-05-16T11:59:41.36Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1163644" +"ListOfficeNationalAssociationId": "1349002" +"Media": array:24 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] ] +"DaysOnMarket": 47 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29763793')" +"ID": "1430516" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24510 +post_id: "1438890" +post_author: 1 +"ListingKey": "29775988" +"ListingId": "40830844" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-06T05:00:35Z" +"RFModificationTimestamp": "2026-06-06T05:13:42Z" +"ListPrice": 799900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2307.0 +"BuildingAreaTotal": 0 +"City": "Stoney Creek" +"PostalCode": "L8E1X8" +"UnparsedAddress": "39 CHESTER Road, Stoney Creek, Ontario L8E1X8" +"Coordinates": array:2 [ 0 => -79.7383009 1 => 43.2252196 ] +"Latitude": 43.2252196 +"Longitude": -79.7383009 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Stop renting and let your tenants pay your mortgage! Welcome to 39 Chester Road, the ultimate house-hacking opportunity in the heart of Stoney Creek. This rare, legal non-conforming duplex features 3 completely self-contained units across 2,307 sq. ft. of total living space—allowing a first-time buyer to live comfortably in one unit while collecting substantial rental income from the other two. The spacious, independent layout includes a 2-bedroom upper-level unit (perfect for an owner-occupant), a 1-bedroom main-level unit, and a bright 1-bedroom lower-level unit complete with a walk-out basement. Each unit boasts its own private entrance, independent kitchen, and separate bathroom. Move right in or select your own tenants with complete peace of mind: the property has been freshly painted and upgraded with new flooring. Financial management is a breeze with separate hydro meters already installed, ensuring tenants pay their own electricity bills. Outside, enjoy a massive triple-wide driveway with parking for up to 8 vehicles and a deep, premium lot with a large private backyard. Perfectly positioned in a highly family-oriented neighbourhood just minutes from schools, local parks, major transit routes, and highway access. Don’t miss this incredible chance to fast-track your home equity! Currently vacant, allowing you to choose your own tenants at market rents. (id:62650)" +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"Cooling": array:1 [ 0 => "None" ] +"CreationDate": "2026-05-20T15:36:50.311235+00:00" +"Directions": "Hwy 8 / Gray Rd" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1981716" +"ListOfficeKey": "299866" +"LivingAreaUnits": "square feet" +"PhotosChangeTimestamp": "2026-05-20T15:03:43Z" +"PhotosCount": 38 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-06T04:50:31Z" +"Stories": "2.0" +"StreetName": "CHESTER" +"StreetNumber": "39" +"StreetSuffix": "Road" +"SubdivisionName": "511 - Eastdale/Poplar Park/Industrial" +"TaxAnnualAmount": "4844" +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=ZBWYZH7iXAr" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:15 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29775988/39-chester-road-stoney-creek" +"ParkingTotal": 8 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "2227788" +"CommonInterest": "Freehold" +"CoListOfficeKey": "299866" +"GeocodeManualYN": true +"ZoningDescription": "R1" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 65.0 +"AboveGradeFinishedArea": 1737 +"BelowGradeFinishedArea": 570 +"OriginalEntryTimestamp": "2026-05-20T15:00:59.36Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1267128" +"ListOfficeNationalAssociationId": "1477944" +"CoListAgentNationalAssociationId": "1470633" +"CoListOfficeNationalAssociationId": "1477944" +"Media": array:38 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] ] +"DaysOnMarket": 43 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29775988')" +"ID": "1438890" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24503 +post_id: "1429424" +post_author: 1 +"ListingKey": "29763295" +"ListingId": "40830843" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-26T23:20:07Z" +"RFModificationTimestamp": "2026-06-26T23:29:23Z" +"ListPrice": 599900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1419.0 +"BuildingAreaTotal": 0 +"City": "Cambridge" +"PostalCode": "N3H4E6" +"UnparsedAddress": "766 GARDEN Street, Cambridge, Ontario N3H4E6" +"Coordinates": array:2 [ 0 => -80.346915 1 => 43.4022636 ] +"Latitude": 43.4022636 +"Longitude": -80.346915 +"YearBuilt": 1961 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Beautiful raised bungalow featuring 3 bedrooms with bay windows installed in 2018, 2 bathrooms, and a bright open-concept layout perfect for comfortable family living and entertaining. Enjoy the inviting sunroom with updated windows completed in 2022, along with a skylight in the kitchen updated in 2025 that fills the home with natural light. Additional updates include eavestroughs replaced in 2023, and furnace and air conditioning updated in 2022 for added peace of mind. This property also offers an extra-large garage with ample storage space, a double wide driveway, and a beautifully maintained large side yard ideal for outdoor enjoyment. in addition to the large shed in the backyard. A wonderful opportunity to own a well-maintained home with thoughtful upgrades throughout. (id:62650)" +"Appliances": array:4 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Stove" 3 => "Oven - Built-In" ] +"ArchitecturalStyle": array:1 [ 0 => "Raised bungalow" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"CommunityFeatures": array:2 [ 0 => "School Bus" 1 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-16T01:44:02.867029+00:00" +"Directions": "From Consession St, turn into Garden" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2087196" +"ListOfficeKey": "156288" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Corner Site" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-16T01:09:24Z" +"PhotosCount": 40 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-26T23:11:52Z" +"Stories": "1.0" +"StreetName": "GARDEN" +"StreetNumber": "766" +"StreetSuffix": "Street" +"SubdivisionName": "51 - Langs Farm/Eagle Valley" +"TaxAnnualAmount": "3746" +"VirtualTourURLUnbranded": "https://youriguide.com/766_garden_st_cambridge_on/" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:13 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29763295/766-garden-street-cambridge" +"ParkingTotal": 3 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R5" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 60.0 +"AboveGradeFinishedArea": 1079 +"BelowGradeFinishedArea": 341 +"OriginalEntryTimestamp": "2026-05-16T01:09:24.05Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1360531" +"ListOfficeNationalAssociationId": "1112493" +"Media": array:40 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] ] +"DaysOnMarket": 47 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29763295')" +"ID": "1429424" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24507 +post_id: "1428072" +post_author: 1 +"ListingKey": "29761614" +"ListingId": "40830835" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-09T23:50:22Z" +"RFModificationTimestamp": "2026-06-09T23:53:48Z" +"ListPrice": 919900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 2 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2304.0 +"BuildingAreaTotal": 0 +"City": "Cambridge" +"PostalCode": "N3C3H7" +"UnparsedAddress": "49 ASHWOOD Drive, Cambridge, Ontario N3C3H7" +"Coordinates": array:2 [ 0 => -80.2987347 1 => 43.4243246 ] +"Latitude": 43.4243246 +"Longitude": -80.2987347 +"YearBuilt": 1984 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Stunning 2 storey detached Energy Certified home located on a premium corner lot in the heart of desirable Hespeler Village, offering over 2,300 sq ft of beautifully finished living space! This impressive carpet free family home has been extensively updated with quality upgrades throughout including newer windows and doors, upgraded insulation and venting, efficient heat pump system, newly installed hardwood flooring in the family room and upper level, plus a brand new owned water softener. Pride of ownership is evident from top to bottom. Bright and inviting main floor features a spacious separate dining room ideal for hosting family gatherings and special occasions. The updated eat-in kitchen is both stylish and functional showcasing stainless steel appliances, tiled backsplash, ample cupboard and prep space, and gorgeous new quartz countertops. Cozy family room with gas fireplace creates the perfect space to unwind and offers a walk-out to the private backyard deck for seamless indoor/outdoor living. Upper level offers 3 generous sized bedrooms including a spacious primary retreat complete with walk-in closet and private 3pc ensuite bath. Additional 4pc main bathroom provides plenty of space for the growing family. Partially finished basement extends the living space with a large rec room, fourth bedroom and convenient 2pc bathroom - ideal for guests, teenagers, home office or hobby space. Step outside to the fully fenced and professionally landscaped backyard featuring a stunning new composite deck and storage shed, perfect for summer entertaining and relaxing evenings. Attached single car garage and private 3 car driveway provide ample parking. Fantastic family friendly location close to excellent schools, parks, trails, public transit, highway access and all major amenities. Exceptional move-in ready home in one of Cambridge's most sought-after neighbourhoods. A definite must see! (id:62650)" +"Appliances": array:9 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Gas stove(s)" 4 => "Dishwasher" 5 => "Dryer" 6 => "Hood Fan" 7 => "Window Coverings" 8 => "Garage door opener" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"BathroomsPartial": 2 +"CommunityFeatures": array:2 [ 0 => "School Bus" 1 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-15T23:03:48.739176+00:00" +"Directions": "Cooper & Jamieson" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Heat Pump" 1 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1879566" +"ListOfficeKey": "294054" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Corner Site" 1 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-15T20:31:24Z" +"PhotosCount": 46 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-09T23:42:51Z" +"Stories": "2.0" +"StreetName": "ASHWOOD" +"StreetNumber": "49" +"StreetSuffix": "Drive" +"SubdivisionName": "41 - Woodland Park/Cambrian Hills" +"TaxAnnualAmount": "5432.65" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:13 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29761614/49-ashwood-drive-cambridge" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "R4" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 60.0 +"AboveGradeFinishedArea": 1842 +"BelowGradeFinishedArea": 462 +"OriginalEntryTimestamp": "2026-05-15T20:31:23.71Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"BelowGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1205653" +"ListOfficeNationalAssociationId": "1434831" +"Media": array:46 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] 44 => array:13 [ …13] 45 => array:13 [ …13] ] +"DaysOnMarket": 47 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29761614')" +"ID": "1428072" } ] +success: true +page_size: 12 +page_count: 16647 +count: 199754 +after_key: "" } "RF Response Time" => "0.3 seconds" ] ]