This home's estimate is 113.5% higher than the average sale price ($1.04M) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
- Climate
















































9815 Humphrey Rd, Cincinnati, OH 45242
Is this your home?
Track this home’s value and nearby sales activity
About this home
Public Remarks: Gorgeous 5 bedroom in Indian Hill Schools - only 3 years old! Soaring ceilings and large windows, open concept with bespoke finishes, incredible butler's pantry/laundry off kitchen, first floor primary suite with dream bathroom feat. monumental shower and dressing room, three bedrooms upstairs with attached baths and large closets plus rec space, finished lower level with 5th bedroom and full bath, large family room, home gym, bonus room/second study and a private wine cellar, plus large storage area! Set on nearly 1 flat acre with covered porch, open patio with fireplace, outdoor kitchenette with built-in grill and beverage fridge, attached three car garage - this home has it all! Beautifully finished and move-in ready.

Redfin Estimate
Market trends in 45242, OH
Last updated August 2026
Buyer's Market
Seller's Market
Seller's market
See all
Provided by Redfin
Homeowner tools
More resources
Track your estimate and nearby sale activity
Review property details and add renovations
Update home photos or make them private
Est. $3,709 per month, based on comparable rentals
Sale and tax history for 9815 Humphrey Rd
- Sale History
- Tax History
$461/sq ft
$455/sq ft
Public record
Property details
Parking
- Parking Information
- # of Garage Spaces: 3
- Garage/Carport: Garage Attached
- Parking Features: Driveway
Interior
- Accessibility Information
- Bedroom Level 1: Yes
- Bathroom Level 1: Yes
- Bathroom Level 1 Type: Full
- Bathroom Information
- # of Bathrooms (1/2): 1
- # of Bathrooms (Full): 5
- Bath 1: Full
- Bath 1 Level: 1
- Bath 2: Full
- Bath 2 Level: 2
- Bath 3: Full
- Bath 3 Level: 2
- Bath 4: Full
- Bath 4 Level: 2
- Primary Bathroom: Shower, Tub
- Bedroom Information
- # of Bedrooms Total: 5
- Primary Bedroom Features: Fireplace
- Primary Bedroom: 19x16 Level: 1
- Primary Bedroom Area: 304
- Primary Bedroom Dimensions: 19 x 16
- Primary Bedroom Length: 19
- Primary Bedroom Width: 16
- Bedroom 2: 16x12 Level: 2
- Bedroom 2 Area: 192
- Bedroom 2 Dimensions: 16 x 12
- Bedroom 2 Length: 16
- Bedroom 2 Width: 12
- Bedroom 3: 19x13 Level: 2
- Bedroom 3 Area: 247
- Bedroom 3 Dimensions: 19 x 13
- Bedroom 3 Length: 19
- Bedroom 3 Width: 13
- Bedroom 4: 13x13 Level: 2
- Bedroom 4 Area: 169
- Bedroom 4 Dimensions: 13 x 13
- Bedroom 4 Length: 13
- Bedroom 4 Width: 13
- Bedroom 5: 13x12 Level: Lower
- Bedroom 5 Area: 156
- Bedroom 5 Dimenstions: 13 x 12
- Bedroom 5 Length: 13
- Bedroom 5 Width: 12
- Den/Recreation Room Information
- Study (Lib/Den): 13x11 Level: 1
- Study Features: French Doors, Wood Floor
- Study/Library/Den Area: 143
- Study/Library/Den Dimensions: 13 x 11
- Study/Library/Den Length: 13
- Study Library/Den Width: 11
- Kitchen/Dining Room Information
- Kitchen Features: Butler's Pantry, Eat-In, Gourmet, Marble/Granite/Slate
- Kitchen Area: 270
- Kitchen Dimensions: 18 x 15
- Kitchen Length: 18
- Kitchen Width: 15
- Dining Room: 14x12 Level: 1
- Dining Room Features: Chandelier, Open
- Dining Room Area: 168
- Dining Room Dimensions: 14 x 12
- Dining Room Length: 14
- Dining Room Width: 12
- Living Room/Family Room Information
- Living/Great Room Area: 399
- Living/Great Room Dimensions: 21 x 19
- Living/Great Room Length: 21
- Living Great Room Width: 19
- Living Room: 21x19 Level: 1
- Living Room Features: Walkout, Fireplace, Wood Floor
- Family Room Area: 460
- Family Room Dimensions: 23 x 20
- Family Room Length: 23
- Family Room Width: 20
- Other Room Information
- Entry (Foyer): Open Foyer, Double Doors
- Entry: 12x8 Level: 1
- Entry Area: 96
- Flex Rooms: Exercise Room, GuestSuite w/o Ktchn
- Laundry Room: 16x9 Level: 1
- Laundry Room Area: 144
- Laundry Room Dimensions: 16 x 9
- Laundry Room Length: 16
- Laundry Room Width: 9
- Basement: Full
- Basement Features: Finished
- Basement Sq. Ft. (Realist): 2,481
- Interior Features
- # of Rooms (Total): 13
- Interior Features: 9Ft + Ceiling, Cathedral Ceiling, French Doors, Natural Woodwork, Vaulted Ceiling
Exterior
- Exterior Features
- Exterior Features: Corner Lot, Covered Deck/Patio, Fire Pit, Fireplace, Patio
- Roof: Shingle
- Construction Materials: Brick, Stone
- Window Features: Double Hung
- Land Information
- Zoning Details: Residential
- Lot Information
- Lot Area (Realist): 41,304
- Lot Size Units: Acres
- Lot Size Acres: 0.9482
- Lot Size Sq. Ft.: 41,304
- Property Information
- # of Fireplaces (Total): 3
- Fireplace Features: Stone, Gas
- Architectural Style: Traditional
- Single Family Desc: Single Family
- Foundation Details: Poured
- Levels: Two
- Census Tract Realist: 243.22
- 2nd Flor Area (Realist): 1,479
Financial
- Tax Information
- Semi-Annual Taxes: $14,004
- Tax Abatement: No
- Parcel Number: 6200160053500
- Lease & Rent Information
- Lease Considered: No
Utilities
- Utility Information
- Water Source: Public
- Cooling: Central Air
- Gas: Natural
- Heating: Forced Air
- Sewer: Public Sewer
- Water Heating: Gas
Location
- Homeowners Association Information
- HOA: No
- School Information
- High School District: Indian Hill Ex Vill
- Location Details
- Suburb: Symmes Twp.
- Directions: Loveland-Madeira Rd to Humphrey, go straight at 90 degree turn.
Public facts
- Beds: —
- Baths: 5.5
- Sq. Ft.: 5,060
- Stories: 2.0
- Lot Size: 0.95 acres
- Style: Single Family Residential
- Year Built: 2023
- Year Renovated: —
- County: Hamilton County
- APN: 6200160053500
Other
- Listing Information
- Listing URL: Listing URL (External Link)
- Auction: No
- FIPS Code: 61
- Picture Provided By: Photo Supplied
Around this home
Schools
Public K-2 • Assigned • 4.1mi
Public 6-8 • Assigned • 3.7mi
Public 9-12 • Assigned • 3.4mi
Climate risks
Minimal risk of a flood reaching the building in the next 30 years
Unlikely to be in a wildfire in next 30 years
7 days above 102° expected this year, 19 days in 30 years
1% chance of strong winds in next 30 years
3 unhealthy days expected this year, 4 days in 30 years
Sun exposure
Exceptional sunlight
SunscoreThis home ranks in the top 1% for direct sun exposure in Cincinnati. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
Nearby similar homes
New listings for sale in 45242
Home values near 9815 Humphrey Rd
| Address | Redfin Estimate |
|---|---|
4 Beds | 2.5 Baths | 2802 Sq. Ft. | $618,306 |
4 Beds | 3 Baths | 4100 Sq. Ft. | $761,190 |
| Address | Redfin Estimate |
|---|---|
4 Beds | 3.5 Baths | 3143 Sq. Ft. | $742,148 |
4 Beds | 2.5 Baths | 2258 Sq. Ft. | $564,763 |
| Address | Redfin Estimate |
|---|---|
4 Beds | 3 Baths | 3400 Sq. Ft. | $650,753 |
5 Beds | 5.5 Baths | - Sq. Ft. | $1,515,529 |
More real estate resources
- Zip Codes
- Neighborhoods
- Cities
- Popular Searches
| 45140 homes for sale | |||
| 45242 homes for sale | |||
| 45243 homes for sale | |||
| 45150 homes for sale | |||
| 45249 homes for sale |
| Stonebridge homes for sale | |||
| Walnut Grove Village homes for sale | |||
| The Woods at Miami Trails homes for sale | |||
| Historic West Loveland homes for sale | |||
| Downtown Loveland homes for sale |
| West Chester homes for sale | |||
| Cincinnati homes for sale | |||
| Mason homes for sale |
Find us
Subsidiaries
Affiliated Business
Copyright: © 2026 Redfin. All rights reserved.
Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.
Do not sell or share my personal information.
REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.
California DRE #01521930
Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures
New Mexico Real Estate Licenses
TREC: Info About Brokerage Services, Consumer Protection Notice
All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.
Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.
If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.
REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

































United States
Canada