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

202 Eagles Way
Eatonton, GA 31024
Jacqueline Cowles with Coldwell Banker Lake Oconee, original listing - (706) 467-3181

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,750,000
Beds: 6
Baths: Full: 7, ½: 1
Status: Active
SqFt: 7890 Square Feet
Agency: Coldwell Banker Lake Oconee
Agency Phone: (706) 467-3181

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2018
Notes: EXCEPTIONAL LAKEFRONT RESIDENCE WITH BREATHTAKING VIEWS FROM VIRTUALLY EVERY ROOM, FEATURING EXPANSIVE PORCHES, A POOL, AND AN ELEVATOR. CRAFTED BY DREAMBUILT IN 2018, NO EXPENSE WAS SPARED IN CREATING THIS UNIQUE MASTERPIECE. THE OPEN FLOOR PLAN BOASTS CUSTOM-BUILT CABINETS AND A FIREPLACE IN THE SPACIOUS GREAT ROOM, SEAMLESSLY CONNECTING TO THE DINING AREA AND KITCHEN. THE MAIN LEVEL HOSTS A MASTER SUITE WITH STUNNING VIEWS, A LAVISH BATHROOM, A SEPARATE SITTING AREA, AND A PORCH.THIS 6-BEDROOM, 7-BATHROOM PROPERTY IS ADORNED WITH LUXURIOUS FEATURES, INCLUDING A LAP POOL, A MAXIMUM DOCK, AND EXPANSIVE PORCHES ON BOTH UPPER AND LOWER LEVELS, COMPLEMENTED BY A SCREENED PORCH ON THE MAIN LEVEL. THE KITCHEN OFFERS BEAUTIFUL LAKE VIEWS, STATE-OF-THE-ART APPLIANCES, AND A SPACIOUS WALK-IN PANTRY. WITH LAUNDRY ROOMS ON ALL THREE LEVELS, A 3-CAR GARAGE, AND ADA ACCOMMODATING FEATURES, THIS HOME IS DESIGNED FOR CONVENIENCE AND LUXURY.FUTURE HOMEOWNERS WILL RELISH IN THE AMENITIES OF CUSCOWILLA, INCLUDING THE COORE-CRENSHAW DESIGNED GOLF COURSE AND THE NEWLY CONSTRUCTED CLUBHOUSE, RESTAURANT, AND FITNESS FACILITY.
MlsNumber: --
ListingId: 68310


Listing Provided By: Coldwell Banker Lake Oconee, original listing
Phone: (706) 318-5354
Office Phone: (706) 467-3181
Agent Name: Jacqueline Cowles
Disclaimer: Copyright © 2025 Lake Country Board of Realtors, Inc (GA). All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App