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.