Public Remarks: Perfectly peaceful paradise! Specifically understated elegance, this expansive estate feels as if it's perched in the clouds, nestled up on approximately 48 stunning acres with sweeping and inspiring views at every turn of the breathtaking countryside, wondrous pond and unrivaled sunsets! This classic and timeless custom designed home flows through three carefully curated levels which includes an indoor all-seasons resort-style extraordinary pool area. Designed and executed with attention to detail this home features uncompromising quality and appointments displaying remarkable craftsmanship, windows carefully executed throughout to capture the stunning views and natural light, soaring 20+ coffered and beamed ceiling, an impressive balcony, a true culinary kitchen with an abundance of prep and gathering space and direct access to the pool area, all generous rooms have ensuites with the primary suite on the first floor, an elevator and a lower level designed for an entertainer's dream. Also, a commercial size multi-use metal barn with water/electric, separate meter, 80x40. All with the convenience of being ~25 minutes to Downtown Cincinnati and CVG Airport. Truly exceptional!!
Single-familyProperty Type
2007Year Built
48 acresLot Size
3 car garageParking
Listed by Lee Robinson• Robinson Sotheby's Int. Realty
Listed by Britt Langman• Robinson Sotheby's Int. Realty
Bought with The Berens Team• Keller Williams Realty Service
As the MLS and public records start to fill up, we'll list the details here.
Public record
Public record
Zoning
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
—
Year renovated
—
Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Boone County
APN
042.00-00-012.13
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jun 10, 2024.
A-2
Agricultural Estate District
The purpose of the Agricultural Estate district is to provide for low density residential development and on a limited basis agricultural uses or agricultural related uses in the context of a rural environment.
Private Yard, Fire Pit, Balcony, Fountain, Hot Tub, Lighting, Outdoor Grill
Shingle
Property Type
Single Family Residence
Property Features
Property Condition: Existing Structure
Has View
Property Information
Property Type: Residential
Land Information
Foundation Details: Poured Concrete
Road Surface Type: Gravel, Paved
Road Frontage Type: City Street, Private Road
Other Structures: Outbuilding, Barn(s), Pool House, Shed(s)
Vegetation: Heavily Wooded
Lot Information
Lot Size Units: Acres
Lot Size Sq. Ft.: 2,090,880
Lot Size Dimensions: Of record
Lot Size Area: 48
Lot Size Acres: 48
Lot Features: Pond, Rolling Slope, Sloped, Wooded
Utilities
Utility Information
Water Source: Public
Sewer: Septic Tank
Utilities: Propane
Location
School Information
Middle Or Junior School: Gray Middle School
Elementary School: New Haven Elementary
High School District: Boone Co Public
High School: Ryle High
Location Information
Directions: 71/75 to exit 175 toward Richwood to KY338N/Richwood Rd, go west to stay on KY 338N, left on US-127/US-42. right on KY-338N to next entry driveway past Liberty Hills Road.
Public facts
Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: —
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: Boone County
APN: 042.00-00-012.13
Home facts updated by county records on Jun 10, 2024
Around this home
Schools
New Haven Elementary School
Public PreK-5 • Assigned • 3.5mi
9/10
Gray Middle School
Public 6-8 • Assigned • 4.1mi
8/10
Larry A. Ryle High School
Public 9-12 • Assigned • 4.3mi
9/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
4/10 Heat Factor
7 days above 103° expected this year, 19 days in 30 years
2/10 Wind Factor
1% chance of strong winds in next 30 years
3/10 Air Factor
2 unhealthy days expected this year, 4 days in 30 years
Provided by First Street
Historical weather
Union, KY • 41091
Average low and high temperatures (°F)
35
19
44
27
62
41
70
49
72
54
83
65
87
70
83
65
82
59
70
49
55
40
44
30
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.1 hours in
June and 3.2 hours in December, placing it below the
U.S. average for solar exposure.
9.1 hrs
3.2 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$2.70M – $3.27M
Reach more buyers when you sell with Redfin. Save up to $28,460 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.