Title Page Background
DEBUG FN args: Array ( [0] => 2451 [1] => [2] => [3] => agent ) BEFORE: Site: 2451 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2451 Igate: njhud LocID: 2451 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2451 AND i.igate IN ('tnhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2451 [1] => [2] => [3] => lender ) BEFORE: Site: 2451 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2451 Igate: njhud LocID: 2451 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2451 AND i.igate IN ('tnhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2451 [1] => [2] => [3] => other ) BEFORE: Site: 2451 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2451 Igate: njhud LocID: 2451 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2451 AND i.igate IN ('tnhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

147 Akers Chapel Loop
Jamestown, TN 38556

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $780,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1881 Square Feet
Agency: Mitchell Real Estate & Auction
Agency Phone: (931) 397-6460

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 13 acre(s)
Property Type: Residential-Other
Year Built: 2006
Notes: Where to start on this beautiful property. Not only is it gorgeous in a beautiful setting but It provides privacy and access to the Highland trail system. The property comes with half interest in a lot in the Highlands which allows you to ride right from your barn into 3000 acres that have 45 miles of private trails. The wood cabin with wrap around porch allows for wonderful fulltime living. The grounds are pristine and loaded with plants, as well as there are acres and acres of lush pasture. The cabin is made from local hemlock,pine and oak. It is in top condition. Open floor plan. New refrigerator, new stove. Washer, dryer and hot water heater installed in 2023. HVAC installed in 2021. The septic inspected and cleaned in 2023. All wood on cabin resealed in 2023 and roof screws replaced. The small guest cabin was installed in 2023 and is the perfect place for guests or to rent out as a B&B. The stable has 5 stalls and extra storage for tack and hay. There is also a large barn to be utilize for hay, equipment and storage. Plus there is a regulation size outdoor arena. Just too many amenities to list. This is a must see property. No restrictions and access to 45 miles of trails is very hard to find in the BSF area. The part ownership in the Highlands lot that allows you to ride their wonderful trails has an HOA with yearly dues of $375.00 and minimal taxes. It's an invaluable asset to this property. But the home and the 13.93 acres are not restricted and no HOA dues.<br /> Call me for a private viewing. <br /> The dog panels and free standing fireplace in the master bedroom do not convey.
MlsNumber: --
ListingId: 1261128


Listing Provided By: Mitchell Real Estate & Auction, original listing
Phone: (931) 397-6460
Office Phone: (931) 397-6460
Agent Name: Glenda Levin
Disclaimer: Copyright © 2024 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