Sold
Last Sold Price
4 beds6,048 sqft
587 Deer Run Road, Newport, KY 41076
Single FamilyProperty Type
1.91 acresLot Size
2006Year Built
$128/sq ftPrice per sq ft
3 carsParking Spaces

Description

This 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...This 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!
  • Listed by: Horan Group 859.760.4104 jmai@horanrosenhagen.com • Horan Rosenhagen Real Estate
Listing closed: 05/28/2025 12:00 AM • Source: Northern Kentucky Multiple Listing Service, MLS#: 631064

See It First on Compass

Find homes before they're listed on other real estate sites.

Start your search

Location

Listing Courtesy of Horan Rosenhagen Real Estate

Sold By Horan Rosenhagen Real Estate

Add your commute

Payment Calculator

$4,629 per month

30 year fixed, 6.71% Interest

Principal and Interest

$4,005

Property Taxes

$624

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 587 Deer Run Road

Property Details
  • MLS Type: Residential / Single Family Residence
  • Has View: Yes
  • Architectural Style: Traditional
  • View: Trees/Woods, Valley
  • Zoning Description: Residential
Building Information
  • Year Built: 2006
  • Lot Size: 1.91 AC / 83,199 SF
Summary
Location and General Information
  • Longitude: -84.429548
  • Latitude: 38.991378
  • Directions: AA HWY to Licking Pike to Deer Run
  • MLSArea Major: K18 - Cold Spring/Crestvw
  • MLSArea Minor: K18 - Cold Spring/Crestvw
  • Year Built Known: Yes
  • Property Condition Disclosure: Yes
  • SIC: RP - Rural Campbell
Taxes and HOA
  • Association: No
  • Parcel Number: 999-99-19-907.10
  • Tax Rate: 11.46
School Information
  • High School District: Campbell Co Public
  • Elementary School: Donald E.Cline Elem
  • Middle Or Junior School: Campbell County Middle School
  • High School: Campbell County High
Parking
  • Parking Features: Driveway, Off Street, Garage Faces Side, Garage
  • Attached Garage: No
  • Garage: Yes
  • Garage Spaces: 3.0
Property
Lot Information
  • Road Frontage Type: County Road, Easement
  • Lot Size Units: Acres
  • Lot Size Square Feet: 83130.0
  • Lot Features: Wooded, Rolling Slope
  • Lot Size Acres: 1.9084
  • Lot Size Source: Realist
  • Lot Size Dimensions: irregular
  • Lot Size Area: 1.91
  • Road Surface Type: Paved
  • Lot Features: Wooded, Rolling Slope
Property and Assessments
  • New Construction: No
  • Year Built: 2006
  • Building Area Total: 6048.0
  • Property Condition: Existing Structure
  • Living Area: 6048.0
  • Living Area Units: Square Feet
  • Land Lease: Yes
  • Living Area Source: Public Records
  • Property Attached: No
  • Land Description: 1 to 4.9 Acres
Building Features
  • Levels: Two
  • Structure Type: House
  • Other Structures: Shed(s)
  • Foundation Details: Poured Concrete
  • Construction Materials: Brick Veneer
Utilities
  • Sewer: Septic Tank
  • Water Source: Public
  • Electric Company: Duke
  • Water Company: NKY Water
Interior and Exterior Features
Interior Features
  • Bathrooms: 4
  • Appliances: Trash Compactor, Disposal, Dryer, Dishwasher, Microwave, Refrigerator, Washer, Electric Range, Electric Oven, Electric Cooktop
  • Bathrooms Half: 1
  • Cooling: Central Air
  • Fireplaces Total: 1
  • Fireplace: Yes
  • Window Features: Vinyl Frames
  • Has Heating: Yes
  • Has Cooling: Yes
  • Basement: Full, Walk-Out Access, Full Finished Bath, Finished, Kitchen, Other, Storage Space
  • Interior Features: Wet Bar, Ceiling Fan(s), Vaulted Ceiling(s), Butler's Pantry, Chandelier, Double Vanity, Entrance Foyer, Storage, Walk-In Closet(s)
  • Rooms Total: 18
  • Laundry Features: Main Level, In Basement
  • Heating: Electric, Heat Pump
  • Fireplace Features: Electric
Exterior Features
  • Exterior Features: Private Yard
  • Patio And Porch Features: Deck, Patio
  • Pool Features: In Ground
  • Roof: Shingle
Room Information
Room 1
  • Room Features: Entrance Foyer, Tile Flooring
  • Room Type: Entry
  • Room Length: 18.0
  • Room Level: First
  • Room Width: 6.0
  • Room Dimensions: 18 x 6
Room 2
  • Room Features: Carpet Flooring, Chandelier
  • Room Type: Dining Room
  • Room Length: 13.0
  • Room Level: First
  • Room Width: 15.0
  • Room Dimensions: 13 x 15
Room 3
  • Room Features: See Remarks
  • Room Type: Den
  • Room Length: 14.0
  • Room Level: First
  • Room Width: 11.0
  • Room Dimensions: 14 x 11
  • Room Description: formal sitting room/carpet flooring
Room 4
  • Room Features: See Remarks
  • Room Type: Bathroom 4
  • Room Length: 5.0
  • Room Level: First
  • Room Width: 5.0
  • Room Dimensions: 5 x 5
Room 5
  • Room Features: Fireplace(s), Carpet Flooring, High Ceilings
  • Room Type: Living Room
  • Room Length: 32.0
  • Room Level: First
  • Room Width: 18.0
  • Room Dimensions: 32 x 18
Room 6
  • Room Features: Butler's Pantry, Wood Cabinets, Solid Surface Counters, Ceramic Tile Flooring, Tile Flooring
  • Room Type: Kitchen
  • Room Length: 14.0
  • Room Level: First
  • Room Width: 14.0
  • Room Dimensions: 14 x 14
Room 7
  • Room Features: Tile Flooring
  • Room Type: Breakfast Room
  • Room Length: 13.0
  • Room Level: First
  • Room Width: 12.0
  • Room Dimensions: 13 x 12
Room 8
  • Room Features: Carpet Flooring, Walk-In Closet(s), Bath Adjoins, High Ceilings, Ceiling Fan(s), Vaulted Ceiling(s)
  • Room Type: Primary Bedroom
  • Room Length: 20.0
  • Room Level: First
  • Room Width: 15.0
  • Room Dimensions: 20 x 15
Room 9
  • Room Features: Ceramic Tile Flooring, Double Vanity, Shower, Tub
  • Room Type: Primary Bath
  • Room Length: 11.0
  • Room Level: First
  • Room Width: 14.0
  • Room Dimensions: 11 x 14
Room 10
  • Room Features: Walk-Out Access, Utility Sink, Tile Flooring
  • Room Type: Laundry
  • Room Length: 9.0
  • Room Level: First
  • Room Width: 5.0
  • Room Dimensions: 9 x 5
Room 11
  • Room Features: Carpet Flooring, Walk-In Closet(s), Bath Adjoins
  • Room Type: Bedroom 2
  • Room Length: 20.0
  • Room Level: Second
  • Room Width: 16.0
  • Room Dimensions: 20 x 16
Room 12
  • Room Features: Shower, Tile Flooring
  • Room Type: Bathroom 2
  • Room Length: 9.0
  • Room Level: Second
  • Room Width: 5.0
  • Room Dimensions: 9 x 5

Property History for 587 Deer Run Road

DateEvent & SourcePriceAppreciation
May 28, 2025

Sold (Public Record)

Public Record #1558333703

$775,000

+6.2% / yr

May 28, 2025

Sold

Northern Kentucky Multiple Listing Service #631064

$775,000
Apr 29, 2025

Contract Signed

Northern Kentucky Multiple Listing Service #631064

DateEvent & SourcePrice
05/28/2025

Sold (Public Record)

Public Record #1558333703

$775,000

+6.2% / yr

05/28/2025

Sold

Northern Kentucky Multiple Listing Service #631064

$775,000
04/29/2025

Contract Signed

Northern Kentucky Multiple Listing Service #631064

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 587 Deer Run Road

Taxable ValueLand$75,000Additions$543,000Total$618,000
Tax Record2025$7,490 ($624 / month)
Home Facts
Beds4Total Finished SqFt4,118 SqFtAbove Grade Finished SqFt4,118 SqFtStories2Lot Size83,112 SqFtStyleSingle Family ResidenceYear Built2006CountyCAMPBELLAPN999-99-19-907.10

Schools near 587 Deer Run Road

This home is within Campbell County.
Rating
School
Type
Grades
Distance
Public - PK to 5
Public - 6 to 8
Public - 9 to 12
Public - 6 to 12
Rating
School
Distance
Donald E. Cline Elementary School
PublicPK to 5

Campbell County Middle School
Public6 to 8

Campbell County High School
Public9 to 12

Alexandria Educational Center
Public6 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

New listings in 41076

$290,000 | 613 Monterey Lane, Newport, KY 41076
1/48
Listed By Coldwell Banker RealtyNew

$290,000

3
Bedrooms
1,899
Square Feet
0.22
Acres
$349,900 | 320 Shadow Ridge Drive, Newport, KY 41076
1/53

$349,900

2
Bedrooms
2,175
Square Feet
$225,000 | 302 Mendocino Court, Unit 303, Newport, KY 41076
1/44

$225,000

2
Bedrooms
1,162
Square Feet
$206,000 | 614 Ivy Ridge Drive, Newport, KY 41076
1/42

$206,000

2
Bedrooms
1,276
Square Feet
$225,000 | 208 South Watchtower Drive, Unit 304, Newport, KY 41076
1/51

$225,000

3
Bedrooms
1,562
Square Feet
$425,000 | 4029 Alexandria Pike, Newport, KY 41076
1/38

$425,000

3
Bedrooms
1,740
Square Feet
0.32
Acres
$1,200,000 | 1143-1147 Steffen Lane, Wilder, KY 41076
1/2

$1,200,000

8
Bedrooms
Unavailable
Bathrooms
Unavailable
Square Feet
12
Acres
$310,000 | 507 Shadow Ridge Drive, Newport, KY 41076
1/20

$310,000

3
Bedrooms
2,624
Square Feet
$300,000 | 6026 Marble Way, Newport, KY 41076
1/44

$300,000

2
Bedrooms
1,870
Square Feet

Nearby home values

AddressSold priceBedsBathsSqftLot (Sqft)
This home: 587 Deer Run Road, Newport, KY 41076
$775,000
4
6,048
83,199
$445,000
5
220,413
$278,000
3
1,600
53,143
$254,000
3
1,547
65,775
67,170
$550,000
3
2,059
60,983

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Horan Rosenhagen Real Estate

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 Compass and its related brokerages 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.