Kerry Schrand-Rawe
Huff Realty - Florence
(859) 600-0975
41 Total Sales
4 in Union
$342K - $520K Price Range
Exceptional living in the sought-after Cool Springs community!
Tucked away on a quiet cul-de-sac, this meticulously maintained 4-bedroom residence offers over 6,600 sq. ft. of beautifully finished living space--showcasing true pride of ownership at every turn.
Designed for both everyday comfort and impressive entertaining, the home features a gourmet kitchen with double ovens, seamlessly flowing into a dramatic two-story great room highlighted by a gas fireplace and built-in speaker system throughout the first floor.
The luxurious primary suite is a private retreat, complete with a cozy sitting area, spa-inspired bath, and an expansive walk-in closet with a custom organization system.
The finished walkout lower level is an entertainer's dream--featuring a spacious family room, wet bar, bonus room, full bath, and direct access to the patio.
Step outside and enjoy multiple outdoor living spaces, including two covered decks, a private patio with hot tub, and professionally designed landscaping with custom stonework and lighting--perfect for relaxing or hosting gatherings.
Additional highlights include dual staircases, a beautifully landscaped half-acre lot, and a prime location just minutes from schools, shopping, and dining.
Enjoy the lifestyle you've been waiting for--complete with neighborhood pool amenities in the highly desirable Cool Springs community.
Last Agent to Sell the Property
Comey & Shepherd REALTORS License #202788 Listed on: 04/02/2026
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Kerry Schrand-Rawe
Huff Realty - Florence
(859) 600-0975
41 Total Sales
4 in Union
$342K - $520K Price Range
Ken Warden
Warden & Associates
(859) 600-0843
25 Total Sales
2 in Union
$340,000 Price Range
Andrew Lohmiller
Lohmiller Real Estate
(812) 577-9616
56 Total Sales
1 in Union
$580,000 Price
Jessica Reeves
Sibcy Cline, REALTORS-Florence
(859) 600-0257
65 Total Sales
2 in Union
$158K - $863K Price Range
Linda Mildon
RE/MAX Victory + Affiliates
(859) 600-1626
142 Total Sales
27 in Union
$55K - $870K Price Range
Cathy Miles
Miles Home Team, LLC
(513) 586-5142
158 Total Sales
13 in Union
$165K - $840K Price Range
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 | Type | Sale Price | Title Company |
|---|---|---|---|
| Deed | $830,000 | Guardian Title | |
| Warranty Deed | $501,040 | Stonebridge Land Title |
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 | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $622,500 | New Conventional | |
| Previous Owner | $430,750 | VA | |
| Previous Owner | $400,800 | New Conventional |
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 |
|---|---|---|---|---|
| 05/29/2026 05/29/26 | Sold | $830,000 | +2.5% | $124 / Sq Ft |
| 04/15/2026 04/15/26 | Pending | -- | -- | -- |
| 04/02/2026 04/02/26 | For Sale | $810,000 | -- | $121 / Sq Ft |
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 | $6,672 | $590,300 | $80,000 | $510,300 |
| 2024 | $5,458 | $490,000 | $55,000 | $435,000 |
| 2023 | $5,576 | $490,000 | $55,000 | $435,000 |
| 2022 | $5,501 | $490,000 | $55,000 | $435,000 |
| 2021 | $5,588 | $490,000 | $55,000 | $435,000 |
| 2020 | $5,610 | $490,000 | $55,000 | $435,000 |
| 2019 | $5,676 | $490,000 | $55,000 | $435,000 |
| 2018 | $5,666 | $490,000 | $55,000 | $435,000 |
| 2017 | $5,591 | $490,000 | $55,000 | $435,000 |
| 2015 | $5,522 | $490,000 | $55,000 | $435,000 |
| 2013 | -- | $490,000 | $55,000 | $435,000 |
Seller's Agent in 2026
Michael Dunn
Comey & Shepherd REALTORS
(859) 512-5155
75 Total Sales
Buyer's Agent in 2026
Aimee Pelletier
Sibcy Cline
(859) 750-1680
157 Total Sales
Source: Northern Kentucky Multiple Listing Service
MLS Number: 641126
APN: 064.00-16-143.00
Ask me questions while you tour the home.