array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29866488 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: "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"
"MediaSize" => 178969
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-85006860163a8433f895be48be37ce8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T19:46:17.02Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29866488_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/3d9127b4d24f0a9e5486ef2894d49566.webp"
"MediaSize" => 214360
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-3d9127b4d24f0a9e5486ef2894d49566.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T19:46:17.02Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29866488_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/04b8a80600ad8010ba1eacc94651f2b3.webp"
"MediaSize" => 172181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-04b8a80600ad8010ba1eacc94651f2b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T19:46:17.02Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29866488_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/cea328065e4bf4dc906e83ba880f8bb6.webp"
"MediaSize" => 194831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-cea328065e4bf4dc906e83ba880f8bb6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T19:46:17.02Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29866488_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/2131a7f471c5a156646e58e74b7ecb18.webp"
"MediaSize" => 159922
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-2131a7f471c5a156646e58e74b7ecb18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T19:46:17.02Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29866488_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/e013b7bdf0ec7f991b4914759f5dc8f6.webp"
"MediaSize" => 155743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-e013b7bdf0ec7f991b4914759f5dc8f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T19:46:17.02Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29866488_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/fc913fbea3c393520cb1618c36659ee0.webp"
"MediaSize" => 190027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-fc913fbea3c393520cb1618c36659ee0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:15.9Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29866488_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/954cb08a944dfbcbf9a73ad3c5610be3.webp"
"MediaSize" => 159051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-954cb08a944dfbcbf9a73ad3c5610be3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:16.15Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29866488_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/f14dd0b8a9a5f14f27280668d1c391da.webp"
"MediaSize" => 111486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-f14dd0b8a9a5f14f27280668d1c391da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:15.89Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29866488_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/1baed19860f48e9cfa01f41fdb943c2b.webp"
"MediaSize" => 116873
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-1baed19860f48e9cfa01f41fdb943c2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:16.15Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29866488_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/353a20d3b5fdf1b280af3e1b26062ed3.webp"
"MediaSize" => 146028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-353a20d3b5fdf1b280af3e1b26062ed3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:15.9Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29866488_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/a8ae8df315f4d9d45281c80466ce0443.webp"
"MediaSize" => 127215
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-a8ae8df315f4d9d45281c80466ce0443.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:16.62Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29866488_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/865251a30f318b61811fd581b16f0cf4.webp"
"MediaSize" => 117407
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-865251a30f318b61811fd581b16f0cf4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:16.29Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29866488_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/58e004e000027dfbcdaa9a9549fe433c.webp"
"MediaSize" => 94458
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-58e004e000027dfbcdaa9a9549fe433c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:16.71Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29866488_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/e52f049ff370d19e1a918ca48bd769f5.webp"
"MediaSize" => 121910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-e52f049ff370d19e1a918ca48bd769f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:16.97Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29866488_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/a1a3802b967c39893e88bf91872babb6.webp"
"MediaSize" => 122539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-a1a3802b967c39893e88bf91872babb6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:17Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29866488_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/b7e8a74fbf88277360afb540400936ea.webp"
"MediaSize" => 114824
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-b7e8a74fbf88277360afb540400936ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:17Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29866488_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/06f5eabff43a7e18feae0718684ef95a.webp"
"MediaSize" => 101500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-06f5eabff43a7e18feae0718684ef95a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:17.39Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29866488_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/c457cc62af59356ed8698b1716bbbaf0.webp"
"MediaSize" => 118542
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-c457cc62af59356ed8698b1716bbbaf0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:18.92Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29866488_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/5e0c6d2b03fa19fd15e3f87d33da50d4.webp"
"MediaSize" => 123085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-5e0c6d2b03fa19fd15e3f87d33da50d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:19.45Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29866488_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/01714f381fc999ec7c569d8d5861f045.webp"
"MediaSize" => 88489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-01714f381fc999ec7c569d8d5861f045.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:19.51Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29866488_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/9ddc8b168139dc6a9c42767d67398142.webp"
"MediaSize" => 74802
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-9ddc8b168139dc6a9c42767d67398142.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:19.5Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29866488_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/2370056dac3fd36b1d1879820d3486dc.webp"
"MediaSize" => 64910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-2370056dac3fd36b1d1879820d3486dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:19.52Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29866488_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/7016d1205f4973d981c88f032983eccd.webp"
"MediaSize" => 98816
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-7016d1205f4973d981c88f032983eccd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:19.36Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29866488_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/a28aee63cdd4bd899fca403f5d1abdf1.webp"
"MediaSize" => 89174
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-a28aee63cdd4bd899fca403f5d1abdf1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:19.47Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29866488_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/564ac7fb640402c054c112cf462b1107.webp"
"MediaSize" => 79443
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-564ac7fb640402c054c112cf462b1107.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:19.64Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29866488_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/942e4fc677d681d7bb07d57379b86893.webp"
"MediaSize" => 72074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-942e4fc677d681d7bb07d57379b86893.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:19.66Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29866488_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/2be42d1ff3f801b33e2c26aaaed2de1b.webp"
"MediaSize" => 96184
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-2be42d1ff3f801b33e2c26aaaed2de1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:19.51Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29866488_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/fc3c75e236debd9866ceedfa3016308d.webp"
"MediaSize" => 78609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-fc3c75e236debd9866ceedfa3016308d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:19.68Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29866488_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/192fa5c01182b283b7747808be0023ce.webp"
"MediaSize" => 84799
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-192fa5c01182b283b7747808be0023ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:18.85Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29866488_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/043467b0ee601ca1bc89ecdfd8deb71e.webp"
"MediaSize" => 95059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-043467b0ee601ca1bc89ecdfd8deb71e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:19.65Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29866488_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/c8c6488dfa020101fe56e77a35366faa.webp"
"MediaSize" => 542855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-c8c6488dfa020101fe56e77a35366faa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:19.73Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29866488_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/f566fa18c8acb01b491142866adb2e63.webp"
"MediaSize" => 544215
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-f566fa18c8acb01b491142866adb2e63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:19.9Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29866488_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/e9e6da82b857610dc6e72946d53d2391.webp"
"MediaSize" => 110837
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-e9e6da82b857610dc6e72946d53d2391.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:19.77Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29866488_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/81c453a0e3c2e2e9133b0d767f32d64b.webp"
"MediaSize" => 105721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-81c453a0e3c2e2e9133b0d767f32d64b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:19.4Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29866488_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29866488/16b80da82b35acbd0c7ae518a39bdc39.webp"
"MediaSize" => 102213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29866488/thumbnail-16b80da82b35acbd0c7ae518a39bdc39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411076"
"ResourceRecordKey" => "29866488"
"ModificationTimestamp" => "2026-06-06T23:46:19.86Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29866488')"
+"ID": "1503934"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 284345" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24694
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2183926" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24779
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29866488'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25102
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29866488'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25118
+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 '29866488' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.572546 43.456625)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25191
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25184
+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 [
"RoomKey" => "1652501964"
"RoomType" => "Den"
"ListingId" => "X13248618"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.45
"ListingKey" => "29861301"
"RoomLength" => 4.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T17:33:11.53Z"
]
1 => array:11 [
"RoomKey" => "1652501965"
"RoomType" => "Living room"
"ListingId" => "X13248618"
"RoomLevel" => "Main level"
"RoomWidth" => 3.5
"ListingKey" => "29861301"
"RoomLength" => 5.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T17:33:11.53Z"
]
2 => array:11 [
"RoomKey" => "1652501966"
"RoomType" => "Kitchen"
"ListingId" => "X13248618"
"RoomLevel" => "Second level"
"RoomWidth" => 5.2
"ListingKey" => "29861301"
"RoomLength" => 2.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T17:33:11.53Z"
]
3 => array:11 [
"RoomKey" => "1652501967"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13248618"
"RoomLevel" => "Third level"
"RoomWidth" => 3.1
"ListingKey" => "29861301"
"RoomLength" => 4.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T17:33:11.53Z"
]
4 => array:11 [
"RoomKey" => "1652501968"
"RoomType" => "Bedroom 2"
"ListingId" => "X13248618"
"RoomLevel" => "Third level"
"RoomWidth" => 2.3
"ListingKey" => "29861301"
"RoomLength" => 3.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T17:33:11.53Z"
]
5 => array:11 [
"RoomKey" => "1652501969"
"RoomType" => "Bedroom 3"
"ListingId" => "X13248618"
"RoomLevel" => "Third level"
"RoomWidth" => 3.6
"ListingKey" => "29861301"
"RoomLength" => 2.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T17:33:11.53Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29861301_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861301/3a3e1dae5f849b0b8b44a520659b95e1.webp"
"MediaSize" => 109596
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861301/thumbnail-3a3e1dae5f849b0b8b44a520659b95e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13248618"
"ResourceRecordKey" => "29861301"
"ModificationTimestamp" => "2026-06-05T17:33:11.51Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29861301_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861301/a30190f170619f36966ba5bae2358e7b.webp"
"MediaSize" => 131601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861301/thumbnail-a30190f170619f36966ba5bae2358e7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248618"
"ResourceRecordKey" => "29861301"
"ModificationTimestamp" => "2026-06-05T17:33:11.51Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29861301_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861301/d2da3b1883ba57c18a993265df7710e6.webp"
"MediaSize" => 79502
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861301/thumbnail-d2da3b1883ba57c18a993265df7710e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248618"
"ResourceRecordKey" => "29861301"
"ModificationTimestamp" => "2026-06-05T17:33:11.51Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29861301_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861301/001e14c6d1077c85b0d474260be80b0f.webp"
"MediaSize" => 115794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861301/thumbnail-001e14c6d1077c85b0d474260be80b0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248618"
"ResourceRecordKey" => "29861301"
"ModificationTimestamp" => "2026-06-05T17:33:11.51Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29861301_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861301/3e2a7d27239cd2717d97299d0e88b50b.webp"
"MediaSize" => 103312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861301/thumbnail-3e2a7d27239cd2717d97299d0e88b50b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248618"
"ResourceRecordKey" => "29861301"
"ModificationTimestamp" => "2026-06-05T17:33:11.51Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29861301_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861301/e6937bf70a3de70a4fbb39896eba4bc2.webp"
"MediaSize" => 114936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861301/thumbnail-e6937bf70a3de70a4fbb39896eba4bc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248618"
"ResourceRecordKey" => "29861301"
"ModificationTimestamp" => "2026-06-05T17:33:11.51Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29861301_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861301/d4eac5424a0a54ab1f7b6e1a5ae5cf7e.webp"
"MediaSize" => 98152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861301/thumbnail-d4eac5424a0a54ab1f7b6e1a5ae5cf7e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248618"
"ResourceRecordKey" => "29861301"
"ModificationTimestamp" => "2026-06-05T17:33:11.51Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29861301_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861301/0959fb81f6399c96dfb3c19157ab12af.webp"
"MediaSize" => 78452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861301/thumbnail-0959fb81f6399c96dfb3c19157ab12af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248618"
"ResourceRecordKey" => "29861301"
"ModificationTimestamp" => "2026-06-05T17:33:11.51Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29861301_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861301/6eb2201473a4539166532b3e39d365d1.webp"
"MediaSize" => 104469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861301/thumbnail-6eb2201473a4539166532b3e39d365d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248618"
"ResourceRecordKey" => "29861301"
"ModificationTimestamp" => "2026-06-05T17:33:11.51Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29861301_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861301/48f3833d65d710a2b113de6141227dd9.webp"
"MediaSize" => 72028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861301/thumbnail-48f3833d65d710a2b113de6141227dd9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
…4
]
10 => array:13 [ …13]
11 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29861301')"
+"ID": "1500897"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25187
+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"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25164
+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"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25188
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25186
+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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25161
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23345
+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"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25189
+post_id: "1488223"
+post_author: 1
+"ListingKey": "29844545"
+"ListingId": "40836178"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T19:45:21Z"
+"RFModificationTimestamp": "2026-06-05T19:48:55Z"
+"ListPrice": 589900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2250.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1Y9"
+"UnparsedAddress": "458 BEECHWOOD Place Unit# 6, Waterloo, Ontario N2T1Y9"
+"Coordinates": array:2 [
0 => -80.5580102
1 => 43.4523682
]
+"Latitude": 43.4523682
+"Longitude": -80.5580102
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Looking for a lifestyle change but you are not prepared to part with things like a main floor primary suite, double car garage, a rec room, your BBQ and plenty of living/storage space? Then take a closer look at 458 Beechwood Place Unit 6. The main floor provides you with large principle rooms, they are carpet free, there is loads of hardwood, vaulted ceilings, crown moulding, a gas fireplace, a king sized primary suite and an l-shapled bank of closets. From the kitchen or living room you can access the large terrace providing you with that space to sit back and relax in the outdoors. The open concept living/dining room with gas fireplace provides the home comfort that many desire with your eat in kitchen just steps away. There is ample cabinetry, and a small pantry with pull out drawers along with a secondary dining option. Need extra bedrooms or an office? The 2nd storey has a loft area plus two additional bedrooms, along with the 4 piece family bathroom. When you want that additional living space you venture down the rec room or on the other side of the laundry area there is a bonus room that can be used as a mud room or a craft/hobby area. You'll also find another full bathroom and the storage utility area. Deceiving large this condo has parking for 4 cars, is carpet free, access to the community pool and offers a flexible closing date. Please take a moment to view the marketing video and the 360 degree photography plus the floor plans. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Freezer"
7 => "Window Coverings"
]
+"AssociationFee": "775"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Water"
4 => "Insurance"
5 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-03T05:20:17.631178+00:00"
+"Directions": "Erb Street West To Beechwood Place"
+"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": "1750027"
+"ListOfficeKey": "280838"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-03T18:13:02Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T19:39:28Z"
+"Stories": "3.0"
+"StreetName": "BEECHWOOD"
+"StreetNumber": "458"
+"StreetSuffix": "Place"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "3699"
+"VirtualTourURLUnbranded": "https://youtu.be/LxpX-tpYD0Q"
+"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/29844545/458-beechwood-place-unit-6-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1888678"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "280838"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "MR150"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 1.0
+"AboveGradeFinishedArea": 1514
+"BelowGradeFinishedArea": 736
+"OriginalEntryTimestamp": "2026-06-03T04:30:47.65Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1174364"
+"ListOfficeNationalAssociationId": "1317747"
+"CoListAgentNationalAssociationId": "1210376"
+"CoListOfficeNationalAssociationId": "1317747"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29844545')"
+"ID": "1488223"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25190
+post_id: "1484173"
+post_author: 1
+"ListingKey": "29839173"
+"ListingId": "40835693"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T20:10:40Z"
+"RFModificationTimestamp": "2026-06-06T20:26:11Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3003.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1A3"
+"UnparsedAddress": "13 GATEVIEW Drive, Waterloo, Ontario N2T1A3"
+"Coordinates": array:2 [
0 => -80.5581298
1 => 43.4503821
]
+"Latitude": 43.4503821
+"Longitude": -80.5581298
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone 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:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Water softener"
2 => "Dishwasher"
3 => "Dryer"
4 => "Microwave"
5 => "Oven - Built-In"
6 => "Central Vacuum - Roughed In"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-02T16:46:50.171636+00:00"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2095939"
+"ListOfficeKey": "274404"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-02T15:01:44Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T20:01:38Z"
+"Stories": "2.0"
+"StreetName": "GATEVIEW"
+"StreetNumber": "13"
+"StreetSuffix": "Drive"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "5803.48"
+"Utilities": array:1 [
0 => "Natural Gas"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/13_gateview_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29839173/13-gateview-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 48.0
+"AboveGradeFinishedArea": 2083
+"BelowGradeFinishedArea": 920
+"OriginalEntryTimestamp": "2026-06-02T15:01:43.89Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1368109"
+"ListOfficeNationalAssociationId": "1254957"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29839173')"
+"ID": "1484173"
}
]
+success: true
+page_size: 9
+page_count: 12
+count: 102
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]