MLS ID: 25022117
For Sale - $419,900

About this property

Bedrooms 4
Baths 3
sq2 2231
Lot Size 0.1700 acres
Year Built 2024
DOM 125

Address

Address:
254 Red Bluff Street
Subdivision:
Limehouse Village
City:
Summerville
Zip Code:
29483
County:
Dorchester
State:
SC

Features and Amenities

#pool #community-pool
Exterior
Balcony, Lawn Irrigation, Rain Gutters, Lighting
Cooling
Central Air
Heating
Natural Gas
Floors
Carpet, Ceramic Tile, Luxury Vinyl
Laundry Features
Electric Dryer Hookup, Washer Hookup, Laundry Room
Security Features
Security System
Community Features
Park, Pool, Trash, Walk/Jog Trails
Interior Features
Ceiling - Smooth, High Ceilings, Kitchen Island, Walk-In Closet(s), Ceiling Fan(s), Eat-in Kitchen, Family, Entrance Foyer, Living/Dining Combo, Loft, In-Law Floorplan, Pantry
Utilities
Dominion Energy
Lot Features
0 - .5 Acre
Style
Charleston Single, Traditional
Other
Asphalt, Ceiling Fan(s), Walk-In Closet(s)

Description

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. 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. The main floor offers a guest bedroom and full bathroom, perfect for visitors ormulti-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.

Schools

Name Address Phone Type Grade
Alston Middle 500 Bryan Street 8438733890 Public 6-8 SPED
Charles B. DuBose Middle 1005 DuBose School Road 8438757012 Public 6-8 SPED
Gregg Middle 500 Green Wave Boulevard 8438713150 Public 6-8 SPED
Rollings Middle School of the Arts 815 South Main Street 8438733610 Public 6-8 SPED
Name Address Phone Type Grade
Alston-Bailey Elementary 820 W 5th N St 8436955210 Public PK-5 SPED
James H. Spann Elementary 901 John McKissick Way 8438733050 Public PK-5 SPED
Knightsville Elementary 847 Orangeburg Road 8438734851 Public PK-5 SPED
Nexton Elementary 200 Scholar Way 8439003222 Public PK-5 SPED
Summerville Elementary 835 South Main Street 8438732372 Public PK-5 SPED
William M. Reeves Elementary 1003 DuBose School Road 8436952450 Public PK-5 SPED
Name Address Phone Type Grade
Cane Bay High 1624 State Road 8438998786 Public 9-12 SPED
Summerville High 1101 Boone Hill Road 8438736460 Public 9-12 SPED
Name Address Phone Type Grade
Dorchester Adult Education 115 Devon Road 8438737372 Public SPED
Name Address Phone Type Grade
Sangaree Elementary 1460 Royle Road 8438203868 Public PK-2 SPED
Name Address Phone Type Grade
Sangaree Intermediate 201 School House Lane 8438203850 Public 3-5 SPED
Name Address Phone Type Grade
Bethany Child Development Center 118 W. Third South Street 843-821-1946 Private PreK-K5
Name Address Phone Type Grade
Faith Christian School 337 Farmington Road 843-873-8464 Private K3-12
Name Address Phone Type Grade
Trinity Classical Academy 111 Waring Street 843-885-1081 Private K-8

Price Change history

  1. $469,990 $211/SqFt

  2. $464,990 $208/SqFt

  3. $455,990 $204/SqFt

  4. $445,990 $200/SqFt

  5. $435,500 $195/SqFt

  6. $424,900 $190/SqFt

  7. $419,900 $188/SqFt

Mortgage Calculator

$
$
%
%
Interest Rate as of: Mon, Dec. 15, 2025
$419,900 Home Price
$419,900 Monthly payment
$419,900 Amount Financed
$419,900 Annual cost of Loan

Map

SEE THIS PROPERTY

James Schiller

James Schiller

Realtor, Brand Name Real Estate
Email: jameseschiller@gmail.com
Live Chat:
Facebook Messenger Icon Facebook Messenger Icon
©2025 CTMLS, GGMLS, CCMLS & CMLS

The information is provided exclusively for consumers’ personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the MLS boards of the SC Realtors.

Broker Logo Listing Provided by Coldwell Banker Realty