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

280 Paradise Lane
Crawford, TN 38554
Shelley Marshall with First Realty Company, original listing - (931) 484-1005

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $375,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: First Realty Company
Agency Phone: (931) 484-1005

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 15 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Creek Frontage year round! Sellers have cleared a nice area of the property where they have built the Metal barn with lean- to with 6 inch concrete flooring. They have cleared for additional drive way and on the other side. A additional cleared area for additional home site is ready for new owner to build their dream home. The homesite that is prepared to build on is completely separated from where the barn was built to ensure privacy for both structures.<br /> There is electric going to the barn, installed in and out, with outlets, lighting and a dedicated 50A outlet for an RV.<br /> There is plumbing in the barn ready for a bathroom to be installed, a septic tank was installed on the property at the Metall Barn. There is a dump station for RV to empty directly into the septic tank. <br /> The barn has a concrete 6 inch floor that is polished and strong enough to house equipment, or even an RV.<br /> The barn is built to where it would easily living quarters or main house /home / barndominium The plumbing, septic. electric, etc is ready for new occupant. <br /> The property has areas of flat land for additional home sites to build on. <br /> The driveways have all 4' inch gravel underneath and 1' inch on top. This makes for easy sturdy access.<br /> The underground electric goes from the pole underground to the barn. There is high speed internet and there are 3 frost proof spigots installed around the barn for water supply. <br /> The barn has rows of LED lighting both in the barn as under the overhang. a 30/50 amp dedicated outlet was installed inside the barn and another one was installed under the overhang to ensure people can bring their camper and stay in it comfortably on the property. It can be hooked up to the sewer (that goes in the septic), water and 30 or 50 amp electric. So technically someone could start living there from day 1. Information is Deemed Reliable but not Guarenteed, buyers to verify any and all information.
MlsNumber: --
ListingId: 1280770


Listing Provided By: First Realty Company, original listing
Phone: (931) 484-1005
Office Phone: (931) 484-1005
Agent Name: Shelley Marshall
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