$590,000
OPEN SUN 12:30PM - 2PM $10K PRICE DROP

2011 Holderness Dr Union, KY 41091

Estimated payment $3,638/month

Total Views 3,732
5 Beds
3.5 Baths
5,255 Sq Ft
$112 Price per Sq Ft

Highlights

  • Media Room
  • Open Floorplan
  • Recreation Room
  • Shirley Mann Elementary School Rated A
  • Deck
  • Traditional Architecture

About This Home

Reduced! Motivated seller! Why wait to build when you can move into this spacious 5 bedroom home in the sought after Hampshire subdivision in Union with low Boone County taxes and community pool amenities. Offering approximately 5,000 square feet across three finished levels, this home blends elegance and comfort with incredible spaces for entertaining both indoors and outdoors. Highlights include a soaring two story living room, new roof, fresh paint, new furnace in 2023, and new carpet in the media room in 2025. The gourmet kitchen features granite countertops, an oversized center island, updated appliances, and a bright breakfast area. Step outside to the Trex deck overlooking a private backyard perfect for gatherings or quiet evenings. The primary suite includes a gas fireplace and a luxurious ensuite bathroom. The finished lower level is ideal for entertaining with a wet bar, media room, fifth bedroom, and full bath. Situated on a cul de sac with abundant natural light and backyard privacy. All information believed accurate but buyer to verify.

Listing Agent

Liz Jacobs

Coldwell Banker Realty FM License #220545 Listed on: 09/18/2025

Coldwell Banker Realty FM

Open House Schedule

  • Sunday, December 14, 2025
    12:30 to 2:00 pm
    12/14/2025 12:30:00 PM +00:00
    12/14/2025 2:00:00 PM +00:00

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,864

Year Built

  • Built in 2008

Lot Details

  • 0.27 Acre Lot
  • Cul-De-Sac
  • Level Lot

HOA Fees

  • $54 Monthly HOA Fees

Parking

  • 2 Car Garage
  • Driveway
  • On-Street Parking

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof
  • Stucco
  • Stone

Interior Spaces

  • 5,255 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Built-In Features
  • High Ceiling
  • Ceiling Fan
  • Chandelier
  • Gas Fireplace
  • Insulated Windows
  • Entrance Foyer
  • Great Room
  • Family Room
  • Living Room
  • Formal Dining Room
  • Media Room
  • Recreation Room
  • Laundry Room

Kitchen

  • Breakfast Area or Nook
  • Eat-In Kitchen
  • Butlers Pantry
  • Electric Oven
  • Microwave
  • Dishwasher
  • Wine Cooler
  • Stainless Steel Appliances
  • Kitchen Island
  • Granite Countertops

Flooring

  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet
  • Double Vanity

Finished Basement

  • Finished Basement Bathroom
  • Basement Storage

Outdoor Features

  • Deck
  • Covered Patio or Porch

Schools

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

Utilities

  • Forced Air Heating and Cooling System

Listing and Financial Details

  • Court or third-party approval is required for the sale
  • Assessor Parcel Number 063.00-26-101.00

Community Details

Overview

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

Recreation

  • Community Pool

Security

  • Resident Manager or Management On Site

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,864

Year Built

Built in 2008

Lot Details

0

HOA Fees

$54 per month

Parking

2

Listing Details

  • Cooling: Central Air
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.27
  • Year Built: 2008
  • Lot Size: Of record
  • Ownership: Consumer
  • Directions: 75 to Mt Zion. Left on Pembrooke to left on Holderness. Home will be at the end of the cul-de-sac on the right.
  • Architectural Style: Traditional
  • 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
  • Location Tax Legal Info:Subdivision2: Hampshire
  • 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
  • Remarks Misc:Agent Only Remarks: This is not a Relocation Inventory home that a relocation company owns- but paperwork will go through sellers relocation company. Sellers will be able to negotiate all offers but will not be able to sign. Seller name to read WHR Group Inc. Seller willing to provide a 1-1 buy down. Reach out w/ any questions. This is an amazing home at a FANTASTIC PRICE!
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Roof:Shingle: Yes
  • Sewer:Public Sewer: Yes
  • Utilities:Natural Gas Available: Yes
  • Water Company: Boone County Water
  • 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:Lot Size Square Feet: 11879.0
  • Structure Type:House: Yes
  • Laundry Features:Laundry Room2: Yes
  • Architecture:Traditional: Yes
  • Levels:Two: Yes
  • Location Tax Legal Info:Tax ID: 063.00-26-101.00
  • Appliances Refrigerators: Yes
  • General Property Description:Fireplaces Total: 1
  • Utilities:Sewer Available: Yes
  • Percent Basement Finished: Yes
  • Special Listing Conditions:Third Party Approval: Yes
  • Special Features: OpenHouse

Interior Features

  • Interior Amenities: Kitchen Island, Open Floorplan, Granite Counters, Entrance Foyer, Eat-in Kitchen, Double Vanity, Built-in Features, Butler's Pantry, Ceiling Fan(s), High Ceilings
  • Basement: Full Finished Bath, See Remarks, Finished, Storage Space
  • Heating: Forced Air
  • Levels: Two
  • Property Type: Residential
  • Appliances: Wine Cooler, Stainless Steel Appliance(s), Electric Oven, Dishwasher, Microwave, Refrigerator
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Fireplace Features: Gas
  • Fireplaces: 1
  • Fireplace: Yes
  • Window Features: Insulated Windows
  • Appliances Dishwasher: Yes
  • Appliances:Electric Oven: Yes
  • Appliances:Stainless Steel Appliance(s): Yes
  • Interior Features:Built-in Features2: 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:Eat-in Kitchen2: Yes
  • Basement:Full Finished Bath: Yes
  • Basement:Storage Space: Yes
  • Fireplace Features:Gas: Yes
  • Interior Features:Butler_squote_s Pantry: Yes
  • Basement:Built-in Features3: Yes
  • Appliances:WineBeverage Cooler: Yes
  • Basement:See Remarks36: Yes

Exterior Features

  • Roof: Shingle
  • Lot Features: Cul-De-Sac, Level
  • Construction Type: Brick, Stone, Stucco
  • Exterior Features: Other
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Covered, Deck, Porch
  • Construction Materials:Brick2: Yes
  • Window Features:Insulated Window(s): Yes
  • Patio and Porch Features:Covered: Yes
  • Patio and Porch Features:Deck: Yes
  • Patio and Porch Features:Porch: Yes
  • Construction Materials:Stone2: Yes
  • Lot Features:Cul-De-Sac: Yes
  • Lot Features:Level: Yes
  • Construction Materials:Stucco2: Yes
  • Exterior Features:See Remarks23: Yes

Garage/Parking

  • Attached Garage: No
  • Parking Features: Driveway, On Street
  • General Property Description:Garage Spaces: 2.0
  • Parking Features:Driveway: Yes
  • Parking Features:On Street: Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Laundry Room
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Natural Gas Available, Sewer Available
  • Heating:Forced Air: Yes

Condo/Co-op/Association

  • Amenities: Pool
  • Association Fee: 325.0
  • Association Fee Frequency: Semi-Annually
  • Association: Yes

Association/Amenities

  • Association Information:Association YN: Yes
  • Association Information:Association Management Name 1: Vertex
  • Association Information:Association Management Phone 1: 859-491-5711
  • Association Information:Total Yearly Fees: 650.0
  • Association Fee Includes:Association Fees: Yes
  • Association Information:Association Fee: 325.0
  • Association Information:Association Fee Frequency: Semi-Annually
  • Association Amenities:Management: Yes
  • Association Amenities:Pool5: Yes
  • Association Fee Includes:See Remarks34: Yes

Fee Information

  • Association Fee Includes: See Remarks, Association Fees, 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

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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
2025 $5,864 $518,000 $50,000 $468,000
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 List to Sale Price per Sq Ft Prior Sale
12/06/2025 12/06/25 Price Changed $590,000 -1.7% $112 / Sq Ft
09/18/2025 09/18/25 For Sale $600,000 +15.8% $114 / Sq Ft
06/02/2022 06/02/22 Sold $518,000 +7.9% $99 / Sq Ft View Prior Sale
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 $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
Closed $492,100 New Conventional
Previous Owner $275,793 FHA
Previous Owner $328,518 FHA
Source: Public Records

Source: Northern Kentucky Multiple Listing Service

MLS Number: 636394

Northern Kentucky Multiple Listing Service

APN: 063.00-26-101.00