array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29905689 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23380
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23382
+post_id: "1531858"
+post_author: 1
+"ListingKey": "29905689"
+"ListingId": "X13446750"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T19:10:06Z"
+"RFModificationTimestamp": "2026-06-15T22:03:48Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A7"
+"UnparsedAddress": "532 - 10 MALLARD TRAIL, Hamilton (Waterdown), Ontario L8B2A7"
+"Coordinates": array:2 [
0 => -79.878112
1 => 43.344161
]
+"Latitude": 43.344161
+"Longitude": -79.878112
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright and modern boutique condominium available for rent located in one of Waterdown's most desirable communities. open-concept living and dining area, Modern kitchen with upgraded countertops & designer cabinetry, large bedroom with double closet, Full bathroom with premium chrome finishes, Stainless steel appliances, In-suite laundry, Energy-efficient geothermal heating and cooling. Comes with one surface parking spot and locker conveniently located on the suite floor. Fully equipped fitness center, Rooftop terrace, Party room with kitchen and pool table, On-site property management. Quick access to Highways 407, 403, QEW, and 401, Minutes to Aldershot GO Station, Close to shopping, restaurants, and schools, Nearby parks include Sealey Park and Waterdown Memorial Park. Offer (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T22:03:42.551051+00:00"
+"Directions": "Dundas Street East"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1857539"
+"ListOfficeKey": "257478"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T18:56:54Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T18:56:54Z"
+"StreetName": "Mallard"
+"StreetNumber": "10"
+"StreetSuffix": "Trail"
+"Rooms": array:3 [
0 => array:11 [
"RoomKey" => "1660030908"
"RoomType" => "Bedroom"
"ListingId" => "X13446750"
"RoomLevel" => "Main level"
"RoomWidth" => 3.13
"ListingKey" => "29905689"
"RoomLength" => 3.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T18:56:54.72Z"
]
1 => array:11 [
"RoomKey" => "1660030909"
"RoomType" => "Great room"
"ListingId" => "X13446750"
"RoomLevel" => "Main level"
"RoomWidth" => 3.46
"ListingKey" => "29905689"
"RoomLength" => 3.94
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T18:56:54.73Z"
]
2 => array:11 [
"RoomKey" => "1660030910"
"RoomType" => "Bathroom"
"ListingId" => "X13446750"
"RoomLevel" => "Main level"
"RoomWidth" => 2.29
"ListingKey" => "29905689"
"RoomLength" => 2.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T18:56:54.73Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29905689/532-10-mallard-trail-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 1900
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-15T18:56:54.7Z"
+"ListAgentNationalAssociationId": "1200241"
+"ListOfficeNationalAssociationId": "1214671"
+"Media": array:18 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29905689_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/530fd6976e4da5a155413779f2c0a498.webp"
"MediaSize" => 221385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-530fd6976e4da5a155413779f2c0a498.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29905689_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/fddbc0272441d1eac80bdc98617280a6.webp"
"MediaSize" => 239192
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-fddbc0272441d1eac80bdc98617280a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29905689_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/4b3fb441ed40b06359a86bce84ff1f41.webp"
"MediaSize" => 193722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-4b3fb441ed40b06359a86bce84ff1f41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29905689_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/9ab7dfa5f5f2281c70f63dbe3511e2e5.webp"
"MediaSize" => 170834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-9ab7dfa5f5f2281c70f63dbe3511e2e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29905689_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/8a70ef721e6ec0d6c0208e8c80eebd10.webp"
"MediaSize" => 202739
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-8a70ef721e6ec0d6c0208e8c80eebd10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29905689_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/7fe8e286d59185ea4b4654ce6d78234f.webp"
"MediaSize" => 160510
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-7fe8e286d59185ea4b4654ce6d78234f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29905689_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/41316e3b5884dfb9c7631789343cba26.webp"
"MediaSize" => 137084
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-41316e3b5884dfb9c7631789343cba26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29905689_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/a103f4f7d4854d3f6d72b3bfc5fa3a1e.webp"
"MediaSize" => 150642
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-a103f4f7d4854d3f6d72b3bfc5fa3a1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29905689_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/3149937a4c2e1de07225a5f38b3d836a.webp"
"MediaSize" => 159705
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-3149937a4c2e1de07225a5f38b3d836a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29905689_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/bac6d8ee6f615c2369126abde9425f1d.webp"
"MediaSize" => 138501
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-bac6d8ee6f615c2369126abde9425f1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29905689_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/6fc8c9496834c5b20de377e8276584ed.webp"
"MediaSize" => 86334
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-6fc8c9496834c5b20de377e8276584ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29905689_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/b5badd528b6671ce4e00b54f11db2e56.webp"
"MediaSize" => 191842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-b5badd528b6671ce4e00b54f11db2e56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29905689_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/0c139fe0634beeaff304941cbe7ee3a5.webp"
"MediaSize" => 183748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-0c139fe0634beeaff304941cbe7ee3a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29905689_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/1b3a8d47d1649585acf3881ae7dd27c4.webp"
"MediaSize" => 185117
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-1b3a8d47d1649585acf3881ae7dd27c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29905689_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/d6cacf55205657ddb3e98bbc4e6a00e1.webp"
"MediaSize" => 211709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-d6cacf55205657ddb3e98bbc4e6a00e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29905689_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/79027e6414147bce36ca7d14a1a82fbf.webp"
"MediaSize" => 80739
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-79027e6414147bce36ca7d14a1a82fbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29905689_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/548fc01a385f64cc07f8e33ee20a5b3f.webp"
"MediaSize" => 63406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-548fc01a385f64cc07f8e33ee20a5b3f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29905689_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905689/0b0df6d9d6c746fb6cde0fa27dfac13b.webp"
"MediaSize" => 48048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905689/thumbnail-0b0df6d9d6c746fb6cde0fa27dfac13b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446750"
"ResourceRecordKey" => "29905689"
"ModificationTimestamp" => "2026-06-15T18:56:54.71Z"
]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905689')"
+"ID": "1531858"
}
]
+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=OfficeMlsId eq 257478" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24835
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1857539" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24808
+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 '29905689'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25125
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29905689'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25141
+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 '29905689' 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.878112 43.344161)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25194
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25188
+post_id: "1548944"
+post_author: 1
+"ListingKey": "29930131"
+"ListingId": "X13468170"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T19:10:09Z"
+"RFModificationTimestamp": "2026-06-19T20:28:25Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "407 - 470 DUNDAS STREET S, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "TWO PARKING SPACES! Make this stylish new condo your home. 2 Bedroom 1 Bathroom. 737 Square feet. Modern finishes. Plenty of amenities with a gym, party room, media room walking trails and more. This condo is located in the heart of Waterdown just a 5 min drive the Aldershot Go station. Available to be moved into Immediately. Available August 15th 2026. (id:62783)"
+"AssociationFee": "1"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T20:28:19.677107+00:00"
+"Directions": "Cross Streets: Mallard Tri & Dundas. ** Directions: Turn onto Riverwalk. Lots of guest parking."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2145642"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-19T18:57:17Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T18:57:17Z"
+"StreetDirSuffix": "South"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1663190097"
"RoomType" => "Bathroom"
"ListingId" => "X13468170"
"RoomLevel" => "Main level"
"RoomWidth" => 1.5
"ListingKey" => "29930131"
"RoomLength" => 2.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T18:57:17.38Z"
]
1 => array:11 [
"RoomKey" => "1663190098"
"RoomType" => "Bedroom"
"ListingId" => "X13468170"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29930131"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T18:57:17.38Z"
]
2 => array:11 [
"RoomKey" => "1663190099"
"RoomType" => "Bedroom 2"
"ListingId" => "X13468170"
"RoomLevel" => "Main level"
"RoomWidth" => 2.84
"ListingKey" => "29930131"
"RoomLength" => 3.12
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T18:57:17.38Z"
]
3 => array:11 [
"RoomKey" => "1663190100"
"RoomType" => "Kitchen"
"ListingId" => "X13468170"
"RoomLevel" => "Main level"
"RoomWidth" => 2.26
"ListingKey" => "29930131"
"RoomLength" => 2.54
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T18:57:17.39Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29930131/407-470-dundas-street-s-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"TotalActualRent": 2750
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-19T18:57:17.27Z"
+"ListAgentNationalAssociationId": "1397064"
+"ListOfficeNationalAssociationId": "1243249"
+"Media": array:12 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29930131_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930131/cb6ffd707f155ecff0456b75ff3e1af7.webp"
"MediaSize" => 50436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930131/thumbnail-cb6ffd707f155ecff0456b75ff3e1af7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13468170"
"ResourceRecordKey" => "29930131"
"ModificationTimestamp" => "2026-06-19T18:57:17.31Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29930131_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930131/40b649f9be2da8f1122b4e660b657162.webp"
"MediaSize" => 12059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930131/thumbnail-40b649f9be2da8f1122b4e660b657162.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468170"
"ResourceRecordKey" => "29930131"
"ModificationTimestamp" => "2026-06-19T18:57:17.31Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29930131_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930131/2012d2b66bbef0dbe6dea41a1bfedc0a.webp"
"MediaSize" => 9701
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930131/thumbnail-2012d2b66bbef0dbe6dea41a1bfedc0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468170"
"ResourceRecordKey" => "29930131"
"ModificationTimestamp" => "2026-06-19T18:57:17.31Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29930131_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930131/fbcab9f29bd8f920c63fe86d16eb5f02.webp"
"MediaSize" => 11872
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930131/thumbnail-fbcab9f29bd8f920c63fe86d16eb5f02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468170"
"ResourceRecordKey" => "29930131"
"ModificationTimestamp" => "2026-06-19T18:57:17.31Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29930131_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930131/199c7545c842db833ad13e22cf61ceac.webp"
"MediaSize" => 10000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930131/thumbnail-199c7545c842db833ad13e22cf61ceac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468170"
"ResourceRecordKey" => "29930131"
"ModificationTimestamp" => "2026-06-19T18:57:17.31Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29930131_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930131/43a7a4b9e8e70b41089fcd44abcb498d.webp"
"MediaSize" => 8778
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930131/thumbnail-43a7a4b9e8e70b41089fcd44abcb498d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468170"
"ResourceRecordKey" => "29930131"
"ModificationTimestamp" => "2026-06-19T18:57:17.31Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29930131_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930131/f6a6fc2a801f16464ec08cd3eea75fa2.webp"
"MediaSize" => 9085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930131/thumbnail-f6a6fc2a801f16464ec08cd3eea75fa2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468170"
"ResourceRecordKey" => "29930131"
"ModificationTimestamp" => "2026-06-19T18:57:17.31Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29930131_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930131/3f73387a89f4aaef3c095c8bbbb3ca87.webp"
"MediaSize" => 9205
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930131/thumbnail-3f73387a89f4aaef3c095c8bbbb3ca87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468170"
"ResourceRecordKey" => "29930131"
"ModificationTimestamp" => "2026-06-19T18:57:17.31Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29930131_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930131/6b783e10f514bb757cbad327cdf36115.webp"
"MediaSize" => 9532
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930131/thumbnail-6b783e10f514bb757cbad327cdf36115.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468170"
"ResourceRecordKey" => "29930131"
"ModificationTimestamp" => "2026-06-19T18:57:17.31Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29930131_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930131/2e625d8d69e95e538cfaac398995d3c9.webp"
"MediaSize" => 9781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930131/thumbnail-2e625d8d69e95e538cfaac398995d3c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468170"
"ResourceRecordKey" => "29930131"
"ModificationTimestamp" => "2026-06-19T18:57:17.31Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29930131_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930131/54c8864c1a5b3841415853297b2a8a63.webp"
"MediaSize" => 14447
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930131/thumbnail-54c8864c1a5b3841415853297b2a8a63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468170"
"ResourceRecordKey" => "29930131"
"ModificationTimestamp" => "2026-06-19T18:57:17.31Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29930131_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930131/a4cdb811c212c4fa9e55f69dd2683a10.webp"
"MediaSize" => 121078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930131/thumbnail-a4cdb811c212c4fa9e55f69dd2683a10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468170"
"ResourceRecordKey" => "29930131"
"ModificationTimestamp" => "2026-06-19T18:57:17.31Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930131')"
+"ID": "1548944"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25190
+post_id: "1548975"
+post_author: 1
+"ListingKey": "29929506"
+"ListingId": "40840194"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T18:10:06Z"
+"RFModificationTimestamp": "2026-06-19T20:14:17Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 737.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "470 DUNDAS Street E Unit# 407, Waterdown, Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.8786066
1 => 43.3439068
]
+"Latitude": 43.3439068
+"Longitude": -79.8786066
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "TWO PARKING SPACES! Make this stylish new condo your home. 2 Bedrooms 1 Bathroom. 737 square feet. Modern finishes. Plenty of amenities with a gym, party room, media room, walking trails and more. This condo is located in the heart of Waterdown just a 5 minute drive from the Aldershot GO station. Available to be moved into immediately. Available August 15, 2026 (id:62650)"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Water"
1 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T20:13:53.372420+00:00"
+"Directions": "Turn on riverwak"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2074429"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "No Pet Home"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-19T17:52:45Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T17:52:45Z"
+"Stories": "4.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1663136850"
"RoomType" => "Kitchen"
"ListingId" => "40840194"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29929506"
"RoomLength" => null
"RoomDimensions" => "7'5'' x 7'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T17:52:45.66Z"
]
1 => array:11 [
"RoomKey" => "1663136851"
"RoomType" => "Bedroom"
"ListingId" => "40840194"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29929506"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T17:52:45.66Z"
]
2 => array:11 [
"RoomKey" => "1663136852"
"RoomType" => "Bedroom"
"ListingId" => "40840194"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29929506"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T17:52:45.66Z"
]
3 => array:11 [
"RoomKey" => "1663136853"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840194"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29929506"
"RoomLength" => null
"RoomDimensions" => "7' x 8'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T17:52:45.66Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29929506/470-dundas-street-e-unit-407-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2750
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Guest Suite"
2 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 737
+"OriginalEntryTimestamp": "2026-06-19T17:52:45.6Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1349609"
+"ListOfficeNationalAssociationId": "1330157"
+"Media": array:12 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29929506_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929506/433d7748ec592158340d64a1815851f9.webp"
"MediaSize" => 49804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929506/thumbnail-433d7748ec592158340d64a1815851f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840194"
"ResourceRecordKey" => "29929506"
"ModificationTimestamp" => "2026-06-19T17:52:45.6Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29929506_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929506/4dd986e5cf22643159786e1fdff91561.webp"
"MediaSize" => 14354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929506/thumbnail-4dd986e5cf22643159786e1fdff91561.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840194"
"ResourceRecordKey" => "29929506"
"ModificationTimestamp" => "2026-06-19T17:52:45.6Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29929506_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929506/fc0698ce0caffa4251c8a48bd3180d4b.webp"
"MediaSize" => 12211
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929506/thumbnail-fc0698ce0caffa4251c8a48bd3180d4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840194"
"ResourceRecordKey" => "29929506"
"ModificationTimestamp" => "2026-06-19T17:52:45.6Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29929506_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929506/2c707e5e7085fc494ffff3500546c9c6.webp"
"MediaSize" => 9490
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929506/thumbnail-2c707e5e7085fc494ffff3500546c9c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840194"
"ResourceRecordKey" => "29929506"
"ModificationTimestamp" => "2026-06-19T17:52:45.6Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29929506_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929506/4516050ebeb70f2d9791bcb96560256e.webp"
"MediaSize" => 9337
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929506/thumbnail-4516050ebeb70f2d9791bcb96560256e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840194"
"ResourceRecordKey" => "29929506"
"ModificationTimestamp" => "2026-06-19T17:52:45.6Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29929506_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929506/28df5c57d725a963266ca250dd914fe0.webp"
"MediaSize" => 10173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929506/thumbnail-28df5c57d725a963266ca250dd914fe0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840194"
"ResourceRecordKey" => "29929506"
"ModificationTimestamp" => "2026-06-19T17:52:45.6Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29929506_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929506/cdd99cfee5fe0e8066768ab1b73c0d9c.webp"
"MediaSize" => 11376
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929506/thumbnail-cdd99cfee5fe0e8066768ab1b73c0d9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840194"
"ResourceRecordKey" => "29929506"
"ModificationTimestamp" => "2026-06-19T17:52:45.6Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29929506_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929506/966032955a188ff3816d49aaccc1be18.webp"
"MediaSize" => 11856
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929506/thumbnail-966032955a188ff3816d49aaccc1be18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840194"
"ResourceRecordKey" => "29929506"
"ModificationTimestamp" => "2026-06-19T17:52:45.6Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29929506_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929506/6617b587ae0dedb1f2f2411e2b1022b7.webp"
"MediaSize" => 9013
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929506/thumbnail-6617b587ae0dedb1f2f2411e2b1022b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840194"
"ResourceRecordKey" => "29929506"
"ModificationTimestamp" => "2026-06-19T17:52:45.6Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29929506_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929506/15cdbec7d3941a1f6a45636600fe5015.webp"
"MediaSize" => 9395
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929506/thumbnail-15cdbec7d3941a1f6a45636600fe5015.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840194"
"ResourceRecordKey" => "29929506"
"ModificationTimestamp" => "2026-06-19T17:52:45.6Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29929506_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929506/f8569620bf838e2c4e1a437721b5e8a4.webp"
"MediaSize" => 9989
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929506/thumbnail-f8569620bf838e2c4e1a437721b5e8a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840194"
"ResourceRecordKey" => "29929506"
"ModificationTimestamp" => "2026-06-19T17:52:45.6Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29929506_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929506/59997dea8b2e57036a1db65e9b5753dc.webp"
"MediaSize" => 8165
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929506/thumbnail-59997dea8b2e57036a1db65e9b5753dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840194"
"ResourceRecordKey" => "29929506"
"ModificationTimestamp" => "2026-06-19T17:52:45.6Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29929506')"
+"ID": "1548975"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25187
+post_id: "1545508"
+post_author: 1
+"ListingKey": "29925516"
+"ListingId": "X13464294"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T22:05:19Z"
+"RFModificationTimestamp": "2026-06-18T22:47:21Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A7"
+"UnparsedAddress": "336 - 10 MALLARD TRAIL, Hamilton (Waterdown), Ontario L8B2A7"
+"Coordinates": array:2 [
0 => -79.878112
1 => 43.344161
]
+"Latitude": 43.344161
+"Longitude": -79.878112
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning 2 + Den condo built by award winning developer New Horizon Development Group. Featuring in-suite laundry, geo-thermal heating & cooling, storage locker and 1 underground parking space! Many building amenities include a party room, gym, rooftop patios and bike storage. Located in the desirable Waterdown community with extensive dining, shopping, schools, parks and a 5 minute drive to downtown Burlington or the Aldershot GO Station. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"CreationDate": "2026-06-18T22:47:17.903956+00:00"
+"Directions": "Dundas St E."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092595"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-18T21:59:15Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T21:59:15Z"
+"StreetName": "Mallard"
+"StreetNumber": "10"
+"StreetSuffix": "Trail"
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1662477792"
"RoomType" => "Bedroom"
"ListingId" => "X13464294"
"RoomLevel" => "Main level"
"RoomWidth" => 2.95
"ListingKey" => "29925516"
"RoomLength" => 3.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T21:59:15.16Z"
]
1 => array:11 [
"RoomKey" => "1662477793"
"RoomType" => "Great room"
"ListingId" => "X13464294"
"RoomLevel" => "Main level"
"RoomWidth" => 3.23
"ListingKey" => "29925516"
"RoomLength" => 6.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T21:59:15.17Z"
]
2 => array:11 [
"RoomKey" => "1662477794"
"RoomType" => "Kitchen"
"ListingId" => "X13464294"
"RoomLevel" => "Main level"
"RoomWidth" => 2.34
"ListingKey" => "29925516"
"RoomLength" => 2.26
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T21:59:15.17Z"
]
3 => array:11 [
"RoomKey" => "1662477795"
"RoomType" => "Den"
"ListingId" => "X13464294"
"RoomLevel" => "Main level"
"RoomWidth" => 2.54
"ListingKey" => "29925516"
"RoomLength" => 2.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T21:59:15.17Z"
]
4 => array:11 [
"RoomKey" => "1662477796"
"RoomType" => "Den"
"ListingId" => "X13464294"
"RoomLevel" => "Main level"
"RoomWidth" => 3.07
"ListingKey" => "29925516"
"RoomLength" => 3.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T21:59:15.17Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29925516/336-10-mallard-trail-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 2700
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-18T21:59:15.14Z"
+"ListAgentNationalAssociationId": "1365159"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:23 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29925516_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/3fa5f6e331aef016dd71e0328abf6a3b.webp"
"MediaSize" => 234115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-3fa5f6e331aef016dd71e0328abf6a3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29925516_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/0c07337f0b60a682ef291a79a3106e7d.webp"
"MediaSize" => 138168
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-0c07337f0b60a682ef291a79a3106e7d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29925516_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/a8640932ab99b0a0d7776a41bc1cb74f.webp"
"MediaSize" => 102928
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-a8640932ab99b0a0d7776a41bc1cb74f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29925516_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/56ad60775ddada3afafaa996bb559415.webp"
"MediaSize" => 105918
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-56ad60775ddada3afafaa996bb559415.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29925516_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/61cee23c9a0bb57469655c37929bf8e7.webp"
"MediaSize" => 95365
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-61cee23c9a0bb57469655c37929bf8e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29925516_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/e0374dca20987a6c2a5f1ef08e231549.webp"
"MediaSize" => 100782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-e0374dca20987a6c2a5f1ef08e231549.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29925516_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/388cdf1d926053aca682ee0e0b83d932.webp"
"MediaSize" => 103936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-388cdf1d926053aca682ee0e0b83d932.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29925516_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/c284fa8fe543ef36418fe28cbba01fa7.webp"
"MediaSize" => 96575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-c284fa8fe543ef36418fe28cbba01fa7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29925516_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/2984ac9c649e1ab2b52cc273963db639.webp"
"MediaSize" => 78125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-2984ac9c649e1ab2b52cc273963db639.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29925516_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/86950d79936ac3e759c006ab9ccf8070.webp"
"MediaSize" => 85730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-86950d79936ac3e759c006ab9ccf8070.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29925516_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/30808daad2585bde6d40e200326d93aa.webp"
"MediaSize" => 94637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-30808daad2585bde6d40e200326d93aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29925516_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/0e40cf86aa76606542bce61e871a74ed.webp"
"MediaSize" => 70905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-0e40cf86aa76606542bce61e871a74ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29925516_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/4c47fd59c5fb9b0c34c0284296717470.webp"
"MediaSize" => 91626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-4c47fd59c5fb9b0c34c0284296717470.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29925516_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/8e42594ded800ad84a0826c3f881aac2.webp"
"MediaSize" => 89474
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-8e42594ded800ad84a0826c3f881aac2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29925516_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/ebc5f775476502a28528b2a12bfb9a97.webp"
"MediaSize" => 93828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-ebc5f775476502a28528b2a12bfb9a97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29925516_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/c3c002589fbba305d6f00de7e5da22f0.webp"
"MediaSize" => 98357
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-c3c002589fbba305d6f00de7e5da22f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29925516_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/7481694ba9d08e3cfb3294653b48e4bc.webp"
"MediaSize" => 88445
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-7481694ba9d08e3cfb3294653b48e4bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29925516_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/c81dbe7e48e3cf4549758482eb2dc8cd.webp"
"MediaSize" => 88247
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-c81dbe7e48e3cf4549758482eb2dc8cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29925516_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/61609ae23ab7f6382aa63073ded303d8.webp"
"MediaSize" => 91405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-61609ae23ab7f6382aa63073ded303d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29925516_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/bd63e323f8e276b82eb6024b6fc3932c.webp"
"MediaSize" => 98120
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-bd63e323f8e276b82eb6024b6fc3932c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29925516_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/0f6867042a6e192aa2965762ea70e5be.webp"
"MediaSize" => 91371
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-0f6867042a6e192aa2965762ea70e5be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29925516_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/1de5eaafffa67ce92a68df227039eccb.webp"
"MediaSize" => 94484
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-1de5eaafffa67ce92a68df227039eccb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29925516_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925516/a409e605b23280d4ecc23248a94c17a8.webp"
"MediaSize" => 82152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925516/thumbnail-a409e605b23280d4ecc23248a94c17a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464294"
"ResourceRecordKey" => "29925516"
"ModificationTimestamp" => "2026-06-18T21:59:15.14Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29925516')"
+"ID": "1545508"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25191
+post_id: "1542420"
+post_author: 1
+"ListingKey": "29920334"
+"ListingId": "X13459650"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T05:25:16Z"
+"RFModificationTimestamp": "2026-06-18T07:32:15Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "114 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This beautifully appointed ground-floor condo offers style, comfort, and convenience in one of Waterdown's most sought-after communities.Ideally located within walking distance to shopping, restaurants, parks, and everyday amenities, this home also offers easy access to major highways and public transit, making commuting a breeze.Step inside to discover a bright open-concept layout featuring elegant flooring throughout. The modern kitchen is designed to impress with quartz countertops, stainless steel appliances, an undermount sink, and a peninsula with breakfast bar seating, perfect for casual dining, entertaining, or your morning coffee.The sun-filled living area opens onto a private balcony, providing the perfect space to relax and enjoy the outdoors. The spacious bedroom features floor-to-ceiling windows and a peaceful atmosphere, while the stylish 4-piece bathroom showcases contemporary finishes. In-suite laundry, one owned parking space, and a storage locker add to the everyday convenience.Residents enjoy access to exceptional building amenities, including a fitness centre, party room, rooftop terrace and garden, community BBQ area, bicycle storage, and a welcoming lobby lounge.Just minutes from Burlington's vibrant waterfront, restaurants, and entertainment district, this move-in-ready condo offers an outstanding opportunity to enter the market and enjoy modern condo living in a prime location.Some photos have been virtually staged to illustrate the property's potential layout and use of space. Furnishings and decor shown in these images may not be present at the property. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T07:32:08.554747+00:00"
+"Directions": "Dundas/ Mallard/ Riverwalk"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2011104"
+"ListOfficeKey": "288626"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T05:15:47Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T05:15:47Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"Rooms": array:3 [
0 => array:11 [
"RoomKey" => "1661876127"
"RoomType" => "Living room"
"ListingId" => "X13459650"
"RoomLevel" => "Main level"
"RoomWidth" => 3.48
"ListingKey" => "29920334"
"RoomLength" => 4.67
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T05:15:47.07Z"
]
1 => array:11 [
"RoomKey" => "1661876128"
"RoomType" => "Kitchen"
"ListingId" => "X13459650"
"RoomLevel" => "Main level"
"RoomWidth" => 2.26
"ListingKey" => "29920334"
"RoomLength" => 2.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T05:15:47.07Z"
]
2 => array:11 [
"RoomKey" => "1661876129"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13459650"
"RoomLevel" => "Main level"
"RoomWidth" => 2.67
"ListingKey" => "29920334"
"RoomLength" => 3.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T05:15:47.07Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29920334/114-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 2100
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-18T05:15:47.01Z"
+"ListAgentNationalAssociationId": "1292549"
+"ListOfficeNationalAssociationId": "1370159"
+"Media": array:27 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29920334_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920334/1946cee7b7846ecf460c73817e97edcf.webp"
"MediaSize" => 318597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920334/thumbnail-1946cee7b7846ecf460c73817e97edcf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13459650"
"ResourceRecordKey" => "29920334"
"ModificationTimestamp" => "2026-06-18T05:15:47.02Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29920334_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920334/b216416b0f2bb2cba93dc537d901a572.webp"
"MediaSize" => 224176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920334/thumbnail-b216416b0f2bb2cba93dc537d901a572.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459650"
"ResourceRecordKey" => "29920334"
"ModificationTimestamp" => "2026-06-18T05:15:47.02Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29920334_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920334/ea881c6270c116c54b8530e1d74a3e1f.webp"
"MediaSize" => 263776
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920334/thumbnail-ea881c6270c116c54b8530e1d74a3e1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459650"
"ResourceRecordKey" => "29920334"
"ModificationTimestamp" => "2026-06-18T05:15:47.02Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29920334_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920334/87ae3e5648cf1c31454682bd3a55ca3b.webp"
"MediaSize" => 175022
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920334/thumbnail-87ae3e5648cf1c31454682bd3a55ca3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459650"
"ResourceRecordKey" => "29920334"
"ModificationTimestamp" => "2026-06-18T05:15:47.02Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29920334_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920334/0720b8eeaa6571fe5592073443797762.webp"
"MediaSize" => 194885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920334/thumbnail-0720b8eeaa6571fe5592073443797762.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459650"
"ResourceRecordKey" => "29920334"
"ModificationTimestamp" => "2026-06-18T05:15:47.02Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29920334_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920334/6d375f95864e900405a7a425f967e573.webp"
"MediaSize" => 155264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920334/thumbnail-6d375f95864e900405a7a425f967e573.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459650"
"ResourceRecordKey" => "29920334"
"ModificationTimestamp" => "2026-06-18T05:15:47.02Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29920334_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920334/da20cef81ad2b4e5cbc303b9d4da16dc.webp"
"MediaSize" => 160815
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920334/thumbnail-da20cef81ad2b4e5cbc303b9d4da16dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459650"
"ResourceRecordKey" => "29920334"
"ModificationTimestamp" => "2026-06-18T05:15:47.02Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29920334_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920334/faf39f3504b7172270e35c8aca78a1c7.webp"
"MediaSize" => 128849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920334/thumbnail-faf39f3504b7172270e35c8aca78a1c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459650"
"ResourceRecordKey" => "29920334"
"ModificationTimestamp" => "2026-06-18T05:15:47.02Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29920334_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920334/98fb913a2f911230bd385edff73db527.webp"
"MediaSize" => 122266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920334/thumbnail-98fb913a2f911230bd385edff73db527.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459650"
"ResourceRecordKey" => "29920334"
"ModificationTimestamp" => "2026-06-18T05:15:47.02Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29920334_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920334/0cde6df7fb004ca5b49112abef530414.webp"
"MediaSize" => 209037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920334/thumbnail-0cde6df7fb004ca5b49112abef530414.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459650"
"ResourceRecordKey" => "29920334"
"ModificationTimestamp" => "2026-06-18T05:15:47.02Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29920334_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920334/19c6ae403c09136f53684ba43ee3b5f9.webp"
"MediaSize" => 136773
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920334/thumbnail-19c6ae403c09136f53684ba43ee3b5f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459650"
"ResourceRecordKey" => "29920334"
"ModificationTimestamp" => "2026-06-18T05:15:47.02Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29920334_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920334/0393f7af7674b7816ba79df1f5c7a750.webp"
"MediaSize" => 201665
…9
]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29920334')"
+"ID": "1542420"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25189
+post_id: "1539053"
+post_author: 1
+"ListingKey": "29915901"
+"ListingId": "X13455876"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T16:05:15Z"
+"RFModificationTimestamp": "2026-06-17T16:35:32Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "1102 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.879544
1 => 43.343071
]
+"Latitude": 43.343071
+"Longitude": -79.879544
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to the Trend Community in Waterdown, overlooking the welcoming greenery of North Burlington from the window of your Condo. This Brand New Stunning 2 Beds, 2 Baths 880 sqft unit boasts an abundance of natural light with windows throughout with the amazing views of lush green Waterdown and glimpses of Lake Ontario. Automated Neutrally Colored Blinds compliments windows of the Apartment all through allowing control of how much Natural light is allowed in. The Open concept Kitchen has rich upgraded white cabinets with beautiful quartz countertops and High-end upgraded Stainless steel appliances. The Spacious Primary Bedroom has its own 3 piece Ensuite with stunning glass shower, quartz cabinet top, upgraded ceramic tiles and upgraded under mount sink. Second room is very conveniently sized, Living room and second 4 piece bath are rich with upgraded tiles and Laminate floorings. Your convenience is assured with Ensuite Laundry that has upgraded extra load stacked Washer and Dryer, 1 underground parking spot and 1 spot storage Locker. The Amenities include Fitness Centre, Rooftop Patio, Bike storage, Party room. This amazing unit located in the Waterdown Neighborhood is surrounded by excellent dining options, shopping, schools and parks. Don't miss this great opportunity, it won't last long. This Condo is 5 minutes to reach the Aldershot Go station, 10 minutes to Downtown Burlington, 15 minutes to Downtown Hamilton and 20 minutes to Mississauga. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T16:35:18.173461+00:00"
+"Directions": "Dundas Street East and Mallard"
+"ExteriorFeatures": array:1 [
0 => "Steel"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2109403"
+"ListOfficeKey": "283413"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-17T15:57:54Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T15:57:54Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29915901/1102-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service"
+"GeocodeManualYN": false
+"TotalActualRent": 2600
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-17T15:57:54.32Z"
+"ListAgentNationalAssociationId": "1378246"
+"ListOfficeNationalAssociationId": "1328652"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915901')"
+"ID": "1539053"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25184
+post_id: "1537881"
+post_author: 1
+"ListingKey": "29914095"
+"ListingId": "40840584"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T04:15:05Z"
+"RFModificationTimestamp": "2026-06-17T04:34:57Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 853.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A7"
+"UnparsedAddress": "10 MALLARD Trail Unit# 336, Waterdown, Ontario L8B2A7"
+"Coordinates": array:2 [
0 => -79.8783655
1 => 43.3443806
]
+"Latitude": 43.3443806
+"Longitude": -79.8783655
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning 2 + Den condo built by award winning developer New Horizon Development Group. Featuring in-suite laundry, geo-thermal heating & cooling, storage locker and 1 underground parking space! Many building amenities include a party room, gym, rooftop patios and bike storage. Located in the desirable Waterdown community with extensive dining, shopping, schools, parks and a 5 minute drive to downtown Burlington or the Aldershot GO Station. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Exterior Maintenance"
1 => "Heat"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"CreationDate": "2026-06-17T04:34:52.234535+00:00"
+"Directions": "Dundas St E to Mallard Trail"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:1 [
0 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007461"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-17T04:09:32Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T04:09:32Z"
+"Stories": "1.0"
+"StreetName": "MALLARD"
+"StreetNumber": "10"
+"StreetSuffix": "Trail"
+"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/29914095/10-mallard-trail-unit-336-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2700
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 853
+"OriginalEntryTimestamp": "2026-06-17T04:09:32.59Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1289513"
+"ListOfficeNationalAssociationId": "1344653"
+"Media": array:23 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914095')"
+"ID": "1537881"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23394
+post_id: "1534320"
+post_author: 1
+"ListingKey": "29909864"
+"ListingId": "X13450338"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T20:05:07Z"
+"RFModificationTimestamp": "2026-06-16T20:29:58Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "112 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Experience contemporary living at Trend 3 Condo in the heart of Waterdown East. This beautifully maintained 2-bedroom corner suite offers a bright, open-concept layout designed for both comfort and functionality. Featuring luxury vinyl flooring throughout, the carpet-free interior is complemented by large windows that fill the space with natural light.The modern kitchen is equipped with stainless steel appliances and overlooks the spacious living and dining area, creating an ideal setting for everyday living and entertaining. Step outside to your private balcony and enjoy your own outdoor retreat. The unit also includes a full 4-piece bathroom, in-suite laundry, one parking space, and a storage locker for added convenience.Residents enjoy access to premium amenities, including a fitness centre, stylish party room, rooftop terraces with BBQ areas, bike storage, and visitor parking. Ideally located close to shopping, restaurants, parks, schools, and scenic trails, with quick access to Hwy 403, Hwy 6, and Hwy 407. A fantastic opportunity to enjoy low-maintenance living in one of Waterdown's most desirable condo communities. available as of August 15. * pictures are virtualy stages and when it was vacant. (id:62783)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T16:25:21.273119+00:00"
+"Directions": "Dundas/River Walk"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2028216"
+"ListOfficeKey": "293485"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-16T15:59:55Z"
+"PhotosCount": 10
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T19:56:17Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29909864/112-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "FirstService Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 2450
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-16T15:59:55.24Z"
+"ListAgentNationalAssociationId": "1307458"
+"ListOfficeNationalAssociationId": "1427673"
+"Media": array:10 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909864')"
+"ID": "1534320"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25192
+post_id: "1532829"
+post_author: 1
+"ListingKey": "29907353"
+"ListingId": "X13448186"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T22:55:10Z"
+"RFModificationTimestamp": "2026-06-16T00:45:07Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1X5"
+"UnparsedAddress": "406 HUMPHREY STREET, Hamilton (Waterdown), Ontario L8B1X5"
+"Coordinates": array:2 [
0 => -79.872212
1 => 43.344959
]
+"Latitude": 43.344959
+"Longitude": -79.872212
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Introducing 406 Humphrey Street Corner lot boosting 3125 Sq. Feet, nestled in a coveted neighborhood ren owned for its excellent schools, parks, and community amenities. Natural light streams through the large windows, illuminating the hardwood floors and creating a warm ambiance. The kitchen is a chef's delight, boasting modern appliances, ample counterspace, and sleek cabinetry. From casual breakfasts to elaborate dinners, this culinary haven caters to all your cooking needs. The dining area is perfect for enjoying meals with loved ones or hosting intimate gatherings. The property features four spacious bedrooms, each offering a tranquil retreat. The primary bedroom boasts an ensuite bathroom, providing privacy and convenience. The remaining bedrooms all have their own walk-in closets. 2nd and 3rd bedroom share a Jack n Jill. While forth bedroom has it's own ensuite. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T00:45:04.369529+00:00"
+"Directions": "Dundas East/Mallard/Humphrey"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1886049"
+"ListOfficeKey": "283370"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"LotSizeDimensions": "41.8 x 106 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T22:48:00Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T22:48:00Z"
+"Stories": "2.0"
+"StreetName": "Humphrey"
+"StreetNumber": "406"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29907353/406-humphrey-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 4500
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 41.9
+"OriginalEntryTimestamp": "2026-06-15T22:48:00.76Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1209021"
+"ListOfficeNationalAssociationId": "1328418"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29907353')"
+"ID": "1532829"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25193
+post_id: "1525412"
+post_author: 1
+"ListingKey": "29895188"
+"ListingId": "X13436674"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T18:05:11Z"
+"RFModificationTimestamp": "2026-06-16T18:26:03Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "801 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.879544
1 => 43.343071
]
+"Latitude": 43.343071
+"Longitude": -79.879544
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful condo, +764 sqft with 1 bedroom, 1 large den, 1.5 bathroom, 2 parking spaces and 1 full size storage locker. Unit has an oversized den that could be utilized as office or second bedroom. Spacious and bright unit with 764 sq ft of living space featuring 9 feet ceilings for a luxurious feel. The suite features an open concept kitchen and living room with all new stainless steel appliances, a breakfast bar, in suite laundry, and a spacious and bright primary bedroom. This beautiful condo comes with a state of the art Geothermal Heating and Cooling system which keeps the hydro bills low! Enjoy all of the fabulous amenities that this building has to offer; including party rooms, modern fitness facilities, rooftop patios, and bike storage. Located just 5 min. to Downtown Burlington, the Aldershot GO Station, a great community with fabulous dining, shopping, schools, parks, easy access to highway but nestled amongst parks and nature, green space, and more. Don't miss this great opportunity. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Range"
4 => "Dryer"
5 => "Microwave"
6 => "Water Heater"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:48:42.690420+00:00"
+"Directions": "Waterdown Rd & Dundas St"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2055517"
+"ListOfficeKey": "283559"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Flat site"
1 => "Conservation/green belt"
2 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-12T15:30:32Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T17:58:59Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29895188/801-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1424001"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residentials"
+"CoListAgentKey2": "2073351"
+"CoListOfficeKey": "283559"
+"GeocodeManualYN": false
+"TotalActualRent": 2600
+"BuildingFeatures": array:6 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Recreation Centre"
3 => "Party Room"
4 => "Security/Concierge"
5 => "Visitor Parking"
]
+"CoListOfficeKey2": "283559"
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-12T15:30:31.96Z"
+"ListAgentNationalAssociationId": "1330795"
+"ListOfficeNationalAssociationId": "1331640"
+"CoListAgentNationalAssociationId": "1261055"
+"CoListAgentNationalAssociationId2": "1348519"
+"CoListOfficeNationalAssociationId": "1331640"
+"CoListOfficeNationalAssociationId2": "1331640"
+"Media": array:21 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895188')"
+"ID": "1525412"
}
]
+success: true
+page_size: 9
+page_count: 6
+count: 47
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]