$495,000
PENDING

Estimated payment $2,971/month

Total Views 1,356
5 Beds
3 Baths
3,167 Sq Ft
$156 Price per Sq Ft

Highlights

  • City View
  • Marble Flooring
  • Main Floor Bedroom
  • Walnut Hills High School Rated A+
  • Traditional Architecture
  • 5-minute walk to Moorman Tot Lot

About This Home

Welcome to the Hackberry Mansion! Fully renovated and income-producing in the heart of East Walnut Hills. Enjoy peace of mind with a new roof, windows, HVAC, kitchen, bathrooms, and more. This spacious property blends historic charm with modern updates, featuring exposed brick, soaring ceilings, stylish finishes, fun fixtures + spunky paint throughout. Fully fenced backyard with pergola creates the perfect entertaining space. Currently operating as a successful short-term rental with strong cash flow. Seller is willing to include all furnishings, making this a true turnkey opportunity for the next owner. Continue as a short-term rental, convert to a long-term rental, or owner occupy. Conveniently located adjacent to Madison Rd. Walking distance to shopping, dining, coffee shops, DeSales corner, and everything East Walnut Hills has to offer. Investment opportunity, personal residence, or both, the possibilities are endless!

Listing Agent

Hannah Wang

Sibcy Cline, Inc. License #2020006118 Listed on: 05/19/2026

Sibcy Cline, Inc.

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,570

Year Built

  • Built in 1885

Lot Details

  • 3,485 Sq Ft Lot
  • Privacy Fence

Parking

  • On-Street Parking

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Stone Foundation
  • Membrane Roofing

Interior Spaces

  • 3,167 Sq Ft Home
  • 3-Story Property
  • Ceiling height of 9 feet or more
  • Chandelier
  • Non-Functioning Fireplace
  • Vinyl Clad Windows
  • Family Room with Fireplace
  • Dining Room with Fireplace
  • Formal Dining Room
  • Bonus Room
  • City Views
  • Basement Fills Entire Space Under The House

Kitchen

  • Eat-In Kitchen
  • Oven or Range
  • Microwave
  • Dishwasher
  • Kitchen Island

Flooring

  • Marble
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Main Floor Bedroom
  • 3 Full Bathrooms
  • Dual Vanity Sinks in Primary Bathroom

Laundry

  • Dryer
  • Washer

Outdoor Features

  • Patio

Utilities

  • Central Air
  • Heating System Uses Gas
  • Gas Water Heater

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,570

Year Built

Built in 1885

Lot Details

3,485 Sq Ft Lot

Listing Details

  • Suburb: Walnut Hills
  • Land Description: Less than .5 Acre
  • Access: City Street
  • Broker Approved: Yes
  • Census Tract Realist: 41.00
  • Cooling: Central Air
  • Heating: Gas
  • Lot Area Realist: 3485.00
  • Suburb S I C: Walnut Hills
  • Zoning: Residential
  • Level 1 Bathroom Type: Full
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: Yes
  • Dining Room Feat: Chandelier, Fireplace, Formal
  • Family Room Feat: Fireplace
  • Living Great Rm Dim: 0 x 0
  • Single Family Desc: Single Family
  • Study Lib Den: 0x0 Level: 1
  • Study Lib Den Dim: 0 x 0
  • Water Heating: Gas
  • Year Built: 1885
  • Architecture: Traditional
  • Full Bathrooms: 3
  • Bedrooms: 5
  • Directions: Directly off Madison take Right. Property on your right.
  • Lot Measurement: Acres
  • Status: Pending
  • Showing Start Date: 2026-05-19
  • Property Subtype 1: Single Family Residence
  • Occupancy: Negotiable
  • Second Floor Area: 2058
  • ADU Y/N: No
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling
  • Bedroom 2: 0x0 Level: 2
  • Bedroom 3: 0x0 Level: 3
  • Bedroom 4: 0x0 Level: 3
  • Bedroom 5: 0x0 Level: 3
  • Dining Room: 0x0 Level: 1
  • Family Room: 0x0 Level: 1
  • Living Room: 0x0 Level: 1
  • Recreation Room: 0x0 Level: 1
  • Flex Rooms: Bonus Room
  • Property Type: Residential
  • Reciprocal Listing: No
  • Semi Annual Taxes: $1785
  • Appliances: Dishwasher, Dryer, Microwave, Oven/Range, Refrigerator, Washer
  • Kitchen Features: Eat-In, Island, Marble/Granite/Slate
  • Basement: Full
  • Study Features: Fireplace
  • Entry: 0x0 Level: 1
  • Bathrooms: 3.00
  • Kitchen Dim: 0 x 0
  • Levels: Three+
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Bathroom 2: Full
  • Bathroom 2 Level: 2
  • Bathroom 3: Full
  • Bathroom 3 Level: 3
  • Laundryroom Dim: 0 x 0
  • Recreation Room Dim: 0 x 0
  • Fireplace: Inoperable
  • Fireplaces: 1
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 3167.00
  • Windows: Vinyl
  • PrimaryBedroomDim: 0 x 0
  • Primary Bathrooms: Tile Floor, Double Vanity, Marb/Gran/Slate
  • PrimaryBedFeat: Other
  • P R I M A R Y B E D R O O M: 0x0 Level: 2

Exterior Features

  • View: City
  • Fencing: Privacy
  • Roof: Membrane
  • Construction: Brick
  • Outside Features: Patio
  • Foundation: Stone
  • Listing Price: 495000.00
  • Acres: 0.0800
  • New Construction: No

Garage/Parking

  • Garage Carport: None
  • Parking: On Street

Utilities

  • Gas: Natural
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

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

Schools

  • District: Cincinnati City SD

Lot Info

  • Lot Size Sq Ft: 3485.00
  • Total Assessed Value: Of Record

Rental Info

  • Sub Lease: No

Tax Info

  • Tax Abatement: No

Map

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

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
2025 $3,571 $56,322 $6,930 $49,392
2024 $3,566 $56,322 $6,930 $49,392
2023 $3,573 $56,322 $6,930 $49,392
2022 $2,235 $29,523 $5,775 $23,748
2021 $2,049 $29,523 $5,775 $23,748
2020 $2,055 $29,523 $5,775 $23,748
2019 $2,256 $29,523 $5,775 $23,748
2018 $2,258 $29,523 $5,775 $23,748
2017 $2,175 $29,523 $5,775 $23,748
2016 $1,712 $22,663 $7,872 $14,791
2015 $1,530 $22,663 $7,872 $14,791
2014 $1,539 $22,663 $7,872 $14,791
2013 $1,436 $20,791 $7,221 $13,570
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
06/01/2026 06/01/26 Pending -- -- --
05/12/2026 05/12/26 For Sale $495,000 -- $156 / Sq Ft
Source: MLS of Greater Cincinnati (CincyMLS)

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1878711

MLS of Greater Cincinnati (CincyMLS)

APN: 055-0006-0043-00

Your Personal Tour Guide

Ask me questions while you tour the home.