Hillary Justice
Coldwell Banker Realty
(513) 647-6201
175 Total Sales
1 in The Village of Indian Hill
$838,400 Price
5400 Waring Dr Cincinnati, OH 45243
The Village of Indian Hill AreaEstimated Value: $1,749,000 - $2,166,000
5
Beds
7
Baths
4,087
Sq Ft
$482/Sq Ft
Est. Value
Highlights
- In Ground Pool
- 132,597 Sq Ft lot
- Wooded Lot
- Views of Trees
- Family Room with Fireplace
- Vaulted Ceiling
About This Home
As of June 2023Total re-fresh! 3 acre - 1st flr primary, 4 bed/3 bath up - Classic updated kitchen & appliances, hardwoods re-finished, designer carpet - all fresh interior paint - gracious brick terrace, pool - 4 car oversized garage - super setting & location! Offers to be left open 72 hrs. Sellers reserve the right to accept an offer at any time on/after showing start date of 06/07/23.
Last Agent to Sell the Property
Sibcy Cline, Inc. License #0000320966 Listed on: 06/05/2023
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
- $14,210
Year Built
- Built in 1962
Lot Details
- 3.04 Acre Lot
- Cul-De-Sac
- Sprinkler System
- Wooded Lot
Parking
- 4 Car Garage
- Side Facing Garage
- Driveway
Home Design
- Traditional Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
Interior Spaces
- 4,087 Sq Ft Home
- 2-Story Property
- Crown Molding
- Beamed Ceilings
- Vaulted Ceiling
- Wood Burning Fireplace
- Brick Fireplace
- Picture Window
- Wood Frame Window
- Entryway
- Family Room with Fireplace
- 3 Fireplaces
- Great Room
- Living Room with Fireplace
- Breakfast Room
- Dining Room
- Game Room
- Views of Trees
- Finished Basement
- Partial Basement
- Storm Windows
- Laundry Room
Kitchen
- Double Oven
- Electric Cooktop
- Microwave
- Dishwasher
- Granite Countertops
Flooring
- Wood
- Carpet
Bedrooms and Bathrooms
- 5 Bedrooms
Outdoor Features
- In Ground Pool
- Patio
- Exterior Lighting
- Shed
Utilities
- Central Air
- Heating Available
- Electric Water Heater
- Septic Tank
Community Details
Overview
- No Home Owners Association
Recreation
- Community Pool
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
Jun 5, 2023
Closed on
Jun 26, 2023
Sold by
Bought by
Seller's Agent
Maureen Pippin
Sibcy Cline, Inc.
Buyer's Agent
Michael Alf
Keller Williams Advisors
List Price
$1,695,000
Sold Price
$1,695,000
Views
11
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
$276,736
Avg. Annual Appreciation
5.00%
Original Mortgage
$1,677,750
Outstanding Balance
$1,618,391
Interest Rate
6.57%
Mortgage Type
New Conventional
Estimated Equity
$353,345
Purchase Details
Listed on
Sep 16, 2013
Closed on
Apr 1, 2014
Sold by
Bought by
Seller's Agent
Mary Kerr
Sibcy Cline, Inc.
Buyer's Agent
Maureen Pippin
Sibcy Cline, Inc.
List Price
$1,200,000
Sold Price
$985,000
Premium/Discount to List
-$215,000
-17.92%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.04%
Original Mortgage
$788,000
Interest Rate
3.5%
Mortgage Type
Adjustable Rate Mortgage/ARM
Purchase Details
Closed on
May 7, 1991
Sold by
Bought by
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Cincinnati, OH
-
Hillary Justice
-
Amy Getgey
Amy Getgey
Comey & Shepherd
(859) 600-6854
95 Total Sales
1 in The Village of Indian Hill
$815,000 Price
-
Jordan Fiore
Jordan Fiore
eXp Realty
(513) 440-3306
116 Total Sales
2 in The Village of Indian Hill
$225K - $1.7M Price Range
-
Nancy Pater
Nancy Pater
Keller Williams Seven Hills Re
(513) 547-2505
32 Total Sales
1 in The Village of Indian Hill
$1,435,000 Price
-
Nickolas Welage
Nickolas Welage
Plum Tree Realty
(513) 586-3385
127 Total Sales
2 in The Village of Indian Hill
$450K - $3.1M Price Range
-
Drew Farmer
Drew Farmer
Plum Tree Realty
(513) 712-8531
21 Total Sales
1 in The Village of Indian Hill
$1,572,800 Price
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 |
|---|---|---|---|
| $1,695,000 | None Listed On Document | ||
| $985,000 | Ltoc | ||
| $615,000 | -- |
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 |
|---|---|---|---|
| Open | $1,677,750 | ||
| Previous Owner | $788,000 | ||
| Previous Owner | $275,000 | ||
| Previous Owner | $50,000 | ||
| Previous Owner | $25,000 | ||
| Previous Owner | $225,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 |
|---|---|---|---|---|---|
| 06/28/2023 06/28/23 | Sold | $1,695,000 | 0.0% | $415 / Sq Ft | |
| 06/09/2023 06/09/23 | Pending | -- | -- | -- | |
| 06/07/2023 06/07/23 | For Sale | $1,695,000 | +72.1% | $415 / Sq Ft | |
| 06/30/2014 06/30/14 | Off Market | $985,000 | -- | -- | |
| 04/01/2014 04/01/14 | Sold | $985,000 | -17.9% | $241 / Sq Ft | View Prior Sale |
| 02/26/2014 02/26/14 | Pending | -- | -- | -- | |
| 09/16/2013 09/16/13 | For Sale | $1,200,000 | -- | $294 / 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 | $16,629 | $453,898 | $275,002 | $178,896 |
| 2024 | $16,285 | $453,898 | $275,002 | $178,896 |
| 2023 | $16,291 | $453,898 | $275,002 | $178,896 |
| 2022 | $14,209 | $325,759 | $199,213 | $126,546 |
| 2021 | $13,897 | $325,759 | $199,213 | $126,546 |
| 2020 | $12,132 | $325,759 | $199,213 | $126,546 |
| 2019 | $12,945 | $325,759 | $199,213 | $126,546 |
| 2018 | $12,969 | $325,759 | $199,213 | $126,546 |
| 2017 | $12,358 | $325,759 | $199,213 | $126,546 |
| 2016 | $13,141 | $344,751 | $207,694 | $137,057 |
| 2015 | $13,175 | $344,751 | $207,694 | $137,057 |
| 2014 | $13,074 | $344,751 | $207,694 | $137,057 |
| 2013 | $13,413 | $340,848 | $209,790 | $131,058 |
Source: Public Records
Agents Affiliated with this Home
-
Maureen Pippin
Seller's Agent in 2023
Maureen Pippin
Sibcy Cline
(513) 703-1993
40 Total Sales
-
Jessica Lieberman Jones
Seller Co-Listing Agent in 2023
Jessica Lieberman Jones
Sibcy Cline
(513) 919-2561
40 Total Sales
-
Michael Alf
Buyer's Agent in 2023
Michael Alf
Keller Williams Advisors
(513) 659-1106
5 Total Sales
-
M
Seller's Agent in 2014
Mary Kerr
Sibcy Cline
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1774246
APN: 529-0125-0073
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
- 5475 Waring Dr
- 7710 Indian Hill Rd
- 7795 Graves Rd
- 3625 Birkdale Ln
- 6780 Camaridge Ln
- 7255 Brill Rd
- 5775 Sugarun Ln
- 5025 Drake Rd
- 7335 Demar Rd
- 9280 Indian Hill Rd
- 4440 Miami Rd
- 6845 E Fork Rd
- 5880 Crabtree Ln
- 6923 Buckingham Place
- 6155 Hunters Trail
- 6837 Vinewood Ave
- 7026 Britton Ave
- 6934 Merwin Ave
- 6925 Windward St
- 5995 Crabtree Ln
- 5450 Waring Dr
- 5405 Waring Dr
- 5435 Hobbit Rd
- 7780 Indian Hill Rd
- 5445 Hobbit Rd
- 5400 Hobbit Rd
- 7805 Brill Rd
- 5340 Miami Rd
- 5360 Miami Rd
- 5495 Waring Dr
- 5320 Miami Rd
- 7820 Indian Hill Rd
- 5380 Miami Rd
- 5400 Miami Rd
- 5300 Miami Rd
- 7900 Indian Hill Rd
- 5280 Miami Rd
- 7800 Indian Hill Rd
- 7825 Brill Rd
- 7760 Indian Hill Rd
Your Personal Tour Guide
Ask me questions while you tour the home.