array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 28526972 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23524
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23526
+post_id: "718706"
+post_author: 1
+"ListingKey": "28526972"
+"ListingId": "X12248010"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-08T15:25:15Z"
+"RFModificationTimestamp": "2026-04-08T15:31:57Z"
+"ListPrice": 1750000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 7585.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "22 MILL STREET S, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8911972
1 => 43.3335953
]
+"Latitude": 43.3335953
+"Longitude": -79.8911972
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Heritage-designated mixed-use building in downtown Waterdown. 3 commercial units on main level, 4 residential units above. All tenants in good standing. 22 dedicated on-site parking spaces. Well-maintained by long-term owner with visible pride of ownership. Excellent tenant mix with stable income and minimal turnover. Please do not approach tenants. Showings require a minimum 24-48 hours' notice. (id:62650)"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2025-06-27T05:54:40.006896+00:00"
+"Directions": "Cross Streets: DUNDAS ST. ** Directions: DUNDAS ST - MILL ST - SOUTH."
+"Heating": array:2 [
0 => "Hot water radiator heat"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2080849"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "115.37 x 160.16 FT"
+"ParkingFeatures": array:1 [
0 => "Other"
]
+"PhotosChangeTimestamp": "2025-07-05T13:20:01Z"
+"PhotosCount": 50
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-04-08T15:18:05Z"
+"StreetDirSuffix": "South"
+"StreetName": "Mill"
+"StreetNumber": "22"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "19685.02"
+"VirtualTourURLUnbranded": "https://youriguide.com/22_mill_st_s_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/28526972/22-mill-street-s-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Residential Commercial Mix"
]
+"CoListAgentKey": "2180354"
+"CoListOfficeKey": "269164"
+"GeocodeManualYN": false
+"ZoningDescription": "C5a"
+"FrontageLengthNumeric": 115.4
+"OriginalEntryTimestamp": "2025-06-26T20:56:34.22Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1355767"
+"ListOfficeNationalAssociationId": "1243249"
+"CoListAgentNationalAssociationId": "1430250"
+"CoListOfficeNationalAssociationId": "1243249"
+"Media": array:50 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6074477178"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/36688acec3485436cfc3d6d05cdb70df.webp"
"MediaSize" => 269137
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-36688acec3485436cfc3d6d05cdb70df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:18.64Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6074477184"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/1384e3b848debbeca01fa6f65f8c0a37.webp"
"MediaSize" => 392990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-1384e3b848debbeca01fa6f65f8c0a37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:30.09Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6074477194"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/472079fae05dd66ea472698550e12a09.webp"
"MediaSize" => 332169
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-472079fae05dd66ea472698550e12a09.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:23.18Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6074477204"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/8982dc10ba952c4cfc35ae4525e42a24.webp"
"MediaSize" => 446195
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-8982dc10ba952c4cfc35ae4525e42a24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:31.14Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6074477213"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/57af2c708bbbf0ddb9901f03d78d6fd1.webp"
"MediaSize" => 386275
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-57af2c708bbbf0ddb9901f03d78d6fd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:30.59Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6074477223"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/b317398a58b42ab991d900d5cb3cd0e7.webp"
"MediaSize" => 336264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-b317398a58b42ab991d900d5cb3cd0e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:29.06Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6074477231"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/91c473ee5ab6ce10bc6d679fb02eac71.webp"
"MediaSize" => 285814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-91c473ee5ab6ce10bc6d679fb02eac71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:31.66Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6074477241"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/4dc6fb8685a34d0a7034cae6ec09fd70.webp"
"MediaSize" => 285987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-4dc6fb8685a34d0a7034cae6ec09fd70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:35.13Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6074477250"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/75280c77ca4ec6463c8d20223905b4ea.webp"
"MediaSize" => 238069
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-75280c77ca4ec6463c8d20223905b4ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:26.31Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6074477262"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/69baf864401a8ccec133b97a76d153e0.webp"
"MediaSize" => 263145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-69baf864401a8ccec133b97a76d153e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:22.77Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6074477275"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/fae92bf12a8c91007c69c7d52cfbe6e5.webp"
"MediaSize" => 161021
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-fae92bf12a8c91007c69c7d52cfbe6e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:26.98Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6074477286"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/794240b55dd5804ac7248d6e4b555ab3.webp"
"MediaSize" => 187243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-794240b55dd5804ac7248d6e4b555ab3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:14.43Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6074477299"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/0354dbc155d9ea8a7918cbfb42735723.webp"
"MediaSize" => 151186
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-0354dbc155d9ea8a7918cbfb42735723.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:19.15Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6074477307"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/3f18251fa416313a09ef5699bcedca3d.webp"
"MediaSize" => 146100
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-3f18251fa416313a09ef5699bcedca3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:13.02Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6074477319"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/4f2285971b366f76beb1b05bfd94215d.webp"
"MediaSize" => 175128
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-4f2285971b366f76beb1b05bfd94215d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:16.63Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6074477330"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/16e5caebf2b3d1113ed1fbcc943b164a.webp"
"MediaSize" => 139670
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-16e5caebf2b3d1113ed1fbcc943b164a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:20.45Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6074477340"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/0d6d09fdd1a342f78b440b3f9cf6b957.webp"
"MediaSize" => 147673
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-0d6d09fdd1a342f78b440b3f9cf6b957.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:26.66Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6074477349"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/4ebba6086618b93d51fd4bc1d49a6c80.webp"
"MediaSize" => 205044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-4ebba6086618b93d51fd4bc1d49a6c80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:18.55Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6074477358"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/db8a48cc8450a0d1363963f87a34d885.webp"
"MediaSize" => 142493
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-db8a48cc8450a0d1363963f87a34d885.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:23.69Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6074477367"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/8b22dfbf98e0044ecd3fabe36f90ab22.webp"
"MediaSize" => 136871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-8b22dfbf98e0044ecd3fabe36f90ab22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:32.63Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6074477413"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/72e91a8eb939ecd7dd3f2835f2db9ff5.webp"
"MediaSize" => 292401
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-72e91a8eb939ecd7dd3f2835f2db9ff5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:20.48Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6074477423"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/5fa230bd71b227236671e4d5b6d19f89.webp"
"MediaSize" => 205964
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-5fa230bd71b227236671e4d5b6d19f89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:28.23Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6074477433"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/77ee14841cb0bf688bc94398824c7de2.webp"
"MediaSize" => 308210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-77ee14841cb0bf688bc94398824c7de2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:31.6Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6074477446"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/d4b7f7ab058a7efe732d3b6ba8c5de9a.webp"
"MediaSize" => 289388
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-d4b7f7ab058a7efe732d3b6ba8c5de9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:34.88Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6074477455"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/0d3e93b7e47234f7ef9b91ead53e695b.webp"
"MediaSize" => 207234
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-0d3e93b7e47234f7ef9b91ead53e695b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:20.24Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6074477462"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/e205abc8a53d81017eac410572245170.webp"
"MediaSize" => 245206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-e205abc8a53d81017eac410572245170.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:26.84Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6074477471"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/d9f74d70c185eeab2224ae28a87cb05e.webp"
"MediaSize" => 281430
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-d9f74d70c185eeab2224ae28a87cb05e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:23.11Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6074477478"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/362da9c3d0d502e8f68f6fbc25a8f26b.webp"
"MediaSize" => 278183
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-362da9c3d0d502e8f68f6fbc25a8f26b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:27.85Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6074477485"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/3dd036bafcecbd99f9c53756391980d4.webp"
"MediaSize" => 301413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-3dd036bafcecbd99f9c53756391980d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:23.47Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6074477526"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/74a7dc42070a15b1d4459c635bfd428d.webp"
"MediaSize" => 217412
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-74a7dc42070a15b1d4459c635bfd428d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:29.36Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6074477535"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/83933bb928c37a0e31266af970e612cf.webp"
"MediaSize" => 120238
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-83933bb928c37a0e31266af970e612cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:32.72Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6074477543"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/06097afa29cb6cfb0c7ee562cff063c1.webp"
"MediaSize" => 134236
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-06097afa29cb6cfb0c7ee562cff063c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:35.3Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6074477556"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/7e1553bb35b8e339a7801ff615695d39.webp"
"MediaSize" => 100989
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-7e1553bb35b8e339a7801ff615695d39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:23.13Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6074477565"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/22d8d19f2159b0f09059413d852306ad.webp"
"MediaSize" => 96035
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-22d8d19f2159b0f09059413d852306ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:27.09Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6074477596"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/0cb28ae11e4a8d4167c3fcd55fa20234.webp"
"MediaSize" => 93236
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-0cb28ae11e4a8d4167c3fcd55fa20234.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:22.89Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6074477617"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/e837926212d9e8fd5cc50d45d381505a.webp"
"MediaSize" => 75181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-e837926212d9e8fd5cc50d45d381505a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:23.19Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6074477623"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/f97c76ad9bdaf5de6c71a941cf41e35b.webp"
"MediaSize" => 49079
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-f97c76ad9bdaf5de6c71a941cf41e35b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:29.41Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6074477632"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/df5ef5b2fb711d9b9d726dd51169301f.webp"
"MediaSize" => 269757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-df5ef5b2fb711d9b9d726dd51169301f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:23.2Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6074477638"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/e3e26550ea96bfe55d7c41c5a1f39795.webp"
"MediaSize" => 262980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-e3e26550ea96bfe55d7c41c5a1f39795.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:27.16Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6074477649"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/7b6a74fe9538d0c9ddb27afa55cdf264.webp"
"MediaSize" => 232344
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-7b6a74fe9538d0c9ddb27afa55cdf264.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:34.02Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6074477657"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/110818221a9211c9450dc6378b41699d.webp"
"MediaSize" => 258759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-110818221a9211c9450dc6378b41699d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:20.23Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6074477663"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/4dc1fb7cc5ed1aaf83fc54894105b856.webp"
"MediaSize" => 194122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-4dc1fb7cc5ed1aaf83fc54894105b856.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:23.28Z"
]
42 => array:13 [
"Order" => 42
"MediaKey" => "6074477671"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/fd8e63f5131eaee3be535a6012644196.webp"
"MediaSize" => 296726
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-fd8e63f5131eaee3be535a6012644196.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:26.57Z"
]
43 => array:13 [
"Order" => 43
"MediaKey" => "6074477678"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/c6de6946460ec95b639c44d2692da4ed.webp"
"MediaSize" => 322602
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-c6de6946460ec95b639c44d2692da4ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:28.89Z"
]
44 => array:13 [
"Order" => 44
"MediaKey" => "6074477685"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/80cb23084049544df8ee09d1b61c46b5.webp"
"MediaSize" => 375765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-80cb23084049544df8ee09d1b61c46b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:31.25Z"
]
45 => array:13 [
"Order" => 45
"MediaKey" => "6074477692"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/c78ed72dd4070ca9e0339154a2eb62a8.webp"
"MediaSize" => 106849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-c78ed72dd4070ca9e0339154a2eb62a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:34.48Z"
]
46 => array:13 [
"Order" => 46
"MediaKey" => "6074477702"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/c51b16d84bf073360b0d2463305819be.webp"
"MediaSize" => 133419
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-c51b16d84bf073360b0d2463305819be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:36.31Z"
]
47 => array:13 [
"Order" => 47
"MediaKey" => "6074477707"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/62b7d2d5aaf058bc84328ee11c2e47d2.webp"
"MediaSize" => 98900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-62b7d2d5aaf058bc84328ee11c2e47d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:37.8Z"
]
48 => array:13 [
"Order" => 48
"MediaKey" => "6074477713"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/6853bc18bc203690124b140032bf13be.webp"
"MediaSize" => 84467
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-6853bc18bc203690124b140032bf13be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:23.47Z"
]
49 => array:13 [
"Order" => 49
"MediaKey" => "6074477717"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28526972/e47ff5c7931d79811cb2940f10da1f14.webp"
"MediaSize" => 89627
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28526972/thumbnail-e47ff5c7931d79811cb2940f10da1f14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12248010"
"ResourceRecordKey" => "28526972"
"ModificationTimestamp" => "2025-07-05T12:37:24.99Z"
]
]
+"DaysOnMarket": 391
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('28526972')"
+"ID": "718706"
}
]
+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 269164" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25036
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24980
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "KELLER WILLIAMS EDGE REALTY"
+"OfficeEmail": null
+"OfficePhone": "905-335-8808"
+"OfficeMlsId": "190600"
+"ModificationTimestamp": "2025-03-26T23:00:15Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "269164"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "3185 HARVESTER RD UNIT 1A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "BURLINGTON"
+"OfficePostalCode": "L7N3N"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1243249"
+"OriginalEntryTimestamp": "2012-02-07T02:31:00Z"
+"OfficeFax": "289-288-0550"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "369910"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "269164"
"SocialMediaUrlOrId" => "http://www.kellerwilliamsedge.com/"
"ModificationTimestamp" => "2025-03-26T21:55:00Z"
]
]
+"FranchiseNationalAssociationId": "1230713"
+"OfficeBrokerNationalAssociationId": "1257741"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('269164')"
}
]
+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 2080849" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24974
+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 '28526972'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25378
+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 '28526972' AND OpenHouseDate ge '2026-07-22'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25394
+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 '28526972' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Commercial+Sale' AND geo.distance(Coordinates, POINT(-79.8911972 43.3335953)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25484
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25461
+post_id: "1615701"
+post_author: 1
+"ListingKey": "30016345"
+"ListingId": "X13547532"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-11T20:15:06Z"
+"RFModificationTimestamp": "2026-07-11T20:19:30Z"
+"ListPrice": 235000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1000.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0G8"
+"UnparsedAddress": "UNIT #6, BOX #7 - 80 HAMILTON STREET N, Hamilton (Waterdown), Ontario L8B0G8"
+"Coordinates": array:2 [
0 => -79.898353
1 => 43.333705
]
+"Latitude": 43.333705
+"Longitude": -79.898353
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Well Established Coin Laundromat with Wash & Fold and Dry Cleaning Depot with Many Loyal Customers, Well Maintained Machines, Current Lease till July 2028 with 5 year option, Low Rent, 13 Washers and 16 Dryers, Water Bill Approximately $1,000 p/m, Visits to the business are by appointment only & showings are exclusively for buyers and their agents (id:62650)"
+"BusinessType": "Special Purpose"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-07-10T17:35:41.960302+00:00"
+"Directions": "Cross Streets: Hamilton and Dundas St. ** Directions: Dundas/Hamilton/Cedar."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1418724"
+"ListOfficeKey": "90198"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-07-10T14:10:06Z"
+"PhotosCount": 16
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-11T20:08:40Z"
+"StreetDirSuffix": "North"
+"StreetName": "Hamilton"
+"StreetNumber": "80"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "10152"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30016345/unit-6-box-7-80-hamilton-street-n-hamilton-waterdown-waterdown"
+"GeocodeManualYN": false
+"ZoningDescription": "Commercial"
+"OriginalEntryTimestamp": "2026-07-10T14:10:05.96Z"
+"ListAgentNationalAssociationId": "1289527"
+"ListOfficeNationalAssociationId": "1153615"
+"Media": array:16 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30016345_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30016345/e1d7f7f0372d456f026ec4b8d4a3f38f.webp"
"MediaSize" => 336827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30016345/thumbnail-e1d7f7f0372d456f026ec4b8d4a3f38f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13547532"
"ResourceRecordKey" => "30016345"
"ModificationTimestamp" => "2026-07-10T14:10:05.97Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30016345_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30016345/4f19fd68cbd8387358fc463691a7c3ad.webp"
"MediaSize" => 330152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30016345/thumbnail-4f19fd68cbd8387358fc463691a7c3ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13547532"
"ResourceRecordKey" => "30016345"
"ModificationTimestamp" => "2026-07-10T14:10:05.97Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30016345_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30016345/88d61998f357ef8b3eb20564773f8085.webp"
"MediaSize" => 234408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30016345/thumbnail-88d61998f357ef8b3eb20564773f8085.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13547532"
"ResourceRecordKey" => "30016345"
"ModificationTimestamp" => "2026-07-10T14:10:05.97Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30016345_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30016345/5e327e56504c22ff025bc6183dc162a4.webp"
"MediaSize" => 264598
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30016345/thumbnail-5e327e56504c22ff025bc6183dc162a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13547532"
"ResourceRecordKey" => "30016345"
"ModificationTimestamp" => "2026-07-10T14:10:05.97Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30016345_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30016345/aeac61f34508062c5e55fbf4df033908.webp"
"MediaSize" => 263901
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30016345/thumbnail-aeac61f34508062c5e55fbf4df033908.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13547532"
"ResourceRecordKey" => "30016345"
"ModificationTimestamp" => "2026-07-10T14:10:05.97Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30016345_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30016345/53324f9e37187b98327b8af6356ea21d.webp"
"MediaSize" => 249654
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30016345/thumbnail-53324f9e37187b98327b8af6356ea21d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13547532"
"ResourceRecordKey" => "30016345"
"ModificationTimestamp" => "2026-07-10T14:10:05.97Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30016345_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30016345/44bd82e7bc7d622cfeb6929b2fce05fd.webp"
"MediaSize" => 222841
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30016345/thumbnail-44bd82e7bc7d622cfeb6929b2fce05fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13547532"
"ResourceRecordKey" => "30016345"
"ModificationTimestamp" => "2026-07-10T14:10:05.97Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30016345_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30016345/6def35bdfa508263f5f940ed46845f1b.webp"
"MediaSize" => 238293
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30016345/thumbnail-6def35bdfa508263f5f940ed46845f1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13547532"
"ResourceRecordKey" => "30016345"
"ModificationTimestamp" => "2026-07-10T14:10:05.97Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30016345_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30016345/84eb107d89754303dde3a7736c7bbfd8.webp"
"MediaSize" => 198055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30016345/thumbnail-84eb107d89754303dde3a7736c7bbfd8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13547532"
"ResourceRecordKey" => "30016345"
"ModificationTimestamp" => "2026-07-10T14:10:05.97Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30016345_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30016345/0e17bc7cfd3052e31924fe16f67ecbdb.webp"
"MediaSize" => 225433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30016345/thumbnail-0e17bc7cfd3052e31924fe16f67ecbdb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13547532"
"ResourceRecordKey" => "30016345"
"ModificationTimestamp" => "2026-07-10T14:10:05.97Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30016345_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30016345/100fe8c10848b399b8a3845efee495c8.webp"
"MediaSize" => 260702
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30016345/thumbnail-100fe8c10848b399b8a3845efee495c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13547532"
"ResourceRecordKey" => "30016345"
"ModificationTimestamp" => "2026-07-10T14:10:05.97Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30016345_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30016345/a8b0d3f7da2e3b5941cee9972609cf3d.webp"
"MediaSize" => 247057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30016345/thumbnail-a8b0d3f7da2e3b5941cee9972609cf3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13547532"
"ResourceRecordKey" => "30016345"
"ModificationTimestamp" => "2026-07-10T14:10:05.97Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30016345_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30016345/69328d93187dc992ba502ca124a88b29.webp"
"MediaSize" => 198398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30016345/thumbnail-69328d93187dc992ba502ca124a88b29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13547532"
"ResourceRecordKey" => "30016345"
"ModificationTimestamp" => "2026-07-10T14:10:05.97Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30016345_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30016345/fa6b41b33dcefb1fa247622ce9327bbf.webp"
"MediaSize" => 274529
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30016345/thumbnail-fa6b41b33dcefb1fa247622ce9327bbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13547532"
"ResourceRecordKey" => "30016345"
"ModificationTimestamp" => "2026-07-10T14:10:05.97Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30016345_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30016345/b32c8d3d498289043f83d36118a18231.webp"
"MediaSize" => 230963
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30016345/thumbnail-b32c8d3d498289043f83d36118a18231.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13547532"
"ResourceRecordKey" => "30016345"
"ModificationTimestamp" => "2026-07-10T14:10:05.97Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30016345_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30016345/adcf3064989e601e559e3b19e9f27e78.webp"
"MediaSize" => 359804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30016345/thumbnail-adcf3064989e601e559e3b19e9f27e78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13547532"
"ResourceRecordKey" => "30016345"
"ModificationTimestamp" => "2026-07-10T14:10:05.97Z"
]
]
+"DaysOnMarket": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30016345')"
+"ID": "1615701"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25463
+post_id: "1599636"
+post_author: 1
+"ListingKey": "29999784"
+"ListingId": "X13532496"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T22:20:09Z"
+"RFModificationTimestamp": "2026-07-07T22:23:42Z"
+"ListPrice": 130000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 5045.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0E5"
+"UnparsedAddress": "2C - 255 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B0E5"
+"Coordinates": array:2 [
0 => -79.89711
1 => 43.330215
]
+"Latitude": 43.330215
+"Longitude": -79.89711
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Excellent Opportunity to Own a Turnkey Franchise Great Canadian Dollar Store. With over 10 years of successful operation in a busy mixed residential and commercial neighbourhood. This well-established Great Canadian Dollar Store offers strong revenue, low operating expenses, and excellent income potential, making it an ideal opportunity for an owner-operator or family-run business. The store is fully stocked with everyday essentials, household items, snacks, party supplies, balloons, seasonal merchandise, and other high-demand products. Located in a high-traffic plaza anchored by Tim Hortons, Freshco, banks, and other popular retailers, it benefits from excellent visibility, steady customer traffic, and ample parking. Don't miss this rare opportunity to acquire a profitable ,well-established, and easy-to-manage retail business with a loyal customer base, low overhead, and excellent potential for future growth. (id:62650)"
+"BuildingAreaUnits": "square feet"
+"BusinessType": "Retail and Wholesale"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-07-07T17:09:17.640867+00:00"
+"Directions": "Dundas St & Hamilton St."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1833958"
+"ListOfficeKey": "285271"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-07-07T16:40:47Z"
+"PhotosCount": 22
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T22:08:55Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "255"
+"StreetSuffix": "Street"
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29999784/2c-255-dundas-street-e-hamilton-waterdown-waterdown"
+"GeocodeManualYN": false
+"ZoningDescription": "C5"
+"OriginalEntryTimestamp": "2026-07-07T16:40:47.55Z"
+"ListAgentNationalAssociationId": "1196555"
+"ListOfficeNationalAssociationId": "1349718"
+"Media": array:22 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29999784_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999784/7da7413562c47ecc8c357e223bc551f5.webp"
"MediaSize" => 266469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999784/thumbnail-7da7413562c47ecc8c357e223bc551f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13532496"
"ResourceRecordKey" => "29999784"
"ModificationTimestamp" => "2026-07-07T16:40:47.55Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29999784_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999784/edd151f12cf82a4fd5b050e78dee1209.webp"
"MediaSize" => 227221
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999784/thumbnail-edd151f12cf82a4fd5b050e78dee1209.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532496"
"ResourceRecordKey" => "29999784"
"ModificationTimestamp" => "2026-07-07T16:40:47.55Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29999784_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999784/6e94e041043c54500794b3ef7541ed4a.webp"
"MediaSize" => 205618
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999784/thumbnail-6e94e041043c54500794b3ef7541ed4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532496"
"ResourceRecordKey" => "29999784"
"ModificationTimestamp" => "2026-07-07T16:40:47.55Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29999784_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999784/fa23fda051fbd4545d1b7b5726ea048f.webp"
"MediaSize" => 224165
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999784/thumbnail-fa23fda051fbd4545d1b7b5726ea048f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532496"
"ResourceRecordKey" => "29999784"
"ModificationTimestamp" => "2026-07-07T16:40:47.55Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29999784_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999784/023c8fc74ab8abab35405589f3e07efb.webp"
"MediaSize" => 230978
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999784/thumbnail-023c8fc74ab8abab35405589f3e07efb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532496"
"ResourceRecordKey" => "29999784"
"ModificationTimestamp" => "2026-07-07T16:40:47.55Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29999784_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999784/f5920ed8bd773d91a3e5059df4978752.webp"
"MediaSize" => 220650
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999784/thumbnail-f5920ed8bd773d91a3e5059df4978752.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532496"
"ResourceRecordKey" => "29999784"
"ModificationTimestamp" => "2026-07-07T16:40:47.55Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29999784_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999784/575f894b0bbfb493054637be8d8e9dcf.webp"
"MediaSize" => 220260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999784/thumbnail-575f894b0bbfb493054637be8d8e9dcf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532496"
"ResourceRecordKey" => "29999784"
"ModificationTimestamp" => "2026-07-07T16:40:47.55Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29999784_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999784/f5a9b46ebd03b8c21530f1523983f300.webp"
"MediaSize" => 414267
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999784/thumbnail-f5a9b46ebd03b8c21530f1523983f300.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532496"
"ResourceRecordKey" => "29999784"
"ModificationTimestamp" => "2026-07-07T16:40:47.55Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29999784_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999784/136d4a342c445233bee7c92a93249014.webp"
"MediaSize" => 202916
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999784/thumbnail-136d4a342c445233bee7c92a93249014.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532496"
"ResourceRecordKey" => "29999784"
"ModificationTimestamp" => "2026-07-07T16:40:47.55Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29999784_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999784/161fb40a670bf4903d8ee307a8aa00ec.webp"
"MediaSize" => 218083
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999784/thumbnail-161fb40a670bf4903d8ee307a8aa00ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532496"
"ResourceRecordKey" => "29999784"
"ModificationTimestamp" => "2026-07-07T16:40:47.55Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29999784_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999784/4eee053d658ebf70f7809d42f5f06d24.webp"
"MediaSize" => 204611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999784/thumbnail-4eee053d658ebf70f7809d42f5f06d24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532496"
"ResourceRecordKey" => "29999784"
"ModificationTimestamp" => "2026-07-07T16:40:47.55Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29999784_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999784/556313a5251aa1e82ab5cd1ae018a32d.webp"
"MediaSize" => 362773
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999784/thumbnail-556313a5251aa1e82ab5cd1ae018a32d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532496"
"ResourceRecordKey" => "29999784"
"ModificationTimestamp" => "2026-07-07T16:40:47.55Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29999784_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999784/77d0ec46bdc2142d95f29883c49af2bd.webp"
"MediaSize" => 230258
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999784/thumbnail-77d0ec46bdc2142d95f29883c49af2bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532496"
"ResourceRecordKey" => "29999784"
"ModificationTimestamp" => "2026-07-07T16:40:47.55Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29999784_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999784/d63608d1031f7189369c7fbb2e7d8df0.webp"
"MediaSize" => 236269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999784/thumbnail-d63608d1031f7189369c7fbb2e7d8df0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532496"
"ResourceRecordKey" => "29999784"
"ModificationTimestamp" => "2026-07-07T16:40:47.55Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29999784_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999784/1de4fa71699abcefbede9336719c2e27.webp"
"MediaSize" => 365782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999784/thumbnail-1de4fa71699abcefbede9336719c2e27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532496"
"ResourceRecordKey" => "29999784"
"ModificationTimestamp" => "2026-07-07T16:40:47.55Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29999784_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999784/726c8252295a21fed68dec30e3d6a12a.webp"
"MediaSize" => 358605
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999784/thumbnail-726c8252295a21fed68dec30e3d6a12a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532496"
"ResourceRecordKey" => "29999784"
"ModificationTimestamp" => "2026-07-07T16:40:47.55Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29999784_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999784/2d46d06d2b25b48026e08164aaf198b5.webp"
"MediaSize" => 463271
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999784/thumbnail-2d46d06d2b25b48026e08164aaf198b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532496"
"ResourceRecordKey" => "29999784"
"ModificationTimestamp" => "2026-07-07T16:40:47.55Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29999784_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999784/af05b1d8872b5c987b63bb32b561c55c.webp"
"MediaSize" => 421204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999784/thumbnail-af05b1d8872b5c987b63bb32b561c55c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532496"
"ResourceRecordKey" => "29999784"
"ModificationTimestamp" => "2026-07-07T16:40:47.55Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29999784_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999784/31af47c717d052552022f9062d1d3d1e.webp"
"MediaSize" => 197465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999784/thumbnail-31af47c717d052552022f9062d1d3d1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532496"
"ResourceRecordKey" => "29999784"
"ModificationTimestamp" => "2026-07-07T16:40:47.55Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29999784_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999784/69076e4a3d80956f5cf66c9ab3462907.webp"
"MediaSize" => 178061
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999784/thumbnail-69076e4a3d80956f5cf66c9ab3462907.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532496"
"ResourceRecordKey" => "29999784"
"ModificationTimestamp" => "2026-07-07T16:40:47.55Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29999784_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999784/78e2aec6deac0356467a79266a7f3de4.webp"
"MediaSize" => 293502
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999784/thumbnail-78e2aec6deac0356467a79266a7f3de4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532496"
"ResourceRecordKey" => "29999784"
"ModificationTimestamp" => "2026-07-07T16:40:47.55Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29999784_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999784/d3fc14e5db496f90e9ad781978c95c05.webp"
"MediaSize" => 589959
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999784/thumbnail-d3fc14e5db496f90e9ad781978c95c05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532496"
"ResourceRecordKey" => "29999784"
"ModificationTimestamp" => "2026-07-07T16:40:47.55Z"
]
]
+"DaysOnMarket": 15
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29999784')"
+"ID": "1599636"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25460
+post_id: "1524476"
+post_author: 1
+"ListingKey": "29894529"
+"ListingId": "40839275"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:50:10Z"
+"RFModificationTimestamp": "2026-06-16T17:11:34Z"
+"ListPrice": 4750000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 10968.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1X3"
+"UnparsedAddress": "39 MALLARD Trail Unit# 2nd, Waterdown, Ontario L8B1X3"
+"Coordinates": array:2 [
0 => -79.8768347
1 => 43.3440558
]
+"Latitude": 43.3440558
+"Longitude": -79.8768347
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Brand New 2-storey, 11000+/- Sq Ft Retail or Medical Plaza Build with Delivery in 15 months +/-. Located is in the heart of Waterdown's fastest growing new neighbourhood. Unit sizes range from 1,000 SF to 5,484 SF. Permitted uses include dental offices, clinics, daycare centres, animal hospitals, recreational uses, restaurants, financial institutions and more. The project is directly across from The Trend condo development bringing thousands of new residents to the area. (id:62650)"
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-06-12T20:09:20.791502+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:1 [
0 => "Visual exposure"
]
+"PhotosChangeTimestamp": "2026-06-16T16:43:01Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T16:43:01Z"
+"Stories": "2.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/29894529/39-mallard-trail-unit-2nd-waterdown"
+"StructureType": array:1 [
0 => "Retail"
]
+"CoListAgentKey": "2007886"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2258783"
+"CoListOfficeKey": "55165"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "55165"
+"ZoningDescription": "UC-13"
+"FrontageLengthNumeric": 72.0
+"OriginalEntryTimestamp": "2026-06-12T14:20:17.3Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1206303"
+"ListOfficeNationalAssociationId": "1333115"
+"CoListAgentNationalAssociationId": "1289860"
+"CoListAgentNationalAssociationId2": "1498689"
+"CoListOfficeNationalAssociationId": "1114492"
+"CoListOfficeNationalAssociationId2": "1114492"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29894529_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894529/3d517675aa3aa84d93530f1819981943.webp"
"MediaSize" => 68680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894529/thumbnail-3d517675aa3aa84d93530f1819981943.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839275"
"ResourceRecordKey" => "29894529"
"ModificationTimestamp" => "2026-06-12T14:20:17.32Z"
]
]
+"DaysOnMarket": 40
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29894529')"
+"ID": "1524476"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25464
+post_id: "1527575"
+post_author: 1
+"ListingKey": "29895447"
+"ListingId": "X13437136"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T16:05:19Z"
+"RFModificationTimestamp": "2026-06-12T16:22:36Z"
+"ListPrice": 4750000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 10968.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1X3"
+"UnparsedAddress": "2ND - 39 MALLARD TRAIL, Hamilton (Waterdown), Ontario L8B1X3"
+"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": "Brand New 2-storey, 11000+/- Sq Ft Retail or Medical Plaza Build with Delivery in 15 months +/-. Located is in the heart of Waterdown's fastest growing new neighbourhood. Unit sizes range from 1,000 SF to 5,484 SF. Permitted uses include dental offices, clinics, daycare centres, animal hospitals, recreational uses, restaurants, financial institutions and more. The project is directly across from The Trend condo development bringing thousands of new residents to the area. (id:62783)"
+"BusinessType": "Retail and Wholesale"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-06-12T16:22:30.100450+00:00"
+"Directions": "Cross Streets: Valley Trail. ** Directions: South of Dundas, to Mallard Trail."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1953908"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "71.76 x 135.5 FT"
+"PhotosChangeTimestamp": "2026-06-12T15:55:47Z"
+"PhotosCount": 1
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T15:55:47Z"
+"StreetName": "Mallard"
+"StreetNumber": "39"
+"StreetSuffix": "Trail"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29895447/2nd-39-mallard-trail-hamilton-waterdown-waterdown"
+"GeocodeManualYN": false
+"ZoningDescription": "UC-13"
+"FrontageLengthNumeric": 71.9
+"OriginalEntryTimestamp": "2026-06-12T15:55:47.82Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1247055"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29895447_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895447/f787ad76d825066bcad19f1e0a4cf8ef.webp"
"MediaSize" => 167103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895447/thumbnail-f787ad76d825066bcad19f1e0a4cf8ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13437136"
"ResourceRecordKey" => "29895447"
"ModificationTimestamp" => "2026-06-12T15:55:47.82Z"
]
]
+"DaysOnMarket": 40
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895447')"
+"ID": "1527575"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25462
+post_id: "1471334"
+post_author: 1
+"ListingKey": "29820828"
+"ListingId": "X13210704"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-28T21:00:45Z"
+"RFModificationTimestamp": "2026-05-28T22:55:31Z"
+"ListPrice": 249000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1300.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A4"
+"UnparsedAddress": "255 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A4"
+"Coordinates": array:2 [
0 => -79.89711
1 => 43.330215
]
+"Latitude": 43.330215
+"Longitude": -79.89711
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "BAR BURRITO Business in Waterdown, ON is For Sale. Located at the busy intersection of Dundas St E/Hamilton St N. Surrounded by Fully Residential Neighbourhood, Close to Schools, Offices, Banks, Major Big Box Store and Much More. Business with so much opportunity to grow the business even more. Rent: $5420/m including TMI & HST, Lease Term: Existing 7 years + Option to renew, Royalty: 5%, Advertising: 2%. (id:62783)"
+"BusinessType": "Restaurant"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-05-28T22:55:19.263016+00:00"
+"Directions": "Cross Streets: Dundas St E/Hamilton St N. ** Directions: Turn right on Dundas St E."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1964360"
+"ListOfficeKey": "269129"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-05-28T20:53:56Z"
+"PhotosCount": 1
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-28T20:53:56Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "255"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29820828/255-dundas-street-e-hamilton-waterdown-waterdown"
+"CoListAgentKey": "2196919"
+"CoListOfficeKey": "146431"
+"GeocodeManualYN": false
+"ZoningDescription": "C5"
+"OriginalEntryTimestamp": "2026-05-28T20:53:56.49Z"
+"ListAgentNationalAssociationId": "1253104"
+"ListOfficeNationalAssociationId": "1231804"
+"CoListAgentNationalAssociationId": "1445459"
+"CoListOfficeNationalAssociationId": "1201577"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29820828_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820828/419500f486abca0d0c720eb7cc7bc15d.webp"
"MediaSize" => 13471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820828/thumbnail-419500f486abca0d0c720eb7cc7bc15d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13210704"
"ResourceRecordKey" => "29820828"
"ModificationTimestamp" => "2026-05-28T20:53:56.5Z"
]
]
+"DaysOnMarket": 55
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29820828')"
+"ID": "1471334"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25457
+post_id: "1430824"
+post_author: 1
+"ListingKey": "29761350"
+"ListingId": "X13135788"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-15T20:01:04Z"
+"RFModificationTimestamp": "2026-05-15T22:58:04Z"
+"ListPrice": 3499900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 5484.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1X3"
+"UnparsedAddress": "39 MALLARD TRAIL, Hamilton (Waterdown), Ontario L8B1X3"
+"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": "Brand New Retail or Medical Plaza Build with Delivery in 12 months +/-. Located is in the heart of Waterdown's fastest growing new neighbourhood. Unit sizes range from 1,318 SF to 5,484 SF. Permitted uses include dental offices, clinics, daycare centres, animal hospitals, recreational uses, restaurants, financial institutions and more. The project is directly across from The Trend condo development bringing thousands of new residents to the area. Need more space?!?, the final construction may allow for a second storey to be added. (id:62650)"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-05-15T22:57:56.526866+00:00"
+"Directions": "Cross Streets: Valley Trail. ** Directions: South of Dundas, to Mallard Trail."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1953908"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "71.76 x 135.5 FT"
+"PhotosChangeTimestamp": "2026-05-15T19:53:39Z"
+"PhotosCount": 1
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-15T19:53:39Z"
+"StreetName": "Mallard"
+"StreetNumber": "39"
+"StreetSuffix": "Trail"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29761350/39-mallard-trail-hamilton-waterdown-waterdown"
+"GeocodeManualYN": false
+"ZoningDescription": "UC-13"
+"FrontageLengthNumeric": 71.9
+"OriginalEntryTimestamp": "2026-05-15T19:53:39.06Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1247055"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29761350_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29761350/50fcdc666d807f50c7ce61c807f4598d.webp"
"MediaSize" => 23530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29761350/thumbnail-50fcdc666d807f50c7ce61c807f4598d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13135788"
"ResourceRecordKey" => "29761350"
"ModificationTimestamp" => "2026-05-15T19:53:39.07Z"
]
]
+"DaysOnMarket": 68
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29761350')"
+"ID": "1430824"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23538
+post_id: "1427206"
+post_author: 1
+"ListingKey": "29759466"
+"ListingId": "40830629"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:30:15Z"
+"RFModificationTimestamp": "2026-06-02T16:33:46Z"
+"ListPrice": 3499900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 5484.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1X3"
+"UnparsedAddress": "39 MALLARD Trail, Waterdown, Ontario L8B1X3"
+"Coordinates": array:2 [
0 => -79.8768458
1 => 43.3440478
]
+"Latitude": 43.3440478
+"Longitude": -79.8768458
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Brand New Retail or Medical Plaza Build with Delivery in 12 months +/-. Located is in the heart of Waterdown's fastest growing new neighbourhood. Unit sizes range from 1,318 SF to 5,484 SF. Permitted uses include dental offices, clinics, daycare centres, animal hospitals, recreational uses, restaurants, financial institutions and more. The project is directly across from The Trend condo development bringing thousands of new residents to the area. Need more space?!?, the final construction may allow for a second storey to be added. Reach out now (before the shovel is in the ground) to understand all the possibilities available to qualified buyers. (id:62650)"
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-05-15T20:51:04.236969+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:1 [
0 => "Visual exposure"
]
+"PhotosChangeTimestamp": "2026-05-15T16:50:51Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:23: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/29759466/39-mallard-trail-waterdown"
+"StructureType": array:1 [
0 => "Commercial Apartment"
]
+"CoListAgentKey": "2007886"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55165"
+"GeocodeManualYN": true
+"ZoningDescription": "UC-13"
+"FrontageLengthNumeric": 72.0
+"OriginalEntryTimestamp": "2026-05-15T16:50:51.12Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1206303"
+"ListOfficeNationalAssociationId": "1333115"
+"CoListAgentNationalAssociationId": "1289860"
+"CoListOfficeNationalAssociationId": "1114492"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29759466_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29759466/772d60ada406a323828a60c62783e990.webp"
"MediaSize" => 22269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29759466/thumbnail-772d60ada406a323828a60c62783e990.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40830629"
"ResourceRecordKey" => "29759466"
"ModificationTimestamp" => "2026-05-15T16:50:51.14Z"
]
]
+"DaysOnMarket": 68
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29759466')"
+"ID": "1427206"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25482
+post_id: "1344349"
+post_author: 1
+"ListingKey": "29642054"
+"ListingId": "X13031460"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-22T19:05:58Z"
+"RFModificationTimestamp": "2026-04-22T19:48:25Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 871.0
+"LivingArea": 871.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "9 MAIN STREET N, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8934625
1 => 43.3336996
]
+"Latitude": 43.3336996
+"Longitude": -79.8934625
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Prime owner-user opportunity in the heart of Waterdown's growing commercial corridor. 9 Main St N offers a well-maintained, turnkey retail/restaurant building with a stable in-place tenant (The Shawarma House - business available separately), providing flexibility for investors or future owner-occupiers. The property has benefited from meaningful capital improvements, including updated ventilation (2019), roof replacement (approx. 2017), interior renovations (2019), and a new air conditioning unit (2025), reducing near-term capital risk. Positioned on Main Street North with strong visibility, consistent traffic, and surrounded by ongoing residential growth, this asset offers long-term upside through both occupancy and rental growth. Ideal for restaurateurs, service-based users, or investors seeking a foothold in one of Waterdown's most active and evolving nodes. (id:62650)"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-04-22T19:48:15.553203+00:00"
+"Directions": "Cross Streets: Main St and Dundas St E. ** Directions: Dundas to Main St."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1422448"
+"ListOfficeKey": "269020"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "871"
+"PhotosChangeTimestamp": "2026-04-22T18:48:45Z"
+"PhotosCount": 6
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-04-22T18:48:45Z"
+"StreetDirSuffix": "North"
+"StreetName": "Main"
+"StreetNumber": "9"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7362"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29642054/9-main-street-n-hamilton-waterdown-waterdown"
+"CoListAgentKey": "2140403"
+"CoListOfficeKey": "269020"
+"GeocodeManualYN": true
+"ZoningDescription": "C5a - Exception 752, 753"
+"FrontageLengthNumeric": 35.0
+"OriginalEntryTimestamp": "2026-04-22T18:48:45.24Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1122944"
+"ListOfficeNationalAssociationId": "1231482"
+"CoListAgentNationalAssociationId": "1392266"
+"CoListOfficeNationalAssociationId": "1231482"
+"Media": array:6 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6620191456"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29642054/e09a48992b80f9e9e9a8c3d5503ddddf.webp"
"MediaSize" => 325006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29642054/thumbnail-e09a48992b80f9e9e9a8c3d5503ddddf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13031460"
"ResourceRecordKey" => "29642054"
"ModificationTimestamp" => "2026-04-22T18:48:45.25Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6620191471"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29642054/a4fb5696f004d0a6de51889469bf4aeb.webp"
"MediaSize" => 306210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29642054/thumbnail-a4fb5696f004d0a6de51889469bf4aeb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13031460"
"ResourceRecordKey" => "29642054"
"ModificationTimestamp" => "2026-04-22T18:48:45.25Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6620191544"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29642054/48449277bfd2a745b1e40638a29a3def.webp"
"MediaSize" => 341720
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29642054/thumbnail-48449277bfd2a745b1e40638a29a3def.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13031460"
"ResourceRecordKey" => "29642054"
"ModificationTimestamp" => "2026-04-22T18:48:45.25Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6620191606"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29642054/6f756cf634dd83ea3359c41c6daf74b0.webp"
"MediaSize" => 354595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29642054/thumbnail-6f756cf634dd83ea3359c41c6daf74b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13031460"
"ResourceRecordKey" => "29642054"
"ModificationTimestamp" => "2026-04-22T18:48:45.25Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6620191683"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29642054/a127a8db036e335c4967c068edf8df29.webp"
"MediaSize" => 352907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29642054/thumbnail-a127a8db036e335c4967c068edf8df29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13031460"
"ResourceRecordKey" => "29642054"
"ModificationTimestamp" => "2026-04-22T18:48:45.25Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6620191752"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29642054/125a9c96b82df72b5635b501ec7b61e5.webp"
"MediaSize" => 357645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29642054/thumbnail-125a9c96b82df72b5635b501ec7b61e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13031460"
"ResourceRecordKey" => "29642054"
"ModificationTimestamp" => "2026-04-22T18:48:45.25Z"
]
]
+"DaysOnMarket": 91
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29642054')"
+"ID": "1344349"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25483
+post_id: "1343973"
+post_author: 1
+"ListingKey": "29641444"
+"ListingId": "40822749"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:56:40Z"
+"RFModificationTimestamp": "2026-06-02T17:42:44Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0.02
+"LivingArea": 871.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "9 N MAIN Street N, Hamilton, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8936404
1 => 43.3337097
]
+"Latitude": 43.3337097
+"Longitude": -79.8936404
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Prime owner-user opportunity in the heart of Waterdown’s growing commercial corridor. 9 Main St N offers a well-maintained, turnkey retail/restaurant building with a stable in-place tenant (The Shawarma House – business available separately), providing flexibility for investors or future owner-occupiers. The property has benefited from meaningful capital improvements, including updated ventilation (2019), roof replacement (approx. 2017), interior renovations (2019), and a new air conditioning unit (2025), reducing near-term capital risk. Positioned on Main Street North with strong visibility, consistent traffic, and surrounded by ongoing residential growth, this asset offers long-term upside through both occupancy and rental growth. Ideal for restaurateurs, service-based users, or investors seeking a foothold in one of Waterdown’s most active and evolving nodes. (id:62783)"
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-04-22T18:50:24.917454+00:00"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2025166"
+"ListOfficeKey": "55164"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.02"
+"PhotosChangeTimestamp": "2026-04-22T18:00:53Z"
+"PhotosCount": 6
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:39:19Z"
+"Stories": "1.0"
+"StreetDirPrefix": "North"
+"StreetDirSuffix": "North"
+"StreetName": "MAIN"
+"StreetNumber": "9"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "7362"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29641444/9-n-main-street-n-hamilton"
+"StructureType": array:1 [
0 => "Retail"
]
+"CoListAgentKey": "2139701"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283099"
+"GeocodeManualYN": true
+"ZoningDescription": "C5a - Exception 752, 753"
+"FrontageLengthNumeric": 35.0
+"OriginalEntryTimestamp": "2026-04-22T18:00:53.11Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1304838"
+"ListOfficeNationalAssociationId": "1003546"
+"CoListAgentNationalAssociationId": "1391481"
+"CoListOfficeNationalAssociationId": "1324631"
+"Media": array:6 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6620097684"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641444/8da104dc20a3c366563982132c57cdd3.webp"
"MediaSize" => 132693
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641444/thumbnail-8da104dc20a3c366563982132c57cdd3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Commercial building featuring a dark gray stucco exterior, a dark shingle roof, a prominent storefront window, and an arched entrance awning"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40822749"
"ResourceRecordKey" => "29641444"
"ModificationTimestamp" => "2026-04-22T18:00:53.12Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6620097723"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641444/b00585590bc2f682e22fbbfac92b6385.webp"
"MediaSize" => 136895
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641444/thumbnail-b00585590bc2f682e22fbbfac92b6385.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Commercial property with a dark exterior, arched entry, and prominent roofline"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822749"
"ResourceRecordKey" => "29641444"
"ModificationTimestamp" => "2026-04-22T18:00:53.12Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6620097753"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641444/7cc9cff5ecad51fcc54147f2229eb364.webp"
"MediaSize" => 158188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641444/thumbnail-7cc9cff5ecad51fcc54147f2229eb364.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Commercial building featuring a textured gray exterior and black window awnings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822749"
"ResourceRecordKey" => "29641444"
"ModificationTimestamp" => "2026-04-22T18:00:53.12Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6620097795"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641444/5da8294e370cd20cfc150ca182844c98.webp"
"MediaSize" => 150324
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641444/thumbnail-5da8294e370cd20cfc150ca182844c98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822749"
"ResourceRecordKey" => "29641444"
"ModificationTimestamp" => "2026-04-22T18:00:53.12Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6620097809"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641444/cc4bf8edacc4d1566577a96fb188ed95.webp"
"MediaSize" => 153001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641444/thumbnail-cc4bf8edacc4d1566577a96fb188ed95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Gray stucco exterior with a dark shingle roof and a single window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822749"
"ResourceRecordKey" => "29641444"
"ModificationTimestamp" => "2026-04-22T18:00:53.12Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6620097858"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29641444/a662c13cacc95e5af9e23c8b2ba5f184.webp"
"MediaSize" => 147362
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29641444/thumbnail-a662c13cacc95e5af9e23c8b2ba5f184.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Commercial building featuring a dark gray exterior, prominent street frontage, and a covered entrance"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822749"
"ResourceRecordKey" => "29641444"
"ModificationTimestamp" => "2026-04-22T18:00:53.12Z"
]
]
+"DaysOnMarket": 91
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29641444')"
+"ID": "1343973"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 12
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
]