$495,000

4947 Charlemar Drive, Cincinnati, OH 45227

  • 2,524 sqft
  • Property Icon Multi-Family Home
  • Property Year Built Icon Built in 1957
  • Property Lot Size Icon7,144sqft lot
  • Property Parking Icon —— car garage
  • Property Price Per Square Feet Icon $196/sqft
  • Property List Date Icon Listed 7 days ago

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!

Listing Status:
Active
Date Added:
March 27, 2026
Data Last Updated:
April 1, 2026 at 12:30PM
Listing Office:
Coldwell Banker Realty : 513-321-9944
Listing Agent:
Scott Oyler : 513 6231351
MLS ID:
1872790
  • Basement: Full
  • Fireplace: None
  • General: Metal Fence
  • Parking: DrivewayGarage
  • Roofing: Shingle
  • Windows: Vinyl
  • General: Aluminum SidingBrickPoured
  • Originating MLS: Cincinnati Multiple Listing Service
  • School District: Cincinnati City SD
  • County: Hamilton
  • Zoning: 051-0008-0040-00
  • Water: Public
  • Source: Cincinnati Multiple Listing Service

This listing courtesy of Scott Oyler , Coldwell Banker Realty

Monthly Payment

$Est. Payment
  • Principal & Interest $
  • Property Taxes $
  • Home Insurance $
  • VA Funding Fee $

Ready to Start a VA Loan?

Get Started Veterans United Home LoansNMLS #1907  †
Get Prequalified »
Interest rates used in the VA mortgage calculator are shown for illustrative purposes only. Your rate may differ based on a variety of factors, including your credit score and the current market conditions. To get your personalized interest rate, start your quote online.

Location

Schools Nearby

J

John P. Parker School

5051 Anderson Pl, Cincinnati, OH, 45227

Grades PK-6

0.55 miles away

S

Shroder High School

5030 Duck Creek Rd, Cincinnati, OH, 45227

Grades 7-12

0.38 miles away

S

Shroder High School

5030 Duck Creek Rd, Cincinnati, OH, 45227

Grades 7-12

0.38 miles away

Disclaimer: School and School District information courtesy of the National Center for Education Statistics (NCES). School boundaries may change. Proximity to listed schools does not guarantee enrollment eligibility. Contact the school district for more information and exact boundaries.

Similar Listing

407 Tusculum Avenue, Cincinnati, OH 45226
Multi-Family Home For Sale

$499,000

  • 2,412 sqft |
407 Tusculum Avenue Cincinnati, OH 45226

#1865379 - Coldwell Banker Realty