Hamilton County property record for 5157 Castlebrook Ct, Cincinnati, OH 45247
| Property Type | Single Family Home |
|---|---|
| Details | 4 bd · 3.5 ba · 3,487 sqft · built 1999 |
| Lot Size | 0.616 acres (26,833 sqft) |
| Owner | Individual Name on File |
| Last Sale | $305,000 (Jul 2018) |
| Tax Bill | $7,215 (2025) |
| Deeds & Mortgages | Jan 2022 Mortgage Jan 2020 Mortgage |
| Flood Zone | Zone X (minimal risk) |
| APN | 550-0103-0166-00 |
| Primary APN | 550-0103-0166-00 |
|---|
| Bedrooms | 4 Beds |
|---|---|
| Full Baths | 3.5 Baths |
| Half Baths | 1 Half Bath |
| Total Rooms | 8 Rooms |
| Stories | 2 Stories |
| Building Area | 3,487 sqft Living Area |
| Gross Area | 4,677 sqft |
| 1st Floor Area | 1,345 sqft |
| 2nd Floor Area | 1,492 sqft |
| Basement Area | 1,345 sqft |
| Finished Basement | 650 sqft |
| Unfinished Basement | 695 sqft |
| Fireplaces | 1 Fireplace |
| Fireplace | Fireplace |
| Year Built | Built 1999 |
|---|---|
| Effective Year Built | Effective 1999 |
| Architectural Style | Conventional |
| Exterior Material | Brick/Stone |
| Construction Type | Masonry / Concrete Block |
| Lot Area | 26,833 sqft (0.616 acres) |
| Garage Type | Attached |
| Garage Area | 495 sqft |
| Parking Spaces | 2 Parking Spaces |
| Porch | Open Frame Porch |
|---|---|
| Porch Area | 84 sqft |
| Deck Area | Deck Area |
| Patio Area | 352 sqft |
| Cooling System | Central |
|---|---|
| Heating System | Baseboard |
| Heating Fuel | Oil |
| Street Address | 5157 CASTLEBROOK CT |
|---|---|
| City | CINCINNATI |
| State | OH |
| Zip | 45247-7955 |
| Property Category | Residential |
| Property Type | Residential > Single Family > Home |
| Local Zoning Code | A2 |
| Legal Description | CASTLEBROOK CT 0.616 AC LOT 8 STRATFORD LAKE SUB BL A |
| Legal Subdivision | STRATFORD LAKE SUB |
| Legal Block | A |
| Legal Lot Number | 8 |
| Jurisdiction | HAMILTON OH |
| Township / Civil Division | GREEN |
| Census Block Group | 2 |
| Census Block | 2007 |
| Census Tract | 20802 |
5157 Castlebrook Ct is owned and occupied by an individual who bought it in July 2018.
Source: Hamilton County records, as of January 21, 2026
| Owner of Record | Individual Name on File |
|---|---|
| Mailing Address | 5157 CASTLEBROOK CT, CINCINNATI, OH 45247-7955 |
| Occupancy | Owner Occupied |
| Owner Type | Individual |
Owner names and exact recorded amounts are on file and can be viewed instantly on this page with a free 10-day trial.
| Date | Document |
|---|---|
| Jan 19, 2022 | Deed of Trust, Mortgage · Conventional Mortgage KEY BANK NA |
| Jan 6, 2020 | Deed of Trust, Mortgage · Conventional with PMI KEYBANK USA |
| Deed Names | Name on Deed |
|---|---|
| Last Sale | Jul 16, 2018 · Amount on File |
| Deed Sale | Jul 16, 2018 · Amount on File |
| Prior Sale | Sep 15, 1998 · Amount on File |
| Deed Document Number | 201860403 |
| Prior Transfer Date | Oct 19, 2005 |
| Prior Transfer Doc | 0000000485 |
| Record Updated | Jun 8, 2026 |
| Document Type | Deed of Trust |
|---|---|
| Jurisdiction | HAMILTON OH |
| Property Address | 5157 CASTLEBROOK CT, CINCINNATI, OH 45247-7955 |
| Transaction Type | Mortgage |
| Record Updated | Feb 10, 2026 |
| Title Company | CORPORATE SETTLEMENTS, CORPORATE SETTLEMENT SLN |
| Name | Verified Name |
|---|
| Document Number | 0000006961 |
|---|---|
| Date | Jan 19, 2022 |
| Book Page | 14586/2089 |
| Instrument | 2022-0006961 |
| Name | KEY BANK NA |
|---|---|
| Type | Bank |
| Address | CLEVELAND, OH 44114 |
| Type | Conventional Mortgage |
|---|---|
| Amount | Amount on Record |
| Term | 181 Months |
| Due | Feb 1, 2037 |
| Document Type | Deed of Trust |
|---|---|
| Jurisdiction | HAMILTON OH |
| Property Address | 5157 CASTLEBROOK CT, CINCINNATI, OH 45247-7955 |
| Document Number | 0000003966 |
| Instrument Date | Jan 6, 2020 |
| Transaction Type | Mortgage |
| Record Updated | Feb 27, 2020 |
| Title Company | NOT AVAILABLE |
| Name | Verified Name |
|---|---|
| Address | 5157 CASTLEBROOK CT CINCINNATI OH 452477955, CINCINNATI, OH 45247-7955 |
| Document Number | 0000003966 |
|---|---|
| Date | Jan 13, 2020 |
| Book Page | 014082/002079 |
| Instrument | 3966 |
| Name | KEYBANK USA |
|---|---|
| Type | Bank |
| Address | CLEVELAND, OH 44114-1306 |
| Type | Conventional with PMI |
|---|---|
| Amount | Amount on Record |
| Term | 180 Months |
| Due | Jan 12, 2035 |
The 2025 property tax bill for 5157 Castlebrook Ct was $7,215, up 2.3% from the year before.
Source: Hamilton County assessment roll, as of January 21, 2026
| Type | Name |
|---|---|
| State | Ohio |
| County | Hamilton County |
| County Subdivision | Green Township |
| Unified School District | Oak Hills Local School District (PK - 12) |
| Year | Tax Bill | Assessed Value | Assessed Market Value |
|---|---|---|---|
| 2025 | $7,215.00 (+2.28%) | $133,179 (-) Land $18,375 Building $114,804 | $380,510 Land $52,500 Building $328,010 |
| 2024 | $7,054.00 (-0.48%) | $133,179 (-) Land $18,375 Building $114,804 | |
| 2023 | $7,088.00 (+1.91%) | $133,179 (+24.76%) Land $18,375 Building $114,804 | $380,510 Land $52,500 Building $328,010 |
| 2022 | $6,955.00 Homeowner's exemption | $106,750 Land $20,699 Building $86,051 | |
| 2020 | $305,000 Land $59,140 Building $245,860 |
Assessed value and assessed market value are set for property tax purposes, not market price estimates; both are a fraction of this property's market value.
FEMA maps place 5157 Castlebrook Ct in Zone X, an area of minimal flood risk, though there have been 1 flood claim nearby since 1982.
Source: FEMA National Flood Hazard Layer, effective December 22, 2024 · OpenFEMA NFIP redacted claims and policies, as of September 2026
| FEMA Flood Zone | Zone X minimal risk |
|---|---|
| Flood Insurance Requirement | Not required lenders may require it |
| Nearby Flood Policies | 1 in force |
| Nearby Flood Claims | 1 (1982) |
| Most Recent Claim | Mar 1982 · tidal / storm surge |
Values are read at the parcel center point; flood claims are located to the census block group, not this parcel; lenders make the official flood determination.
Wildfire risk around 5157 Castlebrook Ct is low, with less than a 0.01% annual chance of wildfire.
Source: USDA Forest Service Wildfire Risk to Communities (2nd edition), as of 2024
| Wildfire Risk | Low lower than 95% of the US · lower than 78% of Ohio |
|---|---|
| Wildfire Likelihood | Under 0.01% annual chance |
| Exposure | Direct burnable vegetation |
Values cover an area roughly 900 ft across, not the parcel itself; insurers use their own ratings.
Source: EPA Safe Drinking Water Information System, as of September 2026
| Water System | CINCINNATI PUBLIC WATER SYSTEM serves 800,000 people · EPA ID OH3102612 |
|---|---|
| Water Source | Surface water |
| Last State Inspection | Dec 2024 |
| Lead | 2 ppb (2026) action level 15 ppb |
| Water Quality | None last 10 years |
|---|---|
| Treatment and Procedure | None last 10 years |
| Monitoring and Reporting | None last 3 years |
Results are for the whole water system, not water tested at this address; lead at the tap also depends on the building's own pipes.
Source: FCC Broadband Data Collection, based on 80 locations within half a mile, as of December 31, 2025
| Provider | Max Down / Up (Mbps) |
|---|---|
| altafiber Network Solutions Fiber | 3,000 / 3,000 |
| Spectrum Cable | 1,000 / 1,000 |
| Verizon Fixed Wireless | 300 / 20 |
| T-Mobile Fixed Wireless | 100 / 20 |
Search by:
By searching, you agree to: Terms • Privacy • Disclosures