Retail unit available for lease in a well-maintained mixed-use property, previously operated as a convenience store and suitable for a variety of retail or service-oriented uses. The unit offers approximately 2160 retail layout, storage area, and service counter, and is in turnkey condition. Features include excellent frontage, signage opportunities, and available on-site or nearby parking. Zoning permits a range of
These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract.
I acknowledge I can only access these forms as a ComFree customer under contract.
These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract and in partnership with Zubic Law.
I acknowledge I can only access these forms as a ComFree customer under contract.
These forms are provided to ComFree’s Unrepresented Sellers as part of their Mere Posting ComFree Listing Contract and in partnership with Imperium LLP – Rocky Kim.
I acknowledge I can only access these forms as a ComFree customer under contract.
1. Purchase Your Package
2. We Ship Your ‘For Sale’ Sign
3. Book Your VR Tour
4. Complete Listing Input Forms
5. We Make Your Listing Live
6. Get Support 7 Days a Week
7. iSOLD!
array:6 [ "RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29497188 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411 +post_id: "1240815" +post_author: 1 +"ListingKey": "29497188" +"ListingId": "40813276" +"PropertyType": "Commercial Lease" +"PropertySubType": "Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T17:05:38Z" +"RFModificationTimestamp": "2026-06-02T17:21:45Z" +"ListPrice": 0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 2160.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9H5E3" +"UnparsedAddress": "1817 REGIONAL RD 97, Hamilton, Ontario L9H5E3" +"Coordinates": array:2 [ 0 => -80.157871 1 => 43.3778384 ] +"Latitude": 43.3778384 +"Longitude": -80.157871 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Retail unit available for lease in a well-maintained mixed-use property, previously operated as a convenience store and suitable for a variety of retail or service-oriented uses. The unit offers approximately 2160 retail layout, storage area, and service counter, and is in turnkey condition. Features include excellent frontage, signage opportunities, and available on-site or nearby parking. Zoning permits a range of uses including convenience store, specialty retail, bakery and more. Available for immediate occupancy or as otherwise agreed! Located on high traffic area, estimate average 10000 to 15000 vehicles every day. Property is centrally located between Cambridge, Puslinch and Hamilton region on Hwy 97. Only 5 minutes from expanding Cambridge's border, 15 minutes drive to Hwy 401. Easy commute to both 401(East/West) and 403.Alternative address :1817 Regional RD. #97 Cambridge On, N1S 5S7 (id:62650)" +"Basement": array:1 [ 0 => "None" ] +"BuildingAreaUnits": "square feet" +"CommunityFeatures": array:1 [ 0 => "High Traffic Area" ] +"ConstructionMaterials": array:3 [ 0 => "Wood frame" 1 => "Concrete block" 2 => "Concrete Walls" ] +"CreationDate": "2026-03-20T19:20:07.405287+00:00" +"Directions": "Highway 6 to Highway 97/ Franklin Blvd to Hwy 97" +"ExteriorFeatures": array:4 [ 0 => "Concrete" 1 => "Wood" 2 => "Brick" 3 => "Metal" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1984576" +"ListOfficeKey": "291992" +"LivingAreaUnits": "square feet" +"PhotosChangeTimestamp": "2026-03-20T18:41:31Z" +"PhotosCount": 9 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:49:21Z" +"Stories": "2.0" +"StreetName": "REGIONAL RD 97" +"StreetNumber": "1817" +"SubdivisionName": "043 - Flamborough West" +"WaterSource": array:1 [ 0 => "Well" ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29497188/1817-regional-rd-97-hamilton" +"StructureType": array:1 [ 0 => "Retail" ] +"CoListAgentKey": "1937380" +"CommonInterest": "Freehold" +"CoListOfficeKey": "291992" +"GeocodeManualYN": true +"TotalActualRent": 2500 +"ExistingLeaseType": array:1 [ 0 => "Gross" ] +"ZoningDescription": "E2, A1" +"LeaseAmountFrequency": "Monthly" +"FrontageLengthNumeric": 530.0 +"OriginalEntryTimestamp": "2026-03-20T18:39:04.76Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1269306" +"ListOfficeNationalAssociationId": "1407252" +"CoListAgentNationalAssociationId": "1235794" +"CoListOfficeNationalAssociationId": "1407252" +"Media": array:9 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "29497188_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29497188/1704c7a4f25272d2020497e51ad5b260.webp" "MediaSize" => 97995 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29497188/thumbnail-1704c7a4f25272d2020497e51ad5b260.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "View of commercial location featuring uncovered parking" "PreferredPhotoYN" => true "ResourceRecordId" => "40813276" "ResourceRecordKey" => "29497188" "ModificationTimestamp" => "2026-03-20T18:41:31.32Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "6530670074" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29497188/b3396f206d98126b8e1f7c87b05b6a9a.webp" "MediaSize" => 91361 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29497188/thumbnail-b3396f206d98126b8e1f7c87b05b6a9a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40813276" "ResourceRecordKey" => "29497188" "ModificationTimestamp" => "2026-03-20T18:41:31.3Z" ] 2 => array:13 [ "Order" => 2 "MediaKey" => "29497188_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29497188/25ff28f59f51a4a85bacedffe4663ebe.webp" "MediaSize" => 122223 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29497188/thumbnail-25ff28f59f51a4a85bacedffe4663ebe.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40813276" "ResourceRecordKey" => "29497188" "ModificationTimestamp" => "2026-03-20T18:41:31.3Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "6530670249" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29497188/a6a6bdf3ba71e32ca57ef043e64a5724.webp" "MediaSize" => 126978 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29497188/thumbnail-a6a6bdf3ba71e32ca57ef043e64a5724.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "View of miscellaneous room" "PreferredPhotoYN" => false "ResourceRecordId" => "40813276" "ResourceRecordKey" => "29497188" "ModificationTimestamp" => "2026-03-20T18:41:31.31Z" ] 4 => array:13 [ "Order" => 4 "MediaKey" => "29497188_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29497188/94dce7117785bb7297ec2509bea7dc2a.webp" "MediaSize" => 126978 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29497188/thumbnail-94dce7117785bb7297ec2509bea7dc2a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "View of miscellaneous room" "PreferredPhotoYN" => false "ResourceRecordId" => "40813276" "ResourceRecordKey" => "29497188" "ModificationTimestamp" => "2026-03-20T18:41:31.31Z" ] 5 => array:13 [ "Order" => 5 "MediaKey" => "6530670348" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29497188/c170c59d0dbf2f7494b6b5916d764269.webp" "MediaSize" => 92789 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29497188/thumbnail-c170c59d0dbf2f7494b6b5916d764269.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Corridor with an upstairs landing and carpet" "PreferredPhotoYN" => false "ResourceRecordId" => "40813276" "ResourceRecordKey" => "29497188" "ModificationTimestamp" => "2026-03-20T18:41:31.31Z" ] 6 => array:13 [ "Order" => 6 "MediaKey" => "6530670436" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29497188/6b82046a37dd8e31f2d816f75d083c19.webp" "MediaSize" => 115884 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29497188/thumbnail-6b82046a37dd8e31f2d816f75d083c19.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "View of miscellaneous room" "PreferredPhotoYN" => false "ResourceRecordId" => "40813276" "ResourceRecordKey" => "29497188" "ModificationTimestamp" => "2026-03-20T18:41:31.31Z" ] 7 => array:13 [ "Order" => 7 "MediaKey" => "6530670538" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29497188/b27d8b51d8d63ef5487ea041350335f6.webp" "MediaSize" => 46057 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29497188/thumbnail-b27d8b51d8d63ef5487ea041350335f6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "View of home floor plan" "PreferredPhotoYN" => false "ResourceRecordId" => "40813276" "ResourceRecordKey" => "29497188" "ModificationTimestamp" => "2026-03-20T18:41:31.3Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "29497188_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29497188/9c82e4f67da04ff15e5f9c31b628506c.webp" "MediaSize" => 100661 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29497188/thumbnail-9c82e4f67da04ff15e5f9c31b628506c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Aerial view of a heavily wooded area" "PreferredPhotoYN" => false "ResourceRecordId" => "40813276" "ResourceRecordKey" => "29497188" "ModificationTimestamp" => "2026-03-20T18:41:29.83Z" ] ] +"DaysOnMarket": 94 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29497188')" +"ID": "1240815" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.11 seconds" ] "RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 291992" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24759 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1984576" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24768 +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 '29497188'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25132 +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 '29497188'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25245 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.11 seconds" ] "RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29497188' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Commercial Lease' AND geo.distance(Coordinates, POINT(-80.157871 43.3778384)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25160 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] ]