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 = 2321 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 = 2321 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 = 2321 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;

1756 Indigo Island Drive
Hanahan, SC 29410
Melissa Reid with Matt O'Neill Real Estate, original listing - (843) 654-7777

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $949,000
Beds: 5
Baths: Full: 3, ½: 2
Status: Active
SqFt: --
Agency: Matt O'Neill Real Estate
Agency Phone: (843) 654-7777

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: Nestled in the desirable Goose Creek Reservoir community of Indigo Island Reserve in Hanahan, this custom-built home offers the perfect blend of luxury, functionality, and marsh and water views. From the moment you arrive, the immaculate landscaping and grand double-stairway leading to the full-width front porch set a tone of elegance and warmth. Inside, the two-story foyer impresses with a sweeping staircase, elaborate railings, and gleaming hardwood floors with custom inlays, while crown molding enhances the home's refined appeal.To the right of the foyer, a pillared entrance leads to a formal dining room featuring a tray ceiling and plantation shutters--an ideal space for hosting dinner parties or intimate gatherings.Passing by the convenient three-stop elevator, you're drawn to the open, light-filled family room, complete with a cozy fireplace flanked by custom built-ins and access to the expansive screened porch. The adjacent kitchen is both stylish and highly functional, with ample cabinetry, granite countertops, sleek appliances, and a center island. Bay windows illuminate the eat-in area, creating a welcoming space to enjoy morning coffee or casual meals.<br /> <br /> The main level primary suite is a serene retreat with porch access, a tray ceiling, and an ensuite bath with a double sink vanity, jetted tub, step-in shower, and walk-in closets. Just off the kitchen, a spacious laundry room with abundant storage offers both convenience and efficiency.<br /> <br /> The lanai, which spans the width of the home, offers a peaceful setting to relax or entertain while enjoying views of local wildlife.<br /> <br /> Upstairs, the second primary suite offers a private sanctuary with an ensuite bath and walk-in closet. Three additional generously sized bedrooms and a full bath with a double vanity complete the second level. The home's outdoor spaces embrace the Lowcountry's natural beauty, featuring a fenced backyard, a lanai, a new paver patio, and a firepitall overlooking the serene water and marsh. A spacious three-car garage with a newly painted floor adds to the home's appeal, while two new AC units and a new water heater provide extra peace of mind.<br /> <br /> Residents of Indigo Island Reserve enjoy access to the Goose Creek Reservoir for kayaking and canoeing, along with the convenience of being just 2 miles from I-26, 8.3 miles from Charleston International Airport, and 9.2 miles from Park Circle. Don't miss this extraordinary home that offers a luxurious lifestyle immersed in nature.
MlsNumber: --
ListingId: 24028910


Listing Provided By: Matt O'Neill Real Estate, original listing
Phone: (843) 654-7777
Office Phone: (843) 654-7777
Agent Name: Melissa Reid
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 = 2321 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;
Jason Petteway
ASCIIeXp Realty
Call Today!: (206) 853-1979

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App