Twitter
Facebook
Email
|
Experience the ultimate Lowcountry waterfront lifestyle at 975 Mayfield Street on the Ashley River. Set on expansive acreage with panoramic water views stretching from the river to Ashborough Lake, this elevated retreat is designed for boating, entertaining, and serenity. Cruise unrestricted by boat all the way to Charleston Harbor, fish for redfish, trout and bass from your backyard, or relax on the incredible grilling porch overlooking the water. The home features a beautifully upgraded chef's kitchen, renovated baths, grand open living spaces, modern finishes, and a fully finished garage. A $350,000 engineered seawall with a 50-year rating creates the ideal setting for future dock permitting or non-permanent dock floats, while the large 2-car workshop shed offers endless possibilities.The immaculate drive-under garage space offers exceptional flexibility for car collectors, boating enthusiasts, workshops, storage, entertaining, or hobby space, with room to accommodate approximately 8-9 vehicles beneath the home plus an additional 2-car outbuilding/workshop.
| DAYS ON MARKET | 18 | LAST UPDATED | 5/7/2026 |
|---|---|---|---|
| TRACT | Ashborough | YEAR BUILT | 1990 |
| COMMUNITY | 62 - Summerville/Ladson/Ravenel to Hwy 165 | GARAGE SPACES | 7.0 |
| COUNTY | Dorchester | STATUS | Active |
| PROPERTY TYPE(S) | Single Family |
| Elementary School | Beech Hill |
|---|---|
| Jr. High School | East Edisto |
| High School | Ashley Ridge |
| ADDITIONAL DETAILS | |
| AIR | Ceiling Fan(s), Central Air |
|---|---|
| AIR CONDITIONING | Yes |
| APPLIANCES | Built-In Electric Oven, Dishwasher, Disposal, Gas Cooktop, Microwave, Refrigerator |
| AREA | 62 - Summerville/Ladson/Ravenel to Hwy 165 |
| CONSTRUCTION | Cement Siding |
| EXTERIOR | Balcony, Dock |
| GARAGE | Yes |
| HEAT | Heat Pump |
| INTERIOR | Cathedral Ceiling(s), Ceiling Fan(s), Eat-in Kitchen, Pantry, Walk-In Closet(s) |
| LOT | 2.77 acre(s) |
| LOT DESCRIPTION | Waterfront |
| LOT DIMENSIONS | 2.77 |
| SEWER | Public Sewer |
| STORIES | 2 |
| STYLE | Contemporary |
| SUBDIVISION | Ashborough |
| TAXES | 6963.2 |
| WATER | Public |
| WATERFRONT | Yes |
| WATERFRONT DESCRIPTION | Canal Front, Canal Access, Lake Front, Pond, River Access, River Front, Seawall |
MORTGAGE CALCULATOR
TOTAL MONTHLY PAYMENT
0
P
I
*Estimate only
| SATELLITE VIEW |
| / | |
We respect your online privacy and will never spam you. By submitting this form with your telephone number
you are consenting for Angie and Chad
Johnson to contact you even if your name is on a Federal or State
"Do not call List".
Listing Provided by IndigoOak - Christie's International Real Estate
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, Inc (CTMLS). All real estate listings are marked with the CTMLS Broker ReciprocitySM thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers.
The broker providing this data believes them to be correct, but advises interested parties to confirm them before relying on them in a purchase decision.
Copyright 2026 Charleston Trident Multiple Listing Service, Inc. All rights reserved.
The broker providing this data believes them to be correct, but advises interested parties to confirm them before relying on them in a purchase decision.
Copyright 2026 Charleston Trident Multiple Listing Service, Inc. All rights reserved.
This IDX solution is (c) Diverse Solutions 2026.