array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29935233 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411
+post_id: "1553188"
+post_author: 1
+"ListingKey": "29935233"
+"ListingId": "X13473008"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T21:40:06Z"
+"RFModificationTimestamp": "2026-06-22T21:45:09Z"
+"ListPrice": 1349000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0G7"
+"UnparsedAddress": "585 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B0G7"
+"Coordinates": array:2 [
0 => -79.870095
1 => 43.351879
]
+"Latitude": 43.351879
+"Longitude": -79.870095
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to the exquisite 585 Dundas Street East! This home boasts classic elegance and attention to detail, while preserving it's heritage and original charm. Entering through the front door, you will be greeted with a large foyer and 9' ceilings throughout the main floor! The spacious living room, dining room and kitchen are ideal for families and entertaining, with gorgeous hardwood floors, granite countertops and stainless steel appliances. The main floor continues on with an oversized family room, featuring a fireplace and perfect atmosphere for entertaining and cozy movie nights. Upstairs you will find 3 very large bedrooms, a bonus closet room and a 5 piece bathroom. The partially finished basement and outdoor shed offer ample storage space, in addition to the double car garage. The beauty of this house keeps going to the backyard with your very own beautifully landscaped private oasis, including an above ground pool built into the huge deck! The property is 0.7 acres, with tons of privacy! Minutes from both downtown Waterdown and Burlington, close to parks and all amenities! (id:62783)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Freezer"
9 => "Water Treatment"
10 => "Window Coverings"
11 => "Water Heater"
]
+"Basement": array:1 [
0 => "Partial"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T13:50:39.541985+00:00"
+"Directions": "Cross Streets: Dundas Street and Kerns Road. ** Directions: Brant Street to Dundas Street."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2026848"
+"ListOfficeKey": "279692"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "137.1 x 225.6 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T21:34:13Z"
+"PhotosCount": 38
+"PoolFeatures": array:1 [
0 => "On Ground Pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T21:34:13Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "585"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6363"
+"ListAOR": "Oakville-Milton"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29935233/585-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 12
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 137.1
+"OriginalEntryTimestamp": "2026-06-22T13:25:59.2Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1306408"
+"ListOfficeNationalAssociationId": "1307219"
+"Media": array:38 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29935233_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/5f3b5200de6d242ee578d2482b5af387.webp"
"MediaSize" => 300370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-5f3b5200de6d242ee578d2482b5af387.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29935233_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/21175d2bb31562c0ef3b41d0146f295e.webp"
"MediaSize" => 296797
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-21175d2bb31562c0ef3b41d0146f295e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29935233_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/5a31a37dee4a66785f9aad598ee9b6bc.webp"
"MediaSize" => 330580
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-5a31a37dee4a66785f9aad598ee9b6bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29935233_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/38ba05b37573d566d4d8d05b5f3ea7b7.webp"
"MediaSize" => 183690
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-38ba05b37573d566d4d8d05b5f3ea7b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29935233_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/5dbee097f2aacdfad1175a0ee3018ea3.webp"
"MediaSize" => 192389
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-5dbee097f2aacdfad1175a0ee3018ea3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29935233_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/36090f673cd55ea3abc278f0eef8d423.webp"
"MediaSize" => 134274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-36090f673cd55ea3abc278f0eef8d423.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29935233_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/915cc7590ae37c8bae4b009c7d6d1326.webp"
"MediaSize" => 124732
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-915cc7590ae37c8bae4b009c7d6d1326.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29935233_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/ac211f9b309a86bc96623b96e1cc146e.webp"
"MediaSize" => 115281
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-ac211f9b309a86bc96623b96e1cc146e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29935233_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/01389a4fa2ebfff1b18b86ec47798ea2.webp"
"MediaSize" => 131651
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-01389a4fa2ebfff1b18b86ec47798ea2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29935233_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/611284fa44df1b53fc4908cee58e3667.webp"
"MediaSize" => 174648
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-611284fa44df1b53fc4908cee58e3667.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29935233_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/b0e7597cd2ef10e60d3363a3ba5e485e.webp"
"MediaSize" => 170425
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-b0e7597cd2ef10e60d3363a3ba5e485e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29935233_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/ad09b2b648fbc9f0fc88308f93ca0497.webp"
"MediaSize" => 173798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-ad09b2b648fbc9f0fc88308f93ca0497.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29935233_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/e9deb9fc101f697131afe6cb946de3d4.webp"
"MediaSize" => 166998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-e9deb9fc101f697131afe6cb946de3d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29935233_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/57e8583e63b51451212fa5418d91ef65.webp"
"MediaSize" => 164346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-57e8583e63b51451212fa5418d91ef65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29935233_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/fe4671e165e886f2386b460e2e563284.webp"
"MediaSize" => 134307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-fe4671e165e886f2386b460e2e563284.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29935233_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/8258024381b3f683173a0fbe9a1d6b8b.webp"
"MediaSize" => 133513
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-8258024381b3f683173a0fbe9a1d6b8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29935233_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/932797c87027a87b26c4188179cd3866.webp"
"MediaSize" => 119488
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-932797c87027a87b26c4188179cd3866.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29935233_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/369acf751961ff95eb03738407321e70.webp"
"MediaSize" => 142192
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-369acf751961ff95eb03738407321e70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29935233_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/2baef3ffd419d8e4b131cadcfaa85659.webp"
"MediaSize" => 142865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-2baef3ffd419d8e4b131cadcfaa85659.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29935233_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/4a113b256e4c1567d54c285a54077f40.webp"
"MediaSize" => 124779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-4a113b256e4c1567d54c285a54077f40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29935233_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/aabffa3cada1a2346f48b9c2dc2c21e7.webp"
"MediaSize" => 163921
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-aabffa3cada1a2346f48b9c2dc2c21e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29935233_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/0e122a0eb6154370aee105506d2e0b3c.webp"
"MediaSize" => 121300
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-0e122a0eb6154370aee105506d2e0b3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29935233_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/f1793ebf9f66d532fb0272433b0db3f8.webp"
"MediaSize" => 130747
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-f1793ebf9f66d532fb0272433b0db3f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29935233_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/2d38a1d3f14cfe2422ffa3cc028d84e7.webp"
"MediaSize" => 137744
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-2d38a1d3f14cfe2422ffa3cc028d84e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29935233_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/68e2fa8befb6bbec34e2696bff120789.webp"
"MediaSize" => 136062
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-68e2fa8befb6bbec34e2696bff120789.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29935233_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/5be35d46477bc6c8427c4024d6c589dd.webp"
"MediaSize" => 138818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-5be35d46477bc6c8427c4024d6c589dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29935233_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/df2897333c11d0eff3beb1bf3d7c8c57.webp"
"MediaSize" => 130047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-df2897333c11d0eff3beb1bf3d7c8c57.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29935233_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/51415a4744ec74c1c222cd5c64517f28.webp"
"MediaSize" => 132456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-51415a4744ec74c1c222cd5c64517f28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29935233_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/8db1caf6b8bc2639ae35939fa45c238d.webp"
"MediaSize" => 98806
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-8db1caf6b8bc2639ae35939fa45c238d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29935233_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/688a3bad178b1c1aff907e39497b4511.webp"
"MediaSize" => 123782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-688a3bad178b1c1aff907e39497b4511.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29935233_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/8a7147e4afd8b08628968998d610110f.webp"
"MediaSize" => 324195
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-8a7147e4afd8b08628968998d610110f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29935233_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/ab8b601f5b138cc36b3534138b7e6180.webp"
"MediaSize" => 334139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-ab8b601f5b138cc36b3534138b7e6180.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29935233_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/65d5147d2ab05ad56fe2765c58f1a7f1.webp"
"MediaSize" => 305786
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-65d5147d2ab05ad56fe2765c58f1a7f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29935233_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/81cdabd3edf8297a1be8725c038cac5d.webp"
"MediaSize" => 238057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-81cdabd3edf8297a1be8725c038cac5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29935233_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/dacf268fbd7c9c4166b017ff0012c398.webp"
"MediaSize" => 264457
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-dacf268fbd7c9c4166b017ff0012c398.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29935233_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/d66f7ee38dd08ded2a3c0fab52a72b99.webp"
"MediaSize" => 304243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-d66f7ee38dd08ded2a3c0fab52a72b99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29935233_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/9afdfb7723f9cedea9d2d6fbca3044b3.webp"
"MediaSize" => 269763
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-9afdfb7723f9cedea9d2d6fbca3044b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29935233_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935233/1befeafcb86f3c0618029a9c2ddb79f4.webp"
"MediaSize" => 220473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935233/thumbnail-1befeafcb86f3c0618029a9c2ddb79f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473008"
"ResourceRecordKey" => "29935233"
"ModificationTimestamp" => "2026-06-22T13:25:59.21Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29935233')"
+"ID": "1553188"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 279692" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24784
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2026848" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24763
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29935233'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25244
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29935233'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25260
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29935233' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.870095 43.351879)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25329
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25323
+post_id: "1554503"
+post_author: 1
+"ListingKey": "29937656"
+"ListingId": "X13475240"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T23:25:12Z"
+"RFModificationTimestamp": "2026-06-22T23:31:38Z"
+"ListPrice": 999999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W5"
+"UnparsedAddress": "15 HAGER CREEK TERRACE, Hamilton (Waterdown), Ontario L8B1W5"
+"Coordinates": array:2 [
0 => -79.874634
1 => 43.341421
]
+"Latitude": 43.341421
+"Longitude": -79.874634
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful Semi Detached Absolutely Gorgeous Glendale 4 Model Elevation 1A, 4 Bedroom 2.5Washroom In Beautiful Waterdown Hamilton. This Home Offers An Open Concept Layout, 9' Ceilings On Main Floor, Upgraded Staircase With Metal Pickets, Laminate Flooring Throughout The Home, Builders Upgraded Master Bedroom Tiles And Tub, Beautiful Kitchen, And Central Air Conditioning. This Home Also Offers Many Windows Allowing Natural Light To Fill The Home. The unfinished basement offers endless potential making it a fantastic opportunity. Located just minutes from schools, parks, shopping, transit, and highway access, this home combines comfort, space, and convenience in one desirable package. Don't miss your chance to call this Waterdown gem home (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T19:44:47.904613+00:00"
+"Directions": "Dundas St. East & Burke St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1979241"
+"ListOfficeKey": "277986"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "24.6 x 90 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T23:17:28Z"
+"PhotosCount": 1
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T23:17:28Z"
+"Stories": "2.0"
+"StreetName": "Hager Creek"
+"StreetNumber": "15"
+"StreetSuffix": "Terrace"
+"TaxAnnualAmount": "7100"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1665545738"
"RoomType" => "Great room"
"ListingId" => "X13475240"
"RoomLevel" => "Main level"
"RoomWidth" => 3.96
"ListingKey" => "29937656"
"RoomLength" => 5.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T18:51:14Z"
]
1 => array:11 [
"RoomKey" => "1665545739"
"RoomType" => "Kitchen"
"ListingId" => "X13475240"
"RoomLevel" => "Main level"
"RoomWidth" => 3.13
"ListingKey" => "29937656"
"RoomLength" => 3.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T18:51:14.01Z"
]
2 => array:11 [
"RoomKey" => "1665545740"
"RoomType" => "Eating area"
"ListingId" => "X13475240"
"RoomLevel" => "Main level"
"RoomWidth" => 2.71
"ListingKey" => "29937656"
"RoomLength" => 3.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T18:51:14.02Z"
]
3 => array:11 [
"RoomKey" => "1665545741"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13475240"
"RoomLevel" => "Second level"
"RoomWidth" => 3.65
"ListingKey" => "29937656"
"RoomLength" => 4.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T18:51:14.03Z"
]
4 => array:11 [
"RoomKey" => "1665545742"
"RoomType" => "Bedroom 2"
"ListingId" => "X13475240"
"RoomLevel" => "Second level"
"RoomWidth" => 2.74
"ListingKey" => "29937656"
"RoomLength" => 3.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T18:51:14.04Z"
]
5 => array:11 [
"RoomKey" => "1665545743"
"RoomType" => "Bedroom 3"
"ListingId" => "X13475240"
"RoomLevel" => "Second level"
"RoomWidth" => 3.1
"ListingKey" => "29937656"
"RoomLength" => 3.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T18:51:14.04Z"
]
6 => array:11 [
"RoomKey" => "1665545744"
"RoomType" => "Bedroom 4"
"ListingId" => "X13475240"
"RoomLevel" => "Second level"
"RoomWidth" => 2.68
"ListingKey" => "29937656"
"RoomLength" => 3.47
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T18:51:14.04Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29937656/15-hager-creek-terrace-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 24.7
+"OriginalEntryTimestamp": "2026-06-22T18:51:13.92Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1265168"
+"ListOfficeNationalAssociationId": "1287892"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29937656_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937656/eaf8f1d81d89a28520b57fbd36d60e28.webp"
"MediaSize" => 99760
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937656/thumbnail-eaf8f1d81d89a28520b57fbd36d60e28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13475240"
"ResourceRecordKey" => "29937656"
"ModificationTimestamp" => "2026-06-22T18:51:13.94Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29937656')"
+"ID": "1554503"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25325
+post_id: "1554337"
+post_author: 1
+"ListingKey": "29936356"
+"ListingId": "X13474102"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T14:30:04Z"
+"RFModificationTimestamp": "2026-06-23T14:31:34Z"
+"ListPrice": 434999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "230 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.880553
1 => 43.342598
]
+"Latitude": 43.342598
+"Longitude": -79.880553
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Trend Living in the heart of Waterdown. This well maintained 1+den condo offers 692 sq ft of thoughtfully designed living space, ideal for comfortable everyday living.Situated on the second floor, the unit features an open concept layout with laminate flooring throughout and a versatile den that can easily function as a home office, guest area, or additional living space. Walk out to a private balcony, perfect for relaxing outdoors.The unit includes two parking spaces, one underground and one outdoor, along with a private locker, offering a rare and highly practical combination.Located in the sought after Trend community, close to parks, shopping, dining, and major highways, while still enjoying the charm of Waterdown. A great opportunity for first time buyers, professionals, or investors seeking a move in ready property. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"AssociationFee": "494.45"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T19:19:43.183868+00:00"
+"Directions": "Dundas and Riverwalk"
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1975151"
+"ListOfficeKey": "283868"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-23T14:22:05Z"
+"PhotosCount": 29
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T14:22:05Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3020.94"
+"VirtualTourURLUnbranded": "https://www.houssmax.ca/vtournb/c3234619"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1665441436"
"RoomType" => "Den"
"ListingId" => "X13474102"
"RoomLevel" => "Flat"
"RoomWidth" => 2.01
"ListingKey" => "29936356"
"RoomLength" => 2.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T16:26:49.16Z"
]
1 => array:11 [
"RoomKey" => "1665441437"
"RoomType" => "Kitchen"
"ListingId" => "X13474102"
"RoomLevel" => "Flat"
"RoomWidth" => 3.47
"ListingKey" => "29936356"
"RoomLength" => 2.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T16:26:49.16Z"
]
2 => array:11 [
"RoomKey" => "1665441438"
"RoomType" => "Living room"
"ListingId" => "X13474102"
"RoomLevel" => "Flat"
"RoomWidth" => 3.47
"ListingKey" => "29936356"
"RoomLength" => 5.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T16:26:49.16Z"
]
3 => array:11 [
"RoomKey" => "1665441439"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13474102"
"RoomLevel" => "Flat"
"RoomWidth" => 2.93
"ListingKey" => "29936356"
"RoomLength" => 3.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T16:26:49.16Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29936356/230-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:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-22T16:26:49.13Z"
+"ListAgentNationalAssociationId": "1261992"
+"ListOfficeNationalAssociationId": "1336201"
+"Media": array:29 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29936356_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/a8674cc0c7e2b1ddc1b4da770e7bff21.webp"
"MediaSize" => 252824
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-a8674cc0c7e2b1ddc1b4da770e7bff21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29936356_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/540b6bd9112355da0b2129c80dd5b2b6.webp"
"MediaSize" => 241816
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-540b6bd9112355da0b2129c80dd5b2b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29936356_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/635dcf52a172d44cc9a0d95c5db0558b.webp"
"MediaSize" => 86800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-635dcf52a172d44cc9a0d95c5db0558b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29936356_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/973d44fb490aa6493f2451f4e5034e72.webp"
"MediaSize" => 152840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-973d44fb490aa6493f2451f4e5034e72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29936356_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/353e933d4072ecbd64f9db6e5eb086d9.webp"
"MediaSize" => 151836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-353e933d4072ecbd64f9db6e5eb086d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29936356_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/ec5e23db47fe43414c2dd990118c5ed9.webp"
"MediaSize" => 141319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-ec5e23db47fe43414c2dd990118c5ed9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29936356_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/2da058580aabdb52368f08380f054128.webp"
"MediaSize" => 120489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-2da058580aabdb52368f08380f054128.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29936356_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/0c8fa154540e3122d645be2f7cb1bc40.webp"
"MediaSize" => 139745
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-0c8fa154540e3122d645be2f7cb1bc40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29936356_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/043bd7a3f80b5fb5fa16048f2c856c27.webp"
"MediaSize" => 141270
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-043bd7a3f80b5fb5fa16048f2c856c27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29936356_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/09cdab163d3850d63110f101f4471873.webp"
"MediaSize" => 137948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-09cdab163d3850d63110f101f4471873.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29936356_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/05bd35089cab18e605268a30144006b1.webp"
"MediaSize" => 143989
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-05bd35089cab18e605268a30144006b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29936356_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/07db18149faf2c7b355839c345c66df8.webp"
"MediaSize" => 133851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-07db18149faf2c7b355839c345c66df8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29936356_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/094cc8efdae72ee209d7b64844f0f7ed.webp"
"MediaSize" => 159670
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-094cc8efdae72ee209d7b64844f0f7ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29936356_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/cb7adf75124194e25156a91a9ff84e07.webp"
"MediaSize" => 157235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-cb7adf75124194e25156a91a9ff84e07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29936356_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/3a65ce8a5bd6109c03167ba24578fd86.webp"
"MediaSize" => 145521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-3a65ce8a5bd6109c03167ba24578fd86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29936356_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/232a98349aa685cb3987675311b42e15.webp"
"MediaSize" => 132981
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-232a98349aa685cb3987675311b42e15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29936356_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/8f908aad49132176ad819ff25f28bc52.webp"
"MediaSize" => 149454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-8f908aad49132176ad819ff25f28bc52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29936356_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/0365cb1433349e93372ae4a0f5a1d3da.webp"
"MediaSize" => 139721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-0365cb1433349e93372ae4a0f5a1d3da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29936356_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/ba501bfa7ccff07e452b3a77689de3ea.webp"
"MediaSize" => 172883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-ba501bfa7ccff07e452b3a77689de3ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29936356_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/63f57dd7115e023074e000d2e6ac6301.webp"
"MediaSize" => 133368
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-63f57dd7115e023074e000d2e6ac6301.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29936356_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/2870329740d24daddc38f4fdc6e94bac.webp"
"MediaSize" => 121909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-2870329740d24daddc38f4fdc6e94bac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29936356_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/09513d4e5971308b99a248c1996b7874.webp"
"MediaSize" => 92866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-09513d4e5971308b99a248c1996b7874.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29936356_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/e62bc2bfa7e4a1f7dc4f979bd67b6347.webp"
"MediaSize" => 247090
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-e62bc2bfa7e4a1f7dc4f979bd67b6347.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29936356_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/91e10654eb09d1eeda77d6b5d7226e8f.webp"
"MediaSize" => 209583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-91e10654eb09d1eeda77d6b5d7226e8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29936356_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/c64e3874ce4a9e125c6529b563f34845.webp"
"MediaSize" => 198300
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-c64e3874ce4a9e125c6529b563f34845.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29936356_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/fbe55b111e04afa06bff4300a1585e62.webp"
"MediaSize" => 210645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-fbe55b111e04afa06bff4300a1585e62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29936356_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/219487900eb05d1e679cfbcb151c279a.webp"
"MediaSize" => 202985
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-219487900eb05d1e679cfbcb151c279a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29936356_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/ca61a953813d4f84d638abbfc98115be.webp"
"MediaSize" => 175080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-ca61a953813d4f84d638abbfc98115be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29936356_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/3be0b8f0182b2ecc84a2ab0cba420072.webp"
"MediaSize" => 190806
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-3be0b8f0182b2ecc84a2ab0cba420072.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29936356')"
+"ID": "1554337"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24871
+post_id: "1547964"
+post_author: 1
+"ListingKey": "29928453"
+"ListingId": "X13466818"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T17:40:11Z"
+"RFModificationTimestamp": "2026-06-19T17:43:02Z"
+"ListPrice": 375000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0L7"
+"UnparsedAddress": "404 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B0L7"
+"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": "Welcome to Trend Living in Waterdown! This newer 1 bed, 1 bath condo at 450 Dundas St E offers a bright open-concept layout with modern finishes throughout. Includes 1 surface parking space and a storage locker on the same floor as the unit. Enjoy great building amenities including a gym and party room. Conveniently located close to shopping, dining, parks, and major routes. Ideal for professionals or retirees seeking low maintenance living. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "523.75"
+"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"
]
+"CreationDate": "2026-06-19T16:57:01.019811+00:00"
+"Directions": "Cross Streets: Riverwalk Dr. ** Directions: Dundas to Riverwalk."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2106841"
+"ListOfficeKey": "284780"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T15:59:09Z"
+"PhotosCount": 19
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T16:34:04Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2988"
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1663068577"
"RoomType" => "Bedroom"
"ListingId" => "X13466818"
"RoomLevel" => "Main level"
"RoomWidth" => 2.87
"ListingKey" => "29928453"
"RoomLength" => 3.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T16:34:04.74Z"
]
1 => array:11 [
"RoomKey" => "1663068578"
"RoomType" => "Bathroom"
"ListingId" => "X13466818"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29928453"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T16:34:04.74Z"
]
2 => array:11 [
"RoomKey" => "1663068579"
"RoomType" => "Living room"
"ListingId" => "X13466818"
"RoomLevel" => "Main level"
"RoomWidth" => 3.58
"ListingKey" => "29928453"
"RoomLength" => 5.92
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T16:34:04.74Z"
]
3 => array:11 [
"RoomKey" => "1663068580"
"RoomType" => "Kitchen"
"ListingId" => "X13466818"
"RoomLevel" => "Main level"
…7
]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29928453/404-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "FirstService Residential Ontario"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-19T15:59:09.75Z"
+"ListAgentNationalAssociationId": "1375881"
+"ListOfficeNationalAssociationId": "1344707"
+"Media": array:19 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29928453')"
+"ID": "1547964"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25326
+post_id: "1547714"
+post_author: 1
+"ListingKey": "29927387"
+"ListingId": "40840891"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T16:20:20Z"
+"RFModificationTimestamp": "2026-06-23T16:25:02Z"
+"ListPrice": 375000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 587.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0L7"
+"UnparsedAddress": "450 DUNDAS Street E Unit# 404, Waterdown, Ontario L8B0L7"
+"Coordinates": array:2 [
0 => -79.879919
1 => 43.342805
]
+"Latitude": 43.342805
+"Longitude": -79.879919
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Trend Living in Waterdown! This newer 1 bed, 1 bath condo at 450 Dundas St E offers a bright open-concept layout with modern finishes throughout. Includes 1 surface parking space and a storage locker on the same floor as the unit. Enjoy great building amenities including a gym and party room. Conveniently located close to shopping, dining, parks, and major routes. Ideal for professionals or retirees seeking low-maintenance living. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "398.52"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T14:50:15.014895+00:00"
+"Directions": "Dundas to Riverwalk"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1829888"
+"ListOfficeKey": "284640"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Paved driveway"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-19T14:33:52Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T16:11:44Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "2988"
+"VirtualTourURLUnbranded": "https://paulandadam.com/listing/404-450-dundas-st-e-2/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29927387/450-dundas-street-e-unit-404-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1756268"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "262629"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 587
+"OriginalEntryTimestamp": "2026-06-19T13:51:29.14Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1195588"
+"ListOfficeNationalAssociationId": "1344651"
+"CoListAgentNationalAssociationId": "1183377"
+"CoListOfficeNationalAssociationId": "1223032"
+"Media": array:22 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29927387')"
+"ID": "1547714"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25324
+post_id: "1546295"
+post_author: 1
+"ListingKey": "29925650"
+"ListingId": "X13464400"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T22:30:05Z"
+"RFModificationTimestamp": "2026-06-19T01:17:17Z"
+"ListPrice": 534990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A7"
+"UnparsedAddress": "336 - 10 MALLARD TRAIL, Hamilton (Waterdown), Ontario L8B2A7"
+"Coordinates": array:2 [
0 => -79.878112
1 => 43.344161
]
+"Latitude": 43.344161
+"Longitude": -79.878112
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning 2 + Den condo built by award winning developer New Horizon Development Group. Featuring in-suite laundry, geo-thermal heating & cooling, storage locker and 2 underground parking spaces! Many building amenities include a party room, gym, rooftop patios and bike storage. Located in the desirable Waterdown community with extensive dining, shopping, schools, parks and a 5 minute drive to downtown Burlington or the Aldershot GO Station (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "708.33"
+"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"
]
+"CreationDate": "2026-06-19T01:17:14.633197+00:00"
+"Directions": "Dundas St E."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092595"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-18T22:21:55Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T22:21:55Z"
+"StreetName": "Mallard"
+"StreetNumber": "10"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "4363"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29925650/336-10-mallard-trail-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-18T22:21:55.08Z"
+"ListAgentNationalAssociationId": "1365159"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:23 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29925650')"
+"ID": "1546295"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24882
+post_id: "1542462"
+post_author: 1
+"ListingKey": "29601678"
+"ListingId": "X12996134"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T12:05:01Z"
+"RFModificationTimestamp": "2026-06-18T12:08:56Z"
+"ListPrice": 1189000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0M5"
+"UnparsedAddress": "40 BROOKHURST CRESCENT, Hamilton (Waterdown), Ontario L8B0M5"
+"Coordinates": array:2 [
0 => -79.8889313
1 => 43.3454208
]
+"Latitude": 43.3454208
+"Longitude": -79.8889313
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to 40 Brookhurst Crescent - an exceptional detached home nestled in one of Waterdown's most sought-after communities. Once you discover this neighbourhood, you truly won't want to leave. Known for its quiet, family-friendly atmosphere and outstanding walkability, you're just steps to local shops, restaurants, and everyday conveniences, with easy access to major highways for a seamless commute. This beautifully maintained 4-bedroom, 4-bathroom home offers a versatile layout designed for both comfort and functionality. The main level features soaring cathedral ceilings and rich hardwood flooring throughout, creating a bright and inviting space. Enjoy an open-concept living and dining area centered around a cozy gas fireplace, perfect for entertaining or relaxing evenings at home. The well-appointed eat-in kitchen offers ample cabinetry and workspace, with a convenient walk-out to the backyard. Two bedrooms and a 4-piece bathroom complete this level, offering ideal flexibility for families, guests, or a home office setup. Upstairs, you'll find two additional generously sized bedrooms and another 4-piece bathroom, providing privacy and separation for growing families. The fully finished basement expands your living space with a large recreation room, laundry area, and plenty of storage options - perfect for hobbies, a home gym, or movie nights. Additional highlights include a 2-car garage and double driveway parking, ensuring ample space for vehicles and guests. A rare opportunity to own a thoughtfully designed home in a welcoming, established neighbourhood - this is one you won't want to miss. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T12:08:50.429061+00:00"
+"Directions": "Cross Streets: Laurendale Ave. ** Directions: Parkside Dr to Boulding Ave to Laurendale Ave to Brookhurst Cres."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2043570"
+"ListOfficeKey": "300091"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40 x 107.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-04-14T16:26:06Z"
+"PhotosCount": 32
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T11:55:23Z"
+"Stories": "2.0"
+"StreetName": "Brookhurst"
+"StreetNumber": "40"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "7061.44"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/40_brookhurst_crescent_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29601678/40-brookhurst-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1-18"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2026-04-14T16:26:06.54Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1319401"
+"ListOfficeNationalAssociationId": "1482797"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 70
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29601678')"
+"ID": "1542462"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1542112"
+post_author: 1
+"ListingKey": "29920202"
+"ListingId": "X13459544"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T12:30:32Z"
+"RFModificationTimestamp": "2026-06-22T12:41:46Z"
+"ListPrice": 1169000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0M2"
+"UnparsedAddress": "119 BOULDING AVENUE, Hamilton (Waterdown), Ontario L8B0M2"
+"Coordinates": array:2 [
0 => -79.88651
1 => 43.345316
]
+"Latitude": 43.345316
+"Longitude": -79.88651
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome home to this beautifully updated, all-brick detached home in one of Waterdown's most sought-after, family-friendly neighbourhoods. Offering stylish finishes and a newly created legal secondary suite, this move-in-ready property is perfect for growing families, multigenerational living, or buyers looking for mortgage-helper income. The bright, open-concept main floor is designed for both everyday living and entertaining. It features hardwood flooring, pot lights, spacious living and dining rooms, and a large eat-in kitchen complete with quartz countertops, stainless steel appliances, abundant cabinetry, and an island overlooking the main living areas. Upstairs, you will find three spacious bedrooms, updated bathrooms, and the convenience of a second-floor stacked washer and dryer. The primary suite combines comfort and functionality with a walk-in closet and a beautifully renovated ensuite. The finished, legal basement suite provides outstanding flexibility and income potential, complete with its own kitchen, living area, bedroom, bathroom, laundry, and plenty of storage. Step outside to a beautifully redesigned backyard oasis featuring an expansive stone patio and landscaped green space, perfect for entertaining, relaxing, and enjoying summer evenings with family and friends. Additional highlights include a double-car garage with lots of storage space, six parking spots, an EV charger, and extensive upgrades throughout. Conveniently located just 10 minutes from Aldershot GO Station and Highway 403, this home offers easy access to parks, schools, shopping, and amazing trails. This is a rare opportunity to own a turnkey home with a legal secondary suite in one of Waterdown's most desirable communities. Simply move in and enjoy. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Range"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Garage door opener remote(s)"
12 => "Water Heater"
]
+"Basement": array:2 [
0 => "Full"
1 => "Apartment in basement"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T04:33:20.723539+00:00"
+"Directions": "Cross Streets: Parkside & Boulding. ** Directions: Parkside Dr, turn on Boulding."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Electric"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2213297"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In-Law Suite"
]
+"LotSizeDimensions": "40.8 x 110.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T03:41:53Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T12:24:52Z"
+"Stories": "2.0"
+"StreetName": "Boulding"
+"StreetNumber": "119"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "6806.15"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/119_boulding_ave_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29920202/119-boulding-avenue-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.9
+"OriginalEntryTimestamp": "2026-06-18T03:41:53.74Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1459157"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:39 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29920202')"
+"ID": "1542112"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25327
+post_id: "1541830"
+post_author: 1
+"ListingKey": "29919855"
+"ListingId": "40840741"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-21T20:40:11Z"
+"RFModificationTimestamp": "2026-06-21T20:42:47Z"
+"ListPrice": 1169000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.1
+"LivingArea": 2436.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0M2"
+"UnparsedAddress": "119 BOULDING Avenue, Waterdown, Ontario L8B0M2"
+"Coordinates": array:2 [
0 => -79.8864323
1 => 43.3453597
]
+"Latitude": 43.3453597
+"Longitude": -79.8864323
+"YearBuilt": 1993
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome home to this beautifully updated, all-brick detached home in one of Waterdown’s most sought-after, family-friendly neighbourhoods. Offering stylish finishes and a newly created legal secondary suite, this move-in-ready property is perfect for growing families, multigenerational living, or buyers looking for mortgage-helper income. The bright, open-concept main floor is designed for both everyday living and entertaining. It features hardwood flooring, pot lights, spacious living and dining rooms, and a large eat-in kitchen complete with quartz countertops, stainless steel appliances, abundant cabinetry, and an island overlooking the main living areas. Upstairs, you will find three spacious bedrooms, updated bathrooms, and the convenience of a second-floor stacked washer and dryer. The primary suite combines comfort and functionality with a walk-in closet and a beautifully renovated ensuite. The finished, legal basement suite provides outstanding flexibility and income potential, complete with its own kitchen, living area, bedroom, bathroom, laundry, and plenty of storage. Step outside to a beautifully redesigned backyard oasis featuring an expansive stone patio and landscaped green space, perfect for entertaining, relaxing, and enjoying summer evenings with family and friends. Additional highlights include a double-car garage with lots of storage space, six parking spots, an EV charger, and extensive upgrades throughout. Conveniently located just 10 minutes from Aldershot GO Station and Highway 403, this home offers easy access to parks, schools, shopping, and amazing trails. This is a rare opportunity to own a turnkey home with a legal secondary suite in one of Waterdown’s most desirable communities. Simply move in and enjoy. Call today for your private showing! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T01:32:31.558023+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2040099"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
2 => "In-Law Suite"
]
+"LotSizeDimensions": "0.1"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T01:01:53Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-21T20:31:59Z"
+"Stories": "2.0"
+"StreetName": "BOULDING"
+"StreetNumber": "119"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6806.15"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/119_boulding_ave_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29919855/119-boulding-avenue-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1-18"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 41.0
+"AboveGradeFinishedArea": 1661
+"BelowGradeFinishedArea": 775
+"OriginalEntryTimestamp": "2026-06-18T01:01:52.74Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1316149"
+"ListOfficeNationalAssociationId": "1344653"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919855')"
+"ID": "1541830"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25328
+post_id: "1541267"
+post_author: 1
+"ListingKey": "29918739"
+"ListingId": "40840867"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T21:40:07Z"
+"RFModificationTimestamp": "2026-06-17T22:46:29Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1280.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0M9"
+"UnparsedAddress": "174 FELLOWES Crescent, Waterdown, Ontario L8B0M9"
+"Coordinates": array:2 [
0 => -79.8856786
1 => 43.3474298
]
+"Latitude": 43.3474298
+"Longitude": -79.8856786
+"YearBuilt": 1995
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Affordable living in the heart of Waterdown! This impeccably maintained and move-in-ready three-bedroom freehold quad townhome offers the perfect blend of comfort, convenience and value. Nestled in a quiet, established neighbourhood surrounded by mature trees, this home offers exceptional access to Highway 6, the QEW, and Highway 403, with Aldershot GO Station just a short drive away. A new stone walkway welcomes you from the two-car driveway into a bright and spacious living room featuring stylish vinyl plank flooring and a cozy gas fireplace. The eat-in kitchen is ideal for everyday living, complete with a gas range and walkout to the private rear yard. The main floor also features a newly renovated two-piece powder room, while all-new (2026) LED lighting and California shutters add a modern touch throughout. Upstairs, the generous primary bedroom boasts dual closets and direct access to the beautifully renovated main bathroom, showcasing a beautiful quartz-topped vanity and updated tub surround. Two additional spacious bedrooms provide plenty of room for family, guests or a home office. The fully finished basement expands your living space with a large family room featuring a second gas fireplace, a convenient two-piece bathroom, and laundry area. Step outside to enjoy the backyard oasis, complete with a stone patio, hot tub, and a Generac generator for added peace of mind year-round. Enjoy all that Waterdown has to offer, including scenic hiking and biking trails, parks, boutique shopping, dining, and a vibrant downtown atmosphere. Don’t be TOO LATE*! *REG TM. RSA. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T22:46:16.179310+00:00"
+"Directions": "Parkside Dr to Boulding Ave to Niska Dr to Fellowes Cres"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-17T21:31:22Z"
+"PhotosCount": 29
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T21:31:22Z"
+"Stories": "2.0"
+"StreetName": "FELLOWES"
+"StreetNumber": "174"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "4565"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29918739/174-fellowes-crescent-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R6-2, R6-7"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 17.0
+"AboveGradeFinishedArea": 1280
+"OriginalEntryTimestamp": "2026-06-17T21:31:22.08Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063673"
+"ListOfficeNationalAssociationId": "1424570"
+"Media": array:29 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918739')"
+"ID": "1541267"
}
]
+success: true
+page_size: 9
+page_count: 17
+count: 150
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]