Date
Details
Price
Change
Source
9/10/2026
Listed
$550,000
—
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/38
$550,000
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/38
Property Description
Mixed-use investment opportunity in Columbia Tusculum! Commercial storefront currently operating as a tire shop with two residential rental units above. Unit 2 rents for $1200/mo and Unit 3 for $750/month. Rear storage and off-street parking. Zoned CC-M. Value-add potential in a prime Cincinnati location.
Full Property Details
Full Property Details for 333 Stanley Ave
General
- Price: $550,000
- Status: Active
- Type: Commercial Service
- Source: Cincinnati
- MLS ID: 1893403
- Updated: 9/10/2026
- Added to Site: 28 day(s) ago
Business
- Business Type: Retail
Interior
- Flooring: Concrete
Parking
- Parking: Lot, On-Site Parking
Location
- Area: Columbia/Tusculum
- County: Hamilton
- Township: Cincinnati City
- Driving Directions: From US-50, turn onto Stanley Ave. Property is the third building on the right.
- Location Details: Residential Area, Commercial Area
Heating & Cooling
- Central air: Yes
- Cooling Type: Central Air Conditioning
- Heating Type: Gas
- Heating Fuel: Natural
Utilities
- Sewer: Public Sewer
- Water: Public
Structural Information
- # Buildings: 1
- Architectural Style: Two Story
- Construction: Brick
- Basement Desc.: None
- Foundation: Slab
- Roof: Shingle
- Stories/Levels: Two
- Current Bldg. Use: Automotive, Commercial, Multi-Tenant
- Year Built: 1927
Lot Features
- Lot Size (Acres): 0.088
- Lot Size (Sq. Ft.): 3,833
- Lot Dimensions: 137 Irregular
- Frontage: City
- Frontage Feet: 4338
- Lot Access: Public
- Zoning: Commercial, See Remarks
Financial Considerations
- Tax Amount: $2, 323
Disclosures and Reports
- APN: 027-0001-0019-00
Listed by Comey & Shepherd (513) 231-2800, Laura Zembrodt (513) 231-2800
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agent
— 333 Stanley Ave —
Laura Zembrodt
Comey & Shepherd
513-231-2800
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 333 Stanley Ave
School District:Cincinnati City School District
| Name | Grades | Distance |
|---|---|---|
Riverview East Academy 3555 Kellogg Avenue, Cincinnati, OH 45226 | 9-12 | 0.3 mi |
Withrow University High School 2488 Madison Road, Cincinnati, OH 45208 | 7-12 | 2 mi |
Walnut Hills High School 3250 Victory Parkway, Cincinnati, OH 45207 | 7-12 | 2.9 mi |
Clark Montessori High School 3030 Erie Avenue, Cincinnati, OH 45208 | 7-12 | 1.7 mi |
Robert A. Taft Information Technology High School 420 Ezzard Charles Drive, Cincinnati, OH 45214 | 7-12 | 4.6 mi |
Hughes STEM High School 2515 Clifton Avenue, Cincinnati, OH 45219 | 7-12 | 4.6 mi |
Mt. Washington Elementary School, Cincinnati, OH 1730 Mears Avenue, Cincinnati, OH 45230 | PK-8 | 3.4 mi |
Shroder Paideia High School 5030 Duck Creek Road, Cincinnati, OH 45227 | 7-12 | 3.8 mi |
Woodward Career Technical High School 7005 Reading Road, Cincinnati, OH 45237 | 7-12 | 5.3 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 333 Stanley Ave
Tax History
Tax History for 333 Stanley Ave
Year
Property Taxes
Change
Tax Assessment
Change
2025
$2,323
1%
$27,311
—
2024
$2,308
—
$27,311
—
2023
$2,302
-1%
$27,311
7%
2021
$2,314
-2%
$25,512
—
2022
$2,371
2%
$25,512
—
2020
$2,314
1%
$25,512
9%
2019
$2,299
—
$23,405
—
2018
$2,301
3%
$23,405
—
2017
$2,226
-17%
$23,405
-16%
2016
$2,684
9%
$27,738
—
2015
$2,468
—
$27,738
—
2014
$2,477
-2%
$27,738
-2%
2013
$2,532
—
$28,305
—
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Estimate the Cost
Estimate the Cost for 333 Stanley Ave
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Commercial Service
- Active
Listed by Drew & 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 10 hours ago
- 3Beds
- 2Total Baths
- 1,841Sq. Ft.
Listed by Todd Blersch (513) 604-3138
- Single Family
- Active
- Updated 1 day ago
- 4Beds
- 1Total Bath
- 1,326Sq. Ft.
- Single Family
- Active
- Updated 1 day ago
- 2Beds
- 1Total Bath
- 1,034Sq. Ft.
- Single Family
- Active
- Updated 5 days ago
- 2Beds
- 1Total Bath
- 1,002Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 5 days ago
- 3Beds
- 2Total Baths
- 1,608Sq. Ft.
- Single Family
- Active
- Updated 2 days ago
- 2Beds
- 2Total Baths
- 1,758Sq. Ft.
- Single Family
- Active
- Updated 5 days ago
- 2Beds
- 2Total Baths
- 1,577Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Closed
- 3Beds
- 3Total Baths
- 1,916Sq. Ft.
Sold by Hinckley Group
- Single Family
- Closed
- 3Beds
- 3Total Baths
- 2,200Sq. Ft.
Sold by Finn Team
333 Stanley Avenue, Cincinnati, OH 45226 (MLS# 1893403) is a Commercial Service property. 333 Stanley Avenue is currently listed for $550,000 and was received on September 10, 2026. Want to learn more about 333 Stanley Avenue? Do you have questions about finding other Commercial Service real estate for sale in Columbia/Tusculum? You can browse all Columbia/Tusculum real estate or contact a Coldwell Banker agent to request more information.