Title Page Background
DEBUG FN args: Array ( [0] => 2321 [1] => [2] => [3] => agent ) BEFORE: Site: 2321 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2321 Igate: njhud LocID: 2321 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 = 2321 AND i.igate IN ('alhud','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 = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2321 [1] => [2] => [3] => lender ) BEFORE: Site: 2321 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2321 Igate: njhud LocID: 2321 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 = 2321 AND i.igate IN ('alhud','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 = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2321 [1] => [2] => [3] => other ) BEFORE: Site: 2321 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2321 Igate: njhud LocID: 2321 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 = 2321 AND i.igate IN ('alhud','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 = 'ushud', 0, 1) LIMIT 0, 1;

821 Roddin Street
Charleston, SC 29492
Andrea Sullivan with BHHS Carolina Sun Real Estate, original listing - (843) 388-8118

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,500,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: BHHS Carolina Sun Real Estate
Agency Phone: (843) 388-8118

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Land-Other
Year Built: --
Notes: BUY NOW, BUILD TOMORROW, OR WHEN YOU'RE READY-AND GOLF ALL THE WHILE! FULL GOLF CLUB MEMBERSHIP AVAILABLE, BYPASS THE WAITING LIST. ARB APPROVAL IS PENDING- ARCHITECTURAL PLANS AVAILABLE FOR PURCHASE. Don't miss videos of property & pool concept.Welcome to your future homesite, 821 Roddin St, in The Retreat on Daniel Island - the most exclusive enclave known for its privacy, charm, and unmatched coastal lowcountry beauty. This is the most spectacular and final neighborhood to be built on Daniel Island, Charleston's Island Town. This generously sized 0.70-acre lot offers a rare opportunity to build your dream home at the pinnacle of one of Charleston's most sought-after communities.Nestled on a quiet cul-de-sac street, lined with majestic grand trees, and bordered by Beresford Creek, it's the perfect blend of seclusion and convenience. Privacy abounds as this homesite is surrounded by protected wetlands with soaring mature trees along the rear perimeter, and only one neighboring property. Large grand oaks frame the views at the front of the property.<br /> <br /> Architectural plans prepared by Coastal Creek Design provide over 6000 sf of living space on 3 floors with elevator access. An accessory structure complete with a full bedroom, bath, kitchen, and living room over the secondary garage designed to compliment the primary home and adds flexibility for many uses. The outdoor living areas are designed to take in the beautiful natural surroundings and views from every angle. This custom 4 bedroom luxury home would not be complete without an infinity edge pool, outdoor kitchen, firepit, and porches on every level.<br /> <br /> Conveniently located and practically an extension to the property, The Retreat's "Fish Camp" has been designed as a collection of amenities that are for the exclusive use of this neighborhood. A dock and deep water boat launch provide convenient access to Beresford Creek and the surrounding waterways, and a pavilion, nestled in the trees on the water's edge, provides a gathering space for friends and neighbors.<br /> <br /> Residents at The Retreat become members of the private Daniel Island Club. A FULL GOLF MEMBERSHIP IS AVAILABLE ON THIS LOT. This is the recreational and social center of Daniel Island Park with two golf courses, an expansive clubhouse, swimming pools, a fitness center, tennis and pickleball courts, plus several dining venues. <br /> <br /> As part of the greater Daniel Island community, residents at The Retreat will also enjoy access to the Island's hundreds of acres of parks and over 25 miles of trails winding through maritime forest along the marsh and the water's edge, and all of the shopping, dining and conveniences in downtown Daniel Island. <br /> <br /> Whether you're ready to build now or planning for the future, this is a truly special place to call home.<br /> <br /> Buyer to contact the Daniel Island Club for membership options and details. Buyer/buyer's agent to verify anything deemed important such as school zones, lot size, flood zone etc. <br /> <br /> Buyer to pay a one-time neighborhood enhancement fee of .5% x sales price to Daniel Island Community Fund at closing and an estoppel fee to Daniel Island Property Owners Association, Inc.
MlsNumber: --
ListingId: 25014343


Listing Provided By: BHHS Carolina Sun Real Estate, original listing
Phone: (843) 388-8118
Office Phone: (843) 388-8118
Agent Name: Andrea Sullivan
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] => berkeley [3] => SC [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: berkeley State: SC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: berkeley 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 = 2321 AND i.igate IN ('alhud','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 = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Melissa Pugh
Melissa Pugh
ASCIIRealty One Group Coastal
Call Today!: (843) 343-5705

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App