4788 Mayhew Ave, Cincinnati, OH 45238 Property Records

Hamilton County property record for 4788 Mayhew Ave, Cincinnati, OH 45238

Property Summary

Property Type	Single Family Home
Details	3 bd · 1.5 ba · 1,432 sqft · built 1995
Lot Size	0.186 acres (8,102 sqft)
Owner	Company Name on Record
Last Sale	$1,500 (Oct 2023)
Tax Bill	$3,468 (2025)
Deeds & Mortgages	Oct 2023 Transfer Mar 2023 Mortgage + 4 more
Flood Zone	Zone X (minimal risk)
APN	`540-0041-0079-00`

Property Details

APN / Parcel Number

Primary APN	`540-0041-0079-00`

Interior

Bedrooms	3 Beds
Full Baths	1.5 Baths
Half Baths	1 Half Bath
Total Rooms	6 Rooms
Stories	2 Stories
Building Area	1,432 sqft Living Area
Gross Area	1,888 sqft
1st Floor Area	456 sqft
2nd Floor Area	976 sqft
Fireplaces	1 Fireplace
Fireplace	Fireplace

Exterior

Year Built	Built 1995
Effective Year Built	Effective 1995
Architectural Style	Conventional
Exterior Material	Aluminum/Vinyl
Construction Type	Frame
Lot Area	8,102 sqft (0.186 acres)
Lot Dimensions	121 ft deep x 66 ft wide
Garage Type	Attached
Garage Area	456 sqft
Parking Spaces	2 Parking Spaces

Utilities, Heating & Cooling

Cooling System	Central
Heating System	Baseboard
Heating Fuel	Oil

Location & Zoning

Street Address	4788 MAYHEW AVE
City	CINCINNATI
State	OH
Zip	45238
Property Category	Residential
Property Type	Residential > Single Family > Home
Local Zoning Code	C
Legal Description	MAYHEW AVE 66 X 121.18 IRR LOTS 170-171 BEPLER- WILLIAMS PARS 79-80 CONS
Legal Subdivision	MT PETER LAND & BLDG ASSN
Legal Lot Number	170-1
Jurisdiction	HAMILTON OH
Township / Civil Division	DELHI
Census Block Group	3
Census Block	3002
Census Tract	21401

Owner

Source: Hamilton County records, as of January 21, 2026

Owner names and exact recorded amounts shown locked on this page are available instantly with a free trial.

Owner of Record	Company Name on Record
Mailing Address	7256 SOUTHAMPTON LN, WEST CHESTER, OH 45069-8540
Owner Type	Company
Vesting	Limited Liability Partnership

Deeds, Mortgages & Sale History

Date	Document
Oct 3, 2023	Intrafamily Transfer, Transfer
Mar 2, 2023	Deed of Trust, Mortgage · Commercial Mortgage LIMESTONE BANK INC
Sep 28, 2020	Deed of Trust, Mortgage · Conventional Mortgage OPTION FINANCIAL LLC OPTION FINANCIAL LLC
Aug 21, 2020	Quit Claim Deed, Transfer NOT AVAILABLE
Jul 2, 2019	Quit Claim Deed, Transfer ATTORNEY ONLY
Jun 27, 2019	Warranty Deed, Transfer · Conventional with PMI OTHER INSTITUTIONAL LENDERS

Assessor's Deed Record

Deed Names	Name on Deed
Last Sale	Oct 3, 2023 · Amount on Record
Deed Sale	Oct 3, 2023 · Amount on Record
Prior Sale	Jun 27, 2019 · Amount on Record
Deed Document Number	202370569
Deed Book / Page	15013 / 1729
Prior Transfer Date	Aug 15, 2020
Prior Transfer Doc	0000083960
Record Updated	Sep 20, 2026

October 2023: Intrafamily Transfer, Transfer

Document Type	Intrafamily Transfer
Jurisdiction	HAMILTON OH
Recording Date	Oct 3, 2023
Property Address	4788 MAYHEW AVE, CINCINNATI, OH 45238
Document Number	0000070569
Book / Page	15013 / 1729
Instrument Date	Sep 22, 2023
Instrument	2023-0070569
Transaction Type	Transfer
Record Updated	Dec 18, 2023

Transaction

Tax	$0.00
Amount Accuracy	No Consideration Stated
Additional	Intrafamily Transfer

Transferred From (Grantor/Seller)

Name	Verified Name

Transferred To (Grantee/Buyer)

Name	Verified Name
Address	7256 SOUTHAMPTON LN, MCKINNEY, TX 75069

March 2023: Deed of Trust, Mortgage

Document Type	Deed of Trust
Jurisdiction	HAMILTON OH
Property Address	4788 MAYHEW AVE, CINCINNATI, OH 45238
Transaction Type	Mortgage
Record Updated	May 15, 2023

Transferred To (Grantee/Buyer)

Name	Verified Name
Address	166 PROSPEROUS PL 200, 200, LEXINGTON, KY 40509-1839

Mortgage

Document Number	0000014258
Date	Mar 2, 2023
Book Page	14864/38
Instrument	2023-0014258

Lender

Name	LIMESTONE BANK INC
Type	Bank
Address	LOUISVILLE, KY 40203

Agreement

Type	Commercial Mortgage
Amount	Amount Recorded
Term	36 Months
Due	Mar 1, 2026

September 2020: Deed of Trust, Mortgage

Document Type	Deed of Trust
Jurisdiction	HAMILTON OH
Property Address	4788 MAYHEW AVE, CINCINNATI, OH 45238
Document Number	0000110793
Instrument Date	Sep 28, 2020
Transaction Type	Mortgage
Record Updated	Apr 23, 2021
Title Company	PRODIGY TITLE AGENCY INC, PRODIGY TITLE AGCY INC

Transferred To (Grantee/Buyer)

Name	Verified Name
Address	4788 MAYHEW AVE CINCINNATI OH 45238, CINCINNATI, OH 45238

Mortgage

Document Number	0000110793
Date	Oct 23, 2020
Book Page	014281/000032
Instrument	110793

Lender

Name	OPTION FINANCIAL LLC OPTION FINANCIAL LLC
Type	Bank
Address	CINCINNATI, OH 45247

Agreement

Type	Conventional Mortgage
Amount	Amount Recorded
Term	360 Months
Due	Oct 22, 2050

August 2020: Quit Claim Deed, Transfer

Document Type	Quit Claim Deed
Jurisdiction	HAMILTON OH
Recording Date	Aug 21, 2020
Property Address	4788 MAYHEW AVE, CINCINNATI, OH 45238
Document Number	0000083960
Book / Page	014237 / 002619
Instrument Date	Aug 21, 2020
Instrument	83960
Transaction Type	Transfer
Record Updated	Oct 30, 2020
Title Company	NOT AVAILABLE

Transaction

Tax	$0.00
Additional	Quitclaim

Transferred From (Grantor/Seller)

Name	Verified Name

Transferred To (Grantee/Buyer)

Name	Verified Name
Address	2006 BURTON KNOLL CT SE GRAND RAPIDS MI 495468261, GRAND RAPIDS, MI 49546-8261

July 2019: Quit Claim Deed, Transfer

Document Type	Quit Claim Deed
Jurisdiction	HAMILTON OH
Recording Date	Jul 2, 2019
Property Address	4788 MAYHEW AVE, CINCINNATI, OH 45238
Document Number	0000052889
Book / Page	013951 / 001727
Instrument Date	Jun 25, 2019
Instrument	52889
Transaction Type	Transfer
Record Updated	Sep 23, 2019
Title Company	ATTORNEY ONLY

Transaction

Tax	$0.00
Additional	Quitclaim Arm's Length

Transferred From (Grantor/Seller)

Name	Verified Name

Transferred To (Grantee/Buyer)

Name	Verified Name
Relationship	Company
Address	2006 BURTON KNOLL CT SE GRAND RAPIDS MI 495468261, GRAND RAPIDS, MI 49546-8261

June 2019: Warranty Deed, Transfer

Document Type	Warranty Deed
Jurisdiction	HAMILTON OH
Recording Date	Jun 27, 2019
Property Address	4788 MAYHEW AVE, CINCINNATI, OH 45238
Document Number	0000051458
Book / Page	013948 / 002024
Instrument Date	Jun 13, 2019
Instrument	51458
Transaction Type	Transfer
Record Updated	Oct 2, 2019
Title Company	ATTORNEY ONLY

Transaction

Amount	Amount Recorded
Downpayment	Downpayment on Record
Loan-to-Value (LTV)	LTV on Record
Tax	$440.00
Amount Accuracy	Confirmed
Additional	Arm's Length

Transferred From (Grantor/Seller)

Name	Verified Name

Transferred To (Grantee/Buyer)

Name	Verified Name
Address	2006 BURTON KNOLL CT SE GRAND RAPIDS MI 495468261, GRAND RAPIDS, MI 49546-8261

Mortgage

Document Number	51459
Date	Jun 27, 2019
Book Page	013948/002026
Instrument	51459

Lender

Name	OTHER INSTITUTIONAL LENDERS
Type	Bank
Address	CINCINNATI, OH 45247

Agreement

Type	Conventional with PMI
Amount	Amount Recorded
Term	360 Months
Due	Jun 26, 2049

Tax Assessment & Valuation

Source: Hamilton County assessment roll, as of January 21, 2026

Property Jurisdictions

Type	Name
State	Ohio
County	Hamilton County
County Subdivision	Delhi Township
Unified School District	Oak Hills Local School District (PK - 12)

Tax Bill & Assessment History

Year	Tax Bill	Assessed Value	Assessed Market Value
2025	$3,468.00 (-0.23%)	$56,865 (-) Land $9,240 Building $47,625	$162,470 (-) Land $26,400 Building $136,070
2024	$3,476.00 (+1.52%)	$56,865 (-) Land $9,240 Building $47,625
2023	$3,424.00 (+31.34%)	$56,865 (+47.7%) Land $9,240 Building $47,625	$162,470 (+47.7%) Land $26,400 Building $136,070
2022	$2,607.00	$38,500 Land $8,267 Building $30,233
2020			$110,000 Land $23,620 Building $86,380

Assessed value and assessed market value are set for property tax purposes and are not market price estimates.

Flood

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 Claims	2 (1998)
Claims Outside the SFHA	2 of 2
Most Recent Claim	Jul 1998 · rainfall accumulation

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

Source: USDA Forest Service Wildfire Risk to Communities (2nd edition), as of 2024

Wildfire Risk	Low lower than 99.1% of the US · lower than 96% of Ohio
Wildfire Likelihood	Under 0.01% annual chance
Exposure	None beyond ember reach

Values cover an area roughly 900 ft across, not the parcel itself; insurers use their own ratings.

Drinking Water

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

Violations Reported to EPA

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.

Internet Providers

Source: FCC Broadband Data Collection, based on 402 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	1,000 / 75
AT&T Fixed Wireless	100 / 20
T-Mobile Fixed Wireless	100 / 20

May also be available: Brightspeed.

Nearby Properties on Mayhew Ave

Nearby Streets

Search Property Records by Address or Parcel Number

Search by:

By searching, you agree to: Terms • Privacy • Disclosures