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

1011 Allgood Road
Athens, GA 30606
« Prev
Next »
Currently Displayed Property Photo


Property Details

List Price: $1,499,900
Beds: 5
Baths: Full: 5, ½: 2
Status: Active
SqFt: 6567 Square Feet
Agency: Coldwell Banker Upchurch Realty
Agency Phone: (706) 543-4000

Map Details Show Map | Show StreetView



Description/Comments

Lot Size: 4 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: Oconee County with an Athens address! Have you wanted to live in a modern-day castle? This home is perfect for you! With over 6,000 sq feet of insulated form construction, ICF, this home is built to last. Exterior walls are thick enough to sit on the windowsills and read a book while you enjoy your morning coffee. This Mediterranean-style home sits on a private 4.42 acres. As you travel down the driveway the home immediately draws your eye to grandiose placement on the lot. The two front porches show numerous spaces to relax after a long day. As you enter the large foyer, you are placed directly on the main level of the home. Looking straight ahead is the living room. With a large fireplace being flanked by multiple builtins this room is flooded with natural light with the two-story floor-to-ceiling windows. Facing towards the rear is an open courtyard with the perfect place for a pool if you are so inclined. To your right will be the kitchen and dining room areas. The kitchen is large and has a spacious island, walk-in pantry, and breakfast nook for cozy family gatherings. There are two exterior doors on this side of the home adjacent to the laundry room just off the kitchen. The right side of the home has a short hallway to reach the library and owner's suite. The library overlooks the circular driveway with a bay of windows that give this room an open feel. The owner's suite was extended during construction to add a 2nd fireplace and a well-designed nook for the placement of the largest beds. The room has an exterior door leading out to the covered rear patio as well. As you travel upstairs you will find three additional ensuites. One of my favorite features of this home is the breezeway that connects the garage to the rest of the home. This garage space not only has an oversized footprint for a two-car garage but also located above is an additional bonus room with a half bath. This room can be accessed from both levels of the home. Downstairs in the basement will be a large family room/media room with 2 additional flex spaces and storage areas. This area also is home to 5th and final ensuite. There is an additional exterior door leading out to a small uncovered patio area. The lot has a slightly rolling composition that has a nice combination of pine and hardwood trees. Conveniently located in Allgood Farms, this home is a short drive to all that Athens and Oconee have to offer via either 441 or the loop. Painting Allowance being offered by seller.
MlsNumber: --
ListingId: 1012493


Listing Provided By: Coldwell Banker Upchurch Realty, original listing
Phone: (706) 543-4000
Office Phone: (706) 543-4000
Agent Name: Nathan Sonke
Disclaimer: Copyright © 2024 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => clarke [3] => GA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: clarke State: GA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: clarke State: GA 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 = 419 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Jen White
ASCIIKeller Williams
Call Today!: (706) 540-9416

Contact Me

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App