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 = 2463 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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 = 2463 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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 = 2463 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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;

838 Longs Bend Road
Rogersville, TN 37857
Katy Bennett with Hurd Realty, LLC, original listing - (423) 491-8335

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $875,000
Beds: 2
Baths: Full: 1
Status: Active
SqFt: 1976 Square Feet
Agency: Hurd Realty, LLC
Agency Phone: (423) 491-8335

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 48 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1962
Notes: Whether you are a farmer, a hunter, a prepper, an off-gridder, or just looking for some peace and quiet, this is the property for you! Come take a look at your very own private valley with ridges on three sides ensuring privacy. The seller has gone to great lengths to make this property a dream come true. Now it's your chance to walk right in and harvest all the fruits of their labor!<br /> <br /> -50+ acre farm—fully fenced with powered automatic gate<br /> -2 bedroom/1 bath (1000sq ft) home w/full basement<br /> -30' x 40' barn <br /> -10 ' x 20' greenhouse equipped w/ solar water heater and kerosene heater as well as electricity<br /> -Basement of home has also been set up w/extensive grow lights as a secondary greenhouse<br /> -20' x 25' poultry enclosure w/ 10' x 10' coop<br /> -10 ' x 15' shooting shack w/ flip up front <br /> -pistol range w/targets<br /> -600+ yard rifle range with targets set up every 100 yards<br /> -deer stand<br /> -2 fully stocked ponds:<br /> -Large Pond w/solar well pump, 12'-15' deep: Koi, bluegill, crappie, catfish and bass<br /> -Small Naturally Spring-fed Pond: bluegill and trout <br /> -above ground pool set up for raising freshwater prawns<br /> -Small Orchard: peach, apple, persimmon, plum, fig, and elderberry <br /> -Other fruit/nut trees including: black walnut, wild cherry, pawpaw (multiple varieties, both wild and cultivated), pecans, hickory, persimmons, sassafras, and blackberries as well as American Chestnut seedlings<br /> -The seller has also cultivated ramps, Morrel mushrooms, and black truffles throughout the woods<br /> -3 beehives w/equipment<br /> -Abundant wildlife frequent the property including deer, bear, wild turkey, bobcat, fox, and coyote<br /> -plentiful water from 2 creeks, 2 ponds, multiple freshwater springs and an excellent well<br /> -tractor w/implements, side-by-side, sawmill and SO MUCH MORE!<br /> There is so much about this amazing property that wouldn't fit here. Ask your REALTOR for the full property description from the MLS documents. <br /> <br /> Info taken from CRS. Buyer/Buyer's Agent to verify all info.
MlsNumber: --
ListingId: 9976540


Listing Provided By: Hurd Realty, LLC, original listing
Phone: (423) 328-2165
Office Phone: (423) 491-8335
Agent Name: Katy Bennett
Disclaimer: Copyright © 2025 Tennessee Virginia Regional Multiple Listing Service. 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