$499,900
About this home
Don't miss the chance to add this lucrative property into your portfolio! Great location and just minutes from downtown Cleveland, this property includes the famous local Danny Mac's Irish Pub, two apartments on the upper level, beautifully updated with newer kitchen, floors, paint, and so much more! Additionally, there is a 3 bedroom 1 bath home right next to building along with a large newly paved parking lot! Make your showing today
Property details
- MLS #
- 5238229
- Property type
- MixedUse
- Subdivision
- Sherman Farms Companys Sub
- Status
- Active
- Days on market
- N/A
- On market date
- August 20, 2026
- Stories
- N/A
- Total bathrooms
- N/A
- Garage spaces
- N/A
- Parking spaces
- N/A
- Lot size
- 0.114 acres
Location
Get directions →Nearby schools
Within 10 miles. School directory data from the National Center for Education Statistics (NCES), accessed via the Urban Institute Education Data API. Local Score is calculated by INNOVATE Real Estate; where a state rating is shown, it comes from that state's own official school report card (e.g. NC Dept. of Public Instruction, SC Report Card).
- Enrollment
- 135
- Student:teacher ratio
- 12.3:1
- District
- Cleveland Preparatory Academy
- Enrollment
- 245
- Student:teacher ratio
- 24.5:1
- District
- Constellation Schools: Old Brooklyn Community Middle
- Enrollment
- 198
- Student:teacher ratio
- 16.5:1
- District
- Old Brook High School
Walkability
Blended score for Cleveland's center, calculated by INNOVATE Real Estate from two sources: the EPA's National Walkability Index (street network, transit, land-use mix) and Google Places amenity data (what's actually reachable on foot from this point). 60% EPA National Walkability Index + 40% nearby-amenity density (Google Places).
Market position
How this listing compares to current activity in Cleveland, from live MLS data.
Mortgage calculator
Estimate only - actual rate and payment depend on your lender, credit, and loan program.
Adjust tax / insurance estimates
Similar homes you might like
Data source: Listing information provided by NOWDD via Trestle/CoreLogic. Last updated August 20, 2026.
Information herein deemed reliable but not guaranteed; all measurements, school assignments, HOA fees, taxes, and feature lists are approximate and should be independently verified. Equal Housing Opportunity.