array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30035988 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23472
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23474
+post_id: "1626777"
+post_author: 1
+"ListingKey": "30035988"
+"ListingId": "X13565994"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-16T15:50:04Z"
+"RFModificationTimestamp": "2026-07-16T17:06:49Z"
+"ListPrice": 959000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1R5"
+"UnparsedAddress": "298 ROXTON DRIVE, Waterloo, Ontario N2T1R5"
+"Coordinates": array:2 [
0 => -80.5631353
1 => 43.4630718
]
+"Latitude": 43.4630718
+"Longitude": -80.5631353
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 298 Roxton Drive, a spacious and versatile two-storey home nestled in Waterloo's sought-after Westwinds community. Thoughtfully designed for comfortable family living and entertaining, this well-appointed home offers an exceptional layout with generous principal rooms and endless potential. The main floor features a bright eat-in kitchen, inviting family room, formal living and dining rooms, a private den ideal for a home office, convenient main floor laundry, and a powder room. Upstairs, the expansive primary suite includes a walk-in closet with built-ins and a private 4-piece ensuite. A generous second bedroom, additional 4-piece bath, and a flexible loft and sitting area provide outstanding versatility - perfect for a media room, home gym, office, or easily converted third sleeping space. The oversized basement offers incredible additional living potential, highlighted by a massive L-shaped recreation room ready to be customized to suit your lifestyle - whether as a games room, home theatre, fitness area, or multi-generational living space. Ideally located close to both University of Waterloo and Wilfrid Laurier University, this home is situated in a desirable family-friendly neighbourhood near parks, schools, shopping, and everyday amenities. Community fees conveniently include landscaping and snow removal, offering added ease and low-maintenance living. This home presents a rare opportunity to create the space you've been looking for in one of Waterloo's most established communities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "376.66"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"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-07-15T17:01:19.196208+00:00"
+"Directions": "Cross Streets: Fischer-Hallman. ** Directions: Fischer-Hallman and Roxton."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2099764"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T15:39:55Z"
+"PhotosCount": 33
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-16T15:40:25Z"
+"Stories": "2.0"
+"StreetName": "Roxton"
+"StreetNumber": "298"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7118.33"
+"VirtualTourURLUnbranded": "https://youriguide.com/298_roxton_dr_waterloo_on/"
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1685929531"
"RoomType" => "Kitchen"
"ListingId" => "X13565994"
"RoomLevel" => "Main level"
"RoomWidth" => 3.68
"ListingKey" => "30035988"
"RoomLength" => 4.52
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T15:40:25.63Z"
]
1 => array:11 [
"RoomKey" => "1685929532"
"RoomType" => "Bathroom"
"ListingId" => "X13565994"
"RoomLevel" => "Second level"
"RoomWidth" => 1.37
"ListingKey" => "30035988"
"RoomLength" => 2.92
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T15:40:25.63Z"
]
2 => array:11 [
"RoomKey" => "1685929533"
"RoomType" => "Living room"
"ListingId" => "X13565994"
"RoomLevel" => "Main level"
"RoomWidth" => 3.63
"ListingKey" => "30035988"
"RoomLength" => 8.64
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T15:40:25.63Z"
]
3 => array:11 [
"RoomKey" => "1685929534"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13565994"
"RoomLevel" => "Basement"
"RoomWidth" => 4.62
"ListingKey" => "30035988"
"RoomLength" => 12.37
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T15:40:25.64Z"
]
4 => array:11 [
"RoomKey" => "1685929535"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13565994"
"RoomLevel" => "Basement"
"RoomWidth" => 3.63
"ListingKey" => "30035988"
"RoomLength" => 5.33
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T15:40:25.64Z"
]
5 => array:11 [
"RoomKey" => "1685929536"
"RoomType" => "Utility room"
"ListingId" => "X13565994"
"RoomLevel" => "Basement"
"RoomWidth" => 4.52
"ListingKey" => "30035988"
"RoomLength" => 5.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T15:40:25.64Z"
]
6 => array:11 [
"RoomKey" => "1685929537"
"RoomType" => "Cold room"
"ListingId" => "X13565994"
"RoomLevel" => "Second level"
"RoomWidth" => 1.14
"ListingKey" => "30035988"
"RoomLength" => 2.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T15:40:25.64Z"
]
7 => array:11 [
"RoomKey" => "1685929538"
"RoomType" => "Family room"
"ListingId" => "X13565994"
"RoomLevel" => "Main level"
"RoomWidth" => 3.66
"ListingKey" => "30035988"
"RoomLength" => 3.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T15:40:25.64Z"
]
8 => array:11 [
"RoomKey" => "1685929539"
"RoomType" => "Den"
"ListingId" => "X13565994"
"RoomLevel" => "Main level"
"RoomWidth" => 3.91
"ListingKey" => "30035988"
"RoomLength" => 5.03
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T15:40:25.64Z"
]
9 => array:11 [
"RoomKey" => "1685929540"
"RoomType" => "Bathroom"
"ListingId" => "X13565994"
"RoomLevel" => "Main level"
"RoomWidth" => 1.19
"ListingKey" => "30035988"
"RoomLength" => 2.67
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T15:40:25.64Z"
]
10 => array:11 [
"RoomKey" => "1685929541"
"RoomType" => "Laundry room"
"ListingId" => "X13565994"
"RoomLevel" => "Main level"
"RoomWidth" => 1.98
"ListingKey" => "30035988"
"RoomLength" => 2.031
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T15:40:25.64Z"
]
11 => array:11 [
"RoomKey" => "1685929542"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13565994"
"RoomLevel" => "Second level"
"RoomWidth" => 3.66
"ListingKey" => "30035988"
"RoomLength" => 5.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T15:40:25.64Z"
]
12 => array:11 [
"RoomKey" => "1685929543"
"RoomType" => "Bathroom"
"ListingId" => "X13565994"
"RoomLevel" => "Second level"
"RoomWidth" => 3.2
"ListingKey" => "30035988"
"RoomLength" => 3.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T15:40:25.64Z"
]
13 => array:11 [
"RoomKey" => "1685929544"
"RoomType" => "Sitting room"
"ListingId" => "X13565994"
"RoomLevel" => "Second level"
"RoomWidth" => 3.05
"ListingKey" => "30035988"
"RoomLength" => 3.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T15:40:25.64Z"
]
14 => array:11 [
"RoomKey" => "1685929545"
"RoomType" => "Loft"
"ListingId" => "X13565994"
"RoomLevel" => "Second level"
"RoomWidth" => 4.06
"ListingKey" => "30035988"
"RoomLength" => 8.31
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T15:40:25.64Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30035988/298-roxton-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Self Managed"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"LivingAreaMaximum": 2499
+"LivingAreaMinimum": 2250
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-07-15T15:39:55.35Z"
+"ListAgentNationalAssociationId": "1369922"
+"ListOfficeNationalAssociationId": "1385020"
+"Media": array:33 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30035988_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/37fa1998307e7f643519619ffb270a79.webp"
"MediaSize" => 216877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-37fa1998307e7f643519619ffb270a79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30035988_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/5d62a4fca0a6afaf89d06883fde284e5.webp"
"MediaSize" => 167038
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-5d62a4fca0a6afaf89d06883fde284e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30035988_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/597a2ba080cc6fec9500e0fc348c0680.webp"
"MediaSize" => 157201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-597a2ba080cc6fec9500e0fc348c0680.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30035988_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/0aa6fbfbf82c25813fbd31aea88e92d4.webp"
"MediaSize" => 165645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-0aa6fbfbf82c25813fbd31aea88e92d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30035988_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/179c0c46a0599d65a1cdffdc93dc412d.webp"
"MediaSize" => 146579
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-179c0c46a0599d65a1cdffdc93dc412d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30035988_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/30e9a50c398d66345413545809bef881.webp"
"MediaSize" => 134998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-30e9a50c398d66345413545809bef881.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30035988_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/fdb184792cf971d33af4fd0ef5e2be24.webp"
"MediaSize" => 136338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-fdb184792cf971d33af4fd0ef5e2be24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30035988_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/5288eea74cb16ba1c0b67d9a7c31a8e4.webp"
"MediaSize" => 153604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-5288eea74cb16ba1c0b67d9a7c31a8e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30035988_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/6149872f2e6ecdfda0bf3197714d70ea.webp"
"MediaSize" => 172421
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-6149872f2e6ecdfda0bf3197714d70ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30035988_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/26821da22326b71e9dbc31781fe0f722.webp"
"MediaSize" => 166743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-26821da22326b71e9dbc31781fe0f722.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30035988_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/6e12dcabca46fe04f4666d2a1397d231.webp"
"MediaSize" => 174331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-6e12dcabca46fe04f4666d2a1397d231.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30035988_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/d2908cfaa0521160b1f1a65ba4366924.webp"
"MediaSize" => 146763
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-d2908cfaa0521160b1f1a65ba4366924.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30035988_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/ac754124748faaaf8806c9848d87ae64.webp"
"MediaSize" => 168302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-ac754124748faaaf8806c9848d87ae64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30035988_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/655beb94e087829d1b3d57d16064b8da.webp"
"MediaSize" => 183071
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-655beb94e087829d1b3d57d16064b8da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30035988_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/e668e0a8a82aa1fb1a5d327a77c2f918.webp"
"MediaSize" => 173908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-e668e0a8a82aa1fb1a5d327a77c2f918.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30035988_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/d2c8301923256634ae8168f6aaf4167d.webp"
"MediaSize" => 164161
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-d2c8301923256634ae8168f6aaf4167d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30035988_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/e3786b69f37dd843c9e2e0d5e0925cc3.webp"
"MediaSize" => 156143
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-e3786b69f37dd843c9e2e0d5e0925cc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30035988_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/6eada59bf634fdcd0df5ab0dea8733dc.webp"
"MediaSize" => 156101
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-6eada59bf634fdcd0df5ab0dea8733dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30035988_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/a19db1a7e1d872e1dff7484f2ce18922.webp"
"MediaSize" => 165440
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-a19db1a7e1d872e1dff7484f2ce18922.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30035988_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/f52a3b627bc38e47b57acfb7cd29c768.webp"
"MediaSize" => 176068
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-f52a3b627bc38e47b57acfb7cd29c768.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30035988_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/7f3b774904132d964fae29fd7ba24608.webp"
"MediaSize" => 114523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-7f3b774904132d964fae29fd7ba24608.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30035988_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/72601b5a91ac62b2f9d84313d6853ccd.webp"
"MediaSize" => 147420
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-72601b5a91ac62b2f9d84313d6853ccd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30035988_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/e2229640eaf0fe0328a8f806ecb45946.webp"
"MediaSize" => 156306
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-e2229640eaf0fe0328a8f806ecb45946.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30035988_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/9b2f34f1b4b518dea329debf52bb607f.webp"
"MediaSize" => 196765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-9b2f34f1b4b518dea329debf52bb607f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30035988_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/273c81679f131f2a6e1b34ec84df7302.webp"
"MediaSize" => 183358
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-273c81679f131f2a6e1b34ec84df7302.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30035988_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/6f79a6a4f4a3b2a5e633b4957364b1aa.webp"
"MediaSize" => 217855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-6f79a6a4f4a3b2a5e633b4957364b1aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30035988_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/41b4a0c2dbb020470a27a967c9c98518.webp"
"MediaSize" => 136114
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-41b4a0c2dbb020470a27a967c9c98518.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30035988_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/ec18af8f1fe4d5c4f537a3ed9f9143a8.webp"
"MediaSize" => 203068
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-ec18af8f1fe4d5c4f537a3ed9f9143a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30035988_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/e40215ea35e7e576939c5aea5359f4c7.webp"
"MediaSize" => 247288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-e40215ea35e7e576939c5aea5359f4c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30035988_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/626d87f0897267e984779fa0b48c8e0a.webp"
"MediaSize" => 262176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-626d87f0897267e984779fa0b48c8e0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30035988_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/bc801eb85597da42a013ae781077dd84.webp"
"MediaSize" => 103963
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-bc801eb85597da42a013ae781077dd84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30035988_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/5e0c3f362a82cd390a4b3fee91ab6831.webp"
"MediaSize" => 103153
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-5e0c3f362a82cd390a4b3fee91ab6831.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30035988_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035988/056b312b6741857520a907777997b573.webp"
"MediaSize" => 96052
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035988/thumbnail-056b312b6741857520a907777997b573.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565994"
"ResourceRecordKey" => "30035988"
"ModificationTimestamp" => "2026-07-15T15:39:55.35Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30035988')"
+"ID": "1626777"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 290246" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24977
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24921
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "519-885-0200"
+"OfficeMlsId": "360903"
+"ModificationTimestamp": "2025-07-15T14:56:28Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "290246"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "83 ERB STREET W UNIT B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "WATERLOO"
+"OfficePostalCode": "N2L6C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1385020"
+"OriginalEntryTimestamp": "2021-04-22T21:38:00Z"
+"OfficeFax": "519-885-4914"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1369644"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('290246')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2099764" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24931
+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 '30035988'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25270
+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 '30035988' AND OpenHouseDate ge '2026-07-17'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25288
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25286
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "32018225"
+"ListingKey": "30035988"
+"ListingId": "X13565994"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-19"
+"OpenHouseStartTime": "2026-07-19T14:00:00Z"
+"OpenHouseEndTime": "2026-07-19T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-18T04:59:19Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('32018225')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30035988' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5631353 43.4630718)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25341
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25335
+post_id: "1637960"
+post_author: 1
+"ListingKey": "30043669"
+"ListingId": "40848597"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:20:09Z"
+"RFModificationTimestamp": "2026-07-17T23:19:02Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1732.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T0A5"
+"UnparsedAddress": "555 CHABLIS Drive Unit# 12, Waterloo, Ontario N2T0A5"
+"Coordinates": array:2 [
0 => -80.5740134
1 => 43.4487735
]
+"Latitude": 43.4487735
+"Longitude": -80.5740134
+"YearBuilt": 2011
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this fantastic townhouse in a highly desirable Waterloo location, just minutes from the universities, shopping, restaurants, and public transit. The bright, open-concept main floor features beautiful hardwood flooring, granite countertops, an undermount sink, updated lighting, California shutters on all window and doors and a full suite of stainless steel appliances. A hidden retractable screen on the front door allows you to enjoy fresh air while keeping insects out. The spacious primary bedroom offers a walk-in closet and a private 3-piece ensuite. The second-floor den features new hardwood flooring, making it an ideal home office, study area, or reading nook. The beautifully finished lower-level recreation room provides exceptional additional living space and has been thoughtfully completed with insulated walls and ceilings, Dricore subfloor beneath luxury vinyl flooring, and fully finished drywall on the walls and ceilings for added comfort and durability. Sliding doors from the main living area lead to a private deck, perfect for relaxing or entertaining. Additional features include a single-car garage, central air conditioning, all new ceiling light fixtures throughout, updated bathrooms, and fresh paint in every room completed within the last few years. Move-in ready and located in one of Waterloo's most convenient neighbourhoods, this beautifully updated home is ideal for professionals, families, or investors looking for a low-maintenance property close to all amenities. Den could be converted to 3rd bedroom (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Central Vacuum - Roughed In"
]
+"AssociationFee": "280"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T23:18:51.013996+00:00"
+"Directions": "Ira Needles"
+"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": "1564233"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Covered"
]
+"PhotosChangeTimestamp": "2026-07-17T16:31:30Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:09:00Z"
+"Stories": "2.0"
+"StreetName": "CHABLIS"
+"StreetNumber": "555"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4358.04"
+"VirtualTourURLUnbranded": "https://youriguide.com/12_555_chablis_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1686992078"
"RoomType" => "2pc Bathroom"
"ListingId" => "40848597"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30043669"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:00.79Z"
]
1 => array:11 [
"RoomKey" => "1686992079"
"RoomType" => "Storage"
"ListingId" => "40848597"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30043669"
"RoomLength" => null
"RoomDimensions" => "5'4'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:00.79Z"
]
2 => array:11 [
"RoomKey" => "1686992080"
"RoomType" => "Recreation room"
"ListingId" => "40848597"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30043669"
"RoomLength" => null
"RoomDimensions" => "14'1'' x 18'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:00.79Z"
]
3 => array:11 [
"RoomKey" => "1686992081"
"RoomType" => "4pc Bathroom"
"ListingId" => "40848597"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30043669"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:00.79Z"
]
4 => array:11 [
"RoomKey" => "1686992082"
"RoomType" => "Den"
"ListingId" => "40848597"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30043669"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 19'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:00.79Z"
]
5 => array:11 [
"RoomKey" => "1686992083"
"RoomType" => "Bedroom"
"ListingId" => "40848597"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30043669"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:00.8Z"
]
6 => array:11 [
"RoomKey" => "1686992084"
"RoomType" => "Full bathroom"
"ListingId" => "40848597"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30043669"
"RoomLength" => null
"RoomDimensions" => "16'3'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:00.8Z"
]
7 => array:11 [
"RoomKey" => "1686992085"
"RoomType" => "Primary Bedroom"
"ListingId" => "40848597"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30043669"
"RoomLength" => null
"RoomDimensions" => "12'8'' x 15'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:00.8Z"
]
8 => array:11 [
"RoomKey" => "1686992086"
"RoomType" => "Foyer"
"ListingId" => "40848597"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30043669"
"RoomLength" => null
"RoomDimensions" => "6'4'' x 16'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:00.8Z"
]
9 => array:11 [
"RoomKey" => "1686992087"
"RoomType" => "2pc Bathroom"
"ListingId" => "40848597"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30043669"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:00.8Z"
]
10 => array:11 [
"RoomKey" => "1686992088"
"RoomType" => "Dining room"
"ListingId" => "40848597"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30043669"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:00.8Z"
]
11 => array:11 [
"RoomKey" => "1686992089"
"RoomType" => "Living room"
"ListingId" => "40848597"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30043669"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 19'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:00.8Z"
]
12 => array:11 [
"RoomKey" => "1686992090"
"RoomType" => "Kitchen"
"ListingId" => "40848597"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30043669"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:00.8Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30043669/555-chablis-drive-unit-12-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R7"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1435
+"BelowGradeFinishedArea": 297
+"OriginalEntryTimestamp": "2026-07-16T18:59:55.46Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070035"
+"ListOfficeNationalAssociationId": "1324759"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30043669_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043669/b5476439e52c46c68caca5d545a0833e.webp"
"MediaSize" => 122024
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043669/thumbnail-b5476439e52c46c68caca5d545a0833e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick and siding exterior featuring multiple dormers, two single-car garages, and an asphalt driveway"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40848597"
"ResourceRecordKey" => "30043669"
"ModificationTimestamp" => "2026-07-17T16:31:29.07Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30043669_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043669/43fa4cb46e6be23e3c7cb02401fec5ee.webp"
"MediaSize" => 113982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043669/thumbnail-43fa4cb46e6be23e3c7cb02401fec5ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior townhome featuring a private driveway, single-car garage, manicured front lawn, mature tree, and covered front porch"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848597"
"ResourceRecordKey" => "30043669"
"ModificationTimestamp" => "2026-07-17T16:31:28.34Z"
]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30043669')"
+"ID": "1637960"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25337
+post_id: "1637101"
+post_author: 1
+"ListingKey": "30042738"
+"ListingId": "40848676"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:15:14Z"
+"RFModificationTimestamp": "2026-07-17T20:56:26Z"
+"ListPrice": 599000.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.5744358
1 => 43.4491472
]
+"Latitude": 43.4491472
+"Longitude": -80.5744358
+"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. Featuring over 1,400 sq. ft. of above-grade living space plus a fully finished basement, this spacious home offers 3 bedrooms plus 2 additional bedrooms in the finished basement and 3 bathrooms, making it an excellent choice for growing families, multi-generational living, or buyers seeking added flexibility. The bright main floor features 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 includes a walk-in closet and semi-ensuite bathroom access, complemented by two additional bedrooms. The fully finished basement features two additional bedrooms, a full bathroom, and a rough-in kitchen, offering excellent flexibility for extended family, guests, a home office, or future in-law suite potential. As an end unit, the home enjoys additional windows, abundant natural light, enhanced privacy, and a larger side yard. Additional features include roof shingles 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. Convenient public transit provides easy access to the University of Waterloo. The Boardwalk Shopping Centre, with Costco, Walmart, Landmark Cinemas, restaurants, cafés, medical services, and a wide range of retail amenities, is just minutes away. With quick access to Laurel Creek Conservation Area, The Hydrocut, and major commuter routes, this move-in-ready freehold townhome combines space, flexibility, and an outstanding location in one of Waterloo's most desirable communities. (Some photos have been virtually staged for illustrative purposes only.) (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-17T20:56:19.914403+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-16T20:42:50Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:08:53Z"
+"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/30042738/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-16T17:18:27.42Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1430684"
+"ListOfficeNationalAssociationId": "1394395"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30042738')"
+"ID": "1637101"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25334
+post_id: "1637112"
+post_author: 1
+"ListingKey": "30031516"
+"ListingId": "40847959"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:20:06Z"
+"RFModificationTimestamp": "2026-07-17T20:47:15Z"
+"ListPrice": 1089900.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.5790555
1 => 43.4649869
]
+"Latitude": 43.4649869
+"Longitude": -80.5790555
+"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 (backs onto Cavendish Park), 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-17T20:47:08.645552+00:00"
+"Directions": "Columbia/Chancery Lane"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Metal"
]
+"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": "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-14T18:25:31Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:10:04Z"
+"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/30031516/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-14T17:48:18.31Z"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30031516')"
+"ID": "1637112"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25338
+post_id: "1637099"
+post_author: 1
+"ListingKey": "30038060"
+"ListingId": "40848404"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:20:08Z"
+"RFModificationTimestamp": "2026-07-17T20:40:34Z"
+"ListPrice": 1149900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.272
+"LivingArea": 2866.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5A5"
+"UnparsedAddress": "337 MARLOWE Drive, Waterloo, Ontario N2L5A5"
+"Coordinates": array:2 [
0 => -80.5513334
1 => 43.4621325
]
+"Latitude": 43.4621325
+"Longitude": -80.5513334
+"YearBuilt": 1973
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This is the Beechwood home you’ve been waiting for. Tucked beneath mature trees & set on an exceptional 78’ x 181’ lot spanning more than 1/4 acre, this distinctive 3-bed, 3-bath home offers 2,800+ SF of finished living space, a landscaped private backyard, inground pool W/ waterfall & finished walkout lower level in one of Waterloo’s most established neighbourhoods. The main flr features two gathering areas. The living rm has a vaulted wood-clad ceiling, expansive windows, built-in shelving & full-height stone gas fireplace, while the family rm offers a wood-burning fireplace & direct access to the deck & backyard. The updated custom kitchen features white cabinetry, quartz counters, stainless appliances, subway-tile backsplash, skylights & ample workspace & storage. The adjoining breakfast rm features custom pantry cabinetry, a quartz-topped serving station, open wood shelving & another walkout to the deck, while the separate dining rm offers ample space for hosting. Upstairs are 3 well-sized beds & 2 full baths, including a spacious primary W/ excellent closet space & private 3-pc ensuite, plus a 4-pc main bath. The finished walkout lower level adds a lrg rec rm, sauna, separate shower ideal for the pool, laundry/utility rm & storage. Surrounded by mature trees & lush perennial gardens, the backyard feels exceptionally private & peaceful. An expansive deck offers plenty of rm for outdoor dining & lounging, while stone pathways lead to the inground pool, waterfall & stone terrace. Multiple walkouts create an easy indoor-outdoor connection. Located on a quiet street, steps from Clair Lake, trails, parks & schools, & close to Uptown Waterloo, both universities, shopping, restaurants & major employers. Residents also enjoy access to Beechwood Park Homes Association amenities & the strong sense of community Beechwood is known for. A rare opportunity to own a private poolside family home on an extraordinary mature lot in one of Waterloo’s most desirable neighbourhoods. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Sauna"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:40:23.159836+00:00"
+"Directions": "KEATS WAY TO AMOS AVENUE, THEN MARLOWE DRIVE"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1932106"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.272"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-16T20:03:30Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:09:21Z"
+"Stories": "2.0"
+"StreetName": "MARLOWE"
+"StreetNumber": "337"
+"StreetSuffix": "Drive"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "7061.04"
+"VirtualTourURLUnbranded": "https://youriguide.com/337_marlowe_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/30038060/337-marlowe-drive-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1975048"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76789"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 78.0
+"AboveGradeFinishedArea": 2064
+"BelowGradeFinishedArea": 802
+"OriginalEntryTimestamp": "2026-07-15T19:48:18.36Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1232419"
+"ListOfficeNationalAssociationId": "1384313"
+"CoListAgentNationalAssociationId": "1261853"
+"CoListOfficeNationalAssociationId": "1004357"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30038060')"
+"ID": "1637099"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25336
+post_id: "1631260"
+post_author: 1
+"ListingKey": "30042935"
+"ListingId": "X13572494"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T03:45:02Z"
+"RFModificationTimestamp": "2026-07-18T03:47:17Z"
+"ListPrice": 599000.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. Featuring over 1,400 sq. ft. of above-grade living space plus a fully finished basement, this spacious home offers 3 bedrooms plus 2 additional bedrooms in the finished basement and 3 bathrooms, making it an excellent choice for growing families, multi-generational living, or buyers seeking added flexibility. The bright main floor features 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 includes a walk-in closet and semi-ensuite bathroom access, complemented by two additional bedrooms. The fully finished basement features two additional bedrooms, a full bathroom, and a rough-in kitchen, offering excellent flexibility for extended family, guests, a home office, or future in-law suite potential. As an end unit, the home enjoys additional windows, abundant natural light, enhanced privacy, and a larger side yard. Additional features include roof shingles 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. Convenient public transit provides easy access to the University of Waterloo. The Boardwalk Shopping Centre, with Costco, Walmart, Landmark Cinemas, restaurants, cafés, medical services, and a wide range of retail amenities, is just minutes away.With quick access to Laurel Creek Conservation Area, The Hydrocut, and major commuter routes, this move-in-ready freehold townhome combines space, flexibility, and an outstanding location in one of Waterloo's most desirable communities.(Some photos have been virtually staged for illustrative purposes only.) (id:62650)"
+"Appliances": array:8 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
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-16T18:06:12.656811+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": "2188755"
+"ListOfficeKey": "291409"
+"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-16T20:58:38Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T03:37:52Z"
+"Stories": "2.0"
+"StreetName": "Paris"
+"StreetNumber": "760"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "4863"
+"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"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30042935/760-paris-boulevard-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1418255"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "90198"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 26.1
+"OriginalEntryTimestamp": "2026-07-16T17:40:46.35Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1437820"
+"ListOfficeNationalAssociationId": "1397659"
+"CoListAgentNationalAssociationId": "1105101"
+"CoListOfficeNationalAssociationId": "1153615"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30042935')"
+"ID": "1631260"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25331
+post_id: "1629363"
+post_author: 1
+"ListingKey": "30038706"
+"ListingId": "X13568634"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T21:20:04Z"
+"RFModificationTimestamp": "2026-07-15T23:10:41Z"
+"ListPrice": 1149900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5A5"
+"UnparsedAddress": "337 MARLOWE DRIVE, Waterloo, Ontario N2L5A5"
+"Coordinates": array:2 [
0 => -80.551304
1 => 43.462117
]
+"Latitude": 43.462117
+"Longitude": -80.551304
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This is the Beechwood home you've been waiting for. Tucked beneath mature trees & set on an exceptional 78' x 181' lot spanning more than 1/4 acre, this distinctive 3-bed, 3-bath home offers 2,800+ SF of finished living space, a landscaped private backyard, inground pool W/ waterfall & finished walkout lower level in one of Waterloo's most established neighbourhoods. The main flr features two gathering areas. The living rm has a vaulted wood-clad ceiling, expansive windows, built-in shelving & full-height stone gas fireplace, while the family rm offers a wood-burning fireplace & direct access to the deck & backyard. The updated custom kitchen features white cabinetry, quartz counters, stainless appliances, subway-tile backsplash, skylights & ample workspace & storage. The adjoining breakfast rm features custom pantry cabinetry, a quartz-topped serving station, open wood shelving & another walkout to the deck, while the separate dining rm offers ample space for hosting. Upstairs are 3 well-sized beds & 2 full baths, including a spacious primary W/ excellent closet space & private 3-pc ensuite, plus a 4-pc main bath. The finished walkout lower level adds a lrg rec rm, sauna, separate shower ideal for the pool, laundry/utility rm & storage. Surrounded by mature trees & lush perennial gardens, the backyard feels exceptionally private & peaceful. An expansive deck offers plenty of rm for outdoor dining & lounging, while stone pathways lead to the inground pool, waterfall & stone terrace. Multiple walkouts create an easy indoor-outdoor connection. Located on a quiet street, steps from Clair Lake, trails, parks & schools, & close to Uptown Waterloo, both universities, shopping, restaurants & major employers. Residents also enjoy access to Beechwood Park Homes Association amenities & the strong sense of community Beechwood is known for. A rare opportunity to own a private poolside family home on an extraordinary mature lot in one of Waterloo's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
11 => "Water Heater"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Walk-up"
3 => "N/A"
4 => "N/A"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T23:10:34.793879+00:00"
+"Directions": "Cross Streets: AMOS AVENUE. ** Directions: KEATS WAY TO AMOS AVENUE, THEN MARLOWE DRIVE."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2103799"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Irregular lot size"
1 => "Conservation/green belt"
2 => "Lighting"
3 => "Sauna"
]
+"LotSizeDimensions": "77.7 x 134.5 FT ; 77.85 x 181.25 x 79.61 x 134.50"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T21:10:25Z"
+"PhotosCount": 50
+"PoolFeatures": array:2 [
0 => "Inground pool"
1 => "Outdoor pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T21:10:25Z"
+"Stories": "2.0"
+"StreetName": "Marlowe"
+"StreetNumber": "337"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7061.04"
+"VirtualTourURLUnbranded": "https://youriguide.com/337_marlowe_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": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30038706/337-marlowe-drive-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 77.8
+"OriginalEntryTimestamp": "2026-07-15T21:10:25.4Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1373322"
+"ListOfficeNationalAssociationId": "1385020"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30038706')"
+"ID": "1629363"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "1626797"
+post_author: 1
+"ListingKey": "30035522"
+"ListingId": "X13565710"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T00:45:02Z"
+"RFModificationTimestamp": "2026-07-17T00:48:12Z"
+"ListPrice": 888888.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2Z3"
+"UnparsedAddress": "571 ST MORITZ AVENUE, Waterloo, Ontario N2T2Z3"
+"Coordinates": array:2 [
0 => -80.58325
1 => 43.453072
]
+"Latitude": 43.453072
+"Longitude": -80.58325
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "An Exceptional Family Home Nestled in the Highly Desirable Clair Hills Community. Situated on a Quiet, Family-Friendly Street, This Beautifully Maintained Residence Offers the Perfect Blend of Comfort, Style, and Convenience. Step Inside to Discover a Bright, Open-Concept Layout Designed for Modern Living. The Spacious Main Floor Features Generous Principal Rooms, a Welcoming Living Area, and a Well-Appointed Kitchen with Ample Cabinetry, Quality Finishes, and Plenty of Space for Entertaining. The Dining Area Walks Out to a Private Backyard, Creating a Seamless Indoor-Outdoor Lifestyle Perfect for Summer Gatherings. Thoughtfully Updated Throughout, Home Features Numerous Recent Upgrades, Including Roof (2024), Patio Stone in the Side Yard (2023), Shed (2024), Gazebo (2025), New Heating and Cooling Systems (2026), Flooring (2026), Back Deck (2026), and Modern Light Fixtures (2026), Offering Modern Comfort, Enhanced Functionality, and Peace of Mind for Years to Come. Upstairs, You'll Find Spacious Bedrooms, Including a Relaxing Primary Retreat Complete with a Walk-In Closet and Private Ensuite. The Finished Lower Level Provides Additional Living Space Ideal for a Recreation Room, Home Office, Gym, or Guest Accommodations. Outside, Enjoy a Fully Fenced Oversized Backyard Featuring the New Back Deck, Gazebo, Shed, and Playground-Creating the Perfect Outdoor Retreat for Entertaining, Relaxing, and Family Enjoyment. The Double Garage and Ample Driveway Parking Add Everyday Convenience. Located Just Minutes from the Boardwalk Shopping District, Costco, Top-Rated Schools, Parks, Scenic Walking Trails, the YMCA, Public Transit, and Both the University of Waterloo and Wilfrid Laurier University, This Home Offers an Unbeatable Location with Easy Access to All Amenities and Major Commuter Routes. Whether You're Growing Your Family or Searching for Your Forever Home, This Home Delivers Outstanding Value in One of Waterloo's Most Sought-After Neighborhoods. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Blinds"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T16:51:29.709042+00:00"
+"Directions": "Columbia St & St Moritz Ave"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2017417"
+"ListOfficeKey": "51195"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "157.7 x 74.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T20:59:44Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T00:39:41Z"
+"Stories": "2.0"
+"StreetName": "St Moritz"
+"StreetNumber": "571"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "6302"
+"VirtualTourURLUnbranded": "https://www.winsold.com/tour/468001"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30035522/571-st-moritz-avenue-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 157.8
+"OriginalEntryTimestamp": "2026-07-15T14:40:56.7Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1298531"
+"ListOfficeNationalAssociationId": "1003018"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30035522')"
+"ID": "1626797"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25339
+post_id: "1626349"
+post_author: 1
+"ListingKey": "30034713"
+"ListingId": "40846939"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T21:10:07Z"
+"RFModificationTimestamp": "2026-07-15T21:11:53Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1702.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1Y7"
+"UnparsedAddress": "450 BEECHWOOD Place Unit# 6, Waterloo, Ontario N2T1Y7"
+"Coordinates": array:2 [
0 => -80.5573776
1 => 43.4527206
]
+"Latitude": 43.4527206
+"Longitude": -80.5573776
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare opportunity in sought-after Beechwood! This exceptionally spacious townhome condo is one of the largest units in the complex and comes with an almost unheard of double car garage. Nestled in the desirable Beechwood West community backing onto the naturalized Clair Creek greenbelt, this home offers a bright, functional layout features a main floor primary bedroom with large ensuite, as well as an additional bedroom and loft space on the upper floor. The main level features spacious living and dining areas, and dual sliders to a private balcony perfect for morning coffee. The full basement offers a large rec room area, office, laundry, and abundant storage with built-in shelving. Enjoy carefree condo living with the community pool, visitor parking, and condo fees that include water, building maintenance, roof, windows and snow removal. Steps to Beechwood Plaza, minutes to The Boardwalk, top-rated schools, both universities, and ION transit. This unit is a blank canvas awaiting your personal touch, so bring your design ideas and get ready to build instant equity and make this home your own! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener"
]
+"AssociationFee": "775"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Water"
4 => "Insurance"
5 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T13:55:49.362342+00:00"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1926813"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T21:03:27Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T21:03:27Z"
+"Stories": "2.0"
+"StreetName": "BEECHWOOD"
+"StreetNumber": "450"
+"StreetSuffix": "Place"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "4067"
+"VirtualTourURLUnbranded": "https://youriguide.com/6_450_beechwood_place_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/30034713/450-beechwood-place-unit-6-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1600707"
+"CommonInterest": "Condo/Strata"
+"CoListAgentKey2": "1563792"
+"CoListOfficeKey": "299554"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "76831"
+"ZoningDescription": "MR150"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1702
+"OriginalEntryTimestamp": "2026-07-15T12:18:43.07Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1229829"
+"ListOfficeNationalAssociationId": "1473831"
+"CoListAgentNationalAssociationId": "1149297"
+"CoListAgentNationalAssociationId2": "1070179"
+"CoListOfficeNationalAssociationId": "1473831"
+"CoListOfficeNationalAssociationId2": "1004391"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30034713')"
+"ID": "1626349"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25340
+post_id: "1625119"
+post_author: 1
+"ListingKey": "30032440"
+"ListingId": "X13562984"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-14T19:45:05Z"
+"RFModificationTimestamp": "2026-07-14T23:39:35Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L1W3"
+"UnparsedAddress": "501 - 312 ERB STREET, Waterloo, Ontario N2L1W3"
+"Coordinates": array:2 [
0 => -80.543468
1 => 43.456288
]
+"Latitude": 43.456288
+"Longitude": -80.543468
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this bright and spacious condo featuring the convenience of in-suite laundry and complimentary Bell internet. Filled with natural light, this thoughtfully designed unit offers two private balconies-one off the secondary bedroom, perfect for enjoying a quiet morning coffee, and a larger balcony accessible from the kitchen. This expansive outdoor space is ideal for summer entertaining, relaxing in the sunshine, or creating your own small garden oasis. Residents enjoy an excellent selection of amenities, including a spacious co-working lounge with private phone pods, a pet washing station, electronic parcel lockers, and a stylish party room with private event space for hosting family and friends. Conveniently located just minutes from the University of Waterloo, this is close to shopping and dining along Westmount Road, the Waterloo Recreation Centre, Waterloo Park, and the vibrant shops, restaurants, and cafés of Uptown Waterloo. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "581.01"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-14T23:39:26.406092+00:00"
+"Directions": "University Ave W/ Erb St W"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2081088"
+"ListOfficeKey": "74899"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-14T19:38:25Z"
+"PhotosCount": 1
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-14T19:38:25Z"
+"StreetName": "Erb"
+"StreetNumber": "312"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3535.71"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30032440/501-312-erb-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-14T19:38:25.22Z"
+"ListAgentNationalAssociationId": "1355934"
+"ListOfficeNationalAssociationId": "1246437"
+"Media": array:1 [
0 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30032440')"
+"ID": "1625119"
}
]
+success: true
+page_size: 9
+page_count: 15
+count: 129
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]