Public Remarks: RIVER RAT’S PARADISE! This is a 2 story home located in Oldham County with a seasonal view of the Ohio River. NO flood insurance req'd. The house has 3 bedrooms, 2 full baths, a great room, partial walkout basement (unfinished), large kitchen, living room, 2 decks, and laundry room. The home is on a large lot with a lot of road frontage.The house was originally a ranch style, with a large 2 story addition added approximately 20 years ago. The first floor contains the kitchen, living room, great room, laundry room, pantry, and 2 bedrooms. The second floor has a suite with a large bedroom (or office) with ample closets, bathroom, and a walk-out deck. Above this is the “crows nest” – basically storage space, although it does have windows. The house is NOT in “move-in” con condition and is in need of significant renovation work, with the original portion of the house needing new finishes and kitchen remodeling. The house has a newer 200 amp electrical service. Water is currently supplied by a well (needs service), but city water is available at the street and can be connected. All improvements on the property are documented to be well above the flood plain. The home will be sold "as-is".
Single-familyProperty Type
0.75 acresLot Size
$143Est. Price/Sq.Ft.
1 spaceParking
Listed by Susan Stomberger• Your Choice Realty, LLC
*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
2.5
Lot width
—
Lot depth
—
Lot size
0.67 Acres
Year renovated
—
Sq. Ft.
1,738
Year built
1990
Style
Single Family Residential
County
Oldham County
APN
01-01B-02-16
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 16, 2026.
R-2
Residential District
The purpose of the R-2 Residential District is to allow, preserve and protect the character of low density, detached single-family areas and neighborhoods at densities up to 3.63 dwelling units per acre
Permitted uses
Include but are not limited to:
Agriculture
Community / recreation center
Religious facility
Housing-Single unit
Housing-Senior
Infrastructure
Public service
Educational/school
Park & open space
Jan 12, 2016 • Final
Addition
Addition
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
Parking Features: Driveway
Interior
Bedroom Information
Bedrooms Total: 3
First Floor PBR: Yes
Primary Bedroom Level: First
# Upper Floor Bedrooms: 0.0
# 2nd Floor Bedrooms: 1.0
# 1st Floor Bedrooms: 2
# Basement Bedrooms: 0.0
Primary Bedroom: Yes
Bathroom Information
Bathrooms Full: 2
Bathrooms Half: 0
Full Bathroom: Yes
Full Bathroom Level: First
Kitchen & Dining Information
Kitchen: Yes
Kitchen Level: First
Interior Features
# of Rooms: 7
# of Closets: 5
# of Fireplaces: 1
Fireplaces Total: 1
Fireplaces: Level 1: 1
Fireplace: Yes
Living Areas
Great Room: Yes
Great Room Level: First
Living Room: Yes
Living Room Level: First
Other Room Information
# of Rooms: 7
Rooms Total: 10
Basement Y/N: Yes
Basement: Walkout Unfinished
Bedroom: Yes
Bedroom Level: First
Fireplaces Total: 1
Full Bathroom: Yes
Full Bathroom Level: First
Kitchen: Yes
Kitchen Level: First
Laundry: Yes
Laundry Level: First
Other: Yes
Other Level: Third
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: Great Room
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: Laundry
Room 5 Information
Room 5 Level: First
Room 5 Type: Primary Bedroom
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 Level: Second
Room 8 Type: Bedroom
Room 9 Information
Room 9 Level: Second
Room 9 Type: Full Bathroom
Room 10 Information
Room 10 Level: Third
Room 10 Type: Other
Exterior
Exterior Features
Exterior Features: Balcony
Land Information
Fencing: None
Fencing: None: Yes
Lot Description
Lot Features: Flood Insurance Req
Lot Size Acres: 0.75
Lot Size Area: 0.75
Lot Size Units: Acres
Corner: Yes
Flood Insurance Req: Yes
Property Information
Property Sub Type: Single Family Residence
Residential
Architectural Style: Other
Subdivision / Condo Amenities
Subdivision Name: OLDHAM ACRES
Building Information
Building Area Total: 1738.0
Stories: 3
Year Built: 0
Roof: Shingle
Foundation Details: Poured Concrete
Construction Materials: Vinyl Siding
Above Grade Finished: 1,738
Below Grade Unfin: 563
Living Area: 1738.0
Financial
Tax Information
Tax Block: 01-0
Tax Lot: B-02
Utilities
Utility Information
Utilities: Electricity Connected, Fuel:Natural
Heating
Heating Y/N: Yes
Heating: Forced Air, Natural Gas
Cooling
Cooling Y/N: Yes
Cooling: Wall/Window Unit(s)
Location
Neighborhood Information
Subdivision Name: OLDHAM ACRES
School Information
High School District: Oldham
School District: Oldham
Location Information
Directions: Hwy 42 to Rose Island Rd. to street.
Public facts
Beds: —
Baths: —
Sq. Ft.: 1,738
Stories: 2.5
Lot Size: 0.67 acres
Style: Single Family Residential
Year Built: 1990
Year Renovated: —
County: Oldham County
APN: 01-01B-02-16
Home facts updated by county records on Oct 16, 2026
Around this home
Schools
Harmony Elementary School
Public K-5 • Assigned • 1.9mi
8/10
North Oldham Middle School
Public 6-8 • Assigned • 1.9mi
9/10
North Oldham High School
Public 9-12 • Assigned • 1.9mi
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
2% 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
89
72
85
65
83
58
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
$237,000 – $287,000
Reach more buyers when you sell with Redfin. Save up to $2,492 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.