Title Page Background
DEBUG FN args: Array ( [0] => 2496 [1] => [2] => [3] => agent ) BEFORE: Site: 2496 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2496 Igate: njhud LocID: 2496 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('tnhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2496 [1] => [2] => [3] => lender ) BEFORE: Site: 2496 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2496 Igate: njhud LocID: 2496 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('tnhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2496 [1] => [2] => [3] => other ) BEFORE: Site: 2496 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2496 Igate: njhud LocID: 2496 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('tnhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) 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: Full: 5
Status: Active
SqFt: 4500 Square Feet
Agency: RE/MAX Properties

Map Details Show Map | Show StreetView




House Features

Appliances: Microwave, Range, Refrigerator
Architectural Style: Other
Heating: Central Furnace
Interior Features: Tub/Shower Combo, Master On Main Level, Washer & Dryer Hookup
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bathroom 5, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5

Window Features

Exterior Features: Level, Porch, Porch Covered, Scenic View, Mountain View, Other 1
Patio and Porch Features: Porch
Roof: Shingle, Asphalt
View: Mountain

Neighborhood/Schools

Elementary School/District: Chilhowee Elementary
Middle/Junior High School/District:
High School/District: Polk County High School
Subvidision Name:

Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential-Single Family Residence
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: --


Listing Provided By: RE/MAX Properties, original listing
Phone: (901) 604-5474
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