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

101 Harris Cove
Carthage, MS 39051
Stuart Warren with Turn Key Properties, LLC, original listing - (601) 427-5088

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $155,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Turn Key Properties, LLC
Agency Phone: (601) 427-5088

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 38 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Nestled just off the beautiful Historic Natchez Trace in Leake County, approximately half a mile from the Madison County Line and Hwy 16, sits this 38.72 +/- surveyed acre tract. When you are traveling the Natchez Trace to this property you quickly find yourself slipping away to the feelings of relaxation, and peace. As you arrive to the property, you will find 100 +/- feet of road-frontage and a gated private drive, here is where you can park or you are welcome to drive deeper into the property to the old Homesite, utilities like electricity and water are available, if you have ever wanted to have horses this would be a great location, soak in the breathtaking views, next utilize the establish trail system that navigates you throughout this 38.72 acre wooded paradise. Throughout this tract you will quickly find that you are in a wildlife paradise. The whitetail deer and turkey population are plentiful, and you will quickly see why. Touring this property, you will notice that there is no shortage of cover consisting of vegetation, sapling groves of pines where wildlife can go to escape and grow old. Recent trail camera inventory has shown several great whitetails, and a healthy turkey population often frequent this farm. This farm truly is a recreational or outdoorsman's paradise. This land has a ton to offer, build your dream home, barndominiums, and mobile home are welcome, build a barn, grow a garden, raise livestock, hunt deer, squirrel, turkey, this is a great location turn left on the Natchez Trace and you will be at Hwy 43 in Gluckstadt or Interstate 55 in no time, or turn right and be in Carthage in minutes, also Hwy 16 is very close and it makes getting to Canton and Carthage very easy as well. The seller owns a total of 80 acres so don't hesitate to ask for a larger or smaller section of land. Don't miss out on this opportunity to call this place home, call today to schedule your private tour.
MlsNumber: --
ListingId: 4099125


Listing Provided By: Turn Key Properties, LLC, original listing
Phone: (601) 672-6808
Office Phone: (601) 427-5088
Agent Name: Stuart Warren
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