This site refreshes every 15 minutes, so the listings are always live, fresh, and current from all SC major market MLS boards with the newest properties
$1,358,000

Status: For Sale

Property type: Detached House
Year built: 1990
List Date: 2026-05-07
Lot Size: 2.7700 acres
Area
3481 ft2
Bedrooms
4
Half Baths
1
Full Baths
4
Days For Sale
7

Location

Amenities

  • 2 - 5 Acres
  • 2 Car Garage
  • 5 Car Garage
  • Architectural
  • Balcony
  • Bonus
  • Canal Access
  • Ceiling - Cathedral/Vaulted
  • Ceiling - Smooth
  • Ceiling Fan(s)
  • Ceiling Fan(s)
  • Central Air
  • Ceramic Tile
  • Contemporary
  • Dock - Existing
  • Dock Facilities
  • Eat-in Kitchen
  • Electric Dryer Hookup
  • Family
  • Garden Tub/Shower
  • Great
  • Heat Pump
  • Lake Front
  • Lakeview
  • Marshfront
  • Marshview
  • Office
  • Pantry
  • Pond
  • Pond Site
  • River Access
  • River Front
  • Riverview
  • Seawall
  • Separate Dining
  • Storm Window(s)
  • Study
  • Sun
  • Utility
  • Walk-In Closet(s)
  • Walk-In Closet(s)
  • Walk/Jog Trails
  • Washer Hookup
  • Wood

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.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.

What's YOUR Home Worth?

Schools

3rd - 12th Schools in 29485

Name
Address
Phone
Type
Grade
225 Midland Parkway
843-851-5015
Private
3rd - 12th

6-8 SPED Schools in 29485

Name
Address
Phone
Type
Grade
1011 Beech Hill Road
8436952451
Public
6-8 SPED

9-12 SPED Schools in 29485

Name
Address
Phone
Type
Grade
9800 Delemar Highway
8436954900
Public
9-12 SPED

K-12 SPED Schools in 29485

Name
Address
Phone
Type
Grade
1520 Old Trolley Road
8436959305
Public
K-12 SPED

PK-5 SPED Schools in 29485

Name
Address
Phone
Type
Grade
1001 Beech Hill Road
8438213970
Public
PK-5 SPED
301 Chandler Creek Rd
8436955205
Public
PK-5 SPED
20 King Charles Circle
8438717400
Public
PK-5 SPED
5201 Old Glory Lane
8438325550
Public
PK-5 SPED
10 King Charles Circle
8438713230
Public
PK-5 SPED
324 Gnarly Oak Ln
8436955201
Public
PK-5 SPED

Show on the map:
Road Map
Fly by view
Street view

James Schiller

Realtor, Brand Name Real Estate

Happy Clients

SEE THIS PROPERTY



    ©2026CTMLS,GGMLS,CCMLS& CMLS

    The information is provided exclusively for consumers’ personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the MLS boards of the SC Realtors.

    Listing Provided by IndigoOak - Christie's International Real Estate

    975 Mayfield Street, Summerville, SC 29485
    MLS #29485
    $1,358,000
    SHARE

    SC mortgage interest rates live. View the latest and most current home loan mortgage interest rates in South Carolina.