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

655 Laprades Road
Clarkesville, GA 30523

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,749,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: --
Agency: Northeast Georgia Clayton
Agency Phone: (706) 960-1941

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1986
Notes: Nestled amidst the undeniable beauty of Lake Burton, this charming lake home offers the perfect escape from the hustle and bustle of everyday life. 655 Laprades Rd is an idyllic retreat that invites you to unwind, relax, and immerse yourself in the serene ambiance of lakefront living. Tucked away in a peaceful inlet of Lake Burton, this home boasts a serene and private setting. Conveniently located near local amenities, it offers the best of both worlds: seclusion and convenience. Step inside to discover a cozy interior adorned with rustic charm. From the exposed wooden beams to the 2 stone fireplaces, every detail reflects the timeless allure of lake house living. Enjoy the expansive decks beckon you to relax and soak in the beauty of your surroundings. Beyond the decks is the two-story, two-stall boathouse---perfect for entertaining guests, jumping off the boat house and endless water activities. Whether it is swimming, boating, fishing, or paddle boarding, Lake Burton offers countless opportunities for recreation and relaxation. Cap off the days activities in the hot tub, the perfect way to relax and unwind after fun in the sun! Back inside, the well-utilized kitchen features stainless steel appliances to prepare delicious meals while enjoying the company of family and friends in the open-concept living and dining area. Retreat to one of the comfortable bedrooms, each offering peaceful views and a welcoming atmosphere. Fall asleep to the gentle lake breeze and wake up refreshed and rejuvenated. Beyond the bedrooms, the terrace level features four built-in bunk beds and a second living space featuring a pool table, stone fireplace and sectional sofa, ideal for children, grandchildren, and overflow guests! From lazy summer days on the water to cozy evenings by the fire in the winter, this home is a year-round retreat for those seeking refuge in nature's embrace. Whether you seek a weekend getaway or a permanent residence, Lake Burton offers a slice of paradise to cherish for years to come. Schedule a showing today!
MlsNumber: --
ListingId: 10310352


Listing Provided By: Northeast Georgia Clayton, original listing
Phone: (404) 372-5698
Office Phone: (706) 960-1941
Agent Name: Evelyn Heald
Disclaimer: Copyright © 2024 Berkshire Hathaway HomeServices Georgia Properties. 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