$240,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
- Consolidated MLS
- MLS #
- 638883
- Property type
- City of Columbia, Denny terrace, Lake Elizabeth
- Subdivision
- BARHAMVILLE
- Status
- Active
- Days on market
- 95
- 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. School directory data from the National Center for Education Statistics (NCES), accessed via the Urban Institute Education Data API. Local Score is calculated by INNOVATE Real Estate; where a state rating is shown, it comes from that state's own official school report card.
- 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, calculated by INNOVATE Real Estate from two sources: the EPA's National Walkability Index (street network, transit, land-use mix) and Google Places amenity data (what's actually reachable on foot from this point). 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 5 days ago.
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.