A once-in-a-lifetime opportunity to acquire 22.9 acres in one of Indian Hill's most coveted locations; conveniently nestled at the intersection of Hopewell & Weil Roads. Originally part of the historic Peterloon Estate, this exceptional property offers a private, wooded setting with close proximity to highway access, the Village, historic downtown Loveland & Montgomery. The true value lies in the land & its irreplaceable location, nearly 23 acres with public water & sewer, offering extraordinary potential for a future estate, equestrian use, or legacy holding. The property includes an original residence & a horse barn, providing utility & architectural character. The Northwest Contemporary inspired home was thoughtfully designed to blend with its surroundings, featuring hand-hewn beams, stone, slate & limestone fireplaces, expansive floor-to-ceiling windows and seamless indoor-outdoor living. A rare offering defined by history, craftsmanship, privacy, and enduring value.
For sale
$5,950,000
8905 Hopewell Rd, Cincinnati, OH 45242
4beds
9,931sqft
Single Family Residence
Built in 1978
22.9 Acres Lot
$-- Zestimate®
$599/sqft
$-- HOA
What's special
Horse barnPrivate wooded settingOriginal residenceNorthwest contemporary inspired homeSeamless indoor-outdoor livingHand-hewn beamsExpansive floor-to-ceiling windows
- 131 days |
- 1,088 |
- 38 |
Zillow last checked:
Listing updated:
Listed by:
Gina A Dubell-Smith 513-477-1219,
eXp Realty 866-212-4991
Source: Cincy MLS,MLS#: 1866430
Originating MLS: Cincinnati Area Multiple Listing Service

Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 6
- Full bathrooms: 4
- 1/2 bathrooms: 2
Primary bedroom
- Features: Bath Adjoins, Walk-In Closet(s), Walkout, Fireplace, Wood Floor
- Level: Second
- Area: 483
- Dimensions: 23 x 21
Bedroom 2
- Level: First
- Area: 437
- Dimensions: 23 x 19
Bedroom 3
- Level: First
- Area: 304
- Dimensions: 19 x 16
Bedroom 4
- Level: Second
- Area: 270
- Dimensions: 18 x 15
Bedroom 5
- Area: 0
- Dimensions: 0 x 0
Primary bathroom
- Features: Tile Floor, Double Vanity, Tub, Tub w/Shower
Bathroom 1
- Features: Full
- Level: Second
Bathroom 2
- Features: Full
- Level: Second
Bathroom 3
- Features: Full
- Level: First
Bathroom 4
- Features: Full
- Level: First
Dining room
- Features: Built-in Features, Walkout, Fireplace, Wood Floor
- Level: First
- Area: 360
- Dimensions: 20 x 18
Family room
- Features: Walkout, Fireplace, Wood Floor
- Area: 420
- Dimensions: 21 x 20
Kitchen
- Features: Pantry, Kitchen Island, Wood Cabinets, Wood Floor
- Area: 270
- Dimensions: 18 x 15
Living room
- Features: Walkout, Fireplace, Wood Floor
- Area: 616
- Dimensions: 28 x 22
Office
- Features: Bookcases, Walkout, Fireplace, Wood Floor
- Level: Second
- Area: 500
- Dimensions: 25 x 20
Heating
- Electric, Heat Pump
Cooling
- Central Air
Appliances
- Included: Oven/Range, Refrigerator, Electric Water Heater
Features
- High Ceilings, Beamed Ceilings, Natural Woodwork, Vaulted Ceiling(s), Recessed Lighting
- Doors: French Doors, Multi Panel Doors
- Windows: Wood Frames
- Basement: Full,Concrete,Unfinished
- Number of fireplaces: 4
- Fireplace features: Stone, Wood Burning, Dining Room, Family Room, Living Room, Master Bedroom, Study
Interior area
- Total structure area: 9,931
- Total interior livable area: 9,931 sqft
Property
Parking
- Total spaces: 3
- Parking features: Driveway
- Garage spaces: 3
- Has uncovered spaces: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Deck, Patio
- Exterior features: Balcony
- Has view: Yes
- View description: Trees/Woods
Lot
- Size: 22.9 Acres
- Dimensions: 22.9 acres
- Features: Wooded, 20 to 49 Acres
Details
- Additional structures: Barn(s)
- Parcel number: 6290300004300
- Zoning description: Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary/Modern
- Property subtype: Single Family Residence
Materials
- Cedar
- Foundation: Block
- Roof: Shingle
Condition
- New construction: No
- Year built: 1978
Utilities & green energy
- Gas: At Street
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Security: Smoke Alarm
HOA
- Has HOA: No
Location
- Region: Cincinnati
Financial & listing details
- Price per square foot: $599/sqft
- Tax assessed value: $1,689,000
- Annual tax amount: $11,545
- Date on market: 1/30/2026
- Listing terms: No Special Financing
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 1/30/2026 | Listed for sale | $5,950,000$599/sqft |
Source: | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $11,545 +1.5% | $591,150 |
| 2023 | $11,379 -5.7% | $591,150 +17.5% |
| 2022 | $12,062 +17.1% | $502,943 |
| 2021 | $10,297 | $502,943 |
| 2020 | $10,297 +2.5% | $502,943 +10% |
| 2019 | $10,049 +3.4% | $457,222 0% |
| 2018 | $9,716 | $457,223 |
| 2017 | $9,716 -1.3% | $457,223 -2.9% |
| 2016 | $9,841 | $470,656 |
| 2015 | $9,841 +0.9% | $470,656 |
| 2014 | $9,751 | $470,656 |
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.6 mi
- 8/10Indian Hill Middle SchoolGrades: 6-8Distance: 4.2 mi
- 9/10Indian Hill High SchoolGrades: 9-12Distance: 4 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
- 8905 Hopewell 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






