array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30024348 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23472
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23474
+post_id: "1618779"
+post_author: 1
+"ListingKey": "30024348"
+"ListingId": "40847107"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T16:00:05Z"
+"RFModificationTimestamp": "2026-07-13T16:01:30Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1050.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A8"
+"UnparsedAddress": "778 LAURELWOOD Drive Unit# 405, Waterloo, Ontario N2V0A8"
+"Coordinates": array:2 [
0 => -80.598786
1 => 43.4711667
]
+"Latitude": 43.4711667
+"Longitude": -80.598786
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience care-free condo living at its finest in Waterloo’s premier Laurelwood neighbourhood. Welcome to Suite 405 at Laurelwood Reflections Phase 2, a stunning unit boasting over 1,000 sq ft of bright, open-concept living. The versatile floor plan features a wealth of natural light, offering total flexibility for your ideal living and dining configurations. Culinary enthusiasts will love the upgraded chef’s kitchen, complete with granite countertops, stainless steel appliances, abundant storage, and a large island with seating for three. The split bedroom layout is ideal for privacy and both bedrooms are generously sized. The primary bedroom features a spacious walk-in closet and a private 3-piece ensuite with a modern glass shower. Step outside onto your private balcony to enjoy picturesque, northern views of Creekside Pond and breathtaking seasonal foliage. There are 2 parking spots with 1 underground and 1 surface spot. Building amenities include a party room, lounge, theatre room, bike storage, visitor parking, and an outdoor BBQ pavilion. You'll love the location in a AAA+ family-friendly area. Walk to groceries, top-rated schools, walking trails, and the Laurel Creek Conservation Area. Turn-key, modern mid-rise living awaits! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"AssociationFee": "480.57"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Property Management"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T14:57:25.447459+00:00"
+"Directions": "Erbsville / Laurelwood Drive"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "Electric"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563807"
+"ListOfficeKey": "76849"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Balcony"
3 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-13T15:58:58Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T15:58:58Z"
+"Stories": "5.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "778"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "4083"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1683116091"
"RoomType" => "Bedroom"
"ListingId" => "40847107"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024348"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 13'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T15:58:58.26Z"
]
1 => array:11 [
"RoomKey" => "1683116092"
"RoomType" => "3pc Bathroom"
"ListingId" => "40847107"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024348"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T15:58:58.26Z"
]
2 => array:11 [
"RoomKey" => "1683116093"
"RoomType" => "Primary Bedroom"
"ListingId" => "40847107"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024348"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 12'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T15:58:58.26Z"
]
3 => array:11 [
"RoomKey" => "1683116094"
"RoomType" => "Living room"
"ListingId" => "40847107"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024348"
"RoomLength" => null
"RoomDimensions" => "16'4'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T15:58:58.26Z"
]
4 => array:11 [
"RoomKey" => "1683116095"
"RoomType" => "Kitchen"
"ListingId" => "40847107"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024348"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T15:58:58.26Z"
]
5 => array:11 [
"RoomKey" => "1683116096"
"RoomType" => "4pc Bathroom"
"ListingId" => "40847107"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024348"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T15:58:58.26Z"
]
6 => array:11 [
"RoomKey" => "1683116097"
"RoomType" => "Laundry room"
"ListingId" => "40847107"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024348"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T15:58:58.26Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30024348/778-laurelwood-drive-unit-405-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "MR100"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1050
+"OriginalEntryTimestamp": "2026-07-13T13:48:09.69Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1070148"
+"ListOfficeNationalAssociationId": "1004401"
+"Media": array:30 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30024348_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/e80acf57d3a20a90e0279e00ff150d05.webp"
"MediaSize" => 137043
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-e80acf57d3a20a90e0279e00ff150d05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T13:48:09.7Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30024348_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/40c25cb5dc58a8f0fe512ccdbd4df75f.webp"
"MediaSize" => 116267
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-40c25cb5dc58a8f0fe512ccdbd4df75f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T13:48:09.7Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30024348_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/6c29d514f3688a03a27dc9c4a014132c.webp"
"MediaSize" => 71108
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-6c29d514f3688a03a27dc9c4a014132c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T13:48:09.7Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30024348_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/13c1e644dc20868729accf8707cfd084.webp"
"MediaSize" => 72119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-13c1e644dc20868729accf8707cfd084.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T13:48:09.7Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30024348_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/fd16ff140700a10883cae1767f252870.webp"
"MediaSize" => 57842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-fd16ff140700a10883cae1767f252870.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T13:48:09.7Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30024348_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/d37d0a1f69a3999f007500aa1e61b64e.webp"
"MediaSize" => 68555
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-d37d0a1f69a3999f007500aa1e61b64e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T13:48:09.7Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30024348_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/0726dc96791d922bec51228c30507a42.webp"
"MediaSize" => 63393
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-0726dc96791d922bec51228c30507a42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T13:48:09.7Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30024348_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/77547dddc6a485d285263a73e89ab62d.webp"
"MediaSize" => 71667
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-77547dddc6a485d285263a73e89ab62d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T13:48:09.7Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30024348_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/63e36707ac2c4eb88227b7d66faff0cb.webp"
"MediaSize" => 73069
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-63e36707ac2c4eb88227b7d66faff0cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T15:52:43.7Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30024348_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/edb9465cbef745a46d0337c90c2bea47.webp"
"MediaSize" => 48913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-edb9465cbef745a46d0337c90c2bea47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T15:52:43.74Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30024348_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/e540adba695ad483e834def524a4ecf9.webp"
"MediaSize" => 49275
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-e540adba695ad483e834def524a4ecf9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T15:52:42.76Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30024348_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/0ceb87354eb51e1c4cf94d77b6dd3fa4.webp"
"MediaSize" => 71711
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-0ceb87354eb51e1c4cf94d77b6dd3fa4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T15:52:42.72Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30024348_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/d3112df7d570ba75932f491fff6cef65.webp"
"MediaSize" => 38450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-d3112df7d570ba75932f491fff6cef65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T15:52:43.74Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30024348_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/2856799afd1de026ff0a88422c55624b.webp"
"MediaSize" => 31649
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-2856799afd1de026ff0a88422c55624b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T15:52:43.71Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30024348_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/bc2c082533dea2a61214120ae2c3ad88.webp"
"MediaSize" => 50285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-bc2c082533dea2a61214120ae2c3ad88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T15:52:43.7Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30024348_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/1177c17037b6c505685aa71870a888d2.webp"
"MediaSize" => 56938
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-1177c17037b6c505685aa71870a888d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T15:52:42.71Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30024348_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/6b26d433c68349150d8ef1c3f492e67c.webp"
"MediaSize" => 48105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-6b26d433c68349150d8ef1c3f492e67c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T15:52:43.79Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30024348_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/b824e76585a6933c212351f9aeec9380.webp"
"MediaSize" => 47523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-b824e76585a6933c212351f9aeec9380.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T15:52:43.71Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30024348_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/b3ad1274d868279c88c2b7d5ae49a079.webp"
"MediaSize" => 71040
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-b3ad1274d868279c88c2b7d5ae49a079.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T15:52:43.71Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30024348_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/9f8645f8fbdf3d4c0ae775adfa708b04.webp"
"MediaSize" => 73471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-9f8645f8fbdf3d4c0ae775adfa708b04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T15:52:42.72Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30024348_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/6c402079afd56aa8705f5e042ad7f60b.webp"
"MediaSize" => 44780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-6c402079afd56aa8705f5e042ad7f60b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T15:52:43.77Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30024348_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/66c1e210cc9d6c81f9fb4006b236f2dc.webp"
"MediaSize" => 106578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-66c1e210cc9d6c81f9fb4006b236f2dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T15:52:43.71Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30024348_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/509fbc12e9efebb3ca9bd3cfdc63e873.webp"
"MediaSize" => 105063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-509fbc12e9efebb3ca9bd3cfdc63e873.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T15:52:45.66Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30024348_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/9f9ad4a8184c7d7fbe44b7c7c67ea42f.webp"
"MediaSize" => 118638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-9f9ad4a8184c7d7fbe44b7c7c67ea42f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T15:52:42.71Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30024348_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/2b52fe5f651594d705f2e9551ee24744.webp"
"MediaSize" => 123570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-2b52fe5f651594d705f2e9551ee24744.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T15:52:45.67Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30024348_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/37f221eaac83e20794cbe9490040ffdf.webp"
"MediaSize" => 81052
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-37f221eaac83e20794cbe9490040ffdf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T15:52:43.7Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30024348_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/3795a876bd10dd76c506caffe7d92f1c.webp"
"MediaSize" => 166875
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-3795a876bd10dd76c506caffe7d92f1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T15:52:45.67Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30024348_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/ee6a70049e2552c2c94b4bf01c7d90c9.webp"
"MediaSize" => 120926
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-ee6a70049e2552c2c94b4bf01c7d90c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T15:52:43.7Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30024348_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/077c8de181d3990b061d514ae85fc5c1.webp"
"MediaSize" => 68671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-077c8de181d3990b061d514ae85fc5c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T15:52:43.79Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30024348_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024348/ebe4b02fd3e500cb2b80ca8a108e2a5c.webp"
"MediaSize" => 153022
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024348/thumbnail-ebe4b02fd3e500cb2b80ca8a108e2a5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847107"
"ResourceRecordKey" => "30024348"
"ModificationTimestamp" => "2026-07-13T15:52:43.71Z"
]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30024348')"
+"ID": "1618779"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 76849" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24972
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24916
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "CENTURY 21 HERITAGE HOUSE LTD."
+"OfficeEmail": null
+"OfficePhone": "519-570-4663"
+"OfficeMlsId": "KW217"
+"ModificationTimestamp": "2026-03-24T17:19:43Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "76849"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "515 RIVERBEND DR., UNIT 103"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "KITCHENER"
+"OfficePostalCode": "N2K3S"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1004401"
+"OriginalEntryTimestamp": null
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "279161"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "76849"
"SocialMediaUrlOrId" => "http://heritagehouse.c21.ca/"
"ModificationTimestamp" => "2026-03-24T16:37:00Z"
]
]
+"FranchiseNationalAssociationId": "1205554"
+"OfficeBrokerNationalAssociationId": "1336243"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('76849')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1563807" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24926
+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 '30024348'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25262
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30024348' AND OpenHouseDate ge '2026-07-17'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25280
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25278
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31970649"
+"ListingKey": "30024348"
+"ListingId": "40847107"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-18"
+"OpenHouseStartTime": "2026-07-18T14:00:00Z"
+"OpenHouseEndTime": "2026-07-18T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-18T09:18:38Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31970649')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30024348' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.598786 43.4711667)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25333
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25327
+post_id: "1637112"
+post_author: 1
+"ListingKey": "30031516"
+"ListingId": "40847959"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:20:06Z"
+"RFModificationTimestamp": "2026-07-17T20:47:15Z"
+"ListPrice": 1089900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2882.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N5"
+"UnparsedAddress": "561 CHANCERY Lane, Waterloo, Ontario N2T2N5"
+"Coordinates": array:2 [
0 => -80.5790555
1 => 43.4649869
]
+"Latitude": 43.4649869
+"Longitude": -80.5790555
+"YearBuilt": 1994
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 561 Chancery Lane, Waterloo – a beautifully open and spacious backsplit nestled in one of Waterloo’s most desirable neighbourhoods. Offering 3 bedrooms, 3 full bathrooms, and exceptional indoor and outdoor living spaces, this home is designed for both everyday comfort and entertaining. The bright and inviting main level features soaring cathedral ceilings, hardwood flooring, and an open-concept living and dining area filled with natural light. The gourmet kitchen is sure to impress with stainless appliances, double wall ovens, a gas cooktop, built-in Miele coffee maker, and a spacious island perfect for gathering with family and friends. The lower level is an entertainer’s dream, showcasing a stylish bar area, custom built-ins, heated slate flooring, and a convenient walk-up to the backyard. A 3-piece bathroom on this level adds functionality and convenience for guests. Upstairs, you'll find three generously sized bedrooms and an updated 4-piece bathroom. The primary bedroom offers the added luxury of a private 3-piece ensuite. The basement provides excellent flexibility and can be used as a home gym, office, additional bedroom, or hobby space. A dedicated laundry room completes this level. Step outside to your own backyard retreat featuring a heated inground pool surrounded by stamped concrete. The cabana is fully equipped with hydro, speakers, a ceiling fan, and a fireplace, creating the perfect setting for summer entertaining. A separate pool house provides ample storage for all your pool equipment and accessories. Completing this home is a double attached garage and an exceptional location close to parks (backs onto Cavendish Park), shopping, and everyday amenities. Families will appreciate being situated within the highly sought-after school catchment for Laurelwood P.S., St. Nicholas Catholic School, Laurel Heights S.S., and Resurrection Catholic S.S., making this an outstanding place to call home. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
8 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:47:08.645552+00:00"
+"Directions": "Columbia/Chancery Lane"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Metal"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908292"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-14T18:25:31Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:10:04Z"
+"Stories": "3.0"
+"StreetName": "CHANCERY"
+"StreetNumber": "561"
+"StreetSuffix": "Lane"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "7433.43"
+"VirtualTourURLUnbranded": "https://youriguide.com/561_chancery_lane_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1686995605"
"RoomType" => "Utility room"
"ListingId" => "40847959"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30031516"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:10:04.33Z"
]
1 => array:11 [
"RoomKey" => "1686995606"
"RoomType" => "Bedroom"
"ListingId" => "40847959"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30031516"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 25'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:10:04.33Z"
]
2 => array:11 [
"RoomKey" => "1686995607"
"RoomType" => "Laundry room"
"ListingId" => "40847959"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30031516"
"RoomLength" => null
"RoomDimensions" => "6'2'' x 15'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:10:04.33Z"
]
3 => array:11 [
"RoomKey" => "1686995608"
"RoomType" => "Family room"
"ListingId" => "40847959"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "30031516"
"RoomLength" => null
"RoomDimensions" => "37'6'' x 16'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:10:04.33Z"
]
4 => array:11 [
"RoomKey" => "1686995609"
"RoomType" => "3pc Bathroom"
"ListingId" => "40847959"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "30031516"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:10:04.33Z"
]
5 => array:11 [
"RoomKey" => "1686995610"
"RoomType" => "Primary Bedroom"
"ListingId" => "40847959"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30031516"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 16'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:10:04.33Z"
]
6 => array:11 [
"RoomKey" => "1686995611"
"RoomType" => "Bedroom"
"ListingId" => "40847959"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30031516"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:10:04.33Z"
]
7 => array:11 [
"RoomKey" => "1686995612"
"RoomType" => "Bedroom"
"ListingId" => "40847959"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30031516"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:10:04.33Z"
]
8 => array:11 [
"RoomKey" => "1686995613"
"RoomType" => "4pc Bathroom"
"ListingId" => "40847959"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30031516"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:10:04.33Z"
]
9 => array:11 [
"RoomKey" => "1686995614"
"RoomType" => "Full bathroom"
"ListingId" => "40847959"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30031516"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:10:04.33Z"
]
10 => array:11 [
"RoomKey" => "1686995615"
"RoomType" => "Living room"
"ListingId" => "40847959"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30031516"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:10:04.34Z"
]
11 => array:11 [
"RoomKey" => "1686995616"
"RoomType" => "Kitchen"
"ListingId" => "40847959"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30031516"
"RoomLength" => null
"RoomDimensions" => "16'8'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:10:04.34Z"
]
12 => array:11 [
"RoomKey" => "1686995617"
"RoomType" => "Foyer"
"ListingId" => "40847959"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30031516"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:10:04.34Z"
]
13 => array:11 [
"RoomKey" => "1686995618"
"RoomType" => "Dining room"
"ListingId" => "40847959"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30031516"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:10:04.34Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30031516/561-chancery-lane-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 2130
+"BelowGradeFinishedArea": 752
+"OriginalEntryTimestamp": "2026-07-14T17:48:18.31Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1221205"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30031516_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031516/259ce55c68fbd08c71afda7f1d082ddc.webp"
"MediaSize" => 145091
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031516/thumbnail-259ce55c68fbd08c71afda7f1d082ddc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40847959"
"ResourceRecordKey" => "30031516"
"ModificationTimestamp" => "2026-07-14T18:25:28.71Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30031516_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031516/d7ef5248132d1db3658fccae92d42209.webp"
"MediaSize" => 170346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031516/thumbnail-d7ef5248132d1db3658fccae92d42209.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847959"
"ResourceRecordKey" => "30031516"
"ModificationTimestamp" => "2026-07-14T18:25:28.8Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30031516_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031516/d321e0413b2d8a5d7fdd8af6275d7635.webp"
"MediaSize" => 141340
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031516/thumbnail-d321e0413b2d8a5d7fdd8af6275d7635.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847959"
"ResourceRecordKey" => "30031516"
"ModificationTimestamp" => "2026-07-14T18:25:28.71Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30031516_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031516/10be8d10f56a5eb86c58e3217f492360.webp"
"MediaSize" => 81378
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031516/thumbnail-10be8d10f56a5eb86c58e3217f492360.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847959"
"ResourceRecordKey" => "30031516"
"ModificationTimestamp" => "2026-07-14T18:25:28.79Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30031516_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031516/c158dd4ddeac8aa46701277bee016690.webp"
"MediaSize" => 80461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031516/thumbnail-c158dd4ddeac8aa46701277bee016690.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847959"
"ResourceRecordKey" => "30031516"
"ModificationTimestamp" => "2026-07-14T18:25:28.79Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30031516_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031516/6796216eabbe2f8bc993dd7159f1f7d2.webp"
"MediaSize" => 97824
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031516/thumbnail-6796216eabbe2f8bc993dd7159f1f7d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847959"
"ResourceRecordKey" => "30031516"
"ModificationTimestamp" => "2026-07-14T18:25:28.74Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30031516_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031516/faaaff1e04dafe17e8663d229a5d4f94.webp"
"MediaSize" => 88498
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031516/thumbnail-faaaff1e04dafe17e8663d229a5d4f94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847959"
"ResourceRecordKey" => "30031516"
"ModificationTimestamp" => "2026-07-14T18:25:28.8Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30031516_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031516/d2b3286aecfc8e9d598643bae07e9e8e.webp"
"MediaSize" => 87073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031516/thumbnail-d2b3286aecfc8e9d598643bae07e9e8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847959"
"ResourceRecordKey" => "30031516"
"ModificationTimestamp" => "2026-07-14T18:25:28.71Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30031516_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031516/62d6206bf8239079088ca3199b72cc49.webp"
"MediaSize" => 96732
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031516/thumbnail-62d6206bf8239079088ca3199b72cc49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847959"
"ResourceRecordKey" => "30031516"
"ModificationTimestamp" => "2026-07-14T18:25:31.32Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30031516_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031516/306cb742e283f6d6105df6ea87755527.webp"
"MediaSize" => 71001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031516/thumbnail-306cb742e283f6d6105df6ea87755527.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847959"
"ResourceRecordKey" => "30031516"
"ModificationTimestamp" => "2026-07-14T18:25:29.76Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30031516_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031516/9fa075d8e2b930458411307f8a393595.webp"
"MediaSize" => 87177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031516/thumbnail-9fa075d8e2b930458411307f8a393595.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847959"
"ResourceRecordKey" => "30031516"
"ModificationTimestamp" => "2026-07-14T18:25:28.8Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30031516_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031516/9f72765120ee8358e4c0663820e632a8.webp"
"MediaSize" => 75911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031516/thumbnail-9f72765120ee8358e4c0663820e632a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847959"
"ResourceRecordKey" => "30031516"
"ModificationTimestamp" => "2026-07-14T18:25:28.79Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30031516_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031516/b5ff4ef79a4c2f905947332fcbde4ff2.webp"
"MediaSize" => 117700
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031516/thumbnail-b5ff4ef79a4c2f905947332fcbde4ff2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847959"
"ResourceRecordKey" => "30031516"
"ModificationTimestamp" => "2026-07-14T18:25:28.71Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30031516_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031516/62d930be67626c2883cc9c7bbe5e53f8.webp"
"MediaSize" => 101633
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031516/thumbnail-62d930be67626c2883cc9c7bbe5e53f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847959"
"ResourceRecordKey" => "30031516"
"ModificationTimestamp" => "2026-07-14T18:25:28.77Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30031516_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031516/cd75262b7be5b3d93b91e99fb047c785.webp"
"MediaSize" => 91507
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031516/thumbnail-cd75262b7be5b3d93b91e99fb047c785.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847959"
"ResourceRecordKey" => "30031516"
"ModificationTimestamp" => "2026-07-14T18:25:28.8Z"
]
15 => array:13 [
"Order" => 16
…12
]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30031516')"
+"ID": "1637112"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25329
+post_id: "1626530"
+post_author: 1
+"ListingKey": "30034584"
+"ListingId": "40844927"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T19:50:03Z"
+"RFModificationTimestamp": "2026-07-17T23:46:33Z"
+"ListPrice": 3150000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 6452.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2G3"
+"UnparsedAddress": "596 REGAL Place, Waterloo, Ontario N2V2G3"
+"Coordinates": array:2 [
0 => -80.6023274
1 => 43.4779011
]
+"Latitude": 43.4779011
+"Longitude": -80.6023274
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience upscale living in this stunning, over 6000 sq ft rarely found bungalow located in one of Waterloo’s most prestigious neighborhoods! The main level features three bedrooms, each with its own walk-in closet and private ensuite! A bright, welcoming foyer leads to a spacious living room with 12 ft ceiling, a gas fireplace, a stunning, open-concept kitchen with a large granite countertop, plenty of cabinets, butler's kitchen, high-end Miele appliances, and a sunny dining area that’s sure to impress. The main floor also includes an office with large windows for plenty of natural light, a separate dining room, a generous walk-in kitchen pantry, a beautiful 2 piece bathroom, and a laundry room. Head down to the expansive wide open basement and discover large windows, two large additional bedrooms (one currently serving as a gym), a luxurious three-piece bathroom, two spacious living areas, a bar/kitchenette, and plenty of room to let your creativity flow. The garage fits three cars and includes stairs leading down to the basement. This home features in-floor heating, granite countertops, high-end finishes throughout and top-of-the-line craftsmanship. The beautifully landscaped backyard is an entertainer’s dream, complete with an inground heated pool, a covered sitting area, and plenty of space for kids to play or for hosting parties. Regal Place is a private street with no through traffic and close to some of the best schools in the region and many amenities. Homes like this are rarely offered for sale. Don't let this one slip away! (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Range - Gas"
6 => "Dishwasher"
7 => "Dryer"
8 => "Freezer"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
12 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T14:09:19.084098+00:00"
+"Directions": "Erbsville Rd"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2046754"
+"ListOfficeKey": "76840"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T19:41:11Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T19:41:11Z"
+"Stories": "1.0"
+"StreetName": "REGAL"
+"StreetNumber": "596"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "17817.31"
+"VirtualTourURLUnbranded": "https://youriguide.com/596_regal_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:20 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30034584/596-regal-place-waterloo"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 78.0
+"AboveGradeFinishedArea": 3285
+"BelowGradeFinishedArea": 3167
+"OriginalEntryTimestamp": "2026-07-15T11:49:59.46Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1322161"
+"ListOfficeNationalAssociationId": "1004363"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30034584')"
+"ID": "1626530"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25326
+post_id: "1625940"
+post_author: 1
+"ListingKey": "30034297"
+"ListingId": "40846141"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T02:55:21Z"
+"RFModificationTimestamp": "2026-07-15T04:44:45Z"
+"ListPrice": 1114000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2245.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2V0H6"
+"UnparsedAddress": "325 CANADA PLUM Street Unit# LOT 225, Kitchener, Ontario N2V0H6"
+"Coordinates": array:2 [
0 => -80.5972206
1 => 43.4571271
]
+"Latitude": 43.4571271
+"Longitude": -80.5972206
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Summer Promo - fully finished basement and a pressure treated deck with aluminum railings — just the beginning of what sets this exceptional to-be-built home apart. This stunning 4-bedroom, 3-bathroom home is thoughtfully designed to showcase elevated craftsmanship, timeless finishes, and sophisticated design throughout. A grand foyer creates an impressive first impression, welcoming you into a spacious open-concept layout designed for both everyday living and entertaining. With generous principal rooms, 9' ceilings on the main floor, a 9' foundation in the basement, engineered hardwood flooring, a hardwood staircase, custom cabinetry, quartz countertops throughout, and carefully curated finishes, every detail has been selected to deliver a refined and luxurious living experience. The chef-inspired kitchen serves as the heart of the home, complete with high-end appliances included, while the professionally finished basement provides even more living space for a recreation room, home office, fitness area, guest accommodations, or all of the above. The walk-up basement enhances the home's functionality and future flexibility, while the main-floor deck creates the perfect setting for outdoor dining and entertaining. Finished with a concrete driveway for lasting curb appeal, and ideally located near top-rated schools, scenic trails, parks, shopping, and everyday amenities, this rare opportunity allows you to own a luxury build, crafted with exceptional attention to detail. Experience the perfect blend of quality, comfort, and modern living in one of Waterloo's most desirable communities. (id:62650)"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T04:44:41.508572+00:00"
+"Directions": "Ira Needles Blvd & Er Street West"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1942381"
+"ListOfficeKey": "277572"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T02:48:21Z"
+"PhotosCount": 3
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T02:48:21Z"
+"Stories": "2.0"
+"StreetName": "CANADA PLUM"
+"StreetNumber": "325"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30034297/325-canada-plum-street-unit-lot-225-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1750692"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "300344"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2245
+"OriginalEntryTimestamp": "2026-07-15T02:48:20.98Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1238864"
+"ListOfficeNationalAssociationId": "1285375"
+"CoListAgentNationalAssociationId": "1117625"
+"CoListOfficeNationalAssociationId": "1486985"
+"Media": array:3 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30034297')"
+"ID": "1625940"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25330
+post_id: "1624331"
+post_author: 1
+"ListingKey": "30031061"
+"ListingId": "40847488"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T16:05:27Z"
+"RFModificationTimestamp": "2026-07-15T16:25:27Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1398.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2X1"
+"UnparsedAddress": "619 WILD GINGER Avenue Unit# H47, Waterloo, Ontario N2V2X1"
+"Coordinates": array:2 [
0 => -80.5939632
1 => 43.4698313
]
+"Latitude": 43.4698313
+"Longitude": -80.5939632
+"YearBuilt": 2006
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "***OPEN HOUSE: SATURDAY JULY 18TH AND SUNDAY JULY 19TH 2-4pm*** Welcome to Unit H47 at 619 Wild Ginger Avenue, a beautifully refreshed four-level townhome offering exceptional value for first-time buyers, families, or investors. Lovingly maintained by the same tenant since 2007, this home has been thoughtfully updated and is move-in ready. Freshly painted throughout, with new flooring, modern lighting, and a stylish new kitchen backsplash, it offers a bright feel from the moment you arrive. The Furnace and AC were replaced in 2024 and 2026 respectively. The front door was replaced in 2022. The main level features a spacious eat-in kitchen, a convenient two-piece powder room, and a generous living room overlooking your private backyard. Upstairs, you'll find two large bedrooms, including a primary bedroom with direct access to the four-piece main bathroom through a convenient cheater ensuite. The lower level offers an ideal third bedroom, home office, or family room, complete with its own three-piece ensuite bathroom. Sliding doors lead to a private deck and fenced backyard. The basement, accessible through the attached garage, houses the laundry area, HVAC system, and additional storage space. Located in a desirable neighbourhood, this home is close to excellent elementary and secondary schools, shopping, parks, public transit, and other everyday conveniences. Whether you're looking for your next home or a smart investment opportunity, this property is one you won't want to miss. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Central Vacuum - Roughed In"
]
+"AssociationFee": "277"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-14T19:42:59.525510+00:00"
+"Directions": "First right turn into complex off of Wild Ginger Ave"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2067711"
+"ListOfficeKey": "286933"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-14T20:48:23Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T15:59:27Z"
+"Stories": "3.0"
+"StreetName": "WILD GINGER"
+"StreetNumber": "619"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3852.78"
+"VirtualTourURLUnbranded": "https://youriguide.com/h47_619_wild_ginger_ave_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30031061/619-wild-ginger-avenue-unit-h47-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1564408"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "286933"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "70-RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1398
+"OriginalEntryTimestamp": "2026-07-14T16:48:17.46Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1342782"
+"ListOfficeNationalAssociationId": "1364894"
+"CoListAgentNationalAssociationId": "1129302"
+"CoListOfficeNationalAssociationId": "1364894"
+"Media": array:37 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30031061')"
+"ID": "1624331"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25328
+post_id: "1621722"
+post_author: 1
+"ListingKey": "30027421"
+"ListingId": "40842165"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T20:55:28Z"
+"RFModificationTimestamp": "2026-07-13T23:04:11Z"
+"ListPrice": 149900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 700.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3Z4"
+"UnparsedAddress": "580 BEAVER CREEK Road Unit# Lot 158, Waterloo, Ontario N2J3Z4"
+"Coordinates": array:2 [
0 => -80.5851199
1 => 43.4834036
]
+"Latitude": 43.4834036
+"Longitude": -80.5851199
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Private serene setting in Green Acre Park. Located right next to beautiful forest and no rear or side neighbours. Approximately 700 sf plus 500 sf of freshly painted deck plus gazebo to enjoy a wonderful summer in a resort like park with lots of fun amenities. Newer French doors, roof furnace and AC. Nothing to do but enjoy. Tastefully decorated throughout with two bedrooms, one bathroom and an open concept kitchen dining and living room area. Lots of room to park on a dead end street. Large yard area with campfire pit and shed for storage. Park is closed January and February. Annual lease fees include use of all amenities to include heated swimming pool, playground, mini putt, fishing pond and more. Also includes water, sewer, garbage disposal, property taxes and common area maintenance. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T23:04:05.092522+00:00"
+"Directions": "Conservation Rd/Beaver Creek Rd"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "None"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1987928"
+"ListOfficeKey": "288925"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Crushed stone driveway"
1 => "Country residential"
2 => "Recreational"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-13T20:54:29Z"
+"PhotosCount": 22
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T20:54:29Z"
+"Stories": "1.0"
+"StreetName": "BEAVER CREEK"
+"StreetNumber": "580"
+"StreetSuffix": "Road"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"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/30027421/580-beaver-creek-road-unit-lot-158-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Modular"
]
+"CommonInterest": "Leasehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 700
+"OriginalEntryTimestamp": "2026-07-13T20:49:06.49Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1272130"
+"ListOfficeNationalAssociationId": "1372539"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30027421')"
+"ID": "1621722"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25323
+post_id: "1619390"
+post_author: 1
+"ListingKey": "30024345"
+"ListingId": "40847363"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T17:20:05Z"
+"RFModificationTimestamp": "2026-07-13T17:22:08Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.12
+"LivingArea": 1793.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P1"
+"UnparsedAddress": "742 BROOKMILL Place, Waterloo, Ontario N2V2P1"
+"Coordinates": array:2 [
0 => -80.58336
1 => 43.4751863
]
+"Latitude": 43.4751863
+"Longitude": -80.58336
+"YearBuilt": 2000
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Positioned at the end of a quiet cul-de-sac in Waterloo's sought-after Laurelwood neighbourhood, this beautifully maintained home sits on a pie-shaped lot backing onto a conservation area with no rear neighbours. Offering 1,230 sq. ft. above grade and nearly 1,800 sq. ft. of finished living space, this smoke-free, pet-free home features 3 bedrooms, 2 bathrooms, and a finished basement with a rough-in for an additional bathroom. The bright, open-concept main floor features hardwood flooring and a spacious Great Room with soaring cathedral ceilings and views of the forest beyond. Upstairs, the generous primary bedroom offers cheater ensuite access, while two additional bedrooms provide room for family, guests, or a home office. The finished basement includes a bright recreation room, laundry and mechanical area, storage, and a rough-in for a future 2-piece bathroom. Outside, the pie-shaped backyard is a great place to unwind or entertain, with a multi-level, surrounded by trees. Recent updates include an RO water system (2026), broadloom in the basement and on the upper stairs (2026), kitchen faucet (2025), upper bathroom sink and faucet (2025), and washer and dryer (2024). Located close to excellent schools, parks, walking trails, shopping, the YMCA, library, and both universities, this is a wonderful opportunity to own a home in the heart of Laurelwood. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T17:20:08.994594+00:00"
+"Directions": "West on Laurelwood from Fischer-Hallman, then north on Brookmill Pl."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981704"
+"ListOfficeKey": "289890"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T17:18:16Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T17:18:16Z"
+"Stories": "2.0"
+"StreetName": "BROOKMILL"
+"StreetNumber": "742"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "4970.51"
+"VirtualTourURLUnbranded": "https://youriguide.com/742_brookmill_place_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/30024345/742-brookmill-place-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 22.0
+"AboveGradeFinishedArea": 1230
+"BelowGradeFinishedArea": 563
+"OriginalEntryTimestamp": "2026-07-13T13:48:07.94Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1267102"
+"ListOfficeNationalAssociationId": "1382470"
+"Media": array:46 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30024345')"
+"ID": "1619390"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "1618344"
+post_author: 1
+"ListingKey": "30023566"
+"ListingId": "40847402"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T17:05:21Z"
+"RFModificationTimestamp": "2026-07-17T17:10:50Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1086.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A8"
+"UnparsedAddress": "776 LAURELWOOD Drive Unit# 302, Waterloo, Ontario N2V0A8"
+"Coordinates": array:2 [
0 => -80.5988401
1 => 43.4699593
]
+"Latitude": 43.4699593
+"Longitude": -80.5988401
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning two-bedroom, two-bathroom corner suite featuring a rare southwest exposure and an abundance of natural light throughout the day. This bright and spacious open-concept layout offers comfortable living and effortless entertaining. The modern kitchen is equipped with ample cabinetry, stainless steel appliances, and a functional center island, with sliding doors leading to a private balcony overlooking the expansive green space of the neighboring school grounds. The sun-filled living room is enhanced by two large windows, while the primary bedroom features a large window and a private ensuite with a walk-in glass shower. The generously sized second bedroom is conveniently located next to a full four-piece bathroom, making it ideal for family members or guests. Additional features include in-suite laundry with a stackable washer and dryer, one above-grade parking space (#111), and an oversized exclusive storage locker (#1707) located in Locker Room 1700 on the main floor. Situated in the highly sought-after Laurelwood community, this exceptional condo backs onto top-rated Waterloo Region schools, including Laurel Heights Secondary School and Abraham Erb Public School. Public transit provides direct access to the University of Waterloo and major shopping destinations, while supermarkets, shops, the YMCA, library, parks, playgrounds, nature trails, and Laurel Creek Conservation Area are all within walking distance. Residents enjoy excellent building amenities including a welcoming lobby, elevator, outdoor BBQ area, games room, theatre room, party room, visitor parking, and bicycle storage. This is a rare opportunity to own a beautiful, move-in ready home in one of Waterloo's most desirable neighbourhoods (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFee": "446.94"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T00:50:54.970748+00:00"
+"Directions": "Erbsville Rd. turn to Laurelwood Dr."
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2139921"
+"ListOfficeKey": "291992"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-12T22:18:00Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T16:59:48Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "776"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3953.04"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30023566/776-laurelwood-drive-unit-302-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2247895"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "291992"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1086
+"OriginalEntryTimestamp": "2026-07-12T22:18:00.75Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1391697"
+"ListOfficeNationalAssociationId": "1407252"
+"CoListAgentNationalAssociationId": "1486775"
+"CoListOfficeNationalAssociationId": "1407252"
+"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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30023566')"
+"ID": "1618344"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25331
+post_id: "1615622"
+post_author: 1
+"ListingKey": "30020496"
+"ListingId": "X13551506"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T17:45:02Z"
+"RFModificationTimestamp": "2026-07-17T17:56:20Z"
+"ListPrice": 1399000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0E7"
+"UnparsedAddress": "787 SNOWBERRY COURT, Waterloo, Ontario N2V0E7"
+"Coordinates": array:2 [
0 => -80.602215
1 => 43.462072
]
+"Latitude": 43.462072
+"Longitude": -80.602215
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A great house in an equally great neighborhood! 787 Snowberry court is one of the few walkout lots on the quiet court in Vista Hills: a neighborhood emersed into nature surrounded by forests of walking trails and some of the top-rated schools in the region. This classic all brick and stone 2 story has beautiful curb appeal, further enhanced by its interlocking driveway and armour stone accents. The double front doors open to a large foyer; adjacent to it is the living room/office, a formal space at the front of the home. The main level was designed around an open spiral oak staircase providing a stunning centre piece that elegantly connects the main floor to the second. The flooring throughout the main is a combination of modern 12x24 tile and wide plank engineered hardwood. The design flows freely through the dining room, over sized kitchen, and dinette overlooking the fully fenced yard complete with composite fencing. The kitchen features abundant cabinet space, built-in stainless-steel appliances, and quartz countertops. The family room sits adjacent and showcases a beautiful fireplace feature wall with staggered floating shelves. The sunken mudroom achieves a partial separation from the main level and is an extremely practical space for access to and from the garage with groceries and preparations. Hardwood flooring continues to finish the space in the high traffic hallway of the second floor. Four bedrooms, 3 bathrooms and a conveniently located laundry make up the second-floor space. The primary bedroom sits at the back of the home and features a walk-in closet with elegant 5 piece ensuite; complete with glass shower and soaker tub. The second bedroom also features a private 3 piece ensuite with glass shower, leaving the 3rd and 4th bedrooms sharing a 5-piece jack and jill bathroom with all the vanities in the home finished in quartz. The basement is ready for your imagination; large windows and large footprint provide lots of finishing options! Don't miss it! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Water Heater"
]
+"Basement": array:4 [
0 => "Unfinished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-11T01:00:31.849246+00:00"
+"Directions": "Cross Streets: Pasture Rose. ** Directions: Columbia to Sundew L to Mayapple R on Autumn Willow R onto Snowberry."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2239281"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "46.1 x 108 M"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-10T22:35:26Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T17:39:30Z"
+"Stories": "2.0"
+"StreetName": "Snowberry"
+"StreetNumber": "787"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "10383.89"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=Vn1tecMngZM"
+"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/30020496/787-snowberry-court-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 46.1
+"OriginalEntryTimestamp": "2026-07-10T22:35:25.94Z"
+"FrontageLengthNumericUnits": "meters"
+"ListAgentNationalAssociationId": "1477313"
+"ListOfficeNationalAssociationId": "1385020"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30020496')"
+"ID": "1615622"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25332
+post_id: "1614857"
+post_author: 1
+"ListingKey": "30019821"
+"ListingId": "40846992"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T16:30:13Z"
+"RFModificationTimestamp": "2026-07-17T16:33:37Z"
+"ListPrice": 1399000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3118.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0E7"
+"UnparsedAddress": "787 SNOWBERRY Court, Waterloo, Ontario N2V0E7"
+"Coordinates": array:2 [
0 => -80.6023722
1 => 43.4620727
]
+"Latitude": 43.4620727
+"Longitude": -80.6023722
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A great house in an equally great neighborhood! 787 Snowberry court is one of the few walkout lots on the quiet court in Vista Hills: a neighborhood emersed into nature surrounded by forests of walking trails and some of the top-rated schools in the region. This classic all brick and stone 2 story has beautiful curb appeal, further enhanced by its interlocking driveway and armour stone accents. The double front doors open to a large foyer; adjacent to it is the living room/office, a formal space at the front of the home. The main level was designed around an open spiral oak staircase providing a stunning centre piece that elegantly connects the main floor to the second. The flooring throughout the main is a combination of modern 12x24 tile and wide plank engineered hardwood. The design flows freely through the dining room, over sized kitchen, and dinette overlooking the fully fenced yard complete with composite fencing. The kitchen features abundant cabinet space, built-in stainless-steel appliances, and quartz countertops. The family room sits adjacent and showcases a beautiful fireplace feature wall with staggered floating shelves. The sunken mudroom achieves a partial separation from the main level and is an extremely practical space for access to and from the garage with groceries and preparations. Hardwood flooring continues to finish the space in the high traffic hallway of the second floor. Four bedrooms, 3 bathrooms and a conveniently located laundry make up the second-floor space. The primary bedroom sits at the back of the home and features a walk-in closet with elegant 5 piece ensuite; complete with glass shower and soaker tub. The second bedroom also features a private 3 piece ensuite with glass shower, leaving the 3rd and 4th bedrooms sharing a 5-piece jack and jill bathroom with all the vanities in the home finished in quartz. The basement is ready for your imagination; large windows and large footprint provide lots of finishing options! Don't miss it! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-10T22:19:17.065389+00:00"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1836163"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Cul-de-sac"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-14T17:41:32Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T16:18:32Z"
+"Stories": "2.0"
+"StreetName": "SNOWBERRY"
+"StreetNumber": "787"
+"StreetSuffix": "Court"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "10383.89"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=Vn1tecMngZM"
+"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/30019821/787-snowberry-court-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1563584"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76789"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 46.0
+"AboveGradeFinishedArea": 3118
+"OriginalEntryTimestamp": "2026-07-10T21:18:20.49Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1197077"
+"ListOfficeNationalAssociationId": "1384313"
+"CoListAgentNationalAssociationId": "1143001"
+"CoListOfficeNationalAssociationId": "1004357"
+"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": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30019821')"
+"ID": "1614857"
}
]
+success: true
+page_size: 9
+page_count: 9
+count: 81
+after_key: ""
}
"RF Response Time" => "0.32 seconds"
]
]