NOT LISTED FOR SALE

9751 Cherbourg Dr Union, KY 41091

Union Area

Estimated Value: $419,000 - $456,000

5 Beds
3.5 Baths
-- Sq Ft
9,583 Sq Ft Lot

Sale Details

Date Sold: July 1, 2025

Last sale price $445,000

Est. 1% decrease in value since last sale

Current estimated payment $2,649 / mo

3 Days on Market

Highlights

  • Eat-In Gourmet Kitchen
  • Pond View
  • Recreation Room
  • Erpenbeck Elementary School Rated A
  • Open Floorplan
  • Cathedral Ceiling

About This Home

As of July 2025

WOW—this one is stellar! From the completely remodeled kitchen to the finished lower level, every inch of this home is pristine. The gourmet kitchen is straight out of a magazine with custom cabinetry, granite counters, wine rack, tile backsplash, stainless appliances, island, and pantry—the works. Luxury vinyl flooring flows throughout the first floor, leading into a cozy great room with fireplace and a stunning 4-season room addition that offers endless versatility. Upstairs, you'll find 4 spacious bedrooms including a vaulted primary suite with a beautifully updated bath. The finished walkout lower level features a 5th bedroom, full bath, wet bar, and access to a covered patio. Step outside to a fenced, level yard with peaceful pond views and a firepit area perfect for relaxing evenings. First-floor laundry, newer roof, and located in a beautifully maintained community with 3 pools and a park. Homes this meticulous and move-in ready don't come along often—don't miss your chance!

Last Agent to Sell the Property

Nicole Riegler

RE/MAX Victory + Affiliates License #198576 Listed on: 05/28/2025

RE/MAX Victory + Affiliates

Last Buyer's Agent

Daniel Baron

Keller Williams Advisors License #260777

Keller Williams Advisors

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1999

Lot Details

  • 9,583 Sq Ft Lot
  • Split Rail Fence
  • Wood Fence

HOA Fees

  • $33 Monthly HOA Fees

Parking

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

Home Design

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

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Wet Bar
  • Chair Railings
  • Crown Molding
  • Cathedral Ceiling
  • Ceiling Fan
  • Gas Fireplace
  • Insulated Windows
  • Panel Doors
  • Entrance Foyer
  • Great Room
  • Family Room
  • Living Room
  • Breakfast Room
  • Formal Dining Room
  • Den
  • Recreation Room
  • Bonus Room
  • Storage
  • Pond Views

Kitchen

  • Eat-In Gourmet Kitchen
  • Electric Range
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Granite Countertops
  • Disposal

Flooring

  • Carpet
  • Laminate
  • Ceramic Tile
  • Luxury Vinyl Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • En-Suite Bathroom
  • Walk-In Closet
  • Double Vanity
  • Soaking Tub
  • Shower

Laundry

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

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Finished Basement Bathroom
  • Basement Storage

Outdoor Features

  • Covered Patio or Porch

Schools

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

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Underground Utilities
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 063.00-16-118.00

Community Details

Overview

  • Plantation Point Rentz Association, Phone Number (859) 581-4815

Recreation

  • Community Playground
  • Community Pool

Home Details

Home Type

Single Family

Year Built

Built in 1999

Lot Details

9,583 Sq Ft Lot

HOA Fees

$33 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: 1999
  • Lot Size: unknown
  • Road Frontage Type: City Street
  • Road Surface Type: Paved
  • Ownership: Consumer
  • Directions: Plantation Pointe to Lancashire Dr to Left on Cherbourg
  • 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: Erpenbeck Elementary
  • Location Tax Legal Info:Middle or Junior School: Ockerman Middle School
  • Location Tax Legal Info:High School: Ryle High
  • Location Tax Legal Info:Subdivision2: Lancashire
  • 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: unknown
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Roof:Shingle: Yes
  • Sewer:Public Sewer: Yes
  • Utilities:Cable Available: Yes
  • Utilities:Natural Gas 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.22
  • General Property Description:Lot Size Square Feet: 9583.0
  • Structure Type:House: Yes
  • Laundry Features:Laundry Room2: Yes
  • Laundry Features:Main Level: Yes
  • Architecture:Traditional: Yes
  • Levels:Two: Yes
  • Location Tax Legal Info:Tax ID: 063.00-16-118.00
  • Laundry Features:Electric Dryer Hookup: Yes
  • Laundry Features:Washer Hookup: Yes
  • General Property Description:Fireplaces Total: 1
  • Fencing:Wood3: Yes
  • Utilities:Sewer Available: Yes
  • Utilities:Water Available: Yes
  • Utilities:Underground Utilities: Yes
  • Fencing:Split Rail: Yes
  • Percent Basement Finished: Yes
  • View:Pond2: Yes
  • Location Tax Legal Info:Property Sub Type: Single Family Residence
  • Special Features: None

Interior Features

  • Interior Amenities: Kitchen Island, Wet Bar, Walk-In Closet(s), Storage, Soaking Tub, Pantry, Open Floorplan, High Speed Internet, Granite Counters, Entrance Foyer, Double Vanity, Crown Molding, Cathedral Ceiling(s), Ceiling Fan(s), High Ceilings, Multi Panel Doors, Vaulted Ceiling(s)
  • Basement: Full Finished Bath, Full, Finished, Storage Space, Walk-Out Access
  • Heating: Natural Gas, Forced Air
  • Levels: Two
  • Property Type: Residential
  • Appliances: Stainless Steel Appliance(s), Electric Range, Dishwasher, Disposal, Microwave
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Fireplace Features: Gas
  • Fireplaces: 1
  • Fireplace: Yes
  • Window Features: Insulated Windows
  • Full Basement: Yes
  • Appliances Dishwasher: 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:Multi Panel Doors: Yes
  • Interior Features:Open Floorplan: Yes
  • Interior Features:Pantry2: Yes
  • Interior Features:Storage2: Yes
  • Interior Features:Walk-In Closet(s)2: Yes
  • Interior Features:Wet Bar4: Yes
  • Basement:Walk-Out Access7: Yes
  • Appliances:Electric Range: Yes
  • Interior Features:Crown Molding: Yes
  • Basement:Full Finished Bath: Yes
  • Basement:Storage Space: Yes
  • Fireplace Features:Gas: Yes
  • Interior Features:High Speed Internet: Yes
  • Interior Features:Cathedral Ceiling(s): Yes
  • Interior Features:Vaulted Ceiling(s): Yes
  • Basement:Wet Bar5: Yes
  • Interior Features:Soaking Tub: Yes
  • Basement:Luxury Vinyl Flooring2: Yes

Exterior Features

  • View: Pond
  • Fencing: Split Rail, Wood
  • Roof: Shingle
  • View: Yes
  • Construction Type: Brick, Vinyl Siding
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Covered, Patio, 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:Patio: Yes
  • Patio and Porch Features:Porch: Yes

Garage/Parking

  • Attached Garage: No
  • Parking Features: Driveway, Garage Door Opener, Garage Faces Front, On Street
  • General Property Description:Garage Spaces: 2.0
  • Parking Features:Driveway: 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, Washer Hookup
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Cable Available, Natural Gas Available, Sewer Available, Underground Utilities, Water Available
  • Heating:Natural Gas2: Yes
  • Heating:Forced Air: Yes

Condo/Co-op/Association

  • Amenities: Playground, Pool
  • Association Fee: 396.0
  • Association Fee Frequency: Annually
  • Association: Yes

Association/Amenities

  • Association Information:Association YN: Yes
  • Association Information:Association Management Name 1: Plantation Point - Rentz
  • Association Information:Association Management Phone 1: 859-581-4815
  • Association Information:Total Yearly Fees: 396.0
  • Association Information:Association Fee: 396.0
  • Association Information:Association Fee Frequency: Annually
  • Association Amenities:Playground: Yes
  • Association Amenities:Pool5: Yes

Schools

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

Lot Info

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

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
May 28, 2025
Closed on
Jul 1, 2025
Sold by
Bought by
Seller's Agent
Nicole Riegler
RE/MAX Victory + Affiliates
Buyer's Agent
Daniel Baron
Keller Williams Advisors
List Price
$450,000
Sold Price
$445,000
Premium/Discount to List
-$5,000
-1.11%
Views
27
Current Estimated Value
$439,752

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$5,248
Avg. Annual Appreciation
-1.09%
Original Mortgage
$430,148
Interest Rate
0.0686%
Mortgage Type
FHA

Purchase Details

Closed on
Jun 27, 2006
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
$220,000
Interest Rate
0.0612%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Sep 24, 1999
Sold by
Bought by

Purchase Details

Closed on
Jan 12, 1999
Sold by
Bought by
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
$445,000 None Listed On Document
$275,000 Advanced Land Title Agency
$191,355 --
$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 Borrower Loan Amount
Open $430,148
Previous Owner $14,000
Previous Owner $208,000
Previous Owner $256,500
Previous Owner $15,000
Previous Owner $45,000
Previous Owner $220,000
Previous Owner $47,000
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
07/01/2025 07/01/25 Sold $445,000 -1.1% --
05/31/2025 05/31/25 Pending -- -- --
05/28/2025 05/28/25 For Sale $450,000 -- --
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 $2,636 $229,200 $30,000 $199,200
2024 $2,593 $229,200 $30,000 $199,200
2023 $2,683 $229,200 $30,000 $199,200
2022 $2,573 $229,200 $30,000 $199,200
2021 $2,654 $229,200 $30,000 $199,200
2020 $2,624 $229,200 $30,000 $199,200
2019 $2,580 $222,730 $30,000 $192,730
2018 $2,616 $222,730 $30,000 $192,730
2017 $2,541 $222,730 $30,000 $192,730
2015 $2,510 $222,730 $30,000 $192,730
2013 -- $198,000 $30,000 $168,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 632864

Northern Kentucky Multiple Listing Service

APN: 063.00-16-118.00

Your Personal Tour Guide

Ask me questions while you tour the home.