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;

4848 Greenville Rd.
White Plains, KY 42464
THE BARNES REALTY GROUP with KELLER WILLIAMS ELITE, original listing - (270) 926-5000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,690,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: KELLER WILLIAMS ELITE
Agency Phone: (270) 685-3705

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Farm-Farm
Year Built: --
Notes: A Western Kentucky Dream – 188+/- Acres of Serenity, Luxury, and Opportunity Welcome to a once-in-a-lifetime opportunity to own a breathtaking nearly 190-acre farm that truly has it all. Nestled in the rolling countryside of Western Kentucky, this expansive estate offers a unique blend of upscale living, agricultural potential, recreational paradise, and income-producing opportunities. At the heart of the property sits a beautifully appointed primary residence boasting nearly 3,000 sq ft of thoughtfully designed living space. Featuring 4 spacious bedrooms and 2 full bathrooms—including a luxurious master suite with an oversized walk-in closet, elegant tile shower, and private access to the sunroom—this home combines comfort and sophistication. The sunroom is your front-row seat to awe-inspiring views of the landscape, with the secondary lake just beyond, creating a picturesque backdrop of peace and tranquility. Inside, you’ll find 10-foot ceilings, granite countertops, custom cabinetry, some soft close cabinetry, and a stunning stone gas fireplace that adds warmth and charm. The grand front porch invites you to unwind with a cup of coffee in the morning or relax in the evening, soaking in the sights and sounds of nature. Water features abound on this property, starting with a massive, fully stocked lake ideal for fishing and relaxing, plus a secondary stocked lake just behind the main home. These serene bodies of water not only enhance the natural beauty but offer fantastic fishing opportunities and scenic reflection points. A full secondary home on the property includes 2 bedrooms and 1 bathroom, making it the perfect guest house, in-law suite, or income-generating rental—ideal for either short-term or long-term stays. For those dreaming of a working farm or equestrian estate, the land is mostly cleared and fenced, offering ample room for row crops, pasture, cattle, or horses. Two barns stand ready—one outfitted with cattle chutes and the other suited for equipment storage—while a three-bay detached garage near the main residence adds further functionality. Outdoor enthusiasts will find themselves in paradise with abundant hunting opportunities including deer, turkey, coyotes, and more. Whether you're looking for a corporate retreat, looking to raise livestock, host events, fish, hunt, or simply enjoy the wide-open space, this land supports every ambition. To top it all off, a gated entrance with a coded security system ensures privacy and peace of mind. This is more than a property—it's a lifestyle. Don't miss your chance to own a piece of Kentucky heaven.
MlsNumber: --
ListingId: 92078


Listing Provided By: KELLER WILLIAMS ELITE, original listing
Phone: (270) 926-5000
Office Phone: (270) 926-5000
Agent Name: THE BARNES REALTY GROUP
Disclaimer: Copyright © 2025 Greater Owensboro Realtor® Association. 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 Rachel Baker
Rachel Baker
ASCIIWright Choice Realty
Call Today!: (270) 543-8724

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App