Public Remarks: This one-of-a-kind property is ideal for entertaining with a dramatic 2-story foyer and large Formal living room and Great rooms. Open kitchen w/high-end appliances, multiple ovens and butler pantry, loads of cabinets, corian/granite counter tops. Luxury Master Suite with whirlpool, steam shower, separate sauna, his/hers walk-in closets, kitchenette, private deck with spiral staircase to first floor! 2nd Fl Master-no worries, the indoor elevator will allow you to live here for many years! The indoor solarium offers a 25' ceiling with skylights, custom leaded glass windows and indoor lap pool - all with breathtaking views of the Ohio river! The INGROUND pool is like new and features: custom stamped concrete pool deck, diving board, slide, poolhouse with kitchenette and full bathroom! New 50' deck and railing, freshly painted exterior! Riverside gazebo overlooks two boat slips, lift and a personal boat ramp!!! Custom creekstone everywhere! Slate roof and Copper gutters!
*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
Zoning
Permits
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
0.82 Acres
Year renovated
—
Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Oldham County
APN
02-01-00-44B,44D&45A
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 29, 2026.
CO-1
Conservation/Residential District
The Conservation/Residential District is intended to promote and protect significant natural features, wooded areas, water courses, existing and potential lake sites, other recreational and conservation resources, wildlife habitat, present and future water supplies, and to minimize erosion of soil and the siltation and pollution of streams and lakes.
Permitted uses
Include but are not limited to:
Agriculture
Community / recreation center
Religious facility
Housing-Single unit
Housing-Senior
Infrastructure
Public service
Educational/school
Recreation
Park & open space
Sep 19, 2012 • Final
Electrical
Electrical
Sep 12, 2012 • Final
Remodel / repair
Remodel
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: 2.0
Parking Features: Attached
Interior
Virtual Tour Information
Virtual Tour Information
Bedroom Information
Bedrooms Total: 6
First Floor PBR: Yes
Primary Bedroom Level: Second
# Upper Floor Bedrooms: 0.0
# 2nd Floor Bedrooms: 4.0
# 1st Floor Bedrooms: 2
# Basement Bedrooms: 0.0
Primary Bedroom: Yes
Bathroom Information
Bathrooms Full: 6
Bathrooms Half: 1
Primary Bathroom Level: Second
Full Bathroom: Yes
Full Bathroom Level: First
Primary Bathroom: Yes
Kitchen & Dining Information
Dining Area: Yes
Dining Area Level: First
Dining Room: Yes
Dining Room Level: First
Kitchen: Yes
Kitchen Level: First
Interior Features
# of Rooms: 19
# of Closets: 13
# of Fireplaces: 3
Fireplaces Total: 3
Fireplaces: Level 1: 2
Fireplaces: Level 2: 1
Fireplace: Yes
Living Areas
Family Room: Yes
Family Room Level: First
Florida Room: Yes
Florida Room Level: First
Great Room: Yes
Great Room Level: First
Living Room: Yes
Living Room Level: First
Other Room Information
# of Rooms: 19
Rooms Total: 21
Basement Y/N: Yes
Basement: Partially Finished, Walkout Unfinished
Bedroom: Yes
Bedroom Level: First
Closets: Basement: 1
Dining Area: Yes
Dining Area Level: First
Dining Room: Yes
Dining Room Level: First
Fireplaces Total: 3
Full Bathroom: Yes
Full Bathroom Level: First
Kitchen: Yes
Kitchen Level: First
Laundry: Yes
Laundry Level: First
Primary Bathroom: Yes
Primary Bathroom Level: Second
Primary Bedroom: Yes
Primary Bedroom Level: Second
Room 1 Information
Room 1 Level: First
Room 1 Type: Living Room
Room 2 Information
Room 2 Level: Second
Room 2 Type: Living Room
Room 3 Information
Room 3 Level: First
Room 3 Type: Family Room
Room 4 Information
Room 4 Level: Second
Room 4 Type: Primary Bedroom
Room 5 Information
Room 5 Level: First
Room 5 Type: Bedroom
Room 6 Information
Room 6 Level: Second
Room 6 Type: Bedroom
Room 7 Information
Room 7 Level: First
Room 7 Type: Bedroom
Room 8 Information
Room 8 Level: Second
Room 8 Type: Bedroom
Room 9 Information
Room 9 Level: Second
Room 9 Type: Bedroom
Room 10 Information
Room 10 Description: Eat in Kitchen
Room 10 Level: First
Room 10 Type: Kitchen
Room 11 Information
Room 11 Description: Eat in Kitchen
Room 11 Level: Second
Room 11 Type: Kitchen
Room 12 Information
Room 12 Level: First
Room 12 Type: Dining Area
Room 13 Information
Room 13 Level: First
Room 13 Type: Great Room
Room 14 Information
Room 14 Level: First
Room 14 Type: Sun Room
Room 15 Information
Room 15 Level: Second
Room 15 Type: Sun Room
Room 16 Information
Room 16 Description: Formal
Room 16 Level: First
Room 16 Type: Dining Room
Room 17 Information
Room 17 Level: Second
Room 17 Type: Separate Apartment
Room 18 Information
Room 18 Level: Second
Room 18 Type: Primary Bathroom
Room 19 Information
Room 19 Level: First
Room 19 Type: Full Bathroom
Room 20 Information
Room 20 Level: Second
Room 20 Type: Full Bathroom
Exterior
Exterior Features
Exterior Features: Patio, Out Buildings, Sauna/Steam, Pool - In Ground, Porch, Water Front, Deck, Balcony, Hot Tub
Land Information
Fencing: Privacy, Partial, Stone
Fencing: Partial: Yes
Fencing: Privacy: Yes
Fencing: Stone: Yes
Lot Description
Lot Features: Flood Insurance Req, AddLndAve
Lot Size Acres: 1
Lot Size Area: 1.0
Lot Size Units: Acres
Add Lnd Ave: Yes
Flood Insurance Req: Yes
Property Information
Property Sub Type: Single Family Residence
Residential
Subdivision / Condo Amenities
Subdivision Name: BELKNAP BEACH ESTATES
Building Information
Building Area Source: Appraiser
Building Area Total: 7759.0
Stories: 2
Roof: Other
Foundation Details: Crawl Space, Poured Concrete
Construction Materials: Wood Frame, Stone
Above Grade Finished: 7,759
Below Grade Finished: 1,250
Living Area: 9009.0
Financial
Tax Information
Tax Block: 02-0
Tax Lot: -00-
Utilities
Utility Information
Utilities: Electricity Connected, Fuel:Natural, Septic System, Public Water
Heating
Heating Y/N: Yes
Heating: Natural Gas, Geothermal
Cooling
Cooling Y/N: Yes
Cooling: Central Air
Location
Multi-Unit Information
Separate Apartment: Yes
Separate Apartment Level: Second
Neighborhood Information
Subdivision Name: BELKNAP BEACH ESTATES
School Information
High School District: Oldham
School District: Oldham
Location Information
Directions: HWY 42 TO ROSE ISLAND ROAD, LEFT ON SPRING DR, LEFT ON BELKNAP BEACH RD
Public facts
Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: 0.82 acres
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: Oldham County
APN: 02-01-00-44B,44D&45A
Home facts updated by county records on Jul 29, 2026
Around this home
Schools
Harmony Elementary School
Public K-5 • Assigned • 2.3mi
8/10
North Oldham Middle School
Public 6-8 • Assigned • 2.4mi
9/10
North Oldham High School
Public 9-12 • Assigned • 2.4mi
10/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
10/10 Flood Factor
Estimated 80%+ 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
4/10 Heat Factor
7 days above 105° expected this year, 20 days in 30 years
2/10 Wind Factor
3% 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
$1.68M – $2.04M
Reach more buyers when you sell with Redfin. Save up to $17,696 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.