array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29246827/Property?$select=ALL&$top=20&$filter=ListingKey eq 29246827&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29246827/Property?$select=ALL&$top=20&$filter=ListingKey eq 29246827&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23484
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "532256"
+post_author: 1
+"ListingKey": "29246827"
+"ListingId": "X12692386"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T20:30:15Z"
+"RFModificationTimestamp": "2026-01-13T23:46:11Z"
+"ListPrice": 1269999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1C2"
+"UnparsedAddress": "166 WESTVALE DRIVE, Waterloo, Ontario N2T1C2"
+"Coordinates": array:2 [
0 => -80.5563613
1 => 43.4504619
]
+"Latitude": 43.4504619
+"Longitude": -80.5563613
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this stunning 4+1 bedroom, 4 bathroom home, completely reimagined with high-quality construction and modern design. Offering an impressive approx 3400 square feet of finished living space, this home seamlessly blends comfort, style, and functionality. The main floor features a chef's dream kitchen with a large island and striking quartz waterfall countertop, complemented by newer appliances and an open-concept layout that's perfect for both everyday living and entertaining. A soaring foyer welcomes you into spacious living and dining areas, with a cozy gas fireplace that adds warmth and charm to the space. Upstairs, you'll find generously sized bedrooms along with an additional family living room-an ideal spot for a kids' play area, media lounge, or quiet retreat that offers even more versatility for a growing household. The fully finished basement includes a large recreation room and a private in-law suite with its own wet bar and bedroom, making it perfect for multi-generational living, or guests. Recent upgrades include a new water softener installed in 2022, updated eavestroughs in 2024, and new basement windows/window wells added the same year. New kitchen appliances (2022), new washing machine (2025). Located in a fantastic neighborhood close to scenic trails, shopping, and a wide range of amenities, this beautifully updated home is truly move-in ready and designed to suit the needs of modern living. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Microwave"
7 => "Blinds"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T23:45:55.606871+00:00"
+"Directions": "Cross Streets: Gateview Drive. ** Directions: Gateview to Westvale."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2203316"
+"ListOfficeKey": "285194"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "49.2 x 111.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-13T20:18:09Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T20:18:09Z"
+"Stories": "2.0"
+"StreetName": "Westvale"
+"StreetNumber": "166"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7797"
+"VirtualTourURLUnbranded": "https://youriguide.com/c17s5_166_westvale_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [
"RoomKey" => "1560014672"
"RoomType" => "Bathroom"
"ListingId" => "X12692386"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29246827"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.88Z"
]
1 => array:11 [
"RoomKey" => "1560014673"
"RoomType" => "Bedroom 3"
"ListingId" => "X12692386"
"RoomLevel" => "Second level"
"RoomWidth" => 2.69
"ListingKey" => "29246827"
"RoomLength" => 3.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.88Z"
]
2 => array:11 [
"RoomKey" => "1560014674"
"RoomType" => "Bedroom 4"
"ListingId" => "X12692386"
"RoomLevel" => "Second level"
"RoomWidth" => 2.69
"ListingKey" => "29246827"
"RoomLength" => 3.17
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.88Z"
]
3 => array:11 [
"RoomKey" => "1560014675"
"RoomType" => "Bedroom"
"ListingId" => "X12692386"
"RoomLevel" => "Second level"
"RoomWidth" => 5.18
"ListingKey" => "29246827"
"RoomLength" => 3.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.88Z"
]
4 => array:11 [
"RoomKey" => "1560014676"
"RoomType" => "Dining room"
"ListingId" => "X12692386"
"RoomLevel" => "Main level"
"RoomWidth" => 5.13
"ListingKey" => "29246827"
"RoomLength" => 3.17
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.88Z"
]
5 => array:11 [
"RoomKey" => "1560014677"
"RoomType" => "Great room"
"ListingId" => "X12692386"
"RoomLevel" => "Second level"
"RoomWidth" => 6.25
"ListingKey" => "29246827"
"RoomLength" => 5.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.88Z"
]
6 => array:11 [
"RoomKey" => "1560014678"
"RoomType" => "Bathroom"
"ListingId" => "X12692386"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29246827"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.88Z"
]
7 => array:11 [
"RoomKey" => "1560014679"
"RoomType" => "Bedroom"
"ListingId" => "X12692386"
"RoomLevel" => "Basement"
"RoomWidth" => 3.4
"ListingKey" => "29246827"
"RoomLength" => 3.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.89Z"
]
8 => array:11 [
"RoomKey" => "1560014680"
"RoomType" => "Other"
"ListingId" => "X12692386"
"RoomLevel" => "Basement"
"RoomWidth" => 2.26
"ListingKey" => "29246827"
"RoomLength" => 2.69
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.89Z"
]
9 => array:11 [
"RoomKey" => "1560014681"
"RoomType" => "Recreational, Games room"
"ListingId" => "X12692386"
"RoomLevel" => "Basement"
"RoomWidth" => 9.09
"ListingKey" => "29246827"
"RoomLength" => 6.86
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.89Z"
]
10 => array:11 [
"RoomKey" => "1560014682"
"RoomType" => "Family room"
"ListingId" => "X12692386"
"RoomLevel" => "Main level"
"RoomWidth" => 4.72
"ListingKey" => "29246827"
"RoomLength" => 4.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.89Z"
]
11 => array:11 [
"RoomKey" => "1560014683"
"RoomType" => "Foyer"
"ListingId" => "X12692386"
"RoomLevel" => "Main level"
"RoomWidth" => 3.1
"ListingKey" => "29246827"
"RoomLength" => 3.02
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.89Z"
]
12 => array:11 [
"RoomKey" => "1560014684"
"RoomType" => "Kitchen"
"ListingId" => "X12692386"
"RoomLevel" => "Main level"
"RoomWidth" => 4.9
"ListingKey" => "29246827"
"RoomLength" => 3.33
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.89Z"
]
13 => array:11 [
"RoomKey" => "1560014685"
"RoomType" => "Laundry room"
"ListingId" => "X12692386"
"RoomLevel" => "Main level"
"RoomWidth" => 1.75
"ListingKey" => "29246827"
"RoomLength" => 3.17
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.89Z"
]
14 => array:11 [
"RoomKey" => "1560014686"
"RoomType" => "Living room"
"ListingId" => "X12692386"
"RoomLevel" => "Main level"
"RoomWidth" => 4.32
"ListingKey" => "29246827"
"RoomLength" => 3.33
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.89Z"
]
15 => array:11 [
"RoomKey" => "1560014687"
"RoomType" => "Bathroom"
"ListingId" => "X12692386"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29246827"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.89Z"
]
16 => array:11 [
"RoomKey" => "1560014688"
"RoomType" => "Bathroom"
"ListingId" => "X12692386"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29246827"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.89Z"
]
17 => array:11 [
"RoomKey" => "1560014689"
"RoomType" => "Bedroom 2"
"ListingId" => "X12692386"
"RoomLevel" => "Second level"
"RoomWidth" => 4.93
"ListingKey" => "29246827"
"RoomLength" => 3.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.89Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29246827/166-westvale-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2042908"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "47312"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 49.2
+"OriginalEntryTimestamp": "2026-01-13T20:18:09.84Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:34 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6403375962"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/67b0a128bf2c00d693ec09bae3eaf8f0.webp"
"MediaSize" => 89769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-67b0a128bf2c00d693ec09bae3eaf8f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6403376015"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/71576c632c96f9c3a93f9061cbeec183.webp"
"MediaSize" => 138916
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-71576c632c96f9c3a93f9061cbeec183.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6403376068"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/7a2a562844572461b0934ae8b54be163.webp"
"MediaSize" => 188105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-7a2a562844572461b0934ae8b54be163.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6403376120"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/0c9439ec69ee2d01260ed39a36f3e2bc.webp"
"MediaSize" => 98973
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-0c9439ec69ee2d01260ed39a36f3e2bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6403376143"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/8463add38644cab6818347c4fa34d2cd.webp"
"MediaSize" => 109721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-8463add38644cab6818347c4fa34d2cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6403376164"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/6b66dfe0ab635b44d9b056345df8da24.webp"
"MediaSize" => 99496
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-6b66dfe0ab635b44d9b056345df8da24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6403376216"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/f8ef9f76d9233cf5c8d936d7f935f83f.webp"
"MediaSize" => 92129
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-f8ef9f76d9233cf5c8d936d7f935f83f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6403376277"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/cbae9f585d1ba85864c7c472c7180a8f.webp"
"MediaSize" => 97744
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-cbae9f585d1ba85864c7c472c7180a8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6403376321"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/ef611b24fe1961fd842bb7cc247849e9.webp"
"MediaSize" => 73028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-ef611b24fe1961fd842bb7cc247849e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6403376366"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/1b957ceca6b6dbdfaa55c5df77840b4c.webp"
"MediaSize" => 115131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-1b957ceca6b6dbdfaa55c5df77840b4c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6403376417"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/6566d8dad48ffc21c5a719b117abcc57.webp"
"MediaSize" => 103500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-6566d8dad48ffc21c5a719b117abcc57.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6403376439"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/86dae850d630972a1956f8559ea3adbd.webp"
"MediaSize" => 103094
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-86dae850d630972a1956f8559ea3adbd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6403376477"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/03bdde3ae8f0e7afb6f400de9813814e.webp"
"MediaSize" => 86985
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-03bdde3ae8f0e7afb6f400de9813814e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6403376497"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/3e7235ea4d151ffe79ce5e84e4aadd81.webp"
"MediaSize" => 105790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-3e7235ea4d151ffe79ce5e84e4aadd81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6403376550"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/94642d8118cc67754e9e55b303a7e339.webp"
"MediaSize" => 77337
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-94642d8118cc67754e9e55b303a7e339.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6403376569"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/bbd2c8e7697c76fdb40cc592c3532868.webp"
"MediaSize" => 57633
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-bbd2c8e7697c76fdb40cc592c3532868.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6403376592"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/eb504952e91352f6e9e5400a75ba2abb.webp"
"MediaSize" => 125618
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-eb504952e91352f6e9e5400a75ba2abb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6403376620"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/79eb56da8e898e611ceab35157ea9b6e.webp"
"MediaSize" => 94328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-79eb56da8e898e611ceab35157ea9b6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6403376638"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/943705f9e24f0fa461d8cdec9dc75230.webp"
"MediaSize" => 83923
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-943705f9e24f0fa461d8cdec9dc75230.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6403376688"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/eb4c31ae6c3f3fdde057ce4ebc2dc2c4.webp"
"MediaSize" => 97201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-eb4c31ae6c3f3fdde057ce4ebc2dc2c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6403376704"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/9212679ce17d30848b7b0a266a0ca439.webp"
"MediaSize" => 84158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-9212679ce17d30848b7b0a266a0ca439.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6403376724"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/6823aa53e4d89553dd7c938c9738134d.webp"
"MediaSize" => 83768
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-6823aa53e4d89553dd7c938c9738134d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6403376774"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/b619296f773958b0cfe8cc0e9a85493f.webp"
"MediaSize" => 84706
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-b619296f773958b0cfe8cc0e9a85493f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6403376791"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/c2fdc0c79af7ff745a1c05e4e27b67ad.webp"
"MediaSize" => 75313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-c2fdc0c79af7ff745a1c05e4e27b67ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6403376828"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/9081ff2119c1cefcc94ab73235485d56.webp"
"MediaSize" => 91910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-9081ff2119c1cefcc94ab73235485d56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6403376859"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/b75ea8325681852775901be5014579de.webp"
"MediaSize" => 98128
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-b75ea8325681852775901be5014579de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6403376893"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/8d949888c702fac6b30ed22f6d4b3aab.webp"
"MediaSize" => 83031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-8d949888c702fac6b30ed22f6d4b3aab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6403376911"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/262e6deaac4f6021d50ff68f2bbfbfbe.webp"
"MediaSize" => 75101
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-262e6deaac4f6021d50ff68f2bbfbfbe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6403376935"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/e0cbc213d4f162958c8be7c958cd1048.webp"
"MediaSize" => 101879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-e0cbc213d4f162958c8be7c958cd1048.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6403376951"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/a61c53537e3617b974fc07944c054b2d.webp"
"MediaSize" => 122191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-a61c53537e3617b974fc07944c054b2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6403376985"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/ad0471b6e9416262b89183b47b7b0700.webp"
"MediaSize" => 104496
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-ad0471b6e9416262b89183b47b7b0700.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6403377008"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/4088bb2548eaf717cabc8cd3d973799c.webp"
"MediaSize" => 213155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-4088bb2548eaf717cabc8cd3d973799c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6403377031"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/ac03830c1f3498b84747711d9b29c65b.webp"
"MediaSize" => 231708
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-ac03830c1f3498b84747711d9b29c65b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6403377059"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29246827/95128825a107d68ca8cf70bc0e016eab.webp"
"MediaSize" => 174510
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29246827/thumbnail-95128825a107d68ca8cf70bc0e016eab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12692386"
"ResourceRecordKey" => "29246827"
"ModificationTimestamp" => "2026-01-13T20:18:09.85Z"
]
]
+"Member": array:1 [
0 => array:21 [
"MemberFullName" => "JACKIE THOMAS"
"MemberFirstName" => "JACKIE"
"MemberLastName" => "THOMAS"
"MemberMlsId" => "9631824"
"OriginatingSystemName" => 26
"MemberKey" => "2203316"
"ModificationTimestamp" => "2025-12-15T09:51:24Z"
"MemberStatus" => "Active"
"OfficeKey" => "285194"
"MemberAOR" => "Toronto"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "519-741-0950"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2023-10-27T17:22:00Z"
"MemberNationalAssociationId" => "1451939"
"OfficeNationalAssociationId" => "1348537"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "RE/MAX REAL ESTATE CENTRE INC."
"OfficePhone" => "519-741-0950"
"OfficeMlsId" => "79824"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "285194"
"ModificationTimestamp" => "2025-08-26T23:33:50Z"
"OfficeAddress1" => "720 WESTMOUNT RD E #B"
"OfficeCity" => "KITCHENER"
"OfficePostalCode" => "N2E2M"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Toronto"
"Media" => array:1 [ …1]
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OfficeCountry" => "Canada"
"OriginalEntryTimestamp" => "2019-05-07T19:31:00Z"
"OfficeNationalAssociationId" => "1348537"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1457687"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29246827')"
+"ID": "532256"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 285194/Office?$select=ALL&$top=10&$filter=OfficeKey eq 285194&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 285194/Office?$select=ALL&$top=10&$filter=OfficeKey eq 285194&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25314
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25316
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX REAL ESTATE CENTRE INC."
+"OfficeEmail": null
+"OfficePhone": "519-741-0950"
+"OfficeMlsId": "79824"
+"ModificationTimestamp": "2025-08-26T23:33:50Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "285194"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "720 WESTMOUNT RD E #B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "KITCHENER"
+"OfficePostalCode": "N2E2M"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1348537"
+"OriginalEntryTimestamp": "2019-05-07T19:31:00Z"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1457687"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('285194')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2203316/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2203316&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2203316/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2203316&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25319
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29246827" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24937
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.42 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29246827/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29246827&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29246827/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29246827&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24919
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29246827 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5563613 43.4504619)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29246827 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5563613 43.4504619)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29246827 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5563613 43.4504619)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29246827 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5563613 43.4504619)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24788
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24861
+post_id: "531765"
+post_author: 1
+"ListingKey": "29247131"
+"ListingId": "40798306"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T21:15:48Z"
+"RFModificationTimestamp": "2026-01-13T23:09:04Z"
+"ListPrice": 999900.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 2
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3355.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1Z4"
+"UnparsedAddress": "599 BEECHWOOD Drive, Waterloo, Ontario N2T1Z4"
+"Coordinates": array:2 [
0 => -80.5659349
1 => 43.4500093
]
+"Latitude": 43.4500093
+"Longitude": -80.5659349
+"YearBuilt": 1989
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "OFFER ANYTIME. All brick 4+1 beds and 5 baths single detached home located in Waterloo's desirable Beechwood neighbourhood. The main floor features a spacious living room and a formal dining room both with large windows. The kitchen features granite countertops and porcelain tiles. The Sunken great room has high ceilings and there is a door that opens to a large patio in the fully fenced backyard. The main floor also features a 2pc powder room and a laundry room. On the 2nd floor you'll find 4 generously sized bedrooms, one 3pc master bedroom en-suite, a 4pc main bathroom, and another 2pc en-suite washroom. The fully finished basement offers a 5th bedroom, a huge rec room, and a 5th bathroom plus plenty of storage space. Recent Updates: Newly installed hardwood staircase (2025), new paint throughout (2025), basement newly finished (2025), two upper floor bathrooms newly updated (2025). New master bedroom curtains (2025), Hot Water Heater Owned (2021). Added Extra Insulation in 2018. Newer Garage Door (2022). Newer Sump Pump (2023). Newer Washer and Dryer (2023). Fridge (2024). Furnace and AC (2024). Great location close to many amenities, within walking distance to schools, bus routes, shopping centers. A short drive to the Boardwalk, and both Waterloo and Laurier University. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T23:08:29.190474+00:00"
+"Directions": "Royal Beech Dr to Beechwood Dr"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1970409"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-13T21:08:44Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T21:08:44Z"
+"Stories": "2.0"
+"StreetName": "BEECHWOOD"
+"StreetNumber": "599"
+"StreetSuffix": "Drive"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "5994"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/599-Beechwood-Dr"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [
"RoomKey" => "1560032758"
"RoomType" => "Utility room"
"ListingId" => "40798306"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "18'8'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.7Z"
]
1 => array:11 [
"RoomKey" => "1560032759"
"RoomType" => "Bedroom"
"ListingId" => "40798306"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.71Z"
]
2 => array:11 [
"RoomKey" => "1560032760"
"RoomType" => "3pc Bathroom"
"ListingId" => "40798306"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "7'9'' x 4'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.72Z"
]
3 => array:11 [
"RoomKey" => "1560032761"
"RoomType" => "Recreation room"
"ListingId" => "40798306"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "29'7'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.72Z"
]
4 => array:11 [
"RoomKey" => "1560032762"
"RoomType" => "Full bathroom"
"ListingId" => "40798306"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "5'11'' x 7'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.72Z"
]
5 => array:11 [
"RoomKey" => "1560032763"
"RoomType" => "Primary Bedroom"
"ListingId" => "40798306"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "18'0'' x 12'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.73Z"
]
6 => array:11 [
"RoomKey" => "1560032764"
"RoomType" => "2pc Bathroom"
"ListingId" => "40798306"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "5'8'' x 4'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.74Z"
]
7 => array:11 [
"RoomKey" => "1560032765"
"RoomType" => "Bedroom"
"ListingId" => "40798306"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "18'3'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.74Z"
]
8 => array:11 [
"RoomKey" => "1560032766"
"RoomType" => "Bedroom"
"ListingId" => "40798306"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.75Z"
]
9 => array:11 [
"RoomKey" => "1560032767"
"RoomType" => "5pc Bathroom"
"ListingId" => "40798306"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.75Z"
]
10 => array:11 [
"RoomKey" => "1560032768"
"RoomType" => "Bedroom"
"ListingId" => "40798306"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.76Z"
]
11 => array:11 [
"RoomKey" => "1560032769"
"RoomType" => "Laundry room"
"ListingId" => "40798306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.76Z"
]
12 => array:11 [
"RoomKey" => "1560032770"
"RoomType" => "Great room"
"ListingId" => "40798306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "15'11'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.76Z"
]
13 => array:11 [
"RoomKey" => "1560032771"
"RoomType" => "2pc Bathroom"
"ListingId" => "40798306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "3'3'' x 5'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.77Z"
]
14 => array:11 [
"RoomKey" => "1560032772"
"RoomType" => "Living room"
"ListingId" => "40798306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "18'0'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.77Z"
]
15 => array:11 [
"RoomKey" => "1560032773"
"RoomType" => "Dining room"
"ListingId" => "40798306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.77Z"
]
16 => array:11 [
"RoomKey" => "1560032774"
"RoomType" => "Kitchen"
"ListingId" => "40798306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.77Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29247131/599-beechwood-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2A"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 69.0
+"AboveGradeFinishedArea": 2324
+"BelowGradeFinishedArea": 1031
+"OriginalEntryTimestamp": "2026-01-13T21:08:44.37Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"Media": array:49 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6403449164"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/139698b13f81141eee2443140d3fe758.webp"
"MediaSize" => 147849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-139698b13f81141eee2443140d3fe758.webp"
…7
]
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29247131')"
+"ID": "531765"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24865
+post_id: "531257"
+post_author: 1
+"ListingKey": "29246008"
+"ListingId": "40795464"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T18:30:13Z"
+"RFModificationTimestamp": "2026-01-13T20:13:09Z"
+"ListPrice": 559000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2571.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5C5"
+"UnparsedAddress": "88 MCDOUGALL Road Unit# F, Waterloo, Ontario N2L5C5"
+"Coordinates": array:2 [
0 => -80.544748
1 => 43.462943
]
+"Latitude": 43.462943
+"Longitude": -80.544748
+"YearBuilt": 1973
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Lovely spacious 4 bedroom end unit townhome located in excellent Beechwood neighbourhood. Main floor boasts large bright main floor family room with gas fireplace and large windows overlooking green space. Separate dining room and eat in kitchen provide ample room for entertaining. This lovely home offers 4 large bedrooms including primary suite and 3 pc bath. You will be impressed with the large finished walk out basement offering high ceilings and two finished family room spaces. From the full walkout you have a private fenced yard for your family to enjoy. A patio and barbeque are surrounded by mature trees nd green space giving this townhome lots of privacy. Well over 2000 sq feet of finished living space. Walking distance to U of W. Uptown Waterloo, Waterloo Park close to all public transit. Wonderful family home or excellent investment property for your son or daughter while attending university. Current owner has all prior licensing requirements for City of Waterloo available for reference. (id:62650)"
+"Appliances": array:7 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Freezer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFee": "681.15"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T20:12:48.730827+00:00"
+"Directions": "Keats Way"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563601"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-01-13T18:20:17Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T18:20:17Z"
+"Stories": "2.0"
+"StreetName": "MCDOUGALL"
+"StreetNumber": "88"
+"StreetSuffix": "Road"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "4205.82"
+"VirtualTourURLUnbranded": "https://youriguide.com/f_88_mcdougall_rd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29246008/88-mcdougall-road-unit-f-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1740
+"BelowGradeFinishedArea": 831
+"OriginalEntryTimestamp": "2026-01-13T18:20:17.58Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"Media": array:37 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29246008')"
+"ID": "531257"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24833
+post_id: "531178"
+post_author: 1
+"ListingKey": "29246328"
+"ListingId": "X12692100"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T19:20:44Z"
+"RFModificationTimestamp": "2026-01-13T19:35:17Z"
+"ListPrice": 559000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5C5"
+"UnparsedAddress": "27 - 88 MCDOUGALL ROAD, Waterloo, Ontario N2L5C5"
+"Coordinates": array:2 [
0 => -80.544893
1 => 43.462883
]
+"Latitude": 43.462883
+"Longitude": -80.544893
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Lovely spacious 4 bedroom end unit townhome located in excellent Beechwood neighbourhood. Main floor boasts large bright main floor family room with gas fireplace and large windows overlooking green space. Separate dining room and eat in kitchen provide ample room for entertaining. This lovely home offers 4 large bedrooms including primary suite and 3 pc bath. You will be impressed with the large finished walk out basement offering high ceilings and two finished family room spaces. From the full walkout you have a private fenced yard for your family to enjoy. A patio and barbeque are surrounded by mature trees nd green space giving this townhome lots of privacy. Well over 2000 sq feet of finished living space. Walking distance to U of W. Uptown Waterloo, Waterloo Park close to all public transit. Wonderful family home or excellent investment property for your son or daughter while attending university. Current owner has all prior licensing requirements for City of Waterloo available for reference. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Water Heater"
]
+"AssociationFee": "681.15"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T19:34:04.390874+00:00"
+"Directions": "Cross Streets: University & Keats Way. ** Directions: Hwy 85, Exit University, Right at Keats Way, Right at McDougall."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2241400"
+"ListOfficeKey": "300351"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-13T19:13:18Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T19:13:17Z"
+"Stories": "2.0"
+"StreetName": "Mcdougall"
+"StreetNumber": "88"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4220"
+"VirtualTourURLUnbranded": "https://youriguide.com/f_88_mcdougall_rd_waterloo_on/"
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29246328/27-88-mcdougall-road-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Trevarren Property Mgmt."
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"BedroomsAboveGrade": 4
+"OriginalEntryTimestamp": "2026-01-13T19:13:17.67Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:37 [
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]
]
+"Member": array:1 [
0 => array:4 [ …4]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29246328')"
+"ID": "531178"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24852
+post_id: "530529"
+post_author: 1
+"ListingKey": "29244370"
+"ListingId": "40797633"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T14:20:20Z"
+"RFModificationTimestamp": "2026-01-14T14:23:59Z"
+"ListPrice": 1269999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3394.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1C2"
+"UnparsedAddress": "166 WESTVALE Drive, Waterloo, Ontario N2T1C2"
+"Coordinates": array:2 [
0 => -80.5562864
1 => 43.4505816
]
+"Latitude": 43.4505816
+"Longitude": -80.5562864
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning 4+1 bedroom, 4 bathroom home, completely reimagined with high-quality construction and modern design. Offering an impressive approx 3400 square feet of finished living space, this home seamlessly blends comfort, style, and functionality. The main floor features a chef’s dream kitchen with a large island and striking quartz waterfall countertop, complemented by newer appliances and an open-concept layout that's perfect for both everyday living and entertaining. A soaring foyer welcomes you into spacious living and dining areas, with a cozy gas fireplace that adds warmth and charm to the space. Upstairs, you'll find generously sized bedrooms along with an additional family living room—an ideal spot for a kids’ play area, media lounge, or quiet retreat that offers even more versatility for a growing household. The fully finished basement includes a large recreation room and a private in-law suite with its own wet bar and bedroom, making it perfect for multi-generational living, or guests. Recent upgrades include a new water softener installed in 2022, updated eavestroughs in 2024, and new basement windows/window wells added the same year. New kitchen appliances (2022), new washing machine (2025). Located in a fantastic neighborhood close to scenic trails, shopping, and a wide range of amenities, this beautifully updated home is truly move-in ready and designed to suit the needs of modern living. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Garage door opener"
5 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T17:43:01.518119+00:00"
+"Directions": "Gateview Drive to Westvale Drive"
+"ExteriorFeatures": array:4 [
0 => "Concrete"
1 => "Aluminum siding"
2 => "Shingles"
3 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2042710"
+"ListOfficeKey": "285135"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-13T13:18:45Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T14:08:28Z"
+"Stories": "2.0"
+"StreetName": "WESTVALE"
+"StreetNumber": "166"
+"StreetSuffix": "Drive"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "7797"
+"VirtualTourURLUnbranded": "https://youriguide.com/c17s5_166_westvale_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29244370/166-westvale-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 49.0
+"AboveGradeFinishedArea": 2411
+"BelowGradeFinishedArea": 983
+"OriginalEntryTimestamp": "2026-01-13T13:18:45.54Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:34 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29244370')"
+"ID": "530529"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24774
+post_id: "526511"
+post_author: 1
+"ListingKey": "29238805"
+"ListingId": "40797702"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-11T23:35:56Z"
+"RFModificationTimestamp": "2026-01-11T23:45:22Z"
+"ListPrice": 530000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1351.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0B3"
+"UnparsedAddress": "223 ERB Street W Unit# 501, Waterloo, Ontario N2L0B3"
+"Coordinates": array:2 [
0 => -80.5362711
1 => 43.459198
]
+"Latitude": 43.459198
+"Longitude": -80.5362711
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience sophisticated living in the luxurious building, ideally situated in the heart of Waterloo. Whether you're seeking a low-maintenance lifestyle or beginning your studies or career at one of Waterloo's prestigious universities, this residence offers the perfect blend of comfort, convenience, and style. This rarely offered corner unit features 2 bedrooms, 2 bathrooms, and an office space across 1,351 sq. ft. of thoughtfully designed space with 9-foot ceilings. Flooded with natural light, the home showcases modern finishes, oversized windows, and panoramic city views from every room. Enjoy a spacious kitchen with granite countertops, a large island, and abundant cabinet and counter space-perfect for entertaining. The primary suite includes generous closets and a spa-inspired ensuite with a glass shower, double sinks, and a smart toilet. Step onto your covered balcony, large enough for outdoor dining or lounging. Located just steps from T&T Supermarket, bus stops, and the Waterloo Public Library & Community Centre, with easy access to restaurants, cafes, and universities, this home offers the ultimate in urban convenience. Vacant property. Show with confidence. Photos are from the previous listing. Top notch amenities including an opulent communal lounge/ library with a grand piano, fitness studio, sauna, an rooftop terrace equipped with BBQ and an indoor party room. Seller is willing to replace carpet in the bedrooms. 1 Parking and 1 locker included (id:62650)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
]
+"AssociationFee": "1112"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-11T23:45:12.476039+00:00"
+"Directions": "Erb St W / Westmount Rd S"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2175198"
+"ListOfficeKey": "292482"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-01-11T23:31:20Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-11T23:31:20Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "ERB"
+"StreetNumber": "223"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "5257.27"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29238805/223-erb-street-w-unit-501-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Exercise Centre"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1351
+"OriginalEntryTimestamp": "2026-01-11T23:29:19.37Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:34 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29238805')"
+"ID": "526511"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24791
+post_id: "526023"
+post_author: 1
+"ListingKey": "29238347"
+"ListingId": "X12684612"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-11T16:20:37Z"
+"RFModificationTimestamp": "2026-01-11T16:30:24Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2J7"
+"UnparsedAddress": "BSMT - 528 VALHALLA CRESCENT, Waterloo, Ontario N2T2J7"
+"Coordinates": array:2 [
0 => -80.5696359
1 => 43.453394
]
+"Latitude": 43.453394
+"Longitude": -80.5696359
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Spacious, bright and newly build 2-bedroom, 1-bathroom legal basement suite. Once you stepped in you will hardly get basement feeling. This Unit offers modern comfort and quality craftsmanship in the sought-after Waterloo West beechwood community. Designed with upgraded finishes throughout, this high Ceiling suite features an open-concept layout, a contemporary kitchen with appliances, stylish lighting, accent wall and vinyl flooring. Enjoy living in a family-friendly community surrounded by parks, trails, and top-rated schools. You would really appreciate the convenience of being just minutes from The Boardwalk, Costco, and both universities, with public transit steps from your door for easy commuting. This rental opportunity provides the perfect blend of modern living and everyday convenience in this beautifully upgraded home. As a bonus one driveway parking included. Ideal for small family but open for nice students who can share the room. 1850+25% utilities. No Pet!!! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Apartment in basement"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-11T16:30:22.650569+00:00"
+"Directions": "Erbsville Rd & Erb St W"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2127635"
+"ListOfficeKey": "238732"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-11T16:12:10Z"
+"PhotosCount": 9
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-11T16:12:10Z"
+"Stories": "2.0"
+"StreetName": "Valhalla"
+"StreetNumber": "528"
+"StreetSuffix": "Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29238347/bsmt-528-valhalla-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 1850
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-11T16:12:10.72Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:9 [
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]
]
+"Member": []
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29238347')"
+"ID": "526023"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23498
+post_id: "525911"
+post_author: 1
+"ListingKey": "29238209"
+"ListingId": "X12684474"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-11T06:21:00Z"
+"RFModificationTimestamp": "2026-01-11T06:41:57Z"
+"ListPrice": 530000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0B3"
+"UnparsedAddress": "501 - 223 ERB STREET W, Waterloo, Ontario N2L0B3"
+"Coordinates": array:2 [
0 => -80.536312
1 => 43.459038
]
+"Latitude": 43.459038
+"Longitude": -80.536312
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Experience sophisticated living in the luxurious building, ideally situated in the heart of Waterloo. Whether you're seeking a low-maintenance lifestyle or beginning your studies or career at one of Waterloo's prestigious universities, this residence offers the perfect blend of comfort, convenience, and style. This rarely offered corner unit features 2 bedrooms, 2 bathrooms, and an office space across 1,351 sq. ft. of thoughtfully designed space with 9-foot ceilings. Flooded with natural light, the home showcases modern finishes, oversized windows, and panoramic city views from every room. Enjoy a spacious kitchen with granite countertops, a large island, and abundant cabinet and counter space-perfect for entertaining. The primary suite includes generous closets and a spa-inspired ensuite with a glass shower, double sinks, and a smart toilet. Step onto your covered balcony, large enough for outdoor dining or lounging. Located just steps from T&T Supermarket, bus stops, and the Waterloo Public Library & Community Centre, with easy access to restaurants, cafes, and universities, this home offers the ultimate in urban convenience. Vacant property. Show with confidence. Photos are from the previous listing. (id:62650)"
+"Appliances": array:1 [
0 => "Sauna"
]
+"AssociationFee": "1112"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-11T06:41:51.433812+00:00"
+"Directions": "Erb St W / Westmount Rd S"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2109335"
+"ListOfficeKey": "70066"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-11T06:11:11Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-11T06:11:11Z"
+"StreetDirSuffix": "West"
+"StreetName": "Erb"
+"StreetNumber": "223"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5257.27"
+"View": "View"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29238209/501-223-erb-street-w-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Sauna"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-01-11T06:11:10.93Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:32 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29238209')"
+"ID": "525911"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24869
+post_id: "525069"
+post_author: 1
+"ListingKey": "29237078"
+"ListingId": "40797443"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-10T15:05:54Z"
+"RFModificationTimestamp": "2026-01-10T16:50:31Z"
+"ListPrice": 1299000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2241.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6N6"
+"UnparsedAddress": "255 KEATS Way Unit# 1404, Waterloo, Ontario N2L6N6"
+"Coordinates": array:2 [
0 => -80.543239
1 => 43.461952
]
+"Latitude": 43.461952
+"Longitude": -80.543239
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this one-of-a-kind, professionally designed 2,241 sq. ft. penthouse in the heart of Waterloo’s coveted Beechwood neighbourhood. Perched high above the treetops, this showstopper boasts panoramic views from three sides and offers an unmatched sense of privacy and natural light through oversized windows at every turn. Meticulously renovated top to bottom by Menno Martin, this residence exudes quality and elegance. The grand living room features coffered ceilings and hardwood flooring throughout, opening onto a breathtaking 400 sq. ft. terrace—one of three outdoor spaces. The open-concept kitchen is a chef’s dream, showcasing solid wood cabinetry, quartz countertops, and premium finishes, seamlessly connecting to a formal dining area perfect for entertaining. The spacious primary suite is a private retreat with its own 400 sq. ft. terrace, a luxurious ensuite, and generous closet space. A second bedroom, additional bedroom or den, and a second expansive 200 sq. ft. terrace offer plenty of flexibility for guests, work, or relaxation. Set in a quiet, exceptionally well-maintained building, this rare penthouse is just steps to Waterloo Park, trails, and the vibrant offerings of Uptown Waterloo. Three underground parking spaces complete this truly exceptional package—an incredibly rare find in this location. The condominium also includes a fitness center, library, on-site super-intendant, guest suite and two lockers. Call to book a private showing today. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Freezer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"AssociationFee": "1344.71"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Water"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-10T16:50:20.477476+00:00"
+"Directions": "University Avenue to Keats Way"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Boiler"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1960053"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Paved driveway"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-10T14:59:59Z"
+"PhotosCount": 25
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-10T14:59:59Z"
+"Stories": "1.0"
+"StreetName": "KEATS"
+"StreetNumber": "255"
+"StreetSuffix": "Way"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "7032"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/255-Keats-Way-1404"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29237078/255-keats-way-unit-1404-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Guest Suite"
2 => "Party Room"
]
+"ZoningDescription": "MR-12"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 2241
+"OriginalEntryTimestamp": "2026-01-10T14:59:59.41Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:25 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29237078')"
+"ID": "525069"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25160
+post_id: "524039"
+post_author: 1
+"ListingKey": "29234905"
+"ListingId": "40795864"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-10T14:31:02Z"
+"RFModificationTimestamp": "2026-01-10T14:35:11Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1200.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L1W7"
+"UnparsedAddress": "401 ERB Street W Unit# 301, Waterloo, Ontario N2L1W7"
+"Coordinates": array:2 [
0 => -80.5510293
1 => 43.4527592
]
+"Latitude": 43.4527592
+"Longitude": -80.5510293
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this extra large 2 bedroom, 2 bathroom condo close to the universities in Waterloo with easy access to Kitchener. This well cared for, quiet and clean building boasts large units not normally found in today's market! Primary bedroom includes a convenient ensuite 2 piece bathroom all to itself. Large rooms carry you through to good sized kitchen, big living room and separate dining area. Generous balcony includes room for furniture and quiet summer nights. Tired of tiny condos with limited space? This might just be the one for you! Book your private viewing today. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "660"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-01-09T23:54:40.322755+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1951359"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"PhotosChangeTimestamp": "2026-01-09T19:39:36Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-10T14:18:27Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "ERB"
+"StreetNumber": "401"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "2621.8"
+"Utilities": array:1 [
0 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://iguidephotos.com/301_401_erb_st_w_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29234905/401-erb-street-w-unit-301-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1563756"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "289722"
+"GeocodeManualYN": true
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1200
+"OriginalEntryTimestamp": "2026-01-09T19:39:36.43Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"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]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29234905')"
+"ID": "524039"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 114
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
]