array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29810633 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: "1464028"
+post_author: 1
+"ListingKey": "29810633"
+"ListingId": "40833945"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T04:10:09Z"
+"RFModificationTimestamp": "2026-06-11T04:16:04Z"
+"ListPrice": 429999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1326.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6N6"
+"UnparsedAddress": "255 KEATS Way Unit# 606, Waterloo, Ontario N2L6N6"
+"Coordinates": array:2 [
0 => -80.5433038
1 => 43.4621008
]
+"Latitude": 43.4621008
+"Longitude": -80.5433038
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "5 Reasons You’ll Love This Home – 255 Keats Way, Unit 606 *Bright Southwest Exposure – Located on the 6th floor with a desirable southwest-facing view, this unit enjoys abundant natural sunlight throughout the day, creating a warm and inviting atmosphere. *Spacious and Functional Layout – Featuring 2 generous bedrooms and 2 full bathrooms, this unit offers a practical and comfortable layout ideal for families, professionals, students, or investors. *Well-Maintained Condo with Strong Security – Enjoy peace of mind with a well-managed building featuring a strict and secure entry system, providing added comfort and safety for residents. *Parking Included – Comes with an included parking space, providing added convenience and value for daily living. *Prime Waterloo Location – Situated in one of Waterloo’s most desirable neighbourhoods, just minutes from University of Waterloo, Wilfrid Laurier University, Costco, T&T Supermarket, shopping, parks, restaurants, and public transit. Excellent opportunity for both end-users and investors alike. (Unit is virtually staged) (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "792"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-27T16:24:54.462585+00:00"
+"Directions": "University and Keats Way"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2192904"
+"ListOfficeKey": "292732"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Southern exposure"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-05-27T14:00:35Z"
+"PhotosCount": 10
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T04:01:58Z"
+"Stories": "1.0"
+"StreetName": "KEATS"
+"StreetNumber": "255"
+"StreetSuffix": "Way"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "4547.2"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1656828940"
"RoomType" => "3pc Bathroom"
"ListingId" => "40833945"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29810633"
"RoomLength" => null
"RoomDimensions" => "5'5'' x 5'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T04:01:58.91Z"
]
1 => array:11 [
"RoomKey" => "1656828941"
"RoomType" => "3pc Bathroom"
"ListingId" => "40833945"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29810633"
"RoomLength" => null
"RoomDimensions" => "5'5'' x 5'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T04:01:58.91Z"
]
2 => array:11 [
"RoomKey" => "1656828942"
"RoomType" => "Bedroom"
"ListingId" => "40833945"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29810633"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 13'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T04:01:58.91Z"
]
3 => array:11 [
"RoomKey" => "1656828943"
"RoomType" => "Primary Bedroom"
"ListingId" => "40833945"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29810633"
"RoomLength" => null
"RoomDimensions" => "12'11'' x 16'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T04:01:58.91Z"
]
4 => array:11 [
"RoomKey" => "1656828944"
"RoomType" => "Kitchen"
"ListingId" => "40833945"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29810633"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T04:01:58.92Z"
]
5 => array:11 [
"RoomKey" => "1656828945"
"RoomType" => "Living room/Dining room"
"ListingId" => "40833945"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29810633"
"RoomLength" => null
"RoomDimensions" => "18'5'' x 21'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T04:01:58.92Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29810633/255-keats-way-unit-606-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RMU"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1326
+"OriginalEntryTimestamp": "2026-05-27T14:00:35.33Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1441853"
+"ListOfficeNationalAssociationId": "1416806"
+"Media": array:10 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29810633_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810633/f7314c007c60775f93e8fa6073f8e6e5.webp"
"MediaSize" => 94258
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810633/thumbnail-f7314c007c60775f93e8fa6073f8e6e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring expansive windows, a kitchen with white cabinetry and appliances, a dining area, and a living area with a built-in fireplace"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40833945"
"ResourceRecordKey" => "29810633"
"ModificationTimestamp" => "2026-05-27T14:00:35.33Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29810633_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810633/ac145a2abcbc84f2c59c6505abd39173.webp"
"MediaSize" => 99145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810633/thumbnail-ac145a2abcbc84f2c59c6505abd39173.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring neutral carpet flooring and crown molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833945"
"ResourceRecordKey" => "29810633"
"ModificationTimestamp" => "2026-05-27T14:00:35.33Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29810633_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810633/7f27f426cd17ac15533cd491fddd2f78.webp"
"MediaSize" => 81421
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810633/thumbnail-7f27f426cd17ac15533cd491fddd2f78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, a central island with a stone-finish countertop, a dark tile backsplash, and track lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833945"
"ResourceRecordKey" => "29810633"
"ModificationTimestamp" => "2026-05-27T14:00:35.33Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29810633_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810633/233d2c24b0e38ea7c2c548a5f91eccf8.webp"
"MediaSize" => 83713
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810633/thumbnail-233d2c24b0e38ea7c2c548a5f91eccf8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Plush carpeted flooring and light blue wall tones define this bedroom space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833945"
"ResourceRecordKey" => "29810633"
"ModificationTimestamp" => "2026-05-27T14:00:35.33Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29810633_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810633/6f4420318c4e684489fddd5bd5f692a8.webp"
"MediaSize" => 79380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810633/thumbnail-6f4420318c4e684489fddd5bd5f692a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive window featuring a broad exterior outlook, accompanied by neutral carpeting, a semi-flush ceiling light fixture, and light blue wall tones"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833945"
"ResourceRecordKey" => "29810633"
"ModificationTimestamp" => "2026-05-27T14:00:35.33Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29810633_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810633/901b9f1be849cd59ae840bbc636b8827.webp"
"MediaSize" => 71750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810633/thumbnail-901b9f1be849cd59ae840bbc636b8827.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Walk-in closet with multi-level wire shelving, white baseboards, and neutral-toned carpeting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833945"
"ResourceRecordKey" => "29810633"
"ModificationTimestamp" => "2026-05-27T14:00:35.33Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29810633_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810633/e895412926c04ffe549b26023b7c967d.webp"
"MediaSize" => 68406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810633/thumbnail-e895412926c04ffe549b26023b7c967d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a spacious tub and shower combination with white subway tile surround"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833945"
"ResourceRecordKey" => "29810633"
"ModificationTimestamp" => "2026-05-27T14:00:35.33Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29810633_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810633/9d183f6c9be4e85300188967563bddee.webp"
"MediaSize" => 79711
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810633/thumbnail-9d183f6c9be4e85300188967563bddee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive window offering abundant natural light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833945"
"ResourceRecordKey" => "29810633"
"ModificationTimestamp" => "2026-05-27T14:00:35.33Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29810633_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810633/3e6d0a98eaea96231950a747b927e6a0.webp"
"MediaSize" => 85543
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810633/thumbnail-3e6d0a98eaea96231950a747b927e6a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring plush carpet flooring, a built-in closet with sliding doors and interior shelving, a desk area with wood-finish shelving, and a white six-panel door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833945"
"ResourceRecordKey" => "29810633"
"ModificationTimestamp" => "2026-05-27T14:00:35.33Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29810633_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810633/23aad1959b4a2af6ac9c1ffcc71d1b51.webp"
"MediaSize" => 70302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810633/thumbnail-23aad1959b4a2af6ac9c1ffcc71d1b51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with a light-colored countertop and integrated sink, a large mirror, and a four-light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833945"
"ResourceRecordKey" => "29810633"
"ModificationTimestamp" => "2026-05-27T14:00:35.33Z"
]
]
+"DaysOnMarket": 38
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29810633')"
+"ID": "1464028"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 292732" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24842
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2192904" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24800
+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 '29810633'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25167
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29810633'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25181
+items: array:5 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25183
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31193457"
+"ListingKey": "29810633"
+"ListingId": "40833945"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-05-30"
+"OpenHouseStartTime": "2026-05-30T14:00:00Z"
+"OpenHouseEndTime": "2026-05-30T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-05-30T19:04:10Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31193457')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25185
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31193458"
+"ListingKey": "29810633"
+"ListingId": "40833945"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-05-31"
+"OpenHouseStartTime": "2026-05-31T14:00:00Z"
+"OpenHouseEndTime": "2026-05-31T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-05-30T19:04:10Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31193458')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25182
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31247291"
+"ListingKey": "29810633"
+"ListingId": "40833945"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-05-31"
+"OpenHouseStartTime": "2026-05-31T14:00:00Z"
+"OpenHouseEndTime": "2026-05-31T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-05-31T17:50:02Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31247291')"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25186
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31330755"
+"ListingKey": "29810633"
+"ListingId": "40833945"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-06"
+"OpenHouseStartTime": "2026-06-07T02:00:00Z"
+"OpenHouseEndTime": "2026-06-07T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-05T16:49:39Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31330755')"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25184
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31335607"
+"ListingKey": "29810633"
+"ListingId": "40833945"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-06"
+"OpenHouseStartTime": "2026-06-06T14:00:00Z"
+"OpenHouseEndTime": "2026-06-06T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-06T15:43:19Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31335607')"
}
]
+success: true
+page_size: 5
+page_count: 1
+count: 5
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29810633' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5433038 43.4621008)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25246
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25240
+post_id: "1591176"
+post_author: 1
+"ListingKey": "29987087"
+"ListingId": "40844492"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T20:25:13Z"
+"RFModificationTimestamp": "2026-07-04T20:33:40Z"
+"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-04T20:18:44Z"
+"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" => "1675187398"
"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-04T20:18:44.57Z"
]
1 => array:11 [
"RoomKey" => "1675187399"
"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-04T20:18:44.57Z"
]
2 => array:11 [
"RoomKey" => "1675187400"
"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-04T20:18:44.57Z"
]
3 => array:11 [
"RoomKey" => "1675187401"
"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-04T20:18:44.57Z"
]
4 => array:11 [
"RoomKey" => "1675187402"
"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-04T20:18:44.57Z"
]
5 => array:11 [
"RoomKey" => "1675187403"
"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-04T20:18:44.57Z"
]
6 => array:11 [
"RoomKey" => "1675187404"
"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-04T20:18:44.57Z"
]
7 => array:11 [
"RoomKey" => "1675187405"
"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-04T20:18:44.57Z"
]
8 => array:11 [
"RoomKey" => "1675187406"
"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-04T20:18:44.57Z"
]
]
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29987087')"
+"ID": "1591176"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25242
+post_id: "1590956"
+post_author: 1
+"ListingKey": "29987378"
+"ListingId": "X13520800"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T18:05:17Z"
+"RFModificationTimestamp": "2026-07-04T18:08:09Z"
+"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:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Blinds"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
10 => "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-04T17:59:58Z"
+"Stories": "2.0"
+"StreetName": "Beechwood"
+"StreetNumber": "459"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "2521"
+"VirtualTourURLUnbranded": "https://youriguide.com/459_beechwood_pl_unit_21_waterloo_on/"
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1675103286"
"RoomType" => "Kitchen"
"ListingId" => "X13520800"
"RoomLevel" => "Main level"
"RoomWidth" => 2.36
"ListingKey" => "29987378"
"RoomLength" => 2.54
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T17:59:58.49Z"
]
1 => array:11 [
"RoomKey" => "1675103287"
"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-04T17:59:58.49Z"
]
2 => array:11 [
"RoomKey" => "1675103288"
"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-04T17:59:58.5Z"
]
3 => array:11 [
"RoomKey" => "1675103289"
"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-04T17:59:58.5Z"
]
4 => array:11 [
"RoomKey" => "1675103290"
"RoomType" => "Bedroom 2"
"ListingId" => "X13520800"
"RoomLevel" => "Second level"
"RoomWidth" => 2.86
"ListingKey" => "29987378"
"RoomLength" => 3.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T17:59:58.51Z"
]
5 => array:11 [
"RoomKey" => "1675103291"
"RoomType" => "Bathroom"
"ListingId" => "X13520800"
"RoomLevel" => "Second level"
"RoomWidth" => 1.52
"ListingKey" => "29987378"
"RoomLength" => 2.12
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T17:59:58.51Z"
]
6 => array:11 [
"RoomKey" => "1675103292"
"RoomType" => "Bathroom"
"ListingId" => "X13520800"
"RoomLevel" => "Second level"
"RoomWidth" => 1.91
"ListingKey" => "29987378"
"RoomLength" => 0.94
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T17:59:58.51Z"
]
7 => array:11 [
"RoomKey" => "1675103293"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13520800"
"RoomLevel" => "Basement"
"RoomWidth" => 2.86
"ListingKey" => "29987378"
"RoomLength" => 2.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T17:59:58.52Z"
]
8 => array:11 [
"RoomKey" => "1675103294"
"RoomType" => "Bathroom"
"ListingId" => "X13520800"
"RoomLevel" => "Basement"
"RoomWidth" => 1.37
"ListingKey" => "29987378"
"RoomLength" => 1.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T17:59:58.52Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29987378_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/3c15b62e59fc34b9081428fa65951c1c.webp"
"MediaSize" => 304339
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-3c15b62e59fc34b9081428fa65951c1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13520800"
"ResourceRecordKey" => "29987378"
"ModificationTimestamp" => "2026-07-03T20:59:56.01Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29987378_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/c7943e12c5a9721c99ccdc2b25b450d0.webp"
"MediaSize" => 329268
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-c7943e12c5a9721c99ccdc2b25b450d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13520800"
"ResourceRecordKey" => "29987378"
"ModificationTimestamp" => "2026-07-03T20:59:56.01Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29987378_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/9490dbae4f427c421e946ebf3aeb1f6e.webp"
"MediaSize" => 149782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-9490dbae4f427c421e946ebf3aeb1f6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13520800"
"ResourceRecordKey" => "29987378"
"ModificationTimestamp" => "2026-07-03T20:59:56.01Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29987378_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/622922041708585fac5da248ec43b3fe.webp"
"MediaSize" => 204687
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-622922041708585fac5da248ec43b3fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13520800"
"ResourceRecordKey" => "29987378"
"ModificationTimestamp" => "2026-07-03T20:59:56.01Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29987378_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/d28f85dad485e62c4045d8f748353117.webp"
"MediaSize" => 194796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-d28f85dad485e62c4045d8f748353117.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13520800"
"ResourceRecordKey" => "29987378"
"ModificationTimestamp" => "2026-07-03T20:59:56.01Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29987378_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/637ab6c896dd2ffa871d198847f6a23c.webp"
"MediaSize" => 210563
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-637ab6c896dd2ffa871d198847f6a23c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13520800"
"ResourceRecordKey" => "29987378"
"ModificationTimestamp" => "2026-07-03T20:59:56.01Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29987378_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/d880d3ce4b3a10325bcd8c7ce563d894.webp"
"MediaSize" => 200644
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-d880d3ce4b3a10325bcd8c7ce563d894.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13520800"
"ResourceRecordKey" => "29987378"
"ModificationTimestamp" => "2026-07-03T20:59:56.01Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29987378_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/096304b2cbda20de1f4239218ae2277a.webp"
"MediaSize" => 151437
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-096304b2cbda20de1f4239218ae2277a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13520800"
"ResourceRecordKey" => "29987378"
"ModificationTimestamp" => "2026-07-03T20:59:56.01Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29987378_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/97077c43ac012f763c4bb772c8891ec3.webp"
"MediaSize" => 148274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-97077c43ac012f763c4bb772c8891ec3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13520800"
"ResourceRecordKey" => "29987378"
"ModificationTimestamp" => "2026-07-03T20:59:56.01Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29987378_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/f02806ca999ba797d566d074bb7c8e8f.webp"
"MediaSize" => 171991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-f02806ca999ba797d566d074bb7c8e8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13520800"
"ResourceRecordKey" => "29987378"
"ModificationTimestamp" => "2026-07-03T20:59:56.01Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29987378_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/ea322cd4427f3d63b2c807671783c364.webp"
"MediaSize" => 207613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-ea322cd4427f3d63b2c807671783c364.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13520800"
"ResourceRecordKey" => "29987378"
"ModificationTimestamp" => "2026-07-03T20:59:56.01Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29987378_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/6c889a4242afa8df0581a3eabdad0620.webp"
"MediaSize" => 89208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-6c889a4242afa8df0581a3eabdad0620.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13520800"
"ResourceRecordKey" => "29987378"
"ModificationTimestamp" => "2026-07-03T20:59:56.01Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29987378_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/8029171f2fe92c9fe666d709da00de6c.webp"
"MediaSize" => 191156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-8029171f2fe92c9fe666d709da00de6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13520800"
"ResourceRecordKey" => "29987378"
"ModificationTimestamp" => "2026-07-03T20:59:56.01Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29987378_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/8eb080a0e6693bf1aa7818364e6a3a0f.webp"
"MediaSize" => 152202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-8eb080a0e6693bf1aa7818364e6a3a0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13520800"
"ResourceRecordKey" => "29987378"
"ModificationTimestamp" => "2026-07-03T20:59:56.01Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29987378_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/9f717b707df99efaa491182f8182cc5a.webp"
"MediaSize" => 135384
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-9f717b707df99efaa491182f8182cc5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13520800"
"ResourceRecordKey" => "29987378"
"ModificationTimestamp" => "2026-07-03T20:59:56.01Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29987378_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/618d9db5264f70d2eef4eadaa9247386.webp"
"MediaSize" => 269180
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-618d9db5264f70d2eef4eadaa9247386.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13520800"
"ResourceRecordKey" => "29987378"
"ModificationTimestamp" => "2026-07-03T20:59:56.01Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29987378_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/6124a58cc10a979e4de95a9f0daaa212.webp"
"MediaSize" => 189141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-6124a58cc10a979e4de95a9f0daaa212.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13520800"
"ResourceRecordKey" => "29987378"
"ModificationTimestamp" => "2026-07-03T20:59:56.01Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29987378_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/d82e038c44acc38122dcd3e0c661f96e.webp"
"MediaSize" => 77610
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-d82e038c44acc38122dcd3e0c661f96e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13520800"
"ResourceRecordKey" => "29987378"
"ModificationTimestamp" => "2026-07-03T20:59:56.01Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29987378_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/d84090d30cfcf82258144bddb88ee32d.webp"
"MediaSize" => 337189
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-d84090d30cfcf82258144bddb88ee32d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13520800"
"ResourceRecordKey" => "29987378"
"ModificationTimestamp" => "2026-07-03T20:59:56.01Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29987378_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/8da0ede7449f781be5dc92335be860da.webp"
"MediaSize" => 405777
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-8da0ede7449f781be5dc92335be860da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13520800"
"ResourceRecordKey" => "29987378"
"ModificationTimestamp" => "2026-07-03T20:59:56.01Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29987378_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/1995f2f7d222516bb0c4356412e8a861.webp"
"MediaSize" => 424421
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-1995f2f7d222516bb0c4356412e8a861.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13520800"
"ResourceRecordKey" => "29987378"
"ModificationTimestamp" => "2026-07-03T20:59:56.01Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29987378_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/803487bda45f26c71403bfbfa8116ded.webp"
"MediaSize" => 422878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-803487bda45f26c71403bfbfa8116ded.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13520800"
"ResourceRecordKey" => "29987378"
"ModificationTimestamp" => "2026-07-03T20:59:56.01Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29987378_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987378/a8e6def4c93ec6050d05af4454a86903.webp"
"MediaSize" => 102103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987378/thumbnail-a8e6def4c93ec6050d05af4454a86903.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
23 => array:13 [ …13]
24 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29987378')"
+"ID": "1590956"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25239
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29985514')"
+"ID": "1590419"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25243
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983725')"
+"ID": "1589820"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25241
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/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 [ …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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29984752')"
+"ID": "1588969"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25236
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983590')"
+"ID": "1588834"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983215')"
+"ID": "1588398"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25244
+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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29982072')"
+"ID": "1587309"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25245
+post_id: "1584049"
+post_author: 1
+"ListingKey": "29970172"
+"ListingId": "X13504148"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T17:45:07Z"
+"RFModificationTimestamp": "2026-07-02T19:09:00Z"
+"ListPrice": 329000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2R3"
+"UnparsedAddress": "404 - 45 WESTMOUNT ROAD N, Waterloo, Ontario N2L2R3"
+"Coordinates": array:2 [
0 => -80.539224
1 => 43.460997
]
+"Latitude": 43.460997
+"Longitude": -80.539224
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright and spacious 2-bedroom condo in the heart of Waterloo. This corner unit boasts a bright, spacious layout with large windows, filling the space with natural light. The larger semi-enclosed sunroom is perfect for relaxing. The bedrooms are generously sized with ample closet space. Located right across from Westmount Place Mall, this condo offers easy access to multiple bus routes, and the LRT, and is just minutes from Uptown Waterloo, making commuting a breeze. Steps away from shopping, public transit, and Waterloos universities, this home is move-in-ready and ideal for first-time buyers, investors, or those looking to downsize. The unit comes with one underground parking and locker. This building offers ample parking, and condo fees cover all utilities (heat, hydro, and water). (id:62650)"
+"AssociationFee": "974.32"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Electricity"
3 => "Water"
4 => "Insurance"
5 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Wall unit"
]
+"CreationDate": "2026-07-02T17:01:57.821410+00:00"
+"Directions": "Westmount/ERB"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2025210"
+"ListOfficeKey": "280927"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-02T17:33:41Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T17:33:41Z"
+"StreetDirSuffix": "North"
+"StreetName": "Westmount"
+"StreetNumber": "45"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "2348"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29970172/404-45-westmount-road-n-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Canlight"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Storage - Locker"
1 => "Visitor Parking"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-30T14:52:07.98Z"
+"ListAgentNationalAssociationId": "1304872"
+"ListOfficeNationalAssociationId": "1318589"
+"Media": array:22 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29970172')"
+"ID": "1584049"
}
]
+success: true
+page_size: 9
+page_count: 39
+count: 349
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]