array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29836075 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23331
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23333
+post_id: "1482670"
+post_author: 1
+"ListingKey": "29836075"
+"ListingId": "X13224622"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-01T21:26:09Z"
+"RFModificationTimestamp": "2026-06-01T23:12:05Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V2"
+"UnparsedAddress": "672 ZERMATT DRIVE, Waterloo, Ontario N2T2V2"
+"Coordinates": array:2 [
0 => -80.577922
1 => 43.458536
]
+"Latitude": 43.458536
+"Longitude": -80.577922
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "*Welcome To 672 Zermatt Dr.***Beautiful Family Home In A Quiet Neighborhood. This Well Kept Two Story Home Features 3 Bedrooms, 2 Bathroom, Freshly painted Main Floor Features Spacious Living Room, Dining Room, Kitchen And Walkout To Wooden Deck For Outdoor Enjoyment. No Rear Neighbors.( KITCHEN, FLOORS, BATHROOMS, FURNACE & WATER SOFTNER UPDATED IN 2026) Just steps away from Waterloo's Costco, Boardwalk Shopping Centre, YMCA, library, schools, and public transit. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-01T23:07:07.109898+00:00"
+"Directions": "Cross Streets: Brandenburg Blvd/Erbsville Rd. ** Directions: Columbia St W/Erbsville Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2002601"
+"ListOfficeKey": "50932"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "32 x 108.9 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-01T21:15:23Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-01T21:15:23Z"
+"Stories": "2.0"
+"StreetName": "Zermatt"
+"StreetNumber": "672"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4151"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://virtualtourphotography.hd.pics/672-Zermatt-Dr"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1648958774"
"RoomType" => "Living room"
"ListingId" => "X13224622"
"RoomLevel" => "Main level"
"RoomWidth" => 3.85
"ListingKey" => "29836075"
"RoomLength" => 4.52
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T21:15:23.8Z"
]
1 => array:11 [
"RoomKey" => "1648958775"
"RoomType" => "Kitchen"
"ListingId" => "X13224622"
"RoomLevel" => "Main level"
"RoomWidth" => 3.94
"ListingKey" => "29836075"
"RoomLength" => 5.61
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T21:15:23.81Z"
]
2 => array:11 [
"RoomKey" => "1648958776"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13224622"
"RoomLevel" => "Second level"
"RoomWidth" => 4.13
"ListingKey" => "29836075"
"RoomLength" => 4.98
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T21:15:23.81Z"
]
3 => array:11 [
"RoomKey" => "1648958777"
"RoomType" => "Bedroom 2"
"ListingId" => "X13224622"
"RoomLevel" => "Second level"
"RoomWidth" => 3.03
"ListingKey" => "29836075"
"RoomLength" => 3.12
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T21:15:23.82Z"
]
4 => array:11 [
"RoomKey" => "1648958778"
"RoomType" => "Bedroom 3"
"ListingId" => "X13224622"
"RoomLevel" => "Second level"
"RoomWidth" => 3.04
"ListingKey" => "29836075"
"RoomLength" => 3.13
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T21:15:23.82Z"
]
5 => array:11 [
"RoomKey" => "1648958779"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13224622"
"RoomLevel" => "Basement"
"RoomWidth" => 6.86
"ListingKey" => "29836075"
"RoomLength" => 8.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T21:15:23.83Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29836075/672-zermatt-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 32.0
+"OriginalEntryTimestamp": "2026-06-01T21:15:23.6Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1285609"
+"ListOfficeNationalAssociationId": "1002980"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29836075_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/88c2d095383c87bab35475de4450fb98.webp"
"MediaSize" => 296520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-88c2d095383c87bab35475de4450fb98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29836075_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/a1400201807f82c4ba335b5963fcba38.webp"
"MediaSize" => 246723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-a1400201807f82c4ba335b5963fcba38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29836075_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/f02d822da9b8c6f2e49153f1765715bf.webp"
"MediaSize" => 262445
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-f02d822da9b8c6f2e49153f1765715bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29836075_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/80ee130d6d7b63b7cc4458a65cb13e2c.webp"
"MediaSize" => 266723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-80ee130d6d7b63b7cc4458a65cb13e2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29836075_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/92276c3195150ea9835258a83a339f7d.webp"
"MediaSize" => 279461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-92276c3195150ea9835258a83a339f7d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29836075_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/12c5c6ba7b271633e42ee1ad64bdb6e2.webp"
"MediaSize" => 259101
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-12c5c6ba7b271633e42ee1ad64bdb6e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29836075_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/067e95731c426747ad6a7ff18433da87.webp"
"MediaSize" => 175435
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-067e95731c426747ad6a7ff18433da87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29836075_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/208b7cfde43670e6169ec977d1a7eb3e.webp"
"MediaSize" => 167404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-208b7cfde43670e6169ec977d1a7eb3e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29836075_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/59ab0478b5dac4831e67cc8466d06f3d.webp"
"MediaSize" => 91787
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-59ab0478b5dac4831e67cc8466d06f3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29836075_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/7a1b5484b789e9dc013f78094b63b232.webp"
"MediaSize" => 126767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-7a1b5484b789e9dc013f78094b63b232.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29836075_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/bfb238f00e656dad481263cfb162517b.webp"
"MediaSize" => 142111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-bfb238f00e656dad481263cfb162517b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29836075_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/c13dc617aab9409f5b66beceb7f656d5.webp"
"MediaSize" => 110828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-c13dc617aab9409f5b66beceb7f656d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29836075_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/18082d0ead5cc5925b6a96be3444bc31.webp"
"MediaSize" => 132685
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-18082d0ead5cc5925b6a96be3444bc31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29836075_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/c93aa4dbd11f18142fe900db27f08529.webp"
"MediaSize" => 131886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-c93aa4dbd11f18142fe900db27f08529.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29836075_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/28a2f1f38269a69518402e1f12ae1f29.webp"
"MediaSize" => 112574
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-28a2f1f38269a69518402e1f12ae1f29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29836075_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/48e2fa649ba27533725e8c071c07c68c.webp"
"MediaSize" => 118863
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-48e2fa649ba27533725e8c071c07c68c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29836075_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/770c30ace486b5aaf9fe07d444290972.webp"
"MediaSize" => 148449
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-770c30ace486b5aaf9fe07d444290972.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29836075_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/1c641e2a7224ea48d9ab363e4635730c.webp"
"MediaSize" => 129241
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-1c641e2a7224ea48d9ab363e4635730c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29836075_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/01409d68be6f67d6a6f248c452d2239f.webp"
"MediaSize" => 129577
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-01409d68be6f67d6a6f248c452d2239f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29836075_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/51b2cc770f3ee14646da742835d9e7c8.webp"
"MediaSize" => 142702
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-51b2cc770f3ee14646da742835d9e7c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29836075_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/ca91577564457be3e56fd85f0195adba.webp"
"MediaSize" => 92177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-ca91577564457be3e56fd85f0195adba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29836075_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/55c198351e72f9e844ad0d48cc73eee6.webp"
"MediaSize" => 125842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-55c198351e72f9e844ad0d48cc73eee6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29836075_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/c27cd3cd043c84869a94935df29dccd7.webp"
"MediaSize" => 120479
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-c27cd3cd043c84869a94935df29dccd7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29836075_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/b97449e450d8e22ddf6e1822d3ef567a.webp"
"MediaSize" => 120603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-b97449e450d8e22ddf6e1822d3ef567a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29836075_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/a1fb569c96f8e2f7799ef866991e0d77.webp"
"MediaSize" => 85922
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-a1fb569c96f8e2f7799ef866991e0d77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29836075_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/d296c1cb28de90af8d4b2063616ebdf6.webp"
"MediaSize" => 111294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-d296c1cb28de90af8d4b2063616ebdf6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29836075_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/6c6c6f6b22e1acc4768566a821fe1fdb.webp"
"MediaSize" => 99523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-6c6c6f6b22e1acc4768566a821fe1fdb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29836075_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/111fe0dd03cc29b5c79441a2eca69902.webp"
"MediaSize" => 77371
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-111fe0dd03cc29b5c79441a2eca69902.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29836075_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/6d5e80e82ae82ca97d12daa391762326.webp"
"MediaSize" => 102987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-6d5e80e82ae82ca97d12daa391762326.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29836075_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/14e4c187c2be6f0d7cc7f71e1a30c49d.webp"
"MediaSize" => 87098
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-14e4c187c2be6f0d7cc7f71e1a30c49d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29836075_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/270c85ce5989d84cea5bf65d24107884.webp"
"MediaSize" => 103782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-270c85ce5989d84cea5bf65d24107884.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29836075_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/7d499984640017cf5c61f83241199ef6.webp"
"MediaSize" => 194413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-7d499984640017cf5c61f83241199ef6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29836075_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/529e73dfb38c8b1f26711403b003722f.webp"
"MediaSize" => 133311
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-529e73dfb38c8b1f26711403b003722f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29836075_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/b4280a4762cff8e0cfd077558a7b26cf.webp"
"MediaSize" => 218176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-b4280a4762cff8e0cfd077558a7b26cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29836075_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/a199f8fb927ad4cba5e4e4732fcf04cb.webp"
"MediaSize" => 229526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-a199f8fb927ad4cba5e4e4732fcf04cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29836075_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/2a79f9710d0c234d9e8d36db705b0971.webp"
"MediaSize" => 223139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-2a79f9710d0c234d9e8d36db705b0971.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29836075_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/91b969f7d3c23f146783315464f0d739.webp"
"MediaSize" => 312995
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-91b969f7d3c23f146783315464f0d739.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29836075_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/a2bb90f78532ba0ee8b3bc5a774278dc.webp"
"MediaSize" => 313890
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-a2bb90f78532ba0ee8b3bc5a774278dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29836075_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/61db5f48dca264093bfbb27d136dd904.webp"
"MediaSize" => 277248
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-61db5f48dca264093bfbb27d136dd904.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29836075_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/5024a8c8c3703e9a57d15e02718387d8.webp"
"MediaSize" => 214399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-5024a8c8c3703e9a57d15e02718387d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29836075_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/c78de661040bc72ae33df695190e1532.webp"
"MediaSize" => 226221
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-c78de661040bc72ae33df695190e1532.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29836075_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/27d2ff8414619333ad370d869495db3a.webp"
"MediaSize" => 222024
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-27d2ff8414619333ad370d869495db3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29836075_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/a7e6230d0945ecf8c11db93c97c56184.webp"
"MediaSize" => 241894
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-a7e6230d0945ecf8c11db93c97c56184.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29836075_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/91dd0666f62de7ff8db59c0a2261c689.webp"
"MediaSize" => 303974
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-91dd0666f62de7ff8db59c0a2261c689.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29836075_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/2bedd3996c1d08ca4eff494943f9ebe6.webp"
"MediaSize" => 295604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-2bedd3996c1d08ca4eff494943f9ebe6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29836075_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/64558ec3da8b42462f7316ff2097b926.webp"
"MediaSize" => 292734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-64558ec3da8b42462f7316ff2097b926.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29836075_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/7d4e8caac0c3b8271fafd67d1efce708.webp"
"MediaSize" => 301379
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-7d4e8caac0c3b8271fafd67d1efce708.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29836075_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/d073a1092e706f197bf75e8c7eb0f62c.webp"
"MediaSize" => 278497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-d073a1092e706f197bf75e8c7eb0f62c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "29836075_4890_49"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/b469aa324a0235dec076da1371d387ea.webp"
"MediaSize" => 301422
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-b469aa324a0235dec076da1371d387ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
49 => array:13 [
"Order" => 50
"MediaKey" => "29836075_4890_50"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836075/41852afecced857ef4ae511d29d11153.webp"
"MediaSize" => 301614
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836075/thumbnail-41852afecced857ef4ae511d29d11153.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224622"
"ResourceRecordKey" => "29836075"
"ModificationTimestamp" => "2026-06-01T21:15:23.61Z"
]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29836075')"
+"ID": "1482670"
}
]
+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 50932" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24708
+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 2002601" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24793
+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 '29836075'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25123
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29836075'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25199
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29836075' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.577922 43.458536)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25157
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25151
+post_id: "1503934"
+post_author: 1
+"ListingKey": "29866488"
+"ListingId": "X13411076"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-07T00:20:08Z"
+"RFModificationTimestamp": "2026-06-07T00:31:18Z"
+"ListPrice": 999999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V1"
+"UnparsedAddress": "505 YORKSHIRE DRIVE, Waterloo, Ontario N2T2V1"
+"Coordinates": array:2 [
0 => -80.572546
1 => 43.456625
]
+"Latitude": 43.456625
+"Longitude": -80.572546
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful custom built house in Upper Beechwood! Beautiful 18ft cathedral ceilings on the main level with an open concept, and a lovely library/office at the front of house. The kitchen has a breakfast bar, and sliders to a huge fully fenced backyard. Upstairs you will find 3 bedrooms with new flooring, no carpet. All generously sized bedroom, with a master bedroom featuring a large walk-in closet and a 4-piece en-suite. Bright basement offers a large family/rec room with a 4-piece bathroom and 2 more bedrooms. Walking distance to all amenities: parks, shops, cafes and both universities. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-06T21:12:01.898240+00:00"
+"Directions": "Erbsville Rd & Keats way"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2183926"
+"ListOfficeKey": "284345"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "Carpet Free"
2 => "Sump Pump"
]
+"LotSizeDimensions": "50.1 x 163.9 FT ; 169.75ftx50.42ftx163.90ftx50.08ft"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-07T00:12:12Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-07T00:12:12Z"
+"Stories": "2.0"
+"StreetName": "Yorkshire"
+"StreetNumber": "505"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7124"
+"VirtualTourURLUnbranded": "https://show.youriguide.com/OuOhKXjx-NXdHHae7aK"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1653641368"
"RoomType" => "Eating area"
"ListingId" => "X13411076"
"RoomLevel" => "Main level"
"RoomWidth" => 2.19
"ListingKey" => "29866488"
"RoomLength" => 4.94
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.21Z"
]
1 => array:11 [
"RoomKey" => "1653641369"
"RoomType" => "Den"
"ListingId" => "X13411076"
"RoomLevel" => "Basement"
"RoomWidth" => 1.83
"ListingKey" => "29866488"
"RoomLength" => 2.41
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.21Z"
]
2 => array:11 [
"RoomKey" => "1653641370"
"RoomType" => "Bedroom"
"ListingId" => "X13411076"
"RoomLevel" => "Basement"
"RoomWidth" => 2.62
"ListingKey" => "29866488"
"RoomLength" => 3.23
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.21Z"
]
3 => array:11 [
"RoomKey" => "1653641371"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13411076"
"RoomLevel" => "Basement"
"RoomWidth" => 6.38
"ListingKey" => "29866488"
"RoomLength" => 10.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.21Z"
]
4 => array:11 [
"RoomKey" => "1653641372"
"RoomType" => "Dining room"
"ListingId" => "X13411076"
"RoomLevel" => "Main level"
"RoomWidth" => 5.33
"ListingKey" => "29866488"
"RoomLength" => 4.85
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.21Z"
]
5 => array:11 [
"RoomKey" => "1653641373"
"RoomType" => "Kitchen"
"ListingId" => "X13411076"
"RoomLevel" => "Main level"
"RoomWidth" => 4.11
"ListingKey" => "29866488"
"RoomLength" => 4.94
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.21Z"
]
6 => array:11 [
"RoomKey" => "1653641374"
"RoomType" => "Living room"
"ListingId" => "X13411076"
"RoomLevel" => "Main level"
"RoomWidth" => 3.99
"ListingKey" => "29866488"
"RoomLength" => 5.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.22Z"
]
7 => array:11 [
"RoomKey" => "1653641375"
"RoomType" => "Office"
"ListingId" => "X13411076"
"RoomLevel" => "Main level"
"RoomWidth" => 4.24
"ListingKey" => "29866488"
"RoomLength" => 3.02
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.22Z"
]
8 => array:11 [
"RoomKey" => "1653641376"
"RoomType" => "Laundry room"
"ListingId" => "X13411076"
"RoomLevel" => "Main level"
"RoomWidth" => 2.13
"ListingKey" => "29866488"
"RoomLength" => 2.32
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.22Z"
]
9 => array:11 [
"RoomKey" => "1653641377"
"RoomType" => "Bedroom"
"ListingId" => "X13411076"
"RoomLevel" => "Second level"
"RoomWidth" => 6.86
"ListingKey" => "29866488"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.22Z"
]
10 => array:11 [
"RoomKey" => "1653641378"
"RoomType" => "Bedroom 2"
"ListingId" => "X13411076"
"RoomLevel" => "Second level"
"RoomWidth" => 5.97
"ListingKey" => "29866488"
"RoomLength" => 3.4
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.22Z"
]
11 => array:11 [
"RoomKey" => "1653641379"
"RoomType" => "Bedroom 3"
"ListingId" => "X13411076"
"RoomLevel" => "Second level"
"RoomWidth" => 3.71
"ListingKey" => "29866488"
"RoomLength" => 3.33
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.22Z"
]
12 => array:11 [
"RoomKey" => "1653641380"
"RoomType" => "Bedroom"
"ListingId" => "X13411076"
"RoomLevel" => "Basement"
"RoomWidth" => 3.76
"ListingKey" => "29866488"
"RoomLength" => 2.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.22Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29866488/505-yorkshire-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 50.1
+"OriginalEntryTimestamp": "2026-06-06T19:46:17.01Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1433591"
+"ListOfficeNationalAssociationId": "1340429"
+"Media": array:43 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29866488_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/c5076093e65d5e2ea48bfa85718e7ca3.webp"
"MediaSize" => 412910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-c5076093e65d5e2ea48bfa85718e7ca3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T19:46:17.02Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29866488_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/916decdde3da11d81fcbfbe8e6bd9865.webp"
"MediaSize" => 122829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-916decdde3da11d81fcbfbe8e6bd9865.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T19:46:17.02Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29866488_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/5b4bc933fad66984329e3b82211e0410.webp"
"MediaSize" => 216364
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-5b4bc933fad66984329e3b82211e0410.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T19:46:17.02Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29866488_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/d2348c638d11fe43ae03a39c50b2ff00.webp"
"MediaSize" => 272980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-d2348c638d11fe43ae03a39c50b2ff00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T19:46:17.02Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29866488_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/f867af46aa975220ea28ed9ee7a7c924.webp"
"MediaSize" => 183998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-f867af46aa975220ea28ed9ee7a7c924.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T19:46:17.02Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29866488_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/26d41448dbdb7bc90a5d5a9d37279279.webp"
"MediaSize" => 157670
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-26d41448dbdb7bc90a5d5a9d37279279.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T19:46:17.02Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29866488_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/1951d25108594d78e6599e2598736fae.webp"
"MediaSize" => 145737
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-1951d25108594d78e6599e2598736fae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T19:46:17.02Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29866488_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/85006860163a8433f895be48be37ce8a.webp"
…10
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29866488')"
+"ID": "1503934"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25153
+post_id: "1500897"
+post_author: 1
+"ListingKey": "29861301"
+"ListingId": "X13248618"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T17:40:54Z"
+"RFModificationTimestamp": "2026-06-05T18:43:54Z"
+"ListPrice": 514900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2K9"
+"UnparsedAddress": "32 - 589 BEECHWOOD DRIVE N, Waterloo, Ontario N2T2K9"
+"Coordinates": array:2 [
0 => -80.565587
1 => 43.448962
]
+"Latitude": 43.448962
+"Longitude": -80.565587
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Experience the ultimate Waterloo location! This updated 3-bedroom, 2-bathroom condo townhouse offers a perfect blend of lifestyle and investment potential. Situated less than 10 minutes from both the University of Waterloo and Wilfrid Laurier, you are also ideally located near top-tier elementary schools. Enjoy unparalleled convenience with easy access to banking, groceries, Costco, and the vibrant shopping and dining at The Boardwalk. Inside, you will find a carpet-free main level featuring rich hardwood floors and a bright living room anchored by a stunning floor-to-ceiling fireplace and TV mount. The functional kitchen includes a cozy breakfast area that overlooks the main living space, perfect for entertaining. Step through the walk-out to your private backyard and BBQ area-a peaceful retreat with no rear neighbours for added privacy. With a fully finished basement recreation room, low condo fees, and visitor parking nearby, this is a rare opportunity to move in and add your personal touch to a home in a prime, high-demand area. Arrange your visit today! (id:62783)"
+"ArchitecturalStyle": array:1 [
0 => "Multi-level"
]
+"AssociationFee": "351.44"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T18:43:32.311058+00:00"
+"Directions": "ERBSVILLE CRT AND ERBS ST W"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Ceramic"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1532767"
+"ListOfficeKey": "269704"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-05T17:33:11Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T17:33:11Z"
+"StreetDirSuffix": "North"
+"StreetName": "Beechwood"
+"StreetNumber": "589"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3072.43"
+"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"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29861301/32-589-beechwood-drive-n-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "LEE MANAGEMENT"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-05T17:33:11.51Z"
+"ListAgentNationalAssociationId": "1142786"
+"ListOfficeNationalAssociationId": "1233633"
+"Media": array:12 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29861301')"
+"ID": "1500897"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25150
+post_id: "1495724"
+post_author: 1
+"ListingKey": "29856070"
+"ListingId": "40830420"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T16:26:09Z"
+"RFModificationTimestamp": "2026-06-05T16:30:15Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2667.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2M3"
+"UnparsedAddress": "743 BUTTERNUT Avenue, Waterloo, Ontario N2V2M3"
+"Coordinates": array:2 [
0 => -80.5881761
1 => 43.4661322
]
+"Latitude": 43.4661322
+"Longitude": -80.5881761
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Loaction! Loacation!! Location!!! Located in the desirable Clair Hills community, Vista Hill PS and Laurel Height SS. This beautifully maintained home offers a double-car garage and an extended front walkway, providing both enhanced curb appeal and everyday convenience. The welcoming main level features a versatile front room that can serve as a home office, living room, or dining area, while upgraded waterproof flooring extends throughout the above-grade living space. Enjoy the spacious family room with nearly 9-foot ceilings, creating an open and comfortable atmosphere. The modern kitchen is equipped with quartz countertops, a large centre island, stylish backsplash, and a bright breakfast area with walkout access to the backyard, where a generous two-tier deck offers exceptional outdoor living and entertaining space. Upstairs, you'll find four well-sized bedrooms, two full bathrooms, a convenient laundry room, and an L-shaped staircase designed for added comfort and safety. The expansive primary suite features a private ensuite with a separate shower and soaker tub, while the three additional bedrooms provide excellent space for family or guests. The professionally finished basement offers distinct living areas, including a dedicated home theatre and a large recreation room, providing flexible space for entertainment, fitness, or family activities. Move-in ready and thoughtfully designed throughout, this home combines comfort, functionality, and an outstanding location. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T20:42:44.351317+00:00"
+"Directions": "From Erbsville heading North out of town, turn left on Columbia Forest then right on Butternut"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2073939"
+"ListOfficeKey": "253316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-04T20:11:34Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T16:11:54Z"
+"Stories": "2.0"
+"StreetName": "BUTTERNUT"
+"StreetNumber": "743"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5932"
+"VirtualTourURLUnbranded": "https://youtu.be/oYIjf4okJ_A"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29856070/743-butternut-avenue-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 2047
+"BelowGradeFinishedArea": 620
+"OriginalEntryTimestamp": "2026-06-04T20:11:34.21Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1349103"
+"ListOfficeNationalAssociationId": "1223329"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29856070')"
+"ID": "1495724"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25154
+post_id: "1494892"
+post_author: 1
+"ListingKey": "29854661"
+"ListingId": "X13241212"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T17:25:55Z"
+"RFModificationTimestamp": "2026-06-05T17:30:01Z"
+"ListPrice": 950000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N8"
+"UnparsedAddress": "670 SALZBURG DRIVE, Waterloo, Ontario N2V2N8"
+"Coordinates": array:2 [
0 => -80.586439
1 => 43.462061
]
+"Latitude": 43.462061
+"Longitude": -80.586439
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "The Holy Grail of Retirement Bungalows with a PRICELESS VIEW! Modern-built, freehold (no condo fees!), and backing onto the serene Rosewood Pond in Waterloo's coveted Clair Hills community - this rare walkout bungalow blends elegance, comfort, and true accessibility in one perfect package. Freshly painted and updated with new carpet, it's completely move-in ready. Featuring 2+1 bedrooms, 3 bathrooms, and nearly 2,000 sq. ft. of beautifully finished living space, this home offers both style and ease. The open-concept main floor showcases rich maple hardwood and ceramic tile, flowing naturally to a raised deck with glass railings - where you'll enjoy the definition of a million-dollar view. The spacious primary suite overlooks the water and includes a private 4-piece ensuite, while the second bedroom with built-in Murphy bed easily converts to a guest room or home office. The bright walkout basement features oversized windows, a cozy gas fireplace, and direct yard access - perfect for entertaining or quiet mornings by the water. A third bedroom with ensuite privileges and large storage area complete the lower level. Built with accessibility in mind, this home includes widened doorways, lowered switches, and modern mechanical systems. Add a double garage, quiet low-traffic street, and peaceful pond-side setting, and you have effortless living at its finest. Homes offering this combination of location, quality, and accessibility are seldom available. This is the perfect combination for those looking to downsize. Don't miss your chance to call Rosewood Estates home! (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T18:42:42.513496+00:00"
+"Directions": "Columbia to Salzburg Drive"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100955"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "45 x 118.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-04T17:59:37Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T16:57:37Z"
+"Stories": "1.0"
+"StreetName": "Salzburg"
+"StreetNumber": "670"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5864"
+"VirtualTourURLUnbranded": "https://youriguide.com/670_salzburg_drive_waterloo_on/"
+"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": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29854661/670-salzburg-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-04T17:59:37.17Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1370979"
+"ListOfficeNationalAssociationId": "1369645"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29854661')"
+"ID": "1494892"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25152
+post_id: "1494914"
+post_author: 1
+"ListingKey": "29853961"
+"ListingId": "40826844"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T15:40:55Z"
+"RFModificationTimestamp": "2026-06-05T15:47:27Z"
+"ListPrice": 950000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.12
+"LivingArea": 1983.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N8"
+"UnparsedAddress": "670 SALZBURG Drive, Waterloo, Ontario N2V2N8"
+"Coordinates": array:2 [
0 => -80.5864412
1 => 43.4620439
]
+"Latitude": 43.4620439
+"Longitude": -80.5864412
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "The Holy Grail of Retirement Bungalows with PRICELESS VIEW! Modern-built, freehold (no condo fees!), and backing onto the serene Rosewood Pond in Waterloo’s coveted Clair Hills community — this rare walkout bungalow blends elegance, comfort, and true accessibility in one perfect package. Freshly painted and updated with new carpet, it’s completely move-in ready. Featuring 2+1 bedrooms, 3 bathrooms, and nearly 2,000 sq. ft. of beautifully finished living space, this home offers both style and ease. The open-concept main floor showcases rich maple hardwood and ceramic tile, flowing naturally to a raised deck with glass railings — where you’ll enjoy the definition of a million-dollar view. The spacious primary suite overlooks the water and includes a private 4-piece en-suite, while the second bedroom with built-in Murphy bed easily converts to a guest room or home office. The bright walkout basement features oversized windows, a cozy gas fireplace, and direct yard access — perfect for entertaining or quiet mornings by the water. A third bedroom with en-suite privileges and large storage area complete the lower level. Built with accessibility in mind, this home includes widened doorways, lowered switches, and modern mechanical systems. Add a double garage, quiet low-traffic street, and peaceful pond-side setting, and you have effortless living at its finest. Homes offering this combination of location, quality, and accessibility are seldom available. This is the perfect combination for those looking to downsize. Don’t miss your chance to call Rosewood Estates home! (id:62650)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T18:35:29.064556+00:00"
+"Directions": "Columbia to Salzburg Drive"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564479"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-04T16:52:02Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T15:34:26Z"
+"Stories": "1.0"
+"StreetName": "SALZBURG"
+"StreetNumber": "670"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5446"
+"VirtualTourURLUnbranded": "https://youriguide.com/670_salzburg_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29853961/670-salzburg-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1223
+"BelowGradeFinishedArea": 760
+"OriginalEntryTimestamp": "2026-06-04T16:52:02.49Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1125580"
+"ListOfficeNationalAssociationId": "1380559"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29853961')"
+"ID": "1494914"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25147
+post_id: "1492859"
+post_author: 1
+"ListingKey": "29851264"
+"ListingId": "X13237998"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-04T03:40:53Z"
+"RFModificationTimestamp": "2026-06-04T04:03:40Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1A3"
+"UnparsedAddress": "13 GATEVIEW DRIVE, Waterloo, Ontario N2T1A3"
+"Coordinates": array:2 [
0 => -80.558439
1 => 43.450269
]
+"Latitude": 43.450269
+"Longitude": -80.558439
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome Home. This beautiful and bright home features 4-bedroom, 4-bathroom with approximately 3,000 sq. ft. of living space designed for growing families and those who love to entertain. Perfectly positioned in a convenient location close to schools, parks, shopping, and everyday amenities, this home combines space, function, and timeless curb appeal. Step inside to discover a bright, welcoming interior filled with natural light throughout the day, creating a warm and inviting atmosphere across every level. Thoughtfully updated with major recent improvements including the roof, furnace, and air conditioning, this home provides peace of mind while offering exceptional comfort year-round. Outside, the impressive backyard retreat is highlighted by a stunning newer deck and professionally crafted armourstone retaining wall, creating the perfect setting for outdoor gatherings, relaxing evenings, or family enjoyment. Located in one of Waterloo's most desirable family-friendly communities, 13 Gateview Drive offers the rare opportunity to own a spacious, move-in-ready home in Westvale where pride of ownership is evident inside and out. Don't forget to check out the large shed or shop at the side of the property. A perfect blend of thoughtful updates, generous living space, and an unbeatable location. (id:66098)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Water softener"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Garage door opener"
7 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T04:03:34.064484+00:00"
+"Directions": "Cross Streets: Erb & Gateview. ** Directions: Erb to Gateview."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2255605"
+"ListOfficeKey": "285253"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Sump Pump"
]
+"LotSizeDimensions": "47.5 x 115 FT ; see geo"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-04T03:31:55Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-04T03:31:55Z"
+"Stories": "2.0"
+"StreetName": "Gateview"
+"StreetNumber": "13"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5803.48"
+"VirtualTourURLUnbranded": "https://youriguide.com/13_gateview_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "OnePoint"
+"TaxYear": 2025
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29851264/13-gateview-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 47.6
+"OriginalEntryTimestamp": "2026-06-04T03:31:55.13Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1494689"
+"ListOfficeNationalAssociationId": "1349485"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29851264')"
+"ID": "1492859"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23345
+post_id: "1490753"
+post_author: 1
+"ListingKey": "29847603"
+"ListingId": "40829482"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-03T22:20:52Z"
+"RFModificationTimestamp": "2026-06-03T22:22:04Z"
+"ListPrice": 829000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2337.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2T5"
+"UnparsedAddress": "435 SPECKLED ALDER Street, Waterloo, Ontario N2V2T5"
+"Coordinates": array:2 [
0 => -80.5941368
1 => 43.4689249
]
+"Latitude": 43.4689249
+"Longitude": -80.5941368
+"YearBuilt": 2004
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This elegant, carpet-free family home in the prestigious Laurel Creek neighborhood offers a perfect blend of modern comfort and unbeatable convenience, with Costco, the YMCA, and the local library all situated within a 5-minute drive. The bright, open-concept interior features three spacious bedrooms, a fully finished basement with a large recreation room, and a fresh coat of paint throughout. Ideally positioned for families and investors alike, the property is steps away from top-rated schools like Abraham Erb P.S. and Laurel Heights S.S., and just minutes from both UW and WLU. Boasting a double driveway and extensive recent upgrades—including a new furnace (2025), washer/dryer (2024), dishwasher (2023), fridge (2022), and roof (2021)—this stunning, move-in-ready home is designed for effortless contemporary living. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-03T18:57:35.796318+00:00"
+"Directions": "Laurelwood Drive to Blue Beech Blvd"
+"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": "2081146"
+"ListOfficeKey": "253316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-03T22:20:27Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-03T22:20:26Z"
+"Stories": "2.0"
+"StreetName": "SPECKLED ALDER"
+"StreetNumber": "435"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4769.43"
+"VirtualTourURLUnbranded": "https://youriguide.com/8tiga_435_speckled_alder_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29847603/435-speckled-alder-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "50-R5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1647
+"BelowGradeFinishedArea": 690
+"OriginalEntryTimestamp": "2026-06-03T17:51:38.89Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1355928"
+"ListOfficeNationalAssociationId": "1223329"
+"Media": array:29 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29847603')"
+"ID": "1490753"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25155
+post_id: "1489104"
+post_author: 1
+"ListingKey": "29844777"
+"ListingId": "40835157"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T20:30:49Z"
+"RFModificationTimestamp": "2026-06-06T20:47:39Z"
+"ListPrice": 899999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1817.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2M3"
+"UnparsedAddress": "784 BUTTERNUT Avenue, Waterloo, Ontario N2V2M3"
+"Coordinates": array:2 [
0 => -80.5893984
1 => 43.4655833
]
+"Latitude": 43.4655833
+"Longitude": -80.5893984
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful move-in-ready 2 storey home in Waterloo’s highly sought-after Columbia Forest neighbourhood. Ideally located just minutes from the city’s largest natural walking trails, the Boardwalk shopping district, top-rated public schools, and both of Waterloo’s renowned universities, this location is perfect for the growing family. This charming 3+1 bedroom, 4-bathroom home offers over 1,700 square feet of finished living space, providing plenty of room for families both inside and outside of the home. Step outside and create lasting memories in your private backyard oasis, featuring mature trees, lush gardens, a dedicated dining area and your very own hot tub. The finished basement adds versatile living space and is the perfect setting for family recreation, an additional bedroom, or a home office. Recent improvements over the last few years include a new roof, full window replacement, new furnace and kitchen renovation. Don’t miss this rare opportunity to own a well-maintained home in one of Waterloo’s most desirable communities. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Tudor"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-03T16:03:35.919356+00:00"
+"Directions": "COL.FT/STAR FLOWER"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2061846"
+"ListOfficeKey": "284641"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0"
+"PhotosChangeTimestamp": "2026-06-03T11:59:28Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T20:21:36Z"
+"Stories": "2.0"
+"StreetName": "BUTTERNUT"
+"StreetNumber": "784"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4943.2"
+"Utilities": array:1 [
0 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29844777/784-butternut-avenue-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2217406"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "54949"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 44.0
+"AboveGradeFinishedArea": 1238
+"BelowGradeFinishedArea": 579
+"OriginalEntryTimestamp": "2026-06-03T11:59:27.95Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1336875"
+"ListOfficeNationalAssociationId": "1344650"
+"CoListAgentNationalAssociationId": "1463083"
+"CoListOfficeNationalAssociationId": "1003557"
+"Media": array:33 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29844777')"
+"ID": "1489104"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25156
+post_id: "1489105"
+post_author: 1
+"ListingKey": "29846036"
+"ListingId": "40836230"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-03T15:31:15Z"
+"RFModificationTimestamp": "2026-06-03T15:53:35Z"
+"ListPrice": 85000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 667.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3Z4"
+"UnparsedAddress": "580 BEAVER CREEK Road Unit# 203, Waterloo, Ontario N2J3Z4"
+"Coordinates": array:2 [
0 => -80.5822901
1 => 43.471847
]
+"Latitude": 43.471847
+"Longitude": -80.5822901
+"YearBuilt": 1992
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome Unit 203 in one of Waterloo's most established and beautifully maintained land-lease communities Green Acres Park! This modular home offers open-concept living, Step outside to your spacious private decks, perfect for morning coffee or summer BBQs surrounded by friendly neighbors. Green Acre Park features a community swimming pool, a game room, a catch and release fishing pond for plenty of outdoor activities. Enjoy resort-style amenities, peaceful surroundings, and low yearly carrying costs. Annual Park fees approx. $9,800-$11,200 + HST includes water & taxes (park closed Jan & Feb). Park approval required for all purchases. Enjoy the comforts of 10-month seasonal living (park closed Jan & Feb) with a turnkey home, surrounded by nature, old growth trees and a spacious lot. Call and book your appointment today!! (id:62650)"
+"Appliances": array:2 [
0 => "Refrigerator"
1 => "Gas stove(s)"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-06-03T15:53:26.359142+00:00"
+"Directions": "FROM NORTHFIELD EXIT-WEST ON NORTHFIELD DR., NORTH ON WESTMOUNT RD N. WEST ON CONSERVATION DR.,"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "None"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1860816"
+"ListOfficeKey": "76831"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Recreational"
]
+"PhotosChangeTimestamp": "2026-06-03T15:20:35Z"
+"PhotosCount": 12
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-03T15:20:35Z"
+"Stories": "1.0"
+"StreetName": "BEAVER CREEK"
+"StreetNumber": "580"
+"StreetSuffix": "Road"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29846036/580-beaver-creek-road-unit-203-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Mobile Home"
]
+"CommonInterest": "Leasehold"
+"GeocodeManualYN": true
+"ZoningDescription": "Rec"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 667
+"OriginalEntryTimestamp": "2026-06-03T15:20:35.35Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1200804"
+"ListOfficeNationalAssociationId": "1004391"
+"Media": array:12 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29846036')"
+"ID": "1489105"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 116
+after_key: ""
}
"RF Response Time" => "0.36 seconds"
]
]