Final home!! Find your slice of paradise at The Overlook at Copahee Sound! This drive under semi-custom home is perfectly located amongst the low country's natural beauty, where you will immediately feel connected to the coastal landscape with it's ocean breeze and panoramic marsh views. This home offers stunning double front & rear porches to look over the marsh and sound. Upon entry of the first floor of The Pinckney, you will find a bright & open layout with the kitchen overlooking the great room. Dual primaries, one on each floor plus 2 additional bedrooms and a loft, all open out to the covered porches.The family Room includes a 42'' fireplace with a floating mantel and shiplap accent. Mohawk 5'' plank Hardwoods flow throughout the first floor as well as the owner's suite, upstairs hall and loft! The second floor features open stair railing & offers a 2nd Master suite as well as a Loft & 2 other bedrooms and full bath. This home includes many more amazing features. Contact on site agent for more details! This boutique community is located within the Ten Mile Historic District & features a public Kayak launch. Also, located within the Highly-rated Wando School District and within minutes from the award-winning shopping and dining at the Mount Pleasant Towne Center or take a short drive to relax on the beautiful Isle of Palms & Sullivan's Beaches!
As the MLS and public records start to fill up, we'll list the details here.
Public record
Public record
Zoning
Permits
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
—
Year renovated
—
Finished Sq. Ft.
—
Unfinished Sq. Ft.
—
Total Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Charleston County
APN
—
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Nov 29, 2025.
R-4
Low Density Residential District
The R-4, Low Density Residential Zoning District implements the Urban/Suburban Mixed Use policies of the Comprehensive Plan.
Permitted uses
Include but are not limited to:
Housing-Group
Housing-Single unit
Infrastructure
Educational/school
Fire house
Library
Museum / gallery
Police station
Apr 30, 2026 • Final
New residential home
Construct a new four-bedroom single-family home.
New construction
Apr 23, 2026 • Final
New residential mechanical
Install a prefabricated fireplace.
HVAC
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Climate risks
10/10 Flood Factor
Estimated 80%+ chance of a flood reaching the building in the next 30 years
5/10 Fire Factor
5% chance of being in a wildfire in next 30 years
10/10 Heat Factor
7 days above 105° expected this year, 19 days in 30 years
9/10 Wind Factor
99% chance of strong winds in next 30 years
3/10 Air Factor
2 unhealthy days expected this year, 3 days in 30 years
Provided by First Street
Historical weather
Awendaw, SC • 29429
Average low and high temperatures (°F)
56
35
62
42
72
50
77
57
82
66
89
72
90
76
86
73
83
68
75
57
71
51
61
41
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
99/ 100
Exceptional sunlight
Sunscore
There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
9.7 hrs
6.8 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 3904 Seafood Rd
$1,269,864
$26K under list price of $1.30M
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $875K to $1.4M.