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

205 Lakecrest Drive Ne
Milledgeville, GA 31061

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,200,000
Beds: 5
Baths: 6
Status: Active
SqFt: --
Agency: HRP Realty, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2023
Notes: Wow, this is an absolutely stunning property not to leave out LOCATION! The combination of luxurious features and the serene setting on Lake Sinclair makes it a dream home. The attention to detail with 5 bedrooms all with an ensuite bathroom, 1/2 bath for guest convenience, hardwood floors throughout, custom cabinets, and solid surface countertops sounds exquisite. And having high-end appliances like a Sub-Zero refrigerator, KitchenAid double ovens, KitchenAid built in ice maker, and a Wolf gas cooktop in the kitchen adds both functionality and elegance. It's also great to hear about the practical aspects like plantation shutters, Rinnai tankless hot water heater, custom closets, an extra-large laundry room with a Sub-Zero freezer, and a separate mudroom for added convenience. The outdoor kitchen is perfect for enjoying the beautiful views while entertaining guests, and having a generator for backup power ensures peace of mind during any outages. Home also offers an attached 3 car garage with large amounts of storage above along with a sprinkler system to keep the grounds looking exquisite. With Pella windows and doors, you're likely enjoying not just the beautiful scenery but also energy efficiency and durability. And having a double boathouse with a max dock and over 130 ft of shoreline sounds like a paradise for anyone who loves water activities. Overall, this is a truly exceptional home that offers both luxury and functionality in a picturesque setting. Enjoy every moment in this beautiful lakeside retreat!
MlsNumber: 10293413


Listing Provided By: HRP Realty, LLC, original listing
Name: HRP Realty, LLC
Phone: (478) 901-2091
Office Name: HRP Realty
Office Phone: (478) 901-2091
Agent Name: Danielle McLemore
Disclaimer: Copyright © 2024 Georgia Multiple Listing Service. 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