Public Remarks: Nestled in the luxury waterfront garden-home community of Rivers Landing, this charming custom-built 1.5 story is the opportunity to own a like-new home without waiting on the construction, allowing owners to immediately begin enjoying a maintenance free lifestyle in a scenic riverside setting. Situated within the award-winning North Oldham county school district, the appeal of this stunning home only continues with groundskeeping, mulching, mowing, snow removal and an irrigation system included in the association fee, leaving homeowners more time to spend where it matters. From the spacious covered front porch with sitting area, guests first arrive into the welcoming foyer of the home before opening into the bright great room featuring gas fireplace, elegant built-in bookshelves, and oversized windows overlooking the treed backyard. From the great room, the home opens into the gourmet eat-in kitchen with granite countertops, stainless steel appliances, stylish cabinetry, expansive breakfast bar, convenient desk built-in, and dining area with access to the home's covered back porch, grilling patio, and rolling lawn. The primary suite of the home offers a spacious primary bedroom with tray ceiling, walk-in closet, and private patio access, as well as primary bath with his-and-her vanities and customized shower. The first floor continues with a spacious flex room, perfect for a convenient home office or guest bedroom. The first floor is complete with a full bath, laundry room (also accessible from the primary suite), and attached two-car garage with drop zone. Featuring upgraded hardwood flooring, bright windows, and recessed lighting, the second floor offers two gracious bedrooms and shared full bath. The home's backyard features a spacious covered patio with outdoor dining area, surrounded by mature trees for added privacy. Homeowners will enjoy shared dock access to the stunning community lake, as well as private gate access to the neighborhood for ultimate peace of mind and security. With a maintenance free lifestyle in an incomparable location, this home is not to be missed!
Single-familyProperty Type
2015Year Built
7,405 sq ftLot Size
$195Est. Price/Sq.Ft.
2 car garageParking
Listed by Claire Alagia• 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
7,579 Sq. Ft.
Year renovated
—
Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Oldham County
APN
01-06A-72-1935
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 29, 2026.
R-4
Residential District
The purpose of the R-4 Residential District is to allow higher density residential uses and low intensity nonresidential uses which are served by adequate infrastructure, while maintaining the unique character of neighborhoods at densities up to 16 units per acre. This district is used to encourage a variety of residential opportunities.
Permitted uses
Include but are not limited to:
Community / recreation center
Religious facility
Housing-Single unit
Housing-Multiple units
Housing-Senior
Infrastructure
Office
Public service
Educational/school
Park & open space
Dec 3, 2025 • Final
Electrical
Install a new circuit for a vehicle charging station.
Electrical
Ev charger
Nov 8, 2025 • Final
Electrical
Install a temporary electrical pole.
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 Side, Driveway
Interior
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: 2
# Basement Bedrooms: 0.0
Primary Bedroom: Yes
Bathroom Information
Bathrooms Full: 3
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: 8
# of Fireplaces: 1
Fireplaces Total: 1
Fireplaces: Level 1: 1
Fireplace: Yes
Living Areas
Great Room: Yes
Great Room Level: First
Other Room Information
# of Rooms: 8
Rooms Total: 12
Basement: None
Bedroom: Yes
Bedroom Level: First
Dining Area: Yes
Dining Area Level: First
Fireplaces Total: 1
Foyer: Yes
Foyer Level: First
Full Bathroom: Yes
Full Bathroom Level: First
Kitchen: Yes
Kitchen Level: First
Laundry: Yes
Laundry Level: First
First Floor Laundry: Yes
Primary Bathroom: Yes
Primary Bathroom Level: First
Primary Bedroom: Yes
Primary Bedroom Level: First
Room 1 Information
Room 1 Level: First
Room 1 Type: Foyer
Room 2 Information
Room 2 Level: First
Room 2 Type: Great Room
Room 3 Information
Room 3 Description: Eat In
Room 3 Level: First
Room 3 Type: Kitchen
Room 4 Information
Room 4 Level: First
Room 4 Type: Dining Area
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: Laundry
Room 8 Information
Room 8 Level: First
Room 8 Type: Bedroom
Room 9 Information
Room 9 Level: First
Room 9 Type: Full Bathroom
Room 10 Information
Room 10 Level: Second
Room 10 Type: Bedroom
Room 11 Information
Room 11 Level: Second
Room 11 Type: Bedroom
Room 12 Information
Room 12 Level: Second
Room 12 Type: Full Bathroom
Exterior
Exterior Features
Exterior Features: See Remarks
Land Information
Fencing: Full
Fencing: Full: Yes
Lot Description
Lot Features: Covt/Restr, Sidewalk, Cleared, Level, Zero Lot Line
Lot Size Acres: 0.17
Lot Size Area: 0.17
Lot Size Units: Acres
Cleared: Yes
Covt Restr: Yes
Level: Yes
Sidewalk: Yes
Zero Lot Line: Yes
Property Information
Property Sub Type: Single Family Residence
Residential
Architectural Style: Traditional
Subdivision / Condo Amenities
# of Garage Spaces: 2
Location of Parking: Garage
Year Building Built: 2015
Year Unit Finished: 2015
Subdivision Name: RIVERS LANDING
Building Information
Building Area Source: Other
Building Area Total: 2609.0
Stories: 2
Year Built: 2015
Roof: Shingle
Foundation Details: Slab
Construction Materials: Wood Frame
Above Grade Finished: 2,609
Living Area: 2609.0
Financial
Tax Information
Tax Block: 0
Tax Lot: 06A
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
Multi-Unit Information
# of Garage Spaces: 2
Dock: Yes
Laundry Features: In Unit
Laundry Located in Unit: Yes
HOA Information
Association Fee: 3000.0
Association Y/N: Yes
Marina, Other
Monthly Maintenance: No
Neighborhood Information
Subdivision Name: RIVERS LANDING
School Information
High School District: Oldham
School District: Oldham
Location Information
Directions: US 42 to Hwy 1793. Turn right onto Rose Island Road. Subdivision is the first on the left.
Public facts
Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: 7,579 square feet
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: Oldham County
APN: 01-06A-72-1935
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.0mi
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
5/10 Heat Factor
7 days above 105° expected this year, 22 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
$484,000 – $586,000
Reach more buyers when you sell with Redfin. Save up to $5,092 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.