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

0 Co Rd 20
Epes, AL 35460
Mitchell Jones with National Land Realty, Gulf Coast, original listing - (855) NLR-LAND

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,500,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 1950 Square Feet
Agency: National Land Realty, Gulf Coast
Agency Phone: (855) NLR-LAND

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 568 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Discover this exceptional 568± acre high-fenced property in Sumter County, a true haven for outdoor enthusiasts nestled in the heart of the Blackbelt! This private retreat offers year-round recreational adventures, including spring turkey hunting, stocked lakes for fishing, dove fields, a duck pond, and the opportunity to pursue world-class whitetail deer. The centerpiece of the property is a charming, rustic cabin built in 2016. Featuring 4 bedrooms and 2.5 baths, it boasts a wood-burning fireplace and elegant finishes of cedar, tile, and granite throughout. Relax on the expansive covered porch overlooking one of the lakes and dove fields—an ideal spot to unwind. The diverse landscape is an outstanding habitat for deer, turkeys, and waterfowl, including thinned mature pine plantations, lush bottomland hardwoods, pockets of cedar, Jones Creek frontage, and strategically placed food plots. With 10 brand-new premium Redneck and Ranch King shooting blinds, the farm is ready to enjoy this season! Additional amenities include a spacious barn, perfect for storing your tractor, ATVs, and other equipment, ensuring everything is protected from the elements. This property truly has it all for those seeking premium quality hunting with all the amenities in a stunning setting. Shown strictly by appointment only!
MlsNumber: --
ListingId: 11354770


Listing Provided By: National Land Realty, Gulf Coast, original listing
Phone: (855) 657-5263
Office Phone: (855) NLR-LAND
Agent Name: Mitchell Jones
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