Viewing Listing MLS# 26013264
$1,358,000 | 4 beds | 4 full baths | 1 half baths | 3,481 sqft
Summerville, SC 29485
- 4Beds
- 4Full Baths
- 1Half Baths
- 3,481SqFt
- 1990Year Built
- 2.77Acres
- MLS# 26013264
- Residential
- Single Family Detached
- Active
- Approx Time on Market27 days
- AreaSummerville/ladson/ravenel Dorchester
- CountyDorchester
- Subdivision Ashborough
Overview
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.
Agriculture / Farm
Grazing Permits Forest Service: No
Grazing Permits Private: No
Grazing Permits Blm: No
Farm Credit Service Incl: No
Association Fees / Info
Community Features: Dock Facilities, Walk/Jog Trails
Bathroom Info
Halfbaths: 1
Fullbaths: 4
Building Info
Levels: Two
Window Features: Storm Window(s)
Year Built: 1990
Floors: Ceramic Tile, Wood
Business Info
Buyer Compensation
Exterior Features
Fencing: Rear Only
Misc Ext: Patio, Covered
Exterior Features: Balcony, Dock - Existing
Style: Contemporary
Garage / Parking
Gar Pkg: 2 Car Garage, 5 Car Garage
Garage: Yes
Green / Env Info
Interior Features
Interior Features: Ceiling - Cathedral/Vaulted, Ceiling - Smooth, Garden Tub/Shower, Walk-In Closet(s), Ceiling Fan(s), Bonus, Eat-in Kitchen, Family, Great, Office, Pantry, Separate Dining, Study, Sun, Utility
Laundry Features: Electric Dryer Hookup, Washer Hookup
Lot Info
Lot Size: 2.77
Lot Desc: 2 - 5 Acres, Lakeview, Marshview, Riverview
Lot Size Units: Acres
Acres: 2.77
Lot Sqft: 120661.2
Irrigation Water Rights: No
Offer Compensation
Other
Mobile Home Remains: No
Property Info
Property Type: A
Stories: 2
Foundation: Raised
Exterior: Cement Siding
Roof: Architectural
Property Subtype: No
Building Area Units: Square Feet
Home Warranty: No
Habitable Residence: No
Room Info
Beds: 4
Primary Bedroom Features: Ceiling Fan(s), Walk-In Closet(s)
Room Master Bedroom Level: Lower
Sale / Lease Info
Lease Renewal Option: No
Lease Considered: No
Lease Assignable: No
Special Features
Sqft Info
Sqft: 3481
Unit Info
Utilities / Hvac
Water Source: Public
Heating: Yes
Heat: Heat Pump
Water Sewer: Public Sewer
Cooling: Central Air
Cooling: Yes
Waterfront / Water
Water Front Features: Canal Access, Lake Front, Marshfront, Pond, Pond Site, River Access, River Front, Seawall
Waterfront: Yes
Directions
Use GpsCourtesy of listing office 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. Real estate listings held by brokerage firms other than Realty ONE Group Coastal are marked with the Broker ReciprocitySM logo or the Broker ReciprocitySM thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Last updated on 06-03-2026 11:52 PM EST .
The broker providing these 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.
Quick Search
My Listings
MLS# 25031286 / Residential
$529,500 in Summerville, SC
MLS# 26013471 / Vacant Land
$210,000 in Moncks Corner, SC
MLS# 26014355 / Residential
$393,000 in North Charleston, SC
MLS# 26006618 / Residential
$339,999 in Summerville, SC
MLS# 26010824 / Residential
$279,900 in Ladson, SC
MLS# 25017637 / Residential
$871,000 in North Charleston, SC
MLS# 26013341 / Residential
$195,000 in North Charleston, SC
MLS# 26013038 / Residential
$589,000 in Johns Island, SC
MLS# 26014423 / Rentals
$1,800 in North Charleston, SC
MLS# 26009843 / Residential
$310,000 in Ladson, SC