858 Hermosa Avenue
Cincinnati, OH 45238
- 5 beds
- 2 baths
- 2,884 sqft
- 6,273 sqft lot
- $92 per sqft
- 1927 build
- – on site
Amazing Turnkey Investment Opportunity – Fully Renovated in 2025! This updated 2-unit multifamily property is perfect for investors or owner-occupants. The downstairs unit features three spacious bedrooms and one bathroom, with updated flooring and appliances. The upstairs unit offers two bedrooms, one bathroom, and two balconies with beautiful views. Each unit has a private entrance, offering added privacy and flexibility. The property includes a full basement with a shared laundry area and ample storage. Major upgrades completed in 2025 include a new roof, HVAC system, plumbing, water heater, electrical panels, and energy-efficient vinyl windows. A new refrigerator and range/stove are also included. This move-in ready property combines modern comfort with long-term value. Don’t miss this turnkey opportunity!
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated May 6, 2025
•
MLS# 933524 —
The Building
-
Year Built:1927
-
Construction Materials:Brick
-
Building Area Total:2884.0
-
Exterior Features:Balcony,Fence,Porch
-
Patio And Porch Features:Balcony,Porch
-
Stories Total:2
-
Basement:Full
-
Basement:true
Room Dimensions
-
Living Area:2884.0
-
Living Area Source:Assessor
Financial & Terms
-
Availability Date:2025-05-05
Location
-
Directions:Glenway to west on Rapid Run to left on Hermosa to corner of St. Lawrence
-
Longitude:-84.594611
The Property
-
Property Type:ResidentialIncome
-
Property Sub Type:Duplex
-
Property Sub Type Additional:Duplex
-
Lot Size Acres:0.144
-
Lot Size Area:6273.0
-
Lot Size Dimensions:50x125
-
Lot Size Square Feet:6273.0
-
Lot Size Source:Assessor
-
Parcel Number:1790079006800
-
Zoning:Residential
-
Zoning Description:Residential
-
Latitude:39.110795
-
Fencing:Partial
Listing Agent
- Contact info:
- Agent phone:
- (937) 890-9111
- Office phone:
- (937) 890-9111
Taxes
-
Tax Legal Description:858 HERMOSA AV 49.48 X 125 LOT 65 RIDGEVIEW SUB
Beds
-
Bedrooms Total:5
Baths
-
Bathrooms Total:2
-
Bathrooms Full:2
Heating & Cooling
-
Heating:NaturalGas
-
Heating:true
-
Cooling:true
-
Cooling:CentralAir
Appliances
-
Appliances:Range,Refrigerator
Schools
-
High School District:Cincinnati
-
Elementary School District:Cincinnati
-
Middle Or Junior School District:Cincinnati
The Community
-
Subdivision Name:Ridgeview Sub
Parking
-
Garage:true
-
Garage Spaces:1.0
-
Parking Features:Garage,OneCarGarage
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Transit Score®
Provided by WalkScore® Inc.
Transit Score measures a location's access to public transit. It is based on nearby transit routes frequency, type of route (bus, rail, etc.), and distance to the nearest stop on the route. Transit Scores range from 0 (Minimal Transit) to 100 (Rider’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Max Internet Speed
Provided by BroadbandNow®
This is the maximum advertised internet speed available for this home. Under 10 Mbps is in the slower range, and anything above 30 Mbps is considered fast. For heavier internet users, some plans allow for more than 100 Mbps.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
5/6/25
May 6, 2025
|
Listed / Active | DABR | $268,000 |