Public Remarks: Nestled atop a vast 3.55-acre expanse along the scenic Ohio River, this magnificent estate stands as a pinnacle of luxury living, commanding breathtaking views of the river and the unspoiled beauty of Twelve Mile Island. Expertly designed by the esteemed local architect, Dan Fultz, the estate offers a harmonious blend of grand formal spaces for entertaining and cozy family areas, ideal for daily enjoyment. Across its sprawling layout, the residence features six luxurious bedrooms, including a first-floor primary suite and a fully-equipped carriage house for guests, ensuring ample space for family and visitors alike. The home's architectural centerpiece is a stunningly crafted center staircase, a visual triumph that gracefully connects each level. Further enhancing this extraordinary property are a 5-car garage, a serene pool with a limestone terrace and elegant pool house, a meticulously designed wine cellar, and a rooftop lookout that provides a panoramic vista of the Ohio River valley. Not a detail was missed in the estate's features and layout while using the finest materials and finishes throughout the expansive 15,000 square foot floor plan. A property of this caliber is a rare offering in our market, presenting a truly exceptional opportunity. It boasts an unparalleled combination of breathtaking views and location, all while being in immaculate, like-new condition and presentation.
Single-familyProperty Type
2018Year Built
3.66 acresLot Size
$475Est. Price/Sq.Ft.
5 car garageParking
Listed by Jon Mand• Lenihan Sotheby's Int'l Realty
Bought with Bluegrass Portfolio Group Lawson• Keller Williams Collective
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Permits
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
1.65 Acres
Year renovated
—
Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Oldham County
APN
02-04-00-13
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 29, 2026.
Nov 3, 2018 • Final
Electrical
Work on a pool house.
Electrical
Pool and hot tub
Sep 25, 2018 • Final
Electrical
Work on an inground pool.
Electrical
Pool and hot tub
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Parking
Parking Information
Garage Spaces: 5.0
Parking Features: Detached, Attached, Driveway
Interior
Bedroom Information
Bedrooms Total: 6
First Floor PBR: Yes
Primary Bedroom Level: First
# Upper Floor Bedrooms: 0.0
# 2nd Floor Bedrooms: 3.0
# 1st Floor Bedrooms: 1
# Basement Bedrooms: 1
Primary Bedroom: Yes
Bathroom Information
Bathrooms Full: 6
Bathrooms Half: 5
Primary Bathroom Level: First
Full Bathroom: Yes
Full Bathroom Level: Second
Half Bathroom: Yes
Half Bathroom Level: First
Primary Bathroom: Yes
Kitchen & Dining Information
Dining Room: Yes
Dining Room Level: First
Kitchen: Yes
Kitchen Level: First
Interior Features
# of Rooms: 21
# of Closets: 13
# of Fireplaces: 4
Fireplaces Total: 4
Fireplaces: Basement: 1
Fireplaces: Level 1: 3
Fireplace: Yes
Living Areas
Family Room: Yes
Family Room Level: Third
Living Room: Yes
Living Room Level: First
Den & Office Information
Den: Yes
Den Level: First
Office: Yes
Office Level: First
Other Room Information
# of Rooms: 21
Rooms Total: 20
Basement Y/N: Yes
Basement: Walkout Finished
Bedroom: Yes
Bedroom Level: Second
Closets: Basement: 3
Dining Room: Yes
Dining Room Level: First
Fireplaces Total: 4
Full Bathroom: Yes
Full Bathroom Level: Second
Gym: Yes
Gym Level: Second
Half Bathroom: Yes
Half Bathroom Level: First
Kitchen: Yes
Kitchen Level: First
Laundry: Yes
Laundry Level: First
First Floor Laundry: Yes
Primary Bathroom: Yes
Primary Bathroom Level: First
Primary Bedroom: Yes
Primary Bedroom Level: First
Room 1 Information
Room 1 Level: First
Room 1 Type: Dining Room
Room 2 Information
Room 2 Level: First
Room 2 Type: Office
Room 3 Information
Room 3 Level: First
Room 3 Type: Living Room
Room 4 Information
Room 4 Level: First
Room 4 Type: Kitchen
Room 5 Information
Room 5 Level: First
Room 5 Type: Den
Room 6 Information
Room 6 Description: Two on 1st Floor
Room 6 Level: First
Room 6 Type: Half Bathroom
Room 7 Information
Room 7 Level: First
Room 7 Type: Primary Bedroom
Room 8 Information
Room 8 Level: First
Room 8 Type: Primary Bathroom
Room 9 Information
Room 9 Description: 2nd Laundry in Basement
Room 9 Level: First
Room 9 Type: Laundry
Room 10 Information
Room 10 Level: Second
Room 10 Type: Bedroom
Room 11 Information
Room 11 Level: Second
Room 11 Type: Full Bathroom
Room 12 Information
Room 12 Level: Second
Room 12 Type: Bedroom
Room 13 Information
Room 13 Level: Second
Room 13 Type: Full Bathroom
Room 14 Information
Room 14 Level: Second
Room 14 Type: Bedroom
Room 15 Information
Room 15 Level: Second
Room 15 Type: Full Bathroom
Room 16 Information
Room 16 Level: Second
Room 16 Type: Gym
Room 17 Information
Room 17 Level: Third
Room 17 Type: Family Room
Room 18 Information
Room 18 Level: Third
Room 18 Type: Half Bathroom
Room 19 Information
Room 19 Level: Basement
Room 19 Type: Family Room
Room 20 Information
Room 20 Level: Basement
Room 20 Type: Bedroom
Exterior
Exterior Features
Exterior Features: Sauna/Steam, Balcony, Hot Tub
Land Information
Fencing: Full
Fencing: Full: Yes
Waterfront Y/N: Yes
Lot Description
Lot Features: Covt/Restr, Cleared, Level
Lot Size Acres: 3.66
Lot Size Area: 3.66
Lot Size Units: Acres
Cleared: Yes
Covt Restr: Yes
Cul De Sac: Yes
Level: Yes
Property Information
Property Sub Type: Single Family Residence
Residential
Subdivision / Condo Amenities
Subdivision Name: RIVER GLEN
Building Information
Building Area Source: Other
Building Area Total: 10546.0
Stories: 3
Year Built: 2018
Roof: Metal, Shingle
Foundation Details: Poured Concrete
Construction Materials: Wood Frame, Stone Veneer
Above Grade Finished: 10,546
Below Grade Finished: 4,000
Below Grade Unfin: 2,972
Living Area: 14546.0
Financial
Tax Information
Tax Block: 02
Tax Lot: 04
Utilities
Utility Information
Utilities: Electricity Connected, Fuel:Natural
Heating
Heating Y/N: Yes
Heating: Forced Air, Natural Gas, Geothermal
Cooling
Cooling Y/N: Yes
Cooling: Central Air
Green Features
Spray in Foam Insulation: Yes
Location
HOA Information
Association Fee: 2050.0
Association Y/N: Yes
Neighborhood Information
Subdivision Name: RIVER GLEN
School Information
High School District: Oldham
School District: Oldham
Location Information
Directions: US 42 to Rose Island Road, left onto River Glen Lane, right onto River Ridge Cove
Public facts
Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: 1.65 acres
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: Oldham County
APN: 02-04-00-13
Home facts updated by county records on Jul 29, 2026
Other
Listing Date Information
Documents Change Timestamp: 2025-12-26T06:16:49Z
Around this home
Schools
Harmony Elementary School
Public K-5 • Assigned • 2.5mi
8/10
North Oldham Middle School
Public 6-8 • Assigned • 2.6mi
9/10
North Oldham High School
Public 9-12 • Assigned • 2.5mi
10/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
7/10 Flood Factor
Estimated 70-78% chance 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
5/10 Heat Factor
7 days above 105° expected this year, 21 days in 30 years
2/10 Wind Factor
4% 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
Prospect, KY • 40059
Average low and high temperatures (°F)
37
21
47
29
65
42
72
51
74
56
85
67
90
72
85
65
82
60
72
49
58
41
46
33
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.4 hours in
June and 3.6 hours in December, placing it below the
U.S. average for solar exposure.
9.4 hrs
3.6 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$6.56M – $7.95M
Reach more buyers when you sell with Redfin. Save up to $69,087 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.