Skip main navigation
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
    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.
    36 days
    |
    5,217
    |
    188
    |

    Zillow last checked: 8 hours ago

    Listing updated: March 06, 2026 at 10:46am

    Listed by:

    Gina A Dubell-Smith 513-477-1219,

    eXp Realty 866-212-4991

    Source: Cincy MLS,MLS#: 1866430MLS LogoOriginating 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
    Get pre-qualifiedBe ready to make an offer.
    Connect with an agentGet info on this home, tour, and more.
    Calculate monthly paymentSee if you can afford this home.

    Estimated market value

    Not available

    Estimated sales range

    Not available

    Not available

    Price history

    Price history
    DateEventPrice
    1/30/2026Listed for sale$5,950,000$599/sqft
    Source: Cincy MLS #1866430 Report a problem

    Public tax history

    Public tax history
    YearProperty taxesTax 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

    BuyAbility℠ payment

    Est. payment
    $36,576/mo
    Principal & interest
    $29386
    Property taxes
    $7190

      Climate risks

      Neighborhood: 45242

      Getting around

      0 / 100
      Car-Dependent
      0 / 100
      No Nearby Transit
      1 / 100
      Somewhat Bikeable

      Nearby schools

      GreatSchools rating

      Local experts in 45242