array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29924884 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: "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"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:49.32Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29924884_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/728e9f2549a37731ef82f73412ac122a.webp"
"MediaSize" => 138392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-728e9f2549a37731ef82f73412ac122a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:49.61Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29924884_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/f24697110c509c524ac35e63f22002c7.webp"
"MediaSize" => 128328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-f24697110c509c524ac35e63f22002c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:49.8Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29924884_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/7e57379caf894e8154b10296bdd5924e.webp"
"MediaSize" => 124991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-7e57379caf894e8154b10296bdd5924e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:49.88Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29924884_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/fc95334860e9d02b3b330d6f73053d98.webp"
"MediaSize" => 204779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-fc95334860e9d02b3b330d6f73053d98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:49.8Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29924884_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/bcb86afbd47a80583ec4efaa047d7cde.webp"
"MediaSize" => 169321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-bcb86afbd47a80583ec4efaa047d7cde.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:49.33Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29924884_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/3a52b3f42449a900062327e42b90cd78.webp"
"MediaSize" => 141815
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-3a52b3f42449a900062327e42b90cd78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:49.31Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29924884_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/80b84b55b120970ab3aae2a19e2ad3df.webp"
"MediaSize" => 146897
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-80b84b55b120970ab3aae2a19e2ad3df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:49.33Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29924884_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/e081a37eb7162eda399a40691de8ddd7.webp"
"MediaSize" => 184095
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-e081a37eb7162eda399a40691de8ddd7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:50.14Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29924884_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/aa80fd11f51b6181e813d5f8e028f749.webp"
"MediaSize" => 167034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-aa80fd11f51b6181e813d5f8e028f749.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:51.38Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29924884_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/1e88af5e24c441d7868bd24b17d209f0.webp"
"MediaSize" => 168582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-1e88af5e24c441d7868bd24b17d209f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:49.67Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29924884_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/6e0e551be4eb9e33d6f69b16d9eceb5d.webp"
"MediaSize" => 161219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-6e0e551be4eb9e33d6f69b16d9eceb5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:51.39Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29924884_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/c9214ef07a214331816b2961e5c5dc6d.webp"
"MediaSize" => 145567
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-c9214ef07a214331816b2961e5c5dc6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:51.47Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29924884_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/1b471610b52ec775d9af2846833510b8.webp"
"MediaSize" => 117231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-1b471610b52ec775d9af2846833510b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:51.38Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29924884_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/9bd13b1a5084db1d2a29b1da368b0909.webp"
"MediaSize" => 111932
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-9bd13b1a5084db1d2a29b1da368b0909.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:49.58Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29924884_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/c10ef767e401aeaad101c5e0143a8df7.webp"
"MediaSize" => 111241
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-c10ef767e401aeaad101c5e0143a8df7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:49.32Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29924884_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/89e4e497090929e2c278209a0053a42c.webp"
"MediaSize" => 113908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-89e4e497090929e2c278209a0053a42c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:51.38Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29924884_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/0f247a03ef15a2f41110c9e21ef46441.webp"
"MediaSize" => 106257
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-0f247a03ef15a2f41110c9e21ef46441.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:49.33Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29924884_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/d097c33401451c3a2f32ff425d3841a7.webp"
"MediaSize" => 183181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-d097c33401451c3a2f32ff425d3841a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:50.11Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29924884_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/f96309dd57735f21a9d0ecd9bb8e7d31.webp"
"MediaSize" => 181752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-f96309dd57735f21a9d0ecd9bb8e7d31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:51.12Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29924884_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/ceb939e9357eda6ca317358cf5428e71.webp"
"MediaSize" => 178804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-ceb939e9357eda6ca317358cf5428e71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:51.38Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29924884_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/39512a11302807acc5f160456ee5243d.webp"
"MediaSize" => 70801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-39512a11302807acc5f160456ee5243d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:51.39Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29924884_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/6ba4d3658dd7d74b1b2d6e8e0c876aa4.webp"
"MediaSize" => 70324
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-6ba4d3658dd7d74b1b2d6e8e0c876aa4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:49.79Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29924884_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/374757c6ebcb3df98a6338d02d91d58a.webp"
"MediaSize" => 70067
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-374757c6ebcb3df98a6338d02d91d58a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:49.92Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29924884_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/3ef9a1ff3cacec429d7ef5e62d504157.webp"
"MediaSize" => 91722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-3ef9a1ff3cacec429d7ef5e62d504157.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:49.84Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29924884_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/b8ea392e05b9f5a95fa5cba8d15c0f25.webp"
"MediaSize" => 76190
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-b8ea392e05b9f5a95fa5cba8d15c0f25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:51.41Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29924884_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/e715b89c28cb1f06fa7cac1007884cc8.webp"
"MediaSize" => 71185
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-e715b89c28cb1f06fa7cac1007884cc8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:51.61Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29924884_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/847507facc8ce597d165e94ebc5ebff5.webp"
"MediaSize" => 65779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-847507facc8ce597d165e94ebc5ebff5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:51.12Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29924884_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/df73c3aa559ce7b8c6effc0aacf58cc7.webp"
"MediaSize" => 71074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-df73c3aa559ce7b8c6effc0aacf58cc7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:51.39Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29924884_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/3d4fd27e2641b715a57288371fbe6e21.webp"
"MediaSize" => 71261
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-3d4fd27e2641b715a57288371fbe6e21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:49.84Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29924884_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/c67a38586cd373951ceb3414006080cb.webp"
"MediaSize" => 68473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-c67a38586cd373951ceb3414006080cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:51.39Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29924884_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/cf53f320a3e97435226ce8b1a6ff4791.webp"
"MediaSize" => 52617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-cf53f320a3e97435226ce8b1a6ff4791.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:51.46Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29924884_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/22eb64d4503570524e9ffc406c75c0a7.webp"
"MediaSize" => 79655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-22eb64d4503570524e9ffc406c75c0a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:49.82Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29924884_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/c28e29f541b1ef73788722f2024e8810.webp"
"MediaSize" => 69842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-c28e29f541b1ef73788722f2024e8810.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:51.12Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29924884_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/4dae8575a812d57784fbf89ad3b661fc.webp"
"MediaSize" => 49689
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-4dae8575a812d57784fbf89ad3b661fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:51.38Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29924884_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/3c3ace9d01a700b215f565a46c9b31c7.webp"
"MediaSize" => 63681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-3c3ace9d01a700b215f565a46c9b31c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841272"
"ResourceRecordKey" => "29924884"
"ModificationTimestamp" => "2026-06-18T20:55:49.67Z"
]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924884')"
+"ID": "1545128"
}
]
+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 292789" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24829
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1944913" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24823
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29924884'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25229
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29924884'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25245
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29924884' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.296337 42.9365675)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25318
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25312
+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 {#25314
+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 [
"RoomKey" => "1664903268"
"RoomType" => "Storage"
"ListingId" => "40839371"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29921679"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-21T20:25:00.91Z"
]
1 => array:11 [
"RoomKey" => "1664903269"
"RoomType" => "Utility room"
"ListingId" => "40839371"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29921679"
"RoomLength" => null
"RoomDimensions" => "29'8'' x 19'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-21T20:25:00.91Z"
]
2 => array:11 [
"RoomKey" => "1664903270"
"RoomType" => "Bedroom"
"ListingId" => "40839371"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29921679"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 8'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-21T20:25:00.91Z"
]
3 => array:11 [
"RoomKey" => "1664903271"
"RoomType" => "Bedroom"
"ListingId" => "40839371"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29921679"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 12'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-21T20:25:00.91Z"
]
4 => array:11 [
"RoomKey" => "1664903272"
"RoomType" => "Primary Bedroom"
"ListingId" => "40839371"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29921679"
"RoomLength" => null
"RoomDimensions" => "14'1'' x 13'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-21T20:25:00.91Z"
]
5 => array:11 [
"RoomKey" => "1664903273"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839371"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921679"
"RoomLength" => null
"RoomDimensions" => "6'4'' x 6'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-21T20:25:00.91Z"
]
6 => array:11 [
"RoomKey" => "1664903274"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839371"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921679"
"RoomLength" => null
"RoomDimensions" => "8'7'' x 5'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-21T20:25:00.91Z"
]
7 => array:11 [
"RoomKey" => "1664903275"
"RoomType" => "Bedroom"
"ListingId" => "40839371"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921679"
"RoomLength" => null
"RoomDimensions" => "14'7'' x 12'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-21T20:25:00.91Z"
]
8 => array:11 [
"RoomKey" => "1664903276"
"RoomType" => "Office"
"ListingId" => "40839371"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921679"
"RoomLength" => null
"RoomDimensions" => "14'7'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-21T20:25:00.91Z"
]
9 => array:11 [
"RoomKey" => "1664903277"
"RoomType" => "Sunroom"
"ListingId" => "40839371"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921679"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 6'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-21T20:25:00.91Z"
]
10 => array:11 [
"RoomKey" => "1664903278"
"RoomType" => "Kitchen"
"ListingId" => "40839371"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921679"
"RoomLength" => null
"RoomDimensions" => "13'1'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-21T20:25:00.91Z"
]
11 => array:11 [
"RoomKey" => "1664903279"
"RoomType" => "Dining room"
"ListingId" => "40839371"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921679"
"RoomLength" => null
"RoomDimensions" => "14'1'' x 19'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-21T20:25:00.92Z"
]
12 => array:11 [
"RoomKey" => "1664903280"
"RoomType" => "Living room"
"ListingId" => "40839371"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921679"
"RoomLength" => null
"RoomDimensions" => "14'2'' x 21'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-21T20:25:00.92Z"
]
13 => array:11 [
"RoomKey" => "1664903281"
"RoomType" => "Mud room"
"ListingId" => "40839371"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921679"
"RoomLength" => null
"RoomDimensions" => "16'0'' x 8'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-21T20:25:00.92Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29921679_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921679/5d8d61949ce3d7fadec9727a525bf18d.webp"
"MediaSize" => 167164
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921679/thumbnail-5d8d61949ce3d7fadec9727a525bf18d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839371"
"ResourceRecordKey" => "29921679"
"ModificationTimestamp" => "2026-06-18T15:24:55.95Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29921679_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921679/6032b509172b50d7ecdcf05f7ede56f6.webp"
"MediaSize" => 163997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921679/thumbnail-6032b509172b50d7ecdcf05f7ede56f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839371"
"ResourceRecordKey" => "29921679"
"ModificationTimestamp" => "2026-06-18T15:24:55.95Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29921679_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921679/7a51e744ae86cec30178941c04bd9d45.webp"
"MediaSize" => 170487
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921679/thumbnail-7a51e744ae86cec30178941c04bd9d45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839371"
"ResourceRecordKey" => "29921679"
"ModificationTimestamp" => "2026-06-18T15:24:55.95Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29921679_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921679/ac3851d62d7c731ca5455fa0c1655b81.webp"
"MediaSize" => 79741
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921679/thumbnail-ac3851d62d7c731ca5455fa0c1655b81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839371"
"ResourceRecordKey" => "29921679"
"ModificationTimestamp" => "2026-06-18T15:24:55.95Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29921679_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921679/00999ba15f4cd0b370ea008436de25e8.webp"
"MediaSize" => 61485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921679/thumbnail-00999ba15f4cd0b370ea008436de25e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839371"
"ResourceRecordKey" => "29921679"
"ModificationTimestamp" => "2026-06-18T15:24:55.95Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29921679_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921679/63bc148a7a85bfce9203e303c980f5be.webp"
"MediaSize" => 71988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921679/thumbnail-63bc148a7a85bfce9203e303c980f5be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839371"
"ResourceRecordKey" => "29921679"
"ModificationTimestamp" => "2026-06-18T15:24:55.95Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29921679_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921679/34da5c227d101bd46acfcb9d11357a4e.webp"
"MediaSize" => 79475
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921679/thumbnail-34da5c227d101bd46acfcb9d11357a4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839371"
"ResourceRecordKey" => "29921679"
"ModificationTimestamp" => "2026-06-18T15:24:55.95Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29921679_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921679/aea15bbe91f7ae6209ad602b78f2fd92.webp"
"MediaSize" => 68217
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921679/thumbnail-aea15bbe91f7ae6209ad602b78f2fd92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839371"
"ResourceRecordKey" => "29921679"
"ModificationTimestamp" => "2026-06-18T15:24:55.95Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29921679_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921679/605a3d5af8de183520d581cfff0ef460.webp"
"MediaSize" => 65068
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921679/thumbnail-605a3d5af8de183520d581cfff0ef460.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839371"
"ResourceRecordKey" => "29921679"
"ModificationTimestamp" => "2026-06-18T15:24:55.95Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29921679_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921679/0c6f8ae7ae609de26cc91011a6c82ed3.webp"
"MediaSize" => 99383
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921679/thumbnail-0c6f8ae7ae609de26cc91011a6c82ed3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839371"
"ResourceRecordKey" => "29921679"
"ModificationTimestamp" => "2026-06-18T15:24:55.95Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29921679_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921679/f0b32cb17690acd3d225e7a5a2dbddb0.webp"
"MediaSize" => 61286
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921679/thumbnail-f0b32cb17690acd3d225e7a5a2dbddb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839371"
"ResourceRecordKey" => "29921679"
"ModificationTimestamp" => "2026-06-18T15:24:55.95Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29921679_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921679/f079e837d92e5904a57e3170f0b914f4.webp"
"MediaSize" => 55485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921679/thumbnail-f079e837d92e5904a57e3170f0b914f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839371"
"ResourceRecordKey" => "29921679"
"ModificationTimestamp" => "2026-06-18T15:24:55.95Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29921679_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921679/4cdab7eece6ea1a62cb2103d0ddb9e84.webp"
"MediaSize" => 58696
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921679/thumbnail-4cdab7eece6ea1a62cb2103d0ddb9e84.webp"
"ResourceName" => "Property"
…6
]
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"
}
2 => 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"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25315
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25313
+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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25308
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23424
+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"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25316
+post_id: "1494556"
+post_author: 1
+"ListingKey": "29853923"
+"ListingId": "40836242"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T21:20:34Z"
+"RFModificationTimestamp": "2026-06-05T21:35:31Z"
+"ListPrice": 1900000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterford"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "136/160 MECHANIC Street W, Waterford, Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.29863
1 => 42.9355588
]
+"Latitude": 42.9355588
+"Longitude": -80.29863
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
+"PublicRemarks": "Residential townhouse development opportunity. 2 parcels totalling 4.42 acres Preliminary Site Plan available with potential for 32 townhouse style lots backing onto to Waterford ponds. Current plan incorporates the existing one story residence, built in 2017 is a 1,346sf executive home with walkout onto the pond. Details available with signed Confidentiality Agreement (CA). Close proximity to schools, local restaurants, backing onto Waterford Ponds makes it a great choice to live. Site plan includes an opportunity for 11 additional guest parking spaces, potential site plan and additional information can be provided upon signing of a Confidentiality Agreement. Property being sold “As Is, Where is”. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-04T18:07:52.922455+00:00"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1398808"
+"ListOfficeKey": "289711"
+"PhotosChangeTimestamp": "2026-06-04T16:44:32Z"
+"PhotosCount": 21
+"Sewer": array:1 [
0 => "No sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T21:14:58Z"
+"StreetDirSuffix": "West"
+"StreetName": "MECHANIC"
+"StreetNumber": "136"
+"StreetSuffix": "Street"
+"SubdivisionName": "Waterford"
+"TaxAnnualAmount": "20474.79"
+"WaterSource": array:1 [
0 => "None"
]
+"ListAOR": "Brantford"
+"ListAORKey": "41"
+"ListingURL": "www.realtor.ca/real-estate/29853923/136160-mechanic-street-w-waterford"
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-A/R4(H)"
+"FrontageLengthNumeric": 188.0
+"OriginalEntryTimestamp": "2026-06-04T16:44:32.16Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1038750"
+"ListOfficeNationalAssociationId": "1380321"
+"Media": array:21 [
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]
]
+"DaysOnMarket": 17
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29853923')"
+"ID": "1494556"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25317
+post_id: "1493585"
+post_author: 1
+"ListingKey": "29851949"
+"ListingId": "40836438"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:00:09Z"
+"RFModificationTimestamp": "2026-06-16T16:14:38Z"
+"ListPrice": 550000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.1
+"LivingArea": 1854.0
+"BuildingAreaTotal": 0
+"City": "Waterford"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "33A LINGWOOD Drive, Waterford, Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.2858845
1 => 42.9361699
]
+"Latitude": 42.9361699
+"Longitude": -80.2858845
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This well cared-for, semi-detached brick bungalow was built in 2003 and offers an open-concept design with a 1-car attached garage and a walk out basement to a private rear yard, a combination that won’t disappoint. The main floor spans approximately 1,085 square feet, providing ample space for entertaining family and friends in a bright, cheery setting bathed in natural light. It includes a spacious living room and an eat-in kitchen with a central island, plus two bedrooms overlooking the backyard. The primary bedroom offers ensuite access to the 4-piece bathroom, and a convenient main-floor laundry room adds daily convenience. Downstairs, you’ll first notice the peaceful rear view through patio doors that open to a deck and a manageable yard. The lower level features a comfortable recreation room with plenty of space for a sitting area and games, and a large 3rd bedroom. A 3-piece washroom and ample storage complete the space. With no rear neighbours and a compact yard that’s easy to maintain, this home is ideal for downsizing or for those starting out, while still offering ample room to relax or entertain without spending excessive time on yard chores. The location is welcoming for walkers, just steps from the trail, and Waterford itself offers charm and community with Pumpkinfest, live music, antique markets, Wishbone Brewery, and the Waterford Ponds. For your personal viewing, call today to arrange a tour. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T14:35:55.528186+00:00"
+"Directions": "Temperance Street E turn north onto Fairview Drive. Turn east onto Lingwood Drive property is on the north side of the road."
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"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 => "Southern exposure"
1 => "Paved driveway"
2 => "Sump Pump"
]
+"LotSizeDimensions": "0.1"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T15:53:01Z"
+"PhotosCount": 38
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:53:01Z"
+"Stories": "1.0"
+"StreetName": "LINGWOOD"
+"StreetNumber": "33"
+"StreetSuffix": "Drive"
+"SubdivisionName": "Waterford"
+"TaxAnnualAmount": "3001.72"
+"VirtualTourURLUnbranded": "https://youtu.be/F785YQpuXLE"
+"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/29851949/33a-lingwood-drive-waterford"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1085
+"BelowGradeFinishedArea": 769
+"OriginalEntryTimestamp": "2026-06-04T13:20:01.98Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1380672"
+"ListOfficeNationalAssociationId": "1380671"
+"Media": array:38 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 18
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29851949')"
+"ID": "1493585"
}
]
+success: true
+page_size: 9
+page_count: 5
+count: 42
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
]