Personal Shopper Log In
528 Queen Street | Columbia | $400,000
528 Queen Street  Photo 1
528 Queen Street  Photo 2
528 Queen Street  Photo 3
528 Queen Street  Photo 4
528 Queen Street  Photo 5
528 Queen Street  Photo 6
528 Queen Street  Photo 7
528 Queen Street  Photo 8
528 Queen Street  Photo 9
528 Queen Street  Photo 10
528 Queen Street  Photo 11
528 Queen Street  Photo 12
528 Queen Street  Photo 13
528 Queen Street  Photo 14
528 Queen Street  Photo 15
528 Queen Street  Photo 16
528 Queen Street  Photo 17
528 Queen Street  Photo 18
528 Queen Street  Photo 19
528 Queen Street  Photo 20
528 Queen Street  Photo 21
528 Queen Street  Photo 22
528 Queen Street  Photo 23
528 Queen Street  Photo 24
528 Queen Street  Photo 25
528 Queen Street  Photo 26
528 Queen Street  Photo 27
528 Queen Street  Photo 28
528 Queen Street  Photo 29
528 Queen Street  Photo 30
528 Queen Street  Photo 31
528 Queen Street  Photo 32
528 Queen Street  Photo 33
528 Queen Street  Photo 34
528 Queen Street  Photo 35
528 Queen Street  Photo 36
528 Queen Street  Photo 37
528 Queen Street  Photo 38
528 Queen Street  Photo 39
528 Queen Street  Photo 40
528 Queen Street  Photo 41
528 Queen Street  Photo 42
528 Queen Street  Photo 43
528 Queen Street  Photo 44
528 Queen Street  Photo 45
528 Queen Street  Photo 46
528 Queen Street  Photo 47
528 Queen Street  Photo 48
528 Queen Street  Photo 49
528 Queen Street  Photo 50
528 Queen Street  Photo 51
528 Queen Street  Photo 52
528 Queen Street  Photo 53
SHOW DETAILS
528 Queen Street Columbia, SC 29205 $400,000
2 BEDS
2.5 BATHS
1,843 SQ. FT.

528 Queen Street Columbia, SC 29205

For SALE Single Family ACTIVE
$400,000
EST. 1,006.89/MO CALCULATE
2 BEDS
2.5 BATHS
1,843 SQ. FT.

Property 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.

Property Details

  • MLS ID639763
  • Property TypeResidential - Single Family
  • Fireplaces2
  • Lot Dimensions0.16 Acre(s)
  • Lot Size0.16 Acres
  • Stories1.0
  • acres0.16

Listed By / Shown By

Listed By

Agency Name: Coldwell Banker Realty

Columbia SC MLS

Shown By

Agent Name: Sapna Agarwal
Agent Phone: (803) 319-8884
Agency Title: Home Advantage Realty

Columbia SC MLS

IDX logo

528 Queen Street  photo 4
528 Queen Street  photo 4
528 Queen Street  photo 4
528 Queen Street  photo 4
Sapna Agarwal
Sapna Agarwal (803) 319-8884

Web address QR Codes

528 Queen Street

Sapna Agarwal

©OneHomeValue

Location 528 Queen Street

Neighborhood Map

Local Content

Neighborhood Hero

Ask A Question 528 Queen Street , Columbia, SC 29205

Sapna Agarwal
Sapna Agarwal (803) 319-8884
Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 07/31/2026. The listing information on this page last changed on 07/31/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Fri 07/31/2026 5:52:45 AM EST) or Pee Dee MLS (last updated Fri 07/31/2026 12:55:14 AM EST) or CCAR MLS (last updated Thu 07/30/2026 11:27:03 PM EST) or Columbia SC MLS (last updated Fri 07/31/2026 1:57:38 AM EST) or Charleston Trident MLS (last updated Thu 07/30/2026 11:32:26 PM EST) or SCCMLS (last updated Fri 07/31/2026 1:53:36 AM EST). Real estate listings held by brokerage firms other than Home Advantage Realty may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.
Privacy Policy / DMCA Notice / ADA Accessibility

Login to Personal Shopper

Pixel