Public Remarks: Attention Rehabbers, Flippers or Owner/Contractor. Riverfront 2br 2bath being sold in as-is condition. This property needs work and is not for everyone but has plenty potential. Built above the flood plain and has its own boat ramp and two docks that need work. Great possibilities and worth a look. Features include: Open Floorplan, Spiral staircase, Eat-In Kitchen, 2 Car Carport, Post and Pier Foundation, Fireplace in Greatroom, Loft family room
Single-familyProperty Type
1992Year Built
0.26 acresLot Size
$171Est. Price/Sq.Ft.
2 spacesParking
Listed by Dee DeWitt Relocation Specialist DeWitt• Semonin Realtors
Bought with Brad Long• Keller Williams Collective
Bought with Natalya Whitaker• 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
Zoning
Permits
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
0.27 Acres
Year renovated
—
Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Oldham County
APN
01-01B-01-3
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
Oct 14, 2025 • Final
Electrical
Electrical
Feb 21, 2019 • Final
Electrical
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
Interior
Virtual Tour Information
Virtual Tour Information
Bedroom Information
Bedrooms Total: 2
First Floor PBR: No
Primary Bedroom Level: First
# Upper Floor Bedrooms: 0.0
# 2nd Floor Bedrooms: 0.0
# 1st Floor Bedrooms: 2
# Basement Bedrooms: 0.0
Primary Bedroom: Yes
Bathroom Information
Bathrooms Full: 2
Bathrooms Half: 0
Primary Bathroom Level: First
Full Bathroom: Yes
Full 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: 5
# of Closets: 4
# of Fireplaces: 1
Fireplaces Total: 1
Fireplaces: Level 1: 1
Fireplace: Yes
Living Areas
Family Room: Yes
Family Room Level: Second
Living Room: Yes
Living Room Level: First
Other Room Information
# of Rooms: 5
Rooms Total: 8
Basement Y/N: Yes
Basement: Walkout Unfinished
Bedroom: Yes
Bedroom Level: First
Dining Area: Yes
Dining Area Level: First
Fireplaces Total: 1
Full Bathroom: Yes
Full Bathroom Level: First
Kitchen: Yes
Kitchen Level: First
Primary Bathroom: Yes
Primary Bathroom Level: First
Primary Bedroom: Yes
Primary Bedroom Level: First
Room 1 Information
Room 1 Level: First
Room 1 Type: Living Room
Room 2 Information
Room 2 Level: First
Room 2 Type: Dining Area
Room 3 Information
Room 3 Description: Eat in Kitchen
Room 3 Level: First
Room 3 Type: Kitchen
Room 4 Information
Room 4 Level: First
Room 4 Type: Primary Bedroom
Room 5 Information
Room 5 Level: First
Room 5 Type: Primary Bathroom
Room 6 Information
Room 6 Level: First
Room 6 Type: Bedroom
Room 7 Information
Room 7 Level: First
Room 7 Type: Full Bathroom
Room 8 Information
Room 8 Description: Loft
Room 8 Level: Second
Room 8 Type: Family Room
Exterior
Exterior Features
Exterior Features: See Remarks
Land Information
Fencing: None
Fencing: None: Yes
Waterfront Y/N: Yes
Lot Description
Lot Features: Flood Insurance Req, See Remarks, DeadEnd
Lot Size Acres: 0.26
Lot Size Area: 0.26
Lot Size Units: Acres
Dead End: Yes
Flood Insurance Req: Yes
See Remarks: Yes
Property Information
Property Sub Type: Single Family Residence
Residential
Subdivision / Condo Amenities
Subdivision Name: OLDHAM ACRES
Building Information
Building Area Total: 1662.0
Stories: 1
Year Built: 1992
Roof: Shingle
Construction Materials: Vinyl Siding, Wood Frame
Above Grade Finished: 1,662
Above Grade Unfin: 662
Living Area: 1662.0
Financial
Tax Information
Tax Block: Sec 1
Tax Lot: 3
Utilities
Utility Information
Utilities: Electricity Connected, Fuel:Natural
Heating
Heating Y/N: Yes
Heating: Forced Air, Natural Gas
Cooling
Cooling Y/N: Yes
Cooling: Central Air
Location
HOA Information
Association Fee: 0.0
Neighborhood Information
Subdivision Name: OLDHAM ACRES
Location Information
Directions: 42 to Rose Island Rd to Oldham Acres to Riverside Drive
Public facts
Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: 0.27 acres
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: Oldham County
APN: 01-01B-01-3
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.0mi
9/10
North Oldham High School
Public 9-12 • Assigned • 2.0mi
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
$271,000 – $328,000
Reach more buyers when you sell with Redfin. Save up to $2,850 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.