Megan Mull
Plum Tree Realty
(513) 650-7793
32 Total Sales
1 in Union
$311,938 Price
Estimated Value: $962,950
Welcome to a masterpiece of design and comfort located in one of the area's most prestigious communities. This high-end ranch style home perfectly balances sophisticated architecture with a backyard oasis. Experience resort-style living with an inground heated pool, built in firepit, pool house with built-in grill, smoker, trash and fridge. The heart of the home has a seamless open floorplan with 10ft ceilings and covered in natural light, offering true first-floor living. The gourmet kitchen flows into the great room, perfect for hosting or quiet evenings in. The Primary Suite serves as a true sanctuary, featuring a spa-inspired master bath with a designer soaking tub and a massive custom-tiled shower. An oversized 4-car garage provides ample space for a collection or hobbyist. The lower level features 9ft ceilings with a walk-out to the pool area. Large rec room area with walk up wet bar. Separate work out room, extra bedroom with large windows and walk in. A dedicated room currently set up as a golf simulator area, but also perfect for a high-end home theater. Every finish reflects new construction! This is more than a home- It's a lifestyle!
Last Agent to Sell the Property
Keller Williams Realty Service License #260318 Listed on: 03/18/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.
Megan Mull
Plum Tree Realty
(513) 650-7793
32 Total Sales
1 in Union
$311,938 Price
Jimmy Dalton
Ashcraft Real Estate Services
(502) 482-5625
45 Total Sales
1 in Union
$1,200,000 Price
Cara Chitwood
Keller Williams Realty Service
(513) 854-6469
114 Total Sales
13 in Union
$200K - $619K Price Range
Kathy Crawford
ERA Real Solutions Realty
(859) 600-0770
39 Total Sales
5 in Union
$173K - $570K Price Range
Brandon Stamper
Plum Tree Realty
(859) 888-1472
129 Total Sales
10 in Union
$163K - $865K Price Range
Lena Keith
Pivot Realty Group
(859) 279-4304
110 Total Sales
5 in Union
$173K - $558K 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 | Buyer | Sale Price | Title Company |
|---|---|---|---|
| -- | Old Town Title | ||
| Mccarthy Justin Paul | $612,874 | Terry Monnie 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 | Borrower | Loan Amount |
|---|---|---|---|
| Open | $788,000 | ||
| Open | Richardson Thomas | $1,388,000 | |
| Previous Owner | Mccarthy Justin | $44,500 | |
| Previous Owner | Mccarthy Justin Paul | $547,900 |
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/13/2026 04/13/26 | Sold | $985,000 | -1.0% | $237 / Sq Ft | |
| 03/19/2026 03/19/26 | Pending | -- | -- | -- | |
| 03/18/2026 03/18/26 | For Sale | $995,000 | +59.5% | $240 / Sq Ft | |
| 06/03/2021 06/03/21 | For Sale | $623,654 | +1.8% | -- | |
| 05/19/2021 05/19/21 | Sold | $612,874 | -- | -- | View Prior Sale |
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,483 | $662,900 | $100,000 | $562,900 |
| 2024 | $7,357 | $662,900 | $100,000 | $562,900 |
| 2023 | $6,975 | $612,900 | $100,000 | $512,900 |
| 2022 | $6,881 | $612,900 | $100,000 | $512,900 |
| 2021 | $1,200 | $100,000 | $100,000 | $0 |
| 2020 | $1,030 | $90,000 | $90,000 | $0 |
| 2019 | $1,042 | $90,000 | $90,000 | $0 |
| 2018 | $1,027 | $90,000 | $90,000 | $0 |
Seller's Agent in 2026
Brooke Roscoe
Keller Williams Realty Service
(859) 803-3043
101 Total Sales
Buyer's Agent in 2026
Ryan Harvey
Wyndham Lyons Realty Ser LLC
(859) 640-2106
66 Total Sales
OA
Seller's Agent in 2021
Outside Agent
Outside Sales
Source: Northern Kentucky Multiple Listing Service
MLS Number: 640695
APN: 064.28-07-084.00
Ask me questions while you tour the home.