array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29851806 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: "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 [
"Order" => 1
"MediaKey" => "29851806_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/37d0cd15411a49c41a210c9e7a800b39.webp"
"MediaSize" => 265998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-37d0cd15411a49c41a210c9e7a800b39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29851806_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/2080a5dfa4f3ded74babffc0e598c142.webp"
"MediaSize" => 286736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-2080a5dfa4f3ded74babffc0e598c142.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29851806_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/ff60da9a4e79db2a556417be9143cc5e.webp"
"MediaSize" => 167455
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-ff60da9a4e79db2a556417be9143cc5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29851806_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/079d86e9f68c9021c0c692528d613db6.webp"
"MediaSize" => 171311
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-079d86e9f68c9021c0c692528d613db6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29851806_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/b9fa59dd989718c1d6e68c90431e8e82.webp"
"MediaSize" => 131526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-b9fa59dd989718c1d6e68c90431e8e82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29851806_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/92ab5bf87562bf6db2e25e519b31ab47.webp"
"MediaSize" => 196007
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-92ab5bf87562bf6db2e25e519b31ab47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29851806_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/22f73586ab91593e4f1fb6529a0a9175.webp"
"MediaSize" => 157201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-22f73586ab91593e4f1fb6529a0a9175.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29851806_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/c320a622ab4c6ba8d68f55f3958cd8ca.webp"
"MediaSize" => 281829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-c320a622ab4c6ba8d68f55f3958cd8ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29851806_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/d25fbd5b77c91b4de2715ee5e5909963.webp"
"MediaSize" => 193071
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-d25fbd5b77c91b4de2715ee5e5909963.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29851806_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/856466d0086e7dc4941db27028dbf9cd.webp"
"MediaSize" => 152117
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-856466d0086e7dc4941db27028dbf9cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29851806_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/5731de0487a9cbb7aba0fb3d756182f5.webp"
"MediaSize" => 158928
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-5731de0487a9cbb7aba0fb3d756182f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29851806_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/a18cfa36a1224a4e3c9f04f0e76de63a.webp"
"MediaSize" => 93774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-a18cfa36a1224a4e3c9f04f0e76de63a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29851806_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/02ac5cb1ea8b26ab1fdec075487f447a.webp"
"MediaSize" => 212535
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-02ac5cb1ea8b26ab1fdec075487f447a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29851806_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/a63ea59b253dbe05e380231f3b3028ba.webp"
"MediaSize" => 224872
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-a63ea59b253dbe05e380231f3b3028ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29851806_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/d4a6a190a1dbafee5282eec64d414cdd.webp"
"MediaSize" => 396122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-d4a6a190a1dbafee5282eec64d414cdd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29851806_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/01a0f82d29c89ae96319f00b1b916228.webp"
"MediaSize" => 243996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-01a0f82d29c89ae96319f00b1b916228.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29851806_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/e6f94d0d2003580f240b6fa2ab338573.webp"
"MediaSize" => 173450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-e6f94d0d2003580f240b6fa2ab338573.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29851806_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/edbf37184feebb163faf17d5d4edd950.webp"
"MediaSize" => 133601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-edbf37184feebb163faf17d5d4edd950.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29851806_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/be84325fed12780dd3601df6cefdf2db.webp"
"MediaSize" => 144225
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-be84325fed12780dd3601df6cefdf2db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29851806_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/19f87c7f79cde1abd26a515cb14c43c9.webp"
"MediaSize" => 111219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-19f87c7f79cde1abd26a515cb14c43c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29851806_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/dfe392ee5ce4df0cdcc4bac9d61448bc.webp"
"MediaSize" => 199307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-dfe392ee5ce4df0cdcc4bac9d61448bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29851806_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/f22ae3c9918b9c3ea29e0b1a98a77792.webp"
"MediaSize" => 117766
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-f22ae3c9918b9c3ea29e0b1a98a77792.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29851806_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851806/5afe29c55cdd7c3aa4d36c82b653e486.webp"
"MediaSize" => 333615
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851806/thumbnail-5afe29c55cdd7c3aa4d36c82b653e486.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13238464"
"ResourceRecordKey" => "29851806"
"ModificationTimestamp" => "2026-06-04T12:46:27.39Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29851806')"
+"ID": "1493217"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 277986" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24654
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2063724" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24739
+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 '29851806'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25042
+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 '29851806'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25060
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25058
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31330396"
+"ListingKey": "29851806"
+"ListingId": "X13238464"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-06"
+"OpenHouseStartTime": "2026-06-06T14:00:00Z"
+"OpenHouseEndTime": "2026-06-06T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-07T00:48:46Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31330396')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29851806' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.484853 43.498109)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25078
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25072
+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
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29859294_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/3492642f794e923ad86ddeddd02d62da.webp"
"MediaSize" => 63089
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-3492642f794e923ad86ddeddd02d62da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29859294_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/5e44c8c4cf53887bd2b778b98657f8a7.webp"
"MediaSize" => 51030
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-5e44c8c4cf53887bd2b778b98657f8a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29859294_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/14a8bd469c7e46c273f6819994e72a5f.webp"
"MediaSize" => 57492
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-14a8bd469c7e46c273f6819994e72a5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29859294_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/05d47e9fa8e2442e6f6f54503312d03e.webp"
"MediaSize" => 58000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-05d47e9fa8e2442e6f6f54503312d03e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29859294_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/0aec3fdbc6e5bef107d9344999b5f724.webp"
"MediaSize" => 33550
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-0aec3fdbc6e5bef107d9344999b5f724.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29859294_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/8cf5834fb02a928cbb6a6e77c51c8e81.webp"
"MediaSize" => 27376
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-8cf5834fb02a928cbb6a6e77c51c8e81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29859294_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/f04a4cdfde5efd2cfc489a004a68276a.webp"
"MediaSize" => 56494
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-f04a4cdfde5efd2cfc489a004a68276a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29859294_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/0628448e814327310235203ef41e2eaa.webp"
"MediaSize" => 42075
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-0628448e814327310235203ef41e2eaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29859294_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/bd7f91e4cb22fb567d7821fbbdde1dd5.webp"
"MediaSize" => 29636
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-bd7f91e4cb22fb567d7821fbbdde1dd5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29859294_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/6d929da784b816ea33aeec2964a230f1.webp"
"MediaSize" => 61238
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-6d929da784b816ea33aeec2964a230f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29859294_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/c9a94b607d2bf8cc4a87c0c522bd4403.webp"
"MediaSize" => 54368
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-c9a94b607d2bf8cc4a87c0c522bd4403.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29859294_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/3559ac8a947cc35f9ad72d8f2ce93e99.webp"
"MediaSize" => 45197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-3559ac8a947cc35f9ad72d8f2ce93e99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29859294_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/8f21a7af7a438c191f10efbfb0fa32f2.webp"
"MediaSize" => 49477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-8f21a7af7a438c191f10efbfb0fa32f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29859294_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/e7b0faf01090ac7b1f76115dec15244b.webp"
"MediaSize" => 50350
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-e7b0faf01090ac7b1f76115dec15244b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29859294_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/c166516f7d0901442a4144397f8081cf.webp"
"MediaSize" => 94810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-c166516f7d0901442a4144397f8081cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29859294_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/95c5698f76e3e57cdbee79cafbe40692.webp"
"MediaSize" => 153966
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-95c5698f76e3e57cdbee79cafbe40692.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29859294_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/29b61535fcd63f68a4c0e5b5212c587e.webp"
"MediaSize" => 159019
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-29b61535fcd63f68a4c0e5b5212c587e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29859294_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/1ba7da3d9ff2bcc3ec0b9614c11acf1c.webp"
"MediaSize" => 137821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-1ba7da3d9ff2bcc3ec0b9614c11acf1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29859294_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/014a951a98331963b6089a4957085c09.webp"
"MediaSize" => 141973
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-014a951a98331963b6089a4957085c09.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29859294_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/f5f1d1bb9000062bdd44da41f0c2c60c.webp"
"MediaSize" => 178304
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-f5f1d1bb9000062bdd44da41f0c2c60c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29859294_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/c849a75cfab1a868839964184882f194.webp"
"MediaSize" => 203048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-c849a75cfab1a868839964184882f194.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837079"
"ResourceRecordKey" => "29859294"
"ModificationTimestamp" => "2026-06-05T14:20:05.69Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29859294_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859294/e662f754dc61504086a6454f63b8609d.webp"
"MediaSize" => 195675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859294/thumbnail-e662f754dc61504086a6454f63b8609d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
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 {#25074
+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"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25071
+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"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25075
+post_id: "1492494"
+post_author: 1
+"ListingKey": "29850354"
+"ListingId": "40830528"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T20:30:51Z"
+"RFModificationTimestamp": "2026-06-06T20:47:37Z"
+"ListPrice": 749000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1880.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4M2"
+"UnparsedAddress": "610 SOUTH HAVEN Drive, Waterloo, Ontario N2K4M2"
+"Coordinates": array:2 [
0 => -80.5000252
1 => 43.5120868
]
+"Latitude": 43.5120868
+"Longitude": -80.5000252
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this exceptional home in the highly sought-after Eastridge community! This move-in ready 2-storey detached home offers 3 spacious bedrooms and 3 bathrooms, ideally located within walking distance to schools and close to charming neighbourhood parks. Backing onto Rim Park and the Grand River, this property provides a rare combination of convenience, privacy, and natural beauty. Recently renovated throughout, the home features brand-new waterproof flooring, fresh designer paint, and numerous modern light fixtures that create a bright and contemporary living environment. The main floor living room is enhanced with abundant pot lights, providing excellent illumination and a warm, inviting atmosphere. The kitchen is equipped with a brand-new refrigerator, adding both style and functionality. Upstairs, a separate family room with a cozy fireplace offers an ideal private retreat for family gatherings, entertainment, or relaxation. The spacious primary bedroom features its own ensuite bathroom, creating a comfortable and private sanctuary. Step outside to enjoy the large backyard deck, perfect for outdoor dining, entertaining, or simply unwinding while enjoying the peaceful surroundings. A beautifully updated home in an unbeatable location—don't miss this incredible opportunity! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Dryer"
5 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-03T23:21:53.555716+00:00"
+"Directions": "Shediac"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2073939"
+"ListOfficeKey": "253316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-03T22:50:39Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T20:23:22Z"
+"Stories": "2.0"
+"StreetName": "SOUTH HAVEN"
+"StreetNumber": "610"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "4891"
+"VirtualTourURLUnbranded": "https://youtu.be/EeMRCR1OF9M"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29850354/610-south-haven-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1880
+"OriginalEntryTimestamp": "2026-06-03T22:50:38.81Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1349103"
+"ListOfficeNationalAssociationId": "1223329"
+"Media": array:31 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29850354')"
+"ID": "1492494"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25073
+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 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29840917')"
+"ID": "1485217"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25068
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23345
+post_id: "1477680"
+post_author: 1
+"ListingKey": "29829690"
+"ListingId": "X13218416"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-30T19:50:24Z"
+"RFModificationTimestamp": "2026-05-30T20:05:52Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H4"
+"UnparsedAddress": "47 - 311 WOOLWICH STREET, Waterloo, Ontario N2K0H4"
+"Coordinates": array:2 [
0 => -80.481759
1 => 43.497163
]
+"Latitude": 43.497163
+"Longitude": -80.481759
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 311 Woolwich Street, a beautifully upgraded 3-bedroom, 2.5-bathroom townhouse located in one of Waterloo's most desirable neighborhoods. Only four years old, this impressive three-story home offers modern design, quality finishes, and a well-planned layout ideal for families, professionals, or investors. The open-concept kitchen seamlessly connects to the dining and living areas, creating a warm and inviting space perfect for everyday living and entertaining. The home features beautiful west-facing views overlooking a peaceful buffer conservation area, allowing you to enjoy privacy, nature, and stunning sunsets. A spacious private deck provides the perfect setting for summer BBQs and gatherings with family and friends. This property also includes a single-car garage along with plenty of visitor parking, offering convenience for both homeowners and guests. The location is truly unbeatable, just minutes from the University of Waterloo, T&T Supermarket, Conestoga Mall, and a wide variety of restaurants, cafés, and major retailers including Indigo, Home Depot, Best Buy, and Galaxy Cinema. Nature lovers will appreciate the proximity to several parks and trails including Kiwanis Park, Falconridge Natural Area, Meltzer Woodlot Trail, River Ridge Park, and nearby volleyball courts, offering plenty of outdoor recreation options. Whether you are looking for a stylish and functional home or a great investment opportunity in a rapidly growing community, 311 Woolwich Street offers the perfect combination of location, comfort, and value. Don't miss this exceptional opportunity-book your private showing today. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
]
+"AssociationFee": "442.9"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-30T20:05:45.262774+00:00"
+"Directions": "Cross Streets: Falconridge Dr. ** Directions: From University Ave turn to Woolwich St, after enter to the condominium then find the unit 40."
+"ExteriorFeatures": array:1 [
0 => "Brick Facing"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1746935"
+"ListOfficeKey": "289187"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-30T19:42:01Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-30T19:42:01Z"
+"Stories": "3.0"
+"StreetName": "Woolwich"
+"StreetNumber": "311"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5014"
+"VirtualTourURLUnbranded": "http://hdvirtualtours.ca/47-311-woolwich-st-waterloo/mls/"
+"Rooms": array:8 [
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]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29829690/47-311-woolwich-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1999
+"LivingAreaMinimum": 1800
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-05-30T19:42:01.28Z"
+"ListAgentNationalAssociationId": "1180620"
+"ListOfficeNationalAssociationId": "1375388"
+"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": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29829690')"
+"ID": "1477680"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25076
+post_id: "1475863"
+post_author: 1
+"ListingKey": "29827496"
+"ListingId": "X13216608"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T20:20:47Z"
+"RFModificationTimestamp": "2026-06-02T20:29:50Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2L7"
+"UnparsedAddress": "A - 432 LEE AVENUE, Waterloo, Ontario N2K2L7"
+"Coordinates": array:2 [
0 => -80.506207
1 => 43.496701
]
+"Latitude": 43.496701
+"Longitude": -80.506207
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Versatile family home in Waterloo's desirable Lincoln Village! This well-maintained and move-in ready home features plenty of modern updates, including new hardwood flooring, new carpet, and fresh paint throughout. The bright and spacious main floor is enhanced by stylish pot lights. The updated kitchen delights with gleaming quartz countertops, stainless steel appliances, a breakfast bar, and an abundance of storage. The spacious primary bedroom provides a comfortable retreat, while the updated 4-piece family bath adds style and functionality. A convenient side entrance offers added flexibility for families, along with future possibilities. Step outside and enjoy a private backyard, complete with a huge deck and gazebo that's perfect for entertaining and relaxing outdoors. Additional updates include newer windows and a roof completed in 2025. Parking for 4 vehicles. This sought-after East Waterloo location is close to schools, parks, shopping and amenities. An exceptional opportunity for families, first-time buyers, or investors alike! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
]
+"Basement": array:1 [
0 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-29T22:29:33.683966+00:00"
+"Directions": "Cross Streets: Lexington Rd. ** Directions: Lexington Rd. Onto Lee Ave."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100955"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "30.1 x 101.2 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-05-29T21:48:22Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T20:15:00Z"
+"Stories": "2.0"
+"StreetName": "Lee"
+"StreetNumber": "432"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3233"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/a_432_lee_avenue_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29827496/a-432-lee-avenue-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 30.1
+"OriginalEntryTimestamp": "2026-05-29T21:48:22.3Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1370979"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:40 [
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]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29827496')"
+"ID": "1475863"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25077
+post_id: "1475347"
+post_author: 1
+"ListingKey": "29827113"
+"ListingId": "40833783"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T19:25:56Z"
+"RFModificationTimestamp": "2026-06-06T19:30:38Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.07
+"LivingArea": 1708.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2L7"
+"UnparsedAddress": "432 LEE Avenue Unit# A, Waterloo, Ontario N2K2L7"
+"Coordinates": array:2 [
0 => -80.5061356
1 => 43.4965054
]
+"Latitude": 43.4965054
+"Longitude": -80.5061356
+"YearBuilt": 1976
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Versatile family home in Waterloo's desirable Lincoln Village! This well-maintained and move-in ready home features plenty of modern updates, including new hardwood flooring, new carpet, and fresh paint throughout. The bright and spacious main floor is enhanced by stylish pot lights. The updated kitchen delights with gleaming quartz countertops, stainless steel appliances, a breakfast bar, and an abundance of storage. The spacious primary bedroom provides a comfortable retreat, while the updated 4-piece family bath adds style and functionality. A convenient side entrance offers added flexibility for families, along with future possibilities. Step outside and enjoy a private backyard, complete with a huge deck and gazebo that's perfect for entertaining and relaxing outdoors. Additional updates include newer windows and a roof completed in 2025. Parking for 4 vehicles. This sought-after East Waterloo location is close to schools, parks, shopping and amenities. An exceptional opportunity for families, first-time buyers, or investors alike! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-29T21:42:02.197275+00:00"
+"Directions": "Lexington Rd. Onto Lee Ave."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564479"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0.07"
+"PhotosChangeTimestamp": "2026-05-29T21:10:07Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T19:19:55Z"
+"Stories": "2.0"
+"StreetName": "LEE"
+"StreetNumber": "432"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "3233"
+"VirtualTourURLUnbranded": "https://youriguide.com/a_432_lee_avenue_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29827113/432-lee-avenue-unit-a-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1308
+"BelowGradeFinishedArea": 400
+"OriginalEntryTimestamp": "2026-05-29T21:10:07.24Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1125580"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:40 [
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]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29827113')"
+"ID": "1475347"
}
]
+success: true
+page_size: 9
+page_count: 7
+count: 62
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]