$419,900
254 Red Bluff Street
Summerville, SC 29483
MLS# 25022117
4 beds  |  3 baths  |  2231 sqft

 | 

2024 build nearly brand-new
  1 / 68  
2024 build nearly brand-new gourmet kitchen huge yard huge corner lot living room huge corner lot second floor stained privacy fence screened porch glass door entry welcome home gourmet kitchen shiplap island vegetable sprayer faucet open floor plan over-sized walk-in pantry dining area dining area living room living room first floor first floor first floor wow oak stained rail second floor second floor second floor second floor second story porch entry second story porch pond view pond view second floor second floor extended tiled shower second floor second floor second floor second floor laundry room screened porch long driveway 2-car garage aerial view beautiful 254 Red Bluff Street aerial view corner lot with pond view easy commute amenities amenities welcome home wow long drive way your new address welcome home side view huge backyard stained fence fun awaits here side view side view side view beautiful Charleston style double front porches features and homeowner upgrades features and homeowner upgrades area info

Property 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 or

Details
Maps
Documents
Contract Info
Primary Structure List Price/SqFt: 188.21
Sub-Type: Single Family Detached
MLS List Date: 2025-08-12
Status: Active
List Price: $419,900
Current Price: $419,900
Location, Tax & Legal
Legal Description: Limehouse/133 O/417-420 City of Summerville
Tax Map #: 1520603329
Street #: 254
Street Name: Red Bluff
Street Suffix: Street
County: Dorchester
State: SC
Zip Code: 29483
Area: 63 - Summerville/Ridgeville
Tax District: 207 - City of Summerville
Subdivision: Limehouse Village
Elementary School: Newington
Middle School: Gregg
High School: Summerville
Directions: Option 1: Berlin G Myers Pkwy, left Osprey Rdg Ln, left Red Blf St. - Option 2: Dorchester Rd, right Ilderton St, E Respite Ln, left Cypress Knee Landing, right N Commodore Way, right W Respite Ln, left Osprey Rdg Ln, right Red Blf St
General Property Info
Primary Bedroom – Main Level: No
C/R: Yes
Stories: 2
HOA Fee: Yes
HOA Frequency: Quarterly
HOA $: 187.5
Ownership: Fee Simple
Occupancy: Owner
Lease Purchase: No
Potential Short Sale: No
Other Structures Y/N: No
Bedrooms: 4
Baths - Full: 3
Baths - Total: 3
Primary Structure Apx SqFt: 2231
Year Built: 2024
Acreage: 0.17
Tax/Fees
Special Assessment: No
Regime Fee: No
Office/Member Info
Seller Concessions Negotiable Y/N: Yes
SqFt Source
Builder/Owner: 1
Hired Measurement: 1
Roof
Asphalt Shingle: 1
Lot Description
0 - .5 Acre: 1
Misc Exterior
Balcony: 1
Fence - Private: 1
Lawn Irrigation: 1
Porch - Front Porch: 1
Porch - Full Front: 1
Porch - Screened: 1
Rain Gutters: 1
Special Yard Lights: 1
Exterior
Vinyl Siding: 1
SF Detached Style
Charleston Single: 1
Traditional: 1
Foundation
Raised Slab: 1
Garage/Parking
2 Car Garage: 1
Detached: 1
Off-Street Parking: 1
Stories/Levels
2 Stories: 1
Equipment/Appliances
Ceiling Fan: 1
Dishwasher: 1
Disposal: 1
Electric Double Oven: 1
Electric Dryer Hookup: 1
Garage Door Opener: 1
Gas Cooktop: 1
Microwave: 1
Range Hood: 1
Refrigerator: 1
Security System: 1
Self-Cleaning Oven: 1
Washer Hookup: 1
Cooling
Central Air: 1
Heat
Natural Gas: 1
Rooms
Eat-In-Kitchen: 1
Family: 1
Foyer: 1
Laundry: 1
Living/Dining Combo: 1
Loft: 1
Mother-In-Law Suite: 1
Pantry: 1
Amenities
Park: 1
Pool: 1
Trash: 1
Walk/Jog Trails: 1
Assumable
No: 1
Primary Bedroom
Ceiling Fan: 1
Upstairs: 1
Walk-In Closets: 1
Proposed Financing
Any: 1
Cash: 1
Conventional Loan: 1
FHA Loan: 1
VA Loan: 1
Misc Interior
Ceiling - Smooth: 1
Ceilings - 9'+: 1
Kitchen Island: 1
Walk-In Closets: 1
New Owned
Pre-Owned: 1
Floors
Carpet: 1
Ceramic Tile: 1
Luxury Vinyl Plank: 1
Possession
At Closing: 1
Special
Termite Bond: 1
Water/Sewer
Public Sewer: 1
Public Water: 1
Utility Suppliers
Dominion Energy: 1
Green Features
Tankless Water Heater: 1
Property Features
SqFt Source: Builder/Owner; Hired Measurement
SF Detached Style: Charleston Single; Traditional
Lot Description: 0 - .5 Acre
Misc Exterior: Balcony; Fence - Private; Lawn Irrigation; Porch - Front Porch; Porch - Full Front; Porch - Screened; Rain Gutters; Special Yard Lights
Roof: Asphalt Shingle
Exterior: Vinyl Siding
Foundation: Raised Slab
Misc Interior: Ceiling - Smooth; Ceilings - 9'+; Kitchen Island; Walk-In Closets
New Owned: Pre-Owned
Rooms: Eat-In-Kitchen; Family; Foyer; Laundry; Living/Dining Combo; Loft; Mother-In-Law Suite; Pantry
Primary Bedroom: Ceiling Fan; Upstairs; Walk-In Closets
Cooling: Central Air
Floors: Carpet; Ceramic Tile; Luxury Vinyl Plank
Heat: Natural Gas
Possession: At Closing
Utility Suppliers: Dominion Energy
Special: Termite Bond
Amenities: Park; Pool; Trash; Walk/Jog Trails
Proposed Financing: Any; Cash; Conventional Loan; FHA Loan; VA Loan
Assumable: No
Green Features: Tankless Water Heater
Supplements
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.

IDX
Listing Office: Coldwell Banker Realty

Last Updated: December - 09 - 2025

Properties marked with IDX logo are provided courtesy of Charleston Trident Multiple Listing Service, Inc. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the Charleston Trident Multiple Listing Service. Real estate listings held by brokerage firms other than the website owner are marked with the Broker Reciprocity logo or the Broker Reciprocity thumbnail logo and detailed information about them includes the name of the listing brokers. The broker providing this data believes it to be correct, but advises interested parties to confirm them before relying on them in a purchase decision. Information is provided exclusively for consumers' personal, non-commerical use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.