array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29957204 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23470
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23472
+post_id: "1569634"
+post_author: 1
+"ListingKey": "29957204"
+"ListingId": "X13492626"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T17:50:02Z"
+"RFModificationTimestamp": "2026-07-09T17:53:12Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "314 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Trend Living in Waterdown! This bright and move-in-ready 1-bedroom, 1-bathroom condo features hardwood flooring throughout, premium upgrades, a modern kitchen with beautiful countertops and stainless steel appliances, and an open-concept layout filled with natural light. Enjoy the convenience of in-suite laundry, one surface parking space, and one locker. Residents enjoy exceptional amenities including a rooftop terrace with BBQs, gym, and party room. Ideally located close to hiking and biking trails, Train Station, and just a short drive to Ontario's renowned wineries, this stylish condo offers the perfect blend of comfort and convenience. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Multi-level"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T17:14:14.160950+00:00"
+"Directions": "Dundas/ Mallard Trail"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2259210"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T14:20:12Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T17:40:26Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1679273727"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13492626"
"RoomLevel" => "Main level"
"RoomWidth" => 3.08
"ListingKey" => "29957204"
"RoomLength" => 2.83
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T17:40:26.16Z"
]
1 => array:11 [
"RoomKey" => "1679273728"
"RoomType" => "Bathroom"
"ListingId" => "X13492626"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29957204"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T17:40:26.16Z"
]
2 => array:11 [
"RoomKey" => "1679273729"
"RoomType" => "Kitchen"
"ListingId" => "X13492626"
"RoomLevel" => "Main level"
"RoomWidth" => 2.28
"ListingKey" => "29957204"
"RoomLength" => 2.37
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T17:40:26.16Z"
]
3 => array:11 [
"RoomKey" => "1679273730"
"RoomType" => "Great room"
"ListingId" => "X13492626"
"RoomLevel" => "Main level"
"RoomWidth" => 3.99
"ListingKey" => "29957204"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T17:40:26.16Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29957204/314-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 1950
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-26T14:20:12.78Z"
+"ListAgentNationalAssociationId": "1499122"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:26 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29957204_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/9673a11a9639e01102a4e2516af1c44e.webp"
"MediaSize" => 162364
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-9673a11a9639e01102a4e2516af1c44e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29957204_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/12b3176c1a1dfd1b6511849418399021.webp"
"MediaSize" => 126758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-12b3176c1a1dfd1b6511849418399021.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29957204_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/93288fd34494dc3e4dd6f5b4c3a11f8a.webp"
"MediaSize" => 156060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-93288fd34494dc3e4dd6f5b4c3a11f8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29957204_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/dcec0fd04fb47ad48f3dd5a10423b9c8.webp"
"MediaSize" => 138117
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-dcec0fd04fb47ad48f3dd5a10423b9c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29957204_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/54aabfef1bdefba6883f1799f3bd330a.webp"
"MediaSize" => 75287
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-54aabfef1bdefba6883f1799f3bd330a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29957204_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/2f19908c27c3dfcb10a0920ae4db0575.webp"
"MediaSize" => 72013
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-2f19908c27c3dfcb10a0920ae4db0575.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29957204_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/37ed754d92e575f0ce5af940424e712c.webp"
"MediaSize" => 56885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-37ed754d92e575f0ce5af940424e712c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29957204_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/84ece3b83a8e259f6dae9b3434984ec6.webp"
"MediaSize" => 77575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-84ece3b83a8e259f6dae9b3434984ec6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29957204_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/44bfbbbbac1533a9a2fd1e709e5ec336.webp"
"MediaSize" => 80669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-44bfbbbbac1533a9a2fd1e709e5ec336.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29957204_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/845cf8437cabd3e625bbd5cd6c6d9f44.webp"
"MediaSize" => 63465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-845cf8437cabd3e625bbd5cd6c6d9f44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29957204_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/81e91991a00f769e85efde0301500d9c.webp"
"MediaSize" => 71468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-81e91991a00f769e85efde0301500d9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29957204_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/41b24589da9c5b54ea5c1770547b074d.webp"
"MediaSize" => 61101
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-41b24589da9c5b54ea5c1770547b074d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29957204_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/85a77509a0035af7a893c4838783cadc.webp"
"MediaSize" => 62126
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-85a77509a0035af7a893c4838783cadc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29957204_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/f3e73e01605d0985b671626663527cc0.webp"
"MediaSize" => 63213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-f3e73e01605d0985b671626663527cc0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29957204_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/7105d775842a94e806210a1ecca06487.webp"
"MediaSize" => 50666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-7105d775842a94e806210a1ecca06487.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29957204_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/9329f00eb3d4c3385fcb6e458e2cc94f.webp"
"MediaSize" => 49427
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-9329f00eb3d4c3385fcb6e458e2cc94f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29957204_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/ccfc9d32f322e2a30b6fdc142a2a8a41.webp"
"MediaSize" => 50912
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-ccfc9d32f322e2a30b6fdc142a2a8a41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29957204_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/62847c375804358333eeea8dd7122f32.webp"
"MediaSize" => 97730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-62847c375804358333eeea8dd7122f32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29957204_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/7cc3de8911d2d78927e2c72fa6136f1d.webp"
"MediaSize" => 77294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-7cc3de8911d2d78927e2c72fa6136f1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29957204_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/1c4bb849bb619d10769dd1d61d77668a.webp"
"MediaSize" => 61321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-1c4bb849bb619d10769dd1d61d77668a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29957204_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/b6cd720ac9ec25d6f989d2b1e892f89a.webp"
"MediaSize" => 47231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-b6cd720ac9ec25d6f989d2b1e892f89a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29957204_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/b07c205c82eb8fa816d1f44fc5dec8b3.webp"
"MediaSize" => 31734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-b07c205c82eb8fa816d1f44fc5dec8b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29957204_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/94ac4866a5f7bee9daa6af3b878eff88.webp"
"MediaSize" => 51979
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-94ac4866a5f7bee9daa6af3b878eff88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29957204_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/6669135d6a40de290cea2d94f63178a9.webp"
"MediaSize" => 51573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-6669135d6a40de290cea2d94f63178a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29957204_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/64236a246bbef743cadad475e0430f9a.webp"
"MediaSize" => 102482
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-64236a246bbef743cadad475e0430f9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29957204_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/4ec64d7cdc8975310104cb1242f37f21.webp"
"MediaSize" => 108469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-4ec64d7cdc8975310104cb1242f37f21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
]
+"DaysOnMarket": 17
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29957204')"
+"ID": "1569634"
}
]
+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=OfficeKey eq 266588" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24956
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24864
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX ESCARPMENT REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "905-639-7676"
+"OfficeMlsId": "184000"
+"ModificationTimestamp": "2026-06-16T17:41:24Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "266588"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "2180 ITABASHI WAY #4B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "BURLINGTON"
+"OfficePostalCode": "L7M5A"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1274323"
+"OriginalEntryTimestamp": "2011-09-09T03:45:00Z"
+"OfficeFax": "905-681-9908"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "324280"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "266588"
"SocialMediaUrlOrId" => "http://www.remaxescarpment.com/"
"ModificationTimestamp" => "2026-06-16T17:35:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1499122"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('266588')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2259210" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24937
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29957204'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25245
+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 '29957204' AND OpenHouseDate ge '2026-07-12'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25261
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29957204' 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.878916 43.343831)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25314
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25308
+post_id: 1620460
+post_author: 1
+"ListingKey": "30025680"
+"ListingId": "X13556850"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T16:50:07Z"
+"RFModificationTimestamp": "2026-07-13T19:35:10Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H4"
+"UnparsedAddress": "409 - 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": "Welcome to Trend Living in the heart of Waterdown, where modern luxury meets everyday convenience. This brand-new 1-bedroom, 1-bathroom condominium offers a thoughtfully designed open-concept layout with premium finishes and contemporary style throughout, making it the perfect opportunity for first-time buyers, professionals, downsizers, or investors. Step inside to discover an elegant interior featuring quartz countertops throughout, upgraded tile and trim packages, stainless steel appliances, in-suite laundry, and quality finishes that provide both comfort and sophistication. Complete with a dedicated parking space and private storage locker, this unit offers everything you need for easy, low-maintenance living. Residents of Trend Living enjoy an exceptional collection of amenities, including stunning rooftop terraces with BBQ areas, stylish party rooms, fully equipped fitness facilities, and inviting social spaces designed to complement your lifestyle. Perfectly situated close to schools, parks, shopping, restaurants, and everyday amenities, with quick access to major highways for an easy commute, this location offers the ideal balance of urban convenience and small-town charm. Whether you're looking for your first home, a turnkey investment, or a stylish place to downsize, this exceptional condo delivers modern living at its finest. Stop searching-your next chapter begins at Trend Living. Available anytime after September 8 (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T19:34:58.641244+00:00"
+"Directions": "MALLARD TRAIL"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2093886"
+"ListOfficeKey": "284792"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T16:40:12Z"
+"PhotosCount": 19
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T16:40:12Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1683154598"
"RoomType" => "Kitchen"
"ListingId" => "X13556850"
"RoomLevel" => "Main level"
"RoomWidth" => 2.26
"ListingKey" => "30025680"
"RoomLength" => 2.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-13T16:40:12.11Z"
]
1 => array:11 [
"RoomKey" => "1683154599"
"RoomType" => "Great room"
"ListingId" => "X13556850"
"RoomLevel" => "Main level"
"RoomWidth" => 4.8
"ListingKey" => "30025680"
"RoomLength" => 3.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-13T16:40:12.12Z"
]
2 => array:11 [
"RoomKey" => "1683154600"
"RoomType" => "Bedroom"
"ListingId" => "X13556850"
"RoomLevel" => "Main level"
"RoomWidth" => 3.25
"ListingKey" => "30025680"
"RoomLength" => 2.69
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-13T16:40:12.12Z"
]
3 => array:11 [
"RoomKey" => "1683154601"
"RoomType" => "Bathroom"
"ListingId" => "X13556850"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "30025680"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-13T16:40:12.12Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30025680/409-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "N/A"
+"GeocodeManualYN": false
+"TotalActualRent": 1949
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-13T16:40:11.9Z"
+"ListAgentNationalAssociationId": "1366297"
+"ListOfficeNationalAssociationId": "1344891"
+"Media": array:19 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30025680_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025680/2fd734c1679d93cf7a45bdf2371ad6f5.webp"
"MediaSize" => 108974
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025680/thumbnail-2fd734c1679d93cf7a45bdf2371ad6f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13556850"
"ResourceRecordKey" => "30025680"
"ModificationTimestamp" => "2026-07-13T16:40:11.91Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30025680_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025680/bec1b665dfc5c60e34d86e3ee990da4f.webp"
"MediaSize" => 178634
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025680/thumbnail-bec1b665dfc5c60e34d86e3ee990da4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556850"
"ResourceRecordKey" => "30025680"
"ModificationTimestamp" => "2026-07-13T16:40:11.91Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30025680_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025680/beab337e107187d91f8104c36aea5034.webp"
"MediaSize" => 153579
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025680/thumbnail-beab337e107187d91f8104c36aea5034.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556850"
"ResourceRecordKey" => "30025680"
"ModificationTimestamp" => "2026-07-13T16:40:11.91Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30025680_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025680/ad5d36e8b4b6939ca4943a9de4374596.webp"
"MediaSize" => 100310
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025680/thumbnail-ad5d36e8b4b6939ca4943a9de4374596.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556850"
"ResourceRecordKey" => "30025680"
"ModificationTimestamp" => "2026-07-13T16:40:11.91Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30025680_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025680/7fcf2172b311aa454a5f62e4f1497a7b.webp"
"MediaSize" => 89990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025680/thumbnail-7fcf2172b311aa454a5f62e4f1497a7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556850"
"ResourceRecordKey" => "30025680"
"ModificationTimestamp" => "2026-07-13T16:40:11.91Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30025680_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025680/943172e2e8fc0bd82b14b79538a216e5.webp"
"MediaSize" => 156883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025680/thumbnail-943172e2e8fc0bd82b14b79538a216e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "VIRTUALLY STAGED"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556850"
"ResourceRecordKey" => "30025680"
"ModificationTimestamp" => "2026-07-13T16:40:11.91Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30025680_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025680/377ab38e8c89427ca961aa5679289df1.webp"
"MediaSize" => 37078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025680/thumbnail-377ab38e8c89427ca961aa5679289df1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556850"
"ResourceRecordKey" => "30025680"
"ModificationTimestamp" => "2026-07-13T16:40:11.91Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30025680_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025680/b06860ba448c6b86f14773a5f1017822.webp"
"MediaSize" => 42028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025680/thumbnail-b06860ba448c6b86f14773a5f1017822.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556850"
"ResourceRecordKey" => "30025680"
"ModificationTimestamp" => "2026-07-13T16:40:11.91Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30025680_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025680/361fcdcab2eac4838de575d78c11bdbf.webp"
"MediaSize" => 124891
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025680/thumbnail-361fcdcab2eac4838de575d78c11bdbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "VIRTUALLY STAGED"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556850"
"ResourceRecordKey" => "30025680"
"ModificationTimestamp" => "2026-07-13T16:40:11.91Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30025680_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025680/d2c128f5ead969270bfb617d2d5a543b.webp"
"MediaSize" => 54082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025680/thumbnail-d2c128f5ead969270bfb617d2d5a543b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556850"
"ResourceRecordKey" => "30025680"
"ModificationTimestamp" => "2026-07-13T16:40:11.91Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30025680_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025680/3e00fbeecd620998fcb1a5ed79a488a8.webp"
"MediaSize" => 44278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025680/thumbnail-3e00fbeecd620998fcb1a5ed79a488a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556850"
"ResourceRecordKey" => "30025680"
"ModificationTimestamp" => "2026-07-13T16:40:11.91Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30025680_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025680/3b887791dbfd1948f54499642562e8c9.webp"
"MediaSize" => 34279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025680/thumbnail-3b887791dbfd1948f54499642562e8c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556850"
"ResourceRecordKey" => "30025680"
"ModificationTimestamp" => "2026-07-13T16:40:11.91Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30025680_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025680/152bbac8458311f0475766be5cbd8de5.webp"
"MediaSize" => 131122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025680/thumbnail-152bbac8458311f0475766be5cbd8de5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "VIRTUALLY STAGED"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556850"
"ResourceRecordKey" => "30025680"
"ModificationTimestamp" => "2026-07-13T16:40:11.91Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30025680_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025680/3b0902c49404fa9accdf9e9b016acabe.webp"
"MediaSize" => 117953
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025680/thumbnail-3b0902c49404fa9accdf9e9b016acabe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "VIRTUALLY STAGED"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556850"
"ResourceRecordKey" => "30025680"
"ModificationTimestamp" => "2026-07-13T16:40:11.91Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30025680_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025680/c8a80b0a2c93f4af4c0a6cdeabdf7717.webp"
"MediaSize" => 88596
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025680/thumbnail-c8a80b0a2c93f4af4c0a6cdeabdf7717.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556850"
"ResourceRecordKey" => "30025680"
"ModificationTimestamp" => "2026-07-13T16:40:11.91Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30025680_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025680/99e3b5f9f9dc484ff69990bea6adbfe4.webp"
"MediaSize" => 87951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025680/thumbnail-99e3b5f9f9dc484ff69990bea6adbfe4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556850"
"ResourceRecordKey" => "30025680"
"ModificationTimestamp" => "2026-07-13T16:40:11.91Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30025680_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025680/f395fdcc5218580aa1138578f2f2f7d3.webp"
"MediaSize" => 116988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025680/thumbnail-f395fdcc5218580aa1138578f2f2f7d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556850"
"ResourceRecordKey" => "30025680"
"ModificationTimestamp" => "2026-07-13T16:40:11.91Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30025680_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025680/40e78ba91928825b099aff76ad0922f0.webp"
"MediaSize" => 89206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025680/thumbnail-40e78ba91928825b099aff76ad0922f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556850"
"ResourceRecordKey" => "30025680"
"ModificationTimestamp" => "2026-07-13T16:40:11.91Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30025680_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025680/d6cc6ba5c6a0708441d20b89b9bd6a25.webp"
"MediaSize" => 89119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025680/thumbnail-d6cc6ba5c6a0708441d20b89b9bd6a25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556850"
"ResourceRecordKey" => "30025680"
"ModificationTimestamp" => "2026-07-13T16:40:11.91Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30025680')"
+"ID": 1620460
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25310
+post_id: "1618853"
+post_author: 1
+"ListingKey": "30024851"
+"ListingId": "40847467"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T15:05:55Z"
+"RFModificationTimestamp": "2026-07-13T15:21:40Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 531.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "450 DUNDAS Street Unit# 409, Waterdown, Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.8799404
1 => 43.3426739
]
+"Latitude": 43.3426739
+"Longitude": -79.8799404
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Trend Living in the heart of Waterdown, where modern luxury meets everyday convenience. This brand-new 1-bedroom, 1-bathroom condominium offers a thoughtfully designed open-concept layout with premium finishes and contemporary style throughout, making it the perfect opportunity for first-time buyers, professionals, downsizers, or investors. Step inside to discover an elegant interior featuring quartz countertops throughout, upgraded tile and trim packages, stainless steel appliances, in-suite laundry, and quality finishes that provide both comfort and sophistication. Complete with a dedicated parking space and private storage locker, this unit offers everything you need for easy, low-maintenance living. Residents of Trend Living enjoy an exceptional collection of amenities, including stunning rooftop terraces with BBQ areas, stylish party rooms, fully equipped fitness facilities, and inviting social spaces designed to complement your lifestyle. Perfectly situated close to schools, parks, shopping, restaurants, and everyday amenities, with quick access to major highways for an easy commute, this location offers the ideal balance of urban convenience and small-town charm. Whether you're looking for your first home, a turnkey investment, or a stylish place to downsize, this exceptional condo delivers modern living at its finest. Stop searching—your next chapter begins at Trend Living. Available anytime after September 8 (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T15:21:36.587803+00:00"
+"Directions": "MALLARD TRAIL"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:1 [
0 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1879839"
+"ListOfficeKey": "284635"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-13T14:59:21Z"
+"PhotosCount": 19
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T14:59:21Z"
+"Stories": "1.0"
+"StreetName": "DUNDAS"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1683063040"
"RoomType" => "4pc Bathroom"
"ListingId" => "40847467"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024851"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T14:59:21.87Z"
]
1 => array:11 [
"RoomKey" => "1683063042"
"RoomType" => "Bedroom"
"ListingId" => "40847467"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024851"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T14:59:21.87Z"
]
2 => array:11 [
"RoomKey" => "1683063044"
"RoomType" => "Great room"
"ListingId" => "40847467"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024851"
"RoomLength" => null
"RoomDimensions" => "15'9'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T14:59:21.87Z"
]
3 => array:11 [
"RoomKey" => "1683063046"
"RoomType" => "Kitchen"
"ListingId" => "40847467"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024851"
"RoomLength" => null
"RoomDimensions" => "7'5'' x 7'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T14:59:21.87Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30024851/450-dundas-street-unit-409-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1975734"
+"CommonInterest": "Condo/Strata"
+"CoListAgentKey2": "1663133"
+"CoListOfficeKey": "54949"
+"GeocodeManualYN": true
+"TotalActualRent": 1949
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"CoListOfficeKey2": "54949"
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 531
+"OriginalEntryTimestamp": "2026-07-13T14:59:21.84Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1205864"
+"ListOfficeNationalAssociationId": "1344652"
+"CoListAgentNationalAssociationId": "1262343"
+"CoListAgentNationalAssociationId2": "1168399"
+"CoListOfficeNationalAssociationId": "1003557"
+"CoListOfficeNationalAssociationId2": "1003557"
+"Media": array:19 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30024851_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024851/a235eda1ec2ba92fcd910cd8131b21fb.webp"
"MediaSize" => 107809
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024851/thumbnail-a235eda1ec2ba92fcd910cd8131b21fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary high-rise architecture featuring extensive glass curtain walls, multiple private balconies, and a distinctive multi-level design"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40847467"
"ResourceRecordKey" => "30024851"
"ModificationTimestamp" => "2026-07-13T14:59:21.85Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30024851_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024851/b3a5992cb41c3128a7dd136a2767f4cb.webp"
"MediaSize" => 176668
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024851/thumbnail-b3a5992cb41c3128a7dd136a2767f4cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Community sign"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847467"
"ResourceRecordKey" => "30024851"
"ModificationTimestamp" => "2026-07-13T14:59:21.85Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30024851_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024851/441d00337665c7982097c5dd30e0ec27.webp"
"MediaSize" => 149532
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024851/thumbnail-441d00337665c7982097c5dd30e0ec27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern architectural facade featuring a prominent central entrance with expansive glass doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847467"
"ResourceRecordKey" => "30024851"
"ModificationTimestamp" => "2026-07-13T14:59:21.85Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30024851_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024851/dc08cdbbf17a9228ab1cea6f0fd6ab95.webp"
"MediaSize" => 98283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024851/thumbnail-dc08cdbbf17a9228ab1cea6f0fd6ab95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lobby"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847467"
"ResourceRecordKey" => "30024851"
"ModificationTimestamp" => "2026-07-13T14:59:21.85Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30024851_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024851/f329847d396072119a6d519782422ea3.webp"
"MediaSize" => 88070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024851/thumbnail-f329847d396072119a6d519782422ea3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Central fireplace feature with wood paneling and teal mosaic tile surround"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847467"
"ResourceRecordKey" => "30024851"
"ModificationTimestamp" => "2026-07-13T14:59:21.85Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30024851_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024851/5d9cd243e2d8b31f696dee7b405c78a6.webp"
"MediaSize" => 75883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024851/thumbnail-5d9cd243e2d8b31f696dee7b405c78a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "AI PHOTO"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847467"
"ResourceRecordKey" => "30024851"
"ModificationTimestamp" => "2026-07-13T14:59:21.85Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30024851_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024851/7cc095e5f167684abebec2bcf6af830e.webp"
"MediaSize" => 34058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024851/thumbnail-7cc095e5f167684abebec2bcf6af830e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white shaker cabinetry, stainless steel appliances, a white solid surface island, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847467"
"ResourceRecordKey" => "30024851"
"ModificationTimestamp" => "2026-07-13T14:59:21.85Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30024851_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024851/9f28b904d2afcc157ad79f7a4d5b80ad.webp"
"MediaSize" => 39543
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024851/thumbnail-9f28b904d2afcc157ad79f7a4d5b80ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white cabinetry, stainless steel appliances, a white solid surface countertop, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847467"
"ResourceRecordKey" => "30024851"
"ModificationTimestamp" => "2026-07-13T14:59:21.85Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30024851_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024851/2fc8ac90d404c5b2e30b391d5acc8df8.webp"
"MediaSize" => 52773
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024851/thumbnail-2fc8ac90d404c5b2e30b391d5acc8df8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "AI PHOTO"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847467"
"ResourceRecordKey" => "30024851"
"ModificationTimestamp" => "2026-07-13T14:59:21.85Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30024851_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024851/0706779e32577737ff72e1108ffd2eaf.webp"
"MediaSize" => 48554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024851/thumbnail-0706779e32577737ff72e1108ffd2eaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847467"
"ResourceRecordKey" => "30024851"
"ModificationTimestamp" => "2026-07-13T14:59:21.85Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30024851_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024851/6065e41c53090b02f4144064fa6862f8.webp"
"MediaSize" => 41800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024851/thumbnail-6065e41c53090b02f4144064fa6862f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area with wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847467"
"ResourceRecordKey" => "30024851"
"ModificationTimestamp" => "2026-07-13T14:59:21.85Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30024851_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024851/a7ec5c71a7ae9b9c883ae1d8faaef618.webp"
"MediaSize" => 31485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024851/thumbnail-a7ec5c71a7ae9b9c883ae1d8faaef618.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a built-in bathtub with subway tile surround, a toilet, a vanity with an integrated sink and light-toned countertop, and large format floor tiles with subtle veining"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847467"
"ResourceRecordKey" => "30024851"
"ModificationTimestamp" => "2026-07-13T14:59:21.85Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30024851_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024851/1e03a04b10ba2b93740caa61e0365a97.webp"
"MediaSize" => 53885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024851/thumbnail-1e03a04b10ba2b93740caa61e0365a97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "AI PHOTO"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847467"
"ResourceRecordKey" => "30024851"
"ModificationTimestamp" => "2026-07-13T14:59:21.85Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30024851_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024851/7df05279d2b874e029e733f8545eab8c.webp"
"MediaSize" => 46678
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024851/thumbnail-7df05279d2b874e029e733f8545eab8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "AI PHOTO"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847467"
"ResourceRecordKey" => "30024851"
"ModificationTimestamp" => "2026-07-13T14:59:21.85Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30024851_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024851/8ea4034c0914cf78888f94aaec4094ab.webp"
"MediaSize" => 86124
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024851/thumbnail-8ea4034c0914cf78888f94aaec4094ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fitness room featuring multiple treadmills, wood-finish flooring, a full-length wall mirror, recessed lighting, and a window with roller blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847467"
"ResourceRecordKey" => "30024851"
"ModificationTimestamp" => "2026-07-13T14:59:21.85Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30024851_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024851/f44a0783f8b708971c94bf030b7db412.webp"
"MediaSize" => 85486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024851/thumbnail-f44a0783f8b708971c94bf030b7db412.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fitness center featuring wood-finish flooring, recessed lighting, and expansive windows with roller shades"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847467"
"ResourceRecordKey" => "30024851"
"ModificationTimestamp" => "2026-07-13T14:59:21.85Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30024851_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024851/db55569708df3649131dbda7cfe9c1c2.webp"
"MediaSize" => 114336
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024851/thumbnail-db55569708df3649131dbda7cfe9c1c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated bicycle storage room featuring a concrete floor, white walls, and a large window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847467"
"ResourceRecordKey" => "30024851"
"ModificationTimestamp" => "2026-07-13T14:59:21.85Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30024851_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024851/82c23dea8d5421c1028747ecc03a99cd.webp"
"MediaSize" => 85913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024851/thumbnail-82c23dea8d5421c1028747ecc03a99cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Recreational room featuring a black billiards table, coffered ceiling, wood-finish flooring, paneled wall detailing, and a circular dining table with seating"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847467"
"ResourceRecordKey" => "30024851"
"ModificationTimestamp" => "2026-07-13T14:59:21.85Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30024851_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024851/27d2b21097edc7cc8dd8336489f9f211.webp"
"MediaSize" => 87255
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024851/thumbnail-27d2b21097edc7cc8dd8336489f9f211.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary living space featuring a built-in electric fireplace with textured wall surround, custom shelving, large windows with vertical blinds, and a coffered ceiling with a modern chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847467"
"ResourceRecordKey" => "30024851"
"ModificationTimestamp" => "2026-07-13T14:59:21.85Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30024851')"
+"ID": "1618853"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25307
+post_id: "1617533"
+post_author: 1
+"ListingKey": "30022643"
+"ListingId": "X13553666"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-11T23:45:01Z"
+"RFModificationTimestamp": "2026-07-12T00:44:18Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1V7"
+"UnparsedAddress": "64 - 22 SPRING CREEK DRIVE, Hamilton (Waterdown), Ontario L8B1V7"
+"Coordinates": array:2 [
0 => -79.878421
1 => 43.345434
]
+"Latitude": 43.345434
+"Longitude": -79.878421
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Your search ends here. The best homes don't simply check boxes. They feel right the moment you walk through the door. This is one of them. Beautifully maintained and thoughtfully designed, this exceptional end-unit townhome offers 1,630 square feet of modern living space in one of Waterdown's most desirable communities. Featuring 3 bedrooms, 2.5 bathrooms, and the added privacy and natural light that only an end unit can provide, this home delivers the perfect balance of style, comfort, and functionality. The highly functional floor plan is designed for the way people live today. The bright, open concept kitchen overlooks the dining and living areas, creating an inviting space for everyday living and effortless entertaining. Step outside to your private balcony to enjoy your morning coffee or unwind at the end of the day. Hard surface flooring extends throughout the principal living areas, with carpet limited to the staircase for added comfort. The spacious primary bedroom features a walk-in closet and private 4-piece ensuite, while two additional bedrooms offer flexibility for family, guests, or a home office. An attached garage with inside entry, private driveway parking, upper-level laundry, central air conditioning, and stainless steel appliances complete this exceptional offering. Ideally located just minutes from the GO Train, Highways 403, QEW and 407, commuting is effortless. Parks, schools, shopping, restaurants, recreation, trails, and everyday amenities are all nearby, offering an outstanding lifestyle with the perfect balance of convenience and community. Whether you're a professional, growing family, or simply looking for a spacious, low-maintenance home in an exceptional location, this is an opportunity you won't want to miss. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"AssociationFee": "134.7"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parcel of Tied Land"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-12T00:44:11.760871+00:00"
+"Directions": "Cross Streets: Dundas Street East & Spring Creek Drive. ** Directions: Dundas Street East to Spring Creek Drive. Visitor parking available."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Slab"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007838"
+"ListOfficeKey": "280225"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "In suite Laundry"
]
+"LotSizeDimensions": "27.4 x 44.3 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-11T23:38:09Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-11T23:38:09Z"
+"Stories": "3.0"
+"StreetName": "Spring Creek"
+"StreetNumber": "22"
+"StreetSuffix": "Drive"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1681451818"
"RoomType" => "Foyer"
"ListingId" => "X13553666"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.54
"ListingKey" => "30022643"
"RoomLength" => 2.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-11T23:38:09.29Z"
]
1 => array:11 [
"RoomKey" => "1681451819"
"RoomType" => "Laundry room"
"ListingId" => "X13553666"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "30022643"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-11T23:38:09.29Z"
]
2 => array:11 [
"RoomKey" => "1681451820"
"RoomType" => "Dining room"
"ListingId" => "X13553666"
"RoomLevel" => "Second level"
"RoomWidth" => 3.1
"ListingKey" => "30022643"
"RoomLength" => 3.94
"RoomDimensions" => null
…3
]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30022643/64-22-spring-creek-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2975
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 27.4
+"OriginalEntryTimestamp": "2026-07-11T23:38:09.26Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1289849"
+"ListOfficeNationalAssociationId": "1310773"
+"Media": array:28 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30022643')"
+"ID": "1617533"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25311
+post_id: "1617373"
+post_author: 1
+"ListingKey": "30022617"
+"ListingId": "40846890"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T19:05:12Z"
+"RFModificationTimestamp": "2026-07-13T19:25:16Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1630.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1V7"
+"UnparsedAddress": "22 SPRING CREEK Drive Unit# 64, Waterdown, Ontario L8B1V7"
+"Coordinates": array:2 [
0 => -79.8773269
1 => 43.3464922
]
+"Latitude": 43.3464922
+"Longitude": -79.8773269
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Your search ends here. The best homes don't simply check boxes. They feel right the moment you walk through the door. This is one of them. Beautifully maintained and thoughtfully designed, this exceptional end-unit townhome offers 1,630 square feet of modern living space in one of Waterdown's most desirable communities. Featuring 3 bedrooms, 2.5 bathrooms, and the added privacy and natural light only an end unit can provide, this home offers the perfect balance of style, comfort, and functionality. The bright, open concept kitchen overlooks the dining and living areas, creating an inviting space for everyday living and entertaining. Step onto your private balcony to enjoy your morning coffee or unwind at the end of the day. Hard surface flooring extends throughout the principal living areas, with carpet limited to the staircase. The spacious primary bedroom features a walk-in closet and private 4-piece ensuite, while two additional bedrooms offer flexibility for family, guests, or a home office. An attached garage with inside entry, private driveway parking, upper-level laundry, and stainless steel appliances complete this exceptional home. Ideally located just minutes from the GO Train, Highways 403, QEW and 407, with parks, schools, shopping, restaurants, recreation, trails, and everyday amenities nearby, this home offers an exceptional lifestyle in a highly sought-after Waterdown community. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:2 [
0 => "Property Management"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-11T23:46:29.811197+00:00"
+"Directions": "Dundas Street East & Spring Creek Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2031755"
+"ListOfficeKey": "282362"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-11T23:18:03Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T18:59:27Z"
+"Stories": "3.0"
+"StreetName": "SPRING CREEK"
+"StreetNumber": "22"
+"StreetSuffix": "Drive"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30022617/22-spring-creek-drive-unit-64-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2975
+"ZoningDescription": "R6-42"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 27.0
+"AboveGradeFinishedArea": 1630
+"OriginalEntryTimestamp": "2026-07-11T23:18:03.79Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1314539"
+"ListOfficeNationalAssociationId": "1320359"
+"Media": array:28 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30022617')"
+"ID": "1617373"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25309
+post_id: "1617166"
+post_author: 1
+"ListingKey": "30022071"
+"ListingId": "40847339"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-11T17:55:16Z"
+"RFModificationTimestamp": "2026-07-11T18:47:50Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1554.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B1Y4"
+"UnparsedAddress": "75 KENESKY Drive, Hamilton, Ontario L8B1Y4"
+"Coordinates": array:2 [
0 => -79.8793776
1 => 43.3379436
]
+"Latitude": 43.3379436
+"Longitude": -79.8793776
+"YearBuilt": 2022
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Semi Detached with 3 Bedrooms & 3 Baths, In Waterdown's Most Desirable Neighbourhood. Open Concept Main Level with Laminate Floors & 9' Ceilings, Modern Kitchen W/ Stainless Steel Appliances. Primary Bedroom with 4 Pc Ensuite & Walk-In Closet, 9' Ceiling On 2nd Floor. 2 Car Parking. Ready To Move-In! Minutes To Hwy 407, Qew & Go Stations, 15 Minutes To Mcmaster, Close To Shopping & Schools. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-11T18:47:44.676342+00:00"
+"Directions": "Dundas/Burke"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2051215"
+"ListOfficeKey": "283262"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-11T17:48:10Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-11T17:48:10Z"
+"Stories": "2.0"
+"StreetName": "KENESKY"
+"StreetNumber": "75"
+"StreetSuffix": "Drive"
+"SubdivisionName": "461 - Waterdown East"
+"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/30022071/75-kenesky-drive-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3200
+"ZoningDescription": "R4-6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1554
+"OriginalEntryTimestamp": "2026-07-11T17:48:10.08Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1326585"
+"ListOfficeNationalAssociationId": "1326249"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30022071')"
+"ID": "1617166"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25304
+post_id: "1615436"
+post_author: 1
+"ListingKey": "30018004"
+"ListingId": "X13549282"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T17:10:04Z"
+"RFModificationTimestamp": "2026-07-10T17:45:22Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "1204 - 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 PENTHOUSE unit at sought after Trend building. Enjoy breathtaking views from the 12th floor in this bright and spacious unit featuring high-end finishes throughout, with an open-concept kitchen and living room with stainless steel appliances, Quartz counters with waterfall end, a breakfast bar, custom blinds. The condo is complete with a 4-piece bathroom and in-suite laundry. Enjoy all the fabulous amenities that this building has to offer, including party rooms, modern fitness facilities, rooftop patios, BBQ area and bike storage. Situated in the desirable Waterdown community with quick access to the local Go Station, QEW, 403 and 407 Highways, local restaurants, shopping, schools and parks. Exclusive parking spaces and 1 locker included! Geothermal heating and cooling throughout. (id:62650)"
+"Appliances": array:8 [
0 => "Refrigerator"
1 => "Intercom"
2 => "Dishwasher"
3 => "Stove"
4 => "Range"
5 => "Microwave"
6 => "Blinds"
7 => "Garage door opener remote(s)"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-10T17:45:03.186285+00:00"
+"Directions": "Dundas St and Burke"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Aluminum siding"
]
+"FoundationDetails": array:3 [
0 => "Concrete"
1 => "Poured Concrete"
2 => "Slab"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1971143"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:9 [
0 => "Level lot"
1 => "Flat site"
2 => "Conservation/green belt"
3 => "Elevator"
4 => "Lighting"
5 => "Balcony"
6 => "Level"
7 => "Carpet Free"
8 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-07-10T17:04:16Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T17:04:16Z"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"View": "City view,Valley view"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30018004/1204-450-dundas-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 2100
+"BuildingFeatures": array:5 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Recreation Centre"
3 => "Separate Electricity Meters"
4 => "Separate Heating Controls"
]
+"SecurityFeatures": array:2 [
0 => "Smoke Detectors"
1 => "Controlled entry"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-10T17:04:15.99Z"
+"ListAgentNationalAssociationId": "1258497"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30018004')"
+"ID": "1615436"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23484
+post_id: "1612855"
+post_author: 1
+"ListingKey": "30017422"
+"ListingId": "X13548898"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-12T17:15:06Z"
+"RFModificationTimestamp": "2026-07-12T17:19:16Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "617 - 470 DUNDAS STREET, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Fully upgraded Trend 3 Condos built by Horizon. One Bedroom and a large, Huge Den could be used as a 2nd bedroom, plus 2 parking spots. 9-foot ceilings and High-class premium finishes including the Kitchen with Vicostone Ventisca Polished Quartz Counters with a Blanco Horizon under-mount sink with Moen Align Black Faucet with Vicostone Ventisca Polished Quartz Backsplash with Charleston 3DL Moonlight colour Kitchen Cabinets with Additional capped ceiling outlet with Extended Breakfast Bar in Kitchen with Stainless Steel appliances, Built-in Microwave, Main Washroom with Charleston 3DL Moonlight colour Cabinets with Vicostone Ventisca Polished Quartz Counters with White Tub & Logan Toilet with Moen Align Black Faucets with Floorsense Beachwood 7'' x 48'' Vinyle Floor all over the Unit, Floor-to-ceiling windows, Master bedroom with walk-in closet with Floorsense Beachwood 7'' x 48'' Vinyle Floor, 3 Pcs Ensuite, Two underground parking spots, and one Locker on Same Floor of the unit, Many visitors parking for your guests. High-class, sleek, and modern building with amenities in a great location close to Aldershot GO Station & School, Shopping Centers, Burlington Costco, Restaurants, Transit, 403/407/QEW, Grindstone Creek, Souharissen Natural Area, Etc Etc. Landlord Looking For AAA Tenants W/ Excellent Credit, a good job, and who will take care of this condo like their own. (Tenants Are To Pay All Utilities) (id:62650)"
+"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 Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-10T17:05:46.977106+00:00"
+"Directions": "Dundas St. E to Mallard Trail"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1947722"
+"ListOfficeKey": "50449"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Trash compactor"
3 => "Carpet Free"
4 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-10T16:10:20Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-12T17:08:29Z"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"VirtualTourURLUnbranded": "https://media.relavix.com/617-470-dundas-street-e-waterdown/?unbranded=true"
+"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/30017422/617-470-dundas-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 2599
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-10T16:10:20.17Z"
+"ListAgentNationalAssociationId": "1242417"
+"ListOfficeNationalAssociationId": "1003210"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30017422')"
+"ID": "1612855"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25312
+post_id: "1615437"
+post_author: 1
+"ListingKey": "30017461"
+"ListingId": "40847041"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T03:35:17Z"
+"RFModificationTimestamp": "2026-07-13T03:39:59Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 587.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "450 DUNDAS Street Unit# 1204, Hamilton, Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.879368
1 => 43.34348
]
+"Latitude": 43.34348
+"Longitude": -79.879368
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning PENTHOUSE unit at sought after Trend building. Enjoy breathtaking views from the 12th floor in this bright and spacious unit featuring high-end finishes throughout, with an open-concept kitchen and living room with stainless steel appliances, Quartz counters with waterfall end, a breakfast bar, custom blinds. The condo is complete with a 4-piece bathroom and in-suite laundry. Enjoy all the fabulous amenities that this building has to offer, including party rooms, modern fitness facilities, rooftop patios, BBQ area and bike storage. Situated in the desirable Waterdown community with quick access to the local Go Station, QEW, 403 and 407 Highways, local restaurants, shopping, schools and parks. Exclusive parking spaces and 1 locker included! Geothermal heating and cooling throughout. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:6 [
0 => "Exterior Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
4 => "Parking"
5 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:4 [
0 => "Quiet Area"
1 => "High Traffic Area"
2 => "School Bus"
3 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-10T17:01:11.107799+00:00"
+"Directions": "Burke ST to Dundas St"
+"ExteriorFeatures": array:5 [
0 => "Stone"
1 => "Stucco"
2 => "Aluminum siding"
3 => "Metal"
4 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1388851"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Paved driveway"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Open"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-13T03:31:04Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T03:31:04Z"
+"Stories": "1.0"
+"StreetName": "DUNDAS"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"Utilities": array:2 [
0 => "Electricity"
1 => "Telephone"
]
+"View": "City view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30017461/450-dundas-street-unit-1204-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2100
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 587
+"OriginalEntryTimestamp": "2026-07-10T16:18:24.62Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1035770"
+"ListOfficeNationalAssociationId": "1333115"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30017461')"
+"ID": "1615437"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25313
+post_id: "1611540"
+post_author: 1
+"ListingKey": "30015008"
+"ListingId": "X13546432"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T00:15:10Z"
+"RFModificationTimestamp": "2026-07-10T00:46:59Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Y4"
+"UnparsedAddress": "75 KENESKY DRIVE, Hamilton (Waterdown), Ontario L8B1Y4"
+"Coordinates": array:2 [
0 => -79.8794366
1 => 43.3380303
]
+"Latitude": 43.3380303
+"Longitude": -79.8794366
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Semi-detached with 3 Bedrooms & 3 Baths, In Waterdown's Most Desirable Neighbourhood. OpenConcept Main Level with Laminate Floors & 9' Ceilings, Modern Kitchen W/ Stainless SteelAppliances. Primary Bedroom W/ 4 Pc Ensuite & Walk-In Closet, 9' Ceiling On 2nd Floor. 2 CarParking. Ready to move in! Minutes to Hwy 407, QEW & GO Stations, 15 minutes to McMaster, CloseTo Shopping & Schools. Pics are from prior to the tenant moving in. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-07-10T00:46:53.464293+00:00"
+"Directions": "Dundas St and Burke"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Laminate"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1423005"
+"ListOfficeKey": "278195"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-10T00:09:40Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T00:09:40Z"
+"Stories": "2.0"
+"StreetName": "Kenesky"
+"StreetNumber": "75"
+"StreetSuffix": "Drive"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30015008/75-kenesky-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1734296"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "275784"
+"GeocodeManualYN": true
+"TotalActualRent": 3200
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-10T00:09:40.39Z"
+"ListAgentNationalAssociationId": "1102771"
+"ListOfficeNationalAssociationId": "1290805"
+"CoListAgentNationalAssociationId": "1177473"
+"CoListOfficeNationalAssociationId": "1268183"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30015008')"
+"ID": "1611540"
}
]
+success: true
+page_size: 9
+page_count: 6
+count: 54
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]