Agent profile image in chat bubble
Agent profile image in chat header

Dream Team United

| Dream Team United | Keller Williams Connected | PLACE

Agent profile image in message

528 Queen St , Columbia, SC 29205
$400,000
Est. Payment: $2,050.90/mo
2 Bed
2.5 Bath
2182 Sqft
Status: active | Days on site: 2
Get Pre-Qualified
VCR-C15903466 - VCR-C159091383,VCR-C159052275

By providing your number, you are expressly consenting, in writing, to receive telemarketing and other messages, including calls or texts at the number you provided above. This consent is not required to purchase any good or service. Message and data rates may apply. Text STOP to cancel.

This site is protected by reCAPTCHA and the GooglePrivacy Policy and Terms of Service apply.

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

Highlights

Listed by Holly Swan , Coldwell Banker Realty , 803-799-8035. Consolidated MLS (IDX)

Property Type

Residential

Lot/Acreage
0.16

Year Built

1940

County

Richland

Area

Columbia - South

Neighborhood

Shandon

School District

Richland One

Listing ID

639763

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • Bedrooms:2
  • Bathrooms:2.5
  • Full Bathrooms:2
  • 1/2 Bathrooms:1
Appliances:Dishwasher, Disposal, Dishwasher,Disposal
Air Cond:Central
Fireplaces:Wood Stove
Basement:No Basement
Other:Cabinets-Natural,Counter Tops-Tile,Floors-Tile,Backsplash-Tiled,Ceiling Fan,Sun Room,Workshop,BookCase,Smoke Detector,Attic Pull-Down Access,Gas,Master on Main
Other:Public

Exterior Features

Garage Capacity:2
Others:Patio,Workshop,Studio,Front Porch - Screened,Back Porch - Uncovered,Other Porch - Covered
Sewer:Public
Principal Interest
$2,051
Taxes
$255

Home Price

$400,000

Loan Details

30 yrs
6.634%

Down Payment

20%
$80,000
All calculations are estimates and provided by Blueroof360. Today’s Rates provided by Blueroof360. Information and interactive calculators are made available to you only as self-help tools for your independent use and are not intended to provide investment or tax advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues.
Monthly Price:
$2,050.90

Principal

Taxes

Principal Taxes HOA Total
Monthly $2,050.90 $255.00 $0.00 $2,305.90
Yearly $24,610.80 $3,060.00 $0.00 $27,670.80
Total $738,323.90 $91,800.00 $0.00 $830,123.90

Today's Rates

30 Year

6.63%

20 Year

6.44%

15 Year

6.12%

Never Miss a Property

Be the first to know when a property hits the market.

Current Listings

Last 30 Days
N/A
Aug 2026

Average Price

All Price Ranges
N/A
Aug 2026

Average Days on Market

All Price Ranges
N/A
Aug 2026
Market insight data is pulled from the same city as the listing being viewed (Columbia, SC).

The schools listed are within a 2-mile radius of the property; however, attendance is not guaranteed. Please contact the local school district to confirm zoning and enrollment options.

Information provided by Columbia MLS, and is deemed reliable but not guaranteed accurate.

IDX service by Blueroof 360

Data last updated: 2026-08-02T00:16:33.700Z

© 2026 Consolidated MLS (IDX)