This site refreshes every 15 minutes, so the listings are always live, fresh, and current from all SC major market MLS boards with the newest properties
Property type: Single Family
Year built: 2017
List Date: 2026-07-17
Lot Size: 0.0700 acres
Area
1085 ft2
Bedrooms
1
Half Baths
2
Days For Sale
2

Location

Amenities

  • 1
  • 4
  • Ceilings-Cathedral
  • Ceilings-High (over 9 Ft)
  • Corner
  • Floors - Carpet
  • Floors-Tile
  • No Basement
  • Other
  • Public
  • Recessed Lights
  • Slab
  • Split System

Description

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.

What's YOUR Home Worth?

Schools

2-8 SPED Schools in 29203

Name
Address
Phone
Type
Grade
6015 N Main Street
8032519138
Public
2-8 SPED

6-8 SPED Schools in 29203

Name
Address
Phone
Type
Grade
5125 Fairfield Road
8037353439
Public
6-8 SPED
500 Summerlea Drive
8033432942
Public
6-8 SPED

9-12 SPED Schools in 29203

Name
Address
Phone
Type
Grade
361 Pisgah Church Road
8037142500
Public
9-12 SPED
4800 Monticello Road
8037357600
Public
9-12 SPED
502 Beckman Drive
8039357203
Public
9-12 SPED

K-12 Schools in 29203

Name
Address
Phone
Type
Grade
577 W. Killian Road
803-679-6423
Private
K-12
1929 Gervais Street, 2nd Floor
803-995-5211
Private
K-12

K4-12 Schools in 29203

Name
Address
Phone
Type
Grade
3019 Farrow Road
803-873-7132
Private
K4-12

PK-12 SPED Schools in 29203

Name
Address
Phone
Type
Grade
5935 Token Street
8037353435
Public
PK-12 SPED

Show on the map:
Road Map
Fly by view
Street view

James Schiller

Realtor, Brand Name Real Estate

Happy Clients

SEE THIS PROPERTY



    803-832-2404

    ©2026CTMLS,GGMLS,CCMLS& CMLS

    The information is provided exclusively for consumers’ personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the MLS boards of the SC Realtors.

    Listing Provided by Olivia Cooley Real Estate

    3207 Piedmont Avenue, Columbia, SC 29203
    MLS #29203
    $250,000
    SHARE

    SC mortgage interest rates live. View the latest and most current home loan mortgage interest rates in South Carolina.