INVESTOR OPPORTUNITY!! Prime Ashley Riverfront Property that INCLUDES 2 LOTS!!!Don't miss this rare opportunity to own a total of 3.60 acres. The property is 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 .41 Acres. Ready for you to develop on or sell! Seize this chance to invest in a unique waterfront property in an unbeatable location.
Active
Price cut: $50K (7/26)
$1,050,000
7074 W Constellation Dr, North Charleston, SC 29418
4beds
2,670sqft
Est.:
Single Family Residence
Built in 1960
3.6 Acres Lot
$-- Zestimate®
$393/sqft
$-- HOA
What's special
Ashley riverfront propertyExpansive marsh views
- 58 days
- on Zillow |
- 537 |
- 19 |
Zillow last checked: 7 hours ago
Listing updated: August 19, 2025 at 11:36am
Listed by:
Realty ONE Group Coastal
Source: CTMLS,MLS#: 25017637

Travel times
Tour with a buyer's agent
Tour with a buyer's agent
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
- Waterfront features: Marshfront, River Access, Waterfront
Lot
- Size: 3.6 Acres
- Features: 2 - 5 Acres
Details
- 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: $393/sqft
- Tax assessed value: $650,000
- Annual tax amount: $3,442
- Date on market: 6/25/2025
- Listing terms: Cash,Conventional
- Loading
- Loading