array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29182172/Property?$select=ALL&$top=20&$filter=ListingKey eq 29182172&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29182172/Property?$select=ALL&$top=20&$filter=ListingKey eq 29182172&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23634
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23636
+post_id: "477718"
+post_author: 1
+"ListingKey": "29182172"
+"ListingId": "40791630"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-12T12:55:12Z"
+"RFModificationTimestamp": "2025-12-12T19:41:25Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1033.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G3"
+"UnparsedAddress": "778 LAURELWOOD Drive Unit# 403, Waterloo, Ontario N2V0G3"
+"Coordinates": array:2 [
0 => -80.5987556
1 => 43.4711694
]
+"Latitude": 43.4711694
+"Longitude": -80.5987556
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautifully maintained 2-bedroom, 2-bathroom condo for lease in Waterloo’s desirable Laurelwood neighbourhood. Owner-occupied and offering a practical, well-designed layout and approximately 1,000 sq. ft. of comfortable living space. The modern kitchen features granite countertops, a tiled backsplash, a large island, stainless steel appliances, and ample counter space. Additional features include in-suite laundry and a private balcony. The primary bedroom offers a walk-in closet and a 3-piece ensuite. Monthly rent includes water, 2 parking spots (one underground, one surface level), plus a storage locker. Located in a well-kept 7-storey building, residents enjoy excellent on-site amenities such as a bicycle storage room, central gazebo with BBQs and prep station, private theatre, entertainment lounge with pool table and kitchenette, and a versatile multi-purpose event room. Ideally situated within walking distance of Waterloo’s top ranked schools, and close to parks, shopping, public transit, and The Boardwalk. Easy access to both universities. Book your private showing today. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Water"
4 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-12T19:41:05.699741+00:00"
+"Directions": "From Erbsville Rd to Laurelwood Dr"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2045949"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Gazebo"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Covered"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2025-12-12T12:49:26Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-12T12:49:26Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "778"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1547827891"
"RoomType" => "Living room"
"ListingId" => "40791630"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29182172"
"RoomLength" => null
"RoomDimensions" => "15'7'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T12:49:26.22Z"
]
1 => array:11 [
"RoomKey" => "1547827892"
"RoomType" => "Full bathroom"
"ListingId" => "40791630"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29182172"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T12:49:26.23Z"
]
2 => array:11 [
"RoomKey" => "1547827893"
"RoomType" => "4pc Bathroom"
"ListingId" => "40791630"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29182172"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T12:49:26.23Z"
]
3 => array:11 [
"RoomKey" => "1547827894"
"RoomType" => "Kitchen"
"ListingId" => "40791630"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29182172"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 16'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T12:49:26.23Z"
]
4 => array:11 [
"RoomKey" => "1547827895"
"RoomType" => "Primary Bedroom"
"ListingId" => "40791630"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29182172"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T12:49:26.23Z"
]
5 => array:11 [
"RoomKey" => "1547827896"
"RoomType" => "Bedroom"
"ListingId" => "40791630"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29182172"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T12:49:26.23Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29182172/778-laurelwood-drive-unit-403-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2650
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1033
+"OriginalEntryTimestamp": "2025-12-12T12:49:26.16Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:40 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6365545504"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/114450629fbe5d441ffe15bfc7d0c50b.webp"
"MediaSize" => 150921
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-114450629fbe5d441ffe15bfc7d0c50b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6365545505"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/fd66d00cbcc264966501d899a4c6ed6b.webp"
"MediaSize" => 93434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-fd66d00cbcc264966501d899a4c6ed6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6365545507"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/7fcaaaf3df24ecfe15f991d9aa319765.webp"
"MediaSize" => 114072
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-7fcaaaf3df24ecfe15f991d9aa319765.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6365545511"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/2ee244053e161ddbb8430b707f134afd.webp"
"MediaSize" => 95720
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-2ee244053e161ddbb8430b707f134afd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6365545513"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/3cdaccd3b4b5e9b782740ce38b5d3958.webp"
"MediaSize" => 83902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-3cdaccd3b4b5e9b782740ce38b5d3958.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6365545518"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/ef32109bd88f4a23496a824b2a6f8e43.webp"
"MediaSize" => 88035
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-ef32109bd88f4a23496a824b2a6f8e43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6365545522"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/4d6b3d56860af4dec2a422d05859b800.webp"
"MediaSize" => 81556
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-4d6b3d56860af4dec2a422d05859b800.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6365545525"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/917c805a1d5750e896c90cf4c4da400a.webp"
"MediaSize" => 93523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-917c805a1d5750e896c90cf4c4da400a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6365545527"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/13cc138af802ae5e5a6364e35a5c4368.webp"
"MediaSize" => 98302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-13cc138af802ae5e5a6364e35a5c4368.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6365545530"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/471a78fdc59acb3eef4fdf74fa48a6a5.webp"
"MediaSize" => 95966
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-471a78fdc59acb3eef4fdf74fa48a6a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6365545532"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/50cf3cdaf1c6b12a89367c6cc35e02e0.webp"
"MediaSize" => 105762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-50cf3cdaf1c6b12a89367c6cc35e02e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6365545535"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/54ab055ab74910519ba5e3046543778b.webp"
"MediaSize" => 100474
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-54ab055ab74910519ba5e3046543778b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6365545539"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/a2830c1ac3d533c0da194dd549b6aaab.webp"
"MediaSize" => 116395
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-a2830c1ac3d533c0da194dd549b6aaab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6365545541"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/f0f7dd68820e017b7d31ed35ffb6b104.webp"
"MediaSize" => 92180
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-f0f7dd68820e017b7d31ed35ffb6b104.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6365545543"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/dd4b1f2f3bcf1e6a3dcec6a674d34cf0.webp"
"MediaSize" => 124750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-dd4b1f2f3bcf1e6a3dcec6a674d34cf0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6365545546"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/7bb7bcb17be6a4aa229e183cf66032bf.webp"
"MediaSize" => 91357
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-7bb7bcb17be6a4aa229e183cf66032bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6365545548"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/cd3df8e9451e86fbebaf14ea2921c8f4.webp"
"MediaSize" => 90723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-cd3df8e9451e86fbebaf14ea2921c8f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6365545550"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/11986fdbd4d2fcb079551e85888cb6ee.webp"
"MediaSize" => 103746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-11986fdbd4d2fcb079551e85888cb6ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6365545551"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/ca36c0a6d7ac46a9a7b7c9eed98142f6.webp"
"MediaSize" => 74168
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-ca36c0a6d7ac46a9a7b7c9eed98142f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6365545555"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/3b1ddcb1afa5fbbfff86d497d346e925.webp"
"MediaSize" => 80430
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-3b1ddcb1afa5fbbfff86d497d346e925.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually staged photo"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6365545557"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/cbbf624dfc1944ae066db19a45518643.webp"
"MediaSize" => 74039
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-cbbf624dfc1944ae066db19a45518643.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6365545560"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/d461121a0f77a4884b4ab06bd207b94e.webp"
"MediaSize" => 95801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-d461121a0f77a4884b4ab06bd207b94e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6365545562"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/65391b7b3c79091df4fe4e2431f3b627.webp"
"MediaSize" => 79407
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-65391b7b3c79091df4fe4e2431f3b627.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6365545564"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/4a82a94cd52087105d5031e8e26f7214.webp"
"MediaSize" => 76971
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-4a82a94cd52087105d5031e8e26f7214.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually staged photo"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6365545567"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/dc6d981e925a05efb5e1866ba81f7200.webp"
"MediaSize" => 100976
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-dc6d981e925a05efb5e1866ba81f7200.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6365545569"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/1c1e3936b45907f484bb6789a173787b.webp"
"MediaSize" => 134701
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-1c1e3936b45907f484bb6789a173787b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6365545571"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/17caf11327b87519381eeb8444e0ea0f.webp"
"MediaSize" => 121221
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-17caf11327b87519381eeb8444e0ea0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6365545573"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/7cd5abb9d98805eb3741183d112151ae.webp"
"MediaSize" => 134187
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-7cd5abb9d98805eb3741183d112151ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6365545575"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/7c885d6225522bd5c5d110202c8c54a0.webp"
"MediaSize" => 89049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-7c885d6225522bd5c5d110202c8c54a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6365545578"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/e4c745e796ff167464d8fe7651b5114a.webp"
"MediaSize" => 119573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-e4c745e796ff167464d8fe7651b5114a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6365545579"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/e03f08e45a512f9ef27372e5d9703642.webp"
"MediaSize" => 75962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-e03f08e45a512f9ef27372e5d9703642.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6365545581"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/dfa90bd358b4f21cbfb8583e578c7277.webp"
"MediaSize" => 87272
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-dfa90bd358b4f21cbfb8583e578c7277.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6365545584"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/7160cc2878a4c4947eb3e14e92704851.webp"
"MediaSize" => 73534
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-7160cc2878a4c4947eb3e14e92704851.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6365545586"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/cb8deeac87b99b8a86ec647bca202502.webp"
"MediaSize" => 117968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-cb8deeac87b99b8a86ec647bca202502.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6365545588"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/dd6f54be7645218c5d52fcce2d061dd2.webp"
"MediaSize" => 76815
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-dd6f54be7645218c5d52fcce2d061dd2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6365545590"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/43ec8cf9741dd82066315ebe81da7f7a.webp"
"MediaSize" => 93795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-43ec8cf9741dd82066315ebe81da7f7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6365545593"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/f27f339f58c0ad39fbb51fc1ade8fa31.webp"
"MediaSize" => 119573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-f27f339f58c0ad39fbb51fc1ade8fa31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6365545595"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/01465b71a3a135bc93c40aae72d14f70.webp"
"MediaSize" => 239760
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-01465b71a3a135bc93c40aae72d14f70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6365545598"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/79c606f9984f9d8919209cfa4b365e65.webp"
"MediaSize" => 173593
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-79c606f9984f9d8919209cfa4b365e65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6365545599"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182172/371b25353cbaa4557c2fce576c692925.webp"
"MediaSize" => 45925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182172/thumbnail-371b25353cbaa4557c2fce576c692925.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791630"
"ResourceRecordKey" => "29182172"
"ModificationTimestamp" => "2025-12-12T12:49:26.17Z"
]
]
+"Member": array:1 [
0 => array:25 [
"MemberFullName" => "Sharon Caesar"
"MemberFirstName" => "Sharon"
"MemberLastName" => "Caesar"
"MemberMlsId" => "KWkw4800"
"OriginatingSystemName" => 26
"MemberKey" => "2045949"
"ModificationTimestamp" => "2024-04-11T15:23:57Z"
"MemberStatus" => "Active"
"OfficeKey" => "283125"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberAOR" => "Waterloo Region"
"MemberFax" => "519-747-2081"
"MemberCity" => "Waterloo"
"MemberType" => "Salesperson"
"MemberAORKey" => "16"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:1 [ …1]
"MemberOfficePhone" => "519-747-2040"
"MemberSocialMedia" => array:2 [ …2]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2017-12-20T18:20:00Z"
"MemberNationalAssociationId" => "1321387"
"OfficeNationalAssociationId" => "1324759"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "Royal LePage Wolle Realty"
"OfficePhone" => "519-578-7300"
"OfficeMlsId" => "KW348"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "289541"
"ModificationTimestamp" => "2025-08-19T15:49:32Z"
"OfficeAddress1" => "71 Weber Street E., Unit B"
"OfficeCity" => "Kitchener"
"OfficePostalCode" => "N2H1C"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"OfficeFax" => "519-742-9904"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2021-02-10T20:35:00Z"
"OfficeNationalAssociationId" => "1378680"
"FranchiseNationalAssociationId" => "1146708"
"OfficeBrokerNationalAssociationId" => "1069818"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29182172')"
+"ID": "477718"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 289541/Office?$select=ALL&$top=10&$filter=OfficeKey eq 289541&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 289541/Office?$select=ALL&$top=10&$filter=OfficeKey eq 289541&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25475
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25477
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage Wolle Realty"
+"OfficeEmail": null
+"OfficePhone": "519-578-7300"
+"OfficeMlsId": "KW348"
+"ModificationTimestamp": "2025-08-19T15:49:32Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "289541"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "71 Weber Street E., Unit B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Kitchener"
+"OfficePostalCode": "N2H1C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1378680"
+"OriginalEntryTimestamp": "2021-02-10T20:35:00Z"
+"OfficeFax": "519-742-9904"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "10163"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "289541"
"SocialMediaUrlOrId" => "https://wollerealty.com/"
"ModificationTimestamp" => "2025-08-19T15:26:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1069818"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('289541')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2045949/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2045949&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2045949/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2045949&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25480
+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 29182172" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25095
+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 29182172/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29182172&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29182172/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29182172&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25075
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29182172 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5987556 43.4711694)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29182172 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5987556 43.4711694)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29182172 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5987556 43.4711694)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29182172 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5987556 43.4711694)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25005
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25030
+post_id: "484133"
+post_author: 1
+"ListingKey": "29188591"
+"ListingId": "40794086"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-16T03:35:23Z"
+"RFModificationTimestamp": "2025-12-16T04:38:01Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2330.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2T3"
+"UnparsedAddress": "421 WHITE BIRCH Avenue, Waterloo, Ontario N2V2T3"
+"Coordinates": array:2 [
0 => -80.5914559
1 => 43.4673633
]
+"Latitude": 43.4673633
+"Longitude": -80.5914559
+"YearBuilt": 2004
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Great Location in Laurelwood Neighbourhood! Situated at the end of a street, this unique home has abundant green space on both sides and the back and a park behind it! Open concept layout. Vaulted California ceilings, a maple kitchen with a ceramic backsplash and an island. Family room with a stone accent wall with sliders to an oversized deck and a private backyard. 3 Bedrooms, 3.5 Bathrooms, fully finished basement with a big-sized Rec. room. Large Master with ensuite on the second floor. All levels are finished. Minutes away from the elementary and high schools, a bus stop to the University of Waterloo directly, a public library, YMCA, Costco, Medical Centre, and Movie Theatre. Fast closing is possible! Easy to show (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-16T04:37:52.322349+00:00"
+"Directions": "WILD GINGER AVENUE / WHITE BIRCH AVENUE"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955745"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-16T03:28:47Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-16T03:28:47Z"
+"Stories": "2.0"
+"StreetName": "WHITE BIRCH"
+"StreetNumber": "421"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1549754336"
"RoomType" => "Full bathroom"
"ListingId" => "40794086"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29188591"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T03:28:47.21Z"
]
1 => array:11 [
"RoomKey" => "1549754337"
"RoomType" => "4pc Bathroom"
"ListingId" => "40794086"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29188591"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T03:28:47.21Z"
]
2 => array:11 [
"RoomKey" => "1549754338"
"RoomType" => "Primary Bedroom"
"ListingId" => "40794086"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29188591"
"RoomLength" => null
"RoomDimensions" => "16'0'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T03:28:47.22Z"
]
3 => array:11 [
"RoomKey" => "1549754339"
"RoomType" => "Bedroom"
"ListingId" => "40794086"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29188591"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T03:28:47.22Z"
]
4 => array:11 [
"RoomKey" => "1549754340"
"RoomType" => "Bedroom"
"ListingId" => "40794086"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29188591"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T03:28:47.22Z"
]
5 => array:11 [
"RoomKey" => "1549754341"
"RoomType" => "Family room"
"ListingId" => "40794086"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29188591"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 21'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T03:28:47.22Z"
]
6 => array:11 [
"RoomKey" => "1549754342"
"RoomType" => "Dining room"
"ListingId" => "40794086"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29188591"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T03:28:47.22Z"
]
7 => array:11 [
"RoomKey" => "1549754343"
"RoomType" => "Dining room"
"ListingId" => "40794086"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29188591"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T03:28:47.22Z"
]
8 => array:11 [
"RoomKey" => "1549754344"
"RoomType" => "Laundry room"
"ListingId" => "40794086"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29188591"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T03:28:47.22Z"
]
9 => array:11 [
"RoomKey" => "1549754345"
"RoomType" => "Kitchen"
"ListingId" => "40794086"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29188591"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T03:28:47.22Z"
]
10 => array:11 [
"RoomKey" => "1549754346"
"RoomType" => "2pc Bathroom"
"ListingId" => "40794086"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29188591"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T03:28:47.22Z"
]
11 => array:11 [
"RoomKey" => "1549754347"
"RoomType" => "Living room"
"ListingId" => "40794086"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29188591"
"RoomLength" => null
"RoomDimensions" => "19'9'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T03:28:47.22Z"
]
12 => array:11 [
"RoomKey" => "1549754348"
"RoomType" => "3pc Bathroom"
"ListingId" => "40794086"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29188591"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T03:28:47.23Z"
]
13 => array:11 [
"RoomKey" => "1549754349"
"RoomType" => "Utility room"
"ListingId" => "40794086"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29188591"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 7'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T03:28:47.23Z"
]
14 => array:11 [
"RoomKey" => "1549754350"
"RoomType" => "Recreation room"
"ListingId" => "40794086"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29188591"
"RoomLength" => null
"RoomDimensions" => "19'6'' x 19'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T03:28:47.23Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29188591/421-white-birch-avenue-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3200
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "FR50"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 31.0
+"AboveGradeFinishedArea": 1940
+"BelowGradeFinishedArea": 390
+"OriginalEntryTimestamp": "2025-12-16T03:28:47.16Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:35 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6371201528"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188591/7682db4137367236612bfac76a976dbf.webp"
"MediaSize" => 127769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188591/thumbnail-7682db4137367236612bfac76a976dbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front of property featuring a garage and brick siding"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40794086"
"ResourceRecordKey" => "29188591"
"ModificationTimestamp" => "2025-12-16T03:28:47.17Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6371201532"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188591/c8f754a018825e353ec8136e1c7a843e.webp"
"MediaSize" => 68436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188591/thumbnail-c8f754a018825e353ec8136e1c7a843e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Doorway to property featuring brick siding and covered porch"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794086"
"ResourceRecordKey" => "29188591"
"ModificationTimestamp" => "2025-12-16T03:28:47.17Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6371201535"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188591/6a32eb8eb27157648823f2686ecc43ce.webp"
"MediaSize" => 69763
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188591/thumbnail-6a32eb8eb27157648823f2686ecc43ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a whirlpool tub, vanity, and a stall shower"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794086"
"ResourceRecordKey" => "29188591"
"ModificationTimestamp" => "2025-12-16T03:28:47.17Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6371201539"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188591/f4708ad88749fb35dc271014e9da8d0b.webp"
"MediaSize" => 57473
…9
]
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]
]
+"Member": []
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29188591')"
+"ID": "484133"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24998
+post_id: "478969"
+post_author: 1
+"ListingKey": "29184586"
+"ListingId": "40793797"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-13T01:45:58Z"
+"RFModificationTimestamp": "2025-12-13T03:34:06Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 690.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A8"
+"UnparsedAddress": "776 LAURELWOOD Drive Unit# 307, Waterloo, Ontario N2V0A8"
+"Coordinates": array:2 [
0 => -80.5983268
1 => 43.4708684
]
+"Latitude": 43.4708684
+"Longitude": -80.5983268
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained 1 bedroom + den condo located in the highly sought-after Laurelwood neighbourhood! This bright and tasteful unit offers a functional layout with a spacious open-concept design, perfect for comfortable everyday living. The kitchen is beautiful and features, granite countertops, stainless steel appliances, and a large island—ideal for casual breakfasts or entertaining guests. The primary bedroom has a walk-in closet and the versatile den provides flexible space that can easily be used as a home office, guest room, or cozy reading nook. Enjoy all the conveniences of condo living in a vibrant community known for its top-rated schools, scenic trails, beautiful parks, the YMCA, public library, shopping, and a wide selection of restaurants—all just minutes from your door. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "326.87"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-13T03:33:46.247518+00:00"
+"Directions": "Erbsville to Laurelwood Drive"
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Brick"
2 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1915825"
+"ListOfficeKey": "290392"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"PhotosChangeTimestamp": "2025-12-13T01:38:20Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-13T01:38:20Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "776"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"VirtualTourURLUnbranded": "https://youriguide.com/776_laurelwood_dr_307_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29184586/776-laurelwood-drive-unit-307-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2100
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 690
+"OriginalEntryTimestamp": "2025-12-13T01:38:19.74Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29184586')"
+"ID": "478969"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24940
+post_id: "476555"
+post_author: 1
+"ListingKey": "29181658"
+"ListingId": "X12628714"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-15T13:31:02Z"
+"RFModificationTimestamp": "2025-12-15T13:33:29Z"
+"ListPrice": 995000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N8"
+"UnparsedAddress": "670 SALZBURG DRIVE, Waterloo, Ontario N2V2N8"
+"Coordinates": array:2 [
0 => -80.5864391
1 => 43.4620608
]
+"Latitude": 43.4620608
+"Longitude": -80.5864391
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "IF THIS IS YOUR TIME TO DOWNSIZE, THIS IS YOUR HOUSE. A Rare Opportunity Come and see this Home before its gone! If you've been searching for the perfect retirement bungalow, this is the one people remember for years - the one that "got away." A modern-built, freehold bungalow (yes, no condo fees) with a walkout basement and a million-dollar pond view in Waterloo's prestigious Rosewood/Clair Hills community. Homes like this almost never come to market, and with the neighbourhood fully built out, finding another one like it may soon be impossible. Designed for effortless, comfortable living, this 2+1 bedroom, 3-bath walkout bungalow offers nearly 2,000 sq. ft. of beautifully finished space. Freshly painted with brand-new carpet, it's fully move-in ready - the perfect option for anyone looking to simplify without compromising quality. The open-concept main floor features maple hardwood, ceramic tile, & seamless access to a raised deck with glass railings overlooking the tranquil Rosewood Pond - a protected view that can't be duplicated today. The primary suite faces the water & includes a private 4-piece en-suite, while the second bedroom with a built-in Murphy bed easily doubles as a guest room or home office. The bright walkout basement expands your living space with oversized windows, a cozy gas fireplace, & direct yard access for peaceful mornings by the water. A third bedroom with en-suite privileges and a generous storage area complete the lower level. Thoughtfully built with long-term comfort in mind, this home includes widened doorways, lowered switches, updated mechanicals, a double garage, and a quiet, low-traffic street - exactly what downsizers value most. This is the ideal combination: one-floor living, serene natural surroundings, no condo fees, minimal maintenance, & a view to die for. Opportunities like this simply do not come twice. Welcome to Rosewood Estates - a truly irreplaceable home. IT COULD BE YEARS BEFORE ANOTHER ONE COMES ALONG. (id:62650)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Water meter"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-12T00:43:51.399784+00:00"
+"Directions": "Cross Streets: Columbia St. W. ** Directions: Columbia to Salzburg Drive."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100955"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "45 x 118.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-11T23:54:34Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-15T13:26:05Z"
+"Stories": "1.0"
+"StreetName": "Salzburg"
+"StreetNumber": "670"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5446"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "http://youriguide.com/670_salzburg_drive_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": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29181658/670-salzburg-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2025-12-11T23:54:34.64Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29181658')"
+"ID": "476555"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24999
+post_id: "476346"
+post_author: 1
+"ListingKey": "29181381"
+"ListingId": "40793071"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-14T21:40:51Z"
+"RFModificationTimestamp": "2025-12-14T21:44:55Z"
+"ListPrice": 995000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.12
+"LivingArea": 1983.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N8"
+"UnparsedAddress": "670 SALZBURG Drive, Waterloo, Ontario N2V2N8"
+"Coordinates": array:2 [
0 => -80.5864356
1 => 43.4620435
]
+"Latitude": 43.4620435
+"Longitude": -80.5864356
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "IF THIS IS YOUR TIME TO DOWNSIZE, THIS IS YOUR HOUSE. A Rare Opportunity Come and see this Home before its gone! If you’ve been searching for the perfect retirement bungalow, this is the one people remember for years — the one that “got away.” A modern-built, freehold bungalow (yes, no condo fees) with a walkout basement and a million-dollar pond view in Waterloo’s prestigious Rosewood/Clair Hills community. Homes like this almost never come to market, and with the neighbourhood fully built out, finding another one like it may soon be impossible. Designed for effortless, comfortable living, this 2+1 bedroom, 3-bath walkout bungalow offers nearly 2,000 sq. ft. of beautifully finished space. Freshly painted with brand-new carpet, it’s fully move-in ready — the perfect option for anyone looking to simplify without compromising quality. The open-concept main floor features maple hardwood, ceramic tile, & seamless access to a raised deck with glass railings overlooking the tranquil Rosewood Pond — a protected view that can’t be duplicated today. The primary suite faces the water & includes a private 4-piece en-suite, while the second bedroom with a built-in Murphy bed easily doubles as a guest room or home office. The bright walkout basement expands your living space with oversized windows, a cozy gas fireplace, & direct yard access for peaceful mornings by the water. A third bedroom with en-suite privileges and a generous storage area complete the lower level. Thoughtfully built with long-term comfort in mind, this home includes widened doorways, lowered switches, updated mechanicals, a double garage, and a quiet, low-traffic street — exactly what downsizers value most. This is the ideal combination: one-floor living, serene natural surroundings, no condo fees, minimal maintenance, & a view to die for. Opportunities like this simply do not come twice. Welcome to Rosewood Estates — a truly irreplaceable home. IT COULD BE YEARS BEFORE ANOTHER ONE COMES ALONG. (id:62650)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-11T22:50:59.185685+00:00"
+"Directions": "Columbia to Salzburg Drive"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564479"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-11T22:29:37Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-14T21:29:59Z"
+"Stories": "1.0"
+"StreetName": "SALZBURG"
+"StreetNumber": "670"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5446"
+"VirtualTourURLUnbranded": "https://youriguide.com/670_salzburg_drive_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/29181381/670-salzburg-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1223
+"BelowGradeFinishedArea": 760
+"OriginalEntryTimestamp": "2025-12-11T22:29:37.47Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"Media": array:49 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29181381')"
+"ID": "476346"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24997
+post_id: "472539"
+post_author: 1
+"ListingKey": "29175977"
+"ListingId": "X12589714"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-10T00:50:19Z"
+"RFModificationTimestamp": "2025-12-10T01:37:18Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2T2"
+"UnparsedAddress": "687B WILD GINGER AVENUE, Waterloo, Ontario N2V2T2"
+"Coordinates": array:2 [
0 => -80.5911467
1 => 43.4680375
]
+"Latitude": 43.4680375
+"Longitude": -80.5911467
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautifully Maintained Semi-Detached Home in One of Waterloo's Most Sought-After Neighbourhoods. Welcome to a rare opportunity in the prestigious Laurelwood community-renowned for its top-ranking schools, safety, and exceptional quality of life. Just steps from Laurelwood High School and Abraham Erb Public School, this home delivers unmatched convenience for families. Why You'll Love This Home: Sun-Filled Living Room: Large windows flood the space with natural light, creating a warm and inviting atmosphere. Spacious Kitchen & Dining Area: Perfect for everyday living and hosting family meals. Thoughtfully Designed Upper Level: Features a cozy family room, three oversized bedrooms, Master Bed Room with Ensuite and a well-appointed second full bathroom.Unspoiled Basement: A clean, open space ready for storage or future customization.Prime Location: Enjoy the peace of a quiet, family-friendly street while being minutes from transit, parks, shopping, the YMCA, and all essential amenities.This home is the perfect blend of comfort, convenience, and value, an incredible opportunity to enjoy the best of Kitchener/Waterloo living. (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-10T01:37:07.531381+00:00"
+"Directions": "Cross Streets: Wild Ginger and Laurelwood. ** Directions: East."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1945012"
+"ListOfficeKey": "70066"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "27.2 x 101.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-10T00:45:04Z"
+"PhotosCount": 11
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-10T00:45:04Z"
+"Stories": "2.0"
+"StreetName": "Wild Ginger"
+"StreetNumber": "687B"
+"StreetSuffix": "Avenue"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29175977/687b-wild-ginger-avenue-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2600
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 27.2
+"OriginalEntryTimestamp": "2025-12-10T00:45:04.74Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:11 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29175977')"
+"ID": "472539"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24942
+post_id: "470888"
+post_author: 1
+"ListingKey": "29173553"
+"ListingId": "40791996"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-13T21:41:06Z"
+"RFModificationTimestamp": "2025-12-13T21:44:00Z"
+"ListPrice": 898000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2408.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0E3"
+"UnparsedAddress": "592 MAYAPPLE Street, Waterloo, Ontario N2V0E3"
+"Coordinates": array:2 [
0 => -80.6003
1 => 43.4586
]
+"Latitude": 43.4586
+"Longitude": -80.6003
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 592 Mayapple Street, Waterloo—an exceptional luxury townhouse nestled in the highly sought-after Vista Hills community. This beautiful walk-out basement home offers 3 spacious bedrooms, 2.5 bathrooms, a second floor family room and a double-car garage. The main floor features an inviting open-concept layout with 9-foot ceilings, a modern kitchen with a granite island, a bright dinette, and a warm, welcoming great room—perfect for everyday living and entertaining. A convenient main-floor laundry room adds to the ease of daily routines. Upstairs, you’ll find three generously sized bedrooms along with a family room, ideal as a home office, media room, or play area. The luxurious primary suite includes a walk-in closet and a spa-like ensuite bathroom complete with double vanities, a soaker tub, a glass shower, and a private toilet area. The walk-out basement provides endless potential for future finishing—whether you envision a recreation room, in-law suite, or hobby space. Ideally situated just steps from scenic trails and green spaces, this home is close to top-rated schools including Vista Hills PS, St. Nicholas Catholic School, and Laurel Heights S.S. You’ll also enjoy quick access to The Boardwalk, Costco, restaurants, parks, and public transit. This is luxury, comfort, and convenience all in one. Don’t miss this incredible opportunity! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-09T17:07:12.143777+00:00"
+"Directions": "Columbia Street W/Sundew Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2050676"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-09T15:00:11Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-13T21:30:05Z"
+"Stories": "2.0"
+"StreetName": "MAYAPPLE"
+"StreetNumber": "592"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "6836"
+"VirtualTourURLUnbranded": "https://youriguide.com/93e16_592_mayapple_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29173553/592-mayapple-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R6-FT"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 27.0
+"AboveGradeFinishedArea": 2408
+"OriginalEntryTimestamp": "2025-12-09T15:00:11Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:48 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29173553')"
+"ID": "470888"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23649
+post_id: "468798"
+post_author: 1
+"ListingKey": "29171100"
+"ListingId": "40792839"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-14T21:40:50Z"
+"RFModificationTimestamp": "2025-12-14T21:44:56Z"
+"ListPrice": 999900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2768.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N6"
+"UnparsedAddress": "368 CAVENDISH Drive, Waterloo, Ontario N2T2N6"
+"Coordinates": array:2 [
0 => -80.5770067
1 => 43.4642492
]
+"Latitude": 43.4642492
+"Longitude": -80.5770067
+"YearBuilt": 1996
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "**Located in Prestigious LAURELWOOD! This beautiful, renovated home offers over 2,750 sq. ft. of above grade finished area! **WALKOUT BASEMENT and massive rear and side yard (0.222-acre lot) surrounded by mature trees. **The main floor has an updated kitchen, subway tile backsplash, quartz countertops, plenty of cupboard space, large island and Kitchen Aid appliances are included. **Living room features custom built-ins, hardwood floors and 24 LED pot lights on the main level. **Main floor laundry and mudroom with access to the double garage. **Second level Primary bedroom with recessed ceilings, updated Ensuite with double sink, freestanding tub, and walk-in closet. **Updated main bathroom with soaker tub along with 2 additional generous size bedrooms, and skylight in the hallway. **Finished walkout basement with recreation room, 4th bedroom, 3-piece bathroom, tons of windows and sliding door to the rear yard! **Other features include roof replaced with 40-year shingles (2025), Concrete driveway (2020), Garage door (2019), 2-tier deck off the Kitchen, Shed with concrete pad (2020), Freshly painted (2025), upstairs carpets (2025) and fenced yard. **Located in the family-friendly Laurelwood neighbourhood surrounded by highly rated schools, parks including the Laurel Creek Conservation Area, and many biking/walking trails. Walking distance to Trillium Valley Park and Chancery Lane Trail. Just minutes away from the University of Waterloo Campus. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-08T17:50:11.594469+00:00"
+"Directions": "Columbia St. to Cavendish Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563803"
+"ListOfficeKey": "76775"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-08T17:28:59Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-14T21:30:06Z"
+"Stories": "2.0"
+"StreetName": "CAVENDISH"
+"StreetNumber": "368"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "6096"
+"VirtualTourURLUnbranded": "https://youriguide.com/5mptk_368_cavendish_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29171100/368-cavendish-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 112.0
+"AboveGradeFinishedArea": 1880
+"BelowGradeFinishedArea": 887
+"OriginalEntryTimestamp": "2025-12-08T17:28:58.89Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:49 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29171100')"
+"ID": "468798"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25018
+post_id: "466453"
+post_author: 1
+"ListingKey": "29167696"
+"ListingId": "X12606140"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-09T18:35:56Z"
+"RFModificationTimestamp": "2025-12-09T18:38:36Z"
+"ListPrice": 650000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2W2"
+"UnparsedAddress": "44 - 360 ERBSVILLE ROAD, Waterloo, Ontario N2T2W2"
+"Coordinates": array:2 [
0 => -80.579155
1 => 43.461338
]
+"Latitude": 43.461338
+"Longitude": -80.579155
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Don't miss your chance to join the sought-after 360 Erbsville community! This Executive-style bungalow condo is vacant and move-in ready before the holidays. Enjoy upgraded flooring, a custom kitchen, and an open living area with walkout to a private deck. With interior access to the garage and all exterior maintenance handled - lawn care, snow removal, roofing, and more - you can truly relax and enjoy a carefree lifestyle. The finished lower level offers a large rec room, home office (or 3rd bedroom), and full bath. Prime Waterloo location close to parks, shopping, and transit - an opportunity not to be missed! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "717.44"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-06T01:29:39.384325+00:00"
+"Directions": "Erbsville Rd. & Columbia St"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1903978"
+"ListOfficeKey": "275965"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-09T18:17:35Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-09T18:17:35Z"
+"Stories": "1.0"
+"StreetName": "Erbsville"
+"StreetNumber": "360"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4644"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29167696/44-360-erbsville-road-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2025-12-05T22:22:15.04Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:35 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29167696')"
+"ID": "466453"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25013
+post_id: "463595"
+post_author: 1
+"ListingKey": "29163814"
+"ListingId": "X12602228"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-04T21:00:53Z"
+"RFModificationTimestamp": "2025-12-04T23:15:31Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N8"
+"UnparsedAddress": "678 SALZBURG DRIVE, Waterloo, Ontario N2V2N8"
+"Coordinates": array:2 [
0 => -80.5870488
1 => 43.461835
]
+"Latitude": 43.461835
+"Longitude": -80.5870488
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Luxury Walkout Bungalow with Million-Dollar View in Prestigious Rosewood Community, Clair Hills. Experience refined living in this elegant all-brick bungalow, offering a seamless blend of space, style, and natural surroundings in one of Waterloo's most sought-after neighbourhoods. This exceptional all-brick 2+2 bedroom, 3 full bath walkout bungalow offers impeccably finished living space with stunning, unobstructed views of the ravine and pond. Set in one of Waterloo's most desirable neighbourhoods, this home is a rare blend of elegance, comfort, and natural beauty-an ideal retreat right in the city. Designed for comfort and style, the main level welcomes you with rich hardwood flooring, elegant coffered ceilings, and an abundance of natural light. It features two bedrooms, a bright kitchen seamlessly flowing into the living and dining areas, and convenient main floor laundry. A standout feature is the sun-drenched tropical-style sunroom, complete with vaulted ceilings, skylights, and an electric fireplace-perfect for any season. Step through the sliding glass doors onto the upper deck to enjoy breakfast with the sounds of nature or unwind under the stars. The walkout basement extends the living space with two generously sized bedrooms and an open-concept Great room featuring a gas fireplace, alongside dedicated areas for reading and fitness. Sliding doors open to a covered lower deck offering tranquil views of the pond and surrounding mature trees-an ideal space to relax or entertain. Close to the University of Waterloo, top-rated schools, shopping centers, walking trails, medical facilities, places of worship, and movie theaters, this home perfectly balances comfort, privacy, and convenience. Featuring double decks and a stunning natural setting, this rare gem won't last long. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-04T23:15:10.205772+00:00"
+"Directions": "Columbia & Erbsville"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1889673"
+"ListOfficeKey": "269129"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Ravine"
1 => "Conservation/green belt"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"LotSizeDimensions": "45.1 x 118.3 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-04T20:52:16Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-04T20:52:16Z"
+"Stories": "1.0"
+"StreetName": "Salzburg"
+"StreetNumber": "678"
+"StreetSuffix": "Drive"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://view.tours4listings.com/cp/678-salzburg-drive-waterloo/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29163814/678-salzburg-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3500
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 45.1
+"OriginalEntryTimestamp": "2025-12-04T20:52:15.79Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29163814')"
+"ID": "463595"
}
]
+success: true
+page_size: 9
+page_count: 11
+count: 96
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]