Notice: Function rest_validate_value_from_schema was called incorrectly. The "type" schema keyword for inspectorHtml can only be one of the built-in types: array, object, string, number, integer, boolean, and null. Please see Debugging in WordPress for more information. (This message was added in version 5.5.0.) in /home/drewsineath/public_html/wp-includes/functions.php on line 6121
975 Mayfield Street, Summerville, SC 29485
New Listing
$1,358,000
Property Type:
Residential
Bedrooms:
4
Baths:
4.5
Square Footage:
3,481
Lot Size (sq. ft.):
120,661
Status:
Active
Current Price:
$1,358,000
List Date:
5/07/2026
Last Modified:
5/07/2026
Description
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.
Supplements: 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.
More Information MLS# 26013264
Contract Info
Primary Structure List Price/SqFt: 390.12
Sub-Type: Single Family Detached
MLS List Date: 2026-05-07
Status: Active
List Price: $1,358,000
Current Price: $1,358,000
Location, Tax & Legal
Legal Description: Tract D
Tax Map #: 1610000078
Street #: 975
Street Name: Mayfield
Street Suffix: Street
County: Dorchester
State: SC
Zip Code: 29485
Area: 62 - Summerville/Ladson/Ravenel to Hwy 165
Tax District: 207 - City of Summerville
Subdivision: Ashborough
Elementary School: Beech Hill
Middle School: East Edisto
High School: Ashley Ridge
Directions: USE gps
General Property Info
Primary Bedroom – Main Level: Yes
C/R: No
Ground Level: No
Stories: 2
HOA Fee: No
Ownership: Fee Simple
Occupancy: Owner
Potential Short Sale: No
Other Structures Y/N: No
Bedrooms: 4
Baths - Full: 4
Baths - Half: 1
Baths - Total: 4.5
Primary Structure Apx SqFt: 3481
Year Built: 1990
Acreage: 2.77
Tax/Fees
Taxes: 6963.2
Regime Fee: No
Office/Member Info
Seller Concessions Negotiable Y/N: Yes
SqFt Source
Tax Records: 1
Roof
Architectural: 1
Lot Description
2 - 5 Acres: 1
Canal: 1
Lakefront: 1
Lakeview: 1
Marshfront: 1
Marshview: 1
Pond: 1
Pond Site: 1
River Access: 1
Riverfront: 1
Riverview: 1
Misc Exterior
Balcony: 1
Dock - Existing: 1
Fence - Rear Only: 1
Patio: 1
Patio - Covered: 1
Porch - Rear: 1
Sea Wall: 1
Storm Windows: 1
Exterior
Cement Plank: 1
SF Detached Style
Contemporary: 1
Attic Features
Access: 1
Foundation
Elv. Construction: 1
Garage/Parking
2 Car Garage: 1
5 Car Garage: 1
Stories/Levels
2 Stories: 1
Equipment/Appliances
Built-In Electric Oven: 1
Ceiling Fan: 1
Dishwasher: 1
Disposal: 1
Electric Dryer Hookup: 1
Gas Cooktop: 1
Microwave: 1
Refrigerator: 1
Washer Hookup: 1
Cooling
Central Air: 1
Heat
Heat Pump: 1
Rooms
Bonus: 1
Breakfast Room: 1
Eat-In-Kitchen: 1
Family: 1
Great: 1
Office: 1
Pantry: 1
Separate Dining: 1
Study: 1
Sun: 1
Utility: 1
Amenities
Boat Dock: 1
Cable TV: 1
Dock Facilities: 1
Walk/Jog Trails: 1
Assumable
No: 1
Primary Bedroom
Ceiling Fan: 1
Downstairs: 1
Walk-In Closets: 1
Proposed Financing
Any: 1
Misc Interior
Adaptable for Elevator: 1
Ceiling - Cathedral/Vaulted: 1
Ceiling - Smooth: 1
Garden Tub/Shower: 1
Walk-In Closets: 1
New Owned
Pre-Owned: 1
Floors
Ceramic Tile: 1
Wood: 1
Possession
At Closing: 1
Water/Sewer
Public Sewer: 1
Public Water: 1
Property Features
SqFt Source: Tax Records
SF Detached Style: Contemporary
Lot Description: 2 - 5 Acres; Canal; Lakefront; Lakeview; Marshfront; Marshview; Pond; Pond Site; River Access; Riverfront; Riverview
Misc Exterior: Balcony; Dock - Existing; Fence - Rear Only; Patio; Patio - Covered; Porch - Rear; Sea Wall; Storm Windows
Roof: Architectural
Exterior: Cement Plank
Attic Features: Access
Foundation: Elv. Construction
Misc Interior: Adaptable for Elevator; Ceiling - Cathedral/Vaulted; Ceiling - Smooth; Garden Tub/Shower; Walk-In Closets
New Owned: Pre-Owned
Rooms: Bonus; Breakfast Room; Eat-In-Kitchen; Family; Great; Office; Pantry; Separate Dining; Study; Sun; Utility
Primary Bedroom: Ceiling Fan; Downstairs; Walk-In Closets
Cooling: Central Air
Floors: Ceramic Tile; Wood
Heat: Heat Pump
Possession: At Closing
Amenities: Boat Dock; Cable TV; Dock Facilities; Walk/Jog Trails
Proposed Financing: Any
Assumable: No
Documents
Owner list of upgrades since purchase ›
Listing Office:
IndigoOak - Christie's International Real Estate
Last Updated: May - 07 - 2026
Properties marked with IDX logo are provided courtesy of Charleston Trident Multiple Listing Service, Inc.
The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the Charleston Trident Multiple Listing Service. Real estate listings held by brokerage firms other than the website owner are marked with the Broker Reciprocity logo or the Broker Reciprocity thumbnail logo and detailed information about them includes the name of the listing brokers. The broker providing this data believes it to be correct, but advises interested parties to confirm them before relying on them in a purchase decision.
Information is provided exclusively for consumers' personal, non-commerical use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.