Welcome to this stunning 4-bedroom, 3-bathroom home in highly sought-after Limehouse Village! Built in 2024, this 2,231 sq ft two-story residence sits on a prime 0.17-acre corner lot with a wooded buffer and tranquil pond views. Almost brand-new Washer, Dryer and Stainless Steel Refrigerator included. Designed for comfort and style, the home features 10' ceilings on the first floor, 9' ceilings upstairs, hardwood stair treads, luxury vinyl plank flooring, all-glass entry doors, and a chef's gourmet kitchen with quartz countertops, white cabinets with soft-close and crown molding, stainless steel appliances, double wall ovens, 5-burner gas cooktop with stainless steel hood, large center island with shiplap and breakfast bar, huge walk-in pantry, and designer tile backsplash.Themain floor offers a guest bedroom and full bathroom, perfect for visitors or multi-generational living. Upstairs, the loft provides a flexible second living area. The luxurious primary suite features a private balcony, massive walk-in closet, and a spa-like ensuite with extended tiled walk-in shower with seat and marble-topped dual vanity. Outdoor living includes a covered front porch, second-story balcony, screened backyard porch, irrigation system, privacy fence, rain gutters and fresh landscaping with palm trees, fresh sod and stone edging. The detached 2-car garage offers remote entry, and a service door to the fenced yard. This move-in ready home offers several upgrades, luxury features, and warranties made for easy low-maintenance peaceful living. Please see Photos for Detailed List of Extras! Limehouse Village residents enjoy resort-style amenities including a swimming pool, pavilion, play park, picnic tables, golf cart lane, scenic ponds, wetlands, walking/jogging trails, and three main neighborhood entrances. Zoned for Dorchester District Two schools: Newington Elementary, Gregg Middle, and Summerville High all recognized for academic excellence and strong community involvement. Economic advantages for buyers include proximity to major employers such as Boeing, Volvo, Bosch, Mercedes-Benz Vans, and Joint Base Charleston, plus easy access to I-26, Charleston International Airport, and the Port of Charleston. Summerville offers steady home value growth, a thriving small business scene, and abundant year-round recreational opportunities all just a short drive from Charleston's historic charm, beaches, and vibrant culture.
Active
$469,990
254 Red Bluff St, Summerville, SC 29483
4beds
2,231sqft
Est.:
Single Family Residence
Built in 2024
7,405.2 Square Feet Lot
$468,100 Zestimate®
$211/sqft
$-- HOA
What's special
Second-story balconyWooded bufferCovered front porchPrivacy fenceTranquil pond viewsCorner lotDouble wall ovens
- 10 days
- on Zillow |
- 308 |
- 22 |
Zillow last checked: 7 hours ago
Listing updated: August 21, 2025 at 12:02pm
Listed by:
Coldwell Banker Realty
Source: CTMLS,MLS#: 25022117

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: 3
Rooms
- Room types: Family Room, Living/Dining Combo, Loft, Eat-In-Kitchen, Family, Foyer, Laundry, Mother-In-Law Suite, Pantry
Heating
- Natural Gas
Cooling
- Central Air
Appliances
- Laundry: Electric Dryer Hookup, Washer Hookup, Laundry Room
Features
- Ceiling - Smooth, High Ceilings, Kitchen Island, Walk-In Closet(s), Ceiling Fan(s), Eat-in Kitchen, Entrance Foyer, In-Law Floorplan, Pantry
- Flooring: Carpet, Ceramic Tile, Luxury Vinyl
- Has fireplace: No
Interior area
- Total structure area: 2,231
- Total interior livable area: 2,231 sqft
Video & virtual tour
Property
Parking
- Total spaces: 2
- Parking features: Garage, Detached, Off Street, Garage Door Opener
- Garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Patio & porch: Front Porch, Screened
- Exterior features: Balcony, Lawn Irrigation, Rain Gutters, Lighting
- Fencing: Privacy
Lot
- Size: 7,405.2 Square Feet
- Features: 0 - .5 Acre
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Charleston Single,Traditional
- Property subtype: Single Family Residence
Materials
- Vinyl Siding
- Foundation: Raised
- Roof: Asphalt
Condition
- New construction: No
- Year built: 2024
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Dominion Energy
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: $211/sqft
- Date on market: 8/12/2025
- Listing terms: Any,Cash,Conventional,FHA,VA Loan
- Loading
- Loading