$478,137
SOLD AUG 3, 2026
5 Beds
3 Baths
3,167 Sq Ft
3,485 Sq Ft Lot

Sale Details

Date Sold: August 3, 2026

$151 Per Sq Ft

3% Below List Price

13 Days on Market

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

As of August 2026

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!

Last Agent to Sell the Property

Hannah Wang

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

Sibcy Cline, Inc.

Last Buyer's Agent

Austin Long

Keller Williams Advisors License #2021002431

Keller Williams Advisors
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 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: Sold
  • On Market 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

Ownership 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 Name Owned For Owner Type

Purchase Details

Closed on
Jul 30, 2021
Sold by
Roth David Scott and Roth David S
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$500,000
Interest Rate
2.9%
Mortgage Type
Commercial

Purchase Details

Closed on
Jul 18, 2011
Sold by
The Bank Of New York Mellon Trust Co Na
Bought by
Roth David Scott

Purchase Details

Closed on
Nov 24, 2010
Sold by
Mcclain Charyn and Mcclain Thomas
Bought by
The Bank Of New York Mellon Trust Co Na

Purchase Details

Closed on
Nov 25, 2003
Sold by
Mcclain Thomas
Bought by
Mcclain Thomas and Mcclain Charyn

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$61,500
Interest Rate
6.1%
Mortgage Type
New Conventional

Purchase Details

Closed on
Mar 25, 1998
Sold by
Lewis John Stewart
Bought by
Mcclain Thomas

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$14,995
Interest Rate
7.27%
Mortgage Type
Seller Take Back

Purchase Details

Closed on
Jan 31, 1994
Sold by
Woodward Anthony Russell
Bought by
Lewis John Stewart
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Agents Specializing in East Walnut Hills, OH

See All Agents

Purchase 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 Type Sale Price Title Company
Warranty Deed -- None Listed On Document
Special Warranty Deed $6,199 None Available
Sheriffs Deed $36,000 None Available
Interfamily Deed Transfer -- --
Warranty Deed $25,000 --
Quit Claim Deed -- --
Source: Public Records

Mortgage 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 Status Loan Amount Loan Type
Open $360,500 New Conventional
Closed $500,000 Commercial
Previous Owner $134,775 New Conventional
Previous Owner $42,600 Credit Line Revolving
Previous Owner $60,000 New Conventional
Previous Owner $61,500 New Conventional
Previous Owner $14,995 Seller Take Back
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
08/03/2026 08/03/26 Sold $478,137 -3.4% $151 / 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)

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

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

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.