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

1620 Mcconnell Road
Hiawassee, GA 30546

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,750,000
Beds: 3
Baths: 4
Status: Active
SqFt: 4095
Agency: Engel & Volkers Atlanta

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential
Year Built: 1995
Notes: LISTED UNDER APPRASIED VALUE!!! Welcome to your dream lakefront retreat in Hiawassee, Georgia! This stunning listing offers an array of features that will make every day feel like a vacation. Situated on the picturesque shores of Lake Chatuge, this expansive property boasts breathtaking views and an impressive 4095 sq. ft. of living space. The main level of this home features three spacious bedrooms and 3 1/2 bathrooms, providing ample space for family and guests. Additionally, the basement offers two bonus Jack and Jill rooms, perfect for use as a home office, hobby space, or additional sleeping quarters. Speaking of the basement, you'll also find a convenient canning kitchen, allowing you to preserve your own delicious creations. Prepare to be captivated by the mesmerizing views of Lake Chatuge from the comfort of your own home. Whether you're enjoying a morning cup of coffee or entertaining guests, the amazing vistas will be a constant backdrop. And with a generator in place, you can rest assured that your comfort and convenience will never be compromised. For those who enjoy working with their hands, this property offers a workshop that is sure to impress. With the potential for an apartment above, you'll have the flexibility to accommodate guests or generate rental income. The boat and RV garage in the basement provide secure storage for your outdoor toys, ensuring that they're always ready for your next adventure. The pristine landscaping surrounding this home has been professionally maintained, creating a serene and inviting atmosphere. The well and county water system provide a reliable water source, adding to the ease of living in this beautiful location. Conveniently located near resorts and vineyards, you'll have endless opportunities for entertainment and relaxation. Whether you're exploring the local wineries or enjoying outdoor activities on Lake Chatuge, this area offers something for everyone. Don't miss out on the opportunity to own this meticulously maintained lakefront gem in Hiawassee, Georgia. This is a rare find that combines luxury, convenience, self-sustainability and natural beauty. Schedule your showing today and start living the lakefront lifestyle you've always dreamed of.
MlsNumber: 10287458


Listing Provided By: Engel & Volkers Atlanta, original listing
Name: Engel & Volkers Atlanta
Phone: (404) 845-7724
Office Name: Engel & V?lkers Atlanta
Office Phone: (404) 845-7724
Agent Name: Mindy McCorvey
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