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

4204 Magnolia Court
North Charleston, SC 29420
Jayson Wingfield with Redfin Corporation, original listing - (843) 416-2000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,059,000
Beds: 5
Baths: Full: 5
Status: Active
SqFt: --
Agency: Redfin Corporation
Agency Phone: (678) 916-2126

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: **Assumable mortgage at 4% is available for qualified Buyers at a NET full purchase price** Welcome to your dream home in the highly desirable Coosaw Creek Country Club--a private gated community offering golf, tennis, and exclusive membership amenities. Nestled on a quiet cul-de-sac, this 5-bedroom, 5-bathroom home provides ultimate privacy, as it backs up to the stunning Coosaw Creek Reserve.Upon entering, you're greeted by 20+ foot ceilings in the grand foyer, showcasing a beautifully upgraded chandelier that sets the tone for the rest of the home. The open-concept layout creates an inviting flow, ideal for both entertaining and everyday living. Large windows throughout fill the home with natural light, including the sunroom that overlooks the expansive backyard and Coosaw Creek preserve, offering sweeping views and a tranquil atmosphere.<br /> The chef's kitchen features newer Samsung and Bosch appliances, including a cooktop, along with granite countertops, ample cabinetry, and a breakfast bar for casual dining. This space seamlessly transitions to the dining and family areas, creating a perfect setting for gathering.<br /> The primary suite serves as a luxurious retreat, complete with a spa-inspired ensuite bath featuring dual vanities, a soaking tub, and a separate walk-in shower. The additional bedrooms are spacious and versatile, providing plenty of room for family or guests. A bonus room upstairs offers even more flexibility for a home office, playroom, or media room.<br /> For added peace of mind and energy efficiency, a newly installed heat pump package ensures year-round comfort. The home's crawl space has been encapsulated, and a dehumidifier has been added to maintain optimal air quality and protect your home.<br /> Storage is abundant, with approximately 900 sq. ft. of walkable attic storage, perfect for seasonal items, hobbies, or extra belongings. The oversized three-car garage provides ample room for vehicles, equipment, and storage.<br /> Outside, the private backyard retreat offers a tranquil setting for relaxation or outdoor entertainment, all backed by the Coosaw Creek Reserve for added seclusion and scenic views.<br /> Living in Coosaw Creek Country Club gives you access to a world-class golf course, tennis courts, clubhouse dining, a community pool, and a vibrant social sceneeverything you need to enjoy an active and fulfilling lifestyle.<br /> Don't miss this rare opportunity to own a beautifully updated home in one of North Charleston's most sought-after communities. Schedule your private tour today!
MlsNumber: --
ListingId: 25009137


Listing Provided By: Redfin Corporation, original listing
Phone: (843) 416-2000
Office Phone: (843) 416-2000
Agent Name: Jayson Wingfield
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] => dorchester [3] => SC [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: dorchester State: SC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: dorchester 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 = 2332 AND i.igate IN ('tnhud','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 = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Karen Lewis
ASCIIHealthy Realty
Call Today!: (843) 242-0740

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App