Waterfront - Primary on Main
Address
597 Prices Mill Road, Adairville, KY
Price
$ 3,750,000
Property Attributes
- MLS#20261521
- TypeSingle Family
- Listing Status Active
- CountyLOGAN
- CityAdairville
- AreaAdairville
- Zip42202
- StyleTraditional
- Year Built1972
- Price$ 3,750,000
- Bedrooms3
- Full Bathrooms2
- Half Bathrooms0
- Sqr Footage2662
- Lot Size165 Acres
Data Source:
REALTOR® Association of Southern Kentucky (RASK)
Property Description
Family Farm Since 1910 – A Rare Opportunity with Endless Possibilities This stunning, income-producing farm, has been cherished by the same family since 1910. Combining productive farmland, scenic river frontage, and exceptional improvements, this unique property is ideal for recreation, farming, and/or property development. The main residence features 3 BD/2 BTH, and 2,662± square feet of living space, highlighted w/two gas fireplaces and an office/bonus room. A separate guest house offers 2 BD/1 BTH, gas fireplace, and loft, providing excellent space for guests, extended family, or rental income. A separate carport with full bar, gym room (equipment negotiable), and full bath w/shower, all central/heat and air. Perfect for entertaining, game nights, or an ultimate man cave retreat. Farm improvements include barn w/stables, hay loft, fenced & cross-fenced pastures, suitable for horses/cattle. Also, a shop/storage building for equipment & tools. Enjoy approx. ¾ mile of Red River frontage w/opportunities for fishing, kayaking, canoeing, and other outdoor recreation. This property adjoins the Red River Fish & Game Club, which offers stocked fishing ponds & hunting for added enjoyment. Conveniently located just 39 miles from downtown Nashville and near the small bedroom community of Adairville, KY (pop. 800), this exceptional property gives the best of both worlds--peaceful rural living and convenient access to Nashville. Surveyed w/development lots already laid out, this bountiful property offers immediate development potential along w/the flexibility to continue as a productive farm, horse property, recreational retreat, or investment opportunity. Properties offering this combination of history, location, river access, improvements, and development potential are becoming increasingly rare. Don't miss this exceptional opportunity to own a remarkable piece of Kentucky countryside with endless possibilities. Unique properties like this seldom come to market!
| Elementary School | Middle School | High School |
|---|---|---|
| Adairville Elementary School | Adairville Middle School | Logan County High School |
| Price History | |
|---|---|
| 3/25/2026 | Listed $3,500,000 |
General Features
| Water | City |
|---|---|
| Sewer | Septic |
| Heating | Central |
| Other Rooms | Bonus Room,Office,Separate Quarters |
| REO | No |
| Subdivision | None |
| Water Heater | Natural Gas |
| County | Logan |
| Class | Residential/Farm |
| Type | Residential Farm |
| New Construction Y/N | No |
| Status | Active |
| Subdivision | KY |
| Sale/Rent | For Sale |
| Auction Y/N | No |
| Docs on File | Aerial Photo |
| Short Sale | No |
| HOA Fee Includes | None |
| Primary City | Adairville |
| Directions | From Adairville,head East on E Gallatin Road. Property will be on right .6mi out. |
| City | Adairville |
| Middle School | Adairville |
| Fees | Trash Collection |
| Originating MLS | RASK |
| High School | Logan County |
| Year Built | 1972 |
| Elementary School | Adairville |
| DOM | 76 |
| Secondary City | Logan County |
| Postal Code | 42202 |
| Price Per Sq Ft Total AG | 1408.72 |
Interior Features
| Kitchen | Dishwasher,Range/Oven,Refrigerator |
|---|---|
| Basement | None |
| Total Baths | 2 |
| Floors | Carpet,Hardwood |
| Interior Features | Attic Access Only,Ceiling Fan(s) |
| Walls | Dry Wall |
| Utility Room | Laundry Room |
| Full Baths | 2 |
| Basement Y/N | No |
| Air Conditioning | Central Air |
| SqFt Source | Other |
Exterior Features
| Garage Spaces | 2 |
|---|---|
| Foundation | Block |
| Lot Size Area | 165 |
| Price Per Acre | 22727 |
| Exterior Features | Barn,Enclosed Patio,Stables,Storage Building |
| Roofing | Shingles |
| Fence | Fenced Yard |
| Garage/Carport | Carport Detached |
| Water Features | River |
| Acreage Source | Survey |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
Property vs Single Family Average in 42202
Price
Year Built
Visits
Data last updated: September 12, 2026 4:57 AM UTC and updating occurs daily
The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of Metro Search, Inc. Real estate listings held by brokerage firms other than United Real Estate Louisville are marked with the Internet Data Exchange logo or the Internet Data Exchange thumbnail logo and detailed information about each listing includes the name of the listing broker.
© 2026 Metro Search, Inc.
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating
The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program. Real estate listings held by IDX Brokerage firms other than United Real Estate Louisville are marked with the Internet Data Exchange logo or the Internet Data Exchange thumbnail logo and detailed information about them includes the name of the listing IDX Brokers. This information is provided exclusively for personal, non-commercial use and may not be used for any purpose other than to
REALTOR® Association of Southern Kentucky All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may
Heart of Kentucky Association of REALTORS® All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating
