H
Seller's Agent in 2026
Hannah Franzen
Keller Williams Advisors
(513) 766-9200
2 in this area
46 Total Sales
5704 Adelphi St Cincinnati, OH 45227
Madisonville NeighborhoodEstimated Value: $508,453 - $516,000
3
Beds
3.5
Baths
2,552
Sq Ft
$201/Sq Ft
Est. Value
Highlights
- Open-Concept Dining Room
- Marble Flooring
- Jetted Tub in Primary Bathroom
- Walnut Hills High School Rated A+
- Traditional Architecture
- No HOA
About This Home
As of March 2026An exceptional opportunity in one of Cincinnati's most coveted locations. Perfectly positioned just steps from Mom 'n 'em Coffee & Wine and only five minutes from Oakley, Hyde Park, and Kenwood, this address offers effortless access to premier dining, shopping, and everyday conveniences while maintaining a true neighborhood feel. This 3 bedroom, 3.5 bathroom residence is thoughtfully designed for both comfort and entertaining, featuring a finished lower level that adds versatile living space. The expansive backyard is a rare find, complete with a tall privacy fence that creates a secluded outdoor retreat. Situated on a prominent corner lot, the home also offers a 2 car garage and private driveway for added convenience. Refined location. Generous space. Elevated living. Come tour it and experience the lifestyle for yourself!
Last Agent to Sell the Property
Keller Williams Advisors License #2025004734 Listed on: 02/18/2026
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $3,728
Year Built
- Built in 2015
Lot Details
- 8,799 Sq Ft Lot
- Privacy Fence
Parking
- 2 Car Attached Garage
- Garage Door Opener
- Driveway
Home Design
- Traditional Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
Interior Spaces
- 2,552 Sq Ft Home
- 2-Story Property
- Ceiling height of 9 feet or more
- Ceiling Fan
- Chandelier
- Vinyl Clad Windows
- Insulated Windows
- Window Treatments
- Panel Doors
- Open-Concept Dining Room
- Finished Basement
- Basement Fills Entire Space Under The House
Kitchen
- Eat-In Kitchen
- Breakfast Bar
- Oven or Range
- Microwave
- Dishwasher
- Smart Appliances
- Kitchen Island
- Solid Wood Cabinet
- Disposal
Flooring
- Wood
- Carpet
- Laminate
- Marble
- Tile
- Vinyl
Bedrooms and Bathrooms
- 3 Bedrooms
- Walk-In Closet
- Dressing Area
- Dual Vanity Sinks in Primary Bathroom
- Jetted Tub in Primary Bathroom
- Bathtub
Home Security
- Smart Lights or Controls
- Smart Thermostat
Accessible Home Design
- Smart Technology
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
- Gas Water Heater
Community Details
- No Home Owners Association
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
Listed on
Feb 18, 2026
Closed on
Mar 11, 2026
Sold by
Bought by
Seller's Agent
Hannah Franzen
Keller Williams Advisors
Buyer's Agent
Hannah Wang
Sibcy Cline, Inc.
List Price
$499,000
Sold Price
$520,000
Premium/Discount to List
$21,000
4.21%
Views
15
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$6,887
Avg. Annual Appreciation
-4.49%
Purchase Details
Listed on
Aug 12, 2022
Closed on
Oct 3, 2022
Sold by
Bought by
Seller's Agent
Megan Stacey
Coldwell Banker Realty
Buyer's Agent
Jerry Garrison
Keller Williams Advisors
List Price
$412,500
Sold Price
$445,000
Premium/Discount to List
$32,500
7.88%
Views
2
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.66%
Original Mortgage
$356,000
Interest Rate
4.13%
Mortgage Type
New Conventional
Purchase Details
Listed on
Jul 26, 2017
Closed on
Aug 29, 2017
Sold by
Bought by
Seller's Agent
Jason Kunkel
Kopf Hunter Haas
Buyer's Agent
Hugh McDonough
Lohmiller Real Estate
List Price
$289,900
Sold Price
$287,500
Premium/Discount to List
-$2,400
-0.83%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
8.91%
Original Mortgage
$273,000
Interest Rate
3.93%
Mortgage Type
New Conventional
Purchase Details
Closed on
Feb 5, 2015
Sold by
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
$185,000
Interest Rate
3.5%
Mortgage Type
Adjustable Rate Mortgage/ARM
Purchase Details
Closed on
Apr 25, 2013
Sold by
Bought by
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
Average Home Value in this Area
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 | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $520,000 | None Listed On Document | ||
| $445,000 | Northwest Title | ||
| $445,000 | Northwest Title | ||
| $287,500 | Old Town Title Agency | ||
| $1,000 | Attorney | ||
| -- | Attorney |
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 | Borrower | Loan Amount |
|---|---|---|---|
| Previous Owner | $356,000 | ||
| Previous Owner | $273,000 | ||
| Previous Owner | $185,000 |
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 | Prior Sale |
|---|---|---|---|---|---|
| 03/11/2026 03/11/26 | Sold | $520,000 | +4.2% | $204 / Sq Ft | |
| 02/22/2026 02/22/26 | Pending | -- | -- | -- | |
| 02/18/2026 02/18/26 | For Sale | $499,000 | +12.1% | $196 / Sq Ft | |
| 10/11/2022 10/11/22 | Sold | $445,000 | +7.9% | $228 / Sq Ft | View Prior Sale |
| 08/14/2022 08/14/22 | Pending | -- | -- | -- | |
| 08/12/2022 08/12/22 | For Sale | $412,500 | +43.5% | $211 / Sq Ft | |
| 11/30/2017 11/30/17 | Off Market | $287,500 | -- | -- | |
| 08/31/2017 08/31/17 | Sold | $287,500 | -0.8% | $147 / Sq Ft | View Prior Sale |
| 07/28/2017 07/28/17 | Pending | -- | -- | -- | |
| 07/26/2017 07/26/17 | For Sale | $289,900 | -- | $149 / 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,728 | $155,751 | $17,504 | $138,247 |
| 2024 | $3,616 | $155,751 | $17,504 | $138,247 |
| 2023 | $3,697 | $155,751 | $17,504 | $138,247 |
| 2022 | $658 | $100,626 | $8,628 | $91,998 |
| 2021 | $613 | $100,626 | $8,628 | $91,998 |
| 2020 | $630 | $100,626 | $8,628 | $91,998 |
| 2019 | $611 | $100,986 | $7,634 | $93,352 |
| 2018 | $612 | $100,986 | $7,634 | $93,352 |
| 2017 | $579 | $100,986 | $7,634 | $93,352 |
| 2016 | $563 | $7,291 | $7,291 | $0 |
| 2015 | $2,306 | $7,291 | $7,291 | $0 |
| 2014 | $2,552 | $7,291 | $7,291 | $0 |
| 2013 | $2,552 | $7,077 | $7,077 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Hannah Franzen
-
Hannah Wang
Buyer's Agent in 2026
Hannah Wang
Sibcy Cline
(513) 324-1162
6 in this area
148 Total Sales
-
Megan Stacey
Seller's Agent in 2022
Megan Stacey
Coldwell Banker Realty
(513) 702-8886
9 in this area
399 Total Sales
-
Jerry Garrison
Buyer's Agent in 2022
Jerry Garrison
Keller Williams Advisors
(513) 325-2245
1 in this area
75 Total Sales
-
Jason Kunkel
Seller's Agent in 2017
Jason Kunkel
Kopf Hunter Haas
(513) 293-5831
3 in this area
105 Total Sales
-
Hugh McDonough
H
Buyer's Agent in 2017
Hugh McDonough
Lohmiller Real Estate
(513) 236-8871
1 in this area
53 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1869054
APN: 037-0001-0037
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc.. Those listings held by brokerage firms other than Ten-X are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed.
Ten-X does not display the entire Cincinnati MLS Broker Reciprocity™ database on this web site. The listings of some real estate brokerage firms have been excluded.
Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved
Nearby Homes
- 5709 Adelphi St
- 5659 Bramble Ave
- 5600 Arnsby Place
- 5811 Bramble Ave
- 4538 Lucerne Ave
- 5706 Roe St
- 4703 Stewart Ave
- 4704 Whetsel Ave
- 4719 Ward St
- 4821 Ebersole Ave
- 4718 Ward St
- 6116 Roe St
- 4424 Simpson Ave
- 4430 Simpson Ave
- 5618 Prentice St
- 6125 Clephane Ave
- 4101 Homer Ave
- 6611 Madison Rd
- 5003 Anderson Place
- 5720 Madison Rd
- 5708 Adelphi St
- 4343 Conant St
- 5716 Adelphi St
- 5717 Whitney Ave
- 5715 Conant St
- 5725 Whitney Ave
- 5720 Adelphi St
- 5705 Adelphi St
- 4331 Conant St
- 5729 Whitney Ave
- 5711 Whitney Ave
- 5711 Whitney Ave Unit 3
- 5713 Adelphi St
- 4325 Conant St
- 5724 Adelphi St
- 5733 Whitney Ave
- 5717 Adelphi St
- 4323 Conant St
- 5737 Whitney Ave
- 4412 Erie Ave
Your Personal Tour Guide
Ask me questions while you tour the home.