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

159 Alvin Willis Road
Columbia, KY 42728
Ken Hill with Patriot Realty - Auction LLC, original listing - (270) 380-1246

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $525,000
Beds: 3
Baths: Full: 1
Status: Active
SqFt: 1925 Square Feet
Agency: Patriot Realty - Auction LLC
Agency Phone: (270) 380-1246

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 21 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1870
Notes: Step out of the ordinary. Anyone can live in a regular, old house, but not everyone gets to literally live in history. This entire farm is dedicated to the great history of the area, and is the long-term, labor of love for the owner family. Located approximately 7 miles from Columbia, along the original road that led to town, the main home consists of a documented log cabin, circa 1870, rescued from its' original location less than a mile away, and painstakingly reproduced on this beautiful farm. Much, if not all, of the original "feel" has been preserved, while modern necessities were tastefully added. A large living room, and 3 bedrooms are within the original structure, including the most amazing, wood-burning, stone fireplace. Walk through the front room, and you enter the modern addition that includes a modern kitchen, dining room,and huge den/living room that is perfect for large gatherings and entertaining. A screened porch off the side of the kitchen extends the gathering area in good weather, and connects the front porch, which has the most relaxing views you can imagine. Live in comfort with zoned split unit and gas wall furnaces. For the most authentic experience you can light a good, crackling fire in the big stone fireplace and step back in time 154 years. Need room for friends and guests? There's a second log cabin with a "dogtrot" breezeway and still more great sitting porches with amazing views of the pond and wide open farmland. There's a kitchen, living room and small bathroom on the first floors, and lots of sleeping space in the connecting bedroom above. This is an equally cool place with lots of charm. You gotta have storage space, so a log pen barn serves both cabins, with a large barn, storage building, and smokehouse located beyond the pond. Need more? There's an orchard, a large, spring-fed pond with a relaxing camp area, a covered shooting table, and an established shooting range through the woods, where matches are regularly held. The woods and fields are teeming with small game, and many deer have been harvested from the property. Just down the road is a great put-in point for canoeing, kayaking and fishing on Russell Creek. All this is located near Columbia, Kentucky, only a short drive from Green River Lake, Lake Cumberland, and about 2 hours from Lexington, Louisville, and Nashville. Although some of the furnishings are family heirlooms, many items shown in the photos are negotiable.
MlsNumber: --
ListingId: SC46108


Listing Provided By: Patriot Realty - Auction LLC, original listing
Phone: (270) 378-1108
Office Phone: (270) 380-1246
Agent Name: Ken Hill
Disclaimer: Copyright © 2024 South Central 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 = 998 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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;
Sarah Smith (Fabian Test Account)
ASCIIBetter Homes and Gardens Real Estate - Nicholson Group
Cell: (241) 555-1812

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App