Public Remarks: If watching gorgeous sunsets overlooking the water is in your future plan, this riverfront paradise awaits you! The 2.5 story home sits directly across from a nature preserve with unobstructed views of the Ohio River. The home offers an open floor plan with elevator access from the first floor garage level to the main living area on the second floor. The first floor offers additional living space including a tiled family room/bar, bonus room and full bathroom with direct access to the lower level patio and private boat dock with 2 slips. There is an abundance of hardwood flooring throughout the second floor including the 2-story great room with a cozy fireplace, dining area, kitchen, half bath, primary suite, guest bedroom with en suite bath and laundry room. Enjoy the outdoors on the elevated deck with a cabana and plumbed in gas grill. Upstairs you will find a loft office and additional bedroom. Other features include a generator, 2 HVAC systems, spray foam insulation, gutter guards and a gas fire feature on the lower level patio. The attached 2 car garage offers a convenient storage loft. Also included is an 8,000 pound boat lift (not installed). Harmony Village is a wonderful community that has a neighborhood boat ramp and trailer storage area. Award-winning Oldham County Schools. Call for a private showing!
Single-familyProperty Type
1990Year Built
9,147 sq ftLot Size
$193Est. Price/Sq.Ft.
2 car garageParking
Listed by Lynette Masterson• Lenihan Sotheby's Int'l Realty
*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
9,322 Sq. Ft.
Year renovated
—
Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Oldham County
APN
01-01A-00-67
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 8, 2018 • Final
Electrical
Work on flood damage.
Electrical
Mar 8, 2018 • Final
Electrical
Remodel and rewire the building.
Electrical
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
Interior
Bedroom Information
Bedrooms Total: 3
First Floor PBR: No
Primary Bedroom Level: Second
# Upper Floor Bedrooms: 1.0
# 2nd Floor Bedrooms: 2.0
# 1st Floor Bedrooms: 0.0
# Basement Bedrooms: 0.0
Primary Bedroom: Yes
Bathroom Information
Bathrooms Full: 3
Bathrooms Half: 1
Primary Bathroom Level: Second
Full Bathroom: Yes
Full Bathroom Level: First
Half Bathroom: Yes
Half Bathroom Level: Second
Primary Bathroom: Yes
Kitchen & Dining Information
Dining Area: Yes
Dining Area Level: Second
Kitchen: Yes
Kitchen Level: Second
Interior Features
# of Rooms: 9
# of Closets: 6
# of Fireplaces: 1
Fireplaces Total: 1
Fireplaces: Level 2: 1
Fireplace: Yes
Living Areas
Family Room: Yes
Family Room Level: First
Great Room: Yes
Great Room Level: Second
Other Room Information
# of Rooms: 9
Rooms Total: 12
Basement: None
Bedroom: Yes
Bedroom Level: Second
Dining Area: Yes
Dining Area Level: Second
Fireplaces Total: 1
Full Bathroom: Yes
Full Bathroom Level: First
Half Bathroom: Yes
Half Bathroom Level: Second
Kitchen: Yes
Kitchen Level: Second
First Floor Laundry: No
Other: Yes
Other 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: Family Room
Room 2 Information
Room 2 Description: Office or Flex Room
Room 2 Level: First
Room 2 Type: Other
Room 3 Information
Room 3 Level: First
Room 3 Type: Full Bathroom
Room 4 Information
Room 4 Level: Second
Room 4 Type: Great Room
Room 5 Information
Room 5 Level: Second
Room 5 Type: Dining Area
Room 6 Information
Room 6 Level: Second
Room 6 Type: Kitchen
Room 7 Information
Room 7 Level: Second
Room 7 Type: Half Bathroom
Room 8 Information
Room 8 Level: Second
Room 8 Type: Primary Bedroom
Room 9 Information
Room 9 Level: Second
Room 9 Type: Primary Bathroom
Room 10 Information
Room 10 Level: Second
Room 10 Type: Bedroom
Room 11 Information
Room 11 Level: Third
Room 11 Type: Other
Room 12 Information
Room 12 Level: Third
Room 12 Type: Bedroom
Exterior
Exterior Features
Exterior Features: Boat Slip
Land Information
Fencing: None
Fencing: None: Yes
Lot Description
Lot Features: Flood Insurance Req
Lot Size Acres: 0.21
Lot Size Area: 0.21
Lot Size Units: Acres
Flood Insurance Req: Yes
Property Information
Property Sub Type: Single Family Residence
Residential
Subdivision / Condo Amenities
Subdivision Name: HARMONY VILLAGE
Building Information
Building Area Source: Other
Building Area Total: 3883.0
Stories: 3
Year Built: 1990
Roof: Shingle
Foundation Details: Concrete Blk, Poured Concrete
Construction Materials: Wood Frame, Stone Veneer
Above Grade Finished: 3,883
Living Area: 3883.0
Financial
Tax Information
Tax Block: 0
Tax Lot: 67
Utilities
Utility Information
# of HVAC Units: 2
# of HVAC Units: 2
Utilities: Electricity Connected, Fuel:Natural
Heating
Heating Y/N: Yes
Heating: Forced Air, Natural Gas, Heat Pump
Cooling
Cooling Y/N: Yes
Cooling: Central Air
Green Features
Spray in Foam Insulation: Yes
Tankless Water Heater: Yes
Location
HOA Information
Association Fee: 50.0
Association Y/N: Yes
Neighborhood Information
Subdivision Name: HARMONY VILLAGE
School Information
High School District: Oldham
School District: Oldham
Location Information
Directions: US 42 to Rose Island Road. Left on Harmony Village. Right on Riverside Drive. Home is on the left.
Public facts
Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: 9,322 square feet
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: Oldham County
APN: 01-01A-00-67
Home facts updated by county records on Jul 29, 2026
Around this home
Schools
Harmony Elementary School
Public K-5 • Assigned • 2.2mi
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
8/10 Flood Factor
Estimated 74-82% 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, 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
86
66
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
$712,000 – $861,000
Reach more buyers when you sell with Redfin. Save up to $7,485 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.