array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29907353 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1532829"
+post_author: 1
+"ListingKey": "29907353"
+"ListingId": "X13448186"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T22:55:10Z"
+"RFModificationTimestamp": "2026-06-16T00:45:07Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1X5"
+"UnparsedAddress": "406 HUMPHREY STREET, Hamilton (Waterdown), Ontario L8B1X5"
+"Coordinates": array:2 [
0 => -79.872212
1 => 43.344959
]
+"Latitude": 43.344959
+"Longitude": -79.872212
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Introducing 406 Humphrey Street Corner lot boosting 3125 Sq. Feet, nestled in a coveted neighborhood ren owned for its excellent schools, parks, and community amenities. Natural light streams through the large windows, illuminating the hardwood floors and creating a warm ambiance. The kitchen is a chef's delight, boasting modern appliances, ample counterspace, and sleek cabinetry. From casual breakfasts to elaborate dinners, this culinary haven caters to all your cooking needs. The dining area is perfect for enjoying meals with loved ones or hosting intimate gatherings. The property features four spacious bedrooms, each offering a tranquil retreat. The primary bedroom boasts an ensuite bathroom, providing privacy and convenience. The remaining bedrooms all have their own walk-in closets. 2nd and 3rd bedroom share a Jack n Jill. While forth bedroom has it's own ensuite. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T00:45:04.369529+00:00"
+"Directions": "Dundas East/Mallard/Humphrey"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1886049"
+"ListOfficeKey": "283370"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"LotSizeDimensions": "41.8 x 106 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T22:48:00Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T22:48:00Z"
+"Stories": "2.0"
+"StreetName": "Humphrey"
+"StreetNumber": "406"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1660178312"
"RoomType" => "Living room"
"ListingId" => "X13448186"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29907353"
"RoomLength" => 5.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T22:48:00.8Z"
]
1 => array:11 [
"RoomKey" => "1660178313"
"RoomType" => "Sitting room"
"ListingId" => "X13448186"
"RoomLevel" => "Second level"
"RoomWidth" => 3.41
"ListingKey" => "29907353"
"RoomLength" => 4.48
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T22:48:00.8Z"
]
2 => array:11 [
"RoomKey" => "1660178314"
"RoomType" => "Dining room"
"ListingId" => "X13448186"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29907353"
"RoomLength" => 5.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T22:48:00.8Z"
]
3 => array:11 [
"RoomKey" => "1660178315"
"RoomType" => "Laundry room"
"ListingId" => "X13448186"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29907353"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T22:48:00.8Z"
]
4 => array:11 [
"RoomKey" => "1660178316"
"RoomType" => "Family room"
"ListingId" => "X13448186"
"RoomLevel" => "Main level"
"RoomWidth" => 3.66
"ListingKey" => "29907353"
"RoomLength" => 5.61
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T22:48:00.8Z"
]
5 => array:11 [
"RoomKey" => "1660178317"
"RoomType" => "Library"
"ListingId" => "X13448186"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29907353"
"RoomLength" => 4.48
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T22:48:00.8Z"
]
6 => array:11 [
"RoomKey" => "1660178318"
"RoomType" => "Kitchen"
"ListingId" => "X13448186"
"RoomLevel" => "Main level"
"RoomWidth" => 2.93
"ListingKey" => "29907353"
"RoomLength" => 4.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T22:48:00.8Z"
]
7 => array:11 [
"RoomKey" => "1660178319"
"RoomType" => "Eating area"
"ListingId" => "X13448186"
"RoomLevel" => "Main level"
"RoomWidth" => 3.11
"ListingKey" => "29907353"
"RoomLength" => 4.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T22:48:00.8Z"
]
8 => array:11 [
"RoomKey" => "1660178320"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13448186"
"RoomLevel" => "Second level"
"RoomWidth" => 3.84
"ListingKey" => "29907353"
"RoomLength" => 6.09
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T22:48:00.81Z"
]
9 => array:11 [
"RoomKey" => "1660178321"
"RoomType" => "Bedroom 2"
"ListingId" => "X13448186"
"RoomLevel" => "Second level"
"RoomWidth" => 3.84
"ListingKey" => "29907353"
"RoomLength" => 6.09
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T22:48:00.81Z"
]
10 => array:11 [
"RoomKey" => "1660178322"
"RoomType" => "Bedroom 3"
"ListingId" => "X13448186"
"RoomLevel" => "Second level"
"RoomWidth" => 3.05
"ListingKey" => "29907353"
"RoomLength" => 4.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T22:48:00.81Z"
]
11 => array:11 [
"RoomKey" => "1660178323"
"RoomType" => "Bedroom 4"
"ListingId" => "X13448186"
"RoomLevel" => "Second level"
"RoomWidth" => 3.05
"ListingKey" => "29907353"
"RoomLength" => 4.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T22:48:00.81Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29907353/406-humphrey-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 4500
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 41.9
+"OriginalEntryTimestamp": "2026-06-15T22:48:00.76Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1209021"
+"ListOfficeNationalAssociationId": "1328418"
+"Media": array:38 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29907353_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/a330aedb43f965f200de47de1c52359b.webp"
"MediaSize" => 186098
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-a330aedb43f965f200de47de1c52359b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29907353_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/ecabaf1faf557901f04968ab1352279c.webp"
"MediaSize" => 184514
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-ecabaf1faf557901f04968ab1352279c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29907353_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/db2b61bc319e24fcf182193703992b70.webp"
"MediaSize" => 174319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-db2b61bc319e24fcf182193703992b70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29907353_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/3113257a0888af4df1354a238e879e80.webp"
"MediaSize" => 132437
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-3113257a0888af4df1354a238e879e80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29907353_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/c0c076be9e3c3d4991374d886be24970.webp"
"MediaSize" => 123213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-c0c076be9e3c3d4991374d886be24970.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29907353_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/9db80f18029bc29f0a57243e1b35ff0f.webp"
"MediaSize" => 118578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-9db80f18029bc29f0a57243e1b35ff0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29907353_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/7e8fa59a079cdfd4b41552ba3ccdf6d7.webp"
"MediaSize" => 178885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-7e8fa59a079cdfd4b41552ba3ccdf6d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29907353_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/09ecf6011a144989fe411826e635c29b.webp"
"MediaSize" => 173095
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-09ecf6011a144989fe411826e635c29b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29907353_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/c5aa44d9f576ce1ff03885f873c32fdb.webp"
"MediaSize" => 156233
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-c5aa44d9f576ce1ff03885f873c32fdb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29907353_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/ca2bf2f94119d5de39e1d84568245028.webp"
"MediaSize" => 169002
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-ca2bf2f94119d5de39e1d84568245028.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29907353_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/042495eb64efd218752ea2df1bac5e99.webp"
"MediaSize" => 174999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-042495eb64efd218752ea2df1bac5e99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29907353_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/60088a02fae4a918606cca5894ba8e2f.webp"
"MediaSize" => 122688
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-60088a02fae4a918606cca5894ba8e2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29907353_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/ca20f426ce7e1e020a1ce7713ae084d8.webp"
"MediaSize" => 139968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-ca20f426ce7e1e020a1ce7713ae084d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29907353_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/81723f775be4d32167e180f5cdd4c1b9.webp"
"MediaSize" => 142231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-81723f775be4d32167e180f5cdd4c1b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29907353_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/2b53c9a2eb37ba06e533cbd25b7ca57c.webp"
"MediaSize" => 118200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-2b53c9a2eb37ba06e533cbd25b7ca57c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29907353_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/b142cff47d7d130fab694e7144eee1d8.webp"
"MediaSize" => 79416
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-b142cff47d7d130fab694e7144eee1d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29907353_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/9fe362313b8ce98ec1a0878fbbcda8d8.webp"
"MediaSize" => 158899
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-9fe362313b8ce98ec1a0878fbbcda8d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29907353_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/aebbd1bd4316a41619a4e897431b5855.webp"
"MediaSize" => 134322
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-aebbd1bd4316a41619a4e897431b5855.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29907353_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/dd6ee8520c915e4ee46e07aa19d5e045.webp"
"MediaSize" => 141035
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-dd6ee8520c915e4ee46e07aa19d5e045.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29907353_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/4495dceee366166435c36bc882524e6b.webp"
"MediaSize" => 156000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-4495dceee366166435c36bc882524e6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29907353_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/24b9dc2af180c998387d7000192618fb.webp"
"MediaSize" => 108981
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-24b9dc2af180c998387d7000192618fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29907353_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/4963876dcaecaeab9092113388ce994d.webp"
"MediaSize" => 125124
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-4963876dcaecaeab9092113388ce994d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29907353_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/fbbe9ab5c7578186fac9b55321e8e8b1.webp"
"MediaSize" => 99546
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-fbbe9ab5c7578186fac9b55321e8e8b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29907353_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/489909ecab23aa452d1851293d72e335.webp"
"MediaSize" => 123585
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-489909ecab23aa452d1851293d72e335.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29907353_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/cd38045713c1c318a6a0791579f687a7.webp"
"MediaSize" => 125854
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-cd38045713c1c318a6a0791579f687a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29907353_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/0aeaf9997867c1cb809babe35377fb4a.webp"
"MediaSize" => 149579
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-0aeaf9997867c1cb809babe35377fb4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29907353_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/1e1f88152e4a30451b69f18aed13c7c5.webp"
"MediaSize" => 139591
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-1e1f88152e4a30451b69f18aed13c7c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29907353_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/a8354b10dc1754c348d8985795a01ce0.webp"
"MediaSize" => 136351
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-a8354b10dc1754c348d8985795a01ce0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29907353_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/d55566e783edabe2222f7cb49c82f4d0.webp"
"MediaSize" => 125778
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-d55566e783edabe2222f7cb49c82f4d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29907353_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/0f98b36b3ccf72727a6febbeff9b6d2c.webp"
"MediaSize" => 139421
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-0f98b36b3ccf72727a6febbeff9b6d2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29907353_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/0252576bc15745c70308c672735b3136.webp"
"MediaSize" => 120577
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-0252576bc15745c70308c672735b3136.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29907353_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/5e06c9dbca8f895252b73bb63e956233.webp"
"MediaSize" => 117301
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-5e06c9dbca8f895252b73bb63e956233.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29907353_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/c4c59a3ea449d6a5c14dc8642c3dcab0.webp"
"MediaSize" => 127743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-c4c59a3ea449d6a5c14dc8642c3dcab0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29907353_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/4d1d209ff0a509f4c727ef9780e8cc9d.webp"
"MediaSize" => 193336
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-4d1d209ff0a509f4c727ef9780e8cc9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29907353_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/874b14c769ca5aa813bccc7514019036.webp"
"MediaSize" => 280625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-874b14c769ca5aa813bccc7514019036.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29907353_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/4c2420d60b71ac82fe259e5d1413b3f2.webp"
"MediaSize" => 317971
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-4c2420d60b71ac82fe259e5d1413b3f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29907353_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/308696ed18f6b4fc87247f2528f07170.webp"
"MediaSize" => 275920
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-308696ed18f6b4fc87247f2528f07170.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29907353_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907353/34b789ea63afad2a44c986f66cab7fb8.webp"
"MediaSize" => 333357
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907353/thumbnail-34b789ea63afad2a44c986f66cab7fb8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448186"
"ResourceRecordKey" => "29907353"
"ModificationTimestamp" => "2026-06-15T22:48:00.77Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29907353')"
+"ID": "1532829"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 283370" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24801
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1886049" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24774
+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 '29907353'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25113
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29907353'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25129
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29907353' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Residential Lease' AND geo.distance(Coordinates, POINT(-79.872212 43.344959)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25182
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25176
+post_id: "1534320"
+post_author: 1
+"ListingKey": "29909864"
+"ListingId": "X13450338"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:10:11Z"
+"RFModificationTimestamp": "2026-06-16T16:25:29Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "112 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Experience contemporary living at Trend 3 Condo in the heart of Waterdown East. This beautifully maintained 2-bedroom corner suite offers a bright, open-concept layout designed for both comfort and functionality. Featuring luxury vinyl flooring throughout, the carpet-free interior is complemented by large windows that fill the space with natural light.The modern kitchen is equipped with stainless steel appliances and overlooks the spacious living and dining area, creating an ideal setting for everyday living and entertaining. Step outside to your private balcony and enjoy your own outdoor retreat. The unit also includes a full 4-piece bathroom, in-suite laundry, one parking space, and a storage locker for added convenience.Residents enjoy access to premium amenities, including a fitness centre, stylish party room, rooftop terraces with BBQ areas, bike storage, and visitor parking. Ideally located close to shopping, restaurants, parks, schools, and scenic trails, with quick access to Hwy 403, Hwy 6, and Hwy 407. A fantastic opportunity to enjoy low-maintenance living in one of Waterdown's most desirable condo communities. available as of August 15. * pictures are virtualy stages and when it was vacant. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T16:25:21.273119+00:00"
+"Directions": "Dundas/River Walk"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2028216"
+"ListOfficeKey": "293485"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-16T15:59:55Z"
+"PhotosCount": 10
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:59:55Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1660529762"
"RoomType" => "Living room"
"ListingId" => "X13450338"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.07
"ListingKey" => "29909864"
"RoomLength" => 3.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T15:59:55.26Z"
]
1 => array:11 [
"RoomKey" => "1660529763"
"RoomType" => "Kitchen"
"ListingId" => "X13450338"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.16
"ListingKey" => "29909864"
"RoomLength" => 2.16
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T15:59:55.26Z"
]
2 => array:11 [
"RoomKey" => "1660529764"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13450338"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.07
"ListingKey" => "29909864"
"RoomLength" => 3.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T15:59:55.26Z"
]
3 => array:11 [
"RoomKey" => "1660529765"
"RoomType" => "Bedroom"
"ListingId" => "X13450338"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.16
"ListingKey" => "29909864"
"RoomLength" => 2.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T15:59:55.26Z"
]
4 => array:11 [
"RoomKey" => "1660529766"
"RoomType" => "Bathroom"
"ListingId" => "X13450338"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.0
"ListingKey" => "29909864"
"RoomLength" => 2.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T15:59:55.26Z"
]
5 => array:11 [
"RoomKey" => "1660529767"
"RoomType" => "Laundry room"
"ListingId" => "X13450338"
"RoomLevel" => "Ground level"
"RoomWidth" => 0.5
"ListingKey" => "29909864"
"RoomLength" => 0.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T15:59:55.27Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29909864/112-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "FirstService Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 2450
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-16T15:59:55.24Z"
+"ListAgentNationalAssociationId": "1307458"
+"ListOfficeNationalAssociationId": "1427673"
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909864')"
+"ID": "1534320"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25178
+post_id: "1531858"
+post_author: 1
+"ListingKey": "29905689"
+"ListingId": "X13446750"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T19:10:06Z"
+"RFModificationTimestamp": "2026-06-15T22:03:48Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A7"
+"UnparsedAddress": "532 - 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": "Bright and modern boutique condominium available for rent located in one of Waterdown's most desirable communities. open-concept living and dining area, Modern kitchen with upgraded countertops & designer cabinetry, large bedroom with double closet, Full bathroom with premium chrome finishes, Stainless steel appliances, In-suite laundry, Energy-efficient geothermal heating and cooling. Comes with one surface parking spot and locker conveniently located on the suite floor. Fully equipped fitness center, Rooftop terrace, Party room with kitchen and pool table, On-site property management. Quick access to Highways 407, 403, QEW, and 401, Minutes to Aldershot GO Station, Close to shopping, restaurants, and schools, Nearby parks include Sealey Park and Waterdown Memorial Park. Offer (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T22:03:42.551051+00:00"
+"Directions": "Dundas Street East"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1857539"
+"ListOfficeKey": "257478"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T18:56:54Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T18:56:54Z"
+"StreetName": "Mallard"
+"StreetNumber": "10"
+"StreetSuffix": "Trail"
+"Rooms": array:3 [
0 => array:11 [
"RoomKey" => "1660030908"
"RoomType" => "Bedroom"
"ListingId" => "X13446750"
"RoomLevel" => "Main level"
"RoomWidth" => 3.13
"ListingKey" => "29905689"
"RoomLength" => 3.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T18:56:54.72Z"
]
1 => array:11 [
"RoomKey" => "1660030909"
"RoomType" => "Great room"
"ListingId" => "X13446750"
"RoomLevel" => "Main level"
"RoomWidth" => 3.46
"ListingKey" => "29905689"
"RoomLength" => 3.94
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T18:56:54.73Z"
]
2 => array:11 [
"RoomKey" => "1660030910"
"RoomType" => "Bathroom"
"ListingId" => "X13446750"
"RoomLevel" => "Main level"
"RoomWidth" => 2.29
"ListingKey" => "29905689"
"RoomLength" => 2.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T18:56:54.73Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29905689/532-10-mallard-trail-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 1900
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-15T18:56:54.7Z"
+"ListAgentNationalAssociationId": "1200241"
+"ListOfficeNationalAssociationId": "1214671"
+"Media": array:18 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29905689_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/530fd6976e4da5a155413779f2c0a498.webp"
"MediaSize" => 221385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-530fd6976e4da5a155413779f2c0a498.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29905689_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/fddbc0272441d1eac80bdc98617280a6.webp"
"MediaSize" => 239192
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-fddbc0272441d1eac80bdc98617280a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29905689_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/4b3fb441ed40b06359a86bce84ff1f41.webp"
"MediaSize" => 193722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-4b3fb441ed40b06359a86bce84ff1f41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29905689_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/9ab7dfa5f5f2281c70f63dbe3511e2e5.webp"
"MediaSize" => 170834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-9ab7dfa5f5f2281c70f63dbe3511e2e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29905689_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/8a70ef721e6ec0d6c0208e8c80eebd10.webp"
"MediaSize" => 202739
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-8a70ef721e6ec0d6c0208e8c80eebd10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29905689_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/7fe8e286d59185ea4b4654ce6d78234f.webp"
"MediaSize" => 160510
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-7fe8e286d59185ea4b4654ce6d78234f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29905689_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/41316e3b5884dfb9c7631789343cba26.webp"
"MediaSize" => 137084
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-41316e3b5884dfb9c7631789343cba26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29905689_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/a103f4f7d4854d3f6d72b3bfc5fa3a1e.webp"
"MediaSize" => 150642
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-a103f4f7d4854d3f6d72b3bfc5fa3a1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29905689_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/3149937a4c2e1de07225a5f38b3d836a.webp"
"MediaSize" => 159705
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-3149937a4c2e1de07225a5f38b3d836a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29905689_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/bac6d8ee6f615c2369126abde9425f1d.webp"
"MediaSize" => 138501
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-bac6d8ee6f615c2369126abde9425f1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29905689_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/6fc8c9496834c5b20de377e8276584ed.webp"
"MediaSize" => 86334
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-6fc8c9496834c5b20de377e8276584ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29905689_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/b5badd528b6671ce4e00b54f11db2e56.webp"
"MediaSize" => 191842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-b5badd528b6671ce4e00b54f11db2e56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29905689_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/0c139fe0634beeaff304941cbe7ee3a5.webp"
"MediaSize" => 183748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-0c139fe0634beeaff304941cbe7ee3a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29905689_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/1b3a8d47d1649585acf3881ae7dd27c4.webp"
"MediaSize" => 185117
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-1b3a8d47d1649585acf3881ae7dd27c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29905689_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/d6cacf55205657ddb3e98bbc4e6a00e1.webp"
"MediaSize" => 211709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-d6cacf55205657ddb3e98bbc4e6a00e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29905689_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/79027e6414147bce36ca7d14a1a82fbf.webp"
"MediaSize" => 80739
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-79027e6414147bce36ca7d14a1a82fbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29905689_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/548fc01a385f64cc07f8e33ee20a5b3f.webp"
"MediaSize" => 63406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-548fc01a385f64cc07f8e33ee20a5b3f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29905689_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/0b0df6d9d6c746fb6cde0fa27dfac13b.webp"
"MediaSize" => 48048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-0b0df6d9d6c746fb6cde0fa27dfac13b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905689')"
+"ID": "1531858"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25175
+post_id: "1525412"
+post_author: 1
+"ListingKey": "29895188"
+"ListingId": "X13436674"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T18:05:11Z"
+"RFModificationTimestamp": "2026-06-16T18:26:03Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "801 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.879544
1 => 43.343071
]
+"Latitude": 43.343071
+"Longitude": -79.879544
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful condo, +764 sqft with 1 bedroom, 1 large den, 1.5 bathroom, 2 parking spaces and 1 full size storage locker. Unit has an oversized den that could be utilized as office or second bedroom. Spacious and bright unit with 764 sq ft of living space featuring 9 feet ceilings for a luxurious feel. The suite features an open concept kitchen and living room with all new stainless steel appliances, a breakfast bar, in suite laundry, and a spacious and bright primary bedroom. This beautiful condo comes with a state of the art Geothermal Heating and Cooling system which keeps the hydro bills low! Enjoy all of the fabulous amenities that this building has to offer; including party rooms, modern fitness facilities, rooftop patios, and bike storage. Located just 5 min. to Downtown Burlington, the Aldershot GO Station, a great community with fabulous dining, shopping, schools, parks, easy access to highway but nestled amongst parks and nature, green space, and more. Don't miss this great opportunity. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Range"
4 => "Dryer"
5 => "Microwave"
6 => "Water Heater"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:48:42.690420+00:00"
+"Directions": "Waterdown Rd & Dundas St"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2055517"
+"ListOfficeKey": "283559"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Flat site"
1 => "Conservation/green belt"
2 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-12T15:30:32Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T17:58:59Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1660628005"
"RoomType" => "Kitchen"
"ListingId" => "X13436674"
"RoomLevel" => "Other"
"RoomWidth" => 2.3
"ListingKey" => "29895188"
"RoomLength" => 2.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T17:58:59.17Z"
]
1 => array:11 [
"RoomKey" => "1660628006"
"RoomType" => "Living room"
"ListingId" => "X13436674"
"RoomLevel" => "Other"
"RoomWidth" => 3.15
"ListingKey" => "29895188"
"RoomLength" => 5.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T17:58:59.18Z"
]
2 => array:11 [
"RoomKey" => "1660628007"
"RoomType" => "Dining room"
"ListingId" => "X13436674"
"RoomLevel" => "Other"
"RoomWidth" => 3.15
"ListingKey" => "29895188"
"RoomLength" => 5.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T17:58:59.18Z"
]
3 => array:11 [
"RoomKey" => "1660628008"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13436674"
"RoomLevel" => "Other"
"RoomWidth" => 2.87
"ListingKey" => "29895188"
"RoomLength" => 3.99
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T17:58:59.19Z"
]
4 => array:11 [
"RoomKey" => "1660628009"
"RoomType" => "Den"
"ListingId" => "X13436674"
"RoomLevel" => "Other"
"RoomWidth" => 2.31
"ListingKey" => "29895188"
"RoomLength" => 3.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T17:58:59.19Z"
]
5 => array:11 [
"RoomKey" => "1660628010"
"RoomType" => "Laundry room"
"ListingId" => "X13436674"
"RoomLevel" => "Other"
"RoomWidth" => null
"ListingKey" => "29895188"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T17:58:59.19Z"
]
6 => array:11 [
"RoomKey" => "1660628011"
"RoomType" => "Bathroom"
"ListingId" => "X13436674"
"RoomLevel" => "Other"
"RoomWidth" => null
"ListingKey" => "29895188"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T17:58:59.2Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29895188/801-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1424001"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residentials"
+"CoListAgentKey2": "2073351"
+"CoListOfficeKey": "283559"
+"GeocodeManualYN": false
+"TotalActualRent": 2600
+"BuildingFeatures": array:6 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Recreation Centre"
3 => "Party Room"
4 => "Security/Concierge"
5 => "Visitor Parking"
]
+"CoListOfficeKey2": "283559"
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-12T15:30:31.96Z"
+"ListAgentNationalAssociationId": "1330795"
+"ListOfficeNationalAssociationId": "1331640"
+"CoListAgentNationalAssociationId": "1261055"
+"CoListAgentNationalAssociationId2": "1348519"
+"CoListOfficeNationalAssociationId": "1331640"
+"CoListOfficeNationalAssociationId2": "1331640"
+"Media": array:21 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29895188_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895188/1f17e78b538eeb0c0f9ab68e3301e1b5.webp"
"MediaSize" => 251521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895188/thumbnail-1f17e78b538eeb0c0f9ab68e3301e1b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13436674"
"ResourceRecordKey" => "29895188"
"ModificationTimestamp" => "2026-06-12T15:30:31.97Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29895188_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895188/0cae3e4b1358cee971aa27d9078bf6f2.webp"
"MediaSize" => 232299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895188/thumbnail-0cae3e4b1358cee971aa27d9078bf6f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436674"
"ResourceRecordKey" => "29895188"
"ModificationTimestamp" => "2026-06-12T15:30:31.97Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29895188_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895188/45b0535e032d9493f8fd38136d1be9dd.webp"
"MediaSize" => 189055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895188/thumbnail-45b0535e032d9493f8fd38136d1be9dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436674"
"ResourceRecordKey" => "29895188"
"ModificationTimestamp" => "2026-06-12T15:30:31.97Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29895188_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895188/cdbb3c06357d31cf29b89692504d9f0e.webp"
"MediaSize" => 189827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895188/thumbnail-cdbb3c06357d31cf29b89692504d9f0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436674"
"ResourceRecordKey" => "29895188"
"ModificationTimestamp" => "2026-06-12T15:30:31.97Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29895188_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895188/de1362856b874d393fa7e483e95aa990.webp"
"MediaSize" => 219077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895188/thumbnail-de1362856b874d393fa7e483e95aa990.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436674"
"ResourceRecordKey" => "29895188"
"ModificationTimestamp" => "2026-06-12T15:30:31.97Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29895188_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895188/72991dedd654ad1e1cc0b4af80542136.webp"
"MediaSize" => 225537
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895188/thumbnail-72991dedd654ad1e1cc0b4af80542136.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436674"
"ResourceRecordKey" => "29895188"
"ModificationTimestamp" => "2026-06-12T15:30:31.97Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29895188_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895188/84f183f408ff670120f1c265a8ec2e17.webp"
"MediaSize" => 228959
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895188/thumbnail-84f183f408ff670120f1c265a8ec2e17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436674"
"ResourceRecordKey" => "29895188"
"ModificationTimestamp" => "2026-06-12T15:30:31.97Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29895188_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895188/477e2a07ed9ed80731daa748faff64db.webp"
"MediaSize" => 230447
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895188/thumbnail-477e2a07ed9ed80731daa748faff64db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436674"
"ResourceRecordKey" => "29895188"
"ModificationTimestamp" => "2026-06-12T15:30:31.97Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29895188_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895188/fba2af46666a652386955a178445d242.webp"
"MediaSize" => 155041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895188/thumbnail-fba2af46666a652386955a178445d242.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436674"
"ResourceRecordKey" => "29895188"
"ModificationTimestamp" => "2026-06-12T15:30:31.97Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29895188_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895188/5045afe74f5eb588ddb229f783969feb.webp"
"MediaSize" => 206509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895188/thumbnail-5045afe74f5eb588ddb229f783969feb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436674"
"ResourceRecordKey" => "29895188"
"ModificationTimestamp" => "2026-06-12T15:30:31.97Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29895188_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895188/6028d07e6eee3e64d7d84e1014fb8fa3.webp"
"MediaSize" => 244802
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895188/thumbnail-6028d07e6eee3e64d7d84e1014fb8fa3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13436674"
"ResourceRecordKey" => "29895188"
"ModificationTimestamp" => "2026-06-12T15:30:31.97Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29895188_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895188/d2d07a3c97ff21b37eb400b1838b5d0e.webp"
"MediaSize" => 104526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895188/thumbnail-d2d07a3c97ff21b37eb400b1838b5d0e.webp"
"ResourceName" => "Property"
…6
]
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895188')"
+"ID": "1525412"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25179
+post_id: "1522395"
+post_author: 1
+"ListingKey": "29893408"
+"ListingId": "X13435152"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T01:50:03Z"
+"RFModificationTimestamp": "2026-06-12T02:06:20Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H4"
+"UnparsedAddress": "617 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L0R2H4"
+"Coordinates": array:2 [
0 => -79.880553
1 => 43.342598
]
+"Latitude": 43.342598
+"Longitude": -79.880553
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "State of the Art Trend Condos. This unit boosts 792 sq. ft., one of the largest one bedroom plus den units available. Located on the 6th floor, this unit offers spacious, modern living with 1bedroom plus den ideal for a home office or additional bedroom. A fantastic open-concept layout featuring upgraded appliances, breakfast bar & sleek laminate flooring in the great room. The openness of the kitchen allows you to enjoy the bright living area, perfect for entertaining and viewing the great outdoors. An upgraded private balcony gives you unobstructed views. A generously sized bedroom with walk-in closet & a 4 piece bathroom finished with modern fixtures. Additional features include convenient in-unit laundry and a storage locker located on the same floor. Added bonus this unit comes with one designated underground & one surface parking spot very much high in demand.. Minutes away from local amenities, Hwy 403/407 making for an easier commute. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T02:06:15.192807+00:00"
+"Directions": "Cross Streets: Dundas St E & Mallard Trail. ** Directions: Dundas St E and Mallard Trail."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1995891"
+"ListOfficeKey": "268183"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-12T01:41:46Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T01:41:46Z"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"Rooms": array:1 [
0 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29893408/617-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 2350
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-12T01:41:46.22Z"
+"ListAgentNationalAssociationId": "1278700"
+"ListOfficeNationalAssociationId": "1230066"
+"Media": array:26 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29893408')"
+"ID": "1522395"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25177
+post_id: "1518871"
+post_author: 1
+"ListingKey": "29889028"
+"ListingId": "X13431622"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T17:25:21Z"
+"RFModificationTimestamp": "2026-06-11T17:32:52Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "101 - 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 bright and stylish 1-bedroom, 1-bathroom suite offers a rare combination of convenience and value, featuring 2 underground parking spaces and a locker. Designed with an open-concept layout, the unit showcases 10 ft. ceilings, floor-to-ceiling windows, and abundant natural light. The modern kitchen includes stainless steel appliances, a breakfast bar, and overlooks the spacious living area with walkout access to a private balcony. The generous primary bedroom features a double closet and large windows, while in-suite laundry adds everyday convenience. Residents enjoy exceptional amenities including a fitness centre, party room, rooftop terrace with BBQs, bike storage, and a games area. Ideally situated close to shopping, restaurants, parks, schools, major highways, and Aldershot GO Station, this is an excellent opportunity to enjoy comfortable, low-maintenance living in one of Waterdown's most desirable communities. (id:62783)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T16:23:46.285604+00:00"
+"Directions": "Dundas St E & Mallard Tr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1905394"
+"ListOfficeKey": "291889"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-11T16:38:12Z"
+"PhotosCount": 25
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T16:58:25Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"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/29889028/101-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "WCC"
+"GeocodeManualYN": false
+"TotalActualRent": 2100
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-11T15:59:16.29Z"
+"ListAgentNationalAssociationId": "1219523"
+"ListOfficeNationalAssociationId": "1406077"
+"Media": array:25 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889028')"
+"ID": "1518871"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25172
+post_id: "1518398"
+post_author: 1
+"ListingKey": "29885326"
+"ListingId": "40838753"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T21:25:15Z"
+"RFModificationTimestamp": "2026-06-11T02:31:08Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 667.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H4"
+"UnparsedAddress": "470 DUNDAS Street E Unit# 103, Waterdown, Ontario L0R2H4"
+"Coordinates": array:2 [
0 => -79.8790501
1 => 43.3433857
]
+"Latitude": 43.3433857
+"Longitude": -79.8790501
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This beautiful 1+1 first floor unit is move-in ready with no prior occupants. Outfitted with brand-new stainless-steel appliances, in-suite laundry, walk-in closet, 10-foot ceilings, and a spacious den! Enjoy party rooms, modern fitness facilities with yoga studio, rooftop patios with fully equipped barbeques and bike storage. One locker on same floor & one underground parking space! Short walk to Waterdown village shops, parks and restaurants. 10 min from Aldershot GO, 15 min from downtown Burlington, 18 min to downtown Hamilton. (id:62783)"
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T02:31:00.955515+00:00"
+"Directions": "Dundas St E"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2202234"
+"ListOfficeKey": "262664"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-10T21:20:03Z"
+"PhotosCount": 10
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T21:20:03Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"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/29885326/470-dundas-street-e-unit-103-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2200
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 667
+"OriginalEntryTimestamp": "2026-06-10T21:20:03.09Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1450779"
+"ListOfficeNationalAssociationId": "1223042"
+"Media": array:10 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29885326')"
+"ID": "1518398"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1516497"
+post_author: 1
+"ListingKey": "29884559"
+"ListingId": "X13427384"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T19:40:15Z"
+"RFModificationTimestamp": "2026-06-10T21:23:05Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H7"
+"UnparsedAddress": "11 HAGER CREEK TERRACE, Hamilton (Waterdown), Ontario L0R2H7"
+"Coordinates": array:2 [
0 => -79.87472
1 => 43.34137
]
+"Latitude": 43.34137
+"Longitude": -79.87472
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "FURNISHED! FURNISHED! FURNISHED! Welcome to 11 Hager Creek Terrace, a beautifully appointed, fully furnished semi-detached home offering the perfect blend of modern luxury and small-town charm. Designed with a highly functional layout, this bright and airy home features soaring 9-foot ceilings across both the main and second floors, creating a spacious, open atmosphere. Perfect for families, professionals, or those relocating, this turn-key property is situated in an exceptional Waterdown location. Enjoy seamless commuting with quick access to Highways 403, 407, and the QEW, as well as the Aldershot GO Station. Property Highlights: Move-In Ready: Fully and tastefully furnished for your convenience. Premium Layout: Expansive Great Room ideal for relaxing or entertaining, with 9ft ceilings throughout. Prime Location: Minutes from Joseph Brant Memorial Hospital, top-ranked schools, and local libraries. Nature at Your Doorstep: Nestled atop the Niagara Escarpment, you are surrounded by lush parks, protected greenbelts, hiking trails, and local waterfalls. Discover a unique, vibrant community where you can truly live, work, and play. The Full Furnished House Price is $3800 which includes all furniture (id:62783)"
+"Basement": array:2 [
0 => "Separate entrance"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T21:22:54.293399+00:00"
+"Directions": "Cross Streets: Dundas St E/Skinner Rd. ** Directions: Great Blvd/Skinner Rd."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2095009"
+"ListOfficeKey": "279090"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "17.7 x 90.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T19:32:37Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T19:32:36Z"
+"Stories": "2.0"
+"StreetName": "Hager Creek"
+"StreetNumber": "11"
+"StreetSuffix": "Terrace"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29884559/11-hager-creek-terrace-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3500
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 17.8
+"OriginalEntryTimestamp": "2026-06-10T19:32:36.93Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1367249"
+"ListOfficeNationalAssociationId": "1301519"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29884559')"
+"ID": "1516497"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25180
+post_id: "1505049"
+post_author: 1
+"ListingKey": "29867801"
+"ListingId": "40837575"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-07T20:56:03Z"
+"RFModificationTimestamp": "2026-06-07T22:37:15Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 657.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "450 DUNDAS Street Unit# 708, Waterdown, Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.8803533
1 => 43.3425206
]
+"Latitude": 43.3425206
+"Longitude": -79.8803533
+"YearBuilt": 2022
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning 1 + 1 bedroom, 1 bathroom condo by the award-winning New Horizon Development Group. This bright, modern unit boasts stainless steel kitchen appliances, laminate flooring throughout, in-suite laundry, 1 storage locker and 1 underground parking spot! The building offers fantastic amenities, including a gym, party room, and a rooftop patio. Conveniently located near GO Stations, major highways, shopping centers, and a variety of restaurants, this condo perfectly combines style and convenience. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:1 [
0 => "Exterior Maintenance"
]
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-07T22:37:08.940880+00:00"
+"Directions": "Dundas Street east to Mallard Trail - first building in the TREND Development."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Other"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007461"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-07T20:49:24Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-07T20:49:24Z"
+"Stories": "1.0"
+"StreetName": "DUNDAS"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"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/29867801/450-dundas-street-unit-708-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2250
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 657
+"OriginalEntryTimestamp": "2026-06-07T20:49:24.59Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1289513"
+"ListOfficeNationalAssociationId": "1344653"
+"Media": array:27 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29867801')"
+"ID": "1505049"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25181
+post_id: "1505054"
+post_author: 1
+"ListingKey": "29867874"
+"ListingId": "X13412396"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-07T21:55:59Z"
+"RFModificationTimestamp": "2026-06-07T22:34:34Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "708 - 450 DUNDAS STREET, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.880553
1 => 43.342598
]
+"Latitude": 43.342598
+"Longitude": -79.880553
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning 1 + 1 bedroom, 1 bathroom condo by the award-winning New Horizon Development Group. This bright, modern unit boasts stainless steel kitchen appliances, laminate flooring throughout, in-suite laundry, 1 storage locker and 1 underground parking spot! The building offers fantastic amenities, including a gym, party room, and a rooftop patio. Conveniently located near GO Stations, major highways, shopping centers, and a variety of restaurants, this condo perfectly combines style and convenience. (id:62650)"
+"Appliances": array:2 [
0 => "Intercom"
1 => "Garage door opener remote(s)"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"CreationDate": "2026-06-07T22:34:30.871737+00:00"
+"Directions": "Cross Streets: Riverwalk Dr. ** Directions: Mallard Trail."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092595"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Elevator"
1 => "Balcony"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-07T21:46:36Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-07T21:46:35Z"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29867874/708-450-dundas-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 2250
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-07T21:46:35.65Z"
+"ListAgentNationalAssociationId": "1365159"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:27 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29867874')"
+"ID": "1505054"
}
]
+success: true
+page_size: 9
+page_count: 5
+count: 44
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]