$675,000
Prospect, KY 40059
MLS# 1712685
3 beds | 3 baths | 3564 sqft

1 / 61
Property Description
A Front Row to Remarkable River Views - just in time for Summer! This Fully Remodeled, Waterfront Retreat offers 95' of river frontage that includes a Newly Built Private Dock and promises of priceless sunsets. Situated on a .64 acre double-lot at the end of a quiet dead-end drive, this estate delivers exceptional privacy, uninterrupted scenery and a life on the river that feels elevated and effortless. Not to mention, you're also in the highly covered Oldham County School District! Inside, an open floor plan delivers uninterrupted sight-lines through the panoramic windows overlooking the Ohio. Vaulted Ceilings in the Great Room create volume, while the rich Hardwood Floors and Stone Fireplace bring warmth and comfort. Most of your time will likely be spent in the Sunroom, where morning
Details
Documents
General Property Description
Total # of Rooms: 9
# Upper Floor Bedrooms: 0
# 2nd Floor Bedrooms: 3
Acres: 0.64
# 1st Floor Bedrooms: 0
# Basement Bedrooms: 0
Garage Y/N: Yes
Garage Spaces: 2
Basement Y/N: No
First Floor Laundry: No
First Floor PBR: No
Laundry Level: 2nd
Total Closets: 6
Total Fireplaces: 1
SqFt -Total Finished: 3564
Above Grade Finished: 3564
Below Grade Finished: 0
Nonconform SqFt Fin: 0
Above Grade Unfin: 0
Below Grade Unfin: 0
Nonconform SqFt UF: 0
Sold As-Is: No
Age: 22
Sqft - Total Unfin: 0
SqFt - Source: Other
Stories: 2
Lot SF Source: Other
M Struct Flood Plain: Yes
Const Stat: Construction Complete
Assumable: No
Total # Bedrooms: 3
Baths - Full: 3
Total Bathrooms: 3
Year Built: 2004
Contract Info
Office Exclusive?: No
HOA Y/N: No
HOA Annual $: 0
HOA Fee: No
Status: Active
Listing Date: 2026-03-27
Original List Price: 675000
Listing Price: 675000
Property Sub Type: Single Family Residence
Location, Tax & Legal Info
Parcel ID: 01-01B-01-10,11,54-56
Deed Bk: 1417
Pg #: 284
Block: 01-01B-01
Lot: 10,11,54,55,56
Sub-Lot: 0
School District: Oldham
Directions: US Hwy 42 to Rose Island Road, left on Oldham Acres Road, left on Riverside Drive, Home on the Right
Disclosure: Yes
REO/Bank Owned/HUD: No
Architectural Style
Open Plan: 1
Raised Ranch: 1
Lot Description
DeadEnd: 1
Flood Insurance Req: 1
Level: 1
Utilities
Electricity Connected: 1
Fuel:Natural: 1
Water Source
Public: 1
Sewer
Septic Tank: 1
Closets
Level 1: 1
Level 2: 5
Fireplaces
Level 2: 1
Construction
Wood Frame: 1
Other: 1
Cement Siding: 1
Roof
Shingle: 1
Fencing
Partial: 1
Basement
None: 1
Foundation
Concrete Blk: 1
Slab: 1
Heating
# of HVAC Units: 2
Forced Air: 1
Natural Gas: 1
Patio and Porch Features
Deck: 1
Patio: 1
Cooling
Central Air: 1
# of HVAC Units: 1
Garage/Parking
Attached: 1
Off Street: 1
Entry Rear: 1
Driveway: 1
Exterior
Balcony: 1
Boat Slip: 1
Waterfront: 1
None
Current Price: $675,000
Location Tax Legal Info
Street #: 1726
Street: Riverside
St Suffix: Dr
County: Oldham
State/Province: KY
Zip Code: 40059
Area: 20-Oldham County N171
Subdivision/Condo: OLDHAM ACRES
Geo Lat: 38.396936
Geo Lon: -85.622268
Property Features
Architectural Style: Open Plan; Raised Ranch
Construction: Wood Frame; Other; Cement Siding
Roof: Shingle
Fencing: Partial
Patio and Porch Features: Deck; Patio
Basement: None
Foundation: Concrete Blk; Slab
Heating: Forced Air; Natural Gas
Cooling: Central Air
Exterior: Balcony; Boat Slip; Waterfront
Utilities: Electricity Connected; Fuel:Natural
Water Source: Public
Sewer: Septic Tank
Lot Description: DeadEnd; Flood Insurance Req; Level
Supplements
coffee feels different and evening sunsets stop you in your tracks. Replacement Windows not only maximize efficiency, but mainly frame the river as living art. A modern kitchen brings style and energy with Bar-top Seating at the peninsula, Stainless Steel Appliances, recessed lighting, and a generous dining area positioned perfectly to capture the river backdrop. Entertaining feels natural when every gathering space flows together and the view does the talking - plus a wet bar with a wine fridge never hurts either! The Primary Suite feels like a private retreat with trey ceilings, a cozy fireplace, and a private balcony overlooking the river. The completely remodeled ensuite offers spa-like luxury with dual vanities, a marble-style walk-in shower, soaking tub, and a walk-in closet - refined, serene, and unforgettable. Wake up every morning to experience unobstructed views that will never get old. A Split Floor Plan means two additional bedrooms share a full bath on the opposite side of the home, while a conveniently located laundry room in the middle keeps the main level practical and polished. The lower level expands the lifestyle with soaring ceilings, low-maintenance epoxy flooring, a dedicated full bathroom, and a versatile loft area ideal as a "4th Bedroom", recreation area, or office, along with cleverly hidden storage below. A deep, oversized 2-Car Garage with 20' ceilings easily accommodates vehicles, boats, jetskis and recreational gear, complete with a rear overhead door for seamless transitions from land to water. Outside, dual balconies and covered patio deck invites unforgettable gatherings while your own Private Dock anchors the experience - ready for boating, fishing, paddle boarding, or spontaneous sunset cruises. An outdoor shower makes rinsing off after a long day on the water effortless, bringing authentic river living into an everyday experience. Rose Island Yacht Club + Drift Bar are just a 5-minute boat ride, while Captain's Quarters and Cunninghams are a quick 10-minute cruise downstream. Additional land across the street is perfect for guest parking, boats, or additional storage. Ready to make unforgettable days on the water? Don't let this one stream right past you...
Room Information
| Room Name | Level | Length | Length | Remarks |
| Foyer | Second | |||
| Great Room | Second | |||
| Sun Room | Second | |||
| Kitchen | Second | w/Breakfast Area | ||
| Dining Area | Second | |||
| Primary Bedroom | Second | |||
| Primary Bathroom | Second | |||
| Bedroom | Second | |||
| Full Bathroom | Second | |||
| Bedroom | Second | 2.00 | 2.00 | |
| Laundry | Second | |||
| Media Room | First | 14.00 | 14.00 | |
| Full Bathroom | First | |||
| Other | First |
Listing Office: RE/MAX Premier Properties
Last Updated: March - 27 - 2026
The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of Metro Search, Inc. Real estate listings held by brokerage firms other than the site owner are marked with the Internet Data Exchange logo or the Internet Data Exchange thumbnail logo and detailed information about each listing includes the name of the listing broker.
Seller Disclosure 