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

1722 Park Rd
Holladay, TN 38341

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,000
Beds: 1
Baths: 1
Status: Active
SqFt: 1000
Agency: Hayden Outdoors Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 227 acre(s)
Property Type: Residential
Year Built: 1960
Notes: Come see this incredible hunting property surrounded by the Natchez Trace State Forest and WMA. This property is set up perfectly for a hunting retreat or could be used for a full time residence. Several established food plots can be found in great locations around the property and there is a good road system throughout. This beautiful 227 acres is loaded with wildlife and is very quiet and peaceful. A hunting cabin is located on the propertyThe property is approximately 227 acres. There is a great mix of open fields and woods throughout the property. The fields have been used for food plots in the past and are great for pulling in deer and turkey for miles off of the surrounding Natchez Trace State Forest. The timber is a good mix of hard woods and pine. Just through the locked gated entrance you'll find the hunting lodge that is approximately 1556 sq ft. The lodge is big enough to accommodate several people at one time and would be perfect for hosting several of your hunting buddies at once. This is also a hoist right outside the lodge to hang your deer The property lays perfectly for great hunting. Each of the food plots could be hunted by one or more hunters at once. The internal road system makes it easy to access each food plot and much of the timber on the property. The established roads also make for cruising around in the side by sides fun and enjoyable. This would also be a great property to ride your favorite horses around as well as a great place to get them ready to ride on the Natchez Trace State Forest just right next door. The property sits just about 12 miles off of I-40 at exit 126, which is just about 80 miles West of Nashville or 40 miles East of Jackson, TN   The property is bordered on two sides by Natchez Trace State Forest and WMA. The State Forest is 48,000 acres and has a reputation for great hunting in the area.
MlsNumber: 11242504


Listing Provided By: Hayden Outdoors Real Estate, original listing
Name: Hayden Outdoors Real Estate
Phone: (970) 674-1990
Office Name: Hayden Outdoors Real Estate
Office Phone: (970) 674-1990
Agent Name: Brandon Pendergrass
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