Public Remarks: This outstanding all Brick Finished Walkout Lower Level Estate Home is located in the popular Overlook on Covered Bridge Subdivision in the North Oldham County School District. This home site is approximately 2.1 Acres and the Home has 7 Bedrooms, 4.5 baths, 1st floor Primary suite with over 7700 Finished Square Feet. As you enter...the home has an impressive foyer with an open rail staircase. The Home Office/Library is on the left side and the formal Dining Room is on the right. The Owner's Suite is on the back left, The Two Story Great Room with fireplace is in the middle of the home and the Kitchen, Breakfast Room and the Family Room with fireplace on the back right. The second level of the home has four Large Bedrooms and two Full Bathrooms. The lower level of the home has two Bedrooms, a Family Room with a kitchenette, a game area and a workout room. This home has beautiful Interior Trim, Custom Cabinetry, Built-In Bookcases, Hardwood Flooring, Ceramic Tile, Upgraded Carpet, Stainless Steel Appliances, Granite Countertops, A Security System, Exterior Irrigation and a side entry oversized Three Car Garage. Take a look through the pictures and make the call to take a look at this special home. Act fast as this special home will not stay on the market very long!
Single-familyProperty Type
2006Year Built
2.12 acresLot Size
$153Est. Price/Sq.Ft.
3 car garageParking
Listed by Lee Hamilton• Semonin Realtors
Bought with Kyle Elmore• White Picket Real Estate
Bought with Chris Gofney• White Picket Real Estate
This exquisite estate home with 2.12 acres is nestled in one of Oldham Counties most desired neighborhood. Featuring 7 bedrooms, 4.5 baths, open floor plan, grand 1st floor Primary suite with over 7800 finished sq. ft, private treed rear views and finished walk out basement. The circular driveway will lead you to an inviting front porch and double glass front door. Stroll into the vaulted Foyer with a 1st floor office with custom built-ins, an exquisite formal dining room with large windows, wainscot below chair-rail and tray ceiling. The vaulted Great room filled with natural light from a wall of arched windows includes a fireplace flanked by custom bookcases. A gourmet kitchen features a center island and a bar height island with painted cabinets, granite countertops, stainless steel appliances including gas range and double ovens. A large pantry, breakfast area with bay windows that flows to a vaulted hearth room with fireplace, and windows all around. The 1st floor Primary suite offers a sitting area with bay window overlooking the private rear yard, tray ceiling and spa bath featuring his and hers separate vanities, jetted tub and tiled shower and his and hers closets. A powder room, large laundry room with custom cubbies flows to a hallway with access to the oversize 3 car garage with built-in storage units. The unique front and rear staircases with iron spindles lead to the 2nd level with a large balcony gallery that leads you to 4 bedrooms and 2 full baths. The finished walk-out lower level features a large family room with custom built-ins and large wet bar, a separate recreation area with pool table & ping pong table, an exercise room with rubber tile flooring, 2 additional large bedrooms, a full bath and a workshop/hobby room with exterior doors and unfinished storage as well. A large upper deck with covered area, a lower-level patio and fenced back yard with lush green lawns and private rear woods is ideal for entertaining. This well maintained, light filled home located in the Overlook on Covered Bridge development within the North Oldham School District is a must see.
*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
2.12 Acres
Year renovated
—
Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Oldham County
APN
10-13G-00-9
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 16, 2026.
CO-1
Conservation/Residential District
The Conservation/Residential District is intended to promote and protect significant natural features, wooded areas, water courses, existing and potential lake sites, other recreational and conservation resources, wildlife habitat, present and future water supplies, and to minimize erosion of soil and the siltation and pollution of streams and lakes.
Permitted uses
Include but are not limited to:
Agriculture
Community / recreation center
Religious facility
Housing-Single unit
Housing-Senior
Infrastructure
Public service
Educational/school
Recreation
Park & open space
Jan 12, 2016 • Final
New building
New construction
Feb 13, 2006 • 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: 7
First Floor PBR: Yes
Primary Bedroom Level: First
# Upper Floor Bedrooms: 0.0
# 2nd Floor Bedrooms: 4.0
# 1st Floor Bedrooms: 1
# Basement Bedrooms: 2
Primary Bedroom: Yes
Bathroom Information
Bathrooms Full: 4
Bathrooms Half: 1
Primary Bathroom Level: First
Full Bathroom: Yes
Full Bathroom Level: Basement
Half Bathroom: Yes
Half Bathroom Level: First
Primary Bathroom: Yes
Kitchen & Dining Information
Dining Room: Yes
Dining Room Level: First
Kitchen: Yes
Kitchen Level: First
Interior Features
# of Rooms: 17
# of Closets: 14
# of Fireplaces: 2
Fireplaces Total: 2
Fireplaces: Level 1: 2
Fireplace: Yes
Living Areas
Family Room: Yes
Family Room Level: First
Great Room: Yes
Great Room Level: First
Den & Office Information
Office: Yes
Office Level: First
Other Room Information
# of Rooms: 17
Rooms Total: 20
Basement Y/N: Yes
Basement: Walkout Part Fin
Bedroom: Yes
Bedroom Level: Second
Closets: Basement: 3
Dining Room: Yes
Dining Room Level: First
Exercise Room: Yes
Exercise Room Level: Basement
Fireplaces Total: 2
Full Bathroom: Yes
Full Bathroom Level: Basement
Game Room: Yes
Game Room Level: Basement
Half Bathroom: Yes
Half 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: Dining Room
Room 2 Information
Room 2 Level: First
Room 2 Type: Office
Room 3 Information
Room 3 Level: First
Room 3 Type: Great Room
Room 4 Information
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: Primary Bedroom
Room 7 Information
Room 7 Level: First
Room 7 Type: Primary Bathroom
Room 8 Information
Room 8 Level: First
Room 8 Type: Half 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 Level: Second
Room 11 Type: Bedroom
Room 12 Information
Room 12 Level: Second
Room 12 Type: Bedroom
Room 13 Information
Room 13 Level: Second
Room 13 Type: Bedroom
Room 14 Information
Room 14 Description: 2 on Second Floor
Room 14 Level: Second
Room 14 Type: Full Bathroom
Room 15 Information
Room 15 Level: Basement
Room 15 Type: Bedroom
Room 16 Information
Room 16 Level: Basement
Room 16 Type: Bedroom
Room 17 Information
Room 17 Level: Basement
Room 17 Type: Exercise Room
Room 18 Information
Room 18 Level: Basement
Room 18 Type: Family Room
Room 19 Information
Room 19 Level: Basement
Room 19 Type: Full Bathroom
Room 20 Information
Room 20 Level: Basement
Room 20 Type: Game Room
Exterior
Land Information
Fencing: Other, Partial
Fencing: Other: Yes
Fencing: Partial: Yes
Lot Description
Lot Features: Wooded
Lot Size Acres: 2.12
Lot Size Area: 2.12
Lot Size Units: Acres
Wooded: Yes
Property Information
Property Sub Type: Single Family Residence
Residential
Subdivision / Condo Amenities
Subdivision Name: OVERLOOK ON COVERED BRIDGE
Building Information
Building Area Source: Other
Building Area Total: 4712.0
Stories: 2
Year Built: 2006
Roof: Shingle
Foundation Details: Poured Concrete
Construction Materials: Brick
Above Grade Finished: 4,712
Below Grade Finished: 3,069
Below Grade Unfin: 698
Living Area: 7781.0
Financial
Tax Information
Tax Block: 0
Tax Lot: 9
Utilities
Utility Information
# of HVAC Units: 2
# of HVAC Units: 2
Utilities: Electricity Connected
Heating
Heating Y/N: Yes
Heating: Forced Air, Natural Gas
Cooling
Cooling Y/N: Yes
Cooling: Central Air
Location
HOA Information
Association Fee: 700.0
Association Y/N: Yes
Neighborhood Information
Subdivision Name: OVERLOOK ON COVERED BRIDGE
School Information
High School District: Oldham
School District: Oldham
Location Information
Directions: Highway 42 to Covered Bridge Road (Hwy 329) to Overlook on Covered Bridge Subdivision. Hidden Springs Lane on left to Right on Overlook Ridge Road to the home on the right.
Public facts
Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: 2.12 acres
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: Oldham County
APN: 10-13G-00-9
Home facts updated by county records on Oct 16, 2026
Around this home
Schools
K - 12
Preschool & daycare
Goshen At Hillcrest Elementary School
Public K-5 • Assigned • 1.4mi
9/10
North Oldham Middle School
Public 6-8 • Assigned • 1.8mi
9/10
North Oldham High School
Public 9-12 • Assigned • 1.7mi
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
4/10 Heat Factor
7 days above 104° expected this year, 20 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°
89°
72°
85°
65°
83°
58°
70°
50°
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
$1.14M – $1.37M
Reach more buyers when you sell with Redfin. Save up to $11,940 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.