Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2332 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2332 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2332 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

8736 Herons Walk
North Charleston, SC 29420
Melanie Dehaven with Carolina Elite Real Estate, original listing - (843) 225-8830

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $625,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: --
Agency: Carolina Elite Real Estate
Agency Phone: (843) 225-8830

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: You will love everything about this single-story home with bonus room/4th bedroom over the garage! This home has been impeccably maintained by the current owners and it shows as you walk throughout. Upon entering you are greeted by gleaming hardwood floors and an open view directly through the spacious Family Room and Sunroom to the tranquility of the golf course. As you sit in your Sunroom, you will enjoy the expansive views of the #13 fairway and the sights and sounds of nature. The Sunroom is climatized with a remote controlled ductless mini-split for year round comfort and enjoyment of this space. Entertain family and friends in your large Family Room as you gather around the cozy gas fireplace on cool evenings. The well-appointed Ktchen has beautiful white quartz counters and cabinets providing a bright and airy feel. An informal eating area off the Kitchen has a bay window with golf course views and, for more formal gatherings, the large separate Dining Room is both functional and beautiful with a soaring ceiling and custom moldings. <br /> <br /> The Primary suite is also spacious and has a tray ceiling, beautiful hardwood flooring and offers golf course views. The deluxe primary Bathroom has been updated exquisitely with quartz® vanity, a custom tiled shower and a large jetted tub. This suite is a great place to retreat to at the end of your day. <br /> <br /> Two ample-sized guest bedrooms are located on the opposite side of the home for added privacy from the Primary Bedroom. The guest bathroom has been completely updated with a gorgeous tiled floor and custom-tiled shower. This modern guest bathroom will be sure to please your guests! <br /> A fourth bedroom or bonus room is located upstairs over the garage and has a full bathroom plus a TON of storage space! <br /> The oversized laundry room with quartz-top and undermount laundry sink leads to the 2 car garage with painted floor and side entry pedestrian door. <br /> <br /> This home has so much to offer including easy single-story living in this open floor plan. Elegant plantation shutters adorn all windows; an encapsulated crawlspace for peace of mind; a paved patio area with lots of bushes and mature landscaping offering privacy from the golf course while enjoying the outdoor patio area. The TV in the Sunroom conveys as does the Kitchen refrigerator, the Washer and the Dryer! All of this and more is waiting for new owners to enjoy! Do not delay in seeing this great home today! <br /> <br /> Coosaw Creek Country Club is the area's premiere private country club offering unlimited golf, swimming, tennis and pickle ball! There is a one-time, nonrefundable equity fee for all Buyers of $20,000 due at closing plus ANNUAL COUNTRY CLUB DUES ARE CURRENTLY $4,800, quarterly food minimums at the Palmetto Grill of $150 and ANNUAL CAPITAL RESERVE FUND of $1430. <br /> <br /> ANNUAL HOA DUES ARE CURRENTLY $1,830 which includes the 24-hr manned security gate, common area expenses, etc.
MlsNumber: --
ListingId: 25002603


Listing Provided By: Carolina Elite Real Estate, original listing
Phone: (843) 225-8830
Office Phone: (843) 225-8830
Agent Name: Melanie Dehaven
Disclaimer: Copyright © 2025 CHS Regional MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2332 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Miranda Stone
ASCIIHome Grown Real Estate
Call Today!: (843) 908-2702

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App