Skip To Content

4000 Colerain Avenue

Cincinnati, OH 45223
  • $1
  • STATUS: Active
  • ON SITE: 254 Days
  • MLS #: 1846480
$1
  • 0
    BEDS
  • 0.06
    ACRES
  • 0
    BATHS
  • 0
    1/2 BATHS
Neighborhood:
Type:
Commercial-Lease
County:
Area:

School Ratings & Info

MLS of Greater Cincinnati logo

Description

Located in the heart of Northside, 4000 Colerain Ave offers a unique opportunity to lease a recently renovated mixed-use property with a rich historical background. Once the iconic Farmers Hotel, this building has been thoughtfully restored. The ground floor features nearly 2,000 square feet of white-boxed space, ready for the incoming tenant's vision. This space is well-suited for a boutique, creative office space, photography studio, or fitness concept. Six newly updated apartments above create a built-in community and provide steady foot traffic. Ownership requesting $18-20/psf for space

MLS of Greater Cincinnati logo The data relating to real estate for sale on this website comes in part from the Broker Reciprocityâ„¢ program of the Multiple Listing Service of Greater Cincinnati. Real estate listings held by brokerage firms other than Apex Group | Keller Williams are marked with the Broker Reciprocityâ„¢ logo (the small black house) and detailed information about them includes the name of the listing brokers. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but is not guaranteed accurate by the MLS or Apex Group | Keller Williams. Data last updated 2026-03-12T00:13:31.473.
www.searchnorthernkentucky.com/homes/165427278
Print Image

4000 Colerain Avenue Cincinnati, OH 45223

  • Price: $1
  • Status: Active
  • On Site: 254 Days
  • MLS #: 1846480
0
Beds
0
Baths
0
½ Baths
0.06
Acres
Neighborhood:
Northside
County:
Hamilton
Area:
Northside
Property Description
Located in the heart of Northside, 4000 Colerain Ave offers a unique opportunity to lease a recently renovated mixed-use property with a rich historical background. Once the iconic Farmers Hotel, this building has been thoughtfully restored. The ground floor features nearly 2,000 square feet of white-boxed space, ready for the incoming tenant's vision. This space is well-suited for a boutique, creative office space, photography studio, or fitness concept. Six newly updated apartments above create a built-in community and provide steady foot traffic. Ownership requesting $18-20/psf for space
Exterior Features

Access Roads Public Amount Onsite Parkng 0 Construction Materials Brick Docks 0 Frontage 0 Levels One Parking Features LotOn Street Roof Slate

Interior Features

Basement Partial Cooling Central Air Flooring Not Applicable Foundation Details Stone Heating CentralElectricGas Net Leasable Area 0 Office 0 Retail 2000 Warehouse 0

Property Features

Annual Taxes 1639.02 Auction No Documents Available Floor Plan Easements Of Record Gas Natural Gas And Electric 0 Gross Income 0 Lease Only Yes Mls Area Hamilton-W05 Net Operating Income 0 New Construction YN No Other Expense 0 Plans Available Yes Property Sub Type Retail Rentable 0 Sewer Public Sewer Site FreestandingCommercial Area Special Financing No Subdivision Name Northside Tenant Pays TaxesInsuranceCommon Area Main Township Cincinnati City Waste Removal 0 Water Sewer Expense 0 Water Source Public Zoning Commercial

MLS of Greater Cincinnati logo © 2026 MLS of Greater Cincinnati, Inc. All rights reserved. Listing courtesy of 3CRE Residential Advisors, LLC, and Rachel Thompson, . Information deemed reliable but not guaranteed.
MLS of Greater Cincinnati logo The data relating to real estate for sale on this website comes in part from the Broker Reciprocityâ„¢ program of the Multiple Listing Service of Greater Cincinnati. Real estate listings held by brokerage firms other than Apex Group | Keller Williams are marked with the Broker Reciprocityâ„¢ logo (the small black house) and detailed information about them includes the name of the listing brokers. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but is not guaranteed accurate by the MLS or Apex Group | Keller Williams. Data last updated 2026-03-12T00:13:31.473.
 
https://bt-photos.global.ssl.fastly.net/cincy/orig_boomver_1_1275758-2.jpg https://bt-photos.global.ssl.fastly.net/cincy/orig_boomver_1_1275758-2.jpg https://bt-photos.global.ssl.fastly.net/cincy/orig_boomver_1_1275758-2.jpg
Logo
Apex Group | Keller Williams
7210 Turfway Rd
Florence KY, 41042
MLS of Greater Cincinnati logo