Date
Details
Price
Change
Source
6/24/2025
Listed
$1
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/29
$1
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/29
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
Full Property Details
Full Property Details for 4000 Colerain Ave
General
- Price: $1
- Taxes: $1,639
- Status: Active
- Type: Commercial Lease
- Source: Cincinnati
- MLS ID: 1846480
- Updated: 6/30/2025
- Added to Site: 207 day(s) ago
Interior
- Flooring: Not Applicable
Parking
- Parking: Lot, On-Street Parking
Location
- Area: Northside
- County: Hamilton
- Township: Cincinnati City
- Driving Directions: From Blue Rock, L on Colerain
- Location Details: Freestanding, Commercial Area
Heating & Cooling
- Central air: Yes
- Cooling Type: Central Air Conditioning
- Heating Type: Central, Electric, Gas
- Heating Fuel: Natural
Utilities
- Sewer: Public Sewer
- Water: Public
Structural Information
- # Buildings: 1
- Architectural Style: One Story
- Construction: Brick
- Basement: Yes
- Basement Desc.: Partial
- Foundation: Stone
- Roof: Slate
- Stories/Levels: One
- Retail: 2,000 Sq. Ft.
Lot Features
- Lot Size (Acres): 0.062
- Lot Size (Sq. Ft.): 2,701
- Lot Access: Public
- Zoning: Commercial
Financial Considerations
- Tax Amount: $1,639.02
- Tenant Pays: Taxes, Insurance, Common Area Main
- Tenant Expense: Taxes, Insurance, Common Area Main
Disclosures and Reports
- Documents Avail.: Floor Plan
- Plans Available: Yes
- APN: 194-0012-0027-00
Listed by 3CRE Residential Advisors, LLC (513) 745-9333, Rachel Thompson
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agent
— 4000 Colerain Ave —
Rachel Thompson
3CRE Residential Advisors, LLC
513-745-9333
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 4000 Colerain Ave
School District:Cincinnati City School District
| Name | Grades | Distance |
|---|---|---|
Chase School 4151 Turrill Street, Cincinnati, OH 45223 | PK-6 | 0.2 mi |
Aiken New Tech High School 5641 Belmont Avenue, Cincinnati, OH 45224 | 7-12 | 2.3 mi |
Walnut Hills High School 3250 Victory Parkway, Cincinnati, OH 45207 | 7-12 | 3.7 mi |
Hughes STEM High School 2515 Clifton Avenue, Cincinnati, OH 45219 | 7-12 | 2.4 mi |
Robert A. Taft Information Technology High School 420 Ezzard Charles Drive, Cincinnati, OH 45214 | 7-12 | 3.6 mi |
Gilbert A. Dater High School 2146 Ferguson Road, Cincinnati, OH 45238 | 7-12 | 3.8 mi |
Woodward Career Technical High School 7005 Reading Road, Cincinnati, OH 45237 | 7-12 | 4.8 mi |
Withrow University High School 2488 Madison Road, Cincinnati, OH 45208 | 7-12 | 5.1 mi |
Shroder Paideia High School 5030 Duck Creek Road, Cincinnati, OH 45227 | 7-12 | 7.3 mi |
Disclaimer:
School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 4000 Colerain Ave
Estimate the Cost
Estimate the Cost for 4000 Colerain Ave
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Commercial Lease
- Active
Listed by The Drew and Ingrid Group
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 2 days ago
- 2Beds
- 1Total Bath
- 990Sq. Ft.
Listed by Edward Lindenschmidt (513) 207-1040
- Single Family
- Active
- Updated 2 days ago
- 3Beds
- 1Total Bath
- 1,248Sq. Ft.
Listed by The Twin Team
- Single Family
- Active
- Updated 2 days ago
- 3Beds
- 2Total Baths
- 1,572Sq. Ft.
Listed by Todd Blersch (513) 604-3138
- Single Family
- Active
- Updated 8 hours ago
- 1Bed
- 1Total Bath
- 570Sq. Ft.
Listed by Nicole Rankin (859) 394-4930
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 1 day ago
- 3Beds
- 2Total Baths
- 1,886Sq. Ft.
- Single Family
- Active
- Updated 3 days ago
- 2Beds
- 2Total Baths
- 1,039Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
4000 Colerain Avenue, Cincinnati, OH 45223 (MLS# 1846480) is a Commercial Lease property. 4000 Colerain Avenue is currently listed for $1 and was received on June 24, 2025. Want to learn more about 4000 Colerain Avenue? Do you have questions about finding other Commercial Lease real estate for sale in Northside? You can browse all Northside real estate or contact a Coldwell Banker agent to request more information.