Skip main navigation
For sale
    • $400,000

    528 Queen St, Columbia, SC 29205

    2beds
    2,182sqft
    : 
    $2,475/mo
    Get pre-qualified
    Single Family Residence
    Built in 1940
    6,969 Square Feet Lot
    $398,500 Zestimate®
    $183/sqft
    $-- HOA

    What's special

    Brick patioDramatic sunroomAuthentic characterSunken hot tubTimeless craftsmanshipExtraordinary floor-to-ceiling built-in libraryRich hardwood floors
    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.
    15 days
    |
    2,108
    |
    168
    |

    Likely to sell faster than

    Zillow last checked:

    Listing updated:

    Listed by:

    Holly Swan,

    Coldwell Banker Realty

    Source: Consolidated MLS,MLS#: 639763MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 2
      • Bathrooms: 3
      • Full bathrooms: 2
      • 1/2 bathrooms: 1
      • Partial bathrooms: 1
      • Main level bathrooms: 3
      Rooms
      • Room types: Sun Room, Workshop
      Primary bedroom
      • Features: Bidet, Tub-Shower, Bath-Shared, Ceiling Fan(s), Closet-Private, Floors-Hardwood
      • Level: Main
      Bedroom 2
      • Features: Bidet, Fireplace, Bath-Shared, Tub-Shower, Built-in Features, Ceiling Fan(s), Closet-Private, Floors-Hardwood
      • Level: Main
      Great room
      • Level: Main
      Kitchen
      • Features: Cabinets-Natural, Tile Counters, Floors-Tile, Backsplash-Tiled, Ceiling Fan(s)
      • Level: Main
      Living room
      • Features: Beams, Books, Fireplace, Floors-Hardwood, Ceiling Fan
      • Level: Main
      Heating
      • Gas 1st Lvl, Split System
      Cooling
      • Central Air
      Appliances
      • Included: Gas Range, Dishwasher, Disposal
      • Laundry: Utility Room, Main Level
      Features
      • Bookcases, Ceiling Fan(s), Built-in Features
      • Flooring: Tile, Hardwood
      • Basement: Crawl Space
      • Attic: Pull Down Stairs
      • Number of fireplaces: 2
      • Fireplace features: Wood Burning Stove
      Interior area
      • Total structure area: 2,182
      • Total interior livable area: 2,182 sqft

      Property

      Parking
      • Total spaces: 2
      • Parking features: No Garage
      Features
      • Stories: 1
      • Patio & porch: Patio
      • Fencing: Rear Only Other
      Lot
      • Size: 6,969 Square Feet
      Details
      • Additional structures: Workshop, Studio
      • Parcel number: 113120805

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Craftsman
      • Property subtype: Single Family Residence
      Materials
      • Wood
      Condition
      • New construction: No
      • Year built: 1940

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public
      • Utilities for property: Electricity Connected
      Green energy
      • Energy generation: Solar

      Community & HOA

      Community
      • Security: Smoke Detector(s)
      • Subdivision: SHANDON
      HOA
      • Has HOA: No
      Location
      • Region: Columbia

      Financial & listing details

      • Price per square foot: $183/sqft
      • Tax assessed value: $251,600
      • Annual tax amount: $1,461
      • Date on market: 7/30/2026
      • Listing agreement: Exclusive Right To Sell
      • Road surface type: Paved

        Estimated market value

        $398,500

        $379,000 - $418,000

        $2,407/mo

        Price history

        DateEventPrice
        7/30/2026Listed for sale$400,000$183/sqft
        Source: Consolidated MLS #639763 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2022$1,461 -3.2%$10,060
        2021$1,509 -5.2%$10,060
        2020$1,592 -0.7%$10,060
        2019$1,603 +12.7%$10,060 +11.9%
        2018$1,422 $8,990
        2017$1,422 +2.7%$8,990
        2016$1,385 +3.7%$8,990
        2015$1,335 0%$8,990 -96%
        2014$1,335 +0.1%$224,800 +2400.6%
        2013$1,334 $8,990 +6%
        2012-- $8,480
        2011-- $8,480
        2010-- $8,480
        2009-- $8,480 +14.9%
        2008-- $7,380
        2007-- $7,380
        2006-- $7,380
        2005-- $7,380 +32.5%
        2004-- $5,570
        2003-- $5,570
        2002-- $5,570 +6.5%
        2000-- $5,230
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: Shandon

        Getting around

        77 / 100
        Very Walkable
        35 / 100
        Some Transit
        61 / 100
        Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: A.C. Moore
        • Middle: Hand
        • High: Dreher
        • District: Richland One

        Source: Consolidated MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts

        Similar homes

              Nearby cities

              Nearby neighborhoods

              Nearby zip codes

              Other Columbia Topics

                Search
                Updates
                Favorites
                Plan
                Inbox