$1,950,000

4047 Mclean Dr Cincinnati, OH 45255

Estimated payment $10,571/month

Total Views 35,012
3 Beds
1 Bath
2,901 Sq Ft
$672 Price per Sq Ft

Highlights

  • City View
  • Main Floor Bedroom
  • 12 Car Detached Garage
  • Cape Cod Architecture
  • No HOA
  • Bathtub with Shower

About This Home

Incredible investment opportunity with this mixed-use 1-acre (potentially 2+ acre with Beechmont frontage) property right in the heart of Cherry Grove. Property includes an existing home and 50x70 detached workshop (currently a metal fab shop) situated adjacent to the hustle and bustle of the main artery through Cherry Grove. Could be a good home for skilled trade business or could be developed along with available adjoining properties, that have Beechmont Ave. road frontage available as well.

Listing Agent

Chris Shepherd

Plum Tree Realty License #2020007240 Listed on: 01/17/2026

Plum Tree Realty

Co-Listing Agent

Mark Shepherd

Plum Tree Realty License #2022006482

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,658

Year Built

  • Built in 1954

Lot Details

  • 1.05 Acre Lot
  • Level Lot
  • Property is zoned Residential,Commercial

Parking

  • 12 Car Detached Garage
  • Driveway

Home Design

  • Cape Cod Architecture
  • Poured Concrete
  • Shingle Roof
  • Vinyl Siding

Interior Spaces

  • 2,901 Sq Ft Home
  • 2-Story Property
  • Vinyl Clad Windows
  • City Views
  • Oven or Range

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Main Floor Bedroom
  • 1 Full Bathroom
  • Bathtub with Shower

Unfinished Basement

  • Basement Fills Entire Space Under The House
  • Rough-In Basement Bathroom

Utilities

  • Window Unit Cooling System
  • Forced Air Heating System
  • 220 Volts
  • Natural Gas Not Available
  • Electric Water Heater

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,658

Year Built

Built in 1954

Lot Details

1.05 Acres

Parking

12

Listing Details

  • Suburb: Union Twp.
  • Topography: Level
  • Buildings: Barn,Shed,Workshop
  • Land Description: 1 to 4.9 Acres
  • Access: City Street
  • Broker Approved: Yes
  • Miscellaneous: 220 Volt
  • Census Tract Realist: 414.04
  • Cooling: Window Unit, None
  • Heating: Electric, Forced Air
  • Lot Area Realist: 45738.00
  • Suburb S I C: Union Twp.
  • Price Per Acre: 1857142.86
  • Zoning: Residential,Commercial
  • Accessibility Features: No
  • Basement Features: Bath Rough-In, Unfinished
  • Level 1 Bathroom Type: Full
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: Yes
  • Living Great Rm Dim: 12 x 12
  • Single Family Desc: Single Family
  • Study Lib Den Dim: 0 x 0
  • Water Heating: Electric
  • Year Built: 1954
  • Architecture: Cape Cod
  • Full Bathrooms: 1
  • Bedrooms: 3
  • Directions: St Rt 125, turn right on McLean, property is on left
  • Lot Measurement: Acres
  • Status: Active
  • Property Subtype 1: Single Family Residence
  • Occupancy: At Closing
  • ADU Y/N: No
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Bedroom 2: 10x10 Level: 1
  • Bedroom 3: 10x10 Level: 1
  • Dining Room: 10x10 Level: 1
  • Living Room: 12x12 Level: 1
  • Property Type: Residential
  • Reciprocal Listing: No
  • Semi Annual Taxes: $3329
  • Appliances: Oven/Range, Refrigerator
  • Basement: Full
  • Bathrooms: 1.00
  • Kitchen Dim: 10 x 10
  • Levels: Two
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Laundry Room: 8x8 Level: 1
  • Laundryroom Dim: 8 x 8
  • Recreation Room Dim: 0 x 0
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 2901.00
  • Windows: Vinyl
  • PrimaryBedroomDim: 10 x 10
  • Primary Bathrooms: Tub w/Shower
  • P R I M A R Y B E D R O O M: 10x10 Level: 1

Exterior Features

  • View: City
  • Roof: Shingle
  • Construction: Vinyl Siding
  • Foundation: Poured
  • Listing Price: 1950000.00
  • Acres: 1.0500
  • New Construction: No

Garage/Parking

  • Garage Spaces: 12.00
  • Garage Carport: Garage Detached
  • Parking: Asphalt, Driveway

Utilities

  • Gas: None
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • HOA Yes/No: No
  • Association: Cincinnati Area Multiple Listing Service

Schools

  • District: West Clermont Local

Green Features

  • Energy Green Features: No

Lot Info

  • Lot Size Sq Ft: 45738.00
  • Total Assessed Value: of record

Rental Info

  • Sub Lease: No

Tax Info

  • Tax Abatement: No

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $6,659 $131,640 $22,330 $109,310
2023 $6,669 $131,640 $22,330 $109,310
2022 $5,413 $92,510 $14,700 $77,810
2021 $5,348 $91,040 $14,700 $76,340
2020 $4,566 $77,910 $14,700 $63,210
2019 $3,136 $62,550 $14,250 $48,300
2018 $3,168 $62,550 $14,250 $48,300
2017 $3,209 $62,550 $14,250 $48,300
2016 $3,096 $55,340 $12,600 $42,740
2015 $3,004 $55,340 $12,600 $42,740
2014 $3,004 $55,340 $12,600 $42,740
2013 $2,842 $51,840 $13,300 $38,540
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
01/17/2026 01/17/26 For Sale $1,950,000 -- $672 / Sq Ft
Source: MLS of Greater Cincinnati (CincyMLS)

Purchase History

Date Type Sale Price Title Company
Deed $112,000 --
Source: Public Records

About the Listing Agent

Chris Shepherd

Plum Tree Realty

(513) 689-3656

Section Image

The Sold By Shep Team, led by brothers Mark and Chris Shepherd with extensive sales experience, offers specialized services in listing and marketing homes, military veteran assistance, relocation, and new construction. With unparalleled communication skills, personalized service, relentless energy and a deep understanding of the challenges of the current real estate market, our top-performing team is committed to helping our clients buy or sell properties quickly and efficiently. Our passion

Chris' Other Listings

  • 203 Bingaman Ln, Mount Orab, OH 45154

    $1,350,000

    • 3 Beds
    • 1 Bath
    • 1,930 Sq Ft
    • 203 Bingaman Ln
    • Mount Orab, OH

    This property includes 21.19 acres of land ideally situated adjacent to railroad tracks and in close proximity to the Mt Orab mega site. Property includes two homes. A 3-bed, 1-bath ranch home with a second manufactured home and a couple barns/sheds on property. Value is in the land.

    Chris Shepherd Plum Tree Realty

    Section Image
  • 206 Bingaman Ln, Mount Orab, OH 45154

    $1,350,000

    • 4 Beds
    • 2 Baths
    • 1,620 Sq Ft
    • 206 Bingaman Ln
    • Mount Orab, OH

    This property includes 19.36 acres of land ideally situated adjacent to railroad tracks and close proximity to the Mt Orab mega site with a 4-bed, 2-bath ranch home. Property also includes 36x56 pole barn, offering plenty of space for storage or work. Value is in the land!

    Chris Shepherd Plum Tree Realty

    Section Image
  • 130 Tall Trees Dr Unit 13J, Amelia, OH 45102

    $193,900 Sold Apr 30, 2025

    • 2 Beds
    • 1 Bath
    • 1,032 Sq Ft
    • 130 Tall Trees Dr
    • Unit 13J
    • Amelia, OH

    Welcome to effortless living in the highly sought-after Tall Trees community! This beautifully maintained first-floor condo offers true no-step living and a thoughtfully designed layout for both comfort and convenience. From the moment you arrive, you'll appreciate the attached garage with direct access into a spacious laundry/mudroomperfect for extra storage or a drop zone. Inside, the living

    Chris Shepherd Plum Tree Realty

  • 3429 Gimli Dr, Amelia, OH 45102

    $326,900 Sold May 13, 2025

    • 4 Beds
    • 4 Baths
    • 1,880 Sq Ft
    • 3429 Gimli Dr
    • Amelia, OH

    Welcome to this stunning 4-bed, 2 full & 2 half-bath home, situated at the end of a cul-de-sac on a GINORMOUS, no-HOA lot (0.87 acre). Offering the ideal blend of privacy and convenience, this home has an attached 2-car garage, new HVAC and a gorgeous, new, trex deck, perfect for entertaining or relaxing. The bright and inviting floor plan has spacious living areas, a fully remodeled kitchen and

    Chris Shepherd Plum Tree Realty

  • 2022 Wood Brook Dr, Amelia, OH 45102

    $390,000 Sold Oct 07, 2025

    • 3 Beds
    • 2.5 Baths
    • 1,752 Sq Ft
    • 2022 Wood Brook Dr
    • Amelia, OH

    Welcome to this spacious 3-bedroom (4th potentially in basement), 2.5-bath ranch-style home offering the perfect blend of comfort and functionality! Featuring a full basement and an attached 2-car garage, this home has space for all your needs. Step out back to enjoy the private, partially fenced yard that backs up to mature trees. The rear paver patio and pergola are perfect for entertaining or

    Chris Shepherd Plum Tree Realty

  • 1905 Liberty St, New Richmond, OH 45157

    $152,000 Sold Oct 07, 2025

    • 3 Beds
    • 1 Bath
    • 1,344 Sq Ft
    • 1905 Liberty St
    • New Richmond, OH

    This 3-bedroom, 1-bath ranch is full of potential and ready for your vision. Whether you're a first-time buyer looking for a project, an investor, or someone wanting to downsize, this home offers a solid foundation to make it your own. Convenient single level living with a functional layout, situated on a nice lot in a quiet neighborhood. Being sold AS IS, bring your ideas and turn this into

    Chris Shepherd Plum Tree Realty

  • 2263 Dean Rd, Bethel, OH 45106

    $225,000 Sold Jan 15, 2026

    • 3 Beds
    • 1 Bath
    • 1,256 Sq Ft
    • 2263 Dean Rd
    • Bethel, OH

    Charming 3-bedroom, 1-bath ranch on 1 acre just outside of Bethel. This well-kept home offers easy one-level living with an attached 2-car garage, a peaceful tree lined backyard, and a spacious rear patio perfect for relaxing or entertaining. Enjoy the privacy of country living with plenty of room to make it your own!

    Chris Shepherd Plum Tree Realty

  • 340 N Main St, Bethel, OH 45106

    $229,000 Sold Mar 14, 2025

    • 3 Beds
    • 2 Baths
    • 1,053 Sq Ft
    • 340 N Main St
    • Bethel, OH

    Welcome to this inviting 3-bed, 2-bath home that sits on a spacious corner lot! Featuring walk-out basement, this property offers outdoor setting around the firepit next to the large 3 season sunroom, perfect for morning coffee or evening relaxation. Home also boasts a newer shed for extra storage, a detached craftsman garage, two blacktop driveways for clean curb appeal. Whether you're looking

    Chris Shepherd Plum Tree Realty

  • 2017 Maple Grove Rd, Mount Orab, OH 45154

    $340,000 Sold Jan 05, 2026

    • 4 Beds
    • 2 Baths
    • 2,376 Sq Ft
    • 2017 Maple Grove Rd
    • Mount Orab, OH

    Completely reimagined from the studs out, this 4-bedroom, 2-bath home offers modern living on 2.21 private acres just outside Mt. Orab. Nearly everything is brand new in 2025 while maintaining much of its original footprint. Peace of mind with NEW HVAC, whole house spray foam insulation, HWH, flooring, appliances, and way more than we can list! The updated layout flows beautifully into a spacious

    Chris Shepherd Plum Tree Realty

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1866525

MLS of Greater Cincinnati (CincyMLS)

APN: 41-41-15.-052

Your Personal Tour Guide

Ask me questions while you tour the home.