Search- Overview
- Sale & tax history
- Property details
- Neighborhood
5700 Roe St, Cincinnati, OH 45227
About this home
Public Remarks: Excellent development opportunity in hot Madisonville! Option to renovate existing historic structures, build SF homes, or combine lots to build multiple units. Property MUST be sold with adjoining parcels 036-0004-0021-00 & 036-0004-0020-00. Buildings sold as-is. If you want to view interior of buildings, you must call listing agent for access. Relative of owner of LLC is licensed realtor.

Redfin Estimate
Market trends in 45227, OH
Last updated September 2026
Buyer's Market
Seller's Market
Balanced market
- OPEN TODAY, 2:30PM TO 4:30PM
See all
Provided by Redfin
Sale history for 5700 Roe St
As the MLS and public records start to fill up, we'll list the details here.
Public record
Property details
Interior
- Accessibility Information
- Accessible Transit: City Street
Exterior
- Land Information
- Land Descriptions: Less than .5 Acre
- Frontage: 0.00
- Wooded: Cleared
- Zoning Details: Residential, See Remarks
- Lot Information
- Lot Area (Realist): 4,678
- Lot Size Dimensions: irregular
- Lot Size Units: Acres
- Lot Size Acres: 0.107
- Lot Size Sq. Ft.: 4,661
- Property Information
- Census Tract Realist: 55
- Elevation Description: Flat
Financial
- Tax Information
- Semi-Annual Taxes: $740.86
- Parcel Number: 036-0004-0022-00
- Other Tax Parcel ID: 036-0004-0021-00 & 036-0004-0020-00
Utilities
- Utility Information
- Water Source: Public
- Gas: Natural
- Sewer: Public Sewer
Location
- School Information
- School Name 1: Call SD 513-363-0000
- School Type 1: District Phone
- High School District: Cincinnati City SD
- Location Details
- Cross Street: Tompkins
- Suburb: Madisonville
- Directions: Erie to Roe, Corner of Roe and Tompkins
Public facts
- Beds: —
- Baths: —
- Sq. Ft.: —
- Stories: —
- Lot Size: —
- Style: Multi-Family (2-4 Unit)
- Year Built: —
- Year Renovated: —
- County: Hamilton County
- APN: —
Other
- Listing Information
- Listing URL: Listing URL (External Link)
- Auction: No
- FIPS Code: 61
- Picture Provided By: Photo Supplied
Around this home
Schools
Public K-6 • Assigned • 2.1mi
Public 8-12 • Assigned • 0.9mi
Lifestyle
Provided by Walk Score and Local Logic
Sun exposure
In this area, properties receive around 9.1 hours in June and 3.1 hours in December, placing it below the U.S. average for solar exposure.
Nearby similar homes
New listings for sale in 45227
Home values near 5700 Roe St
| Address | Redfin Estimate |
|---|---|
3 Beds | 2.5 Baths | 1443 Sq. Ft. | $363,190 |
3 Beds | 2.5 Baths | 1905 Sq. Ft. | $527,225 |
| Address | Redfin Estimate |
|---|---|
- Beds | - Baths | - Sq. Ft. | — |
3 Beds | 2.5 Baths | 1905 Sq. Ft. | $549,980 |
| Address | Redfin Estimate |
|---|---|
4 Beds | 2 Baths | 1958 Sq. Ft. | $232,757 |
3 Beds | 2.5 Baths | 1905 Sq. Ft. | $519,652 |
More real estate resources
- Neighborhoods
- Cities
- Zip Codes
- Popular Searches
| Madisonville homes for sale |
| West Chester homes for sale | |||
| Loveland homes for sale | |||
| Mason homes for sale |
| 45238 homes for sale | |||
| 45208 homes for sale | |||
| 45230 homes for sale | |||
| 45231 homes for sale | |||
| 45247 homes for sale |
Find us
Subsidiaries
Affiliated Business
Copyright: © 2026 Redfin. All rights reserved.
Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.
Do not sell or share my personal information.
REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.
California DRE #01521930
Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures
New Mexico Real Estate Licenses
TREC: Info About Brokerage Services, Consumer Protection Notice
All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.
Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.
If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.
REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

































United States
Canada