array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29891241 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: "1521720"
+post_author: 1
+"ListingKey": "29891241"
+"ListingId": "X13433690"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T20:40:08Z"
+"RFModificationTimestamp": "2026-06-11T20:42:31Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1V8"
+"UnparsedAddress": "601 - 30 HAMILTON STREET S, Hamilton (Waterdown), Ontario L8B1V8"
+"Coordinates": array:2 [
0 => -79.894191
1 => 43.330175
]
+"Latitude": 43.330175
+"Longitude": -79.894191
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 601 at 30 Hamilton St S - a stunning 1 Bed + Den sixth-floor residence in the heart of Waterdown where thoughtful design meets an unbeatable location. This spacious 700 sq ft layout offers the perfect blend of comfort and versatility. Step out onto your private balcony and be greeted by sweeping views that remind you why you chose to call Waterdown home. Just seconds away, the building's Sky Deck takes it further - panoramic sight-lines stretching across the Niagara Escarpment, the Hamilton skyline, the iconic Skyway Bridge, and the shimmering expanse of Lake Ontario. Few residences anywhere in the region can match this vantage point. Convenience is built right into the neighbourhood. Everything you need is within walking distance - groceries, restaurants, pharmacies, banks, and gas stations are all just steps from your front door, making everyday errands effortless. And for those who commute, Aldershot GO Station is just a 5-minute drive away, putting Toronto and the entire GO network well within reach.This isn't just a unit to rent - it's a home you'll be proud to come back to every day. From the sixth-floor elevation that sets you above the noise to the community-focused charm of Waterdown's village streets below, Unit 601 offers a lifestyle as elevated as its views. Whether you're a professional seeking a seamless commute, a couple looking for a stylish and functional space, or anyone who simply refuses to settle for ordinary - this is the one. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T20:42:18.338679+00:00"
+"Directions": "Cross Streets: Hamilton St S @ Barton St. ** Directions: Hamilton St S to Barton Street."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2068660"
+"ListOfficeKey": "85099"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-11T20:33:06Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T20:33:06Z"
+"StreetDirSuffix": "South"
+"StreetName": "Hamilton"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"View": "City view,Lake view,View of water"
+"VirtualTourURLUnbranded": "https://youriguide.com/unit_601_30_hamilton_st_s_hamilton_on/"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1657325701"
"RoomType" => "Kitchen"
"ListingId" => "X13433690"
"RoomLevel" => "Main level"
"RoomWidth" => 2.72
"ListingKey" => "29891241"
"RoomLength" => 3.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T20:33:06.43Z"
]
1 => array:11 [
"RoomKey" => "1657325702"
"RoomType" => "Dining room"
"ListingId" => "X13433690"
"RoomLevel" => "Main level"
"RoomWidth" => 2.85
"ListingKey" => "29891241"
"RoomLength" => 3.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T20:33:06.43Z"
]
2 => array:11 [
"RoomKey" => "1657325703"
"RoomType" => "Living room"
"ListingId" => "X13433690"
"RoomLevel" => "Main level"
"RoomWidth" => 2.96
"ListingKey" => "29891241"
"RoomLength" => 3.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T20:33:06.44Z"
]
3 => array:11 [
"RoomKey" => "1657325704"
"RoomType" => "Bedroom"
"ListingId" => "X13433690"
"RoomLevel" => "Main level"
"RoomWidth" => 3.14
"ListingKey" => "29891241"
"RoomLength" => 3.85
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T20:33:06.44Z"
]
4 => array:11 [
"RoomKey" => "1657325705"
"RoomType" => "Bathroom"
"ListingId" => "X13433690"
"RoomLevel" => "Main level"
"RoomWidth" => 2.28
"ListingKey" => "29891241"
"RoomLength" => 2.99
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T20:33:06.44Z"
]
5 => array:11 [
"RoomKey" => "1657325706"
"RoomType" => "Den"
"ListingId" => "X13433690"
"RoomLevel" => "Main level"
"RoomWidth" => 2.39
"ListingKey" => "29891241"
"RoomLength" => 3.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T20:33:06.44Z"
]
]
+"ListAOR": "OnePoint"
+"CityRegion": "Waterdown"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29891241/601-30-hamilton-street-s-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"TotalActualRent": 2375
+"BuildingFeatures": array:5 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Security/Concierge"
4 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-11T19:31:56.65Z"
+"ListAgentNationalAssociationId": "1343730"
+"ListOfficeNationalAssociationId": "1187791"
+"Media": array:44 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29891241_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/3051e4bfd1168335c4c7791eb8e41334.webp"
"MediaSize" => 377249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-3051e4bfd1168335c4c7791eb8e41334.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29891241_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/b9cccd89497ce5235bb21c1e14118b3b.webp"
"MediaSize" => 268520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-b9cccd89497ce5235bb21c1e14118b3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29891241_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/27513e1a13c3cb72f168e2d317b3a5da.webp"
"MediaSize" => 394512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-27513e1a13c3cb72f168e2d317b3a5da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29891241_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/fab1d03646ce37197f269bd1c241d83c.webp"
"MediaSize" => 349104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-fab1d03646ce37197f269bd1c241d83c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29891241_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/8d0dcd12022a52532e25041320818e36.webp"
"MediaSize" => 147610
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-8d0dcd12022a52532e25041320818e36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29891241_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/a1514d04ac75712ffa42e0b8b3e40bcd.webp"
"MediaSize" => 122928
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-a1514d04ac75712ffa42e0b8b3e40bcd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29891241_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/30fb4c3eeb601ae6b9bc0f09617774c8.webp"
"MediaSize" => 77241
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-30fb4c3eeb601ae6b9bc0f09617774c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29891241_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/a8c9accd44dc0c069d2ece20d5a6124d.webp"
"MediaSize" => 98277
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-a8c9accd44dc0c069d2ece20d5a6124d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29891241_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/cc68b7cf32bdeed4fb36a91dcb26d95f.webp"
"MediaSize" => 166857
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-cc68b7cf32bdeed4fb36a91dcb26d95f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29891241_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/7a579939c00a58d58322f2fde94255c0.webp"
"MediaSize" => 126661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-7a579939c00a58d58322f2fde94255c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29891241_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/98e2cd2ec5f726cbb03e3e4bdc2cb3aa.webp"
"MediaSize" => 155575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-98e2cd2ec5f726cbb03e3e4bdc2cb3aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29891241_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/763eccef8a0098411977d6dd6404e1e9.webp"
"MediaSize" => 128300
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-763eccef8a0098411977d6dd6404e1e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29891241_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/cd030102b39c1ecddaa80a59c02cb6de.webp"
"MediaSize" => 123698
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-cd030102b39c1ecddaa80a59c02cb6de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29891241_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/0c8e6b087b13c90b9d94ec09618c125e.webp"
"MediaSize" => 128544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-0c8e6b087b13c90b9d94ec09618c125e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29891241_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/c0ca81a1c3230ad9f6bda6fa41ceb86b.webp"
"MediaSize" => 127610
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-c0ca81a1c3230ad9f6bda6fa41ceb86b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29891241_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/510fb287f3c8fe6301ca102d9b6089ff.webp"
"MediaSize" => 124224
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-510fb287f3c8fe6301ca102d9b6089ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29891241_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/02fe037810b8815deba59236c147df8b.webp"
"MediaSize" => 233497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-02fe037810b8815deba59236c147df8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29891241_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/779d195162291700ab4f36ee8afb5221.webp"
"MediaSize" => 234426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-779d195162291700ab4f36ee8afb5221.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29891241_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/25a2bca38989e20b84794831c27a2bf5.webp"
"MediaSize" => 254132
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-25a2bca38989e20b84794831c27a2bf5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29891241_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/d58006fb14a090d3f5aa3c84c2c2ac1a.webp"
"MediaSize" => 108491
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-d58006fb14a090d3f5aa3c84c2c2ac1a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29891241_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/95b09eea3433235627e8963eaf1f69e2.webp"
"MediaSize" => 100759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-95b09eea3433235627e8963eaf1f69e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29891241_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/09bd5407c1e5b7acf2ca66e8df93af01.webp"
"MediaSize" => 105060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-09bd5407c1e5b7acf2ca66e8df93af01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29891241_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/f41780bc0702996f94faa19e7595386e.webp"
"MediaSize" => 103751
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-f41780bc0702996f94faa19e7595386e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29891241_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/099539c6e7d4ce1d8409dbd258c146a7.webp"
"MediaSize" => 231909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-099539c6e7d4ce1d8409dbd258c146a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29891241_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/84e662b8b2a3b59a09d2dfa075c0f2c6.webp"
"MediaSize" => 199185
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-84e662b8b2a3b59a09d2dfa075c0f2c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29891241_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/58fb5870bffc22ccfc72258ecc4f62dd.webp"
"MediaSize" => 168001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-58fb5870bffc22ccfc72258ecc4f62dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29891241_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/27bd10b7ab5c2ad38b82ecc56c3cfb3f.webp"
"MediaSize" => 159122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-27bd10b7ab5c2ad38b82ecc56c3cfb3f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29891241_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/0d1dd9fd7725f7c7a80620f36b027304.webp"
"MediaSize" => 213591
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-0d1dd9fd7725f7c7a80620f36b027304.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29891241_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/db79da58c563acd0eb2474cbf3a0ccf9.webp"
"MediaSize" => 323241
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-db79da58c563acd0eb2474cbf3a0ccf9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29891241_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/a24161a93739c81349b1b4fbc864dcc2.webp"
"MediaSize" => 211252
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-a24161a93739c81349b1b4fbc864dcc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29891241_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/c67f2471a07fde17098623590338c8e2.webp"
"MediaSize" => 298822
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-c67f2471a07fde17098623590338c8e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29891241_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/33350ab7b086249d0166d9fbeec4b02d.webp"
"MediaSize" => 213351
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-33350ab7b086249d0166d9fbeec4b02d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29891241_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/ad975961b5bece4034abd28164ac6082.webp"
"MediaSize" => 195429
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-ad975961b5bece4034abd28164ac6082.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29891241_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/81662d721b981b4032f35eeb9be5fdbc.webp"
"MediaSize" => 224013
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-81662d721b981b4032f35eeb9be5fdbc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29891241_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/6b7697ad31dd19c3c19fe3d8a732a873.webp"
"MediaSize" => 191689
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-6b7697ad31dd19c3c19fe3d8a732a873.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29891241_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/267d9fed5a4450cd16a66f97961be7b4.webp"
"MediaSize" => 190886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-267d9fed5a4450cd16a66f97961be7b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29891241_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/5095ae4859e0ffc783a61abe12f8d942.webp"
"MediaSize" => 226754
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-5095ae4859e0ffc783a61abe12f8d942.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29891241_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/69db3e477d0807b2a913d3f98131c449.webp"
"MediaSize" => 198269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-69db3e477d0807b2a913d3f98131c449.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29891241_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/043019c766307195686d67818615207e.webp"
"MediaSize" => 197408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-043019c766307195686d67818615207e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29891241_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/98268fd64516a9ed1dd72c41038f682a.webp"
"MediaSize" => 214166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-98268fd64516a9ed1dd72c41038f682a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29891241_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/6e72dccac759fbbe8790dfc814eaeb40.webp"
"MediaSize" => 215467
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-6e72dccac759fbbe8790dfc814eaeb40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29891241_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/0fe873e2926b6517b42d086ea5c52e0e.webp"
"MediaSize" => 279783
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-0fe873e2926b6517b42d086ea5c52e0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29891241_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/72f444aec3f1e097706dd0f3340c0a42.webp"
"MediaSize" => 256739
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-72f444aec3f1e097706dd0f3340c0a42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:31:56.66Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29891241_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891241/b15301bdd00a5fc828c919740b83763f.webp"
"MediaSize" => 107208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891241/thumbnail-b15301bdd00a5fc828c919740b83763f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433690"
"ResourceRecordKey" => "29891241"
"ModificationTimestamp" => "2026-06-11T19:56:27.24Z"
]
]
+"DaysOnMarket": 31
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891241')"
+"ID": "1521720"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.26 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 85099" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24991
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24865
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Coldwell Banker Neumann Real Estate"
+"OfficeEmail": null
+"OfficePhone": "519-821-3600"
+"OfficeMlsId": "558300"
+"ModificationTimestamp": "2026-04-22T08:10:00Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "85099"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "824 GORDON STREET"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "GUELPH"
+"OfficePostalCode": "N1G1Y"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "OnePoint"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1187791"
+"OriginalEntryTimestamp": null
+"OfficeFax": "519-821-3660"
+"OfficeAORKey": "47"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "395246"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "85099"
"SocialMediaUrlOrId" => "http://www.cbn.on.ca/"
"ModificationTimestamp" => "2026-04-22T05:27:00Z"
]
]
+"FranchiseNationalAssociationId": "1230688"
+"OfficeBrokerNationalAssociationId": "1181540"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('85099')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2068660" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24888
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29891241'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25316
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29891241' AND OpenHouseDate ge '2026-07-12'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25332
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29891241' 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.894191 43.330175)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25407
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25401
+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"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25403
+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"
…9
]
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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30022071')"
+"ID": "1617166"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25400
+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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30018004')"
+"ID": "1615436"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25404
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25402
+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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25397
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23484
+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"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25405
+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"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25406
+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"
}
]
+success: true
+page_size: 9
+page_count: 6
+count: 49
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]