$424,900
PENDING

9795 Cherbourg Dr Union, KY 41091

Estimated payment $2,515/month

Total Views 564
4 Beds
4 Baths
2,789 Sq Ft
$152 Price per Sq Ft

Highlights

  • Gourmet Kitchen
  • Open Floorplan
  • Cathedral Ceiling
  • Erpenbeck Elementary School Rated A
  • Deck
  • Traditional Architecture

About This Home

This spacious home is located in the highly desired community of Lancanshire. The heart of the home features a light-filled kitchen that walks out to a covered patio and a level, fenced-in backyard. Inside, the first floor offers a dedicated office or flex space and a convenient laundry room. The bedrooms are equally impressive, each boasting a large walk-in closet, ensuring everyone has an organized retreat. The primary suite serves as a true sanctuary, featuring soaring vaulted ceilings and a newly updated adjoining bath with a double-bowl vanity and dual showerheads. For even more room to grow, the large second-floor loft offers more room to expand. The finished lower level includes a half bath and extensive storage solutions, perfect for seasonal gear and growing hobbies. This home seamlessly combines a functional design with premium features.

Listing Agent

Leah Kordenbrock

eXp Realty, LLC License #200558 Listed on: 04/16/2026

eXp Realty, LLC

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2002

Lot Details

  • 9,583 Sq Ft Lot
  • Lot Dimensions are 64x150
  • Split Rail Fence
  • Level Lot
  • Land Lease

HOA Fees

  • $34 Monthly HOA Fees

Parking

  • Garage
  • Front Facing Garage
  • Garage Door Opener
  • Driveway

Home Design

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

Interior Spaces

  • 2,789 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Crown Molding
  • Cathedral Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Chandelier
  • Gas Fireplace
  • Vinyl Clad Windows
  • Panel Doors
  • Entrance Foyer
  • Great Room
  • Family Room
  • Formal Dining Room
  • Home Office
  • Loft
  • Game Room
  • Storage
  • Neighborhood Views

Kitchen

  • Gourmet Kitchen
  • Breakfast Bar
  • Electric Oven
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile
  • Luxury Vinyl Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • En-Suite Bathroom
  • Walk-In Closet
  • Double Vanity
  • Shower Only

Laundry

  • Laundry Room
  • Laundry on main level

Finished Basement

  • Basement Fills Entire Space Under The House
  • Basement Storage

Outdoor Features

  • Deck
  • Covered Patio or Porch

Schools

  • Erpenbeck Elementary School
  • Ockerman Middle School
  • Ryle High School

Utilities

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

Community Details

Overview

  • Association fees include management
  • Rentz Association, Phone Number (859) 581-4815

Recreation

  • Community Playground
  • Community Pool
  • Trails

Home Details

Home Type

Single Family

Year Built

Built in 2002

Lot Details

9,583 Sq Ft Lot

HOA Fees

$34 per month

Parking

2

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.22
  • Year Built: 2002
  • Lot Size: 64x150
  • Road Frontage Type: City Street
  • Road Surface Type: Paved
  • Ownership: Consumer
  • Directions: US42 to Wetherington R on Lancashire L on Cherbourg
  • Architectural Style: Traditional
  • Garage Yn: Yes
  • New Construction: No
  • Property Attached Yn: No
  • Structure Type: House
  • Contract Info:Auction YN: No
  • General Property Description:Basement YN2: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: Yes
  • Special Features: VirtualTour

Interior Features

  • Interior Amenities: Ceiling Fan(s), Multi Panel Doors, High Ceilings, Crown Molding, Cathedral Ceiling(s), Breakfast Bar, Chandelier, Double Vanity, Entrance Foyer, High Speed Internet, Open Floorplan, Pantry, Storage, Walk-In Closet(s)
  • Basement: Full, Finished, Storage Space
  • Heating: Natural Gas
  • Levels: Two
  • Property Type: Residential
  • Appliances: Disposal, Dishwasher, Microwave, Refrigerator, Electric Oven
  • Full Bathrooms: 2
  • Half Bathrooms: 2
  • Total Bedrooms: 4
  • Fireplace Features: Gas
  • Fireplaces: 1
  • Fireplace: Yes
  • Living Area: 2789.0
  • Window Features: Vinyl Clad Window(s)

Exterior Features

  • View: Neighborhood
  • Fencing: Split Rail
  • Roof: Shingle
  • Lot Features: Level
  • View: Yes
  • Construction Type: Brick, Vinyl Siding
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Deck, Porch, Covered

Garage/Parking

  • Attached Garage: No
  • Parking Features: Driveway, Garage Faces Front, Garage Door Opener, Garage

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Main Level, Laundry Room
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electric: 220 Volts
  • Utilities: Cable Available

Condo/Co-op/Association

  • Amenities: Pool, Playground, Trail(s)
  • Association Fee: 413.0
  • Association Fee Frequency: Annually
  • Association: Yes

Association/Amenities

  • Association Information:Association Management Name 1: Rentz
  • Association Information:Association Management Phone 1: (859) 581-4815
  • Association Information:Total Yearly Fees: 413.0

Fee Information

  • Association Fee Includes: Management

Schools

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

Lot Info

  • Land Lease: Yes
  • Lot Size Sq Ft: 9583.0
  • Zoning Description: Residential

Map

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 $2,546 $221,100 $30,000 $191,100
2024 $2,504 $221,100 $30,000 $191,100
2023 $2,516 $221,100 $30,000 $191,100
2022 $2,482 $221,100 $30,000 $191,100
2021 $2,562 $221,100 $30,000 $191,100
2020 $2,531 $221,100 $30,000 $191,100
2019 $2,288 $197,500 $30,000 $167,500
2018 $2,328 $197,500 $30,000 $167,500
2017 $2,253 $197,500 $30,000 $167,500
2015 $2,385 $211,620 $30,000 $181,620
2013 -- $212,900 $30,000 $182,900
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
04/16/2026 04/16/26 Pending -- -- --
04/16/2026 04/16/26 For Sale $424,900 -- $152 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

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 Type Sale Price Title Company
Deed $197,500 Northern Kentucky Title Inc
Deed $194,543 --
Deed $28,530 --
Deed $174,812 --
Deed $25,950 --
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 Loan Amount Loan Type
Open $190,888 FHA
Previous Owner $155,600 New Conventional
Previous Owner $164,086 New Conventional
Source: Public Records

Source: Northern Kentucky Multiple Listing Service

MLS Number: 641592

Northern Kentucky Multiple Listing Service

APN: 063.00-16-138.00

Your Personal Tour Guide

Ask me questions while you tour the home.