array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29789956 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23410
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23412
+post_id: "1449735"
+post_author: 1
+"ListingKey": "29789956"
+"ListingId": "40827298"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-07T20:31:00Z"
+"RFModificationTimestamp": "2026-06-07T20:42:35Z"
+"ListPrice": 579900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.19
+"LivingArea": 1729.0
+"BuildingAreaTotal": 0
+"City": "Waterford"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "168 MONTCLAIR Crescent, Waterford, Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.2842474
1 => 42.9310667
]
+"Latitude": 42.9310667
+"Longitude": -80.2842474
+"YearBuilt": 1960
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
+"PublicRemarks": "Welcome to 168 Montclair Circle in Waterford, ideally located in town and backing directly onto Waterford Public School. This immaculate brick bungalow with an attached oversized single-car garage offers 3 main-floor bedrooms and 2 full bathrooms, combining comfort, functionality, and thoughtful updates throughout. Perfect for hosting family and friends, the home features ample street parking along with a double-wide concrete and paved driveway, while the spacious garage provides an excellent workspace for hobbyists. Inside, you’ll find gleaming hardwood floors, a bright open-concept kitchen and living area ideal for entertaining, and a large finished basement rec room highlighted by a cozy gas fireplace set against a striking brick feature wall. Extensive recent upgrades include a new furnace and A/C (2024/25), leaf and gutter guards on the eavestroughs (2025), updated lighting throughout the home and garage (2024), a fully renovated 3-piece basement bathroom (2025), new doors in the rec room, laundry room, and basement bath (2025), blackout blinds in the primary bedroom, kitchen, and bathroom (2024), a new kitchen island and pantry (2024), new wood fencing in the backyard (2024), fresh front landscaping with a beach-stone rock bed (2025), a poured concrete pad/deck (2023), gas fireplace (2019), new washer, dryer, and range hood (2024), and the entire home professionally painted in 2024. Simply move in and enjoy this beautifully maintained home. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-22T15:23:33.059868+00:00"
+"Directions": "Thompson Road East, Waterford to Duncombe Road. Turn north. Pass the first access to Montclair Cres on left, continuing north to the second access point. Turn west onto Montclair Cres., property on north side of road."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1964570"
+"ListOfficeKey": "289711"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.19"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-05-22T21:56:04Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-07T20:24:45Z"
+"Stories": "1.0"
+"StreetName": "MONTCLAIR"
+"StreetNumber": "168"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "Waterford"
+"TaxAnnualAmount": "3478"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/dgwrbvvvlz0"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [
"RoomKey" => "1654421519"
"RoomType" => "Utility room"
"ListingId" => "40827298"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29789956"
"RoomLength" => null
"RoomDimensions" => "3'1'' x 5'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-07T20:24:45.96Z"
]
1 => array:11 [
"RoomKey" => "1654421520"
"RoomType" => "3pc Bathroom"
"ListingId" => "40827298"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29789956"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 5'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-07T20:24:45.96Z"
]
2 => array:11 [
"RoomKey" => "1654421521"
"RoomType" => "Laundry room"
"ListingId" => "40827298"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29789956"
"RoomLength" => null
"RoomDimensions" => "6'2'' x 16'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-07T20:24:45.96Z"
]
3 => array:11 [
"RoomKey" => "1654421522"
"RoomType" => "Storage"
"ListingId" => "40827298"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29789956"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 5'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-07T20:24:45.96Z"
]
4 => array:11 [
"RoomKey" => "1654421523"
"RoomType" => "Utility room"
"ListingId" => "40827298"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29789956"
"RoomLength" => null
"RoomDimensions" => "25'9'' x 9'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-07T20:24:45.96Z"
]
5 => array:11 [
"RoomKey" => "1654421524"
"RoomType" => "Recreation room"
"ListingId" => "40827298"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29789956"
"RoomLength" => null
"RoomDimensions" => "19'3'' x 31'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-07T20:24:45.96Z"
]
6 => array:11 [
"RoomKey" => "1654421525"
"RoomType" => "Other"
"ListingId" => "40827298"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29789956"
"RoomLength" => null
"RoomDimensions" => "24'0'' x 17'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-07T20:24:45.97Z"
]
7 => array:11 [
"RoomKey" => "1654421526"
"RoomType" => "Bedroom"
"ListingId" => "40827298"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29789956"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-07T20:24:45.97Z"
]
8 => array:11 [
"RoomKey" => "1654421527"
"RoomType" => "Bedroom"
"ListingId" => "40827298"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29789956"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 8'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-07T20:24:45.97Z"
]
9 => array:11 [
"RoomKey" => "1654421528"
"RoomType" => "Primary Bedroom"
"ListingId" => "40827298"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29789956"
"RoomLength" => null
"RoomDimensions" => "14'2'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-07T20:24:45.97Z"
]
10 => array:11 [
"RoomKey" => "1654421529"
"RoomType" => "4pc Bathroom"
"ListingId" => "40827298"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29789956"
"RoomLength" => null
"RoomDimensions" => "6'6'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-07T20:24:45.97Z"
]
11 => array:11 [
"RoomKey" => "1654421530"
"RoomType" => "Living room"
"ListingId" => "40827298"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29789956"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-07T20:24:45.97Z"
]
12 => array:11 [
"RoomKey" => "1654421531"
"RoomType" => "Dining room"
"ListingId" => "40827298"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29789956"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-07T20:24:45.97Z"
]
13 => array:11 [
"RoomKey" => "1654421532"
"RoomType" => "Kitchen"
"ListingId" => "40827298"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29789956"
"RoomLength" => null
"RoomDimensions" => "7'10'' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-07T20:24:45.97Z"
]
14 => array:11 [
"RoomKey" => "1654421533"
"RoomType" => "Foyer"
"ListingId" => "40827298"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29789956"
"RoomLength" => null
"RoomDimensions" => "3'3'' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-07T20:24:45.97Z"
]
15 => array:11 [
"RoomKey" => "1654421534"
"RoomType" => "Foyer"
"ListingId" => "40827298"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29789956"
"RoomLength" => null
"RoomDimensions" => "3'1'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-07T20:24:45.97Z"
]
]
+"ListAOR": "Brantford"
+"ListAORKey": "41"
+"ListingURL": "www.realtor.ca/real-estate/29789956/168-montclair-crescent-waterford"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 71.0
+"AboveGradeFinishedArea": 993
+"BelowGradeFinishedArea": 736
+"OriginalEntryTimestamp": "2026-05-22T14:55:16.5Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1253211"
+"ListOfficeNationalAssociationId": "1380321"
+"Media": array:34 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29789956_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/9c7d32fa7a3fdb76a215d30b77f37e76.webp"
"MediaSize" => 140677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-9c7d32fa7a3fdb76a215d30b77f37e76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:17.43Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29789956_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/70013343175555e142a6e82fd5d9750a.webp"
"MediaSize" => 132546
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-70013343175555e142a6e82fd5d9750a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:18.59Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29789956_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/51699ecc8b9a2366762deeda19ff8683.webp"
"MediaSize" => 100140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-51699ecc8b9a2366762deeda19ff8683.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:18.64Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29789956_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/9f0d6b8d66803e1a96778dab001237a9.webp"
"MediaSize" => 162254
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-9f0d6b8d66803e1a96778dab001237a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:22.67Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29789956_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/3a3f9ab824bd108a27ca1dbd662e8ec1.webp"
"MediaSize" => 97729
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-3a3f9ab824bd108a27ca1dbd662e8ec1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:18.6Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29789956_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/57f0561dd900dc12286479abd64962ff.webp"
"MediaSize" => 118423
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-57f0561dd900dc12286479abd64962ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:17.42Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29789956_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/8e417648d9df97aeba4dc00b8611695a.webp"
"MediaSize" => 61506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-8e417648d9df97aeba4dc00b8611695a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:17.43Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29789956_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/4568bdefc62c29251a0799ed401f8047.webp"
"MediaSize" => 70759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-4568bdefc62c29251a0799ed401f8047.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:17.5Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29789956_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/b95abfcef0f41008e6c1953c6112867f.webp"
"MediaSize" => 70592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-b95abfcef0f41008e6c1953c6112867f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:17.43Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29789956_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/d33f87d5c38c58ca868091b75867216c.webp"
"MediaSize" => 60413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-d33f87d5c38c58ca868091b75867216c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:17.5Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29789956_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/5bf93720016817f044fa56af44a42190.webp"
"MediaSize" => 61997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-5bf93720016817f044fa56af44a42190.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:17.42Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29789956_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/4b3a90e23ca82b8d9aca08325f703c26.webp"
"MediaSize" => 85439
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-4b3a90e23ca82b8d9aca08325f703c26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:17.5Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29789956_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/124cce7fe9d880bde2d1ad39cf369a85.webp"
"MediaSize" => 81230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-124cce7fe9d880bde2d1ad39cf369a85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:17.5Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29789956_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/94bba0dfb748c7c4012efd4dff873c65.webp"
"MediaSize" => 60389
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-94bba0dfb748c7c4012efd4dff873c65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:17.5Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29789956_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/fcb1e78d8849dbf5923fd9e135197c6b.webp"
"MediaSize" => 67115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-fcb1e78d8849dbf5923fd9e135197c6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:17.5Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29789956_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/603ae55d5a7b8d969417f13b45a0821a.webp"
"MediaSize" => 82370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-603ae55d5a7b8d969417f13b45a0821a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:17.57Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29789956_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/d58be77d8eef1e5d70a3343d45f74ecf.webp"
"MediaSize" => 69111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-d58be77d8eef1e5d70a3343d45f74ecf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:17.5Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29789956_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/4eb8092962e57eab4217b5c791ed7ae2.webp"
"MediaSize" => 59668
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-4eb8092962e57eab4217b5c791ed7ae2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:17.5Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29789956_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/bd486c5b21b36fd2a9e89959efbcbd7c.webp"
"MediaSize" => 41924
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-bd486c5b21b36fd2a9e89959efbcbd7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:17.49Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29789956_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/b3eb3377c58704a0c8458cffc66ecb9f.webp"
"MediaSize" => 44898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-b3eb3377c58704a0c8458cffc66ecb9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:17.5Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29789956_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/24e38a5c75696dcf2dc0ee7c15ce8323.webp"
"MediaSize" => 110970
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-24e38a5c75696dcf2dc0ee7c15ce8323.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:17.49Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29789956_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/548cecc444506324a343547a5a1973fa.webp"
"MediaSize" => 119227
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-548cecc444506324a343547a5a1973fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:18.6Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29789956_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/11a380ea895ed1d5153d4939860d4ae4.webp"
"MediaSize" => 118190
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-11a380ea895ed1d5153d4939860d4ae4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:18.63Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29789956_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/d0ddf2d55b9048cbbe9bbbc4665eb348.webp"
"MediaSize" => 118505
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-d0ddf2d55b9048cbbe9bbbc4665eb348.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:22.67Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29789956_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/5bef714e1696613281bfb54515d8e9a7.webp"
"MediaSize" => 110263
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-5bef714e1696613281bfb54515d8e9a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:22.69Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29789956_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/2da931baccc5541d3ee46ffc3c9536fb.webp"
"MediaSize" => 100486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-2da931baccc5541d3ee46ffc3c9536fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T14:55:16.51Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29789956_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/c61ebaf229bd976a51a4903d69b42171.webp"
"MediaSize" => 132943
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-c61ebaf229bd976a51a4903d69b42171.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:18.6Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29789956_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/5c3822a3f80a42c897b261be9c2acc2d.webp"
"MediaSize" => 139135
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-5c3822a3f80a42c897b261be9c2acc2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:18.64Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29789956_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/731ffe4b779cead2dd32206f249ded8f.webp"
"MediaSize" => 121690
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-731ffe4b779cead2dd32206f249ded8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:30:18.6Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29789956_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/9f2d6e0a1df0f1abc8285a2dd20f340b.webp"
"MediaSize" => 133612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-9f2d6e0a1df0f1abc8285a2dd20f340b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:51:04.13Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29789956_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/dca57a5c47e3d3667f087b22101a0453.webp"
"MediaSize" => 141725
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-dca57a5c47e3d3667f087b22101a0453.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:51:05.4Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29789956_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/1aae553d89e7f379b882a2b357009187.webp"
"MediaSize" => 121532
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-1aae553d89e7f379b882a2b357009187.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:51:06.23Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29789956_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/c38f9b42b728b9688824e6f8e216fd60.webp"
"MediaSize" => 130351
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-c38f9b42b728b9688824e6f8e216fd60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:51:05.4Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29789956_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29789956/4c55adfa742f517e8888f8bcc3cf2c18.webp"
"MediaSize" => 36076
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29789956/thumbnail-4c55adfa742f517e8888f8bcc3cf2c18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40827298"
"ResourceRecordKey" => "29789956"
"ModificationTimestamp" => "2026-05-22T21:51:05.41Z"
]
]
+"DaysOnMarket": 31
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29789956')"
+"ID": "1449735"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 289711" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24820
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1964570" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24824
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29789956'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25221
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29789956'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25240
+items: array:3 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25237
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31291288"
+"ListingKey": "29789956"
+"ListingId": "40827298"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-07"
+"OpenHouseStartTime": "2026-06-07T14:00:00Z"
+"OpenHouseEndTime": "2026-06-07T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-06T20:11:09Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31291288')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25239
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31291289"
+"ListingKey": "29789956"
+"ListingId": "40827298"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-06"
+"OpenHouseStartTime": "2026-06-06T14:00:00Z"
+"OpenHouseEndTime": "2026-06-06T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-06T20:11:09Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31291289')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25236
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31356002"
+"ListingKey": "29789956"
+"ListingId": "40827298"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-07"
+"OpenHouseStartTime": "2026-06-07T14:00:00Z"
+"OpenHouseEndTime": "2026-06-07T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-07T18:56:53Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31356002')"
}
]
+success: true
+page_size: 3
+page_count: 1
+count: 3
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29789956' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.2842474 42.9310667)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25316
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25310
+post_id: "1553298"
+post_author: 1
+"ListingKey": "29935119"
+"ListingId": "40841738"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T15:20:10Z"
+"RFModificationTimestamp": "2026-06-22T15:29:25Z"
+"ListPrice": 989500.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1971.0
+"BuildingAreaTotal": 0
+"City": "Waterford"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "163 GIBBONS Street, Waterford, Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.2974462
1 => 42.9425213
]
+"Latitude": 42.9425213
+"Longitude": -80.2974462
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "To Be Built - This 3-bedroom, 2-bath brick and stone bungalow with main-floor laundry is a true showstopper on one of the last remaining premium lots in the Villages of Waterford. The open-concept floorplan features a gourmet kitchen with custom cabinetry, a large island, quartz counters, and backsplash. The dining and living rooms showcase 9' ceilings complemented by your choice of hardwood or luxury vinyl flooring throughout. The primary bedroom has a tray ceiling and offers a walk-in closet and a spacious ensuite with a standalone tub and tiled shower with glass doors. Enjoy entertaining on the back covered composite deck or relaxing on the front porch. Fully sodded, with a Tarion warranty. Optional appliance package available. (id:62650)"
+"Appliances": array:3 [
0 => "Hood Fan"
1 => "Garage door opener"
2 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T14:41:07.061451+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2211588"
+"ListOfficeKey": "48560"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Crushed stone driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T12:30:51Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T15:11:27Z"
+"Stories": "1.0"
+"StreetName": "GIBBONS"
+"StreetNumber": "163"
+"StreetSuffix": "Street"
+"SubdivisionName": "Waterford"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1665395072"
"RoomType" => "Bedroom"
"ListingId" => "40841738"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29935119"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T15:11:27.71Z"
]
1 => array:11 [
"RoomKey" => "1665395073"
"RoomType" => "Bedroom"
"ListingId" => "40841738"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29935119"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T15:11:27.71Z"
]
2 => array:11 [
"RoomKey" => "1665395074"
"RoomType" => "Full bathroom"
"ListingId" => "40841738"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29935119"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T15:11:27.71Z"
]
3 => array:11 [
"RoomKey" => "1665395075"
"RoomType" => "Primary Bedroom"
"ListingId" => "40841738"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29935119"
"RoomLength" => null
"RoomDimensions" => "13'8'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T15:11:27.71Z"
]
4 => array:11 [
"RoomKey" => "1665395076"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841738"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29935119"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T15:11:27.71Z"
]
5 => array:11 [
"RoomKey" => "1665395077"
"RoomType" => "Mud room"
"ListingId" => "40841738"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29935119"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T15:11:27.71Z"
]
6 => array:11 [
"RoomKey" => "1665395078"
"RoomType" => "Laundry room"
"ListingId" => "40841738"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29935119"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T15:11:27.72Z"
]
7 => array:11 [
"RoomKey" => "1665395079"
"RoomType" => "Foyer"
"ListingId" => "40841738"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29935119"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T15:11:27.72Z"
]
8 => array:11 [
"RoomKey" => "1665395080"
"RoomType" => "Living room"
"ListingId" => "40841738"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29935119"
"RoomLength" => null
"RoomDimensions" => "16'8'' x 17'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T15:11:27.73Z"
]
9 => array:11 [
"RoomKey" => "1665395081"
"RoomType" => "Dining room"
"ListingId" => "40841738"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29935119"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T15:11:27.73Z"
]
10 => array:11 [
"RoomKey" => "1665395082"
"RoomType" => "Kitchen"
"ListingId" => "40841738"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29935119"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 15'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T15:11:27.74Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29935119/163-gibbons-street-waterford"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-B"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 1971
+"OriginalEntryTimestamp": "2026-06-22T12:30:50.96Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1457486"
+"ListOfficeNationalAssociationId": "1218974"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29935119_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935119/e8f26452fa043998de5669b584ed4430.webp"
"MediaSize" => 57682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935119/thumbnail-e8f26452fa043998de5669b584ed4430.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841738"
"ResourceRecordKey" => "29935119"
"ModificationTimestamp" => "2026-06-22T12:30:50.96Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29935119')"
+"ID": "1553298"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25312
+post_id: "1545128"
+post_author: 1
+"ListingKey": "29924884"
+"ListingId": "40841272"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T11:55:10Z"
+"RFModificationTimestamp": "2026-06-19T11:57:32Z"
+"ListPrice": 520000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.25
+"LivingArea": 1248.0
+"BuildingAreaTotal": 0
+"City": "Waterford"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "97 MECHANIC Street W, Waterford, Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.296337
1 => 42.9365675
]
+"Latitude": 42.9365675
+"Longitude": -80.296337
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Great opportunity! 2 Storey, 4 Bedroom Home Sitting on an amazing 77 x 126 foot lot. Massive 20 x 40 foot Garage/Workshop with Hydro and a bonus Woodstove. Main Floor Consists of Large Eat-In Kitchen w/ Side Door Access, 4 pc Bath w/ Laundry, Living Room. Recent Improvements Include Fence 2020, Hot Water Tank Owned and Purchased in 2024, and Exterior House Painted in 2024, wood floors refinished, new trim, NEW kitchen and doors! Waterford is located centrally to Simcoe, Brantford, Port Dover, Delhi and with the 403 (which is about a 15-20 minute drive) it is close to Hamilton and beyond. Lake Erie is only a 20 minute drive away for the beach, fishing and boating enthusiasts in the family. Don't Miss Out!! This is a must see. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Crawl space"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T21:26:02.627093+00:00"
+"Directions": "From main St go west on mechanic"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1944913"
+"ListOfficeKey": "292789"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.25"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T20:55:51Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T11:50:11Z"
+"Stories": "2.0"
+"StreetDirSuffix": "West"
+"StreetName": "MECHANIC"
+"StreetNumber": "97"
+"StreetSuffix": "Street"
+"SubdivisionName": "Waterford"
+"TaxAnnualAmount": "2959"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=W48mQlkZuqY"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1662859708"
"RoomType" => "Bedroom"
"ListingId" => "40841272"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29924884"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T11:50:11.37Z"
]
1 => array:11 [
"RoomKey" => "1662859709"
"RoomType" => "Bedroom"
"ListingId" => "40841272"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29924884"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T11:50:11.37Z"
]
2 => array:11 [
"RoomKey" => "1662859710"
"RoomType" => "Primary Bedroom"
"ListingId" => "40841272"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29924884"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T11:50:11.37Z"
]
3 => array:11 [
"RoomKey" => "1662859711"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841272"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924884"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T11:50:11.37Z"
]
4 => array:11 [
"RoomKey" => "1662859712"
"RoomType" => "Bedroom"
"ListingId" => "40841272"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924884"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T11:50:11.37Z"
]
5 => array:11 [
"RoomKey" => "1662859713"
"RoomType" => "Living room"
"ListingId" => "40841272"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924884"
"RoomLength" => null
"RoomDimensions" => "14'2'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T11:50:11.37Z"
]
6 => array:11 [
"RoomKey" => "1662859714"
"RoomType" => "Eat in kitchen"
"ListingId" => "40841272"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924884"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 17'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T11:50:11.37Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29924884/97-mechanic-street-w-waterford"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 84.0
+"AboveGradeFinishedArea": 1248
+"OriginalEntryTimestamp": "2026-06-18T20:51:03.14Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1240500"
+"ListOfficeNationalAssociationId": "1417429"
+"Media": array:36 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29924884_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/fb9bcd55e487c288f5708af6f645ada5.webp"
"MediaSize" => 115791
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-fb9bcd55e487c288f5708af6f645ada5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924884')"
+"ID": "1545128"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25309
+post_id: "1543148"
+post_author: 1
+"ListingKey": "29921679"
+"ListingId": "40839371"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-21T20:30:04Z"
+"RFModificationTimestamp": "2026-06-21T20:33:34Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.21
+"LivingArea": 2026.0
+"BuildingAreaTotal": 0
+"City": "Waterford"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "121 MAIN Street N, Waterford, Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.2933571
1 => 42.9402224
]
+"Latitude": 42.9402224
+"Longitude": -80.2933571
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
+"PublicRemarks": "Some homes check the boxes. Others make you stop the car. Welcome to 121 Main Street North in Waterford. Set on a large 0.21-acre lot in one of Norfolk County’s most charming communities, this beautifully maintained vintage home offers over 2,000 square feet of above-grade living space, 4 bedrooms, 2 bathrooms, and craftsmanship that’s increasingly difficult to find. Lovingly cared for by its owner, this home is exceptionally clean, well-maintained, and features numerous major updates completed over time, allowing you to enjoy its character with confidence. From the moment you arrive, the attractive brick exterior and inviting curb appeal set the tone. The original front door with transom window welcomes you into a home filled with warmth and personality. Inside you’ll find tall ceilings, thick baseboards, original trim and woodwork, oversized windows, exposed brick, French doors, and timeless architectural detail throughout. The main kitchen offers classic oak cabinetry, while a second kitchenette adds flexibility for large families or multi-generational living. The sunroom stands out with exposed brick and natural light, and the parlour-style living room is ideal for quiet evenings and family gatherings. Outside, a fully fenced backyard framed by mature trees offers a private retreat. A carport and parking for four vehicles complete the package. This is a home with true character and presence, the kind that leaves a lasting impression. Offered at $499,900. Welcome home. Home Buyer Protection Plan included covering the central heating system, ductwork, central air conditioning or heat pump (up to $10,000 in year one), plus interior plumbing and electrical for added peace of mind. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T16:50:24.292332+00:00"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2204020"
+"ListOfficeKey": "92520"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0.21"
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-06-18T15:24:56Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-21T20:25:00Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "MAIN"
+"StreetNumber": "121"
+"StreetSuffix": "Street"
+"SubdivisionName": "Waterford"
+"TaxAnnualAmount": "2942.96"
+"VirtualTourURLUnbranded": "https://vimeo.com/1202261145?share=copy&fl=sv&fe=ci"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
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]
]
+"ListAOR": "Brantford"
+"ListAORKey": "41"
+"ListingURL": "www.realtor.ca/real-estate/29921679/121-main-street-n-waterford"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2153963"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1941010"
+"CoListAgentKey3": "2130098"
+"CoListOfficeKey": "291581"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "92520"
+"CoListOfficeKey3": "92520"
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 68.0
+"AboveGradeFinishedArea": 2026
+"OriginalEntryTimestamp": "2026-06-18T15:24:55.94Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1452607"
+"ListOfficeNationalAssociationId": "1191923"
+"CoListAgentNationalAssociationId": "1405496"
+"CoListAgentNationalAssociationId2": "1238374"
+"CoListAgentNationalAssociationId3": "1383021"
+"CoListOfficeNationalAssociationId": "1400487"
+"CoListOfficeNationalAssociationId2": "1191923"
+"CoListOfficeNationalAssociationId3": "1191923"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921679')"
+"ID": "1543148"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25313
+post_id: "1526557"
+post_author: 1
+"ListingKey": "29894806"
+"ListingId": "40827544"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T14:50:07Z"
+"RFModificationTimestamp": "2026-06-12T20:05:06Z"
+"ListPrice": 1129000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.212
+"LivingArea": 3090.0
+"BuildingAreaTotal": 0
+"City": "Waterford"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "69 TAN Avenue, Waterford, Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.2808014
1 => 42.9208593
]
+"Latitude": 42.9208593
+"Longitude": -80.2808014
+"YearBuilt": 2011
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Set in Waterford’s desirable Yin’s Subdivision on a very private pie-shaped lot at a quiet dead-end cul-de-sac, 69 Tan Avenue showcases meticulous care and enduring quality. Built in 2011, this award-winning Energy Star 2+2 bedroom, 3-bathroom bungalow features a double wide paved driveway, and an oversized 2-car attached garage with 12’ ceiling height & inside entry access. A stamped concrete walkway welcomes you to the covered front entry bordered by mature landscaping. Inside, you’ll discover an open concept living space with oak hardwood, ceramic, and carpet flooring, 9’ ceilings, and a large great room with a 12’ coffered ceiling, gas fireplace, and garden doors to the rear deck. The bright formal dining area features 14’ ceiling & crown moulding, while the spacious eat-in kitchen is appointed with custom cabinetry, island w/sink, granite counters, a built-in oven, stove top, and dishwasher. A convenient main floor laundry with sink and cabinetry sits adjacent to the kitchen. The primary bedroom offers a private 3-piece ensuite, and a guest bedroom along with a 4-piece bathroom complete the main level. The lower level adds an expansive recreation room and games area, two additional bedrooms, a 3-piece bathroom, plus a utility room and separate storage room. Exterior highlights include a brick/stone façade, low maintenance landscaping, inground irrigation, stamped concrete side patio & walkways, side entrance with direct access to basement area for multi-generational possibilities and a 13’ x 8’ garden shed, nestled on a premium lot offering additional privacy adjacent to farmer’s fields. This home is perfectly positioned close to the Waterford Ponds, Conservation area for paddling and fishing, the Waterford Heritage Trail, antique markets, and the Wishbone Brewery—an ideal blend of comfort, convenience, and opportunity. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Dryer"
5 => "Oven - Built-In"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T20:04:44.912540+00:00"
+"Directions": "Old Highway 24 go east onto Lam Blvd. Take Lam Blvd right to the end go east at the stop sign onto Tan Ave. Property is on the north side of the road."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2127441"
+"ListOfficeKey": "289745"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Southern exposure"
2 => "Paved driveway"
]
+"LotSizeDimensions": "0.212"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T14:42:15Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T14:42:15Z"
+"Stories": "1.0"
+"StreetName": "TAN"
+"StreetNumber": "69"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "Waterford"
+"TaxAnnualAmount": "7035.28"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://youtu.be/tB6lI5eZ7CY"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29894806/69-tan-avenue-waterford"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-A"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 98.0
+"AboveGradeFinishedArea": 1750
+"BelowGradeFinishedArea": 1340
+"OriginalEntryTimestamp": "2026-06-12T14:42:15.81Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1380672"
+"ListOfficeNationalAssociationId": "1380671"
+"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": 10
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29894806')"
+"ID": "1526557"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25311
+post_id: "1522517"
+post_author: 1
+"ListingKey": "29891970"
+"ListingId": "X13434222"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T21:10:14Z"
+"RFModificationTimestamp": "2026-06-11T21:41:51Z"
+"ListPrice": 1799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Norfolk (Waterford)"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "276 MECHANIC STREET W, Norfolk (Waterford), Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.3042611
1 => 42.933974
]
+"Latitude": 42.933974
+"Longitude": -80.3042611
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome to a truly rare waterfront offering where the tranquility of cottage living meets the convenience of town amenities. Set on nearly 4 acres with over 700 feet of shoreline on beautiful Shadow Lake, this exceptional property provides a private retreat surrounded by mature trees, abundant wildlife, and breathtaking natural scenery. The thoughtfully updated bungalow offers approximately 1,800 sq. ft. of comfortable main-floor living, featuring an inviting open-concept layout designed for both everyday living and entertaining. The renovated kitchen serves as the heart of the home, while generous living spaces and large windows capture stunning views of the surrounding property. The fully finished walkout lower level provides additional living and guest space with direct access to the outdoor entertaining area and pool deck. Step outside and enjoy a lifestyle that feels more like a lakeside cottage than a residence in town. Spend your mornings paddleboarding or kayaking, afternoons exploring the shoreline and nearby trails, and evenings relaxing by the water while taking in spectacular sunsets. Properties offering this level of privacy, waterfront access, and natural beauty are seldom available. A spacious attached 4-car garage is fully insulated and heated, complete with a rare drive-through design, making it ideal for hobbyists, car enthusiasts, recreational equipment, or additional storage. Numerous recent updates provide peace of mind, including improvements to the roof, furnace, air conditioning, pool liner, pool pump, and extensive interior renovations. Located just over an hour from Toronto and minutes from the Waterford Ponds, Trans Canada Trail, and local amenities, this is a unique opportunity to enjoy the best of both worlds -- a cottage lifestyle with the convenience of town living. (id:59439)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Range"
7 => "Dryer"
8 => "Garburator"
9 => "Garage door opener"
10 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Separate entrance"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
5 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Fishing"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-06-11T21:41:48.736059+00:00"
+"Directions": "Cross Streets: Concession 8 Townsend Rd/Mechanic St W. ** Directions: Hwy 24 to Concession 8 Townsend Rd/Mechanic St W."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1570202"
+"ListOfficeKey": "65141"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Irregular lot size"
1 => "Backs on greenbelt"
2 => "Carpet Free"
3 => "Gazebo"
4 => "In-Law Suite"
]
+"LotSizeDimensions": "48.8 x 733.1 FT ; Irregular"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T21:03:44Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T21:03:44Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "Mechanic"
+"StreetNumber": "276"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6729"
+"View": "Lake view,View of water,Direct Water View"
+"VirtualTourURLUnbranded": "https://pictureyourhome.hd.pics/276-Mechanic-St-W"
+"WaterBodyName": "Waterford Ponds"
+"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": "OnePoint"
+"TaxYear": 2025
+"CityRegion": "Waterford"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29891970/276-mechanic-street-w-norfolk-waterford-waterford"
+"ParkingTotal": 14
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 2
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on pond"
]
+"FrontageLengthNumeric": 48.9
+"OriginalEntryTimestamp": "2026-06-11T21:03:44.04Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1150973"
+"ListOfficeNationalAssociationId": "1129731"
+"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": 10
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891970')"
+"ID": "1522517"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25306
+post_id: "1517206"
+post_author: 1
+"ListingKey": "29882414"
+"ListingId": "40838565"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T20:45:04Z"
+"RFModificationTimestamp": "2026-06-13T20:48:52Z"
+"ListPrice": 1079900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2389.0
+"BuildingAreaTotal": 0
+"City": "Waterford"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "48 TEMPERANCE Street E, Waterford, Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.2879279
1 => 42.9331162
]
+"Latitude": 42.9331162
+"Longitude": -80.2879279
+"YearBuilt": 1900
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to your summer escape in the heart of Waterford — a move-in ready century home designed for outdoor living, entertaining, and making memories all season long. Imagine long evenings in the beautifully landscaped, private backyard, where there’s room for kids to play, friends to gather, and summer nights to stretch on. The standout two-storey barn adds incredible lifestyle space, featuring a finished and insulated room that’s perfect for a home gym, studio, workshop, or the ultimate hangout zone for guests and teens. Inside, the home is just as inviting for hosting. The bright, open kitchen and dining area is made for summer meals, weekend brunches, and holiday celebrations. A warm family room with a gas fireplace offers the perfect place to unwind after a day outside, while the separate living room with a classic woodburning fireplace adds timeless charm and cozy character. Upstairs, oversized windows fill the home with natural light and lead to a spacious landing. The primary bedroom connects directly to a beautifully updated bathroom with heated floors, and two additional bedrooms plus a second bath provide plenty of room for family or guests. With many updates already completed, this is your chance to settle in before summer truly begins and enjoy everything this home — and Waterford — has to offer (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T22:00:22.656756+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1965936"
+"ListOfficeKey": "48558"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Private Yard"
]
+"NumberOfUnitsTotal": "1"
+"PhotosChangeTimestamp": "2026-06-10T16:10:03Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T20:39:45Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "TEMPERANCE"
+"StreetNumber": "48"
+"StreetSuffix": "Street"
+"SubdivisionName": "Waterford"
+"TaxAnnualAmount": "4690"
+"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/29882414/48-temperance-street-e-waterford"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 82.0
+"AboveGradeFinishedArea": 2389
+"OriginalEntryTimestamp": "2026-06-10T16:10:03.23Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1254154"
+"ListOfficeNationalAssociationId": "1004255"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29882414')"
+"ID": "1517206"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23424
+post_id: "1506653"
+post_author: 1
+"ListingKey": "29869037"
+"ListingId": "40836926"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T14:30:17Z"
+"RFModificationTimestamp": "2026-06-08T17:29:44Z"
+"ListPrice": 1900000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 1346.0
+"BuildingAreaTotal": 0
+"City": "Waterford"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "136-160 MECHANIC Street W, Waterford, Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.2986096
1 => 42.9353977
]
+"Latitude": 42.9353977
+"Longitude": -80.2986096
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
+"PublicRemarks": "Residential Home with additional land which includes 2 parcels totalling 4.42 acres. The home was built in 2017 and is a 1,346sf executive home with walkout onto the pond. 3rd garage door to additional double deep garage bay. In-floor heating. Close proximity to schools, local restaurants, backing onto Waterford Ponds makes it a great choice to live. Future Residential townhouse development opportunity. Preliminary Site Plan available with potential for 32 townhouse style lots backing onto to Waterford ponds. Current plan incorporates the existing one story residence. Potential Site Plan includes an opportunity for 11 additional guest parking spaces. Property being sold “As Is, Where is”. (id:62650)"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-08T17:29:35.847896+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1398808"
+"ListOfficeKey": "289711"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-08T14:25:02Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T14:25:02Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "MECHANIC"
+"StreetNumber": "136"
+"StreetSuffix": "Street"
+"SubdivisionName": "Waterford"
+"TaxAnnualAmount": "20474.79"
+"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": "Brantford"
+"ListAORKey": "41"
+"ListingURL": "www.realtor.ca/real-estate/29869037/136-160-mechanic-street-w-waterford"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-A/R4(H)"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 188.0
+"AboveGradeFinishedArea": 1346
+"OriginalEntryTimestamp": "2026-06-08T14:25:02.15Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1038750"
+"ListOfficeNationalAssociationId": "1380321"
+"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": 14
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29869037')"
+"ID": "1506653"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25314
+post_id: "1501702"
+post_author: 1
+"ListingKey": "29862636"
+"ListingId": "40835602"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T00:40:10Z"
+"RFModificationTimestamp": "2026-06-11T00:56:53Z"
+"ListPrice": 519900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1401.0
+"BuildingAreaTotal": 0
+"City": "Waterford"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "86 GREEN Street, Waterford, Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.2928635
1 => 42.9288358
]
+"Latitude": 42.9288358
+"Longitude": -80.2928635
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Move-in ready brick bungalow offering over 1,400 sq ft of finished living space in a desirable Waterford location. The main floor features 2 bedrooms plus a versatile office that could serve as a third bedroom, abundant natural light, and a beautifully updated custom kitchen (2021) with premium cabinetry, soft-close drawers, slide-out shelves, new quartz countertops, and corner pull-outs for exceptional storage and convenience. Additional 2021 updates include new flooring throughout, subfloor, 4-piece bathroom, and upgraded lighting with dimmers. The finished basement provides additional living space, a cold room, and ample storage. Recent 2023 improvements include new exterior insulation, siding, basement ceiling, and windows. Enjoy the fully fenced backyard with plenty of room to relax, entertain, or play, plus a spacious shed for bikes, tools, and lawn equipment. Ideally located near the Waterford Heritage Trail, Waterford Ponds, arena, ballpark, and within walking distance to elementary and secondary schools. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T23:01:48.744235+00:00"
+"Directions": "Old Highway 24 to Green Street"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1470071"
+"ListOfficeKey": "48558"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"PhotosChangeTimestamp": "2026-06-11T00:31:57Z"
+"PhotosCount": 32
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T00:31:57Z"
+"Stories": "1.0"
+"StreetName": "GREEN"
+"StreetNumber": "86"
+"StreetSuffix": "Street"
+"SubdivisionName": "Waterford"
+"TaxAnnualAmount": "2785.58"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://visithome.ai/C7n5h49cQgS6gP3QBnKdyH?mu=ft"
+"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/29862636/86-green-street-waterford"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 59.0
+"AboveGradeFinishedArea": 1081
+"BelowGradeFinishedArea": 320
+"OriginalEntryTimestamp": "2026-06-05T19:39:33.59Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1127015"
+"ListOfficeNationalAssociationId": "1004255"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29862636')"
+"ID": "1501702"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25315
+post_id: "1497596"
+post_author: 1
+"ListingKey": "29856241"
+"ListingId": "40834172"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T19:40:06Z"
+"RFModificationTimestamp": "2026-06-14T19:42:50Z"
+"ListPrice": 824900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1475.0
+"BuildingAreaTotal": 0
+"City": "Waterford"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "15 WINTERBERRY Lane, Waterford, Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.2856016
1 => 42.9211293
]
+"Latitude": 42.9211293
+"Longitude": -80.2856016
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "END UNIT luxury bungalow townhome in sought-after Waterford, proudly built by Prominent Homes Inc. This beautiful 2+1 bedroom open-concept home offers upscale, low-maintenance living with quality finishes throughout. Features include 9-foot ceilings, rich hardwood floors, rounded corners, decorative ceilings, pot lights, and elegant custom details throughout. Quality construction includes 9” poured concrete foundation walls with reinforced walls and footings. The gourmet kitchen is a showpiece featuring granite countertops, spacious island, custom cabinetry, and ample storage space. Additional upgrades include stained stringers with rod iron railings, colonial-style doors and trim, HRV system, humidifier, central air conditioning, and central vac rough-in. Main floor laundry with direct access to the insulated 2-car garage. The fully finished basement offers exceptional additional living space with a spacious third bedroom, large rec room, separate office, and 4-piece bathroom, ideal for guests, extended family, or working from home. Enjoy the covered composite deck with tile patio stone sitting area, extended rear privacy fencing between units, attractive landscaping, and no-maintenance aluminum soffit, fascia, and troughs. Conveniently located very close to visitor parking. Condo corporation handles grass cutting, snow removal, landscaping, and exterior maintenance for easy living. Located close to schools, churches, Waterford Ponds, Lynn Valley Trail, golf, downtown amenities, wineries, breweries, and just a short drive to Port Dover Beach. A must-see home offering custom style, modern finishes, quality construction, and a prime location. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "395"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T21:08:24.329421+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2079582"
+"ListOfficeKey": "285770"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-05T21:50:16Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-14T19:32:23Z"
+"Stories": "1.0"
+"StreetName": "WINTERBERRY"
+"StreetNumber": "15"
+"StreetSuffix": "Lane"
+"SubdivisionName": "Town of Simcoe"
+"TaxAnnualAmount": "5024"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29856241/15-winterberry-lane-waterford"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R4 (H)"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1475
+"OriginalEntryTimestamp": "2026-06-04T20:32:20.68Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1354478"
+"ListOfficeNationalAssociationId": "1354408"
+"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": 17
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29856241')"
+"ID": "1497596"
}
]
+success: true
+page_size: 9
+page_count: 5
+count: 45
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]