INVESTOR OPPORTUNITY!! Prime Ashley Riverfront Property that includes 2 LOTS!!!Don't miss this rare opportunity to own 3.60 acres. The property can be subdivided into multiple lots. A major value-add for developers and investors alike. Lot 1, sits a spacious 4-bedroom, 3-bath home that offers endless potential and is ready for your vision. Whether you're looking to renovate, expand, or develop, the possibilities are truly wide open. It has direct deep-water access to the scenic Ashley River. Enjoy expansive marsh views and the convenience of a private dock and floating dock already in place. Sold as-is. Lot 2 is .22 of an acre. Ready for you to develop on or sell! Seize this chance to invest in a unique waterfront property in an unbeatable location.
Active contingent
$869,000
7074 W Constellation Dr, North Charleston, SC 29418
4beds
2,670sqft
Single Family Residence
Built in 1960
3.6 Acres Lot
$816,300 Zestimate®
$325/sqft
$-- HOA
What's special
Ashley riverfront propertyExpansive marsh views
- 514 days
- 400
- 20
Zillow last checked:
Listing updated:
Listed by:
Realty ONE Group Coastal
Source: CTMLS,MLS#: 25017637
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 4
Heating
- Electric
Cooling
- Central Air, Window Unit(s)
Features
- Flooring: Ceramic Tile, Laminate
- Has fireplace: No
Interior area
- Total structure area: 2,670
- Total interior livable area: 2,670 sqft
Property
Parking
- Parking features: Off Street
Features
- Levels: One
- Stories: 1
- Exterior features: Dock
- Fencing: Partial
- On waterfront: Yes
- Waterfront features: Marshfront, River Access, Waterfront
Lot
- Size: 3.6 Acres
- Features: 2 - 5 Acres
Details
- Additional structures: Storage
- Parcel number: 4041600027
- Special conditions: Handy Man Special
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Brick
- Foundation: Slab
- Roof: Metal
Condition
- New construction: No
- Year built: 1960
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Subdivision: Riverbend
Location
- Region: North Charleston
Financial & listing details
- Price per square foot: $325/sqft
- Tax assessed value: $804,800
- Annual tax amount: $3,778
- Date on market: 6/25/2025
- Listing terms: Cash,Conventional
Estimated market value
$816,300
$775,000 - $857,000
$4,064/mo
Price history
| Date | Event | Price |
|---|---|---|
| 6/26/2026 | Price change | $869,000-0.1%$325/sqft |
Source: | ||
| 6/15/2026 | Price change | $870,000-0.1%$326/sqft |
Source: | ||
| 5/26/2026 | Price change | $871,000-0.1%$326/sqft |
Source: | ||
| 5/18/2026 | Price change | $872,000-0.1%$327/sqft |
Source: | ||
| 5/11/2026 | Price change | $873,000-0.1%$327/sqft |
Source: | ||
| 5/4/2026 | Price change | $874,000-0.1%$327/sqft |
Source: | ||
| 4/20/2026 | Price change | $875,000-2.7%$328/sqft |
Source: | ||
| 1/19/2026 | Price change | $899,000-0.1%$337/sqft |
Source: | ||
| 1/5/2026 | Price change | $900,000-5.3%$337/sqft |
Source: | ||
| 10/20/2025 | Price change | $950,000-5%$356/sqft |
Source: | ||
| 9/3/2025 | Price change | $999,999-4.8%$375/sqft |
Source: | ||
| 7/26/2025 | Price change | $1,050,000-4.5%$393/sqft |
Source: | ||
| 6/25/2025 | Listed for sale | $1,100,000+22.4%$412/sqft |
Source: | ||
| 12/19/2023 | Listing removed | -- |
Source: | ||
| 12/8/2023 | Listed for sale | $899,000$337/sqft |
Source: | ||
| 4/25/2023 | Listing removed | -- |
Source: | ||
| 2/16/2023 | Price change | $899,000-5.4%$337/sqft |
Source: | ||
| 1/26/2023 | Price change | $950,000-4.5%$356/sqft |
Source: | ||
| 1/13/2023 | Listed for sale | $995,000-0.5%$373/sqft |
Source: | ||
| 10/7/2022 | Listing removed | -- |
Source: | ||
| 4/25/2022 | Listed for sale | $1,000,000+25%$375/sqft |
Source: | ||
| 10/6/2021 | Listed for sale | $800,000$300/sqft |
Source: | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $3,778 +9.7% | $28,140 +15% |
| 2024 | $3,442 +2% | $24,470 |
| 2023 | $3,375 | $24,470 |
| 2022 | -- | $24,470 +127.8% |
| 2021 | $1,638 -60.6% | $10,740 -26.8% |
| 2020 | $4,162 | $14,680 +15% |
| 2019 | $4,162 | $12,760 |
| 2017 | $4,162 +16.2% | $12,760 |
| 2016 | $3,582 +3.1% | $12,760 |
| 2015 | $3,475 +3.5% | $12,760 |
| 2014 | $3,359 | -- |
| 2011 | $3,359 +133.6% | -- |
| 2010 | $1,438 -0.9% | $11,600 |
| 2009 | $1,451 +9.2% | $11,600 |
| 2008 | $1,329 -24.3% | $11,600 |
| 2006 | $1,754 -1.9% | $11,600 |
| 2005 | $1,788 +54% | $11,600 +47.2% |
| 2004 | $1,161 +2.4% | $7,880 |
| 2003 | $1,133 +6.3% | $7,880 |
| 2002 | $1,066 +111.7% | $7,880 +58.2% |
| 2000 | $504 | $4,980 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 29418
Nearby schools
Schools provided by the listing agent
- Elementary: Hunley Park Elementary School
- Middle: Jerry Zucker
- High: Stall
Source: CTMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.




