9738 Cherbourg Dr Union, KY 41091
Union AreaEstimated payment $2,550/month
Highlights
- 0.46 Acre Lot
- Open Floorplan
- Recreation Room
- Erpenbeck Elementary School Rated A
- Deck
- Traditional Architecture
About This Home
Welcome to your own private backyard retreat in Union, where this Plantation Pointe home unfolds across two lots with outdoor oasis vibes at every turn. The immaculate extended deck is the heart of the home's outdoor living, overlooking a fenced backyard beautifully framed by thoughtful landscaping, garden-ready spaces, a storage shed, and room to keep growing your vision into the second lot. From the charming front porch, step inside to a welcoming foyer that draws you down the hall into an open, easy-flowing layout where the kitchen, dining area, and living room connect seamlessly for everyday comfort and effortless entertaining. Just off the entry, elegant French doors link a dedicated office and family room, creating a flexible space for work, play, gathering, or quiet relaxation. The kitchen shines with charm and function, offering a center island, pantry, and planning desk for added workspace and organization. Upstairs, the spacious primary suite feels bright and serene with soaring ceilings, a private en-suite bath with a gorgeous oversized garden tub, and a massive walk-in closet, plus three additional bedrooms nearby. The finished basement adds even more room to enjoy with a recreation room perfect for movie nights, games, or hosting, along with a large storage room. With generous indoor living, rare extra lot space, and an unforgettable backyard setting, this Plantation Pointe home is ready to impress.
Home Details
Home Type
- Single Family
Year Built
- Built in 1998
Lot Details
- 20,038 Sq Ft Lot
- Property is Fully Fenced
- Wood Fence
- Level Lot
- Private Yard
- 063.00-16-086.02
HOA Fees
- $34 Monthly HOA Fees
Parking
- 2 Car Garage
Home Design
- Traditional Architecture
- Brick Veneer
- Poured Concrete
- Shingle Roof
- Composition Roof
Interior Spaces
- 2-Story Property
- Open Floorplan
- Built-In Features
- High Ceiling
- Ceiling Fan
- Recessed Lighting
- Wood Burning Fireplace
- Brick Fireplace
- Vinyl Clad Windows
- French Doors
- Entrance Foyer
- Family Room
- Living Room
- Dining Room
- Home Office
- Recreation Room
- Storage Room
- Laundry Room
Kitchen
- Eat-In Kitchen
- Electric Oven
- Microwave
- Dishwasher
- Kitchen Island
- Utility Sink
Flooring
- Carpet
- Luxury Vinyl Tile
Bedrooms and Bathrooms
- 4 Bedrooms
- En-Suite Bathroom
- Walk-In Closet
- Double Vanity
- Soaking Tub
- Bathtub with Shower
- Shower
Basement
- Basement Fills Entire Space Under The House
- Basement Storage
Outdoor Features
- Deck
- Covered Patio or Porch
- Fire Pit
- Shed
Schools
- Erpenbeck Elementary School
- Ockerman Middle School
- Ryle High School
Utilities
- Forced Air Heating and Cooling System
Community Details
Overview
- Plantation Pointe Association, Phone Number (859) 581-4815
- Plantation Pointe Subdivision
Recreation
- Community Pool
Map
Home Values in the Area
Average Home Value in this Area
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,208 | $240,000 | $30,000 | $210,000 |
| 2024 | $2,711 | $240,000 | $30,000 | $210,000 |
| 2023 | $2,731 | $240,000 | $30,000 | $210,000 |
| 2022 | $2,694 | $240,000 | $30,000 | $210,000 |
| 2021 | $2,775 | $240,000 | $30,000 | $210,000 |
| 2020 | $2,748 | $240,000 | $30,000 | $210,000 |
| 2019 | $2,590 | $223,560 | $30,000 | $193,560 |
| 2018 | $2,626 | $223,560 | $30,000 | $193,560 |
| 2017 | $2,551 | $223,560 | $30,000 | $193,560 |
| 2015 | $2,520 | $223,560 | $30,000 | $193,560 |
| 2013 | -- | $214,330 | $30,000 | $184,330 |
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 |
|---|---|---|---|---|
| 08/14/2026 08/14/26 | For Sale | $425,000 | -- | -- |
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 |
|---|---|---|---|
| Quit Claim Deed | -- | None Listed On Document | |
| Deed | $10,000 | -- | |
| Deed | $200,681 | -- | |
| Deed | $25,950 | -- |
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 |
|---|---|---|---|
| Previous Owner | $108,000 | New Conventional |
Source: Northern Kentucky Multiple Listing Service
MLS Number: 645720
APN: 063.00-16-112.00
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.
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.
- 9718 Cherbourg Dr
- 9616 Splendor Dr
- 1232 Lancashire Dr
- 1549 Sweetsong Dr
- 2034 Evening Star
- 1153 Appomattox Dr
- 9609 Daybreak Ct
- 2200 Dawns Light Rd
- 8566 Concerto Ct
- 8554 Concerto Ct Unit 251B
- 8558 Concerto Ct Unit 251C
- 4928 Kerry Crossing St
- 4932 Kerry Crossing Ln
- 2174 Serenity Ct Unit 201D
- 9845 Burleigh Ln
- 1070 Tudor Ln
- 1305 Rubyhill Ln
- 10058 Brandsteade Ct
- 2026 Stonewall Trail
- 9754 Windsor Way
- 9710 Soaring Breezes
- 1620 Corinthian Dr
- 1373 Ruby Hill Ln
- 3000 Affinity Fields
- 10111 Brandsteade Ct
- 10196 Waterside Ct
- 1919 Promenade Cir
- 9030 Crimson Oak Dr
- 10082 Shagy Bark Ct
- 2005 Farmview Dr
- 1000 Tamarack Cir
- 550 Mt Zion Rd
- 996 Trellises Dr
- 412 Marian Ln Unit 8
- 412 Marian Ln Unit 12
- 2237 Antoinette Way
- 340-458 Wysteria Village Dr
- 3-69 Deer Haven Ct
- 239 Landon Ct
- 239 Landon Ct
Ask me questions while you tour the home.