Search
Mixed-Use Property with Drive-Through

904 Main St, Columbia, MS 39429

For Sale
$739,900

Three operating businesses share a remodeled restaurant, seafood market, and boutique, with furnishings and equipment included.

Property Size3,500 SF
Price / SF$211.40
Days on Market71

Property Features for 904 Main St

General Information

Standard status Active
Size 3,500 SF

Site & Location

Corner Location Yes
Traffic Count 18,000 vehicles/day
Highway Access Yes

Additional Details

Furnished Yes
Business Included Yes
Equipment Included Yes
Currently Operating Yes

Taxes and HOA fees

Annual Taxes $4,822
Listing Agency: Real Broker
Listed By: Beau Davis · License MS S56272
Source: Exprealty
Added: Sep 11 Changed: Nov 14 Last Checked: Nov 18 at 9:29AM

Displayed information is deemed reliable but is not guaranteed and should be independently verified. All listing content including descriptions, pricing, images are the copyrighted material of Real Broker

Rey
Ask AI about this property
Review the available facts, identify missing information and prepare questions for the agent.

Investment Insights

Based on property information with market context.

This mixed-use property combines a full-service restaurant, seafood market, and boutique. The restaurant has a large dining room, a separate party room, and a layout suited to buffet or full-menu service. The seafood operation includes a walk-in cooler and freezer, preparation and cooking areas, and operating equipment. The restaurant has undergone a recent remodel, and the building has a metal roof and drive-through capability. Furniture, fixtures, equipment, staff, and inventory are included in the sale.

At the intersection of US-98 and MS-13 in Columbia, the property is situated where approximately 18,000 vehicles pass daily. On-site parking supports the multi-business configuration. The building contains 3,500 square feet, with space arranged for the restaurant, market, and boutique operations.

Key Highlights

  • Three businesses included: Rajun Cajun, L&D Seafood, and Graceful Pearl Boutique
  • 3,500‑square‑foot building at the corner of US‑98 and MS‑13
  • Approximately 18,000 vehicles pass the intersection daily

Property Analytics

Current Use

Conventional restaurants

Suggested Use

Top Pick Real Estate Agency (Bike/Boat/Book/etc) Store Barber Shop Carpet & Flooring Store Computer & Electronic Repair Home Appliance Store

Score = modeled unmet demand for each use within ~1 mi (higher = bigger opportunity). Zoning and permitted uses should be independently verified with local authorities.

Lease Details

18,000 VPD
Traffic count
Turnkey business
Opportunity
Yes
Highway access

Location Intelligence

Trade Area within ½ mile

357
Businesses Nearby
73k
Monthly Visits Nearby

Foot Traffic Nearby

Superstores 89% Dining 8% Shops & Services 3%
Walmart Superstores
65,229 visits/mo 0.5 miles
Fox's Pizza Den Dining
5,516 visits/mo 0.5 miles
BankPlus Shops & Services
2,271 visits/mo 0.5 miles

Demographics for 39429, MS

16,073
Population
7,459
Households
2.2
Avg Household Size
41
Median Age
13%
College-Educated
85%
High-School Grad
298.7 sq mi
ZIP Area
54
Density / Sq Mi
$42,953
Median Household Income
$32,047
Median Earnings
$585
Median Rent
$133,700
Median Home Value

Market

Vacancy Rate% for Retail in South region

7% 2020
6.2% 2021
5.1% 2022
4.8% 2023
4.9% 2024
5.4% 2025

Frequently Asked Questions

What type of property is this?
Mixed-use property - Three operating businesses share a remodeled restaurant, seafood market, and boutique, with furnishings and equipment included.
Where is this mixed-use property located?
The property is located at 904 Main St Columbia, MS.
What is the asking price?
The asking price for this property is $739,900.
What are key features of this property?
This property features: Three businesses included: Rajun Cajun, L&D Seafood, and Graceful Pearl Boutique; 3,500‑square‑foot building at the corner of US‑98 and MS‑13; Approximately 18,000 vehicles pass the intersection daily
Research This Page with AI

Rey answers here. ChatGPT, Grok and Claude get the same data packet.

Includes: Price & PSF · Cap rate · Location · Zoning

Ask Rey → ChatGPT Grok Claude
Preferred Make Realmo a preferred source.

Our comps and market reports get this label in your Google results.

Add as a preferred source on Google One click on Google
More about this property
Thanks! Your message was sent.
Error! Your message wasn't sent.
Please enter your name
Please enter email
Please enter the email in the correct format
Please enter phone
Please enter the number in the correct format
Please enter message
Why this one?
Why hide this one?