array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29872092 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1508447"
+post_author: 1
+"ListingKey": "29872092"
+"ListingId": "X13416316"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T16:35:14Z"
+"RFModificationTimestamp": "2026-06-10T16:39:29Z"
+"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-10T16:29:53Z"
+"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": "R6-46"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-08T19:53:40.88Z"
+"ListAgentNationalAssociationId": "1172164"
+"ListOfficeNationalAssociationId": "1461559"
+"Media": array:43 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29872092_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/0a31ae0b790cbbcb3f80c5c742c40f8e.webp"
"MediaSize" => 283882
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-0a31ae0b790cbbcb3f80c5c742c40f8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29872092_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/49d98636cd5d78c1d0f5d3d68ecc74a7.webp"
"MediaSize" => 284093
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-49d98636cd5d78c1d0f5d3d68ecc74a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29872092_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/50509a617c1c3bf6e2253c57b7696ada.webp"
"MediaSize" => 285367
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-50509a617c1c3bf6e2253c57b7696ada.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29872092_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/beb9c01eb90399a0bdfc6e9ba86184a0.webp"
"MediaSize" => 143154
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-beb9c01eb90399a0bdfc6e9ba86184a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29872092_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/38a3b52c96b51ec5dab1310021b72a8d.webp"
"MediaSize" => 78766
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-38a3b52c96b51ec5dab1310021b72a8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29872092_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/490fe92ce4e3e8a1308c697909cba99c.webp"
"MediaSize" => 129210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-490fe92ce4e3e8a1308c697909cba99c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29872092_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/6fa7de156650084f5a2fd6f0aded99d7.webp"
"MediaSize" => 136994
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-6fa7de156650084f5a2fd6f0aded99d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29872092_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/c8fa06b21d3b3d9092b20d2c91669b3d.webp"
"MediaSize" => 131975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-c8fa06b21d3b3d9092b20d2c91669b3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29872092_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/bd99f0733d1696f1d3a77aafbfefe1a9.webp"
"MediaSize" => 160384
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-bd99f0733d1696f1d3a77aafbfefe1a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29872092_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/0ba08ac3e1c3c922a8578be39796775e.webp"
"MediaSize" => 131993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-0ba08ac3e1c3c922a8578be39796775e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29872092_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/f24fa37b352f6c5f66e9221b4831ac6a.webp"
"MediaSize" => 142613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-f24fa37b352f6c5f66e9221b4831ac6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29872092_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/a7874b17231e7361d5a9400089b80e24.webp"
"MediaSize" => 141297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-a7874b17231e7361d5a9400089b80e24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29872092_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/972950ec661e231744edcbf8ccb976e2.webp"
"MediaSize" => 153435
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-972950ec661e231744edcbf8ccb976e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29872092_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/a2bb580f99c10172f37f2f02dee839b9.webp"
"MediaSize" => 252145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-a2bb580f99c10172f37f2f02dee839b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29872092_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/97fb0d657fae40530d25d91bf548569a.webp"
"MediaSize" => 167532
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-97fb0d657fae40530d25d91bf548569a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29872092_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/eb27012f8e028cbb21942a9814abdacb.webp"
"MediaSize" => 220290
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-eb27012f8e028cbb21942a9814abdacb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29872092_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/a100761fbd079ccb1372e5102eb1afbf.webp"
"MediaSize" => 219819
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-a100761fbd079ccb1372e5102eb1afbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29872092_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/e7c41ee658738b69830a801fd308211a.webp"
"MediaSize" => 205154
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-e7c41ee658738b69830a801fd308211a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29872092_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/83845280da6f57e4754fa28f922fe318.webp"
"MediaSize" => 194804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-83845280da6f57e4754fa28f922fe318.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29872092_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/26bb471fe3b7a025384fc35ba65a4af0.webp"
"MediaSize" => 119339
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-26bb471fe3b7a025384fc35ba65a4af0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29872092_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/0605972d5677baea6256d9a34d3dafe7.webp"
"MediaSize" => 193162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-0605972d5677baea6256d9a34d3dafe7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29872092_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/d98257b8e53aabd637a867c28ecfdded.webp"
"MediaSize" => 157058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-d98257b8e53aabd637a867c28ecfdded.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29872092_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/4f45e89b08aa5d04460cbc8f0fdb465d.webp"
"MediaSize" => 147208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-4f45e89b08aa5d04460cbc8f0fdb465d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29872092_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/b5a276178f06dc07c9817b814429a153.webp"
"MediaSize" => 131893
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-b5a276178f06dc07c9817b814429a153.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29872092_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/5a03dc8959f6606970ba1d9d0a662e91.webp"
"MediaSize" => 130903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-5a03dc8959f6606970ba1d9d0a662e91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29872092_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/5bf753d11c904edf8848d6fb92fcdcaf.webp"
"MediaSize" => 99019
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-5bf753d11c904edf8848d6fb92fcdcaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29872092_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/ba48e2c7584a70eae0e1ddd06a7a1b54.webp"
"MediaSize" => 96394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-ba48e2c7584a70eae0e1ddd06a7a1b54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29872092_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/9bd27ea537ce4c8c6798a3bab2847656.webp"
"MediaSize" => 220160
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-9bd27ea537ce4c8c6798a3bab2847656.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29872092_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/fcf8b24de3697c10bd4543242b515698.webp"
"MediaSize" => 154024
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-fcf8b24de3697c10bd4543242b515698.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29872092_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/07628d366f2daa462883d50be2a647b9.webp"
"MediaSize" => 145458
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-07628d366f2daa462883d50be2a647b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29872092_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/447eb5ab86b832a023276effa136fac1.webp"
"MediaSize" => 160762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-447eb5ab86b832a023276effa136fac1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29872092_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/f91ca2f07a877c57d546d3d32d663f32.webp"
"MediaSize" => 130903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-f91ca2f07a877c57d546d3d32d663f32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29872092_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/58cab6a227dc64e5819911c1757d822a.webp"
"MediaSize" => 155585
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-58cab6a227dc64e5819911c1757d822a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29872092_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/6040ab3216ad04946bb5330b1a12fe2d.webp"
"MediaSize" => 161907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-6040ab3216ad04946bb5330b1a12fe2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29872092_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/3ac8e75f6425372eab4c831e6cdccbba.webp"
"MediaSize" => 331340
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-3ac8e75f6425372eab4c831e6cdccbba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29872092_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/3f92f428e132e2fd0ce53e37fe2d5ac3.webp"
"MediaSize" => 368996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-3f92f428e132e2fd0ce53e37fe2d5ac3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29872092_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/f422909276469819d09d4bc43a31bf25.webp"
"MediaSize" => 167131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-f422909276469819d09d4bc43a31bf25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29872092_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/65aa9751151a5e94e12b0cef3346d283.webp"
"MediaSize" => 161558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-65aa9751151a5e94e12b0cef3346d283.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29872092_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/8bb8988885f8b9128fea864b6efaef2d.webp"
"MediaSize" => 366788
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-8bb8988885f8b9128fea864b6efaef2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29872092_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/595b61595526598e6ba920e50cdaa606.webp"
"MediaSize" => 139161
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-595b61595526598e6ba920e50cdaa606.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29872092_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/ff8228c320044a147a2f89d9a9557ce4.webp"
"MediaSize" => 137506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-ff8228c320044a147a2f89d9a9557ce4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29872092_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/48c0bcfe5cb9e5f7188ba05a36cdb2c8.webp"
"MediaSize" => 125314
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-48c0bcfe5cb9e5f7188ba05a36cdb2c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29872092_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29872092/00c68eec09dc8dabb1ebdf8c8b245c25.webp"
"MediaSize" => 200465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29872092/thumbnail-00c68eec09dc8dabb1ebdf8c8b245c25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13416316"
"ResourceRecordKey" => "29872092"
"ModificationTimestamp" => "2026-06-08T19:53:40.89Z"
]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29872092')"
+"ID": "1508447"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Cache Key: 6b1bf49d925b6642b02c22d2cbf9ca7fbc92f0a190df873d88beaf9b22ce8cb6" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24495
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1678635" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24809
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29872092'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25127
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29872092'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25142
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25143
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31410970"
+"ListingKey": "29872092"
+"ListingId": "X13416316"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-12T22:30:49Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31410970')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25145
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31410969"
+"ListingKey": "29872092"
+"ListingId": "X13416316"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-13"
+"OpenHouseStartTime": "2026-06-13T14:00:00Z"
+"OpenHouseEndTime": "2026-06-13T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-12T22:30:49Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31410969')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29872092' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.887763 43.339072)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25264
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25258
+post_id: "1525931"
+post_author: 1
+"ListingKey": "29898285"
+"ListingId": "X13439700"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T21:40:08Z"
+"RFModificationTimestamp": "2026-06-12T23:51:00Z"
+"ListPrice": 2395000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 2
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H7"
+"UnparsedAddress": "345 MOUNTAIN BROW ROAD, Hamilton (Waterdown), Ontario L0R2H7"
+"Coordinates": array:2 [
0 => -79.870648
1 => 43.339359
]
+"Latitude": 43.339359
+"Longitude": -79.870648
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Set on approximately 3-acres (per MPAC) this property overlooks the breathtaking natural landscape of Smokey Hollow and backs directly onto the iconic Bruce Trail. This remarkable gated estate offers a rare opportunity to acquire one of the area's most picturesque and private estates. A graceful, swooping driveway leads through expansive, awe-inspiring grounds, creating a dramatic sense of arrival while remaining discreet and private from the road. The 2.5-storey residence offers 7 bedrooms and 5 bathrooms, along with a library with a fireplace. The home in its current state needs to be renovated. Outdoor features include an inground swimming pool and a detached double-car garage, all set within the property's remarkable estate setting. For those with a vision for transformation, a new house rendering design by SMPL Design Studio offers inspiration for a spectacular modern residence. Ideally located just minutes from downtown Waterdown, Burlington, and the convenient Aldershot GO Station, providing easy access to amenities and commuting options. Property and all structures are being sold in AS-IS condition. Floor plans and a survey are available. Either renovate the existing house or build a new one. Exterior photos are current and from a few years ago. Interior photos and new home renderings are for creative / illustrative purposes only. (id:62783)"
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-12T23:50:55.953773+00:00"
+"Directions": "Cross Streets: Waterdown Rd / Mountain Brow Rd. ** Directions: -."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1529018"
+"ListOfficeKey": "291562"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Wooded area"
]
+"LotSizeDimensions": "151.8 x 579.2 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T21:31:41Z"
+"PhotosCount": 12
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Holding Tank"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T21:31:41Z"
+"Stories": "2.5"
+"StreetName": "Mountain Brow"
+"StreetNumber": "345"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "17408"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29898285/345-mountain-brow-road-hamilton-waterdown-waterdown"
+"ParkingTotal": 16
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1743890"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "291562"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"BedroomsAboveGrade": 7
+"FrontageLengthNumeric": 151.9
+"OriginalEntryTimestamp": "2026-06-12T21:31:41.06Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1140630"
+"ListOfficeNationalAssociationId": "1400240"
+"CoListAgentNationalAssociationId": "1292982"
+"CoListOfficeNationalAssociationId": "1400240"
+"Media": array:12 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29898285_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898285/a986ee0d49191535d4684c0e8744d61f.webp"
"MediaSize" => 229163
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898285/thumbnail-a986ee0d49191535d4684c0e8744d61f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13439700"
"ResourceRecordKey" => "29898285"
"ModificationTimestamp" => "2026-06-12T21:31:41.06Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29898285_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898285/8387e5bcb7d51f49e11908c547353fec.webp"
"MediaSize" => 177455
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898285/thumbnail-8387e5bcb7d51f49e11908c547353fec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13439700"
"ResourceRecordKey" => "29898285"
"ModificationTimestamp" => "2026-06-12T21:31:41.06Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29898285_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898285/b5ed58ed1c382f5cf0fa94a5be909e57.webp"
"MediaSize" => 206407
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898285/thumbnail-b5ed58ed1c382f5cf0fa94a5be909e57.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13439700"
"ResourceRecordKey" => "29898285"
"ModificationTimestamp" => "2026-06-12T21:31:41.06Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29898285_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898285/43769e6373bd064e311b609491a90e20.webp"
"MediaSize" => 209847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898285/thumbnail-43769e6373bd064e311b609491a90e20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13439700"
"ResourceRecordKey" => "29898285"
"ModificationTimestamp" => "2026-06-12T21:31:41.06Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29898285_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898285/0d9f88e5f20d0a57c7b53c85348ef155.webp"
"MediaSize" => 213151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898285/thumbnail-0d9f88e5f20d0a57c7b53c85348ef155.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13439700"
"ResourceRecordKey" => "29898285"
"ModificationTimestamp" => "2026-06-12T21:31:41.06Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29898285_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898285/ff3d85ab0a850e8908e295b21e43ef6b.webp"
"MediaSize" => 199140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898285/thumbnail-ff3d85ab0a850e8908e295b21e43ef6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13439700"
"ResourceRecordKey" => "29898285"
"ModificationTimestamp" => "2026-06-12T21:31:41.06Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29898285_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898285/eb11858c875c968bed2342aaa44194c6.webp"
"MediaSize" => 191481
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898285/thumbnail-eb11858c875c968bed2342aaa44194c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13439700"
"ResourceRecordKey" => "29898285"
"ModificationTimestamp" => "2026-06-12T21:31:41.06Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29898285_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898285/57bfb0219bff037419762c1699aa753d.webp"
"MediaSize" => 169020
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898285/thumbnail-57bfb0219bff037419762c1699aa753d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13439700"
"ResourceRecordKey" => "29898285"
"ModificationTimestamp" => "2026-06-12T21:31:41.06Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29898285_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898285/4597e4e748e93c1b0d0ba7bb091ff742.webp"
"MediaSize" => 162565
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898285/thumbnail-4597e4e748e93c1b0d0ba7bb091ff742.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13439700"
"ResourceRecordKey" => "29898285"
"ModificationTimestamp" => "2026-06-12T21:31:41.06Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29898285_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898285/3b46ddde6d2f667e99f9da3e553c808a.webp"
"MediaSize" => 218264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898285/thumbnail-3b46ddde6d2f667e99f9da3e553c808a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13439700"
"ResourceRecordKey" => "29898285"
"ModificationTimestamp" => "2026-06-12T21:31:41.06Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29898285_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898285/cdfaef5123b5c384542075d3e97435d2.webp"
"MediaSize" => 204131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898285/thumbnail-cdfaef5123b5c384542075d3e97435d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13439700"
"ResourceRecordKey" => "29898285"
"ModificationTimestamp" => "2026-06-12T21:31:41.06Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29898285_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898285/21ec813ca86a7683bd0960e6fca9802b.webp"
"MediaSize" => 192850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898285/thumbnail-21ec813ca86a7683bd0960e6fca9802b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13439700"
"ResourceRecordKey" => "29898285"
"ModificationTimestamp" => "2026-06-12T21:31:41.06Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898285')"
+"ID": "1525931"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25260
+post_id: "1522007"
+post_author: 1
+"ListingKey": "29891787"
+"ListingId": "40839144"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T20:45:04Z"
+"RFModificationTimestamp": "2026-06-12T01:28:39Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1408.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B0Y3"
+"UnparsedAddress": "54 NISBET Boulevard Unit# 33, Hamilton, Ontario L8B0Y3"
+"Coordinates": array:2 [
0 => -79.9069775
1 => 43.3380781
]
+"Latitude": 43.3380781
+"Longitude": -79.9069775
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright and stylish townhome featuring low-maintenance living in a highly desirable Waterdown location. Featuring a functional open-concept main floor with neutral décor and thoughtful design throughout. Sleek dark kitchen complete with stainless steel appliances, breakfast bar, abundant cabinetry, pantry and storage space, seamlessly flowing into the spacious dining area and bright living room. Convenient powder room, additional storage, and inside garage access add to the practicality of this home. The upper level offers a spacious primary bedroom with double closets and private ensuite, a generous second bedroom, additional full bathroom, and convenient full laundry room with extra storage, linen closet, and drying rack. Enjoy outdoor living on the private terrace featuring an awning for added comfort and shade. The unfinished basement provides exceptional storage space and offers great potential to customize and finish to suit your needs, whether for a recreation room, home gym, office, or additional living space. Amazing location with convenient access to major highways, GO Transit, and public transit. Move-in ready and perfectly located on a quiet, family-friendly court. Walking distance to parks, trails, schools, shopping, restaurants, and everyday amenities. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFee": "94.06"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Landscaping"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T01:27:27.209917+00:00"
+"Directions": "Hamilton St N to Nisbet Blvd, right into complex"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1933651"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Southern exposure"
2 => "Balcony"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T20:39:39Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T20:39:39Z"
+"Stories": "2.0"
+"StreetName": "NISBET"
+"StreetNumber": "54"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "4900"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1657326884"
"RoomType" => "Recreation room"
"ListingId" => "40839144"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29891787"
"RoomLength" => null
"RoomDimensions" => "30'8'' x 16'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T20:39:39.53Z"
]
1 => array:11 [
"RoomKey" => "1657326885"
"RoomType" => "Laundry room"
"ListingId" => "40839144"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29891787"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T20:39:39.53Z"
]
2 => array:11 [
"RoomKey" => "1657326886"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839144"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29891787"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T20:39:39.53Z"
]
3 => array:11 [
"RoomKey" => "1657326887"
"RoomType" => "Bedroom"
"ListingId" => "40839144"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29891787"
"RoomLength" => null
"RoomDimensions" => "14'11'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T20:39:39.53Z"
]
4 => array:11 [
"RoomKey" => "1657326888"
"RoomType" => "Full bathroom"
"ListingId" => "40839144"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29891787"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T20:39:39.53Z"
]
5 => array:11 [
"RoomKey" => "1657326889"
"RoomType" => "Primary Bedroom"
"ListingId" => "40839144"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29891787"
"RoomLength" => null
"RoomDimensions" => "21'9'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T20:39:39.54Z"
]
6 => array:11 [
"RoomKey" => "1657326890"
"RoomType" => "2pc Bathroom"
"ListingId" => "40839144"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29891787"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T20:39:39.54Z"
]
7 => array:11 [
"RoomKey" => "1657326891"
"RoomType" => "Living room"
"ListingId" => "40839144"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29891787"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T20:39:39.54Z"
]
8 => array:11 [
"RoomKey" => "1657326892"
"RoomType" => "Dining room"
"ListingId" => "40839144"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29891787"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 7'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T20:39:39.54Z"
]
9 => array:11 [
"RoomKey" => "1657326893"
"RoomType" => "Kitchen"
"ListingId" => "40839144"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29891787"
"RoomLength" => null
"RoomDimensions" => "13'9'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T20:39:39.54Z"
]
10 => array:11 [
"RoomKey" => "1657326894"
"RoomType" => "Foyer"
"ListingId" => "40839144"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29891787"
"RoomLength" => null
"RoomDimensions" => "7'4'' x 5'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T20:39:39.54Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29891787/54-nisbet-boulevard-unit-33-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2185296"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283666"
+"GeocodeManualYN": true
+"ZoningDescription": "R6-27"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 24.0
+"AboveGradeFinishedArea": 1408
+"OriginalEntryTimestamp": "2026-06-11T20:39:39.49Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1233597"
+"ListOfficeNationalAssociationId": "1333115"
+"CoListAgentNationalAssociationId": "1434925"
+"CoListOfficeNationalAssociationId": "1333115"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29891787_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891787/3093e2ee3e65fe413705c27b2c41747b.webp"
"MediaSize" => 128740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891787/thumbnail-3093e2ee3e65fe413705c27b2c41747b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick and stone facade featuring decorative shutters and white-framed windows"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839144"
"ResourceRecordKey" => "29891787"
"ModificationTimestamp" => "2026-06-11T20:39:39.5Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29891787_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891787/3e807ff120d5bed96d7b0c29366febab.webp"
"MediaSize" => 137211
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891787/thumbnail-3e807ff120d5bed96d7b0c29366febab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick and stone facade featuring a covered front porch with pillar supports, a black entry door with decorative glass, white-trimmed windows, and an integrated garage"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839144"
"ResourceRecordKey" => "29891787"
"ModificationTimestamp" => "2026-06-11T20:39:39.5Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29891787_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891787/07fb1b294a423247f36ff1987787fa72.webp"
"MediaSize" => 145772
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891787/thumbnail-07fb1b294a423247f36ff1987787fa72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick facade townhome with stone accents, a covered front entry, private balcony, and integrated garage access"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839144"
"ResourceRecordKey" => "29891787"
"ModificationTimestamp" => "2026-06-11T20:39:39.5Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29891787_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891787/6039fbc64bf87694a35fade47599b6a7.webp"
"MediaSize" => 65964
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891787/thumbnail-6039fbc64bf87694a35fade47599b6a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839144"
"ResourceRecordKey" => "29891787"
"ModificationTimestamp" => "2026-06-11T20:39:39.5Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29891787_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891787/7e3b7db2a35afe685b7003d172e528e2.webp"
"MediaSize" => 79637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891787/thumbnail-7e3b7db2a35afe685b7003d172e528e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring wood-finish flooring, light gray wall tones, and a staircase with wood treads and white risers"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839144"
"ResourceRecordKey" => "29891787"
"ModificationTimestamp" => "2026-06-11T20:39:39.5Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29891787_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891787/e26f8329f6215c226a584c1c68d58525.webp"
"MediaSize" => 67980
…9
]
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('29891787')"
+"ID": "1522007"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25257
+post_id: "1522008"
+post_author: 1
+"ListingKey": "29892469"
+"ListingId": "X13434412"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T14:25:12Z"
+"RFModificationTimestamp": "2026-06-12T14:28:02Z"
+"ListPrice": 519998.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H4"
+"UnparsedAddress": "617 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L0R2H4"
+"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": "State of the Art Trend Condos. This unit boosts 792 sq. ft., one of the largest one bedroom units available. Located on the 6th floor, this unit offers spacious, modern living with 1 bedroom plus den ideal for a home office or additional bedroom. A fantastic open-concept layout featuring upgraded appliances, breakfast bar & sleek laminate flooring in the Great room. The openness of the kitchen allows you to enjoy the bright living area, perfect for entertaining and viewing the great outdoors. An upgraded private balcony gives you unobstructed views. A generously sized bedroom with walk-in closet & a 4 piece bathroom finished with modern fixtures. Additional features include convenient in-unit laundry and a storage locker located on the same floor. Added bonus this unit comes with one designated underground & one surface parking spot very much high in demand.. Minutes away from local amenities, Hwy 403/407 makingfor an easier commute. (id:62650)"
+"Appliances": array:1 [
0 => "Window Coverings"
]
+"AssociationFee": "551.44"
+"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-12T01:02:54.162610+00:00"
+"Directions": "Dundas St E & Mallard Trail"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1995891"
+"ListOfficeKey": "268183"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Elevator"
1 => "Balcony"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-11T21:53:56Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T14:19:15Z"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3700"
+"Rooms": array:1 [
0 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29892469/617-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:3 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-11T21:53:56.23Z"
+"ListAgentNationalAssociationId": "1278700"
+"ListOfficeNationalAssociationId": "1230066"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29892469')"
+"ID": "1522008"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25261
+post_id: "1522009"
+post_author: 1
+"ListingKey": "29892584"
+"ListingId": "X13434636"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T22:25:10Z"
+"RFModificationTimestamp": "2026-06-11T22:54:34Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0Y3"
+"UnparsedAddress": "33 - 54 NISBET BOULEVARD, Hamilton (Waterdown), Ontario L8B0Y3"
+"Coordinates": array:2 [
0 => -79.906772
1 => 43.339029
]
+"Latitude": 43.339029
+"Longitude": -79.906772
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright and stylish townhome offering low-maintenance living in a highly desirable Waterdown location. Featuring a functional open-concept main floor with neutral decor and thoughtful design throughout. Sleek dark kitchen complete with stainless steel appliances, breakfast bar, abundant cabinetry, pantry and storage space, seamlessly flowing into the spacious dining area and bright living room. Convenient powder room, additional storage, and inside garage access add to the practicality of this home. The upper level offers a spacious primary bedroom with double closets and private ensuite, a generous second bedroom, additional full bathroom, and convenient full laundry room with extra storage, linen closet, and drying rack. Enjoy outdoor living on the private terrace featuring an awning for added comfort and shade. The unfinished basement provides exceptional storage space and offers great potential to customize and finish to suit your needs, whether for a recreation room, home gym, office, or additional living space. Amazing location with convenient access to major highways, GO Transit, and public transit. Move-in ready and perfectly located on a quiet, family-friendly court. Walking distance to parks, trails, schools, shopping, restaurants, and everyday amenities (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
]
+"AssociationFee": "94.06"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parcel of Tied Land"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T22:54:28.009574+00:00"
+"Directions": "Cross Streets: Hamilton St N. ** Directions: Hamilton St N to Nisbet Blvd, right into complex."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2222832"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Cul-de-sac"
]
+"LotSizeDimensions": "24.2 x 53.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T22:19:47Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T22:19:47Z"
+"Stories": "2.0"
+"StreetName": "NISBET"
+"StreetNumber": "54"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "4900"
+"VirtualTourURLUnbranded": "https://visithome.ai/XDtEMoVHECyeZNFcEfNpdF?mu=ft"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29892584/33-54-nisbet-boulevard-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2227828"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "266588"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R6-27"
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 24.2
+"OriginalEntryTimestamp": "2026-06-11T22:19:47.42Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1466475"
+"ListOfficeNationalAssociationId": "1274323"
+"CoListAgentNationalAssociationId": "1470830"
+"CoListOfficeNationalAssociationId": "1274323"
+"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('29892584')"
+"ID": "1522009"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25259
+post_id: "1521037"
+post_author: 1
+"ListingKey": "29891435"
+"ListingId": "X13433494"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T20:00:09Z"
+"RFModificationTimestamp": "2026-06-11T21:50:06Z"
+"ListPrice": 824999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0R2"
+"UnparsedAddress": "4 COLE STREET, Hamilton (Waterdown), Ontario L8B0R2"
+"Coordinates": array:2 [
0 => -79.9062491
1 => 43.3361384
]
+"Latitude": 43.3361384
+"Longitude": -79.9062491
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautifully maintained freehold townhouse in sought-after Waterdown offering approximately 1470 sq. ft. of above ground finished living space. This 3-bedroom, 4-bathroom home features a bright open-concept layout with 9-ft ceilings on the main floor, a finished basement, and numerous quality upgrades throughout. Major updates include new basement/staircase carpeting (2021); kitchen countertops, backsplash, sinks, faucets, microwave, bathroom countertops, sinks and faucets, primary ensuite glass shower door, pot lights throughout the main and second floors, basement light fixtures, automated garage door opener, and humidifier (2022); new furnace, water softener, drinking water filtration system, and smart door lock (2023); plus a smart thermostat and Google video doorbell (2020).The functional layout offers spacious principal rooms, a modernized kitchen with ample cabinetry and workspace, and a finished lower level ideal for recreation, work-from-home space, or extended family living. Attached garage and private driveway parking add everyday convenience. Ideally located close to schools, the YMCA, Park, playgrounds, public transit, and a full-service shopping plaza featuring Fortinos, Tim Hortons, McDonald's, restaurants, daycare services, family medical and dental offices, convenience stores, and more. Move-in ready and thoughtfully updated, this home offers exceptional comfort, convenience, and value in one of Waterdown's most desirable communities. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Humidifier"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T21:49:54.750046+00:00"
+"Directions": "Parkside Dr/Hamilton St N"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2072378"
+"ListOfficeKey": "282777"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "18 x 100.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T19:54:52Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T19:54:52Z"
+"Stories": "2.0"
+"StreetName": "Cole"
+"StreetNumber": "4"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4896.45"
+"VirtualTourURLUnbranded": "https://homes.motionstudio.ca/listings/DsjdOGEOX8hCTJ3iwqUy/website/basic/unbranded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29891435/4-cole-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2190178"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2130691"
+"CoListOfficeKey": "298485"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "282777"
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 18.0
+"OriginalEntryTimestamp": "2026-06-11T19:54:52.33Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1347560"
+"ListOfficeNationalAssociationId": "1321336"
+"CoListAgentNationalAssociationId": "1439294"
+"CoListAgentNationalAssociationId2": "1383597"
+"CoListOfficeNationalAssociationId": "1470118"
+"CoListOfficeNationalAssociationId2": "1321336"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891435')"
+"ID": "1521037"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25254
+post_id: "1520592"
+post_author: 1
+"ListingKey": "29887232"
+"ListingId": "X13429762"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T16:05:09Z"
+"RFModificationTimestamp": "2026-06-11T16:34:04Z"
+"ListPrice": 1589000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8N2Z7"
+"UnparsedAddress": "194 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8N2Z7"
+"Coordinates": array:2 [
0 => -79.901709
1 => 43.325096
]
+"Latitude": 43.325096
+"Longitude": -79.901709
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to charming Waterdown where this estate style property feels like the country but has all the perks of in-town-living! This raised bungalow features over 2600 square feet of finished living space with 5 bedrooms and 3 bathrooms combined on both levels. Tons of room for a growing family or set it up with a nanny/income suite in the lower level with a separate walk out to the backyard. Sitting on over half an acre, you've got excellent space to play and entertain. Fully fenced backyard with saltwater inground pool, deck and gas bbq line. Invite all your friends because there's parking for 15 vehicles! Recent upgrades include basement flooring with R4 thermal subfloor (2026), furnace (2025), upper front windows (2024), main bath (2022), ensuite (2022), roof (2022). Please see the attached feature sheet for a complete list of features and upgrades. Fireplace not currently operational. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T16:33:51.597596+00:00"
+"Directions": "Cross Streets: Dundas/Hamilton. ** Directions: On the south side of Dundas just east of Riley."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2004228"
+"ListOfficeKey": "285613"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Sloping"
1 => "Flat site"
2 => "Carpet Free"
3 => "Sump Pump"
4 => "In-Law Suite"
]
+"LotSizeDimensions": "110.4 x 207.4 FT ; 110.44 x 207.42 x 110.21 x 214.83"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T11:35:12Z"
+"PhotosCount": 42
+"PoolFeatures": array:2 [
0 => "Inground pool"
1 => "Salt Water Pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T15:56:47Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "194"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "9299.1"
+"VirtualTourURLUnbranded": "https://youriguide.com/194_dundas_street_east_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29887232/194-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 17
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1841558"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "285613"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R1-6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 110.4
+"OriginalEntryTimestamp": "2026-06-11T11:35:11.96Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1287388"
+"ListOfficeNationalAssociationId": "1352696"
+"CoListAgentNationalAssociationId": "1197719"
+"CoListOfficeNationalAssociationId": "1352696"
+"Media": array:42 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29887232')"
+"ID": "1520592"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1520053"
+post_author: 1
+"ListingKey": "29888470"
+"ListingId": "X13430622"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T18:05:07Z"
+"RFModificationTimestamp": "2026-06-12T07:20:20Z"
+"ListPrice": 1275000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H5"
+"UnparsedAddress": "310 PARKSIDE DRIVE, Hamilton (Waterdown), Ontario L0R2H5"
+"Coordinates": array:2 [
0 => -79.90055364
1 => 43.3397812
]
+"Latitude": 43.3397812
+"Longitude": -79.90055364
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "THE HOME YOU HAVE BEEN WAITING FOR IS HERE! Rarely offered, this exceptional property delivers the feeling of cottage living in the city while offering the convenience of one of Waterdown's most sought after neighbourhoods. Situated on an incredible lot of nearly 10,000 sq. ft., this beautifully updated bungalow offers approximately 2,360 sq. ft. of finished living space with 3+2 bedrooms and 3 full bathrooms.The stunning open concept layout is anchored by a beautifully renovated kitchen featuring a massive centre island, stainless steel appliances, a 5 burner gas range, pot lights, and seamless flow into the living and dining areas. Bright, sun filled rooms throughout allow for an abundance of natural light, while updated railings, renovated closet spaces, and thoughtful improvements create a home that is both stylish and functional.The fully finished lower level offers incredible versatility with two additional bedrooms, a living area with a fireplace, and a relaxing 4 person infrared sauna for all your health/detox needs.Step outside and enjoy your own private backyard oasis. Surrounded by newer fencing for enhanced privacy, this expansive outdoor space features two gazebos, an extended patio, and a fire pit area, providing the perfect setting for entertaining, relaxing, and enjoying the outdoors.Major updates include a recently replaced roof and updated appliances within the last few years, providing peace of mind for years to come. With parking for 5 vehicles and a prime location just steps to shopping, schools, parks, and the renowned Bruce Trail, this move in ready home offers a lifestyle that is truly hard to find.VIEW THE MATTERPORT TOUR AND IMMERSE YOURSELF IN ALL THE BEAUTY OF THIS HOME! ----> https://my.matterport.com/show/?m=3Uop6F8x9zp&mls=1 (id:62650)"
+"Appliances": array:4 [
0 => "All"
1 => "Sauna"
2 => "Window Coverings"
3 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T16:21:30.107435+00:00"
+"Directions": "Main St./Parkside Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2102095"
+"ListOfficeKey": "275438"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Gazebo"
1 => "Sauna"
]
+"LotSizeDimensions": "56 x 150 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T17:59:54Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T17:59:54Z"
+"Stories": "1.0"
+"StreetName": "Parkside"
+"StreetNumber": "310"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6054.31"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=3Uop6F8x9zp&mls=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29888470/310-parkside-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 56.0
+"OriginalEntryTimestamp": "2026-06-11T15:02:30.1Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1371918"
+"ListOfficeNationalAssociationId": "1265158"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29888470')"
+"ID": "1520053"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25262
+post_id: "1518137"
+post_author: 1
+"ListingKey": "29887094"
+"ListingId": "X13429540"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T04:50:27Z"
+"RFModificationTimestamp": "2026-06-11T05:58:26Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "905 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.879544
1 => 43.343071
]
+"Latitude": 43.343071
+"Longitude": -79.879544
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Modern Trend Living condo with 9-ft ceilings and an open-concept layout. Features ceramic tile flooring and bright LED lighting throughout. The stylish kitchen offers custom cabinetry, designer faucet, and laminate countertops with a backsplash, while the bathrooms boast quartz countertops and spa-inspired premium fixtures. Enjoy a feature wall for your TV, a French balcony, and an owned locker for extra convenience. Pet-friendly in both living areas and bedrooms. This energy-efficient building includes geothermal heating/cooling, secure entry, 2 owned underground parking spaces, rooftop terrace, and professional management. Freshly painted and perfectly located near parks, shopping, restaurants, and major highways. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Range"
5 => "Dryer"
6 => "Microwave"
]
+"AssociationFee": "497.21"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T05:58:17.496106+00:00"
+"Directions": "Dundas St/ Riverwalk Dr"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2036997"
+"ListOfficeKey": "90198"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-11T04:42:09Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T04:42:09Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3952.38"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29887094/905-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residentials"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-11T04:42:09.45Z"
+"ListAgentNationalAssociationId": "1313436"
+"ListOfficeNationalAssociationId": "1153615"
+"Media": array:22 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29887094')"
+"ID": "1518137"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25263
+post_id: "1517898"
+post_author: 1
+"ListingKey": "29886601"
+"ListingId": "X13429118"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T00:50:04Z"
+"RFModificationTimestamp": "2026-06-11T03:18:01Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1X2"
+"UnparsedAddress": "223 SKINNER ROAD, Hamilton (Waterdown), Ontario L8B1X2"
+"Coordinates": array:2 [
0 => -79.876439
1 => 43.340782
]
+"Latitude": 43.340782
+"Longitude": -79.876439
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A maintenance-free townhome that lives like a detached; and it doesn't come up often on Skinner. This home delivers over 2,100 sq ft of finished, carpet-free living across three bedrooms, three bathrooms, and a true walk-out lower level that sets it apart from every other townhome on the street. The chef-inspired kitchen is the anchor: a 10-ft island built for gathering, white cabinetry paired with gold hardware, stainless appliances, and 9-ft ceilings dotted with pot lights. Open-concept flow connects kitchen, dining, and living for everyday function and effortless entertaining. Upstairs delivers what most townhomes can't: three genuinely large bedrooms, a primary suite that functions as a true escape, and an ensuite finished with the kind of detail you'd expect in a custom build like a massive tub overlooking your backyard. The fully finished basement (2023) walks out to a fully landscaped backyard featuring over 500 sq ft of professionally laid interlock, turf grass, and matured plantings; the rose bush and tulips are already blooming. Add the upper deck (2024) and you've got two outdoor living rooms, three seasons of use, and zero weekend lawn maintenance. Mechanically dialed in: high-efficiency heat pump (2024) for year-round comfort and low operating costs, luxury laminate throughout (2020), and a garage with direct backyard access plus a custom loft (2024) for seasonal storage. Walk to top-rated schools, new parks, and the Waterdown village's cafés and Farmers' Market; with Aldershot GO and 403/407 access making the commute a non-issue. A turnkey home for a family ready to put down roots in one of the area's fastest-growing communities, without inheriting a weekend's worth of upkeep. (id:62783)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Oven"
7 => "Dryer"
8 => "Microwave"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Garage door opener remote(s)"
12 => "Water Heater"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
3 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T03:17:52.207026+00:00"
+"Directions": "Skinner and McKnight"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2154884"
+"ListOfficeKey": "300286"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "24.8 x 92.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T00:44:07Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T00:44:07Z"
+"Stories": "2.0"
+"StreetName": "Skinner"
+"StreetNumber": "223"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6440.21"
+"VirtualTourURLUnbranded": "https://www.223skinnerroad.com/"
+"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/29886601/223-skinner-road-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 24.9
+"OriginalEntryTimestamp": "2026-06-11T00:44:07.05Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1406384"
+"ListOfficeNationalAssociationId": "1485877"
+"Media": array:45 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29886601')"
+"ID": "1517898"
}
]
+success: true
+page_size: 9
+page_count: 24
+count: 213
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]