array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29790409 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23472
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23474
+post_id: "1449379"
+post_author: 1
+"ListingKey": "29790409"
+"ListingId": "40832634"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:25:36Z"
+"RFModificationTimestamp": "2026-06-02T16:37:43Z"
+"ListPrice": 38.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 5484.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L9B1Z2"
+"UnparsedAddress": "39 MALLARD Trail Unit# FULL, Waterdown, Ontario L9B1Z2"
+"Coordinates": array:2 [
0 => -79.8771274
1 => 43.343791
]
+"Latitude": 43.343791
+"Longitude": -79.8771274
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "39 Mallard Trail is a new Plaza construction located in heart of the growing neighborhood of Waterdown South. Delivery will be in 12-18 months - so, if you act fast, there is time to request plan changes to customise to your requirements. Permitted uses include clinics (dental, physicians, phiso, pharmacy, etc. ), place of recreation, restaurant, convenience or fast food, financial institutions and more. 13 parking spots available but lots of designated on-street parking in this forward-thinking pedestrian-designed community. Place your business in the middle of Waterdowns best demographics ! TMI estimated at $10.00 psf. Tenant pays separately metered utilities (id:62650)"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Exterior Maintenance"
2 => "Landscaping"
3 => "Property Management"
4 => "Insurance"
]
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-05-22T16:56:43.154171+00:00"
+"Directions": "DUNDAS ST TO MALLARD TRAIL"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1880620"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Visual exposure"
1 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-05-22T15:51:00Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:18:25Z"
+"Stories": "1.0"
+"StreetName": "MALLARD"
+"StreetNumber": "39"
+"StreetSuffix": "Trail"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29790409/39-mallard-trail-unit-full-waterdown"
+"LeaseAmount": 38
+"LeasePerUnit": "square feet"
+"ParkingTotal": 13
+"StructureType": array:1 [
0 => "Retail"
]
+"CoListAgentKey": "2007886"
+"CoListOfficeKey": "55165"
+"GeocodeManualYN": true
+"ZoningDescription": "UC-13"
+"FrontageLengthNumeric": 72.0
+"OriginalEntryTimestamp": "2026-05-22T15:51:00.02Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1206303"
+"ListOfficeNationalAssociationId": "1333115"
+"CoListAgentNationalAssociationId": "1289860"
+"CoListOfficeNationalAssociationId": "1114492"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29790409_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29790409/fb034371eb68003954e84e06396caced.webp"
"MediaSize" => 22269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29790409/thumbnail-fb034371eb68003954e84e06396caced.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40832634"
"ResourceRecordKey" => "29790409"
"ModificationTimestamp" => "2026-05-22T15:51:00.03Z"
]
]
+"DaysOnMarket": 55
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29790409')"
+"ID": "1449379"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 283666" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24907
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24823
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX Escarpment Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-639-7676"
+"OfficeMlsId": "HBRMXESCBU4B"
+"ModificationTimestamp": "2026-06-18T15:38:17Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "283666"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "2180 Itabashi Way Unit 4B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Burlington"
+"OfficePostalCode": "L7M5A"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1333115"
+"OriginalEntryTimestamp": "2018-06-25T18:38:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439661"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "283666"
"SocialMediaUrlOrId" => "https://www.remaxescarpment.com/"
"ModificationTimestamp" => "2026-06-18T14:28:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1064286"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('283666')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1880620" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24851
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29790409'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25180
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29790409' AND OpenHouseDate ge '2026-07-16'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25196
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29790409' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Commercial+Lease' AND geo.distance(Coordinates, POINT(-79.8771274 43.343791)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25249
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25243
+post_id: "1631155"
+post_author: 1
+"ListingKey": "30041845"
+"ListingId": "X13571488"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-16T15:50:06Z"
+"RFModificationTimestamp": "2026-07-16T17:01:48Z"
+"ListPrice": 28.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 865.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "2 - 312 DUNDAS STREET E, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.892442
1 => 43.333498
]
+"Latitude": 43.333498
+"Longitude": -79.892442
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "965 Sqft of Prime Retail Space in the Downtown Core of Waterdown amongst other very successful stores and Cafes. Excellent visibility, signage space and onsite parking. (id:62650)"
+"BusinessType": "Retail and Wholesale"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-07-16T17:01:38.366508+00:00"
+"Directions": "Dundas St E/Main St Waterdown"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1422943"
+"ListOfficeKey": "51454"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-07-16T15:40:32Z"
+"PhotosCount": 5
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-16T15:40:32Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "312"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "11.5"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30041845/2-312-dundas-street-e-hamilton-waterdown-waterdown"
+"LeaseAmount": 28
+"LeasePerUnit": "square feet"
+"CoListAgentKey": "1423524"
+"CoListOfficeKey": "51454"
+"GeocodeManualYN": false
+"ZoningDescription": "Retial/Commercial"
+"OriginalEntryTimestamp": "2026-07-16T15:40:32.34Z"
+"ListAgentNationalAssociationId": "1062332"
+"ListOfficeNationalAssociationId": "1001135"
+"CoListAgentNationalAssociationId": "1062331"
+"CoListOfficeNationalAssociationId": "1001135"
+"Media": array:5 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30041845_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30041845/80951b3609bb53a5b3f767b0bbd05583.webp"
"MediaSize" => 329015
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30041845/thumbnail-80951b3609bb53a5b3f767b0bbd05583.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13571488"
"ResourceRecordKey" => "30041845"
"ModificationTimestamp" => "2026-07-16T15:40:32.34Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30041845_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30041845/b22b4a84194a52dd51cd6202665f9197.webp"
"MediaSize" => 244806
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30041845/thumbnail-b22b4a84194a52dd51cd6202665f9197.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13571488"
"ResourceRecordKey" => "30041845"
"ModificationTimestamp" => "2026-07-16T15:40:32.34Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30041845_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30041845/19d49335741890b9f4ba8901a12fe0af.webp"
"MediaSize" => 449012
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30041845/thumbnail-19d49335741890b9f4ba8901a12fe0af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13571488"
"ResourceRecordKey" => "30041845"
"ModificationTimestamp" => "2026-07-16T15:40:32.34Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30041845_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30041845/6292635d6c88528a2b125355cbeed9db.webp"
"MediaSize" => 382103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30041845/thumbnail-6292635d6c88528a2b125355cbeed9db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13571488"
"ResourceRecordKey" => "30041845"
"ModificationTimestamp" => "2026-07-16T15:40:32.34Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30041845_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30041845/6b8655edcf2b9f47969127a31b6695e7.webp"
"MediaSize" => 51034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30041845/thumbnail-6b8655edcf2b9f47969127a31b6695e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13571488"
"ResourceRecordKey" => "30041845"
"ModificationTimestamp" => "2026-07-16T15:40:32.34Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30041845')"
+"ID": "1631155"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25245
+post_id: "1631297"
+post_author: 1
+"ListingKey": "30041524"
+"ListingId": "X13571136"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-16T16:50:06Z"
+"RFModificationTimestamp": "2026-07-16T16:55:14Z"
+"ListPrice": 37.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 809.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A7"
+"UnparsedAddress": "06 - 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": "Prime Retail/Commercial Unit For Lease At 10 Mallard Trail, Waterdown. Excellent Opportunity To Establish Your Business In The Highly Desirable Trend Living Condos Community. Offering Approximately 809 Sq. Ft., This Bright And Functional Commercial Space Is Suitable For A Variety Of Permitted Uses, Including Medical, Professional Office, Clinic, Dry Cleaning, Service Shop, Hair Salon, Retail, And More. Located Within A 55-Unit Condominium Development, The Property Benefits From Shared Visitor/Commercial Parking Spaces. Ideally Situated With Quick Access To The QEW, Highways 403, 401, And 407, Providing Excellent Connectivity Throughout The GTA. Available Immediately. A Fantastic Opportunity To Grow Your Business In A High-Visibility, Well-Connected Location. (id:62650)"
+"BusinessType": "Retail and Wholesale"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-07-16T16:55:03.405628+00:00"
+"Directions": "Dundas St E / Mallard Tr"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2024040"
+"ListOfficeKey": "275784"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-07-16T15:40:29Z"
+"PhotosCount": 17
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-16T16:40:52Z"
+"StreetName": "Mallard"
+"StreetNumber": "10"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "12"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30041524/06-10-mallard-trail-hamilton-waterdown-waterdown"
+"LeaseAmount": 37
+"LeasePerUnit": "square feet"
+"GeocodeManualYN": false
+"ZoningDescription": "UC-12"
+"OriginalEntryTimestamp": "2026-07-16T15:05:57.81Z"
+"ListAgentNationalAssociationId": "1303771"
+"ListOfficeNationalAssociationId": "1268183"
+"Media": array:17 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30041524_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30041524/afe4313f0626cd226277e575e5aecae1.webp"
"MediaSize" => 269898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30041524/thumbnail-afe4313f0626cd226277e575e5aecae1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13571136"
"ResourceRecordKey" => "30041524"
"ModificationTimestamp" => "2026-07-16T15:05:57.82Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30041524_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30041524/d03d28e84f0aace9deba8db2adebd407.webp"
"MediaSize" => 250296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30041524/thumbnail-d03d28e84f0aace9deba8db2adebd407.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13571136"
"ResourceRecordKey" => "30041524"
"ModificationTimestamp" => "2026-07-16T15:05:57.82Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30041524_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30041524/250129cad1646cb1e208b8b95e6540ed.webp"
"MediaSize" => 249149
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30041524/thumbnail-250129cad1646cb1e208b8b95e6540ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13571136"
"ResourceRecordKey" => "30041524"
"ModificationTimestamp" => "2026-07-16T15:05:57.82Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30041524_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30041524/585773807c2a5387d35778853b9ef0df.webp"
"MediaSize" => 244947
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30041524/thumbnail-585773807c2a5387d35778853b9ef0df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13571136"
"ResourceRecordKey" => "30041524"
"ModificationTimestamp" => "2026-07-16T15:05:57.82Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30041524_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30041524/f70a6b9aca6b2b1cdc3e74a1ac4f9004.webp"
"MediaSize" => 288238
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30041524/thumbnail-f70a6b9aca6b2b1cdc3e74a1ac4f9004.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13571136"
"ResourceRecordKey" => "30041524"
"ModificationTimestamp" => "2026-07-16T15:05:57.82Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30041524_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30041524/b92a39d5ca7773cd658681ba2ec2e951.webp"
"MediaSize" => 253311
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30041524/thumbnail-b92a39d5ca7773cd658681ba2ec2e951.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13571136"
"ResourceRecordKey" => "30041524"
"ModificationTimestamp" => "2026-07-16T15:05:57.82Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30041524_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30041524/6fb16e506ceeb3020e9728460989f2aa.webp"
"MediaSize" => 256901
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30041524/thumbnail-6fb16e506ceeb3020e9728460989f2aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13571136"
"ResourceRecordKey" => "30041524"
"ModificationTimestamp" => "2026-07-16T15:05:57.82Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30041524_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30041524/73eecefcdf1c44cfc1183d84a1e7498f.webp"
"MediaSize" => 274116
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30041524/thumbnail-73eecefcdf1c44cfc1183d84a1e7498f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13571136"
"ResourceRecordKey" => "30041524"
"ModificationTimestamp" => "2026-07-16T15:05:57.82Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30041524_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30041524/198012670dab294eeebee3d177f55ff0.webp"
"MediaSize" => 163453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30041524/thumbnail-198012670dab294eeebee3d177f55ff0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13571136"
"ResourceRecordKey" => "30041524"
"ModificationTimestamp" => "2026-07-16T15:05:57.82Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30041524_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30041524/fdb763f094ad9f530e369be8146168a4.webp"
"MediaSize" => 162593
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30041524/thumbnail-fdb763f094ad9f530e369be8146168a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13571136"
"ResourceRecordKey" => "30041524"
"ModificationTimestamp" => "2026-07-16T15:05:57.82Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30041524_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30041524/fc9fddc5bf9fb08dac9539dd7ef7d4ce.webp"
"MediaSize" => 149496
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30041524/thumbnail-fc9fddc5bf9fb08dac9539dd7ef7d4ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13571136"
"ResourceRecordKey" => "30041524"
"ModificationTimestamp" => "2026-07-16T15:05:57.82Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30041524_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30041524/9821a6eb3866bb11d61c81e2d7652b82.webp"
"MediaSize" => 151588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30041524/thumbnail-9821a6eb3866bb11d61c81e2d7652b82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13571136"
"ResourceRecordKey" => "30041524"
"ModificationTimestamp" => "2026-07-16T15:05:57.82Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30041524_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30041524/a0a56db39031c5cb36ea53edfd5c49cb.webp"
"MediaSize" => 121223
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30041524/thumbnail-a0a56db39031c5cb36ea53edfd5c49cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13571136"
"ResourceRecordKey" => "30041524"
"ModificationTimestamp" => "2026-07-16T15:05:57.82Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30041524_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30041524/cfe0c2a77b5f6e890b4437bdfe8f1f9f.webp"
"MediaSize" => 117329
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30041524/thumbnail-cfe0c2a77b5f6e890b4437bdfe8f1f9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13571136"
"ResourceRecordKey" => "30041524"
"ModificationTimestamp" => "2026-07-16T15:05:57.82Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30041524_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30041524/f58a261a27bdd181bbd94c2617ae45e4.webp"
"MediaSize" => 134366
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30041524/thumbnail-f58a261a27bdd181bbd94c2617ae45e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13571136"
"ResourceRecordKey" => "30041524"
"ModificationTimestamp" => "2026-07-16T15:05:57.82Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30041524_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30041524/efc4e95f408cf8a85f9dcfaf054dccb6.webp"
"MediaSize" => 151664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30041524/thumbnail-efc4e95f408cf8a85f9dcfaf054dccb6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13571136"
"ResourceRecordKey" => "30041524"
"ModificationTimestamp" => "2026-07-16T15:05:57.82Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30041524_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30041524/26ce50ccd9631abc3ad9c95880516808.webp"
"MediaSize" => 123203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30041524/thumbnail-26ce50ccd9631abc3ad9c95880516808.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13571136"
"ResourceRecordKey" => "30041524"
"ModificationTimestamp" => "2026-07-16T15:05:57.82Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30041524')"
+"ID": "1631297"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25242
+post_id: "1454249"
+post_author: 1
+"ListingKey": "29794752"
+"ListingId": "X13164616"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-23T00:05:45Z"
+"RFModificationTimestamp": "2026-05-23T00:53:53Z"
+"ListPrice": 40.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 2698.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "1&2 - 39 MALLARD TRAIL, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.877076
1 => 43.344024
]
+"Latitude": 43.344024
+"Longitude": -79.877076
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "39 Mallard Trail is a new Plaza construction located in heart of the growing neighborhood of Waterdown South. Delivery will be in 12-18 months - so, if you act fast, there is time to request plan changes to customise to your requirements. Permitted uses include clinics (dental, physicians, phiso, pharmacy, etc. ), place of recreation, restaurant, convenience or fast food, financial institutions and more. 13 parking spots available but lots of designated on-street parking in this forward-thinking pedestrian-designed community. Place your business in the middle of Waterdowns best demographics ! TMI estimated at $10.00 psf. Tenant pays separately metered utilities. (id:62650)"
+"BusinessType": "Retail and Wholesale"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-05-23T00:53:44.378889+00:00"
+"Directions": "Cross Streets: Valley Trail. ** Directions: South of Dundas, to Mallard Tr."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1953908"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "Unit=71.76 x 135.5 FT"
+"PhotosChangeTimestamp": "2026-05-22T23:59:40Z"
+"PhotosCount": 1
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-22T23:59:40Z"
+"StreetName": "Mallard"
+"StreetNumber": "39"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "10"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29794752/12-39-mallard-trail-hamilton-waterdown-waterdown"
+"LeaseAmount": 40
+"LeasePerUnit": "square feet"
+"ParkingTotal": 13
+"StructureType": array:1 [
0 => "Retail"
]
+"GeocodeManualYN": false
+"ExistingLeaseType": array:1 [
0 => "Net"
]
+"ZoningDescription": "UC-13"
+"FrontageLengthNumeric": 71.9
+"OriginalEntryTimestamp": "2026-05-22T23:42:51.68Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1247055"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29794752_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29794752/0153520b42b7f9191c86b827840691af.webp"
"MediaSize" => 23530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29794752/thumbnail-0153520b42b7f9191c86b827840691af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13164616"
"ResourceRecordKey" => "29794752"
"ModificationTimestamp" => "2026-05-22T23:42:51.68Z"
]
]
+"DaysOnMarket": 55
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29794752')"
+"ID": "1454249"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25246
+post_id: "1454154"
+post_author: 1
+"ListingKey": "29794608"
+"ListingId": "X13164558"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-23T01:50:13Z"
+"RFModificationTimestamp": "2026-05-23T01:52:57Z"
+"ListPrice": 38.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 5484.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "FULL - 39 MALLARD TRAIL, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.877076
1 => 43.344024
]
+"Latitude": 43.344024
+"Longitude": -79.877076
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "39 Mallard Trail is a new Plaza construction located in heart of the growing neighborhood of Waterdown South. Delivery will be in 12-18 months - so, if you act fast, there is time to request plan changes to customise to your requirements. Permitted uses include clinics (dental, physicians, phiso, pharmacy, etc. ), place of recreation, restaurant, convenience or fast food, financial institutions and more. 13 parking spots available but lots of designated on-street parking in this forward-thinking pedestrian-designed community. Place your business in the middle of Waterdowns best demographics ! TMI estimated at $10.00 psf. Tenant pays separately metered utilities (id:62783)"
+"BusinessType": "Retail and Wholesale"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-05-22T23:52:15.697262+00:00"
+"Directions": "Cross Streets: Valley Trail. ** Directions: South of Dundas, to Mallard Tr."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1953908"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "71.76 x 135 FT"
+"PhotosChangeTimestamp": "2026-05-22T23:42:51Z"
+"PhotosCount": 1
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-23T01:42:12Z"
+"StreetName": "Mallard"
+"StreetNumber": "39"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "10"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29794608/full-39-mallard-trail-hamilton-waterdown-waterdown"
+"LeaseAmount": 38
+"LeasePerUnit": "square feet"
+"ParkingTotal": 13
+"StructureType": array:1 [
0 => "Retail"
]
+"GeocodeManualYN": false
+"ExistingLeaseType": array:1 [
0 => "Net"
]
+"ZoningDescription": "UC-13"
+"FrontageLengthNumeric": 71.9
+"OriginalEntryTimestamp": "2026-05-22T23:28:50.99Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1247055"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29794608_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29794608/19e5773d4e6c43460793afa88d99cd80.webp"
"MediaSize" => 23530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29794608/thumbnail-19e5773d4e6c43460793afa88d99cd80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13164558"
"ResourceRecordKey" => "29794608"
"ModificationTimestamp" => "2026-05-22T23:28:51Z"
]
]
+"DaysOnMarket": 55
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29794608')"
+"ID": "1454154"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25244
+post_id: "1454153"
+post_author: 1
+"ListingKey": "29794609"
+"ListingId": "X13164588"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-22T23:50:20Z"
+"RFModificationTimestamp": "2026-05-22T23:52:26Z"
+"ListPrice": 40.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1358.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "4 - 39 MALLARD TRAIL, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.877076
1 => 43.344024
]
+"Latitude": 43.344024
+"Longitude": -79.877076
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "39 Mallard Trail is a new Plaza construction located in heart of the growing neighborhood of Waterdown South. Delivery will be in 12-18 months - so, if you act fast, there is time to request plan changes to customise to your requirements. Permitted uses include clinics (dental, physicians, phiso, pharmacy, etc. ), place of recreation, restaurant, convenience or fast food, financial institutions and more. 13 parking spots available but lots of designated on-street parking in this forward-thinking pedestrian-designed community. Place your business in the middle of Waterdowns best demographics ! TMI estimated at $10.00 psf. Tenant pays separately metered utilities. (id:62650)"
+"BusinessType": "Retail and Wholesale"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-05-22T23:52:15.696724+00:00"
+"Directions": "Cross Streets: Valley Trail. ** Directions: South of Dundas, to Mallard Tr."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1953908"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "71.76 x 135.5 FT"
+"PhotosChangeTimestamp": "2026-05-22T23:42:51Z"
+"PhotosCount": 1
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-22T23:42:51Z"
+"StreetName": "Mallard"
+"StreetNumber": "39"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "10"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29794609/4-39-mallard-trail-hamilton-waterdown-waterdown"
+"LeaseAmount": 40
+"LeasePerUnit": "square feet"
+"GeocodeManualYN": false
+"ExistingLeaseType": array:1 [
0 => "Net"
]
+"ZoningDescription": "UC - 13"
+"FrontageLengthNumeric": 71.9
+"OriginalEntryTimestamp": "2026-05-22T23:28:51.07Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1247055"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29794609_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29794609/0744efce07bf250da7468948741ab964.webp"
"MediaSize" => 23530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29794609/thumbnail-0744efce07bf250da7468948741ab964.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13164588"
"ResourceRecordKey" => "29794609"
"ModificationTimestamp" => "2026-05-22T23:28:51.07Z"
]
]
+"DaysOnMarket": 55
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29794609')"
+"ID": "1454153"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25239
+post_id: "1454155"
+post_author: 1
+"ListingKey": "29794605"
+"ListingId": "X13164528"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-22T23:50:20Z"
+"RFModificationTimestamp": "2026-05-22T23:52:26Z"
+"ListPrice": 40.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 4127.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "1 & 2 & 3 - 39 MALLARD TRAIL, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.8768943
1 => 43.34403
]
+"Latitude": 43.34403
+"Longitude": -79.8768943
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "39 Mallard Trail is a new Plaza construction located in heart of the growing neighborhood of Waterdown South. Delivery will be in 12-18 months - so, if you act fast, there is time to request plan changes to customise to your requirements. Permitted uses include clinics (dental, physicians, phiso, pharmacy, etc. ), place of recreation, restaurant, convenience or fast food, financial institutions and more. 13 parking spots available but lots of designated on-street parking in this forward-thinking pedestrian-designed community. Place your business in the middle of Waterdowns best demographics ! TMI estimated at $10.00 psf. Tenant pays separately metered utilities. (id:62650)"
+"BusinessType": "Retail and Wholesale"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-05-22T23:52:15.587888+00:00"
+"Directions": "Cross Streets: Valley Trail. ** Directions: South of Dundas, to Mallard."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1953908"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "71.76 x 135.5 FT"
+"PhotosChangeTimestamp": "2026-05-22T23:42:51Z"
+"PhotosCount": 1
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-22T23:42:51Z"
+"StreetName": "Mallard"
+"StreetNumber": "39"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "10"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29794605/1-2-3-39-mallard-trail-hamilton-waterdown-waterdown"
+"LeaseAmount": 40
+"LeasePerUnit": "square feet"
+"ParkingTotal": 13
+"GeocodeManualYN": true
+"ExistingLeaseType": array:1 [
0 => "Net"
]
+"ZoningDescription": "UC - 13"
+"FrontageLengthNumeric": 71.9
+"OriginalEntryTimestamp": "2026-05-22T23:28:50.67Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1247055"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29794605_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29794605/15d83f786411615181d174a2c9f439b5.webp"
"MediaSize" => 23530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29794605/thumbnail-15d83f786411615181d174a2c9f439b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13164528"
"ResourceRecordKey" => "29794605"
"ModificationTimestamp" => "2026-05-22T23:28:50.68Z"
]
]
+"DaysOnMarket": 55
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29794605')"
+"ID": "1454155"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "1449381"
+post_author: 1
+"ListingKey": "29790410"
+"ListingId": "40832629"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:25:36Z"
+"RFModificationTimestamp": "2026-06-02T16:37:43Z"
+"ListPrice": 40.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 2698.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L9B1Z2"
+"UnparsedAddress": "39 MALLARD Trail Unit# 1 & 2, Waterdown, Ontario L9B1Z2"
+"Coordinates": array:2 [
0 => -79.8770844
1 => 43.3437716
]
+"Latitude": 43.3437716
+"Longitude": -79.8770844
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "39 Mallard Trail is a new Plaza construction located in heart of the growing neighborhood of Waterdown South. Delivery will be in 12-18 months - so, if you act fast, there is time to request plan changes to customise to your requirements. Permitted uses include clinics (dental, physicians, phiso, pharmacy, etc. ), place of recreation, restaurant, convenience or fast food, financial institutions and more. 13 parking spots available but lots of designated on-street parking in this forward-thinking pedestrian-designed community. Place your business in the middle of Waterdowns best demographics ! TMI estimated at $10.00 psf. Tenant pays separately metered utilities. (id:62650)"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Exterior Maintenance"
2 => "Landscaping"
3 => "Property Management"
4 => "Insurance"
]
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-05-22T16:56:40.260858+00:00"
+"Directions": "DUNDAS ST TO MALLARD TRAIL"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1880620"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Visual exposure"
1 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-05-22T15:51:00Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:18:26Z"
+"Stories": "1.0"
+"StreetName": "MALLARD"
+"StreetNumber": "39"
+"StreetSuffix": "Trail"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29790410/39-mallard-trail-unit-1-2-waterdown"
+"LeaseAmount": 40
+"LeasePerUnit": "square feet"
+"StructureType": array:1 [
0 => "Retail"
]
+"CoListAgentKey": "2007886"
+"CoListOfficeKey": "55165"
+"GeocodeManualYN": true
+"ZoningDescription": "UC-13"
+"FrontageLengthNumeric": 72.0
+"OriginalEntryTimestamp": "2026-05-22T15:51:00.11Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1206303"
+"ListOfficeNationalAssociationId": "1333115"
+"CoListAgentNationalAssociationId": "1289860"
+"CoListOfficeNationalAssociationId": "1114492"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29790410_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29790410/c5e8e3651ac92fdb58ca223276d99c82.webp"
"MediaSize" => 22269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29790410/thumbnail-c5e8e3651ac92fdb58ca223276d99c82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40832629"
"ResourceRecordKey" => "29790410"
"ModificationTimestamp" => "2026-05-22T15:51:00.11Z"
]
]
+"DaysOnMarket": 55
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29790410')"
+"ID": "1449381"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25247
+post_id: "1453144"
+post_author: 1
+"ListingKey": "29790628"
+"ListingId": "40832639"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:25:36Z"
+"RFModificationTimestamp": "2026-06-02T16:37:42Z"
+"ListPrice": 40.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 4127.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "39 MALLARD Trail Unit# 1,2,3, Waterdown, Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.877932
1 => 43.3441734
]
+"Latitude": 43.3441734
+"Longitude": -79.877932
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "39 Mallard Trail is a new Plaza construction located in heart of the growing neighborhood of Waterdown South. Delivery will be in 12-18 months - so, if you act fast, there is time to request plan changes to customise to your requirements. Permitted uses include clinics (dental, physicians, phiso, pharmacy, etc. ), place of recreation, restaurant, convenience or fast food, financial institutions and more. 13 parking spots available but lots of designated on-street parking in this forward-thinking pedestrian-designed community. Place your business in the middle of Waterdowns best demographics ! TMI estimated at $10.00 psf. Tenant pays separately metered utilities. (id:62650)"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Exterior Maintenance"
2 => "Landscaping"
3 => "Property Management"
4 => "Insurance"
]
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-05-22T16:40:21.449093+00:00"
+"Directions": "DUNDAS ST TO MALLARD TRAIL"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1880620"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Visual exposure"
1 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-05-22T16:09:56Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:18:24Z"
+"Stories": "1.0"
+"StreetName": "MALLARD"
+"StreetNumber": "39"
+"StreetSuffix": "Trail"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29790628/39-mallard-trail-unit-123-waterdown"
+"LeaseAmount": 40
+"LeasePerUnit": "square feet"
+"StructureType": array:1 [
0 => "Retail"
]
+"CoListAgentKey": "2007886"
+"CoListOfficeKey": "55165"
+"GeocodeManualYN": true
+"ZoningDescription": "UC-13"
+"FrontageLengthNumeric": 72.0
+"OriginalEntryTimestamp": "2026-05-22T16:09:56.21Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1206303"
+"ListOfficeNationalAssociationId": "1333115"
+"CoListAgentNationalAssociationId": "1289860"
+"CoListOfficeNationalAssociationId": "1114492"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29790628_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29790628/e38a35575a7fe057a5adf7914e3ad26a.webp"
"MediaSize" => 22269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29790628/thumbnail-e38a35575a7fe057a5adf7914e3ad26a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40832639"
"ResourceRecordKey" => "29790628"
"ModificationTimestamp" => "2026-05-22T16:09:56.22Z"
]
]
+"DaysOnMarket": 55
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29790628')"
+"ID": "1453144"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25248
+post_id: "1453143"
+post_author: 1
+"ListingKey": "29790627"
+"ListingId": "40832644"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:25:36Z"
+"RFModificationTimestamp": "2026-06-02T16:37:42Z"
+"ListPrice": 40.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1358.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "39 MALLARD Trail Unit# 4, Waterdown, Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.8772668
1 => 43.3437832
]
+"Latitude": 43.3437832
+"Longitude": -79.8772668
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "39 Mallard Trail is a new Plaza construction located in heart of the growing neighborhood of Waterdown South. Delivery will be in 12-18 months - so, if you act fast, there is time to request plan changes to customise to your requirements. Permitted uses include clinics (dental, physicians, phiso, pharmacy, etc. ), place of recreation, restaurant, convenience or fast food, financial institutions and more. 13 parking spots available but lots of designated on-street parking in this forward-thinking pedestrian-designed community. Place your business in the middle of Waterdowns best demographics ! TMI estimated at $10.00 psf. Tenant pays separately metered utilities. (id:62650)"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Exterior Maintenance"
2 => "Landscaping"
3 => "Property Management"
4 => "Insurance"
]
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-05-22T16:40:19.161521+00:00"
+"Directions": "DUNDAS ST TO MALLARD TRAIL"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1880620"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Visual exposure"
1 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-05-22T16:09:56Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:18:23Z"
+"Stories": "1.0"
+"StreetName": "MALLARD"
+"StreetNumber": "39"
+"StreetSuffix": "Trail"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29790627/39-mallard-trail-unit-4-waterdown"
+"LeaseAmount": 40
+"LeasePerUnit": "square feet"
+"StructureType": array:1 [
0 => "Retail"
]
+"CoListAgentKey": "2007886"
+"CoListOfficeKey": "55165"
+"GeocodeManualYN": true
+"ZoningDescription": "UC-13"
+"FrontageLengthNumeric": 72.0
+"OriginalEntryTimestamp": "2026-05-22T16:09:56.11Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1206303"
+"ListOfficeNationalAssociationId": "1333115"
+"CoListAgentNationalAssociationId": "1289860"
+"CoListOfficeNationalAssociationId": "1114492"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29790627_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29790627/a93ff12b3e2cdcf1b52db0493c7ff757.webp"
"MediaSize" => 22269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29790627/thumbnail-a93ff12b3e2cdcf1b52db0493c7ff757.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40832644"
"ResourceRecordKey" => "29790627"
"ModificationTimestamp" => "2026-05-22T16:09:56.11Z"
]
]
+"DaysOnMarket": 55
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29790627')"
+"ID": "1453143"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 10
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
]