NOT LISTED FOR SALE

1703 Pickett Run Union, KY 41091

Union Area

Estimated Value: $451,200

4 Beds
3.5 Baths
2,410 Sq Ft
$187/Sq Ft Est. Value

Sale Details

Date Sold: February 16, 2023

Last sale price $415,000 $172 Per Sq Ft

Est. 9% increase in value since last sale

Current estimated payment $2,883 / mo

11 Days on Market

Highlights

  • Spa
  • 0.62 Acre Lot
  • Cathedral Ceiling
  • Erpenbeck Elementary School Rated A
  • Traditional Architecture
  • Wood Flooring

About This Home

As of February 2023

Beautiful Executive Home on a .6 acre lot. 4 Bedrooms including one on main level. 2-story soaring great room. Recently finished lower level with tile plank floor throughout. This home is built for entertaining!!

Last Agent to Sell the Property

Doug Mayberry

Huff Realty - Florence License #186924 Listed on: 12/27/2022

Huff Realty - Florence

Last Buyer's Agent

Debbie Steiner

Huff Realty - Florence

Huff Realty - Florence
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 Details

Home Type

  • Single Family

Year Built

  • Built in 1997

Lot Details

  • 27,007 Sq Ft Lot

HOA Fees

  • $10 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Side Facing Garage

Home Design

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

Interior Spaces

  • 2,410 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Built-In Features
  • Bookcases
  • Tray Ceiling
  • Cathedral Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Chandelier
  • Gas Fireplace
  • Vinyl Clad Windows
  • Window Treatments
  • Entrance Foyer
  • Great Room
  • Family Room with entrance to outdoor space
  • Family Room
  • Breakfast Room
  • Formal Dining Room
  • Bonus Room

Kitchen

  • Electric Oven
  • Electric Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Carpet
  • Laminate
  • Tile
  • Luxury Vinyl Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • Dressing Area
  • Dual Vanity Sinks in Primary Bathroom
  • Jetted Tub in Primary Bathroom
  • Soaking Tub
  • Primary Bathroom includes a Walk-In Shower

Laundry

  • Laundry Room
  • Laundry on main level
  • Dryer
  • Washer

Basement

  • Walk-Out Basement
  • Finished Basement Bathroom
  • Stubbed For A Bathroom
  • Basement Storage

Outdoor Features

  • Spa
  • Covered Patio or Porch

Schools

  • Erpenbeck Elementary School
  • Gray Middle School
  • Ryle High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • 220 Volts

Community Details

  • Http://Www.Unionvillagehoa.Net/ Association, Phone Number (859) 123-4567

Listing and Financial Details

  • Assessor Parcel Number 062.00-04-031.00

Home Details

Home Type

Single Family

Year Built

Built in 1997

Lot Details

0.62 Acres

HOA Fees

$10 per month

Parking

2

Listing Details

  • Cooling: Central Air
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.62
  • Year Built: 1997
  • Lot Size: Irreg
  • Directions: US 42 toward Union. Left on Braxton to Left on Pickett Run.
  • Architectural Style: Traditional
  • Garage Yn: Yes
  • New Construction: No
  • Property Attached Yn: No
  • ResoPropertyType: Residential
  • Location Tax Legal Info:Property Attached YN: No
  • Location Tax Legal Info:New Construction: No
  • Location Tax Legal Info:Elementary School: Erpenbeck Elementary
  • 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: Irreg
  • 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:Family Room4: Yes
  • Room Type:Laundry Room3: Yes
  • Sewer:Public Sewer: Yes
  • Utilities Electric Company: Duke Energy
  • Utilities Gas Company: Duke Energy
  • Water Company: Boone Co. 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.62
  • General Property Description:Living Area: 2410.0
  • General Property Description:Lot Size Square Feet: 27007.0
  • Laundry Features:Main Level: Yes
  • Room Type:Breakfast Room2: Yes
  • Room Type:Breakfast Room Level: Second
  • Architecture:Traditional: Yes
  • Levels:Two: Yes
  • Location Tax Legal Info:Tax ID: 062.00-04-031.00
  • Appliances Refrigerators: Yes
  • General Property Description:Fireplaces Total: 1
  • Appliances Dryer: Yes
  • Washers: Yes
  • Room Type:Bonus Room2: Yes
  • Room Type:Great Room4: Yes
  • Laundry Room Features:Tile Flooring15: Yes
  • Bonus Room Features:Ceiling Fans: Yes
  • Great Room Features:Carpet Flooring8: Yes
  • Entry Features:Entrance Foyer: Yes
  • Entry Features:Tile Flooring: Yes
  • Laundry Room Features:Built-in Features6: Yes
  • Great Room Features:High Ceiling(s)3: Yes
  • Bonus Room Features:Luxury Vinyl Flooring3: Yes
  • Bonus Room Features:Recessed Lighting5: Yes
  • Bonus Room Features:Plank Flooring3: Yes
  • Bonus Room Features:Built-In Features10: Yes
  • Special Features: None

Interior Features

  • Interior Amenities: Kitchen Island, Walk-In Closet(s), Soaking Tub, Pantry, Entrance Foyer, Double Vanity, Chandelier, Bookcases, Built-in Features, 220 Volts, Ceiling Fan(s), High Ceilings, Recess Ceiling(s), Wet Bar
  • Basement: Bath/Stubbed, Storage Space, Walk-Out Access
  • Heating: Natural Gas, Forced Air
  • Levels: Two
  • Flooring: Laminate
  • Property Type: Residential
  • Appliances: Electric Oven, Electric Range, Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Washer
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Fireplace Features: Gas
  • Fireplaces: 1
  • Fireplace: Yes
  • Living Area: 2410.0
  • Window Features: Vinyl Clad Window(s)
  • Appliances Dishwasher: Yes
  • Appliances:Electric Oven: 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:High Ceilings: Yes
  • Interior Features:Kitchen Island2: Yes
  • Interior Features:Pantry2: Yes
  • Interior Features:Walk-In Closet(s)2: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Basement:Walk-Out Access7: Yes
  • Kitchen Features Pantry: Yes
  • Primary Bedroom Features:Bath Adjoins: Yes
  • Primary Bedroom Features:Walk-In Closet(s): Yes
  • Appliances:Electric Range: Yes
  • Primary Bath Features:Shower: Yes
  • Family Room Features:Walk-Out Access4: Yes
  • Basement:Full Finished Bath: Yes
  • Basement:Storage Space: Yes
  • Fireplace Features:Gas: Yes
  • Family Room Features:Window Treatments4: Yes
  • Interior Features:Chandelier2: Yes
  • Dining Room Features:Chandelier: Yes
  • Kitchen Features:Window Treatments3: Yes
  • Primary Bedroom Features:Window Treatments6: Yes
  • Kitchen Features:Hardwood Floors10: Yes
  • Primary Bath Features:Jetted Tub: Yes
  • Basement:Wet Bar5: Yes
  • Interior Features:Bookcases4: Yes
  • Interior Features:Soaking Tub: Yes
  • Kitchen Features:Recessed Lighting3: Yes
  • Primary Bath Features:Double Vanity: Yes
  • Interior Features:Recess Ceiling(s): Yes
  • Family Room Features:Recessed Lighting6: Yes
  • Family Room Features:Wet Bar2: Yes
  • Primary Bedroom Features:Cathedral Ceiling(s)2: Yes
  • Dining Room Features:Carpet Flooring3: Yes
  • Primary Bath Features:Shower With Bench: Yes
  • Primary Bedroom Features:Dressing Area: Yes
  • Family Room Features:Tile Flooring6: Yes
  • Primary Bedroom Features:Plank Flooring18: Yes
  • Primary Bath Features:Window Treatments7: Yes
  • Primary Bedroom Features:Luxury Vinyl Flooring19: Yes
  • Basement:Plank Flooring2: Yes
  • Family Room Features:Plank Flooring8: Yes
  • Interior Features 220 Volts: Yes

Exterior Features

  • Roof: Shingle
  • Construction Type: Brick, Vinyl Siding
  • Exterior Features: Hot Tub
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Covered, Patio, Porch
  • Construction Materials:Brick2: Yes
  • Construction Materials:Vinyl Siding: Yes
  • Patio and Porch Features:Covered: Yes
  • Patio and Porch Features:Patio: Yes
  • Patio and Porch Features:Porch: Yes
  • Window Features:Vinyl Clad Window(s): Yes
  • Exterior Features:Hot Tub: Yes

Garage/Parking

  • Attached Garage: Yes
  • Parking Features: Attached, Garage Faces Side
  • General Property Description:Garage Spaces: 2.0
  • Parking Features:Attached: Yes
  • Parking Features:Garage Faces Side: Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Utility Sink, Main Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Heating:Natural Gas2: Yes
  • Heating:Forced Air: Yes

Condo/Co-op/Association

  • Association Fee: 120.0
  • Association Fee Frequency: Annually
  • Association: Yes
  • ResoAssociationFeeFrequency: Annually

Association/Amenities

  • Association Information:Association YN: Yes
  • Association Information:Association Management Name 1: http://www.unionvillagehoa.net/
  • Association Information:Association Management Phone 1: 8591234567
  • Association Information:Total Yearly Fees: 120.0
  • Association Information:Association Fee: 120.0
  • Association Information:Association Fee Frequency: Annually

Schools

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

Lot Info

  • Lot Size Sq Ft: 27007.0
  • Zoning Description: Residential
  • ResoLotSizeUnits: Acres

Ownership 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 Name Owned For Owner Type

Purchase Details

Listed on
Dec 27, 2022
Closed on
Feb 16, 2023
Sold by
Bought by
Seller's Agent
Doug Mayberry
Huff Realty - Florence
Buyer's Agent
Debbie Steiner
Huff Realty - Florence
List Price
$414,900
Sold Price
$415,000
Premium/Discount to List
$100
0.02%
Views
58
Current Estimated Value
$451,200

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$36,200
Avg. Annual Appreciation
2.41%
Original Mortgage
$394,250
Outstanding Balance
$378,323
Interest Rate
6.48%
Mortgage Type
New Conventional
Estimated Equity
$72,877

Purchase Details

Closed on
Oct 19, 2018
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$236,823
Interest Rate
4.5%
Mortgage Type
FHA

Purchase Details

Closed on
May 21, 1997
Sold by
Bought by
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Agents Specializing in Union, KY

  • Brit Roberts Real Estate Agent - Coldwell Banker Realty

    Brit Roberts

    Coldwell Banker Realty

    (513) 666-5562

    113 Total Sales

    3 in Union

    $169K - $405K Price Range

    Brit Roberts
     Section Image
  • Mike Wright Real Estate Agent - Hoeting, Realtors

    Mike Wright

    Hoeting, Realtors

    (513) 440-2953

    157 Total Sales

    1 in Union

    $380,000 Price

    Mike Wright
     Section Image
  • Todd Blersch Real Estate Agent - Coldwell Banker Realty

    Todd Blersch

    Coldwell Banker Realty

    (513) 866-7490

    73 Total Sales

    1 in Union

    $330,000 Price

    Todd Blersch
     Section Image
  • Edmund Ferrall Real Estate Agent - Comey & Shepherd

    Edmund Ferrall

    Comey & Shepherd

    (513) 952-8798

    198 Total Sales

    1 in Union

    $330,000 Price

    Edmund Ferrall
     Section Image
  • Kathy Wolfe Real Estate Agent - Keller Williams Distinctive RE

    Kathy Wolfe

    Keller Williams Distinctive RE

    (859) 888-1955

    51 Total Sales

    2 in Union

    $210K - $235K Price Range

    Kathy Wolfe
     Section Image
  • Tasha Klaber-Flood Real Estate Agent - Sibcy Cline, REALTORS-Florence

    Tasha Klaber-Flood

    Sibcy Cline, REALTORS-Florence

    (513) 599-0879

    96 Total Sales

    33 in Union

    $168K - $3.9M Price Range

    Tasha Klaber-Flood
     Section Image
See All Agents

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
$415,000 --
$245,000 360 American Title Services
$33,000 --
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 $394,250
Previous Owner $235,397
Previous Owner $236,063
Previous Owner $236,823
Previous Owner $13,800
Previous Owner $278,500
Source: Public Records

Property 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 Event Price List to Sale Price per Sq Ft
02/16/2023 02/16/23 Sold $415,000 0.0% $172 / Sq Ft
01/08/2023 01/08/23 Pending -- -- --
12/27/2022 12/27/22 For Sale $414,900 -- $172 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

Tax 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.

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 $4,713 $415,000 $25,000 $390,000
2024 $4,634 $415,000 $25,000 $390,000
2023 $2,788 $245,000 $25,000 $220,000
2022 $2,751 $245,000 $25,000 $220,000
2021 $2,831 $245,000 $25,000 $220,000
2020 $2,805 $245,000 $25,000 $220,000
2019 $2,838 $245,000 $25,000 $220,000
2018 $2,574 $219,000 $25,000 $194,000
2017 $2,499 $219,000 $25,000 $194,000
2015 $2,468 $219,000 $25,000 $194,000
2013 -- $219,000 $25,000 $194,000
Source: Public Records

Agents Affiliated with this Home

  • Doug Mayberry Real Estate Agent - Huff Realty - Florence

    Seller's Agent in 2023

    Doug Mayberry

    Huff Realty - Florence

    (859) 816-3393

    179 Total Sales

    Doug Mayberry
    Section Image
  • Debbie Steiner Real Estate Agent - Huff Realty - Florence

    Buyer's Agent in 2023

    Debbie Steiner

    Huff Realty - Florence

    (859) 653-1328

    344 Total Sales

    Debbie Steiner
    Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 610251

Northern Kentucky Multiple Listing Service

APN: 062.00-04-031.00

Kentucky Boone County Union 41091

1703 Pickett Run, Union, KY

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Northern Kentucky Multiple Listing Service 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 Ten-X 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.

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.