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

1721 Withrow Road
Greensboro, GA 30642-2560

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,590,000
Beds: 5
Baths:
Status: Active
SqFt: 4536 Square Feet
Agency: Keller Williams Realty Atlanta

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2011
Notes: WELCOME TO THE PERFECT BLEND OF LUXURY AND COMFORT AT THIS CUSTOM-BUILT HOME NESTLED WITHIN THE COVES OF LAKE OCONEE IN WHITE OAK PLANTATION. LOCATED ON A PRIVATE 3.58 ACRE LOT WITH 120FT OF WATER FRONTAGE, PRIVATE MAX DOCK, AND SOME OF THE BEST VIEWS THE LAKE HAS TO OFFER. ATTENTION TO DETAIL AND UNPARALLELED CRAFTSMANSHIP ARE EVIDENT THROUGHOUT THE ENTIRE HOME. ROCKING CHAIR FRONT PORCH WELCOMES YOU INTO THE GRAND, TWO-STORY FOYER LEADING TO A DESIRABLE OPEN AND BRIGHT FLOOR PLAN. BEAUTIFUL, WIDE-PLANK HARD WOOD FLOORING THROUGHOUT THE ENTIRE MAIN LEVEL. GREAT ROOM BOASTS IMPRESSIVE PANORAMIC LAKE VIEWS AND A WOOD BURNING, STONE FIREPLACE WITH ANCHORING BUILT-IN BOOKSHELVES SET THE TONE FOR A WARM LIVING SPACE. ELEVATE YOUR CULINARY EXPERIENCE IN THE CHEF'S KITCHEN DESIGNED WITH BEAUTY AND FUNCTIONALITY IN MIND. EQUIPPED WITH CUSTOM CABINETRY, INTEGRATED REFRIGERATOR AND DISHWASHER, INDUCTION COOKTOP, AND A SPACIOUS ISLAND AND DINING AREA THAT ARE PERFECT FOR ENTERTAINING FAMILY AND GUESTS ALIKE. EXTEND THE ENTERTAINING OUTDOORS ON THE SCREENED IN PORCH TO UNWIND AND ENJOY THE BREATHTAKING SUNSETS. BEYOND THE KITCHEN YOU WILL FIND A WALK-IN PANTRY WITH ABUNDANT STORAGE AND A SPACIOUS LAUNDRY/MUDROOM COMPLETE WITH A HALF BATHROOM. THE MAIN LEVEL ALSO FEATURES AN OVERSIZED PRIMARY SUITE THAT IS NOTHING SHORT OF A RETREAT WITH A SITTING AREA AND FRENCH DOOR ACCESS TO THE EXPANSIVE DECK AND HOT TUB. SPA LIKE BATH FEATURES DOUBLE VANITY, HEATED TILE FLOOR LEADING INTO THE WALK-IN SHOWER, AND A VAST CUSTOM, WALK-IN CLOSET THAT IS FIT FOR THE MOST EXTENSIVE OF WARDROBES. THERE IS ROOM FOR EVERYONE TO STAY AS THE UPPER LEVEL FEATURES FOUR GENEROUS SIZED SECONDARY BEDROOMS, 3 WITH PRIVATE FULL BATHROOMS. WALK DOWN THE OPEN PATH TO THE WELL-MAINTAINED DOCK THAT IS READY FOR THE ULTIMATE WATER EXPERIENCE WITH A COVERED BOAT LIFT AND TWO JET SKI LIFTS. COVERED WALKWAY FROM THE HOME LEADS TO THE 3 CAR GARAGE AND A PARTIALLY FINISHED ABOVE GARAGE GUEST SUITE. THIS HOME WOULD NOT BE COMPLETE WITHOUT THE 54FT COOLED BOAT GARAGE WITH CUSTOM RACKS TO HOLD UP TO 75 FISHING RODS AND AMPLE SPACE TO STORE ALL OF YOUR WATERCRAFT. WHETHER YOU'RE ENTERTAINING GUESTS, SEEKING A PEACEFUL RETREAT, OR LOOKING FOR THE PERFECT SPOT TO ENJOY LAKEFRONT LIVING, THIS PROPERTY HAS IT ALL!
MlsNumber: --


Listing Provided By: Keller Williams Realty Atlanta, original listing
Phone: (404) 804-5710
Office Phone: (678) 808-1300
Agent Name: Ashley Baldner
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App