array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29931778 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: "1550150"
+post_author: 1
+"ListingKey": "29931778"
+"ListingId": "X13469760"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T14:30:04Z"
+"RFModificationTimestamp": "2026-06-23T14:31:35Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A4"
+"UnparsedAddress": "501 - 5 HAMILTON STREET N, Hamilton (Waterdown), Ontario L8B2A4"
+"Coordinates": array:2 [
0 => -79.8964742
1 => 43.3310512
]
+"Latitude": 43.3310512
+"Longitude": -79.8964742
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Are You Looking for a spacious 2-bedroom, 2 Bathroom Suite with designer finishes and a functional layout? This 1,025 SF suite has been completely transformed with over $47,000 in luxurious upgrades - and it shows the moment you walk through the door. Enjoy the bright open-concept layout with a large Chef's Kitchen with custom cabinetry, stone countertops, a large centre island with seating, an Induction Cooktop, Premium Appliances, upgraded lighting, and tiles that were selected with care. The living area flows to your private balcony through a sliding door, with motorized roller shades that let you control light and privacy at the touch of a button. North exposure means open, unobstructed views to enjoy your private 72 SF Balcony. Both bedrooms are generously sized, with the primary retreat complete with a large walk-in closet fitted with custom built-ins and a private ensuite bath and double vanity. The second bedroom is genuinely usable as a guest room, home office or gym, served by the main four-piece bathroom. Custom California Closet organizers throughout, with modern, low-maintenance vinyl plank flooring in the main living areas and bedrooms. Everything is move-in ready. In-suite laundry, one underground parking space, and one locker included. Located in the heart of Waterdown's downtown core, you are steps from restaurants, cafés, grocery stores, schools, and transit - with quick access to Hwy 6, Hwy 403, the QEW, Burlington and Aldershot GO Station. Available Starting September 1st! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Oven"
4 => "Dryer"
5 => "Microwave"
6 => "Cooktop"
7 => "Hood Fan"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T23:43:55.261845+00:00"
+"Directions": "Cross Streets: Dundas St/ Hamilton St. N. ** Directions: North of Dundas St, West side of Hamilton St. N."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1616151"
+"ListOfficeKey": "51182"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Level lot"
1 => "Balcony"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-23T14:21:07Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T14:21:07Z"
+"StreetDirSuffix": "North"
+"StreetName": "Hamilton"
+"StreetNumber": "5"
+"StreetSuffix": "Street"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youtu.be/DWvqeTDAehg"
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1665759517"
"RoomType" => "Foyer"
"ListingId" => "X13469760"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29931778"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-23T00:43:43.63Z"
]
1 => array:11 [
"RoomKey" => "1665759518"
"RoomType" => "Kitchen"
"ListingId" => "X13469760"
"RoomLevel" => "Main level"
"RoomWidth" => 2.77
"ListingKey" => "29931778"
"RoomLength" => 3.48
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-23T00:43:43.63Z"
]
2 => array:11 [
"RoomKey" => "1665759519"
"RoomType" => "Living room"
"ListingId" => "X13469760"
"RoomLevel" => "Main level"
"RoomWidth" => 4.6
"ListingKey" => "29931778"
"RoomLength" => 5.54
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-23T00:43:43.63Z"
]
3 => array:11 [
"RoomKey" => "1665759520"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13469760"
"RoomLevel" => "Main level"
"RoomWidth" => 3.1
"ListingKey" => "29931778"
"RoomLength" => 4.37
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-23T00:43:43.63Z"
]
4 => array:11 [
"RoomKey" => "1665759521"
"RoomType" => "Bedroom 2"
"ListingId" => "X13469760"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29931778"
"RoomLength" => 3.53
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-23T00:43:43.63Z"
]
5 => array:11 [
"RoomKey" => "1665759522"
"RoomType" => "Bathroom"
"ListingId" => "X13469760"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29931778"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-23T00:43:43.63Z"
]
6 => array:11 [
"RoomKey" => "1665759523"
"RoomType" => "Other"
"ListingId" => "X13469760"
"RoomLevel" => "Main level"
"RoomWidth" => 3.12
"ListingKey" => "29931778"
"RoomLength" => 2.13
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-23T00:43:43.63Z"
]
7 => array:11 [
"RoomKey" => "1665759524"
"RoomType" => "Utility room"
"ListingId" => "X13469760"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29931778"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-23T00:43:43.63Z"
]
8 => array:11 [
"RoomKey" => "1665759525"
"RoomType" => "Laundry room"
"ListingId" => "X13469760"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29931778"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-23T00:43:43.64Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29931778/501-5-hamilton-street-n-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Property Management Guild 905.575.3636"
+"GeocodeManualYN": true
+"TotalActualRent": 2900
+"BuildingFeatures": array:3 [
0 => "Storage - Locker"
1 => "Party Room"
2 => "Visitor Parking"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-19T22:48:21.23Z"
+"ListAgentNationalAssociationId": "1159607"
+"ListOfficeNationalAssociationId": "1003183"
+"Media": array:18 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29931778_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931778/353adb845bf5e2f1fe914e48ca04eb9e.webp"
"MediaSize" => 148901
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931778/thumbnail-353adb845bf5e2f1fe914e48ca04eb9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Custom Kitchen & Island"
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13469760"
"ResourceRecordKey" => "29931778"
"ModificationTimestamp" => "2026-06-19T22:48:21.24Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29931778_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931778/c71b46c86f65a2177747952d6b603817.webp"
"MediaSize" => 155780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931778/thumbnail-c71b46c86f65a2177747952d6b603817.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Custom Kitchen & Island"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469760"
"ResourceRecordKey" => "29931778"
"ModificationTimestamp" => "2026-06-19T22:48:21.24Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29931778_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931778/8fc86316bc4083f00b2385873d024562.webp"
"MediaSize" => 160734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931778/thumbnail-8fc86316bc4083f00b2385873d024562.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living Room and Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469760"
"ResourceRecordKey" => "29931778"
"ModificationTimestamp" => "2026-06-19T22:48:21.24Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29931778_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931778/d926fe0701a16ca8b65fc4c3d430197e.webp"
"MediaSize" => 175105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931778/thumbnail-d926fe0701a16ca8b65fc4c3d430197e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Private Balcony"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469760"
"ResourceRecordKey" => "29931778"
"ModificationTimestamp" => "2026-06-19T22:48:21.24Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29931778_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931778/7c88debb8854e5df4b3def011d1b30f9.webp"
"MediaSize" => 130428
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931778/thumbnail-7c88debb8854e5df4b3def011d1b30f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Bedroom Retreat"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469760"
"ResourceRecordKey" => "29931778"
"ModificationTimestamp" => "2026-06-19T22:48:21.24Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29931778_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931778/c5380ddae6f21646136e25119da46d11.webp"
"MediaSize" => 173259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931778/thumbnail-c5380ddae6f21646136e25119da46d11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Walk-In Closet with Custom Organizers"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469760"
"ResourceRecordKey" => "29931778"
"ModificationTimestamp" => "2026-06-19T22:48:21.24Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29931778_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931778/61bf69d47b03530114da0ff8bb3a9c39.webp"
"MediaSize" => 152148
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931778/thumbnail-61bf69d47b03530114da0ff8bb3a9c39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Ensuite Bathroom with Double Vanity"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469760"
"ResourceRecordKey" => "29931778"
"ModificationTimestamp" => "2026-06-19T22:48:21.24Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29931778_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931778/b30dd9d13b1300e031d5b4901b0f1a9b.webp"
"MediaSize" => 155578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931778/thumbnail-b30dd9d13b1300e031d5b4901b0f1a9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Ensuite Custom Shower"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469760"
"ResourceRecordKey" => "29931778"
"ModificationTimestamp" => "2026-06-19T22:48:21.24Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29931778_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931778/435b2385283da6c2313304175e21e4e7.webp"
"MediaSize" => 89362
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931778/thumbnail-435b2385283da6c2313304175e21e4e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Ensuite Bathroom with Double Vanity"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469760"
"ResourceRecordKey" => "29931778"
"ModificationTimestamp" => "2026-06-19T22:48:21.24Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29931778_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931778/6045281bb9d592fd7520e2d3d1741473.webp"
"MediaSize" => 143793
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931778/thumbnail-6045281bb9d592fd7520e2d3d1741473.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "2nd Bedroom or Gym"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469760"
"ResourceRecordKey" => "29931778"
"ModificationTimestamp" => "2026-06-19T22:48:21.24Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29931778_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931778/5a6a91e40a191be7d7593cc9d578f5c5.webp"
"MediaSize" => 154790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931778/thumbnail-5a6a91e40a191be7d7593cc9d578f5c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "2nd Bedroom Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469760"
"ResourceRecordKey" => "29931778"
"ModificationTimestamp" => "2026-06-19T22:48:21.24Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29931778_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931778/c44b80360f2d7bb74bb2f701c5db4e8a.webp"
"MediaSize" => 125681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931778/thumbnail-c44b80360f2d7bb74bb2f701c5db4e8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main 4 Piece Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469760"
"ResourceRecordKey" => "29931778"
"ModificationTimestamp" => "2026-06-23T00:50:30.67Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29931778_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931778/98b3991f9686bc4a001c6b38162f8cfa.webp"
"MediaSize" => 120767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931778/thumbnail-98b3991f9686bc4a001c6b38162f8cfa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Custom Front Closet & Built-Ins"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469760"
"ResourceRecordKey" => "29931778"
"ModificationTimestamp" => "2026-06-23T00:50:17.46Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29931778_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931778/72b14b2ac1267032d93827d9a584f81b.webp"
"MediaSize" => 183395
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931778/thumbnail-72b14b2ac1267032d93827d9a584f81b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Private Balcony Sunset"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469760"
"ResourceRecordKey" => "29931778"
"ModificationTimestamp" => "2026-06-23T00:50:12.44Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29931778_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931778/d254ca40db4d876ceba7c7a8ed4779f2.webp"
"MediaSize" => 91149
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931778/thumbnail-d254ca40db4d876ceba7c7a8ed4779f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Insuite Laundry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469760"
"ResourceRecordKey" => "29931778"
"ModificationTimestamp" => "2026-06-23T00:50:20.6Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29931778_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931778/c40968b9ac54740db7ab6556fbdd8fb7.webp"
"MediaSize" => 170275
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931778/thumbnail-c40968b9ac54740db7ab6556fbdd8fb7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Large Underground Parking Spot"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469760"
"ResourceRecordKey" => "29931778"
"ModificationTimestamp" => "2026-06-23T00:50:26.2Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29931778_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931778/d46bb786fbc18ceee3a8b752b0c62d6f.webp"
"MediaSize" => 319865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931778/thumbnail-d46bb786fbc18ceee3a8b752b0c62d6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Locker"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469760"
"ResourceRecordKey" => "29931778"
"ModificationTimestamp" => "2026-06-23T00:50:32.1Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29931778_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931778/0ce3b41fdcf3c0f53d6c5d010e8f6cca.webp"
"MediaSize" => 188292
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931778/thumbnail-0ce3b41fdcf3c0f53d6c5d010e8f6cca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "5 Hamilton St. N."
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469760"
"ResourceRecordKey" => "29931778"
"ModificationTimestamp" => "2026-06-23T00:51:07.34Z"
]
]
+"DaysOnMarket": 23
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29931778')"
+"ID": "1550150"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 51182" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24942
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24886
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX CONDOS PLUS CORPORATION"
+"OfficeEmail": null
+"OfficePhone": "416-203-6636"
+"OfficeMlsId": "592600"
+"ModificationTimestamp": "2026-03-03T10:59:08Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "51182"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "45 HARBOUR SQUARE"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "TORONTO"
+"OfficePostalCode": "M5J2G"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1003183"
+"OriginalEntryTimestamp": null
+"OfficeFax": "416-203-1908"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "339774"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "51182"
"SocialMediaUrlOrId" => "http://www.remaxcondosplus.com/"
"ModificationTimestamp" => "2025-06-11T21:26:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1107824"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('51182')"
}
]
+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 1616151" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24896
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29931778'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25220
+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 '29931778' AND OpenHouseDate ge '2026-07-12'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25236
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29931778' 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.8964742 43.3310512)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25289
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25283
+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 [
"RoomKey" => "1681157474"
"RoomType" => "Bedroom"
"ListingId" => "40847339"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30022071"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-11T17:48:10.13Z"
]
1 => array:11 [
"RoomKey" => "1681157475"
"RoomType" => "4pc Bathroom"
"ListingId" => "40847339"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30022071"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-11T17:48:10.13Z"
]
2 => array:11 [
"RoomKey" => "1681157476"
"RoomType" => "Bedroom"
"ListingId" => "40847339"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30022071"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-11T17:48:10.14Z"
]
3 => array:11 [
"RoomKey" => "1681157477"
"RoomType" => "Full bathroom"
"ListingId" => "40847339"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30022071"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-11T17:48:10.14Z"
]
4 => array:11 [
"RoomKey" => "1681157478"
"RoomType" => "Primary Bedroom"
"ListingId" => "40847339"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30022071"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-11T17:48:10.14Z"
]
5 => array:11 [
"RoomKey" => "1681157479"
"RoomType" => "2pc Bathroom"
"ListingId" => "40847339"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30022071"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-11T17:48:10.14Z"
]
6 => array:11 [
"RoomKey" => "1681157480"
"RoomType" => "Breakfast"
"ListingId" => "40847339"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30022071"
"RoomLength" => null
"RoomDimensions" => "8'5'' x 9'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-11T17:48:10.14Z"
]
7 => array:11 [
"RoomKey" => "1681157481"
"RoomType" => "Kitchen"
"ListingId" => "40847339"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30022071"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-11T17:48:10.14Z"
]
8 => array:11 [
"RoomKey" => "1681157482"
"RoomType" => "Dining room"
"ListingId" => "40847339"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30022071"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 19'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-11T17:48:10.14Z"
]
9 => array:11 [
"RoomKey" => "1681157483"
"RoomType" => "Living room"
"ListingId" => "40847339"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30022071"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 19'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-11T17:48:10.14Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "30022071_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/98d19bda1b4b0814adee3d39457b3777.webp"
"MediaSize" => 98617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-98d19bda1b4b0814adee3d39457b3777.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick facade residence featuring a covered front porch with white columns, a dark shingle roof, decorative window grids, and an attached garage with a panel door"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30022071_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/049efb92ace48f2d1f3b9194f04eda25.webp"
"MediaSize" => 73100
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-049efb92ace48f2d1f3b9194f04eda25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick and stone facade residence featuring a covered front porch with pillars, a shingled roof, a glass-panel front door, and a garage door with window inserts"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30022071_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/8331ded0703fb3d68c116ddaf2040249.webp"
"MediaSize" => 74669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-8331ded0703fb3d68c116ddaf2040249.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior with decorative window trim and a covered front porch featuring white columns"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30022071_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/b1f0b205f23b3e16e2b5a56bb8ce2d8b.webp"
"MediaSize" => 27880
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-b1f0b205f23b3e16e2b5a56bb8ce2d8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story staircase with dark wood-finish treads and railings featuring black metal balusters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30022071_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/14f66d4fa28f5dcc741ea2a9dcd44cb2.webp"
"MediaSize" => 23322
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-14f66d4fa28f5dcc741ea2a9dcd44cb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring dark wood-finish flooring, a wall-mounted fireplace, multiple large windows, and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30022071_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/26f5f59fa8107c4ff556406e0b7b549e.webp"
"MediaSize" => 25243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-26f5f59fa8107c4ff556406e0b7b549e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious interior featuring dark wood-finish flooring, multiple windows, a wall-mounted electric fireplace, recessed ceiling details, and a neutral color palette"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30022071_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/1260af1be4fde995287d97552d9bbff7.webp"
"MediaSize" => 18588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-1260af1be4fde995287d97552d9bbff7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring dark wood-finish flooring, a wall-mounted linear electric fireplace, bright white walls, and a large window with multiple panes"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30022071_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/9ecbc7fae121182ee3941185fa559d42.webp"
"MediaSize" => 21745
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-9ecbc7fae121182ee3941185fa559d42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30022071_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/82f827b4b8395122d7de14462f0855d2.webp"
"MediaSize" => 25218
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-82f827b4b8395122d7de14462f0855d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring wood-finish cabinetry, light-toned countertops, and a stainless steel sink with a single-handle faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30022071_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/ef3ff8c49a77095e73bb28a4e5f90b09.webp"
"MediaSize" => 26716
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-ef3ff8c49a77095e73bb28a4e5f90b09.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen area featuring dark wood-finish cabinetry, white countertops, and a stainless steel sink with a chrome faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30022071_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/2d3adc0c9b9a6aa86c7b6483831e7e9c.webp"
"MediaSize" => 20125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-2d3adc0c9b9a6aa86c7b6483831e7e9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring dark wood-finish cabinetry and light-toned countertops"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30022071_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/9984f3fa486267ec46fba3fae8c54659.webp"
"MediaSize" => 20967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-9984f3fa486267ec46fba3fae8c54659.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring dark wood-finish cabinetry, light-toned countertops, and a double-basin stainless steel sink with a chrome faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30022071_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/23e6b115e741b179dbde4ca6d18e2f94.webp"
"MediaSize" => 22436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-23e6b115e741b179dbde4ca6d18e2f94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring dark wood-finish flooring, white baseboards, and white walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30022071_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/62483b6c1662f5b5c948c8446fcc0b64.webp"
"MediaSize" => 21683
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-62483b6c1662f5b5c948c8446fcc0b64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white bathtub with full-height gray tile surround, a dark wood-finish vanity with a light-colored countertop, and a chrome light fixture above the mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30022071_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/5b1bda34accfc701e5cca5290f9ad47c.webp"
"MediaSize" => 17523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-5b1bda34accfc701e5cca5290f9ad47c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Interior room featuring dark wood-finish flooring, light neutral wall paint, two large windows, white trim, and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30022071_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/26b02f1ddff18cee2eccd6e219870ee0.webp"
"MediaSize" => 23653
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-26b02f1ddff18cee2eccd6e219870ee0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stairwell landing featuring dark wood-finish flooring, a white-framed window, and a dark wood banister with balusters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30022071_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/fddbec6d0a8f9e888b4afb3862fefd71.webp"
"MediaSize" => 22931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-fddbec6d0a8f9e888b4afb3862fefd71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dark wood-finish flooring extending into multiple rooms"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30022071_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/d3c71e49b43cd43984b4553144f027f0.webp"
"MediaSize" => 19464
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-d3c71e49b43cd43984b4553144f027f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring dark wood-finish flooring, white baseboards, and light-toned walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30022071_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/90871afb8d8db2f003a88a39f711e5a1.webp"
"MediaSize" => 18070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-90871afb8d8db2f003a88a39f711e5a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30022071_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/d0980a9e5ae399d6630b5cff856a6545.webp"
"MediaSize" => 14437
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-d0980a9e5ae399d6630b5cff856a6545.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious closet with dark wood-finish flooring, white baseboards, and built-in shelving with hanging rods"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30022071_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/f7f01801cd54bc76ccbd5b61f9f2afa8.webp"
"MediaSize" => 24173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-f7f01801cd54bc76ccbd5b61f9f2afa8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a deep soaking tub with tile surround, a single vanity with a white countertop and dark wood-finish cabinetry, a commode, and tiled flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30022071_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/955d1d34fb4c0de8f0ef526135f8b1dc.webp"
"MediaSize" => 29466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-955d1d34fb4c0de8f0ef526135f8b1dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Shower enclosure with sliding glass doors and chrome hardware"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30022071_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30022071/16a8a6eb5224b620c984bdeec3266f93.webp"
"MediaSize" => 30913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30022071/thumbnail-16a8a6eb5224b620c984bdeec3266f93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847339"
"ResourceRecordKey" => "30022071"
"ModificationTimestamp" => "2026-07-11T17:48:10.08Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30022071')"
+"ID": "1617166"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25285
+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 [
"RoomKey" => "1680173009"
"RoomType" => "Foyer"
"ListingId" => "X13549282"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "30018004"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-10T17:04:16.01Z"
]
1 => array:11 [
"RoomKey" => "1680173010"
"RoomType" => "Kitchen"
"ListingId" => "X13549282"
"RoomLevel" => "Main level"
"RoomWidth" => 2.26
"ListingKey" => "30018004"
"RoomLength" => 2.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-10T17:04:16.01Z"
]
2 => array:11 [
"RoomKey" => "1680173011"
"RoomType" => "Living room"
"ListingId" => "X13549282"
"RoomLevel" => "Main level"
"RoomWidth" => 5.92
"ListingKey" => "30018004"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-10T17:04:16.01Z"
]
3 => array:11 [
"RoomKey" => "1680173012"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13549282"
"RoomLevel" => "Main level"
"RoomWidth" => 3.25
"ListingKey" => "30018004"
"RoomLength" => 2.87
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-10T17:04:16.01Z"
]
4 => array:11 [
"RoomKey" => "1680173013"
"RoomType" => "Laundry room"
"ListingId" => "X13549282"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "30018004"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-10T17:04:16.01Z"
]
5 => array:11 [
"RoomKey" => "1680173014"
"RoomType" => "Bathroom"
"ListingId" => "X13549282"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "30018004"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-10T17:04:16.01Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "30018004_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018004/04bbf4fa80fd6153a0bd7b6dad2421af.webp"
"MediaSize" => 188950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018004/thumbnail-04bbf4fa80fd6153a0bd7b6dad2421af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13549282"
"ResourceRecordKey" => "30018004"
"ModificationTimestamp" => "2026-07-10T17:04:15.99Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30018004_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018004/00c271e6b3995a04290b4a1dce3cce01.webp"
"MediaSize" => 107658
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018004/thumbnail-00c271e6b3995a04290b4a1dce3cce01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549282"
"ResourceRecordKey" => "30018004"
"ModificationTimestamp" => "2026-07-10T17:04:15.99Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30018004_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018004/9bdd99b6fa1b26f4a033a0709081603a.webp"
"MediaSize" => 165749
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018004/thumbnail-9bdd99b6fa1b26f4a033a0709081603a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549282"
"ResourceRecordKey" => "30018004"
"ModificationTimestamp" => "2026-07-10T17:04:15.99Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30018004_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018004/b9b006c1f475700f0981fca07e8317b9.webp"
"MediaSize" => 118768
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018004/thumbnail-b9b006c1f475700f0981fca07e8317b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549282"
"ResourceRecordKey" => "30018004"
"ModificationTimestamp" => "2026-07-10T17:04:15.99Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30018004_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018004/f83d82c4987ea79e24b7e5ea70fcfb60.webp"
"MediaSize" => 110854
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018004/thumbnail-f83d82c4987ea79e24b7e5ea70fcfb60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549282"
"ResourceRecordKey" => "30018004"
"ModificationTimestamp" => "2026-07-10T17:04:15.99Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30018004_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018004/99fa8c82b93fd21ae178143b3f500d19.webp"
"MediaSize" => 120475
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018004/thumbnail-99fa8c82b93fd21ae178143b3f500d19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549282"
"ResourceRecordKey" => "30018004"
"ModificationTimestamp" => "2026-07-10T17:04:15.99Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30018004_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018004/de0b36cf620d1d96e465c91014c05924.webp"
"MediaSize" => 96751
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018004/thumbnail-de0b36cf620d1d96e465c91014c05924.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549282"
"ResourceRecordKey" => "30018004"
"ModificationTimestamp" => "2026-07-10T17:04:15.99Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30018004_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018004/29ba6dff60cca6c5f187120a0856e6fa.webp"
"MediaSize" => 45164
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018004/thumbnail-29ba6dff60cca6c5f187120a0856e6fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549282"
"ResourceRecordKey" => "30018004"
"ModificationTimestamp" => "2026-07-10T17:04:15.99Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30018004_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018004/a4a80f8350d4a120091b2efc0d38b3bc.webp"
"MediaSize" => 40229
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018004/thumbnail-a4a80f8350d4a120091b2efc0d38b3bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549282"
"ResourceRecordKey" => "30018004"
"ModificationTimestamp" => "2026-07-10T17:04:15.99Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30018004_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018004/a5183bffb3287f3115e4340ec42ef0f5.webp"
"MediaSize" => 39818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018004/thumbnail-a5183bffb3287f3115e4340ec42ef0f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549282"
"ResourceRecordKey" => "30018004"
"ModificationTimestamp" => "2026-07-10T17:04:15.99Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30018004_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018004/7c3b8369e3bb2a715206d473a52cfe1f.webp"
"MediaSize" => 46077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018004/thumbnail-7c3b8369e3bb2a715206d473a52cfe1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549282"
"ResourceRecordKey" => "30018004"
"ModificationTimestamp" => "2026-07-10T17:04:15.99Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30018004_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018004/2a605af6f2c9aaf035405dfcb3dba63b.webp"
"MediaSize" => 61449
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018004/thumbnail-2a605af6f2c9aaf035405dfcb3dba63b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549282"
"ResourceRecordKey" => "30018004"
"ModificationTimestamp" => "2026-07-10T17:04:15.99Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30018004_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018004/1d49e742d31fc5ae100cb5c7e69adfd7.webp"
"MediaSize" => 49502
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018004/thumbnail-1d49e742d31fc5ae100cb5c7e69adfd7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549282"
"ResourceRecordKey" => "30018004"
"ModificationTimestamp" => "2026-07-10T17:04:15.99Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30018004_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018004/bdcbf02849b1269c3ae19f63d77f4610.webp"
"MediaSize" => 44294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018004/thumbnail-bdcbf02849b1269c3ae19f63d77f4610.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549282"
"ResourceRecordKey" => "30018004"
"ModificationTimestamp" => "2026-07-10T17:04:15.99Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30018004_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018004/1e9b0bf120bad1e84923f25e6b6cad8e.webp"
"MediaSize" => 48968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018004/thumbnail-1e9b0bf120bad1e84923f25e6b6cad8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549282"
"ResourceRecordKey" => "30018004"
"ModificationTimestamp" => "2026-07-10T17:04:15.99Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30018004_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018004/08e6116758e4a35586a491cc87699c3d.webp"
"MediaSize" => 60863
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018004/thumbnail-08e6116758e4a35586a491cc87699c3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549282"
"ResourceRecordKey" => "30018004"
"ModificationTimestamp" => "2026-07-10T17:04:15.99Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30018004_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018004/9df64c3682b748f3af48de9c54275623.webp"
"MediaSize" => 59750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018004/thumbnail-9df64c3682b748f3af48de9c54275623.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549282"
"ResourceRecordKey" => "30018004"
"ModificationTimestamp" => "2026-07-10T17:04:15.99Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30018004_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30018004/15b43e4ccebe065a7701b531ec5ae194.webp"
"MediaSize" => 55562
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30018004/thumbnail-15b43e4ccebe065a7701b531ec5ae194.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549282"
"ResourceRecordKey" => "30018004"
"ModificationTimestamp" => "2026-07-10T17:04:15.99Z"
]
18 => array:13 [
"Order" => 19
…12
]
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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30018004')"
+"ID": "1615436"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25282
+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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30017461')"
+"ID": "1615437"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25286
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25284
+post_id: "1612309"
+post_author: 1
+"ListingKey": "30011803"
+"ListingId": "X13543826"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-11T21:15:03Z"
+"RFModificationTimestamp": "2026-07-11T21:16:37Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0R3"
+"UnparsedAddress": "74 COLE STREET, Hamilton (Waterdown), Ontario L8B0R3"
+"Coordinates": array:2 [
0 => -79.907465
1 => 43.336608
]
+"Latitude": 43.336608
+"Longitude": -79.907465
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful freehold semi-detached home in the highly sought-after west end of Waterdown! This bright, open-concept home features dark hardwood flooring throughout the main level, stainless steel appliances, a stylish backsplash, crown moulding, and a walk-out to the deck-perfect for indoor-outdoor living. The hardwood staircase is accented with elegant wrought iron spindles, while large windows fill the home with an abundance of natural light. The spacious primary bedroom offers ensuite privilege, and the house has been freshly painted with new floors on the upstairs level. The finished basement includes a bedroom with its own ensuite bathroom, ideal for guests or extended family. (id:62650)"
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T19:43:51.688171+00:00"
+"Directions": "Cross Streets: Parkside Dr & Hamilton St. ** Directions: Parkside Dr to Cole st."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027012"
+"ListOfficeKey": "268183"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-10T02:09:26Z"
+"PhotosCount": 29
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-11T21:08:34Z"
+"Stories": "2.0"
+"StreetName": "Cole"
+"StreetNumber": "74"
+"StreetSuffix": "Street"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30011803/74-cole-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3000
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-09T16:41:10.09Z"
+"ListAgentNationalAssociationId": "1306463"
+"ListOfficeNationalAssociationId": "1230066"
+"Media": array:29 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30011803')"
+"ID": "1612309"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25279
+post_id: "1607869"
+post_author: 1
+"ListingKey": "30009815"
+"ListingId": "X13541784"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-12T16:50:03Z"
+"RFModificationTimestamp": "2026-07-12T16:51:40Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "1205 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.879636
1 => 43.343264
]
+"Latitude": 43.343264
+"Longitude": -79.879636
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Spectacular floor to ceiling views from the 12th floor Penthouse of this premium corner 2 Bedrooms, 2 full bath condo. Tons of Natural Light in every room! Be the first to live in this bright, sleek & stylish suite in popular "Trend 2" building, desirable Waterdown! Modern 880 Sq Ft, offers 10ft ceilings, in suite laundry. Tastefully Upgraded w/ Zebra blinds. Tile & laminate flooring. Open Kitchen & Great Room. White shaker style cabinetry, Quartz Counter tops, under cabinet lighting, SS Appliances & Island w/ double sink & seating for 4. Large Great room w/ Juliette Balcony. Primary Bedroom w/ Floor to Ceiling Windows, Upgraded 3 Piece Ensuite & Walk-In Closet. Second Bedroom also has Floor to Ceiling Windows w/ double sliding door closet. Beautiful 4 piece main bath. 1 Underground Parking & 1 Locker. Fabulous Amenities Includes Party Rooms, Fitness Facilities, Rooftop Patio with BBQ's, Secure Bike Storage, Secure Parcel Storage. Minutes from Hwy 403 & 407, Aldershot GO Station. Available August 15, 2026 (id:62650)"
+"Appliances": array:1 [
0 => "Garage door opener remote(s)"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"CreationDate": "2026-07-09T13:50:20.176462+00:00"
+"Directions": "DUNDAS ST - MALLARD TRAIL"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Stucco"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2094168"
+"ListOfficeKey": "283410"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-09T12:38:48Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-12T16:41:02Z"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30009815/1205-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 2750
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-09T12:38:48.66Z"
+"ListAgentNationalAssociationId": "1366612"
+"ListOfficeNationalAssociationId": "1328651"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30009815')"
+"ID": "1607869"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23484
+post_id: "1607870"
+post_author: 1
+"ListingKey": "30009813"
+"ListingId": "X13541768"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-11T01:10:03Z"
+"RFModificationTimestamp": "2026-07-11T01:17:05Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L2B2A5"
+"UnparsedAddress": "602 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L2B2A5"
+"Coordinates": array:2 [
0 => -79.879636
1 => 43.343264
]
+"Latitude": 43.343264
+"Longitude": -79.879636
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "2 Bedrooms, 2 bathrooms, 2 parking spots! Welcome to suite 602. Fantastic condo available in the desirable Waterdown community! This gorgeous corner suite offers plenty of space and convenience for modern living. It is designed to impress with its sun-drenched interiors, 10-foot ceilings, and floor-to-ceiling windows with custom blinds. The open concept kitchen and living area are perfect for entertaining, complete with stainless steel appliances and a breakfast bar. A spacious, bright primary bedroom with ensuite bathroom and a second bedroom and bathroom provide ample living space. In-suite laundry and a storage locker on the same floor provide extra convenience. For added comfort and efficiency, the state-of-the-art Geothermal Heating and Cooling system keeps hydro bills impressively low. The building boasts a host of fabulous amenities including party rooms, modern fitness facilities, rooftop patios, and bike storage. The location is ideal, surrounded by excellent dining, shopping, schools, and parks. Commuters will appreciate being close to key routes-just a five-minute drive to downtown Burlington or the Aldershot GO Station, and only a 25-minute commute to Mississauga. (id:62650)"
+"Appliances": array:1 [
0 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Apartment in basement"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T13:36:49.517814+00:00"
+"Directions": "Dundas st/Riverwalk Dr"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Stucco"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2107580"
+"ListOfficeKey": "50211"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-09T12:38:48Z"
+"PhotosCount": 19
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-11T01:04:03Z"
+"StreetDirPrefix": "East"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"View": "Mountain view"
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30009813/602-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 2650
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-09T12:38:48.38Z"
+"ListAgentNationalAssociationId": "1376621"
+"ListOfficeNationalAssociationId": "1002576"
+"Media": array:19 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30009813')"
+"ID": "1607870"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25287
+post_id: "1599103"
+post_author: 1
+"ListingKey": "29995657"
+"ListingId": "X13529006"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T20:30:03Z"
+"RFModificationTimestamp": "2026-07-07T01:32:35Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "513 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.880553
1 => 43.342598
]
+"Latitude": 43.342598
+"Longitude": -79.880553
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Newer Luxury Condo In A Commuters Dream Location, Short Drive To 403, Hwy 6 And 407 . This One + Den Bedroom Condo Has A Great Layout With A Large Living Room And Extra High Ceilings. Packed With Rare Builder Upgrades: Quartz Counter In Kitchen And Bathroom With Under Mount Sinks, Upgraded Flooring Thru Out (No Carpet), Upgraded Stainless Steel Appliances And A Full Sized Front Loading Washer And Dryer! Fantastic Galley Kitchen With A Large Breakfast Bar And A Walk-Out To Your Private Sunny South Facing Balcony. Convenient Bedroom With Large Walk In Closet. The Condo Is Complete With A 4 Piece Bathroom With Tile Shower And Tub, Cabinets And Tile Flooring. Enjoy All Of The Fabulous Amenities That This Building Has To Offer, Including Party Room, Fitness Facility, Rooftop Patios With Bbqs, Bike Storage And More. Situated In The Desirable Waterdown Community With Fabulous Dining, Shopping, Schools And Parks All Within A Short Stroll. 1 Underground Parking Spot And 1 Locker Included. (id:62650)"
+"Appliances": array:3 [
0 => "Washer"
1 => "Dryer"
2 => "Blinds"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T01:32:28.303927+00:00"
+"Directions": "Dundas Street East"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1735614"
+"ListOfficeKey": "118891"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-06T20:24:43Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T20:24:43Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"View": "City view"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29995657/513-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1593651"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"CoListOfficeKey": "283413"
+"GeocodeManualYN": false
+"TotalActualRent": 2150
+"BuildingFeatures": array:5 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Recreation Centre"
3 => "Party Room"
4 => "Visitor Parking"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-06T20:24:43.68Z"
+"ListAgentNationalAssociationId": "1177744"
+"ListOfficeNationalAssociationId": "1168927"
+"CoListAgentNationalAssociationId": "1155094"
+"CoListOfficeNationalAssociationId": "1328652"
+"Media": array:24 [
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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29995657')"
+"ID": "1599103"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25288
+post_id: "1594555"
+post_author: 1
+"ListingKey": "29991073"
+"ListingId": "X13524416"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T21:50:06Z"
+"RFModificationTimestamp": "2026-07-07T01:25:30Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "309 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.879636
1 => 43.343264
]
+"Latitude": 43.343264
+"Longitude": -79.879636
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "One bedroom condo with ensuite laundry, surface parking and locker. The hydro and water utility bills to be paid by tenant. Building amenities include an exercise room, rooftopterrace with BBQs, beautiful party room, bike storage. Area amenities include close proximity to Aldershot GO and highways, close to trails for hiking and biking, shopping. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-05T18:45:48.975945+00:00"
+"Directions": "Riverwalk dr and Dundas St E"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1879322"
+"ListOfficeKey": "162091"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-05T17:39:08Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T21:41:20Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29991073/309-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2108964"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"CoListOfficeKey": "162091"
+"GeocodeManualYN": false
+"TotalActualRent": 1900
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-05T17:39:08.29Z"
+"ListAgentNationalAssociationId": "1205602"
+"ListOfficeNationalAssociationId": "1284595"
+"CoListAgentNationalAssociationId": "1377779"
+"CoListOfficeNationalAssociationId": "1284595"
+"Media": array:21 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29991073')"
+"ID": "1594555"
}
]
+success: true
+page_size: 9
+page_count: 4
+count: 36
+after_key: ""
}
"RF Response Time" => "0.19 seconds"
]
]