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 ('cihud','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 = 'cihud', 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 ('cihud','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 = 'cihud', 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 ('cihud','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 = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

4075 Egret Perch Court Court
Hollywood, SC 29470

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $749,000
Beds: 3
Baths: Full: 2, ½: 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: 2018
Notes: **Charming Like New One-Story Home with Luxurious Finishes and Prime Amenities***Discover the rare opportunity to own a like-new, one-story home in the highly sought-after Poplar Grove community. Just steps away from the inviting saltwater pool, state-of-the-art fitness center, and deepwater access, this custom-built residence offers the epitome of convenient, luxurious living.Picture yourself enjoying the gentle breezes on the welcoming front porch or savoring breathtaking sunsets from the screened rear porch. This elegant home boasts 10-foot ceilings and a range of high-end finishes, including a stunning coffered ceiling. The spacious laundry room, located conveniently off the master bath and hallway, features an abundance of cabinets and a handy sink. The heart of this home is its open kitchen, designed for both style and function. It showcases a large island, 42-inch cabinets with crown molding, soft-close drawers, a gas cooktop, and a generously sized custom walk-in pantry. Every detail has been thoughtfully considered to enhance your living experience.<br /> One-story homes are a rare find, especially in such a desirable neighborhood. Don't miss out on this exceptional propertycall today to schedule your private showing and make this dream home yours.<br /> **Premier Amenities & Community:** Nestled within Poplar Grove, this home offers access to a breathtaking array of amenities. Engage in an active outdoor lifestyle with fishing, kayaking, and miles of walking, biking, and equestrian trails with an active social calendar. The award-winning amenity center features a saltwater pool, fitness center, and marsh observation deck. **Ideal Location:** Situated conveniently close to Charleston's charm, shopping, dining, and medical facilities, this residence strikes the perfect balance between serenity and urban accessibility. Revel in the peaceful ambiance of a park-like setting while remaining connected to the city's offerings. Don't miss the unique opportunity to own a piece of Charleston's dream living. This extraordinary home awaits your personal touch. Reach out now to arrange a private tour and secure your place in this sought-after gated community just minutes to every convenience.
MlsNumber: --
ListingId: 24017862


Listing Provided By: Southeastern, original listing
Phone: (843) 458-0827
Office Phone: (843) 458-0827
Agent Name: Deborah Wingard
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

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 ('cihud','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 = 'cihud', 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

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App