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: 1935
List Date: 2025-09-03
Lot Size: 0.3200 acres
Area
1008 ft2
Bedrooms
3
Full Baths
1
Days For Sale
1

Location

Amenities

  • 1
  • Backsplash-Tiled
  • Bungalow
  • Cabinets-Painted
  • Ceiling Fan
  • Central
  • Closet-Private
  • Counter Tops-Formica
  • Crawl Space
  • Floors-Hardwood
  • No Basement
  • Public
  • Refrigerator
  • Tub-Shower

Description

Turnkey Airbnb with Commercial Zoning – Endless Possibilities Await! Close to shopping and dining, this versatile property is currently operating as an Airbnb and offers incredible flexibility. Zoned C3 Commercial, Multi-Family, it’s ideal as a rental property, small office, boutique salon, or live/work space. Inside, you’ll find 3 bedrooms, 1 bath, a formal dining room, living room, kitchen, laundry room, and deck. The home features hardwood floors throughout (with tile in the kitchen and bath), plus major updates including a new roof in 2019 and HVAC in 2015. Added bonus: gutters with leaf filters mean you’ll never worry about cleaning them out.All kitchen appliances, washer, and dryer convey, and the property may be sold furnished, making it a true turnkey investment opportunity. Whether you’re looking to continue its short-term rental success or repurpose it for business use, this property is ready to deliver. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

What's YOUR Home Worth?

Schools

9-12 SPED Schools in 29223

Name
Address
Phone
Type
Grade
7500 Brookfield Road
8036992800
Public
9-12 SPED
501 Commerce Drive, NE
8664766416
Public
9-12 SPED

K-8 SPED Schools in 29223

Name
Address
Phone
Type
Grade
2740 Alpine Road
8037368740
Public
K-8 SPED

K4-10 Schools in 29223

Name
Address
Phone
Type
Grade
2304 Kneece Road
803-462-9904
Private
K4-10

PK-5 SPED Schools in 29223

Name
Address
Phone
Type
Grade
7150 Trenholm Rd Exn
8037903800
Public
PK-5 SPED
7500 Springcrest Drive
8037368754
Public
PK-5 SPED
225 North Brickyard Road
8037368730
Public
PK-5 SPED
8040 Hunt Club Road
8037368720
Public
PK-5 SPED
1250 Polo Road
8034192226
Public
PK-5 SPED
9800 Dunbarton Drive
8037368723
Public
PK-5 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-388-8798

    ©2025CTMLS,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 Yip Premier Real Estate LLC

    8824 Two Notch, Columbia, SC 29223
    MLS #29223
    $189,900
    SHARE

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