Title Page Background
DEBUG FN args: Array ( [0] => 2324 [1] => [2] => [3] => agent ) BEFORE: Site: 2324 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2324 Igate: njhud LocID: 2324 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('alhud','usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'alhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2324 [1] => [2] => [3] => lender ) BEFORE: Site: 2324 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2324 Igate: njhud LocID: 2324 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('alhud','usahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'alhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2324 [1] => [2] => [3] => other ) BEFORE: Site: 2324 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2324 Igate: njhud LocID: 2324 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('alhud','usahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'alhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

1988 Long Creek Road
Wadmalaw Island, SC 29487
Henry Robinson with The Cassina Group, original listing - (843) 628-0008

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,999,900
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: --
Agency: The Cassina Group
Agency Phone: (843) 628-0008

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1996
Notes: Tucked away on 3.5 acres of pristine Lowcountry beauty, this waterfront retreat is your personal sanctuary--where privacy, comfort, and outdoor adventure come together in perfect harmony. Tucked away along the Grand Oak-lined Longcreek Road, this estate isn't just a place to live--it's a front-row seat to the best of the Wadmalaw Island waterfront lifestyle. With at least six feet of water at low tide, you can hop in the boat and head out at anytime. A large floating dock and boat lift make it effortless--whether you're setting out for an early-morning fishing trip for Reds and Trout or cruising back just in time for a picture-perfect sunset. After a day on the water, kick back with a glass of wine on the covered pierhead swing or cool off with a swim in the saltwater pool.When it's time to head inside, you can take the back steps or let the elevator do the work (it's conveniently located under cover just a couple of steps outside the garage).<br /> <br /> Inside, the home is flooded with natural light, highlighting the refinished hardwood floors and stunning French doors that frame breathtaking river views from nearly every room. Recent updates add even more appeal, including a brand-new roof (March 2025) and gorgeous new porcelain flooring and shower tile in the primary and guest baths (2024).<br /> <br /> At the heart of the home, the chef's kitchen is ready for entertaining, featuring a high-end Wolf range, custom glass-front cabinetry, a Sub-Zero fridge, an ice maker, a butler's pantry, and a spacious island. The open layout flows seamlessly into the grand living room, where vaulted ceilings, skylights, and a gas fireplace set the perfect scene for cozy nights in. For a more intimate retreat, a separate den with a wood-burning fireplace provides the ideal spot to curl up with a good book.<br /> <br /> The primary suite, tucked away in its own private wing, is a true oasis, complete with multiple closets, a sitting room or office, and a spa-like bath featuring a garden tub, walk-in shower, and dual vanities. On the opposite side of the home, two generously sized guest rooms share a beautifully updated full bath. Downstairs, a massive two bay garage offers plenty of space for multiple vehicles, projects, and all your outdoor gear. With a whole-house Generac generator standing by, you'll have total peace of mind knowing your home stays powered during outages. And for those with a green thumb, an 11'x17' greenhouse equipped with electricity and water will allow your plants and flowers to thrive.<br /> <br /> Located in Longcreek Plantation, one of Wadmalaw Island's most sought-after gated communities, this estate offers the perfect blend of timeless Lowcountry charm and modern convenience. While it feels like a secluded retreat, you're still less than ten minutes from shopping and dining on Johns Island. Plus, residents enjoy exclusive access to a private boat ramp and dock, making life on the water even easier.<br /> <br /> This isn't just a house, it's a lifestyle. And it's waiting for you!
MlsNumber: --
ListingId: 25007551


Listing Provided By: The Cassina Group, original listing
Phone: (843) 628-0008
Office Phone: (843) 628-0008
Agent Name: Henry Robinson
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => charleston [3] => SC [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: charleston State: SC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: charleston State: SC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('alhud','usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'alhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) 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