Viewing Listing MLS# 25022117

Begin your Charleston Home Search here! Featuring: Historic Charleston Homes, Luxury Waterfront Condos, Golf Course Homes, Charleston Area New Homes for Sale, and NOW Charleston Foreclosures & Bank Owned Properties. Charleston, SC offers living for any lifestyle.

Interested in viewing this property? Please Call me at 843.810.9414 or click the Inquiry link below.
Limehouse Village - Summerville, SC Real Estate | Summerville - Residential Property

$469,990 No Recent Price Change
254 Red Bluff Street
Summerville, SC 29483
  • 4Beds
  • 3Full Baths
  • N/AHalf Baths
  • 2,231SqFt
  • 2024Year Built
  • 0.17Acres
  • MLS# 25022117
  • Residential
  • Single Family Detached
  • Active

  • Approx Time on Market1 day
  • AreaSummerville/ridgeville
  • CountyDorchester
  • Subdivision Limehouse Village

Overview

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.



Agriculture / Farm

Grazing Permits Forest Service:  No

Grazing Permits Private:  No

Grazing Permits Blm:  No

Horse:  No

Farm Credit Service Incl:  No

Association Fees / Info

Community Features:  Park, Pool, Trash, Walk/Jog Trails

Bathroom Info

Fullbaths:  3

Building Info

Levels:  Two

Year Built:  2024

Floors:  Carpet, Ceramic Tile, Luxury Vinyl

Business Info

Rent Control:  No

Buyer Compensation

Exterior Features

Fencing:  Privacy

Misc Ext:  Front Porch, Porch - Full Front, Screened

Exterior Features:  Balcony, Lawn Irrigation, Rain Gutters, Lighting

Pool Private:  No

Style:  Charleston Single, Traditional

Garage / Parking

Gar Pkg:  2 Car Garage, Detached, Off Street, Garage Door Opener

Garage:  Yes

Attached Garage:  No

Green / Env Info

Interior Features

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

Fireplace:  No

Laundry Features:  Electric Dryer Hookup, Washer Hookup, Laundry Room

Lot Info

Lot Size:  0.17

Lot Desc:  0 - .5 Acre

Lot Size Units:  Acres

Acres:  0.17

Lot Sqft:  7405.2

Irrigation Water Rights:  No

Offer Compensation

Other

Security Features:  Security System

Mobile Home Remains:  No

Property Info

Property Type:  A

Stories:  2

Foundation:  Raised Slab

Exterior:  Vinyl Siding

New Construction:  No

Roof:  Asphalt

Property Subtype:  No

Building Area Units:  Square Feet

View:  No

Home Warranty:  No

Habitable Residence:  No

Room Info

Beds:  4

Primary Bedroom Features:  Ceiling Fan(s), Walk-In Closet(s)

Room Master Bedroom Level:  Upper

Sale / Lease Info

Lease Renewal Option:  No

Lease Considered:  No

Lease Assignable:  No

Special Features

Sqft Info

Sqft:  2231

Unit Info

Utilities / Hvac

Water Source:  Public

Utilities:  Dominion Energy

Heating:  Yes

Heat:  Natural Gas

Water Sewer:  Public Sewer

Cooling:  Central Air

Cooling:  Yes

Waterfront / Water

Water Front Features:  Pond

Waterfront:  No

Schools

Elem:  Newington

Middle:  Gregg

High:  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

Courtesy of listing office Coldwell Banker Realty 

Mortgage Calculator

%
$
%
Dollars per $1000
$
Approximate Monthly Payment 0.0
On heatherlord.com since Tue, Aug 12th 2025
No Property History recorded for this listing.

Residential, Land, Other Disclaimer:

Broker Reciprocity The data relating to real estate for sale on this web site comes in part from the Broker ReciprocitySM Program of the Charleston Trident Multiple Listing Service. Real estate listings held by brokerage firms other than The Boulevard Company are marked with the Broker ReciprocitySM logo or the Broker ReciprocitySM thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Last updated on 08-13-2025 5:53 PM EST . The broker providing these data believes them to be correct, but advises interested parties to confirm them before relying on them in a purchase decision. Copyright 2025 Charleston Trident Multiple Listing Service, Inc. All rights reserved.
Commercial Sale/Lease: Copyright 2025 South Carolina commercial MLS, Inc. All rights reserved. Last updated on 08-13-2025 5:53 PM EST est.

Any images related to data from the MLS is the sole property of the MLS and not the responsibility of the owner of this website.


This real estate website and IDX data is Powered & Hosted by IDX data is hosted by Dynamic IDX, LLC Real Estate Web Solutions

For Showings or Detailed Information regarding any of these properties please call Heather Lord at 843 810-9414 or email:  heather@heatherlord.com

Connect with me on the following networks

Contact Heather Lord today for all your Charleston, SC Real Estate needs!

Quick Search











search now


Advanced Property Search Types

Free Foreclosure Lists