Investor-ready duplex with reliable tenants already in place, providing immediate rental income. Unit 2 has been recently remodeled with new flooring, fresh paint, updated kitchen cabinets, and modern appliances. All showings are subject to an accepted offer. Photos shown are of Unit 2 only. Lease Terms: Unit 1: $1,065/month | Lease 08/01/2024-08/01/2026 Unit 2: $1,295/month | Lease 12/22/2025-12/31/2026
For sale
$249,900
5214 Sidney Rd, Cincinnati, OH 45238
4beds
2,214sqft
Est.: Get pre-qualified
Multi Family, Duplex
Built in 1941
-- sqft lot
$-- Zestimate®
$113/sqft
$-- HOA
What's special
Modern appliancesFresh paintUpdated kitchen cabinetsNew flooring
- 3 days |
- 183 |
- 13 |
Likely to sell faster than
Zillow last checked:
Listing updated:
Listed by:
Coleen M. Garrett 513-509-4924,
3 B Realty Group LLC 513-278-7545,
Hayley A. Sunshine 937-654-7233,
3 B Realty Group LLC
Source: Cincy MLS,MLS#: 1880877
Originating MLS: Cincinnati Area Multiple Listing Service
Originating MLS: Cincinnati Area Multiple Listing Service
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 2
- Full bathrooms: 2
Heating
- Forced Air, Gas
Cooling
- Window Unit(s), Wall Unit(s)
Appliances
- Laundry: Individual Laundry
Features
- Windows: Aluminum Frames, Double Hung
- Basement: Full
- Has fireplace: Yes
- Fireplace features: Inoperable
Interior area
- Total structure area: 2,214
- Total interior livable area: 2,214 sqft
Property
Parking
- Total spaces: 2
- Parking features: Assigned, Off Street, Driveway
- Garage spaces: 2
- Has uncovered spaces: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Enclosed Porch
- Exterior features: Balcony
- Has view: Yes
- View description: City
Lot
- Size: 6,926 Square Feet
- Features: Busline Near
Details
- Parcel number: 5500041024500
- Zoning description: Multi Family
Construction
Type & style
- Home type: MultiFamily
- Property subtype: Multi Family, Duplex
Materials
- Aluminum Siding, Brick
- Foundation: Concrete Perimeter
- Roof: Shingle
Condition
- New construction: No
- Year built: 1941
Utilities & green energy
- Gas: Natural
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Security: Smoke Alarm
Location
- Region: Cincinnati
Financial & listing details
- Price per square foot: $113/sqft
- Tax assessed value: $156,600
- Annual tax amount: $3,574
- Date on market: 5/27/2026
- Listing terms: No Special Financing
- Total actual rent: 2345
- Tenant pays: Heat
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 5/28/2026 | Listed for sale | $249,900+21.9%$113/sqft |
Source:  Cincy MLS #1880877 Report a problem | ||
| 12/6/2025 | Listing removed | $1,295$1/sqft |
Source: Zillow Rentals Report a problem | ||
| 10/18/2025 | Listed for rent | $1,295$1/sqft |
Source: Zillow Rentals Report a problem | ||
| 3/3/2025 | Sold | $205,000+2.5%$93/sqft |
Source: Cincy MLS #1829269 Report a problem | ||
| 2/10/2025 | Pending sale | $200,000$90/sqft |
Source: Cincy MLS #1829269 Report a problem | ||
| 2/6/2025 | Listed for sale | $200,000+27.7%$90/sqft |
Source: Cincy MLS #1829269 Report a problem | ||
| 2/9/2023 | Sold | $156,600+49.1%$71/sqft |
Source: Public Record Report a problem | ||
| 12/13/2022 | Sold | $105,000+200%$47/sqft |
Source: Public Record Report a problem | ||
| 6/10/2011 | Sold | $35,000-32.7%$16/sqft |
Source: Cincy MLS #1261946 Report a problem | ||
| 5/13/2011 | Pending sale | $52,000$23/sqft |
Source: HUFF Realty, LLC #1261946 Report a problem | ||
| 3/30/2011 | Listed for sale | $52,000-35%$23/sqft |
Source: HUFF Realty, LLC #1261946 Report a problem | ||
| 3/11/2010 | Sold | $80,000-40.3%$36/sqft |
Source: Public Record Report a problem | ||
| 6/6/2002 | Sold | $134,000$61/sqft |
Source: Cincy MLS #782003 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $3,415 -0.2% | $54,810 |
| 2023 | $3,420 +20.9% | $54,810 +44.4% |
| 2022 | $2,830 +9% | $37,954 |
| 2021 | $2,597 | $37,954 |
| 2020 | $2,597 +0.2% | $37,954 +12% |
| 2019 | $2,592 +3.3% | $33,887 |
| 2018 | $2,509 | $33,887 |
| 2017 | $2,509 +149.1% | $33,887 +132.8% |
| 2016 | $1,007 | $14,554 |
| 2015 | $1,007 -0.5% | $14,554 |
| 2014 | $1,012 +2% | $14,554 -1% |
| 2013 | $993 +0.6% | $14,700 |
| 2012 | $987 +1.1% | $14,700 |
| 2011 | $976 -65.3% | $14,700 -69.4% |
| 2010 | $2,811 +2.5% | $47,989 |
| 2009 | $2,741 +1.8% | $47,989 |
| 2008 | $2,692 +16.6% | $47,989 -2% |
| 2007 | $2,308 +1.7% | $48,965 |
| 2006 | $2,271 -0.6% | $48,965 |
| 2005 | $2,285 -4.6% | $48,965 +3.1% |
| 2003 | $2,394 +7.8% | $47,495 |
| 2002 | $2,221 +28.8% | $47,495 +36.4% |
| 2001 | $1,724 +3% | $34,825 |
| 2000 | $1,675 | $34,825 |
Find assessor info on the county website
Monthly payment
Est. payment$--/mo
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.
Climate risks
Neighborhood: 45238
Nearby schools
GreatSchools rating
- 6/10Covedale Elementary SchoolGrades: PK-6Distance: 0.1 mi
- 3/10Western Hills University High SchoolGrades: 7-12Distance: 0.5 mi
- 3/10Gilbert A. Dater High SchoolGrades: 5,7-12Distance: 0.6 mi
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.
- Ohio
- Hamilton County
- Covedale
- 45238
- 5214 Sidney Rd
Nearby cities
Nearby zip codes
Other Covedale Topics
