Public Remarks: A vacation spot for your family that you can enjoy every day and be minutes from work with exceptional Ohio River frontage of over 267'. You have found it! Exquisite views and vistas from every light-filled window, porch, balcony, gallery, deck and patio! This grand cedar shingled cape cod is accented with copper, 40 year shingle roof and Tennessee Crab Orchard Stone. Exceptional entry leads to dramatic and elegant great room with Kentucky whiskey distillery heart of pine floors, 14'3'' ceiling height and an enormous fireplace with beautiful curved chimney. French doors lead to river gallery, deck, 16'x16' screened porch, grilling area and stairs to stone patio and glorious river and 3 decks. Gourmet kitchen and sitting area enjoy light filled windows and fabulous river views. Custom cabinetry, granite counter tops, stainless appliances, farm sink all enhance the beauty of this kitchen design which is serviced by a convenient dumb waiter for groceries by the garage. The main level has a wonderful library or office and the main level master suite includes private balcony, gorgeous bath with bubble tub, steam shower, double sinks, exceptional closets and laundry. Staircase leads to second floor with large sitting area, two gorgeous bedrooms with river views, outstanding bath and additional laundry. Staircase leading to walk out lower level and patio brings you to a fabulous family room and game room, pine paneled bedroom and full bath. Top quality construction by premier builder Bill Wilkinson with outstanding details. Total finished square footage 5465 - A breezeway can take you from the driveway to the river that is also convenient to grab your river needs out of the many storage areas along the way. The kitchen is equipped with gourmet appliances including a Viking 6 burner gas stove plus griddle and a Sub-Zero refrigerator also a Miele dishwasher. The boat dock is equipped with a 10,000 lb. Lift and 2 Jet Ski lifts. This home is a water lover's dream.
Single-familyProperty Type
2007Year Built
0.68 acresLot Size
$344Est. Price/Sq.Ft.
2 car garageParking
Listed by Karen Kraft• Lenihan Sotheby's Int'l Realty
Bought with The Jimmy Welch Team Welch• Keller Williams Collective
Stunning new construction with exceptional Ohio River frontage of over 267'. Exquisite views and vistas from every light-filled window, porch, balcony, gallery, deck and patio! This grand cedar shingled cape cod is accented with copper, 40 year shingle roof and Tennessee Crab Orchard Stone. Exceptional entry leads to dramatic and elegant great room with Kentucky whiskey distillery heart of pine floors, 14'3'' ceiling height and an enormous fireplace with beautiful curved chimney. French doors lead to river gallery, deck, 16'x16' screened porch, grilling area and stairs to stone patio and glorious river and 3 decks. Gourmet kitchen and sitting area enjoy light filled windows and fabulous river views. Custom cabinetry, granite counter tops, stainless appliances, farm sink all enhance the beauty of this kitchen design which is serviced by a convenient dumb waiter for groceries by the garage. The main level has a wonderful library or office and the main level master suite includes private balcony, gorgeous bath with bubble tub, steam shower, double sinks, exceptional closets and laundry. Staircase leads to second floor with large sitting area, two gorgeous bedrooms with river views, outstanding bath and additional laundry. Staircase leading to walk out lower level and patio brings you to a fabulous family room and game room, pine paneled bedroom and full bath. Top quality construction by premier builder Bill Wilkinson with outstanding details. Total finished square footage 5465 - 1500 walk out lower level included.
Metro Search MLS #1267358
Oct 1, 2010
Listing Removed
—
Apr 1, 2010
Listed
$1,435,000
$263/sq ft
Metro Search MLS #1246732
Dec 31, 2009
Listing Removed
—
Aug 13, 2009
Listed
$1,585,000
$290/sq ft
Metro Search MLS #1231812
Aug 13, 2009
Listing Removed
—
Mar 12, 2009
Listed
$1,695,000
$310/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$16,968
$275,000 + $1,100,000
$1,375,000
2024
$16,954 (+3.6%)
$275,000 + $1,100,000
$1,375,000
2023
$16,357 (+0.5%)
$275,000 + $1,100,000
$1,375,000
2022
$16,283 (+0.7%)
$255,000 + $1,065,000
$1,320,000
2021
$16,177 (−0.2%)
$255,000 + $1,065,000
$1,320,000
2020
$16,217 (+1.0%)
$255,000 + $1,065,000
$1,320,000
2019
$16,064
$255,000 + $1,065,000
$1,320,000
2018
$16,071 (+0.7%)
$255,000 + $1,065,000
$1,320,000
2017
$15,958 (+19.7%)
$255,000 + $1,065,000
$1,320,000
2016
$13,332 (+0.3%)
$255,000 + $1,065,000
$1,320,000
2015
$13,287 (+5.4%)
2013
$12,604
$255,000 + $865,000
$1,120,000
Tax history for 2400 Belknap Beach Rd
Year
Property tax
Land + Additions
Assessment*
2025
$16,968
$275,000 + $1,100,000
$1,375,000
2024
$16,954 (+3.6%)
$275,000 + $1,100,000
$1,375,000
2023
$16,357 (+0.5%)
$275,000 + $1,100,000
$1,375,000
2022
$16,283 (+0.7%)
$255,000 + $1,065,000
$1,320,000
2021
$16,177 (−0.2%)
$255,000 + $1,065,000
$1,320,000
2020
$16,217 (+1.0%)
$255,000 + $1,065,000
$1,320,000
2019
$16,064
$255,000 + $1,065,000
$1,320,000
2018
$16,071 (+0.7%)
$255,000 + $1,065,000
$1,320,000
2017
$15,958 (+19.7%)
$255,000 + $1,065,000
$1,320,000
2016
$13,332 (+0.3%)
$255,000 + $1,065,000
$1,320,000
2015
$13,287 (+5.4%)
2013
$12,604
$255,000 + $865,000
$1,120,000
*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.96 Acres
Year renovated
—
Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Oldham County
APN
02-01-00-1A
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
Jun 23, 2006 • Final
Addition
Addition
Jun 23, 2006 • 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, Entry Front, Driveway
Interior
Virtual Tour Information
Virtual Tour Information
Bedroom Information
Bedrooms Total: 4
First Floor PBR: Yes
Primary Bedroom Level: First
# Upper Floor Bedrooms: 0.0
# 2nd Floor Bedrooms: 2.0
# 1st Floor Bedrooms: 1
# Basement Bedrooms: 1
Primary Bedroom: Yes
Bathroom Information
Bathrooms Full: 3
Bathrooms Half: 1
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 Area: Yes
Dining Area Level: First
Kitchen: Yes
Kitchen Level: First
Interior Features
# of Rooms: 9
# of Closets: 13
# of Fireplaces: 2
Fireplaces Total: 2
Fireplaces: Basement: 1
Fireplaces: Level 1: 1
Fireplace: Yes
Living Areas
Family Room: Yes
Family Room Level: Basement
Great Room: Yes
Great Room Level: First
Den & Office Information
Study: Yes
Study Level: First
Other Room Information
# of Rooms: 9
Rooms Total: 16
Basement Y/N: Yes
Basement: Walkout Part Fin
Bedroom: Yes
Bedroom Level: Second
Closets: Basement: 3
Dining Area: Yes
Dining Area Level: First
Fireplaces Total: 2
Full Bathroom: Yes
Full Bathroom Level: Second
Half Bathroom: Yes
Half Bathroom Level: First
Kitchen: Yes
Kitchen Level: First
Laundry: Yes
Laundry Level: First
Other: Yes
Other Level: Second
Primary Bathroom: Yes
Primary Bathroom Level: First
Primary Bedroom: Yes
Primary Bedroom Level: First
Room 1 Information
Room 1 Level: First
Room 1 Type: Great Room
Room 2 Information
Room 2 Description: Eat in Kitchen
Room 2 Level: First
Room 2 Type: Kitchen
Room 3 Information
Room 3 Level: First
Room 3 Type: Dining Area
Room 4 Information
Room 4 Level: First
Room 4 Type: Study
Room 5 Information
Room 5 Level: First
Room 5 Type: Primary Bedroom
Room 6 Information
Room 6 Level: First
Room 6 Type: Primary Bathroom
Room 7 Information
Room 7 Level: First
Room 7 Type: Half Bathroom
Room 8 Information
Room 8 Level: First
Room 8 Type: Laundry
Room 9 Information
Room 9 Level: Second
Room 9 Type: Bedroom
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: Laundry
Room 13 Information
Room 13 Level: Second
Room 13 Type: Other
Room 14 Information
Room 14 Level: Basement
Room 14 Type: Family Room
Room 15 Information
Room 15 Level: Basement
Room 15 Type: Bedroom
Room 16 Information
Room 16 Level: Basement
Room 16 Type: Full Bathroom
Exterior
Exterior Features
Exterior Features: See Remarks, Balcony
Land Information
Fencing: Wood
Fencing: Wood: Yes
Lot Description
Lot Features: Flood Insurance Req, DeadEnd
Lot Size Acres: 0.68
Lot Size Area: 29621.0
Lot Size Units: Square Feet
Dead End: Yes
Flood Insurance Req: Yes
Irregular: Yes
Property Information
Property Sub Type: Single Family Residence
Residential
Architectural Style: Traditional
Subdivision / Condo Amenities
Subdivision Name: BELKNAP BEACH ESTATES
Building Information
Building Area Total: 3965.0
Stories: 3
Year Built: 2007
Roof: Shingle
Foundation Details: Concrete Blk, Poured Concrete
Construction Materials: Wood Frame
Above Grade Finished: 3,965
Below Grade Unfin: 340
Living Area: 5465.0
Financial
Tax Information
Tax Block: 02-0
Tax Lot: 00
Utilities
Utility Information
Utilities: Electricity Connected, Fuel:Natural
Heating
Heating Y/N: Yes
Heating: Natural Gas, Heat Pump
Cooling
Cooling Y/N: Yes
Cooling: Central Air, Heat Pump
Location
Neighborhood Information
Subdivision Name: BELKNAP BEACH ESTATES
Location Information
Directions: Rose Island Road to Street. Turn Right on Belknap Beach. Last house on the River.
Public facts
Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: 0.96 acres
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: Oldham County
APN: 02-01-00-1A
Home facts updated by county records on Jul 29, 2026
Around this home
Schools
Harmony Elementary School
Public K-5 • Assigned • 2.1mi
8/10
North Oldham Middle School
Public 6-8 • Assigned • 2.1mi
9/10
North Oldham High School
Public 9-12 • Assigned • 2.1mi
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.79M – $2.16M
Reach more buyers when you sell with Redfin. Save up to $18,781 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.