NOT LISTED FOR SALE

2028 Holderness Dr Union, KY 41091

Estimated Value: $457,000 - $541,000

4 Beds
3 Baths
3,224 Sq Ft
$158/Sq Ft Est. Value

Sale Details

Date Sold: December 9, 2022

Last sale price $455,000 $141 Per Sq Ft

Est. 12% increase in value since last sale

Current estimated payment $3,187 / mo

38 Days on Market

Highlights

  • Spa
  • Gourmet Kitchen
  • Living Room with Fireplace
  • Shirley Mann Elementary School Rated A
  • Open Floorplan
  • Traditional Architecture

About This Home

As of December 2022

Welcome home to highly sought after Hampshire! This inviting home is located with great proximity to the community pool and offers the best in function and comfort. Rich hardwood floors throughout the first and second floors. The fenced back yard is a gorgeous oasis with stamped concrete patio, outdoor fireplace, and hot tub with pergola. The gourmet kitchen boasts 42'' wood cabinets, pantry, granite counters and all kitchen appliances are included. Entertaining is a breeze with the open concept living area. First floor also features large office and formal dining room. You will appreciate the large bedrooms all with walk-in closets. The second floor loft offers versatility as a second living space or play area. Massive garage features third car tandem area perfect for storage. The lower level is ready for your vision with full bath rough in. Custom exterior lights illuminate the front and back yard areas. Make your appointment today to tour this magnificent home!

Last Agent to Sell the Property

Debbie Steiner

Huff Realty - Florence Listed on: 09/30/2022

Huff Realty - Florence

Last Buyer's Agent

Eric Sztanyo

Keller Williams Advisors License #241335

Keller Williams Advisors

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2010

Lot Details

  • 12,018 Sq Ft Lot
  • Wood Fence
  • Wire Fence

HOA Fees

  • $45 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Side Facing Garage
  • Tandem Parking
  • Garage Door Opener

Home Design

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

Interior Spaces

  • 3,224 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Built-In Features
  • Chair Railings
  • Crown Molding
  • Tray Ceiling
  • Cathedral Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Chandelier
  • Wood Burning Fireplace
  • Gas Fireplace
  • Vinyl Clad Windows
  • Double Hung Windows
  • French Doors
  • Panel Doors
  • Entrance Foyer
  • Family Room
  • Living Room with Fireplace
  • 2 Fireplaces
  • Breakfast Room
  • Formal Dining Room
  • Home Office
  • Loft
  • Neighborhood Views

Kitchen

  • Gourmet Kitchen
  • Breakfast Bar
  • Double Oven
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Solid Wood Cabinet
  • Disposal

Flooring

  • Wood
  • Concrete

Bedrooms and Bathrooms

  • 4 Bedrooms
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • 3 Full Bathrooms
  • Double Vanity
  • Soaking Tub

Laundry

  • Laundry Room
  • Laundry on upper level

Unfinished Basement

  • Basement Fills Entire Space Under The House
  • Stubbed For A Bathroom
  • Rough-In Basement Bathroom
  • Basement Storage

Home Security

  • Closed Circuit Camera
  • Fire and Smoke Detector

Outdoor Features

  • Spa
  • Patio
  • Exterior Lighting
  • Pergola

Schools

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

Utilities

  • Central Air
  • Heating System Uses Natural Gas
  • 220 Volts
  • High Speed Internet

Listing and Financial Details

  • Assessor Parcel Number 063.00-26-111.00

Community Details

Overview

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

Recreation

  • Community Playground
  • Community Pool

Security

  • Resident Manager or Management On Site

Home Details

Home Type

Single Family

Year Built

Built in 2010

Lot Details

0.28 Acres

HOA Fees

$45 per month

Parking

3

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.28
  • Year Built: 2010
  • Lot Size: of record
  • Road Frontage Type: City Street
  • Directions: Mt Zion Road to Pembroke Drive to L on Holderness Drive
  • Architectural Style: Traditional
  • Garage Yn: Yes
  • New Construction: No
  • Property Attached Yn: No
  • Structure Type: House
  • ResoPropertyType: Residential
  • 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:Basement YN2: Yes
  • General Property Description:Fireplace YN: Yes
  • General Property Description:Lot Size Dimensions: of record
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Roof:Shingle: Yes
  • Room Type:Dining Room4: Yes
  • Room Type:Entry: Yes
  • Room Type:Laundry Room3: Yes
  • Room Type:Office5: Yes
  • Sewer:Public Sewer: Yes
  • Utilities Electric Company: Duke Energy
  • Utilities Gas Company: Duke Energy
  • 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.2759
  • General Property Description:Living Area: 3224.0
  • General Property Description:Lot Size Square Feet: 12018.0
  • Structure Type:House: Yes
  • Laundry Features:Laundry Room2: Yes
  • Room Type:Breakfast Room2: Yes
  • Room Type:Breakfast Room Level: First
  • Security Features:Smoke Detector(s): Yes
  • Architecture:Traditional: Yes
  • Laundry Features:Upper Level: Yes
  • Room Type:Loft3: Yes
  • Levels:Two: Yes
  • Location Tax Legal Info:Tax ID: 063.00-26-111.00
  • Appliances Refrigerators: Yes
  • Room Type:Living Room4: Yes
  • General Property Description:Fireplaces Total: 2
  • Fencing:Wood3: Yes
  • Fencing:Wire: Yes
  • Entry Features:Hardwood Floors5: Yes
  • Entry Features:Entrance Foyer: Yes
  • Laundry Room Features:Built-in Features6: Yes
  • Office Features:Hardwood Floors16: Yes
  • Entry Features:Lighting3: Yes
  • Other Structures:Pergola: Yes
  • Loft Features:Hardwood Floors14: Yes
  • Loft Features:Ceiling Fan(s)7: Yes
  • Special Features: None

Interior Features

  • Interior Amenities: Kitchen Island, Walk-In Closet(s), Stone Counters, Soaking Tub, Pantry, Open Floorplan, High Speed Internet, Granite Counters, Entrance Foyer, Double Vanity, Crown Molding, Chandelier, Breakfast Bar, 220 Volts, Cathedral Ceiling(s), Ceiling Fan(s), French Doors, High Ceilings, Multi Panel Doors, Recessed Lighting
  • Basement: Full, Bath/Stubbed, Storage Space, Unfinished
  • Heating: Natural Gas
  • Levels: Two
  • Flooring: Concrete
  • Property Type: Residential
  • Appliances: Dishwasher, Disposal, Double Oven, Microwave, Refrigerator
  • Full Bathrooms: 3
  • Total Bedrooms: 4
  • Fireplace Features: Gas, Wood Burning
  • Fireplaces: 2
  • Fireplace: Yes
  • Living Area: 3224.0
  • Window Features: Double Hung, Vinyl Frames
  • Full Basement: Yes
  • Appliances Dishwasher: Yes
  • Appliances:Double Oven: 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:Multi Panel Doors: Yes
  • Interior Features:Open Floorplan: Yes
  • Interior Features:Pantry2: Yes
  • Interior Features:Walk-In Closet(s)2: Yes
  • Kitchen Features:Granite Countertops: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Primary Bedroom Features:Ceiling Fan(s)8: Yes
  • Basement:Full Bath Rough In: Yes
  • Basement:Unfinished2: Yes
  • Interior Features:French Doors: Yes
  • Kitchen Features Pantry: Yes
  • Kitchen Features:Wood Cabinets: Yes
  • Primary Bedroom Features:Bath Adjoins: Yes
  • Primary Bedroom Features:Walk-In Closet(s): Yes
  • Living Room Features:Hardwood Floors13: Yes
  • Dining Room Features:Hardwood Floors4: Yes
  • Basement:Concrete Flooring: Yes
  • Fireplace Features:Wood Burning: Yes
  • Interior Features:Crown Molding: Yes
  • Basement:Storage Space: Yes
  • Fireplace Features:Gas: Yes
  • Interior Features:High Speed Internet: Yes
  • Living Room Features:Fireplace(s): Yes
  • Interior Features:Breakfast Bar2: Yes
  • Interior Features:Cathedral Ceiling(s): Yes
  • Interior Features:Chandelier2: Yes
  • Living Room Features:Ceiling Fan(s)6: Yes
  • Dining Room Features:Chandelier: Yes
  • Kitchen Features:Breakfast Bar: Yes
  • Primary Bedroom Features:Window Treatments6: Yes
  • Interior Features:Stone Counters: Yes
  • Kitchen Features:Hardwood Floors10: Yes
  • Primary Bedroom Features:Hardwood Floors18: Yes
  • Primary Bedroom Features:High Ceiling(s)6: Yes
  • Interior Features:Recessed Lighting: Yes
  • Interior Features:Soaking Tub: Yes
  • Kitchen Features:Gourmet Kitchen: Yes
  • Kitchen Features:Recessed Lighting3: Yes
  • Living Room Features:Recessed Lighting4: Yes
  • Primary Bedroom Features:Tray Ceiling(s)2: Yes
  • Dining Room Features:Chair Rail: Yes
  • Interior Features 220 Volts: Yes

Exterior Features

  • View: Neighborhood
  • Fencing: Wire, Wood
  • Roof: Shingle
  • View: Yes
  • Construction Type: Brick, Stone, Vinyl Siding
  • Exterior Features: Hot Tub, Lighting
  • Foundation Details: Poured Concrete
  • Other Structures: Pergola
  • Patio And Porch Features: Patio
  • Construction Materials:Brick2: Yes
  • Construction Materials:Vinyl Siding: Yes
  • Window Features:Vinyl Frames: Yes
  • Patio and Porch Features:Patio: Yes
  • Construction Materials:Stone2: Yes
  • Office Features:French Doors5: Yes
  • Window Features:Double Hung: Yes
  • Exterior Features:Lighting: Yes
  • Exterior Features:Hot Tub: Yes

Garage/Parking

  • Attached Garage: Yes
  • Parking Features: Attached, Garage, Garage Door Opener, Garage Faces Side, Tandem
  • General Property Description:Garage Spaces: 3.0
  • Parking Features:Attached: Yes
  • Parking Features:Garage5: Yes
  • Parking Features:Garage Door Opener: Yes
  • Parking Features:Garage Faces Side: Yes
  • Parking Features:Tandem: Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Utility Sink, Laundry Room, Upper Level
  • Security: Closed Circuit Camera(s), Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Heating:Natural Gas2: Yes

Condo/Co-op/Association

  • Amenities: Playground, Pool
  • Association Fee: 270.0
  • Association Fee Frequency: Semi-Annually
  • Association: Yes
  • ResoAssociationFeeFrequency: SemiAnnually

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: 540.0
  • Association Information:Association Fee: 270.0
  • Association Information:Association Fee Frequency: Semi-Annually
  • Association Amenities:Management: Yes
  • Association Amenities:Playground: Yes
  • Association Amenities:Pool5: Yes

Fee Information

  • Association Fee Includes: 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: 12018.0
  • Zoning Description: Residential
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 30, 2022
Closed on
Dec 8, 2022
Sold by
Keller Donald Wesley
Bought by
Sgarlata Anthony and Sgarlata Theresa M
Seller's Agent
Debbie Steiner
Huff Realty - Florence
Buyer's Agent
Eric Sztanyo
Keller Williams Advisors
List Price
$495,000
Sold Price
$455,000
Premium/Discount to List
-$40,000
-8.08%
Views
32
Current Estimated Value
$508,421

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$53,421
Avg. Annual Appreciation
3.27%
Original Mortgage
$177,000
Outstanding Balance
$171,466
Interest Rate
7.08%
Mortgage Type
New Conventional
Estimated Equity
$336,955

Purchase Details

Listed on
May 10, 2021
Closed on
Jul 16, 2021
Sold by
Damico Jeffrey T and Damico Michelle
Bought by
Keller Donald W and Frye Andrew
Seller's Agent
Michele O'Brien
Huff Realty - Ft. Mitchell
Buyer's Agent
Brit Roberts
Coldwell Banker Realty
List Price
$420,000
Sold Price
$435,000
Premium/Discount to List
$15,000
3.57%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.26%
Original Mortgage
$413,250
Interest Rate
2.96%
Mortgage Type
New Conventional

Purchase Details

Closed on
Mar 8, 2010
Sold by
The Drees Company
Bought by
Damico Jeffrey T

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$218,300
Interest Rate
4.93%
Mortgage Type
New Conventional
Source: Public Records
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

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
Sgarlata Anthony $455,000 Acuity Title
Sgarlata Anthony $455,000 Acuity Title
Keller Donald W $435,000 Lawyers Ttl Of Cincinnati In
Keller Donald Wesley $435,000 Lawyers Title
Damico Jeffrey T $301,490 Stonebridge Land Title Agenc
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
Open Sgarlata Anthony $177,000
Closed Sgarlata Anthony $177,000
Previous Owner Keller Donald Wesley $413,250
Previous Owner Damico Jeffrey T $218,300
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
12/09/2022 12/09/22 Sold $455,000 -4.2% $141 / Sq Ft
11/08/2022 11/08/22 Pending -- -- --
10/18/2022 10/18/22 Price Changed $475,000 -4.0% $147 / Sq Ft
09/30/2022 09/30/22 For Sale $495,000 +13.8% $154 / Sq Ft
07/16/2021 07/16/21 Sold $435,000 +3.6% $135 / Sq Ft View Prior Sale
06/14/2021 06/14/21 Pending -- -- --
06/09/2021 06/09/21 For Sale $420,000 0.0% $130 / Sq Ft
05/11/2021 05/11/21 Pending -- -- --
05/10/2021 05/10/21 For Sale $420,000 -- $130 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

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,160 $455,000 $50,000 $405,000
2024 $5,073 $455,000 $50,000 $405,000
2023 $5,178 $455,000 $50,000 $405,000
2022 $4,884 $435,000 $50,000 $385,000
2021 $3,753 $326,900 $50,000 $276,900
2020 $3,452 $301,500 $42,000 $259,500
2019 $3,492 $301,500 $42,000 $259,500
2018 $3,515 $301,500 $42,000 $259,500
2017 $3,440 $301,500 $42,000 $259,500
2015 $3,398 $301,500 $42,000 $259,500
2013 -- $301,500 $42,000 $259,500
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 608384

Northern Kentucky Multiple Listing Service

APN: 063.00-26-111.00

Your Personal Tour Guide

Ask me questions while you tour the home.