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 = 64 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 = 64 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 = 64 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 Antioch Church Rd
Millry, AL 36558
Slade Johnston with Tutt Real Estate, original listing - (334) 627-4004

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $142,900
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Tutt Real Estate
Agency Phone: (334) 627-4004

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 35 acre(s)
Garage: Garage
Property Type: Land-Other
Year Built: --
Notes: This property is turn-key ready to go for a small home place or hunting camp with recreational opportunities! It is surveyed at 34.58ac. The timber consists of young pine and mixed pine/hardwood SMZ. The seller has cleared 2-3 acres for the home place and trails to access the rest of the property. This area has great hunting and you could easily incorporate a couple hunting foodplots on the property. There is a small seasonal stream running through the West side of the property. Included with the land is the 2012 40ft K-Z- Inferno 3710T Toy Hauler, Power Tools, Chainsaw, Weedwhacker, Craftsman 26 hp 54 inch lawn mower and a brand new elite seed spreader. The toy hauler is insured as stationary and can carry full coverage. Or it can be changed for travel use. Power/ well water has already been run to and hooked up to the Toy Hauler. The well is brand new with an upgraded 1hp pump and bigger tank providing great, clear water. There is 1 main and 2 secondary hookups for hoses. Seller already has garbage pick-up and mail delivery in place. Seller would like to sell everything as a package but open to offers on the land only as well. Additional acreage could be available nearby too. Property Coordinates: 31.5812, -88.4474 Distances: 15min to Millry, AL 35min to Waynesboro, MS 1hr 25min to Mobile, AL
MlsNumber: --
ListingId: 11342391


Listing Provided By: Tutt Real Estate, original listing
Office Phone: (334) 627-4004
Agent Name: Slade Johnston
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