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.
    69 days
    |
    4,046
    |
    125
    |

    Zillow last checked: 7 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

        Monthly payment

        Est. payment
        $37,874/mo
        Principal & interest
        $30684
        Property taxes
        $7190
        More affordability tools

          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