array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29895192 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23361
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23363
+post_id: "1524681"
+post_author: 1
+"ListingKey": "29895192"
+"ListingId": "X13436726"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T15:40:12Z"
+"RFModificationTimestamp": "2026-06-12T19:50:47Z"
+"ListPrice": 429900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5S7"
+"UnparsedAddress": "4 - 417 KEATS WAY, Waterloo, Ontario N2L5S7"
+"Coordinates": array:2 [
0 => -80.556684
1 => 43.457734
]
+"Latitude": 43.457734
+"Longitude": -80.556684
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Updated and spacious, this Beechwood, 3 bedroom, 2.5 bathroom townhouse offers approximately 1,600 square feet of comfortable living space in a highly desirable Waterloo location. Ideal for first-time buyers, families, or investors, the home features a bright, open living room with built-in shelving and elegant crown molding. Upstairs, you'll find a large primary bedroom with a walk-in closet, along with two additional generously sized bedrooms. The fully finished basement adds excellent flexibility with a large, versatile rec room, full bathroom, and laundry area. Set in a quiet complex with ample visitor parking and green space, this property is conveniently located close to everyday amenities, including two grocery stores within walking distance, major bus routes, the expressway, and both universities, including walking distance to the University of Waterloo. A well-kept, move-in-ready opportunity in a convenient and sought-after location. (id:62783)"
+"AssociationFee": "612"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:48:38.683182+00:00"
+"Directions": "Fischer-Hallman"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100955"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:3 [
0 => "Garage"
1 => "Carport"
2 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-12T15:30:32Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T15:30:32Z"
+"Stories": "2.0"
+"StreetName": "Keats"
+"StreetNumber": "417"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "3014"
+"VirtualTourURLUnbranded": "https://youriguide.com/4_417_keats_way_waterloo_on/"
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1657760648"
"RoomType" => "Dining room"
"ListingId" => "X13436726"
"RoomLevel" => "Second level"
"RoomWidth" => 2.74
"ListingKey" => "29895192"
"RoomLength" => 3.13
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T15:30:32.6Z"
]
1 => array:11 [
"RoomKey" => "1657760649"
"RoomType" => "Kitchen"
"ListingId" => "X13436726"
"RoomLevel" => "Second level"
"RoomWidth" => 2.38
"ListingKey" => "29895192"
"RoomLength" => 2.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T15:30:32.6Z"
]
2 => array:11 [
"RoomKey" => "1657760650"
"RoomType" => "Living room"
"ListingId" => "X13436726"
"RoomLevel" => "Second level"
"RoomWidth" => 3.52
"ListingKey" => "29895192"
"RoomLength" => 7.01
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T15:30:32.6Z"
]
3 => array:11 [
"RoomKey" => "1657760651"
"RoomType" => "Bedroom"
"ListingId" => "X13436726"
"RoomLevel" => "Third level"
"RoomWidth" => 3.22
"ListingKey" => "29895192"
"RoomLength" => 3.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T15:30:32.61Z"
]
4 => array:11 [
"RoomKey" => "1657760652"
"RoomType" => "Bedroom"
"ListingId" => "X13436726"
"RoomLevel" => "Third level"
"RoomWidth" => 2.59
"ListingKey" => "29895192"
"RoomLength" => 3.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T15:30:32.61Z"
]
5 => array:11 [
"RoomKey" => "1657760653"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13436726"
"RoomLevel" => "Third level"
"RoomWidth" => 2.93
"ListingKey" => "29895192"
"RoomLength" => 5.01
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T15:30:32.61Z"
]
6 => array:11 [
"RoomKey" => "1657760654"
"RoomType" => "Laundry room"
"ListingId" => "X13436726"
"RoomLevel" => "Basement"
"RoomWidth" => 2.46
"ListingKey" => "29895192"
"RoomLength" => 3.09
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T15:30:32.61Z"
]
7 => array:11 [
"RoomKey" => "1657760655"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13436726"
"RoomLevel" => "Basement"
"RoomWidth" => 3.32
"ListingKey" => "29895192"
"RoomLength" => 6.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T15:30:32.61Z"
]
8 => array:11 [
"RoomKey" => "1657760656"
"RoomType" => "Utility room"
"ListingId" => "X13436726"
"RoomLevel" => "Basement"
"RoomWidth" => 2.76
"ListingKey" => "29895192"
"RoomLength" => 4.81
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T15:30:32.61Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29895192/4-417-keats-way-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Weigel Management"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-12T15:30:32.56Z"
+"ListAgentNationalAssociationId": "1370979"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:47 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29895192_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/bd05694eb3f93cbf4dcb782cf39f2ef3.webp"
"MediaSize" => 318919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-bd05694eb3f93cbf4dcb782cf39f2ef3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29895192_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/5748fc79a4ebe3c5f6b33071f7110ee0.webp"
"MediaSize" => 348084
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-5748fc79a4ebe3c5f6b33071f7110ee0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29895192_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/605f68d9b758070d15c8470092ce6ca5.webp"
"MediaSize" => 339736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-605f68d9b758070d15c8470092ce6ca5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29895192_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/e44adbe578839a43507a153747eb4099.webp"
"MediaSize" => 320697
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-e44adbe578839a43507a153747eb4099.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29895192_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/9139791b15f550975cb7cc74a44f7788.webp"
"MediaSize" => 92567
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-9139791b15f550975cb7cc74a44f7788.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29895192_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/3e6edd447b0e5080d6d8f1103f476970.webp"
"MediaSize" => 112641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-3e6edd447b0e5080d6d8f1103f476970.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29895192_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/1f7c9fc39d8b20c4a29c7d55b05fcb79.webp"
"MediaSize" => 90027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-1f7c9fc39d8b20c4a29c7d55b05fcb79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29895192_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/16cc10fdf88c9356879238db7308b8e6.webp"
"MediaSize" => 46303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-16cc10fdf88c9356879238db7308b8e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29895192_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/143501d78849b0b9f540fbc2cb15b455.webp"
"MediaSize" => 127781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-143501d78849b0b9f540fbc2cb15b455.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29895192_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/3d87f5d87e05e2aa2185feab83481f2a.webp"
"MediaSize" => 115624
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-3d87f5d87e05e2aa2185feab83481f2a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29895192_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/2f2b07d48342f211f2118d4389428c36.webp"
"MediaSize" => 139069
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-2f2b07d48342f211f2118d4389428c36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29895192_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/0ada796047fcc72d31cc92b78063e463.webp"
"MediaSize" => 128140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-0ada796047fcc72d31cc92b78063e463.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29895192_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/eb61971170f871f0e6d3f3488246bbf3.webp"
"MediaSize" => 148556
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-eb61971170f871f0e6d3f3488246bbf3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29895192_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/e64860f19f3f4ef54919a032c8ad5f42.webp"
"MediaSize" => 115590
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-e64860f19f3f4ef54919a032c8ad5f42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29895192_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/39cec626cad00ee1fe82d8bfccc725d7.webp"
"MediaSize" => 91054
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-39cec626cad00ee1fe82d8bfccc725d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29895192_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/854beb4074ff2f4f98263d647cb5838c.webp"
"MediaSize" => 101133
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-854beb4074ff2f4f98263d647cb5838c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29895192_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/7d1e97bc7d86efd6bdb410de1f83cafd.webp"
"MediaSize" => 134052
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-7d1e97bc7d86efd6bdb410de1f83cafd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29895192_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/21f83ef9c7c920d7f9100cfa0394d158.webp"
"MediaSize" => 74693
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-21f83ef9c7c920d7f9100cfa0394d158.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29895192_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/292f05546b2114e5fd0c45dea98027de.webp"
"MediaSize" => 81677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-292f05546b2114e5fd0c45dea98027de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29895192_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/19690485e7f8dadb9d845f8803e8d1cd.webp"
"MediaSize" => 77463
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-19690485e7f8dadb9d845f8803e8d1cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29895192_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/d9964d3740608eaf8e897222aa5f3ab8.webp"
"MediaSize" => 123866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-d9964d3740608eaf8e897222aa5f3ab8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29895192_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/532d1d02146ba8cc41a34c1c079d9bef.webp"
"MediaSize" => 57286
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-532d1d02146ba8cc41a34c1c079d9bef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29895192_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/82ccdc80c96907bdffa9455dea2a02e5.webp"
"MediaSize" => 88392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-82ccdc80c96907bdffa9455dea2a02e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29895192_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/0d4ededf78a59b38ee1b6a8aa6ed6249.webp"
"MediaSize" => 101798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-0d4ededf78a59b38ee1b6a8aa6ed6249.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29895192_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/33d388730a1afcfad224a57ec0cd4d6b.webp"
"MediaSize" => 83180
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-33d388730a1afcfad224a57ec0cd4d6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29895192_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/9d1646b9a7ae81f0cd86a08c40005e61.webp"
"MediaSize" => 54486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-9d1646b9a7ae81f0cd86a08c40005e61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29895192_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/83507b2ded7bba5b33b864021b5d4de6.webp"
"MediaSize" => 40797
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-83507b2ded7bba5b33b864021b5d4de6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29895192_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/9b914d9960c623f4d3a7a3ca283df262.webp"
"MediaSize" => 109043
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-9b914d9960c623f4d3a7a3ca283df262.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29895192_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/79a5d825a126b80580737d056edbda46.webp"
"MediaSize" => 90781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-79a5d825a126b80580737d056edbda46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29895192_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/80922109c7f5e71b1b37cc6051bc4ba5.webp"
"MediaSize" => 113125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-80922109c7f5e71b1b37cc6051bc4ba5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29895192_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/6871ca25c237d4b1f3402c78c6560bf0.webp"
"MediaSize" => 87184
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-6871ca25c237d4b1f3402c78c6560bf0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29895192_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/66b4b2ae2745e11fea922e70057df7df.webp"
"MediaSize" => 113427
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-66b4b2ae2745e11fea922e70057df7df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29895192_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/0af62eed4930e18be9c268d4301a6671.webp"
"MediaSize" => 125465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-0af62eed4930e18be9c268d4301a6671.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29895192_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/6927fa685ac5aedc19531a8f635b8019.webp"
"MediaSize" => 109208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-6927fa685ac5aedc19531a8f635b8019.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29895192_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/9c7eb01014127e7f4f5ff99a210cff92.webp"
"MediaSize" => 127291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-9c7eb01014127e7f4f5ff99a210cff92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29895192_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/67c643b5a295018f4249d1081d4f4314.webp"
"MediaSize" => 63586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-67c643b5a295018f4249d1081d4f4314.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29895192_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/00d3e9a561c2e8f8c841990e466acfad.webp"
"MediaSize" => 108623
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-00d3e9a561c2e8f8c841990e466acfad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29895192_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/6ac95498448bf7e9dd9e4d87cd3f6a99.webp"
"MediaSize" => 66886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-6ac95498448bf7e9dd9e4d87cd3f6a99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29895192_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/d9cf54899cbe4f8f2e50faea5dfb64d2.webp"
"MediaSize" => 119287
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-d9cf54899cbe4f8f2e50faea5dfb64d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29895192_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/b6f05c51f5553f41ef5eba72790cb60e.webp"
"MediaSize" => 344264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-b6f05c51f5553f41ef5eba72790cb60e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29895192_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/982e11c5ea96efde717961c5762cf5c8.webp"
"MediaSize" => 346199
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-982e11c5ea96efde717961c5762cf5c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29895192_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/d7499df29a7d93bb7cfe79ba2a807c54.webp"
"MediaSize" => 320924
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-d7499df29a7d93bb7cfe79ba2a807c54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29895192_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/6508301f2674958ca61e66cd421e2b19.webp"
"MediaSize" => 371057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-6508301f2674958ca61e66cd421e2b19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29895192_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/96bd5a08bdab375a26bb07baa62ea39d.webp"
"MediaSize" => 81504
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-96bd5a08bdab375a26bb07baa62ea39d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29895192_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/9f3c6e3491a3e34a45d74a7fa66691f5.webp"
"MediaSize" => 94152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-9f3c6e3491a3e34a45d74a7fa66691f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29895192_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/86d76c57ae4a9c8868b02b9c235bac62.webp"
"MediaSize" => 111877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-86d76c57ae4a9c8868b02b9c235bac62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29895192_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895192/cb38ce10d386384047458a45d62635d9.webp"
"MediaSize" => 102173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895192/thumbnail-cb38ce10d386384047458a45d62635d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436726"
"ResourceRecordKey" => "29895192"
"ModificationTimestamp" => "2026-06-12T15:30:32.56Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895192')"
+"ID": "1524681"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 288578" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24818
+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 2100955" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24791
+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 '29895192'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25139
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29895192'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24790
+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 '29895192' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.556684 43.457734)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25173
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25167
+post_id: "1525564"
+post_author: 1
+"ListingKey": "29898161"
+"ListingId": "40839319"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T19:45:02Z"
+"RFModificationTimestamp": "2026-06-13T19:46:04Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1322.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2K6"
+"UnparsedAddress": "629 SETTLERSFIELD Court Unit# B, Waterloo, Ontario N2T2K6"
+"Coordinates": array:2 [
0 => -80.569755
1 => 43.4490121
]
+"Latitude": 43.4490121
+"Longitude": -80.569755
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Prepare to fall in love with this beautifully updated backsplit with separate side entrance. Located in a quiet family friendly neighbourhood close to the Boardwalk Costco and more. This 2 plus bedroom boasts 3 full bathrooms, open concept floor plan featuring Stainless steel appliance, quartz countertops, upgraded kitchen cabinets and lighting package plus an attractive staircase. Upstairs you will find 2 bedrooms plus built in laundry and 4 piece bath. You'll love the familyroom with large windows for tons of natural light. Full 4 piece bath is within easy reach, there is a side entrance leading to a great deck and a fully fenced pie shaped back yard with mature trees. Looking for extra space then basement level features a brand new inlaw with 2nd kitchen with appliances, good size 3rd bedroom or recroom plus another 3 piece bathroom for the teens. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
]
+"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-12T21:37:11.360335+00:00"
+"Directions": "ERBSVILLE ROAD TO RUMMERLHARDT DR TO PINEROW CRES"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1948781"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-06-12T21:10:21Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T19:39:15Z"
+"Stories": "3.0"
+"StreetName": "SETTLERSFIELD"
+"StreetNumber": "629"
+"StreetSuffix": "Court"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "4025"
+"Utilities": array:1 [
0 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/629_b_settlersfield_ct_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1658699384"
"RoomType" => "3pc Bathroom"
"ListingId" => "40839319"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29898161"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T19:39:15.7Z"
]
1 => array:11 [
"RoomKey" => "1658699385"
"RoomType" => "Living room"
"ListingId" => "40839319"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29898161"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T19:39:15.7Z"
]
2 => array:11 [
"RoomKey" => "1658699386"
"RoomType" => "Breakfast"
"ListingId" => "40839319"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29898161"
"RoomLength" => null
"RoomDimensions" => "7'10'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T19:39:15.7Z"
]
3 => array:11 [
"RoomKey" => "1658699387"
"RoomType" => "Recreation room"
"ListingId" => "40839319"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29898161"
"RoomLength" => null
"RoomDimensions" => "17' x 20'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T19:39:15.7Z"
]
4 => array:11 [
"RoomKey" => "1658699388"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839319"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29898161"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T19:39:15.7Z"
]
5 => array:11 [
"RoomKey" => "1658699389"
"RoomType" => "Family room"
"ListingId" => "40839319"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29898161"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 20'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T19:39:15.7Z"
]
6 => array:11 [
"RoomKey" => "1658699390"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839319"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29898161"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T19:39:15.71Z"
]
7 => array:11 [
"RoomKey" => "1658699391"
"RoomType" => "Bedroom"
"ListingId" => "40839319"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29898161"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T19:39:15.71Z"
]
8 => array:11 [
"RoomKey" => "1658699392"
"RoomType" => "Primary Bedroom"
"ListingId" => "40839319"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29898161"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 13'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T19:39:15.71Z"
]
9 => array:11 [
"RoomKey" => "1658699393"
"RoomType" => "Dining room"
"ListingId" => "40839319"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29898161"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T19:39:15.71Z"
]
10 => array:11 [
"RoomKey" => "1658699394"
"RoomType" => "Kitchen"
"ListingId" => "40839319"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29898161"
"RoomLength" => null
"RoomDimensions" => "7'7'' x 10'0''"
"RoomDescription" => null
…2
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29898161/629-settlersfield-court-unit-b-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1563914"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76807"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 24.0
+"AboveGradeFinishedArea": 829
+"BelowGradeFinishedArea": 493
+"OriginalEntryTimestamp": "2026-06-12T21:10:19.47Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1243289"
+"ListOfficeNationalAssociationId": "1380559"
+"CoListAgentNationalAssociationId": "1069671"
+"CoListOfficeNationalAssociationId": "1004370"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898161')"
+"ID": "1525564"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25169
+post_id: "1524680"
+post_author: 1
+"ListingKey": "29894553"
+"ListingId": "40829023"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T14:30:06Z"
+"RFModificationTimestamp": "2026-06-12T20:09:42Z"
+"ListPrice": 429900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1596.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5S7"
+"UnparsedAddress": "417 KEATS Way Unit# 4, Waterloo, Ontario N2L5S7"
+"Coordinates": array:2 [
0 => -80.5566627
1 => 43.4577016
]
+"Latitude": 43.4577016
+"Longitude": -80.5566627
+"YearBuilt": 1977
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Updated and spacious, this Beechwood, 3 bedroom, 2.5 bathroom townhouse offers approximately 1,600 square feet of comfortable living space in a highly desirable Waterloo location. Ideal for first-time buyers, families, or investors, the home features a bright, open living room with built-in shelving and elegant crown molding. Upstairs, you’ll find a large primary bedroom with a walk-in closet, along with two additional generously sized bedrooms. The fully finished basement adds excellent flexibility with a large, versatile rec room, full bathroom, and laundry area. Set in a quiet complex with ample visitor parking and green space, this property is conveniently located close to everyday amenities, including two grocery stores within walking distance, major bus routes, the expressway, and both universities, including walking distance to the University of Waterloo. A well-kept, move-in-ready opportunity in a convenient and sought-after location. (id:62783)"
+"AssociationFee": "612"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T20:09:38.059035+00:00"
+"Directions": "Fischer-Hallman"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564479"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-06-12T14:22:18Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T14:22:18Z"
+"Stories": "2.0"
+"StreetName": "KEATS"
+"StreetNumber": "417"
+"StreetSuffix": "Way"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3014"
+"VirtualTourURLUnbranded": "https://youriguide.com/4_417_keats_way_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29894553/417-keats-way-unit-4-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1366
+"BelowGradeFinishedArea": 230
+"OriginalEntryTimestamp": "2026-06-12T14:22:18.59Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1125580"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29894553')"
+"ID": "1524680"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25166
+post_id: "1521301"
+post_author: 1
+"ListingKey": "29891893"
+"ListingId": "X13433902"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T22:00:07Z"
+"RFModificationTimestamp": "2026-06-11T22:02:43Z"
+"ListPrice": 1049000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2R2"
+"UnparsedAddress": "450 WESTHAVEN STREET, Waterloo, Ontario N2T2R2"
+"Coordinates": array:2 [
0 => -80.566908
1 => 43.445283
]
+"Latitude": 43.445283
+"Longitude": -80.566908
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 450 Westhaven Street, a beautifully upgraded Ritz Homes residence in one of Waterloo's most sought after family neighbourhoods. Less than one year old, this stunning home offers approximately 2,320 sq ft above grade plus a finished basement, featuring quartz countertops throughout, a designer kitchen with a custom coffee bar, engineered hardwood flooring, oak staircases with black metal pickets, and no carpet throughout. The finished lower level adds exceptional versatility with a spacious recreation room, additional bedroom, full bathroom, and a convenient kitchenette complete with a sink, making it ideal for extended family, guests, or multi generational living. Complete with 200 amp service, central air conditioning, gas lines for the stove and BBQ, and numerous builder upgrades, this move in ready home offers the perfect blend of style, comfort, and functionality.Ideally situated in the highly desirable Westvale area of Waterloo, this home is surrounded by excellent schools, beautiful parks, walking trails, playgrounds, and family friendly amenities. Enjoy convenient access to shopping, restaurants, Costco, The Boardwalk, universities, public transit, and major commuter routes including Highway 7/8. Whether you're raising a family, working from home, or simply looking for a newer home in a thriving community, 450 Westhaven Street delivers exceptional value in one of Waterloo's most convenient and connected locations. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
]
+"Basement": array:7 [
0 => "Finished"
1 => "Full"
2 => "Apartment in basement"
3 => "Separate entrance"
4 => "N/A"
5 => "N/A"
6 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T21:22:24.773387+00:00"
+"Directions": "Cross Streets: Erb Street W to Westhaven Street. ** Directions: Erb Street W."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2071055"
+"ListOfficeKey": "148048"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "Guest Suite"
2 => "In-Law Suite"
]
+"LotSizeDimensions": "31.5 x 113.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T20:54:15Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T21:53:53Z"
+"Stories": "2.0"
+"StreetName": "Westhaven"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3794.36"
+"VirtualTourURLUnbranded": "https://youriguide.com/450_westhaven_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": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29891893/450-westhaven-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "SR-1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 31.6
+"OriginalEntryTimestamp": "2026-06-11T20:54:14.99Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1346258"
+"ListOfficeNationalAssociationId": "1177786"
+"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('29891893')"
+"ID": "1521301"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25170
+post_id: "1520602"
+post_author: 1
+"ListingKey": "29889823"
+"ListingId": "40838151"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T18:50:08Z"
+"RFModificationTimestamp": "2026-06-13T18:53:44Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2301.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V4"
+"UnparsedAddress": "729 BRANDENBURG Boulevard, Waterloo, Ontario N2T2V4"
+"Coordinates": array:2 [
0 => -80.5790115
1 => 43.4569573
]
+"Latitude": 43.4569573
+"Longitude": -80.5790115
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 729 Brandenburg Boulevard, a beautifully maintained and thoughtfully updated 3-bedroom, 3-bathroom detached home in one of Waterloo’s most sought-after family-friendly neighbourhoods. Offering the perfect blend of comfort, functionality, and convenience, this move-in-ready home is ideal for growing families and busy professionals alike. The main floor features a bright and inviting layout, where a central staircase creates distinct living spaces while maintaining an open and connected feel. Spacious principal rooms provide plenty of room for everyday living and entertaining, while direct access to the backyard seamlessly extends your living space outdoors. Upstairs, you'll find three generously sized bedrooms and a well-appointed main bathroom designed for everyday family living. The finished basement adds valuable additional space with a large rec room, versatile den, full bathroom, cold cellar, and utility room—perfect for a home office, guest space, or recreation area. A rare detached double-car garage accessed from the rear laneway, along with direct gated access to the backyard, offers exceptional convenience, privacy, and flexibility. Ideally located just minutes from shopping, restaurants, The Boardwalk, Costco, Laurel Creek Conservation Area, parks, and excellent schools, this home offers an outstanding lifestyle in a highly desirable Waterloo community. Meticulously cared for and perfectly situated, this is a home you won't want to miss. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T20:31:02.889440+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2011048"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T17:10:34Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T18:39:40Z"
+"Stories": "2.0"
+"StreetName": "BRANDENBURG"
+"StreetNumber": "729"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4644"
+"VirtualTourURLUnbranded": "https://youriguide.com/729_brandenburg_blvd_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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29889823/729-brandenburg-boulevard-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1549
+"BelowGradeFinishedArea": 752
+"OriginalEntryTimestamp": "2026-06-11T17:10:33.94Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1292484"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:40 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889823')"
+"ID": "1520602"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25168
+post_id: "1521937"
+post_author: 1
+"ListingKey": "29891240"
+"ListingId": "X13433662"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T20:15:13Z"
+"RFModificationTimestamp": "2026-06-11T20:20:04Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2X4"
+"UnparsedAddress": "462 LAUSANNE CRESCENT, Waterloo, Ontario N2T2X4"
+"Coordinates": array:2 [
0 => -80.5749644
1 => 43.453304
]
+"Latitude": 43.453304
+"Longitude": -80.5749644
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Rarely does a home offer the perfect combination of privacy, convenience, and natural surroundings quite like this. Welcome to 462 Lausanne Crescent, a beautifully maintained FREEHOLD townhouse in Waterloo's highly desirable Clair Hills neighbourhood - providing the freedom of homeownership with no condo fees and backing directly onto open park-like space. Inside, you'll find a thoughtfully designed layout featuring two spacious bedrooms, each complete with its own private 4-piece ensuite bathroom - an ideal setup for professionals, downsizers, guests, or those seeking comfortable multi-generational living. The bright and functional main living areas provide an inviting space for everyday life, while the fully finished basement expands your options with a generous recreation room and versatile den, perfect for a home office or hobby room. One of the home's standout features is its exceptional setting. Backing onto expansive open park-like space with no rear neighbours, you'll enjoy peaceful views, added privacy, and direct access to trails and the outdoors. Located in the sought-after Clair Hills community and nearby Boardwalk shopping district, you'll enjoy close proximity to shopping, restaurants, public transit, and everyday amenities making this a favourite neighbourhood for professionals, families, and active adults alike. Offering flexible living space, a fully finished basement, two private ensuites, no condo fees, and a premium park-side location, this is a wonderful opportunity to enjoy all that Clair Hills has to offer. (id:66098)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Sauna"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Freezer"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T20:19:52.553690+00:00"
+"Directions": "Cross Streets: Erbsville Road. ** Directions: Erbsville Road to Keats Way to Brandenburg Blvd to Lausanne Cres."
+"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": "1555372"
+"ListOfficeKey": "85457"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "16 x 99.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T19:31:56Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T20:04:17Z"
+"Stories": "2.0"
+"StreetName": "Lausanne"
+"StreetNumber": "462"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3766.84"
+"VirtualTourURLUnbranded": "https://youriguide.com/lmi4y_462_lausanne_crescent_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": "OnePoint"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29891240/462-lausanne-crescent-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2088761"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "85457"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 16.0
+"OriginalEntryTimestamp": "2026-06-11T19:31:56.5Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1147383"
+"ListOfficeNationalAssociationId": "1002051"
+"CoListAgentNationalAssociationId": "1362076"
+"CoListOfficeNationalAssociationId": "1002051"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891240')"
+"ID": "1521937"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25163
+post_id: "1520603"
+post_author: 1
+"ListingKey": "29890553"
+"ListingId": "40838621"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T16:20:03Z"
+"RFModificationTimestamp": "2026-06-12T16:26:21Z"
+"ListPrice": 2350000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.374
+"LivingArea": 6672.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2E7"
+"UnparsedAddress": "336 BUSHWOOD Court, Waterloo, Ontario N2T2E7"
+"Coordinates": array:2 [
0 => -80.5744606
1 => 43.4627013
]
+"Latitude": 43.4627013
+"Longitude": -80.5744606
+"YearBuilt": 1989
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to The Woods' of Upper Beechwood. Bushwood Court is one of the premier cul-de-sacs in the subdivision. Built by Bushview Homes, this grand Georgian style brick home with stone accents, offers 5 bedrooms, 6 bathrooms, 3 gas fireplaces, triple car garage & a fully finished walkout basement level plus walk-up stairs to the garage. Fabulous 4,780 sq feet above grade plus the finished lower level with about an additional 1,891 sq feet ensures your family will enjoy the extensive livability of this home. Wonderful opportunity for a generational family to live comfortably here with modifications. Vestibule entry leads to an impressive foyer introducing you to a centre hall plan. The main floor features 9' ceilings with layered molding, Brazilian cherry hardwood floors, 18 travertine tile, wide baseboard trim, multiple windows in each room with French doors to open or close off the rooms while entertaining. Elegant oversized dining room. Gather in the kitchen featuring granite counters, bubble tile backsplash, stainless appliances, centre island with sitting peninsula plus multiple ceiling pot lights. The bright vaulted dinette has overhead skylights with views to the deck & mature yard. Your office can be on the main floor or one of the upper bedrooms. The Primary suite fits king sized furniture with a private den/nursery/sitting area plus has 3 closets & a 5 pc Ensuite. Each upper bathroom has its own linen closet. Spacious basement level ready for recreation activities. Known for its great community spirit, families enjoy the neighbourhood for the greenspace trails that lead up to the Recreational facility which has a supervised oversized inground pool, basketball court & two tennis courts. Fun programs for the whole family to participate in throughout the Summer season. Minutes to shopping, Library, Laurelwood Conservation area plus Universities of Waterloo & Laurier. Amazing space in a wonderful location...Bushwood Court in Upper Beechwood! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Tudor"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T19:13:13.411100+00:00"
+"Directions": "Columbia Street West to roundabout at Bennington Gate, turn right on Clair Creek, right on Bushwood Court"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564125"
+"ListOfficeKey": "76836"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Skylight"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.374"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T18:31:42Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T16:11:06Z"
+"Stories": "2.0"
+"StreetName": "BUSHWOOD"
+"StreetNumber": "336"
+"StreetSuffix": "Court"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "18947.94"
+"VirtualTourURLUnbranded": "https://youriguide.com/336_bushwood_court_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:22 [
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]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29890553/336-bushwood-court-waterloo"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 140.0
+"AboveGradeFinishedArea": 4781
+"BelowGradeFinishedArea": 1891
+"OriginalEntryTimestamp": "2026-06-11T18:31:42.07Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070169"
+"ListOfficeNationalAssociationId": "1004398"
+"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('29890553')"
+"ID": "1520603"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23375
+post_id: "1520604"
+post_author: 1
+"ListingKey": "29890254"
+"ListingId": "X13432602"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T18:05:11Z"
+"RFModificationTimestamp": "2026-06-11T18:50:56Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V4"
+"UnparsedAddress": "729 BRANDENBURG BOULEVARD, Waterloo, Ontario N2T2V4"
+"Coordinates": array:2 [
0 => -80.57901
1 => 43.456959
]
+"Latitude": 43.456959
+"Longitude": -80.57901
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 729 Brandenburg Boulevard, a beautifully maintained and thoughtfully updated 3-bedroom, 3-bathroom detached home in one of Waterloo's most sought-after family-friendly neighbourhoods. Offering the perfect blend of comfort, functionality, and convenience, this move-in-ready home is ideal for growing families and busy professionals alike. The main floor features a bright and inviting layout, where a central staircase creates distinct living spaces while maintaining an open and connected feel. Spacious principal rooms provide plenty of room for everyday living and entertaining, while direct access to the backyard seamlessly extends your living space outdoors. Upstairs, you'll find three generously sized bedrooms and a well-appointed main bathroom designed for everyday family living. The finished basement adds valuable additional space with a large rec room, versatile den, full bathroom, cold cellar, and utility room-perfect for a home office, guest space, or recreation area. A rare detached double-car garage accessed from the rear laneway, along with direct gated access to the backyard, offers exceptional convenience, privacy, and flexibility. Ideally located just minutes from shopping, restaurants, The Boardwalk, Costco, Laurel Creek Conservation Area, parks, and excellent schools, this home offers an outstanding lifestyle in a highly desirable Waterloo community. Meticulously cared for and perfectly situated, this is a home you won't want to miss. (id:62783)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Freezer"
9 => "Water Treatment"
10 => "Window Coverings"
11 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T18:50:49.899890+00:00"
+"Directions": "Cross Streets: Erbsville Rd and Keats Way. ** Directions: Erbsville Rd to Brandenburg Blvd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2138804"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "30.2 x 115.6 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T17:59:58Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T17:59:58Z"
+"Stories": "2.0"
+"StreetName": "Brandenburg"
+"StreetNumber": "729"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "4644"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/729_brandenburg_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29890254/729-brandenburg-boulevard-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 30.2
+"OriginalEntryTimestamp": "2026-06-11T17:59:58.77Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1390596"
+"ListOfficeNationalAssociationId": "1385020"
+"Media": array:40 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29890254')"
+"ID": "1520604"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25171
+post_id: "1512361"
+post_author: 1
+"ListingKey": "29879145"
+"ListingId": "X13422676"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T22:25:49Z"
+"RFModificationTimestamp": "2026-06-09T22:27:31Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1A7"
+"UnparsedAddress": "72 PINEMEADOW CRESCENT, Waterloo, Ontario N2T1A7"
+"Coordinates": array:2 [
0 => -80.554071
1 => 43.449234
]
+"Latitude": 43.449234
+"Longitude": -80.554071
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 72 Pinemeadow Crescent! This spotless, completely carpet-free over 1700 sqft finished living space raised bungalow in highly sought-after Westvale is move-in ready. Premium vinyl flooring & fresh professional paint (both 2026) flow throughout. Enjoy new pot lights in the living room & major updates including refrigerator (2026), dryer (2026), sump pump (2026), and A/C (2021). The fully finished lower level offers incredible versatility with a 4th bedroom, full bath & spacious rec room-ideal for an in-law suite, guest retreat, or rental potential. Step outside to a private, fenced backyard perfect for family gatherings. No sidewalk = less hassle & easier snow removal! Parking is a breeze w/ total 5 spaces (1 garage + 4 driveway). Minutes to top-rated schools, parks, transit, and The Boardwalk, featuring medical centres, a movie theatre, a water splash park, and a climbing park. Also close to Walmart, Costco & shops at Boardwalk. A quick walk away from the 201 and 202 bus stations to the University of Waterloo and Wilfrid Laurier University " A truly rare, turn-key opportunity - don't miss! (id:62650)"
+"Appliances": array:4 [
0 => "Water meter"
1 => "Water softener"
2 => "Garage door opener remote(s)"
3 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T22:27:20.959675+00:00"
+"Directions": "westvake dr & thorndale dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2135760"
+"ListOfficeKey": "70066"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "Sump Pump"
]
+"LotSizeDimensions": "47 x 118 FT ; 119.98ftx47.46ft x125.48 ftx36.24ft"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T21:49:10Z"
+"PhotosCount": 27
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T22:19:22Z"
+"Stories": "1.0"
+"StreetName": "PINEMEADOW"
+"StreetNumber": "72"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4055"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=tmdr6sHSX76&play=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29879145/72-pinemeadow-crescent-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 47.0
+"OriginalEntryTimestamp": "2026-06-09T21:49:10.49Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1388108"
+"ListOfficeNationalAssociationId": "1132867"
+"Media": array:27 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29879145')"
+"ID": "1512361"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25172
+post_id: "1512898"
+post_author: 1
+"ListingKey": "29878628"
+"ListingId": "X13422258"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T23:50:02Z"
+"RFModificationTimestamp": "2026-06-11T23:52:29Z"
+"ListPrice": 399999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5E5"
+"UnparsedAddress": "26A HELENE CRESCENT, Waterloo, Ontario N2L5E5"
+"Coordinates": array:2 [
0 => -80.545003
1 => 43.456854
]
+"Latitude": 43.456854
+"Longitude": -80.545003
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Fantastic opportunity for first-time buyers and investors! This exceptionally clean and well-maintained 3-bedroom semi-detached home features a highly functional, sun-filled layout with spacious principal rooms and a practical kitchen. The upper level offers 3 comfortable bedrooms and a solid 4-piece bathroom. Features a private separate side entrance leading to a fully self-contained, city-registered 1-bedroom Legal Basement apartment-the ultimate mortgage helper to offset living costs! Extended driveway with parking for 3 cars. Move right in or customize to your taste over time. Unbeatable location close to top schools, local transit, major highway, and shopping centers! The tenant is willing to stay and pay $1,300 per month. An unbeatable location perfect for students or commuters, offering effortless access to both the universities University of Waterloo & Wilfrid Laurier university and public transit(Bus Stop). Upgraded electrical Panel. (id:62650)"
+"Basement": array:4 [
0 => "Finished"
1 => "Apartment in basement"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-09T22:22:30.502075+00:00"
+"Directions": "ERB ST/AMOS AVE"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2062462"
+"ListOfficeKey": "278186"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "32.3 x 95.2 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T21:36:55Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T23:43:55Z"
+"Stories": "2.0"
+"StreetName": "Helene"
+"StreetNumber": "26A"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3548"
+"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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29878628/26a-helene-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 32.3
+"OriginalEntryTimestamp": "2026-06-09T20:48:43.12Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1337461"
+"ListOfficeNationalAssociationId": "1290738"
+"Media": array:43 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29878628')"
+"ID": "1512898"
}
]
+success: true
+page_size: 9
+page_count: 15
+count: 135
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]