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.
33545742
33545749

4034 HAMILTON AVE, CINCINNATI, OH 45223

WG
Prodigy Properties
Listed by Prodigy Properties
Unpriced
1 day on market
Updated 1 day ago
Opportunity zone

4034 Hamilton Avenue

Details
APN 02210013014000
Property Type Retail
Sub Type Bar
Square Footage 2,738
Units 2
Cap Rate 10.24%
NOI $37,875
Year Built 1890
Stories 2
Acreage 0.060
Ground Lease No
Sale Condition Distressed

About This Property

Marketing description

Located in the heart of Cincinnati’s highly sought-after Northside neighborhood, 4034 Hamilton Avenue presents a rare opportunity to acquire a mixed-use investment property with immediate cash flow and value-add potential. This two-story brick asset features a fully leased ground-floor retail space occupied by an established local tenant and a vacant studio apartment that can be used for owner/tenant occupancy, or short-term rental use.

Positioned along the vibrant Hamilton Avenue corridor, the property benefits from exceptional visibility, strong pedestrian traffic, and convenient access to I-74, surrounded by Northside’s popular restaurants, entertainment venues, and independent retailers. Offering stable in-place income, a clear path to increased NOI through residential lease-up, and an attractive entry basis, 4034 Hamilton Avenue is an ideal opportunity for investors seeking both current returns and future upside.

Auction Date / Times

Auction Starts: Live Now

Auction Ends: July 14, 2026 @ 2pm ET

Sale Terms

  • A 10% (ten percent) buyer's premium will be added to the highest acceptable bid to determine the final purchase price
  • As-Is, Where-Is
  • Sold free and clear of all liens
  • Taxes are prorated of the day of closing
  • Receiver will convey insurable title
  • Financing contingencies are not permitted
  • Due diligence contingencies are not permitted
  • Subject to court approval
  • Winning bidder must wire a ten percent (10%) deposit to escrow holder by 11am ET July 15, 2026

Listing Contacts

WG
Prodigy Properties
Listed by Prodigy Properties

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
$37,875.00
$3,156.25/mo

Valuation Metrics

0
DSCR
--
Cap Rate
--
ROI

Map

Broker Selected Comps View More Comps

Property History

Intelligence Badge

Tax History

Intelligence Badge

Similar Properties

View All
*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