Title Page Background
HFQUERY 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 ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 ('usahud','cihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 ('usahud','cihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

107 Paige Court
Goose Creek, SC 29445

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $557,500
Beds: 4
Baths: 4
Status: Pending
SqFt: --
Agency: Brand Name Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2000
Notes: Introducing 107 Paige Court, nestled in the prestigious Hamlets section of the Crowfield Plantation subdivision, a luxury community in the heart of Goose Creek, South Carolina. This exquisite two-story home, located on a peaceful cul-de-sac, stands on a generous .3-acre lot surrounded by mature trees and meticulous landscaping, offering both privacy and a picturesque setting.As you approach, the regal facade of this home commands attention. The attached two-car garage and expansive driveway ensure ample parking for large gatherings, enhancing its welcoming appeal. Step inside to discover an inviting open stairwell flanked by a versatile formal dining room or home office on the left and a downstairs master suite or full guest suite to the right, complete with a recently remodeled bathroom.<br /> <br /> The heart of the home is the spacious kitchen, which boasts granite countertops, extensive cabinet space, and bar seating at the counter. Adjacent to the kitchen, a charming breakfast nook sits within a turret, providing stunning views of the lush backyard. Beyond the kitchen, the large den or formal living area, complete with a cozy fireplace, forms a perfect space for relaxation and family time.<br /> <br /> Outdoor living is a joy at this property, with a large gazebo that's screened-in to create an idyllic setting for morning coffee and bird watching. The backyard also features two raised garden beds within a wooden privacy fence, ideal for those with a green thumb.<br /> <br /> Upstairs, the home continues to impress with three additional bedrooms. The upstairs master suite features tray vaulted ceilings, walk-in closets, dual vanities, a jetted soaking tub, and a separate shower, providing a private retreat. The secondary bedrooms are generously sized and share a well-appointed guest bathroom. Adding to the luxurious feel, a full-out movie theater room complete with a built-in wet bar, surround sound, projector, screen, and even a popcorn machine offers an entertainment experience that rivals any cinema.<br /> <br /> 107 Paige Court is more than just a home; it's a lifestyle choice for those seeking luxury, comfort, and convenience close to Charleston, SC. This property is ideal for those who appreciate a well-appointed living space while enjoying the tranquility of a highly sought-after neighborhood. Don't miss the opportunity to own this stunning residence. Schedule your viewing today and experience the perfect blend of elegance and practicality at Paige Court.
MlsNumber: 24009816


Listing Provided By: Brand Name Real Estate, original listing
Name: Brand Name Real Estate
Phone: (843) 343-8193
Office Name: Brand Name Real Estate
Office Phone: (843) 343-8193
Agent Name: Adam Tournear
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

HFQUERY 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 ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Angie Gooden
ASCIICarolina One Real Estate - The Palmetto Elite Group
Call Today!: (843) 576-9551

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App