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 {#23380
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23382
+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": 7
+"@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.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 85099" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24771
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2068660" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24776
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29891241'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25238
+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'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25254
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '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 {#25314
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25308
+post_id: "1546777"
+post_author: 1
+"ListingKey": "29926450"
+"ListingId": "X13465022"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T01:55:19Z"
+"RFModificationTimestamp": "2026-06-19T04:50:24Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0K9"
+"UnparsedAddress": "33 STRATHROY CRESCENT, Hamilton (Waterdown), Ontario L8B0K9"
+"Coordinates": array:2 [
0 => -79.916092
1 => 43.327793
]
+"Latitude": 43.327793
+"Longitude": -79.916092
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning 3 bedrooms exec. double garage detached house 2566 sq. ft. (converted from 4 bedroom plan) on a premium 131' deeppie-shaped lot that is 61' wide across back of the house! Main floor has a bright & airy high ceiling foyer. New upgraded staircase andnew wood flooring 2nd floor and landing areas (2026), upgraded wide-plank hardwood floors, formal liv. room with bay window,spacious dining room w/coffered ceiling & wainscotting, large family room w/rustic wood feature wall, gas fireplace w/porcelain tilesurround & sliding door walk-out to sun room with skylight & walk-outs to back yard. Completely renovated designer kitchenw/custom white cabinetry, quartz counters, high-end built-in S/S appliances, large island with breakfast bar, open to family room. Theprofessionally landscaped backyard oasis with covered interlock stone patio, BBQ area, lighting & inground heated saltwater poolw/newer liner (2019), new pool heater & pool pump (2025),great for time spend w/family & friends. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Oven"
5 => "Dryer"
6 => "Microwave"
7 => "Blinds"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T04:50:20.832923+00:00"
+"Directions": "Parkside/Hollybush/Strathroy"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"Flooring": array:4 [
0 => "Concrete"
1 => "Tile"
2 => "Hardwood"
3 => "Carpeted"
]
+"FoundationDetails": array:2 [
0 => "Concrete"
1 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1562528"
+"ListOfficeKey": "285001"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"LotSizeDimensions": "41 x 131.2 FT ; Irregular"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T01:47:24Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T01:47:23Z"
+"Stories": "2.0"
+"StreetName": "Strathroy"
+"StreetNumber": "33"
+"StreetSuffix": "Crescent"
+"VirtualTourURLUnbranded": "https://view.tours4listings.com/cp/33-strathroy-crescent-hamilton/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1662654776"
"RoomType" => "Living room"
"ListingId" => "X13465022"
"RoomLevel" => "Main level"
"RoomWidth" => 3.38
"ListingKey" => "29926450"
"RoomLength" => 4.32
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.96Z"
]
1 => array:11 [
"RoomKey" => "1662654777"
"RoomType" => "Other"
"ListingId" => "X13465022"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29926450"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.96Z"
]
2 => array:11 [
"RoomKey" => "1662654778"
"RoomType" => "Sunroom"
"ListingId" => "X13465022"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29926450"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.96Z"
]
3 => array:11 [
"RoomKey" => "1662654779"
"RoomType" => "Dining room"
"ListingId" => "X13465022"
"RoomLevel" => "Main level"
"RoomWidth" => 4.55
"ListingKey" => "29926450"
"RoomLength" => 4.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.96Z"
]
4 => array:11 [
"RoomKey" => "1662654780"
"RoomType" => "Family room"
"ListingId" => "X13465022"
"RoomLevel" => "Main level"
"RoomWidth" => 5.21
"ListingKey" => "29926450"
"RoomLength" => 6.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.96Z"
]
5 => array:11 [
"RoomKey" => "1662654781"
"RoomType" => "Kitchen"
"ListingId" => "X13465022"
"RoomLevel" => "Main level"
"RoomWidth" => 3.99
"ListingKey" => "29926450"
"RoomLength" => 5.54
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.96Z"
]
6 => array:11 [
"RoomKey" => "1662654782"
"RoomType" => "Laundry room"
"ListingId" => "X13465022"
"RoomLevel" => "Main level"
"RoomWidth" => 1.85
"ListingKey" => "29926450"
"RoomLength" => 3.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.96Z"
]
7 => array:11 [
"RoomKey" => "1662654783"
"RoomType" => "Foyer"
"ListingId" => "X13465022"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29926450"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.97Z"
]
8 => array:11 [
"RoomKey" => "1662654784"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13465022"
"RoomLevel" => "Second level"
"RoomWidth" => 5.18
"ListingKey" => "29926450"
"RoomLength" => 5.61
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.97Z"
]
9 => array:11 [
"RoomKey" => "1662654785"
"RoomType" => "Bedroom 2"
"ListingId" => "X13465022"
"RoomLevel" => "Second level"
"RoomWidth" => 3.96
"ListingKey" => "29926450"
"RoomLength" => 4.55
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.97Z"
]
10 => array:11 [
"RoomKey" => "1662654786"
"RoomType" => "Bedroom 3"
"ListingId" => "X13465022"
"RoomLevel" => "Second level"
"RoomWidth" => 3.43
"ListingKey" => "29926450"
"RoomLength" => 4.55
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.97Z"
]
11 => array:11 [
"RoomKey" => "1662654787"
"RoomType" => "Cold room"
"ListingId" => "X13465022"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29926450"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:23.97Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29926450/33-strathroy-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 4300
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 41.0
+"OriginalEntryTimestamp": "2026-06-19T01:47:23.93Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1138252"
+"ListOfficeNationalAssociationId": "1346507"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29926450_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/43ee55fd0fcd39ba161f178a44bd1450.webp"
"MediaSize" => 83230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-43ee55fd0fcd39ba161f178a44bd1450.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29926450_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/5b422953de77be56f8e020b2fd5c1936.webp"
"MediaSize" => 101566
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-5b422953de77be56f8e020b2fd5c1936.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29926450_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/13475a0dd02dbc264fbef3bb8d9b64fe.webp"
"MediaSize" => 123880
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-13475a0dd02dbc264fbef3bb8d9b64fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29926450_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/fe43da8eed85fee457d3c6dfbd8007b0.webp"
"MediaSize" => 45347
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-fe43da8eed85fee457d3c6dfbd8007b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29926450_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/dfa969d9d36bc0c61443cfc3d5c086ca.webp"
"MediaSize" => 62009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-dfa969d9d36bc0c61443cfc3d5c086ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29926450_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/6a459f166582fcf19edc5e716bdd4a67.webp"
"MediaSize" => 57638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-6a459f166582fcf19edc5e716bdd4a67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29926450_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/752fe4f557d8c67d51ceb7856b46df6d.webp"
"MediaSize" => 53729
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-752fe4f557d8c67d51ceb7856b46df6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29926450_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/efeb540030590908cbd5ad292750aaed.webp"
"MediaSize" => 64508
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-efeb540030590908cbd5ad292750aaed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29926450_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/09c74cc558c2fa337ac95a69bd8a4dda.webp"
"MediaSize" => 59554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-09c74cc558c2fa337ac95a69bd8a4dda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29926450_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/cf1b6f3bd1ea71d5687b32806ca785a7.webp"
"MediaSize" => 64677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-cf1b6f3bd1ea71d5687b32806ca785a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29926450_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/210b51d089e55833e1b05d8db0910d5c.webp"
"MediaSize" => 63802
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-210b51d089e55833e1b05d8db0910d5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29926450_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/57698bbd7ae5f812b61ee0d1d02a45c9.webp"
"MediaSize" => 64951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-57698bbd7ae5f812b61ee0d1d02a45c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29926450_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/dcc164974c8272f89db9ef3573d1567e.webp"
"MediaSize" => 59030
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-dcc164974c8272f89db9ef3573d1567e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29926450_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/70b95afaff246ce9b8136037ef2b87d5.webp"
"MediaSize" => 54499
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-70b95afaff246ce9b8136037ef2b87d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29926450_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/8146a0557904aec06f64052609045604.webp"
"MediaSize" => 60637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926450/thumbnail-8146a0557904aec06f64052609045604.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465022"
"ResourceRecordKey" => "29926450"
"ModificationTimestamp" => "2026-06-19T01:47:23.94Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29926450_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926450/296917fae425120b76483a01b6dba319.webp"
"MediaSize" => 54880
…9
]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29926450')"
+"ID": "1546777"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25310
+post_id: "1542420"
+post_author: 1
+"ListingKey": "29920334"
+"ListingId": "X13459650"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T05:25:16Z"
+"RFModificationTimestamp": "2026-06-18T07:32:15Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "114 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This beautifully appointed ground-floor condo offers style, comfort, and convenience in one of Waterdown's most sought-after communities.Ideally located within walking distance to shopping, restaurants, parks, and everyday amenities, this home also offers easy access to major highways and public transit, making commuting a breeze.Step inside to discover a bright open-concept layout featuring elegant flooring throughout. The modern kitchen is designed to impress with quartz countertops, stainless steel appliances, an undermount sink, and a peninsula with breakfast bar seating, perfect for casual dining, entertaining, or your morning coffee.The sun-filled living area opens onto a private balcony, providing the perfect space to relax and enjoy the outdoors. The spacious bedroom features floor-to-ceiling windows and a peaceful atmosphere, while the stylish 4-piece bathroom showcases contemporary finishes. In-suite laundry, one owned parking space, and a storage locker add to the everyday convenience.Residents enjoy access to exceptional building amenities, including a fitness centre, party room, rooftop terrace and garden, community BBQ area, bicycle storage, and a welcoming lobby lounge.Just minutes from Burlington's vibrant waterfront, restaurants, and entertainment district, this move-in-ready condo offers an outstanding opportunity to enter the market and enjoy modern condo living in a prime location.Some photos have been virtually staged to illustrate the property's potential layout and use of space. Furnishings and decor shown in these images may not be present at the property. (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-06-18T07:32:08.554747+00:00"
+"Directions": "Dundas/ Mallard/ Riverwalk"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2011104"
+"ListOfficeKey": "288626"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T05:15:47Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T05:15:47Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29920334/114-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 2100
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-18T05:15:47.01Z"
+"ListAgentNationalAssociationId": "1292549"
+"ListOfficeNationalAssociationId": "1370159"
+"Media": array:27 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29920334')"
+"ID": "1542420"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25307
+post_id: "1542427"
+post_author: 1
+"ListingKey": "29919819"
+"ListingId": "40840666"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T00:45:18Z"
+"RFModificationTimestamp": "2026-06-18T03:48:22Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2200.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B1W3"
+"UnparsedAddress": "141 BORERS CREEK Circle, Hamilton, Ontario L8B1W3"
+"Coordinates": array:2 [
0 => -79.9185268
1 => 43.3322591
]
+"Latitude": 43.3322591
+"Longitude": -79.9185268
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning freehold corner townhome in sought-after Waterdown West, offering over 2,300 sq. ft. of beautifully finished living space with 4+1 bedrooms and 4 bathrooms. The ground level features a bright recreation room with walkout access to the backyard, a versatile den ideal for a home office or guest room, and a newly finished lower level that provides even more flexible living space for a growing family. The main floor is flooded with natural light and showcases 9-foot ceilings, oversized windows, and hardwood flooring throughout. At the heart of the home is a beautifully appointed kitchen featuring stainless steel appliances, granite countertops, upgraded cabinetry, modern fixtures, and a large centre island perfect for both everyday living and entertaining. Upstairs, you’ll find spacious bedrooms, well-appointed bathrooms, custom closet organizers, and thoughtful finishes throughout. Additional features include central vacuum, builder-installed ethernet wiring, and cable connections for modern convenience. Step outside to your private backyard retreat, complete with professional hardscaping. Perfectly positioned beside scenic Borers Creek Trail and just minutes from downtown Waterdown’s charming shops, restaurants, parks, and amenities, with easy access to Highway 403 and the GO Station, this is an exceptional opportunity to own a move-in-ready home in one of Waterdown’s most desirable communities. (id:62783)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T03:48:13.994444+00:00"
+"Directions": "Parkside to Mosaic"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2110665"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T00:40:03Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T00:40:03Z"
+"Stories": "3.0"
+"StreetName": "BORERS CREEK"
+"StreetNumber": "141"
+"StreetSuffix": "Circle"
+"SubdivisionName": "460 - Waterdown West"
+"VirtualTourURLUnbranded": "https://oatstudio.aryeo.com/sites/141-borers-creek-cir-hamilton-on-l8b-1w3-25868668/branded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29919819/141-borers-creek-circle-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2185296"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283666"
+"GeocodeManualYN": true
+"TotalActualRent": 3800
+"ZoningDescription": "R6-38"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2200
+"OriginalEntryTimestamp": "2026-06-18T00:40:03.12Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1379232"
+"ListOfficeNationalAssociationId": "1333115"
+"CoListAgentNationalAssociationId": "1434925"
+"CoListOfficeNationalAssociationId": "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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919819')"
+"ID": "1542427"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25311
+post_id: "1542434"
+post_author: 1
+"ListingKey": "29919882"
+"ListingId": "X13459338"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T01:35:11Z"
+"RFModificationTimestamp": "2026-06-18T01:49:46Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W3"
+"UnparsedAddress": "141 BORERS CREEK CIRCLE, Hamilton (Waterdown), Ontario L8B1W3"
+"Coordinates": array:2 [
0 => -79.918643
1 => 43.332392
]
+"Latitude": 43.332392
+"Longitude": -79.918643
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to this stunning freehold corner townhome in sought-after Waterdown West, offering over 2,300 sq. ft. of beautifully finished living space with 4+1 bedrooms and 4 bathrooms. The ground level features a bright recreation room with walkout access to the backyard, a versatile den ideal for a home office or guest room, and a newly finished lower level that provides even more flexible living space for a growing family. The main floor is flooded with natural light and showcases 9-foot ceilings, oversized windows, and hardwood flooring throughout. At the heart of the home is a beautifully appointed kitchen featuring stainless steel appliances, granite countertops, upgraded cabinetry, modern fixtures, and a large centre island perfect for both everyday living and entertaining. Upstairs, you'll find spacious bedrooms, well-appointed bathrooms, custom closet organizers, and thoughtful finishes throughout. Additional features include central vacuum, builder-installed ethernet wiring, and cable connections for modern convenience. Step outside to your private backyard retreat, complete with professional hardscaping. Perfectly positioned beside scenic Borers Creek Trail and just minutes from downtown Waterdown's charming shops, restaurants, parks, and amenities, with easy access to Highway 403 and the GO Station, this is an exceptional opportunity to own a move-in-ready home in one of Waterdown's most desirable communities. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T01:49:36.409059+00:00"
+"Directions": "Mosaic Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955536"
+"ListOfficeKey": "205316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T01:26:28Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T01:26:28Z"
+"Stories": "3.0"
+"StreetName": "Borers Creek"
+"StreetNumber": "141"
+"StreetSuffix": "Circle"
+"VirtualTourURLUnbranded": "https://oatstudio.aryeo.com/sites/141-borers-creek-cir-hamilton-on-l8b-1w3-25868668/branded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29919882/141-borers-creek-circle-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2227828"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "266588"
+"GeocodeManualYN": false
+"TotalActualRent": 3800
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-18T01:26:28.3Z"
+"ListAgentNationalAssociationId": "1247407"
+"ListOfficeNationalAssociationId": "1264489"
+"CoListAgentNationalAssociationId": "1470830"
+"CoListOfficeNationalAssociationId": "1274323"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919882')"
+"ID": "1542434"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25309
+post_id: "1541752"
+post_author: 1
+"ListingKey": "29919163"
+"ListingId": "X13458862"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T22:35:12Z"
+"RFModificationTimestamp": "2026-06-18T00:26:49Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8N2Z7"
+"UnparsedAddress": "184 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8N2Z7"
+"Coordinates": array:2 [
0 => -79.902542
1 => 43.324431
]
+"Latitude": 43.324431
+"Longitude": -79.902542
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Discover luxury and lifestyle in this beautifully crafted custom bungalow, situated on animpressive 0.45-acre lot just minutes from downtown Waterdown. This home offers nearly 5,000sq. ft. of living space, featuring 5 bedrooms (3 on the main floor and 2 in the lower level)and 6 bathrooms (3 on the main floor and 3 in the lower level). Home can come furnished and available for a 1 year lease.As you approach the property, you'll be greeted by oversized trees and thoughtfully designed landscaping, complemented by ample parking and stone pillars with lights. The main entrance features custom doors and a covered front entry with iron railings, leading into a main floor that overlooks the sunken great room, which has French doors opening to the flagstone patio with an awning. The main floor also includes a private office, perfect for remote work, as well as a separate formal dining room. The open-concept kitchen and family room create an entertainer's delight, equipped with large glass sliders that lead to a bright sunroom. Thefamily room features a stunning wall of granite stone and a gas fireplace.The modern lower level is finished to perfection, featuring 2 spacious bedrooms, each with walk-in closets and personal 3-piece en-suites. The open-concept kitchen and family room flow seamlessly to a walkout patio, providing an excellent setting for relaxation. With a separate entrance and privacy. Step outside to your own backyard oasis, complete with a cozy fire pit area and multi-level patios made of flagstone and interlock, all enclosed by a fully fenced yard for your private enjoyment. The professionally landscaped exterior features natural rockery and mature gardens, enhancing the home's impressive curb appeal.Additional highlights:- Utilities & Cable/Internet not included in lease price- 2 kitchens and 2 laundry rooms- 2.5 car garage- A full-house generator- Tenant insurance required- AAA Tenants only. (id:62783)"
+"Appliances": array:9 [
0 => "Water purifier"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Range"
4 => "Oven - Built-In"
5 => "Water Treatment"
6 => "Garage door opener remote(s)"
7 => "Water Heater - Tankless"
8 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:10 [
0 => "Finished"
1 => "Full"
2 => "Apartment in basement"
3 => "Separate entrance"
4 => "Walk out"
5 => "Walk-up"
6 => "N/A"
7 => "N/A"
8 => "N/A"
9 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T00:26:39.515315+00:00"
+"Directions": "Dundas St. East & Riley"
+"Electric": "Generator"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1992922"
+"ListOfficeKey": "47632"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Wheelchair access"
1 => "Carpet Free"
2 => "Sump Pump"
3 => "In-Law Suite"
]
+"LotSizeDimensions": "105.4 x 184.8 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-17T22:26:20Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T22:26:19Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "184"
+"StreetSuffix": "Street"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29919163/184-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 15
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 6500
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"PropertyCondition": array:1 [
0 => "Insulation upgraded"
]
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 105.4
+"OriginalEntryTimestamp": "2026-06-17T22:26:19.43Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1276178"
+"ListOfficeNationalAssociationId": "1001102"
+"Media": array:39 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919163')"
+"ID": "1541752"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25304
+post_id: "1539053"
+post_author: 1
+"ListingKey": "29915901"
+"ListingId": "X13455876"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T16:05:15Z"
+"RFModificationTimestamp": "2026-06-17T16:35:32Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "1102 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.879544
1 => 43.343071
]
+"Latitude": 43.343071
+"Longitude": -79.879544
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to the Trend Community in Waterdown, overlooking the welcoming greenery of North Burlington from the window of your Condo. This Brand New Stunning 2 Beds, 2 Baths 880 sqft unit boasts an abundance of natural light with windows throughout with the amazing views of lush green Waterdown and glimpses of Lake Ontario. Automated Neutrally Colored Blinds compliments windows of the Apartment all through allowing control of how much Natural light is allowed in. The Open concept Kitchen has rich upgraded white cabinets with beautiful quartz countertops and High-end upgraded Stainless steel appliances. The Spacious Primary Bedroom has its own 3 piece Ensuite with stunning glass shower, quartz cabinet top, upgraded ceramic tiles and upgraded under mount sink. Second room is very conveniently sized, Living room and second 4 piece bath are rich with upgraded tiles and Laminate floorings. Your convenience is assured with Ensuite Laundry that has upgraded extra load stacked Washer and Dryer, 1 underground parking spot and 1 spot storage Locker. The Amenities include Fitness Centre, Rooftop Patio, Bike storage, Party room. This amazing unit located in the Waterdown Neighborhood is surrounded by excellent dining options, shopping, schools and parks. Don't miss this great opportunity, it won't last long. This Condo is 5 minutes to reach the Aldershot Go station, 10 minutes to Downtown Burlington, 15 minutes to Downtown Hamilton and 20 minutes to Mississauga. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
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-06-17T16:35:18.173461+00:00"
+"Directions": "Dundas Street East and Mallard"
+"ExteriorFeatures": array:1 [
0 => "Steel"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2109403"
+"ListOfficeKey": "283413"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-17T15:57:54Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T15:57:54Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29915901/1102-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service"
+"GeocodeManualYN": false
+"TotalActualRent": 2600
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-17T15:57:54.32Z"
+"ListAgentNationalAssociationId": "1378246"
+"ListOfficeNationalAssociationId": "1328652"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915901')"
+"ID": "1539053"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23394
+post_id: "1534320"
+post_author: 1
+"ListingKey": "29909864"
+"ListingId": "X13450338"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T20:05:07Z"
+"RFModificationTimestamp": "2026-06-16T20:29:58Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "112 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Experience contemporary living at Trend 3 Condo in the heart of Waterdown East. This beautifully maintained 2-bedroom corner suite offers a bright, open-concept layout designed for both comfort and functionality. Featuring luxury vinyl flooring throughout, the carpet-free interior is complemented by large windows that fill the space with natural light.The modern kitchen is equipped with stainless steel appliances and overlooks the spacious living and dining area, creating an ideal setting for everyday living and entertaining. Step outside to your private balcony and enjoy your own outdoor retreat. The unit also includes a full 4-piece bathroom, in-suite laundry, one parking space, and a storage locker for added convenience.Residents enjoy access to premium amenities, including a fitness centre, stylish party room, rooftop terraces with BBQ areas, bike storage, and visitor parking. Ideally located close to shopping, restaurants, parks, schools, and scenic trails, with quick access to Hwy 403, Hwy 6, and Hwy 407. A fantastic opportunity to enjoy low-maintenance living in one of Waterdown's most desirable condo communities. available as of August 15. * pictures are virtualy stages and when it was vacant. (id:62783)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T16:25:21.273119+00:00"
+"Directions": "Dundas/River Walk"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2028216"
+"ListOfficeKey": "293485"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-16T15:59:55Z"
+"PhotosCount": 10
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T19:56:17Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"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/29909864/112-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "FirstService Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 2450
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-16T15:59:55.24Z"
+"ListAgentNationalAssociationId": "1307458"
+"ListOfficeNationalAssociationId": "1427673"
+"Media": array:10 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909864')"
+"ID": "1534320"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25312
+post_id: "1525412"
+post_author: 1
+"ListingKey": "29895188"
+"ListingId": "X13436674"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T18:05:11Z"
+"RFModificationTimestamp": "2026-06-16T18:26:03Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "801 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.879544
1 => 43.343071
]
+"Latitude": 43.343071
+"Longitude": -79.879544
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful condo, +764 sqft with 1 bedroom, 1 large den, 1.5 bathroom, 2 parking spaces and 1 full size storage locker. Unit has an oversized den that could be utilized as office or second bedroom. Spacious and bright unit with 764 sq ft of living space featuring 9 feet ceilings for a luxurious feel. The suite features an open concept kitchen and living room with all new stainless steel appliances, a breakfast bar, in suite laundry, and a spacious and bright primary bedroom. This beautiful condo comes with a state of the art Geothermal Heating and Cooling system which keeps the hydro bills low! Enjoy all of the fabulous amenities that this building has to offer; including party rooms, modern fitness facilities, rooftop patios, and bike storage. Located just 5 min. to Downtown Burlington, the Aldershot GO Station, a great community with fabulous dining, shopping, schools, parks, easy access to highway but nestled amongst parks and nature, green space, and more. Don't miss this great opportunity. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Range"
4 => "Dryer"
5 => "Microwave"
6 => "Water Heater"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:48:42.690420+00:00"
+"Directions": "Waterdown Rd & Dundas St"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2055517"
+"ListOfficeKey": "283559"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Flat site"
1 => "Conservation/green belt"
2 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-12T15:30:32Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T17:58:59Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"Rooms": array:7 [
0 => array:11 [ …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/29895188/801-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1424001"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residentials"
+"CoListAgentKey2": "2073351"
+"CoListOfficeKey": "283559"
+"GeocodeManualYN": false
+"TotalActualRent": 2600
+"BuildingFeatures": array:6 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Recreation Centre"
3 => "Party Room"
4 => "Security/Concierge"
5 => "Visitor Parking"
]
+"CoListOfficeKey2": "283559"
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-12T15:30:31.96Z"
+"ListAgentNationalAssociationId": "1330795"
+"ListOfficeNationalAssociationId": "1331640"
+"CoListAgentNationalAssociationId": "1261055"
+"CoListAgentNationalAssociationId2": "1348519"
+"CoListOfficeNationalAssociationId": "1331640"
+"CoListOfficeNationalAssociationId2": "1331640"
+"Media": array:21 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895188')"
+"ID": "1525412"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25313
+post_id: "1522395"
+post_author: 1
+"ListingKey": "29893408"
+"ListingId": "X13435152"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T01:50:03Z"
+"RFModificationTimestamp": "2026-06-12T02:06:20Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H4"
+"UnparsedAddress": "617 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L0R2H4"
+"Coordinates": array:2 [
0 => -79.880553
1 => 43.342598
]
+"Latitude": 43.342598
+"Longitude": -79.880553
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "State of the Art Trend Condos. This unit boosts 792 sq. ft., one of the largest one bedroom plus den units available. Located on the 6th floor, this unit offers spacious, modern living with 1bedroom plus den ideal for a home office or additional bedroom. A fantastic open-concept layout featuring upgraded appliances, breakfast bar & sleek laminate flooring in the great room. The openness of the kitchen allows you to enjoy the bright living area, perfect for entertaining and viewing the great outdoors. An upgraded private balcony gives you unobstructed views. A generously sized bedroom with walk-in closet & a 4 piece bathroom finished with modern fixtures. Additional features include convenient in-unit laundry and a storage locker located on the same floor. Added bonus this unit comes with one designated underground & one surface parking spot very much high in demand.. Minutes away from local amenities, Hwy 403/407 making for an easier commute. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T02:06:15.192807+00:00"
+"Directions": "Cross Streets: Dundas St E & Mallard Trail. ** Directions: Dundas St E and Mallard Trail."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1995891"
+"ListOfficeKey": "268183"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-12T01:41:46Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T01:41:46Z"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"Rooms": array:1 [
0 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29893408/617-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 2350
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-12T01:41:46.22Z"
+"ListAgentNationalAssociationId": "1278700"
+"ListOfficeNationalAssociationId": "1230066"
+"Media": array:26 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29893408')"
+"ID": "1522395"
}
]
+success: true
+page_size: 9
+page_count: 5
+count: 45
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]