Welcome to 174 Red Bluff Street, located in the highly sought-after Limehouse Village, a charming boutique community in Summerville, just minutes from the quaint shops and restaurants of historic downtown.Step inside to discover beautiful wood flooring and a spacious living room with high ceilings, flowing seamlessly into the open kitchen. This inviting space features stainless steel gas appliances, white cabinetry, quartz countertops, and a classic subway tile backsplash, combining both style and functionality.On the main level, you'll also find a versatile flex room, perfect for a home office, playroom, or creative space.Upstairs includes a bright and open loft, ideal for a second living area or media room. The private owner's suite is thoughtfully positioned apartand offers a full en suite bath with a separate soaking tub and walk-in shower. Three additional bedrooms provide plenty of room for family, guests, or hobbies. Step outside to enjoy the screened-in back porch, perfect for morning coffee or evening relaxation, overlooking a spacious backyard with room to play, garden, or entertain. Limehouse Village is known for its tree-lined sidewalks, classic charm, top-rated Dorchester District 2 schools, and convenient access to Summerville's best dining, shopping, and entertainment. Don't miss the opportunity to make this beautiful home yours, schedule your showing today!
Active
Price cut: $9.1K (6/13)
$409,900
174 Red Bluff St, Summerville, SC 29483
4beds
2,569sqft
Est.:
Single Family Residence
Built in 2022
6,098.4 Square Feet Lot
$409,600 Zestimate®
$160/sqft
$-- HOA
What's special
Stainless steel gas appliancesTree-lined sidewalksBright and open loftScreened-in back porchVersatile flex roomHigh ceilingsQuartz countertops
- 26 days
- on Zillow |
- 823 |
- 69 |
Zillow last checked: 7 hours ago
Listing updated: June 13, 2025 at 06:05pm
Listed by:
The Boulevard Company
Source: CTMLS,MLS#: 25015292

Travel times
Tour with a buyer’s agent
Tour with a buyer’s agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Rooms
- Room types: Bonus Room, Family Room, Game Room, Great Room, Loft, Office, Dining Room
Heating
- Forced Air, Natural Gas
Cooling
- Central Air
Appliances
- Laundry: Electric Dryer Hookup, Washer Hookup, Laundry Room
Features
- Ceiling - Smooth, High Ceilings, Garden Tub/Shower, Kitchen Island, Eat-in Kitchen, Entrance Foyer, Pantry
- Flooring: Carpet, Ceramic Tile, Laminate
- Windows: Window Treatments
- Has fireplace: No
Interior area
- Total structure area: 2,569
- Total interior livable area: 2,569 sqft
Property
Parking
- Total spaces: 2
- Parking features: Garage, Attached, Garage Door Opener
- Attached garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Patio & porch: Front Porch, Screened
Lot
- Size: 6,098.4 Square Feet
- Features: 0 - .5 Acre, Wooded
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence
Materials
- Vinyl Siding
- Foundation: Raised
- Roof: Architectural
Condition
- New construction: No
- Year built: 2022
Utilities & green energy
- Water: Private, Public
- Utilities for property: Dominion Energy, Dorchester Cnty Water and Sewer Dept, Dorchester Cnty Water Auth
Community & HOA
Community
- Features: Park, Pool, Trash, Walk/Jog Trails
- Security: Security System
- Subdivision: Limehouse Village
Location
- Region: Summerville
Financial & listing details
- Price per square foot: $160/sqft
- Date on market: 6/3/2025
- Listing terms: Any
- Loading
- Loading