• $2,190,000

    NEW ($12,473.65/mo.)
    • 4
    • 3481
    • 2.77
  • House
  • MLS® #: 23011672
  • Days on Website: 5
  • 975 Mayfield Street

  • Summerville, SC 29485
  • Ashborough

  • MLS® 23011672 is located at 975 Mayfield Street in Summerville, SC. This house offers 4 bedrooms, 3.5 baths, and is 3481 square feet.

Welcome to the most unique property you will find in Summerville. This property is one of the 5 exclusive estate lots in the Ashborough Farms subsection of Ashborough. This exclusive property is not in the HOA and the deed is not tied to the neighborhood covenants and restrictions. This 2.77 acre property rests on banks of the Ashley River. Enjoy 230' of River frontage with your newly built boat slip. There is a boat lift permit that is active and will convey to the buyer. Walking into the home, you'll notice the flowing hardwoods throughout most of the main living area. To the left is the formal dining room that is currently being used as an office.with the breathtaking Ashborough lake serving as your neighbor and providing a stunning view from your own front porch. As you drive down this personal pathway, take in the meticulously manicured acreage and the presence of nine majestic oak trees thoughtfully placed throughout the property. This unique estate truly embraces the natural surroundings, allowing you to immerse yourself in the beauty of the environment. Step out of your back door and enter your own private oasis. Take a leisurely stroll down to your newly constructed custom steel boat slip, a valuable asset worth $400,000. Here, you can relish in the tranquility of the surroundings, sit under the starry night sky, or embark on an evening boat ride with your loved ones. Escape down the Ashley River and journey into the majestic Charleston Harbor, all while being enveloped by the enchanting beauty of the Lowcountry, your new home. Walking into the home, you'll notice the flowing hardwoods throughout most of the main living area. To the left is the formal dining room that is currently being used as an office. Walking straight into the home, the soaring vaulted ceilings will certainly draw your eye to the back of the home that includes the back wall of windows. To the left of the family room is the secondary dining area and fully renovated kitchen. The sellers removed walls in this area to open up the living area, you'll appreciate the improvement. In 2019 the kitchen experienced a full renovation to include features a 6 burner gas cooktop, custom Sapele hardwood cabinetry, granite countertops, new dishwasher, trash compactor, wall oven and built in microwave. The flow of the kitchen and dining area make for a comfortable flow for your gatherings. Relax in the sunroom that had new flooring installed in 2021. The home recently had new Anderson doors installed leading to the back patio. The main floor master suite is on the right side of the home, has gone through an extensive renovation and features access to the back patio. Starting with the Italian Porcelain Flooring throughout, the custom wood shutters, custom designed walk in closet and fully renovated ensuite, this will surely please. The ensuite features dual vanities, custom designed walk in shower and soaking tub. Walking upstairs you'll notice the wide staircase that is impressive to see as you walk in the front doors. Upstairs you'll find the secondary master bedroom with a fully renovated bathroom and walk-in closet. The 2 additional guest rooms both offer walk-in closets. The guest bath for these 2 rooms has also gone through a complete renovation. Walking out of one of the multiple doors to the back patio/ deck area, you'll see the extensive view of the backyard and the Ashley River. There is plenty of room on this deck area to enjoy many of the reasons we enjoy the lowcountry! Walking down the staircase, you'll notice the large pavilion area that is perfect for many functions. The sellers have also: - replaced both HVAC units in 2020 and 2022 and Ergonomically redesigned and replaced AC duct work on lower level. - added all new cement plank, removed the stucco exterior wall and built in the block wall surrounding the garage and repainted the entire exterior. - added gutters - Custom drainage system for roof drains - poured the 300 ft x 15ft x 6" thick Cement Driveway and 4000 sqft Concrete access Pad for garages - 22 zone sprinkler system - extensive landscaping, including sod and landscape uplighting - new 24x25 metal workshop, with electricity on a full slab - 2019 new garage doors and openers - Closed cell spray foam under the first floor living area for energy efficiency - redesigned the entire 10+ car garage that included new concrete flooring - the list with this property goes on and on and on. This is a fabulous home that is nothing like you've seen and will certainly please!

Essential Information

  • MLS® #23011672
  • Price$2,190,000
  • Bedrooms4
  • Full Baths3
  • Half Baths1
  • Square Footage3,481
  • Acres2.77
  • Year Built1990
  • TypeHouse
  • StyleTraditional

Community Information

  • Address975 Mayfield Street
  • SubdivisionAshborough
  • CitySummerville
  • CountyDorchester
  • StateSC
  • Zip Code29485


62 - Summerville/Ladson/Ravenel to Hwy 165


  • Neighborhood AmenitiesCable Avail, Trash Pickup
  • FeaturesTankless Water Heater
  • Parking Spaces5
  • # of Garages5
  • Is WaterfrontYes


Attached, Off-st Prkng, 5 Car Garage


Attached, Off-st Prkng, 5 Car Garage


  • CoolingCentral
  • Stories2 Story


Ceramic Tile, Wall to Wall Carpet, Wood, Stone

Interior Features

Ceilings - 9'+, Ceiling - Cathedral/Vaulted, Kitchen Island, Ceiling - Smooth, Window Treatments - Some, Walk-In Closets


Electric, Forced Air, Heat Pump


  • ExteriorCement Plank
  • RoofArchitectural
  • ConstructionPre-Owned
  • FoundationElev Construction, Slab

Exterior Features

Covr'd Patio, Deck, Metal F/encl, Gutters, Lawn Irriga., Part'l Fence, Patio, Some Storm Wnd/Doors, Strg/outbldg, Storm Doors, Therml Wn/dr, Work Shop, Porch - Front Porch, Boatlift, Dock Existng, Some Thermal Wnd/Doors, Spcl Lights, Strm Windows

Lot Description

W/f-shallow, 2-5 Acres, Lakefront, Lake view, River Access, Riverfront, River View, Stream, W/frnt-deep, Canal

School Information

  • ElementaryBeech Hill
  • MiddleEast Edisto
  • HighAshley Ridge

Additional Information

  • Days on Website5
  • Office: Carolina One Real Estate
  • Office Contact: 843-779-8660

Aerial View/Directions

Birdseye View

Please provide a valid email address.

Active Listings Similar to 975 Mayfield Street

Photo of Listing #23003927

10812 Dorchester Road


4 Bed, 3 Bath, 3028 Sqft, 3.62 Acres
Summerville, SC
The Boulevard Company, Llc

Photo of Listing #22008468

823 Hamlet Circle


6 Bed, 8 Bath, 7679 Sqft, 1 Acre
Crowfield Plantation
Goose Creek, SC
Carolina One Real Estate

Photo of Listing #23010611

118 Peninsula Court


4 Bed, 4 Bath, 2800 Sqft, 1.85 Acres
Poplar Grove
Ravenel, SC

Photo of Listing #22026722

116 Peninsula Court


4 Bed, 5 Bath, 3745 Sqft, 1.73 Acres
Poplar Grove
Ravenel, SC

Photo of Listing #22027619

3945 Bulow Landing Road


3 Bed, 4 Bath, 3573 Sqft, 0.8 Acres
Poplar Grove
Ravenel, SC

Photo of Listing #23009207

4089 Ten Shillings Way


5 Bed, 5 Bath, 4721 Sqft, 0.63 Acres
Poplar Grove
Ravenel, SC
Carolina One Real Estate

Recently Sold Listings Similar to 975 Mayfield Street

Photo of Listing #21030469

3990 Ten Shillings Way


5 Bed, 5 Bath, 3622 Sqft, 0.68 Acres
Poplar Grove
Ravenel, SC

Photo of Listing #23004073

4349 Lady Banks Lane


3 Bed, 4 Bath, 3163 Sqft, 0.82 Acres
Poplar Grove
Hollywood, SC

Photo of Listing #22016062

3001 Bushy Park Road


6 Bed, 9 Bath, 8280 Sqft, 4.82 Acres
Moncks Corner, SC

Photo of Listing #23002065

1416 Mcpherson Landing


4 Bed, 5 Bath, 3405 Sqft, 0.55 Acres
Rushland Landing
Johns Island, SC

Photo of Listing #22021937

1931 Capri Drive


4 Bed, 4 Bath, 2449 Sqft, 0.38 Acres
Capri Isles
Charleston, SC

Photo of Listing #22026457

1431 Headquarters Plantation Drive


6 Bed, 4 Bath, 4905 Sqft, 0.43 Acres
Headquarters Plantation
Johns Island, SC

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 Carolina One Real Estate 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.

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 2023 Charleston Trident Multiple Listing Service, Inc. All rights reserved.