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','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 = 395 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 = 395 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;

205 Ne Lakecrest Drive
Milledgeville, GA 31061
Lee McLemore with HRP Realty, LLC, original listing - (478) 901-2091

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,200,000
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 5456 Square Feet
Agency: HRP Realty, LLC
Agency Phone: (478) 901-2091

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
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: --
ListingId: 67313


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


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 = 395 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;
Real Estate Expert Photo for Greg Norwood
Greg Norwood
ASCIIFickling & Company
Call Today!: (478) 357-2623

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App