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

43 Stone Cave Lp
Dunlap, TN 37327
Darwin White with Heritage Homes & Lands LLC, original listing - (423) 894-8999

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,000,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Heritage Homes & Lands LLC
Agency Phone: (423) 894-8999

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 292 acre(s)
Property Type: Land-Other
Year Built: --
Notes: This is an amazing and complicated track of land. It borders state hwy 28 in two places. One is 417.5 ft wide and the other is per tax map 114 ft wide. It borders both sides of Stone Cave Rd for a meandering approx. 2500 ft. It includes 72 ft and a 585 ft of road frontage on Hudlow Loop Rd. The property includes frontage on Thurman Creek, Stone Creek and Woodcock Creek. <br /> This property is famous for a Stone Cave Spring that is located across from Stone Cave Loop Rd. The entirety of the land is 294.7 Acres with approximately half on either side of Stone Cave Rd. The spring side is mostly hardwood, and includes beautiful development sites along Thurman Creek. The property rises up to provide easy sloping top of the ridge land that can be developed with spectacular views of the Sequatchie Valley. The Campus Side includes multiple buildings and rental income properties. an estimated 50 acres or more is in pasture land. ( do not hold the agent accountable for the estimate of cleared land) The seller will divide the 294.7 acres, and the seller will owner finance, with terms to be negotiated. There is a commercial and agricultural aspect to this listing and it does have a green belt tax status. Wildlife roams freely with deer, turkey, fox, beaver (creek beavers), raccoons, and coyote present. NOTE: Portions of this property is in the 100 year flood plain. At one time the campus side was a Sanitarium and a Private School. Stone Creek is dry most of the season and is full of Stones. <br /> If divided the seller will accept 1.5 Million for the Spring Side and 1.7Million for the Campus Side. <br /> NOTE: There are 140ish Line measurements in the survey for the total of 292.7 Acres. (Please disregard the measurements listed, the MLS requires something in that field so the listing agent counted the Length X the width with out counting the turns of the line measurements on the campus side added them together but they are in no way represented of the reality of the bound
MlsNumber: --
ListingId: 1363964


Listing Provided By: Heritage Homes & Lands LLC, original listing
Phone: (423) 421-4111
Office Phone: (423) 894-8999
Agent Name: Darwin White
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