#25017967, Listing office: Carolina One Real Estate
$409,800 List price
174 Red Bluff St Summerville, SC 29483
4 beds
2 full, 1 partial
2,569 sqft
0.1 acres
$160 / sqft
House
Property details
About 174 Red Bluff St
Welcome to 174 Red Bluff Street, located in the highly sought-after Limehouse Village, a charming boutique community in Summerville, just minutes from the quaint shops and restaurants of historic downtown.Step inside to discover beautiful wood flooring and a spacious living room with high ceilings, flowing seamlessly into the open kitchen. This inviting space features stainless steel gas appliances, white cabinetry, quartz countertops, and a classic subway tile backsplash, combining both style and functionality.On the main level, you'll also find a versatile flex room, perfect for a home office, playroom, or creative space.Upstairs includes a bright and open loft, ideal for a second living area or media room. The private owner's suite is thoughtfully positioned apartand offers a full en suite bath with a separate soaking tub and walk-in shower. Three additional bedrooms provide plenty of room for family, guests, or hobbies. Step outside to enjoy the screened-in back porch, perfect for morning coffee or evening relaxation, overlooking a spacious backyard with room to play, garden, or entertain. Limehouse Village is known for its tree-lined sidewalks, classic charm, top-rated Dorchester District 2 schools, and convenient access to Summerville's best dining, shopping, and entertainment. Don't miss the opportunity to make this beautiful home yours, schedule your showing today!
Highlights
Home typeSingle Family Residence
HeatingForced Air, Natural Gas
StatusActive
CoolingCentral Air
Size2,569 sqft
Lot size0.14 Acres
Year built2022
Parking2 Car Garage, Attached, Garage Door Opener
MLS #25015292
Attached garage2 spaces
Summary
- Partial Bathrooms: 1
- Full Bathrooms: 2
- Flooring Type: Carpet, Ceramic Tile, Laminate
- Interior: Ceiling - Smooth, High Ceilings, Garden Tub/Shower, Kitchen Island, Bonus, Eat-in Kitchen, Family, Entrance Foyer, Game, Great, Loft, Office, Pantry, Separate Dining, Study
- Total Bedroom Count: 4
- Garage Space: 2 spaces
- Attached Garage: Yes
- Parking: 2 Car Garage, Attached, Garage Door Opener
- Architectural Style: Traditional
- Heating: Forced Air, Natural Gas
- Cooling: Central Air
- List Price: $409,800
- Price/SqFt: $159
- Annual Tax Amount: $3,605
- Tax Year: 2023
- Lot: Wooded
- Directions: From Summerville, Take Hwy 165 Towards Dorchester Road. Right Onto Dorchester Road And Limehouse Village Will Be On Your Right.
- Year Built: 2022
- Stories: 2
- Living Area: 2,569 SqFt
- Lot Size: 0.14 Acres
- MLS Number: 25015292
- Office Name: The Boulevard Company
The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity℠ Program of the CHS Multiple Listing Service. Those properties marked with the CHS MLS Approved logo are provided courtesy of the CHS MLS Broker Reciprocity Database. Information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data deemed reliable but not guaranteed accurate by the MLS.
Copyright © 2025 Charleston Trident Association of REALTORS®
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 7/10/2025, 5:45:31 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Price information
Property sales
| Date | Event | Price |
|---|---|---|
| Nov 01, 2022 | Home Sold | $382,415 |
Tax history
| Year | Assessment | Property Tax |
|---|---|---|
| 2023 | $22,645 | $3,605 |
History based on county public records data.
Nearby schools
5
Newington Elementary School
Public District PK-5
0.9 mi
•10 King Charles Cir
5
Flowertown Elementary School
Public District PK-5
1.0 mi
•20 King Charles Cir
6
Knightsville Elementary School
Public District PK-5
2.0 mi
•847 Orangeburg Rd
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $89,950. The most common annual income of people living in Summerville, SC is between $35k-100k. Most families are married, no kids. The most common level of education of people living in this area is post secondary degree.
How much money do the neighbors make?
8%
<35k
52%
35k-100k
34%
100k-200k
6%
200k+
What level of education do the neighbors have?
High School Diploma
Post Secondary Degree
Masters Degree
Doctorate
What types of families live nearby?
22%
Single, No Kids
11%
Single, with Kids
34%
Married, No Kids
33%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
18%
<11 yrs old
10%
12-17 yrs old
17%
18-34 yrs old
45%
35-64 yrs old
10%
65+ yrs old
What do the neighbors do for fun?
College Football
Soccer
NASCAR
Where do the neighbors shop?
Express/Express For Men
Best Buy
Old Navy
Where do the neighbors go to eat?
Sonic
Texas Roadhouse
Jimmy Johns
What do the neighbors drive?
Kia
Ram
GMC
What do the neighbors listen to?
New Country
Contemporary Christian
Adult Hits
All data provided by Home Junction and Claritas
Similar homes for sale
#2512192, Listing office: Trelora Realty, Inc.
Backup offers
#25010517, Listing office: EVERPLACE Realty
Backup offers
#25010084, Listing office: Tabby Realty LLC
#25009573, Listing office: NextHome The Agency Group
#25017845, Listing office: Coldwell Banker Realty
#25004735, Listing office: Carolina One Real Estate
7 days on RocketTour
#25018274, Listing office: Brand Name Real Estate
#25007679, Listing office: Coldwell Banker Realty
#25014257, Listing office: Matt O'Neill Real Estate
Frequently asked questions
Living in Summerville, SC
Transportation in Summerville includes a network of roads and highways that connect residents to nearby cities and attractions. Public transportation options are available, providing connectivity within the town and to surrounding areas. The community is also served by ride-sharing services, enhancing mobility for those without private vehicles. Certain areas of Summerville are known for their walkability, particularly the historic downtown district, while other parts are more car-dependent.
The community is served by a number of public schools, including several elementary, middle, and high schools, as well as private educational institutions, providing a range of options for families. Healthcare services are accessible, with local clinics and a hospital that offers various medical services. Summerville also features a public library system that supports the community's educational and informational needs. Retail and dining options reflect the local culture, with a blend of familiar chains and unique local businesses.
Summerville is celebrated for its small-town charm and community-oriented atmosphere. The area is known for its annual Flowertown Festival, which showcases the town's rich cultural heritage and love for nature. The historic downtown area, with its local boutiques and eateries, contributes to the town's quaint character, while the surrounding natural landscapes offer a serene backdrop to daily life.
Summerville's housing market is diverse, offering a mix of single-family homes, apartments, and townhouses to accommodate various preferences. The architectural styles in the area range from charming historic homes to contemporary new constructions. Single-family homes are the most prevalent, providing a suburban feel to the community. The homeownership rate in Summerville is robust, with a significant majority of residents owning their homes, while a smaller portion of the population opts for renting.
About 174 Red Bluff St
The listing price of 174 Red Bluff St property is $409,800.
The property 174 Red Bluff St is a house located in Summerville, South Carolina, 29483.
Active Listing: 174 Red Bluff St is For Sale (Active/New) which means the seller is accepting offers.
The nearby schools for 174 Red Bluff St are: Newington Elementary School (GreatSchools Rating 5/10), Flowertown Elementary School (GreatSchools Rating 5/10), Knightsville Elementary School (GreatSchools Rating 6/10), Gregg Middle School (GreatSchools Rating 4/10), Rollings Middle School of the Arts (GreatSchools Rating 9/10), Charles B. Dubose Middle School (GreatSchools Rating 7/10), Summerville High School (GreatSchools Rating 6/10), Ashley Ridge High School (GreatSchools Rating 7/10), Fort Dorchester High School (GreatSchools Rating 7/10).
According to the records, the last property tax for 2023 is $3,605 (source: MLS/based on county public records data).
The last sale was on November 1, 2022 for $382,415 (source: MLS/tax record).
The property at 174 Red Bluff St has 4 bedrooms and 2 full and 1 half bathrooms.
The property 174 Red Bluff St is 2,569 SqFt (source: MLS/tax record).
The year of construction for 174 Red Bluff St is 2022.
This home is located at 174 Red Bluff St in Summerville, SC and zip code 29483. This 2,569 square foot home, which was built in 2022, sits on a 0.14 acre lot. Features: 4 bedrooms, 3 bathrooms. It has been listed on Rocket Homes since June 3, 2025 and is currently priced at $409,800.
While more than 63 listings in Summerville, SC in June 2025 were sold above asking price, there were more than 105 listings sold at asking price, and more than 149 were sold below. Between May and June 2025, Summerville, SC real estate market has seen increase in the number of listings by 5.8%. In June 2025 median list price was $396,919 and the average listing age was 65 days.
From Rocket Homes Real Estate and based on county public records data.