You're browsing as guest. Top-line numbers are free. Full reports — owner contacts, refine, methodology — are paid. Guest mode. Top-line is free.
Back to Search
Property profile & analytics
OFF-MARKET
Investment properties

4034 Hamilton Ave Cincinnati, OH 45223-2667

2,738 SF 0.06 ac lot Built 1890
Entity Owned 2-yr Hold ~ Est. High Equity
Property ID
US66-6225082
Property summary
AI-generated overview

This exceptional mixed-use property at 4034 Hamilton Avenue in Cincinnati, Ohio, presents a lucrative investment opportunity. The 2,838 square foot building, constructed in 1890 and extensively renovated in 2012, currently operates as a thriving bar with 100% occupancy. The property boasts attractive vaulted ceilings and sits on a 0.06-acre lot, identified by APN 221-0013-0140. The building is a two-story structure, offering versatile space for both retail and bar operations. The permitted zoning is CC-P, providing flexibility for future uses. This turnkey operation requires minimal landlord involvement, with existing income in place, making it an ideal investment for passive income seekers. The property's prime location in Cincinnati, Ohio, within Hamilton County, zip code 45223, ensures high visibility and accessibility. Showings are available by appointment only. The asking price for this established and profitable business is $425,000. This is a rare opportunity to acquire a well-maintained, income-producing property in a desirable location.

Property profile
Verified
Property type Investment properties
Use group OFFICE/RESIDENTIAL (MIXED USE)
Year built 1890
Total area 2,738 SF
Lot 0.06 ac (2,788 SF)
APN 221-0013-0140-00
UPID US66-6225082
Cap rate & NOI
Priority signal for investors
Implied cap rate, NOI & suggested price
Cap rate vs submarket · NOI estimate · 3 price anchors
Implied cap rate, NOI & suggested price
Cap vs submarket · NOI estimate · 3 price anchors
Current use
Occupant on record · Public records
  • Red Rose Lounge Bar & Pub
  • Pour Lounge Bar & Pub Nightclub
  • Lunachick's Tarot & Astro Spiritual Center
Value estimations
Realmo proprietary · 4 methods
AI Approach AI
by Request
CAP Approach CAP
by Request
Comparable Approach Comparable
by Request
Blend (final) Blend
by Request
Owner & transaction history
Savannah Properties II LLC · 2 yrs held
Savannah Properties II LLC
since 2023
Last sale
$380,000
7 recorded transactions
2025
Price N/A
2023
$380,000
2021
$295,000
2020
Price N/A
2013
$125,000
2005
$120,000
2001
$130,000
Zoning & alternative use
Permitted uses
Permitted uses
Allowed · conditional · prohibited
Try Rey
Ask anything about this address in plain English.
“Is 15.6% cap rate sustainable?” · “Best tenant mix for BU1?” · “What’s the redev upside?”
You own 4034 Hamilton Ave?
List it free. Reach 20,000 daily buyers.
We’ve already pulled the facts. Confirm photos + price and you’re live in 2 minutes.
List this address →
More about this property
Thanks! Your message was sent.
Error! Your message wasn't sent.
Please enter your name
Please enter email
Please enter the email in the correct format
Please enter phone
Please enter the number in the correct format
Please enter message