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 ('mihud','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 = 'mihud', 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 ('mihud','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 = 'mihud', 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 ('mihud','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 = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back | All Foreclosures | | | All Cities

3945 Bulow Landing Road
Hollywood, SC 29470
Elyssa St.pierre with Southeastern, original listing - (843) 458-0827
« Prev
Next »
Currently Displayed Property Photo


Property Details

List Price: $2,350,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3573 Square Feet
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: 2025
Notes: Discover the pinnacle of Lowcountry luxury in this stunning, newly constructed one-story dream home by Coastal Premier Homes, perfectly situated on an expansive 0.8-acre estate lot with a three-car garage. Designed with architectural excellence, this meticulously crafted residence boasts an open, flowing floor plan tailored for the most discerning buyer. With three spacious bedrooms, a private study/den, huge outdoor living with outdoor fireplace, and a versatile bonus/flex space, this home offers a perfect balance of elegance and functionality.The chef-inspired kitchen is a true masterpiece, featuring a grand center island, abundant custom cabinetry, and a walk-in pantry, seamlessly blending beauty and practicality. The great room and dining area extend effortlessly onto an expansive lanai, where you'll find a cozy outdoor fireplace and option for aa gourmet summer kitchenideal for year-round entertaining. The generously sized lot also provides ample space to add a custom-designed pool, creating your own private oasis.<br /> Retreat to the luxurious owner's suite, complete with two oversized walk-in closets, an enormous spa-like shower, and a freestanding soaking tub for the ultimate relaxation experience. Designed for durability and efficiency, this home is built with a full metal roof, spray foam insulation, impact-rated sliding glass doors and windows, and an encapsulated crawl space, ensuring lasting quality and energy efficiency.<br /> Nestled on a rarely available private estate lot with no left-side neighbor, this residence offers an unparalleled sense of tranquility within Poplar Grove's newest enclave. Enjoy resort-style living every day in this gated Lowcountry paradise, set within Charleston's historic Plantation Districta premier planned community bordered by the deepwater Rantowles Creek and surrounded by pristine saltwater marshes and abundant wildlife. Residents enjoy a deepwater dock with direct access to the Stono River, Intracoastal Waterway, and Charleston Harbor, as well as a boathouse, boat landing, kayaking outpost, fishing, and crabbing opportunities. The community also offers an equestrian center with boarding options, scenic riding trails, a resort-style saltwater pool, a fitness center, and an observation deck overlooking the marsh.<br /> Located just minutes from downtown Charleston, the airport, world-class shopping, dining, beaches, and top medical facilities, this home is truly a rare find. Currently under construction, this architectural masterpiece is framed and can be move-in ready by September 2025.<br /> Luxury one-story homes on large estate lots with three-car garages are nearly impossible to finddon't miss this incredible opportunity! Call today for exclusive access and details on how Coastal Premier Homes can build your custom dream home on this lot or one of your own.<br /> Please note: Images are inspiration renderings and photos from a similar home previously built. Actual home may vary from renderings and fl
MlsNumber: --
ListingId: 25007175


Listing Provided By: Southeastern, original listing
Phone: (843) 458-0827
Office Phone: (843) 458-0827
Agent Name: Elyssa St.pierre
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 ('mihud','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 = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Donna Urban
Donna Urban
ASCIIThe Agent Owned Realty Co.
Call Today!: (843) 830-2913

Contact Me

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App