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

31 811 Road
Tillatoba, MS 38961
Kevin Glidewell with Pioneer Auction & Realty Llc, original listing - (662) 562-6767

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $69,750
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Pioneer Auction & Realty Llc
Agency Phone: (662) 562-6767

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 31 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Yalobusha Co. 31 +/- Ac. Of Hunting / Recreation Land located in the middle of the Holly Springs National Forest. This is the perfect opportunity to buy small acreage and get the benefit of having thousands of acres of government national forest to enjoy, hunt and restock your property with wildlife. The deer and turkey population in this area is tremendous and will offer plenty of opportunities. An interior trail and food plot is already in place. The timber was cut recently which opened the land up for better vision of wildlife activity. There are still some trees left and new growth will continue for years to come. There is an adjoining 49 +/- Acre tract that can be bought if you are looking for more land. This land is located a short 6.6 mile drive from the I-55 Tillatobia Exit 220. Enid Lake and Grenada Lake are 20 - 30 minutes away. Directions : from the I-55 Tillatobia Exit 220 go East on Hwy 330 for 5 miles. Turn left on County Road 65 for 2/10 mi. then left on County Road 64 for 7/10 Mi. then left on the government gravel road for 7/10 mi to the land. GPS setting 33.989491, -89.804286
MlsNumber: --
ListingId: 4093051


Listing Provided By: Pioneer Auction & Realty Llc, original listing
Phone: (662) 562-2767
Office Phone: (662) 562-6767
Agent Name: Kevin Glidewell
Disclaimer: Copyright © 2024 MLS United. 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