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

0 Willie Neyland Road
Centreville, MS 39631
Billy Ulmer with Stedman Ulmer Properties, original listing - (601) 442-2286

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $900,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Stedman Ulmer Properties
Agency Phone: (601) 442-2286

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 143 acre(s)
Property Type: Land-Other
Year Built: --
Notes: This secluded hunting and recreational retreat in Wilkinson County offers ultimate privacy, located just south of the intersection of Willie Neyland Rd. and the Buffalo River. With the bridge having washed out years ago, the road is now a dead end, ensuring minimal traffic and enhancing the property's seclusion. Once inside the gated entrance, you'll find a spacious 60x27 mobile home, thoughtfully designed for both comfort and entertainment. A standout feature is the expansive outdoor kitchen, complete with a bar and fireplace, providing the perfect setting for hosting family and friends. The property is well-equipped with everything needed for both recreational and practical use. It includes an enclosed storage shed, a skinning station for game processing, and a covered shed for tractors and implements. With three bedrooms and two bathrooms, there is plenty of room to accommodate guests while also providing ample storage for hunting gear and equipment. The all-weather road system allows easy access throughout the land, leading to strategically placed food plots and box stands that offer excellent hunting opportunities. Additionally, a 1/2 mile power line right-of-way creates even more acreage for seasonal plantings. The land itself is rich with mature pine and hardwood timber, offering not only a thriving habitat for wildlife but also an immediate financial return if timber harvesting is desired. Known for its outstanding hunting, Wilkinson County provides prime habitat for deer and turkey, and this property is no exception. With its combination of food plots, box stands, a small pond, and a carefully maintained landscape, it is an ideal hunting destination. Beyond its natural beauty and hunting potential, the property is also conveniently located just one hour from Baton Rouge and 40 minutes from historic Natchez, MS. Whether you're looking for a hunting retreat, a weekend getaway, or an investment in timberland, this property truly checks all the boxes. With its rare combination of seclusion, modern amenities, and prime hunting land, this opportunity won't last long schedule your showing today!
MlsNumber: --
ListingId: 143970


Listing Provided By: Stedman Ulmer Properties, original listing
Phone: (601) 431-5022
Office Phone: (601) 442-2286
Agent Name: Billy Ulmer
Disclaimer: Copyright © 2025 Southwest Mississippi Board 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