Notice: Function rest_validate_value_from_schema was called incorrectly. The "type" schema keyword for inspectorHtml can only be one of the built-in types: array, object, string, number, integer, boolean, and null. Please see Debugging in WordPress for more information. (This message was added in version 5.5.0.) in /home/drewsineath/public_html/wp-includes/functions.php on line 6121
254 Red Bluff Street, Summerville, SC 29483
$409,900
Property Type:
Residential
Bedrooms:
4
Baths:
3
Square Footage:
2,231
Lot Size (sq. ft.):
7,405
Status:
Active
Current Price:
$409,900
List Date:
1/16/2026
Last Modified:
1/28/2026
Description
Nearly brand-new 2024-built 4BR/3BA home in desirable Limehouse Village, located on a corner lot with pond view.
Features include 10' ceilings on the main level, LVP flooring, gourmet quartz kitchen with gas cooktop and double ovens, main-floor guest bedroom and full bathroom, loft, and primary suite with private balcony. Enjoy outdoor living with a screened porch, fenced yard, irrigation, rain gutters, and detached 2-car garage.
Resort-style amenities. Convenient to Boeing, Volvo, Bosch, Joint Base Charleston, I-26, and the airport. Move-in ready, easy to show, and quick close possible. Only lived in 4-months, come get it! Schedule your showing today!
~see photos for detailed List of Upgrades & Features
More Information MLS# 26001502
Contract Info
Primary Structure List Price/SqFt: 183.73
Sub-Type: Single Family Detached
MLS List Date: 2026-01-16
Status: Active
List Price: $409,900
Current Price: $409,900
Location, Tax & Legal
Legal Description: Limehouse/133O/417-420CityOfSummerville
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
Stories: 2
HOA Fee: Yes
HOA Frequency: Quarterly
HOA $: 187.5
Ownership: Fee Simple
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
Office/Member Info
Seller Concessions Negotiable Y/N: Yes
SqFt Source
Previous Listing: 1
Roof
Architectural: 1
Lot Description
0 - .5 Acre: 1
Misc Exterior
Balcony: 1
Fence - Private: 1
Fence - Wood: 1
Fence - Wooden Enclosed: 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
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
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: Previous Listing
SF Detached Style: Charleston Single; Traditional
Lot Description: 0 - .5 Acre
Misc Exterior: Balcony; Fence - Private; Fence - Wood; Fence - Wooden Enclosed; Lawn Irrigation; Porch - Front Porch; Porch - Full Front; Porch - Screened; Rain Gutters; Special Yard Lights
Roof: Architectural
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; Walk/Jog Trails
Proposed Financing: Any; Cash; Conventional Loan; FHA Loan; VA Loan
Assumable: No
Green Features: Tankless Water Heater
Listing Office:
Coldwell Banker Realty
Last Updated: January - 28 - 2026
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.