Located on the quiet end of Queen Street, this charming corner-lot home offers the best of downtown living in a safe, friendly community. Just a 2-minute walk to Colonial Lake and within walking distance to MUSC, The Battery, top-rated restaurants, boutique shopping, and several downtown schools.
The home features a sunny private courtyard, perfect for relaxing or entertaining. With plenty of street parking available on both sides of the house, convenience is never an issue. Tennis and pickleball courts are just a 5-minute walk away.
Offered fully furnished, with unfurnished options negotiable. Pets also negotiable with fee.
No smoking. Lots of street parking available alongside house. Small pets negotiable with additional pet fee.
Sold for $700,000 on 11/17/22
$700,000
174 Queen St, Charleston, SC 29401
3beds
1,496sqft
Single Family Residence
Built in ----
-- sqft lot
$1,194,600 Zestimate®
$468/sqft
$6,223 Estimated rent
Owner options
What's special
Zillow last checked: 9 hours ago
Listing updated: October 04, 2025 at 03:39am
Source: Zillow Rentals
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Cooling
- Central Air
Appliances
- Included: Dishwasher, Dryer, Freezer, Microwave, Oven, Refrigerator, Washer
- Laundry: In Unit
Features
- Flooring: Hardwood, Tile
- Furnished: Yes
Interior area
- Total interior livable area: 1,496 sqft
Property
Parking
- Parking features: Off Street
- Details: Contact manager
Details
- Parcel number: 4570803105
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Community & neighborhood
Location
- Region: Charleston
HOA & financial
Other fees
- Deposit fee: $6,900
Other
Other facts
- Available date: 01/01/2026
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,194,600