1902 N Rose Island Rd, Prospect, KY 40059

Off market jan 2004 for $242K

$542,401

•

3,330

sq ft

1902 N Rose Island Rd, Prospect, KY 40059

About this home

Public Remarks: FINALLY AVAILABLE!! This architecturally designed, 3 bedroom, 2.5 bath home is situated on a 1.6 wooded acre lot off the Ohio River. Hardwoods throughout 1st floor w/ quarry tile in kitchen and family room. Spacious living room w/ 2-story ceiling is overlooked by master bedroom balcony on 2nd floor. Master bedroom offers private bath and large walk-in closet. Two wood burning fireplaces and Pella insulated windows and doors allow for a cozy, comfortable atmosphere. Lots of new updates including new roof in 2002. Large deck in front and back w/ outdoor hot tub. 2600 sq.ft. w/ additional 730 sq.ft. in partially finished walk-out basement offer plenty of room for the whole family. Located just minutes away from the brand new award winning North Oldham school system. Come see this unique home and find out what other desirable amenities it has to offer!!

Single-familyProperty Type

1.6 acresLot Size

$163Est. Price/Sq.Ft.

2 car garageParking

Listed by Ryan Frey • BlackHorse Real Estate

Bought with Ryan Frey • BlackHorse Real Estate

Redfin checked: 3 minutes ago

•Source:Metro Search MLS #1040195

Redfin Estimate

$542,401

$300K since sold in January 2004$6,000 since September

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 17.7% higher than the average sale price ($461K) of 6 comparable homes.

SOLD FEB 20, 2026
$444,000
A
4 beds2.5 baths2,862 sq ft
13006 Lost Trl, Goshen, KY 40026
Keller Williams Collective
SOLD SEP 11, 2026
$600,000
B
4 beds2.5 baths3,744 sq ft
13801 Lakewoods Ct, Prospect, KY 40059
R & Y Realty Group
SOLD JUL 8, 2026
$560,000
C
4 beds2.5 baths3,523 sq ft
13708 Mockingbird Dr, Prospect, KY 40059
Polo Real Estate Group LLC
SOLD OCT 1, 2026
$369,900
D
3 beds2 baths1,736 sq ft
1209 Pheasant Ridge Rd, Goshen, KY 40026
White Picket Real Estate
SOLD SEP 2, 2026
$410,000
E
3 beds2 baths2,589 sq ft
1105 Hollendale Way, Goshen, KY 40026
Keller Williams Collective
SOLD SEP 11, 2026
$381,000
F
3 beds3 baths2,000 sq ft
1938 Cardinal Harbour Rd, Prospect, KY 40059
1 Percent Lists Purple Door

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$439,182

Est. take-home

List your home with Redfin and save $5,424

Rent

$3,165/mo

Redfin rental estimate

List your home for rent

Market trends in 40059, KY

Last updated September 2026

Buyer's Market

Seller's Market

Balanced market

Sale-to-List Price

98.2%

+0.4% MoM

Median sale price

$715K

$18K MoM

Avg. days on market

48d

7 days MoM

Recently sold homes

127

14 MoM

New listings for sale

NEW 2 HRS AGO
$435,000
4 beds2.5 baths2,771 sq ft
9206 Newbury Ct, Prospect, KY 40059
Family Realty LLC
NEW 2 HRS AGO
$1,475,000
5 beds4.5 baths6,968 sq ft
12039 Hunting Crest Dr, Prospect, KY 40059
Semonin Realtors
COMING SOON
$1,998,000
4 beds4 baths4,718 sq ft
11500 River Beauty Loop, Prospect, KY 40059
Keller Williams Collective
NEW 27 HRS AGO
$975,000
4 beds3.5 baths3,732 sq ft
3124 English Way, Prospect, KY 40059
The Brokerage
NEW 29 HRS AGO
$223,900
2 beds1.5 baths1,336 sq ft
5608 Harrods Cv, Prospect, KY 40059
Keller Williams Collective
NEW 29 HRS AGO
$750,000
4 beds4.5 baths5,176 sq ft
6524 Harrods View Cir, Prospect, KY 40059
Coldwell Banker McMahan
3D WALKTHROUGH
$840,000
5 beds4.5 baths4,807 sq ft
12805 Deer Cross Dr, Prospect, KY 40059
Semonin Realtors
OPEN SAT, 12PM TO 2PM
$399,000
3 beds3 baths1,872 sq ft
13917 Harbour Pl, Prospect, KY 40059
Lenihan Sotheby's Int'l Realty
$630,000
3 beds2 baths3,280 sq ft
7241 Fox Harbor Rd, Prospect, KY 40059
EXP Realty LLC
OPEN SUN, 2PM TO 4PM
$550,000
4 beds2.5 baths2,620 sq ft
13323 Creekview Rd, Prospect, KY 40059
Keller Williams Collective
See all

Provided by Redfin

Sale history for 1902 N Rose Island Rd

Year

Property tax

Land + Additions

Assessment*

2025

$4,110

$80,000 + $250,000

$330,000

2024

$4,107 (+9.3%)

$80,000 + $250,000

$330,000

2023

$3,756 (+0.8%)

$80,000 + $250,000

$330,000

2022

$3,727 (+0.6%)

$80,000 + $220,000

$300,000

2021

$3,703 (−0.2%)

$80,000 + $220,000

$300,000

2020

$3,712 (+20.9%)

$80,000 + $220,000

$300,000

2019

$3,070

$80,000 + $220,000

$300,000

2018

$3,071 (+0.7%)

$70,000 + $180,000

$250,000

2017

$3,050 (+1.6%)

$70,000 + $180,000

$250,000

2016

$3,002 (+0.3%)

$70,000 + $180,000

$250,000

2015

$2,992 (+6.4%)

2013

$2,813

$70,000 + $180,000

$250,000

Tax history for 1902 N Rose Island Rd

Year

Property tax

Land + Additions

Assessment*

2025

$4,110

$80,000 + $250,000

$330,000

2024

$4,107 (+9.3%)

$80,000 + $250,000

$330,000

2023

$3,756 (+0.8%)

$80,000 + $250,000

$330,000

2022

$3,727 (+0.6%)

$80,000 + $220,000

$300,000

2021

$3,703 (−0.2%)

$80,000 + $220,000

$300,000

2020

$3,712 (+20.9%)

$80,000 + $220,000

$300,000

2019

$3,070

$80,000 + $220,000

$300,000

2018

$3,071 (+0.7%)

$70,000 + $180,000

$250,000

2017

$3,050 (+1.6%)

$70,000 + $180,000

$250,000

2016

$3,002 (+0.3%)

$70,000 + $180,000

$250,000

2015

$2,992 (+6.4%)

2013

$2,813

$70,000 + $180,000

$250,000

*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

1.85 Acres

Year renovated

—

Sq. Ft.

—

Year built

—

Style

Single Family Residential

County

Oldham County

APN

04-02B-04-178

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

Property details

Parking

Parking Information
Garage Spaces: 2.0
Parking Features: Detached

Interior

Bedroom Information
Bedrooms Total: 3
First Floor PBR: No
Primary Bedroom Level: Second
# Upper Floor Bedrooms: 0.0
# 2nd Floor Bedrooms: 3.0
# 1st Floor Bedrooms: 0.0
# Basement Bedrooms: 0.0
Primary Bedroom: Yes

Bathroom Information
Bathrooms Full: 2
Bathrooms Half: 1
Primary Bathroom Level: Second
Full Bathroom: Yes
Full Bathroom Level: Second
Half Bathroom: Yes
Half 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: 13
# of Fireplaces: 2
Fireplaces Total: 2
Fireplaces: Level 1: 2
Fireplace: Yes

Living Areas
Family Room: Yes
Family Room Level: Basement
Great Room: Yes
Great Room Level: First
Living Room: Yes
Living Room Level: First

Other Room Information
# of Rooms: 13
Rooms Total: 13
Basement Y/N: Yes
Basement: Partially Finished
Bedroom: Yes
Bedroom Level: Second
Closets: Basement: 0
Dining Area: Yes
Dining Area Level: First
Fireplaces Total: 2
Full Bathroom: Yes
Full Bathroom Level: Second
Half Bathroom: Yes
Half Bathroom Level: First
Kitchen: Yes
Kitchen Level: First
Laundry: Yes
Laundry Level: Second
Other: Yes
Other Level: Second
Primary Bathroom: Yes
Primary Bathroom Level: Second
Primary Bedroom: Yes
Primary Bedroom Level: Second

Room 1 Information
Room 1 Level: Basement
Room 1 Type: Family Room

Room 2 Information
Room 2 Level: First
Room 2 Type: Living Room

Room 3 Information
Room 3 Level: First
Room 3 Type: Dining Area

Room 4 Information
Room 4 Description: Eat in Kitchen
Room 4 Level: First
Room 4 Type: Kitchen

Room 5 Information
Room 5 Level: First
Room 5 Type: Great Room

Room 6 Information
Room 6 Level: First
Room 6 Type: Half Bathroom

Room 7 Information
Room 7 Level: Second
Room 7 Type: Bedroom

Room 8 Information
Room 8 Level: Second
Room 8 Type: Bedroom

Room 9 Information
Room 9 Level: Second
Room 9 Type: Primary Bedroom

Room 10 Information
Room 10 Level: Second
Room 10 Type: Primary Bathroom

Room 11 Information
Room 11 Level: Second
Room 11 Type: Full Bathroom

Room 12 Information
Room 12 Level: Second
Room 12 Type: Laundry

Room 13 Information
Room 13 Level: Second
Room 13 Type: Other

Exterior

Exterior Features
Exterior Features: Deck, Hot Tub

Land Information
Fencing: None
Fencing: None: Yes

Lot Description
Lot Features: Wooded
Lot Size Acres: 1.6
Lot Size Area: 1.6
Lot Size Units: Acres
Wooded: Yes

Property Information
Property Sub Type: Single Family Residence
Residential

Subdivision / Condo Amenities
Subdivision Name: CARDINAL HARBOUR

Building Information
Building Area Total: 2600.0
Stories: 2
Roof: Shingle
Construction Materials: Wood Frame
Above Grade Finished: 2,600
Below Grade Finished: 730
Living Area: 3330.0

Financial

Tax Information
Tax Block: 0000
Tax Lot: 178

Utilities

Utility Information
Utilities: Electricity Connected, Fuel:Natural, Public Sewer, Public Water

Cooling
Cooling Y/N: Yes
Cooling: Central Air

Location

HOA Information
Association Y/N: Yes
Clubhouse

Neighborhood Information
Subdivision Name: CARDINAL HARBOUR

Location Information
Directions: Take Hwy. 42 or Hwy. 1793 to Rose Island Rd.

Public facts

Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: 1.85 acres
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: Oldham County
APN: 04-02B-04-178

Home facts updated by county records on Oct 16, 2026

Around this home

Schools

Harmony Elementary School

Public K-5 • Assigned • 2.1mi

8/10

North Oldham Middle School

Public 6-8 • Assigned • 1.9mi

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

5/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)

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

$516,000 – $624,000

Reach more buyers when you sell with Redfin. Save up to $5,424 in fees. 3 minutes to get started.

Get a free, detailed breakdown of how we calculated your estimate.

Nearby similar homes

$38,000

3 beds1.5 baths1,370 sq ft

1210 New St, Charlestown, IN 47111

$385,000

3 beds2.5 baths2,352 sq ft

1000 Cliffwood Dr, Goshen, KY 40026

Coldwell Banker McMahan

NEW CONSTRUCTION

$296,990

5 beds3 baths2,600 sq ft

2008 Harmony Ln, Charlestown, IN 47111

NEW CONSTRUCTION

$286,990

4 beds2.5 baths2,203 sq ft

1906 Harmony Ln, Charlestown, IN 47111

NEW CONSTRUCTION

$257,990

4 beds2 baths1,671 sq ft

2022 Harmony Ln, Charlestown, IN 47111

$250,000

3 beds2 baths1,638 sq ft

1933 Harmony Cir, Charlestown, IN 47111

New listings for sale in 40059

NEW 2 HRS AGO

$435,000

4 beds2.5 baths2,771 sq ft

9206 Newbury Ct, Prospect, KY 40059

Family Realty LLC

NEW 2 HRS AGO3D WALKTHROUGH

$1,475,000

5 beds4.5 baths6,968 sq ft

12039 Hunting Crest Dr, Prospect, KY 40059

Semonin Realtors

COMING SOON

$1,998,000

4 beds4 baths4,718 sq ft

11500 River Beauty Loop, Prospect, KY 40059

Keller Williams Collective

NEW 27 HRS AGO

$975,000

4 beds3.5 baths3,732 sq ft

3124 English Way, Prospect, KY 40059

The Brokerage

NEW 29 HRS AGO

$223,900

2 beds1.5 baths1,336 sq ft

5608 Harrods Cv, Prospect, KY 40059

Keller Williams Collective

NEW 29 HRS AGO3D WALKTHROUGH

$750,000

4 beds4.5 baths5,176 sq ft

6524 Harrods View Cir, Prospect, KY 40059

Coldwell Banker McMahan

3D WALKTHROUGH

$840,000

5 beds4.5 baths4,807 sq ft

12805 Deer Cross Dr, Prospect, KY 40059

Semonin Realtors

OPEN SAT, 12PM TO 2PM

$399,000

3 beds3 baths1,872 sq ft

13917 Harbour Pl, Prospect, KY 40059

Lenihan Sotheby's Int'l Realty

$630,000

3 beds2 baths3,280 sq ft

7241 Fox Harbor Rd, Prospect, KY 40059

EXP Realty LLC

Home values near 1902 N Rose Island Rd

Data from public records.

Address	Redfin Estimate
1904 N Rose Island Road, Prospect, KY 4 Beds \| 2.5 Baths \| 3400 Sq. Ft.	$597,052
1818 Rivers Landing Drive, Prospect, KY 3 Beds \| 2.5 Baths \| 3074 Sq. Ft.	$574,752

Address	Redfin Estimate
1908 N Rose Island Road, Prospect, KY 3 Beds \| 2 Baths \| 2179 Sq. Ft.	$476,008
1908 Oriole Place, Prospect, KY 3 Beds \| 2 Baths \| 2069 Sq. Ft.	$446,026

Address	Redfin Estimate
1910 N Rose Island Road, Prospect, KY 4 Beds \| 3 Baths \| 2903 Sq. Ft.	$516,318
1900 Oriole Place, Prospect, KY 4 Beds \| 3.5 Baths \| 4040 Sq. Ft.	$623,388

Property information provided by Metro Search MLS when last listed in 2003. This data may not match . Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

40027 homes for sale
47130 homes for sale
47111 homes for sale
40059 homes for sale
40241 homes for sale

Harrods Creek homes for sale
Worthington homes for sale
Jeffersonville homes for sale
North Floyds Park homes for sale
Northeast Jefferson homes for sale

Houses for sale near me	Louisville, KY homes for sale	Frankfort, KY homes for sale
Land for sale near me	Lexington, KY homes for sale	Richmond, KY homes for sale
Open Houses near me	Bowling Green, KY homes for sale	Prospect Property Records
Condos for sale near me	Covington, KY homes for sale	KY New Listings
Agents near me	Georgetown, KY homes for sale	Prospect Housing Market

Louisville homes for sale
Shelbyville homes for sale
New Albany homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 40059, KY

Sale history for 1902 N Rose Island Rd

Tax history for 1902 N Rose Island Rd

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 40059

Home values near 1902 N Rose Island Rd

More real estate resources