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 = 397 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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 = 397 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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 = 397 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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;

1478 Georgia Club Drive
Statham, GA 30666
Judy McDonald with Keller Williams Greater Athens, original listing - (706) 316-2900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,400,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4400 Square Feet
Agency: Keller Williams Greater Athens
Agency Phone: (706) 316-2900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: "TAKE A LOOK AT ME NOW . . . not just an empty space"! Flooded with natural light, decorator inspired paint colors, and stunning, natural pine floors throughout the main level, you will be dazzled by this updated beauty.<br /> Both, the interior and exterior of this home have been transformed over the last few months, including new paint inside and outside; refinished pine hardwood floors that have been extended throughout the main level; refinished porches; new fans/fixtures; new main level HVAC; and THE LIST GOES ON.<br /> This amazing, custom-built home, with 4 bedrooms/4.5 baths, provides the perfect opportunity for you to enjoy The Georgia Club lifestyle. The Georgia Club is a gated, 27-hole golf course community with a relaxed, country club lifestyle and located only 9 miles from the city limits of Athens, Georgia. You will be able to enjoy fantastic golf course views and colorful sunsets from several oversized/covered porches of this home, including a large screened back porch. <br /> The chef's kitchen, with a spacious keeping room, is the perfect spot to gather friends and family for camaraderie, while assisting the chef with final dinner preparations. Dinner for 12 to 14 guests can be enjoyed around a cozy, second fireplace in the formal dining room; or enjoy al fresco dining on one of the huge covered porches. A separate Grand Room, with a large fireplace and wet bar, offers private space for soft music and quiet conversations and features French Door access to one of the large covered porches.<br /> The spacious primary suite, with spa-like bath, separate huge titled shower and Jacuzzi tub, are located on the main level and offer a quiet retreat for relaxation.<br /> Overnight/weekend guests will appreciate the privacy available in the two spacious, upper level bedrooms/baths. Two smaller, upper-level rooms offer convenient his/her home office space or hobby room areas.<br /> The partially finished terrace level includes a 4th bedroom/bath and a large home office, as well as, a large workshop and storage space. The terrace level has approximately 1500 square feet of unfinished space that can be customized and completed as desired.<br /> A large, circular-drive leads to an oversized, three-car garage with golf cart parking and ample space for guest parking.<br /> Also noteworthy: the roof on the home is only two years old and an owner's home warranty is transferrable.
MlsNumber: --
ListingId: 1024917


Listing Provided By: Keller Williams Greater Athens, original listing
Phone: (706) 309-2900
Office Phone: (706) 316-2900
Agent Name: Judy McDonald
Disclaimer: Copyright © 2025 Athens Area 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 = 397 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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;
Paul Cooke
ASCIIeXp Realty
Call Today!: (706) 714-8553

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App