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;

7410 Mercedes Way
Hanahan, SC 29410

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $615,900
Beds: 4
Baths: 3
Status: Active
SqFt: --
Agency: eXp Realty Charleston

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2017
Notes: Welcome to your Ultimate Oasis! This stunning home is designed for those who prioritize relaxation and entertainment over yard work. But that's not all-- The seller is offering a 1/1 buydown to make your mortgage payment that much more affordable! Say goodbye to mowing and pruning and hello to endless enjoyment in your own private pool and spacious patio area. Elegant Gas Lanterns adorn the front porch.Step inside to discover a haven of upscale living. The heart of this home boasts an open floor plan, featuring a gourmet kitchen complete with an upscale Monogram 6 burner gas stove & appliances, tile backsplash, pot filler and full pantry. With an abundance of cabinets, shelves and granite countertops, meal prep and entertaining are a breeze. And for the health-conscious, a 7-Stage undersink reverse osmosis water filter system ensures pure drinking water at your fingertips. The saltwater pool is a pleasant view from the great room which opens up to the patio, screened porch and pool where fun water features including spray streaming fountains and lights create a festive ambiance day or night. Relax on the screened porch while the kids splash in the pool, or enjoy a refreshing dip yourself. You work hard, you deserve it!<br /> <br /> Another great feature is a Natural Gas Hookup in back. It's perfect for a gas grill or fire pit. Never haul clunky propane tanks again!<br /> <br /> Downstairs, two spacious bedrooms including the primary bedroom with excellent closet space, offer convenience and comfort, along with two full baths. Need to catch up on work? The spacious office comes equipped with a bar, cold drink fridge, and wine fridge, ensuring productivity meets pleasure.<br /> <br /> Upstairs, a large bonus/media/playroom provides endless possibilities for entertainment, while a study or craft desk offers a space for creativity to flourish. Additional bedrooms with nice size closets and a full bath complete the excellent floorplan, providing ample space for family and guests. There's also ample walk in storage easily accessed on both sides of the bonus room.<br /> A Big Bonus is the EV, (electric car,) charging station in the garage!<br /> <br /> Conveniently located near shopping, dining, and entertainment, this home is also a short walk or bike ride to The Hawks Nest, the ultimate community hub offering amenities such as a dog park, fishing pond, sand volleyball, tennis courts, basketball, baseball, exercise and martial arts classes and more.<br /> <br /> With its prime location just minutes from schools, beaches, downtown Charleston, and the airport, this home truly offers the best of both worlds: luxurious living and convenient access to everything you need. Don't miss your chance to make this your forever home! Schedule a showing today and start living the dream.
MlsNumber: 24009059


Listing Provided By: eXp Realty Charleston, original listing
Name: eXp Realty Charleston
Phone: (888) 440-2798
Office Name: EXP Realty LLC
Office Phone: (888) 440-2798
Agent Name: Bambi Elstrom
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