Seller's Agent in 2025
Julie Mai
Horan Rosenhagen Real Estate
(859) 760-4104
16 in this area
175 Total Sales
587 Deer Run Rd Cold Spring, KY 41076
4
Beds
4.5
Baths
6,048
Sq Ft
1.91
Acres
Highlights
- Wine Cellar
- In Ground Pool
- 1.91 Acre Lot
- Media Room
- View of Trees or Woods
- Deck
About This Home
As of May 2025This stunning estate on 1.9 private acres is the ultimate blend of luxury and functionality, offering over 6,000 sq. ft. of finished living space! Step inside to soaring ceilings, a massive living room with a fireplace, and a kitchen built for entertaining. The first-floor en-suite is perfect for convenience, while the second level offers another en-suite, a Jack & Jill bath, and an open loft overlooking the main level.
But wait until you see the walkout basement—this is next-level living! A huge family room, wet bar, MOVIE ROOM, wine cellar, secondary laundry, and TWO bonus rooms (think extra sleeping areas, gym, or home office). It's a home within a home!
Outside? Pure paradise! A composite deck, pool, and private wooded views make this home an entertainer's dream.
Location. Space. Privacy. This is the one you've been waiting for—don't miss out! Schedule your showing today!
Last Agent to Sell the Property
Horan Rosenhagen Real Estate License #214982 Listed on: 03/28/2025
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $6,022
Year Built
- Built in 2006
Lot Details
- 1.91 Acre Lot
- Property fronts a county road
- Property fronts an easement
- Lot Has A Rolling Slope
- Wooded Lot
- Private Yard
Parking
- 3 Car Garage
- Side Facing Garage
- Driveway
- Off-Street Parking
Property Views
- Woods
- Valley
Home Design
- Traditional Architecture
- Brick Veneer
- Poured Concrete
- Shingle Roof
Interior Spaces
- 6,048 Sq Ft Home
- 2-Story Property
- Wet Bar
- Vaulted Ceiling
- Ceiling Fan
- Chandelier
- Electric Fireplace
- Vinyl Clad Windows
- Entrance Foyer
- Wine Cellar
- Family Room
- Living Room
- Breakfast Room
- Formal Dining Room
- Media Room
- Den
- Recreation Room
- Loft
- Storage
Kitchen
- Eat-In Kitchen
- Butlers Pantry
- Electric Oven
- Electric Cooktop
- Microwave
- Dishwasher
- Solid Surface Countertops
- Utility Sink
- Trash Compactor
- Disposal
Flooring
- Carpet
- Laminate
- Ceramic Tile
Bedrooms and Bathrooms
- 4 Bedrooms
- En-Suite Bathroom
- Walk-In Closet
- Double Vanity
- Bathtub with Shower
- Shower Only
Laundry
- Laundry Room
- Laundry on main level
- Dryer
- Washer
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Kitchen in Basement
- Finished Basement Bathroom
- Laundry in Basement
- Basement Storage
Outdoor Features
- In Ground Pool
- Deck
- Patio
- Shed
Schools
- Donald E.Cline Elementary School
- Campbell County Middle School
- Campbell County High School
Utilities
- Central Air
- Heat Pump System
- Septic Tank
Community Details
- No Home Owners Association
Listing and Financial Details
- Assessor Parcel Number 999-99-19-907.10
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Closed on
May 1, 2017
Sold by
Hoover James Alan
Bought by
Stortz Ryan M and Stortz Allison N
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
$381,900
Outstanding Balance
$316,463
Interest Rate
4.23%
Mortgage Type
New Conventional
Estimated Equity
$462,385
Purchase Details
Closed on
Oct 17, 2013
Sold by
Keairns Vincent S and Keairns Renai C
Bought by
Hoover James Alan
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$417,000
Interest Rate
4.57%
Mortgage Type
New Conventional
Purchase Details
Closed on
Feb 16, 2010
Sold by
Neises Daniel L and Tharp Jennifer W
Bought by
Keairns Vincent S and Keairns Renai C
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$250,000
Interest Rate
4.97%
Mortgage Type
New Conventional
Purchase Details
Closed on
Apr 20, 2005
Sold by
Schenk John J and Schenk Gloria
Bought by
Neises Daniel L and Tharp Jennifer W
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 Values in the Area
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $477,400 | Sterling Land Title Agency I | |
| Warranty Deed | $450,000 | Lawyers Title Of Cincinnati | |
| Warranty Deed | $360,000 | Homestead Title Agency Ltd | |
| Deed | $52,200 | None Available |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $381,900 | New Conventional | |
| Previous Owner | $417,000 | New Conventional | |
| Previous Owner | $250,000 | New Conventional |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 05/28/2025 05/28/25 | Sold | $775,000 | -6.0% | $128 / Sq Ft |
| 04/28/2025 04/28/25 | Pending | -- | -- | -- |
| 04/23/2025 04/23/25 | Price Changed | $824,900 | -2.9% | $136 / Sq Ft |
| 03/28/2025 03/28/25 | For Sale | $849,900 | -- | $141 / Sq Ft |
Source: Northern Kentucky Multiple Listing Service
Tax History Compared to Growth
Tax History
| 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,022 | $618,000 | $75,000 | $543,000 |
| 2024 | $6,022 | $490,400 | $65,000 | $425,400 |
| 2023 | $5,885 | $490,400 | $65,000 | $425,400 |
| 2022 | $6,077 | $490,400 | $65,000 | $425,400 |
| 2021 | $6,077 | $490,400 | $65,000 | $425,400 |
| 2020 | $5,981 | $477,400 | $52,000 | $425,400 |
| 2019 | $5,877 | $477,400 | $52,000 | $425,400 |
| 2018 | $5,917 | $477,400 | $52,000 | $425,400 |
| 2017 | $5,506 | $450,000 | $52,000 | $398,000 |
| 2016 | $5,411 | $450,000 | $0 | $0 |
| 2015 | $5,498 | $450,000 | $0 | $0 |
| 2014 | $5,359 | $450,000 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Julie Mai
-
Nicholas Groh
Buyer's Agent in 2025
Nicholas Groh
Horan Rosenhagen Real Estate
(859) 620-2169
5 in this area
95 Total Sales
Map
Source: Northern Kentucky Multiple Listing Service
MLS Number: 631064
APN: 999-99-19-907.10
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 web site comes in part from the Internet Data Exchange Program of NKMLS. Real estate listings held by IDX Brokerage firms other than Ten-X are marked with the Internet Data Exchange logo or the Internet Data Exchange thumbnail logo and detailed information about them includes the name of the listing Brokers.
Listing information is deemed reliable, but not guaranteed.
Copyright 2025 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.
Nearby Homes
- 368 Shadow Ridge Dr Unit 24B
- 0 Licking Pike Unit 637023
- 629 Lake Watch Ct Unit 11B
- 503 Shadow Ridge Dr
- 150 Hidden Ridge Ct
- 363 Hidden Valley Rd
- 0 Aa-Hwy & Rocky View Unit 553765
- 315 Ivy Ridge Dr Unit 315
- 201 Thornbush Ct
- 714 Streamside Dr Unit L
- 762 Yorkshire Dr
- 600 Ivy Ridge Dr
- 7446 Cheshire Ct
- Lot 40 Dry Creek Rd
- Lot 42 Dry Creek Rd
- Lot 41 Dry Creek Rd
- 0 Dry Creek Road 4 56 Acres Unit 620727
- Lot 39 Dry Creek Rd
- 7523 Devonshire Dr
- 7797 Promontory Dr