Robert Smith
Coldwell Banker Realty
(513) 599-1654
329 Total Sales
4 in Colerain
$333K - $487K Price Range
5712 Squirrelsnest Ln Cincinnati, OH 45252
Colerain AreaEstimated Value: $466,558
4
Beds
3
Baths
2,059
Sq Ft
$227/Sq Ft
Est. Value
Highlights
- Eat-In Gourmet Kitchen
- Deck
- Cathedral Ceiling
- View of Trees or Woods
- Ranch Style House
- Solid Surface Countertops
About This Home
As of May 2015Sharp all brick custom ranch w/open floor plan, updated neutral dcor,many quality features,2 bay bumpouts,new carpet,granite kit w/tons of storage/counter space. A/C 3yrs,newer kit & entry flrs,cathedral ceilings,4th bdrm & bath in lower level w/kit
Last Agent to Sell the Property
Lee Engleman
RE/MAX Preferred Group License #0000345120 Listed on: 02/25/2015
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
- $4,512
Year Built
- Built in 1991
Lot Details
- 1 Acre Lot
- Lot Dimensions are 155x291
Parking
- 2 Car Garage
- Driveway
- On-Street Parking
Home Design
- Ranch Style House
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
- Cedar
Interior Spaces
- 2,059 Sq Ft Home
- Chair Railings
- Woodwork
- Crown Molding
- Cathedral Ceiling
- Chandelier
- Wood Burning Fireplace
- Insulated Windows
- Double Hung Windows
- Bay Window
- Wood Frame Window
- Panel Doors
- Entrance Foyer
- Family Room
- Living Room with Fireplace
- Formal Dining Room
- Tile Flooring
- Views of Woods
Kitchen
- Eat-In Gourmet Kitchen
- Oven or Range
- Microwave
- Dishwasher
- Kitchen Island
- Solid Surface Countertops
- Solid Wood Cabinet
- Disposal
Bedrooms and Bathrooms
- 4 Bedrooms
- Walk-In Closet
- 3 Full Bathrooms
Partially Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
Outdoor Features
- Deck
- Patio
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
- Aerobic Septic System
Community Details
- No Home Owners Association
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
Sep 7, 2021
Sold by
Guenther Shail Lynne
Bought by
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$75,000
Outstanding Balance
$66,587
Interest Rate
2.8%
Mortgage Type
Credit Line Revolving
Estimated Equity
$399,971
Purchase Details
Listed on
Feb 25, 2015
Closed on
Jun 1, 2015
Sold by
Freese Larry C and Freese Patricia
Bought by
Guenther Glenn Edward and Guenther Shari Lynne
Seller's Agent
Lee Engleman
RE/MAX Preferred Group
Buyer's Agent
Karen Casey
RE/MAX Alliance Realty
List Price
$279,900
Sold Price
$262,500
Premium/Discount to List
-$17,400
-6.22%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.21%
Original Mortgage
$20,000
Interest Rate
3.65%
Mortgage Type
Credit Line Revolving
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Cincinnati, OH
-
Robert Smith
-
Cindy Shetterly
Cindy Shetterly
Keller Williams Realty Service
(513) 866-3124
525 Total Sales
6 in Colerain
$97K - $440K Price Range
-
Wendi Sheets
Wendi Sheets
eXp Realty
(513) 813-1446
212 Total Sales
1 in Colerain
$282,000 Price
-
Mark Schwab
Mark Schwab
OwnerLand Realty, Inc.
(513) 586-5203
41 Total Sales
2 in Colerain
$336K - $459K Price Range
-
Andrea White
Andrea White
White's Farm Est. 1922 DBA White's Realty
(513) 993-6674
125 Total Sales
1 in Colerain
$650,000 Price
-
Judith Maiden
Judith Maiden
Comey & Shepherd
(513) 866-8614
66 Total Sales
1 in Colerain
$119,900 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 |
|---|---|---|---|
| -- | Buckeye Land Title | ||
| Guenther Glenn Edward | $262,500 | 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 | $75,000 | ||
| Closed | Guenther Glenn Edward | $103,500 | |
| Closed | Guenther Glenn E | $75,000 | |
| Closed | Guenther Glenn Edward | $20,000 | |
| Closed | Guenther Glenn Edward | $118,000 | |
| Previous Owner | Freese Larry C | $75,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 |
|---|---|---|---|---|
| 08/31/2015 08/31/15 | Off Market | $262,500 | -- | -- |
| 05/30/2015 05/30/15 | Sold | $262,500 | -- | $127 / 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 | $5,915 | $102,624 | $18,956 | $83,668 |
| 2023 | $5,517 | $102,624 | $18,956 | $83,668 |
| 2022 | $7,136 | $108,413 | $18,645 | $89,768 |
| 2021 | $7,074 | $108,413 | $18,645 | $89,768 |
| 2020 | $7,149 | $108,413 | $18,645 | $89,768 |
| 2019 | $6,491 | $91,875 | $15,799 | $76,076 |
| 2018 | $5,822 | $91,875 | $15,799 | $76,076 |
| 2017 | $5,515 | $91,875 | $15,799 | $76,076 |
| 2016 | $5,002 | $82,208 | $15,799 | $66,409 |
| 2015 | $4,505 | $82,208 | $15,799 | $66,409 |
| 2014 | $4,513 | $82,208 | $15,799 | $66,409 |
| 2013 | $4,295 | $82,208 | $15,799 | $66,409 |
Source: Public Records
Agents Affiliated with this Home
-
LE
Seller's Agent in 2015
Lee Engleman
RE/MAX
-
Karen Casey
Buyer's Agent in 2015
Karen Casey
RE/MAX
(513) 312-0100
84 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1437581
APN: 510-0270-0175
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
- 5159 W Kemper Rd
- 5250 Yeatman Rd
- 11930 Stone Mill Rd
- 5391 Stonetrace Dr
- 4875 W Kemper Rd
- 10960 Gosling Rd
- 10919 Kristiridge Dr
- 5014 Airymeadows Dr
- 2117 Cardinal Ave
- 2183 Thrush Ave
- 2273 Cardinal Ave
- 10811 Colerain Ave
- 6067 Day Rd
- 5560 Birch Dr
- 2392 Cardinal Ave
- 11627 Bank Rd
- 4235 Hamilton Cleves Rd
- 4498 Day Rd
- 8738 Sarahs Bend Dr
- 8545 Noelle Dr
- 5698 Dunlap Rd
- 5702 Dunlap Rd
- 5705 Dunlap Rd
- 5704 Squirrelsnest Ln
- 5708 Dunlap Rd
- 5686 Dunlap Rd
- 5730 Squirrelsnest Ln
- 5714 Dunlap Rd
- 5715 Dunlap Rd
- 5744 Squirrelsnest Ln
- 5680 Dunlap Rd
- 5708 Squirrelsnest Ln
- 5673 Dunlap Rd
- 5672 Dunlap Rd
- 5750 Squirrelsnest Ln
- 5758 Squirrelsnest Ln
- 5665 Dunlap Rd
- 5665 Dunlap Rd Unit 1
- 5664 Dunlap Rd
- 5725 Dunlap Rd
Your Personal Tour Guide
Ask me questions while you tour the home.