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

573 Old Grandview Hwy
Grandview, TN 37337
Sheryl Webb with Weichert, Realtors-The Webb Agency, original listing - (931) 707-8787

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $244,499
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Weichert, Realtors-The Webb Agency
Agency Phone: (931) 707-8787

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Property Type: Land-Other
Year Built: --
Notes: This is truly one of the nicest pieces of property I've ever seen! Prepare to be impressed as soon as you pull onto the property. The majority of the property is cleared except for a nice buffer of trees all the way around the outside perimeter. The property is level and would have several nice homesites. There is a permit for a 2 bedroom septic system, but that was only because the owner only planned to build a small cabin and could probably be extended. The seller will leave several stacks of leach field chambers. The property has a greenhouse and an 8x20 foot shed. There is a chicken coop and two structures holding four beehives ready for bees. There are over 60 fruit trees, including apple, cherry, plum, pear, apricot, peach, and nectarine; lots of berries, including 30 blueberry bushes plus blackberries, boysenberries, raspberries, and elderberries; grapevines, and raised beds already planted with strawberries and asparagus. There is a garden site that is planted with vegetables. Four mature chestnut trees produce lots of chestnuts. Water lines are buried with spigots every few feet for easy watering. The large pond is filling up and should be full soon. There are some old structures on the property that are not structurally sound, but it could be refurbished or used for storage. There was a mobile home that has been removed, and it had a septic system that could possibly be used for a camper while you build your dream home. There are two city water taps, and there are also three wells from the old homesites. This is a perfect homestead!
MlsNumber: --
ListingId: 1299721


Listing Provided By: Weichert, Realtors-The Webb Agency, original listing
Phone: (931) 707-8787
Office Phone: (931) 707-8787
Agent Name: Sheryl Webb
Disclaimer: Copyright © 2025 East Tennessee 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