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

158 Rocken B Dr
Delano, TN 37325

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,350,000
Beds: 10
Baths: 5
Status: Active
SqFt: 4500
Agency: RE/MAX Properties

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential
Year Built: 2008
Notes: Welcome to VilLodge, an endless possibility with endless revenue potential! 10 acres with 5 established 5 star rated fully operational airbnb's sitting on 3 of the 10 acres, leaving 7 acres ready for you to expand! Expand as economical as you want with campsites; put minimal effort into adding an RV park; double your revenue with 5 more cabins or chalets; or build a group lodge for large gatherings! You could even build your forever home on site and self manage the existing cabins for extra income. Located right off of Highway 411, the Chilhowee Mountain Range, Ocoee River, Hiwassee River, Chilhowee sugar gliders, and Delano, Tn. Prime Airbnb location with no motels/hotels in sight and tourists traveling from all over for leaf peeping season, rafting, hiking, traveling, and sight seeing! Each of the five homes have been beautifully remodeled, boasting modern amenities such as smart thermostats and locks, along with fully furnished interiors that include all pictured appliances, decor, and linens. These properties are perfect for the savvy investor, as they're currently set up as remotely managed short-term rentals with a surveillance system set up at each front door, and 2 cameras showing the backyard of homes. In addition, a mesh wifi infrastructure means that one commercial internet connection services all five homes, saving you money on monthly expenses. Relax in style with a dedicated built-in fire pit for each unit, while the blue home has the added luxury of a recently installed hot tub. With this much potential, what are you waiting for? The VilLodge did the hard part of establishing themselves, now it is time for you to take it over and grow it! Listing Agent has personal interest in property.
MlsNumber: 1390557


Listing Provided By: RE/MAX Properties, original listing
Name: RE/MAX Properties
Phone: (423) 894-2900
Office Name: RE/MAX Properties
Office Phone: (423) 894-2900
Agent Name: Hunter Denton
Disclaimer: Copyright © 2024 Greater Chattanooga Association 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