Date
Details
Price
Change
Source
3/27/2026
Listed
$495,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/20
$495,000 Just Listed
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/20
Property Description
Turnkey investment opportunity in a prime, high demand location! This well maintained 3 family building features two spacious 2 bedroom units and one efficiency/studio, just perfect for maximizing income potential. Currently, one 2 bedroom and the studio are leased, offering immediate cash flow, while the remaining 2 bedroom unit is vacant and ready for an owner occupant or additional rental income. Ideal for house hacking or expanding your portfolio. Situated between Oakley and Madisonville, right near Red Bank & Madison Rd, the Medpace Madison Square Campus, Element Eatery, and lots of popular ongoing development, plus quick access to Oakley Station and beyond. A rare blend of location, flexibility, and opportunity!
Full Property Details
Full Property Details for 4947 Charlemar Dr
General
- Price: $495,000
- Status: Active
- Type: Triplex
- Source: Cincinnati
- MLS ID: 1872790
- Updated: 3/27/2026
- Added to Site: 5 day(s) ago
Rental Information
- Lease Info: see attached docs
Interior
- Interior Features: Coin Laundry
- Appliances: ranges, fridges, dishwashers, W/D
Additional Information
- Other Features: Coin Laundry
Exterior
- Exterior Features: Metal Fence
Parking
- Parking: Driveway, Garage
- Garage Description: Built-In, Front
Location
- Area: Madisonville
- County: Hamilton
- Township: Cincinnati City
- Cross Streets: Madison Road
- Driving Directions: West on Madison Road, left on Charlemar Drive
School Information
- School District: Cincinnati City SD
- High School District: Cincinnati City SD
Heating & Cooling
- Central air: Yes
- Cooling Type: Central Air Conditioning, Wall Unit
- Separate Air Cond.: Yes
- Heating Type: Gas, Hot Water
- Heating Fuel: Natural
Utilities
- Separate Gas/Elect: Yes
- Sewer: Public Sewer
- Water: Public
Structural Information
- # Buildings: 1
- Architectural Style: Two Story
- Exterior Const.: Aluminum Siding, Brick
- Basement: Yes
- Basement Desc.: Full
- Foundation: Poured
- Roof: Shingle
- Windows: Vinyl
- Stories/Levels: Two
- Square Feet: 2,524
- Year Built: 1957
Unit Information
- Studio/Effic Units: 1
- 2 Bedroom Units: 2
Unit 1
- Bedrooms: 2
Unit 2
- Bedrooms: 2
Unit 3
- Bedrooms: 1
Lot Features
- Lot Size (Acres): 0.164
- Lot Size (Sq. Ft.): 7,144
- Lot Dimensions: 69.60 x 141.08
- Zoning: Multi Family
Financial Considerations
- Semi-Annual Taxes: $3382
- Tenant Expense: Heat
- Pays Heat: Tenant
- Pays Water: Owner
Disclosures and Reports
- APN: 051-0008-0040-00
Buyer's Brokerage Compensation: Contact Listing Agent
Not binding unless confirmed by separate agreement among applicable parties.
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 4947 Charlemar Dr
School District:Cincinnati City School District
| Name | Grades | Distance |
|---|---|---|
Shroder Paideia High School 5030 Duck Creek Road, Cincinnati, OH 45227 | 7-12 | 0.4 mi |
John P Parker Elementary School 5051 Anderson Place, Cincinnati, OH 45227 | PK-6 | 0.6 mi |
Withrow University High School 2488 Madison Road, Cincinnati, OH 45208 | 7-12 | 2.6 mi |
Clark Montessori High School 3030 Erie Avenue, Cincinnati, OH 45208 | 7-12 | 1.8 mi |
Hughes STEM High School 2515 Clifton Avenue, Cincinnati, OH 45219 | 7-12 | 6.4 mi |
Robert A. Taft Information Technology High School 420 Ezzard Charles Drive, Cincinnati, OH 45214 | 7-12 | 7 mi |
Woodward Career Technical High School 7005 Reading Road, Cincinnati, OH 45237 | 7-12 | 3.5 mi |
Riverview East Academy 3555 Kellogg Avenue, Cincinnati, OH 45226 | 9-12 | 3.6 mi |
Walnut Hills High School 3250 Victory Parkway, Cincinnati, OH 45207 | 7-12 | 4 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 4947 Charlemar Dr
Tax History
Tax History for 4947 Charlemar Dr
Year
Property Taxes
Change
Tax Assessment
Change
2025
$6,765
—
$106,572
—
2024
$6,755
—
$106,572
—
2023
$6,767
-7%
$106,572
1%
2021
$7,304
-1%
$105,035
—
2022
$7,411
1%
$105,035
—
2020
$7,304
9%
$105,035
20%
2019
$6,687
—
$87,528
—
2018
$6,692
4%
$87,528
—
2017
$6,446
114%
$87,528
120%
2016
$3,007
12%
$39,725
—
2015
$2,688
-1%
$39,725
—
2014
$2,703
-2%
$39,725
—
2013
$2,749
—
$39,725
—
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 4947 Charlemar Dr
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 3 hours ago
- 3Beds
- 2Total Baths
- 1,570Sq. Ft.
Listed by Todd Blersch (513) 604-3138
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 3 days ago
- 4Beds
- 5Total Baths
- 3,688Sq. Ft.
- Single Family
- Active
- Updated 5 days ago
- 3Beds
- 2Total Baths
- 1,763Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Closed
- 3Beds
- 2Total Baths
- 2,313Sq. Ft.
Listed by Melissa Wolfe McNally
Sold by Finn Team
Sold by Finn Team
- Single Family
- Closed
- Updated 12 days ago
- 3Beds
- 3Total Baths
- 1,727Sq. Ft.
- Single Family
- Closed
- Updated 11 days ago
- 5Beds
- 3Total Baths
- 2,470Sq. Ft.
Listed by Meg Perez
4947 Charlemar Drive, Cincinnati, OH 45227 (MLS# 1872790) is a Triplex property with 0 bedrooms and 0 full bathrooms. 4947 Charlemar Drive is currently listed for $495,000 and was received on March 27, 2026. This property is listed by Oyler Hines from our Hyde Park Office.Want to learn more about 4947 Charlemar Drive? Do you have questions about finding other Triplex real estate for sale in Madisonville? You can browse all Madisonville real estate or contact a Coldwell Banker agent to request more information.