$250,000
About this home
Positioned on a prominent corner in Columbia's established Barhamville community, 3207 Piedmont Avenue presents a unique opportunity for investors or buyers seeking a property with endless potential. Built in 2017, this approximately 1,085-square-foot building features soaring cathedral ceilings, recessed lighting, abundant natural light, and an open interior ready to be reimagined. Zoned residential and being sold with seven parcel numbers, this property offers exceptional redevelopment, investment, or future-use potential (subject to local zoning and permitting requirements). Conveniently located near downtown Columbia, shopping, dining, and major interstates, this is a rare opportunity to bring your vision to life.Sale includes the following parcel numbers: R11508-17-07, R11508-17-08, R11508-17-09, R11508-17-10, R11508-17-11, R11508-17-12, and R11508-17-13, providing a unique opportunity with additional land and potential. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
Property details
- MLS #
- 638883
- Property type
- City of Columbia, Denny terrace, Lake Elizabeth
- Subdivision
- BARHAMVILLE
- Status
- Active
- Days on market
- 72
- On market date
- July 17, 2026
- Stories
- 1
- Total bathrooms
- 1
- Garage spaces
- N/A
- Parking spaces
- N/A
- Lot size
- 0.069 acres
Location
Get directions →Nearby schools
Within 10 miles · public school directory data (NCES)
- Enrollment
- 276
- Student:teacher ratio
- 11.5:1
- District
- Richland 01
- Enrollment
- 304
- Student:teacher ratio
- 8.0:1
- District
- Richland 01
- Enrollment
- 404
- Student:teacher ratio
- 9.9:1
- District
- Richland 01
Walkability
Blended score for Columbia's center: EPA's National Walkability Index (street network, transit, land-use mix) combined with nearby-amenity density. 60% EPA National Walkability Index + 40% nearby-amenity density (Google Places).
Market position
How this listing compares to current activity in Columbia, from live MLS data.
Mortgage calculator
Estimate only - actual rate and payment depend on your lender, credit, and loan program.
Adjust tax / insurance estimates
Similar homes you might like
Data source: Listing information provided by Consolidated MLS (COLUMBIA) via Trestle/CoreLogic. Last updated August 12, 2026.
Information herein deemed reliable but not guaranteed; all measurements, school assignments, HOA fees, taxes, and feature lists are approximate and should be independently verified. Equal Housing Opportunity.