$609,900
$30K PRICE DROP

2011 Holderness Dr Union, KY 41091

Estimated payment $3,906/month

Total Views 14,428
5 Beds
3.5 Baths
5,255 Sq Ft
$116 Price per Sq Ft

Highlights

  • Docks
  • Home Theater
  • Open Floorplan
  • Shirley Mann Elementary School Rated A
  • View of Trees or Woods
  • Seasonal Lake or River

About This Home

Welcome to Your Dream Home in the Highly Sought-After Hampshire Subdivision in Union, KY! This beautiful 5-bedroom, 3.5-bath home offers over 5,000 square feet of luxurious living space—perfect for growing families or those who love to entertain. Nestled in one of Union's most desirable neighborhoods, this home seamlessly combines elegance, comfort, and convenience. Step inside to discover an oversized gourmet kitchen with updated appliances, a spacious island, and an expansive breakfast room—ideal for family gatherings and casual dining. The home also boasts a formal dining room and a dedicated home office, perfect for today's flexible work-from-home lifestyle. Enjoy movie nights in your private theater room, unwind at your custom bar in the fully finished basement, or host unforgettable summer parties on the huge trex deck overlooking your peaceful backyard. Freshly painted interior, Brand-new roof. Along with Top-rated schools: Ryle High School & Gray Middle School and Shirley Mann Elementary. Don't miss your chance to live in Hampshire! Schedule your private showing today and experience this incredible home for yourself.

Listing Agent

Aimee Pelletier

Sibcy Cline, REALTORS-Florence License #217983 Listed on: 06/17/2025

Sibcy Cline, REALTORS-Florence

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,765

Year Built

  • Built in 2007

Lot Details

  • 0.27 Acre Lot
  • Lot Has A Rolling Slope
  • Partially Wooded Lot
  • Private Yard

HOA Fees

  • $58 Monthly HOA Fees

Parking

  • 2 Car Garage
  • Front Facing Garage
  • Garage Door Opener
  • Driveway
  • On-Street Parking

Property Views

  • Woods
  • Neighborhood

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Asphalt Roof
  • Vinyl Siding
  • Stone

Interior Spaces

  • 5,255 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Wet Bar
  • Built-In Features
  • High Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Gas Fireplace
  • Insulated Windows
  • Double Hung Windows
  • Entrance Foyer
  • Great Room
  • Family Room
  • Living Room
  • Breakfast Room
  • Formal Dining Room
  • Home Theater
  • Recreation Room
  • Fire and Smoke Detector

Kitchen

  • Eat-In Kitchen
  • Electric Oven
  • Electric Range
  • Microwave
  • Dishwasher
  • Wine Cooler
  • Stainless Steel Appliances
  • Kitchen Island
  • Granite Countertops

Flooring

  • Carpet
  • Vinyl Plank

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet
  • Double Vanity
  • Soaking Tub

Laundry

  • Laundry Room
  • Laundry on main level
  • Electric Dryer Hookup

Basement

  • Basement Fills Entire Space Under The House
  • Finished Basement Bathroom
  • Basement Storage

Outdoor Features

  • Docks
  • Seasonal Lake or River
  • Covered patio or porch

Schools

  • Shirley Mann Elementary School
  • Gray Middle School
  • Ryle High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 063.00-26-101.00

Community Details

Overview

  • Association fees include management
  • Vertex Association, Phone Number (859) 491-5711

Recreation

  • Community Playground
  • Community Pool
  • Trails

Security

  • Resident Manager or Management On Site

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,765

Year Built

Built in 2007

Lot Details

0

HOA Fees

$58 per month

Parking

2

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.27
  • Year Built: 2007
  • Lot Size: Of Record
  • Road Frontage Type: City Street
  • Road Surface Type: Paved
  • Ownership: Consumer
  • Directions: Mount Zion Road to left onto Hempsteade, slight right onto Burleigh Lane left onto Holderness.
  • Architectural Style: Traditional
  • Garage Yn: Yes
  • New Construction: No
  • Property Attached Yn: No
  • Structure Type: House
  • Location Tax Legal Info:Property Attached YN: No
  • Location Tax Legal Info:New Construction: No
  • Location Tax Legal Info:Elementary School: Shirley Mann School
  • Location Tax Legal Info:Middle or Junior School: Gray Middle School
  • Location Tax Legal Info:High School: Ryle High
  • Contract Info:Auction YN: No
  • General Property Description:Half Baths: 1
  • General Property Description:Basement YN2: Yes
  • General Property Description:Fireplace YN: Yes
  • General Property Description:Lot Size Dimensions: Of Record
  • General Property Description:Approx SqFt2: 5255.0
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Sewer:Public Sewer: Yes
  • Utilities:Cable Available: Yes
  • Water Source:Public: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: Yes
  • General Property Description:Lot Size Acres: 0.2727
  • General Property Description:Living Area: 5255.0
  • General Property Description:Lot Size Square Feet: 11879.0
  • Structure Type:House: Yes
  • Laundry Features:Laundry Room2: Yes
  • Laundry Features:Main Level: Yes
  • Security Features:Smoke Detector(s): Yes
  • Architecture:Traditional: Yes
  • Levels:Two: Yes
  • Location Tax Legal Info:Tax ID: 063.00-26-101.00
  • Appliances Refrigerators: Yes
  • Laundry Features:Electric Dryer Hookup: Yes
  • General Property Description:Fireplaces Total: 1
  • View:TreesWoods: Yes
  • Vegetation:Partially Wooded: Yes
  • Roof:Asphalt: Yes
  • Special Features: None

Interior Features

  • Interior Amenities: Kitchen Island, Wet Bar, Walk-In Closet(s), Soaking Tub, Open Floorplan, Granite Counters, Entrance Foyer, Eat-in Kitchen, Double Vanity, Ceiling Fan(s), High Ceilings, Recessed Lighting, Built-in Features
  • Basement: Full Finished Bath, Full, Storage Space
  • Heating: Natural Gas, Forced Air
  • Levels: Two
  • Property Type: Residential
  • Appliances: Wine Cooler, Stainless Steel Appliance(s), Electric Oven, Electric Range, Dishwasher, Microwave, Refrigerator
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Fireplace Features: Gas
  • Fireplaces: 1
  • Fireplace: Yes
  • Living Area: 5255.0
  • Window Features: Insulated Windows, Double Hung
  • Full Basement: Yes
  • Appliances Dishwasher: Yes
  • Appliances:Electric Oven: Yes
  • Appliances:Stainless Steel Appliance(s): Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Interior Features:Double Vanity2: Yes
  • Interior Features:Entrance Foyer2: Yes
  • Interior Features:Granite Counters: Yes
  • Interior Features:High Ceilings: Yes
  • Interior Features:Kitchen Island2: Yes
  • Interior Features:Open Floorplan: Yes
  • Interior Features:Walk-In Closet(s)2: Yes
  • Interior Features:Wet Bar4: Yes
  • Appliances:Electric Range: Yes
  • Interior Features:Eat-in Kitchen2: Yes
  • Basement:Full Finished Bath: Yes
  • Basement:Storage Space: Yes
  • Basement:Carpet Flooring7: Yes
  • Fireplace Features:Gas: Yes
  • Interior Features:Recessed Lighting: Yes
  • Basement:Wet Bar5: Yes
  • Interior Features:Soaking Tub: Yes
  • Basement:Built-in Features3: Yes
  • Appliances:WineBeverage Cooler: Yes
  • Basement:Plank Flooring2: Yes

Exterior Features

  • View: Neighborhood, Trees/Woods
  • Roof: Asphalt
  • Lot Features: See Remarks, Rolling Slope, Wooded
  • View: Yes
  • Construction Type: Brick, Stone, Vinyl Siding
  • Exterior Features: Private Yard, Dock
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Covered, Porch
  • Construction Materials:Brick2: Yes
  • Construction Materials:Vinyl Siding: Yes
  • Window Features:Insulated Window(s): Yes
  • Patio and Porch Features:Covered: Yes
  • Patio and Porch Features:Porch: Yes
  • Construction Materials:Stone2: Yes
  • Window Features:Double Hung: Yes
  • Lot Features:Wooded: Yes
  • Exterior Features:Private Yard: Yes
  • Lot Features:Rolling Slope: Yes
  • Exterior Features:Dock: Yes
  • Lot Features:See Remarks44: Yes

Garage/Parking

  • Attached Garage: No
  • Parking Features: Driveway, Garage, Garage Door Opener, Garage Faces Front, On Street
  • General Property Description:Garage Spaces: 2.0
  • Parking Features:Driveway: Yes
  • Parking Features:Garage5: Yes
  • Parking Features:Garage Door Opener: Yes
  • Parking Features:Garage Faces Front: Yes
  • Parking Features:On Street: Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Electric Dryer Hookup, Laundry Room, Main Level
  • Security: Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Cable Available
  • Heating:Natural Gas2: Yes
  • Heating:Forced Air: Yes

Condo/Co-op/Association

  • Amenities: Lake Seasonal, Playground, Pool, Trail(s)
  • Association Fee: 700.0
  • Association Fee Frequency: Annually
  • Association: Yes

Association/Amenities

  • Association Information:Association YN: Yes
  • Association Information:Association Management Name 1: Vertex
  • Association Information:Association Management Phone 1: 8594915711
  • Association Information:Total Yearly Fees: 700.0
  • Association Information:Association Fee: 700.0
  • Association Information:Association Fee Frequency: Annually
  • Association Amenities:Management: Yes
  • Association Amenities:Playground: Yes
  • Association Amenities:Pool5: Yes
  • Association Amenities:Trail(s): Yes
  • Association Amenities:Lake Seasonal: Yes
  • Association Fee Includes:See Remarks34: Yes

Fee Information

  • Association Fee Includes: See Remarks, Management

Schools

  • Elementary School: Shirley Mann School
  • Junior High Dist: Boone Co Public
  • High School: Ryle High
  • Middle Or Junior School: Gray Middle School

Lot Info

  • Lot Size Sq Ft: 11879.0
  • Zoning Description: Residential

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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

Source: Public Records

Average Home Value in this Area





Source: Public Records

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
2024 $5,765 $518,000 $50,000 $468,000
2023 $5,895 $518,000 $50,000 $468,000
2022 $4,102 $365,400 $50,000 $315,400
2021 $4,186 $365,400 $50,000 $315,400
2020 $3,800 $331,900 $45,000 $286,900
2019 $3,844 $331,900 $45,000 $286,900
2018 $3,492 $299,500 $42,000 $257,500
2017 $3,417 $299,500 $42,000 $257,500
2015 $3,732 $331,120 $42,000 $289,120
2013 -- $331,120 $42,000 $289,120
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/29/2025 07/29/25 Price Changed $609,900 -1.6% $116 / Sq Ft
07/08/2025 07/08/25 Price Changed $619,900 -2.4% $118 / Sq Ft
06/26/2025 06/26/25 Price Changed $634,900 -0.8% $121 / Sq Ft
06/17/2025 06/17/25 For Sale $639,900 +23.5% $122 / Sq Ft
06/02/2022 06/02/22 Sold $518,000 +7.9% $99 / Sq Ft
04/09/2022 04/09/22 Pending -- -- --
04/07/2022 04/07/22 For Sale $480,000 -- $91 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

Purchase History

Date Type Sale Price Title Company
Warranty Deed $518,000 Lawyers Title
Warranty Deed $299,500 360 American Title Svcs Llc
Warranty Deed $331,115 Kentucky Land Title Agency
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $492,100 New Conventional
Previous Owner $253,435 New Conventional
Previous Owner $256,700 New Conventional
Previous Owner $275,793 FHA
Previous Owner $325,284 FHA
Previous Owner $334,989 FHA
Previous Owner $333,445 FHA
Previous Owner $328,518 FHA
Source: Public Records

Similar Homes in Union, KY

  • 10797 Saint Leger Cir, Union, KY 41091

    $699,900

    • 3 Beds
    • 2.5 Baths
    • 2,918 Sq Ft
    • 10797 Saint Leger Cir
    • Union, KY

    Discover the final new construction home available in the prestigious St. Leger neighborhood in Triple Crown, built by the renowned Tim Burks Builder, Inc. This elegantly designed model home showcases exceptional craftsmanship and high-end finishes throughout.Features & Highlights:Low-Maintenance Living: Homeowner fees cover lawn mowing, mulching, leaf removal, and

    Clayton Horan Horan Rosenhagen Real Estate

    Section Image
  • 8501 Robert Grant Dr, Union, KY 41091

    $709,146

    • 3 Beds
    • 2 Baths
    • 2,521 Sq Ft
    • 8501 Robert Grant Dr
    • Union, KY

    Stylish new Finley Modern European plan by Fischer Homes in beautiful Ballyshannon featuring a welcoming covered front porch. Once inside you'll find a private study with double door. Open concept with an island kitchen with built-in stainless steel appliances, upgraded maple cabinetry with 42 inch uppers and soft close hinges, durable quartz counters, walk-in pantry and walk-out breakfast room

    Section Image
  • 10070 Cedarwood Dr, Union, KY 41091

    $455,000

    • 4 Beds
    • 3.5 Baths
    • 10070 Cedarwood Dr
    • Union, KY

    Stunning 4-Bedroom Home with Finished Lower Level & Multi-Tier Deck!This beautifully maintained 2-story home offers 4 spacious bedrooms, 3.5 bathrooms, and a finished lower level complete with an exercise room. The first floor features elegant hardwood flooring, a cozy wood-burning fireplace, and a modern kitchen with stainless steel appliances. Step outside to enjoy the multi-tier deck—perfect

    Julie Ray-Ritchie Coldwell Banker Realty FM

    Section Image
  • 1807 Whispering Trail, Union, KY 41091

    $459,000

    • 4 Beds
    • 2.5 Baths
    • 2,730 Sq Ft
    • 1807 Whispering Trail
    • Union, KY

    Welcome to your dream home in the heart of Union! Nestled on a private street with plenty of space between neighbors, this beautiful, full brick, 2-story home offers the perfect blend of convenience and tranquility. Enjoy a large front yard and a secluded backyard — the upper back yard feels like your own nature sanctuary! Walk to the new parks, Union Promenade, and award-winning schools. Inside,

    Randi Jansen Keller Williams Realty Services

    Section Image
  • 10377 Brookhurst Ln N, Union, KY 41091

    $664,900

    • 5 Beds
    • 4 Baths
    • 3,364 Sq Ft
    • 10377 Brookhurst Ln N
    • Union, KY

    Celebrate living in the open, spacious Drees Homes Vanderburgh. From the charming exterior, step inside to discover an elegant formal dining room just off the main foyer. Beyond the foyer, a large central living area features an open arrangement of the family room with wall of windows, a well-equipped kitchen with convenient island, and casual dining area - the perfect space for relaxing or

    John Heisler Drees/Zaring Realty

    Section Image
  • 1239 Adison Ridge, Union, KY 41091

    $640,000

    • 4 Beds
    • 3.5 Baths
    • 1239 Adison Ridge
    • Union, KY

    Stunning 2-Sty Home in Sought-After Traemore Subdivision! Skip the wait of building—this brand new Buchanan model is move-in ready & priced $44K below reproduction cost! Located on a cul-de-sac st this home offers a spacious layout w/high-end finishes throughout. Inviting covered front porch*open-concept floor plan w/9-foot ceilings*LVP flooring throughout the 1st floor*Gourmet kitchen w/quartz

    Paula Ritter Sibcy Cline, REALTORS-Florence

    Section Image
  • 6685 Gordon Blvd, Union, KY 41091

    $489,900

    • 4 Beds
    • 4 Baths
    • 6685 Gordon Blvd
    • Union, KY

    Step inside the Ashton and view a welcoming foyer with a unique alcove flanked by two cloak closets. The formal dining room lets you entertain with ease. Beyond the foyer, a central living area includes an open family room with a relaxing fireplace, casual dining space and a well-equipped kitchen. Upstairs, the Ashton offers vaulted ceilings with four bedrooms, including the primary suite,

    John Heisler Drees/Zaring Realty

    Section Image
  • 815 Devin Ct, Union, KY 41091

    $464,900

    • 4 Beds
    • 4 Baths
    • 2,925 Sq Ft
    • 815 Devin Ct
    • Union, KY

    The Ashton, a popular floor plan is underway at Hawk's Landing. Step inside and view a welcoming foyer with a unique alcove flanked by two cloak closets. Beyond the foyer, a central living area includes an open family room, casual dining space and a well-equipped kitchen. A nicely sized flex room situated off the foyer can be used as a formal dining room, home office or whatever fits your

    John Heisler Drees/Zaring Realty

    Section Image
  • 12988 Pavilion Ct, Union, KY 41091

    $565,500

    • 4 Beds
    • 4.5 Baths
    • 4,352 Sq Ft
    • 12988 Pavilion Ct
    • Union, KY

    Gorgeous Zaring Premier 2-story brick home with freshly painted exterior trim. The spacious primary suite offers an oversized walk-in closet and a luxurious bath with spa tub and double vanity. Bedroom 2 features a private en-suite with tile flooring and tiled shower, while Bedrooms 3 and 4 share a Jack-and-Jill bath with double vanity. There is a laundry shoot in the upstairs hallway. The large

    Cara Klare Coldwell Banker Realty FM

    Section Image

Source: Northern Kentucky Multiple Listing Service

MLS Number: 633537

Northern Kentucky Multiple Listing Service

APN: 063.00-26-101.00