array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29937261 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411
+post_id: "1555169"
+post_author: 1
+"ListingKey": "29937261"
+"ListingId": "40841980"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T22:20:08Z"
+"RFModificationTimestamp": "2026-06-22T22:23:34Z"
+"ListPrice": 489950.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 756.0
+"BuildingAreaTotal": 0
+"City": "Waterford"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "20 TRINITY Lane Unit# 20, Waterford, Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.2833639
1 => 42.9267111
]
+"Latitude": 42.9267111
+"Longitude": -80.2833639
+"YearBuilt": 2010
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to easy, low-maintenance living in the charming community of Waterford. Perfect for downsizers or empty nesters, this well-appointed bungalow townhouse condo features easy, low-maintenance living. Featuring a functional main-floor layout, bright living spaces, with room to expand and design your basement space including a rough in. Enjoy the freedom of condo living in a welcoming community designed for comfort and convenience. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Hood Fan"
5 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "291"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T19:54:24.775480+00:00"
+"Directions": "Thompson Road to Trinity Lane"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2024167"
+"ListOfficeKey": "262664"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Southern exposure"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T22:01:45Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T22:12:04Z"
+"Stories": "1.0"
+"StreetName": "TRINITY"
+"StreetNumber": "20"
+"StreetSuffix": "Lane"
+"SubdivisionName": "Waterford"
+"TaxAnnualAmount": "2935"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1665675394"
"RoomType" => "Laundry room"
"ListingId" => "40841980"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29937261"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T22:12:04.15Z"
]
1 => array:11 [
"RoomKey" => "1665675395"
"RoomType" => "Kitchen"
"ListingId" => "40841980"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29937261"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T22:12:04.17Z"
]
2 => array:11 [
"RoomKey" => "1665675396"
"RoomType" => "Living room"
"ListingId" => "40841980"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29937261"
"RoomLength" => null
"RoomDimensions" => "15'5'' x 17'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T22:12:04.17Z"
]
3 => array:11 [
"RoomKey" => "1665675397"
"RoomType" => "Bedroom"
"ListingId" => "40841980"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29937261"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 9'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T22:12:04.18Z"
]
4 => array:11 [
"RoomKey" => "1665675398"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841980"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29937261"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T22:12:04.18Z"
]
5 => array:11 [
"RoomKey" => "1665675399"
"RoomType" => "Bedroom"
"ListingId" => "40841980"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29937261"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 13'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T22:12:04.18Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29937261/20-trinity-lane-unit-20-waterford"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1524898"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "284641"
+"GeocodeManualYN": true
+"ZoningDescription": "IN"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 756
+"OriginalEntryTimestamp": "2026-06-22T18:10:53.38Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1303931"
+"ListOfficeNationalAssociationId": "1223042"
+"CoListAgentNationalAssociationId": "1064112"
+"CoListOfficeNationalAssociationId": "1344650"
+"Media": array:45 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29937261_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/fd9d1f8a13305de79cf68b808c8f4ae9.webp"
"MediaSize" => 134561
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-fd9d1f8a13305de79cf68b808c8f4ae9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T18:10:53.39Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29937261_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/6e3111f91d9ed533c75355423dad7179.webp"
"MediaSize" => 142097
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-6e3111f91d9ed533c75355423dad7179.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T18:10:53.39Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29937261_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/c5b2f4024a58ceab7194fcf89aeaf7e3.webp"
"MediaSize" => 134979
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-c5b2f4024a58ceab7194fcf89aeaf7e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T18:10:53.39Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29937261_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/0c3d949f06c6a2faa66c29f3570cbaf4.webp"
"MediaSize" => 147754
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-0c3d949f06c6a2faa66c29f3570cbaf4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T18:10:53.39Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29937261_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/ca96e8c6c4369def3b1c52f37d2ec202.webp"
"MediaSize" => 152376
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-ca96e8c6c4369def3b1c52f37d2ec202.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T18:10:53.39Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29937261_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/48329dcd3c4ba519c128f2eb90491f18.webp"
"MediaSize" => 73709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-48329dcd3c4ba519c128f2eb90491f18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T18:10:53.39Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29937261_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/1a9a5f13b657f8a5c034d0846ce870be.webp"
"MediaSize" => 58600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-1a9a5f13b657f8a5c034d0846ce870be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T18:10:53.39Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29937261_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/d5d90f08b8b570d27a67c13bc96ed019.webp"
"MediaSize" => 70338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-d5d90f08b8b570d27a67c13bc96ed019.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T18:10:53.39Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29937261_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/f8b9be4026921faab95ab5ca3bce75fb.webp"
"MediaSize" => 78215
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-f8b9be4026921faab95ab5ca3bce75fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:43.54Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29937261_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/546f27e3e07dad5570bac97793cbc4e1.webp"
"MediaSize" => 72242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-546f27e3e07dad5570bac97793cbc4e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:43.14Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29937261_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/38023ae2b678876606ff8f7400951bf8.webp"
"MediaSize" => 80106
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-38023ae2b678876606ff8f7400951bf8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:43.14Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29937261_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/52d97cdf3a4a7712cf87c0fbd4978ca3.webp"
"MediaSize" => 83632
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-52d97cdf3a4a7712cf87c0fbd4978ca3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:43.14Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29937261_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/260ad27917a34ee9c0f372a04953bc82.webp"
"MediaSize" => 74781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-260ad27917a34ee9c0f372a04953bc82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:43.14Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29937261_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/985320ea067359371daffd56c0d8d7f8.webp"
"MediaSize" => 80897
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-985320ea067359371daffd56c0d8d7f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:44.2Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29937261_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/6dd981411b4544e233778b6c10152de0.webp"
"MediaSize" => 87988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-6dd981411b4544e233778b6c10152de0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:44.2Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29937261_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/3700ce249320b450b2de06947e6c04b6.webp"
"MediaSize" => 84764
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-3700ce249320b450b2de06947e6c04b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:44.21Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29937261_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/12cb1693b1ab32f7283edda5cdb9f103.webp"
"MediaSize" => 89292
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-12cb1693b1ab32f7283edda5cdb9f103.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:44.2Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29937261_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/a924aa7192de68d5a1cfc577180b167f.webp"
"MediaSize" => 74070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-a924aa7192de68d5a1cfc577180b167f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:43.54Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29937261_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/d8cee05424d3e5ca4a80804f2fb6d5b7.webp"
"MediaSize" => 71964
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-d8cee05424d3e5ca4a80804f2fb6d5b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:44.2Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29937261_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/30ccf19085fff4dc3b9d3351cd810a8f.webp"
"MediaSize" => 83953
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-30ccf19085fff4dc3b9d3351cd810a8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:44.22Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29937261_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/1e2a5b25e6aa8d4982c09906a9f882cc.webp"
"MediaSize" => 76692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-1e2a5b25e6aa8d4982c09906a9f882cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:43.54Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29937261_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/d489a19b54e48bffe0a468f39ec80868.webp"
"MediaSize" => 99896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-d489a19b54e48bffe0a468f39ec80868.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:45.91Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29937261_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/7996efa95d13515974e5c0572d2db89d.webp"
"MediaSize" => 84181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-7996efa95d13515974e5c0572d2db89d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:45.91Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29937261_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/13d58f47be90be5ee9aa050c80b90f1b.webp"
"MediaSize" => 63776
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-13d58f47be90be5ee9aa050c80b90f1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:43.54Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29937261_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/652891cbb0ddb3d0781f235c2fcac02c.webp"
"MediaSize" => 69828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-652891cbb0ddb3d0781f235c2fcac02c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:45.79Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29937261_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/b597276f6dc07e8241b902a0b29d22ac.webp"
"MediaSize" => 62374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-b597276f6dc07e8241b902a0b29d22ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:45.9Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29937261_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/7be2787e53825700112d175d28232b35.webp"
"MediaSize" => 73279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-7be2787e53825700112d175d28232b35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:43.54Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29937261_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/1598bc10308ac43da66de07aa8739aaf.webp"
"MediaSize" => 126544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-1598bc10308ac43da66de07aa8739aaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:44.22Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29937261_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/3cde3a2e0c867f02fe45ead61fe83ea0.webp"
"MediaSize" => 123838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-3cde3a2e0c867f02fe45ead61fe83ea0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:43.54Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29937261_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/71d2204399ce3cd5051ffe44a2c0f0f2.webp"
"MediaSize" => 114200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-71d2204399ce3cd5051ffe44a2c0f0f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:43.61Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29937261_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/b309a1279f39138d745105ae4bb251ec.webp"
"MediaSize" => 110055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-b309a1279f39138d745105ae4bb251ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:44.22Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29937261_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/16dbec9c774919051024a8b8087cc1c4.webp"
"MediaSize" => 112992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-16dbec9c774919051024a8b8087cc1c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:44.21Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29937261_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/74be80b3f87e0b7c5ba00cd5fbe433c9.webp"
"MediaSize" => 168694
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-74be80b3f87e0b7c5ba00cd5fbe433c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:45.91Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29937261_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/f2204d3888093e68df9ee2b7fa5f1148.webp"
"MediaSize" => 157886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-f2204d3888093e68df9ee2b7fa5f1148.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:44.21Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29937261_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/0cafb131a82b1041831dbe43441301c6.webp"
"MediaSize" => 121177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-0cafb131a82b1041831dbe43441301c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:45.79Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29937261_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/fa1a73514356fde9b76ba60f91b66511.webp"
"MediaSize" => 144489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-fa1a73514356fde9b76ba60f91b66511.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:43.48Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29937261_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/26b1974b0c6551810e544723663319b6.webp"
"MediaSize" => 146304
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-26b1974b0c6551810e544723663319b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:44.21Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29937261_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/5e821349cca5a0ce0f7e8eaa7db2ce00.webp"
"MediaSize" => 156385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-5e821349cca5a0ce0f7e8eaa7db2ce00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:44.2Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29937261_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/db901a6bac574383720ca4c4087b64c6.webp"
"MediaSize" => 132587
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-db901a6bac574383720ca4c4087b64c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:44.2Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29937261_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/f27a08e278d7c70b46a0ff3bc14e37a4.webp"
"MediaSize" => 150505
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-f27a08e278d7c70b46a0ff3bc14e37a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:43.54Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29937261_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/a2f6eff99ac611193569deed86ebc576.webp"
"MediaSize" => 164445
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-a2f6eff99ac611193569deed86ebc576.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:44.2Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29937261_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/7c83b828ccbdc1f1c8eccc4732f7e5e6.webp"
"MediaSize" => 168998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-7c83b828ccbdc1f1c8eccc4732f7e5e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:45.9Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29937261_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/48de2d9e2000ed61beb2494aae56e205.webp"
"MediaSize" => 168420
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-48de2d9e2000ed61beb2494aae56e205.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:45.79Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29937261_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/024dd3bd03bb983cfa07138b31763862.webp"
"MediaSize" => 156306
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-024dd3bd03bb983cfa07138b31763862.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:45.79Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29937261_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937261/e3eb030272d6bce9949c18677f3ad435.webp"
"MediaSize" => 153152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937261/thumbnail-e3eb030272d6bce9949c18677f3ad435.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841980"
"ResourceRecordKey" => "29937261"
"ModificationTimestamp" => "2026-06-22T22:01:45.79Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29937261')"
+"ID": "1555169"
}
]
+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 262664" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24841
+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 2024167" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24840
+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 '29937261'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25243
+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 '29937261'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25259
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29937261' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.2833639 42.9267111)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25332
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25326
+post_id: "1556498"
+post_author: 1
+"ListingKey": "29939105"
+"ListingId": "40842136"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T22:45:13Z"
+"RFModificationTimestamp": "2026-06-22T23:58:02Z"
+"ListPrice": 779000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2535.0
+"BuildingAreaTotal": 0
+"City": "Waterford"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "5 BEEMER Street, Waterford, Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.2952739
1 => 42.9408104
]
+"Latitude": 42.9408104
+"Longitude": -80.2952739
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
+"PublicRemarks": "Pulled straight out a magazine.. Welcome HOME to 5 Beemer street in the beautiful and welcoming town of Waterford. County living with a small town twist, only 25 minutes to Brantford, 45 minutes to Hamilton and 15 minutes to the famous Lake Erie, Waterford IS where you want to call HOME. Walk through the front door and be immediately met with an impressive open concept floor plan, boasting warm and cozy modern living at its absolute finest. Featuring 10 foot vaulted ceilings with a 9 foot tray ceiling at the front door to please your eye line as you walk inside. The red ribbon was cut on this house in the summer of 2021 and has been impeccably maintained and turned from a house into a home. Gorgeous white marble courters throughout the entire house from the kitchen to the laundry room. Modern blonde engineered hardwood floors throughout the entire main area. Upgraded back splash in the kitchen, the ensuite showcases black octagon flooring and glass tiled walk-in shower paired with his and hers sinks. This house is truly complimented with the show stopping floor to ceiling fireplace wrapped in shiplap with a perfectly stained wood mantle, a real piece of modern art. Stepping downstairs is a fully finished rec room to give add a layer of warmth to those cozy movie nights, or a spot to curl up with a book after a long day. Fully equipped with 2 extra bedrooms and a 3rd full bathroom, it adds a perfect finishing touch to the IM HOME feeling you just can't help but feel when your there. Oh and that feeling of being at home doesn't stop inside.. the backyard has been designed with tranquility in mind. The fully covered and private back patio has entrances not just from the main area but also from your master bedroom, so you can slip outside for a morning coffee or take a dip in the spa like hot tub to wash away the day. It's just one of those houses that check, check and checks off all the boxes you've had and some you didn't even know you needed. Welcome HOME (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T23:57:52.158114+00:00"
+"Directions": "South on old highway 24 - Right onto Amber Street - Left onto Beemer"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2101851"
+"ListOfficeKey": "92544"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T22:35:06Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T22:35:06Z"
+"Stories": "1.0"
+"StreetName": "BEEMER"
+"StreetNumber": "5"
+"StreetSuffix": "Street"
+"SubdivisionName": "Waterford"
+"TaxAnnualAmount": "4800"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1665686690"
"RoomType" => "Recreation room"
"ListingId" => "40842136"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29939105"
"RoomLength" => null
"RoomDimensions" => "13'2'' x 24'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T22:35:06.37Z"
]
1 => array:11 [
"RoomKey" => "1665686691"
"RoomType" => "3pc Bathroom"
"ListingId" => "40842136"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29939105"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T22:35:06.37Z"
]
2 => array:11 [
"RoomKey" => "1665686692"
"RoomType" => "Bedroom"
"ListingId" => "40842136"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29939105"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 24'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T22:35:06.38Z"
]
3 => array:11 [
"RoomKey" => "1665686693"
"RoomType" => "Bedroom"
"ListingId" => "40842136"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29939105"
"RoomLength" => null
"RoomDimensions" => "13'2'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T22:35:06.38Z"
]
4 => array:11 [
"RoomKey" => "1665686694"
"RoomType" => "Porch"
"ListingId" => "40842136"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939105"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T22:35:06.39Z"
]
5 => array:11 [
"RoomKey" => "1665686695"
"RoomType" => "Full bathroom"
"ListingId" => "40842136"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939105"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T22:35:06.39Z"
]
6 => array:11 [
"RoomKey" => "1665686696"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842136"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939105"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T22:35:06.39Z"
]
7 => array:11 [
"RoomKey" => "1665686697"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842136"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939105"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T22:35:06.4Z"
]
8 => array:11 [
"RoomKey" => "1665686698"
"RoomType" => "Bedroom"
"ListingId" => "40842136"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939105"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 12'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T22:35:06.4Z"
]
9 => array:11 [
"RoomKey" => "1665686699"
"RoomType" => "Laundry room"
"ListingId" => "40842136"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939105"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 5'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T22:35:06.4Z"
]
10 => array:11 [
"RoomKey" => "1665686700"
"RoomType" => "Living room"
"ListingId" => "40842136"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939105"
"RoomLength" => null
"RoomDimensions" => "15'2'' x 18'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T22:35:06.41Z"
]
11 => array:11 [
"RoomKey" => "1665686701"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "40842136"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939105"
"RoomLength" => null
"RoomDimensions" => "20'4'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T22:35:06.41Z"
]
]
+"ListAOR": "Brantford"
+"ListAORKey": "41"
+"ListingURL": "www.realtor.ca/real-estate/29939105/5-beemer-street-waterford"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1A"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1305
+"BelowGradeFinishedArea": 1230
+"OriginalEntryTimestamp": "2026-06-22T22:35:06.04Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1371672"
+"ListOfficeNationalAssociationId": "1183612"
+"Media": array:45 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29939105_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939105/e34c6e3290984498c06b5fb4a7f79d0e.webp"
"MediaSize" => 82062
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939105/thumbnail-e34c6e3290984498c06b5fb4a7f79d0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842136"
"ResourceRecordKey" => "29939105"
"ModificationTimestamp" => "2026-06-22T22:35:06.06Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29939105_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939105/30d33078aac689eda355d393e690c007.webp"
"MediaSize" => 82009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939105/thumbnail-30d33078aac689eda355d393e690c007.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842136"
"ResourceRecordKey" => "29939105"
"ModificationTimestamp" => "2026-06-22T22:35:06.06Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29939105_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939105/5c1a2b7a5b6bec8adc14222405c5720b.webp"
"MediaSize" => 54539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939105/thumbnail-5c1a2b7a5b6bec8adc14222405c5720b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842136"
"ResourceRecordKey" => "29939105"
"ModificationTimestamp" => "2026-06-22T22:35:06.06Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29939105_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939105/32ea6822bdfc373f1bfc04b6f4dbdf79.webp"
…10
]
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29939105')"
+"ID": "1556498"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25328
+post_id: "1556499"
+post_author: 1
+"ListingKey": "29939044"
+"ListingId": "X13476398"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T18:55:19Z"
+"RFModificationTimestamp": "2026-06-23T18:58:51Z"
+"ListPrice": 489950.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Norfolk (Waterford)"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "20 - 20 TRINITY LANE, Norfolk (Waterford), Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.283498
1 => 42.926875
]
+"Latitude": 42.926875
+"Longitude": -80.283498
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to easy, low-maintenance living in the charming community of Waterford. Perfect for downsizers or empty nesters, this well-appointed bungalow townhouse condo features easy, low-maintenance living. Featuring a functional main-floor layout, bright living spaces, with room to expand and design your basement space including a rough in. Enjoy the freedom of condo living in a welcoming community designed for comfort and convenience. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Hood Fan"
5 => "Window Coverings"
6 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "291"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T23:35:32.657093+00:00"
+"Directions": "Thompson Road to Trinity Lane"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Facing"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2238738"
+"ListOfficeKey": "284787"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T18:50:41Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T18:50:41Z"
+"Stories": "1.0"
+"StreetName": "Trinity"
+"StreetNumber": "20"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "2935"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterford"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29939044/20-20-trinity-lane-norfolk-waterford-waterford"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Self Managed"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-22T22:24:45.71Z"
+"ListAgentNationalAssociationId": "1476573"
+"ListOfficeNationalAssociationId": "1344854"
+"Media": array:45 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29939044')"
+"ID": "1556499"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25325
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/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 [ …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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924884')"
+"ID": "1545128"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25329
+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": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921679')"
+"ID": "1543148"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25327
+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": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29894806')"
+"ID": "1526557"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25302
+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": 13
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891970')"
+"ID": "1522517"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+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": 14
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29882414')"
+"ID": "1517206"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25330
+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": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29869037')"
+"ID": "1506653"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25331
+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": 19
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29862636')"
+"ID": "1501702"
}
]
+success: true
+page_size: 9
+page_count: 4
+count: 36
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]