Ty Boeppler
Comey & Shepherd
(513) 493-1749
77 Total Sales
1 in Colerain
$344,000 Price
5884 Squirrelsnest Ln Cincinnati, OH 45252
Colerain AreaEstimated Value: $579,091
4
Beds
3.5
Baths
3,100
Sq Ft
$187/Sq Ft
Est. Value
Highlights
- View of Trees or Woods
- Covered Deck
- Wooded Lot
- Fireplace in Primary Bedroom
- Contemporary Architecture
- Main Floor Bedroom
About This Home
As of April 2018Park like neighborhood exceptional custom homes, backs to 30 acre nature persevere. Serenely situated on an acre. Spacious bright kitchen w/ butler pantry & wooded view from breakfast nook. Impressive two story entry w/ open stairs. 2nd flr bd rms have walk in closets & own full baths. Master w/ luxury bath, fr pl & balcony. Lovely private setting.
Last Agent to Sell the Property
RE/MAX Preferred Group License #0000333722 Listed on: 01/19/2018
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,307
Year Built
- Built in 1992
Lot Details
- 1 Acre Lot
- Lot Dimensions are 202 x 217
- Cul-De-Sac
- Wooded Lot
Parking
- 2 Car Garage
- Garage Door Opener
- Driveway
- Off-Street Parking
Home Design
- Contemporary Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
Interior Spaces
- 3,100 Sq Ft Home
- 2-Story Property
- Woodwork
- Crown Molding
- Ceiling height of 9 feet or more
- Chandelier
- Brick Fireplace
- Gas Fireplace
- Insulated Windows
- Wood Frame Window
- French Doors
- Panel Doors
- Living Room with Fireplace
- 2 Fireplaces
- Formal Dining Room
- Views of Woods
- Unfinished Basement
- Basement Fills Entire Space Under The House
Kitchen
- Eat-In Kitchen
- Breakfast Bar
- Oven or Range
- Microwave
- Dishwasher
- Kitchen Island
- Solid Wood Cabinet
- Disposal
Flooring
- Concrete
- Vinyl
Bedrooms and Bathrooms
- 4 Bedrooms
- Main Floor Bedroom
- Fireplace in Primary Bedroom
- Walk-In Closet
Outdoor Features
- Balcony
- Covered Deck
- Patio
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
- Septic Tank
Community Details
- No Home Owners Association
- Squirrelsnest 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
Closed on
Mar 12, 2020
Sold by
Whyle Zachary D
Bought by
Current Estimated Value
Purchase Details
Listed on
Jan 19, 2018
Closed on
Apr 23, 2018
Sold by
Bookbinder Andrew B
Bought by
Whyle Zachary D and Nguyen Thi Bich Dung
Seller's Agent
Roy Miller
RE/MAX Preferred Group
Buyer's Agent
Roy Miller
RE/MAX Preferred Group
List Price
$359,900
Sold Price
$320,000
Premium/Discount to List
-$39,900
-11.09%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.28%
Original Mortgage
$304,000
Interest Rate
4.45%
Mortgage Type
New Conventional
Purchase Details
Listed on
Dec 11, 2015
Closed on
Mar 18, 2016
Sold by
Royer Thomas J
Bought by
Bookbinder Andrew
Seller's Agent
Tom Deutsch
Coldwell Banker Realty
Buyer's Agent
Tom Deutsch
Coldwell Banker Realty
List Price
$299,950
Sold Price
$295,950
Premium/Discount to List
-$4,000
-1.33%
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.75%
Purchase Details
Closed on
Nov 5, 1992
Sold by
Landmark Communities Inc
Bought by
Royer Thomas J and Royer Felipa T
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Cincinnati, OH
-
Ty Boeppler
-
Jillian Sprague
Jillian Sprague
Plum Tree Realty
(513) 666-5175
69 Total Sales
3 in Colerain
$181K - $228K Price Range
-
Stephanie Mason
Stephanie Mason
Keller Williams Advisors
(513) 586-6909
82 Total Sales
2 in Colerain
$97K - $125K Price Range
-
Alex Wagner
Alex Wagner
Coldwell Banker Realty
(513) 854-1091
264 Total Sales
8 in Colerain
$170K - $442K Price Range
-
Teri Herrmann
Teri Herrmann
Keller Williams Seven Hills Re
(513) 586-4538
90 Total Sales
2 in Colerain
$221K - $392K Price Range
-
Adam Minehart
Adam Minehart
NavX Realty, LLC
(937) 717-3860
103 Total Sales
1 in Colerain
$313,500 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 |
|---|---|---|---|
| -- | None Available | ||
| Whyle Zachary D | $320,000 | None Available | |
| Bookbinder Andrew | $295,950 | -- | |
| Royer Thomas J | $278,700 | -- |
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 | $301,500 | ||
| Previous Owner | Whyle Zachary D | $304,000 | |
| Previous Owner | Royer Thomas J | $168,800 | |
| Previous Owner | Royer Thomas J | $46,500 | |
| Previous Owner | Royer T Jerry | $245,000 | |
| Previous Owner | Royer T Jerry | $100,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 |
|---|---|---|---|---|---|
| 07/23/2018 07/23/18 | Off Market | $320,000 | -- | -- | |
| 04/23/2018 04/23/18 | Sold | $320,000 | -5.2% | $103 / Sq Ft | |
| 03/19/2018 03/19/18 | Pending | -- | -- | -- | |
| 03/13/2018 03/13/18 | Price Changed | $337,555 | -0.6% | $109 / Sq Ft | |
| 03/09/2018 03/09/18 | Price Changed | $339,500 | -0.1% | $110 / Sq Ft | |
| 03/03/2018 03/03/18 | Price Changed | $340,000 | -2.2% | $110 / Sq Ft | |
| 02/24/2018 02/24/18 | Price Changed | $347,500 | -0.7% | $112 / Sq Ft | |
| 02/01/2018 02/01/18 | Price Changed | $350,000 | -2.8% | $113 / Sq Ft | |
| 01/21/2018 01/21/18 | For Sale | $359,900 | +21.6% | $116 / Sq Ft | |
| 06/12/2016 06/12/16 | Off Market | $295,950 | -- | -- | |
| 03/11/2016 03/11/16 | Sold | $295,950 | -- | $95 / Sq Ft | View Prior Sale |
| 01/30/2016 01/30/16 | Pending | -- | -- | -- |
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,937 | $155,373 | $18,918 | $136,455 |
| 2023 | $8,334 | $155,373 | $18,918 | $136,455 |
| 2022 | $7,449 | $112,000 | $18,606 | $93,394 |
| 2021 | $7,302 | $112,000 | $18,606 | $93,394 |
| 2020 | $7,379 | $112,000 | $18,606 | $93,394 |
| 2019 | $7,310 | $103,583 | $15,768 | $87,815 |
| 2018 | $6,555 | $103,583 | $15,768 | $87,815 |
| 2017 | $6,208 | $103,583 | $15,768 | $87,815 |
| 2016 | $6,291 | $103,583 | $15,768 | $87,815 |
| 2015 | $6,677 | $108,896 | $15,768 | $93,128 |
| 2014 | $6,688 | $108,896 | $15,768 | $93,128 |
| 2013 | $6,365 | $108,896 | $15,768 | $93,128 |
Source: Public Records
Agents Affiliated with this Home
-
Roy Miller
Seller's Agent in 2018
Roy Miller
RE/MAX Preferred Group
(513) 253-8838
67 Total Sales
-
Tom Deutsch
Seller's Agent in 2016
Tom Deutsch
Coldwell Banker Realty
(513) 460-5302
619 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1565220
APN: 510-0270-0191
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
- 2117 Cardinal Ave
- 2183 Thrush Ave
- 10919 Kristiridge Dr
- 5391 Stonetrace Dr
- 2273 Cardinal Ave
- 5159 W Kemper Rd
- 11930 Stone Mill Rd
- 5250 Yeatman Rd
- 2392 Cardinal Ave
- 5560 Birch Dr
- 4875 W Kemper Rd
- 4235 Hamilton Cleves Rd
- 6067 Day Rd
- 5014 Airymeadows Dr
- 10811 Colerain Ave
- 2829 Wyatt Way
- 3644 Silax Dr
- 3882 Piper Ln
- 2795 Venice Crossing Dr
- 5898 Squirrelsnest Ln
- 5870 Squirrelsnest Ln
- 5871 Squirrelsnest Ln
- 5889 Squirrelsnest Ln
- 5865 Squirrelsnest Ln
- 5910 Squirrelsnest Ln
- 5856 Squirrelsnest Ln
- 5911 Squirrelsnest Ln
- 5859 Squirrelsnest Ln
- 5932 Squirrelsnest Ln
- 5922 Squirrelsnest Ln
- 5844 Squirrelsnest Ln
- 5843 Squirrelsnest Ln
- 4288 Miamitrail Ln
- 5921 Squirrelsnest Ln
- 5833 Squirrelsnest Ln
- 5934 Squirrelsnest Ln
- 5841 Squirrelsnest Ln
- 5830 Squirrelsnest Ln
- 5931 Squirrelsnest Ln
Your Personal Tour Guide
Ask me questions while you tour the home.