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 = 530 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 = 530 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 = 530 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;

2579 Hwy 66
Young Harris, GA 30582

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,850,000
Beds: 5
Baths: 6
Status: Active
SqFt: 6407
Agency: REMAX Town & Country

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential
Year Built: 2002
Notes: See Attached Full Description: Creekside Lodge is a custom built timber frame masterpiece in the mountains and 630' trout stream and built in sauna. LR w/ massive stack stone FP (gas), 60' cathedral ceilings, wall of windows, & mtn laurel railing. Oversized DR w/ access to back deck w/ long-range mtn views. Chef's farmhouse style kitchen w/ 5-burner gas stove, prep island w/ sink, S/S apps, granite c-tops, & pantry, barn wood table that seats 16. 2 laundry rms (main & upstairs). Huge primary w/ deck access, gas FP, walk-in closet, 2 massive owner's suites (main/upstairs) w/ step-in double headed shower, jetted tub, walk-in closet, & dual stone sink vanity w/ added storage. Vaulted loft w/ seating area, 2 BRs, & full BA upstairs. 2,330 sqft terrace level: full kitchen w/ S/S apps & granite c-tops, LR w/ stone pass-through FP (gas), deck access, game rm with 8' pool table, foosball, slot machine, dart board, BR, full BA with claw foot soaking tub, 2nd full BA w/ trough sink, step-in shower, & sauna, plus single car garage access w/custom cabinets and add'l storage room. Gorgeous property w/ wide creek, fruit trees, outdoor FP w/ seating area, walking paths, over 2K sqft of multiple full-width decks, storage tower has add'l storage for yard tools w/ deck, generous parking. Home comes furnished, w/golf cart, & yard equip. Work from home w/Mesh WiFi wide range, 8 security camera w/motion, intruder alert, smoke, fire, and carbon monoxide detection, view cameras on PC, Phone or TV.
MlsNumber: 325853


Listing Provided By: REMAX Town & Country, original listing
Name: REMAX Town & Country
Phone: (770) 596-6599
Office Name: REMAX Town & Country - Blairsville
Office Phone: (706) 745-8097
Agent Name: Ivan Walker
Disclaimer: Copyright © 2024 Northeast Georgia Board of Realtors. 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