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

413 Childress Road
Mammoth Cave, KY 42259

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,500,000
Beds: 4
Baths: 3
Status: Active
SqFt: 3100
Agency: AMERICANA REAL ESTATE AND AUCTIONS

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 176 acre(s)
Property Type: Residential
Year Built: 2005
Notes: The property consists of a custom-home built from 2005 a barn, garden building, attached 2 car garage and separate 3 car garage, specially built RV building suitable for a large motor home. The buildings are located on approximately 17 acres. The total property consists of 177 acres, 60+- tillable, currently in soybeans and 100 acres in timber and woods. A creek and spring are on the property. Childress Rd is a 1/2 mile long, single lane blacktop, no outlet and is a county-maintained road. The wooded area has caves, springs, creeks, cliffs and lots of natural beauty. wildlife consists of turkey deer, fox, coyote, hawk, buzzard and many smaller birds and animals. Most of the property has not had a timber harvest in over 30 years. Within 5 miles is Mammoth Cave National Park. it is 55,000 acres and has walking and riding trails and the longest cave system in the United States. Nearby Nolin Lake has several boat ramps and offers fishing, boating, and waterskiing. Restaurants and convenience stores are also within this five-mile radius. The county has cellular service with Verizon, TV entertainment with DirecTV and internet through Stars satellite and Kinetic that also provide land lines. If outdoors is where you want to be there are covered concrete porches at the front, side and rear of the house. The main porch is an AAZEK deck with stairs to the back and side yards. A concrete patio is accessible via the lower level. Beyond the deck is a small pond which is a magnet for wildlife and provides fishing and fire protection. There are 2 fire pits. A large fire pit in front sits on gravel and a smaller one beyond the ponds on pavers with concrete benches. There is also a covered swing on a concrete pad. The house is a 3-bedroom 2 bath on the main level. Five rooms and a bath on the lower level. The total finished area is 3,100 sq ft. The basement is fully finished with tile and carpet flooring and a lowered ceiling. The lower level is used for a media room, exercise room, office and 2 large storage rooms. Walk out to the patio and backyard via the office. The house is heated with a heat pump supplemented with propane. One is a 500-gallon inground tank with a 1000-gallon aboveground tank. The house has central air. The house is on county water and has a septic system that was serviced in 2020. Hot water is provided by a 75-gallon hot water tank. A 20 KW generator supplies the house with power should the electric fail. Propane powers the generator.
MlsNumber: HK24000853


Listing Provided By: AMERICANA REAL ESTATE AND AUCTIONS, original listing
Name: AMERICANA REAL ESTATE AND AUCTIONS
Phone: (270) 668-2432
Office Name: AMERICANA REAL ESTATE AND AUCTIONS
Office Phone: (270) 668-2432
Agent Name: Dwight Butler
Disclaimer: Copyright © 2024 Heart of Kentucky Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 1028 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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;
Real Estate Expert Photo for Sarah Smith
Sarah Smith
ASCIIGeneric Real Estate
Cell: (241) 555-1812
Office: (241) 555-1776

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App