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

400 Mulberry Gap Road
Ellijay, GA 30540
Gregory Goad with Real Broker, LLC., original listing - (855) 450-0442

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,695,000
Beds: --
Baths: --
Status: Active
SqFt: 9400 Square Feet
Agency: Real Broker, LLC.
Agency Phone: (855) 450-0442

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 15 acre(s)
Property Type: Commercial Sale-Business
Year Built: 1998
Notes: Escape to a place in North Georgia in the Blue Ridge Mountains that encapsulates the outdoor enthusiast’s dream. Welcome to Mulberry Gap Adventure Basecamp. Never before offered for sale. <br /> <br /> Mulberry Gap is at 15.6 acre property located in Murray County, GA just outside the county line of Gilmer County and northwest of Downtown Ellijay, also bordering a national forest outside of the Cohutta Wilderness Management Area and the Chattahoochee National Forest. <br /> <br /> Ellijay, the Mountain Bike Capital of Georgia, is known nationally for some of the best trail systems in the South and even the nation. It boosts many species of trees from hardwoods, pines, and the coveted hemlock. There is a small koi pond with a natural creek that runs through the property and echoes the sound of nature. Mulberry Gap is a place where outdoor recreation enthusiasts have been visiting for over 17 years. The property hosts its own flow trail, jump line, and pump track for mountain bikers, and sits within direct access to trails right outside the gates, including the infamous Pinhoti Trail that runs from Alabama to South Carolina as one of the few national trail systems that allow mountain bikes. <br /> <br /> The amenities include over 11 cabins (room for more), two bathhouses, 8 campsites, 3 car camping sites with electricity, an office/check-in/retail space with staff quarters to stay overnight and a renovated barn that has been converted into a gathering space for family-style meals, late-night games, and satellite TV. The Barn is also where all the family-style meals are prepared in a commercial kitchen for breakfast & dinner on the weekends, or even a sack lunch by demand. There are two community hot tubs, nestled creekside in between the cabins great for a morning soak or a post-adventure recovery. <br /> <br /> Mulberry Gap offers shuttles throughout the week for the mountain biker or hiker looking for pick up or drop off. It also hosts many events from corporate retreats, trail races, bike events (demos), weddings, family gatherings, club retreats, and anything where people can gather. <br /> <br /> This property can never be duplicated it is grandfathered in to be what it is today. Don’t miss this incredible opportunity! To learn more, email info@goadhomepartners as we have built a detailed due diligence packet for prospective buyers.
MlsNumber: --
ListingId: 7380967


Listing Provided By: Real Broker, LLC., original listing
Phone: (404) 553-4799
Office Phone: (855) 450-0442
Agent Name: Gregory Goad
Disclaimer: Copyright © 2024 First Multiple Listing Service, Inc. 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