array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29867339 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23406
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23408
+post_id: "1504824"
+post_author: 1
+"ListingKey": "29867339"
+"ListingId": "X13411856"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T12:35:09Z"
+"RFModificationTimestamp": "2026-06-15T15:39:18Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2X9"
+"UnparsedAddress": "520 CHABLIS DRIVE, Waterloo, Ontario N2T2X9"
+"Coordinates": array:2 [
0 => -80.575159
1 => 43.450204
]
+"Latitude": 43.450204
+"Longitude": -80.575159
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 520 Chablis Drive, Waterloo! Whole house newly painted, The Seller has decided to replace all windows throughout the house, along with the main-floor sliding door leading to the backyard deck. Vacant house, ready to move in , Located in one of Waterloo's most desirable, family-friendly, calm, and quiet neighborhoods, this beautiful carpet-free home offers exceptional convenience-just minutes to The Boardwalk, Costco, shopping, schools, and all major amenities. The main floor features an open-concept layout with a spacious kitchen, cathedral ceiling in the great room, and a sliding door walkout to the back deck and landscaped backyard. The welcoming front entrance opens into a bright hallway leading to the living room. To the right is a powder room and the kitchen; to the left is a dedicated dining room-perfect for family gatherings and entertaining. The second floor offers 3 bedrooms, including a generous primary bedroom with its own ensuite. Two additional good-sized bedrooms share a full main bathroom. The fully finished basement adds valuable living space with a large recreation room complete with countertop, sink, and cabinetry-ideal for entertaining or extended family. A full bathroom, cold cellar, laundry area, and utility room complete the lower level. Upgrades & Features: Kitchen countertop and island with quartz, interior paint (2023), Washer/Dryer/Stove (2022), Two cooking lines: Hydro/Gas, Air Conditioner (2022), Water Softener (2022), Furnace (2018), Roof (2017), Concrete driveway (2024), Properly insulated cold room. Garage door remote sold as is. A wonderful opportunity to own a well-maintained home in a prime Waterloo location! (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-07T16:42:40.138733+00:00"
+"Directions": "Cross Streets: Erbsville Rd/Chablis Dr. ** Directions: Erbsville Road to Chablis Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2136085"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Irregular lot size"
1 => "Carpet Free"
2 => "Sump Pump"
3 => "In-Law Suite"
]
+"LotSizeDimensions": "28 x 105 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-07T14:46:31Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T12:27:22Z"
+"Stories": "2.0"
+"StreetName": "Chablis"
+"StreetNumber": "520"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4261"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1659772057"
"RoomType" => "Kitchen"
"ListingId" => "X13411856"
"RoomLevel" => "Main level"
"RoomWidth" => 2.95
"ListingKey" => "29867339"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T12:27:22.8Z"
]
1 => array:11 [
"RoomKey" => "1659772058"
"RoomType" => "Bathroom"
"ListingId" => "X13411856"
"RoomLevel" => "Second level"
"RoomWidth" => 1.52
"ListingKey" => "29867339"
"RoomLength" => 2.82
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T12:27:22.8Z"
]
2 => array:11 [
"RoomKey" => "1659772059"
"RoomType" => "Dining room"
"ListingId" => "X13411856"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29867339"
"RoomLength" => 2.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T12:27:22.8Z"
]
3 => array:11 [
"RoomKey" => "1659772060"
"RoomType" => "Living room"
"ListingId" => "X13411856"
"RoomLevel" => "Main level"
"RoomWidth" => 3.63
"ListingKey" => "29867339"
"RoomLength" => 5.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T12:27:22.8Z"
]
4 => array:11 [
"RoomKey" => "1659772061"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13411856"
"RoomLevel" => "Second level"
"RoomWidth" => 3.63
"ListingKey" => "29867339"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T12:27:22.8Z"
]
5 => array:11 [
"RoomKey" => "1659772062"
"RoomType" => "Bedroom"
"ListingId" => "X13411856"
"RoomLevel" => "Second level"
"RoomWidth" => 2.9
"ListingKey" => "29867339"
"RoomLength" => 3.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T12:27:22.8Z"
]
6 => array:11 [
"RoomKey" => "1659772063"
"RoomType" => "Bedroom"
"ListingId" => "X13411856"
"RoomLevel" => "Second level"
"RoomWidth" => 2.79
"ListingKey" => "29867339"
"RoomLength" => 3.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T12:27:22.8Z"
]
7 => array:11 [
"RoomKey" => "1659772064"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13411856"
"RoomLevel" => "Basement"
"RoomWidth" => 4.37
"ListingKey" => "29867339"
"RoomLength" => 5.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T12:27:22.8Z"
]
8 => array:11 [
"RoomKey" => "1659772065"
"RoomType" => "Bathroom"
"ListingId" => "X13411856"
"RoomLevel" => "Basement"
"RoomWidth" => 1.52
"ListingKey" => "29867339"
"RoomLength" => 2.06
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T12:27:22.8Z"
]
9 => array:11 [
"RoomKey" => "1659772066"
"RoomType" => "Bathroom"
"ListingId" => "X13411856"
"RoomLevel" => "Main level"
"RoomWidth" => 1.5
"ListingKey" => "29867339"
"RoomLength" => 1.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T12:27:22.8Z"
]
10 => array:11 [
"RoomKey" => "1659772067"
"RoomType" => "Bathroom"
"ListingId" => "X13411856"
"RoomLevel" => "Second level"
"RoomWidth" => 1.47
"ListingKey" => "29867339"
"RoomLength" => 2.82
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T12:27:22.8Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29867339/520-chablis-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "A"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 28.0
+"OriginalEntryTimestamp": "2026-06-07T14:46:31.19Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1388344"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29867339_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/f9c19a5e0bca6bbb7a334a3919adb4a6.webp"
"MediaSize" => 379146
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-f9c19a5e0bca6bbb7a334a3919adb4a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29867339_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/e89358c48d230ff6091da255b3564a6b.webp"
"MediaSize" => 152495
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-e89358c48d230ff6091da255b3564a6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29867339_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/9c894e5edec860801c3c9a7ae553b0dd.webp"
"MediaSize" => 168243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-9c894e5edec860801c3c9a7ae553b0dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29867339_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/d0f5c3f008d8687c91435afa35cfef30.webp"
"MediaSize" => 183836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-d0f5c3f008d8687c91435afa35cfef30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29867339_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/697e5b727a024d038e21e024053718ae.webp"
"MediaSize" => 192201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-697e5b727a024d038e21e024053718ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29867339_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/93a4bcc24b5b2d1a7ba178ff35d91e19.webp"
"MediaSize" => 222488
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-93a4bcc24b5b2d1a7ba178ff35d91e19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29867339_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/c28d41620d19a295b0fdf0aaadcb4a59.webp"
"MediaSize" => 239827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-c28d41620d19a295b0fdf0aaadcb4a59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29867339_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/6998b0df98a11b59a947190f38a382da.webp"
"MediaSize" => 141728
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-6998b0df98a11b59a947190f38a382da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29867339_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/b25931c014b2f52c5b93fedea3e60840.webp"
"MediaSize" => 70377
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-b25931c014b2f52c5b93fedea3e60840.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29867339_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/02d0c2a7d917cabf76a2374f2313c93e.webp"
"MediaSize" => 59611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-02d0c2a7d917cabf76a2374f2313c93e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29867339_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/2d8a84aa6d5fe2e0e878fe435be6ae19.webp"
"MediaSize" => 76686
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-2d8a84aa6d5fe2e0e878fe435be6ae19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29867339_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/d32e61bf9ac705f1d24ae876535c8d47.webp"
"MediaSize" => 157631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-d32e61bf9ac705f1d24ae876535c8d47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29867339_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/a4334e7d6a34ff182ad825369f572e85.webp"
"MediaSize" => 173003
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-a4334e7d6a34ff182ad825369f572e85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29867339_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/421f1e43ce3ba7b76daa1549e222c17b.webp"
"MediaSize" => 163188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-421f1e43ce3ba7b76daa1549e222c17b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29867339_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/ed6fd47ced518a592840b79cd42f53b2.webp"
"MediaSize" => 201777
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-ed6fd47ced518a592840b79cd42f53b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29867339_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/24b155d69bc67170ad100ec7ec6a7835.webp"
"MediaSize" => 119048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-24b155d69bc67170ad100ec7ec6a7835.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29867339_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/fcc68cdb345e3b5c6495194802ac2ee5.webp"
"MediaSize" => 202723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-fcc68cdb345e3b5c6495194802ac2ee5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29867339_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/ef83975757bfc88dcc6aa0a72c273312.webp"
"MediaSize" => 186086
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-ef83975757bfc88dcc6aa0a72c273312.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29867339_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/e60c9e3bb0145f4dc65393449054c1ad.webp"
"MediaSize" => 129760
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-e60c9e3bb0145f4dc65393449054c1ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29867339_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/743182bf3e361530fd30043fab7f0450.webp"
"MediaSize" => 121950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-743182bf3e361530fd30043fab7f0450.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29867339_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/d69cd6ef2fe57f975b4bf0772d8a6bf3.webp"
"MediaSize" => 109084
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-d69cd6ef2fe57f975b4bf0772d8a6bf3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29867339_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/81919df602b0f924affb69dcb9488b10.webp"
"MediaSize" => 113842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-81919df602b0f924affb69dcb9488b10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29867339_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/46f298290752a949b792285c7e2fac45.webp"
"MediaSize" => 191556
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-46f298290752a949b792285c7e2fac45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29867339_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/d48e43938ae56ffc2cdfdd1c8c6a6bb8.webp"
"MediaSize" => 182226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-d48e43938ae56ffc2cdfdd1c8c6a6bb8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29867339_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/b8acea0412e36eecbad351d66d3e622e.webp"
"MediaSize" => 152137
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-b8acea0412e36eecbad351d66d3e622e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29867339_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/5b3161305ce42e81a9cb5d495c630d41.webp"
"MediaSize" => 133116
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-5b3161305ce42e81a9cb5d495c630d41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29867339_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/ad8b734e7353bdef38b928eceb05d16f.webp"
"MediaSize" => 126965
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-ad8b734e7353bdef38b928eceb05d16f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29867339_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/7779217269ec3d01431816be34b13ebc.webp"
"MediaSize" => 486275
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-7779217269ec3d01431816be34b13ebc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29867339_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/af8ff99bcd4a5d14656130ac26c0e338.webp"
"MediaSize" => 455333
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-af8ff99bcd4a5d14656130ac26c0e338.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29867339_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/dfa686b45d75560230a84adc1f1f4138.webp"
"MediaSize" => 492016
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-dfa686b45d75560230a84adc1f1f4138.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29867339_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867339/7db2582adedc1253c55613fa817515c5.webp"
"MediaSize" => 432868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867339/thumbnail-7db2582adedc1253c55613fa817515c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411856"
"ResourceRecordKey" => "29867339"
"ModificationTimestamp" => "2026-06-07T14:46:31.19Z"
]
]
+"DaysOnMarket": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29867339')"
+"ID": "1504824"
}
]
+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 288578" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24891
+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 2136085" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24864
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29867339'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25194
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29867339'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25211
+items: array:4 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25210
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31404317"
+"ListingKey": "29867339"
+"ListingId": "X13411856"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-13"
+"OpenHouseStartTime": "2026-06-13T14:00:00Z"
+"OpenHouseEndTime": "2026-06-13T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-14T01:48:34Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31404317')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25212
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31404318"
+"ListingKey": "29867339"
+"ListingId": "X13411856"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-14T01:48:34Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31404318')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25209
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31476206"
+"ListingKey": "29867339"
+"ListingId": "X13411856"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-14T10:57:06Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31476206')"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25213
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31481153"
+"ListingKey": "29867339"
+"ListingId": "X13411856"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-15T05:12:07Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31481153')"
}
]
+success: true
+page_size: 4
+page_count: 1
+count: 4
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29867339' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.575159 43.450204)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25271
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25265
+post_id: "1549245"
+post_author: 1
+"ListingKey": "29930561"
+"ListingId": "40841361"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T21:05:28Z"
+"RFModificationTimestamp": "2026-06-19T21:08:54Z"
+"ListPrice": 839900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2321.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2Z3"
+"UnparsedAddress": "570 ST MORITZ Avenue, Waterloo, Ontario N2T2Z3"
+"Coordinates": array:2 [
0 => -80.5830118
1 => 43.453361
]
+"Latitude": 43.453361
+"Longitude": -80.5830118
+"YearBuilt": 2008
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "AN ABSOLUTE GEM! Beautifully maintained home on generous lot with double garage! Inviting front entrance with large covered porch, spacious foyer with 2 pc. bathroom, open concept main floor, gorgeous kitchen with granite countertops, stainless steel appliances, & breakfast bar with 4 bar stools (included), spacious dining area with walkout to new wrap-around deck and beautiful fenced yard, and huge living room with hardwood floors & custom feature wall! The upper floor features an oversized primary bedroom with walk-in closet, fabulous ensuite bathroom with large vanity, double sinks & tiled shower with built-in bench & glass door, 2 additional good sized bedrooms, and 4 pc. main bathroom. Venture downstairs to see the professionally finished basement featuring a large rec room, 2 office areas, and a pull-down Murphy bed! Beautifully landscaped exterior with professionally maintained lawns and attractive gardens. Other features include newer carpeting on upper floor, newer roof (2022), new deck & side privacy fence (2025), new water softener (2025), and interior & exterior painting! Ideal location steps from Edna Staebler pubic school and close to Costco & Canadian Tire plaza! Don't miss out on this exceptional family home! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Range - Gas"
4 => "Dishwasher"
5 => "Dryer"
6 => "Central Vacuum - Roughed In"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T21:08:44.485878+00:00"
+"Directions": "Columbia St. W. to St. Moritz"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564080"
+"ListOfficeKey": "76789"
+"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-06-19T19:51:13Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T20:32:01Z"
+"Stories": "2.0"
+"StreetName": "ST MORITZ"
+"StreetNumber": "570"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5944"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1663260672"
"RoomType" => "Laundry room"
"ListingId" => "40841361"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29930561"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:01.13Z"
]
1 => array:11 [
"RoomKey" => "1663260673"
"RoomType" => "Office"
"ListingId" => "40841361"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29930561"
"RoomLength" => null
"RoomDimensions" => "6'8'' x 14'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:01.13Z"
]
2 => array:11 [
"RoomKey" => "1663260674"
"RoomType" => "Recreation room"
"ListingId" => "40841361"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29930561"
"RoomLength" => null
"RoomDimensions" => "16'9'' x 23'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:01.13Z"
]
3 => array:11 [
"RoomKey" => "1663260675"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841361"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29930561"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:01.13Z"
]
4 => array:11 [
"RoomKey" => "1663260676"
"RoomType" => "Bedroom"
"ListingId" => "40841361"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29930561"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:01.14Z"
]
5 => array:11 [
"RoomKey" => "1663260677"
"RoomType" => "Bedroom"
"ListingId" => "40841361"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29930561"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:01.14Z"
]
6 => array:11 [
"RoomKey" => "1663260678"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841361"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29930561"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:01.14Z"
]
7 => array:11 [
"RoomKey" => "1663260679"
"RoomType" => "Primary Bedroom"
"ListingId" => "40841361"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29930561"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 17'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:01.14Z"
]
8 => array:11 [
"RoomKey" => "1663260680"
"RoomType" => "Dining room"
"ListingId" => "40841361"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930561"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:01.14Z"
]
9 => array:11 [
"RoomKey" => "1663260681"
"RoomType" => "Living room"
"ListingId" => "40841361"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930561"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 18'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:01.15Z"
]
10 => array:11 [
"RoomKey" => "1663260682"
"RoomType" => "Kitchen"
"ListingId" => "40841361"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930561"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 10'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:01.15Z"
]
11 => array:11 [
"RoomKey" => "1663260683"
"RoomType" => "2pc Bathroom"
"ListingId" => "40841361"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930561"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:01.15Z"
]
12 => array:11 [
"RoomKey" => "1663260684"
"RoomType" => "Foyer"
"ListingId" => "40841361"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930561"
"RoomLength" => null
"RoomDimensions" => "5'11'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:32:01.15Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29930561/570-st-moritz-avenue-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "FR G2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 39.0
+"AboveGradeFinishedArea": 1746
+"BelowGradeFinishedArea": 575
+"OriginalEntryTimestamp": "2026-06-19T19:51:13.63Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1070108"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:30 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29930561_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930561/a55ee02153a3ae1fea531a58f938fd60.webp"
"MediaSize" => 146370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930561/thumbnail-a55ee02153a3ae1fea531a58f938fd60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Appealing exterior with double car garage!"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841361"
"ResourceRecordKey" => "29930561"
"ModificationTimestamp" => "2026-06-19T19:51:13.64Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29930561_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930561/e7255b026d2a8bfe884e9bd7b3dd2fca.webp"
"MediaSize" => 178795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930561/thumbnail-e7255b026d2a8bfe884e9bd7b3dd2fca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841361"
"ResourceRecordKey" => "29930561"
"ModificationTimestamp" => "2026-06-19T19:51:13.64Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29930561_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930561/1815d6548adf36647b1732639498a07e.webp"
"MediaSize" => 178089
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930561/thumbnail-1815d6548adf36647b1732639498a07e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Beautifully landscaped front and side yards!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841361"
"ResourceRecordKey" => "29930561"
"ModificationTimestamp" => "2026-06-19T19:51:13.64Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29930561_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930561/810d2bcf125862216670b1cd5629301b.webp"
"MediaSize" => 126310
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930561/thumbnail-810d2bcf125862216670b1cd5629301b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Large covered porch"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841361"
"ResourceRecordKey" => "29930561"
"ModificationTimestamp" => "2026-06-19T19:51:13.64Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29930561_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930561/498b6bca4b77915c7bb32353f681b890.webp"
"MediaSize" => 49584
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930561/thumbnail-498b6bca4b77915c7bb32353f681b890.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious foyer with 2 pc. bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841361"
"ResourceRecordKey" => "29930561"
"ModificationTimestamp" => "2026-06-19T19:51:13.64Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29930561_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930561/a45d79c4a0b98f5a526974eb2e68dff0.webp"
"MediaSize" => 39960
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930561/thumbnail-a45d79c4a0b98f5a526974eb2e68dff0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main floor 2 pc. bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841361"
"ResourceRecordKey" => "29930561"
"ModificationTimestamp" => "2026-06-19T19:51:13.64Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29930561_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930561/e26c9f9305dbbe1b627e564899893a54.webp"
"MediaSize" => 101477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930561/thumbnail-e26c9f9305dbbe1b627e564899893a54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of staircase and open concept main floor"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841361"
"ResourceRecordKey" => "29930561"
"ModificationTimestamp" => "2026-06-19T19:51:13.64Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29930561_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930561/ceb089ad621b1d93ad5e0572fb66fa54.webp"
"MediaSize" => 91862
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930561/thumbnail-ceb089ad621b1d93ad5e0572fb66fa54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Gorgeous kitchen with granite countertops and stainless steel appliances!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841361"
…2
]
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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930561')"
+"ID": "1549245"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25267
+post_id: "1544041"
+post_author: 1
+"ListingKey": "29922564"
+"ListingId": "X13461546"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T19:10:09Z"
+"RFModificationTimestamp": "2026-06-18T19:13:19Z"
+"ListPrice": 999990.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B4"
+"UnparsedAddress": "274 BUTTONBUSH STREET, Waterloo, Ontario N2V0B4"
+"Coordinates": array:2 [
0 => -80.590313
1 => 43.451104
]
+"Latitude": 43.451104
+"Longitude": -80.590313
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This Is The Opportunity Buyers Have Been Waiting For. A Detached 4+1 Bedroom, 4 Bathroom Home With Over 3,000 Sq Ft Of Finished Living Space, Double Garage, Finished Basement With Separate Entrance, And Immediate Vacant Possession - All In One Of Waterloo's Most Sought-After School Communities. Located In The Highly Desired Vista Hills Neighbourhood, Known For Top-Ranked Schools, Parks, Trails, And Family-Friendly Living, This Home Delivers The Space, Location, And Flexibility That Are Almost Impossible To Replace At This Price Point. The Main Floor Offers A Bright Open-Concept Layout With Hardwood Floors, Pot Lights, Large Windows, And A Chef-Inspired Kitchen Featuring Quartz Counters, Stainless Steel Appliances, And An Oversized Centre Island. Upstairs Features A Spacious Primary Retreat With Walk-In Closet And Ensuite, Plus Generous Bedrooms - Including A Rare Jr. Primary-Style Bedroom Ideal For Older Children, Guests, Extended Family, Or A Private Home Office. The Finished Lower Level Adds Major Value With A Full Bedroom, 3-Piece Bath, Large Rec Room, Separate Entrance, And Excellent In-Law Suite Or Income Potential. Vacant, Easy To Show, And Ready For Immediate Closing. If You Have Been Waiting For The Right Waterloo Family Home At The Right Price - This Is It. A Home With This Much Space, In This School District, At This Price Point, Should Not Be Missed! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T18:59:58.572140+00:00"
+"Directions": "Columbia St W and Ladyslipper Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1976739"
+"ListOfficeKey": "238732"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "In-Law Suite"
]
+"LotSizeDimensions": "34.1 x 98.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T19:00:22Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T19:00:21Z"
+"Stories": "2.5"
+"StreetName": "Buttonbush"
+"StreetNumber": "274"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6513.55"
+"VirtualTourURLUnbranded": "https://sites.happyhousegta.com/274buttonbushstreet"
+"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/29922564/274-buttonbush-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 34.1
+"OriginalEntryTimestamp": "2026-06-18T16:44:37.31Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1263079"
+"ListOfficeNationalAssociationId": "1200762"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29922564')"
+"ID": "1544041"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25264
+post_id: "1543514"
+post_author: 1
+"ListingKey": "29921932"
+"ListingId": "40841103"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T16:20:06Z"
+"RFModificationTimestamp": "2026-06-18T17:34:50Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1638.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2P7"
+"UnparsedAddress": "350 ERBSVILLE Road Unit# 13, Waterloo, Ontario N2T2P7"
+"Coordinates": array:2 [
0 => -80.5787185
1 => 43.4610221
]
+"Latitude": 43.4610221
+"Longitude": -80.5787185
+"YearBuilt": 1994
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 350 Erbsville Rd #13, Waterloo! Ideally located in a highly desirable neighbourhood with convenient access to the universities, Tech Park, YMCA, shopping centres, transit, and numerous amenities. This well-maintained home offers excellent potential for first-time buyers, investors, or parents seeking housing for university students. Main floor features a functional layout with a walkout from the living room to a private deck and spacious backyard—perfect for relaxing or entertaining. The finished basement adds valuable living space, complete with a large recreation room featuring good-sized windows, laminate flooring, and a 3-piece bathroom. this home presents a fantastic opportunity to build equity and create a comfortable living space in one of Waterloo’s most sought-after locations. Don't miss this affordable entry into the Waterloo market! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "230"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T17:34:37.381920+00:00"
+"Directions": "olumbia Street W/ Erbsville Road"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1834644"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-18T16:11:13Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T16:11:13Z"
+"Stories": "2.0"
+"StreetName": "ERBSVILLE"
+"StreetNumber": "350"
+"StreetSuffix": "Road"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "3652"
+"View": "City view"
+"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/29921932/350-erbsville-road-unit-13-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD-3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1223
+"BelowGradeFinishedArea": 415
+"OriginalEntryTimestamp": "2026-06-18T15:51:28.04Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1196787"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:23 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921932')"
+"ID": "1543514"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25268
+post_id: "1542297"
+post_author: 1
+"ListingKey": "29920234"
+"ListingId": "40840985"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T16:30:38Z"
+"RFModificationTimestamp": "2026-06-19T16:42:31Z"
+"ListPrice": 1399000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3965.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T0B3"
+"UnparsedAddress": "505 ST MORITZ Avenue, Waterloo, Ontario N2T0B3"
+"Coordinates": array:2 [
0 => -80.5797441
1 => 43.4507512
]
+"Latitude": 43.4507512
+"Longitude": -80.5797441
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this exceptional custom-built two-storey residence nestled in the highly sought-after Clair Hills community. This stunning home offers over three levels of beautifully finished living space, featuring 3+2 bedrooms and 3.5 bathrooms. Meticulously maintained and extensively upgraded over the last three years, the home showcases a beautifully renovated chef-inspired kitchen and a luxurious primary ensuite, along with numerous high-quality improvements throughout. The sophisticated open-concept layout is ideal for both everyday living and entertaining, while the expansive walk-in pantry provides exceptional storage and convenience. The inviting family room is anchored by a striking custom stone fireplace and enhanced by a premium built-in audio system throughout the home. Sliding doors lead to a spacious deck overlooking a private, resort-style backyard oasis complete with a sparkling inground pool, creating the perfect setting for summer enjoyment and outdoor entertaining. Fronting onto St. Moritz Park, the property enjoys exceptional privacy with no rear neighbours, offering a serene, countryside-like setting rarely found within the city. Surrounded by mature greenery and tranquil views, the backyard provides a peaceful retreat that feels miles away from urban living. A functional mudroom with direct garage access adds practicality, while the professionally finished lower level offers additional living space, two bedrooms, full bathroom, and a walk-up to the backyard, providing excellent flexibility for guests, extended family, or recreation. Ideally situated within walking distance to top-rated schools, parks, scenic trails, and everyday amenities, and just minutes from Highways 7 / 8, this remarkable property seamlessly blends luxury, comfort, and convenience in one of Waterloo's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Gas stove(s)"
5 => "Range - Gas"
6 => "Dishwasher"
7 => "Wine Fridge"
8 => "Dryer"
9 => "Central Vacuum - Roughed In"
10 => "Hood Fan"
11 => "Window Coverings"
12 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T05:21:24.245183+00:00"
+"Directions": "Columbia Road/St.Moritz Avenue"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1905477"
+"ListOfficeKey": "296136"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
2 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T04:19:37Z"
+"PhotosCount": 43
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T15:50:37Z"
+"Stories": "2.0"
+"StreetName": "ST MORITZ"
+"StreetNumber": "505"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "8727"
+"VirtualTourURLUnbranded": "https://youriguide.com/505_st_moritz_ave_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/29920234/505-st-moritz-avenue-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2039305"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "296136"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "FR G2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 31.0
+"AboveGradeFinishedArea": 2787
+"BelowGradeFinishedArea": 1178
+"OriginalEntryTimestamp": "2026-06-18T04:19:36.99Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1219577"
+"ListOfficeNationalAssociationId": "1454937"
+"CoListAgentNationalAssociationId": "1315396"
+"CoListOfficeNationalAssociationId": "1454937"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29920234')"
+"ID": "1542297"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25266
+post_id: "1531332"
+post_author: 1
+"ListingKey": "29906172"
+"ListingId": "X13447102"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T00:55:16Z"
+"RFModificationTimestamp": "2026-06-20T00:57:10Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2K6"
+"UnparsedAddress": "629B SETTLERSFIELD COURT, Waterloo, Ontario N2T2K6"
+"Coordinates": array:2 [
0 => -80.569765
1 => 43.449035
]
+"Latitude": 43.449035
+"Longitude": -80.569765
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Prepare to fall in love with this beautifully updated back-split with separate side entrance. Located in a quiet family friendly neighbourhood close to the Boardwalk Costco and more. This 2 plus bedroom boasts 3 full bathrooms, open concept floor plan featuring Stainless steel appliance, quartz countertops, upgraded kitchen cabinets and lighting package plus an attractive staircase. Upstairs you will find 2 bedrooms plus built in laundry and 4 piece bath. You'll love the family-room with large windows for tons of natural light. Full 4 piece bath is within easy reach, there is a side entrance leading to a great deck and a fully fenced pie shaped back yard with mature trees. Looking for extra space then basement level features a brand new inlaw with 2nd kitchen with appliances, good size 3rd bedroom or rec-room plus another 3 piece bathroom for the teens. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
6 => "Water Heater"
]
+"Basement": array:7 [
0 => "Finished"
1 => "Full"
2 => "Apartment in basement"
3 => "Separate entrance"
4 => "N/A"
5 => "N/A"
6 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T20:55:42.913447+00:00"
+"Directions": "Cross Streets: Pinerow. ** Directions: ERBSVILLE ROAD TO RUMMERLHARDT DR TO PINEROW CRES."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2152762"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "24 x 121.7 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T20:02:49Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T00:47:32Z"
+"StreetName": "Settlersfield"
+"StreetNumber": "629B"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "3850"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/629_b_settlersfield_ct_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29906172/629b-settlersfield-court-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 24.0
+"OriginalEntryTimestamp": "2026-06-15T20:02:49.07Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1404760"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29906172')"
+"ID": "1531332"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25261
+post_id: "1525564"
+post_author: 1
+"ListingKey": "29898161"
+"ListingId": "40839319"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T22:05:23Z"
+"RFModificationTimestamp": "2026-06-19T22:09:30Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1322.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2K6"
+"UnparsedAddress": "629 SETTLERSFIELD Court Unit# B, Waterloo, Ontario N2T2K6"
+"Coordinates": array:2 [
0 => -80.569755
1 => 43.4490121
]
+"Latitude": 43.4490121
+"Longitude": -80.569755
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Prepare to fall in love with this beautifully updated backsplit with separate side entrance. Located in a quiet family friendly neighbourhood close to the Boardwalk Costco and more. This 2 plus bedroom boasts 3 full bathrooms, open concept floor plan featuring Stainless steel appliance, quartz countertops, upgraded kitchen cabinets and lighting package plus an attractive staircase. Upstairs you will find 2 bedrooms plus built in laundry and 4 piece bath. You'll love the familyroom with large windows for tons of natural light. Full 4 piece bath is within easy reach, there is a side entrance leading to a great deck and a fully fenced pie shaped back yard with mature trees. Looking for extra space then basement level features a brand new inlaw with 2nd kitchen with appliances, good size 3rd bedroom or recroom plus another 3 piece bathroom for the teens. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T21:37:11.360335+00:00"
+"Directions": "ERBSVILLE ROAD TO RUMMERLHARDT DR TO PINEROW CRES"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1948781"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-06-19T21:51:42Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T21:51:42Z"
+"Stories": "3.0"
+"StreetName": "SETTLERSFIELD"
+"StreetNumber": "629"
+"StreetSuffix": "Court"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "4025"
+"Utilities": array:1 [
0 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/629_b_settlersfield_ct_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …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/29898161/629-settlersfield-court-unit-b-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1563914"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76807"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 24.0
+"AboveGradeFinishedArea": 829
+"BelowGradeFinishedArea": 493
+"OriginalEntryTimestamp": "2026-06-12T21:10:19.47Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1243289"
+"ListOfficeNationalAssociationId": "1380559"
+"CoListAgentNationalAssociationId": "1069671"
+"CoListOfficeNationalAssociationId": "1004370"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898161')"
+"ID": "1525564"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23420
+post_id: "1524680"
+post_author: 1
+"ListingKey": "29894553"
+"ListingId": "40829023"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T14:30:06Z"
+"RFModificationTimestamp": "2026-06-12T20:09:42Z"
+"ListPrice": 429900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1596.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5S7"
+"UnparsedAddress": "417 KEATS Way Unit# 4, Waterloo, Ontario N2L5S7"
+"Coordinates": array:2 [
0 => -80.5566627
1 => 43.4577016
]
+"Latitude": 43.4577016
+"Longitude": -80.5566627
+"YearBuilt": 1977
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Updated and spacious, this Beechwood, 3 bedroom, 2.5 bathroom townhouse offers approximately 1,600 square feet of comfortable living space in a highly desirable Waterloo location. Ideal for first-time buyers, families, or investors, the home features a bright, open living room with built-in shelving and elegant crown molding. Upstairs, you’ll find a large primary bedroom with a walk-in closet, along with two additional generously sized bedrooms. The fully finished basement adds excellent flexibility with a large, versatile rec room, full bathroom, and laundry area. Set in a quiet complex with ample visitor parking and green space, this property is conveniently located close to everyday amenities, including two grocery stores within walking distance, major bus routes, the expressway, and both universities, including walking distance to the University of Waterloo. A well-kept, move-in-ready opportunity in a convenient and sought-after location. (id:62783)"
+"AssociationFee": "612"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T20:09:38.059035+00:00"
+"Directions": "Fischer-Hallman"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564479"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-06-12T14:22:18Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T14:22:18Z"
+"Stories": "2.0"
+"StreetName": "KEATS"
+"StreetNumber": "417"
+"StreetSuffix": "Way"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3014"
+"VirtualTourURLUnbranded": "https://youriguide.com/4_417_keats_way_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29894553/417-keats-way-unit-4-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1366
+"BelowGradeFinishedArea": 230
+"OriginalEntryTimestamp": "2026-06-12T14:22:18.59Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1125580"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29894553')"
+"ID": "1524680"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25269
+post_id: "1524681"
+post_author: 1
+"ListingKey": "29895192"
+"ListingId": "X13436726"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T15:40:12Z"
+"RFModificationTimestamp": "2026-06-12T19:50:47Z"
+"ListPrice": 429900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5S7"
+"UnparsedAddress": "4 - 417 KEATS WAY, Waterloo, Ontario N2L5S7"
+"Coordinates": array:2 [
0 => -80.556684
1 => 43.457734
]
+"Latitude": 43.457734
+"Longitude": -80.556684
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Updated and spacious, this Beechwood, 3 bedroom, 2.5 bathroom townhouse offers approximately 1,600 square feet of comfortable living space in a highly desirable Waterloo location. Ideal for first-time buyers, families, or investors, the home features a bright, open living room with built-in shelving and elegant crown molding. Upstairs, you'll find a large primary bedroom with a walk-in closet, along with two additional generously sized bedrooms. The fully finished basement adds excellent flexibility with a large, versatile rec room, full bathroom, and laundry area. Set in a quiet complex with ample visitor parking and green space, this property is conveniently located close to everyday amenities, including two grocery stores within walking distance, major bus routes, the expressway, and both universities, including walking distance to the University of Waterloo. A well-kept, move-in-ready opportunity in a convenient and sought-after location. (id:62783)"
+"AssociationFee": "612"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:48:38.683182+00:00"
+"Directions": "Fischer-Hallman"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100955"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:3 [
0 => "Garage"
1 => "Carport"
2 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-12T15:30:32Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T15:30:32Z"
+"Stories": "2.0"
+"StreetName": "Keats"
+"StreetNumber": "417"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "3014"
+"VirtualTourURLUnbranded": "https://youriguide.com/4_417_keats_way_waterloo_on/"
+"Rooms": array:9 [
0 => array:11 [ …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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29895192/4-417-keats-way-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Weigel Management"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-12T15:30:32.56Z"
+"ListAgentNationalAssociationId": "1370979"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895192')"
+"ID": "1524681"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25270
+post_id: "1524682"
+post_author: 1
+"ListingKey": "29895200"
+"ListingId": "40838845"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T00:40:13Z"
+"RFModificationTimestamp": "2026-06-13T00:41:23Z"
+"ListPrice": 1179000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3112.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2V4"
+"UnparsedAddress": "725 ZURICH Drive, Waterloo, Ontario N2V2V4"
+"Coordinates": array:2 [
0 => -80.58337
1 => 43.4566032
]
+"Latitude": 43.4566032
+"Longitude": -80.58337
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located in the highly desirable neighbourhood of Clair Hills in West Waterloo, 725 Zurich Drive is a rare opportunity for growing families seeking space, functionality, and an unbeatable location! Boasting over 3000 sq/ft of finished living space, this impressive 5 Bed/3 Bath home offers a thoughtfully designed open concept layout with incredible versatility throughout. The bright and welcoming main floor serves as the heart of the home, featuring spacious principal rooms ideal for everyday living and entertaining. Large windows provide an abundance of natural light while creating a warm and inviting atmosphere. Recent major updates including a new roof with solar panels (~5k/Yr ROI), new windows, new furnace, and new on-demand water heater provide exceptional value and peace of mind for years to come. Upstairs, the spacious primary bedroom offers a comfortable retreat with a large en-suite, while an additional bedroom and full bathroom complete the upper level with functionality and convenience. A true standout feature of this home is the fully finished basement, offering exceptional additional living space with *3 generously sized bedrooms, making it ideal for larger families, multi-generational living, overnight guests, or flexible work-from-home options. Complete with a full bathroom and ample space for recreation or additional family living, the lower level adds tremendous versatility and value rarely found in homes within this neighbourhood. Step outside to enjoy the fully fenced backyard featuring a private patio area and storage shed, the perfect setting for relaxing evenings, entertaining guests, or safe outdoor play for children and pets alike. Ideally located near top-rated schools including Vista Hills and Laurel Heights Secondary School, as well as the scenic GeoTime trails and surrounding forest, this family-friendly location offers the perfect balance of convenience and nature. Pride of ownership is evident throughout this beautifully maintained home! (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Satellite Dish"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:48:03.419047+00:00"
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Brick"
2 => "Stone"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2052274"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Corner Site"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T15:31:43Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T00:31:49Z"
+"Stories": "1.0"
+"StreetName": "ZURICH"
+"StreetNumber": "725"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "6877"
+"VirtualTourURLUnbranded": "https://youriguide.com/725_zurich_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/29895200/725-zurich-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1587
+"BelowGradeFinishedArea": 1525
+"OriginalEntryTimestamp": "2026-06-12T15:31:43.37Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1327496"
+"ListOfficeNationalAssociationId": "1004387"
+"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": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895200')"
+"ID": "1524682"
}
]
+success: true
+page_size: 9
+page_count: 11
+count: 94
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]