Last Sold Price
4 beds6,048 sqft$128/sqft
587 Deer Run Road, Newport, KY 41076

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!
LISTING CLOSED: 05/28/2025 12:00 AM

  1. Listed by Horan Group • Horan Rosenhagen Real Estate
    P: (859) 760-4104 C: (859) 760-4104 jmai@horanrosenhagen.com

Property Details for 587 Deer Run Road

Status
MLS #
631064
Days on Market
31
Taxes
-
HOA Fees
-
Condo/Co-op Fees
-
Property Type
MLS Type
Residential / Single Family Residence
Year Built
2006
Lot Size
1.91 AC / 83,199 SF
Has View
Yes
Architectural Style
Traditional
View
Trees/Woods, Valley
Zoning Description
Residential

Recent comparable sales

Median sold price

$725,000

Avg days on market

100

Sale-to-list ratio

93.3%

Newport, KY

9 comparable properties found

$725,000 | 833 Sandstone Ridge, Newport, KY 41076
1/51
1

$725,000

Sold 05/08/26

4
Bedrooms
3,802
Square Feet
0.28
Acres
$1,799,000 | 111 Greggs Road, Newport, WA 99156
2

$1,799,000

Sold 06/23/25

4
Bedrooms
5
Bathrooms
6,744
Square Feet
12.9
Acres
$650,000 | 4342 Dewey Road, Newport, MI 48166
1/52
3

$650,000

Sold 12/06/24

4
Bedrooms
3,991
Square Feet
1.12
Acres
$595,400 | 507 Alpine Road, Newport, VA 24128
1/91
4

$595,400

Sold 02/03/25

4
Bedrooms
3,774
Square Feet
7.11
Acres
$740,000 | 6099 Cabin Creek E Drive, Newport, KY 41076
1/51
5

$740,000

Sold 01/29/26

3
Bedrooms
6,640
Square Feet
3.55
Acres
$735,000 | 268 Springfield Road, Newport, NH 03773
1/57
6

$735,000

Sold 02/17/26

4
Bedrooms
4,711
Square Feet
5
Acres
$997,900 | 855 Cannonsgate Drive, Newport, NC 28570
1/39
7

$997,900

Sold 12/16/24

4
Bedrooms
3,210
Square Feet
0.18
Acres
$415,000 | 5091 Holtz Drive, Newport, KY 41076
1/49
8

$415,000

Sold 05/30/25

4
Bedrooms
3,669
Square Feet
0.39
Acres
$550,000 | 539 Deer Run Road, Newport, KY 41076
1/2
9

$550,000

Sold 11/25/24

3
Bedrooms
2,059
Square Feet
1.40
Acres

Location

Listing Courtesy of Horan Rosenhagen Real Estate

Sold By Horan Rosenhagen Real Estate

Add your commute

Building Information for 587 Deer Run Road

Stories-Year Built2006Building Size-Lot Size1.91 AC / 83,199 SF

Payment Calculator

$4,563 per month

30 year fixed, 6.55% Interest

Principal and Interest

$3,939

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

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

$210,000 | 402 Napa Valley, Unit 203, Newport, KY 41076
1/6
Listed By Coldwell Banker RealtyNew

$210,000

2
Bedrooms
1,151
Square Feet
$205,000 | 7 Highland Meadows Drive, Unit 1, Newport, KY 41076
1/24

$205,000

2
Bedrooms
1,088
Square Feet
$310,000 | 507 Shadow Ridge Drive, Newport, KY 41076
1/20

$310,000

3
Bedrooms
2,624
Square Feet
$269,900 | 623 West Johns Hill Road, Wilder, KY 41076
1/53

$269,900

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

$300,000

2
Bedrooms
1,870
Square Feet
$265,000 | 2019 Uhl Road, Newport, KY 41076
1/19

$265,000

4
Bedrooms
1,530
Square Feet
0.32
Acres
$232,000 | 844 Flint Ridge, Newport, KY 41076
1/34

$232,000

2
Bedrooms
Unavailable
Square Feet
$220,000 | 4 Springside Drive, Newport, KY 41076
1/29
Listed By Coldwell Banker Realty

$220,000

2
Bedrooms
1,205
Square Feet
0.17
Acres
$160,000 | 562 Fawn Run Drive, Newport, KY 41076
1/28

$160,000

1
Bedrooms
834
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.