www.crexi.com - The Commercial Real Estate Exchange
Subscribe to Intelligence for full access
Analyze more property details including ownership and financial history. Share advanced property insights with your clients and teams.
Subscribe to Intelligence for full access
Analyze more property details including ownership and financial history. Share advanced property insights with your clients and teams.
23437549
23437550

3801 Harrison Ave, Cincinnati, OH 45211

JD
OH OH BRKP.0000209660, KY 194842
Dwyer Commercial Real Estate
MM
OH 2023003061
Dwyer Commercial Real Estate
Listed by Dwyer Commercial Real Estate
Unpriced
654 days on market
Updated 87 days ago

Legends Bar & Venue

Details
APN 551-0007-0268 and -0395
Property Type Mixed Use, Multifamily (+1)
Sub Type Bar, Event Venue (+1)
Square Footage 9,243
Net Rentable (SqFt) 9,243
Units 5
Occupancy 100%
Tenancy Multi
Lease Expiration 09/30/2024
Lease Options 3
Class B
Year Built 1939
Year Renovated 2020
Buildings 1
Stories 2
Acreage 0.284
Zoning B-OZ
Investment Type Owner/User
Occupancy Date 10/01/2024
Ground Lease No
Ownership Private

Entertainment Venue Available

Marketing description

  • A 300+ seating capacity venue designed for high-volume entertainment and events.

  • A 75-foot bar optimized for speed of service and maximum patron engagement.

  • Large outdoor patio featuring a secondary bar, perfect for seasonal transitions and the DORA "walk-around" crowd.

  • Equipped with a dedicated stage, multiple restrooms, and an open layout suitable for live music, comedy, or corporate bookings.

Investment highlights

  • Mixed-Use Structure: A ±9,243 SF building featuring a premier first-floor entertainment venue with four residential apartments above.

  • HUGE 75-foot bar, professional stage, and a 300+ person seating capacity, making it ideal for large-scale events, live music, or nightlife.

  • Premium Outdoor Amenities: Includes a large outdoor patio with its own dedicated bar.

  • Residential Income Stream: Four well-distributed units providing immediate diversification:

    • (2) 2-Bedroom Units

    • (1) 1-Bedroom Unit

    • (1) Efficiency Unit

Cheviot Designated Outdoor Refreshment Area, driving significant foot traffic and synergy with neighboring bars and restaurants.

Cheviot Business District with excellent walkability for residents and patrons.

Ownership is open to Creative Seller Financing (including Lease-to-Own options) and is also open to leasing the property to a qualified operator.

Listing Contacts

JD
OH OH BRKP.0000209660, KY 194842
Dwyer Commercial Real Estate
MM
OH 2023003061
Dwyer Commercial Real Estate
Listed by Dwyer Commercial Real Estate

Valuation Calculator

Login or Sign up to see Valuation Metrics
Sign up for Crexi to see valuation metrics for this property
$
$
%
Loan Amount
$--
Annual Debt Service
$--
$--
Annual Cash Flow
$--
$--

Valuation Metrics

0
DSCR
--
Cap Rate
--
ROI

Map

Zoning

Intelligence Badge
B-OZ OverlayBusiness Overlay Zone
View municipality zoning documents
Upgrade to see the zone description and what's allowed on this property
Upgrade to search and view land use codes
View all 84 uses
View all 84 uses
Last updated Apr 15, 2026 For deeper zoning details, reports are available at Zoneomics

Broker Selected Comps View More Comps

Property History

Intelligence Badge

Tax History

Intelligence Badge

Similar Properties

View All

Additional Information

Name
John Dwyer
License
OH BRKP.0000209660
Brokerage
Dwyer CRE
Brokerage Phone
5137841776
Title
Broker
Brokerage Address
2998 Colerain Avenue
Name
Matt Morris
License
2023003061
Brokerage
Dwyer CRE
Brokerage Phone
513.784.1776
Title
Vice President
Brokerage Address
2928 Colerain Avenue
*All information is deemed reliable but not guaranteed. Buyer to verify all information.
Is there information that looks off?
For assistance, reach out to our support team at [email protected] or call 888.273.0423 . For press inquiries, contact [email protected]
Equal Housing Opportunity
5510 Lincoln Blvd #400, Los Angeles, CA 90094Commercial Real Estate Exchange, Inc.Crexi Technologies, LLCCXTechnology, LLC
© 2026 Commercial Real Estate Exchange, Inc. All Rights Reserved. DRE #02086591