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

000 Hwy 478 & John Wright Rd
New Hebron, MS 39140
James Kavitz with United Country - McDaniel Gray, original listing - (601) 835-2000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $426,400
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: United Country - McDaniel Gray
Agency Phone: (601) 835-2000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 164 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Nestled in Simpson County, Mississippi, this 164-acre property is a natural paradise. Featuring a dense 10-year-old pine forest, an extensive road network, and abundant deer and turkey populations, it's a haven for outdoor enthusiasts. Notably, Vaughn Creek gracefully bisects the land, adding both scenic charm and recreational potential. The mature 10-year-old pine trees form a lush canopy, offering both visual appeal and the prospect of future timber income. A well-maintained road system crisscrosses the property, ensuring easy access for exploration and outdoor activities. Wildlife lovers will relish the thriving deer and turkey populations sustained by the diverse habitat created by the pine forest and Vaughn Creek's presence. Whether you're a hunter or prefer wildlife observation, this property provides ample opportunities. Moreover, Vaughn Creek itself is a captivating feature, offering relaxation and recreation possibilities. Its meandering flow adds to the property's aesthetic beauty and potential for fishing or simply unwinding to the soothing sound of flowing water. In summary, this 164-acre property in Simpson County, Mississippi, offers a unique blend of natural beauty, recreational opportunities, and potential timber resources. It's a perfect escape to experience the great outdoors in Mississippi's countryside. PLEASE CONTACT LISTING AGENT TO SCHEDULE SHOWINGS & FOR THE PROSPECTIVE PURCHASER INSPECTION AGREEMENT
MlsNumber: --
ListingId: 140053


Listing Provided By: United Country - McDaniel Gray, original listing
Phone: (601) 201-4048
Office Phone: (601) 835-2000
Agent Name: James Kavitz
Disclaimer: Copyright © 2024 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