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

4714 Gold Cup Lane
Hollywood, SC 29449
Elyssa St.pierre with Southeastern, original listing - (843) 458-0827

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,350,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: --
Agency: Southeastern
Agency Phone: (843) 458-0827

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2001
Notes: Welcome to your dream home--an exquisite, luxury custom residence boasting 4 bedrooms and 3.5 bathrooms, meticulously renovated in 2021 with no expense spared. Nestled on a beautifully landscaped homesite, this property exudes tranquility and elegance from every corner. As you approach, you'll be captivated by the new custom Mahogany double front doors and charming copper gas lanterns, creating a welcoming Charleston ambiance. Inside, the foyer impresses with its soaring two-story ceilings and a grand staircase adorned with dramatic custom newel posts and shaker-style wainscoting. Bespoke charm and luxury details throughout from the cooper brown stained white oak flooring, marble countertops and tiles, to the antique vanity mirrors and classic trim details. The spacious dining room, conveniently located to the right of the entry, flows seamlessly into a chef's dream kitchen, featuring an 10' island with leathered marble countertops and a farm sink. Custom shaker-style cabinets to the ceiling, a GE Monogram 48" range, a 48" built-in refrigerator with panels, a custom hood vent, 180 bottle built in wine ref., GE paneled dishwasher quartz perimeter countertops, and a Carrara marble backsplash complete the gourmet space. Adjacent to the kitchen is a charming office overlooking the backyard and a walk-in pantry with a recessed pocket door, built-in shelving, storage cabinet, and dedicated space for coffee bar and small appliances. <br /> <br /> The living room is a showstopper with its 20-foot high ceilings, a classic carved wood mantel, and a gas fireplace flanked by 8' solid Mahogany doors leading to a screened porch area with custom shades for privacy. The expansive first-floor master suite is a serene retreat, featuring a custom trey ceiling, large windows for ample natural light, and a spa-like bathroom with leathered marble countertops, designer sconce lighting, a freestanding tub, marble tile floors, and a luxurious tiled shower. A spacious walk-in closet with a custom organization system completes this sanctuary. Also, on the first floor you will find an exquisite powder bath with marble floors, and classical brass leg marble top vanity.<br /> <br /> Throughout the home, you'll find an abundance of beautiful windows, bathing the interior in natural light and offering views of the inviting green spaces and majestic trees. Outdoor entertaining is a delight with two dedicated areas: open the French wood doors to the screened porch, or gather around the stone-walled paver patio area for cozy fire pit evenings. <br /> <br /> Upstairs, discover a versatile bonus space perfect for a home office, media room, or a potential fifth bedroom. Down the hall, two guest bedrooms share a Jack and Jill bathroom with a luxurious tile shower and private vanity areas for each. Across the hall, an additional spacious bedroom with a private ensuite provides comfort and privacy for guests.<br /> <br /> Stono Ferry in Hollywood, South Carolina, is a picturesque, gated community nestled along the Intracoastal Waterway, just a short drive from the vibrant city of Charleston. Known for its rich history and stunning natural beauty, Stono Ferry offers a tranquil setting with oak-lined streets and breathtaking marsh views. The community is centered around its award-winning golf course, which provides challenging play and scenic landscapes for golf enthusiasts. Residents enjoy a variety of amenities, including a clubhouse, tennis and pickleball courts, swimming pools, and an equestrian center, fostering an active and social lifestyle. With its blend of Southern charm and modern conveniences, Stono Ferry is an ideal place for anyone seeking a serene, community-oriented environment. Stono Ferry is also home to the annual Charleston Steeplechase. Convenient to local shops and restaurants and Downtown Charleston. Schedule a private showing today.
MlsNumber: --
ListingId: 24019332


Listing Provided By: Southeastern, original listing
Phone: (843) 458-0827
Office Phone: (843) 458-0827
Agent Name: Elyssa St.pierre
Disclaimer: Copyright © 2024 Charleston Trident Association of REALTORS. 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 = 2324 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;
Real Estate Expert Photo for Nate Gainey
Nate Gainey
ASCIIThree Real Estate
Call Today!: (843) 868-4235

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App