FULLY EQUIPPED AND TURNKEY READY RESTAURANT (FORMER ST JOACHIM’S DINER) LOCATED ON HIGH TRAFFIC AREA AT THE CORNER OF COUNTY RD 42 AND COUNTY RD 31, WITH 50 PARKING SPOTS. CAPACITY OF 193. IT INCLUDES 2 LARGE APARTMENTS AS CHEF’S QUARTERS, ONE A TWO BEDROOM AND 1 BEDROOM APARTMENT, OFFC SPACE, LOTS OF STORAGE, ETC …. CALL TODAY TO VIEW.
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 29421359 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443 +post_id: "1205895" +post_author: 1 +"ListingKey": "29421359" +"ListingId": "26004448" +"PropertyType": "Commercial Sale" +"PropertySubType": "Industrial" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-09T20:05:51Z" +"RFModificationTimestamp": "2026-03-09T20:09:59Z" +"ListPrice": 999900.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St. Joachim" +"PostalCode": "N0R1S0" +"UnparsedAddress": "2744 COUNTY RD 42, St. Joachim, Ontario N0R1S0" +"Coordinates": array:2 [ 0 => -82.608015 1 => 42.302726 ] +"Latitude": 42.302726 +"Longitude": -82.608015 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Windsor-Essex County Association of REALTORS®" +"PublicRemarks": "FULLY EQUIPPED AND TURNKEY READY RESTAURANT (FORMER ST JOACHIM'S DINER) LOCATED ON HIGH TRAFFIC AREA AT THE CORNER OF COUNTY RD 42 AND COUNTY RD 31, WITH 50 PARKING SPOTS. CAPACITY OF 193. IT INCLUDES 2 LARGE APARTMENTS AS CHEF'S QUARTERS, ONE A TWO BEDROOM AND 1 BEDROOM APARTMENT , OFFC SPACE, LOTS OF STORAGE, ETC .... CALL TODAY TO VIEW. (id:62650)" +"BusinessType": "Restaurant" +"Cooling": array:1 [ 0 => "Air Conditioned" ] +"CreationDate": "2026-03-03T19:54:41.731713+00:00" +"Flooring": array:2 [ 0 => "Carpeted" 1 => "Ceramic/Porcelain" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1397736" +"ListOfficeKey": "48711" +"LotFeatures": array:2 [ 0 => "Corner Site" 1 => "Visual exposure" ] +"LotSizeDimensions": "115.69 X IRREG" +"PhotosChangeTimestamp": "2026-03-09T19:59:27Z" +"PhotosCount": 21 +"Sewer": array:1 [ 0 => "Holding Tank" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-03-09T19:59:27Z" +"StreetName": "COUNTY RD 42" +"StreetNumber": "2744" +"ListAOR": "Windsor" +"TaxYear": 2025 +"ListAORKey": "34" +"ListingURL": "www.realtor.ca/real-estate/29421359/2744-county-rd-42-st-joachim" +"CommonInterest": "Freehold" +"GeocodeManualYN": false +"SecurityFeatures": array:2 [ 0 => "Monitored Alarm" 1 => "Full Sprinkler System" ] +"ZoningDescription": "COM/RES HC" +"OriginalEntryTimestamp": "2026-03-03T18:35:15.38Z" +"ListAgentNationalAssociationId": "1110485" +"ListOfficeNationalAssociationId": "1001200" +"Media": array:21 [ 0 => array:13 [ "Order" => 0 "MediaKey" => "6498073767" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29421359/78f0613ac5e816102607e40a94376a47.webp" "MediaSize" => 104759 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29421359/thumbnail-78f0613ac5e816102607e40a94376a47.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "26004448" "ResourceRecordKey" => "29421359" "ModificationTimestamp" => "2026-03-06T15:10:23.15Z" ] 1 => array:13 [ "Order" => 1 "MediaKey" => "6498073776" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29421359/84adb9db4d0f0961b9fa5137122def79.webp" "MediaSize" => 93867 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29421359/thumbnail-84adb9db4d0f0961b9fa5137122def79.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26004448" "ResourceRecordKey" => "29421359" "ModificationTimestamp" => "2026-03-06T15:10:23.14Z" ] 2 => array:13 [ "Order" => 2 "MediaKey" => "6506297059" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29421359/f69b258f8832677e917770eebf5b3ada.webp" "MediaSize" => 139645 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29421359/thumbnail-f69b258f8832677e917770eebf5b3ada.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26004448" "ResourceRecordKey" => "29421359" "ModificationTimestamp" => "2026-03-09T19:41:41.85Z" ] 3 => array:13 [ "Order" => 3 "MediaKey" => "6506297075" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29421359/ca4e4e6d9909ca7c0896189b778178dd.webp" "MediaSize" => 142834 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29421359/thumbnail-ca4e4e6d9909ca7c0896189b778178dd.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26004448" "ResourceRecordKey" => "29421359" "ModificationTimestamp" => "2026-03-09T19:41:41.85Z" ] 4 => array:13 [ "Order" => 4 "MediaKey" => "6506297122" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29421359/78adc9698f92003ff9dfe7df93a34076.webp" "MediaSize" => 150594 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29421359/thumbnail-78adc9698f92003ff9dfe7df93a34076.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26004448" "ResourceRecordKey" => "29421359" "ModificationTimestamp" => "2026-03-09T19:41:44.76Z" ] 5 => array:13 [ "Order" => 5 "MediaKey" => "6506297161" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29421359/e312ef61abe1e2047767d6a31b8c7a15.webp" "MediaSize" => 145883 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29421359/thumbnail-e312ef61abe1e2047767d6a31b8c7a15.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26004448" "ResourceRecordKey" => "29421359" "ModificationTimestamp" => "2026-03-09T19:41:44.66Z" ] 6 => array:13 [ "Order" => 6 "MediaKey" => "6506297166" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29421359/969281effcafa0b0745b317b8f6ca2db.webp" "MediaSize" => 131594 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29421359/thumbnail-969281effcafa0b0745b317b8f6ca2db.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26004448" "ResourceRecordKey" => "29421359" "ModificationTimestamp" => "2026-03-09T19:41:44.72Z" ] 7 => array:13 [ "Order" => 7 "MediaKey" => "6506297227" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29421359/200855e8fa54d9ed502c7e248adcf98b.webp" "MediaSize" => 138443 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29421359/thumbnail-200855e8fa54d9ed502c7e248adcf98b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26004448" "ResourceRecordKey" => "29421359" "ModificationTimestamp" => "2026-03-09T19:41:44.7Z" ] 8 => array:13 [ "Order" => 8 "MediaKey" => "6506297268" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29421359/4b500309cf167b6780e38682ea9b1c2c.webp" "MediaSize" => 150858 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29421359/thumbnail-4b500309cf167b6780e38682ea9b1c2c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26004448" "ResourceRecordKey" => "29421359" "ModificationTimestamp" => "2026-03-09T19:41:44.76Z" ] 9 => array:13 [ "Order" => 9 "MediaKey" => "6506297306" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29421359/fad089e10167c939d1ba26eccb43e428.webp" "MediaSize" => 141624 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29421359/thumbnail-fad089e10167c939d1ba26eccb43e428.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26004448" "ResourceRecordKey" => "29421359" "ModificationTimestamp" => "2026-03-09T19:41:44.72Z" ] 10 => array:13 [ "Order" => 10 "MediaKey" => "6506297315" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29421359/6be73371724d49220cd12a8c3bb060e8.webp" "MediaSize" => 151954 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29421359/thumbnail-6be73371724d49220cd12a8c3bb060e8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26004448" "ResourceRecordKey" => "29421359" "ModificationTimestamp" => "2026-03-09T19:41:44.72Z" ] 11 => array:13 [ "Order" => 11 "MediaKey" => "6506297348" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29421359/9135dba95c2af5283f067b4feedcd13c.webp" "MediaSize" => 121249 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29421359/thumbnail-9135dba95c2af5283f067b4feedcd13c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26004448" "ResourceRecordKey" => "29421359" "ModificationTimestamp" => "2026-03-09T19:41:44.71Z" ] 12 => array:13 [ "Order" => 12 "MediaKey" => "6506297368" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29421359/19f6454188dc4239631ba083255c471d.webp" "MediaSize" => 112341 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29421359/thumbnail-19f6454188dc4239631ba083255c471d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26004448" "ResourceRecordKey" => "29421359" "ModificationTimestamp" => "2026-03-09T19:41:44.71Z" ] 13 => array:13 [ "Order" => 13 "MediaKey" => "6506297408" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29421359/a53359c0289b5e9f777c1b0eef5b3208.webp" "MediaSize" => 119531 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29421359/thumbnail-a53359c0289b5e9f777c1b0eef5b3208.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26004448" "ResourceRecordKey" => "29421359" "ModificationTimestamp" => "2026-03-09T19:41:44.65Z" ] 14 => array:13 [ "Order" => 14 "MediaKey" => "6506297417" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29421359/a90b52f72310eee5afd239883d8e80b3.webp" "MediaSize" => 128046 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29421359/thumbnail-a90b52f72310eee5afd239883d8e80b3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26004448" "ResourceRecordKey" => "29421359" "ModificationTimestamp" => "2026-03-09T19:41:44.71Z" ] 15 => array:13 [ "Order" => 15 "MediaKey" => "6506297434" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29421359/927b07ae46de853311311d2f66cf6695.webp" "MediaSize" => 133351 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29421359/thumbnail-927b07ae46de853311311d2f66cf6695.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26004448" "ResourceRecordKey" => "29421359" "ModificationTimestamp" => "2026-03-09T19:41:44.76Z" ] 16 => array:13 [ "Order" => 16 "MediaKey" => "6506297446" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29421359/79c1cf7bb465a3bd61bcd9b204484be1.webp" "MediaSize" => 115546 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29421359/thumbnail-79c1cf7bb465a3bd61bcd9b204484be1.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26004448" "ResourceRecordKey" => "29421359" "ModificationTimestamp" => "2026-03-09T19:41:44.72Z" ] 17 => array:13 [ "Order" => 17 "MediaKey" => "6506297471" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29421359/79fc62d2af2e19f739ea2f4b78c974ac.webp" "MediaSize" => 101408 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29421359/thumbnail-79fc62d2af2e19f739ea2f4b78c974ac.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26004448" "ResourceRecordKey" => "29421359" "ModificationTimestamp" => "2026-03-09T19:41:44.69Z" ] 18 => array:13 [ "Order" => 18 "MediaKey" => "6506297510" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29421359/b3b65cd227943f4af53dd9674c07d3f4.webp" "MediaSize" => 135477 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29421359/thumbnail-b3b65cd227943f4af53dd9674c07d3f4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26004448" "ResourceRecordKey" => "29421359" "ModificationTimestamp" => "2026-03-09T19:41:46.48Z" ] 19 => array:13 [ "Order" => 19 "MediaKey" => "6506297562" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29421359/14a2d6021c85afa42be7346ba8fcee55.webp" "MediaSize" => 126853 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29421359/thumbnail-14a2d6021c85afa42be7346ba8fcee55.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26004448" "ResourceRecordKey" => "29421359" "ModificationTimestamp" => "2026-03-09T19:41:46.14Z" ] 20 => array:13 [ "Order" => 20 "MediaKey" => "6506297576" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29421359/20131b1ee3e42c0bc9e165fe9660374c.webp" "MediaSize" => 117745 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29421359/thumbnail-20131b1ee3e42c0bc9e165fe9660374c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26004448" "ResourceRecordKey" => "29421359" "ModificationTimestamp" => "2026-03-09T19:41:46.14Z" ] ] +"DaysOnMarket": 120 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29421359')" +"ID": "1205895" } ] +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 48711" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24821 +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 1397736" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24812 +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 '29421359'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25196 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29421359'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25212 +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 '29421359' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Commercial Sale' AND geo.distance(Coordinates, POINT(-82.608015 42.302726)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25259 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] ]