Barry Bates
Coldwell Banker Realty
(513) 993-6141
139 Total Sales
3 in Colerain
$226K - $389K Price Range
5813 Squirrelsnest Ln Cincinnati, OH 45252
Colerain AreaEstimated Value: $659,671
4
Beds
3.5
Baths
4,636
Sq Ft
$142/Sq Ft
Est. Value
Highlights
- View of Trees or Woods
- 1.73 Acre Lot
- Traditional Architecture
- Heated Floors
- Deck
- Outdoor Fireplace
About This Home
As of June 2024Welcome home to this captivating retreat on a private drive, offering serene wooded view on nearly 2 acres. This custom built home offers a harmonious blend of comfort & luxury perfect for family & entertaining. The walk-out lower level includes bedroom/office space, family room, wine room, bar w/ full kitchen, pool table & full bath. Outdoor oasis includes 4 Season Room, 2nd floor deck off the kitchen, spectacular in-ground gunite pool w/ plenty of seating on the patio, hot tub, stone fireplace, built-in grill & gorgeous stone walkway. This home has been meticulously maintained by original owners. Convenient highway access puts Kenwood Towne Center, Liberty Center, Kings Island, Aronoff & top private schools just minutes away.
Last Agent to Sell the Property
Coldwell Banker Realty License #2018001171 Listed on: 02/10/2024
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
- $8,472
Year Built
- Built in 1991
Lot Details
- 1.73 Acre Lot
HOA Fees
- $2 Monthly HOA Fees
Parking
- 2 Car Garage
Home Design
- Traditional Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
Interior Spaces
- 4,636 Sq Ft Home
- 2-Story Property
- Bookcases
- Woodwork
- Crown Molding
- Cathedral Ceiling
- Ceiling Fan
- Chandelier
- 2 Fireplaces
- Brick Fireplace
- Double Hung Windows
- Wood Frame Window
- Casement Windows
- Entrance Foyer
- Views of Woods
Kitchen
- Oven or Range
- Electric Cooktop
- Microwave
- Dishwasher
Flooring
- Wood
- Heated Floors
- Tile
Bedrooms and Bathrooms
- 4 Bedrooms
- Walk-In Closet
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
Outdoor Features
- Balcony
- Deck
- Patio
- Outdoor Fireplace
- Outdoor Kitchen
- Shed
Utilities
- Central Air
- Heating System Uses Gas
- Gas Water Heater
- Septic Tank
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 10, 2024
Closed on
May 30, 2024
Sold by
Colangelo Gregory and Colangelo Kimberly Jo
Bought by
Seller's Agent
Josie O'toole
Coldwell Banker Realty
Buyer's Agent
Mark Osterday
Comey & Shepherd
List Price
$749,900
Sold Price
$705,000
Premium/Discount to List
-$44,900
-5.99%
Views
490
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
-$45,329
Avg. Annual Appreciation
-2.84%
Original Mortgage
$728,265
Interest Rate
7.22%
Mortgage Type
VA
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Cincinnati, OH
-
Barry Bates
-
Roxane Leitsch
Roxane Leitsch
Martha Baker Realty, Inc.
(513) 657-1937
168 Total Sales
1 in Colerain
$137,000 Price
-
Steven Douglass
Steven Douglass
Comey & Shepherd
(513) 952-8792
135 Total Sales
2 in Colerain
$215K - $450K Price Range
-
Victor Godbey
Victor Godbey
Sibcy Cline, Inc.
(513) 612-9790
76 Total Sales
1 in Colerain
$105,000 Price
-
Janelle Sprandel
Janelle Sprandel
Comey & Shepherd REALTORS
(513) 599-0248
333 Total Sales
1 in Colerain
$550,000 Price
-
Brad Wells
Brad Wells
Lohmiller Real Estate
(812) 577-9791
34 Total Sales
1 in Colerain
$170,000 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 |
|---|---|---|---|
| $705,000 | None Listed On Document |
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 | $739,664 | ||
| Closed | Ormond Sean Patrick | $728,265 | |
| Previous Owner | Colangelo Gregory | $240,000 | |
| Previous Owner | Colagelo Gregory | $260,000 | |
| Previous Owner | Colangelo Gregory | $203,000 | |
| Previous Owner | Colangelo Gregory | $150,000 | |
| Previous Owner | Colangelo Gregory | $75,000 | |
| Previous Owner | Colangelo Gregory | $122,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 |
|---|---|---|---|---|
| 06/07/2024 06/07/24 | Sold | $705,000 | -1.4% | $152 / Sq Ft |
| 04/30/2024 04/30/24 | Pending | -- | -- | -- |
| 04/16/2024 04/16/24 | Price Changed | $714,900 | -4.7% | $154 / Sq Ft |
| 02/15/2024 02/15/24 | For Sale | $749,900 | 0.0% | $162 / Sq Ft |
| 02/15/2024 02/15/24 | Off Market | $749,900 | -- | -- |
| 02/10/2024 02/10/24 | For Sale | $749,900 | -- | $162 / 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 | $7,655 | $153,027 | $25,788 | $127,239 |
| 2024 | $8,198 | $153,027 | $25,788 | $127,239 |
| 2023 | $8,236 | $153,027 | $25,788 | $127,239 |
| 2022 | $8,451 | $128,143 | $25,358 | $102,785 |
| 2021 | $8,390 | $128,143 | $25,358 | $102,785 |
| 2020 | $8,463 | $128,143 | $25,358 | $102,785 |
| 2019 | $7,690 | $108,595 | $21,490 | $87,105 |
| 2018 | $6,898 | $108,595 | $21,490 | $87,105 |
| 2017 | $6,543 | $108,595 | $21,490 | $87,105 |
| 2016 | $7,256 | $118,825 | $21,490 | $97,335 |
| 2015 | $7,318 | $118,825 | $21,490 | $97,335 |
| 2014 | $7,331 | $118,825 | $21,490 | $97,335 |
| 2013 | $6,978 | $118,825 | $21,490 | $97,335 |
Source: Public Records
Agents Affiliated with this Home
-
Josie O'toole
Seller's Agent in 2024
Josie O'toole
Coldwell Banker Realty
(513) 404-3773
47 Total Sales
-
Mark Osterday
Buyer's Agent in 2024
Mark Osterday
Comey & Shepherd
(513) 470-7112
40 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1795888
APN: 510-0270-0221
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
- 10919 Kristiridge Dr
- 5391 Stonetrace Dr
- 5250 Yeatman Rd
- 11930 Stone Mill Rd
- 4875 W Kemper Rd
- 2117 Cardinal Ave
- 2183 Thrush Ave
- 5014 Airymeadows Dr
- 2273 Cardinal Ave
- 6067 Day Rd
- 5560 Birch Dr
- 2392 Cardinal Ave
- 4235 Hamilton Cleves Rd
- 10811 Colerain Ave
- 11627 Bank Rd
- 2829 Wyatt Way
- 4498 Day Rd
- 3644 Silax Dr
- 5815 Squirrelsnest Ln
- 5817 Squirrelsnest Ln
- 5809 Squirrelsnest Ln
- 5797 Squirrelsnest Ln
- 5785 Squirrelsnest Ln
- 5821 Squirrelsnest Ln
- 55 Squirrelsnest Ln Unit 55
- 5819 Squirrelsnest Ln
- 5775 Squirrelsnest Ln
- 5810 Squirrelsnest Ln
- 5833 Squirrelsnest Ln
- 5820 Squirrelsnest Ln
- 5830 Squirrelsnest Ln
- 5757 Squirrelsnest Ln
- 5800 Squirrelsnest Ln
- 5763 Squirrelsnest Ln
- 5780 Squirrelsnest Ln
- 5859 Squirrelsnest Ln
- 5844 Squirrelsnest Ln
- 5843 Squirrelsnest Ln
Your Personal Tour Guide
Ask me questions while you tour the home.