Search
Storefront With New Roof
For Sale
$54,900

242 Church St, Columbia, MS 39429

COMMERCIAL - Columbia, MS

Property SizeContact for details
Days on Market106

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
Listed By: Beau Davis · License #S56272
Added: Apr 24 Changed: Aug 4 Last Checked: Aug 7 at 9: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-built storefront at 242 Church St in Columbia offers a flexible commercial layout with one bathroom. The property can accommodate several stated concepts, including a hair or nail salon, professional office, or boutique retail operation. The space may also be converted for apartment or mixed-use use, subject to applicable requirements.

A new roof with a 15-year warranty is in place. Its downtown Columbia setting provides an in-town address for an owner seeking a configurable commercial property with multiple potential formats.

Key Highlights

  • New roof backed by a 15‑year warranty
  • Downtown Columbia location at 242 Church St
  • Block construction

Property Analytics

Current Use

Storefront properties

Suggested Use

Top Pick Real Estate Agency Computer & Electronic Repair (Bike/Boat/Book/etc) Store Kitchen & Bath Showroom Veterinary Clinic Butcher

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

Location Intelligence

Trade Area within ½ mile

236
Businesses Nearby
Under-served
Demand for This Use

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
Rey
Questions? Ask Rey
Realmo’s AI knows this listing — price, zoning, demand, history. Ask anything.

Similar Off Market Nearby

  • The Flower Shop on Church Street 323 Church St #2725, Columbia, MS 39429
  • Berry Patch LLC 220 2nd St, Columbia, MS 39429

Frequently Asked Questions

What type of property is this?
Storefront property - Adaptable commercial space for salon, office, boutique retail, or potential mixed-use conversion.
Where is this storefront 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: New roof backed by a 15‑year warranty; Downtown Columbia location at 242 Church St; Block construction
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