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=154860&$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 {#24576 +items: array:12 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24657 +post_id: "1434038" +post_author: 1 +"ListingKey": "29768403" +"ListingId": "40831156" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T16:30:21Z" +"RFModificationTimestamp": "2026-06-02T16:33:22Z" +"ListPrice": 869900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 2700.0 +"BuildingAreaTotal": 0 +"City": "Waterford" +"PostalCode": "N0E1Y0" +"UnparsedAddress": "9 PURSEL Street, Waterford, Ontario N0E1Y0" +"Coordinates": array:2 [ 0 => -80.2961517 1 => 42.9421326 ] +"Latitude": 42.9421326 +"Longitude": -80.2961517 +"YearBuilt": 2022 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Modern comfort meets small-town charm in this 2022-built bungalow nestled in the family-friendly Villages of Waterford. At the heart of the home is a designer kitchen that will impress any home chef — crisp white shaker cabinetry, quartz countertops, full-height quartz backsplash, a generous island with seating for casual meals, corner pantry, gas range, and stainless steel appliances all illuminated by pot lights and under-cabinet lighting. The open-concept main floor flows effortlessly from kitchen to dining to living room, with patio doors leading to your private backyard retreat and storage shed. Retreat to the spacious primary suite featuring a walk-in closet and beautiful ensuite with his-and-hers sinks and a large walk-in shower — your own private oasis at the end of the day. A second main-floor bedroom rounds out one-floor living, while the fully finished lower level adds a self-contained in-law suite with kitchenette and three additional bedrooms. A double-car garage, all appliances included, and a prime location within walking distance of two elementary schools and the local high school make this the lifestyle home your family has been waiting for. (id:62650)" +"Appliances": array:9 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water meter" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" 6 => "Central Vacuum - Roughed In" 7 => "Window Coverings" 8 => "Garage door opener" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CommunityFeatures": array:1 [ 0 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-19T15:07:25.341973+00:00" +"Directions": "Main Street North to Gibbons, Left on Amber, Right on Pursel to #9" +"ExteriorFeatures": array:3 [ 0 => "Brick" 1 => "Stone" 2 => "Vinyl siding" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2173239" +"ListOfficeKey": "48558" +"LivingAreaUnits": "square feet" +"LotFeatures": array:4 [ 0 => "Crushed stone driveway" 1 => "Sump Pump" 2 => "Automatic Garage Door Opener" 3 => "In-Law Suite" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-19T13:50:27Z" +"PhotosCount": 37 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:21:54Z" +"Stories": "1.0" +"StreetName": "PURSEL" +"StreetNumber": "9" +"StreetSuffix": "Street" +"SubdivisionName": "Waterford" +"TaxAnnualAmount": "5068" +"Utilities": array:4 [ 0 => "Natural Gas" 1 => "Electricity" 2 => "Cable" 3 => "Telephone" ] +"VirtualTourURLUnbranded": "https://vimeo.com/1192349760?share=copy&fl=sv&fe=ci" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:15 [ 0 => array:11 [ "RoomKey" => "1649811226" "RoomType" => "4pc Bathroom" "ListingId" => "40831156" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29768403" "RoomLength" => null "RoomDimensions" => "5'4'' x 8'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:21:54.29Z" ] 1 => array:11 [ "RoomKey" => "1649811227" "RoomType" => "Bedroom" "ListingId" => "40831156" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29768403" "RoomLength" => null "RoomDimensions" => "11'10'' x 11'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:21:54.29Z" ] 2 => array:11 [ "RoomKey" => "1649811228" "RoomType" => "Bedroom" "ListingId" => "40831156" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29768403" "RoomLength" => null "RoomDimensions" => "12'0'' x 9'10''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:21:54.29Z" ] 3 => array:11 [ "RoomKey" => "1649811229" "RoomType" => "Bedroom" "ListingId" => "40831156" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29768403" "RoomLength" => null "RoomDimensions" => "11'2'' x 11'10''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:21:54.3Z" ] 4 => array:11 [ "RoomKey" => "1649811230" "RoomType" => "Kitchen" "ListingId" => "40831156" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29768403" "RoomLength" => null "RoomDimensions" => "15'9'' x 9'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:21:54.31Z" ] 5 => array:11 [ "RoomKey" => "1649811231" "RoomType" => "Dinette" "ListingId" => "40831156" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29768403" "RoomLength" => null "RoomDimensions" => "12'0'' x 9'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:21:54.32Z" ] 6 => array:11 [ "RoomKey" => "1649811232" "RoomType" => "Family room" "ListingId" => "40831156" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29768403" "RoomLength" => null "RoomDimensions" => "16'11'' x 12'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:21:54.32Z" ] 7 => array:11 [ "RoomKey" => "1649811233" "RoomType" => "Laundry room" "ListingId" => "40831156" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29768403" "RoomLength" => null "RoomDimensions" => "6'9'' x 7'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:21:54.33Z" ] 8 => array:11 [ "RoomKey" => "1649811234" "RoomType" => "4pc Bathroom" "ListingId" => "40831156" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29768403" "RoomLength" => null "RoomDimensions" => "5'0'' x 7'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:21:54.34Z" ] 9 => array:11 [ "RoomKey" => "1649811235" "RoomType" => "Bedroom" "ListingId" => "40831156" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29768403" "RoomLength" => null "RoomDimensions" => "11'0'' x 9'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:21:54.35Z" ] 10 => array:11 [ "RoomKey" => "1649811236" "RoomType" => "Full bathroom" "ListingId" => "40831156" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29768403" "RoomLength" => null "RoomDimensions" => "5'8'' x 11'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:21:54.36Z" ] 11 => array:11 [ "RoomKey" => "1649811239" "RoomType" => "Primary Bedroom" "ListingId" => "40831156" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29768403" "RoomLength" => null "RoomDimensions" => "11'5'' x 11'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:21:54.37Z" ] 12 => array:11 [ "RoomKey" => "1649811246" "RoomType" => "Living room" "ListingId" => "40831156" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29768403" "RoomLength" => null "RoomDimensions" => "15'8'' x 9'9''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:21:54.37Z" ] 13 => array:11 [ "RoomKey" => "1649811247" "RoomType" => "Kitchen" "ListingId" => "40831156" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29768403" "RoomLength" => null "RoomDimensions" => "20'7'' x 13'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:21:54.38Z" ] 14 => array:11 [ "RoomKey" => "1649811248" "RoomType" => "Dining room" "ListingId" => "40831156" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29768403" "RoomLength" => null "RoomDimensions" => "24'1'' x 11'7''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:21:54.39Z" ] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29768403/9-pursel-street-waterford" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "1672163" +"CommonInterest": "Freehold" +"CoListOfficeKey": "48559" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "R1-B" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 3 +"FrontageLengthNumeric": 45.0 +"AboveGradeFinishedArea": 1435 +"BelowGradeFinishedArea": 1265 +"OriginalEntryTimestamp": "2026-05-19T13:50:27Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1423696" +"ListOfficeNationalAssociationId": "1004255" +"CoListAgentNationalAssociationId": "1170625" +"CoListOfficeNationalAssociationId": "1091951" +"Media": array:37 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "29768403_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/1db241f1c2c3af54f25dfeede85a0417.webp" "MediaSize" => 143193 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-1db241f1c2c3af54f25dfeede85a0417.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "29768403_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/491048932314c807e06755ec4bc69bac.webp" "MediaSize" => 106168 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-491048932314c807e06755ec4bc69bac.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "29768403_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/048f50ecb58a1a94a93858edc77e5dbb.webp" "MediaSize" => 125914 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-048f50ecb58a1a94a93858edc77e5dbb.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "29768403_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/0efcc488b369119676473c9b715f004d.webp" "MediaSize" => 57154 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-0efcc488b369119676473c9b715f004d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "29768403_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/184d177247e1c66d55c8fe583c984ffb.webp" "MediaSize" => 61723 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-184d177247e1c66d55c8fe583c984ffb.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "29768403_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/544d57404a3668d1361ddcf053a17957.webp" "MediaSize" => 90167 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-544d57404a3668d1361ddcf053a17957.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "29768403_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/b416ab1f476a4c22d405e6f24c86f2fe.webp" "MediaSize" => 80558 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-b416ab1f476a4c22d405e6f24c86f2fe.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "29768403_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/aa1e1296bbb6cb09c08068f52fcc6e29.webp" "MediaSize" => 64288 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-aa1e1296bbb6cb09c08068f52fcc6e29.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "29768403_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/3210bc12332551f49cc18adea389347e.webp" "MediaSize" => 64678 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-3210bc12332551f49cc18adea389347e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "29768403_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/c8ec0204798509965b91114a5309eac0.webp" "MediaSize" => 74537 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-c8ec0204798509965b91114a5309eac0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "29768403_4890_11" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/c37daa94cbcb674d7f4f734ba4d566a1.webp" "MediaSize" => 85277 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-c37daa94cbcb674d7f4f734ba4d566a1.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "29768403_4890_12" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/e0d0a1f2325a125369d7b9fd73d1230e.webp" "MediaSize" => 79818 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-e0d0a1f2325a125369d7b9fd73d1230e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "29768403_4890_13" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/8db08fa94d2f772f9b781ec8a2ee0167.webp" "MediaSize" => 86020 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-8db08fa94d2f772f9b781ec8a2ee0167.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 13 => array:13 [ "Order" => 14 "MediaKey" => "29768403_4890_14" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/b1c57c72dc3c15263233dec8ed5db02f.webp" "MediaSize" => 75979 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-b1c57c72dc3c15263233dec8ed5db02f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 14 => array:13 [ "Order" => 15 "MediaKey" => "29768403_4890_15" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/1ae4a52fe1e3a9c4e72b5d80c45ce5ff.webp" "MediaSize" => 78984 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-1ae4a52fe1e3a9c4e72b5d80c45ce5ff.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 15 => array:13 [ "Order" => 16 "MediaKey" => "29768403_4890_16" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/4eaaf58c2065f43a9254f40ba95b7055.webp" "MediaSize" => 91839 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-4eaaf58c2065f43a9254f40ba95b7055.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 16 => array:13 [ "Order" => 17 "MediaKey" => "29768403_4890_17" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/4f43f7636cf345ee474e4e76b46b708c.webp" "MediaSize" => 76809 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-4f43f7636cf345ee474e4e76b46b708c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 17 => array:13 [ "Order" => 18 "MediaKey" => "29768403_4890_18" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/fcec7f4e30724bc72e0f3656d13c5ee0.webp" "MediaSize" => 58556 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-fcec7f4e30724bc72e0f3656d13c5ee0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 18 => array:13 [ "Order" => 19 "MediaKey" => "29768403_4890_19" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/bcfb7895bd6fa71490c6e5690eaf0728.webp" "MediaSize" => 54556 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-bcfb7895bd6fa71490c6e5690eaf0728.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 19 => array:13 [ "Order" => 20 "MediaKey" => "29768403_4890_20" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/309b8be694047e73dbee0a9b3f4aa3a6.webp" "MediaSize" => 61793 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-309b8be694047e73dbee0a9b3f4aa3a6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 20 => array:13 [ "Order" => 21 "MediaKey" => "29768403_4890_21" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/98da988fee782eef96ceb6151c1165f5.webp" "MediaSize" => 70348 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-98da988fee782eef96ceb6151c1165f5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 21 => array:13 [ "Order" => 22 "MediaKey" => "29768403_4890_22" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/81edc4a26994c561cc3e102ec5ae83a1.webp" "MediaSize" => 62878 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-81edc4a26994c561cc3e102ec5ae83a1.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 22 => array:13 [ "Order" => 23 "MediaKey" => "29768403_4890_23" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/b8f598b68135aa57c65516a963c8391f.webp" "MediaSize" => 60127 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-b8f598b68135aa57c65516a963c8391f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 23 => array:13 [ "Order" => 24 "MediaKey" => "29768403_4890_24" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/0bde8cbf46d667f9ccb8209ce8392b2d.webp" "MediaSize" => 50616 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-0bde8cbf46d667f9ccb8209ce8392b2d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 24 => array:13 [ "Order" => 25 "MediaKey" => "29768403_4890_25" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/2472592a16aecc6e618fea1f84db1dc9.webp" "MediaSize" => 58173 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-2472592a16aecc6e618fea1f84db1dc9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 25 => array:13 [ "Order" => 26 "MediaKey" => "29768403_4890_26" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/0d29b4b4898ed4249bf1552a3610d1fb.webp" "MediaSize" => 65549 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-0d29b4b4898ed4249bf1552a3610d1fb.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 26 => array:13 [ "Order" => 27 "MediaKey" => "29768403_4890_27" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/9bcdb2616bfdde956d56fd6cb38a0984.webp" "MediaSize" => 70245 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-9bcdb2616bfdde956d56fd6cb38a0984.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 27 => array:13 [ "Order" => 28 "MediaKey" => "29768403_4890_28" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/20c403fa22de73cbdb7189309edc19c3.webp" "MediaSize" => 75815 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-20c403fa22de73cbdb7189309edc19c3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 28 => array:13 [ "Order" => 29 "MediaKey" => "29768403_4890_29" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/b15167dfeb3caa0186eb11de7ac0d3d3.webp" "MediaSize" => 68045 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-b15167dfeb3caa0186eb11de7ac0d3d3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 29 => array:13 [ "Order" => 30 "MediaKey" => "29768403_4890_30" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/88b8f21fc805ac4596870924fa61244e.webp" "MediaSize" => 83422 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-88b8f21fc805ac4596870924fa61244e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 30 => array:13 [ "Order" => 31 "MediaKey" => "29768403_4890_31" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/f3ed13b0d6e0dc28ca6ebb50884182b4.webp" "MediaSize" => 136985 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-f3ed13b0d6e0dc28ca6ebb50884182b4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 31 => array:13 [ "Order" => 32 "MediaKey" => "29768403_4890_32" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/795ef6d839eb6ecf48984d2dfe6507f2.webp" "MediaSize" => 153137 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-795ef6d839eb6ecf48984d2dfe6507f2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 32 => array:13 [ "Order" => 33 "MediaKey" => "29768403_4890_33" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768403/d3c1c16f510b1e32ea783740a5edfcec.webp" "MediaSize" => 137491 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768403/thumbnail-d3c1c16f510b1e32ea783740a5edfcec.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831156" "ResourceRecordKey" => "29768403" "ModificationTimestamp" => "2026-05-19T13:50:27.01Z" ] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] ] +"DaysOnMarket": 43 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29768403')" +"ID": "1434038" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24504 +post_id: "1459946" +post_author: 1 +"ListingKey": "29804683" +"ListingId": "40831155" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T16:30:36Z" +"RFModificationTimestamp": "2026-06-02T16:31:19Z" +"ListPrice": 989900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1612.0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L6N2" +"UnparsedAddress": "147 REIBER Court, Waterloo, Ontario N2L6N2" +"Coordinates": array:2 [ 0 => -80.5520868 1 => 43.4557802 ] +"Latitude": 43.4557802 +"Longitude": -80.5520868 +"YearBuilt": 2002 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Nestled on a quiet, private court in Waterloo's sought-after Beechwood neighbourhood, this beautifully maintained brick bungaloft offers the perfect blend of comfort, style, and everyday functionality. The meticulously landscaped front gardens — bursting with colour and mature plantings — and covered front porch create instant curb appeal that sets this home apart. Step inside to a thoughtfully designed main floor featuring soaring 9' ceilings across 1,612 square feet above grade, rich hardwood flooring and a gas fireplace in the great room, elegant crown moulding in the dining room, and California shutters throughout. The stunning renovated kitchen (2020) features crisp white cabinetry, granite countertops, a classic subway tile backsplash, stainless steel appliances, and a bright eat-in area with bay window — a true chef's delight..... Step inside the dining room perfect for hosting or a home office setup. The primary bedroom and a well appointed full bathroom complete the main level, while the loft provides a private second bedroom with its own full bathroom and hardwood flooring. The fully finished basement adds a spacious recreation room, flexible third bedroom or office/den, a third full bathroom, and generous storage. Outside, the fully fenced backyard is an absolute showstopper — lush perennial gardens, mature trees, and vibrant florals frame a composite deck topped with a stunning pergola, the perfect setting for outdoor entertaining or peaceful relaxation. The double car garage and beautifully maintained exterior complete with concrete driveway & entrance round out this exceptional package. Minutes from The Boardwalk shopping, transit, top-rated schools, both Universities, Westmount Golf & Country Club, and scenic walking trails — 147 Reiber Court is a rare Beechwood gem not to be missed. (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CommunityFeatures": array:3 [ 0 => "Quiet Area" 1 => "School Bus" 2 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-26T14:12:31.353317+00:00" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2016330" +"ListOfficeKey": "283168" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Cul-de-sac" 1 => "Corner Site" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-26T13:32:35Z" +"PhotosCount": 42 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:21:54Z" +"Stories": "1.5" +"StreetName": "REIBER" +"StreetNumber": "147" +"StreetSuffix": "Court" +"SubdivisionName": "417 - Beechwood/University" +"TaxAnnualAmount": "6199" +"VirtualTourURLUnbranded": "https://youriguide.com/147_reiber_ct_waterloo_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/29804683/147-reiber-court-waterloo" +"ParkingTotal": 6 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R2" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 54.0 +"AboveGradeFinishedArea": 1612 +"OriginalEntryTimestamp": "2026-05-26T13:31:35.63Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1297578" +"ListOfficeNationalAssociationId": "1325206" +"Media": array:42 [ 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] ] +"DaysOnMarket": 36 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29804683')" +"ID": "1459946" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24645 +post_id: "1448776" +post_author: 1 +"ListingKey": "29788866" +"ListingId": "40831154" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-03T12:46:20Z" +"RFModificationTimestamp": "2026-06-03T12:51:19Z" +"ListPrice": 724900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 1830.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8T2W9" +"UnparsedAddress": "46 BEACONSFIELD Drive, Hamilton, Ontario L8T2W9" +"Coordinates": array:2 [ 0 => -79.8350593 1 => 43.2136111 ] +"Latitude": 43.2136111 +"Longitude": -79.8350593 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to this exceptional income-generating property nestled in one of Hamilton's most sought-after East Mountain neighbourhoods. This fully tenanted duplex delivers $4,290/month in gross rental income from day one — no renovations, no vacancy headaches, just returns. Sitting on a 50 x 100 ft lot, this property offers a generous footprint in a high-demand rental corridor. Main Floor Unit features a spacious 3-bedroom, 1-bathroom layout with comfortable living spaces and a floor plan that tenants love. Lower Unit mirrors the main floor with its own self-contained 3-bedroom, 1-bathroom configuration — maximizing your rental income potential under one roof. Both units are leased at market rents to reliable tenants, and the property includes 2 private driveway parking spots — a premium feature renters in this area consistently look for. This is a true turnkey acquisition with all the heavy lifting already done. The East Mountain location offers easy access to major commuter routes, transit, schools, shopping, and amenities — a perennial favourite for renters and a proven area for long-term appreciation. (id:62650)" +"Appliances": array:5 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-22T15:45:15.153102+00:00" +"Directions": "UPPER OTTAWA, TO LORRAINE DRIVE" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2046407" +"ListOfficeKey": "282362" +"LivingAreaUnits": "square feet" +"PhotosChangeTimestamp": "2026-05-22T11:51:40Z" +"PhotosCount": 34 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-03T11:50:54Z" +"Stories": "1.0" +"StreetName": "BEACONSFIELD" +"StreetNumber": "46" +"StreetSuffix": "Drive" +"SubdivisionName": "260 - Berrisfield" +"TaxAnnualAmount": "4835.75" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:12 [ 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] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29788866/46-beaconsfield-drive-hamilton" +"ParkingTotal": 3 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R1" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 3 +"FrontageLengthNumeric": 50.0 +"AboveGradeFinishedArea": 915 +"BelowGradeFinishedArea": 915 +"OriginalEntryTimestamp": "2026-05-22T11:51:40.63Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Owner" +"BelowGradeFinishedAreaSource": "Owner" +"ListAgentNationalAssociationId": "1321830" +"ListOfficeNationalAssociationId": "1320359" +"Media": array:34 [ 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] ] +"DaysOnMarket": 41 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29788866')" +"ID": "1448776" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24530 +post_id: "1455838" +post_author: 1 +"ListingKey": "29775107" +"ListingId": "40831153" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-20T20:40:06Z" +"RFModificationTimestamp": "2026-06-20T20:46:42Z" +"ListPrice": 1299999.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 2 +"BedroomsTotal": 4.0 +"LotSizeArea": 1.46 +"LivingArea": 2640.0 +"BuildingAreaTotal": 0 +"City": "Grassie" +"PostalCode": "L0R1M0" +"UnparsedAddress": "3568 SOUTH GRIMSBY RD 12 Road, Grassie, Ontario L0R1M0" +"Coordinates": array:2 [ 0 => -79.6063714 1 => 43.1528563 ] +"Latitude": 43.1528563 +"Longitude": -79.6063714 +"YearBuilt": 1990 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to your own private country retreat! Nestled on approximately 1.5 acres, this custom Cape Cod-inspired home offers the perfect blend of space, comfort, and lifestyle. Featuring over 2,600 sq ft above grade, this well-maintained home boasts 4 spacious bedrooms, 4 bathrooms, and an ideal family-friendly layout. The main level offers a bright eat-in kitchen, formal dining room, oversized living room, cozy family room with fireplace, convenient main floor laundry, and inside access to the attached double car garage. Upstairs you’ll find generous bedrooms including a large primary suite, additional full bath, and a massive bonus bedroom/living space with another bathroom perfect for guests, a games room, home office, or teen retreat. The unfinished basement provides endless potential for future living space, storage, or an in-law setup. Step outside and enjoy the incredible grounds featuring a stunning stocked pond approximately 60 ft x 130 ft, expansive green space, mature landscaping, and endless room to entertain, relax, or enjoy the outdoors. A rare opportunity to own a beautifully maintained country property with executive home appeal and resort-style surroundings. Perfect for families, hobbyists, outdoor enthusiasts, or anyone seeking privacy and space just outside the city. Located close to churches, schools and just minutes from Grimsby this location can't be beat! (id:62650)" +"Appliances": array:8 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Hood Fan" 6 => "Window Coverings" 7 => "Garage door opener" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"BathroomsPartial": 2 +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-20T18:12:17.526558+00:00" +"Directions": "Mud St to South Grimsby Road 12" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2082579" +"ListOfficeKey": "275238" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Paved driveway" 1 => "Country residential" 2 => "Automatic Garage Door Opener" ] +"LotSizeDimensions": "1.46" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-20T13:01:44Z" +"PhotosCount": 50 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-20T20:34:32Z" +"Stories": "2.0" +"StreetName": "SOUTH GRIMSBY RD 12" +"StreetNumber": "3568" +"StreetSuffix": "Road" +"SubdivisionName": "056 - West Lincoln" +"TaxAnnualAmount": "6941.1" +"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/363676" +"WaterSource": array:1 [ 0 => "Cistern" ] +"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/29775107/3568-south-grimsby-rd-12-road-grassie" +"ParkingTotal": 12 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 150.0 +"AboveGradeFinishedArea": 2640 +"OriginalEntryTimestamp": "2026-05-20T13:01:19.93Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1357288" +"ListOfficeNationalAssociationId": "1263001" +"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": 43 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29775107')" +"ID": "1455838" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24525 +post_id: "1464351" +post_author: 1 +"ListingKey": "29811547" +"ListingId": "40831151" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-29T13:20:17Z" +"RFModificationTimestamp": "2026-06-29T13:45:20Z" +"ListPrice": 574900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1573.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8H2G3" +"UnparsedAddress": "196 CAMPBELL Avenue, Hamilton, Ontario L8H2G3" +"Coordinates": array:2 [ 0 => -79.8125096 1 => 43.2484303 ] +"Latitude": 43.2484303 +"Longitude": -79.8125096 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 196 Campbell Avenue, a thoughtfully updated home in Hamilton’s vibrant Crown Point neighbourhood. The main floor features an updated kitchen complete with quartz countertops, flowing seamlessly into the open-concept living and dining area, while main floor laundry adds everyday convenience. Recent improvements include newly completed exterior siding that gives the home fresh curb appeal, along with a replaced lead water service line for added peace of mind. The finished basement offers excellent flexibility with a spacious rec room, additional bedroom, and bathroom, while the separate side entrance and previous kitchen rough-ins leave open the potential for in-law or extended family living. Outside, enjoy a private backyard space perfect for relaxing, gardening, or summer evenings with friends and family. Whether you’re looking for your first home, additional space for a growing family, or a move-in ready property in one of Hamilton’s continually growing communities, this home checks all the right boxes. (id:62650)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Window Coverings" 6 => "Microwave Built-in" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-27T16:58:56.975818+00:00" +"Directions": "OTTAWA/CAMPBELL" +"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": "2064793" +"ListOfficeKey": "275238" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Ravine" ] +"PhotosChangeTimestamp": "2026-05-27T15:32:58Z" +"PhotosCount": 42 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-29T13:11:49Z" +"Stories": "2.0" +"StreetName": "CAMPBELL" +"StreetNumber": "196" +"StreetSuffix": "Avenue" +"SubdivisionName": "201 - Crown Point" +"TaxAnnualAmount": "3114" +"VirtualTourURLUnbranded": "https://northernmediagroup.hd.pics/196-Campbell-Ave" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:11 [ 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] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29811547/196-campbell-avenue-hamilton" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "D" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 25.0 +"AboveGradeFinishedArea": 1125 +"BelowGradeFinishedArea": 448 +"OriginalEntryTimestamp": "2026-05-27T15:32:58.38Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Assessor" +"BelowGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1339843" +"ListOfficeNationalAssociationId": "1263001" +"Media": array:42 [ 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] ] +"DaysOnMarket": 35 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29811547')" +"ID": "1464351" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24641 +post_id: "1452795" +post_author: 1 +"ListingKey": "29795182" +"ListingId": "40831150" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-05T15:40:52Z" +"RFModificationTimestamp": "2026-06-05T15:48:39Z" +"ListPrice": 1779000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0.46 +"LivingArea": 4549.0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2J2C8" +"UnparsedAddress": "57 MARGARET Avenue S, Waterloo, Ontario N2J2C8" +"Coordinates": array:2 [ 0 => -80.5019551 1 => 43.4689745 ] +"Latitude": 43.4689745 +"Longitude": -80.5019551 +"YearBuilt": 1954 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Fantastic opportunity to live in one of the most sought-after neighbourhoods in all of Kitchener-Waterloo! Situated on a private lot just under half an acre in the heart of the city, this exceptional custom-built home showcases quality craftsmanship and thoughtful design throughout its more than 4,500 sq. ft. of finished living space. Featuring 6 bedrooms and 5 bathrooms, every detail has been carefully curated to offer both luxury and functionality. Completely renovated and redesigned in 2012, the home was extensively updated from top to bottom, including the addition of a triple-car garage and a fully self-contained 2-bedroom, 2-bathroom accessory apartment. Expansive living spaces include a stunning living room addition, a spacious primary retreat with a walk-in closet and luxurious 6-piece en-suite, as well as a fully finished basement offering additional living and entertaining space. Additional highlights include heated bathroom floors, huge games room with pool table above the garage, hardwood flooring throughout the main level, and parking for up to 11 vehicles. The mature, private, fully fenced backyard features an inground sprinkler system and provides the perfect setting for entertaining, relaxing, and enjoying the tranquility of nature — all while being centrally located close to every amenity. (id:62650)" +"Appliances": array:9 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Dishwasher" 4 => "Stove" 5 => "Central Vacuum - Roughed In" 6 => "Hood Fan" 7 => "Window Coverings" 8 => "Garage door opener" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Partial" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-23T04:48:58.549748+00:00" +"Directions": "Erb St E (one way going east) to Margaret Ave S" +"ExteriorFeatures": array:2 [ 0 => "Stucco" 1 => "Brick Veneer" ] +"Fencing": array:1 [ 0 => "Fence" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:3 [ 0 => "Forced air" 1 => "In Floor Heating" 2 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1563561" +"ListOfficeKey": "77518" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Paved driveway" 1 => "Sump Pump" 2 => "In-Law Suite" ] +"LotSizeDimensions": "0.46" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-29T15:01:29Z" +"PhotosCount": 39 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-05T15:33:43Z" +"Stories": "2.0" +"StreetDirSuffix": "South" +"StreetName": "MARGARET" +"StreetNumber": "57" +"StreetSuffix": "Avenue" +"SubdivisionName": "114 - Uptown Waterloo/North Ward" +"TaxAnnualAmount": "6179" +"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/57-Margaret-Ave-S" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:22 [ 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] 19 => array:11 [ …11] 20 => array:11 [ …11] 21 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29795182/57-margaret-avenue-s-waterloo" +"ParkingTotal": 11 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "SR2" +"BedroomsAboveGrade": 5 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 75.0 +"AboveGradeFinishedArea": 3696 +"BelowGradeFinishedArea": 853 +"OriginalEntryTimestamp": "2026-05-23T01:39:28.8Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"BelowGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1123355" +"ListOfficeNationalAssociationId": "1186916" +"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": 40 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29795182')" +"ID": "1452795" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24640 +post_id: "1433994" +post_author: 1 +"ListingKey": "29767911" +"ListingId": "40831149" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-17T14:00:05Z" +"RFModificationTimestamp": "2026-06-17T14:04:59Z" +"ListPrice": 549800.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1703.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8H5T8" +"UnparsedAddress": "156 ADELINE Avenue, Hamilton, Ontario L8H5T8" +"Coordinates": array:2 [ 0 => -79.7918871 1 => 43.2411152 ] +"Latitude": 43.2411152 +"Longitude": -79.7918871 +"YearBuilt": 1947 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 156 Adeline Avenue! This three bedroom, two bathroom home has been recently updated with new flooring, new kitchen, fresh paint and trim!! Roof (2012), Furnace (2010), AC (2020). Move in ready property! The home is located in Hamilton East, excellent access to Red Hill and QEW! The home has lots of parking and a detached garage for hobbies, storage or car collector! Call me today to view the property! (id:62650)" +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-19T15:07:50.942445+00:00" +"Directions": "Parkdale Avenue to Roxborough Avenue to Adeline Ave" +"ExteriorFeatures": array:1 [ 0 => "Aluminum siding" ] +"FireplaceFeatures": array:2 [ 0 => "Wood" 1 => "Stove" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1917243" +"ListOfficeKey": "264845" +"LivingAreaUnits": "square feet" +"ParkingFeatures": array:1 [ 0 => "Detached Garage" ] +"PhotosChangeTimestamp": "2026-06-17T13:52:00Z" +"PhotosCount": 29 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-17T13:52:00Z" +"Stories": "1.5" +"StreetName": "ADELINE" +"StreetNumber": "156" +"StreetSuffix": "Avenue" +"SubdivisionName": "232 - Normanhurst" +"TaxAnnualAmount": "3419" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:11 [ 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] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29767911/156-adeline-avenue-hamilton" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "None" ] +"ZoningDescription": "R1" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 30.0 +"AboveGradeFinishedArea": 1303 +"BelowGradeFinishedArea": 400 +"OriginalEntryTimestamp": "2026-05-19T11:49:22.35Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Assessor" +"BelowGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1225588" +"ListOfficeNationalAssociationId": "1225289" +"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": 44 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29767911')" +"ID": "1433994" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25068 +post_id: "1437796" +post_author: 1 +"ListingKey": "29773891" +"ListingId": "40831145" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-10T20:00:07Z" +"RFModificationTimestamp": "2026-06-10T20:15:38Z" +"ListPrice": 2299900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 10.102 +"LivingArea": 4536.0 +"BuildingAreaTotal": 0 +"City": "Puslinch" +"PostalCode": "N0B2J0" +"UnparsedAddress": "2092 HIGHWAY 6, Puslinch, Ontario N0B2J0" +"Coordinates": array:2 [ 0 => -80.0593779 1 => 43.4165618 ] +"Latitude": 43.4165618 +"Longitude": -80.0593779 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Set on over 10 acres of ultra-private land in sought-after Flamborough, this exceptional country estate offers a rare blend of luxury, lifestyle, and functionality. Thoughtfully updated throughout, the 4-bedroom, 4-bathroom home delivers the kind of space, finish level, and versatility that is increasingly difficult to find. The main level is anchored by a dramatic family room with soaring cathedral ceilings, oversized windows, and a striking feature fireplace wall that creates an immediate sense of scale and warmth. Durable wood-look tile flooring runs throughout, while the chef-inspired kitchen features Cabico cabinetry, dovetail drawers, Cambria quartz countertops, and an oversized island designed for gathering and entertaining. A bright four-season sunroom with hot tub access overlooks the peaceful surrounding landscape and opens onto multiple outdoor seating areas and raised gardens. Upstairs, the open-to-below den with skylights adds to the home’s airy, connected feel. The spacious primary suite includes a custom walk-in closet and spa-inspired ensuite with oversized double shower and dual vanity, while three additional bedrooms and a full bathroom complete the upper level. The finished lower level was designed with entertaining in mind, offering an oversized rec room with wet bar and island seating, media room, wine cellar, and full bathroom. A true standout feature is the newly built 40’ x 54’ heated shop (2023) with hydro and high-speed internet — ideal for entrepreneurs, hobbyists, collectors, or recreational use. Additional highlights include a heated attached garage, furnace and heat pump(A/C) updates (2022), a 60-amp EV connection(at the shop), and participation in the CLTP program for valuable property tax savings. A truly spectacular offering combining privacy, modern comfort, and elevated country living — all within easy reach of the city. (id:62650)" +"Appliances": array:9 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Hot Tub" 3 => "Dishwasher" 4 => "Dryer" 5 => "Microwave" 6 => "Wet Bar" 7 => "Window Coverings" 8 => "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-20T00:53:06.761981+00:00" +"Directions": "On HWY 6 between Mountsberg Rd & Campbellville Rd" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:2 [ 0 => "Heat Pump" 1 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2239450" +"ListOfficeKey": "299790" +"LivingAreaUnits": "square feet" +"LotFeatures": array:4 [ 0 => "Wet bar" 1 => "Country residential" 2 => "Automatic Garage Door Opener" 3 => "Private Yard" ] +"LotSizeDimensions": "10.102" +"NumberOfUnitsTotal": "1" +"ParkingFeatures": array:2 [ 0 => "Attached Garage" 1 => "Detached Garage" ] +"PhotosChangeTimestamp": "2026-05-20T15:33:50Z" +"PhotosCount": 50 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-10T19:51:44Z" +"Stories": "2.0" +"StreetName": "HIGHWAY 6" +"StreetNumber": "2092" +"SubdivisionName": "044 - Flamborough East" +"TaxAnnualAmount": "8164" +"VirtualTourURLUnbranded": "https://2092-hwy-6-flamborough.netlify.app/#top" +"WaterSource": array:1 [ 0 => "Drilled Well" ] +"Rooms": array:20 [ 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] 19 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29773891/2092-highway-6-puslinch" +"ParkingTotal": 26 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "2050273" +"CommonInterest": "Freehold" +"CoListOfficeKey": "299790" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Security system" ] +"ZoningDescription": "P7, P8" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 0 +"AboveGradeFinishedArea": 3258 +"BelowGradeFinishedArea": 1278 +"OriginalEntryTimestamp": "2026-05-19T23:49:32.64Z" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"BelowGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1477386" +"ListOfficeNationalAssociationId": "1476846" +"CoListAgentNationalAssociationId": "1325722" +"CoListOfficeNationalAssociationId": "1476846" +"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": 43 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29773891')" +"ID": "1437796" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24534 +post_id: "1433754" +post_author: 1 +"ListingKey": "29768540" +"ListingId": "40831144" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-23T04:50:04Z" +"RFModificationTimestamp": "2026-06-23T04:53:25Z" +"ListPrice": 560000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1250.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8P4J6" +"UnparsedAddress": "47 NEW Street Unit# 2, Hamilton, Ontario L8P4J6" +"Coordinates": array:2 [ 0 => -79.8872812 1 => 43.2605712 ] +"Latitude": 43.2605712 +"Longitude": -79.8872812 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Beautifully renovated, quaint home in Hamilton’s sought-after West End blending modern functionality with warm, comfortable design. Ideally located just seconds from Highway 403 access and within walking distance to grocery shopping, Locke Street, Hess Village, and Downtown Hamilton, this move-in ready property offers the perfect balance of convenience and lifestyle. The bright open-concept main floor features a modern kitchen complete with oversized island seating, concrete countertops, stainless steel appliances and updated lighting that flows beautifully into the spacious living area and family room. Main level laundry adds everyday practicality, while functional basement storage areas maximize usability throughout the home. Upstairs, the home offers two large bedrooms and an updated bathroom with a cohesive aesthetic that feels elevated yet comfortable. Major building components including the roof, windows, A/C, electrical, and plumbing have all been updated within the last 10 years, providing peace of mind for future owners. Outside, the private maintenance-free backyard is a true urban retreat featuring multiple seating areas, covered shed space, string lighting, and rare driveway parking. This turnkey West Hamilton home offering style, function, and location in one complete package (id:62783)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water meter" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Partial" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-19T14:41:44.074325+00:00" +"ExteriorFeatures": array:1 [ 0 => "Vinyl siding" ] +"FoundationDetails": array:1 [ 0 => "Stone" ] +"Heating": array:3 [ 0 => "Hot water radiator heat" 1 => "Forced air" 2 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1524139" +"ListOfficeKey": "91227" +"LivingAreaUnits": "square feet" +"PhotosChangeTimestamp": "2026-06-23T04:23:03Z" +"PhotosCount": 23 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-23T04:33:12Z" +"Stories": "2.0" +"StreetName": "NEW" +"StreetNumber": "47" +"StreetSuffix": "Street" +"SubdivisionName": "103 - Strathcona South" +"TaxAnnualAmount": "4600" +"Utilities": array:2 [ 0 => "Natural Gas" 1 => "Electricity" ] +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:9 [ 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] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29768540/47-new-street-hamilton" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "D" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 25.0 +"AboveGradeFinishedArea": 1250 +"OriginalEntryTimestamp": "2026-05-19T14:11:06.83Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Owner" +"ListAgentNationalAssociationId": "1063186" +"ListOfficeNationalAssociationId": "1155187" +"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": 43 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29768540')" +"ID": "1433754" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24575 +post_id: "1440278" +post_author: 1 +"ListingKey": "29776951" +"ListingId": "40831136" +"PropertyType": "Residential Income" +"PropertySubType": "Multi-family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T16:30:28Z" +"RFModificationTimestamp": "2026-06-02T16:32:30Z" +"ListPrice": 1199000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 12.0 +"LotSizeArea": 0 +"LivingArea": 1047.0 +"BuildingAreaTotal": 0 +"City": "Listowel" +"PostalCode": "N4W1X2" +"UnparsedAddress": "180 UNION Street W, Listowel, Ontario N4W1X2" +"Coordinates": array:2 [ 0 => -80.9561993 1 => 43.7290717 ] +"Latitude": 43.7290717 +"Longitude": -80.9561993 +"YearBuilt": 2015 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Attention Investors and Multi-Family Buyers! Rare opportunity to own a modern 4-plex in the heart of Listowel featuring four spacious 3-bedroom, 1-bathroom units, each with in-suite laundry and separate hydro and gas meters. Built in 2015, this 11-year-old building has been exceptionally maintained and offers a strong gross annual income of $66,420 with potential for much more. . Perfect for investors or an owner-occupier seeking a multi-family residence, this property provides flexibility to live in one unit while housing extended family or generating steady rental income. Each unit features bright, open living spaces with laminate flooring throughout, modern kitchens equipped with a refrigerator, stove, dishwasher, and over-the-range microwave, as well as a mechanical/storage room for added convenience. The main floor units provide all one-level living and include a private terrace by the entrance—ideal for barbecues or relaxing outdoors. Each unit has its own dedicated parking space, and the property is pet-friendly, located in a quiet, family-oriented neighborhood close to downtown Listowel, Listowel Memorial Hospital, and nearby green space. With newer construction, separate utilities, and low maintenance costs, this property offers an exceptional blend of comfort, flexibility, and income potential—making it ideal for both investors and those seeking a multi-generational living opportunity in a thriving community. Don’t miss out on this solid investment with endless possibilities. (id:62650)" +"Basement": array:1 [ 0 => "None" ] +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-20T19:46:52.738924+00:00" +"Directions": "Take Elma St E and Wallace Ave S to Union St W" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2110923" +"ListOfficeKey": "86262" +"LivingAreaUnits": "square feet" +"ParkingFeatures": array:1 [ 0 => "Open" ] +"PhotosChangeTimestamp": "2026-05-20T16:41:08Z" +"PhotosCount": 25 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:22:00Z" +"Stories": "2.0" +"StreetDirSuffix": "West" +"StreetName": "UNION" +"StreetNumber": "180" +"StreetSuffix": "Street" +"SubdivisionName": "32 - Listowel" +"TaxAnnualAmount": "8092" +"VirtualTourURLUnbranded": "https://youriguide.com/d_180_union_st_w_listowel_on/" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29776951/180-union-street-w-listowel" +"ParkingTotal": 6 +"StructureType": array:1 [ 0 => "Fourplex" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R4" +"FrontageLengthNumeric": 82.0 +"AboveGradeFinishedArea": 1047 +"OriginalEntryTimestamp": "2026-05-20T16:41:08.88Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1379465" +"ListOfficeNationalAssociationId": "1004415" +"Media": array:25 [ 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] ] +"DaysOnMarket": 42 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29776951')" +"ID": "1440278" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24526 +post_id: "1433534" +post_author: 1 +"ListingKey": "29767465" +"ListingId": "40831120" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-16T14:20:05Z" +"RFModificationTimestamp": "2026-06-16T14:24:22Z" +"ListPrice": 389900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0.968 +"LivingArea": 2585.0 +"BuildingAreaTotal": 0 +"City": "Dunnville" +"PostalCode": "N1A2W8" +"UnparsedAddress": "6219 RAINHAM Road, Dunnville, Ontario N1A2W8" +"Coordinates": array:2 [ 0 => -79.7235816 1 => 42.8727177 ] +"Latitude": 42.8727177 +"Longitude": -79.7235816 +"YearBuilt": 1860 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "OPPORTUNITY KNOCKS!!! Rural Hamlet property not far away from Dunnville Central and the Lake on the way to Selkirk and Port Dover on historic Regional Road #3/Rainham Rd. Original 1860 portion of home has at least triple brick walls. Main floor plan is over 2,000 sqft with 2 bedrooms, 1.5 bathes, 2 Family rooms, Dining Room and full Kitchen. 2nd level has 3 bedrooms and it seems there is development potential in the attic area to get a 2nd level bathroom with middle plan den existing already. Original house corners South Cayuga Rd. Check out the AI improved property pictures for what this home could become in the great neighbourhood of historic homes and modern builds. The immense side yard is the prize...you want that big side yard, great!!!....but the potential is in reach for the east portion of this property to be severed and a new lot is created with great value to an owner. Build your own new home on the new lot and rent the original home....perfect for income potential or future family 2nd residence home. Possibilities are endless for future prosperity. An amazing opportunity to obtain a property with extremely large financial upside. GREAT AREA, GREAT SCHOOLS, GREAT PEOPLE IN HALDIMAND AND CLOSE TO THAT COOL LAKE ERIE LAKE LIFE!!! AI photos used and attic space not in sqft. (id:62783)" +"Basement": array:2 [ 0 => "Unfinished" 1 => "Partial" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "School Bus" ] +"Cooling": array:1 [ 0 => "None" ] +"CreationDate": "2026-05-19T00:45:39.248260+00:00" +"Directions": "From Dunnville Main St., W on the bridge, becomes Rainham Rd." +"ExteriorFeatures": array:2 [ 0 => "Vinyl siding" 1 => "Brick Veneer" ] +"FoundationDetails": array:1 [ 0 => "Stone" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1559466" +"ListOfficeKey": "280713" +"LivingAreaUnits": "square feet" +"LotFeatures": array:6 [ 0 => "Southern exposure" 1 => "Corner Site" 2 => "Paved driveway" 3 => "Country residential" 4 => "Sump Pump" 5 => "Private Yard" ] +"LotSizeDimensions": "0.968" +"PhotosChangeTimestamp": "2026-06-16T14:12:04Z" +"PhotosCount": 47 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-16T14:12:04Z" +"Stories": "2.0" +"StreetName": "RAINHAM" +"StreetNumber": "6219" +"StreetSuffix": "Road" +"SubdivisionName": "603 - Sherbrooke" +"TaxAnnualAmount": "2651.47" +"Utilities": array:3 [ 0 => "Natural Gas" 1 => "Electricity" 2 => "Telephone" ] +"VirtualTourURLUnbranded": "https://roomvu.sfo2.digitaloceanspaces.com/video-listing/2026/5/270c4e115dba3fef409a6f842557c184y15nyjaq.mp4" +"WaterSource": array:1 [ 0 => "Cistern" ] +"Rooms": array:18 [ 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] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29767465/6219-rainham-road-dunnville" +"ParkingTotal": 5 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "RH" +"BedroomsAboveGrade": 5 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 208.0 +"AboveGradeFinishedArea": 2585 +"BelowGradeFinishedArea": 0 +"OriginalEntryTimestamp": "2026-05-18T23:01:23.85Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"BelowGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1146566" +"ListOfficeNationalAssociationId": "1318170" +"Media": array:47 [ 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] ] +"DaysOnMarket": 44 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29767465')" +"ID": "1433534" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24532 +post_id: "1443974" +post_author: 1 +"ListingKey": "29783283" +"ListingId": "40831118" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-05T17:00:40Z" +"RFModificationTimestamp": "2026-06-05T17:04:33Z" +"ListPrice": 1178000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 2369.0 +"BuildingAreaTotal": 0 +"City": "Oakville" +"PostalCode": "L6H5K9" +"UnparsedAddress": "1115 AVONDALE Drive, Oakville, Ontario L6H5K9" +"Coordinates": array:2 [ 0 => -79.6968594 1 => 43.4878411 ] +"Latitude": 43.4878411 +"Longitude": -79.6968594 +"YearBuilt": 1988 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to this specious well maintained Freehold townhome located in sought after Wedgewood Creek Neighbourhood. This home features, specious foyer, Eat-In kitchen with loads of cupboards and plenty of counter space. Main level offers a bright living room, additional intended dining space with walkout to private backyard, powder room. Located on a half level above the garage is a large sunny family room with a fireplace, built in cabinets and desk space. Upstairs you will find 3 good size bedrooms and two full bathrooms. Primary bedroom with 4pc ensuite, has added insulation w. QuietRock Drywall on joining wall for improved sound isolation, Triple-glazed window with exceptional thermal insulation/outside sound reduction. The finished lower level with porcelain tiles has dual zone Nuheat radiant floor heating in rec area providing enjoyable atmosphere. Perfect recreation space, built in TV entertainment w. Sound dampened wall, extra Home-Office, built in cabinets with ample storage. Located on this level is laundry room, cold room, multiple storage spaces all with shelves for storing extra items. Parking for 3 cars, double wide driveway, 1.5 garage with insulated garage doors w. door opener and WITH ACCESS TO BACKYARD, custom shelves, plenty of storage space. Backyard is fully fenced with a patio, gazebo, garden lighting, mature plants and water fountain. Upgrades: Main floor hardwood floors, Kiesel’s self-leveling subfloor cement under tile on main level, stone entrance, custom cedar porch soffit with pot lights, smooth ceilings throughout, crown moldings, pot lights, upgraded electrical fixtures/plates/dimmers/timers, window blinds, central vacuum, backyard lighting with programmable timer, updated windows, roof 2018; furnace 2022; AC & water heater 2025. Walking distance to top-rated Iroquois Ridge High School, dog park, baseball diamonds & soccer fields, grocery stores, shops & restaurants; Easy access to Major Highways 403, 407 & QEW. A must see! (id:62650)" +"Appliances": array:10 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water meter" 3 => "Central Vacuum" 4 => "Dishwasher" 5 => "Stove" 6 => "Dryer" 7 => "Window Coverings" 8 => "Garage door opener" 9 => "Microwave Built-in" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-21T16:53:27.548839+00:00" +"ExteriorFeatures": array:2 [ 0 => "Concrete" 1 => "Brick" ] +"FireplaceFeatures": array:2 [ 0 => "Wood" 1 => "Other - See remarks" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1523666" +"ListOfficeKey": "103841" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Paved driveway" 1 => "Automatic Garage Door Opener" 2 => "Private Yard" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-21T22:40:57Z" +"PhotosCount": 41 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-05T16:52:01Z" +"Stories": "2.0" +"StreetName": "AVONDALE" +"StreetNumber": "1115" +"StreetSuffix": "Drive" +"SubdivisionName": "1018 - WC Wedgewood Creek" +"TaxAnnualAmount": "4357" +"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/29783283/1115-avondale-drive-oakville" +"ParkingTotal": 3 +"StructureType": array:1 [ 0 => "Row / Townhouse" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "RM1" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 23.0 +"AboveGradeFinishedArea": 1794 +"BelowGradeFinishedArea": 575 +"OriginalEntryTimestamp": "2026-05-21T15:32:08.6Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1132512" +"ListOfficeNationalAssociationId": "1165450" +"Media": array:41 [ 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] ] +"DaysOnMarket": 41 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29783283')" +"ID": "1443974" } ] +success: true +page_size: 12 +page_count: 16651 +count: 199803 +after_key: "" } "RF Response Time" => "0.19 seconds" ] ]