array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29997712 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23447
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23449
+post_id: "1598978"
+post_author: 1
+"ListingKey": "29997712"
+"ListingId": "X13530548"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T12:00:05Z"
+"RFModificationTimestamp": "2026-07-07T19:54:22Z"
+"ListPrice": 1049000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2V4"
+"UnparsedAddress": "775 KLOSTERS DRIVE, Waterloo, Ontario N2V2V4"
+"Coordinates": array:2 [
0 => -80.5840528
1 => 43.4564789
]
+"Latitude": 43.4564789
+"Longitude": -80.5840528
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Some homes are simply lived in. This one has been loved. Nestled in Clair Hills, one of Waterloo's most coveted, family-oriented, quiet, and safe neighbourhoods, 775 Klosters Drive sits within walking distance of some of the region's top-rated schools: Vista Hills PS, St. Nicholas Catholic Elementary, and Laurel Heights Secondary. This 3+1-bedroom, 4-bathroom home has been completely renovated, with brand-new flooring throughout and a bright, open-concept kitchen at the heart of the main floor. A powder room on the main level with a window adds everyday convenience, and the finished walkout basement extends your living space with direct access to a private backyard. A dedicated laundry room comes fully equipped with a washroom, sink, cabinetry, and a new washer & dryer tower, while the double garage offers generous parking and storage. Outside, the raised deck (fully replaced) is ready for summer entertaining. Columbia Forest's trails are moments away for after-dinner walks and weekend adventures, with Costco and The Boardwalk a short drive from your door. You're also close to the famous St. Jacobs Farmers' Market and nearby farms, meaning fresh fruits, vegetables, and easy living are always within reach. Highlights: roof (2021), newly replaced sump pump and water softener system, brand-new flooring throughout, including the exterior deck floorboards, all-new major appliances, plus a laundry center. This isn't just a house in a great school district. It's the backdrop for the next chapter of your family's story. (id:62650)"
+"Appliances": array:8 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Dishwasher"
3 => "Oven"
4 => "Cooktop"
5 => "Blinds"
6 => "Garage door opener remote(s)"
7 => "Water Heater"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T07:37:24.568560+00:00"
+"Directions": "Cross Streets: Columbia St. W. & Zurich Dr. ** Directions: Columbia Street West."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2070166"
+"ListOfficeKey": "283379"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "45 x 119.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T11:51:12Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T11:51:12Z"
+"Stories": "2.0"
+"StreetName": "Klosters"
+"StreetNumber": "775"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5822"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=SoACHeabafh"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1677218370"
"RoomType" => "Living room"
"ListingId" => "X13530548"
"RoomLevel" => "Main level"
"RoomWidth" => 4.32
"ListingKey" => "29997712"
"RoomLength" => 4.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T05:38:16.54Z"
]
1 => array:11 [
"RoomKey" => "1677218371"
"RoomType" => "Dining room"
"ListingId" => "X13530548"
"RoomLevel" => "Main level"
"RoomWidth" => 4.65
"ListingKey" => "29997712"
"RoomLength" => 2.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T05:38:16.54Z"
]
2 => array:11 [
"RoomKey" => "1677218372"
"RoomType" => "Kitchen"
"ListingId" => "X13530548"
"RoomLevel" => "Main level"
"RoomWidth" => 4.65
"ListingKey" => "29997712"
"RoomLength" => 3.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T05:38:16.54Z"
]
3 => array:11 [
"RoomKey" => "1677218373"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13530548"
"RoomLevel" => "Second level"
"RoomWidth" => 4.27
"ListingKey" => "29997712"
"RoomLength" => 4.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T05:38:16.54Z"
]
4 => array:11 [
"RoomKey" => "1677218374"
"RoomType" => "Bedroom 2"
"ListingId" => "X13530548"
"RoomLevel" => "Second level"
"RoomWidth" => 3.68
"ListingKey" => "29997712"
"RoomLength" => 3.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T05:38:16.55Z"
]
5 => array:11 [
"RoomKey" => "1677218375"
"RoomType" => "Bedroom 3"
"ListingId" => "X13530548"
"RoomLevel" => "Second level"
"RoomWidth" => 3.68
"ListingKey" => "29997712"
"RoomLength" => 2.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T05:38:16.55Z"
]
6 => array:11 [
"RoomKey" => "1677218376"
"RoomType" => "Living room"
"ListingId" => "X13530548"
"RoomLevel" => "Basement"
"RoomWidth" => 5.0
"ListingKey" => "29997712"
"RoomLength" => 5.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T05:38:16.55Z"
]
7 => array:11 [
"RoomKey" => "1677218377"
"RoomType" => "Office"
"ListingId" => "X13530548"
"RoomLevel" => "Basement"
"RoomWidth" => 3.73
"ListingKey" => "29997712"
"RoomLength" => 2.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T05:38:16.55Z"
]
8 => array:11 [
"RoomKey" => "1677218378"
"RoomType" => "Laundry room"
"ListingId" => "X13530548"
"RoomLevel" => "Basement"
"RoomWidth" => 3.02
"ListingKey" => "29997712"
"RoomLength" => 2.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T05:38:16.55Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29997712/775-klosters-drive-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Canopy"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-07-07T05:38:16.5Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1345333"
+"ListOfficeNationalAssociationId": "1328472"
+"Media": array:37 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29997712_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/2b5059ab58fa8ddbbdaa96075ea412e5.webp"
"MediaSize" => 415466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-2b5059ab58fa8ddbbdaa96075ea412e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29997712_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/a502891ab190059a9f5a74034363c0dd.webp"
"MediaSize" => 397600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-a502891ab190059a9f5a74034363c0dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29997712_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/aab5e0f2b1cc814de568a3d47745a26e.webp"
"MediaSize" => 159513
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-aab5e0f2b1cc814de568a3d47745a26e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29997712_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/87dcf64be813e2390bd98165096cb31f.webp"
"MediaSize" => 247194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-87dcf64be813e2390bd98165096cb31f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29997712_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/9ad8ab878e665ab60a79c4cfd9fb9eba.webp"
"MediaSize" => 221563
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-9ad8ab878e665ab60a79c4cfd9fb9eba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29997712_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/57632a1b3213097ce9172c98f98e159e.webp"
"MediaSize" => 213604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-57632a1b3213097ce9172c98f98e159e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29997712_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/b91a543ad652314e11137c405695cb17.webp"
"MediaSize" => 225715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-b91a543ad652314e11137c405695cb17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29997712_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/1492da2105679c82225529e17a8ed333.webp"
"MediaSize" => 200993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-1492da2105679c82225529e17a8ed333.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29997712_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/e8041dd21d8821a33587434be6ba4a58.webp"
"MediaSize" => 216332
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-e8041dd21d8821a33587434be6ba4a58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29997712_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/8c5329d153ec10b9fa3285952c7a3943.webp"
"MediaSize" => 209493
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-8c5329d153ec10b9fa3285952c7a3943.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29997712_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/7950ad97a1b7df50935fd6daf342b852.webp"
"MediaSize" => 193713
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-7950ad97a1b7df50935fd6daf342b852.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29997712_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/e1cc309c08df9dd6262c5e5f56c8133e.webp"
"MediaSize" => 161065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-e1cc309c08df9dd6262c5e5f56c8133e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29997712_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/402200ce57ef837fa9c89aef2c54482c.webp"
"MediaSize" => 171453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-402200ce57ef837fa9c89aef2c54482c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29997712_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/f52a8f53c4666506e6c0ff0d1ac55f71.webp"
"MediaSize" => 197275
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-f52a8f53c4666506e6c0ff0d1ac55f71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29997712_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/aa58a146bedc3a0d9c1d9d867efbf12c.webp"
"MediaSize" => 181155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-aa58a146bedc3a0d9c1d9d867efbf12c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29997712_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/d43cfa8b7b4f00e393329f9b9fa71186.webp"
"MediaSize" => 183913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-d43cfa8b7b4f00e393329f9b9fa71186.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29997712_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/2d33ef2e97cc931feb9a6646a53866ef.webp"
"MediaSize" => 148202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-2d33ef2e97cc931feb9a6646a53866ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29997712_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/a235af8ff6694bd37df6e521d0eeda8c.webp"
"MediaSize" => 213457
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-a235af8ff6694bd37df6e521d0eeda8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29997712_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/e94884a53be96de92548a3b7498c6b3d.webp"
"MediaSize" => 235504
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-e94884a53be96de92548a3b7498c6b3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29997712_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/0e29a640648fdbb6124e9071a70485ed.webp"
"MediaSize" => 181074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-0e29a640648fdbb6124e9071a70485ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29997712_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/87627cd1825d14f5e4d33485fb2e2f8c.webp"
"MediaSize" => 216256
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-87627cd1825d14f5e4d33485fb2e2f8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29997712_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/b8429cb2f2c160d7fe806f10715c2ae2.webp"
"MediaSize" => 185977
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-b8429cb2f2c160d7fe806f10715c2ae2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29997712_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/e651e0ec01da4362648ef2960861260e.webp"
"MediaSize" => 167252
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-e651e0ec01da4362648ef2960861260e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29997712_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/8157f132d462b3d013c07ae3bea352ea.webp"
"MediaSize" => 131284
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-8157f132d462b3d013c07ae3bea352ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29997712_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/0687500a7eb5fd433c7ff2d00ced49e5.webp"
"MediaSize" => 205593
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-0687500a7eb5fd433c7ff2d00ced49e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29997712_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/dbd4d69f24f6d73060fd788504b0e3df.webp"
"MediaSize" => 193661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-dbd4d69f24f6d73060fd788504b0e3df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29997712_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/da1cef274d3005d0ff049a3ac16294dd.webp"
"MediaSize" => 168669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-da1cef274d3005d0ff049a3ac16294dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29997712_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/72f9fa7323d5c12776df62d06dfd3e98.webp"
"MediaSize" => 174629
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-72f9fa7323d5c12776df62d06dfd3e98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
28 => array:13 [
"Order" => 32
"MediaKey" => "29997712_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/0fa20ec408a036a1afc059aecf8dcf5c.webp"
"MediaSize" => 231974
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-0fa20ec408a036a1afc059aecf8dcf5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
29 => array:13 [
"Order" => 33
"MediaKey" => "29997712_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/d52969a7089e10136203df3238a5378e.webp"
"MediaSize" => 168735
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-d52969a7089e10136203df3238a5378e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
30 => array:13 [
"Order" => 34
"MediaKey" => "29997712_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/d16bf9ef9916f98f7e75a710ebc43efe.webp"
"MediaSize" => 209955
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-d16bf9ef9916f98f7e75a710ebc43efe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
31 => array:13 [
"Order" => 35
"MediaKey" => "29997712_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/a2d86d366bb5d465cfe1980c49fee3fe.webp"
"MediaSize" => 407167
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-a2d86d366bb5d465cfe1980c49fee3fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
32 => array:13 [
"Order" => 36
"MediaKey" => "29997712_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/af5465058cbdab34bb40a979d31045a0.webp"
"MediaSize" => 322983
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-af5465058cbdab34bb40a979d31045a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
33 => array:13 [
"Order" => 37
"MediaKey" => "29997712_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/5b9f5885f2642c50330420c1d5a6d0ea.webp"
"MediaSize" => 300286
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-5b9f5885f2642c50330420c1d5a6d0ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T05:38:16.51Z"
]
34 => array:13 [
"Order" => 29
"MediaKey" => "29997712_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/22e1f74b3c3cccf081d15ad7fe4f0c80.webp"
"MediaSize" => 269858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-22e1f74b3c3cccf081d15ad7fe4f0c80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T11:51:12.79Z"
]
35 => array:13 [
"Order" => 30
"MediaKey" => "29997712_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/ee97e969fcc703dc0ff77268af648154.webp"
"MediaSize" => 283343
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-ee97e969fcc703dc0ff77268af648154.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T11:51:12.9Z"
]
36 => array:13 [
"Order" => 31
"MediaKey" => "29997712_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29997712/bffca01584ea2bf4bf22b4d3d45d5561.webp"
"MediaSize" => 261185
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29997712/thumbnail-bffca01584ea2bf4bf22b4d3d45d5561.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13530548"
"ResourceRecordKey" => "29997712"
"ModificationTimestamp" => "2026-07-07T11:51:12.82Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29997712')"
+"ID": "1598978"
}
]
+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 283379" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24901
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2070166" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24870
+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 '29997712'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25258
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29997712'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25274
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29997712' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5840528 43.4564789)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25347
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25321
+post_id: "1602038"
+post_author: 1
+"ListingKey": "30001133"
+"ListingId": "X13533876"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T19:20:09Z"
+"RFModificationTimestamp": "2026-07-07T23:42:49Z"
+"ListPrice": 1099900.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0H1"
+"UnparsedAddress": "294 CHOKECHERRY CRESCENT, Waterloo, Ontario N2V0H1"
+"Coordinates": array:2 [
0 => -80.592862
1 => 43.451488
]
+"Latitude": 43.451488
+"Longitude": -80.592862
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully designed 2,400 sq. ft. single-detached home, ideally situated on a quiet crescent in the highly sought-after Vista Hills neighbourhood. Offering 4 spacious bedrooms and 2.5 bathrooms, this thoughtfully designed home combines modern finishes with functional living spaces, making it perfect for growing families. The bright and airy main floor features 9-foot ceilings and an open-concept layout that seamlessly connects the kitchen, dining, and living areas, creating the perfect space for both everyday living and entertaining. The spacious eat-in kitchen offers abundant cabinetry, a large centre island, and plenty of workspace for family meals and gatherings. Also located on the main level is a convenient laundry/mudroom with direct access to the double-car garage, adding both functionality and convenience to the home's thoughtful design. Upstairs, the impressive primary suite features a walk-in closet and a private 5-piece ensuite. Three additional generously sized bedrooms, and a 4-piece main bathroom complete the second floor. This home also offers numerous upgrades, including quality finishes throughout and insulated garage doors. Located just steps from parks, walking trails, top-rated schools, and recreational facilities. The neighbourhood is also located near The Boardwalk shopping district, Costco, medical centres, and numerous everyday services. Residents benefit from excellent access to public transit and major roadways, including Ira Needles Boulevard, Erb Street West, and Highway 85, providing convenient travel throughout Waterloo Region. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"Basement": array:4 [
0 => "Unfinished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T23:42:43.975692+00:00"
+"Directions": "Cross Streets: SUNDEW DRIVE. ** Directions: FROM COLUMBIA STREET WEST TO SUNDEW DRIVE then to CHOKECHERRY CRESCENT."
+"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": "1973790"
+"ListOfficeKey": "84654"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Irregular lot size"
]
+"LotSizeDimensions": "36 x 98.5 FT ; 36.06 ft x 98.59 ft x 36.06 ft x 98.59ft"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T19:11:35Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T19:11:34Z"
+"Stories": "2.0"
+"StreetName": "Chokecherry"
+"StreetNumber": "294"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "7466"
+"VirtualTourURLUnbranded": "https://sites.odyssey3d.ca/294chokecherrycrescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1677550235"
"RoomType" => "Living room"
"ListingId" => "X13533876"
"RoomLevel" => "Main level"
"RoomWidth" => 2.06
"ListingKey" => "30001133"
"RoomLength" => 4.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T19:11:34.64Z"
]
1 => array:11 [
"RoomKey" => "1677550236"
"RoomType" => "Kitchen"
"ListingId" => "X13533876"
"RoomLevel" => "Main level"
"RoomWidth" => 2.67
"ListingKey" => "30001133"
"RoomLength" => 5.21
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T19:11:34.65Z"
]
2 => array:11 [
"RoomKey" => "1677550237"
"RoomType" => "Laundry room"
"ListingId" => "X13533876"
"RoomLevel" => "Main level"
"RoomWidth" => 2.64
"ListingKey" => "30001133"
"RoomLength" => 2.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T19:11:34.66Z"
]
3 => array:11 [
"RoomKey" => "1677550238"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13533876"
"RoomLevel" => "Second level"
"RoomWidth" => 4.37
"ListingKey" => "30001133"
"RoomLength" => 5.31
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T19:11:34.66Z"
]
4 => array:11 [
"RoomKey" => "1677550239"
"RoomType" => "Bedroom 2"
"ListingId" => "X13533876"
"RoomLevel" => "Second level"
"RoomWidth" => 3.53
"ListingKey" => "30001133"
"RoomLength" => 3.63
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T19:11:34.66Z"
]
5 => array:11 [
"RoomKey" => "1677550240"
"RoomType" => "Bedroom 3"
"ListingId" => "X13533876"
"RoomLevel" => "Second level"
"RoomWidth" => 3.48
"ListingKey" => "30001133"
"RoomLength" => 3.02
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T19:11:34.66Z"
]
6 => array:11 [
"RoomKey" => "1677550241"
"RoomType" => "Bedroom 4"
"ListingId" => "X13533876"
"RoomLevel" => "Second level"
"RoomWidth" => 2.95
"ListingKey" => "30001133"
"RoomLength" => 3.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T19:11:34.66Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30001133/294-chokecherry-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 36.0
+"OriginalEntryTimestamp": "2026-07-07T19:11:34.37Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1260583"
+"ListOfficeNationalAssociationId": "1145170"
+"Media": array:48 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30001133_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001133/537e89278a9b6bf50ae5e4416a0bb7c2.webp"
"MediaSize" => 299093
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001133/thumbnail-537e89278a9b6bf50ae5e4416a0bb7c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13533876"
"ResourceRecordKey" => "30001133"
"ModificationTimestamp" => "2026-07-07T19:11:34.41Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30001133_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001133/4c681b48bd6f4bebc610471e9b5c4604.webp"
"MediaSize" => 308985
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001133/thumbnail-4c681b48bd6f4bebc610471e9b5c4604.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533876"
"ResourceRecordKey" => "30001133"
"ModificationTimestamp" => "2026-07-07T19:11:34.41Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30001133_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001133/8b6b4ffa78a39f733edb8f725eb2b159.webp"
"MediaSize" => 167648
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001133/thumbnail-8b6b4ffa78a39f733edb8f725eb2b159.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533876"
"ResourceRecordKey" => "30001133"
"ModificationTimestamp" => "2026-07-07T19:11:34.41Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30001133_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001133/6d5162cee12538d0d453748244de4fcb.webp"
"MediaSize" => 164250
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001133/thumbnail-6d5162cee12538d0d453748244de4fcb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533876"
"ResourceRecordKey" => "30001133"
"ModificationTimestamp" => "2026-07-07T19:11:34.41Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30001133_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001133/f8b3b38e1eac4939a63c73a5cfff2e76.webp"
"MediaSize" => 181715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001133/thumbnail-f8b3b38e1eac4939a63c73a5cfff2e76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533876"
"ResourceRecordKey" => "30001133"
"ModificationTimestamp" => "2026-07-07T19:11:34.41Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30001133_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001133/6917d5e55be02c421f63fd30b627a70a.webp"
"MediaSize" => 140974
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001133/thumbnail-6917d5e55be02c421f63fd30b627a70a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533876"
"ResourceRecordKey" => "30001133"
"ModificationTimestamp" => "2026-07-07T19:11:34.41Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30001133_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001133/5c94609e002d365026a673a26c7a0055.webp"
"MediaSize" => 155901
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001133/thumbnail-5c94609e002d365026a673a26c7a0055.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533876"
"ResourceRecordKey" => "30001133"
"ModificationTimestamp" => "2026-07-07T19:11:34.41Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30001133_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001133/66ffd2126f018078c0249b05f7b8a9af.webp"
"MediaSize" => 183020
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001133/thumbnail-66ffd2126f018078c0249b05f7b8a9af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533876"
"ResourceRecordKey" => "30001133"
"ModificationTimestamp" => "2026-07-07T19:11:34.41Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30001133_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001133/fe8a1aa904862aee10dd1e025424f216.webp"
"MediaSize" => 214015
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001133/thumbnail-fe8a1aa904862aee10dd1e025424f216.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533876"
"ResourceRecordKey" => "30001133"
"ModificationTimestamp" => "2026-07-07T19:11:34.41Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30001133_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001133/55153729b450019fa6b8bfd84e9b21c7.webp"
"MediaSize" => 197222
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001133/thumbnail-55153729b450019fa6b8bfd84e9b21c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533876"
"ResourceRecordKey" => "30001133"
"ModificationTimestamp" => "2026-07-07T19:11:34.41Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30001133_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001133/99757a6ab2cf85e33b88937566962dc4.webp"
"MediaSize" => 192675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001133/thumbnail-99757a6ab2cf85e33b88937566962dc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533876"
"ResourceRecordKey" => "30001133"
"ModificationTimestamp" => "2026-07-07T19:11:34.41Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30001133_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001133/88323eab20f4ee2d567b503a4ef0add2.webp"
"MediaSize" => 235607
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001133/thumbnail-88323eab20f4ee2d567b503a4ef0add2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533876"
"ResourceRecordKey" => "30001133"
"ModificationTimestamp" => "2026-07-07T19:11:34.41Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30001133_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001133/dc22903cd74b36ab2fa1489dc3971290.webp"
"MediaSize" => 199994
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001133/thumbnail-dc22903cd74b36ab2fa1489dc3971290.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533876"
"ResourceRecordKey" => "30001133"
"ModificationTimestamp" => "2026-07-07T19:11:34.41Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30001133_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001133/4179eee26b5f251539dcea1ffc43350c.webp"
"MediaSize" => 201082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001133/thumbnail-4179eee26b5f251539dcea1ffc43350c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533876"
"ResourceRecordKey" => "30001133"
"ModificationTimestamp" => "2026-07-07T19:11:34.41Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30001133_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001133/8490c1e4f55599ba6ea9e7a682626359.webp"
"MediaSize" => 216786
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001133/thumbnail-8490c1e4f55599ba6ea9e7a682626359.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533876"
"ResourceRecordKey" => "30001133"
"ModificationTimestamp" => "2026-07-07T19:11:34.41Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30001133_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001133/f1e8258fdf3a10780e62dedf106289ac.webp"
"MediaSize" => 228179
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001133/thumbnail-f1e8258fdf3a10780e62dedf106289ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
…4
]
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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30001133')"
+"ID": "1602038"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25342
+post_id: "1600759"
+post_author: 1
+"ListingKey": "29999459"
+"ListingId": "40844340"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T16:25:13Z"
+"RFModificationTimestamp": "2026-07-07T19:43:57Z"
+"ListPrice": 1189900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2882.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N5"
+"UnparsedAddress": "561 CHANCERY Lane, Waterloo, Ontario N2T2N5"
+"Coordinates": array:2 [
0 => -80.5790434
1 => 43.4650221
]
+"Latitude": 43.4650221
+"Longitude": -80.5790434
+"YearBuilt": 1994
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 561 Chancery Lane, Waterloo – a beautifully open and spacious backsplit nestled in one of Waterloo’s most desirable neighbourhoods. Offering 3 bedrooms, 3 full bathrooms, and exceptional indoor and outdoor living spaces, this home is designed for both everyday comfort and entertaining. The bright and inviting main level features soaring cathedral ceilings, hardwood flooring, and an open-concept living and dining area filled with natural light. The gourmet kitchen is sure to impress with stainless appliances, double wall ovens, a gas cooktop, built-in Miele coffee maker, and a spacious island perfect for gathering with family and friends. The lower level is an entertainer’s dream, showcasing a stylish bar area, custom built-ins, heated slate flooring, and a convenient walk-up to the backyard. A 3-piece bathroom on this level adds functionality and convenience for guests. Upstairs, you'll find three generously sized bedrooms and an updated 4-piece bathroom. The primary bedroom offers the added luxury of a private 3-piece ensuite. The basement provides excellent flexibility and can be used as a home gym, office, additional bedroom, or hobby space. A dedicated laundry room completes this level. Step outside to your own backyard retreat featuring a heated inground pool surrounded by stamped concrete. The cabana is fully equipped with hydro, speakers, a ceiling fan, and a fireplace, creating the perfect setting for summer entertaining. A separate pool house provides ample storage for all your pool equipment and accessories. Completing this home is a double attached garage and an exceptional location close to parks, shopping, and everyday amenities. Families will appreciate being situated within the highly sought-after school catchment for Laurelwood P.S., St. Nicholas Catholic School, Laurel Heights S.S., and Resurrection Catholic S.S., making this an outstanding place to call home. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
8 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T19:43:49.423369+00:00"
+"Directions": "Columbia/Chancery Lane"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Metal"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908292"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T16:18:23Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T16:18:23Z"
+"Stories": "3.0"
+"StreetName": "CHANCERY"
+"StreetNumber": "561"
+"StreetSuffix": "Lane"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "7433.43"
+"VirtualTourURLUnbranded": "https://youriguide.com/561_chancery_lane_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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29999459/561-chancery-lane-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 2130
+"BelowGradeFinishedArea": 752
+"OriginalEntryTimestamp": "2026-07-07T16:18:23.82Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1221205"
+"ListOfficeNationalAssociationId": "1378680"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29999459')"
+"ID": "1600759"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25320
+post_id: "1600092"
+post_author: 1
+"ListingKey": "30000354"
+"ListingId": "40845142"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T17:55:15Z"
+"RFModificationTimestamp": "2026-07-07T18:48:38Z"
+"ListPrice": 1099900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.082
+"LivingArea": 2421.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0H1"
+"UnparsedAddress": "294 CHOKECHERRY Crescent, Waterloo, Ontario N2V0H1"
+"Coordinates": array:2 [
0 => -80.5928731
1 => 43.4514986
]
+"Latitude": 43.4514986
+"Longitude": -80.5928731
+"YearBuilt": 2022
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully designed 2,400 sq. ft. single-detached home, ideally situated on a quiet crescent in the highly sought-after Vista Hills neighbourhood. Offering 4 spacious bedrooms and 2.5 bathrooms, this thoughtfully designed home combines modern finishes with functional living spaces, making it perfect for growing families. The bright and airy main floor features 9-foot ceilings and an open-concept layout that seamlessly connects the kitchen, dining, and living areas, creating the perfect space for both everyday living and entertaining. The spacious eat-in kitchen offers abundant cabinetry, a large centre island, and plenty of workspace for family meals and gatherings. Also located on the main level is a convenient laundry/mudroom with direct access to the double-car garage, adding both functionality and convenience to the home's thoughtful design. Upstairs, the impressive primary suite features a walk-in closet and a private 5-piece ensuite. Three additional generously sized bedrooms, and a 4-piece main bathroom complete the second floor. This home also offers numerous upgrades, including quality finishes throughout and insulated garage doors. Located just steps from parks, walking trails, top-rated schools, and recreational facilities. The neighbourhood is also located near The Boardwalk shopping district, Costco, medical centres, and numerous everyday services. Residents benefit from excellent access to public transit and major roadways, including Ira Needles Boulevard, Erb Street West, and Highway 85, providing convenient travel throughout Waterloo Region. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T18:48:26.545815+00:00"
+"Directions": "FROM COLUMBIA STREET WEST TO SUNDEW DRIVE then to CHOKECHERRY CRESCENT"
+"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": "1750657"
+"ListOfficeKey": "156288"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.082"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T17:48:38Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T17:48:38Z"
+"Stories": "2.0"
+"StreetName": "CHOKECHERRY"
+"StreetNumber": "294"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "7466"
+"VirtualTourURLUnbranded": "https://sites.odyssey3d.ca/294chokecherrycrescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30000354/294-chokecherry-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2421
+"OriginalEntryTimestamp": "2026-07-07T17:48:38.36Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1066259"
+"ListOfficeNationalAssociationId": "1112493"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30000354')"
+"ID": "1600092"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25344
+post_id: "1598749"
+post_author: 1
+"ListingKey": "29997266"
+"ListingId": "40845459"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T01:55:15Z"
+"RFModificationTimestamp": "2026-07-07T04:43:07Z"
+"ListPrice": 1565000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3582.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0C3"
+"UnparsedAddress": "257 LADYSLIPPER Drive, Waterloo, Ontario N2V0C3"
+"Coordinates": array:2 [
0 => -80.5933448
1 => 43.4558864
]
+"Latitude": 43.4558864
+"Longitude": -80.5933448
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "AWARD WINNING BUILDER BREXON HOMES****OPEN HOUSE SUNDAY 2-4 PM****VISTA HILLS***EAST FACING, BOASTING OVER 3580 + SQUARE FEET, WALKOUT BASEMENT, BACKING ONTO GREENSPACE, PREMIUM LOT! Modern finishes throughout. Large foyer entry with double door entry. This executive family home is brand new and move in ready. Features include a main floor office with French Doors for the elegant touch. Huge family room open to the kitchen with QUARTZ COUNTER TOPS & BACKSPLASH! 9 foot ceilings, pot lights, modern millwork and trim. Spacious dinette with GREENSPACE VIEWS. Walkout to your private covered porch perfect for BBQ's and morning coffee. Kitchen features walk in pantry and butler prep area/server. Mudroom off of the garage is ideal for your growing family. Upstairs leads to UPPER FLOOR FAMILY ROOM with VAULTED CEILINGS and pot lights. Carpet free makes it an ideal playroom for kids or hangout space. 4 BEDROOMS PLUS , 3 FULL BATHS (2 ensuites) ticks all the boxes! Primary bedrooms with MASSIVE walk in closet, coffered tray ceilings and GREENSPACE VIEWS. Ensuite features additional cabinetry, soaker tub and large luxury shower. 3 additional bedrooms are good sizes with walk in closet and ensuite! Upper floor laundry room with cabinets. Lower level WALKOUT BASEMENT BACKING ONTO GREENSPACE lends itself to countless possibilities such as INLAW SET UP or REC ROOM. Photos are virtually staged. (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T04:43:04.761885+00:00"
+"Directions": "Columbia St. West to Ladyslipper Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1600661"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Backs on greenbelt"
1 => "Conservation/green belt"
2 => "Crushed stone driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T01:48:08Z"
+"PhotosCount": 32
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T01:48:08Z"
+"Stories": "2.0"
+"StreetName": "LADYSLIPPER"
+"StreetNumber": "257"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "1"
+"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/29997266/257-ladyslipper-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 49.0
+"AboveGradeFinishedArea": 3582
+"OriginalEntryTimestamp": "2026-07-07T01:48:08.42Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1155649"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:32 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29997266')"
+"ID": "1598749"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25322
+post_id: "1596331"
+post_author: 1
+"ListingKey": "29994028"
+"ListingId": "X13527304"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T17:35:32Z"
+"RFModificationTimestamp": "2026-07-06T19:15:32Z"
+"ListPrice": 1199000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0H8"
+"UnparsedAddress": "565 BALSAM POPLAR STREET, Waterloo, Ontario N2V0H8"
+"Coordinates": array:2 [
0 => -80.599902
1 => 43.457707
]
+"Latitude": 43.457707
+"Longitude": -80.599902
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Client RemarksThis stunning 3,000+ sqft home offers the potential for an elevator and features a spacious double-car garage with a separate entrance to the finished basement. Large basement windows and also has the option to add a legal basement apartment. The garage itself is exceptionally large, providing ample storage and parking space. The house has 4 generously sized bedrooms, including two luxurious master suites, plus a dedicated home office perfect for remote work or study. The home boasts 4.5 bathrooms, ensuring comfort and privacy for the whole family. Designed for modern efficiency and comfort, this home is equipped with a dual-fuel furnace, air-source heat pump, and an ERV system, promoting superior air quality and energy savings. High-end finishes include 9-ft ceilings on both the main and second floors, and elegant hardwood flooring throughout the second floor. Conveniently located near shopping plazas, Costco, Highway 85, and the famous St. Jacobs Market, this home offers both luxury and accessibility in a prime location. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-06T19:15:24.356618+00:00"
+"Directions": "Cross Streets: Columbia St W/ Platinum Dr. ** Directions: Found on the west side of street near Sundew Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick Facing"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2221801"
+"ListOfficeKey": "280107"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "36.2 x 98.6 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T17:11:31Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T17:11:31Z"
+"Stories": "3.0"
+"StreetName": "Balsam Poplar"
+"StreetNumber": "565"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "8851.36"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29994028/565-balsam-poplar-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 36.2
+"OriginalEntryTimestamp": "2026-07-06T17:11:31.13Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1465441"
+"ListOfficeNationalAssociationId": "1309558"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29994028')"
+"ID": "1596331"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25317
+post_id: "1593193"
+post_author: 1
+"ListingKey": "29989193"
+"ListingId": "X13522394"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T13:40:41Z"
+"RFModificationTimestamp": "2026-07-04T16:50:30Z"
+"ListPrice": 679000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2Y1"
+"UnparsedAddress": "760 PARIS BOULEVARD, Waterloo, Ontario N2T2Y1"
+"Coordinates": array:2 [
0 => -80.574452
1 => 43.449168
]
+"Latitude": 43.449168
+"Longitude": -80.574452
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained freehold end-unit townhome in the highly sought-after Clair Hills community of Waterloo. Offering over 1,400 sq. ft. above grade plus a fully finished basement, this spacious home features 3+2 bedrooms and 3 bathrooms, making it an exceptional choice for growing families, multi-generational living, or buyers seeking added flexibility. The bright main floor offers a functional open-concept layout with a spacious living room, an eat-in kitchen, and sliding doors leading to a private backyard deck, perfect for relaxing or entertaining. Upstairs, the generous primary bedroom features a walk-in closet with semi-ensuite access, complemented by two additional bedrooms. The fully finished basement adds two additional bedrooms, a full bathroom, and a rough-in kitchen, creating outstanding flexibility for extended family, guests, a home business, or future in-law suite possibilities. As an end unit, the home enjoys additional windows, abundant natural light, enhanced privacy, and a larger side yard. Additional features include an attached garage with inside entry, parking for 2 vehicles (1 garage & 1driveway), central air conditioning, and a roof replaced in 2022. Families will appreciate being within the highly regarded Laurel Heights Secondary School boundary, along with excellent elementary schools, nearby parks, walking trails, and playgrounds. The location also offers easy public transit access to the University of Waterloo, making commuting simple for students and faculty alike. Everyday conveniences are just minutes away at The Boardwalk Shopping Centre, featuring Costco, Walmart, Landmark Cinemas, restaurants, cafés, medical services, and countless retail amenities. With quick access to Laurel Creek Conservation Area, The Hydrocut, and major commuter routes, this move-in-ready freehold end-unit offers an exceptional lifestyle in one of Waterloo's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-04T16:50:27.634629+00:00"
+"Directions": "Cross Streets: Erbsville Road and Erb Street. ** Directions: Erbsville Rd to Chablis, Left on Paris."
+"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": "1418255"
+"ListOfficeKey": "90198"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "26.9 x 99.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-04T13:34:22Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T13:34:22Z"
+"Stories": "2.0"
+"StreetName": "Paris"
+"StreetNumber": "760"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "3863"
+"VirtualTourURLUnbranded": "https://iguideradix.com/760_paris_blvd_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": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29989193/760-paris-boulevard-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2188755"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "291409"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 26.1
+"OriginalEntryTimestamp": "2026-07-04T13:34:22.52Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1105101"
+"ListOfficeNationalAssociationId": "1153615"
+"CoListAgentNationalAssociationId": "1437820"
+"CoListOfficeNationalAssociationId": "1397659"
+"Media": array:49 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29989193')"
+"ID": "1593193"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23461
+post_id: "1593233"
+post_author: 1
+"ListingKey": "29989099"
+"ListingId": "40844983"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T15:35:15Z"
+"RFModificationTimestamp": "2026-07-04T15:54:26Z"
+"ListPrice": 1139900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2550.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G2"
+"UnparsedAddress": "573 MAYAPPLE Street, Waterloo, Ontario N2V0G2"
+"Coordinates": array:2 [
0 => -80.5992488
1 => 43.4588412
]
+"Latitude": 43.4588412
+"Longitude": -80.5992488
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rarely offered former model home stands out as one of the most desirable family residences within the prestigious Vista Hills Public School boundary. Boasting striking modern exterior with stone, brick, and stucco accents, undeniable Luxury curb appeal on both sides of Mayapple St & Canada Plum St. Step inside, the home is filled with premium upgrades and thoughtful design elements, this is the turnkey opportunity that today’s buyers have been waiting for. Flooded with natural light from east to west, the home offers an elevated living experience. Warm morning sun and calm, cinematic evening light naturally bring the family together. The open-concept main floor boasts 9-foot ceilings, a convenient powder room and laundry room with soaring 11.5' high ceilings. An upgraded chef’s kitchen with a massive central island—the ultimate hub for daily family life. Upstairs, you’ll find 4 spacious bedrooms and 2 full bathrooms, including a spa-inspired primary suite with a beautifully tiled glass walk-in shower. The unspoiled basement provides lots of storage spaces. Double car garage plus double decorative exposed aggregate concrete driveway. Near Vista Hill Public School, Costco, Long Hiking Trails, and a short drive to both Universities and all other amenities. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-04T13:50:06.846491+00:00"
+"Directions": "Sundew Dr to Mayapple St"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1970409"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Crushed stone driveway"
1 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-04T15:31:45Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T15:31:45Z"
+"Stories": "2.0"
+"StreetName": "MAYAPPLE"
+"StreetNumber": "573"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "8069"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/573-Mayapple-St"
+"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/29989099/573-mayapple-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "NR-SL"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 44.0
+"AboveGradeFinishedArea": 2550
+"OriginalEntryTimestamp": "2026-07-04T12:28:39.53Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1257707"
+"ListOfficeNationalAssociationId": "1452740"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29989099')"
+"ID": "1593233"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25345
+post_id: "1593240"
+post_author: 1
+"ListingKey": "29989116"
+"ListingId": "40845198"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T14:05:19Z"
+"RFModificationTimestamp": "2026-07-06T14:06:13Z"
+"ListPrice": 679000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1433.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2Y1"
+"UnparsedAddress": "760 PARIS Boulevard, Waterloo, Ontario N2T2Y1"
+"Coordinates": array:2 [
0 => -80.574427
1 => 43.4491534
]
+"Latitude": 43.4491534
+"Longitude": -80.574427
+"YearBuilt": 2007
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained freehold end-unit townhome in the highly sought-after Clair Hills community of Waterloo. Offering over 1,400 sq. ft. above grade plus a fully finished basement, this spacious home features 3+2 bedrooms and 3 bathrooms, making it an exceptional choice for growing families, multi-generational living, or buyers seeking added flexibility. The bright main floor offers a functional open-concept layout with a spacious living room, an eat-in kitchen, and sliding doors leading to a private backyard deck—perfect for relaxing or entertaining. Upstairs, the generous primary bedroom features a walk-in closet with semi-ensuite access, complemented by two additional bedrooms. The fully finished basement adds two additional bedrooms, a full bathroom, and a rough-in kitchen, creating outstanding flexibility for extended family, guests, a home business, or future in-law suite possibilities. As an end unit, the home enjoys additional windows, abundant natural light, enhanced privacy, and a larger side yard. Additional features include an attached garage with inside entry, parking for 2 vehicles (1 garage & 1 driveway), central air conditioning, and a roof replaced in 2022. Families will appreciate being within the highly regarded Laurel Heights Secondary School boundary, along with excellent elementary schools, nearby parks, walking trails, and playgrounds. The location also offers easy public transit access to the University of Waterloo, making commuting simple for students and faculty alike. Everyday conveniences are just minutes away at The Boardwalk Shopping Centre, featuring Costco, Walmart, Landmark Cinemas, restaurants, cafés, medical services, and countless retail amenities. With quick access to Laurel Creek Conservation Area, The Hydrocut, and major commuter routes, this move-in-ready freehold end-unit offers an exceptional lifestyle in one of Waterloo's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:7 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-04T13:49:09.564563+00:00"
+"Directions": "Erbsville Rd. to Chablis, left on Paris"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2180828"
+"ListOfficeKey": "290853"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-04T12:48:23Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T13:59:28Z"
+"Stories": "2.0"
+"StreetName": "PARIS"
+"StreetNumber": "760"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3863"
+"VirtualTourURLUnbranded": "https://iguideradix.com/760_paris_blvd_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/29989116/760-paris-boulevard-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 27.0
+"AboveGradeFinishedArea": 1433
+"OriginalEntryTimestamp": "2026-07-04T12:48:23.48Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1430684"
+"ListOfficeNationalAssociationId": "1394395"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29989116')"
+"ID": "1593240"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25346
+post_id: "1590429"
+post_author: 1
+"ListingKey": "29986610"
+"ListingId": "40844919"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T14:50:05Z"
+"RFModificationTimestamp": "2026-07-06T14:56:19Z"
+"ListPrice": 927500.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2692.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V6"
+"UnparsedAddress": "439 WOODROW Drive, Waterloo, Ontario N2T2V6"
+"Coordinates": array:2 [
0 => -80.5847827
1 => 43.4697703
]
+"Latitude": 43.4697703
+"Longitude": -80.5847827
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled in Waterloo's highly sought after Laurelwood neighbourhood, this beautifully renovated backsplit offers the perfect balance of modern updates, functional living space, and an incredible outdoor retreat. Every level of this home has been thoughtfully updated, making it truly move in ready. The beautifully designed kitchen (2016) serves as the heart of the home, showcasing quartz countertops, a spacious centre island, and abundant cabinetry. Whether you're preparing family meals or hosting friends, the open layout seamlessly connects the kitchen to the bright living and dining areas, creating an ideal space for everyday living and entertaining. A few steps down, the inviting family room is the perfect place to unwind, featuring a stylish gas fireplace with a custom mantel (2021) and patio doors that open to your own private backyard sanctuary. Enjoy beautifully landscaped perennial gardens, a charming gazebo, and an outdoor BBQ with prep station all included creating an exceptional setting for summer gatherings or peaceful evenings outdoors. The lower level features a flexible fourth bedroom or home office, a beautifully updated 3 piece bathroom (2018), a convenient laundry room, and direct access to the side entrance. The fully finished basement provides more living space with a generous recreation room, utility area, and extensive storage options to meet the needs of a growing family. Upstairs, you'll find three spacious bedrooms, including a relaxing primary retreat, along with a tastefully renovated 4npiece bathroom (2020). Additional features include a double car garage with EV charger rough in, a concrete driveway accommodating 4 vehicles, and quality finishes throughout. Ideally situated close to excellent schools, parks, scenic walking trails, shopping, universities, and all the amenities Waterloo has to offer, this exceptional Laurelwood home delivers the perfect combination of comfort, style, and location. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T20:06:47.479378+00:00"
+"Directions": "Laurelwood to Old Oak Dr to Woodrow Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1958320"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Gazebo"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T14:41:25Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T14:48:26Z"
+"Stories": "3.0"
+"StreetName": "WOODROW"
+"StreetNumber": "439"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5946"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/439_woodrow_dr_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/29986610/439-woodrow-drive-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1564580"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2037
+"BelowGradeFinishedArea": 655
+"OriginalEntryTimestamp": "2026-07-03T19:18:19.14Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1249173"
+"ListOfficeNationalAssociationId": "1389824"
+"CoListAgentNationalAssociationId": "1069941"
+"CoListOfficeNationalAssociationId": "1004387"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986610')"
+"ID": "1590429"
}
]
+success: true
+page_size: 9
+page_count: 11
+count: 97
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]