This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
$238,000
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
Property Description
Mixed-Use Investment Opportunity.Presented at a 7.73% Cap Rate Investment opportunity with existing income Turnkey-ready property with income in place into 2026 Tenant responsible for base rent and partial reimbursements for expenses. Many major components have been upgraded or replaced, including HVAC, structural joists, permits and drawings, electrical systems, roofing, stairs, siding, fencing, windows, framing, abatement work, flooring,kitchen, appliances, parking lot, plumbing, drywall, and doors.
Full Property Details
Full Property Details for 4174 Hamilton Ave
General
- Sold For: $238,000
- Taxes: $3,449
- Status: Closed
- Type: Duplex
- Source: Cincinnati
- MLS ID: 1859915
- Added to Site: 81 day(s) ago
Rental Information
- Lease Info: Year Leases
Interior
- Appliances: Stove, Refrigerator, Oven, Dishwasher
Parking
- Parking: Public
Location
- Area: Northside
- County: Hamilton
- Driving Directions: North on Hamilton Ave past Northside business district; property located just north of Spring Grove Avenue on the west side of the street.
School Information
- School District: Cincinnati City SD
- High School District: Cincinnati City SD
Heating & Cooling
- Central air: Yes
- Cooling Type: Central Air Conditioning
- Separate Air Cond.: Yes
- Heating Type: Forced Air
- Heating Fuel: At Street
- Separate Furnace: Yes
Utilities
- Separate Gas/Elect: Yes
- Sewer: Public Sewer
- Water: At Street
Structural Information
- # Buildings: 1
- Architectural Style: Two Story
- Exterior Const.: Vinyl Siding, Wood Siding
- Basement: Yes
- Basement Desc.: Full
- Foundation: Stone
- Roof: Membrane
- Windows: Insulated
- Stories/Levels: Two
- Year Built: 1906
Unit Information
- 2 Bedroom Units: 1
- 2 Bedroom Sq. Ft.: 740
- 3 Bedroom Units: 1
- 3 Bedroom Sq. Ft.: 820
Unit 2
- Bedrooms: 2
Lot Features
- Lot Size (Acres): 0.068
- Lot Size (Sq. Ft.): 2,962
Financial Considerations
- Semi-Annual Taxes: $1724
- Tax Amount: $3,449
- Tenant Expense: Heat, Water
- Pays Heat: Tenant
- Pays Water: Tenant
Disclosures and Reports
- APN: 196-0022-0004-00
Listed by 3CRE Residential Advisors, LLC (513) 745-9333, Tryfon Christoforou (513) 745-9333
Sold by Comey & Shepherd (513) 777-2333, Scott Otten
Get Pre-Approved Today
Schools
Schools serving 4174 Hamilton 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.1 mi |
Walnut Hills High School 3250 Victory Parkway, Cincinnati, OH 45207 | 7-12 | 3.6 mi |
Hughes STEM High School 2515 Clifton Avenue, Cincinnati, OH 45219 | 7-12 | 2.6 mi |
Robert A. Taft Information Technology High School 420 Ezzard Charles Drive, Cincinnati, OH 45214 | 7-12 | 3.8 mi |
Gilbert A. Dater High School 2146 Ferguson Road, Cincinnati, OH 45238 | 7-12 | 4.2 mi |
Woodward Career Technical High School 7005 Reading Road, Cincinnati, OH 45237 | 7-12 | 4.4 mi |
Withrow University High School 2488 Madison Road, Cincinnati, OH 45208 | 7-12 | 4.9 mi |
Shroder Paideia High School 5030 Duck Creek Road, Cincinnati, OH 45227 | 7-12 | 7 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 4174 Hamilton Ave
Date
Details
Price
Change
Source
12/12/2025
Sold
$238,000
3.48%
MLS
10/27/2025
Listed
$230,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.
4174 Hamilton Avenue, Cincinnati, OH 45223 (MLS# 1859915) is a Duplex property that was sold at $238,000 on December 12, 2025. Want to learn more about 4174 Hamilton Avenue? Do you have questions about finding other Duplex real estate for sale in Northside? You can browse all Northside real estate or contact a Coldwell Banker agent to request more information.

