Mike Wright
Hoeting, Realtors
(513) 440-2953
154 Total Sales
1 in Colerain
$145,000 Price
5775 Squirrelsnest Ln Cincinnati, OH 45252
Colerain AreaEstimated Value: $497,000 - $537,000
4
Beds
4
Baths
2,421
Sq Ft
$216/Sq Ft
Est. Value
Highlights
- In Ground Pool
- View of Trees or Woods
- Transitional Architecture
- Eat-In Gourmet Kitchen
- Cathedral Ceiling
- Wood Flooring
About This Home
As of April 2021Nicely updated 4 BR 2-story on 1+ acre. New gourmet granite eat-in kitchen w/island, SS appliances & walk-out. Vaulted FR w/gas fireplace, skylight & brand new carpet. Cathedral living room w/hardwood flooring. Formal dining room. Master w/adjoining full granite BA w/double vanity, custom shower & soaker tub. Great private backyard w/in-ground pool & wooded views. Fin LL w/wetbar, half bath & new exercise room. Furnishings are negotiable.
Last Agent to Sell the Property
eXp Realty License #0000409383 Listed on: 02/25/2021
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
- $6,797
Year Built
- Built in 1991
Lot Details
- 1.05 Acre Lot
- Aluminum or Metal Fence
Parking
- 4 Car Garage
- Garage Door Opener
- Driveway
Home Design
- Transitional Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
- Vinyl Siding
Interior Spaces
- 2,421 Sq Ft Home
- 2-Story Property
- Cathedral Ceiling
- Skylights
- Chandelier
- Gas Fireplace
- Insulated Windows
- Panel Doors
- Entrance Foyer
- Family Room with Fireplace
- Formal Dining Room
- Views of Woods
- Finished Basement
- Basement Fills Entire Space Under The House
Kitchen
- Eat-In Gourmet Kitchen
- Oven or Range
- Microwave
- Dishwasher
- Kitchen Island
- Solid Wood Cabinet
Flooring
- Wood
- Laminate
Bedrooms and Bathrooms
- 4 Bedrooms
- Main Floor Bedroom
Outdoor Features
- In Ground Pool
- Patio
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
- Gas Water Heater
- Aerobic Septic System
Community Details
- No Home Owners Association
- Squirrels Nest Subdivision
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 25, 2021
Closed on
Apr 15, 2021
Sold by
Kalkhoff Mark and Schafer Kalkhoff Tara
Bought by
Seller's Agent
Kevin Hildebrand
eXp Realty
Buyer's Agent
Michele Donovan
Coldwell Banker Realty
List Price
$394,900
Sold Price
$410,000
Premium/Discount to List
$15,100
3.82%
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
$112,300
Avg. Annual Appreciation
4.59%
Original Mortgage
$389,500
Outstanding Balance
$344,736
Interest Rate
3%
Mortgage Type
New Conventional
Estimated Equity
$177,565
Purchase Details
Listed on
Aug 25, 2018
Closed on
Oct 10, 2018
Sold by
Figgins James R and Figgins Janice F
Bought by
Kalkhoff Mark and Schuter Kalkhoff Tara
Seller's Agent
Mark Schupp
Sibcy Cline, Inc.
Buyer's Agent
Michael Stylski
Comey & Shepherd
List Price
$299,900
Sold Price
$295,000
Premium/Discount to List
-$4,900
-1.63%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
13.95%
Original Mortgage
$220,000
Interest Rate
4.5%
Mortgage Type
New Conventional
Purchase Details
Closed on
Oct 17, 1990
Sold by
John M Niehaus Inc
Bought by
Figgins James R
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Cincinnati, OH
-
Mike Wright
-
Sally Metz
Sally Metz
Coldwell Banker Realty
(513) 993-5215
40 Total Sales
2 in Colerain
$156K - $258K Price Range
-
DaVan Gassett
DaVan Gassett
Responds QuicklyKeller Williams Pinnacle Group
(513) 599-0218
55 Total Sales
1 in Colerain
$245,900 Price
-
Mika Walker
Mika Walker
Coldwell Banker Realty
(513) 854-2223
77 Total Sales
1 in Colerain
$226,000 Price
-
Edmund Ferrall
Edmund Ferrall
Comey & Shepherd
(513) 952-8798
199 Total Sales
1 in Colerain
$215,000 Price
-
Barry Bates
Barry Bates
Coldwell Banker Realty
(513) 993-6141
139 Total Sales
3 in Colerain
$226K - $389K Price Range
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 |
|---|---|---|---|
| $410,000 | None Available | ||
| Kalkhoff Mark | $295,000 | Prominent Title Agency Llc | |
| Figgins James R | $34,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 | $389,500 | ||
| Previous Owner | Kalkhoff Tara Scjafer | $219,200 | |
| Previous Owner | The Kalkhoff Family Trust | $220,000 | |
| Previous Owner | Kalkhoff Mark | $220,000 | |
| Previous Owner | Figgins James R | $202,000 | |
| Previous Owner | Figgins James R | $227,000 | |
| Previous Owner | Figgins James R | $10,000 | |
| Previous Owner | Figgins James R | $100,000 | |
| Previous Owner | Figgins James R | $90,000 | |
| Previous Owner | Figgins James R | $80,900 | |
| Previous Owner | Figgins James R | $70,000 | |
| Previous Owner | Figgins James R | $39,973 | |
| Previous Owner | Figgins James R | $15,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 |
|---|---|---|---|---|---|
| 04/15/2021 04/15/21 | Sold | $410,000 | +3.8% | $169 / Sq Ft | |
| 03/04/2021 03/04/21 | Pending | -- | -- | -- | |
| 03/01/2021 03/01/21 | For Sale | $394,900 | +33.9% | $163 / Sq Ft | |
| 01/09/2019 01/09/19 | Off Market | $295,000 | -- | -- | |
| 10/10/2018 10/10/18 | Sold | $295,000 | -1.6% | $136 / Sq Ft | View Prior Sale |
| 09/04/2018 09/04/18 | Pending | -- | -- | -- | |
| 08/25/2018 08/25/18 | For Sale | $299,900 | -- | $138 / 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 | $8,270 | $143,501 | $19,373 | $124,128 |
| 2024 | $7,675 | $143,501 | $19,373 | $124,128 |
| 2023 | $7,716 | $143,501 | $19,373 | $124,128 |
| 2022 | $6,809 | $103,251 | $19,051 | $84,200 |
| 2021 | $6,756 | $103,251 | $19,051 | $84,200 |
| 2020 | $6,819 | $103,251 | $19,051 | $84,200 |
| 2019 | $5,410 | $76,332 | $16,146 | $60,186 |
| 2018 | $4,853 | $76,332 | $16,146 | $60,186 |
| 2017 | $4,602 | $76,332 | $16,146 | $60,186 |
| 2016 | $5,051 | $82,702 | $16,146 | $66,556 |
| 2015 | $5,095 | $82,702 | $16,146 | $66,556 |
| 2014 | $5,104 | $82,702 | $16,146 | $66,556 |
| 2013 | $4,859 | $82,702 | $16,146 | $66,556 |
Source: Public Records
Agents Affiliated with this Home
-
Kevin Hildebrand
Seller's Agent in 2021
Kevin Hildebrand
eXp Realty
(513) 509-5677
617 Total Sales
-
Michael Stylski
Seller Co-Listing Agent in 2021
Michael Stylski
Comey & Shepherd
(513) 264-9340
125 Total Sales
-
Michele Donovan
Buyer's Agent in 2021
Michele Donovan
Coldwell Banker Realty
(513) 919-2718
232 Total Sales
-
Mark Schupp
Seller's Agent in 2018
Mark Schupp
Sibcy Cline, Inc.
(513) 543-1477
326 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1691152
APN: 510-0270-0225
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
- 10960 Gosling Rd
- 5159 W Kemper Rd
- 5391 Stonetrace Dr
- 5250 Yeatman Rd
- 11930 Stone Mill Rd
- 10919 Kristiridge Dr
- 4875 W Kemper Rd
- 2117 Cardinal Ave
- 2183 Thrush Ave
- 2273 Cardinal Ave
- 6067 Day Rd
- 10415 E Miami River Rd
- 5560 Birch Dr
- 2392 Cardinal Ave
- 4235 Hamilton Cleves Rd
- 10811 Colerain Ave
- 11627 Bank Rd
- 4498 Day Rd
- 2829 Wyatt Way
- 3882 Piper Ln
- 5785 Squirrelsnest Ln
- 5763 Squirrelsnest Ln
- 5780 Squirrelsnest Ln
- 5770 Squirrelsnest Ln
- 5797 Squirrelsnest Ln
- 5757 Squirrelsnest Ln
- 5800 Squirrelsnest Ln
- 5758 Squirrelsnest Ln
- 5810 Squirrelsnest Ln
- 5809 Squirrelsnest Ln
- 5813 Squirrelsnest Ln
- 5752 Squirrelsnest Ln
- 5820 Squirrelsnest Ln
- 5744 Squirrelsnest Ln
- 55 Squirrelsnest Ln Unit 55
- 4273 Miamitrail Ln
- 5815 Squirrelsnest Ln
- 5821 Squirrelsnest Ln
- 5750 Squirrelsnest Ln
- 5817 Squirrelsnest Ln
Your Personal Tour Guide
Ask me questions while you tour the home.