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

7525 Mt Carmel Road
Decaturville, TN 38329
Pat Doyle with Hayden Outdoors Real Estate, original listing - (970) 674-1990

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,895,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Hayden Outdoors Real Estate
Agency Phone: (970) 674-1990

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 170 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: --
Notes: Beautiful waterfront development property located approximately 1 hour and 45 minutes west of Nashville, Tennessee along the banks of the Tennessee River. Development ideas include, 1) sell the remaining available lots and add a revenue generating dry storage facility onsite, and / or 2) sell the premium waterfront lots while developing short term rental areas with a combination of small cabins, plus RV pads with hook-ups. The total footprint of the property is approximately 189 acres. However, upon subtracting the sold lots along the east side as shown in the map attached, it is estimated that the total acreage to be conveyed upon sale will be approximately 170 +/- acres. New survey to confirm Approximately 1.5 miles of waterfront frontage with a combination of the Tennessee River and White's Creek Approximately 2000 feet of county road frontage on Mt Carmel Road Private boat launch on the Tennessee River Utilities already in place include electric, fiber optic internet wifi, city water Oxbow lake on the north side of the property provides inland fishing opportunities Excellent outdoor recreation throughout the property The vast majority of the market value is placed on the lot sales potential within the 46+/- acres on the east side of the property, plus the possible dry land storage high ground area near the main gate (see the map attached). Other than the high ground area on the west side near the gated entry to the property, the balance of the acreage is technically in floodplain like most waterfront properties along the Tennessee River, so proper elevated construction is required Private boat launch on the Tennessee River Boating Fishing Water sports Hunting ATV Tennessee River Golf Club is located just 4 miles north on Mt Carmel Road Approximately 100 acres is currently planted in soybeans. This revenue generating tillable ground has been rotated between corn and soybeans for several years The Decaturville, Tennessee area experiences 4 distinct seasons of weather. Springtime green-up is beautiful with comfortable daytime temperatures in the 60's and 70's. Summertime highs range from the mid 80's to low 90's making it ideal for water sports. Fall colors are gorgeous and temperatures are generally in the 70's and 80's. Winter is moderate by most standards boasting daytime temperatures in the 50's and nighttime lows in the 40's - with the rare, but seemingly always welcomed light snowfall 20 minutes from Parsons, TN (grocery, restaurants, shopping) 40 minutes from Benton County Regional Airport 60 minutes from Jackson, Tennessee 1 hour and 45 minutes from Nashville, TN 2 hours from Memphis, TN  
MlsNumber: --
ListingId: 11354724


Listing Provided By: Hayden Outdoors Real Estate, original listing
Phone: (615) 490-2771
Office Phone: (970) 674-1990
Agent Name: Pat Doyle
Disclaimer: Copyright © 2024 My State MLS. 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