Public Remarks: Covered Bridge Road presents; a Gentleman's Manor. Custom built with every Architectural detail planned and executed, timeless artisan design all with 9.98 acres located next to Fox Hollow Farm in Oldham County. Impressive custom finishes-big family spaces. Collectors take note over 1,400sqft secured space. Complete with Impressive Master including 4 Suites, lighted Tennis Court, woods, small running branch, equestrian flat acres and a yard to meet the needs of every team sport, covered porch, board fencing, heated 4-5 car garage. Master carpentry elevates each room throughout your home on all 3 floors and front & rear staircases. 3 Gracious Masonry wood burning fireplaces, gas starters. DETAILS; cherry floors with Herringbone pattern. ADDITIONAL 7 ACRES available..PLS See YouTube video DETAILS: ...mahogany Library, Formal Dining, Living Room or Family Room with French door leading to your 500sqft Covered Veranda, Sunroom open to kitchen, Entertaining Lower Level. LOWER LEVEL: Finished ready for teen entertaining, bonus home office professional built-ins, impressive theater room and exercise room. Private stair case leads to heated garage. SECOND FLOOR: 4 suites; Master Suite includes, owners sitting area wrapped in windows, dreamy custom His & Hers closets and spa bath. Plus, 2 junior en-suites and the 4th suite planned for guests or in-law suite 21x43 plumbed and ready for a 2nd kitchen for a potential carriage apartment or use as a second family room. EXPANDED LIVING: Covered brick veranda over looking a BBQ terrace and rear yard (used as Ball field for the boys). DETAILS: Appliances: SUBZero, Asko, Thermodor, HVAC: Zoned 4 Lennox systems. 2-75 gallon Gas Hot water Heaters. Central vacuum. Alarm. Zoned Irrigation. Grand Mannor Roof. Theater room screen and projector conveys. FINISH: Lime Stone sills, custom quality throughout. 3 masonry fireplaces all with oversized fire boxes and gas starters. CAT 5 wiring, ready to customize for your "smart home". Surround sound inside and out. Two Story Entry Foyer compliment the first floor. Ceiling 10-11-12' through out. Click multiple photos for additional details, survey, appraisal footprint and disclosures. Low Utilities: AVG LGE $427.73/mo and Water $57.21 &42.06/mo.
RanchProperty Type
1999Year Built
9.9 acresLot Size
$259Price/Sq.Ft.
5 car garageParking
Listed by Colleen Walker• Kentucky Select Properties
*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
9.93 Acres
Year renovated
—
Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Oldham County
APN
10-00-00-6B
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 5, 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
Sep 19, 2018 • Final
Electrical
Electrical
Kitchen
Oct 2, 1997 • Final
New building
New construction
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: 5.0
Parking Features: Entry Rear, See Remarks
Interior
Bedroom Information
Bedrooms Total: 4
First Floor PBR: No
Primary Bedroom Level: Second
# Upper Floor Bedrooms: 0.0
# 2nd Floor Bedrooms: 4.0
# 1st Floor Bedrooms: 0.0
# Basement Bedrooms: 0.0
Primary Bedroom: Yes
Bathroom Information
Bathrooms Full: 4
Bathrooms Half: 3
Primary Bathroom Level: Second
Half Bathroom: Yes
Half Bathroom Level: First
Primary Bathroom: Yes
Kitchen & Dining Information
Breakfast Room: Yes
Breakfast Room Level: First
Dining Room: Yes
Dining Room Level: First
Kitchen: Yes
Kitchen Level: First
Interior Features
# of Rooms: 25
# of Closets: 15
# of Fireplaces: 3
Fireplaces Total: 3
Fireplaces: Basement: 1
Fireplaces: Level 1: 2
Fireplace: Yes
Living Areas
Family Room: Yes
Family Room Level: First
Den & Office Information
Office: Yes
Office Level: Basement
Study: Yes
Study Level: First
Other Room Information
# of Rooms: 25
Rooms Total: 19
Basement Y/N: Yes
Basement: Partially Finished
Bedroom: Yes
Bedroom Level: Second
Breakfast Room: Yes
Breakfast Room Level: First
Closets: Basement: 3
Craft Hobby Room: Yes
Craft Hobby Room Level: Basement
Dining Room: Yes
Dining Room Level: First
Exercise Room: Yes
Exercise Room Level: Basement
Fireplaces Total: 3
Game Room: Yes
Game Room Level: Basement
Half Bathroom: Yes
Half Bathroom Level: First
Kitchen: Yes
Kitchen Level: First
Laundry: Yes
Laundry Level: First
Media Room: Yes
Media Room Level: Basement
Other: Yes
Other Level: First
Primary Bathroom: Yes
Primary Bathroom Level: Second
Primary Bedroom: Yes
Primary Bedroom Level: Second
Room 1 Information
Room 1 Description: Elegant; Formal
Room 1 Length: 16.00
Room 1 Level: First
Room 1 Type: Dining Room
Room 1 Width: 16.00
Room 2 Information
Room 2 Description: Breakfast bar
Room 2 Length: 19.00
Room 2 Level: First
Room 2 Type: Kitchen
Room 2 Width: 16.00
Room 3 Information
Room 3 Level: First
Room 3 Type: Breakfast Room
Room 4 Information
Room 4 Description: Sunroom
Room 4 Length: 14.00
Room 4 Level: First
Room 4 Type: Other
Room 4 Width: 12.00
Room 5 Information
Room 5 Description: Living room
Room 5 Length: 23.00
Room 5 Level: First
Room 5 Type: Family Room
Room 5 Width: 21.00
Room 6 Information
Room 6 Description: Mahogony library
Room 6 Length: 17.00
Room 6 Level: First
Room 6 Type: Study
Room 6 Width: 11.00
Room 7 Information
Room 7 Description: 2 half baths
Room 7 Level: First
Room 7 Type: Half Bathroom
Room 8 Information
Room 8 Level: First
Room 8 Type: Laundry
Room 9 Information
Room 9 Description: w/sitting room 11x18
Room 9 Length: 19.00
Room 9 Level: Second
Room 9 Type: Primary Bedroom
Room 9 Width: 18.00
Room 10 Information
Room 10 Description: Spa finishes
Room 10 Level: Second
Room 10 Type: Primary Bathroom
Room 11 Information
Room 11 Description: Ensuite #2
Room 11 Length: 15.00
Room 11 Level: Second
Room 11 Type: Bedroom
Room 11 Width: 12.00
Room 12 Information
Room 12 Description: Ensuite #3
Room 12 Length: 13.00
Room 12 Level: Second
Room 12 Type: Bedroom
Room 12 Width: 13.00
Room 13 Information
Room 13 Description: Ensuite $#4 or In-law suite
Room 13 Length: 47.00
Room 13 Level: Second
Room 13 Type: Bedroom
Room 13 Width: 17.00
Room 14 Information
Room 14 Length: 11.00
Room 14 Level: Basement
Room 14 Type: Office
Room 14 Width: 11.00
Room 15 Information
Room 15 Length: 16.00
Room 15 Level: Basement
Room 15 Type: Craft/Hobby Room
Room 15 Width: 15.00
Room 16 Information
Room 16 Description: Wet bar
Room 16 Length: 27.00
Room 16 Level: Basement
Room 16 Type: Game Room
Room 16 Width: 19.00
Room 17 Information
Room 17 Description: Theater room
Room 17 Length: 22.00
Room 17 Level: Basement
Room 17 Type: Media Room
Room 17 Width: 20.00
Room 18 Information
Room 18 Length: 17.00
Room 18 Level: Basement
Room 18 Type: Exercise Room
Room 18 Width: 12.00
Room 19 Information
Room 19 Level: Basement
Room 19 Type: Half Bathroom
Exterior
Exterior Features
Exterior Features: See Remarks, Tennis Court(s)
Land Information
Acreage Info: Lake/Pond: 0.0
Acreage Info: Pasture Acres: 9.9
Acreage Info: Tillable Acres: 0.0
Acreage Info: Timber Acres: 0.0
Fencing: Partial, Wood
Fencing: Partial: Yes
Fencing: Wood: Yes
Waterfront Y/N: Yes
Lot Description
Lot Features: AddLndAve, Cleared, Level, Wooded
Lot Size Acres: 9.9
Lot Size Area: 9.9
Lot Size Units: Acres
Add Lnd Ave: Yes
Cleared: Yes
Level: Yes
Wooded: Yes
Property Information
Property Sub Type: Farm
Residential
Architectural Style: Traditional
Subdivision / Condo Amenities
Subdivision Name: NONE
Building Information
Building Area Source: Appraiser
Building Area Total: 6167.0
Stories: 2
Year Built: 1999
Roof: Shingle
Foundation Details: Poured Concrete
Construction Materials: Brick, Stucco
Above Grade Finished: 6,167
Below Grade Finished: 2,140
Below Grade Unfin: 1,839
Living Area: 8307.0
Financial
Tax Information
Tax Block: 0000
Tax Lot: 006b
Utilities
Utility Information
Utilities: Electricity Connected, Fuel:Natural
Heating
Heating Y/N: Yes
Heating: Natural Gas
Cooling
Cooling Y/N: Yes
Cooling: Central Air
Location
HOA Information
Association Fee: 0.0
Neighborhood Information
Subdivision Name: NONE
School Information
High School District: Oldham
School District: Oldham
Location Information
Directions: US HWY 42 to Covered Bridge (house on left just before Fox Hollow Farm) OR I71 to exit 14 to US HWY 42 through Browsnboro house on Right. GPS DOES NOT WORK.
Public facts
Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: 9.93 acres
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: Oldham County
APN: 10-00-00-6B
Home facts updated by county records on Oct 5, 2026
Around this home
Schools
Goshen At Hillcrest Elementary School
Public K-5 • Assigned • 2.8mi
9/10
North Oldham Middle School
Public 6-8 • Assigned • 3.0mi
9/10
North Oldham High School
Public 9-12 • Assigned • 2.9mi
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
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
Work with an experienced agent and save on fees. 3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.