Seller's Agent in 2025
Julie Mai
Horan Rosenhagen Real Estate
(859) 760-4104
15 in this area
188 Total Sales
587 Deer Run Rd Cold Spring, KY 41076
Estimated Value: $750,591 - $800,000
4
Beds
4.5
Baths
6,048
Sq Ft
$127/Sq Ft
Est. Value
Highlights
- Wine Cellar
- Media Room
- View of Trees or Woods
- Donald E. Cline Elementary School Rated A
- In Ground Pool
- 1.91 Acre Lot
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
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
$453,935
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 | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Stortz Ryan M | $477,400 | Sterling Land Title Agency I | |
| Hoover James Alan | $450,000 | Lawyers Title Of Cincinnati | |
| Keairns Vincent S | $360,000 | Homestead Title Agency Ltd | |
| Neises Daniel L | $52,200 | None Available |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Stortz Ryan M | $381,900 | |
| Previous Owner | Hoover James Alan | $417,000 | |
| Previous Owner | Keairns Vincent S | $250,000 |
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
- 7268 Licking Pike
- 368 Shadow Ridge Dr Unit 24B
- 0 Licking Pike Unit 637023
- 608 Lake Watch Ct
- 363 Hidden Valley Rd
- 39 Sturbridge Dr
- 404 Millrace Dr
- 0 Aa-Hwy & Rocky View Unit 553765
- 315 Ivy Ridge Dr Unit 315
- 564 Inverness Way
- 201 Thornbush Ct
- 319 Fallingwater 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
- 6903 E Alexandria Pike
- 595 Deer Run Rd
- 599 Deer Run Rd
- 575 Deer Run Rd
- 555 Deer Run Rd
- 555 Deer Run Rd
- 600 Deer Run Rd
- 539 Deer Run Rd
- 539 Deer Run Rd
- 0 Deer Run Rd Unit 5 275448
- 0 Deer Run Rd Unit 6 275449
- 0 Deer Run Rd Unit 10 275452
- 0 Deer Run Rd Unit 7 275450
- 0 Deer Run Rd Unit 4 275447
- 0 Deer Run Rd Unit 9
- 14 Deer Run Rd
- 11 Deer Run Rd
- 7 Deer Run Rd
- 596 Deer Run Rd
- 596 Deer Run Rd
- 533 Deer Run Rd