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

1285 John Lansden Road
Nebo, KY 42441

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $6,500,000
Beds: 5
Baths: 3
Status: Active
SqFt: 6148
Agency: United Country, Heartland Realty & Auction, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 598 acre(s)
Property Type: Residential
Year Built: 2008
Notes: A premier "turn-key" lifestyle property located in Western Kentucky offers a unique opportunity for those who have been searching for that perfect blend of amenities not found in the urban areas. If you are looking for that simpler and more connected way of life for your families, welcome to the rolling hills and landscape of Nebo, KY. The property features the primary custom-built home built in 2008 boasting over 6,100 sq ft with walk-out basement and mothering law suite, (see addendum for details on all three residential houses), detached two story 30' x30' garage built with steel and concrete with lower level storage, 5 agricultural buildings including a 100' x 80' steel shop building w/concrete, livestock barn, hay barn, equipment shed and grain bins. For the exercise and sport minded family the property includes a tennis, basketball, pickleball court and an in-ground 20' x 40' pool with heater. Adjacent to the courts is your personal backyard vegetable and herb garden, surrounded by fencing to keep the varmints at bay! Boasting a primary benefit as a prime 400-acre cattle farm and ranch, the property features ample grasslands, natural water sources, and boundary and cross fencing, facilitating rotational grazing. Furthermore, it caters to hunting and recreational enthusiasts, offering various game species for sport and trophy hunting, as well as ponds stocked with crappie, catfish, bass, and bluegill. With nine lakes and ponds, alongside seven Redneck and two-person enclosed hunting houses scattered throughout the property, outdoor pursuits are abundant. The sellers are presenting a seamless turn-key opportunity inclusive of three residential houses and improvements situated upon 598+/- acres. Alongside the properties, select farm tractors, hay & forage equipment, trailers, and related support equipment and tools are included in the offering. A comprehensive equipment list is being generated, accompanied by a brief addendum detailing the residential properties. It's important to note that the sellers will not subdivide the property nor sell any equipment individually; this offering is presented as a complete turn-key package.
MlsNumber: RA20242329


Listing Provided By: United Country, Heartland Realty & Auction, LLC, original listing
Name: United Country, Heartland Realty & Auction, LLC
Phone: (270) 791-5583
Office Name: United Country, Heartland Realty & Auction, L
Office Phone: (270) 783-3000
Agent Name: Ron Kirby
Disclaimer: Copyright © 2024 REALTOR ® Association of Southern Kentucky, Inc. 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 = 1051 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;
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