4174 Hamilton Ave | Cincinnati, OH 45223
This feature is unavailable at the moment.
We apologize, but the feature you are trying to access is currently unavailable. We are aware of this issue and our team is working hard to resolve the matter.
Please check back in a few minutes. We apologize for the inconvenience.
- LoopNet Team
This Retail Property is no longer advertised on LoopNet.com.
4174 Hamilton Ave
Cincinnati, OH 45223
Retail Property For Sale

INVESTMENT HIGHLIGHTS
- Presented at a 7.73% Cap Rate
- Investment opportunity with existing income
- Current NOI: $17,788.00
- Many major components have been upgraded or replaced
PROPERTY FACTS
Property Type
Retail
Property Subtype
Storefront Retail/Residential
Building Size
1,504 SF
Building Class
C
Year Built/Renovated
1906/2024
Tenancy
Multiple
Building Height
2 Stories
Building FAR
0.49
Lot Size
0.07 AC
Zoning
CCP - 404 - RETAIL/APARTMENT OVER
Parking
2 Spaces (1.43 Spaces per 1,000 SF Leased)
Frontage
22’ on Hamilton Ave
AMENITIES
- Tenant Controlled HVAC
- Recessed Lighting
- Air Conditioning
PROPERTY TAXES
| Parcel Number | 196-0022-0004 | Improvements Assessment | $37,503 |
| Land Assessment | $4,207 | Total Assessment | $41,710 |
PROPERTY TAXES
Parcel Number
196-0022-0004
Land Assessment
$4,207
Improvements Assessment
$37,503
Total Assessment
$41,710
Listing ID: 38204540
Date on Market: 10/24/2025
Last Updated:
Address: 4174 Hamilton Ave, Cincinnati, OH 45223
The Northside Retail Property at 4174 Hamilton Ave, Cincinnati, OH 45223 is no longer being advertised on LoopNet.com. Contact the broker for information on availability.
RETAIL PROPERTIES IN NEARBY NEIGHBORHOODS
NEARBY LISTINGS
- 3389 Glenmore Ave, Cincinnati OH
- 3415 Glenmore Ave, Cincinnati OH
- 3186 Harrison Ave, Cincinnati OH
- 911 E McMillan St, Cincinnati OH
- 268 W McMicken Ave, Cincinnati OH
- 2024 Mohawk Pl, Cincinnati OH
- 1778 Central Ave, Cincinnati OH
- 405 Riverboat Row, Newport KY
- 1440 Main St, Cincinnati OH
- 1824 Elm St, Cincinnati OH
- 5209 Glenway Ave, Cincinnati OH
- 811 Race St, Cincinnati OH
- 3344 Central Pky, Cincinnati OH
- 5709 Cheviot Rd, White Oak OH
- 2075 Mills Ave, Norwood OH
1 of 1
VIDEOS
MATTERPORT 3D EXTERIOR
MATTERPORT 3D TOUR
PHOTOS
STREET VIEW
STREET
MAP

Link copied
Your LoopNet account has been created!
Thank you for your feedback.
Please Share Your Feedback
We welcome any feedback on how we can improve LoopNet to better serve your needs.X
{{ getErrorText(feedbackForm.starRating, "rating") }}
255 character limit ({{ remainingChars() }} charactercharacters remainingover)
{{ getErrorText(feedbackForm.msg, "rating") }}
{{ getErrorText(feedbackForm.fname, "first name") }}
{{ getErrorText(feedbackForm.lname, "last name") }}
{{ getErrorText(feedbackForm.phone, "phone number") }}
{{ getErrorText(feedbackForm.phonex, "phone extension") }}
{{ getErrorText(feedbackForm.email, "email address") }}
You can provide feedback any time using the Help button at the top of the page.