array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29840917 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23331
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23333
+post_id: "1485217"
+post_author: 1
+"ListingKey": "29840917"
+"ListingId": "X13229038"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T18:25:21Z"
+"RFModificationTimestamp": "2026-06-02T18:56:36Z"
+"ListPrice": 849000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3K5"
+"UnparsedAddress": "304 AUBURN DRIVE, Waterloo, Ontario N2K3K5"
+"Coordinates": array:2 [
0 => -80.494171
1 => 43.493187
]
+"Latitude": 43.493187
+"Longitude": -80.494171
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Experience refined bungalow living in one of the area's most sought-after neighbourhoods. This beautifully updated three-bedroom home offers an exceptional combination of luxury, comfort, and accessibility, all set against a serene backdrop of protected green space. The bright, open-concept main floor is designed for both everyday living and elegant entertaining, featuring spacious principal rooms, premium finishes, and an abundance of natural light throughout. The stunning updated kitchen serves as the heart of the home, seamlessly connecting to the living and dining areas. An oversized sliding door opens to a private deck overlooking lush green space, creating the perfect setting for morning coffee, outdoor dining, or simply enjoying the peaceful surroundings. The spacious primary retreat is a true sanctuary, complete with an oversized walk-in closet and a beautifully renovated ensuite featuring luxurious in-floor heating. Thoughtfully designed accessibility features, including oversized doorways and a ramp, ensure effortless living without compromising style. The fully finished lower level offers remarkable additional living space, including a generous recreation room, two spacious bedrooms, and a full bathroom. Large, above-grade windows flood the basement with natural light, creating a bright and welcoming atmosphere that feels anything but below ground. Car enthusiasts and hobbyists will appreciate the oversized double-car garage, offering ample space for vehicles, storage, and workspace. Ideally located close to top-rated schools, shopping, parks, walking trails, transit, and every essential amenity, this exceptional home delivers the perfect blend of luxury, convenience, and lifestyle. A rare opportunity to own a meticulously maintained bungalow in an outstanding location. (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-02T18:56:24.522210+00:00"
+"Directions": "Cross Streets: University Avenue. ** Directions: University Avenue to Auburn Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2198898"
+"ListOfficeKey": "293007"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Wheelchair access"
]
+"LotSizeDimensions": "65.7 x 116 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-02T17:56:04Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T18:15:14Z"
+"Stories": "1.0"
+"StreetName": "Auburn"
+"StreetNumber": "304"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6124"
+"VirtualTourURLUnbranded": "https://youriguide.com/304_auburn_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29840917/304-auburn-drive-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 65.8
+"OriginalEntryTimestamp": "2026-06-02T17:56:04.43Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1447639"
+"ListOfficeNationalAssociationId": "1420771"
+"Media": array:37 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29840917_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/e1e8d715802a04803aeae16a9ed0cd21.webp"
"MediaSize" => 220746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-e1e8d715802a04803aeae16a9ed0cd21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29840917_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/fdfc0f20176be822cc2ab4499056e02f.webp"
"MediaSize" => 349998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-fdfc0f20176be822cc2ab4499056e02f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29840917_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/aa5907185d22de6c2cb1ec415fac275b.webp"
"MediaSize" => 346869
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-aa5907185d22de6c2cb1ec415fac275b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29840917_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/51293ce5dd31a13f0c75527fa432845a.webp"
"MediaSize" => 139018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-51293ce5dd31a13f0c75527fa432845a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29840917_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/00889b3e54a7dc2d00114a61e21c6632.webp"
"MediaSize" => 178402
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-00889b3e54a7dc2d00114a61e21c6632.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29840917_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/44e678461916aea47ea1120f9ed21b58.webp"
"MediaSize" => 165280
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-44e678461916aea47ea1120f9ed21b58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29840917_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/dbad380747c5ba86273321062c85c3f2.webp"
"MediaSize" => 170408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-dbad380747c5ba86273321062c85c3f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29840917_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/13ad2aa3952713f59fe70894d5d3c14c.webp"
"MediaSize" => 176683
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-13ad2aa3952713f59fe70894d5d3c14c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29840917_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/782706461060480bed3c7cdc690aeb36.webp"
"MediaSize" => 175510
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-782706461060480bed3c7cdc690aeb36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29840917_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/50fe397e586a42c7888d5b00621804dd.webp"
"MediaSize" => 182766
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-50fe397e586a42c7888d5b00621804dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29840917_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/67688f0c5baa9c0f857a3129a36bde9d.webp"
"MediaSize" => 169232
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-67688f0c5baa9c0f857a3129a36bde9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29840917_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/fcaad0cc726d276af1bda655464dbc5e.webp"
"MediaSize" => 193558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-fcaad0cc726d276af1bda655464dbc5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29840917_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/673b470bacb8a24b0eea2d1ccbf9cc62.webp"
"MediaSize" => 209457
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-673b470bacb8a24b0eea2d1ccbf9cc62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29840917_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/6d38e7b453e3fd20ef6611753f8c2c4c.webp"
"MediaSize" => 246003
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-6d38e7b453e3fd20ef6611753f8c2c4c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29840917_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/0d2dc5c9c4fcd663bb38cce910a48151.webp"
"MediaSize" => 187419
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-0d2dc5c9c4fcd663bb38cce910a48151.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29840917_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/d93372ce4cd98eb2132a2f0cd0c4bc32.webp"
"MediaSize" => 179243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-d93372ce4cd98eb2132a2f0cd0c4bc32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29840917_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/6a50397b0be99bc5e70f568c086907c5.webp"
"MediaSize" => 139834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-6a50397b0be99bc5e70f568c086907c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29840917_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/570d2d2748b394e37ac24079cf73adce.webp"
"MediaSize" => 145415
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-570d2d2748b394e37ac24079cf73adce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29840917_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/2b8f3f3b38a47ec07d9d06f3940a9fd3.webp"
"MediaSize" => 157621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-2b8f3f3b38a47ec07d9d06f3940a9fd3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29840917_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/927f2984b93db2cbc6c60578683a1b5a.webp"
"MediaSize" => 147660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-927f2984b93db2cbc6c60578683a1b5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29840917_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/1513781b372c08dc75aabf1e5a4b8866.webp"
"MediaSize" => 119419
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-1513781b372c08dc75aabf1e5a4b8866.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29840917_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/adf907508231485eefc1a0098395cfba.webp"
"MediaSize" => 189089
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-adf907508231485eefc1a0098395cfba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29840917_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/28cc2646d87201b4c6e390d8378791bc.webp"
"MediaSize" => 235810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-28cc2646d87201b4c6e390d8378791bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29840917_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/85b46b21f9fd742d5c99f09902c01598.webp"
"MediaSize" => 179115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-85b46b21f9fd742d5c99f09902c01598.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29840917_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/c17d642c04f0efa62e362ed0fb7610d4.webp"
"MediaSize" => 103157
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-c17d642c04f0efa62e362ed0fb7610d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29840917_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/da1b3f1daa990564c93d5c37169a841e.webp"
"MediaSize" => 124272
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-da1b3f1daa990564c93d5c37169a841e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29840917_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/9002b3453c45bbce16ed70a6f3db1c00.webp"
"MediaSize" => 162687
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-9002b3453c45bbce16ed70a6f3db1c00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29840917_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/d57ae1557c1a619b96d4fd41305fbd0a.webp"
"MediaSize" => 184994
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-d57ae1557c1a619b96d4fd41305fbd0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29840917_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/06e3ff37a7e073c58dee1ea0cb2f2f5d.webp"
"MediaSize" => 194907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-06e3ff37a7e073c58dee1ea0cb2f2f5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29840917_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/59cba74537f8b7fa83fb1f89c14ec708.webp"
"MediaSize" => 189840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-59cba74537f8b7fa83fb1f89c14ec708.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29840917_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/99fec5789b5710c4b752ff8e1193e3d8.webp"
"MediaSize" => 217488
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-99fec5789b5710c4b752ff8e1193e3d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29840917_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/ecf68a18975f1d65f79c2cf8448bb272.webp"
"MediaSize" => 369191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-ecf68a18975f1d65f79c2cf8448bb272.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29840917_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/9495a4af2cdd070697c069f1f70a99bd.webp"
"MediaSize" => 396631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-9495a4af2cdd070697c069f1f70a99bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29840917_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/d57cf69ce804476cdaac6be930ba9321.webp"
"MediaSize" => 382060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-d57cf69ce804476cdaac6be930ba9321.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29840917_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/26bca35f46d04867a4646a92d0fc4e49.webp"
"MediaSize" => 477060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-26bca35f46d04867a4646a92d0fc4e49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29840917_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/28716e7247b2013e99da6ff047795959.webp"
"MediaSize" => 386278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-28716e7247b2013e99da6ff047795959.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29840917_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840917/f79601a45110f34dcce3f7cb69991da5.webp"
"MediaSize" => 195535
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840917/thumbnail-f79601a45110f34dcce3f7cb69991da5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13229038"
"ResourceRecordKey" => "29840917"
"ModificationTimestamp" => "2026-06-02T17:56:04.43Z"
]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29840917')"
+"ID": "1485217"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 293007" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24683
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2198898" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24768
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29840917'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25085
+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 '29840917'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25101
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29840917' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.494171 43.493187)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25173
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25148
+post_id: "1498871"
+post_author: 1
+"ListingKey": "29859294"
+"ListingId": "40837079"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T20:30:54Z"
+"RFModificationTimestamp": "2026-06-06T20:46:33Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1549.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3N5"
+"UnparsedAddress": "455 BOETTGER Place, Waterloo, Ontario N2K3N5"
+"Coordinates": array:2 [
0 => -80.5024643
1 => 43.4962144
]
+"Latitude": 43.4962144
+"Longitude": -80.5024643
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "OPEN HOUSE SAT. June 6th (2-4). Welcome to 455 Boettger Place, tucked away on a quiet cul-de-sac in Waterloo’s sought-after family-friendly neighbourhood of Lincoln Village. From the charming front porch to the peaceful backyard pond view, this is the kind of home that feels welcoming the moment you arrive. Step inside and appreciate the bright open-concept design that keeps everyone connected. Whether you're hosting family gatherings, helping with homework at the kitchen island, or entertaining friends, this home was designed for comfortable everyday living. The kitchen is truly the heart of the home, complete with stainless steel appliances, a large centre island that naturally becomes the gathering place, and a beautiful bay window overlooking the front yard. The spacious living room is warm and inviting with a walkout to the backyard oasis. The fully fenced backyard is where this property truly shines with mature trees, a concrete patio, and a gazebo, which creates a peaceful retreat right at home. Summer BBQs, quiet evenings and outdoor entertaining are all ready to be enjoyed. Upstairs, you’ll find three good-sized bedrooms, all with closets and natural light, along with an updated 4-piece bathroom (2024) featuring modern finishes. The finished lower level offers valuable extra living space perfect for a rec room, home gym, office, hobby room, or kids’ play area. An updated 3-piece bathroom and plenty of storage add even more function to the space. This home has been well cared for with important updates, including freshly painted neutral décor and updated lighting (2026), Furnace & A/C (2025), updated bathrooms (2024), and a durable Green Metal Roof and Eaves Guard (2021). The location is exceptional, close to golfing, Kiwanis Park, Snyder's Flats Conservation Area, RIM Park, the Walter Bean Trail, schools, shopping, and highway access. This is more than just a house... It’s a place to truly feel at home. Call your REALTOR® today and come see for yourself! (id:62783)"
+"Appliances": array:8 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T17:12:17.515342+00:00"
+"Directions": "Bridge St. W. to Dansbury Dr. to Boettger Pl."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564736"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Paved driveway"
2 => "Gazebo"
3 => "Sump Pump"
]
+"PhotosChangeTimestamp": "2026-06-05T14:20:06Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T20:20:16Z"
+"Stories": "2.0"
+"StreetName": "BOETTGER"
+"StreetNumber": "455"
+"StreetSuffix": "Place"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "3372.84"
+"VirtualTourURLUnbranded": "https://youriguide.com/455_boettger_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1653462432"
"RoomType" => "Storage"
"ListingId" => "40837079"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29859294"
"RoomLength" => null
"RoomDimensions" => "4'8'' x 6'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:20:16.7Z"
]
1 => array:11 [
"RoomKey" => "1653462433"
"RoomType" => "Laundry room"
"ListingId" => "40837079"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29859294"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:20:16.71Z"
]
2 => array:11 [
"RoomKey" => "1653462434"
"RoomType" => "Utility room"
"ListingId" => "40837079"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29859294"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:20:16.71Z"
]
3 => array:11 [
"RoomKey" => "1653462435"
"RoomType" => "3pc Bathroom"
"ListingId" => "40837079"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29859294"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:20:16.72Z"
]
4 => array:11 [
"RoomKey" => "1653462436"
"RoomType" => "Recreation room"
"ListingId" => "40837079"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29859294"
"RoomLength" => null
"RoomDimensions" => "14'11'' x 16'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:20:16.72Z"
]
5 => array:11 [
"RoomKey" => "1653462437"
"RoomType" => "4pc Bathroom"
"ListingId" => "40837079"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29859294"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:20:16.72Z"
]
6 => array:11 [
"RoomKey" => "1653462438"
"RoomType" => "Bedroom"
"ListingId" => "40837079"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29859294"
"RoomLength" => null
"RoomDimensions" => "7'9'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:20:16.73Z"
]
7 => array:11 [
"RoomKey" => "1653462439"
"RoomType" => "Bedroom"
"ListingId" => "40837079"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29859294"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 16'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:20:16.73Z"
]
8 => array:11 [
"RoomKey" => "1653462440"
"RoomType" => "Primary Bedroom"
"ListingId" => "40837079"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29859294"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:20:16.76Z"
]
9 => array:11 [
"RoomKey" => "1653462441"
"RoomType" => "Living room"
"ListingId" => "40837079"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859294"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 16'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:20:16.76Z"
]
10 => array:11 [
"RoomKey" => "1653462442"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "40837079"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859294"
"RoomLength" => null
"RoomDimensions" => "16'1'' x 17'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:20:16.77Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29859294/455-boettger-place-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SD1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 33.0
+"AboveGradeFinishedArea": 1076
+"BelowGradeFinishedArea": 473
+"OriginalEntryTimestamp": "2026-06-05T14:20:05.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1126313"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:43 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29859294_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/4f947e94e5ef5846e4ff220a29544ff7.webp"
"MediaSize" => 170128
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-4f947e94e5ef5846e4ff220a29544ff7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29859294_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/b950ca7f5faadf0ff35f48923bf4075a.webp"
"MediaSize" => 157080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-b950ca7f5faadf0ff35f48923bf4075a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29859294_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/115e38ef162c0e4b0a266402c7536c7c.webp"
"MediaSize" => 163219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-115e38ef162c0e4b0a266402c7536c7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29859294_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/0ac3c0531f06bd519d106ac2c68e4b0c.webp"
"MediaSize" => 125266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-0ac3c0531f06bd519d106ac2c68e4b0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29859294_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/e2d75093d616b2742c392002b58d6165.webp"
"MediaSize" => 172613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-e2d75093d616b2742c392002b58d6165.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29859294_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/39bda45d4b39f9c3e79aa3848e7ff5f8.webp"
"MediaSize" => 108122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-39bda45d4b39f9c3e79aa3848e7ff5f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29859294_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/61deb033fbd735868f6bc4ae4dc97ad6.webp"
"MediaSize" => 74699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-61deb033fbd735868f6bc4ae4dc97ad6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29859294_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/8eecd1381d67718518368d6c0515c8bc.webp"
"MediaSize" => 64656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-8eecd1381d67718518368d6c0515c8bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29859294_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/bdb416713995374bc63d4486319386b1.webp"
"MediaSize" => 70065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-bdb416713995374bc63d4486319386b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29859294_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/2d6bf1afabb958b32c6e02962410b60e.webp"
"MediaSize" => 58782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-2d6bf1afabb958b32c6e02962410b60e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29859294_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/c7d7c8305fb1c2cfb4e686cb63d72603.webp"
"MediaSize" => 55962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-c7d7c8305fb1c2cfb4e686cb63d72603.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29859294_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/9bdb353ea8edba16a1f8e8fe966a6e3f.webp"
"MediaSize" => 71937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-9bdb353ea8edba16a1f8e8fe966a6e3f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29859294_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/90f804364c6e373fa8aaf13dbf3e0dc8.webp"
"MediaSize" => 56455
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-90f804364c6e373fa8aaf13dbf3e0dc8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29859294_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/6cb31ddf0168dfa68abe87b22ee9de23.webp"
"MediaSize" => 47902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-6cb31ddf0168dfa68abe87b22ee9de23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29859294_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/70c051ed7ef0b5a43bd2f55f6ebbc9bf.webp"
"MediaSize" => 53343
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-70c051ed7ef0b5a43bd2f55f6ebbc9bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29859294_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/e45487ee4266715862fcd3dd6aa547cc.webp"
"MediaSize" => 51628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-e45487ee4266715862fcd3dd6aa547cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
…3
]
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29859294')"
+"ID": "1498871"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25150
+post_id: "1496013"
+post_author: 1
+"ListingKey": "29854251"
+"ListingId": "X13240524"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-04T17:30:10Z"
+"RFModificationTimestamp": "2026-06-04T19:11:13Z"
+"ListPrice": 2180000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K1Z2"
+"UnparsedAddress": "345 OLD STONE ROAD, Waterloo, Ontario N2K1Z2"
+"Coordinates": array:2 [
0 => -80.511713
1 => 43.501889
]
+"Latitude": 43.501889
+"Longitude": -80.511713
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to an extraordinary Colonial Acres bungalow, offering over 4,000 sq. ft. of finished living space on a breathtaking 0.376-acre park-like lot. Combining luxury, comfort, and resort-style outdoor living, this exceptional property is a rare opportunity in one of Waterloo's most sought-after neighbourhoods. From the moment you arrive, you'll be impressed by the outstanding curb appeal, featuring an oversized double-car garage and an expansive driveway with parking for six or more vehicles. The beautifully landscaped grounds create a private backyard retreat complete with a stunning inground concrete pool,hot tub, and multiple outdoor entertaining spaces designed for relaxation and memorable gatherings. Inside, the thoughtfully designed open-concept main floor is highlighted by a dramatic two-sided stone gas fireplace that serves as the heart of the home. The custom gourmet kitchen is a chef's dream, showcasing premium appliances, a gas cooktop, built-in convection oven and microwave, wine fridge, oversized island, and peninsula seating-perfect for both everyday living and entertaining. The main level features three spacious bedrooms, including a generous primary retreat, along with a beautifully appointed main bathroom featuring a double-sink vanity, glass shower, and luxurious soaker tub. A separate front entrance leads to a functional mudroom and laundry area, complemented by a stylish powder room with a custom live-edge vanity. The finished lower level extends the home's impressive living space with a large family room featuring a cozy gas stove, two oversized bedrooms, a full bathroom, and a versatile office/library complete with custom built-in shelving. Offering the perfect blend of luxury and convenience, this private urban oasis is ideally located just minutes from the expressway, shopping, golf courses, parks, and everyday amenities. Experience resort-style living without ever leaving the city. (id:62783)"
+"Appliances": array:15 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Wine Fridge"
7 => "Dryer"
8 => "Microwave"
9 => "Oven - Built-In"
10 => "Hood Fan"
11 => "Window Coverings"
12 => "Garage door opener"
13 => "Garage door opener remote(s)"
14 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T19:09:52.050938+00:00"
+"Directions": "Cross Streets: Lexington Road and Lee Ave. ** Directions: Lee Ave to Green Acres to Old Stone."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2211703"
+"ListOfficeKey": "296481"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "125.2 x 132.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-04T17:21:25Z"
+"PhotosCount": 47
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-04T17:21:25Z"
+"Stories": "1.0"
+"StreetName": "Old Stone"
+"StreetNumber": "345"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "9039.77"
+"VirtualTourURLUnbranded": "https://youriguide.com/345_old_stone_road_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29854251/345-old-stone-road-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 125.2
+"OriginalEntryTimestamp": "2026-06-04T17:13:02.9Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1457628"
+"ListOfficeNationalAssociationId": "1470796"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29854251')"
+"ID": "1496013"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25147
+post_id: "1493409"
+post_author: 1
+"ListingKey": "29851946"
+"ListingId": "40836587"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T20:30:52Z"
+"RFModificationTimestamp": "2026-06-06T20:47:37Z"
+"ListPrice": 475000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1245.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2C1"
+"UnparsedAddress": "279 SANDOWNE Drive Unit# 32, Waterloo, Ontario N2K2C1"
+"Coordinates": array:2 [
0 => -80.5048607
1 => 43.4910648
]
+"Latitude": 43.4910648
+"Longitude": -80.5048607
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautifully updated 3 bdrm, 2 bath townhouse in desirable Waterloo location. Just steps to Sandowne public school, the location is ideal for a young family, first-time buyer or investor. The main level features a nicely appointed kitchen with appliances included, a dining area, and a spacious living room. There is also a powder room on the main level with a convenient pocket door. Upstairs, you’ll find the modernized bathroom with gorgeous tile shower and vanity. Each bedroom is generously sized and the updated wooden stairs and railings add a modern look and feel to the home. The main living area on all floors is carpet free. The finished basement provides extra living space with a large rec room with new flooring, plenty of storage, laundry area and a rough-in for a bathroom. Step outside to enjoy your private patio and the convenient carport. This move-in ready home is in a well-established, family-friendly neighbourhood, and only minutes away from schools, parks, shopping and everyday amenities. It is close to Conestoga Mall, nearby restaurants, transit routes, and major roadways. This home has it all, from the remodeled main bathroom, updated kitchen, luxury vinyl flooring, modern stairs, nest thermostat, heat pump & furnace (2024), California stucco ceilings, and neutral décor throughout. In addition, the Condo Corp maintains the building and grounds exceptionally well with recent updates including; newer roof, concrete walkways, basement windows, eavestroughs and more. Additional parking is available at no charge and is only steps away. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"AssociationFee": "540"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T14:36:03.246715+00:00"
+"Directions": "Lexington to Dunvegan to Sandowne"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1672317"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Carport"
1 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-04T13:21:24Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T20:20:30Z"
+"Stories": "2.0"
+"StreetName": "SANDOWNE"
+"StreetNumber": "279"
+"StreetSuffix": "Drive"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "2758"
+"VirtualTourURLUnbranded": "https://youriguide.com/32_279_sandowne_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29851946/279-sandowne-drive-unit-32-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1245
+"OriginalEntryTimestamp": "2026-06-04T13:20:00.45Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1170621"
+"ListOfficeNationalAssociationId": "1004387"
+"Media": array:43 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29851946')"
+"ID": "1493409"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25151
+post_id: "1493217"
+post_author: 1
+"ListingKey": "29851806"
+"ListingId": "X13238464"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T15:40:55Z"
+"RFModificationTimestamp": "2026-06-05T15:47:28Z"
+"ListPrice": 1146555.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0E7"
+"UnparsedAddress": "121 STEEPLECHASE WAY, Waterloo, Ontario N2K0E7"
+"Coordinates": array:2 [
0 => -80.484853
1 => 43.498109
]
+"Latitude": 43.498109
+"Longitude": -80.484853
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 121 Steeplechase Way, Waterloo - a rare opportunity to own one of the most desirable homes currently available for SALE in the city !!!!! Nestled on a premium ravine lot backing onto protected green space and scenic walking trails, this exceptional property offers privacy, nature, and income potential all in one.This beautifully upgraded home features over 3,000 sq. ft. of finished living space, including a legal walkout basement apartment currently generating approximately $2,000/month in rental income, making it an ideal mortgage helper or perfect setup for multi-generational living.The bright and spacious main residence offers 4 generous bedrooms, 3 upgraded bathrooms, elegant living and family rooms, a modern kitchen, second-floor laundry, and abundant natural light throughout. Enjoy breathtaking views of the protected greenspace from the large deck, perfect for entertaining family and friends or summer BBQs.The fully finished legal walkout basement features 2 spacious bedrooms, a modern kitchen, a stylish 3-piece bathroom, and a separate entrance, providing excellent rental income potential.Additional highlights include a double-car garage, ample driveway parking, pot lights throughout, modern finishes, and a quiet family-friendly neighborhood.Located in the highly sought-after Kiwanis Park area, close to the Grand River, walking trails, parks, top-rated schools, Grey Silo Golf Club, Conestoga Mall, and both the University of Waterloo and Wilfrid Laurier University. Waterloo is recognized as one of Canada's most educated and innovative cities, making this location highly desirable for families and investors alike.A truly one-of-a-kind offering combining a premium ravine lot, legal walkout income suite, spacious family living, and an unbeatable location. Properties with this combination of features rarely become available. Book your private showing today! (id:62650)"
+"Appliances": array:1 [
0 => "Garage door opener remote(s)"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T13:42:08.759204+00:00"
+"Directions": "UNIVERSITY AVE/WOOLWICH ST/ FALCONRIDGE DR"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Vinyl siding"
]
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2063724"
+"ListOfficeKey": "277986"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Backs on greenbelt"
]
+"LotSizeDimensions": "36.1 x 98.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-04T12:46:27Z"
+"PhotosCount": 23
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T15:32:00Z"
+"Stories": "2.0"
+"StreetName": "Steeplechase"
+"StreetNumber": "121"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "6836"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29851806/121-steeplechase-way-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 36.1
+"OriginalEntryTimestamp": "2026-06-04T12:46:27.38Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1338711"
+"ListOfficeNationalAssociationId": "1287892"
+"Media": array:23 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29851806')"
+"ID": "1493217"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25149
+post_id: "1492205"
+post_author: 1
+"ListingKey": "29850552"
+"ListingId": "40835076"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-04T21:21:10Z"
+"RFModificationTimestamp": "2026-06-04T21:41:59Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2226.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4C2"
+"UnparsedAddress": "644 YARMOUTH Drive, Waterloo, Ontario N2K4C2"
+"Coordinates": array:2 [
0 => -80.4980853
1 => 43.5099308
]
+"Latitude": 43.5099308
+"Longitude": -80.4980853
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "It isn't every day that you find an East Coast-inspired home with a backyard that's every bit as charming as the front porch. This is a home filled with inviting spaces that encourage you to slow down, relax, and enjoy life's quieter moments. Inside, the bright, open layout feels surprisingly spacious, with large windows that fill the home with natural light and create a warm, welcoming atmosphere. Some of the most stunning features include the hardwood and ceramic tile floors, the two matte-black gas fireplaces, and the beautiful, creamy quartz countertops paired with a soft subway backsplash. Finished on all three levels with three generous bedrooms and three bathrooms, this is a home you can move into and immediately begin enjoying. Located in the highly sought-after Eastbridge neighbourhood, you'll appreciate being within a short walking distance of both Catholic and public schools, while also being minutes from RIM Park, Browns Socialhouse, Grey Silo Golf Course, and convenient expressway access. From sunny reading corners to peaceful places to unwind at the end of the day, this home simply feels good to be in. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T00:49:12.108870+00:00"
+"Directions": "Eastbridge"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1878823"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Country residential"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-04T14:00:44Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-04T21:09:57Z"
+"Stories": "2.0"
+"StreetName": "YARMOUTH"
+"StreetNumber": "644"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "5425"
+"VirtualTourURLUnbranded": "https://youtu.be/EjB3iZm_x-k"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29850552/644-yarmouth-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 37.0
+"AboveGradeFinishedArea": 1612
+"BelowGradeFinishedArea": 614
+"OriginalEntryTimestamp": "2026-06-03T23:31:16.94Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1205262"
+"ListOfficeNationalAssociationId": "1473831"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29850552')"
+"ID": "1492205"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25144
+post_id: "1491078"
+post_author: 1
+"ListingKey": "29849472"
+"ListingId": "40835098"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-03T21:20:21Z"
+"RFModificationTimestamp": "2026-06-03T21:39:54Z"
+"ListPrice": 2180000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 4477.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K1Z2"
+"UnparsedAddress": "345 OLD STONE Road, Waterloo, Ontario N2K1Z2"
+"Coordinates": array:2 [
0 => -80.5117631
1 => 43.5018605
]
+"Latitude": 43.5018605
+"Longitude": -80.5117631
+"YearBuilt": 1970
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to an extraordinary Colonial Acres bungalow, offering over 4,000 sq. ft. of finished living space on a breathtaking 0.376-acre park-like lot. Combining luxury, comfort, and resort-style outdoor living, this exceptional property is a rare opportunity in one of Waterloo's most sought-after neighbourhoods. From the moment you arrive, you'll be impressed by the outstanding curb appeal, featuring an oversized double-car garage and an expansive driveway with parking for six or more vehicles. The beautifully landscaped grounds create a private backyard retreat complete with a stunning inground concrete pool,hot tub, and multiple outdoor entertaining spaces designed for relaxation and memorable gatherings. Inside, the thoughtfully designed open-concept main floor is highlighted by a dramatic two-sided stone gas fireplace that serves as the heart of the home. The custom gourmet kitchen is a chef's dream, showcasing premium appliances, a gas cooktop, built-in convection oven and microwave, wine fridge, oversized island, and peninsula seating—perfect for both everyday living and entertaining. The main level features three spacious bedrooms, including a generous primary retreat, along with a beautifully appointed main bathroom featuring a double-sink vanity, glass shower, and luxurious soaker tub. A separate front entrance leads to a functional mudroom and laundry area, complemented by a stylish powder room with a custom live-edge vanity. The finished lower level extends the home's impressive living space with a large family room featuring a cozy gas stove, two oversized bedrooms, a full bathroom, and a versatile office/library complete with custom built-in shelving. Offering the perfect blend of luxury and convenience, this private urban oasis is ideally located just minutes from the expressway, shopping, golf courses, parks, and everyday amenities. Experience resort-style living without ever leaving the city. (id:62783)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Wine Fridge"
6 => "Stove"
7 => "Dryer"
8 => "Oven - Built-In"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
12 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-03T21:39:10.964739+00:00"
+"Directions": "Lee Avenue to Green Acres and turn left on Old Stone Road"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1688209"
+"ListOfficeKey": "296447"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-03T21:10:33Z"
+"PhotosCount": 49
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-03T21:10:33Z"
+"Stories": "1.0"
+"StreetName": "OLD STONE"
+"StreetNumber": "345"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "9039.77"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/345_old_stone_road_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29849472/345-old-stone-road-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2099327"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283397"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 125.0
+"AboveGradeFinishedArea": 2255
+"BelowGradeFinishedArea": 2222
+"OriginalEntryTimestamp": "2026-06-03T21:10:32.88Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1173922"
+"ListOfficeNationalAssociationId": "1458684"
+"CoListAgentNationalAssociationId": "1369514"
+"CoListOfficeNationalAssociationId": "1328541"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29849472')"
+"ID": "1491078"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23345
+post_id: "1488653"
+post_author: 1
+"ListingKey": "29846452"
+"ListingId": "X13233780"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T20:55:59Z"
+"RFModificationTimestamp": "2026-06-05T21:00:04Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4Y7"
+"UnparsedAddress": "264 HOLBEACH COURT, Waterloo, Ontario N2J4Y7"
+"Coordinates": array:2 [
0 => -80.518448
1 => 43.490365
]
+"Latitude": 43.490365
+"Longitude": -80.518448
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "***Welcome To 264 Holbeach Court*** Detached Home In A Family-Friendly Neighbourhood, Situated On A Cul-De-Sac. Beautifully Maintained Home Featuring A Double Car Garage With No Sidewalk, Providing Ample Parking Space. This Bright And Spacious Property Offers A Modern Kitchen With Quartz Countertops, A Separate Side Entrance To The Basement, And An Abundance Of Natural Light Throughout. Enjoy A Fully Fenced Backyard Complete With A Spacious Wooden Deck - Perfect For Outdoor Entertaining . The Upper Floor Features A Generous Family Room With Vaulted Ceilings, A Circular Window, And A Gas Fireplace, Alongside A Spacious Primary Bedroom With Ample Closet Space And A Three-Piece Ensuite, Plus Two Additional Well-Sized Bedrooms And A Second Full Bathroom. The Fully Finished Basement Expands The Living Space, Featuring Two Versatile Rooms And A Modern Three-Piece Bathroom. A Rough-In For A Second Washer And Dryer Is Also Available, Offering Added Convenience And Flexibility. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Stove"
5 => "Range"
6 => "Dryer"
7 => "Microwave"
8 => "Blinds"
9 => "Window Coverings"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-03T16:35:17.429772+00:00"
+"Directions": "Lexington Rd & Dearborn Blvd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Laminate"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1996457"
+"ListOfficeKey": "49949"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Carpet Free"
2 => "Gazebo"
3 => "Sump Pump"
]
+"LotSizeDimensions": "50.4 x 118.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-03T15:57:09Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T20:49:57Z"
+"Stories": "2.0"
+"StreetName": "Holbeach"
+"StreetNumber": "264"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "5102.74"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"View": "View"
+"VirtualTourURLUnbranded": "https://realfeedsolutions.com/vtour/264HolbeachCt/index_.php"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29846452/264-holbeach-court-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Canopy"
1 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 50.4
+"OriginalEntryTimestamp": "2026-06-03T15:57:09.49Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1279172"
+"ListOfficeNationalAssociationId": "1113045"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29846452')"
+"ID": "1488653"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25152
+post_id: "1485148"
+post_author: 1
+"ListingKey": "29840553"
+"ListingId": "40835791"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T20:30:48Z"
+"RFModificationTimestamp": "2026-06-06T20:47:50Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2262.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3S1"
+"UnparsedAddress": "60 MAYFIELD Avenue, Waterloo, Ontario N2J3S1"
+"Coordinates": array:2 [
0 => -80.5020119
1 => 43.4782336
]
+"Latitude": 43.4782336
+"Longitude": -80.5020119
+"YearBuilt": 1981
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This charming 2+2 bed raised bungalow in Lincoln Heights is perfect for environmentally aware buyers. The fully owned roof-top solar installation brings in $5500 in revenue each year until 2031. A panel upgrade in 2014 allows for not one, but two car chargers! Inside the home you'll find a fully renoed open concept main floor. The kitchen has a centre island, induction range and a walkout to the deck. The master bedroom is truly spacious with a good sized closet and a walk out to the back yard as well. Downstairs you'll find a second full bath, a rec-room and two more bedrooms. There's also an extra bonus space that you can do up as you choose. The backyard is a quiet oasis filled with mature trees. Enjoy the backyard deck and get your veggies from the planter boxes too. His and hers sheds complete the outside space. The larger of the two is fully insulated, heated, and even has power. The roof has 40 year shingles and most of the windows were replaced in 2015. Nearby you'll find great local schools and plenty of shopping. The expressway a minute away making commuting a breeze. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Water softener"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-02T18:20:03.165942+00:00"
+"Directions": "Off Bluevale, via Bridgeport or direct via University"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1985202"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
2 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-02T17:21:27Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T20:21:11Z"
+"Stories": "1.0"
+"StreetName": "MAYFIELD"
+"StreetNumber": "60"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "5657.42"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/60_mayfield_avenue_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29840553/60-mayfield-avenue-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1273
+"BelowGradeFinishedArea": 989
+"OriginalEntryTimestamp": "2026-06-02T17:21:27.54Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1269822"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29840553')"
+"ID": "1485148"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25153
+post_id: "1481800"
+post_author: 1
+"ListingKey": "29836433"
+"ListingId": "X13224894"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-04T17:36:30Z"
+"RFModificationTimestamp": "2026-06-04T17:42:04Z"
+"ListPrice": 1099000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2J9"
+"UnparsedAddress": "359 LEXINGTON ROAD, Waterloo, Ontario N2K2J9"
+"Coordinates": array:2 [
0 => -80.5032142
1 => 43.4989006
]
+"Latitude": 43.4989006
+"Longitude": -80.5032142
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to the home that makes every day feel like a vacation. This meticulously maintained 2-storey family home offers beautifully finished living space across three levels, combining timeless character, thoughtful updates, and an incredible backyard retreat that will have you rethinking summer getaways. The spacious kitchen features an oversized island with seating, abundant cabinetry, and generous prep space that is perfect for hosting family gatherings, holiday celebrations. Large windows throughout fill the home with natural light, creating warm and inviting spaces. With 4 bedrooms and 4 bathrooms, there is room for the entire family to spread out. The recently renovated main bathroom offers a spa-like experience with a luxurious deep soaker tub and skylight to let in the sunshine. The fully finished basement provides exceptional flexibility with additional living space and recreation areas ideal for teens, guests, multi-generational living, or work from home. Step outside and discover what truly sets this property apart. The private backyard oasis features a luxurious heated in ground fiberglass pool surrounded by expansive patio space and mature landscaping. Whether you're entertaining guests, enjoying family time, or simply unwinding after work, this outdoor retreat delivers resort-style living right at home. Additional highlights include a durable steel roof, recently upgraded gas fireplace, double-car garage, parking for six vehicles, abundant storage throughout, and pride of ownership evident in every corner of the property. Every update has been thoughtfully completed, creating a home that is move-in ready and designed to be enjoyed for years to come. Located close to schools, parks, shopping, and everyday amenities, this is more than a home-it's a lifestyle. Don't miss your opportunity to own this exceptional family home, where unforgettable summers, effortless entertaining, and everyday comfort come together in one remarkable property. (id:62650)"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-01T22:54:37.535361+00:00"
+"Directions": "Lexington Rd/Bridge St W"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1474342"
+"ListOfficeKey": "299885"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "65.6 x 148.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-01T21:55:33Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-04T17:21:02Z"
+"Stories": "2.0"
+"StreetName": "Lexington"
+"StreetNumber": "359"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6473.8"
+"VirtualTourURLUnbranded": "https://estate-shutter-portal.aryeo.com/videos/019e8357-4852-731f-b030-a69f8bc38f7c?v=362"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29836433/359-lexington-road-waterloo"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2185334"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299885"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 65.7
+"OriginalEntryTimestamp": "2026-06-01T21:55:33.75Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1129773"
+"ListOfficeNationalAssociationId": "1478640"
+"CoListAgentNationalAssociationId": "1435541"
+"CoListOfficeNationalAssociationId": "1478640"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29836433')"
+"ID": "1481800"
}
]
+success: true
+page_size: 9
+page_count: 11
+count: 97
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]