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

116 Round Top Road
Mineral Bluff, GA 30559
Heather Foresman with Engel & Völkers North Georgia Mountains, original listing - (706) 406-5572

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,499,900
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4400 Square Feet
Agency: Engel & Völkers North Georgia Mountains
Agency Phone: (706) 406-5572

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Other-Single Family Residence
Year Built: 2024
Notes: Discover the Pinnacle of Luxury Living at this Brand New Lomonaco Homes Lodge. Step into this luxurious and secluded mountain retreat to immerse yourself in breathtaking views of the majestic mountain ranges. This newly constructed home combines classic cabin finishes with modern touches, complemented by high end furnishings making it the perfect haven for those seeking peace and relaxation. As you enter, you are greeted by a beautifully designed open staircase featuring metal accents, creating a stunning centerpiece for this luxurious lodge. A Lomonaco-style stone fireplace and numerous windows usher in natural light, creating a warm and inviting atmosphere. This lodge boasts 5 bedrooms and 4 and a half baths, and large walk-in custom closets ensuring ample space for guests. The expansive decking and open floor plan are ideal for hosting both intimate gatherings and larger dinner parties. The chef's kitchen is a culinary delight, featuring upscale appliances, custom cabinetry, a unique trough-like sink, an expansive island for entertaining, and a walk in pantry. Hardwood floors lead you through oversized closets with plush carpeting, while rustic accents such as wood beams, stone fireplaces, premier lighting, upgraded tile, and fixtures adorn each room. The main level includes a laundry room with additional cabinetry, adding convenience and functionality. Large porches on every level offer spectacular short and long-range mountain views, with additional stone fireplaces that make mountain evenings even more relaxing. The terrace level encompasses an open space where entertaining is limitless. Here you'll find a secondary kitchen with a custom island, a movie theater, a bunk room, and an outdoor dining area. Experience tranquility in this stunning home and surrounded by lush landscaping. The lodge is perfectly situated just far enough from town to provide an authentic mountain experience, yet close enough to enjoy all the adventures the mountains have to offer.
MlsNumber: --
ListingId: 7480832


Listing Provided By: Engel & Völkers North Georgia Mountains, original listing
Phone: (706) 406-5572
Office Phone: (706) 406-5572
Agent Name: Heather Foresman
Disclaimer: Copyright © 2024 Engel & Völkers. 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 = 445 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 Amber Herendon
Amber Herendon
ASCIIHarry Norman Realtors
Call Today!: (706) 669-7400

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App