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: 1940
List Date: 2026-07-30
Lot Size: 0.1600 acres
Area
2182 ft2
Bedrooms
2
Half Baths
1
Full Baths
2
Days For Sale
0

Location

Amenities

  • 1
  • 2
  • Attic Pull-Down Access
  • Backsplash-Tiled
  • Bath-Shared
  • Bidet
  • Bookcase
  • Built-ins
  • Cabinets-Natural
  • Ceiling Fan
  • Central
  • Closet-Private
  • Counter Tops-Tile
  • Crawl Space
  • Dishwasher
  • Disposal
  • Floors-Hardwood
  • Floors-Tile
  • Gas 1st Lvl
  • No Basement
  • Public
  • Smoke Detector
  • Split System
  • Tub-Shower
  • Wood Stove

Description

Every great home has a story — and this remarkable shandon home has been collecting them for generations.Nestled on Queen Street and backing directly to Emily Douglas Park, this one-of-a-kind property is filled with authentic character, timeless craftsmanship, and an unbeatable location just a short stroll from Five Points, USC, and downtown columbia. Creative souls, collectors, professors, and anyone who appreciates architecture with personality will recognize immediately how special this home is.Rich hardwood floors, handcrafted details, and custom tilework create distinctive living spaces with warmth at every turn — if you've grown tired of cookie-cutter renovations, this may be the one you've been waiting for. The dramatic sunroom steals the show, with soaring cathedral ceilings, walls of windows, and a sunken hot tub unlike anything else on the market. An extraordinary floor-to-ceiling built-in library serves as the home's architectural centerpiece, a reflection of its legacy as the longtime residence of USC English professors and artists.Beyond the screened front porch and brick patio, a detached 319 sf studio — with a half bath, mini-split HVAC, owned solar, and its own metal roof — served most recently as a pottery studio, would be ideal as an art space, office, or guest retreat.Offered as-is, this is a rare opportunity to own one of shandon's truly distinctive properties. Bring your imagination, preserve its remarkable character, and write the next chapter of a home that simply could not be recreated today. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

What's YOUR Home Worth?

Schools

11-12 SPED Schools in 29205

Name
Address
Phone
Type
Grade
316 South Beltline Boulevard
8037387114
Public
11-12 SPED

6-8 SPED Schools in 29205

Name
Address
Phone
Type
Grade
2600 Wheat Street
8033432947
Public
6-8 SPED

9-12 SPED Schools in 29205

Name
Address
Phone
Type
Grade
3319 Millwood Avenue
8032537000
Public
9-12 SPED

Infant-Kindergarten Schools in 29205

Name
Address
Phone
Type
Grade
3407 Devine Street
803-256-1498
Private
Infant-Kindergarten

K-5 SPED Schools in 29205

Name
Address
Phone
Type
Grade
3300 Rosewood Drive
8033432930
Public
K-5 SPED

K3-6th Schools in 29205

Name
Address
Phone
Type
Grade
411 S. Maple Street
803-783-8838
Private
K3-6th

PK-5 SPED Schools in 29205

Name
Address
Phone
Type
Grade
333 Etiwan Avenue
8033432910
Public
PK-5 SPED
4438 Devereaux Road
8037387204
Public
PK-5 SPED
1400 South Kilbourne Road
8037387215
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-733-3650

    ©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 Coldwell Banker Realty

    528 Queen Street, Columbia, SC 29205
    MLS #29205
    $400,000
    SHARE

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