Public Remarks: Stunning, custom executive home has it all! Designer features & architectural detail on corner/cul-de-sac in award winning No. Oldham school district. Impressive 2 story kitchen/dining area w/stainless appliances open to vaulted hearth rm w/stone fireplace. Brazilian hardwood throughout 1st floor. 1st floor office, Formal Dining rm, Mudroom cubbies & laundry rm w/writing desk. 5 OVERSIZED BRs each w/EN SUITE FULL BA. Spacious 1st floor MASTER SUITE w/sitting room & Italian travertine BA. Lower level w/10’ ceilings has a Family Rm, Bar-Kitchenette, Game Room, Gym, 1 ½ baths & large Bedroom PLUS a wired/unfinished Media Room. A delightful open floor plan & well designed flow. OVERSIZED 3 car garage. Country Club membership optional for social, golf, pool & tennis.
*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.49 Acres
Year renovated
—
Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Oldham County
APN
11-11C-11E-627
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 16, 2026.
R-2A
Residential District
The purpose of the R-2A Residential District is to allow, preserve and protect the character of low to medium density, detached single-family areas and neighborhoods at densities up to 5.81 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
New building
New construction
Jan 12, 2016 • 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
Parking
Parking Information
Garage Spaces: 3.0
Parking Features: Attached, Entry Side
Interior
Bedroom Information
Bedrooms Total: 5
First Floor PBR: Yes
Primary Bedroom Level: First
# Upper Floor Bedrooms: 0.0
# 2nd Floor Bedrooms: 3.0
# 1st Floor Bedrooms: 1
# Basement Bedrooms: 1
Primary Bedroom: Yes
Bathroom Information
Bathrooms Full: 5
Bathrooms Half: 2
Primary Bathroom Level: First
Full Bathroom: Yes
Full Bathroom Level: Second
Half Bathroom: Yes
Half Bathroom Level: Basement
Primary Bathroom: Yes
Kitchen & Dining Information
Dining Room: Yes
Dining Room Level: First
Kitchen: Yes
Kitchen Level: First
Interior Features
# of Rooms: 11
# of Closets: 11
# of Fireplaces: 2
Fireplaces Total: 2
Fireplaces: Basement: 1
Fireplaces: Level 1: 1
Fireplace: Yes
Living Areas
Family Room: Yes
Family Room Level: Basement
Great Room: Yes
Great Room Level: First
Den & Office Information
Office: Yes
Office Level: First
Other Room Information
# of Rooms: 11
Rooms Total: 20
Basement Y/N: Yes
Basement: Finished
Bedroom: Yes
Bedroom Level: Second
Closets: Basement: 1
Dining Room: Yes
Dining Room Level: First
Fireplaces Total: 2
Full Bathroom: Yes
Full Bathroom Level: Second
Game Room: Yes
Game Room Level: Basement
Half Bathroom: Yes
Half Bathroom Level: Basement
Kitchen: Yes
Kitchen Level: First
Laundry: Yes
Laundry 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: Office
Room 2 Information
Room 2 Description: Formal
Room 2 Level: First
Room 2 Type: Dining Room
Room 3 Information
Room 3 Level: First
Room 3 Type: Great Room
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: Family Room
Room 6 Information
Room 6 Level: First
Room 6 Type: Half Bathroom
Room 7 Information
Room 7 Level: First
Room 7 Type: Primary Bedroom
Room 8 Information
Room 8 Level: First
Room 8 Type: Primary Bathroom
Room 9 Information
Room 9 Level: First
Room 9 Type: Laundry
Room 10 Information
Room 10 Level: Second
Room 10 Type: Bedroom
Room 11 Information
Room 11 Description: en suite
Room 11 Level: Second
Room 11 Type: Full Bathroom
Room 12 Information
Room 12 Level: Second
Room 12 Type: Bedroom
Room 13 Information
Room 13 Description: en suite
Room 13 Level: Second
Room 13 Type: Full Bathroom
Room 14 Information
Room 14 Level: Second
Room 14 Type: Bedroom
Room 15 Information
Room 15 Description: en suite
Room 15 Level: Second
Room 15 Type: Full Bathroom
Room 16 Information
Room 16 Level: Basement
Room 16 Type: Family Room
Room 17 Information
Room 17 Level: Basement
Room 17 Type: Half Bathroom
Room 18 Information
Room 18 Level: Basement
Room 18 Type: Bedroom
Room 19 Information
Room 19 Description: en suite
Room 19 Level: Basement
Room 19 Type: Full Bathroom
Room 20 Information
Room 20 Level: Basement
Room 20 Type: Game Room
Exterior
Exterior Features
Exterior Features: Tennis Court
Lot Description
Lot Features: Covt/Restr, Sidewalk
Lot Size Area: 0.0
Lot Size Units: Acres
Lot Size Dimensions: 110 x 206
Covt Restr: Yes
Cul De Sac: Yes
Sidewalk: Yes
Property Information
Property Sub Type: Single Family Residence
Residential
Architectural Style: Traditional
Subdivision / Condo Amenities
Subdivision Name: GLEN OAKS
Building Information
Building Area Source: Appraiser
Building Area Total: 4067.0
Stories: 2
Year Built: 2006
Roof: Shingle
Foundation Details: Poured Concrete
Construction Materials: Brick, Stone
Above Grade Finished: 4,067
Below Grade Finished: 2,398
Below Grade Unfin: 266
Living Area: 6465.0
Financial
Tax Information
Tax Block: 11E
Tax Lot: 627
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
Association Y/N: Yes
Clubhouse, Golf Course, Playground, Pool
Neighborhood Information
Subdivision Name: GLEN OAKS
School Information
High School District: Oldham
School District: Oldham
Location Information
Directions: Hwy 22 to Hwy 1694. Right on Stone School (Glen Oaks Entrance). Right Worthington Lane, left Waterfall Way.
Public facts
Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: 0.49 acres
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: Oldham County
APN: 11-11C-11E-627
Home facts updated by county records on Oct 16, 2026
Around this home
Schools
Goshen At Hillcrest Elementary School
Public K-5 • Assigned • 3.1mi
9/10
North Oldham Middle School
Public 6-8 • Assigned • 4.3mi
9/10
North Oldham High School
Public 9-12 • Assigned • 4.2mi
10/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk 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 104° 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, 3 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
$994,000 – $1.20M
Reach more buyers when you sell with Redfin. Save up to $10,458 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.