Skip main navigation
For sale
    • $499,000

    142 E Clifton Ave, Cincinnati, OH 45202

    3beds
    3,590sqft
    : 
    $3,793/mo
    Get pre-qualified
    Condominium
    Built in 1870
    -- sqft lot
    $-- Zestimate®
    $139/sqft
    $120/mo HOA

    What's special

    Designer-quality upgrades throughoutNew flooringNew kitchen islandModern stainless-steel appliancesNew windowsNew furnace
    Welcome to this majestic and eloquent three-bedroom condo, a truly special place filled with warmth, character, and timeless charm, located in Over the Rhine, just a 5 minutes' walk to downtown Cincinnati, and minutes by car to Newport and Covington! This home has been thoughtfully redesigned with expert craftsmanship, featuring designer-quality upgrades throughout with no expense spared. The property has been extensively reimagined and fully rehabilitated from top to bottom, seamlessly blending historic character with modern luxury. Exposed original brick walls add authentic charm, while modern stainless-steel appliances and contemporary finishes deliver both style and functionality. Property was taken down to the studs and major systems have all been updated for peace of mind, including new windows, new furnace, electrical, plumbing, new flooring, Cabinets, New Kitchen Island So you can enjoy the beauty of the home without the worry of future maintenance.
    189 days
    |
    120
    |
    2
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    John J. Harrison 513-325-4403,

    Endurance Realty & Investments 513-325-4403

    Source: Cincy MLS,MLS#: 1867097MLS LogoOriginating MLS: Cincinnati Area Multiple Listing Service

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 2
      • Full bathrooms: 2
      Primary bedroom
      • Level: Second
      • Area: 140
      • Dimensions: 10 x 14
      Bedroom 2
      • Level: Second
      • Area: 132
      • Dimensions: 11 x 12
      Bedroom 3
      • Level: Second
      • Area: 88
      • Dimensions: 8 x 11
      Bedroom 4
      • Area: 0
      • Dimensions: 0 x 0
      Bedroom 5
      • Area: 0
      • Dimensions: 0 x 0
      Primary bathroom
      • Features: Tub w/Shower, Marb/Gran/Slate
      Bathroom 1
      • Features: Full
      • Level: Second
      Bathroom 2
      • Features: Full
      • Level: First
      Dining room
      • Level: First
      • Area: 169
      • Dimensions: 13 x 13
      Family room
      • Area: 0
      • Dimensions: 0 x 0
      Kitchen
      • Area: 143
      • Dimensions: 13 x 11
      Living room
      • Area: 0
      • Dimensions: 0 x 0
      Office
      • Area: 0
      • Dimensions: 0 x 0
      Heating
      • Gas
      Cooling
      • Central Air
      Appliances
      • Included: Gas Water Heater
      Features
      • Windows: Vinyl
      • Basement: None
      Interior area
      • Total structure area: 3,590
      • Total interior livable area: 3,590 sqft

      Property

      Parking
      • Parking features: None
      Features
      • Levels: Two
      • Stories: 2
      Lot
      • Size: 2,352 Square Feet
      • Dimensions: 30 x 79
      Details
      • Parcel number: 0940005025000
      • Zoning description: Residential

      Construction

      Type & style
      • Home type: Condo
      • Architectural style: Traditional
      • Property subtype: Condominium
      Materials
      • Brick
      • Foundation: Stone
      • Roof: Shingle
      Condition
      • New construction: No
      • Year built: 1870

      Utilities & green energy

      • Gas: Natural
      • Sewer: Public Sewer
      • Water: At Street

      Community & HOA

      HOA
      • Has HOA: Yes
      • Services included: Sewer, Trash, Water
      • HOA fee: $120 monthly
      Location
      • Region: Cincinnati

      Financial & listing details

      • Price per square foot: $139/sqft
      • Tax assessed value: $125,000
      • Annual tax amount: $2,774
      • Date on market: 1/22/2026
      • Listing terms: No Special Financing

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        1/23/2026Listed for sale$499,000+299.2%$139/sqft
        Source: Cincy MLS #1867097 Report a problem
        9/4/2020Sold$125,000$35/sqft
        Source: Cincy MLS #1669300 Report a problem
        7/21/2020Pending sale$125,000$35/sqft
        Source: Comey & Shepherd #1669300 Report a problem
        7/21/2020Listed for sale$125,000+6150%$35/sqft
        Source: Comey & Shepherd #1669300 Report a problem
        12/30/1988Sold$2,000$1/sqft
        Source: Agent Provided Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2024$2,774 -0.2%$43,750
        2023$2,779 +170.2%$43,750 +202.1%
        2022$1,028 -3.2%$14,483
        2021$1,062 +5%$14,483
        2020$1,011 +47.1%$14,483 +62.2%
        2019$688 +3.9%$8,928 0%
        2018$662 $8,929
        2017$662 +135.1%$8,929 +129.2%
        2016$282 +4.9%$3,896
        2015$268 -0.5%$3,896
        2014$270 -0.6%$3,896 +1%
        2013$271 +2.2%$3,857
        2012$265 +1.5%$3,857
        2011$262 +1%$3,857 -6.9%
        2010$259 +1.7%$4,141
        2009$255 +1.4%$4,141
        2008$251 +16.1%$4,141 +2%
        2007$216 -3.9%$4,060
        2006$225 +4.1%$4,060
        2005$216 -0.4%$4,060 +8.4%
        2003$217 +6.7%$3,745
        2002$203 +4.6%$3,745 +11.5%
        2001$194 +3%$3,360
        2000$189 $3,360
        Find assessor info on the county website

        Monthly payment

        Est. payment

        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.
        Get pre-qualified

        Climate risks

        Neighborhood: Over-The-Rhine

        Getting around

        90 / 100
        Walker's Paradise
        69 / 100
        Good Transit
        48 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        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.

        Browse local experts

        Similar homes

              Nearby cities

              Nearby neighborhoods

              Nearby zip codes

              Other Cincinnati Topics

                Search
                Updates
                Favorites
                Plan
                Inbox