array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29641444 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: "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: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 55164" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24950
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24894
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage Burloak Real Estate Services"
+"OfficeEmail": null
+"OfficePhone": "905-335-3042"
+"OfficeMlsId": "HBROYBURLM"
+"ModificationTimestamp": "2025-07-09T18:17:42Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "55164"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "Suite#200-3060 Mainway"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Burlington"
+"OfficePostalCode": "L7M1A"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1003546"
+"OriginalEntryTimestamp": null
+"OfficeFax": "905-335-1659"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439627"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "55164"
"SocialMediaUrlOrId" => "https://www.royallepageburlington.ca/"
"ModificationTimestamp" => "2025-07-09T18:07:00Z"
]
]
+"FranchiseNationalAssociationId": "1230730"
+"OfficeBrokerNationalAssociationId": "1196412"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('55164')"
}
]
+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 2025166" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24888
+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 '29641444'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25248
+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 '29641444' AND OpenHouseDate ge '2026-07-22'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25264
+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 '29641444' 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.8936404 43.3337097)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25317
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25311
+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 {#25313
+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 {#25310
+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 {#25314
+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 {#25312
+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 {#25307
+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 {#25315
+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 {#25316
+post_id: "1248569"
+post_author: 1
+"ListingKey": "29479170"
+"ListingId": "X12890066"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-24T13:50:46Z"
+"RFModificationTimestamp": "2026-03-24T13:52:54Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1049.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H4"
+"UnparsedAddress": "1 - 219 DUNDAS STREET E, Hamilton (Waterdown), Ontario L0R2H4"
+"Coordinates": array:2 [
0 => -79.900589
1 => 43.32762
]
+"Latitude": 43.32762
+"Longitude": -79.900589
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Turnkey investment opportunity offering a strong 5.75% cap rate. Featuring a international, well established tenant (Edward Jones) secured by a long term lease with built-in rental escalations. This nearly new corner unit offers 1,049 sqft plus a full basement, providing excellent utility and flexibility. Ample street frontage with abundant visitor parking. Ideally situated on one of Waterdown's busiest corridors, surrounded by a dense and growing residential community of thousands of homes, ensuring consistent exposure and long term value. (id:62650)"
+"BuildingAreaUnits": "square feet"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-03-24T13:52:34.468551+00:00"
+"Directions": "Dundas & Waterdown"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2003282"
+"ListOfficeKey": "90198"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-03-17T12:36:46Z"
+"PhotosCount": 8
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-03-24T13:42:32Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "219"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "10601.43"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29479170/1-219-dundas-street-e-hamilton-waterdown-waterdown"
+"StructureType": array:1 [
0 => "Retail"
]
+"GeocodeManualYN": false
+"ZoningDescription": "Commercial / Retail"
+"OriginalEntryTimestamp": "2026-03-17T12:36:46.6Z"
+"ListAgentNationalAssociationId": "1286167"
+"ListOfficeNationalAssociationId": "1153615"
+"Media": array:8 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6538714293"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29479170/86110848b7467d9202db5b7d45a4bd77.webp"
"MediaSize" => 132502
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29479170/thumbnail-86110848b7467d9202db5b7d45a4bd77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12890066"
"ResourceRecordKey" => "29479170"
"ModificationTimestamp" => "2026-03-17T12:36:46.6Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6538714302"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29479170/8bc52511d09128b34f452c7e62c06453.webp"
"MediaSize" => 68003
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29479170/thumbnail-8bc52511d09128b34f452c7e62c06453.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12890066"
"ResourceRecordKey" => "29479170"
"ModificationTimestamp" => "2026-03-17T12:36:46.6Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6538714357"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29479170/77f865418a931f11a68ab8ae985e7852.webp"
"MediaSize" => 128188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29479170/thumbnail-77f865418a931f11a68ab8ae985e7852.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12890066"
"ResourceRecordKey" => "29479170"
"ModificationTimestamp" => "2026-03-17T12:36:46.6Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6538714417"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29479170/a49f98a6c70178cc6a06b0b0af6ea4cb.webp"
"MediaSize" => 59029
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29479170/thumbnail-a49f98a6c70178cc6a06b0b0af6ea4cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12890066"
"ResourceRecordKey" => "29479170"
"ModificationTimestamp" => "2026-03-17T12:36:46.6Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6538714440"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29479170/98132d69f3edf121fd66d015d203360c.webp"
"MediaSize" => 58477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29479170/thumbnail-98132d69f3edf121fd66d015d203360c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12890066"
"ResourceRecordKey" => "29479170"
"ModificationTimestamp" => "2026-03-17T12:36:46.6Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6538714508"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29479170/927a8b10ddba614e98738459488f94aa.webp"
"MediaSize" => 126215
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29479170/thumbnail-927a8b10ddba614e98738459488f94aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12890066"
"ResourceRecordKey" => "29479170"
"ModificationTimestamp" => "2026-03-17T12:36:46.6Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6538714557"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29479170/877e5711572eedb315cfddde93c9a7c8.webp"
"MediaSize" => 81434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29479170/thumbnail-877e5711572eedb315cfddde93c9a7c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12890066"
"ResourceRecordKey" => "29479170"
"ModificationTimestamp" => "2026-03-17T12:36:46.6Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6538714622"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29479170/f85b12c6bf20982c32f34246ea60c671.webp"
"MediaSize" => 103115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29479170/thumbnail-f85b12c6bf20982c32f34246ea60c671.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12890066"
"ResourceRecordKey" => "29479170"
"ModificationTimestamp" => "2026-03-17T12:36:46.6Z"
]
]
+"DaysOnMarket": 127
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29479170')"
+"ID": "1248569"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 12
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
]