array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29867875 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23335
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23337
+post_id: "1505055"
+post_author: 1
+"ListingKey": "29867875"
+"ListingId": "X13412402"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-07T21:55:59Z"
+"RFModificationTimestamp": "2026-06-07T22:34:33Z"
+"ListPrice": 419990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "708 - 450 DUNDAS STREET, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.880553
1 => 43.342598
]
+"Latitude": 43.342598
+"Longitude": -79.880553
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning 1 + 1 bedroom, 1 bathroom condo by the award-winning New Horizon Development Group. This bright, modern unit boasts stainless steel kitchen appliances, laminate flooring throughout, in-suite laundry, 1 storage locker and 1 underground parking spot! The building offers fantastic amenities, including a gym, party room, and a rooftop patio. Conveniently located near GO Stations, major highways, shopping centers, and a variety of restaurants, this condo perfectly combines style and convenience. (id:62650)"
+"Appliances": array:2 [
0 => "Intercom"
1 => "Garage door opener remote(s)"
]
+"AssociationFee": "579.53"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"CreationDate": "2026-06-07T22:34:30.765240+00:00"
+"Directions": "Cross Streets: Riverwalk Dr. ** Directions: Mallard Trail."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092595"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Elevator"
1 => "Balcony"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-07T21:46:36Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-07T21:46:36Z"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3152.36"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1654486939"
"RoomType" => "Kitchen"
"ListingId" => "X13412402"
"RoomLevel" => "Main level"
"RoomWidth" => 2.34
"ListingKey" => "29867875"
"RoomLength" => 2.26
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T21:46:36.16Z"
]
1 => array:11 [
"RoomKey" => "1654486940"
"RoomType" => "Great room"
"ListingId" => "X13412402"
"RoomLevel" => "Main level"
"RoomWidth" => 3.17
"ListingKey" => "29867875"
"RoomLength" => 5.64
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T21:46:36.16Z"
]
2 => array:11 [
"RoomKey" => "1654486941"
"RoomType" => "Bedroom"
"ListingId" => "X13412402"
"RoomLevel" => "Main level"
"RoomWidth" => 2.95
"ListingKey" => "29867875"
"RoomLength" => 3.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T21:46:36.16Z"
]
3 => array:11 [
"RoomKey" => "1654486942"
"RoomType" => "Den"
"ListingId" => "X13412402"
"RoomLevel" => "Main level"
"RoomWidth" => 2.01
"ListingKey" => "29867875"
"RoomLength" => 2.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T21:46:36.16Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29867875/708-450-dundas-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-07T21:46:36.13Z"
+"ListAgentNationalAssociationId": "1365159"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:27 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29867875_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/e97ffc5dc3f63d12048b5459f9b39e22.webp"
"MediaSize" => 240160
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-e97ffc5dc3f63d12048b5459f9b39e22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29867875_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/dba7e306d0deb5d87750170213e6f55f.webp"
"MediaSize" => 210231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-dba7e306d0deb5d87750170213e6f55f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29867875_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/383467a02579414875ee2c77885c1816.webp"
"MediaSize" => 191956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-383467a02579414875ee2c77885c1816.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29867875_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/b0a79882b5b372402c02316562207325.webp"
"MediaSize" => 124231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-b0a79882b5b372402c02316562207325.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29867875_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/72472684b94e25edefd181c68761da27.webp"
"MediaSize" => 132863
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-72472684b94e25edefd181c68761da27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29867875_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/dbb71cf5d1d1aa17b4b2d4290ebe639c.webp"
"MediaSize" => 113390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-dbb71cf5d1d1aa17b4b2d4290ebe639c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29867875_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/25a66711b27c14b5b4cbefb1b8a0e1ad.webp"
"MediaSize" => 113996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-25a66711b27c14b5b4cbefb1b8a0e1ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29867875_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/d217978627f5f6585334697e7ef29ff3.webp"
"MediaSize" => 136816
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-d217978627f5f6585334697e7ef29ff3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29867875_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/bd9c5670e449c18dec6e1a6feb7f0479.webp"
"MediaSize" => 102109
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-bd9c5670e449c18dec6e1a6feb7f0479.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29867875_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/0b62c337b10d642205868dd77d68b598.webp"
"MediaSize" => 111005
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-0b62c337b10d642205868dd77d68b598.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29867875_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/d23e6921e9133cb00384c79e5437776e.webp"
"MediaSize" => 149004
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-d23e6921e9133cb00384c79e5437776e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29867875_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/48f8d52c8938a3bcf4af6adf205f4467.webp"
"MediaSize" => 156607
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-48f8d52c8938a3bcf4af6adf205f4467.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29867875_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/31ee05871846125b5844616aefb27278.webp"
"MediaSize" => 162933
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-31ee05871846125b5844616aefb27278.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29867875_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/021f65b7df3fc8fefea90a5d68310851.webp"
"MediaSize" => 146485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-021f65b7df3fc8fefea90a5d68310851.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29867875_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/ef3612b411c9d7adda7d49c732981e8b.webp"
"MediaSize" => 128837
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-ef3612b411c9d7adda7d49c732981e8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29867875_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/c62a0ff96affb4b0ccf0af37fe7cccea.webp"
"MediaSize" => 202578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-c62a0ff96affb4b0ccf0af37fe7cccea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29867875_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/7e81e017e657104cfcaf8c682e0bcbd6.webp"
"MediaSize" => 239244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-7e81e017e657104cfcaf8c682e0bcbd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29867875_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/3704531c1f70a55a9c17ced78259e4ff.webp"
"MediaSize" => 207223
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-3704531c1f70a55a9c17ced78259e4ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29867875_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/f626e43932eeb3e65f7dad212d9986cf.webp"
"MediaSize" => 231501
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-f626e43932eeb3e65f7dad212d9986cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29867875_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/627f6201c6fc634fd6414bce2dba02eb.webp"
"MediaSize" => 135401
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-627f6201c6fc634fd6414bce2dba02eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29867875_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/5db8ff518f7392d0792046c67afbc5e2.webp"
"MediaSize" => 110140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-5db8ff518f7392d0792046c67afbc5e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29867875_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/0affdda894e978d8961c5dc1b535b1c6.webp"
"MediaSize" => 94506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-0affdda894e978d8961c5dc1b535b1c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29867875_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/fbb09f532adc804f5c2d041a71700b4c.webp"
"MediaSize" => 122110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-fbb09f532adc804f5c2d041a71700b4c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29867875_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/498dadc5cf8f94fc8e8f667debd01bd5.webp"
"MediaSize" => 124034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-498dadc5cf8f94fc8e8f667debd01bd5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29867875_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/9422ee30747e420f1f263f24a76496dd.webp"
"MediaSize" => 110494
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-9422ee30747e420f1f263f24a76496dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29867875_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/5840cc7f1b5a266e030344cc4e398e34.webp"
"MediaSize" => 116026
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-5840cc7f1b5a266e030344cc4e398e34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29867875_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867875/9635bc9f9169b16540f0c3067cead6a3.webp"
"MediaSize" => 191643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867875/thumbnail-9635bc9f9169b16540f0c3067cead6a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13412402"
"ResourceRecordKey" => "29867875"
"ModificationTimestamp" => "2026-06-07T21:46:36.14Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29867875')"
+"ID": "1505055"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 284790" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24664
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2092595" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24749
+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 '29867875'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25056
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29867875'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24717
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29867875' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.880553 43.342598)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25090
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25084
+post_id: "1511803"
+post_author: 1
+"ListingKey": "29877414"
+"ListingId": "40835826"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T19:30:30Z"
+"RFModificationTimestamp": "2026-06-09T19:35:02Z"
+"ListPrice": 1849343.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3247.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7P0T2"
+"UnparsedAddress": "1811 OLD WATERDOWN Road, Burlington, Ontario L7P0T2"
+"Coordinates": array:2 [
0 => -79.8748565
1 => 43.3279071
]
+"Latitude": 43.3279071
+"Longitude": -79.8748565
+"YearBuilt": 1982
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome home to this stunning country property in the city! As you step inside, you're greeted by soaring vaulted ceilings & bright skylights. The sunken living room features a handpicked stone wood burning FP, with brand new broadloom and large windows. The newly designed open-concept kitchen showcases DeBoers cabinets, Cambria quartz counters, a full suite of s/s appliances. Enjoy cooking on the induction cooktop or relax at the breakfast bar. The kitchen flows effortlessly into the family room, highlighted by custom millwork, bookshelves & FP, while garden doors lead to a spacious wood deck, perfect for outdoor entertaining. Formal dining awaits in an elegant room with large windows & upgraded lighting, while the main floor laundry doubles as a convenient 2pcs washroom, featuring chic hexagon tile & cabinetry. Ascend to the 2nd flr where vaulted ceilings & skylights continue to impress. The expansive primary bedroom boasts an oversized bay window & a luxurious retreat featuring triple closets & a spa-like ensuite w/double vanity w/quartz counters, stand-up shower, soaker tub, & radiant finishes. Two additional bedrooms, each with ample natural light & storage, round out this floor, along with a beautifully appointed 3pc main bathroom.The fully finished basement offers a large recreation room, an additional bedroom w/egress window & closet and substantial storage space. An aggregate stone walkway leads from the driveway to a covered porch, while the serene backyard features a wooden deck accessible from the garden doors. The property includes a MASSIVE detached Garage/Workshop, equipped with an oil-fired furnace & HVAC distribution, underground 60 amp electrical sub-service, 2 10' high insulated garage doors, concrete epoxy floors & includes built in 10 delta Unisaw, 10 Mastercraft radial arm saw & Ingersoll-Ram T10-60 gallon air compressor. Perfect for tradesperson or car enthusiast. This residence offers both privacy and peaceful living close to everything! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Window Coverings"
5 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Other"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T19:34:48.042596+00:00"
+"Directions": "Waterdown Rd to Old Waterdown Road - follow it south"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceFeatures": array:4 [
0 => "Wood"
1 => "Electric"
2 => "Other - See remarks"
3 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1533175"
+"ListOfficeKey": "54923"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Country residential"
4 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T18:21:09Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T19:20:47Z"
+"Stories": "2.0"
+"StreetName": "OLD WATERDOWN"
+"StreetNumber": "1811"
+"StreetSuffix": "Road"
+"SubdivisionName": "302 - Aldershot Central"
+"TaxAnnualAmount": "6944.81"
+"VirtualTourURLUnbranded": "https://track.pstmrk.it/3s/listings.monstermediahouse.com%2Fsites%2F1811-old-waterdown-rd-burlington-on-l7p-0t2-25609094%2Fbranded/cUpU/1enFAQ/AQ/4ba8033d-0d7d-4b4c-a36e-c2dca737e496/2/7fVGk26W4v"
+"WaterSource": array:2 [
0 => "Cistern"
1 => "Drilled Well"
]
+"Rooms": array:17 [
0 => array:11 [
"RoomKey" => "1655810475"
"RoomType" => "Utility room"
"ListingId" => "40835826"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29877414"
"RoomLength" => null
"RoomDimensions" => "11' x 22'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:20:47.2Z"
]
1 => array:11 [
"RoomKey" => "1655810476"
"RoomType" => "Bedroom"
"ListingId" => "40835826"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29877414"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 17'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:20:47.2Z"
]
2 => array:11 [
"RoomKey" => "1655810477"
"RoomType" => "Recreation room"
"ListingId" => "40835826"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29877414"
"RoomLength" => null
"RoomDimensions" => "17'8'' x 14'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:20:47.2Z"
]
3 => array:11 [
"RoomKey" => "1655810478"
"RoomType" => "5pc Bathroom"
"ListingId" => "40835826"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29877414"
"RoomLength" => null
"RoomDimensions" => "14'11'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:20:47.2Z"
]
4 => array:11 [
"RoomKey" => "1655810479"
"RoomType" => "Primary Bedroom"
"ListingId" => "40835826"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29877414"
"RoomLength" => null
"RoomDimensions" => "14'6'' x 15'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:20:47.21Z"
]
5 => array:11 [
"RoomKey" => "1655810480"
"RoomType" => "3pc Bathroom"
"ListingId" => "40835826"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29877414"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 6'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:20:47.21Z"
]
6 => array:11 [
"RoomKey" => "1655810481"
"RoomType" => "Bedroom"
"ListingId" => "40835826"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29877414"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:20:47.21Z"
]
7 => array:11 [
"RoomKey" => "1655810482"
"RoomType" => "Bedroom"
"ListingId" => "40835826"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29877414"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:20:47.21Z"
]
8 => array:11 [
"RoomKey" => "1655810483"
"RoomType" => "2pc Bathroom"
"ListingId" => "40835826"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29877414"
"RoomLength" => null
"RoomDimensions" => "6' x 7'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:20:47.21Z"
]
9 => array:11 [
"RoomKey" => "1655810484"
"RoomType" => "Laundry room"
"ListingId" => "40835826"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29877414"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 7'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:20:47.21Z"
]
10 => array:11 [
"RoomKey" => "1655810485"
"RoomType" => "Bedroom"
"ListingId" => "40835826"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29877414"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:20:47.21Z"
]
11 => array:11 [
"RoomKey" => "1655810486"
"RoomType" => "Breakfast"
"ListingId" => "40835826"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29877414"
"RoomLength" => null
"RoomDimensions" => "13'2'' x 6'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:20:47.21Z"
]
12 => array:11 [
"RoomKey" => "1655810487"
"RoomType" => "Eat in kitchen"
"ListingId" => "40835826"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29877414"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:20:47.21Z"
]
13 => array:11 [
"RoomKey" => "1655810488"
"RoomType" => "Family room"
"ListingId" => "40835826"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29877414"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 15'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:20:47.21Z"
]
14 => array:11 [
"RoomKey" => "1655810489"
"RoomType" => "Dining room"
"ListingId" => "40835826"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29877414"
"RoomLength" => null
"RoomDimensions" => "16'8'' x 9'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:20:47.22Z"
]
15 => array:11 [
"RoomKey" => "1655810490"
"RoomType" => "Great room"
"ListingId" => "40835826"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29877414"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 18'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:20:47.22Z"
]
16 => array:11 [
"RoomKey" => "1655810491"
"RoomType" => "Foyer"
"ListingId" => "40835826"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29877414"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T19:20:47.22Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29877414/1811-old-waterdown-road-burlington"
+"ParkingTotal": 17
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1524250"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "54923"
+"GeocodeManualYN": true
+"ZoningDescription": "O3-196, RNA1-366"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 100.0
+"AboveGradeFinishedArea": 2407
+"BelowGradeFinishedArea": 840
+"OriginalEntryTimestamp": "2026-06-09T18:21:07.97Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1143027"
+"ListOfficeNationalAssociationId": "1003529"
+"CoListAgentNationalAssociationId": "1127411"
+"CoListOfficeNationalAssociationId": "1003529"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29877414_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/c0c6fe6ea8a00fde291ddf22d9712660.webp"
"MediaSize" => 177933
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-c0c6fe6ea8a00fde291ddf22d9712660.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29877414_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/a100a2dfed0116c1dffcc63a11ab87ee.webp"
"MediaSize" => 181525
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-a100a2dfed0116c1dffcc63a11ab87ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29877414_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/c749ab58bad3ab89f7a65a8f32ab298c.webp"
"MediaSize" => 195368
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-c749ab58bad3ab89f7a65a8f32ab298c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29877414_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/be4424dfcec11e6953081c6aa7385c32.webp"
"MediaSize" => 165389
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-be4424dfcec11e6953081c6aa7385c32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Garage/Workshop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29877414_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/1828c5f9903318056c7e09610bfeb27b.webp"
"MediaSize" => 180536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-1828c5f9903318056c7e09610bfeb27b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Property Maintenance Garage"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29877414_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/c820da070fcf3bc2cbefe4d0e65602e9.webp"
"MediaSize" => 152945
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-c820da070fcf3bc2cbefe4d0e65602e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29877414_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/ac00139432c5b233dcf5b36056a0d652.webp"
"MediaSize" => 118569
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-ac00139432c5b233dcf5b36056a0d652.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open concept living space featuring a natural wood staircase, wood-finish flooring, exposed beam ceiling, stone-surround fireplace, and a window with exterior tree views"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29877414_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/275dbd07b44a2efa4e0dfcc4ef602586.webp"
"MediaSize" => 113072
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-275dbd07b44a2efa4e0dfcc4ef602586.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29877414_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/1c62025c08276c1d4944b695d98a6081.webp"
"MediaSize" => 130303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-1c62025c08276c1d4944b695d98a6081.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor-to-ceiling stone fireplace with a wood mantle, vaulted wood-paneled ceiling, multiple windows with wood trim, and neutral wall paint"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29877414_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/1e339a4e50b206667c6665f3a5c254c4.webp"
"MediaSize" => 119561
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-1e339a4e50b206667c6665f3a5c254c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Vaulted wood-paneled ceilings with exposed beams and multiple skylights"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29877414_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/258d7771766fc864c83284a769e6807b.webp"
"MediaSize" => 109708
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-258d7771766fc864c83284a769e6807b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Vaulted wood-paneled ceiling with exposed beams, central chandelier, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29877414_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/ebbd30ac74cf57fe932848affd0bc88a.webp"
"MediaSize" => 121506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-ebbd30ac74cf57fe932848affd0bc88a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Vaulted wood-paneled ceiling with skylights, featuring a prominent stone fireplace with a wood mantle"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29877414_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/294f82a69a0518fad65e849957c606c6.webp"
"MediaSize" => 127150
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-294f82a69a0518fad65e849957c606c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29877414_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/89c89920cf618c3c3fc9a8629df8a178.webp"
"MediaSize" => 88680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-89c89920cf618c3c3fc9a8629df8a178.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring hardwood-finish flooring and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29877414_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/f22efb62ec8abf6194461ce3697a0470.webp"
"MediaSize" => 93127
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-f22efb62ec8abf6194461ce3697a0470.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Gourmet kitchen featuring dark wood cabinetry, granite countertops, stainless steel appliances, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29877414_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/2b8d06019c04365d481a80b45ddd5d74.webp"
"MediaSize" => 86185
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-2b8d06019c04365d481a80b45ddd5d74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring wood-finish flooring, dark wood cabinetry, light-toned countertops, tile backsplash, and stainless steel appliances"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29877414_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/2439f986fbd9895bec6748077f6371cd.webp"
"MediaSize" => 89492
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-2439f986fbd9895bec6748077f6371cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring dark wood cabinetry, light-toned countertops, a stainless steel sink, a stainless steel dishwasher, and a window overlooking greenery"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29877414_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/10bebc2e64b714d8ceb9fed19e31746b.webp"
"MediaSize" => 88231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-10bebc2e64b714d8ceb9fed19e31746b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring dark wood cabinetry, light-toned countertops, integrated cooktop, stainless steel appliances including a built-in microwave and oven, and a white subway tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29877414_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/52206f29d2bd41fc69dc6cee2945ac93.webp"
"MediaSize" => 90752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-52206f29d2bd41fc69dc6cee2945ac93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring dark wood cabinetry, light-toned countertops, hardwood flooring, an island with seating, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29877414_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/dd3117206a56c9a38d4e32eb13a0b576.webp"
"MediaSize" => 84321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-dd3117206a56c9a38d4e32eb13a0b576.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen island with a light-toned countertop, pendant lighting, built-in stainless steel appliances, dark wood-finish cabinetry, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29877414_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/c25e764fd3a4c7e6ff69eb5d45ee9441.webp"
"MediaSize" => 96609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-c25e764fd3a4c7e6ff69eb5d45ee9441.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29877414_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/6cd2256d521ae92192bd42785c72af45.webp"
"MediaSize" => 105058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-6cd2256d521ae92192bd42785c72af45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious dining area featuring wood-finish flooring and a contemporary drum pendant light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29877414_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/eebac5caae52ceeebc257346361621dd.webp"
"MediaSize" => 103304
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-eebac5caae52ceeebc257346361621dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring wood-finish flooring, a contemporary ceiling light fixture, crown molding, and a large window with natural light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29877414_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/12a33c8bf0f929d7dd1b3c65950b40e2.webp"
"MediaSize" => 81973
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-12a33c8bf0f929d7dd1b3c65950b40e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main floor bedroom/office featuring closet, hardwood flooring, extensive crown molding, recessed lighting, and multiple windows with white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29877414_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/e32a06569de8512ddae22a816acc1a6c.webp"
"MediaSize" => 60180
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29877414/thumbnail-e32a06569de8512ddae22a816acc1a6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom/Laundry area featuring stacked cabinetry, a window with a roller shade, crown molding, and tiled flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835826"
"ResourceRecordKey" => "29877414"
"ModificationTimestamp" => "2026-06-09T18:21:07.98Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29877414_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29877414/1a86ca037aa5f8e8691cd886aa4de91b.webp"
"MediaSize" => 67520
…9
]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29877414')"
+"ID": "1511803"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25086
+post_id: "1511413"
+post_author: 1
+"ListingKey": "29876660"
+"ListingId": "X13420134"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T17:00:23Z"
+"RFModificationTimestamp": "2026-06-09T19:05:13Z"
+"ListPrice": 1265000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0T7"
+"UnparsedAddress": "156 MCKNIGHT AVENUE, Hamilton (Waterdown), Ontario L8B0T7"
+"Coordinates": array:2 [
0 => -79.879152
1 => 43.340171
]
+"Latitude": 43.340171
+"Longitude": -79.879152
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 156 McKnight Ave, Waterdown. Step into a home that truly lives as beautifully as it looks. Located in one of Waterdown's most sought after neighbourhoods, this inviting property offers generous, light filled spaces designed for the way modern families actually live. The main floor impresses with large, well-proportioned primary rooms that lend themselves to easy entertaining and everyday comfort, along with a versatile bonus room, perfect as a home office, playroom, or guest space. Natural light pours throughout, creating a warm and welcoming atmosphere at every turn. Downstairs, a spacious unfinished basement presents a blank canvas ready for your vision. Whether that's a recreation room, home gym, or additional living space, the possibilities are yours to define. Outside, enjoy a fully fenced backyard, ideal for kids, pets, and summer gatherings. Set within a beautiful, established neighbourhood that checks every box. Top rated schools, scenic parks, and everyday amenities are all just minutes away. A rare opportunity to settle into a home that offers space, light, and community in equal measure. Don't miss your chance to make 156 McKnight Ave yours. (id:62650)"
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T19:05:01.085149+00:00"
+"Directions": "Burke Street & Mcknight Avenue"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027760"
+"ListOfficeKey": "299902"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "47 x 90.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T16:54:49Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T16:54:49Z"
+"Stories": "2.0"
+"StreetName": "McKnight"
+"StreetNumber": "156"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "7400"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=4Hh24FGSx3e"
+"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": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29876660/156-mcknight-avenue-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1-39"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 47.0
+"OriginalEntryTimestamp": "2026-06-09T16:54:49.07Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1307105"
+"ListOfficeNationalAssociationId": "1478673"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29876660')"
+"ID": "1511413"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25083
+post_id: "1510179"
+post_author: 1
+"ListingKey": "29875905"
+"ListingId": "40837871"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T22:30:20Z"
+"RFModificationTimestamp": "2026-06-09T22:34:52Z"
+"ListPrice": 1265000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2160.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0T7"
+"UnparsedAddress": "156 MCKNIGHT Avenue, Waterdown, Ontario L8B0T7"
+"Coordinates": array:2 [
0 => -79.8790932
1 => 43.3401803
]
+"Latitude": 43.3401803
+"Longitude": -79.8790932
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 156 McKnight Ave, Waterdown. Step into a home that truly lives as beautifully as it looks. Located in one of Waterdown's most sought after neighbourhoods, this inviting property offers generous, light filled spaces designed for the way modern families actually live. The main floor impresses with large, well-proportioned primary rooms that lend themselves to easy entertaining and everyday comfort, along with a versatile bonus room, perfect as a home office, playroom, or guest space. Natural light pours throughout, creating a warm and welcoming atmosphere at every turn. Downstairs, a spacious unfinished basement presents a blank canvas ready for your vision. Whether that's a recreation room, home gym, or additional living space, the possibilities are yours to define. Outside, enjoy a fully fenced backyard, ideal for kids, pets, and summer gatherings. Set within a beautiful, established neighbourhood that checks every box. Top rated schools, scenic parks, and everyday amenities are all just minutes away. A rare opportunity to settle into a home that offers space, light, and community in equal measure. Don't miss your chance to make 156 McKnight Ave yours. (id:62783)"
+"Appliances": array:1 [
0 => "Central Vacuum - Roughed In"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T16:52:29.850080+00:00"
+"Directions": "Dundas Street E to Burke Street, to McKnight Avenue"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981716"
+"ListOfficeKey": "299866"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T15:39:38Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T22:20:35Z"
+"Stories": "2.0"
+"StreetName": "MCKNIGHT"
+"StreetNumber": "156"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "7400"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=4Hh24FGSx3e"
+"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/29875905/156-mcknight-avenue-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2058648"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "282362"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-39"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 47.0
+"AboveGradeFinishedArea": 2160
+"OriginalEntryTimestamp": "2026-06-09T15:39:37.9Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1267128"
+"ListOfficeNationalAssociationId": "1477944"
+"CoListAgentNationalAssociationId": "1334211"
+"CoListOfficeNationalAssociationId": "1320359"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29875905')"
+"ID": "1510179"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25087
+post_id: "1509073"
+post_author: 1
+"ListingKey": "29873826"
+"ListingId": "X13417738"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T00:35:39Z"
+"RFModificationTimestamp": "2026-06-09T00:50:40Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1V7"
+"UnparsedAddress": "33 - 22 SPRING CREEK DRIVE, Hamilton (Waterdown), Ontario L8B1V7"
+"Coordinates": array:2 [
0 => -79.8781647
1 => 43.3461257
]
+"Latitude": 43.3461257
+"Longitude": -79.8781647
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Discover this gorgeous freehold end-unit townhome, a 3-bedroom, 3-bathroom residence that perfectly blends style and function. The main level is designed for both elegance and comfort, featuring a separate formal dining room and an inviting great room with a dedicated breakfast area. This level is beautifully finished with hardwood floors, elegant crown molding, and California shutters throughout. The gourmet kitchen comes complete with quartz countertops, a premium backsplash, and under-cabinet lighting, making it a perfect match for the passionate chef.Upstairs, the primary retreat features a spa-like double-sink master ensuite with a quartz vanity, walk-in shower, and soaker tub, alongside two additional bedrooms and a convenient laundry room. The finished basement adds significant living space with custom storage cabinetry, while the landscaped rear yard offers a premium 16x16 composite deck for outdoor enjoyment.Perfectly situated in desirable Waterdown, this home balances small-town charm with commuter convenience. Enjoy proximity to Trails, Parks and easy Highway access to 403,407, QEW and the GO Station. (id:62783)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
11 => "Water Heater - Tankless"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T00:50:33.952250+00:00"
+"Directions": "Cross Streets: Dundas. ** Directions: Dundas to Spring Creek."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1991882"
+"ListOfficeKey": "205093"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Level lot"
1 => "Flat site"
]
+"LotSizeDimensions": "28.6 x 85 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T00:25:46Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T00:25:46Z"
+"Stories": "2.0"
+"StreetName": "Spring Creek"
+"StreetNumber": "22"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6860"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://tours.aisonphoto.com/316388"
+"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": "Oakville-Milton"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29873826/33-22-spring-creek-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R6-42"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 28.7
+"OriginalEntryTimestamp": "2026-06-09T00:25:46.61Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1276037"
+"ListOfficeNationalAssociationId": "1001110"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29873826')"
+"ID": "1509073"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25085
+post_id: "1508710"
+post_author: 1
+"ListingKey": "29873709"
+"ListingId": "X13417580"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T00:20:40Z"
+"RFModificationTimestamp": "2026-06-09T00:22:07Z"
+"ListPrice": 1149000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H8"
+"UnparsedAddress": "44 STILLWATER CRESCENT, Hamilton (Waterdown), Ontario L0R2H8"
+"Coordinates": array:2 [
0 => -79.878431
1 => 43.346428
]
+"Latitude": 43.346428
+"Longitude": -79.878431
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This stunning Waterdown home has so much to offer - and it's ready to impress from the moment you walk in! Boasting over 1,900 sq ft above grade and built in 2017, every detail has been thoughtfully designed with modern living in mind. Engineered hardwood flooring flows throughout both the main and second level, and the open concept kitchen features beautiful quartz countertops - ideal for entertaining family and friends. A main floor office and a chic powder room complete the main level with both function and flair. Upstairs you'll find 3 spacious bedrooms plus the potential for a 4th, served by 2 well-appointed bathrooms including a luxurious private ensuite. The fully finished basement offers even more living space complete with a gym and rec room, plus ample storage throughout. Step outside to your private, fully fenced backyard oasis featuring a gazebo and hot tub - the perfect place to relax and unwind. With parking for 5 vehicles, easy highway access and just minutes to Aldershot GO Station, this one checks every box. Don't miss it! (id:62650)"
+"Appliances": array:6 [
0 => "All"
1 => "Water meter"
2 => "Hot Tub"
3 => "Central Vacuum"
4 => "Window Coverings"
5 => "Water Heater - Tankless"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T00:21:57.360258+00:00"
+"Directions": "Cross Streets: Spring Creek. ** Directions: Spring Creek Drive to Still Water."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2234778"
+"ListOfficeKey": "292146"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Ravine"
1 => "Dry"
2 => "Carpet Free"
3 => "Gazebo"
4 => "Sump Pump"
]
+"LotSizeDimensions": "30 x 89.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-08T23:42:26Z"
+"PhotosCount": 28
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T00:11:56Z"
+"Stories": "2.0"
+"StreetName": "Stillwater"
+"StreetNumber": "44"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6644"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"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"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29873709/44-stillwater-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R1-69"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 30.0
+"OriginalEntryTimestamp": "2026-06-08T23:42:25.94Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1472623"
+"ListOfficeNationalAssociationId": "1417330"
+"Media": array:28 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29873709')"
+"ID": "1508710"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25080
+post_id: "1508447"
+post_author: 1
+"ListingKey": "29872092"
+"ListingId": "X13416316"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T20:00:42Z"
+"RFModificationTimestamp": "2026-06-08T23:31:49Z"
+"ListPrice": 699999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1X6"
+"UnparsedAddress": "22 - 383 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1X6"
+"Coordinates": array:2 [
0 => -79.887763
1 => 43.339072
]
+"Latitude": 43.339072
+"Longitude": -79.887763
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this meticulously maintained End-Unit Townhouse offering the perfect blend of privacy, natural light, and modern comfort. Situated in a desirable community, this home features plenty of windows throughout, filling the space with abundant natural light. This house boasts High End Finishings throughout that feels like a Semi. All Three Spacious Bedrooms with Full-Ensuite Washrooms. The functional layout includes a spacious living and dining area, a well-appointed kitchen with Stainless Steel appliances, Quartz Counter Top, Updated Backsplash and ample cabinetry overlooking Dining area that opens to the balcony space. The primary bedroom offers a peaceful retreat with large closet space, Ensuite and a Balcony. The lower LVL third bedroom offers Ensuite with back yard access. The Lower level also features garage access and includes an additional Family/Rec room. Modern and Practical Layout. Enjoy the benefits of an end unit with added privacy, a larger Fenced yard space, EV Garage Charger and convenient access to visitor parking. Perfect for families, first-time buyers, or investors. Located closer to schools, shopping, transit, and many amenities of life. Move-in ready-don't miss this opportunity! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "215.88"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-08T23:31:38.042463+00:00"
+"Directions": "Dundas/Burke"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1678635"
+"ListOfficeKey": "296729"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-08T19:53:40Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T19:53:40Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "383"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4328"
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29872092/22-383-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Melbourne Property Management"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"ZoningDescription": "HC-2"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-08T19:53:40.88Z"
+"ListAgentNationalAssociationId": "1172164"
+"ListOfficeNationalAssociationId": "1461559"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29872092')"
+"ID": "1508447"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23349
+post_id: "1507953"
+post_author: 1
+"ListingKey": "29871823"
+"ListingId": "40837880"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T22:31:06Z"
+"RFModificationTimestamp": "2026-06-08T22:37:09Z"
+"ListPrice": 1149000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1909.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H8"
+"UnparsedAddress": "44 STILLWATER Crescent, Waterdown, Ontario L0R2H8"
+"Coordinates": array:2 [
0 => -79.878352
1 => 43.3464429
]
+"Latitude": 43.3464429
+"Longitude": -79.878352
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This stunning Waterdown home has so much to offer — and it's ready to impress from the moment you walk in! Boasting over 1,900 sq ft above grade and built in 2017, every detail has been thoughtfully designed with modern living in mind. Engineered hardwood flooring flows throughout both the main and second level, and the open concept kitchen features beautiful quartz countertops — ideal for entertaining family and friends. A main floor office and a chic powder room complete the main level with both function and flair. Upstairs you'll find 3 spacious bedrooms plus the potential for a 4th, served by 2 well-appointed bathrooms including a luxurious private ensuite. The fully finished basement offers even more living space complete with a gym and rec room, plus ample storage throughout. Step outside to your private, fully fenced backyard oasis featuring a gazebo and hot tub — the perfect place to relax and unwind. With parking for 5 vehicles, easy highway access and just minutes to Aldershot GO Station, this one checks every box. Don't miss it! (id:62650)"
+"Appliances": array:1 [
0 => "Central Vacuum"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-08T20:34:21.888112+00:00"
+"Directions": "Dundas Street East to Spring Creek to Stillwater"
+"ExteriorFeatures": array:2 [
0 => "Stucco"
1 => "Brick Veneer"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2043485"
+"ListOfficeKey": "262629"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Gazebo"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-08T19:19:37Z"
+"PhotosCount": 28
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T22:20:16Z"
+"Stories": "2.0"
+"StreetName": "STILLWATER"
+"StreetNumber": "44"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6644"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29871823/44-stillwater-crescent-waterdown"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:3 [
0 => "Alarm system"
1 => "Security system"
2 => "Smoke Detectors"
]
+"ZoningDescription": "R1-69"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1909
+"OriginalEntryTimestamp": "2026-06-08T19:19:37.13Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1319320"
+"ListOfficeNationalAssociationId": "1223032"
+"Media": array:28 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29871823')"
+"ID": "1507953"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25088
+post_id: "1507263"
+post_author: 1
+"ListingKey": "29870285"
+"ListingId": "X13414412"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T17:01:17Z"
+"RFModificationTimestamp": "2026-06-08T17:29:25Z"
+"ListPrice": 385000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "114 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Perfect for first-time buyers or downsizers. This beautifully appointed ground-floor condo offers style, comfort, and convenience in one of Waterdown's most sought-after communities.Ideally located within walking distance to shopping, restaurants, parks, and everyday amenities, this home also offers easy access to major highways and public transit, making commuting a breeze.Step inside to discover a bright open-concept layout featuring elegant flooring throughout. The modern kitchen is designed to impress with quartz countertops, stainless steel appliances, an undermount sink, and a peninsula with breakfast bar seating, perfect for casual dining, entertaining, or your morning coffee.The sun-filled living area opens onto a private balcony, providing the perfect space to relax and enjoy the outdoors. The spacious bedroom features floor-to-ceiling windows and a peaceful atmosphere, while the stylish 4-piece bathroom showcases contemporary finishes. In-suite laundry, one owned parking space, and a storage locker add to the everyday convenience.Residents enjoy access to exceptional building amenities, including a fitness centre, party room, rooftop terrace and garden, community BBQ area, bicycle storage, and a welcoming lobby lounge.Just minutes from Burlington's vibrant waterfront, restaurants, and entertainment district, this move-in-ready condo offers an outstanding opportunity to enter the market and enjoy modern condo living in a prime location.Some photos have been virtually staged to illustrate the property's potential layout and use of space. Furnishings and décor shown in these images may not be present at the property. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "501.68"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-08T17:29:06.215037+00:00"
+"Directions": "Dundas/ Mallard/ Riverwalk"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2011104"
+"ListOfficeKey": "288626"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-08T16:53:36Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T16:53:36Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2558.9"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29870285/114-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-08T16:38:59Z"
+"ListAgentNationalAssociationId": "1292549"
+"ListOfficeNationalAssociationId": "1370159"
+"Media": array:27 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29870285')"
+"ID": "1507263"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25089
+post_id: "1505882"
+post_author: 1
+"ListingKey": "29869910"
+"ListingId": "40837683"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T20:30:14Z"
+"RFModificationTimestamp": "2026-06-09T20:32:03Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1242.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R3H0"
+"UnparsedAddress": "352 PARKSIDE Drive, Waterdown, Ontario L0R3H0"
+"Coordinates": array:2 [
0 => -79.8971548
1 => 43.3422221
]
+"Latitude": 43.3422221
+"Longitude": -79.8971548
+"YearBuilt": 1947
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Opportunity is knocking in the heart of Old Waterdown. Welcome to 352 Parkside Drive, a 1.5 storey home sitting on a beautiful 75’ x 93’ lot in one of Waterdown’s most established and sought after neighbourhoods. With 3 bedrooms, 1+1 bathrooms, a detached garage, and 1,242 sq ft of living space, this home is ready for someone with vision to bring it back to life. TLC required, but the potential here is undeniable!! Whether you’re an investor, contractor, flipper, or a buyer dreaming of creating a home fully your own, this is the kind of property that rarely comes up in Old Town Waterdown at an approachable price point. Big lot. Incredible location. Endless potential. (id:62650)"
+"Basement": array:2 [
0 => "Partially finished"
1 => "Partial"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-08T16:42:40.576751+00:00"
+"Directions": "Hamilton St N to Parkside Dr"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1922779"
+"ListOfficeKey": "288925"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-08T16:00:24Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T20:20:50Z"
+"Stories": "1.5"
+"StreetName": "PARKSIDE"
+"StreetNumber": "352"
+"StreetSuffix": "Drive"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "5275"
+"VirtualTourURLUnbranded": "https://youtu.be/yYP-O1y40_s"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29869910/352-parkside-drive-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-74c"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 75.0
+"AboveGradeFinishedArea": 1242
+"OriginalEntryTimestamp": "2026-06-08T16:00:23.79Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1227684"
+"ListOfficeNationalAssociationId": "1372539"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29869910')"
+"ID": "1505882"
}
]
+success: true
+page_size: 9
+page_count: 20
+count: 174
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]