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 = 2315 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 = 2315 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 = 2315 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;

412 Geranium Street
Graniteville, SC 29829

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $360,000
Beds: 5
Baths: 4
Status: Active
SqFt: 3173
Agency: Meybohm Realtors - N. Augusta

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2018
Notes: Welcome to your lavish retreat! This remarkable home situated on an expansive .7 acre lot promises a lifestyle of unparalleled luxury and comfort. From the moment you arrive, you'll be captivated by the elegance and grandeur of this home.<br /> <br /> Step inside to discover a lower level designed for both relaxation and entertainment. A formal dining room sets the stage for intimate gatherings and special occasions, while a versatile study/flex room offers endless possibilities to suit your lifestyle needs. A cozy bedroom and adjacent full bathroom provide convenience and privacy for guests or family members. The heart of the home lies in the spacious family room and chef's kitchen, where high-end finishes and top-of-the-line appliances create a culinary haven. Granite countertops, stainless steel appliances, an expansive island, and a walk-in pantry make this kitchen a dream for any chef or entertainer.<br /> <br /> The lower level is adorned with luxurious LVP flooring throughout, enhancing the aesthetic appeal and ease of maintenance. The family room and kitchen seamlessly flow out to the backyard oasis, where a custom-built saltwater pool awaits. Surrounded by Kool Crete, the pool area beckons you to relax, unwind, and enjoy endless hours of fun in the sun. The charming gazebo provides the perfect spot for al fresco dining or lounging with loved ones. <br /> <br /> Upstairs, the opulence continues with the owner's suite, media room, and three additional bedrooms. The owner's suite is a tranquil sanctuary, complete with luxurious amenities and ample space to unwind after a long day. The media room offers the perfect setting for movie nights or gaming sessions, while the additional bedrooms provide comfort and privacy for family members or guests. Two of the bedrooms share a convenient Jack and Jill bathroom, while the third bedroom boasts its own private entrance to another full bathroom.<br /> <br /> But that's not all - this home can come fully furnished, making it truly move-in ready and has a brand new hot water heater. Whether you're relaxing by the pool, entertaining guests in the chef's kitchen, or enjoying quiet moments of solitude in the owner's suite, every aspect of this home exudes sophistication and style. Don't miss your chance to call this exquisite property your own!
MlsNumber: 211286


Listing Provided By: Meybohm Realtors - N. Augusta, original listing
Name: Meybohm Realtors - N. Augusta
Phone: (803) 278-4437
Office Name: Meybohm Real Estate - North Augusta
Office Phone: (803) 278-4437
Agent Name: Erica Barton
Disclaimer: Copyright © 2024 Aiken 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

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 = 2315 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;
Real Estate Expert Photo for Jarrett Townsend and Landry Townsend
Jarrett Townsend and Landry Townsend
ASCIIRE/MAX True Advantage
Jarrett: (706) 755-5993
Landry: (706) 755-5992

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App