See other homes in:
Primary listing photo
Listing photo 2
Listing photo 3
Listing photo 4
Listing photo 5

450 Waterworks Rd, Danville, KY, 40422

10beds
10baths
11,442sqft
$1,290,000
$113price/sqft
$9,403/moest. monthly cost
$376,120/yrincome needed

About This Home

Located in Danville, KY The Farm Inn is a unique hospitality and event property offering rustic charm, scenic countryside views, and endless potential. Ideal for a boutique inn, wedding venue, retreat, or private estate, this established property combines peaceful surroundings with convenient access. A rare opportunity to own a one-of-a-kind destination in Central Kentucky. Beautiful 26-acre property offers a versatile blend of productive tillable ground and fenced pasture, perfectly suited for horses, cattle, hay production, or crops. The gently rolling terrain provides scenic countryside views and excellent usability, creating a peaceful setting ideal for both agricultural and recreational use. Guests of the inn can enjoy walking trails, open green space, and the quiet charm of the surrounding landscape. With ample room for farming, livestock, outdoor events, or future expansion. Main House-This stunning 7,348 sq. ft. Colonial-style home blends timeless character with extensive modern renovations and additions throughout. Featuring 10 bedrooms, 8 bathrooms, 2 full kitchens, multiple dining and living spaces, and several beautiful fireplaces, the property is perfectly suited for a bed & breakfast, boutique inn, or short-term room rentals. Thoughtfully updated while preserving its historic charm, this spacious estate offers exceptional flexibility for hospitality, events, or private residential use. Guest House- A charming 1,200 sq. ft. guest house offers flexible living space with a studio-style layout, full kitchen, and full bath. Ideal for long-term tenants, short-term rentals, guest accommodations, or an event prep building. Cabin 1 and Cabin 2- A pair of beautiful 1,400 sq. ft. guest cabins combines rustic warmth with comfortable living, featuring beautiful pine interior finishes, 2 bedrooms, 1 full bath, a cozy loft, full kitchen, and inviting living area. A spacious back deck offers the perfect place to relax and enjoy the peaceful countryside setting. Ideal for short-term rentals, private guest accommodations, or elegant bride and groom suites, this cabin provides both character and income-producing potential. Outbuildings/Barns-The property also features two classic barns and three silos that add incredible character and visual appeal to the grounds. Beyond their charming farmhouse aesthetic, the barns provide excellent storage and functional space for event supplies, equipment, décor, or agricultural use, further enhancing the property's versatility for hospitality, weddings, and special events. This picturesque property offers endless recreational opportunities in a peaceful countryside setting. The gently rolling 26 acres are ideal for walking trails, horseback riding, outdoor gatherings, gardening, and enjoying the scenic beauty of Central Kentucky. With open green space, charming barns, and quiet surroundings, the property creates the perfect retreat for relaxation, weekend escapes, weddings, events, or agritourism experiences just minutes from town, golfing, and the Bourbon Trail. This property is well suited for a variety of agricultural uses, featuring a combination of productive tillable ground and fenced pasture ideal for crops, cattle, horses, or a hobby farm operation. The gently rolling landscape provides excellent usability for grazing, hay production, gardening, or recreational farming, while also offering scenic open space that complements the property's peaceful rural setting. Previously operated as a successful inn from 2010-2019, the property offered guests a true Kentucky experience - waking up to breakfast before being chauffeured in a sprinter van for tours along the famous Bourbon Trail. Today, the property continues to generate income through a combination of long-term and short-term rentals, offering excellent flexibility and proven hospitality potential for future owners. Seller incentives- The sellers are amenable to including up toa $25,000 courtesy sellercredit to buyer at the time of closing. Further, recognizing the uniqueness of the Property and its many uses, the sellers will also consider offers that contemplate partial seller financing.Parties may contact the listing agent to initiate a conversation about the terms and conditions of any such dynamic financing. Kentucky enjoys a moderate four-season climate with warm summers, mild springs and falls, and generally moderate winters. The region is known for its lush green landscapes, rolling countryside, and long growing seasons that are ideal for agriculture, horse farms, and outdoor recreation. Seasonal changes bring colorful autumn foliage, blooming spring scenery, and comfortable conditions for year-round tourism and events. Danville, founded in 1787, is known as the "Birthplace of Kentucky" because it hosted the conventions that led to Kentucky becoming the 15th state in 1792. Rich in history and preserved architecture, Danville features a vibrant downtown filled with historic buildings, locally owned shops, restaurants, and cultural attractions. The city is also home to Centre College, one of the nation's top liberal arts colleges, and is centrally located near Kentucky's famous Bourbon Trail and scenic countryside. Located in Danville, this property offers the perfect balance of peaceful countryside living and convenient access to local amenities. Known for its historic charm, vibrant downtown, and rich Kentucky heritage, Danville is home to unique shops, restaurants, entertainment, and the renowned Bourbon Trail. Centrally positioned in Central Kentucky, the area provides easy access to Lexington, outdoor recreation, and regional attractions while maintaining the quiet appeal of small-town living.

Getting Around

0
WalkingCar-Dependent
0
TransitVery Limited Transit
27
BikeSomewhat Bikeable

Schools

10/10
7/10
10/10
Boyle County High SchoolGrades 9-123.9 mi

Construction

Condition

  • Year built: 1860

Type & Style

  • Home type: SingleFamily
  • Property subType: Farm

Interior

Bedrooms & Bathrooms

  • Bedrooms: 10
  • Bathrooms: 10
  • Full bathrooms: 10

Features

  • Finished area above ground: 11,442

Interior Area

  • Total structure area: 11,442
  • Total interior livable area: 11,442 sqft

Property

Details

  • Parcel number: 049000010
  • Lease amount: 0

Lot

  • Lot size: 26 Acres

Climate Risk is Financial Risk

Every home has a financial story beyond the listing price. Below, you’ll see the climate risks that could affect this property — and in Bills & Affordability, how those risks may influence repairs, insurance, utilities, and long-term value.

Biggest Threats for This Home

  • Strong Wind
    Strong WindVery High
  • Tornado
    TornadoVery High
  • Cold Wave
    Cold WaveRelatively High
  • Lightning
    LightningRelatively High
  • Winter Weather
    Winter WeatherRelatively High
  • Hail
    HailModerate
  • Inland Flooding
    Inland FloodingModerate
  • Ice Storm
    Ice StormModerate

How This Home’s Risks Compare

Strong Wind
Tornado
Cold Wave
Lightning
Winter Weather
Hail
Inland Flooding
Ice Storm

FEMA Declared Disasters Across Kentucky Counties

Flood
Mud Landslide
Severe Storm
Straight Line Winds
Tornado
Winter Storm

Understanding the Costs

Financial advisors generally recommend spending no more than 30% of your gross household income on housing costs. In practice, many households stretch to 35% or beyond — especially in high-cost markets.

Estimated Costs Today

MonthlyAnnual
Mortgage $6,522$78,264
Home Insurance *$933$11,196
Property Taxes $1,045$12,540
Electricity $903$10,843
Total$9,403$112,836
*Does not include cost of any FAIR Plan premiums

Income You'd Need if You Spent...

35% on housing$322,388/yr
40% on housing$282,090/yr
45% on housing$250,746/yr

Kentucky FAIR Plan Programs

Kentucky FAIR Plan Reinsurance Association

Covered
WildfireWildfire
Add-on available
HailHail
WindWind
Visit Website →
Current Policies
Residential: 4,102Commercial: 175
Total Premiums$2.55M
Total Exposure$206.09M

How Costs Could Change Over Time

Climate risk is quickly impacting all of the major home ownership costs. Adjust the growth rates and percentage of income spent on housing below to see how your housing costs could change over the next 10 years — and what income you'd need to keep up.

Insurance Growth Rate5-year average: 9.7%
9.7%
0%30.0%
Electricity Growth Rate10-year average: 6.0%
6.0%
0%15.0%
Property Taxes Growth Rate2-year average: -1.9%
-1.9%
0%15.0%
Income Spent on Housing
30%
30%45%

Comparing Against the Market

Price Per Sq Ft

$113This listing

vs Other Active Listings

Avg $/sqft

ZIP 40422$150
Boyle County$170

vs Homes Sold Last Month

Median $/sqft

ZIP 40422$153
Boyle County$162

Current Market Trends

Median Price Per Square Foot

The median price per square foot of homes sold in this area each month. Compare this to this listing's price per square foot to gauge whether the home is priced in line with recent sales.

Historicals for This Listing

Zestimate History ($/sqft)

Price History

DateEventPrice
2026-07-22Listed for sale$1,290,000
2026-07-22Listing removed$1,290,000
2026-07-14Price change$1,290,000
2026-05-12Listed for sale$1,370,000
2026-03-13Listing removed$1,450,000
2026-03-06Price change$1,450,000
2025-12-15Listed for sale$1,680,000
2020-05-27Sold$58,000

For Sale by Agent

AgentSilas Sparrow
BrokerageHayden Outdoors Real Estate

Similar Homes