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.
Pending
$2,300,000
9815 Humphrey Rd, Cincinnati, OH 45242
5beds
5,060sqft
Est.:
Single Family Residence
Built in 2023
0.95 Acres Lot
$-- Zestimate®
$455/sqft
$-- HOA
What's special
Covered porchPrivate wine cellarLarge storage areaHome gymOpen patio with fireplaceLarge windowsLarge family room
- 2 days |
- 350 |
- 24 |
Zillow last checked:
Listing updated:
Listed by:
Steve S Early 513-382-1218,
Sibcy Cline, Inc. 513-793-2121
Source: Cincy MLS,MLS#: 1877922
Originating MLS: Cincinnati Area Multiple Listing Service

Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 6
- Full bathrooms: 5
- 1/2 bathrooms: 1
Primary bedroom
- Features: Bath Adjoins, Dressing Area, Fireplace
- Level: First
- Area: 304
- Dimensions: 19 x 16
Bedroom 2
- Level: Second
- Area: 192
- Dimensions: 16 x 12
Bedroom 3
- Level: Second
- Area: 247
- Dimensions: 19 x 13
Bedroom 4
- Level: Second
- Area: 169
- Dimensions: 13 x 13
Bedroom 5
- Level: Lower
- Area: 156
- Dimensions: 13 x 12
Primary bathroom
- Features: Shower, Tile Floor, Double Vanity, Tub, Marb/Gran/Slate
Bathroom 1
- Features: Full
- Level: First
Bathroom 2
- Features: Full
- Level: Second
Bathroom 3
- Features: Full
- Level: Second
Bathroom 4
- Features: Full
- Level: Second
Dining room
- Features: Chandelier, Open
- Level: First
- Area: 168
- Dimensions: 14 x 12
Family room
- Area: 460
- Dimensions: 23 x 20
Kitchen
- Features: Butler's Pantry, Eat-in Kitchen, Gourmet, Marble/Granite/Slate
- Area: 270
- Dimensions: 18 x 15
Living room
- Features: Walkout, Fireplace, Wood Floor
- Area: 399
- Dimensions: 21 x 19
Office
- Features: French Doors, Wood Floor
- Level: First
- Area: 143
- Dimensions: 13 x 11
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Gas Water Heater
Features
- High Ceilings, Cathedral Ceiling(s), Natural Woodwork, Vaulted Ceiling(s)
- Doors: French Doors
- Windows: Double Hung
- Basement: Full,Finished
- Number of fireplaces: 3
- Fireplace features: Stone, Gas, Outside, Living Room, Master Bedroom
Interior area
- Total structure area: 5,060
- Total interior livable area: 5,060 sqft
Property
Parking
- Total spaces: 3
- Parking features: Driveway
- Attached garage spaces: 3
- Has uncovered spaces: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Covered Deck/Patio, Patio
- Exterior features: Fire Pit, Fireplace
Lot
- Size: 0.95 Acres
- Features: Corner Lot
Details
- Parcel number: 6200160053500
- Zoning description: Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence
Materials
- Brick, Stone
- Foundation: Concrete Perimeter
- Roof: Shingle
Condition
- New construction: No
- Year built: 2023
Utilities & green energy
- Gas: Natural
- Sewer: Public Sewer
- Water: Public
Community & HOA
HOA
- Has HOA: No
Location
- Region: Cincinnati
Financial & listing details
- Price per square foot: $455/sqft
- Tax assessed value: $142,980
- Annual tax amount: $28,008
- Date on market: 5/15/2026
- Listing terms: No Special Financing
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 5/17/2026 | Pending sale | $2,300,000$455/sqft |
Source: | ||
| 5/15/2026 | Listed for sale | $2,300,000+32.4%$455/sqft |
Source: | ||
| 3/15/2024 | Sold | $1,737,500-8.3%$343/sqft |
Source: | ||
| 2/7/2024 | Pending sale | $1,895,000$375/sqft |
Source: | ||
| 1/16/2024 | Price change | $1,895,000-5.2%$375/sqft |
Source: | ||
| 10/12/2023 | Price change | $1,999,800-6.8%$395/sqft |
Source: | ||
| 9/21/2023 | Price change | $2,145,000-2.3%$424/sqft |
Source: | ||
| 3/24/2023 | Listed for sale | $2,195,000$434/sqft |
Source: | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2023 | $2,233 -61.3% | $50,043 -52.3% |
| 2022 | $5,770 | $105,000 |
| 2021 | -- | -- |
Find assessor info on the county website
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 45242
Nearby schools
GreatSchools rating
- NAIndian Hill Primary Elementary SchoolGrades: K-2Distance: 4.1 mi
- 8/10Indian Hill Middle SchoolGrades: 6-8Distance: 3.7 mi
- 9/10Indian Hill High SchoolGrades: 9-12Distance: 3.6 mi
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
- Ohio
- Hamilton County
- The Village of Indian Hill
- 45242
- 9815 Humphrey Rd
Nearby cities
Nearby zip codes
Other The Village of Indian Hill Topics
- Apartments for Rent in 45242
- Houses for Sale in 45242
- Houses for Rent in 45242
- 45242 Real Estate
- The Village of Indian Hill Condos
- Houses for Sale in The Village of Indian Hill
- Newest Listings in The Village of Indian Hill
- The Village of Indian Hill Home Values
- The Village of Indian Hill Real Estate Agents
- The Village of Indian Hill Refinance
- The Village of Indian Hill Mortgage Rates





