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 ('ilhud','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 = 'ilhud', 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 ('ilhud','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 = 'ilhud', 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 ('ilhud','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 = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

151 Blue Heron Drive
Eatonton, GA 31024

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,499,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4565 Square Feet
Agency: Atlanta Fine Homes Sotheby's International
Agency Phone: (770) 442-7300

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: **Exquisite Lakefront Home on Beautiful Lake Oconee** Nestled along the serene shoreline in a highly sought-after gated community, this turnkey residence epitomizes lakefront luxury living. Meticulously completed by DreamBuilt, this unique custom home showcases unparalleled attention to detail. Step inside to discover an inviting and airy interior graced with expansive floor-to-ceiling windows, flooding the space with natural light and offering tranquil water views. The warm wood-paneled walls and soaring vaulted ceilings perfectly complement the sleek, modern designer furnishings, creating a cozy yet sophisticated atmosphere. The sprawling open floor plan is an entertainer’s dream, featuring a gourmet kitchen with custom white cabinets, an oversized island with concrete countertops, a Viking Range, a Sub-Zero refrigerator, a walk-in pantry and a light-filled dining area. The main floor boasts an expansive master suite with private exterior access to a large stone patio, large walk-in closets with a washer and dryer and a light-filled spa-like bathroom. An ensuite bedroom upstairs, along with two additional character-rich bedrooms and a full bathroom, offer ample space and comfort. Wind up the spiral staircase to the crow’s nest and enjoy captivating scenic views of the property or relax in the bonus room. Outdoors, the saltwater pool and spa, coupled with a grilling station, serve as the focal point for gatherings, promising endless enjoyment. A separate, fully finished guest house ensures privacy and comfort for visitors, featuring a private bedroom, a large gathering area and a full kitchen. Exterior details include professional landscaping, outdoor lighting, a firepit, stone walkways, a metal roof, a large driveway, a Max dock, a newly finished seawall and two jet ski lifts. Discover the harmonious blend of sophistication and leisure in this remarkable lakefront sanctuary—welcome home.
MlsNumber: --
ListingId: 7570632


Listing Provided By: Atlanta Fine Homes Sotheby's International, original listing
Phone: (770) 442-7300
Office Phone: (770) 442-7300
Agent Name: Becky Danyo
Disclaimer: Copyright © 2025 First Multiple Listing Service, Inc. 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