Mixed-Use Property with Two Brick
For Sale
$1,900,000
217 Bear Creek Pike, Columbia, TN 38401
Two brick structures combine residential space with a separate building formerly used for antiques.
Property Size4,620 SF
Price / SF$411.26
Days on Market500
Property Features for 217 Bear Creek Pike
General Information
Standard status
Active
Size
4,620 SF
Property subtype
Commercial Sale / Mixed Use
Amenities
Shingle
No Dock
Building Details
Year Built
1985
Listing Agency:
RE/MAX Encore
(931) 446-6370
Listed By:
Andy Wilhoite · License #279783
(931) 446-6370
Source:
Compass
Added: Apr 19, 2025
Changed: Aug 30
Last Checked: Aug 30 at 10:58PM
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 RE/MAX Encore
Investment Insights
Based on property information with market context.
This mixed-use property includes a 2946 sq ft brick home with three bedrooms and two bathrooms, plus a separate 1200 sq ft brick home/shop. The secondary building was formerly used by Sewell's Antiques. Both structures date to 1985, and the property is zoned CD4C for urban commercial-residential corridor use.
Water, electric, gas, and city sewer are located on the lots. The offering includes the property at 217 Bear Creek Pike and a separate 3.53-acre vacant lot identified by Tax ID 090 009.09. The site is near Interstate access, downtown Columbia, the GE Auto Plant, and a new Dollar Store, and it is not in a flood zone.
Water, electric, gas, and city sewer are located on the lots. The offering includes the property at 217 Bear Creek Pike and a separate 3.53-acre vacant lot identified by Tax ID 090 009.09. The site is near Interstate access, downtown Columbia, the GE Auto Plant, and a new Dollar Store, and it is not in a flood zone.
Key Highlights
- 2946 sq ft brick home with 3 bedrooms and 2 bathrooms
- Separate 1200 sq ft brick home/shop
- CD4C zoning for urban commercial‑residential corridor use
Property Analytics
Property Profile
Current Use
Location Intelligence
Trade Area within ½ mile
230
Businesses Nearby
Explore this area
Business Placement
Demographics for 38401, TN
63,075
Population
28,470
Households
2.2
Avg Household Size
40
Median Age
24%
College-Educated
92%
High-School Grad
296.7 sq mi
ZIP Area
213
Density / Sq Mi
$69,467
Median Household Income
$42,314
Median Earnings
$1,084
Median Rent
$295,200
Median Home Value
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 - Two brick structures combine residential space with a separate building formerly used for antiques.
Where is this mixed-use property located?
The property is located at 217 Bear Creek Pike Columbia, TN.
What is the asking price?
The asking price for this property is $1,900,000.
What are key features of this property?
This property features: 2946 sq ft brick home with 3 bedrooms and 2 bathrooms; Separate 1200 sq ft brick home/shop; CD4C zoning for urban commercial‑residential corridor use
