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;

8867 E Fairway Woods Circle
North Charleston, SC 29420
Larry Mazalatis with AgentOwned Realty, original listing - (843) 871-9133

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $629,777
Beds: 4
Baths: Full: 3
Status: Active
SqFt: --
Agency: AgentOwned Realty
Agency Phone: (843) 871-9133

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: Get ready to be impressed! Welcome home to 8867 E Fairway Woods located in the gated golf course community of Coosaw Creek! This home has a great floor plan, it's on the golf course, is a smart home (mostly all lights, thermostats, even the kitchen sink can be controlled by an alexa command!) and it has a built in pool. Upon entering in to the two story foyer, to your right is the formal dining room which is the perfect size for entertaining and has arched doorways, creating an open flow in to the living room and kitchen. The living room has vaulted ceilings, a gas fireplace and is open to the kitchen. The kitchen is a chef's delight and has been updated to offer a gas cooktop, two ovens, stainless steel appliances, granite countertops and an oversized island that can seat at least four!Access the large screened in porch from the kitchen. This porch is perfect for relaxing before you step out to your gorgeous saltwater pool. Head back inside to the first floor primary bedroom which has views of the golf course, a tray ceiling, plantation shutters as well as access to the porch. The primary bath has been updated as well and offers dual vanities, a gorgeous shower with body sprays and a walk in closet with ample storage. On the other side of the first floor is another bedroom, perfect for guests, with a full bathroom located just outside of it. On this same side of the house you'll find the laundry room which has its own sink and extra cabinet storage. Upstairs, you'll find two more bedrooms with large closets, a full bathroom in the hallway as well as some attic storage. The huge FROG can be used as a fifth bedroom if needed or just a great media/entertainment room. Coosaw Creek is a hidden gem and the golf course is a beauty offering an 18 hole Par 71 course designed by Arthur Hills, a driving range as well as a chipping and putting range. There are leagues and tournaments offered as well as a pro shop. Unlimited rounds of golf for the member, spouse/significant other and dependent children up to the age of 23. The community pool facility features a salt water junior Olympic size salt water pool, a covered cabana, pool side service available from the bar and kitchen, kids splash pad, playground, tennis courts and pickleball, volleyball, basketball, shuffleboard and bocce area. So many fun events and activities are always on the calendar at the clubhouse which makes it a great way to meet people! Don't forget the delicious restaurant, The Palmetto Grill, also located in the clubhouse. This neighborhood is convenient to the airport, AFB, Bosch and Boeing. Dorchester District Two Schools! Come live the good life!
MlsNumber: --
ListingId: 24025355


Listing Provided By: AgentOwned Realty, original listing
Phone: (843) 871-9133
Office Phone: (843) 871-9133
Agent Name: Larry Mazalatis
Disclaimer: Copyright © 2024 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