array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30011803 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23470
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23472
+post_id: "1612309"
+post_author: 1
+"ListingKey": "30011803"
+"ListingId": "X13543826"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-11T21:15:03Z"
+"RFModificationTimestamp": "2026-07-11T21:16:37Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0R3"
+"UnparsedAddress": "74 COLE STREET, Hamilton (Waterdown), Ontario L8B0R3"
+"Coordinates": array:2 [
0 => -79.907465
1 => 43.336608
]
+"Latitude": 43.336608
+"Longitude": -79.907465
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful freehold semi-detached home in the highly sought-after west end of Waterdown! This bright, open-concept home features dark hardwood flooring throughout the main level, stainless steel appliances, a stylish backsplash, crown moulding, and a walk-out to the deck-perfect for indoor-outdoor living. The hardwood staircase is accented with elegant wrought iron spindles, while large windows fill the home with an abundance of natural light. The spacious primary bedroom offers ensuite privilege, and the house has been freshly painted with new floors on the upstairs level. The finished basement includes a bedroom with its own ensuite bathroom, ideal for guests or extended family. (id:62650)"
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T19:43:51.688171+00:00"
+"Directions": "Cross Streets: Parkside Dr & Hamilton St. ** Directions: Parkside Dr to Cole st."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027012"
+"ListOfficeKey": "268183"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-10T02:09:26Z"
+"PhotosCount": 29
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-11T21:08:34Z"
+"Stories": "2.0"
+"StreetName": "Cole"
+"StreetNumber": "74"
+"StreetSuffix": "Street"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30011803/74-cole-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3000
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-09T16:41:10.09Z"
+"ListAgentNationalAssociationId": "1306463"
+"ListOfficeNationalAssociationId": "1230066"
+"Media": array:29 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30011803_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/27724ed74d5f259053e3214b35a243da.webp"
"MediaSize" => 306281
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-27724ed74d5f259053e3214b35a243da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30011803_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/74a7220fda57f02f05a2ac667bc4351b.webp"
"MediaSize" => 87133
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-74a7220fda57f02f05a2ac667bc4351b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30011803_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/4c07f066bb54914884f9fc328ae8f91c.webp"
"MediaSize" => 92691
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-4c07f066bb54914884f9fc328ae8f91c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30011803_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/ac41c2797bac98e0c43f0f3c403cd4b1.webp"
"MediaSize" => 162301
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-ac41c2797bac98e0c43f0f3c403cd4b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30011803_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/e1529e463e092aad3b11e00d8f6e14eb.webp"
"MediaSize" => 111689
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-e1529e463e092aad3b11e00d8f6e14eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30011803_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/20a10a41252dfd2c8de2b8056d5582e4.webp"
"MediaSize" => 127638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-20a10a41252dfd2c8de2b8056d5582e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30011803_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/15d7b8c88ce5f60f78af77c7cd8a66f1.webp"
"MediaSize" => 145036
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-15d7b8c88ce5f60f78af77c7cd8a66f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30011803_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/e384afacb869c7dbfed3cb50cbc96984.webp"
"MediaSize" => 153823
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-e384afacb869c7dbfed3cb50cbc96984.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30011803_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/dc48383441ad2d482241a101515d5498.webp"
"MediaSize" => 82628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-dc48383441ad2d482241a101515d5498.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30011803_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/2e1d93e4f407b6b83b9be6f9823b4bdd.webp"
"MediaSize" => 75853
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-2e1d93e4f407b6b83b9be6f9823b4bdd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30011803_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/12ceb6f62322151ffbe0dd3765d91d19.webp"
"MediaSize" => 141843
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-12ceb6f62322151ffbe0dd3765d91d19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30011803_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/f92514a25dda71436074fd8cb7524108.webp"
"MediaSize" => 129069
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-f92514a25dda71436074fd8cb7524108.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30011803_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/2e17610ea152ba5f29b7ca65f4a65e04.webp"
"MediaSize" => 111012
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-2e17610ea152ba5f29b7ca65f4a65e04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30011803_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/2692f015d1f85967331c9acef698a7b3.webp"
"MediaSize" => 133671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-2692f015d1f85967331c9acef698a7b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30011803_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/112571d04af844562dcab07c14bf284b.webp"
"MediaSize" => 165313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-112571d04af844562dcab07c14bf284b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30011803_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/fd61552861a38c76186d740d3bb16a40.webp"
"MediaSize" => 110132
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-fd61552861a38c76186d740d3bb16a40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30011803_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/8ba4ba744154be29880b011bfb366687.webp"
"MediaSize" => 118202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-8ba4ba744154be29880b011bfb366687.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30011803_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/8bbebca17d26ac3404be9030a2bef53e.webp"
"MediaSize" => 96556
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-8bbebca17d26ac3404be9030a2bef53e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30011803_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/045aa58dd1d8c481b802f0fc9443a281.webp"
"MediaSize" => 126433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-045aa58dd1d8c481b802f0fc9443a281.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30011803_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/37b1c4686abce829959f139b10b42283.webp"
"MediaSize" => 112047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-37b1c4686abce829959f139b10b42283.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-09T16:41:10.1Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30011803_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/68fcf7a18972de1e2e58d2450e5e4d22.webp"
"MediaSize" => 96308
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-68fcf7a18972de1e2e58d2450e5e4d22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-10T01:25:58.51Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30011803_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/dca1343bfd58b6c6c684beb13a01e33e.webp"
"MediaSize" => 111103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-dca1343bfd58b6c6c684beb13a01e33e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-10T01:25:58.39Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30011803_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/e6872b795cb844331b2a6cd0a8ea1c3a.webp"
"MediaSize" => 106678
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-e6872b795cb844331b2a6cd0a8ea1c3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-10T01:25:58.47Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30011803_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/a57fdd640d9683e0b2998ec4c6752fa7.webp"
"MediaSize" => 103282
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-a57fdd640d9683e0b2998ec4c6752fa7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-10T01:25:58.53Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30011803_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/2496ceb3106433b533d20eb3f09fa7b5.webp"
"MediaSize" => 115793
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-2496ceb3106433b533d20eb3f09fa7b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-10T01:25:58.49Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30011803_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/f761b9aa2a0161b2e9561d117542c654.webp"
"MediaSize" => 286916
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-f761b9aa2a0161b2e9561d117542c654.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-10T01:25:58.55Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30011803_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/0aefdeece3814b061011618125069611.webp"
"MediaSize" => 314850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-0aefdeece3814b061011618125069611.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-10T01:25:58.57Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30011803_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/f2e7d8db2aad1abb7646ad41059670e9.webp"
"MediaSize" => 457816
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-f2e7d8db2aad1abb7646ad41059670e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-10T01:25:58.49Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30011803_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011803/010b2d5f9cc9b9fca3c08d0efc9fc855.webp"
"MediaSize" => 436279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011803/thumbnail-010b2d5f9cc9b9fca3c08d0efc9fc855.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13543826"
"ResourceRecordKey" => "30011803"
"ModificationTimestamp" => "2026-07-10T01:25:58.53Z"
]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30011803')"
+"ID": "1612309"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 268183" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24963
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24907
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "SUTTON GROUP - SUMMIT REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "905-897-9555"
+"OfficeMlsId": "686501"
+"ModificationTimestamp": "2026-03-03T10:56:50Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "268183"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "33 PEARL STREET #100"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "MISSISSAUGA"
+"OfficePostalCode": "L5M1X"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1230066"
+"OriginalEntryTimestamp": "2011-12-03T02:04:00Z"
+"OfficeFax": "905-897-9610"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"FranchiseNationalAssociationId": "1176600"
+"OfficeBrokerNationalAssociationId": "1230069"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('268183')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2027012" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24917
+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 '30011803'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25252
+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 '30011803' AND OpenHouseDate ge '2026-07-12'" => 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: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30011803' 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.907465 43.336608)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25321
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25315
+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 [
"RoomKey" => "1666331803"
"RoomType" => "Living room"
"ListingId" => "X13480968"
"RoomLevel" => "Main level"
"RoomWidth" => 4.26
"ListingKey" => "29943943"
"RoomLength" => 5.94
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-23T20:53:42.82Z"
]
1 => array:11 [
"RoomKey" => "1666331804"
"RoomType" => "Dining room"
"ListingId" => "X13480968"
"RoomLevel" => "Main level"
"RoomWidth" => 4.26
"ListingKey" => "29943943"
"RoomLength" => 5.94
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-23T20:53:42.82Z"
]
2 => array:11 [
"RoomKey" => "1666331805"
"RoomType" => "Kitchen"
"ListingId" => "X13480968"
"RoomLevel" => "Main level"
"RoomWidth" => 3.53
"ListingKey" => "29943943"
"RoomLength" => 2.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-23T20:53:42.82Z"
]
3 => array:11 [
"RoomKey" => "1666331806"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13480968"
"RoomLevel" => "Second level"
"RoomWidth" => 3.15
"ListingKey" => "29943943"
"RoomLength" => 4.21
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-23T20:53:42.82Z"
]
4 => array:11 [
"RoomKey" => "1666331807"
"RoomType" => "Bedroom 2"
"ListingId" => "X13480968"
"RoomLevel" => "Second level"
"RoomWidth" => 2.43
"ListingKey" => "29943943"
"RoomLength" => 2.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-23T20:53:42.82Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29943943_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/c1c04f375bf991395cb617ce5a4d9c53.webp"
"MediaSize" => 315856
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-c1c04f375bf991395cb617ce5a4d9c53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29943943_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/49b935329bc6efa2041183cac853419b.webp"
"MediaSize" => 316918
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-49b935329bc6efa2041183cac853419b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29943943_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/f4007192f18a7fe794c11a9efe9c2617.webp"
"MediaSize" => 263016
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-f4007192f18a7fe794c11a9efe9c2617.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29943943_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/b217173a49ccf4abe7ec6a15bb66e4eb.webp"
"MediaSize" => 269277
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-b217173a49ccf4abe7ec6a15bb66e4eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29943943_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/b43500268bb3e1d3ff22a562f33d455f.webp"
"MediaSize" => 363223
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-b43500268bb3e1d3ff22a562f33d455f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29943943_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/89c6b5dbbdd0e87eb7136430cecd4316.webp"
"MediaSize" => 318645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-89c6b5dbbdd0e87eb7136430cecd4316.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29943943_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/727b2a25166e279a094cb9505a590fc2.webp"
"MediaSize" => 307685
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-727b2a25166e279a094cb9505a590fc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29943943_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/24de836a813038c9a32f4150f8cd39cd.webp"
"MediaSize" => 243706
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-24de836a813038c9a32f4150f8cd39cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29943943_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/17fd6708143f95a6e1c1ee3317582e32.webp"
"MediaSize" => 235990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-17fd6708143f95a6e1c1ee3317582e32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29943943_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/32f62a48edbf88f570ee408d303fa595.webp"
"MediaSize" => 104571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-32f62a48edbf88f570ee408d303fa595.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29943943_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/0cafa6cfa77f817c37e18ac619d65803.webp"
"MediaSize" => 96681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-0cafa6cfa77f817c37e18ac619d65803.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29943943_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/5992d538173a46a7d4e216a9fe266b56.webp"
"MediaSize" => 168894
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-5992d538173a46a7d4e216a9fe266b56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29943943_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/235fa0712b6ac36050670b86300ce2ec.webp"
"MediaSize" => 181490
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-235fa0712b6ac36050670b86300ce2ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29943943_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/45350b6fd8fa4061f0bee58e8461296f.webp"
"MediaSize" => 145038
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-45350b6fd8fa4061f0bee58e8461296f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29943943_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/2fe81b2325c8f3547a4dd0e1571d98e1.webp"
"MediaSize" => 156041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-2fe81b2325c8f3547a4dd0e1571d98e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29943943_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/073d395385e10bf5ae83e157d8fc4ebe.webp"
"MediaSize" => 134734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-073d395385e10bf5ae83e157d8fc4ebe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29943943_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/4c400f17d110a718dfc58312c9defd59.webp"
"MediaSize" => 147415
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-4c400f17d110a718dfc58312c9defd59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29943943_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/5a51973e2d9b0f7d0562637af6004551.webp"
"MediaSize" => 133253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-5a51973e2d9b0f7d0562637af6004551.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29943943_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/089e4b272b652fc7986fb57447d560ec.webp"
"MediaSize" => 108328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-089e4b272b652fc7986fb57447d560ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29943943_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/0d5ed76691425208607d6a45be725aac.webp"
"MediaSize" => 131466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-0d5ed76691425208607d6a45be725aac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29943943_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/c59f358c0e3158b89c33da66839e14bc.webp"
"MediaSize" => 132896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-c59f358c0e3158b89c33da66839e14bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29943943_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/5ad4d5be97eb2424419e438c24c04ff6.webp"
"MediaSize" => 146972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-5ad4d5be97eb2424419e438c24c04ff6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29943943_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/425ed695dfcd951db15bdbf20cadefda.webp"
"MediaSize" => 127197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-425ed695dfcd951db15bdbf20cadefda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29943943_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/6278e2176a424205c03a14a465ed12fa.webp"
"MediaSize" => 88187
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-6278e2176a424205c03a14a465ed12fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29943943_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/7ac7f2b2e97461a8de0565990e8b9d40.webp"
"MediaSize" => 159777
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-7ac7f2b2e97461a8de0565990e8b9d40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29943943_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/458e97b58a831b45e5d66e0fb3294962.webp"
"MediaSize" => 147634
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-458e97b58a831b45e5d66e0fb3294962.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29943943_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/502f03cb5a046996e369d88e63eead2f.webp"
"MediaSize" => 169130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-502f03cb5a046996e369d88e63eead2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29943943_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/43ce2b4003e847504465185a2e01159f.webp"
"MediaSize" => 146876
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-43ce2b4003e847504465185a2e01159f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29943943_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/392a41068b5ff3ee61818816636d7ac4.webp"
"MediaSize" => 179956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-392a41068b5ff3ee61818816636d7ac4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29943943_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/973b0f9f4f3506a058f958badf8cde53.webp"
"MediaSize" => 146177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-973b0f9f4f3506a058f958badf8cde53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29943943_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/b88c05dd5c80ed2acafb4f385755e192.webp"
"MediaSize" => 152795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-b88c05dd5c80ed2acafb4f385755e192.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29943943_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/294825870a507a77db3401738caa6413.webp"
"MediaSize" => 156795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-294825870a507a77db3401738caa6413.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29943943_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/c86b7b224c5587ecb10dfbde75ac6112.webp"
"MediaSize" => 79432
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-c86b7b224c5587ecb10dfbde75ac6112.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29943943_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/1d1bbe84216c70edca935328d80b4bc2.webp"
"MediaSize" => 121386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-1d1bbe84216c70edca935328d80b4bc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29943943_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/778dd26a07329ccccbe9f2c46f4755a2.webp"
"MediaSize" => 117637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-778dd26a07329ccccbe9f2c46f4755a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29943943_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/552a22080bda46307aa536739864284d.webp"
"MediaSize" => 172951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-552a22080bda46307aa536739864284d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29943943_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/ca1723c57724410f332e44b01a4165d2.webp"
"MediaSize" => 128239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-ca1723c57724410f332e44b01a4165d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29943943_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/234c83bab602c1c2763f7aadbf246836.webp"
"MediaSize" => 111869
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-234c83bab602c1c2763f7aadbf246836.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13480968"
"ResourceRecordKey" => "29943943"
"ModificationTimestamp" => "2026-06-23T20:53:42.79Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29943943_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943943/d23639664044ae5b884758229c9b6362.webp"
"MediaSize" => 117725
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943943/thumbnail-d23639664044ae5b884758229c9b6362.webp"
"ResourceName" => "Property"
…6
]
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": 19
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29943943')"
+"ID": "1559429"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25317
+post_id: "1550150"
+post_author: 1
+"ListingKey": "29931778"
+"ListingId": "X13469760"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T14:30:04Z"
+"RFModificationTimestamp": "2026-06-23T14:31:35Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A4"
+"UnparsedAddress": "501 - 5 HAMILTON STREET N, Hamilton (Waterdown), Ontario L8B2A4"
+"Coordinates": array:2 [
0 => -79.8964742
1 => 43.3310512
]
+"Latitude": 43.3310512
+"Longitude": -79.8964742
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Are You Looking for a spacious 2-bedroom, 2 Bathroom Suite with designer finishes and a functional layout? This 1,025 SF suite has been completely transformed with over $47,000 in luxurious upgrades - and it shows the moment you walk through the door. Enjoy the bright open-concept layout with a large Chef's Kitchen with custom cabinetry, stone countertops, a large centre island with seating, an Induction Cooktop, Premium Appliances, upgraded lighting, and tiles that were selected with care. The living area flows to your private balcony through a sliding door, with motorized roller shades that let you control light and privacy at the touch of a button. North exposure means open, unobstructed views to enjoy your private 72 SF Balcony. Both bedrooms are generously sized, with the primary retreat complete with a large walk-in closet fitted with custom built-ins and a private ensuite bath and double vanity. The second bedroom is genuinely usable as a guest room, home office or gym, served by the main four-piece bathroom. Custom California Closet organizers throughout, with modern, low-maintenance vinyl plank flooring in the main living areas and bedrooms. Everything is move-in ready. In-suite laundry, one underground parking space, and one locker included. Located in the heart of Waterdown's downtown core, you are steps from restaurants, cafés, grocery stores, schools, and transit - with quick access to Hwy 6, Hwy 403, the QEW, Burlington and Aldershot GO Station. Available Starting September 1st! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Oven"
4 => "Dryer"
5 => "Microwave"
6 => "Cooktop"
7 => "Hood Fan"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T23:43:55.261845+00:00"
+"Directions": "Cross Streets: Dundas St/ Hamilton St. N. ** Directions: North of Dundas St, West side of Hamilton St. N."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1616151"
+"ListOfficeKey": "51182"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Level lot"
1 => "Balcony"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-23T14:21:07Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T14:21:07Z"
+"StreetDirSuffix": "North"
+"StreetName": "Hamilton"
+"StreetNumber": "5"
+"StreetSuffix": "Street"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youtu.be/DWvqeTDAehg"
+"Rooms": array:9 [
0 => array:11 [ …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/29931778/501-5-hamilton-street-n-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Property Management Guild 905.575.3636"
+"GeocodeManualYN": true
+"TotalActualRent": 2900
+"BuildingFeatures": array:3 [
0 => "Storage - Locker"
1 => "Party Room"
2 => "Visitor Parking"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-19T22:48:21.23Z"
+"ListAgentNationalAssociationId": "1159607"
+"ListOfficeNationalAssociationId": "1003183"
+"Media": array:18 [
0 => array:13 [ …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]
]
+"DaysOnMarket": 23
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29931778')"
+"ID": "1550150"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25314
+post_id: "1542427"
+post_author: 1
+"ListingKey": "29919819"
+"ListingId": "40840666"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T00:45:18Z"
+"RFModificationTimestamp": "2026-06-18T03:48:22Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2200.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B1W3"
+"UnparsedAddress": "141 BORERS CREEK Circle, Hamilton, Ontario L8B1W3"
+"Coordinates": array:2 [
0 => -79.9185268
1 => 43.3322591
]
+"Latitude": 43.3322591
+"Longitude": -79.9185268
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning freehold corner townhome in sought-after Waterdown West, offering over 2,300 sq. ft. of beautifully finished living space with 4+1 bedrooms and 4 bathrooms. The ground level features a bright recreation room with walkout access to the backyard, a versatile den ideal for a home office or guest room, and a newly finished lower level that provides even more flexible living space for a growing family. The main floor is flooded with natural light and showcases 9-foot ceilings, oversized windows, and hardwood flooring throughout. At the heart of the home is a beautifully appointed kitchen featuring stainless steel appliances, granite countertops, upgraded cabinetry, modern fixtures, and a large centre island perfect for both everyday living and entertaining. Upstairs, you’ll find spacious bedrooms, well-appointed bathrooms, custom closet organizers, and thoughtful finishes throughout. Additional features include central vacuum, builder-installed ethernet wiring, and cable connections for modern convenience. Step outside to your private backyard retreat, complete with professional hardscaping. Perfectly positioned beside scenic Borers Creek Trail and just minutes from downtown Waterdown’s charming shops, restaurants, parks, and amenities, with easy access to Highway 403 and the GO Station, this is an exceptional opportunity to own a move-in-ready home in one of Waterdown’s most desirable communities. (id:62783)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T03:48:13.994444+00:00"
+"Directions": "Parkside to Mosaic"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2110665"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T00:40:03Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T00:40:03Z"
+"Stories": "3.0"
+"StreetName": "BORERS CREEK"
+"StreetNumber": "141"
+"StreetSuffix": "Circle"
+"SubdivisionName": "460 - Waterdown West"
+"VirtualTourURLUnbranded": "https://oatstudio.aryeo.com/sites/141-borers-creek-cir-hamilton-on-l8b-1w3-25868668/branded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29919819/141-borers-creek-circle-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2185296"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283666"
+"GeocodeManualYN": true
+"TotalActualRent": 3800
+"ZoningDescription": "R6-38"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2200
+"OriginalEntryTimestamp": "2026-06-18T00:40:03.12Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1379232"
+"ListOfficeNationalAssociationId": "1333115"
+"CoListAgentNationalAssociationId": "1434925"
+"CoListOfficeNationalAssociationId": "1333115"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 25
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919819')"
+"ID": "1542427"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25318
+post_id: "1542434"
+post_author: 1
+"ListingKey": "29919882"
+"ListingId": "X13459338"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T01:35:11Z"
+"RFModificationTimestamp": "2026-06-18T01:49:46Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W3"
+"UnparsedAddress": "141 BORERS CREEK CIRCLE, Hamilton (Waterdown), Ontario L8B1W3"
+"Coordinates": array:2 [
0 => -79.918643
1 => 43.332392
]
+"Latitude": 43.332392
+"Longitude": -79.918643
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to this stunning freehold corner townhome in sought-after Waterdown West, offering over 2,300 sq. ft. of beautifully finished living space with 4+1 bedrooms and 4 bathrooms. The ground level features a bright recreation room with walkout access to the backyard, a versatile den ideal for a home office or guest room, and a newly finished lower level that provides even more flexible living space for a growing family. The main floor is flooded with natural light and showcases 9-foot ceilings, oversized windows, and hardwood flooring throughout. At the heart of the home is a beautifully appointed kitchen featuring stainless steel appliances, granite countertops, upgraded cabinetry, modern fixtures, and a large centre island perfect for both everyday living and entertaining. Upstairs, you'll find spacious bedrooms, well-appointed bathrooms, custom closet organizers, and thoughtful finishes throughout. Additional features include central vacuum, builder-installed ethernet wiring, and cable connections for modern convenience. Step outside to your private backyard retreat, complete with professional hardscaping. Perfectly positioned beside scenic Borers Creek Trail and just minutes from downtown Waterdown's charming shops, restaurants, parks, and amenities, with easy access to Highway 403 and the GO Station, this is an exceptional opportunity to own a move-in-ready home in one of Waterdown's most desirable communities. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T01:49:36.409059+00:00"
+"Directions": "Mosaic Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955536"
+"ListOfficeKey": "205316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T01:26:28Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T01:26:28Z"
+"Stories": "3.0"
+"StreetName": "Borers Creek"
+"StreetNumber": "141"
+"StreetSuffix": "Circle"
+"VirtualTourURLUnbranded": "https://oatstudio.aryeo.com/sites/141-borers-creek-cir-hamilton-on-l8b-1w3-25868668/branded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29919882/141-borers-creek-circle-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2227828"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "266588"
+"GeocodeManualYN": false
+"TotalActualRent": 3800
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-18T01:26:28.3Z"
+"ListAgentNationalAssociationId": "1247407"
+"ListOfficeNationalAssociationId": "1264489"
+"CoListAgentNationalAssociationId": "1470830"
+"CoListOfficeNationalAssociationId": "1274323"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 25
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919882')"
+"ID": "1542434"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25316
+post_id: "1541752"
+post_author: 1
+"ListingKey": "29919163"
+"ListingId": "X13458862"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T22:35:12Z"
+"RFModificationTimestamp": "2026-06-18T00:26:49Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8N2Z7"
+"UnparsedAddress": "184 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8N2Z7"
+"Coordinates": array:2 [
0 => -79.902542
1 => 43.324431
]
+"Latitude": 43.324431
+"Longitude": -79.902542
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Discover luxury and lifestyle in this beautifully crafted custom bungalow, situated on animpressive 0.45-acre lot just minutes from downtown Waterdown. This home offers nearly 5,000sq. ft. of living space, featuring 5 bedrooms (3 on the main floor and 2 in the lower level)and 6 bathrooms (3 on the main floor and 3 in the lower level). Home can come furnished and available for a 1 year lease.As you approach the property, you'll be greeted by oversized trees and thoughtfully designed landscaping, complemented by ample parking and stone pillars with lights. The main entrance features custom doors and a covered front entry with iron railings, leading into a main floor that overlooks the sunken great room, which has French doors opening to the flagstone patio with an awning. The main floor also includes a private office, perfect for remote work, as well as a separate formal dining room. The open-concept kitchen and family room create an entertainer's delight, equipped with large glass sliders that lead to a bright sunroom. Thefamily room features a stunning wall of granite stone and a gas fireplace.The modern lower level is finished to perfection, featuring 2 spacious bedrooms, each with walk-in closets and personal 3-piece en-suites. The open-concept kitchen and family room flow seamlessly to a walkout patio, providing an excellent setting for relaxation. With a separate entrance and privacy. Step outside to your own backyard oasis, complete with a cozy fire pit area and multi-level patios made of flagstone and interlock, all enclosed by a fully fenced yard for your private enjoyment. The professionally landscaped exterior features natural rockery and mature gardens, enhancing the home's impressive curb appeal.Additional highlights:- Utilities & Cable/Internet not included in lease price- 2 kitchens and 2 laundry rooms- 2.5 car garage- A full-house generator- Tenant insurance required- AAA Tenants only. (id:62783)"
+"Appliances": array:9 [
0 => "Water purifier"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Range"
4 => "Oven - Built-In"
5 => "Water Treatment"
6 => "Garage door opener remote(s)"
7 => "Water Heater - Tankless"
8 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:10 [
0 => "Finished"
1 => "Full"
2 => "Apartment in basement"
3 => "Separate entrance"
4 => "Walk out"
5 => "Walk-up"
6 => "N/A"
7 => "N/A"
8 => "N/A"
9 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T00:26:39.515315+00:00"
+"Directions": "Dundas St. East & Riley"
+"Electric": "Generator"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1992922"
+"ListOfficeKey": "47632"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Wheelchair access"
1 => "Carpet Free"
2 => "Sump Pump"
3 => "In-Law Suite"
]
+"LotSizeDimensions": "105.4 x 184.8 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-17T22:26:20Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T22:26:19Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "184"
+"StreetSuffix": "Street"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29919163/184-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 15
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 6500
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"PropertyCondition": array:1 [
0 => "Insulation upgraded"
]
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 105.4
+"OriginalEntryTimestamp": "2026-06-17T22:26:19.43Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1276178"
+"ListOfficeNationalAssociationId": "1001102"
+"Media": array:39 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
]
+"DaysOnMarket": 25
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919163')"
+"ID": "1541752"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25311
+post_id: "1521720"
+post_author: 1
+"ListingKey": "29891241"
+"ListingId": "X13433690"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T20:40:08Z"
+"RFModificationTimestamp": "2026-06-11T20:42:31Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1V8"
+"UnparsedAddress": "601 - 30 HAMILTON STREET S, Hamilton (Waterdown), Ontario L8B1V8"
+"Coordinates": array:2 [
0 => -79.894191
1 => 43.330175
]
+"Latitude": 43.330175
+"Longitude": -79.894191
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 601 at 30 Hamilton St S - a stunning 1 Bed + Den sixth-floor residence in the heart of Waterdown where thoughtful design meets an unbeatable location. This spacious 700 sq ft layout offers the perfect blend of comfort and versatility. Step out onto your private balcony and be greeted by sweeping views that remind you why you chose to call Waterdown home. Just seconds away, the building's Sky Deck takes it further - panoramic sight-lines stretching across the Niagara Escarpment, the Hamilton skyline, the iconic Skyway Bridge, and the shimmering expanse of Lake Ontario. Few residences anywhere in the region can match this vantage point. Convenience is built right into the neighbourhood. Everything you need is within walking distance - groceries, restaurants, pharmacies, banks, and gas stations are all just steps from your front door, making everyday errands effortless. And for those who commute, Aldershot GO Station is just a 5-minute drive away, putting Toronto and the entire GO network well within reach.This isn't just a unit to rent - it's a home you'll be proud to come back to every day. From the sixth-floor elevation that sets you above the noise to the community-focused charm of Waterdown's village streets below, Unit 601 offers a lifestyle as elevated as its views. Whether you're a professional seeking a seamless commute, a couple looking for a stylish and functional space, or anyone who simply refuses to settle for ordinary - this is the one. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T20:42:18.338679+00:00"
+"Directions": "Cross Streets: Hamilton St S @ Barton St. ** Directions: Hamilton St S to Barton Street."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2068660"
+"ListOfficeKey": "85099"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-11T20:33:06Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T20:33:06Z"
+"StreetDirSuffix": "South"
+"StreetName": "Hamilton"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"View": "City view,Lake view,View of water"
+"VirtualTourURLUnbranded": "https://youriguide.com/unit_601_30_hamilton_st_s_hamilton_on/"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "OnePoint"
+"CityRegion": "Waterdown"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29891241/601-30-hamilton-street-s-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"TotalActualRent": 2375
+"BuildingFeatures": array:5 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Security/Concierge"
4 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-11T19:31:56.65Z"
+"ListAgentNationalAssociationId": "1343730"
+"ListOfficeNationalAssociationId": "1187791"
+"Media": array:44 [
0 => array:13 [ …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]
]
+"DaysOnMarket": 31
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891241')"
+"ID": "1521720"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23484
+post_id: "1492866"
+post_author: 1
+"ListingKey": "29851063"
+"ListingId": "X13237920"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-04T21:05:11Z"
+"RFModificationTimestamp": "2026-06-04T21:31:19Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8N2Z7"
+"UnparsedAddress": "UPPER LEVEL (ONLY) - 184 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8N2Z7"
+"Coordinates": array:2 [
0 => -79.902542
1 => 43.324431
]
+"Latitude": 43.324431
+"Longitude": -79.902542
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Turn-key custom-built bungalow main floor only, fully furnished. Situated on an impressive 0.45-acre lot just minutes from downtown Waterdown. This home offers 2350 sq. ft. Featuring 3 bedrooms and 3 bathrooms. Home comes furnished and available for a 1-year lease. Lower-level walkout is tenanted with separate entrance.As you approach the property, you'll be greeted by oversized trees and thoughtfully designed landscaping, complemented by ample parking and stone pillars with lights. The main entrance features custom doors and a covered front entry with iron railings, leading into a main floor that overlooks the sunken great room, which has French doors opening to the flagstone patio with an awning. The main floor also includes a private office, perfect for remote work, as well as a separate formal dining room. The open-concept kitchen and family room create an entertainer's delight, equipped with large glass sliders that lead to a bright sunroom. The family room features a stunning wall of granite stone fireplace with gas. Step outside to your own backyard oasis, flagstone and interlock, all enclosed by a fully fenced yard for your private enjoyment. The professionally landscaped exterior features natural rockery and mature gardens, enhancing the home's impressive curb appeal. Upper Garden Level only. Additional highlights:- Utilities & Cable/Internet/propety taxes/ garden matinance/ grass cutting- 1 car garage + 2 exterior spots- A full-house generator- Tenant insurance required- AAA Tenants only.+ 2025 Notice of Assessment. The tenant is in agreement that the home can be offered for sale and shown 60 days prior to the end of the lease term. (id:62783)"
+"Appliances": array:16 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Range"
7 => "Oven"
8 => "Dryer"
9 => "Microwave"
10 => "Freezer"
11 => "Oven - Built-In"
12 => "Water Treatment"
13 => "Garage door opener remote(s)"
14 => "Water Heater - Tankless"
15 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:10 [
0 => "Finished"
1 => "Full"
2 => "Apartment in basement"
3 => "Separate entrance"
4 => "Walk out"
5 => "Walk-up"
6 => "N/A"
7 => "N/A"
8 => "N/A"
9 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T04:43:05.623413+00:00"
+"Directions": "Cross Streets: Dundas St. East & Riley. ** Directions: Highway #6 East to 3rd TrafficLight."
+"Electric": "Generator"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1992922"
+"ListOfficeKey": "47632"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Wooded area"
1 => "Wheelchair access"
2 => "Carpet Free"
]
+"LotSizeDimensions": "105.4 x 184.8 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-04T20:56:46Z"
+"PhotosCount": 12
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-04T20:56:46Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "184"
+"StreetSuffix": "Street"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array: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": "Oakville-Milton"
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29851063/upper-level-only-184-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Other"
]
+"GeocodeManualYN": false
+"TotalActualRent": 4500
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"PropertyCondition": array:1 [
0 => "Insulation upgraded"
]
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 105.4
+"OriginalEntryTimestamp": "2026-06-04T02:26:13.27Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1276178"
+"ListOfficeNationalAssociationId": "1001102"
+"Media": array:12 [
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]
]
+"DaysOnMarket": 39
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29851063')"
+"ID": "1492866"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25319
+post_id: "1468087"
+post_author: 1
+"ListingKey": "29816068"
+"ListingId": "40834238"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:25:56Z"
+"RFModificationTimestamp": "2026-06-02T16:35:42Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 948.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "22 MILL Street S Unit# 203, Waterdown, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8913622
1 => 43.3338403
]
+"Latitude": 43.3338403
+"Longitude": -79.8913622
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to your new home in the heart of Waterdown! This spacious 1+ bedroom apartment, just under 1000 sq ft, offers a versatile layout with a living room, family room, and an additional room that can serve as a dining area, second bedroom, or a den/office. Conveniently located with public transportation right at your doorstep, you'll also enjoy easy access to nearby hiking and walking trails. Plus, downtown is just a short stroll away, making this the perfect blend of comfort and convenience. Great value at $2,290/month, includes heat & hydro. 1 parking spot available. 2nd parking spot is $75/month. Laundry is $40/month. (id:62650)"
+"Appliances": array:3 [
0 => "Refrigerator"
1 => "Stove"
2 => "Microwave"
]
+"AssociationFeeIncludes": array:6 [
0 => "Exterior Maintenance"
1 => "Landscaping"
2 => "Heat"
3 => "Electricity"
4 => "Water"
5 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-05-28T04:02:54.529577+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525314"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-05-28T18:40:14Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:14:04Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "MILL"
+"StreetNumber": "22"
+"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/29816068/22-mill-street-s-unit-203-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1982606"
+"CoListOfficeKey": "283457"
+"GeocodeManualYN": true
+"TotalActualRent": 2290
+"ZoningDescription": "C5a"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 115.0
+"AboveGradeFinishedArea": 948
+"OriginalEntryTimestamp": "2026-05-28T03:39:05.76Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1063775"
+"ListOfficeNationalAssociationId": "1330157"
+"CoListAgentNationalAssociationId": "1267853"
+"CoListOfficeNationalAssociationId": "1330157"
+"Media": array:18 [
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]
]
+"DaysOnMarket": 46
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29816068')"
+"ID": "1468087"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25320
+post_id: "1464957"
+post_author: 1
+"ListingKey": "29812484"
+"ListingId": "X13192382"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-27T17:30:52Z"
+"RFModificationTimestamp": "2026-05-27T18:03:27Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H4"
+"UnparsedAddress": "307 - 30 HAMILTON STREET S, Hamilton (Waterdown), Ontario L0R2H4"
+"Coordinates": array:2 [
0 => -79.893998
1 => 43.330366
]
+"Latitude": 43.330366
+"Longitude": -79.893998
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This gorgeous, upscale modern unit boasts many stylish upgrades and features! It features a one-bedroom plus a full-size den with a feature wall, a spacious kitchen with all-new cabinetry, and numerous space-maximizing touches throughout. There's even a brand-new live-edge breakfast bar for extra seating. The living room has a modern acoustic feature wall, and the primary bedroom has easy access to a large four-piece washroom and laundry. The building is trendy and offers all the best amenities. There's an exercise room, bike room, main and sixth-floor common terraces, a pet washing station, a party room, a car charging station, and a real concierge. Convenient storage lockers are available on the same floor as the condo, and there's an underground parking space with plenty of visitor parking for your guests. (id:62783)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-27T18:03:15.392888+00:00"
+"Directions": "Dundas St E / Hamilton St S"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Flooring": array:1 [
0 => "Hardwood"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1533526"
+"ListOfficeKey": "247988"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Balcony"
1 => "Level"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-05-27T16:59:58Z"
+"PhotosCount": 11
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-27T16:59:58Z"
+"StreetDirSuffix": "South"
+"StreetName": "Hamilton"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"Rooms": array:8 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29812484/307-30-hamilton-street-s-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"TotalActualRent": 2300
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Security/Concierge"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-05-27T16:59:58.47Z"
+"ListAgentNationalAssociationId": "1177439"
+"ListOfficeNationalAssociationId": "1243257"
+"Media": array:11 [
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]
]
+"DaysOnMarket": 46
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29812484')"
+"ID": "1464957"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 10
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]