- Overview
- Description
- Property Details
- Location
- HOA Management
- Facts & Features
- Getting Around
- Nearby Homes
Street View
$499,000
Monthly Est:$2,484
3 Beds
2 Baths2 full baths
3,590sqft
142 E Clifton Ave, Cincinnati, OH 45202
$499,000
$2,484/moEst:
Get Pre-Approved
Condominium
Built in 1870
$120/mo HOA
0.05 acre lot
$139/sq.ft
Description
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.
- Houzeo last checked: 3 minutes ago
- Listing updated: January 23, 2026 at 2:51 am
- Listing Provided by: John J Harrison (513) 325-4403 | Endurance Realty & Investments
- Source: Cincinnati MLS-OH | MLS#: 1867097
Property Details
Status
Active
Type
Condominium
No. of Stories
-
County
City
Neighborhood
Year Built
1870
HOA Fees
$120/mo
Finished Area
3,590 sqft
Lot Size
0.05 acre lot
Basement Area
- sqft
MLS Name
Cincinnati MLS
MLS Number
1867097
MLS Status
Active
Days on Market
262
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
HOA Management
N/A
HOA Fees
$120/ Monthly
Amenities
Amenities and services may be covered by one or multiple associations and service providers.
Sewer
Trash Pickup
Water
Disclaimer: Amenities are based on third-party information and may vary; buyers must independently verify all amenities, as information is deemed reliable but not guaranteed.
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 3
Bathrooms: 2
Interior
Sewer
Public Sewer
Window Features
Vinyl
Cooling
Central Air
Heating
Gas
Construction
Year Built
Year Built: 1870
Home type
Condominium
Foundation Details
Stone
Roof
Shingle
Construction Materials
Brick
Architectural Style
Traditional
Utilities & Energy
Parking Features
None
Basement
None
Water Source
At Street
Price History
| Date | Event | Price |
|---|---|---|
01/23/2026 Source: | Listed for Sale | $499,000 +299.20% $139/sqft |
09/04/2020 Source: | Sold | $125,000 +242.47% $35/sqft |
03/18/2004 Source: | Listing Removed | $36,500 $10/sqft |
Nearby Homes
Find Homes by Property Features in Cincinnati, OH
Nearby New Homes For Sale
Based on information from the Multiple Listing Service of Greater Cincinnati (alternatively the REALTOR Alliance of Greater Cincinnati) through Oct 11, 2026, 07:15AM. IDX information is provided exclusively for consumers’ personal, non-commercial use, it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and the data is deemed reliable but is not guaranteed accurate by the MLS. The listings of some real estate brokerage firms have been excluded. The listing broker’s offer of compensation is made only to participants of the MLS where the listing is filed. Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved
Advertising Broker: Nicholas Huscroft | Chosen Realty