array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29793028 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1451580"
+post_author: 1
+"ListingKey": "29793028"
+"ListingId": "X13163466"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T19:40:09Z"
+"RFModificationTimestamp": "2026-06-10T19:46:53Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z4"
+"UnparsedAddress": "38 SILVER MEADOW GDNS GARDENS N, Hamilton (Waterdown), Ontario L8B1Z4"
+"Coordinates": array:2 [
0 => -79.873145
1 => 43.341598
]
+"Latitude": 43.341598
+"Longitude": -79.873145
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "MOVE-IN READY! MOVE-IN READY! MOVE-IN READY! Welcome to your turnkey sanctuary. Nestled on a premium lot in Waterdown's highly sought-after Mountainview Heights, this brand-new, 4-bedroom, 3-bathroom semi-detached home is making its lease debut. Spanning approximately 2,000 square feet of impeccably designed, fully furnished living space, it offers the perfect blend of modern sophistication and everyday comfort. The Highlights: Architectural Elegance: Step inside to soaring 9-foot ceilings on both levels, striking coffered ceilings, and a seamless open-concept layout bathed in natural light. Sophisticated Spaces: The main level boasts a cozy electric fireplace, elegant hardwood stairs, and ultra-convenient main-floor laundry with direct garage access. Space for Everyone: The upper level features a generous landing leading to four beautifully appointed, fully furnished bedrooms and three full bathrooms-offering unparalleled privacy for families or executive guests. Modern Tech & Conveniences: Stay connected and secure with smart home upgrades (including a doorbell and driveway camera), modern light fixtures, a high-efficiency HVAC system, and 3-car parking (1-car garage + 2-car driveway). The Location: Perfect for outdoor enthusiasts and commuters alike. You're just minutes from the breathtaking views of the Bruce Trail and Great Falls, while enjoying effortless access to the Aldershot GO Station, QEW, 407, and Waterdown's vibrant local dining, shopping, and parks. Just bring your suitcase and settle into luxury. The Fully Furnished House - $3,950/month (All Furniture Included) (id:62650)"
+"Appliances": array:1 [
0 => "Oven - Built-In"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-22T20:32:10.364688+00:00"
+"Directions": "Cross Streets: Great Fall/Hager Creek Terrace. ** Directions: Hager Creek/Silver Meadow Gdns."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2095009"
+"ListOfficeKey": "279090"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"LotSizeDimensions": "20.4 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-22T19:56:38Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T19:31:11Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "Silver Meadow Gdns"
+"StreetNumber": "38"
+"StreetSuffix": "Gardens"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29793028/38-silver-meadow-gdns-gardens-n-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3500
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 20.4
+"OriginalEntryTimestamp": "2026-05-22T19:56:38.63Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1367249"
+"ListOfficeNationalAssociationId": "1301519"
+"Media": array:42 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29793028_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/04898828d27d03beec08a2ac137af470.webp"
"MediaSize" => 279586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-04898828d27d03beec08a2ac137af470.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29793028_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/e413ca8a5a35d048150300cd03c6506e.webp"
"MediaSize" => 295472
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-e413ca8a5a35d048150300cd03c6506e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29793028_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/434938f9edb5fda8a6925d5bc9a4635e.webp"
"MediaSize" => 298619
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-434938f9edb5fda8a6925d5bc9a4635e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29793028_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/54520e90cf5d10049a0dc39c707b109f.webp"
"MediaSize" => 298646
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-54520e90cf5d10049a0dc39c707b109f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29793028_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/e67a58a4ee07fec3758d11060cae0b4a.webp"
"MediaSize" => 85549
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-e67a58a4ee07fec3758d11060cae0b4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29793028_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/07bb193b0e24281ccb32f28219369891.webp"
"MediaSize" => 97194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-07bb193b0e24281ccb32f28219369891.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29793028_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/9149f93ea3b5b4b37cda4b47b1d7907c.webp"
"MediaSize" => 93282
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-9149f93ea3b5b4b37cda4b47b1d7907c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29793028_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/90e877b505ff5cf951c021b20321c6bc.webp"
"MediaSize" => 75131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-90e877b505ff5cf951c021b20321c6bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29793028_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/6b7b6f6bc9322caa53aae89bb5f2e861.webp"
"MediaSize" => 73160
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-6b7b6f6bc9322caa53aae89bb5f2e861.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29793028_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/c4cf257625266de559ff1edf8cee0302.webp"
"MediaSize" => 82474
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-c4cf257625266de559ff1edf8cee0302.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29793028_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/6194b4ebc960917340942dfb7ed104c0.webp"
"MediaSize" => 115530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-6194b4ebc960917340942dfb7ed104c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29793028_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/866d85192c9d763ffad21fbfac7fa079.webp"
"MediaSize" => 92805
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-866d85192c9d763ffad21fbfac7fa079.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29793028_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/47f620be1c747f08fc2c37f2c25c7c3d.webp"
"MediaSize" => 128956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-47f620be1c747f08fc2c37f2c25c7c3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29793028_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/ec5886bf58415ccbe6a723027ef5a7b9.webp"
"MediaSize" => 131880
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-ec5886bf58415ccbe6a723027ef5a7b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29793028_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/e6268c7c163f9a986d317918906672c3.webp"
"MediaSize" => 142906
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-e6268c7c163f9a986d317918906672c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29793028_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/a8befee365492f73d24ff3df172b43cc.webp"
"MediaSize" => 115179
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-a8befee365492f73d24ff3df172b43cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29793028_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/e6c697641e2374f3d09c9a423102bf24.webp"
"MediaSize" => 138991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-e6c697641e2374f3d09c9a423102bf24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29793028_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/747eb76a408dfe75d7162ad013bba3d2.webp"
"MediaSize" => 121107
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-747eb76a408dfe75d7162ad013bba3d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29793028_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/74ebcfab8cb83faeb170412f076544ae.webp"
"MediaSize" => 121032
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-74ebcfab8cb83faeb170412f076544ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29793028_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/c0c7ec233b3e1ca2f7df3790036233c4.webp"
"MediaSize" => 163043
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-c0c7ec233b3e1ca2f7df3790036233c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29793028_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/0e442a1a46b35954330da6d577366042.webp"
"MediaSize" => 153484
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-0e442a1a46b35954330da6d577366042.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29793028_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/45dfff4bab48a133bdd3d1f43eb81f94.webp"
"MediaSize" => 168975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-45dfff4bab48a133bdd3d1f43eb81f94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29793028_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/afe2ead17460f2c834a5a9a8a2661355.webp"
"MediaSize" => 158450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-afe2ead17460f2c834a5a9a8a2661355.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29793028_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/0e832cd290ccf3f7ff07442f02ba9046.webp"
"MediaSize" => 123850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-0e832cd290ccf3f7ff07442f02ba9046.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29793028_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/c93c415be5741c5fbd57b72df5d5ae9c.webp"
"MediaSize" => 93785
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-c93c415be5741c5fbd57b72df5d5ae9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29793028_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/d342afce5fdca4fc2a7e63265bb27f4a.webp"
"MediaSize" => 92310
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-d342afce5fdca4fc2a7e63265bb27f4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29793028_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/525a498f72a51579600538fbd7234cf1.webp"
"MediaSize" => 97466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-525a498f72a51579600538fbd7234cf1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29793028_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/c20572eccb10d96242cfe7b024e1ca18.webp"
"MediaSize" => 80053
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-c20572eccb10d96242cfe7b024e1ca18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29793028_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/f0125ad602cf7ec6a99b4ac4ac59ac97.webp"
"MediaSize" => 99211
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-f0125ad602cf7ec6a99b4ac4ac59ac97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29793028_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/4510991bbd192cf63f490688ae1523bb.webp"
"MediaSize" => 94948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-4510991bbd192cf63f490688ae1523bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29793028_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/966319f7f69d0811fba1306e9f01669b.webp"
"MediaSize" => 104253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-966319f7f69d0811fba1306e9f01669b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29793028_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/0cf1e18aca4e2241784b0ea1e5e84fc1.webp"
"MediaSize" => 109647
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-0cf1e18aca4e2241784b0ea1e5e84fc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29793028_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/c27f1c8493242bd5485a7a860c95f890.webp"
"MediaSize" => 96619
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-c27f1c8493242bd5485a7a860c95f890.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29793028_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/66ef7186c8f55dac034b04afef87b09c.webp"
"MediaSize" => 110562
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-66ef7186c8f55dac034b04afef87b09c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29793028_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/e90cd30aa8b1ec224f8ccd2f5c073c12.webp"
"MediaSize" => 109987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-e90cd30aa8b1ec224f8ccd2f5c073c12.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29793028_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/21c3a07548c6960be9ebf5bde16cfe91.webp"
"MediaSize" => 107481
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-21c3a07548c6960be9ebf5bde16cfe91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29793028_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/934f7715727910e34b011095621b7d7e.webp"
"MediaSize" => 180934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-934f7715727910e34b011095621b7d7e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29793028_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/0e923070b8091758f97d484a410c8173.webp"
"MediaSize" => 76539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-0e923070b8091758f97d484a410c8173.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29793028_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/df627525a4fc196fca1b4e6d6f55fd35.webp"
"MediaSize" => 80926
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-df627525a4fc196fca1b4e6d6f55fd35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29793028_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/c5870241a7ce6cb3809d3a32a8fa3372.webp"
"MediaSize" => 300244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-c5870241a7ce6cb3809d3a32a8fa3372.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29793028_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/8d3c62a86abea52cc53d70d0cd0c105f.webp"
"MediaSize" => 315435
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-8d3c62a86abea52cc53d70d0cd0c105f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29793028_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29793028/d198699d1fa066232a2c09ab5ad56f8b.webp"
"MediaSize" => 329193
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29793028/thumbnail-d198699d1fa066232a2c09ab5ad56f8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13163466"
"ResourceRecordKey" => "29793028"
"ModificationTimestamp" => "2026-05-22T19:56:38.64Z"
]
]
+"DaysOnMarket": 35
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29793028')"
+"ID": "1451580"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 279090" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24906
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2095009" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24875
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29793028'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25268
+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 '29793028'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25284
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29793028' 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.873145 43.341598)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25357
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25351
+post_id: "1569634"
+post_author: 1
+"ListingKey": "29957204"
+"ListingId": "X13492626"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T14:30:19Z"
+"RFModificationTimestamp": "2026-06-26T17:14:17Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "314 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Trend Living in Waterdown! This bright and move-in-ready 1-bedroom, 1-bathroom condo features hardwood flooring throughout, premium upgrades, a modern kitchen with beautiful countertops and stainless steel appliances, and an open-concept layout filled with natural light. Enjoy the convenience of in-suite laundry, one surface parking space, and one locker. Residents enjoy exceptional amenities including a rooftop terrace with BBQs, gym, and party room. Ideally located close to hiking and biking trails, Train Station, and just a short drive to Ontario's renowned wineries, this stylish condo offers the perfect blend of comfort and convenience. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Multi-level"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T17:14:14.160950+00:00"
+"Directions": "Dundas/ Mallard Trail"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2259210"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T14:20:12Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T14:20:12Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1668534026"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13492626"
"RoomLevel" => "Main level"
"RoomWidth" => 3.08
"ListingKey" => "29957204"
"RoomLength" => 2.83
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T14:20:12.85Z"
]
1 => array:11 [
"RoomKey" => "1668534027"
"RoomType" => "Bathroom"
"ListingId" => "X13492626"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29957204"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T14:20:12.85Z"
]
2 => array:11 [
"RoomKey" => "1668534028"
"RoomType" => "Kitchen"
"ListingId" => "X13492626"
"RoomLevel" => "Main level"
"RoomWidth" => 2.28
"ListingKey" => "29957204"
"RoomLength" => 2.37
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T14:20:12.85Z"
]
3 => array:11 [
"RoomKey" => "1668534029"
"RoomType" => "Great room"
"ListingId" => "X13492626"
"RoomLevel" => "Main level"
"RoomWidth" => 3.99
"ListingKey" => "29957204"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T14:20:12.86Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29957204/314-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 2100
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-26T14:20:12.78Z"
+"ListAgentNationalAssociationId": "1499122"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:26 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29957204_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/9673a11a9639e01102a4e2516af1c44e.webp"
"MediaSize" => 162364
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-9673a11a9639e01102a4e2516af1c44e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29957204_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/12b3176c1a1dfd1b6511849418399021.webp"
"MediaSize" => 126758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-12b3176c1a1dfd1b6511849418399021.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29957204_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/93288fd34494dc3e4dd6f5b4c3a11f8a.webp"
"MediaSize" => 156060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-93288fd34494dc3e4dd6f5b4c3a11f8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29957204_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/dcec0fd04fb47ad48f3dd5a10423b9c8.webp"
"MediaSize" => 138117
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-dcec0fd04fb47ad48f3dd5a10423b9c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29957204_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/54aabfef1bdefba6883f1799f3bd330a.webp"
"MediaSize" => 75287
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-54aabfef1bdefba6883f1799f3bd330a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29957204_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/2f19908c27c3dfcb10a0920ae4db0575.webp"
"MediaSize" => 72013
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-2f19908c27c3dfcb10a0920ae4db0575.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29957204_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/37ed754d92e575f0ce5af940424e712c.webp"
"MediaSize" => 56885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-37ed754d92e575f0ce5af940424e712c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29957204_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/84ece3b83a8e259f6dae9b3434984ec6.webp"
"MediaSize" => 77575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-84ece3b83a8e259f6dae9b3434984ec6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29957204_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/44bfbbbbac1533a9a2fd1e709e5ec336.webp"
"MediaSize" => 80669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-44bfbbbbac1533a9a2fd1e709e5ec336.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29957204_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/845cf8437cabd3e625bbd5cd6c6d9f44.webp"
"MediaSize" => 63465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-845cf8437cabd3e625bbd5cd6c6d9f44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29957204_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/81e91991a00f769e85efde0301500d9c.webp"
"MediaSize" => 71468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-81e91991a00f769e85efde0301500d9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29957204_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/41b24589da9c5b54ea5c1770547b074d.webp"
"MediaSize" => 61101
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-41b24589da9c5b54ea5c1770547b074d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29957204_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/85a77509a0035af7a893c4838783cadc.webp"
"MediaSize" => 62126
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-85a77509a0035af7a893c4838783cadc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29957204_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/f3e73e01605d0985b671626663527cc0.webp"
"MediaSize" => 63213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-f3e73e01605d0985b671626663527cc0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29957204_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/7105d775842a94e806210a1ecca06487.webp"
"MediaSize" => 50666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-7105d775842a94e806210a1ecca06487.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29957204_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/9329f00eb3d4c3385fcb6e458e2cc94f.webp"
"MediaSize" => 49427
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-9329f00eb3d4c3385fcb6e458e2cc94f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29957204_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/ccfc9d32f322e2a30b6fdc142a2a8a41.webp"
"MediaSize" => 50912
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-ccfc9d32f322e2a30b6fdc142a2a8a41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29957204_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/62847c375804358333eeea8dd7122f32.webp"
"MediaSize" => 97730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-62847c375804358333eeea8dd7122f32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29957204_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/7cc3de8911d2d78927e2c72fa6136f1d.webp"
"MediaSize" => 77294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-7cc3de8911d2d78927e2c72fa6136f1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29957204_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/1c4bb849bb619d10769dd1d61d77668a.webp"
"MediaSize" => 61321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-1c4bb849bb619d10769dd1d61d77668a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29957204_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/b6cd720ac9ec25d6f989d2b1e892f89a.webp"
"MediaSize" => 47231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-b6cd720ac9ec25d6f989d2b1e892f89a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29957204_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/b07c205c82eb8fa816d1f44fc5dec8b3.webp"
"MediaSize" => 31734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-b07c205c82eb8fa816d1f44fc5dec8b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29957204_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/94ac4866a5f7bee9daa6af3b878eff88.webp"
"MediaSize" => 51979
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-94ac4866a5f7bee9daa6af3b878eff88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29957204_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/6669135d6a40de290cea2d94f63178a9.webp"
"MediaSize" => 51573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-6669135d6a40de290cea2d94f63178a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29957204_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/64236a246bbef743cadad475e0430f9a.webp"
"MediaSize" => 102482
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-64236a246bbef743cadad475e0430f9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29957204_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957204/4ec64d7cdc8975310104cb1242f37f21.webp"
"MediaSize" => 108469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957204/thumbnail-4ec64d7cdc8975310104cb1242f37f21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13492626"
"ResourceRecordKey" => "29957204"
"ModificationTimestamp" => "2026-06-26T14:20:12.79Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29957204')"
+"ID": "1569634"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25353
+post_id: "1566996"
+post_author: 1
+"ListingKey": "29946413"
+"ListingId": "40842485"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T15:00:19Z"
+"RFModificationTimestamp": "2026-06-26T03:21:36Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 614.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "460 DUNDAS Street Unit# 1208, Waterdown, Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.8792153
1 => 43.3435524
]
+"Latitude": 43.3435524
+"Longitude": -79.8792153
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright penthouse suite will well planned layout, inside the TREND 2 Condos in Waterdown. Soaring 10' ceilings with oversized floor to ceiling windows with incredible views. 1 bed + spacious den, 1 bath, complete with underground parking and locker. Fashionable upgrades throughout. Enjoy multiple gyms, roof top patios, party rooms. Close to downtown Waterdown, HWY 403 and HWY 407. This is not just a condo unit, this is Trend Living. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:3 [
0 => "Exterior Maintenance"
1 => "Heat"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T03:21:12.259250+00:00"
+"Directions": "DUNDAS ST E TO RIVERWALK"
+"ExteriorFeatures": array:3 [
0 => "Steel"
1 => "Stone"
2 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2041170"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-24T14:53:07Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T14:53:07Z"
+"Stories": "1.0"
+"StreetName": "DUNDAS"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"View": "View (panoramic)"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1666887598"
"RoomType" => "Laundry room"
"ListingId" => "40842485"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946413"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T14:51:22.97Z"
]
1 => array:11 [
"RoomKey" => "1666887600"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842485"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946413"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T14:51:22.97Z"
]
2 => array:11 [
"RoomKey" => "1666887602"
"RoomType" => "Den"
"ListingId" => "40842485"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946413"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 8'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T14:51:22.97Z"
]
3 => array:11 [
"RoomKey" => "1666887604"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842485"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946413"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T14:51:22.97Z"
]
4 => array:11 [
"RoomKey" => "1666887606"
"RoomType" => "Kitchen"
"ListingId" => "40842485"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946413"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 7'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T14:51:22.98Z"
]
5 => array:11 [
"RoomKey" => "1666887608"
"RoomType" => "Living room"
"ListingId" => "40842485"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946413"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T14:51:22.98Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29946413/460-dundas-street-unit-1208-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2250
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 614
+"OriginalEntryTimestamp": "2026-06-24T14:51:22.94Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1317423"
+"ListOfficeNationalAssociationId": "1344653"
+"Media": array:26 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29946413_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946413/ef2cec86ff3d757c0ecd7a2c1f8ca77e.webp"
"MediaSize" => 75328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946413/thumbnail-ef2cec86ff3d757c0ecd7a2c1f8ca77e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842485"
"ResourceRecordKey" => "29946413"
"ModificationTimestamp" => "2026-06-24T14:53:05.74Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29946413_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946413/3244ecde7f23756d486dc97d2c4cbc3c.webp"
"MediaSize" => 50659
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946413/thumbnail-3244ecde7f23756d486dc97d2c4cbc3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842485"
"ResourceRecordKey" => "29946413"
"ModificationTimestamp" => "2026-06-24T14:53:07.48Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29946413_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946413/4b9b2e93669b60a7222ac09d0421478f.webp"
"MediaSize" => 58842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946413/thumbnail-4b9b2e93669b60a7222ac09d0421478f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842485"
"ResourceRecordKey" => "29946413"
"ModificationTimestamp" => "2026-06-24T14:53:05.74Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29946413_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946413/3b13a1023ef0c6445c6a1822c401b41e.webp"
"MediaSize" => 60282
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946413/thumbnail-3b13a1023ef0c6445c6a1822c401b41e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842485"
"ResourceRecordKey" => "29946413"
"ModificationTimestamp" => "2026-06-24T14:53:05.73Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29946413_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946413/f493c6d985e3bc8fbffe219d568abf0a.webp"
"MediaSize" => 67305
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946413/thumbnail-f493c6d985e3bc8fbffe219d568abf0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842485"
"ResourceRecordKey" => "29946413"
"ModificationTimestamp" => "2026-06-24T14:53:04.74Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29946413_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946413/8b7ea690361b8d1ff044853c88993e07.webp"
"MediaSize" => 67049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946413/thumbnail-8b7ea690361b8d1ff044853c88993e07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842485"
"ResourceRecordKey" => "29946413"
"ModificationTimestamp" => "2026-06-24T14:53:07.48Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29946413_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946413/f9632379c4b28d38d687cf4a33bdcdd4.webp"
"MediaSize" => 72346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946413/thumbnail-f9632379c4b28d38d687cf4a33bdcdd4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842485"
"ResourceRecordKey" => "29946413"
"ModificationTimestamp" => "2026-06-24T14:53:07.52Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29946413_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946413/84bce43174f26dc5f350ea77b6944963.webp"
"MediaSize" => 67520
"MediaType" => "webp"
…8
]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946413')"
+"ID": "1566996"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25350
+post_id: "1566337"
+post_author: 1
+"ListingKey": "29946904"
+"ListingId": "X13483466"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T16:25:13Z"
+"RFModificationTimestamp": "2026-06-26T02:33:54Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "1208 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.879544
1 => 43.343071
]
+"Latitude": 43.343071
+"Longitude": -79.879544
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright penthouse suite with well planned layout, inside the TREND 2 Condos in Waterdown. Soaring 10' ceilings with oversized floor to ceiling windows with incredible views. 1 bed + spacious den, 1 bath, complete with underground parking and locker. Fashionable upgrades throughout. Enjoy multiple gyms, roof top patios, party rooms. Close to downtown Waterdown, Aldershot GO, the 403 and the 407. This is not just a condo unit, this is Trend Living. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T02:32:49.519735+00:00"
+"Directions": "Cross Streets: DUNDAS & MALLARD. ** Directions: DUNDAS ST E TO RIVERWALK DR."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2098722"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Flat site"
1 => "Elevator"
2 => "Balcony"
3 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-24T16:17:40Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T16:17:40Z"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"View": "View"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29946904/1208-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "FIRST SERVICE RESIDENTIAL"
+"GeocodeManualYN": false
+"TotalActualRent": 2250
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-24T15:58:52.15Z"
+"ListAgentNationalAssociationId": "1369003"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:26 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946904')"
+"ID": "1566337"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25354
+post_id: "1565367"
+post_author: 1
+"ListingKey": "29949613"
+"ListingId": "X13486054"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T22:25:05Z"
+"RFModificationTimestamp": "2026-06-25T23:17:03Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W5"
+"UnparsedAddress": "23 RIDGESIDE LANE, Hamilton (Waterdown), Ontario L8B1W5"
+"Coordinates": array:2 [
0 => -79.874314
1 => 43.343002
]
+"Latitude": 43.343002
+"Longitude": -79.874314
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained end-unit townhouse in a highly desirable community of Waterdown. Offering a perfect blend of comfort, style, and convenience, this 3-bedroom, 2-bathroom home is ideal for families, professionals, or anyone seeking low-maintenance living in a vibrant neighbourhood.Step inside to discover a bright and spacious layout featuring laminate flooring throughout, creating a seamless and modern look across all levels. The open-concept main floor is designed for both everyday living and entertaining, with generous living and dining areas that flow effortlessly together.Upstairs, you'll find three well-sized bedrooms, providing ample space for rest, work, or growing families.As an end-unit, this home benefits from additional natural light and enhanced privacy. Outside, enjoy the practicality of parking for two vehicles, a rare and valuable feature in this sought-after area.Located close to parks, schools, shopping, and commuter routes, this property offers the perfect balance of suburban tranquility and urban accessibility.Don't miss your opportunity to own a stylish and functional home in one of Waterdown's most desirable communities. (id:62783)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:16:19.941953+00:00"
+"Directions": "dundas and mallard"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1958291"
+"ListOfficeKey": "285730"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T22:17:44Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T22:17:44Z"
+"Stories": "3.0"
+"StreetName": "Ridgeside"
+"StreetNumber": "23"
+"StreetSuffix": "Lane"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=AOIyBWgklBg"
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29949613/23-ridgeside-lane-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "wilson blanchard"
+"GeocodeManualYN": false
+"TotalActualRent": 3000
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-24T22:17:44.4Z"
+"ListAgentNationalAssociationId": "1249178"
+"ListOfficeNationalAssociationId": "1353943"
+"Media": array:28 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29949613')"
+"ID": "1565367"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25352
+post_id: "1565368"
+post_author: 1
+"ListingKey": "29950236"
+"ListingId": "40842892"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T01:00:12Z"
+"RFModificationTimestamp": "2026-06-25T22:30:38Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 792.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "450 DUNDAS Street E Unit# 1113, Waterdown, Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.880407
1 => 43.3424738
]
+"Latitude": 43.3424738
+"Longitude": -79.880407
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning 1+Den 1 Bath unit at sought after Trend building. Enjoy breathtaking views from the 11th floor in this bright and spacious unit featuring high-end finishes throughout, with an open-concept kitchen and living room with stainless steel appliances, a breakfast bar and a walk-out to your private balcony. The condo is complete with a 4-piece bathroom and in-suite laundry. Enjoy all the fabulous amenities that this building has to offer, including party rooms, modern fitness facilities, rooftop patios and bike storage. Situated in the desirable Waterdown community with quick access to the local Go Station, QEW, 403 and 407 Highways, local restaurants, shopping, schools and parks. 2 parking spaces and 1 locker included! Geothermal heating and cooling throughout. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:4 [
0 => "Exterior Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"CreationDate": "2026-06-25T22:30:16.587194+00:00"
+"Directions": "RIVERWALK TO MALLARD TRAIL"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007461"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Balcony"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Open"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-25T00:50:17Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T00:50:17Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "450"
+"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/29950236/450-dundas-street-e-unit-1113-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2300
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 792
+"OriginalEntryTimestamp": "2026-06-25T00:50:17.55Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1289513"
+"ListOfficeNationalAssociationId": "1344653"
+"Media": array:21 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29950236')"
+"ID": "1565368"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25327
+post_id: "1565369"
+post_author: 1
+"ListingKey": "29950342"
+"ListingId": "X13486556"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T01:50:03Z"
+"RFModificationTimestamp": "2026-06-25T22:18:52Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "1113 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.880553
1 => 43.342598
]
+"Latitude": 43.342598
+"Longitude": -79.880553
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning 1+Den 1 Bath unit at sought after Trend building. Enjoy breathtaking views from the 11th floor in this bright and spacious unit featuring high-end finishes throughout, with an open-concept kitchen and living room with stainless steel appliances, a breakfast bar and a walk-out to your private balcony. The condo is complete with a 4-piece bathroom and in-suite laundry. Enjoy all the fabulous amenities that this building has to offer, including party rooms, modern fitness facilities, rooftop patios and bike storage. Situated in the desirable Waterdown community with quick access to the local Go Station, QEW, 403 and 407 Highways, local restaurants, shopping, schools and parks. 2 parking spaces and 1 locker included! Geothermal heating and cooling throughout. (id:62783)"
+"Appliances": array:1 [
0 => "Intercom"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"CreationDate": "2026-06-25T22:18:25.623507+00:00"
+"Directions": "Riverwalk Dr"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092595"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Conservation/green belt"
1 => "Elevator"
2 => "Balcony"
3 => "Carpet Free"
4 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-25T01:42:34Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T01:42:34Z"
+"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/29950342/1113-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 2300
+"BuildingFeatures": array:3 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-25T01:42:34.31Z"
+"ListAgentNationalAssociationId": "1365159"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:21 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29950342')"
+"ID": "1565369"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1561999"
+post_author: 1
+"ListingKey": "29953637"
+"ListingId": "X13489192"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T19:05:24Z"
+"RFModificationTimestamp": "2026-06-25T20:31:04Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H5"
+"UnparsedAddress": "162 BOULDING AVENUE, Hamilton (Waterdown), Ontario L0R2H5"
+"Coordinates": array:2 [
0 => -79.88884
1 => 43.34767
]
+"Latitude": 43.34767
+"Longitude": -79.88884
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "In a Demand Location Of Waterdown. Well maintained Detached house with open Concept Layout,Main floor hardwood, Large living/ Dining rm. Gorgeous family room located on 2nd floor, can beused as a bedroom as well. 3 good size bedroom w/ 2 full bath upstairs. Fully Finished bsmnt w/lrg rec rm & office space. pot light in the main floor and basement, Neutral painting make brighter in the house, Nice landscaping in the front and backyard, will give you very comfortable living environment. Close to shopping, school, parks & major hwy, go station... andmore. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
5 => "Window Coverings"
6 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T20:28:11.125161+00:00"
+"Directions": "Parkside/Boulding"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Carpeted"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1423606"
+"ListOfficeKey": "287452"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T18:36:45Z"
+"PhotosCount": 22
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T18:58:47Z"
+"Stories": "2.0"
+"StreetName": "Boulding"
+"StreetNumber": "162"
+"StreetSuffix": "Avenue"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29953637/162-boulding-avenue-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3500
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-25T18:36:44.71Z"
+"ListAgentNationalAssociationId": "1117938"
+"ListOfficeNationalAssociationId": "1368149"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29953637')"
+"ID": "1561999"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25355
+post_id: "1560541"
+post_author: 1
+"ListingKey": "29945358"
+"ListingId": "40842570"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T03:40:13Z"
+"RFModificationTimestamp": "2026-06-24T04:34:01Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 614.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "460 DUNDAS Street E Unit# 809, Waterdown, Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.8794637
1 => 43.3434067
]
+"Latitude": 43.3434067
+"Longitude": -79.8794637
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "1 Bedroom + Den....TREND 2 condo available for lease located in trendy hot spot of Waterdown. Built by Award Winning NHDG. Living steps away from upscale boutiques, antique shops and super centre with major stores, that will satisfy any shopping fanatic. Grand Entrance will give you first impression of stylish interiors and elegant lobby. Enjoy a fresh cup of coffee while you bask in sunshine on your rooftop patio. During cooler days, take the festivities indoors to your fully furnished party room. Say goodbye to gym membership with a fully equipped facility at your disposal. Stunning 1 BEDROOM+DEN condo features open concept kitchen, along with your living space that exudes both comfort and style spacious interiors that provides endless opportunities to create unique lifestyle. Quality upgrades through out includes stylish tiles, upgraded ample kitchen cabinetry, interior doors, vinyl plank flooring throughout, and remotely controlled zebra blinds. In-suite laundry. Experience the convenience of condo living with 1 UG PARKING, bike storage, & your own personal locker. Balcony with unobstructed view. GeoThermal Heat/Cool. Minutes to Aldershot GO Station, downtown Burlington and Hamilton. Min 1y lease, 1st & last deposit, letter of employment, recent 4 pay stubs, references, rental application, credit check (Full report Equifax) and ID. No smoking of any kind. Not pet friendly. Monthly rent includes heating. Photos taken before current tenant took possession. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:6 [
0 => "Exterior Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Heat"
4 => "Insurance"
5 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-24T04:33:52.359608+00:00"
+"Directions": "460 Dundas Street East, Waterdown (Between Riverwalk and Millard)"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stucco"
2 => "Other"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563191"
+"ListOfficeKey": "262664"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Balcony"
2 => "No Pet Home"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-24T03:31:21Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T03:31:21Z"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29945358/460-dundas-street-e-unit-809-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2150
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 614
+"OriginalEntryTimestamp": "2026-06-24T03:31:21.39Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1148616"
+"ListOfficeNationalAssociationId": "1223042"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29945358')"
+"ID": "1560541"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25356
+post_id: "1559429"
+post_author: 1
+"ListingKey": "29943943"
+"ListingId": "X13480968"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T21:00:17Z"
+"RFModificationTimestamp": "2026-06-23T22:22:39Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1X6"
+"UnparsedAddress": "76 - 383 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1X6"
+"Coordinates": array:2 [
0 => -79.887763
1 => 43.339072
]
+"Latitude": 43.339072
+"Longitude": -79.887763
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Townhome 2 Bed & 3 Bath In The Heart Of Waterdown!! Large Open Concept Living & Dining Rooms, Upgraded Kitchen With Stainless Steel Appliances!! New Paint Throughout the the house! Huge Roof Top Terrace(27 x 18 sq. ft). 2 Parking. Walking Distance To Downtown Waterdown, Minutes To Go Train, School, Restaurants, Shopping. Easy Access To Hwys 403 & 407. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Blinds"
6 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T22:22:31.407514+00:00"
+"Directions": "First Street/ Dundas Street East"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Flooring": array:2 [
0 => "Carpeted"
1 => "Ceramic"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1947489"
+"ListOfficeKey": "164016"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T20:53:42Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T20:53:42Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "383"
+"StreetSuffix": "Street"
+"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/29943943/76-383-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1918183"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Melbourne Property Management Inc."
+"CoListOfficeKey": "164016"
+"GeocodeManualYN": false
+"TotalActualRent": 2650
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-23T20:53:42.78Z"
+"ListAgentNationalAssociationId": "1243138"
+"ListOfficeNationalAssociationId": "1184644"
+"CoListAgentNationalAssociationId": "1225816"
+"CoListOfficeNationalAssociationId": "1184644"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29943943')"
+"ID": "1559429"
}
]
+success: true
+page_size: 9
+page_count: 7
+count: 55
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]