array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29882580 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1517071"
+post_author: 1
+"ListingKey": "29882580"
+"ListingId": "X13425842"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T16:35:16Z"
+"RFModificationTimestamp": "2026-06-10T21:59:21Z"
+"ListPrice": 649000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4N2"
+"UnparsedAddress": "525 FALLINGBROOK DRIVE, Waterloo, Ontario N2L4N2"
+"Coordinates": array:2 [
0 => -80.5584506
1 => 43.4876256
]
+"Latitude": 43.4876256
+"Longitude": -80.5584506
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 525 Fallingbrook Drive - a well-cared-for home in one of Waterloo's most established and family-oriented neighbourhoods. This property offers 3 bedrooms upstairs plus an additional bedroom in the finished basement, along with 2 full bathrooms, giving families, downsizers, or investors plenty of flexibility.The home has received several important updates, including a new furnace (2019), new gutters, new windows, a stamped concrete driveway, updated kitchen cabinets, five upgraded appliances, and a newer water heater. These improvements mean lower maintenance and peace of mind for years ahead.Inside, the layout is bright and functional, with comfortable living spaces and a finished basement that can serve as a guest suite, home office, or recreation area. Outside, the neighbourhood is known for quiet streets, mature trees, and excellent walkability. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T21:58:11.504811+00:00"
+"Directions": "Cross Streets: Westmount and Bearinger. ** Directions: East on Bearinger and left on Glen Forest."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1974114"
+"ListOfficeKey": "285194"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40 x 125 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T16:30:06Z"
+"PhotosCount": 25
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T16:30:06Z"
+"Stories": "1.0"
+"StreetName": "Fallingbrook"
+"StreetNumber": "525"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4253.82"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1656331428"
"RoomType" => "Living room"
"ListingId" => "X13425842"
"RoomLevel" => "Main level"
"RoomWidth" => 3.56
"ListingKey" => "29882580"
"RoomLength" => 5.41
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T16:30:06.92Z"
]
1 => array:11 [
"RoomKey" => "1656331429"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13425842"
"RoomLevel" => "Basement"
"RoomWidth" => 4.93
"ListingKey" => "29882580"
"RoomLength" => 5.16
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T16:30:06.92Z"
]
2 => array:11 [
"RoomKey" => "1656331430"
"RoomType" => "Utility room"
"ListingId" => "X13425842"
"RoomLevel" => "Basement"
"RoomWidth" => 6.05
"ListingKey" => "29882580"
"RoomLength" => 4.01
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T16:30:06.92Z"
]
3 => array:11 [
"RoomKey" => "1656331431"
"RoomType" => "Bedroom"
"ListingId" => "X13425842"
"RoomLevel" => "Main level"
"RoomWidth" => 3.45
"ListingKey" => "29882580"
"RoomLength" => 2.64
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T16:30:06.92Z"
]
4 => array:11 [
"RoomKey" => "1656331432"
"RoomType" => "Bedroom"
"ListingId" => "X13425842"
"RoomLevel" => "Main level"
"RoomWidth" => 3.45
"ListingKey" => "29882580"
"RoomLength" => 2.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T16:30:06.92Z"
]
5 => array:11 [
"RoomKey" => "1656331433"
"RoomType" => "Bedroom"
"ListingId" => "X13425842"
"RoomLevel" => "Main level"
"RoomWidth" => 3.33
"ListingKey" => "29882580"
"RoomLength" => 3.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T16:30:06.93Z"
]
6 => array:11 [
"RoomKey" => "1656331434"
"RoomType" => "Bathroom"
"ListingId" => "X13425842"
"RoomLevel" => "Main level"
"RoomWidth" => 1.5
"ListingKey" => "29882580"
"RoomLength" => 2.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T16:30:06.93Z"
]
7 => array:11 [
"RoomKey" => "1656331435"
"RoomType" => "Kitchen"
"ListingId" => "X13425842"
"RoomLevel" => "Main level"
"RoomWidth" => 3.56
"ListingKey" => "29882580"
"RoomLength" => 5.41
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T16:30:06.93Z"
]
8 => array:11 [
"RoomKey" => "1656331436"
"RoomType" => "Dining room"
"ListingId" => "X13425842"
"RoomLevel" => "Main level"
"RoomWidth" => 2.39
"ListingKey" => "29882580"
"RoomLength" => 2.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T16:30:06.93Z"
]
9 => array:11 [
"RoomKey" => "1656331437"
"RoomType" => "Bedroom"
"ListingId" => "X13425842"
"RoomLevel" => "Basement"
"RoomWidth" => 3.2
"ListingKey" => "29882580"
"RoomLength" => 3.99
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T16:30:06.93Z"
]
10 => array:11 [
"RoomKey" => "1656331438"
"RoomType" => "Office"
"ListingId" => "X13425842"
"RoomLevel" => "Basement"
"RoomWidth" => 3.35
"ListingKey" => "29882580"
"RoomLength" => 2.13
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T16:30:06.93Z"
]
11 => array:11 [
"RoomKey" => "1656331439"
"RoomType" => "Bathroom"
"ListingId" => "X13425842"
"RoomLevel" => "Basement"
"RoomWidth" => 1.5
"ListingKey" => "29882580"
"RoomLength" => 2.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T16:30:06.93Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29882580/525-fallingbrook-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2026-06-10T16:30:06.89Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1260876"
+"ListOfficeNationalAssociationId": "1348537"
+"Media": array:25 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29882580_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/be0981d4e68c8902a32845b124e503fe.webp"
"MediaSize" => 354373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-be0981d4e68c8902a32845b124e503fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29882580_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/b8c0a7587d02af1806715c0b87af4827.webp"
"MediaSize" => 162884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-b8c0a7587d02af1806715c0b87af4827.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29882580_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/900366fa979a9a4288bc12212058a40b.webp"
"MediaSize" => 216477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-900366fa979a9a4288bc12212058a40b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29882580_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/9fb5683935d1aeb66b824b8b262ffa7f.webp"
"MediaSize" => 198575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-9fb5683935d1aeb66b824b8b262ffa7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29882580_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/20748c6d2a84e5ab516cf5797c99d7e6.webp"
"MediaSize" => 181442
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-20748c6d2a84e5ab516cf5797c99d7e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29882580_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/cdf0fdf2f3ae1dd4e87c304ec3b83486.webp"
"MediaSize" => 223091
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-cdf0fdf2f3ae1dd4e87c304ec3b83486.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29882580_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/7c94626190bb417dc9862ab351a092f4.webp"
"MediaSize" => 200032
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-7c94626190bb417dc9862ab351a092f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29882580_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/0c629d6b6a4aa6317df90e6fc211ab06.webp"
"MediaSize" => 217883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-0c629d6b6a4aa6317df90e6fc211ab06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29882580_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/058ee9e4555e667b4dca8af428119aa3.webp"
"MediaSize" => 188998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-058ee9e4555e667b4dca8af428119aa3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29882580_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/b231792f2ab59733c75dd527eb1ff633.webp"
"MediaSize" => 205536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-b231792f2ab59733c75dd527eb1ff633.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29882580_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/0b0d8c9434fae54b4fc0ee78e2c0dcd3.webp"
"MediaSize" => 210780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-0b0d8c9434fae54b4fc0ee78e2c0dcd3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29882580_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/3bd2d074fb9a5c61fdda0beab476e3b0.webp"
"MediaSize" => 163456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-3bd2d074fb9a5c61fdda0beab476e3b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29882580_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/535199ef31c4fc6fe95f99ca2492e906.webp"
"MediaSize" => 209986
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-535199ef31c4fc6fe95f99ca2492e906.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29882580_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/5cad0cbe64f398c19778e1953ca1a23e.webp"
"MediaSize" => 200747
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-5cad0cbe64f398c19778e1953ca1a23e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29882580_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/be9be72264192bcd30aeaf67ae536b53.webp"
"MediaSize" => 104744
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-be9be72264192bcd30aeaf67ae536b53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29882580_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/07088519be2c8b2c429784e6ddef8fef.webp"
"MediaSize" => 211177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-07088519be2c8b2c429784e6ddef8fef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29882580_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/24fb87a1f5cad0ab579aec40acf6af26.webp"
"MediaSize" => 197473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-24fb87a1f5cad0ab579aec40acf6af26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29882580_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/b232c3bcc7e18fdd0b1da15e81c6d919.webp"
"MediaSize" => 199782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-b232c3bcc7e18fdd0b1da15e81c6d919.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29882580_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/4d42a24cf1b02ce2196e04d79fa1295b.webp"
"MediaSize" => 385009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-4d42a24cf1b02ce2196e04d79fa1295b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29882580_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/122f1adadf66e3599f07cedbaa73740d.webp"
"MediaSize" => 542671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-122f1adadf66e3599f07cedbaa73740d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29882580_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/4e32aabb2277f4b0c510f6f50cc988e5.webp"
"MediaSize" => 321902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-4e32aabb2277f4b0c510f6f50cc988e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29882580_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/a64cd278daf139ddb48089d72a09dd00.webp"
"MediaSize" => 582496
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-a64cd278daf139ddb48089d72a09dd00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29882580_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/6d133c4cd23d1bd9558684287d01a36e.webp"
"MediaSize" => 476183
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-6d133c4cd23d1bd9558684287d01a36e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29882580_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/dfe6ddd9e13369fdde9188757dab94f1.webp"
"MediaSize" => 114316
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-dfe6ddd9e13369fdde9188757dab94f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29882580_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882580/16b917fe1f0b0481b7a7df9b798662fc.webp"
"MediaSize" => 107866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882580/thumbnail-16b917fe1f0b0481b7a7df9b798662fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13425842"
"ResourceRecordKey" => "29882580"
"ModificationTimestamp" => "2026-06-10T16:30:06.9Z"
]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29882580')"
+"ID": "1517071"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Cache Key: 2d9c813a502452a4eb21a164a7a5f16f782a46927e6c7c982becadb3ec87577c" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24460
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1974114" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24704
+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 '29882580'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25115
+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 '29882580'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25131
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29882580' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5584506 43.4876256)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24739
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24762
+post_id: "1536562"
+post_author: 1
+"ListingKey": "29912895"
+"ListingId": "X13453290"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T22:05:19Z"
+"RFModificationTimestamp": "2026-06-16T22:19:34Z"
+"ListPrice": 769000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4Y1"
+"UnparsedAddress": "591 DOGWOOD LANE, Waterloo, Ontario N2L4Y1"
+"Coordinates": array:2 [
0 => -80.560828
1 => 43.486633
]
+"Latitude": 43.486633
+"Longitude": -80.560828
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To Dogwood Lane! This Well-Maintained Bungalow Is Situated On A Quiet, Family-Friendly Street And Offers Comfortable Living With Excellent Income Potential. The Bright Living And Dining Areas Feature Hardwood Flooring And Large Windows For Plenty Of Natural Light. The Updated Kitchen Boasts Ceramic Flooring, Quartz Countertops, And A Stylish Backsplash. The Main Floor Includes Three Generously Sized Bedrooms With Parquet Flooring, Closets, And Separate Main Floor Laundry. The Fully Renovated (2022) Basement Features A Separate Entrance, Separate Laundry, Two Bedrooms, Vinyl Flooring, Pot Lights, A Cozy Fireplace, And A Spacious Living Area. The Bathroom Includes Ceramic Flooring, A Modern Vanity, And A Beautiful Clawfoot Soaker Tub. Enjoy A Large, Beautifully Landscaped Backyard Perfect For Entertaining. Recent Updates Include A.C./Heat Pump (Aug 2023), Furnace (Aug 2023), Tankless Water Heater (Aug 2023), Roof Insulation (Aug 2023), Water Purifier (Jun 2023), Water Filter (Jun 2023), And LeafFilter Gutter Protection (Aug 2023). Conveniently Located Close To Hwy 401, Schools, Shopping, Parks, Public Transit, And Within Walking Distance To The University Of Waterloo Campus. Move-In Ready Home Offering Comfort, Convenience, And Versatility. EXTRAS: Separate Entrance To Renovated Basement With Separate Laundry, Tankless Water Heater, Water Purifier, Water Filter, Heat Pump, LeafFilter Gutter Protection, Fireplace In Basement. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Water purifier"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
9 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Separate entrance"
2 => "Walk-up"
3 => "N/A"
4 => "N/A"
5 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T22:19:28.544312+00:00"
+"Directions": "Bearinger Road / Toll Gate/Dogwood Ln"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:4 [
0 => "Hardwood"
1 => "Parquet"
2 => "Ceramic"
3 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2105595"
+"ListOfficeKey": "164016"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "45 x 114 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T21:55:46Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T21:55:46Z"
+"Stories": "1.0"
+"StreetName": "Dogwood"
+"StreetNumber": "591"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "4316"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"View": "View"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1660771827"
"RoomType" => "Living room"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 3.6
"ListingKey" => "29912895"
"RoomLength" => 4.97
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.32Z"
]
1 => array:11 [
"RoomKey" => "1660771828"
"RoomType" => "Dining room"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29912895"
"RoomLength" => 2.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.32Z"
]
2 => array:11 [
"RoomKey" => "1660771829"
"RoomType" => "Kitchen"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 3.48
"ListingKey" => "29912895"
"RoomLength" => 4.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.32Z"
]
3 => array:11 [
"RoomKey" => "1660771830"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 3.14
"ListingKey" => "29912895"
"RoomLength" => 3.91
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.32Z"
]
4 => array:11 [
"RoomKey" => "1660771831"
"RoomType" => "Bedroom 2"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 2.69
"ListingKey" => "29912895"
"RoomLength" => 3.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.32Z"
]
5 => array:11 [
"RoomKey" => "1660771832"
"RoomType" => "Bedroom 3"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29912895"
"RoomLength" => 2.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.32Z"
]
6 => array:11 [
"RoomKey" => "1660771833"
"RoomType" => "Living room"
"ListingId" => "X13453290"
"RoomLevel" => "Basement"
"RoomWidth" => 4.72
"ListingKey" => "29912895"
"RoomLength" => 5.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.32Z"
]
7 => array:11 [
"RoomKey" => "1660771834"
"RoomType" => "Bedroom 4"
"ListingId" => "X13453290"
"RoomLevel" => "Basement"
"RoomWidth" => 3.96
"ListingKey" => "29912895"
"RoomLength" => 3.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.33Z"
]
8 => array:11 [
"RoomKey" => "1660771835"
"RoomType" => "Bedroom 5"
"ListingId" => "X13453290"
"RoomLevel" => "Basement"
"RoomWidth" => 3.02
"ListingKey" => "29912895"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.33Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29912895/591-dogwood-lane-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-16T21:55:46.28Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1374868"
+"ListOfficeNationalAssociationId": "1184644"
+"Media": array:38 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29912895_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/fb975b8a5449de12ebf6f2bbc2755134.webp"
"MediaSize" => 535748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-fb975b8a5449de12ebf6f2bbc2755134.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29912895_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/a1c63bdb354f10c613066fab83f1b315.webp"
"MediaSize" => 467201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-a1c63bdb354f10c613066fab83f1b315.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29912895_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/8d37c3159eedb5a52e519dfe3e28d123.webp"
"MediaSize" => 410878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-8d37c3159eedb5a52e519dfe3e28d123.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29912895_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/21b6eaffba637eadd7d7cbb83b64e548.webp"
"MediaSize" => 233326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-21b6eaffba637eadd7d7cbb83b64e548.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29912895_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/76996cf06e62124448ef7fc5a0d3ab4d.webp"
"MediaSize" => 181093
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-76996cf06e62124448ef7fc5a0d3ab4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29912895_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/b7583655d55f0c54bee9638d768aa66e.webp"
"MediaSize" => 188793
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-b7583655d55f0c54bee9638d768aa66e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29912895_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/765fd4c87d7fa914afd1e22fb78fe01f.webp"
"MediaSize" => 209197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-765fd4c87d7fa914afd1e22fb78fe01f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29912895_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/7ff4879424177e7f96f3a8e72d6c08ce.webp"
"MediaSize" => 164711
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-7ff4879424177e7f96f3a8e72d6c08ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29912895_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/3a38f301a955b2331a3f7ef232b712e3.webp"
"MediaSize" => 150405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-3a38f301a955b2331a3f7ef232b712e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29912895_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/8e43a39643f4fb4f7eaf5379ccc0319a.webp"
"MediaSize" => 154948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-8e43a39643f4fb4f7eaf5379ccc0319a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29912895_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/66cd52d9d1107e6eb72f74d278a49a46.webp"
"MediaSize" => 127490
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-66cd52d9d1107e6eb72f74d278a49a46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29912895_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/620645837387dc617bdacec22232e805.webp"
"MediaSize" => 206724
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-620645837387dc617bdacec22232e805.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29912895_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/9740899d4ed8c99bd09e163cab95ef3a.webp"
"MediaSize" => 178358
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-9740899d4ed8c99bd09e163cab95ef3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29912895_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/c1171762eccc0755a6101706ddeb7ef0.webp"
"MediaSize" => 181321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-c1171762eccc0755a6101706ddeb7ef0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29912895_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/60000bfb24cb1568204544017510f7a5.webp"
"MediaSize" => 175070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-60000bfb24cb1568204544017510f7a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29912895_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/585a01a791106aca4628eec3bc4f049a.webp"
"MediaSize" => 179129
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-585a01a791106aca4628eec3bc4f049a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29912895_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/8da9383aac5db4de0c4eb96abb9c118b.webp"
"MediaSize" => 177765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-8da9383aac5db4de0c4eb96abb9c118b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29912895_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/62367b8ee8a18f80062096452cc218a7.webp"
"MediaSize" => 147483
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-62367b8ee8a18f80062096452cc218a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29912895_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/1c42aaed56a33f8880786f0a640370e5.webp"
"MediaSize" => 170664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-1c42aaed56a33f8880786f0a640370e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29912895_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/60322702cbb69e899c1eb36a88ec3d15.webp"
"MediaSize" => 114303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-60322702cbb69e899c1eb36a88ec3d15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29912895_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/3c7f1288f42c1c5ddbefecd97391ef2b.webp"
"MediaSize" => 114303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-3c7f1288f42c1c5ddbefecd97391ef2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29912895_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/111633c212a4198625857ccaff229cf6.webp"
"MediaSize" => 98561
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-111633c212a4198625857ccaff229cf6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29912895_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/b8d9a782eddd3ded2aaa0e474a490602.webp"
"MediaSize" => 155117
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-b8d9a782eddd3ded2aaa0e474a490602.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29912895_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/85d0447ee6489d476a69bac74bc39bf5.webp"
"MediaSize" => 153346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-85d0447ee6489d476a69bac74bc39bf5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29912895_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/1fb5e580c160bfff24440230659cdda1.webp"
"MediaSize" => 184426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-1fb5e580c160bfff24440230659cdda1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29912895_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/bbc289bae1dcbf5e47eec070a65f4cb8.webp"
"MediaSize" => 197660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-bbc289bae1dcbf5e47eec070a65f4cb8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29912895_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/9192d1426936f423797abda1a119075e.webp"
"MediaSize" => 222168
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-9192d1426936f423797abda1a119075e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29912895_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/f4af648ba903233b548b26bcd4c2660d.webp"
"MediaSize" => 156100
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-f4af648ba903233b548b26bcd4c2660d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29912895_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/91c808b8a1f948023d5da8b42dcbee82.webp"
"MediaSize" => 184290
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-91c808b8a1f948023d5da8b42dcbee82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29912895_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/50aa839fab60dfd7bd57489df2b53ea7.webp"
"MediaSize" => 158156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-50aa839fab60dfd7bd57489df2b53ea7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29912895_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/3367137d8a3d2c54c8d470b4e25114a1.webp"
"MediaSize" => 141048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-3367137d8a3d2c54c8d470b4e25114a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29912895_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/3418b6af4d6de92f66e07706cac01064.webp"
"MediaSize" => 101129
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-3418b6af4d6de92f66e07706cac01064.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29912895_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/2f6f3104ec01adc7316340fa9ea99c22.webp"
"MediaSize" => 422049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-2f6f3104ec01adc7316340fa9ea99c22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29912895_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/7e38958834c7b014bc3bd0911fa76d71.webp"
"MediaSize" => 448610
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-7e38958834c7b014bc3bd0911fa76d71.webp"
…7
]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912895')"
+"ID": "1536562"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24766
+post_id: "1536272"
+post_author: 1
+"ListingKey": "29912090"
+"ListingId": "40838984"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T02:40:13Z"
+"RFModificationTimestamp": "2026-06-17T02:46:19Z"
+"ListPrice": 800000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.12
+"LivingArea": 2776.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2J3"
+"UnparsedAddress": "491 SANDBANKS Crescent, Waterloo, Ontario N2V2J3"
+"Coordinates": array:2 [
0 => -80.5768545
1 => 43.4964646
]
+"Latitude": 43.4964646
+"Longitude": -80.5768545
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "IS THIS YOUR NEW HOME? Situated in desirable Conservation Meadows, this 2 Storey home offers a special option for those needing accessible features, including a main floor bedroom and ramp to the front door (2015) and also a ramp off the deck (2016). The stunning acacia engineered hardwood flooring (2019) greets you as you enter this bright and spacious main floor. The updates continue into the kitchen with new white cabinetry, quartz counters, stainless appliances and dimmable pot lights (2022). The sliders to the backyard walk out to the peaceful backyard showcasing lovely perennial gardens, and also features an Arctic Spa Yukon hot tub. Upstairs you will find 3 good-sized bedrooms including a spacious primary bedroom with large walk-in closet, and a long bathroom with potential for splitting it into two (a main bath and an ensuite bath). In the finished basement you will find a newly finished rec room, large utility room / workshop area, laundry room, cold cellar, and a separate den/office/storage room (potential for a 5th bedroom!). Additional updates include roof (2014), air conditioner (2017) washer/dryer (approx 2021), dishwasher (2024). (id:62783)"
+"AccessibilityFeatures": array:1 [
0 => "Accessible Approach with Ramp"
]
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T20:49:21.761386+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1990854"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Sump Pump"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T00:32:16Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T02:32:01Z"
+"Stories": "2.0"
+"StreetName": "SANDBANKS"
+"StreetNumber": "491"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "6158"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/491-Sandbanks-Crescent"
+"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/29912090/491-sandbanks-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 2063
+"BelowGradeFinishedArea": 713
+"OriginalEntryTimestamp": "2026-06-16T20:10:34.34Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1274526"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:45 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912090')"
+"ID": "1536272"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24769
+post_id: "1536105"
+post_author: 1
+"ListingKey": "29911948"
+"ListingId": "40840389"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T21:40:11Z"
+"RFModificationTimestamp": "2026-06-16T21:44:59Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 2137.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4J3"
+"UnparsedAddress": "543 GLEN FORREST Boulevard, Waterloo, Ontario N2L4J3"
+"Coordinates": array:2 [
0 => -80.5539256
1 => 43.4861133
]
+"Latitude": 43.4861133
+"Longitude": -80.5539256
+"YearBuilt": 1967
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this detached bungalow in a desirable and tucked-away Waterloo location, offering over 1,800 sq. ft. of finished living space, a huge lot, and incredible potential inside and out. Perfect for first-time buyers, investors, or multi-generational families, this home features a bright main level with 3 bedrooms, 1 full bathroom, and comfortable living and dining areas. The separate entrance to the basement adds excellent flexibility, with 4 additional bedrooms and 2 full bathrooms, making it ideal for extended family use or potential mortgage-helper income. Set on a generous lot with 60 ft. frontage, this property offers parking for up to 4 vehicles in the driveway plus 1 in the garage. The backyard is a major highlight, offering so much potential to create a private outdoor retreat, garden space, patio area, or future entertaining setup. Located in a secluded area of Waterloo while still being close to everyday amenities, shopping, schools, public transportation, Conestoga College, and the University of Waterloo, this home provides both convenience and opportunity. Whether you are looking to move in, invest, or add value over time, this property is full of possibilities. Book your private showing today! * Some photos have been virtually staged. (id:62783)"
+"Appliances": array:3 [
0 => "Washer"
1 => "Stove"
2 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T20:34:13.849462+00:00"
+"Directions": "BEARINGER RD TO GLEN FORREST BLVD"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750682"
+"ListOfficeKey": "289792"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T19:50:57Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T21:32:44Z"
+"Stories": "1.0"
+"StreetName": "GLEN FORREST"
+"StreetNumber": "543"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "4425"
+"VirtualTourURLUnbranded": "https://youriguide.com/0frvu_543_glen_forrest_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29911948/543-glen-forrest-boulevard-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2172787"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "156376"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 1108
+"BelowGradeFinishedArea": 1029
+"OriginalEntryTimestamp": "2026-06-16T19:50:55.86Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1164848"
+"ListOfficeNationalAssociationId": "1381240"
+"CoListAgentNationalAssociationId": "1423270"
+"CoListOfficeNationalAssociationId": "1003925"
+"Media": array:31 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29911948')"
+"ID": "1536105"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24765
+post_id: "1534435"
+post_author: 1
+"ListingKey": "29909870"
+"ListingId": "X13450512"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:10:11Z"
+"RFModificationTimestamp": "2026-06-16T16:26:29Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4N7"
+"UnparsedAddress": "514 HAVELOCK DRIVE, Waterloo, Ontario N2L4N7"
+"Coordinates": array:2 [
0 => -80.55825
1 => 43.489526
]
+"Latitude": 43.489526
+"Longitude": -80.55825
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 514 Havelock Drive! Nestled in one of Waterloo's most sought-after family-friendly neighbourhoods, this well-maintained 3+1 bedroom, 2-bathroom bungalow offers the perfect combination of comfort, convenience, and future potential. The carpet-free main floor features a bright and functional layout with 3 spacious bedrooms, a full bathroom, a well-appointed kitchen, and inviting living and dining areas ideal for everyday living and entertaining. A separate side entrance provides excellent flexibility and potential for an in-law setup or multi-generational living. The fully finished basement expands your living space with a large rec room, an office or fourth bedroom, a 3-piece bathroom, laundry room, and a bonus workshop-perfect for hobbyists, DIY enthusiasts, or additional storage. Step outside to your own private retreat. The fully fenced backyard oasis is designed for relaxation and entertaining, featuring a spacious deck, storage shed, and a wooden gazebo covering the hot tub-an ideal space to unwind year-round. With parking for up to 5 vehicles, this home is perfectly suited for growing families and busy households. Deck (2023), Water Heater (2023), Washer & Dryer (2024), Roof (2023). Conveniently located just minutes from Highway 7 and Highway 8, as well as Wilfrid Laurier University, University of Waterloo, numerous parks and trails, and Conestoga Mall, this exceptional property offers an unbeatable location close to everything you need. Whether you're a growing family, investor, or buyer seeking multi-generational living potential, 514 Havelock Drive delivers outstanding value in an incredible Waterloo location. Book your private showing today! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T16:26:23.962076+00:00"
+"Directions": "Glen Forest Blvd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2127512"
+"ListOfficeKey": "283918"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Gazebo"
]
+"LotSizeDimensions": "43.1 x 122.2 FT"
+"ParkingFeatures": array:2 [
0 => "Covered"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T15:59:56Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:59:56Z"
+"Stories": "1.0"
+"StreetName": "Havelock"
+"StreetNumber": "514"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3987"
+"VirtualTourURLUnbranded": "https://youriguide.com/wqcfm_514_havelock_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29909870/514-havelock-drive-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 43.1
+"OriginalEntryTimestamp": "2026-06-16T15:59:55.98Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1380753"
+"ListOfficeNationalAssociationId": "1336772"
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909870')"
+"ID": "1534435"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24764
+post_id: "1534290"
+post_author: 1
+"ListingKey": "29909459"
+"ListingId": "40836533"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T15:20:10Z"
+"RFModificationTimestamp": "2026-06-16T15:36:25Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2101.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4N7"
+"UnparsedAddress": "514 HAVELOCK Drive, Waterloo, Ontario N2L4N7"
+"Coordinates": array:2 [
0 => -80.5582589
1 => 43.4895518
]
+"Latitude": 43.4895518
+"Longitude": -80.5582589
+"YearBuilt": 1971
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 514 Havelock Drive! Nestled in one of Waterloo’s most sought-after family-friendly neighbourhoods, this well-maintained 3+1 bedroom, 2-bathroom bungalow offers the perfect combination of comfort, convenience, and future potential. The carpet-free main floor features a bright and functional layout with 3 spacious bedrooms, a full bathroom, a well-appointed kitchen, and inviting living and dining areas ideal for everyday living and entertaining. A separate side entrance provides excellent flexibility and potential for an in-law setup or multi-generational living. The fully finished basement expands your living space with a large rec room, an office or fourth bedroom, a 3-piece bathroom, laundry room, and a bonus workshop—perfect for hobbyists, DIY enthusiasts, or additional storage. Step outside to your own private retreat. The fully fenced backyard oasis is designed for relaxation and entertaining, featuring a spacious deck, storage shed, and a wooden gazebo covering the hot tub—an ideal space to unwind year-round. With parking for up to 5 vehicles, this home is perfectly suited for growing families and busy households. Deck (2023), Water Heater (2023), Washer & Dryer (2024), Roof (2023). Conveniently located just minutes from Highway 7 and Highway 8, as well as Wilfrid Laurier University, University of Waterloo, numerous parks and trails, and Conestoga Mall, this exceptional property offers an unbeatable location close to everything you need. Whether you're a growing family, investor, or buyer seeking multi-generational living potential, 514 Havelock Drive delivers outstanding value in an incredible Waterloo location. Book your private showing today! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T15:36:23.785553+00:00"
+"Directions": "Glen Forest Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750161"
+"ListOfficeKey": "283896"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-06-16T15:13:40Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:13:40Z"
+"Stories": "1.0"
+"StreetName": "HAVELOCK"
+"StreetNumber": "514"
+"StreetSuffix": "Drive"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "3987"
+"VirtualTourURLUnbranded": "https://youriguide.com/wqcfm_514_havelock_dr_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/29909459/514-havelock-drive-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 43.0
+"AboveGradeFinishedArea": 1071
+"BelowGradeFinishedArea": 1030
+"OriginalEntryTimestamp": "2026-06-16T15:11:23.62Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1163644"
+"ListOfficeNationalAssociationId": "1349002"
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909459')"
+"ID": "1534290"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24757
+post_id: "1534996"
+post_author: 1
+"ListingKey": "29908944"
+"ListingId": "40839096"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T14:20:09Z"
+"RFModificationTimestamp": "2026-06-16T14:34:59Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1202.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1Z2"
+"UnparsedAddress": "255 NORTHLAKE Drive Unit# 15, Waterloo, Ontario N2V1Z2"
+"Coordinates": array:2 [
0 => -80.55183
1 => 43.4976023
]
+"Latitude": 43.4976023
+"Longitude": -80.55183
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Don't miss this opportunity to own a well-maintained home in Waterloo's desirable North Lakeshore neighbourhood. Location is everything! Just minutes from the LRT, Conestoga Mall, the St. Jacobs Market District, excellent schools, restaurants, grocery stores, parks, trails, and major highways. Walk or bike to almost everything you need. The main floor features a spacious entryway with a double closet, an updated powder room, and a bright white kitchen with newer countertops and sink, open to the dining and living areas. The functional layout offers comfortable everyday living with direct access to the backyard deck, perfect for relaxing or entertaining. With over 1,500 sq. ft. of finished living space, this home offers 3 bedrooms, 1.5 bathrooms, and a fully finished basement complete with a recreation room, laundry area, and rough-in for a future bathroom. Recent updates include modern laminate flooring, interior doors, and hardware. Outside, enjoy a welcoming patio and the convenience of a single carport. Ideal for first-time buyers, families, commuters, or investors looking for a low-maintenance home in a prime Waterloo location. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
]
+"AssociationFee": "500"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T14:34:50.434290+00:00"
+"Directions": "Weber and Golden Eagle"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564276"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:2 [
0 => "Carport"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-16T14:12:31Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T14:12:31Z"
+"Stories": "2.0"
+"StreetName": "NORTHLAKE"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "3036.39"
+"VirtualTourURLUnbranded": "https://youriguide.com/unit_15_255_northlake_dr_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/29908944/255-northlake-drive-unit-15-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1202
+"OriginalEntryTimestamp": "2026-06-16T14:10:40.39Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1107226"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908944')"
+"ID": "1534996"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1532260"
+post_author: 1
+"ListingKey": "29903651"
+"ListingId": "40839157"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T15:40:08Z"
+"RFModificationTimestamp": "2026-06-15T20:50:40Z"
+"ListPrice": 330000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 800.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1Z1"
+"UnparsedAddress": "331 NORTHLAKE Drive Unit# 5, Waterloo, Ontario N2V1Z1"
+"Coordinates": array:2 [
0 => -80.5540193
1 => 43.5009095
]
+"Latitude": 43.5009095
+"Longitude": -80.5540193
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 5 at 331 Northlake Drive, a bright and move-in-ready condo offering a practical layout and everyday convenience, perfect for first-time buyers, downsizers, or young families. The spacious open-concept living area creates an inviting space to relax, dine, and entertain, while the kitchen offers great functionality with restored cabinetry and plenty of room for daily use. New flooring and fresh paint throughout give the unit a clean, updated feel. Two comfortable bedrooms offer versatile options for a nursery, guest room, or office, and the refreshed bathroom adds a polished touch. Enjoy the convenience of in-suite laundry, plus a storage locker for extra storage and organization. Close to schools, parks, and trails, you’ll love this location in a quiet, family-friendly Waterloo neighbourhood. Groceries, dining, and fitness options are conveniently around the corner, while Conestoga Mall and the ION Rail are nearby. If you’re looking for a low-maintenance lifestyle in a convenient location, this unit is for you! Book your private showing today. (id:62783)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"AssociationFee": "335"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-15T20:46:42.470151+00:00"
+"Directions": "Swallow Street / Northlake Drive"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2025082"
+"ListOfficeKey": "291822"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Laundry- Coin operated"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-15T15:31:21Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T15:31:20Z"
+"Stories": "1.0"
+"StreetName": "NORTHLAKE"
+"StreetNumber": "331"
+"StreetSuffix": "Drive"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "2019.49"
+"VirtualTourURLUnbranded": "https://youtu.be/tTqPA_pGGbw"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29903651/331-northlake-drive-unit-5-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1989189"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "292624"
+"GeocodeManualYN": true
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 800
+"OriginalEntryTimestamp": "2026-06-15T15:31:20.93Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1304786"
+"ListOfficeNationalAssociationId": "1405037"
+"CoListAgentNationalAssociationId": "1273184"
+"CoListOfficeNationalAssociationId": "1414872"
+"Media": array:12 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29903651')"
+"ID": "1532260"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24763
+post_id: "1528066"
+post_author: 1
+"ListingKey": "29900056"
+"ListingId": "40839552"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T13:40:14Z"
+"RFModificationTimestamp": "2026-06-13T14:02:37Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 546.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K7"
+"UnparsedAddress": "145 COLUMBIA Street W Unit# 1536, Waterloo, Ontario N2L0K7"
+"Coordinates": array:2 [
0 => -80.5389137
1 => 43.4769907
]
+"Latitude": 43.4769907
+"Longitude": -80.5389137
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Society 145, a brand-new luxury condominium ideally located in the heart of Waterloo, just steps from both the University of Waterloo and Wilfrid Laurier University. The unit is adorned with high-end finishes, including hardwood floors, quartz countertops, stylish light fixtures, and rich carpentry throughout, ensuring a sophisticated and comfortable living environment. Modern kitchen featuring stainless steel appliances, ample storage, and an open-concept living area perfect for entertaining. The bedroom and den are spacious and fully furnished. Residents of 145 Society enjoy top-tier amenities, including a state-of-the-art fitness center, yoga studio, indoor basketball court, games room with billiards, ping pong, and arcade games, as well as a movie theater and business lounge. The ideal blend of luxury, convenience, and modern living - a perfect choice for anyone looking to invest in one of Waterloo's best buildings. 145 Columbia St. W. unit 1536 is currently occupied by Tenant, generating more than $2500.00per month. The lease will be end of August 2026. (id:62783)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
]
+"AssociationFee": "311.45"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"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-06-13T14:02:10.081436+00:00"
+"Directions": "Phillip St to Columbia St W"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2175198"
+"ListOfficeKey": "292482"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Southern exposure"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-13T13:31:32Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T13:31:31Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "COLUMBIA"
+"StreetNumber": "145"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3304.57"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29900056/145-columbia-street-w-unit-1536-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Exercise Centre"
]
+"ZoningDescription": "RN-25"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 546
+"OriginalEntryTimestamp": "2026-06-13T13:31:31.86Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1425540"
+"ListOfficeNationalAssociationId": "1412629"
+"Media": array:22 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29900056')"
+"ID": "1528066"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24711
+post_id: "1525986"
+post_author: 1
+"ListingKey": "29897607"
+"ListingId": "X13439034"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T15:25:16Z"
+"RFModificationTimestamp": "2026-06-15T15:25:56Z"
+"ListPrice": 779000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4J8"
+"UnparsedAddress": "598 GLEN FORREST BOULEVARD, Waterloo, Ontario N2L4J8"
+"Coordinates": array:2 [
0 => -80.557071
1 => 43.48873
]
+"Latitude": 43.48873
+"Longitude": -80.557071
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Opportunity knocks at 598 Glen Forrest Boulevard! This spacious bungalow is very deceiving from the street! offers a versatile floor plan with 4 bedrooms on the main floor and 2 additional bedrooms in the finished lower level. The home is equipped with 2 kitchens, 2 bathrooms, and a fully separate entrance. The home is ideally suited for multi-generational living, an in-law setup, or potential income-generating possibilities. Numerous upgrades have been completed throughout the years, making this property move-in ready while still offering future potential. Enjoy a double driveway and garage for ample parking. A fantastic location close to top-rated schools, parks, shopping, transit, and Waterloo's renowned universities. 5 minutes from the future home of the new waterloo regional hospital. Quick possession available for buyers looking to make their move without delay. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T00:11:02.146610+00:00"
+"Directions": "Cross Streets: Weber St. ** Directions: Northfield to Weber St S to Glen Forrest Blvd."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2143277"
+"ListOfficeKey": "284147"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "65.6 x 114.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T15:18:48Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T15:18:48Z"
+"Stories": "1.0"
+"StreetName": "Glen Forrest"
+"StreetNumber": "598"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "5227.74"
+"VirtualTourURLUnbranded": "https://youriguide.com/598_glen_forrest_boulevard_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/29897607/598-glen-forrest-boulevard-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 65.7
+"OriginalEntryTimestamp": "2026-06-12T19:50:44.02Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1406869"
+"ListOfficeNationalAssociationId": "1338998"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29897607')"
+"ID": "1525986"
}
]
+success: true
+page_size: 9
+page_count: 10
+count: 82
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]