array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30044700 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23472
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23474
+post_id: "1633125"
+post_author: 1
+"ListingKey": "30044700"
+"ListingId": "X13574062"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-16T23:00:02Z"
+"RFModificationTimestamp": "2026-07-16T23:07:14Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A2"
+"UnparsedAddress": "86 VALLEY TRAIL PLACE, Hamilton (Waterdown), Ontario L8B2A2"
+"Coordinates": array:2 [
0 => -79.875966
1 => 43.344639
]
+"Latitude": 43.344639
+"Longitude": -79.875966
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Stunning, brand-new freehold 4-bedroom townhome backing onto a serene green space with a desirable walk-out basement in East Waterdown! The bright, open-concept main floor features 9ft ceilings, resilient vinyl flooring, an elegant oak staircase with iron pickets, and a versatile den perfect for an office or nanny suite, complete with a 3pc bath. The custom kitchen boasts stainless steel appliances, quartz countertops, and a walk-out to a private deck overlooking lush greenery.Upstairs, discover 4 spacious bedrooms and 4 full bathrooms (including 2 ensuites!), plus a convenient laundry room with upper cabinets. The primary retreat offers an oversized walk-in closet and a deluxe 5pc ensuite with double sinks, a soaker tub, and a massive glass shower. Move-in ready with ample storage and no rear neighbors! Minutes from highways, GO Stations, shopping, schools, and scenic trails. A rare opportunity in a highly sought-after locale! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:4 [
0 => "Unfinished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-16T23:02:10.662557+00:00"
+"Directions": "Mallard to Valley Trail"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1735614"
+"ListOfficeKey": "118891"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-16T21:25:09Z"
+"PhotosCount": 29
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-16T22:54:53Z"
+"Stories": "2.0"
+"StreetName": "Valley Trail"
+"StreetNumber": "86"
+"StreetSuffix": "Place"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/30044700/86-valley-trail-place-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1593651"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283413"
+"GeocodeManualYN": false
+"TotalActualRent": 4600
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-16T21:25:09.49Z"
+"ListAgentNationalAssociationId": "1177744"
+"ListOfficeNationalAssociationId": "1168927"
+"CoListAgentNationalAssociationId": "1155094"
+"CoListOfficeNationalAssociationId": "1328652"
+"Media": array:29 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30044700_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/afd6277acde95b11615b5e7b32934a49.webp"
"MediaSize" => 223022
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-afd6277acde95b11615b5e7b32934a49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30044700_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/0007540289e4190015e97e18e0bfe22c.webp"
"MediaSize" => 108817
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-0007540289e4190015e97e18e0bfe22c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office, Den, Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30044700_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/9d4ffd190116654260499fe6dbc5ebd0.webp"
"MediaSize" => 103516
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-9d4ffd190116654260499fe6dbc5ebd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office/ Den/ Nanny Suite"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30044700_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/53bb4c2b30073f214ed161b1f38d2aaa.webp"
"MediaSize" => 109042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-53bb4c2b30073f214ed161b1f38d2aaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "3PC Main Floor Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30044700_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/9beae52ed326db7e099ca7004083c43c.webp"
"MediaSize" => 192313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-9beae52ed326db7e099ca7004083c43c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Massive Great Room and Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30044700_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/42ab6eed9274c81c13e90a79e052c7c5.webp"
"MediaSize" => 188298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-42ab6eed9274c81c13e90a79e052c7c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30044700_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/41d6ae798aec713ee0501cb6964cabef.webp"
"MediaSize" => 108513
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-41d6ae798aec713ee0501cb6964cabef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Massive Great Room and Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30044700_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/58c41ea905c3443443852af042207a0b.webp"
"MediaSize" => 230709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-58c41ea905c3443443852af042207a0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Private green space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30044700_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/a1a6603fe4017c6bef96bcf73a271b88.webp"
"MediaSize" => 261965
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-a1a6603fe4017c6bef96bcf73a271b88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Private green space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30044700_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/4c68f82fcd5f96dbdae328ad03087e22.webp"
"MediaSize" => 124767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-4c68f82fcd5f96dbdae328ad03087e22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30044700_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/39a4013f8fd51e6281b6af6e7cfe7725.webp"
"MediaSize" => 114617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-39a4013f8fd51e6281b6af6e7cfe7725.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30044700_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/3c3077fe8a18409ec3a40c67f4a5e16b.webp"
"MediaSize" => 110173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-3c3077fe8a18409ec3a40c67f4a5e16b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30044700_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/21d813d1d6cf43187cf7400f2a417535.webp"
"MediaSize" => 108328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-21d813d1d6cf43187cf7400f2a417535.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30044700_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/687405d414020fdb52e17e40d2c07c1f.webp"
"MediaSize" => 133461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-687405d414020fdb52e17e40d2c07c1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30044700_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/dcc5c39e9e94e642e8b8c1fb78b752f6.webp"
"MediaSize" => 108667
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-dcc5c39e9e94e642e8b8c1fb78b752f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30044700_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/687c4d3bb27fa26a98859fb618b805aa.webp"
"MediaSize" => 103833
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-687c4d3bb27fa26a98859fb618b805aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Massive walk in closet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30044700_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/1293f21f5e054cf74e953a861671ad25.webp"
"MediaSize" => 157567
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-1293f21f5e054cf74e953a861671ad25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "5 PC Primary Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30044700_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/4fa069014d5349892bac853d76126717.webp"
"MediaSize" => 98054
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-4fa069014d5349892bac853d76126717.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "5 PC Primary Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30044700_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/ba06329686fce22b01cb6213fd3b6734.webp"
"MediaSize" => 196603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-ba06329686fce22b01cb6213fd3b6734.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30044700_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/dab7f4f7fd8dba1d1548fd0083a0e7f5.webp"
"MediaSize" => 100036
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-dab7f4f7fd8dba1d1548fd0083a0e7f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30044700_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/ec8cfc1034d7e3dfaf289007eb4efb3e.webp"
"MediaSize" => 121304
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-ec8cfc1034d7e3dfaf289007eb4efb3e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30044700_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/df19be8a74612fb270ba10db24e9267a.webp"
"MediaSize" => 108211
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-df19be8a74612fb270ba10db24e9267a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30044700_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/2d7c018b252b65ad74215875c0a1d389.webp"
"MediaSize" => 74523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-2d7c018b252b65ad74215875c0a1d389.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30044700_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/aa8b6e902ad997ef73d784dae2d2deb0.webp"
"MediaSize" => 101300
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-aa8b6e902ad997ef73d784dae2d2deb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30044700_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/597f5b1b01a05b277bd97ffcfe857e4c.webp"
"MediaSize" => 101684
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-597f5b1b01a05b277bd97ffcfe857e4c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "2nd Ensuite Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30044700_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/8187ba8542cf396143ac8a86b0439250.webp"
"MediaSize" => 153707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-8187ba8542cf396143ac8a86b0439250.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30044700_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/f2b5f4ff286b133d1428377640d5395e.webp"
"MediaSize" => 346687
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-f2b5f4ff286b133d1428377640d5395e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30044700_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/67bcffffb407d43e6668eee5ab0e615f.webp"
"MediaSize" => 299244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-67bcffffb407d43e6668eee5ab0e615f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30044700_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044700/a59742637f51080e3ca9180f20d6920b.webp"
"MediaSize" => 454178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044700/thumbnail-a59742637f51080e3ca9180f20d6920b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Private green space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13574062"
"ResourceRecordKey" => "30044700"
"ModificationTimestamp" => "2026-07-16T21:25:09.5Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30044700')"
+"ID": "1633125"
}
]
+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=OfficeKey eq 118891" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24968
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24912
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage Real Estate Services Ltd., Brokerage"
+"OfficeEmail": null
+"OfficePhone": "905-257-3633"
+"OfficeMlsId": "540509"
+"ModificationTimestamp": "2025-01-12T14:03:26Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "118891"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "231 OAK PARK BLVD - UNIT 400"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "OAKVILLE"
+"OfficePostalCode": "L6H7S"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Oakville-Milton"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1168927"
+"OriginalEntryTimestamp": null
+"OfficeFax": "905-257-3550"
+"OfficeAORKey": "15"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "261790"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "118891"
"SocialMediaUrlOrId" => "http://www.royallepageoakpark.ca/"
"ModificationTimestamp" => "2024-12-03T17:15:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1447911"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('118891')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1735614" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24922
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30044700'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25257
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30044700' AND OpenHouseDate ge '2026-07-17'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25273
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30044700' 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.875966 43.344639)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25326
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25320
+post_id: "1637941"
+post_author: 1
+"ListingKey": "30037909"
+"ListingId": "40848532"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:15:10Z"
+"RFModificationTimestamp": "2026-07-17T23:31:15Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 675.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "470 DUNDAS Street E Unit# 1107, Hamilton, Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.8786496
1 => 43.3440079
]
+"Latitude": 43.3440079
+"Longitude": -79.8786496
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Trend Living in the heart of Waterdown! This bright and modern 1-bedroom + den, 1-bathroom suite offers 675 sq. ft. of thoughtfully designed living space on the 11th floor, showcasing beautiful east-facing views and an abundance of natural light. The open-concept layout features wide-plank flooring, a contemporary kitchen with quartz countertops, stainless steel appliances, ample cabinetry, and a breakfast bar. The versatile den is perfect for a home office, reading nook, or guest space, while the generous bedroom offers large windows and plenty of closet space. Enjoy the convenience of in-suite laundry, modern finishes throughout, and a stylish 4-piece bathroom. Located in one of Waterdown's most desirable condominium communities, Trend offers exceptional access to everyday amenities. Walk to shopping, restaurants, cafes, parks, and trails, with Aldershot GO Station just minutes away for an easy commute to Toronto. Quick access to Highways 403, 407, QEW, and Highway 6 makes getting around the Golden Horseshoe effortless. Nearby attractions include the Bruce Trail, Smokey Hollow Falls, Memorial Park, and vibrant downtown Waterdown, with Burlington, Hamilton, and McMaster University all within a short drive. An ideal opportunity for professionals or couples seeking a stylish, low-maintenance lifestyle in a thriving community. Move in and enjoy everything Waterdown has to offer! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Microwave Built-in"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-07-17T23:31:08.310155+00:00"
+"Directions": "Dundas to Mallard, Mallard to Riverwalk."
+"ExteriorFeatures": array:2 [
0 => "Stucco"
1 => "Hardboard"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2005051"
+"ListOfficeKey": "284634"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-15T19:28:50Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:09:06Z"
+"Stories": "12.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1686992403"
"RoomType" => "4pc Bathroom"
"ListingId" => "40848532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30037909"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:06.36Z"
]
1 => array:11 [
"RoomKey" => "1686992404"
"RoomType" => "Den"
"ListingId" => "40848532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30037909"
"RoomLength" => null
"RoomDimensions" => "7'7'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:06.36Z"
]
2 => array:11 [
"RoomKey" => "1686992405"
"RoomType" => "Kitchen"
"ListingId" => "40848532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30037909"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:06.36Z"
]
3 => array:11 [
"RoomKey" => "1686992406"
"RoomType" => "Bedroom"
"ListingId" => "40848532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30037909"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:06.36Z"
]
4 => array:11 [
"RoomKey" => "1686992407"
"RoomType" => "Living room"
"ListingId" => "40848532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30037909"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 17'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:06.36Z"
]
5 => array:11 [
"RoomKey" => "1686992408"
"RoomType" => "Laundry room"
"ListingId" => "40848532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30037909"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:06.36Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30037909/470-dundas-street-e-unit-1107-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2200
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 675
+"OriginalEntryTimestamp": "2026-07-15T19:28:50.46Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1287441"
+"ListOfficeNationalAssociationId": "1344654"
+"Media": array:22 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30037909_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037909/b2bac7dcc9cfc6ccc5c9753a0b6c87a7.webp"
"MediaSize" => 131366
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037909/thumbnail-b2bac7dcc9cfc6ccc5c9753a0b6c87a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40848532"
"ResourceRecordKey" => "30037909"
"ModificationTimestamp" => "2026-07-15T19:28:50.47Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30037909_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037909/18cd370b3eace95eccfa01685e06cde2.webp"
"MediaSize" => 128335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037909/thumbnail-18cd370b3eace95eccfa01685e06cde2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern multi-story residential complex featuring expansive glass facades and private balconies"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848532"
"ResourceRecordKey" => "30037909"
"ModificationTimestamp" => "2026-07-15T19:28:50.47Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30037909_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037909/c094305f3cb1d1403ee90122902c173a.webp"
"MediaSize" => 113400
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037909/thumbnail-c094305f3cb1d1403ee90122902c173a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848532"
"ResourceRecordKey" => "30037909"
"ModificationTimestamp" => "2026-07-15T19:28:50.47Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30037909_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037909/9283ef8a61a3bfd8090fd80a12ca8c59.webp"
"MediaSize" => 98194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037909/thumbnail-9283ef8a61a3bfd8090fd80a12ca8c59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern entryway featuring sleek wood-finish paneling, a linear fireplace, and a contemporary chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848532"
"ResourceRecordKey" => "30037909"
"ModificationTimestamp" => "2026-07-15T19:28:50.47Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30037909_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037909/4a80129e13b24d8c6fe1468c138d6022.webp"
"MediaSize" => 69753
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037909/thumbnail-4a80129e13b24d8c6fe1468c138d6022.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious common area featuring wood-finish flooring, recessed lighting, and large glass entry doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848532"
"ResourceRecordKey" => "30037909"
"ModificationTimestamp" => "2026-07-15T19:28:50.47Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30037909_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037909/bb74935723f5c9161af3ee4e0e2f26ec.webp"
"MediaSize" => 36425
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037909/thumbnail-bb74935723f5c9161af3ee4e0e2f26ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848532"
"ResourceRecordKey" => "30037909"
"ModificationTimestamp" => "2026-07-15T19:28:50.47Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30037909_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037909/61663fd2270368b79db3d5ef2ffe526f.webp"
"MediaSize" => 33525
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037909/thumbnail-61663fd2270368b79db3d5ef2ffe526f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848532"
"ResourceRecordKey" => "30037909"
"ModificationTimestamp" => "2026-07-15T19:28:50.47Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30037909_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037909/84fd791036e989a07f8a623953b84868.webp"
"MediaSize" => 27762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037909/thumbnail-84fd791036e989a07f8a623953b84868.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry area featuring a white stackable washer and dryer unit, light wood-finish flooring, white walls, and white baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848532"
"ResourceRecordKey" => "30037909"
"ModificationTimestamp" => "2026-07-15T19:28:50.47Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30037909_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037909/516e2c0449caf9048d216bee81522431.webp"
"MediaSize" => 50073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037909/thumbnail-516e2c0449caf9048d216bee81522431.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring wood-finish flooring throughout, a modern kitchen island with an integrated sink and dishwasher, stainless steel appliances, and a floor-to-ceiling sliding glass doo"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848532"
"ResourceRecordKey" => "30037909"
"ModificationTimestamp" => "2026-07-15T19:28:50.47Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30037909_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037909/d62ff580e263350cc9669014977af8a4.webp"
"MediaSize" => 39802
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037909/thumbnail-d62ff580e263350cc9669014977af8a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring an island with a built-in sink, stainless steel appliances, white cabinetry, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848532"
"ResourceRecordKey" => "30037909"
"ModificationTimestamp" => "2026-07-15T19:28:50.47Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30037909_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037909/85e0f62b6be88c84388b086a89c8f4d1.webp"
"MediaSize" => 50767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037909/thumbnail-85e0f62b6be88c84388b086a89c8f4d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area with wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848532"
"ResourceRecordKey" => "30037909"
"ModificationTimestamp" => "2026-07-15T19:28:50.47Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30037909_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037909/7bcaea85d4610d79ff51f6b837f14507.webp"
"MediaSize" => 39490
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037909/thumbnail-7bcaea85d4610d79ff51f6b837f14507.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space with wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848532"
"ResourceRecordKey" => "30037909"
"ModificationTimestamp" => "2026-07-15T19:28:50.47Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30037909_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037909/df99ced97c259a984a558418c422cc80.webp"
"MediaSize" => 43323
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037909/thumbnail-df99ced97c259a984a558418c422cc80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen corner featuring stainless steel appliances including a range and microwave"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848532"
"ResourceRecordKey" => "30037909"
"ModificationTimestamp" => "2026-07-15T19:28:50.47Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30037909_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037909/802af96f8aeff6f5d7439f4f7ba86bf2.webp"
"MediaSize" => 44194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037909/thumbnail-802af96f8aeff6f5d7439f4f7ba86bf2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, light countertops, wood-finish flooring, stainless steel appliances, and a double basin sink with a high-arch faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848532"
"ResourceRecordKey" => "30037909"
"ModificationTimestamp" => "2026-07-15T19:28:50.47Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30037909_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037909/48912c10df219b55dfa34ce56146cdf1.webp"
"MediaSize" => 49315
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037909/thumbnail-48912c10df219b55dfa34ce56146cdf1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious interior with contemporary wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848532"
"ResourceRecordKey" => "30037909"
"ModificationTimestamp" => "2026-07-15T19:28:50.47Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30037909_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037909/29f1ecdea22e45fcf04c43bfaae4e77d.webp"
"MediaSize" => 35850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037909/thumbnail-29f1ecdea22e45fcf04c43bfaae4e77d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary bathroom featuring a light blue vanity with a white countertop, a rectangular mirror with overhead vanity lighting, a white bathtub with subway tile surround, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848532"
"ResourceRecordKey" => "30037909"
"ModificationTimestamp" => "2026-07-15T19:28:50.47Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30037909_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037909/86964d0b576e7fdc07edf8581ce5c1be.webp"
"MediaSize" => 47051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037909/thumbnail-86964d0b576e7fdc07edf8581ce5c1be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848532"
"ResourceRecordKey" => "30037909"
"ModificationTimestamp" => "2026-07-15T19:28:50.47Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30037909_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037909/ff6517b695f305c9bf9dc570cbe444d9.webp"
"MediaSize" => 50724
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037909/thumbnail-ff6517b695f305c9bf9dc570cbe444d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room with wood-finish flooring, white baseboards, and a sliding glass door to a balcony"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848532"
"ResourceRecordKey" => "30037909"
"ModificationTimestamp" => "2026-07-15T19:28:50.47Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30037909_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037909/2221775b5aa5d29d4cd62ed806225828.webp"
"MediaSize" => 88094
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037909/thumbnail-2221775b5aa5d29d4cd62ed806225828.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Balcony"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848532"
"ResourceRecordKey" => "30037909"
"ModificationTimestamp" => "2026-07-15T19:28:50.47Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30037909_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037909/eb3d9263ad20190175b5ada434f87687.webp"
"MediaSize" => 86110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037909/thumbnail-eb3d9263ad20190175b5ada434f87687.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Private balcony featuring a concrete surface and contemporary glass railing with black framing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848532"
"ResourceRecordKey" => "30037909"
"ModificationTimestamp" => "2026-07-15T19:28:50.47Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30037909_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037909/a32728cbf422c21537949b60937f7e1e.webp"
"MediaSize" => 81841
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037909/thumbnail-a32728cbf422c21537949b60937f7e1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Balcony"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848532"
"ResourceRecordKey" => "30037909"
"ModificationTimestamp" => "2026-07-15T19:28:50.47Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30037909_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037909/986e1ef818f16c7d5174c923e84954b4.webp"
"MediaSize" => 41924
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037909/thumbnail-986e1ef818f16c7d5174c923e84954b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary interior featuring wood-finish flooring, white walls, and a sliding closet door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848532"
"ResourceRecordKey" => "30037909"
"ModificationTimestamp" => "2026-07-15T19:28:50.47Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30037909')"
+"ID": "1637941"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25322
+post_id: "1637741"
+post_author: 1
+"ListingKey": "30050633"
+"ListingId": "X13579202"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T22:15:09Z"
+"RFModificationTimestamp": "2026-07-17T22:35:17Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H8"
+"UnparsedAddress": "519 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L0R2H8"
+"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": "Stylishly upgraded, and move-in ready! Welcome to this exceptional 1+Den condo by New Horizon Development Group in the highly sought-after Trend 3 building. Offering 638 sq. ft. of beautifully finished living space, this suite perfectly blends modern design with everyday comfort- ideal for single professionals, young couples, or retired couple looking for low maintenance living. The modern kitchen is both elegant and timeless, showcasing quartz countertops, stylish cabinetry, upgraded hardware, and a full suite of upgraded Whirlpool appliances, including a versatile range with microwave and cooktop. The open-concept living area is complemented by sleek, neutral vinyl plank flooring throughout, creating a warm and contemporary feel. The generous primary bedroom is paired with a versatile den-ideal for a home office or guest space-and a well-appointed 4-piece bath. Enjoy the comfort and efficiency of geothermal heating and cooling year-round. This unit also includes one exclusively owned locker and one underground parking space for added convenience. Residents can enjoy the fantastic amenities, including a fully equipped gym on the main level and a beautifully designed terrace on the same floor-complete with seating areas, BBQs, and scenic views. Whether you're relaxing with a book, hosting summer get-togethers, or enjoying a quiet evening meal, this space is the perfect extension of your home. Ideally located within walking distance to downtown Waterdown, offering easy access to grocery stores, restaurants, and everyday amenities, and just minutes to the GO for effortless commuting. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Whirlpool"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Dryer"
7 => "Microwave"
8 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T22:35:09.289069+00:00"
+"Directions": "Cross Streets: East on Dundas St E Right on Mallard Tr. ** Directions: Southwest of Brant, South Side of Dundas St E."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2236089"
+"ListOfficeKey": "293485"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-17T22:09:38Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T22:09:38Z"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1687108663"
"RoomType" => "Kitchen"
"ListingId" => "X13579202"
"RoomLevel" => "Main level"
"RoomWidth" => 2.31
"ListingKey" => "30050633"
"RoomLength" => 2.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T22:09:38.89Z"
]
1 => array:11 [
"RoomKey" => "1687108664"
"RoomType" => "Great room"
"ListingId" => "X13579202"
"RoomLevel" => "Main level"
"RoomWidth" => 3.15
"ListingKey" => "30050633"
"RoomLength" => 5.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T22:09:38.89Z"
]
2 => array:11 [
"RoomKey" => "1687108665"
"RoomType" => "Bedroom"
"ListingId" => "X13579202"
"RoomLevel" => "Main level"
"RoomWidth" => 2.92
"ListingKey" => "30050633"
"RoomLength" => 3.4
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T22:09:38.89Z"
]
3 => array:11 [
"RoomKey" => "1687108666"
"RoomType" => "Bedroom"
"ListingId" => "X13579202"
"RoomLevel" => "Main level"
"RoomWidth" => 2.01
"ListingKey" => "30050633"
"RoomLength" => 2.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T22:09:38.89Z"
]
4 => array:11 [
"RoomKey" => "1687108667"
"RoomType" => "Laundry room"
"ListingId" => "X13579202"
"RoomLevel" => "Main level"
"RoomWidth" => 1.34
"ListingKey" => "30050633"
"RoomLength" => 1.23
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T22:09:38.89Z"
]
5 => array:11 [
"RoomKey" => "1687108668"
"RoomType" => "Bathroom"
"ListingId" => "X13579202"
"RoomLevel" => "Main level"
"RoomWidth" => 1.23
"ListingKey" => "30050633"
"RoomLength" => 1.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T22:09:38.89Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30050633/519-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:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-17T22:09:38.87Z"
+"ListAgentNationalAssociationId": "1474228"
+"ListOfficeNationalAssociationId": "1427673"
+"Media": array:43 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30050633_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/7befca9691afc72ad6c83985becedf48.webp"
"MediaSize" => 167333
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-7befca9691afc72ad6c83985becedf48.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30050633_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/56c7ac8eb543fbd77a064365d662cdb8.webp"
"MediaSize" => 208855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-56c7ac8eb543fbd77a064365d662cdb8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30050633_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/c1e1bb32c3c3d353f798717184d87d6e.webp"
"MediaSize" => 219110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-c1e1bb32c3c3d353f798717184d87d6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30050633_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/93ea377daf147f03c171fcdc97a3f34c.webp"
"MediaSize" => 106074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-93ea377daf147f03c171fcdc97a3f34c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30050633_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/9fc894e7e413526eae9624d6f90262a7.webp"
"MediaSize" => 147158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-9fc894e7e413526eae9624d6f90262a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30050633_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/d395aa9b28e5dfc8c230baecffed3d08.webp"
"MediaSize" => 141943
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-d395aa9b28e5dfc8c230baecffed3d08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30050633_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/40a3d1a5dd07472dcfd86ffcf1d99074.webp"
"MediaSize" => 124993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-40a3d1a5dd07472dcfd86ffcf1d99074.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30050633_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/ee902ed41d21fdaf058d7fda217ee928.webp"
"MediaSize" => 155374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-ee902ed41d21fdaf058d7fda217ee928.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30050633_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/aa34d47af735722e0db70d8a28b3eddd.webp"
"MediaSize" => 176462
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-aa34d47af735722e0db70d8a28b3eddd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30050633_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/e1c64bafef6aa007eaaea022b029303c.webp"
"MediaSize" => 213478
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-e1c64bafef6aa007eaaea022b029303c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30050633_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/203f67280ff7f9ddb1c341c75f7da69d.webp"
"MediaSize" => 167903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-203f67280ff7f9ddb1c341c75f7da69d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30050633_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/b8d41d8901973d45579efa0a7fc9d1ac.webp"
"MediaSize" => 148326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-b8d41d8901973d45579efa0a7fc9d1ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30050633_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/3e3ea6ec156ab47719069344b395f4d7.webp"
"MediaSize" => 134533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-3e3ea6ec156ab47719069344b395f4d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30050633_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/1c864334459eeebb5575d11d11036588.webp"
"MediaSize" => 121530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-1c864334459eeebb5575d11d11036588.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30050633_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/faee7a19b03d4d73053b1611285e2cdb.webp"
"MediaSize" => 152938
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-faee7a19b03d4d73053b1611285e2cdb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30050633_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/07dbfa9269bbd0b19cafb979269d6a34.webp"
"MediaSize" => 121450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-07dbfa9269bbd0b19cafb979269d6a34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30050633_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/41de3191a72be3e9670646920afc6b93.webp"
"MediaSize" => 126650
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-41de3191a72be3e9670646920afc6b93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30050633_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/85e39c97c1a980bfe9ad2bb7c5890b80.webp"
"MediaSize" => 135057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-85e39c97c1a980bfe9ad2bb7c5890b80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30050633_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/b0dd2bf6a16c0bee2155ad2bb5620d26.webp"
"MediaSize" => 228327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-b0dd2bf6a16c0bee2155ad2bb5620d26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30050633_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/54d35de8b830f31c371b114fac0c7dca.webp"
"MediaSize" => 104300
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-54d35de8b830f31c371b114fac0c7dca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30050633_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/b044eb4eb76580592e134ab20330b999.webp"
"MediaSize" => 247279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-b044eb4eb76580592e134ab20330b999.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30050633_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/89b73a9d7087018076e2d36e2800b820.webp"
"MediaSize" => 208972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-89b73a9d7087018076e2d36e2800b820.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30050633_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/d8f92eabc9881044a1ca062c4b3ed8cc.webp"
"MediaSize" => 233562
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-d8f92eabc9881044a1ca062c4b3ed8cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30050633_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/7b8c722de6b1bf227441b5ca8438dcde.webp"
"MediaSize" => 227893
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-7b8c722de6b1bf227441b5ca8438dcde.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30050633_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/63c5460cfcb57d9e752a3f8b702edb60.webp"
"MediaSize" => 239506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-63c5460cfcb57d9e752a3f8b702edb60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
"ResourceRecordKey" => "30050633"
"ModificationTimestamp" => "2026-07-17T22:09:38.87Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30050633_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050633/5a66227e0abe853fc4fe515e88b7b465.webp"
"MediaSize" => 168976
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050633/thumbnail-5a66227e0abe853fc4fe515e88b7b465.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579202"
…2
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30050633')"
+"ID": "1637741"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25319
+post_id: "1637001"
+post_author: 1
+"ListingKey": "30038367"
+"ListingId": "40848568"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:20:08Z"
+"RFModificationTimestamp": "2026-07-17T20:39:13Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 795.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A9"
+"UnparsedAddress": "237 BURKE Street, Waterdown, Ontario L8B2A9"
+"Coordinates": array:2 [
0 => -79.8789674
1 => 43.3367843
]
+"Latitude": 43.3367843
+"Longitude": -79.8789674
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning 1-bedroom plus den, 1-bath stacked townhome in the highly sought-after Waterdown community! This bright, modern unit offers 795 sq. ft. of thoughtfully designed living space, featuring an open-concept layout, large windows that fill the home with natural light, and quality finishes throughout. The stylish kitchen showcases quartz countertops, a subway tile backsplash, stainless steel appliances, sleek cabinetry with black hardware, a spacious island with breakfast seating, and contemporary pendant lighting, making it ideal for everyday living and entertaining. Vinyl plank flooring flows throughout the home, complemented by pot lights, quality Moen plumbing fixtures, and more. The spacious bedroom is accompanied by a versatile den, perfect for a home office, and a beautifully finished 4-piece bath. Additional features include in-suite laundry, a garage EV charger, and one parking space. Located in one of Waterdown's most desirable communities, this home offers modern, low-maintenance living close to parks, shopping, restaurants, schools, and major highways. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Exterior Maintenance"
1 => "Landscaping"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:39:05.480148+00:00"
+"Directions": "Dundas St E. to Burke St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007461"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-07-15T22:02:49Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:09:03Z"
+"Stories": "1.0"
+"StreetName": "BURKE"
+"StreetNumber": "237"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30038367/237-burke-street-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2350
+"ZoningDescription": "R6-30"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 795
+"OriginalEntryTimestamp": "2026-07-15T20:18:24.63Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1289513"
+"ListOfficeNationalAssociationId": "1344653"
+"Media": array:23 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30038367')"
+"ID": "1637001"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25323
+post_id: "1629173"
+post_author: 1
+"ListingKey": "30038553"
+"ListingId": "X13568440"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T20:45:06Z"
+"RFModificationTimestamp": "2026-07-15T23:23:33Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "1107 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Trend Living in the heart of Waterdown! This bright and modern 1-bedroom + den,1-bathroom suite offers 675 sq. ft. of thoughtfully designed living space on the 11th floor,showcasing beautiful east-facing views and an abundance of natural light. The open-concept layout features wide-plank flooring, a contemporary kitchen with quartz countertops, stainless steel appliances, ample cabinetry, and a breakfast bar. The versatile den is perfect for a home office, reading nook, or guest space, while the generous bedroom offers large windows and plenty of closet space. Enjoy the convenience of in-suite laundry, modern finishes throughout,and a stylish 4-piece bathroom. Located in one of Waterdown's most desirable condominium communities, Trend offers exceptional access to everyday amenities. Walk to shopping,restaurants, cafes, parks, and trails, with Aldershot GO Station just minutes away for an easy commute to Toronto. Quick access to Highways 403, 407, QEW, and Highway 6 makes getting around the GTA effortless. Nearby attractions include the Bruce Trail, Smokey Hollow Falls, Memorial Park, and vibrant downtown Waterdown, with Burlington, Hamilton, and McMaster University all within a short drive. An ideal opportunity for professionals or couples seeking a stylish,low-maintenance lifestyle in a thriving community. Move in and enjoy everything Waterdown has to offer! (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T23:23:30.840267+00:00"
+"Directions": "Cross Streets: DUNDAS AND MALLARD. ** Directions: Dundas to Mallard, Mallard to Riverwalk."
+"ExteriorFeatures": array:2 [
0 => "Stucco"
1 => "Hardboard"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2128241"
+"ListOfficeKey": "284773"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-15T20:39:45Z"
+"PhotosCount": 22
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T20:39:45Z"
+"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/30038553/1107-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 2200
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-15T20:39:45.36Z"
+"ListAgentNationalAssociationId": "1381390"
+"ListOfficeNationalAssociationId": "1344627"
+"Media": array:22 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30038553')"
+"ID": "1629173"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25321
+post_id: "1625084"
+post_author: 1
+"ListingKey": "30032431"
+"ListingId": "X13562892"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T01:15:05Z"
+"RFModificationTimestamp": "2026-07-15T01:19:47Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "715 - 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": "Discover luxury living at its finest in this brand new 1 bed, PLUS DEN suite at the coveted TREND 3 in Waterdown! Built by the award-winning New Horizon Group, this 792 sq ft gem offers an open concept design flooded with natural light with walkout to a large double width balcony. Every detail has been meticulously upgraded, including the smooth ceilings, upgraded trim work, the designer kitchen featuring pristine white cabinets, stainless steel appliances, quartz countertops, and a convenient breakfast bar with 2 custom pendant lights. The bedroom is a bright retreat with a walk in closet. The bathroom is complete with a quartz countertop, tile and a glass insert at the tub. This suite offers efficient geothermal heating/cooling for year-round comfort. Plus, enjoy the ultimate in convenience with 2 PARKING SPOTS, a locker unit, and a host of on-site amenities, including a fully equipped gym, rooftop terrace, and party room. The location couldn't be more ideal, with easy access to highways, the Go Station, shopping, schools, and parks. This is your chance to experience the pinnacle of contemporary living in Waterdown. Don't miss out on this remarkable opportunity! (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 not Allowed"
]
+"CreationDate": "2026-07-14T23:40:11.415912+00:00"
+"Directions": "Dundas & Mallard Trail"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2058183"
+"ListOfficeKey": "269020"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-14T19:38:24Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T01:08:24Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"View": "View"
+"VirtualTourURLUnbranded": "https://drive.google.com/file/d/12qbFrQhL7OY1pAXXUWzJ40DkNvZZ_zL8/view?usp=drivesdk"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30032431/715-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2110073"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"CoListOfficeKey": "269020"
+"GeocodeManualYN": false
+"TotalActualRent": 2350
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-14T19:38:24.55Z"
+"ListAgentNationalAssociationId": "1333377"
+"ListOfficeNationalAssociationId": "1231482"
+"CoListAgentNationalAssociationId": "1378701"
+"CoListOfficeNationalAssociationId": "1231482"
+"Media": array:20 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30032431')"
+"ID": "1625084"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25316
+post_id: "1623940"
+post_author: 1
+"ListingKey": "30032146"
+"ListingId": "40847826"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T00:50:01Z"
+"RFModificationTimestamp": "2026-07-15T00:54:10Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 792.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "470 DUNDAS Street Unit# 715, Waterdown, Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.8787733
1 => 43.3435573
]
+"Latitude": 43.3435573
+"Longitude": -79.8787733
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover luxury living at its finest in this brand new 1 bed, PLUS DEN suite at the coveted TREND 3 in Waterdown! Built by the award-winning New Horizon Group, this 792 sq ft gem offers an open concept design flooded with natural light with walkout to a large double width balcony. Every detail has been meticulously upgraded, including the smooth ceilings, upgraded trim work, the designer kitchen featuring pristine white cabinets, stainless steel appliances, quartz countertops, and a convenient breakfast bar with 2 custom pendant lights. The bedroom is a bright retreat with a walk in closet. The bathroom is complete with a quartz countertop, tile and a glass insert at the tub. This suite offers efficient geothermal heating/cooling for year-round comfort. Plus, enjoy the ultimate in convenience with 2 PARKING SPOTS, a locker unit, and a host of on-site amenities, including a fully equipped gym, rooftop terrace, and party room. The location couldn't be more ideal, with easy access to highways, the Go Station, shopping, schools, and parks. This is your chance to experience the pinnacle of contemporary living in Waterdown. Don't miss out on this remarkable opportunity! (id:62650)"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-14T19:50:19.098752+00:00"
+"Directions": "Dundas St E & Mallard Trail"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1585114"
+"ListOfficeKey": "283099"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "No Pet Home"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-07-15T00:41:36Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T00:48:06Z"
+"Stories": "1.0"
+"StreetName": "DUNDAS"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"VirtualTourURLUnbranded": "https://drive.google.com/file/d/12qbFrQhL7OY1pAXXUWzJ40DkNvZZ_zL8/view?usp=drivesdk"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30032146/470-dundas-street-unit-715-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2080080"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "283099"
+"GeocodeManualYN": true
+"TotalActualRent": 2350
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 792
+"OriginalEntryTimestamp": "2026-07-14T18:59:40.83Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1152418"
+"ListOfficeNationalAssociationId": "1324631"
+"CoListAgentNationalAssociationId": "1354911"
+"CoListOfficeNationalAssociationId": "1324631"
+"Media": array:20 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30032146')"
+"ID": "1623940"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "1620799"
+post_author: 1
+"ListingKey": "30026989"
+"ListingId": "X13557830"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T22:15:17Z"
+"RFModificationTimestamp": "2026-07-13T22:20:43Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Y1"
+"UnparsedAddress": "41 WESTFIELD CRESCENT, Hamilton (Waterdown), Ontario L8B1Y1"
+"Coordinates": array:2 [
0 => -79.880033
1 => 43.33686
]
+"Latitude": 43.33686
+"Longitude": -79.880033
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Client RemarksThis is your opportunity to lease a nearly 'New' oversized and upgraded home nestled in the heart of friendly and beautiful Waterdown! The premium corner lot on a crescent offers two-car parking, a full-size backyard with a large deck, and plenty of green space. The large windows provide unobstructed views of greenery and trees, filling the house with sunshine throughout the year. The large open-concept floor plan provides the space, comfort, and convenience the modern family is looking for. The main floor also features a den that can be used as an office, living space or a 5th bedroom. Upstairs, you'll find four good-sized bedrooms, including the primary with a walk-in closet and ensuite, a junior suite with a second ensuite, a third bedroom with 12+ ft ceiling and a fourth bedroom that is adjacent to the third full three-piece bathroom! The laundry room is also conveniently situated upstairs adjacent to a large open space that can be used as a second living room / TV room! The quiet, family-oriented neighbourhood is close to major highways (QEW, 403, 407) and minutes away from the Aldershot GO station. With modern finishes and high ceilings throughout the house, this beautiful home is ready for you to call your own! Pictures are from previous listing. Property vacant now. (id:62650)"
+"Appliances": array:1 [
0 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T22:20:37.556928+00:00"
+"Directions": "Cross Streets: Burke and Kenesky Dr. ** Directions: Dundas and Burke Street."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1681786"
+"ListOfficeKey": "285001"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "33 x 90.4 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T19:58:40Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T22:09:34Z"
+"Stories": "2.0"
+"StreetName": "Westfield"
+"StreetNumber": "41"
+"StreetSuffix": "Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30026989/41-westfield-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3800
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 33.0
+"OriginalEntryTimestamp": "2026-07-13T19:40:03.34Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1172729"
+"ListOfficeNationalAssociationId": "1346507"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30026989')"
+"ID": "1620799"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25324
+post_id: "1620460"
+post_author: 1
+"ListingKey": "30025680"
+"ListingId": "X13556850"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T16:50:07Z"
+"RFModificationTimestamp": "2026-07-13T19:35:10Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H4"
+"UnparsedAddress": "409 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L0R2H4"
+"Coordinates": array:2 [
0 => -79.880553
1 => 43.342598
]
+"Latitude": 43.342598
+"Longitude": -79.880553
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Trend Living in the heart of Waterdown, where modern luxury meets everyday convenience. This brand-new 1-bedroom, 1-bathroom condominium offers a thoughtfully designed open-concept layout with premium finishes and contemporary style throughout, making it the perfect opportunity for first-time buyers, professionals, downsizers, or investors. Step inside to discover an elegant interior featuring quartz countertops throughout, upgraded tile and trim packages, stainless steel appliances, in-suite laundry, and quality finishes that provide both comfort and sophistication. Complete with a dedicated parking space and private storage locker, this unit offers everything you need for easy, low-maintenance living. Residents of Trend Living enjoy an exceptional collection of amenities, including stunning rooftop terraces with BBQ areas, stylish party rooms, fully equipped fitness facilities, and inviting social spaces designed to complement your lifestyle. Perfectly situated close to schools, parks, shopping, restaurants, and everyday amenities, with quick access to major highways for an easy commute, this location offers the ideal balance of urban convenience and small-town charm. Whether you're looking for your first home, a turnkey investment, or a stylish place to downsize, this exceptional condo delivers modern living at its finest. Stop searching-your next chapter begins at Trend Living. Available anytime after September 8 (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T19:34:58.641244+00:00"
+"Directions": "MALLARD TRAIL"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2093886"
+"ListOfficeKey": "284792"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T16:40:12Z"
+"PhotosCount": 19
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T16:40:12Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30025680/409-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "N/A"
+"GeocodeManualYN": false
+"TotalActualRent": 1949
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-13T16:40:11.9Z"
+"ListAgentNationalAssociationId": "1366297"
+"ListOfficeNationalAssociationId": "1344891"
+"Media": array:19 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30025680')"
+"ID": "1620460"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25325
+post_id: "1618853"
+post_author: 1
+"ListingKey": "30024851"
+"ListingId": "40847467"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T15:05:55Z"
+"RFModificationTimestamp": "2026-07-13T15:21:40Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 531.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "450 DUNDAS Street Unit# 409, Waterdown, Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.8799404
1 => 43.3426739
]
+"Latitude": 43.3426739
+"Longitude": -79.8799404
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Trend Living in the heart of Waterdown, where modern luxury meets everyday convenience. This brand-new 1-bedroom, 1-bathroom condominium offers a thoughtfully designed open-concept layout with premium finishes and contemporary style throughout, making it the perfect opportunity for first-time buyers, professionals, downsizers, or investors. Step inside to discover an elegant interior featuring quartz countertops throughout, upgraded tile and trim packages, stainless steel appliances, in-suite laundry, and quality finishes that provide both comfort and sophistication. Complete with a dedicated parking space and private storage locker, this unit offers everything you need for easy, low-maintenance living. Residents of Trend Living enjoy an exceptional collection of amenities, including stunning rooftop terraces with BBQ areas, stylish party rooms, fully equipped fitness facilities, and inviting social spaces designed to complement your lifestyle. Perfectly situated close to schools, parks, shopping, restaurants, and everyday amenities, with quick access to major highways for an easy commute, this location offers the ideal balance of urban convenience and small-town charm. Whether you're looking for your first home, a turnkey investment, or a stylish place to downsize, this exceptional condo delivers modern living at its finest. Stop searching—your next chapter begins at Trend Living. Available anytime after September 8 (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T15:21:36.587803+00:00"
+"Directions": "MALLARD TRAIL"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:1 [
0 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1879839"
+"ListOfficeKey": "284635"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-13T14:59:21Z"
+"PhotosCount": 19
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T14:59:21Z"
+"Stories": "1.0"
+"StreetName": "DUNDAS"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30024851/450-dundas-street-unit-409-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1975734"
+"CommonInterest": "Condo/Strata"
+"CoListAgentKey2": "1663133"
+"CoListOfficeKey": "54949"
+"GeocodeManualYN": true
+"TotalActualRent": 1949
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"CoListOfficeKey2": "54949"
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 531
+"OriginalEntryTimestamp": "2026-07-13T14:59:21.84Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1205864"
+"ListOfficeNationalAssociationId": "1344652"
+"CoListAgentNationalAssociationId": "1262343"
+"CoListAgentNationalAssociationId2": "1168399"
+"CoListOfficeNationalAssociationId": "1003557"
+"CoListOfficeNationalAssociationId2": "1003557"
+"Media": array:19 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30024851')"
+"ID": "1618853"
}
]
+success: true
+page_size: 9
+page_count: 6
+count: 53
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
]