Adaptable Mixed-Use
For Sale
$54,900
242 Church St, Columbia, MS 39429
Commercial Sale, Columbia, MS
Property SizeContact for details
Days on Market151
Property Features for 242 Church St
General Information
Property type
Commercial Sale
Property subtype
Other
Bathrooms
1
Full bathrooms
1
Rooms
Bathroom 1
Subdivision
Columbia
Standard status
Active
Taxes and HOA fees
Tax Description
LOT 15FT X 112FT RANKIN & HICKS; PT BLK 11; DB 624/399 DB 640/236 DB 1493/651
Tax Annual Amount
286
Legal Description
LOT 15FT X 112FT RANKIN & HICKS; PT BLK 11; DB 624/399 DB 640/236 DB 1493/651
Building Details
Building materials
Block
Listing Agency:
Real Broker
(228) 471-5211
Listed By:
Beau Davis · License #S56272
(855) 450-0442
Added: Apr 24
Changed: Sep 12
Last Checked: Sep 21 at 11:06AM
MLS# 146826
Copyright © 2026 Hattiesburg Area Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
Investment Insights
Based on property information with market context.
This block-construction property at 242 Church St in downtown Columbia is configured for flexible commercial or residential use. The stated possibilities include a hair or nail salon, professional office, boutique retail space, apartment conversion, or a mixed-use arrangement. The building includes one bathroom and can accommodate an owner’s chosen configuration within those described use concepts.
A new roof is in place with a 15-year warranty. Its downtown setting places the property within Columbia’s in-town commercial environment, while the adaptable format supports several business and residential directions identified for the space.
A new roof is in place with a 15-year warranty. Its downtown setting places the property within Columbia’s in-town commercial environment, while the adaptable format supports several business and residential directions identified for the space.
Key Highlights
- Mixed‑use property at 242 Church St in downtown Columbia, MS
- Block construction
- New roof with a 15‑year warranty
Property Analytics
Unlock full access to Insights
Subscribe to Realmo Intelligence
Open Analytics
Current Use
Location Intelligence
Trade Area within ½ mile
453
Businesses Nearby
9k
Monthly Visits Nearby
Explore this area
Business Placement
Foot Traffic Nearby
Shops & Services 68%
Dining 32%
Regions Bank
Shops & Services
4,036 visits/mo
0.4 miles
Krispy Krunchy Chicken
Dining
2,855 visits/mo
0.4 miles
Valero Energy
Shops & Services
2,108 visits/mo
0.4 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
Check the figures for this property
Cap Rate, Value Estimation, Potential NOI and more
View Realmo Analytics
Market
Vacancy Rate% for Retail in South region
Questions? Ask Rey
Realmo’s AI knows this listing — price, zoning, demand, history. Ask anything.
Frequently Asked Questions
What type of property is this?
Mixed-use property - Block construction and a new roof support flexible commercial or residential use.
Where is this mixed-use property located?
The property is located at 242 Church St Columbia, MS.
What is the asking price?
The asking price for this property is $54,900.
What are key features of this property?
This property features: Mixed‑use property at 242 Church St in downtown Columbia, MS; Block construction; New roof with a 15‑year warranty
