Ben Schreiber
eXp Realty, LLC
(859) 600-6189
89 Total Sales
3 in Cold Spring
$170K - $320K Price Range
587 Deer Run Rd Cold Spring, KY 41076
Cold Spring AreaEstimated Value: $795,011
4
Beds
4.5
Baths
6,048
Sq Ft
$131/Sq Ft
Est. Value
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
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
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
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
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
Listed on
Mar 28, 2025
Closed on
May 28, 2025
Sold by
Bought by
Seller's Agent
Julie Mai
Horan Rosenhagen Real Estate
Buyer's Agent
Nicholas Groh
Horan Rosenhagen Real Estate
List Price
$849,900
Sold Price
$775,000
Premium/Discount to List
-$74,900
-8.81%
Views
105
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$20,011
Avg. Annual Appreciation
2.18%
Purchase Details
Closed on
May 1, 2017
Sold by
Bought by
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
Interest Rate
4.23%
Mortgage Type
New Conventional
Purchase Details
Closed on
Oct 17, 2013
Sold by
Bought by
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
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$38,000
Interest Rate
4.97%
Mortgage Type
Credit Line Revolving
Purchase Details
Closed on
Apr 20, 2005
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$345,000
Interest Rate
5.75%
Mortgage Type
Construction
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Cold Spring, KY
-
Ben Schreiber
-
Ken Warden
Ken Warden
Warden & Associates
(859) 600-0843
25 Total Sales
2 in Cold Spring
$235K - $330K Price Range
-
Heather Townsend
Heather Townsend
Huff Realty - Florence
(859) 739-3465
54 Total Sales
1 in Cold Spring
$242,500 Price
-
David Schneider
David Schneider
Blue Chicken Realty
(513) 586-5839
93 Total Sales
8 in Cold Spring
$135K - $395K Price Range
-
Kimberly Nachazel
Kimberly Nachazel
eXp Realty, LLC
(513) 802-9458
132 Total Sales
2 in Cold Spring
$195K - $225K Price Range
-
Jody Connett
JC
Jody Connett
Huff Realty - CC
(513) 586-6213
115 Total Sales
5 in Cold Spring
$175K - $305K Price Range
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 |
|---|---|---|---|
| $775,000 | Springdale Title | ||
| $477,400 | Sterling Land Title Agency I | ||
| $450,000 | Lawyers Title Of Cincinnati | ||
| $360,000 | Homestead Title Agency Ltd | ||
| $52,200 | None Available |
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 |
|---|---|---|---|
| Previous Owner | $100,000 | ||
| Previous Owner | $362,000 | ||
| Previous Owner | $381,900 | ||
| Previous Owner | $400,000 | ||
| Previous Owner | $417,000 | ||
| Previous Owner | $311,000 | ||
| Previous Owner | $38,000 | ||
| Previous Owner | $250,000 | ||
| Previous Owner | $340,000 | ||
| Previous Owner | $340,000 | ||
| Previous Owner | $18,200 | ||
| Previous Owner | $355,200 | ||
| Previous Owner | $345,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 |
|---|---|---|---|---|
| 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
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,490 | $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
Seller's Agent in 2025
Julie Mai
Horan Rosenhagen Real Estate
(859) 760-4104
196 Total Sales
-
Nicholas Groh
Buyer's Agent in 2025
Nicholas Groh
Horan Rosenhagen Real Estate
(859) 620-2169
92 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 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.
Nearby Homes
- 5700 Alexandria Pike
- 6862 Autumn Ln
- 502 Brookstone Ln Unit 19-E
- 0 Aa-Hwy & Rocky View Unit 553765
- 7262 Rimrock Ln
- 4 Springside Dr
- 1125 Cabin Creek West Dr
- 612 Inverness Way
- 7000 Alexandria Pike
- 615 Ivy Ridge Dr
- 7669 Arcadia Blvd
- 6069 Boulder View
- 0 Dry Creek Road 4 56 Acres Unit 640255
- 7423 Devonshire Dr
- 7541 Devonshire Dr
- 7580 Woodhaven Ct
- 7463 Flintshire Dr
- 6903 E Alexandria Pike
- 7610 Woodhaven Ct
- 7495 Flintshire Dr
- 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
- 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
- 576 Deer Run Rd
Your Personal Tour Guide
Ask me questions while you tour the home.