Investor opportunity in prime Clifton location near University of Cincinnati, hospitals, and downtown. This updated 4-5 bed, 2.5 bath property offers strong in-place income with a lease secured at $2,800/month through July 2027 (tenant pays utilities). Current lease at $2,500/month with owner-paid utilities provides immediate occupancy with upside built in. Recent improvements include new furnace, A/C, siding, and a fully updated kitchen with new cabinets and countertops. Unique rooftop porches and flexible layout enhance tenant appeal. Off-street parking adds value in this high-demand rental area. Ideal for investors seeking a stabilized asset with long-term appreciation, strong rental demand, and operational upside in one of Cincinnati's most consistent rental corridors.
For sale
Price cut: $15K (6/23)
$320,000
404 Warner St, Cincinnati, OH 45219
4beds
1,956sqft
Single Family Residence
Built in 1905
2,526 Square Feet Lot
$-- Zestimate®
$164/sqft
$-- HOA
What's special
Fully updated kitchenFlexible layoutOff-street parkingUnique rooftop porchesNew cabinets and countertopsNew furnace
- 204 days |
- 210 |
- 10 |
Zillow last checked:
Listing updated:
Listed by:
Julie Rose 513-317-7452,
Coldwell Banker Realty 513-922-9400
Source: Cincy MLS,MLS#: 1848832
Originating MLS: Cincinnati Area Multiple Listing Service

Loading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Features: Other
- Level: First
- Area: 135
- Dimensions: 15 x 9
Bedroom 2
- Level: First
- Area: 135
- Dimensions: 15 x 9
Bedroom 3
- Level: Second
- Area: 150
- Dimensions: 15 x 10
Bedroom 4
- Level: Second
- Area: 135
- Dimensions: 15 x 9
Bedroom 5
- Area: 0
- Dimensions: 0 x 0
Primary bathroom
- Features: Other
Bathroom 1
- Features: Full
- Level: Second
Bathroom 2
- Features: Full
- Level: Second
Bathroom 3
- Features: Partial
- Level: First
Dining room
- Area: 0
- Dimensions: 0 x 0
Family room
- Area: 0
- Dimensions: 0 x 0
Kitchen
- Features: Solid Surface Ctr, Wood Cabinets
- Area: 210
- Dimensions: 15 x 14
Living room
- Area: 0
- Dimensions: 0 x 0
Office
- Area: 0
- Dimensions: 0 x 0
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Dishwasher, Oven/Range, Refrigerator, Gas Water Heater
Features
- High Ceilings, Recessed Lighting
- Windows: Vinyl
- Basement: None
Interior area
- Total structure area: 1,956
- Total interior livable area: 1,956 sqft
Property
Parking
- Parking features: On Street, Driveway
- Has uncovered spaces: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Porch
Lot
- Size: 2,526 Square Feet
- Features: Less than .5 Acre
Details
- Parcel number: 0970002010200
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence
Materials
- Vinyl Siding
- Foundation: Block
- Roof: Shingle
Condition
- New construction: No
- Year built: 1905
Utilities & green energy
- Gas: Natural
- 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: $164/sqft
- Tax assessed value: $151,100
- Annual tax amount: $3,348
- Date on market: 7/21/2025
- Listing terms: No Special Financing
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 6/23/2026 | Price change | $320,000-4.5%$164/sqft |
Source: | ||
| 6/9/2026 | Price change | $335,000-4.3%$171/sqft |
Source: | ||
| 3/19/2026 | Listed for sale | $350,000+3%$179/sqft |
Source: | ||
| 1/12/2026 | Listing removed | $2,800$1/sqft |
Source: Zillow Rentals Report a problem | ||
| 12/28/2025 | Price change | $2,800-12.5%$1/sqft |
Source: Zillow Rentals Report a problem | ||
| 11/18/2025 | Listed for rent | $3,200$2/sqft |
Source: Zillow Rentals Report a problem | ||
| 11/10/2025 | Listing removed | $3,200$2/sqft |
Source: Zillow Rentals Report a problem | ||
| 10/22/2025 | Listing removed | $339,900$174/sqft |
Source: | ||
| 9/26/2025 | Listed for rent | $3,200+481.8%$2/sqft |
Source: Zillow Rentals Report a problem | ||
| 9/18/2025 | Listing removed | $550 |
Source: Zillow Rentals Report a problem | ||
| 9/16/2025 | Price change | $550-15.4% |
Source: Zillow Rentals Report a problem | ||
| 9/15/2025 | Price change | $339,900-4.3%$174/sqft |
Source: | ||
| 9/2/2025 | Price change | $355,000-2.7%$181/sqft |
Source: | ||
| 7/30/2025 | Price change | $650-80.3% |
Source: Zillow Rentals Report a problem | ||
| 7/21/2025 | Listed for sale | $365,000+128.1%$187/sqft |
Source: | ||
| 5/15/2025 | Price change | $3,300-12%$2/sqft |
Source: Zillow Rentals Report a problem | ||
| 2/28/2025 | Price change | $3,750-3.2%$2/sqft |
Source: Zillow Rentals Report a problem | ||
| 1/8/2025 | Listed for rent | $3,875$2/sqft |
Source: Zillow Rentals Report a problem | ||
| 12/4/2024 | Listing removed | $3,875$2/sqft |
Source: Zillow Rentals Report a problem | ||
| 10/24/2024 | Listed for rent | $3,875+10.7%$2/sqft |
Source: Zillow Rentals Report a problem | ||
| 11/27/2023 | Listing removed | -- |
Source: Zillow Rentals Report a problem | ||
| 11/6/2023 | Listed for rent | $3,500$2/sqft |
Source: Zillow Rentals Report a problem | ||
| 8/4/2023 | Sold | $160,000$82/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $3,349 -0.2% | $52,885 |
| 2023 | $3,355 +30.6% | $52,885 +45.3% |
| 2022 | $2,568 +1.7% | $36,397 |
| 2021 | $2,525 | $36,397 +0% |
| 2020 | $2,525 +3.4% | $36,396 +14% |
| 2019 | $2,441 +3.8% | $31,927 |
| 2018 | $2,351 | $31,927 |
| 2017 | $2,351 -4.8% | $31,927 -12.8% |
| 2016 | $2,471 | $36,632 |
| 2015 | $2,471 -0.5% | $36,632 |
| 2014 | $2,484 +9.1% | $36,632 +11% |
| 2013 | $2,277 +2.3% | $33,002 |
| 2012 | $2,227 +1.5% | $33,002 |
| 2011 | $2,193 +3.6% | $33,002 -4.6% |
| 2010 | $2,117 +1.7% | $34,605 |
| 2009 | $2,081 +1.5% | $34,605 |
| 2008 | $2,051 +22.1% | $34,605 +7% |
| 2007 | $1,680 +1.1% | $32,340 |
| 2006 | $1,662 -1.1% | $32,340 |
| 2005 | $1,681 +7.5% | $32,340 +17.4% |
| 2003 | $1,563 +6.7% | $27,545 |
| 2002 | $1,465 +2.8% | $27,545 +9.6% |
| 2001 | $1,425 -0.6% | $25,130 |
| 2000 | $1,434 | $25,130 |
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: CUF
Nearby schools
GreatSchools rating
- 7/10Clifton Area Neighborhood SchoolGrades: PK-6,8Distance: 1.8 mi
- 3/10Hughes STEM High SchoolGrades: 7-12Distance: 0.3 mi
- 3/10Robert A. Taft Information Technology High SchoolGrades: 7-12Distance: 1.1 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
- Cincinnati
- 45219
- CUF
- 404 Warner St






