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;

18 Wawayanda Drive
Mineral Bluff, GA 30559
Ana Bridges with Real Broker LLC, original listing - (855) 450-0442

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,300,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 7664 Square Feet
Agency: Real Broker LLC
Agency Phone: (855) 450-0442

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Cabin
Year Built: 2022
Notes: Custom designed and built by Keith Sumner Custom Homes, this new cabin offers all the bells and whistles! With high-end rustic chic style furnishings and designer lighting through-out.. simply high expectations is all you'll have here! As you step into this grand rustic yet elegant lodge you'll find all the luxuries of fine living as you & your friends spread out in the open and spacious family room. Kickback and enjoy the stone fireplace with a flat screen TV conveniently hanging above for your entertainment. Free wifi and TVs in all common areas have sound bars for streaming music or other audio from a wifi device. If you like cooking you'll be in heaven with the fully equipped kitchen for anything you'll need. Custom rock countertops, stainless steel appliances & an abundance of cooking utensils. Dining table seating for 6. Greystone Ridge offers 2 levels of living area, which makes privacy all yours! Located on the main floor is the master bedroom furnished with an large flat screen TV, King size bed, walk in closet, 2 vanities in the bathroom with a massive rock shower! Also on the main floor is a 2nd bedroom with a queen bed, large flat screen TV, full bath with rock shower, large walk-in closet with washer/dryer for your convenience. Downstairs features 1 bedroom with a cozy king size bed- large walk in closet and a 2nd bedroom with a set of bunk beds and a large flat screen TV. Step out of either room into the entertainment/game room. Making memories is what it's all about! Beautiful table seating for 6 situated in front of the custom designed wet bar, couch for seating around another beautiful stone gas log fireplace w/a TV for entertainment! Being indoors not really your thing? No problem! Get outside and hang out on the large party deck located off the main level! Comfortable sitting for everyone to enjoy the wood burning fireplace & massive TV for all the sports fans! Located on the lower level, outside of the entertainment room has an outdoor kitchen featuring a stone countertop space, Bull Grill and a separate gas burner top! Kick back after a day full of adventures around the stone firepit and relax being surrounded by the splendor of nature at its finest. Square footage of 4,552 includes main house (3,112 square feet above ground) and upstairs living area of detached garage (1,440). All of this located in the most desired area of North GA! Fannin County is named the "Trout Capital of Georgia!" Book an excursion with one of the local fly fishing tour guides or visit the Fannin County Chamber of Commerce web site for more things to do in our area. Greystone Lodge is located less than 10 minutes away from all your outdoor activities, hiking, white water rafting, tubing down the Toccoa River, horseback riding, biking trails, Lake Blue Ridge Marina, Mercier's Apple Orchard and our historic Downtown Blue Ridge area!
MlsNumber: --
ListingId: 10320920


Listing Provided By: Real Broker LLC, original listing
Phone: (855) 450-0442
Office Phone: (855) 450-0442
Agent Name: Ana Bridges
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.


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