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 = 2450 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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 = 2450 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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 = 2450 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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 Bateman Rd
Moscow, TN 38057
Stephen Shane Martin with Southern Land Company TN, llc, original listing - (901) 755-8877

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $490,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Southern Land Company TN, llc
Agency Phone: (901) 755-8877

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 49 acre(s)
Garage: Garage
Property Type: Land-Other
Year Built: --
Notes: Beautiful rolling hills with multiple build sites provide the perfect opportunity for a family retreat and outdoor recreational activities, such as hunting, ATV riding, or horseback riding. The property features a diverse mix of hardwood and pine timber, meandering fields, and a well-maintained road system throughout. Partially enclosed with barbed wire fencing on three sides, it also offers a gated entrance from Bateman Road for added privacy and security. Outdoor enthusiasts will appreciate the excellent deer and turkey habitat, making it a haven for hunters and nature lovers alike. Conveniently located near Collierville and Germantown, this property strikes the perfect balance of seclusion and accessibility. Whether you're looking to build your dream home or simply enjoy the great outdoors, this land has it all. Don't miss this rare opportunity! PRICE: ( $10,000 per acre ) includes all owned gas, oil and mineral rights, Tract 1 - $490,000 Tract 2 - $490,000 LOCATION:located in Fayette County on Bateman Rd in Moscow, TN near Wolf River &Ghost River SNA & WMA, close proximity to Collierville. *Coordinate: 35.037935°N, 89.350637°W ACREAGE: 98.66 +/- Total Deeded Acres survey has been done on complete property. Tract 1 - 49+/- acres ( stocked pond) Tract 2 - 49+/- Acres INSPECTION: Shown by Appointment:
MlsNumber: --
ListingId: 11381046


Listing Provided By: Southern Land Company TN, llc, original listing
Phone: (901) 755-8877
Office Phone: (901) 755-8877
Agent Name: Stephen Shane Martin
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