• Resources
    • Learning Center
    • Blog
Add a Listing Advertise
  • Property Lists
  • Listings
    • Commercial Real Estate
  • Comparables
  • Owners
  • Maps
  1. Retail Space
  2. OH
  3. Cincinnati
  • Details
  • Spaces Available
  • Contacts
  • Location
  • POI
For Lease

Farmers Hotel

4000 Colerain Avenue, Cincinnati, OH 45223

2,440

SF Available
Northside Cincinnati Is a diverse and vibrant neighborhood known for its artistic community, historic architecture, and unique local businesses. Artistic and Cultural Scene: Northside is known for its thriving artistic community. The neighborhood features numerous art galleries, live music venues, and theaters, making it a hub for local artists and creatives. Local Businesses: The area boasts a variety of locally-owned businesses, including eclectic shops, restaurants, and bars. The emphasis on supporting local businesses contributes to a strong sense of community. Green Spaces: Northside has several parks and green spaces, including Hoffner Park, which hosts community events and gatherings. Access to green areas adds to the neighborhood's appeal and walkability. Public Transportation: The neighborhood has good access to public transportation, with bus routes connecting it to downtown Cincinnati and other parts of the city. Community Involvement: Northside is active and engaged, with numerous neighborhood associations and community groups continuously working to enhance the area. Development: Northside is actively attracting multifamily residences, retailers, and various other developments to revitalize its urban landscape and promote economic growth.3CRE is excited to present the opportunity of the Historic Farmer's Hotel in Northside! This mixed-use space comprises approximately 2,440 square feet of street-level retail space and six fully modernized apartments above. This space is a perfect mix of new construction while maintaining historic elements. The former hotel's commercial space offers a unique and exciting opportunity for various businesses, including retail stores, cocktail bars, and restaurants. This historic property was built in 1859 and is the oldest standing commercial building in Northside and the only remaining former hotel that housed farmers and their livestock during the 19th-century heyday of Porkopolis. Following the City Historic Landmark designation, the Hamilton County Landbank saved this structure from demolition and stabilized it for future redevelopment in 2014.

Key features

  • Corner of Colerain & Hoffner
  • Historical Building
  • Up and Coming Northside

Rental Details

  • Number of spaces 1
  • Total square feet available 2,440 SF
  • For Lease Contact for pricing
  • Space Types Retail
  • Lease Type NNN
  • Date Updated May 5, 2026
Want more info on this listing?

Reach out to the broker for more info on lease terms and amenities

True

For Lease 1 Space Available

First Floor Corner Retail

  • Space Type Retail
  • Lease Rate Contact for pricing
  • Total Space Available 2,440 SF
  • Divisible Space 2,440 - 2,440 SF
  • Available Date Immediate
  • Lease Type NNN
  • Renewal Option Yes
  • Sublease No
broker
Gabriela Costantini

3CRE Advisors

Contacts

broker
Gabriela Costantini

3CRE Advisors

Building Details

  • For Lease Contact for pricing
  • Property Type Retail - Freestanding
  • Property Size 7,515 SF
  • Lot Size 2,698 Acre
  • Property Tenancy Multi-Tenant
  • Year Built 1910
  • Year Renovated 2023
  • Date Updated May 5, 2026

Attachments

  • Property Brochure 1 ()opens in new window

Getting Around

  • Walk Score ®

    Very Walkable (84)
  • Transit Score ®

    Good Transit (50)
  • Bike Score ®

    Bikeable (64)
Powered by Walk Score ®

Location

  • City Cincinnati, OH
  • Neighborhood Northside Cincinnati
  • Zip Code 45223
  • Market Cincinnati
  • Map
  • Street

Points of Interest

Findlay Market–Race

3.31 miles

Findlay Market–Elm

3.32 miles

Cincinnati Union Terminal

3.41 miles

Liberty & Elm

3.46 miles

Liberty & Race

3.52 miles

14th & Elm

3.67 miles

Washington Park

3.80 miles

12th & Vine

3.85 miles

Hanke Exchange

3.91 miles

Marathon

0.42 miles

Shell

1.74 miles

Mobil

2.01 miles

Sunoco

2.05 miles

Clifton Court Garage Charging Station

2.24 miles

Daniels Street Fast Charger

2.58 miles

Thorntons

2.65 miles

FLO

3.29 miles

Clipper Creek

6.21 miles

Putz’s

1.27 miles

Merchant Parking

1.68 miles

Anchor Building

1.69 miles

Kirby Loop Trail Parking Area

1.73 miles

Lower Lot

1.74 miles

Upper Lot

1.78 miles

Clifton Court Garage

2.24 miles

Stratford Heights Parking Deck

2.26 miles

Woodside Garage

2.29 miles

Clifton Market

1.71 miles

Save-A-Lot

2.39 miles

Target

2.61 miles

Walmart Supercenter

3.54 miles

Kroger on the Rhine

3.99 miles

Burlington

4.04 miles

TJ Maxx

4.11 miles

Dillard’s Factory Direct

4.36 miles

SolarPanelsCincinnati.com

4.36 miles

4000 Colerain Avenue Listing Summary

  • The Price for Retail Space at 4000 Colerain Avenue

    The cost of renting retail space in a property highly depends on features such as its location, parking availability and type of retail space, or advantages and features that might be unique to it. For details on asking rent or information on other costs, use the contact form available on this page to reach out to the property representative.

    Reach out to the listing broker for information on best parking and other access options at or near the property.

    Recent renovations also contribute to the attractiveness of a retail property, which, in turn, influences rent. 4000 Colerain Avenue was last renovated in 2023.

  • Retail Space Options Available at 4000 Colerain Avenue

    The property exclusively contains Retail space totaling 2,440 square feet. The leasing opportunity here is available under NNN lease terms.

    In addition to retail space type, you will also need to consider the space size that you need for your business to operate at its best. You will find 1 retail space(s) ranging from 1,000 square feet to 10,000 square feet at 4000 Colerain Avenue, which can serve small or medium retail businesses that are planning to accommodate growth throughout the duration of their lease at this address. For more information or to schedule a tour of the property, reach out using the contact form on this page to get in touch with a broker.

Contact Listing Broker
broker
Gabriela Costantini

3CRE Advisors

  1. 1Main information
  2. 2Extra information
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Nearby Listings

3344 Central Parkway

3344 Central Parkway

3344 Central Parkway, Cincinnati, OH
Contact for pricing
Property
  • Retail
  • 13,621 SF
Availability
  • 1 Space
  • 6,371 SF
3300 Central Pkwy

3300 Central Pkwy

3300 Central Pkwy, Cincinnati, OH
Contact for pricing
Property
  • Retail
  • 5,785 SF
Availability
  • 1 Space
  • 5,785 SF
4770 Kenard Ave

4770 Kenard Ave

4770 Kenard Ave, Cincinnati, OH
$13.50/SF/YR
Property
  • Retail
  • 13,400 SF
Availability
  • 1 Space
  • 10,500 SF
Retail @ Hotel Celare

Retail @ Hotel Celare

310 Straight Street, Cincinnati, OH
Contact for pricing
Property
  • Retail
  • 134,000 SF
Availability
  • 3 Spaces
  • 13,902 SF
2356 Wyoming Ave

2356 Wyoming Ave

2356 Wyoming Ave, Cincinnati, OH
$4,500.00/MO
Property
  • Retail
  • 2,900 SF
Availability
  • 1 Space
  • 2,900 SF

Popular Searches

  • Columbus Retail Space for Lease
  • Cincinnati Retail Space for Lease
  • Indianapolis Retail Space for Lease
  • Louisville Retail Space for Lease
  • Dayton Retail Space for Lease
  • Lexington Retail Space for Lease
  • West Chester Retail Space for Lease
  • Norwood Retail Space for Lease
  • Blue Ash Retail Space for Lease
  • Newport Retail Space for Lease
  • Cincinnati Commercial Real Estate
  • Columbus Commercial Real Estate
  • Indianapolis Commercial Real Estate
  • Louisville Commercial Real Estate
  • Dayton Commercial Real Estate
  • Lexington Commercial Real Estate
  • West Chester Commercial Real Estate
  • Miamisburg Commercial Real Estate
  • Blue Ash Commercial Real Estate
  • Sharonville Commercial Real Estate
  • Indianapolis Office Space for Rent
  • Cincinnati Office Space for Rent
  • Columbus Office Space for Rent
  • Louisville Office Space for Rent
  • Dayton Office Space for Rent
  • Lexington Office Space for Rent
  • Blue Ash Office Space for Rent
  • West Chester Office Space for Rent
  • Sharonville Office Space for Rent
  • Miamisburg Office Space for Rent
Copyright 2003-2026, PropertyShark.com
Contact Us  |  About  |  Privacy Policy  |  Terms Of Service  |  Sitemaps