Seller's Agent in 2025
Alison Fossette
BF Realty
(513) 502-3347
1 in this area
141 Total Sales
5574 Squirrel Run Cincinnati, OH 45247
Estimated Value: $473,554 - $559,000
4
Beds
4
Baths
2,440
Sq Ft
$206/Sq Ft
Est. Value
Highlights
- View of Trees or Woods
- Family Room with Fireplace
- Traditional Architecture
- Deck
- Wooded Lot
- Wood Flooring
About This Home
As of May 2025Exceptional Opportunity in Squirrel Creek! Discover this incredible home in the highly sought-after Squirrel Creek neighborhood. The spacious eat-in kitchen features elegant granite countertops and stainless steel appliances. The fully finished basement includes a convenient half bath, walkout access, and brand-new carpeting. The primary bathroom has been beautifully updated with luxury vinyl tile. Enjoy the ease of first-floor laundry with its own walkout. Step onto the expansive back deck and take in the serene wooded views perfect for relaxing or entertaining. Ideally located with quick access to the expressway, this home offers both comfort and convenience. Don't miss out schedule your showing today!
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $6,150
Year Built
- Built in 1986
Lot Details
- Cul-De-Sac
- Wooded Lot
HOA Fees
- $8 Monthly HOA Fees
Parking
- 2 Car Attached Garage
Home Design
- Traditional Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
- Wood Siding
Interior Spaces
- 2,440 Sq Ft Home
- 2-Story Property
- Bookcases
- Crown Molding
- Chandelier
- Wood Burning Fireplace
- Brick Fireplace
- Vinyl Clad Windows
- Insulated Windows
- Wood Frame Window
- Family Room with Fireplace
- 2 Fireplaces
- Views of Woods
Kitchen
- Eat-In Kitchen
- Breakfast Bar
- Oven or Range
- Microwave
- Dishwasher
- Solid Wood Cabinet
Flooring
- Wood
- Tile
Bedrooms and Bathrooms
- 4 Bedrooms
- Walk-In Closet
- Dual Vanity Sinks in Primary Bathroom
- Bathtub
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
Outdoor Features
- Deck
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
- Gas Water Heater
- Septic Tank
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Apr 4, 2025
Closed on
May 12, 2025
Sold by
Somerville-Powell Samir R and Feuchter Jonathan
Bought by
Asper Kevin R and Asper Amy E
Seller's Agent
Alison Fossette
BF Realty
Buyer's Agent
Brian Thomas
Coldwell Banker Heritage
List Price
$479,900
Sold Price
$489,000
Premium/Discount to List
$9,100
1.9%
Views
17
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
-$9,066
Avg. Annual Appreciation
2.65%
Original Mortgage
$379,900
Outstanding Balance
$376,474
Interest Rate
6.64%
Mortgage Type
New Conventional
Estimated Equity
$126,165
Purchase Details
Listed on
Nov 9, 2019
Closed on
Mar 13, 2020
Sold by
Kemphaus Aaron E and Kemphaus Megan M
Bought by
Somerville Powell Samir R and Feuchter Jonathan
Seller's Agent
Adam Schupp
Sibcy Cline, Inc.
Buyer's Agent
Alison Fossette
BF Realty
List Price
$324,900
Sold Price
$297,500
Premium/Discount to List
-$27,400
-8.43%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
10.09%
Original Mortgage
$292,111
Interest Rate
5.12%
Mortgage Type
FHA
Purchase Details
Listed on
Jan 4, 2012
Closed on
Feb 21, 2012
Sold by
Russell William M and Russell Mary A
Bought by
Kemphaus Aaron E and Kemphaus Megan M
Seller's Agent
Jean Raga
Coldwell Banker Realty
Buyer's Agent
Sandra Wilger
Comey & Shepherd
List Price
$250,000
Sold Price
$225,000
Premium/Discount to List
-$25,000
-10%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.53%
Original Mortgage
$202,500
Interest Rate
3.87%
Mortgage Type
New Conventional
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 |
|---|---|---|---|
| Asper Kevin R | $479,900 | None Listed On Document | |
| Asper Kevin R | $479,900 | None Listed On Document | |
| Somerville Powell Samir R | $297,500 | None Available | |
| Kemphaus Aaron E | -- | 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 |
|---|---|---|---|
| Open | Asper Kevin R | $379,900 | |
| Closed | Asper Kevin R | $379,900 | |
| Previous Owner | Somerville Powell Samir R | $292,111 | |
| Previous Owner | Kemphaus Aaron E | $202,500 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 05/12/2025 05/12/25 | Sold | $489,000 | +1.9% | $200 / Sq Ft | |
| 04/15/2025 04/15/25 | Off Market | $479,900 | -- | -- | |
| 04/11/2025 04/11/25 | Pending | -- | -- | -- | |
| 04/11/2025 04/11/25 | Off Market | $479,900 | -- | -- | |
| 04/10/2025 04/10/25 | For Sale | $479,900 | 0.0% | $197 / Sq Ft | |
| 04/09/2025 04/09/25 | Off Market | $479,900 | -- | -- | |
| 04/06/2025 04/06/25 | Off Market | $479,900 | -- | -- | |
| 06/14/2020 06/14/20 | Off Market | $297,500 | -- | -- | |
| 03/13/2020 03/13/20 | Sold | $297,500 | -5.5% | $122 / Sq Ft | View Prior Sale |
| 02/17/2020 02/17/20 | Pending | -- | -- | -- | |
| 12/06/2019 12/06/19 | Price Changed | $314,900 | -3.1% | $129 / Sq Ft | |
| 11/09/2019 11/09/19 | For Sale | $324,900 | +44.4% | $133 / Sq Ft | |
| 05/22/2012 05/22/12 | Off Market | $225,000 | -- | -- | |
| 02/21/2012 02/21/12 | Sold | $225,000 | -10.0% | $92 / Sq Ft | View Prior Sale |
| 01/20/2012 01/20/12 | Pending | -- | -- | -- | |
| 01/04/2012 01/04/12 | For Sale | $250,000 | -- | $102 / Sq Ft |
Source: MLS of Greater Cincinnati (CincyMLS)
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 |
|---|---|---|---|---|
| 2025 | $6,549 | $112,214 | $19,250 | $92,964 |
| 2024 | $6,060 | $112,214 | $19,250 | $92,964 |
| 2023 | $6,094 | $112,214 | $19,250 | $92,964 |
| 2022 | $6,914 | $104,125 | $22,715 | $81,410 |
| 2021 | $6,853 | $104,125 | $22,715 | $81,410 |
| 2020 | $6,925 | $104,125 | $22,715 | $81,410 |
| 2019 | $6,466 | $90,766 | $19,250 | $71,516 |
| 2018 | $5,804 | $90,766 | $19,250 | $71,516 |
| 2017 | $5,501 | $90,766 | $19,250 | $71,516 |
| 2016 | $4,845 | $78,750 | $19,110 | $59,640 |
| 2015 | $4,892 | $78,750 | $19,110 | $59,640 |
| 2014 | $4,900 | $78,750 | $19,110 | $59,640 |
| 2013 | $5,867 | $98,802 | $24,500 | $74,302 |
Source: Public Records
Agents Affiliated with this Home
-
Alison Fossette
-
Laura Faz
Seller Co-Listing Agent in 2025
Laura Faz
Coldwell Banker Realty
(513) 502-3347
1 in this area
124 Total Sales
-
Brian Thomas
Buyer's Agent in 2025
Brian Thomas
Coldwell Banker Heritage
(513) 503-9763
1 in this area
154 Total Sales
-
Adam Schupp
Seller's Agent in 2020
Adam Schupp
Sibcy Cline, Inc.
(513) 460-5336
17 in this area
272 Total Sales
-
Jean Raga
Seller's Agent in 2012
Jean Raga
Coldwell Banker Realty
(513) 378-7753
100 Total Sales
-
S
Seller Co-Listing Agent in 2012
Sandra Ward
Exit Best Realty
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1835550
APN: 510-0222-0126
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
- 7535 Sheed Rd
- 7757 Dennler Ln
- 6700 Gaines Rd
- 7098 Sheed Rd
- 5991 Gaines Rd
- 4994 Shadow Hawk Dr
- 8169 Lakevalley Dr
- 7845 Livingston Rd
- 4929 Shadow Hawk Dr
- 6130 Wilmer Rd
- 5840 Sutters Mill Dr
- 7350 Appleridge Ct
- 4357 Hubble Rd
- 6328 Oakcreek Dr
- 5807 Gaines Rd
- 4166 Philnoll Dr
- 5792 Gaines Rd
- Site 1 Brierly Creek Rd
- 3999 Philnoll Dr
- 4643 Whispering Oak Trail
- 5566 Squirrel Run
- 5580 Squirrel Run
- 5558 Squirrel Run
- 5588 Squirrel Run
- 5550 Squirrel Run
- 5571 Squirrel Run
- 5579 Squirrel Run
- 5585 Squirrel Run
- 5563 Squirrel Run
- 5551 Anna Marie Ln
- 5594 Squirrel Run
- 5553 Squirrel Run
- 5598 Squirrel Run
- 5542 Squirrel Run
- 0 Squirrel Run Unit 10 1660545
- 7 Squirrel Run
- 5596 Squirrel Run
- 5597 Squirrel Run
- 5540 Hubble Rd
- 5545 Anna Marie Ln
Your Personal Tour Guide
Ask me questions while you tour the home.