array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29984752 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
+post_id: "1588969"
+post_author: 1
+"ListingKey": "29984752"
+"ListingId": "X13518362"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T16:10:07Z"
+"RFModificationTimestamp": "2026-07-03T16:16:45Z"
+"ListPrice": 398000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6E4"
+"UnparsedAddress": "502 - 265 WESTCOURT PLACE, Waterloo, Ontario N2L6E4"
+"Coordinates": array:2 [
0 => -80.540493
1 => 43.460629
]
+"Latitude": 43.460629
+"Longitude": -80.540493
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to The Beechmount at 265 Westcourt Place! This designer dressed updated one-bedroom condo truly will not disappoint. Offering exceptional space, premium finishes, and a highly functional layout, this bright and inviting home is a fantastic opportunity! From the moment you step inside, you will notice the gorgeous hardwood flooring that flows seamlessly throughout the entire unit. This spacious layout is the pinnacle of comfort living. Expansive windows frame a beautiful North East view, filling the home with fantastic morning light and peaceful scenery. The true centrepiece of this condo is the elegant custom-designed kitchen. Beautifully modernized, it is fully outfitted with Bosch stainless steel appliances, sleek cabinetry, and ample counter space. With pristine, neutral decor, this stunning unit is completely move-in ready. Additional features include convenient in-suite laundry and excellent storage options. Includes Parking &Locker along with great amenities for the residents. Enjoy worry-free condo living in a highly sought-after, well-maintained building that is ideally located just minutes away from shopping, parks, transit, and all the incredible amenities Waterloo has to offer. Welcome to your beautiful new home! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Intercom"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
]
+"AssociationFee": "865"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T16:16:38.918986+00:00"
+"Directions": "Westmount"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Hardwood"
]
+"Heating": array:4 [
0 => "Baseboard heaters"
1 => "Forced air"
2 => "Electric"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2074772"
+"ListOfficeKey": "285351"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-03T15:40:21Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T16:05:08Z"
+"StreetName": "Westcourt"
+"StreetNumber": "265"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "3423.1"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1674197703"
"RoomType" => "Living room"
"ListingId" => "X13518362"
"RoomLevel" => "Main level"
"RoomWidth" => 3.5
"ListingKey" => "29984752"
"RoomLength" => 5.48
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T16:05:08.72Z"
]
1 => array:11 [
"RoomKey" => "1674197704"
"RoomType" => "Kitchen"
"ListingId" => "X13518362"
"RoomLevel" => "Main level"
"RoomWidth" => 3.05
"ListingKey" => "29984752"
"RoomLength" => 9.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T16:05:08.72Z"
]
2 => array:11 [
"RoomKey" => "1674197705"
"RoomType" => "Dining room"
"ListingId" => "X13518362"
"RoomLevel" => "Main level"
"RoomWidth" => 3.05
"ListingKey" => "29984752"
"RoomLength" => 9.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T16:05:08.72Z"
]
3 => array:11 [
"RoomKey" => "1674197706"
"RoomType" => "Eating area"
"ListingId" => "X13518362"
"RoomLevel" => "Main level"
"RoomWidth" => 3.05
"ListingKey" => "29984752"
"RoomLength" => 9.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T16:05:08.72Z"
]
4 => array:11 [
"RoomKey" => "1674197707"
"RoomType" => "Bedroom"
"ListingId" => "X13518362"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29984752"
"RoomLength" => 5.15
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T16:05:08.72Z"
]
5 => array:11 [
"RoomKey" => "1674197708"
"RoomType" => "Sunroom"
"ListingId" => "X13518362"
"RoomLevel" => "Main level"
"RoomWidth" => 2.59
"ListingKey" => "29984752"
"RoomLength" => 5.64
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T16:05:08.72Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29984752/502-265-westcourt-place-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Canlight Property Mgmt"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Storage - Locker"
1 => "Separate Heating Controls"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-07-03T15:40:21.05Z"
+"ListAgentNationalAssociationId": "1349976"
+"ListOfficeNationalAssociationId": "1350793"
+"Media": array:33 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29984752_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/64ad33891896819641fef8a08296fc59.webp"
"MediaSize" => 342669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-64ad33891896819641fef8a08296fc59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29984752_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/896bad8c4defb3abaf62f894c6f30c9e.webp"
"MediaSize" => 491194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-896bad8c4defb3abaf62f894c6f30c9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29984752_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/4cda9b82366f89ff1fcd9ba36d894ce4.webp"
"MediaSize" => 369394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-4cda9b82366f89ff1fcd9ba36d894ce4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29984752_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/d9ab855d02c06baa1b0c6ef6cbc8480c.webp"
"MediaSize" => 133457
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-d9ab855d02c06baa1b0c6ef6cbc8480c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29984752_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/4243e7dc1f9cc0e6884c88835b82cd5b.webp"
"MediaSize" => 87668
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-4243e7dc1f9cc0e6884c88835b82cd5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29984752_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/6d69b43a029270b05c479912e1fc0eda.webp"
"MediaSize" => 143415
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-6d69b43a029270b05c479912e1fc0eda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29984752_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/df654bf7403f16408864032b42287b81.webp"
"MediaSize" => 125541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-df654bf7403f16408864032b42287b81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29984752_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/0b1a87c2a8598022503fb3bc208eaa35.webp"
"MediaSize" => 128894
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-0b1a87c2a8598022503fb3bc208eaa35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29984752_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/7853103c0eebc6bddfbcbb9d411d5b22.webp"
"MediaSize" => 120959
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-7853103c0eebc6bddfbcbb9d411d5b22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29984752_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/8a6bf8660672d21e3c7fe66c6c96e902.webp"
"MediaSize" => 126310
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-8a6bf8660672d21e3c7fe66c6c96e902.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29984752_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/367c005742c56e8ee431f3f39a647ec1.webp"
"MediaSize" => 105835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-367c005742c56e8ee431f3f39a647ec1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29984752_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/9b7ff7cfc73f46f5f360c6425401d026.webp"
"MediaSize" => 104960
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-9b7ff7cfc73f46f5f360c6425401d026.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29984752_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/3babd117e757e44a3657729ea372b0a9.webp"
"MediaSize" => 97181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-3babd117e757e44a3657729ea372b0a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29984752_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/3a69a7a337d46312187103677ad0de4c.webp"
"MediaSize" => 103829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-3a69a7a337d46312187103677ad0de4c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29984752_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/100a758e30eaff584fdc0b2dc0d8bd7a.webp"
"MediaSize" => 106863
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-100a758e30eaff584fdc0b2dc0d8bd7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29984752_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/5f63aa89b1f414f685ec17d001eea84b.webp"
"MediaSize" => 142711
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-5f63aa89b1f414f685ec17d001eea84b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29984752_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/40a5f9fe8bec97685ab71b1211cee194.webp"
"MediaSize" => 154336
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-40a5f9fe8bec97685ab71b1211cee194.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29984752_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/e95870981c7186aa6890fa69c401e091.webp"
"MediaSize" => 201741
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-e95870981c7186aa6890fa69c401e091.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29984752_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/ad138506ae297aa72e78998d5b9d6b42.webp"
"MediaSize" => 209818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-ad138506ae297aa72e78998d5b9d6b42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29984752_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/b9e506df1edd719868cf4dccaa3bd6b9.webp"
"MediaSize" => 88473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-b9e506df1edd719868cf4dccaa3bd6b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29984752_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/d130677b778d79da1ded9fcd6262257e.webp"
"MediaSize" => 128234
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-d130677b778d79da1ded9fcd6262257e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29984752_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/f37db03e9016059284377f2b3bdcdd63.webp"
"MediaSize" => 133953
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-f37db03e9016059284377f2b3bdcdd63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29984752_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/7bcfb20a7fd05a3bf1f9240b92a462bb.webp"
"MediaSize" => 181727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-7bcfb20a7fd05a3bf1f9240b92a462bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29984752_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/27acd6b898737f5931d97d310b37fdb8.webp"
"MediaSize" => 106564
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-27acd6b898737f5931d97d310b37fdb8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29984752_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/6c5826e595f5aff7ecdbe40ec148baf9.webp"
"MediaSize" => 120218
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-6c5826e595f5aff7ecdbe40ec148baf9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29984752_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/64a3a5541afc856d66373b888b5bcc21.webp"
"MediaSize" => 80059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-64a3a5541afc856d66373b888b5bcc21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29984752_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/27092e970c18ce09e2483cbde883e0bc.webp"
"MediaSize" => 225387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-27092e970c18ce09e2483cbde883e0bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29984752_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/e7225fc03868cf897937737f547f132e.webp"
"MediaSize" => 210713
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-e7225fc03868cf897937737f547f132e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29984752_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/212c90320f65b1d1796674f6a8d53b9a.webp"
"MediaSize" => 274881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-212c90320f65b1d1796674f6a8d53b9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29984752_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/67c30352251c0a92ff3da7aa8e242687.webp"
"MediaSize" => 217697
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-67c30352251c0a92ff3da7aa8e242687.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29984752_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/468cbd5c157d34ca9b98e31de5cf6fc6.webp"
"MediaSize" => 339946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-468cbd5c157d34ca9b98e31de5cf6fc6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29984752_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/8f05ac7d8b6fb5356d6bee065b45d5f1.webp"
"MediaSize" => 344209
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-8f05ac7d8b6fb5356d6bee065b45d5f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29984752_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984752/a7ff963e742780a456603e227e590f8e.webp"
"MediaSize" => 101047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984752/thumbnail-a7ff963e742780a456603e227e590f8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13518362"
"ResourceRecordKey" => "29984752"
"ModificationTimestamp" => "2026-07-03T15:40:21.06Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29984752')"
+"ID": "1588969"
}
]
+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=OfficeMlsId eq 285351" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24887
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2074772" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24845
+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 '29984752'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25235
+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 '29984752'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25355
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29984752' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.540493 43.460629)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25269
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25263
+post_id: "1591176"
+post_author: 1
+"ListingKey": "29987087"
+"ListingId": "40844492"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T00:35:18Z"
+"RFModificationTimestamp": "2026-07-04T00:37:21Z"
+"ListPrice": 390000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 982.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N8"
+"UnparsedAddress": "459 BEECHWOOD Place Unit# 21, Waterloo, Ontario N2T2N8"
+"Coordinates": array:2 [
0 => -80.5590418
1 => 43.4510561
]
+"Latitude": 43.4510561
+"Longitude": -80.5590418
+"YearBuilt": 1993
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beechwood has long been one of Waterloo's most sought-after neighbourhoods, loved for its mature tree-lined streets, established community, and unbeatable everyday convenience. Nestled within a quiet condo complex, this home feels welcoming and peaceful, located just minutes from shopping, restaurants, parks, trails, transit, and both globally renowned universities. Inside, you will find an inviting, functional layout designed for comfortable living. The main floor features the kitchen, dining, and living areas. Upstairs, the two bedrooms are complemented by a full bathroom, while the primary bedroom enjoys the added luxury of its own private two-piece ensuite. The finished basement extends your living space even further, complete with a third bathroom and endless flexibility for a family room, home office, workout area, or guest retreat. Interior access to the attached garage, along with a second driveway parking space, adds convenience to your daily routine. In 2025, the furnace was upgraded to include a humidifier, and a new laundry machine set was added around 2023. The condominium corporation handles exterior maintenance, landscaping, and snow removal, allowing you to spend less time on upkeep and more time enjoying everything this exceptional neighbourhood has to offer. Whether you are searching for your first home or a smart investment in one of Waterloo's most consistently desirable communities, this is an opportunity you will not want to miss. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener"
6 => "Microwave Built-in"
]
+"AssociationFee": "464.42"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Other, See Remarks"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Partial"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T23:23:32.715919+00:00"
+"Directions": "Erb st to Beechwood pl"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2249661"
+"ListOfficeKey": "300896"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Balcony"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-03T20:18:20Z"
+"PhotosCount": 25
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T00:29:13Z"
+"Stories": "2.0"
+"StreetName": "BEECHWOOD"
+"StreetNumber": "459"
+"StreetSuffix": "Place"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "2512.57"
+"Utilities": array:1 [
0 => "Natural Gas"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/459_beechwood_pl_unit_21_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1674570343"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844492"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29987087"
"RoomLength" => null
"RoomDimensions" => "6'11'' x 5'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T00:29:13.26Z"
]
1 => array:11 [
"RoomKey" => "1674570344"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844492"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29987087"
"RoomLength" => null
"RoomDimensions" => "4'3'' x 4'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T00:29:13.26Z"
]
2 => array:11 [
"RoomKey" => "1674570345"
"RoomType" => "Recreation room"
"ListingId" => "40844492"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29987087"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T00:29:13.27Z"
]
3 => array:11 [
"RoomKey" => "1674570346"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844492"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29987087"
"RoomLength" => null
"RoomDimensions" => "6'3'' x 3'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T00:29:13.27Z"
]
4 => array:11 [
"RoomKey" => "1674570347"
"RoomType" => "Bedroom"
"ListingId" => "40844492"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29987087"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T00:29:13.27Z"
]
5 => array:11 [
"RoomKey" => "1674570348"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844492"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29987087"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T00:29:13.27Z"
]
6 => array:11 [
"RoomKey" => "1674570349"
"RoomType" => "Living room"
"ListingId" => "40844492"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987087"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T00:29:13.27Z"
]
7 => array:11 [
"RoomKey" => "1674570350"
"RoomType" => "Dining room"
"ListingId" => "40844492"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987087"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T00:29:13.27Z"
]
8 => array:11 [
"RoomKey" => "1674570351"
"RoomType" => "Kitchen"
"ListingId" => "40844492"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987087"
"RoomLength" => null
"RoomDimensions" => "7'9'' x 8'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T00:29:13.27Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29987087/459-beechwood-place-unit-21-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "CPPS-MUR1-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 838
+"BelowGradeFinishedArea": 144
+"OriginalEntryTimestamp": "2026-07-03T20:18:20.66Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1488485"
+"ListOfficeNationalAssociationId": "1494469"
+"Media": array:25 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29987087_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/4fa3b4ba9d48348e9abdb009a870a628.webp"
"MediaSize" => 126259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-4fa3b4ba9d48348e9abdb009a870a628.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29987087_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/cc7623e5ccce068aec4825d63d06f6cb.webp"
"MediaSize" => 133446
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-cc7623e5ccce068aec4825d63d06f6cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29987087_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/3464bc50a617e94faa4264743f389c12.webp"
"MediaSize" => 64694
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-3464bc50a617e94faa4264743f389c12.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29987087_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/94d73920fde920099c0562deda9e776e.webp"
"MediaSize" => 84686
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-94d73920fde920099c0562deda9e776e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29987087_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/7619cfbc851e9741d2dec40e65f15fd1.webp"
"MediaSize" => 78947
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-7619cfbc851e9741d2dec40e65f15fd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29987087_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/12996dfe983f469b7d3dbea583060b13.webp"
"MediaSize" => 86379
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-12996dfe983f469b7d3dbea583060b13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29987087_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/d43abaaa6c775849d358cfb9afcad2ed.webp"
"MediaSize" => 81741
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-d43abaaa6c775849d358cfb9afcad2ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29987087_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/3acbac2b64c4da75cd747147d0953966.webp"
"MediaSize" => 61379
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-3acbac2b64c4da75cd747147d0953966.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29987087_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/4932999f007e4baab3fbe6b51a8801c2.webp"
"MediaSize" => 74307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-4932999f007e4baab3fbe6b51a8801c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29987087_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/a1bd691b7f9ef5c9bc7152ba4c70f946.webp"
"MediaSize" => 59341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-a1bd691b7f9ef5c9bc7152ba4c70f946.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29987087_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/d26e203b32ad37cfe1db37e123a847fb.webp"
"MediaSize" => 83724
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-d26e203b32ad37cfe1db37e123a847fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29987087_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/c1d10e998dd7b119e80dc156971a5846.webp"
"MediaSize" => 36993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-c1d10e998dd7b119e80dc156971a5846.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29987087_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/1cb9fa798a661477388dfb6b9f546fc4.webp"
"MediaSize" => 77459
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-1cb9fa798a661477388dfb6b9f546fc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29987087_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/9fe8d0992e20c7e8161db5a24a5d95ec.webp"
"MediaSize" => 70494
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-9fe8d0992e20c7e8161db5a24a5d95ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29987087_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/72c2291114a1e23a4add266a46b02b94.webp"
"MediaSize" => 56571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-72c2291114a1e23a4add266a46b02b94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29987087_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/4d63799f227b3ac64a2aa907b95602da.webp"
"MediaSize" => 116670
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-4d63799f227b3ac64a2aa907b95602da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29987087_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/25230237d4e53bb2e224cddd28971d39.webp"
"MediaSize" => 80136
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-25230237d4e53bb2e224cddd28971d39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29987087_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/9bc79ef513358c40b2ddac1ec228a527.webp"
"MediaSize" => 32952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-9bc79ef513358c40b2ddac1ec228a527.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29987087_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/e103b36b6daf6696052de97295c00e59.webp"
"MediaSize" => 142629
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-e103b36b6daf6696052de97295c00e59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29987087_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/f34a3f96a85656be6db3e5382949bf11.webp"
"MediaSize" => 172898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-f34a3f96a85656be6db3e5382949bf11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29987087_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/7fa64b064de7d237b011f44741444c5e.webp"
"MediaSize" => 180138
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-7fa64b064de7d237b011f44741444c5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29987087_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/2349727391134dcde9a8764d49232224.webp"
"MediaSize" => 178980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-2349727391134dcde9a8764d49232224.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29987087_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/4094f3a9d6de302305d36f2fab04d344.webp"
"MediaSize" => 44681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-4094f3a9d6de302305d36f2fab04d344.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29987087_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/e596b92dd4e0e42a53f02b45cb74d192.webp"
"MediaSize" => 41671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-e596b92dd4e0e42a53f02b45cb74d192.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29987087_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/b53d94f299e729e21c8a0b432f422653.webp"
"MediaSize" => 38403
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-b53d94f299e729e21c8a0b432f422653.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29987087')"
+"ID": "1591176"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25265
+post_id: "1590956"
+post_author: 1
+"ListingKey": "29987378"
+"ListingId": "X13520800"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T21:05:17Z"
+"RFModificationTimestamp": "2026-07-03T21:33:35Z"
+"ListPrice": 390000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N8"
+"UnparsedAddress": "21 - 459 BEECHWOOD PLACE, Waterloo, Ontario N2T2N8"
+"Coordinates": array:2 [
0 => -80.557278
1 => 43.451718
]
+"Latitude": 43.451718
+"Longitude": -80.557278
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Beechwood has long been one of Waterloo's most sought-after neighbourhoods, loved for its mature tree-lined streets, established community, and unbeatable everyday convenience. Nestled within a quiet condo complex, this home feels welcoming and peaceful, located just minutes from shopping, restaurants, parks, trails, transit, and both globally renowned universities. Inside, you will find an inviting, functional layout designed for comfortable living. The main floor features the kitchen, dining, and living areas. Upstairs, the two bedrooms are complemented by a full bathroom, while the primary bedroom enjoys the added luxury of its own private two-piece ensuite. The finished basement extends your living space even further, complete with a third bathroom and endless flexibility for a family room, home office, workout area, or guest retreat. Interior access to the attached garage, along with a second driveway parking space, adds convenience to your daily routine. In 2025, the furnace was upgraded to include a humidifier, and a new laundry machine set was added around 2023. The condominium corporation handles exterior maintenance, landscaping, and snow removal, allowing you to spend less time on upkeep and more time enjoying everything this exceptional neighbourhood has to offer. Whether you are searching for your first home or a smart investment in one of Waterloo's most consistently desirable communities, this is an opportunity you will not want to miss. (id:66098)"
+"Appliances": array:10 [
0 => "Refrigerator"
1 => "Water purifier"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Blinds"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"AssociationFee": "464.42"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Water"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Partial"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T21:19:17.843583+00:00"
+"Directions": "Cross Streets: Erb St to Beechwood Pl. ** Directions: Erb S."
+"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": "2253532"
+"ListOfficeKey": "300496"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Balcony"
2 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T20:59:56Z"
+"PhotosCount": 25
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T20:59:56Z"
+"Stories": "2.0"
+"StreetName": "Beechwood"
+"StreetNumber": "459"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "2521"
+"VirtualTourURLUnbranded": "https://youriguide.com/459_beechwood_pl_unit_21_waterloo_on/"
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1674416557"
"RoomType" => "Kitchen"
"ListingId" => "X13520800"
"RoomLevel" => "Main level"
"RoomWidth" => 2.36
"ListingKey" => "29987378"
"RoomLength" => 2.54
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T20:59:56.03Z"
]
1 => array:11 [
"RoomKey" => "1674416558"
"RoomType" => "Living room"
"ListingId" => "X13520800"
"RoomLevel" => "Main level"
"RoomWidth" => 3.44
"ListingKey" => "29987378"
"RoomLength" => 3.32
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T20:59:56.03Z"
]
2 => array:11 [
"RoomKey" => "1674416559"
"RoomType" => "Dining room"
"ListingId" => "X13520800"
"RoomLevel" => "Main level"
"RoomWidth" => 3.47
"ListingKey" => "29987378"
"RoomLength" => 3.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T20:59:56.04Z"
]
3 => array:11 [
"RoomKey" => "1674416560"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13520800"
"RoomLevel" => "Second level"
"RoomWidth" => 3.03
"ListingKey" => "29987378"
"RoomLength" => 3.19
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T20:59:56.04Z"
]
4 => array:11 [
"RoomKey" => "1674416561"
"RoomType" => "Bathroom"
"ListingId" => "X13520800"
"RoomLevel" => "Second level"
"RoomWidth" => 1.52
"ListingKey" => "29987378"
"RoomLength" => 2.12
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T20:59:56.04Z"
]
5 => array:11 [
"RoomKey" => "1674416562"
"RoomType" => "Bathroom"
"ListingId" => "X13520800"
…8
]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "OnePoint"
+"TaxYear": 2025
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29987378/21-459-beechwood-place-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-03T20:59:56Z"
+"ListAgentNationalAssociationId": "1492517"
+"ListOfficeNationalAssociationId": "1489080"
+"Media": array:25 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29987378')"
+"ID": "1590956"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25262
+post_id: "1590419"
+post_author: 1
+"ListingKey": "29985514"
+"ListingId": "X13519104"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T17:40:02Z"
+"RFModificationTimestamp": "2026-07-03T19:34:06Z"
+"ListPrice": 299900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0G2"
+"UnparsedAddress": "514 - 280 LESTER STREET, Waterloo, Ontario N2L0G2"
+"Coordinates": array:2 [
0 => -80.535645
1 => 43.475677
]
+"Latitude": 43.475677
+"Longitude": -80.535645
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rare-Find! Spacious 549 Sqft Furnished 1 Bedroom Unit in Sage 5 With Unobstructed Views.***1 Underground Parking Included*** Southwest Exposure Brings Abundant Natural Light! Features An Oversized 2.9M x 4.8M Bedroom With Floor-To-Ceiling Window, Closet, And Walkout To Balcony Overlooking The Community Green Park. The Open-Concept Living And Dining Area Also Walks Out To The Balcony. Modern Kitchen Equipped With Stainless Steel Appliances, Granite Centre Island With Seating For Three, And Plenty Of Cabinet Space. Ensuite Laundry Included. Condo Fees Cover Heating, Cooling, Water, And Internet. Sage 5 offers an impressive range of amenities for its residents, including a fully equipped fitness center, an on-site movie theater and auditorium, a two-level study lounge, and a spacious outdoor terrace ideal for unwinding or connecting with others. Perfectly positioned just steps from the University of Waterloo, Wilfrid Laurier University, and Conestoga College, with easy access to the Waterloo LRT station and the vibrant shops, restaurants, and entertainment of Uptown Waterloo. This is an outstanding opportunity for students, investors, or first-time buyers! (id:62650)"
+"AssociationFee": "414.5"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T19:19:04.500589+00:00"
+"Directions": "Cross Streets: University & King Street North. ** Directions: columbia to Lester."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Ceramic"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1885687"
+"ListOfficeKey": "103644"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-03T17:06:19Z"
+"PhotosCount": 15
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T17:06:19Z"
+"StreetName": "Lester"
+"StreetNumber": "280"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3236.29"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29985514/514-280-lester-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "WILSON BLANCHARD"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Exercise Centre"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-07-03T17:06:19.69Z"
+"ListAgentNationalAssociationId": "1208862"
+"ListOfficeNationalAssociationId": "1162020"
+"Media": array:15 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29985514')"
+"ID": "1590419"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25266
+post_id: "1589820"
+post_author: 1
+"ListingKey": "29983725"
+"ListingId": "X13517266"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T13:10:02Z"
+"RFModificationTimestamp": "2026-07-03T18:10:00Z"
+"ListPrice": 689000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1A7"
+"UnparsedAddress": "92 PINEMEADOW CRESCENT, Waterloo, Ontario N2T1A7"
+"Coordinates": array:2 [
0 => -80.553692
1 => 43.449029
]
+"Latitude": 43.449029
+"Longitude": -80.553692
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "The bright and inviting main level features spacious principal rooms, premium laminate flooring, fresh professional paint, updated interior doors and railings, and beautifully renovated bathrooms. At the heart of the home is the modern kitchen, showcasing refreshed cabinetry, sleek countertops, and stainless steel appliances-an ideal space for both everyday living and entertaining. The fully finished lower level adds exceptional flexibility with a spacious recreation room, a fourth bedroom, and a full bathroom, making it ideal for growing families, multi-generational living, overnight guests, a home office, or future income potential. Step outside to enjoy a fully fenced backyard offering privacy and plenty of space for children, pets, gardening, or summer BBQs. An attached garage and double driveway provide parking for up to three vehicles. Located on a quiet crescent in the desirable Westvale community, you'll appreciate the convenience of being just minutes from highly regarded schools, beautiful parks and trails, shopping, restaurants, public transit, and easy access to the University of Waterloo, Wilfrid Laurier University, and major commuter routes. Recent updates include premium laminate flooring (2023), stainless steel kitchen appliances, including the fridge and stove (2023), fresh professional paint (2024), roof shingles (2016), and a furnace (2018). This is an exceptional opportunity to own a beautifully maintained home in one of Waterloo's most established and family-friendly communities. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T18:09:54.238532+00:00"
+"Directions": "Cross Streets: Fischer-Hallman Road & Erb Street. ** Directions: Westvale Drive to Pinemeadow Crescent."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Concrete Block"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2188755"
+"ListOfficeKey": "291409"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40 x 108.5 FT ; 40.35ft. x 113.0ft. x 40.09ft x 108.45ft"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Tandem"
]
+"PhotosChangeTimestamp": "2026-07-03T13:04:24Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T13:04:24Z"
+"Stories": "1.0"
+"StreetName": "Pinemeadow"
+"StreetNumber": "92"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4096"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29983725/92-pinemeadow-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1418255"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "90198"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2026-07-03T13:04:24.39Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1437820"
+"ListOfficeNationalAssociationId": "1397659"
+"CoListAgentNationalAssociationId": "1105101"
+"CoListOfficeNationalAssociationId": "1153615"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983725')"
+"ID": "1589820"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25264
+post_id: "1588834"
+post_author: 1
+"ListingKey": "29983590"
+"ListingId": "40844806"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T12:40:07Z"
+"RFModificationTimestamp": "2026-07-03T13:44:45Z"
+"ListPrice": 689000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.102
+"LivingArea": 1572.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1A7"
+"UnparsedAddress": "92 PINEMEADOW Crescent, Waterloo, Ontario N2T1A7"
+"Coordinates": array:2 [
0 => -80.5538293
1 => 43.4490161
]
+"Latitude": 43.4490161
+"Longitude": -80.5538293
+"YearBuilt": 1980
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "The bright and inviting main level features spacious principal rooms, premium laminate flooring, fresh professional paint, updated interior doors and railings, and beautifully renovated bathrooms. At the heart of the home is the modern kitchen, showcasing refreshed cabinetry, sleek countertops, and stainless steel appliances—an ideal space for both everyday living and entertaining. The fully finished lower level adds exceptional flexibility with a spacious recreation room, a fourth bedroom, and a full bathroom, making it ideal for growing families, multi-generational living, overnight guests, a home office, or future income potential. Step outside to enjoy a fully fenced backyard offering privacy and plenty of space for children, pets, gardening, or summer BBQs. An attached garage and double driveway provide parking for up to three vehicles. Located on a quiet crescent in the desirable Westvale community, you'll appreciate the convenience of being just minutes from highly regarded schools, beautiful parks and trails, shopping, restaurants, public transit, and easy access to the University of Waterloo, Wilfrid Laurier University, and major commuter routes. Recent updates include premium laminate flooring (2023), stainless steel kitchen appliances including the fridge and stove (2023), fresh professional paint (2024), roof shingles (2016), and furnace (2018). This is an exceptional opportunity to own a beautifully maintained home in one of Waterloo's most established and family-friendly communities. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T13:44:33.076117+00:00"
+"Directions": "Westvale Drive to Pinemeadow Crescent"
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Brick"
2 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2180828"
+"ListOfficeKey": "290853"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.102"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T12:28:38Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T12:28:38Z"
+"Stories": "1.0"
+"StreetName": "PINEMEADOW"
+"StreetNumber": "92"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "4096"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"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/29983590/92-pinemeadow-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 1066
+"BelowGradeFinishedArea": 506
+"OriginalEntryTimestamp": "2026-07-03T12:28:37.91Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1430684"
+"ListOfficeNationalAssociationId": "1394395"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983590')"
+"ID": "1588834"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25259
+post_id: "1588398"
+post_author: 1
+"ListingKey": "29983215"
+"ListingId": "X13516818"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T04:20:01Z"
+"RFModificationTimestamp": "2026-07-03T06:51:55Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5G5"
+"UnparsedAddress": "109 WESTMOUNT ROAD N, Waterloo, Ontario N2L5G5"
+"Coordinates": array:2 [
0 => -80.540795
1 => 43.463692
]
+"Latitude": 43.463692
+"Longitude": -80.540795
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Fantastic Opportunity in the Heart of Waterloo! This spacious 4-bedroom condo is located just steps from the University of Waterloo, making it an excellent choice for students, professionals, families, or investors. Vacant possession is available, allowing you to move in immediately or set your own rental rates. Renovated a few years ago, this bright and functional unit features 2 updated bathrooms, an open-concept kitchen with ample cabinetry and storage, in-suite laundry, and 6 included appliances. The thoughtfully designed layout offers comfortable living with excellent rental potential.The building includes secure underground parking and a private storage locker. Conveniently located near the University of Waterloo, schools, public transit, shopping, restaurants, and beautiful Waterloo Park. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "594"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-03T06:51:47.113593+00:00"
+"Directions": "Westmount Rd N/ University Ave"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2052787"
+"ListOfficeKey": "88155"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T04:12:38Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T04:12:38Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "Westmount"
+"StreetNumber": "109"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3850.78"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29983215/109-westmount-road-n-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Weigel Property Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 4
+"OriginalEntryTimestamp": "2026-07-03T04:12:38.48Z"
+"ListAgentNationalAssociationId": "1328120"
+"ListOfficeNationalAssociationId": "1150768"
+"Media": array:13 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983215')"
+"ID": "1588398"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1588109"
+post_author: 1
+"ListingKey": "29983122"
+"ListingId": "40844772"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T12:55:15Z"
+"RFModificationTimestamp": "2026-07-03T18:13:51Z"
+"ListPrice": 679900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.19
+"LivingArea": 1578.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3E2"
+"UnparsedAddress": "6 TWEED Street, Waterloo, Ontario N2J3E2"
+"Coordinates": array:2 [
0 => -80.5172119
1 => 43.4664292
]
+"Latitude": 43.4664292
+"Longitude": -80.5172119
+"YearBuilt": 1904
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 6 Tweed Street, a charming double-brick century home in the heart of Waterloo, offering the character buyers love with many thoughtful updates already completed. Built in 1904 and not heritage designated, this home features a double-wide interlock driveway, single detached garage with opener, steel roof, and replaced vinyl Centennial windows. Inside, you’ll find hardwood flooring through the entrance, living room, dining room, and staircase, along with a classic pocket door separating the living and dining areas. The main floor also offers a convenient office with a large closet, making it ideal for working from home or added storage. The kitchen was renovated approximately 10 years ago and features tile flooring, an island with granite counters, gas stove, range hood, dishwasher, and a butler’s pantry. Upstairs are three bedrooms, including a third bedroom with a walkout to a porch area, plus a beautifully renovated 4-piece bathroom with heated tile floor, tiled glass shower, new vanity, and clawfoot tub. The basement offers laundry, water softener, owned water heater, and a great shop area at the back of the basement. Major updates include electrical, plumbing, 200-amp service, conversion from oil to gas heat, central air approximately 5 years old, four new screen doors, and more. A rare opportunity to own a well-cared-for century home with timeless character, practical updates, and a fantastic Waterloo location. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Range - Gas"
4 => "Dishwasher"
5 => "Dryer"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T04:37:10.957246+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564175"
+"ListOfficeKey": "259258"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.19"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T03:01:57Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T12:48:31Z"
+"Stories": "2.0"
+"StreetName": "TWEED"
+"StreetNumber": "6"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "5342.33"
+"VirtualTourURLUnbranded": "https://youriguide.com/15w5d_6_tweed_street_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/29983122/6-tweed-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 66.0
+"AboveGradeFinishedArea": 1578
+"OriginalEntryTimestamp": "2026-07-03T03:01:57.6Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1140384"
+"ListOfficeNationalAssociationId": "1217708"
+"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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983122')"
+"ID": "1588109"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25267
+post_id: "1587309"
+post_author: 1
+"ListingKey": "29982072"
+"ListingId": "40844850"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T15:55:11Z"
+"RFModificationTimestamp": "2026-07-03T16:07:34Z"
+"ListPrice": 425000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 666.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0H2"
+"UnparsedAddress": "251 HEMLOCK Street Unit# 208, Waterloo, Ontario N2L0H2"
+"Coordinates": array:2 [
0 => -80.5316024
1 => 43.4750774
]
+"Latitude": 43.4750774
+"Longitude": -80.5316024
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Sage 6! Located near both University of Laurier and University of Waterloo. Are you a student looking for a modern condo in one of Waterloo's most desirable locations....this one is for you! Are you an investor looking to purchase the perfect rental unit with excellent monthly income.....this condo is for you! This condo was designed beautifully for student living in the right location and steps away to so many amenities. This contemporary condo features nine foot ceilings, two spacious bedrooms, one three piece bathroom and a second two piece bathroom, kitchen with stainless steel appliances open to a perfectly sized family room with open balcony and in suite laundry. This corner condo unit is surrounded with large windows bringing in lots of natural light. You will love all the impressive amenities while living at Sage 6... a rooftop garden terrace, party room and lounge, fitness center, and secure bicycle storage. The location is so perfect and so close to everything you need for everyday living. Countless restaurants, grocery stores, shopping, major highway and excellent scenery and trails to enjoy when you have time. Look no further this condo is waiting for its new owner or student to move in and begin the next chapter of their life. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"AssociationFee": "435.77"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T01:22:43.025871+00:00"
+"Directions": "University to Hemlock"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2088562"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-02T22:10:31Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T15:48:12Z"
+"Stories": "1.0"
+"StreetName": "HEMLOCK"
+"StreetNumber": "251"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2826.63"
+"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/29982072/251-hemlock-street-unit-208-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 666
+"OriginalEntryTimestamp": "2026-07-02T22:10:31.74Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1361859"
+"ListOfficeNationalAssociationId": "1004370"
+"Media": array:24 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29982072')"
+"ID": "1587309"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25268
+post_id: "1586550"
+post_author: 1
+"ListingKey": "29982077"
+"ListingId": "40844186"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T17:45:39Z"
+"RFModificationTimestamp": "2026-07-03T17:52:20Z"
+"ListPrice": 1099000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2230.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2A3K6"
+"UnparsedAddress": "46 HUNTINGDALE Drive, Kitchener, Ontario N2A3K6"
+"Coordinates": array:2 [
0 => -80.5348763
1 => 43.4438901
]
+"Latitude": 43.4438901
+"Longitude": -80.5348763
+"YearBuilt": 1989
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 46 Huntingdale Drive in Kitchener! One of Idlewood's most mature and high demand streets to live. This home has had the pleasure of having one owner. This solid brick custom built home sits on an over sized lot with 100 feet frontage on a beautiful corner with mature gardens and trees. The main floor features a welcoming front foyer, with wood spiral staircase, formal living room, dining room kitchen with dinette, family room with wood burning fireplace, laundry with two piece bathroom and two additional door entrances to the home. The second level features four bedrooms and two 4 piece bathrooms. You will love the spacious primary bedroom with separate closet/seating area and ensuite. The finished walkout has a spacious seating area with lots of room for storage and 3 piece bathroom and walk in utility room. The basement has large windows and separate entrance to the downstairs patio. This home has many large windows for natural light. You have plenty of room for parking with 5 spaces. This family and friendly neighborhood is minutes away to schools, school bus routes, public transit, shopping, Chicopee Ski Hills, walking trails and so much more. 46 Huntingdale Drive is waiting for its new owner......don't miss your chance to see this beautiful home. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Freezer"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
]
+"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-02T23:23:21.824538+00:00"
+"Directions": "Old Chicopee to Huntingdale Drive."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:4 [
0 => "Wood"
1 => "Electric"
2 => "Other - See remarks"
3 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2088562"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T22:10:38Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T17:18:55Z"
+"Stories": "2.0"
+"StreetName": "HUNTINGDALE"
+"StreetNumber": "46"
+"StreetSuffix": "Drive"
+"SubdivisionName": "232 - Idlewood/Lackner Woods"
+"TaxAnnualAmount": "6525.52"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/46_huntington_pl_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29982077/46-huntingdale-drive-kitchener"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R2A"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 100.0
+"AboveGradeFinishedArea": 2230
+"OriginalEntryTimestamp": "2026-07-02T22:10:37.98Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1361859"
+"ListOfficeNationalAssociationId": "1004370"
+"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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29982077')"
+"ID": "1586550"
}
]
+success: true
+page_size: 9
+page_count: 41
+count: 367
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]