This versatile space is a blank canvas, ready for its next chapter. Previously home to a successful hardware store for over 10 years, it offers a solid foundation for a wide range of possibilities. Whether you envision a cozy coffee shop, a charming ice cream parlour, a specialty pet food store, or a stylish hair salon, this location is ready
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 29534196 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362 +post_id: "1270200" +post_author: 1 +"ListingKey": "29534196" +"ListingId": "X12936734" +"PropertyType": "Commercial Lease" +"PropertySubType": "Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-24T23:21:15Z" +"RFModificationTimestamp": "2026-05-24T23:26:28Z" +"ListPrice": 0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 1900.0 +"BuildingAreaTotal": 0 +"City": "Frontenac (Frontenac South)" +"PostalCode": "K0H2W0" +"UnparsedAddress": "6826 HWY 38 N, Frontenac (Frontenac South), Ontario K0H2W0" +"Coordinates": array:2 [ 0 => -76.691545 1 => 44.485526 ] +"Latitude": 44.485526 +"Longitude": -76.691545 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Kingston & Area Real Estate Association" +"PublicRemarks": "This versatile space is a blank canvas, ready for its next chapter. Previously home to a successful hardware store for over 10 years, it offers a solid foundation for a wide range of possibilities. Whether you envision a cozy coffee shop, a charming ice cream parlour, a specialty pet food store, or a stylish hair salon, this location is ready to bring your ideas to life. Bring your creativity and make it your own-endless potential awaits! (id:62650)" +"Cooling": array:1 [ 0 => "None" ] +"CreationDate": "2026-03-31T04:03:11.949907+00:00" +"Directions": "Cross Streets: hwy 38 and Pine Rdg Dr. ** Directions: Hwy 401 N on Hwy 38 to Verona." +"Heating": array:1 [ 0 => "Baseboard heaters" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2251279" +"ListOfficeKey": "300016" +"LivingAreaUnits": "square feet" +"LotSizeDimensions": "100 x 185 FT" +"PhotosChangeTimestamp": "2026-04-06T16:08:08Z" +"PhotosCount": 4 +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-05-24T23:10:59Z" +"StreetDirSuffix": "North" +"StreetName": "Hwy 38" +"StreetNumber": "6826" +"TaxAnnualAmount": "2771" +"ListAOR": "Kingston" +"TaxYear": 2025 +"CityRegion": "47 - Frontenac South" +"ListAORKey": "37" +"ListingURL": "www.realtor.ca/real-estate/29534196/6826-hwy-38-n-frontenac-frontenac-south-47-frontenac-south" +"GeocodeManualYN": false +"TotalActualRent": 1850 +"ZoningDescription": "UC- Urban Commercial" +"LeaseAmountFrequency": "Monthly" +"FrontageLengthNumeric": 100.0 +"OriginalEntryTimestamp": "2026-03-30T20:10:42.65Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1490212" +"ListOfficeNationalAssociationId": "1480730" +"Media": array:4 [ 0 => array:13 [ "Order" => 0 "MediaKey" => "6572498374" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29534196/04c00a3ad7384a57d7301ec024dd5883.webp" "MediaSize" => 100316 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29534196/thumbnail-04c00a3ad7384a57d7301ec024dd5883.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "X12936734" "ResourceRecordKey" => "29534196" "ModificationTimestamp" => "2026-04-06T16:08:07.97Z" ] 1 => array:13 [ "Order" => 1 "MediaKey" => "6572498382" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29534196/6fe8bcf2425a271a53e83650dc7bfff5.webp" "MediaSize" => 93953 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29534196/thumbnail-6fe8bcf2425a271a53e83650dc7bfff5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X12936734" "ResourceRecordKey" => "29534196" "ModificationTimestamp" => "2026-04-06T16:08:07.96Z" ] 2 => array:13 [ "Order" => 2 "MediaKey" => "6572498388" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29534196/8541f187c53d13eab341e0b2e4c51ebc.webp" "MediaSize" => 59085 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29534196/thumbnail-8541f187c53d13eab341e0b2e4c51ebc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X12936734" "ResourceRecordKey" => "29534196" "ModificationTimestamp" => "2026-04-06T16:08:08.06Z" ] 3 => array:13 [ "Order" => 3 "MediaKey" => "6572498399" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29534196/28abf65e7a02b184dd9c483a8899fdc9.webp" "MediaSize" => 237982 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29534196/thumbnail-28abf65e7a02b184dd9c483a8899fdc9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X12936734" "ResourceRecordKey" => "29534196" "ModificationTimestamp" => "2026-04-06T16:08:08.02Z" ] ] +"DaysOnMarket": 78 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29534196')" +"ID": "1270200" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.12 seconds" ] "RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 300016" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24645 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.11 seconds" ] "RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2251279" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24639 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.11 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29534196'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25008 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29534196'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25024 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.12 seconds" ] "RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29534196' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Commercial Lease' AND geo.distance(Coordinates, POINT(-76.691545 44.485526)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25071 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.17 seconds" ] ]