Recently Viewed Properties
See This Home
Save This Listing
Close

$415,000

  • Sold
  • Closed
  • Single Family
  • 4 Beds
  • 2 Full Baths
  • 1 Partial Bath
  • 0.46 Acres
  • 2 Car Garage
  • Updated 4 days ago
See This Home
Save This Home
See This Home
Save 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.

Full Property Details for 9738 Cherbourg Dr

General

  • Sold For: $415,000
  • HOA FEE: $34/month
  • HOA FEE FREQ.: Annually
  • Status: Closed
  • Type: Single Family
  • Source: Northern_Kentucky
  • MLS ID: 645720
  • Added to Site: 57 day(s) ago

Interior

  • Number of Rooms: 11
  • Interior Features: Kitchen Island, Walk-In Closet(s), Storage, Soaking Tub, Pantry, Open Floorplan, Entrance Foyer, Eat-in Kitchen, Double Vanity, Built-in Features, Ceiling Fan(s), High Ceilings, Recessed Lighting
  • Fireplace: Yes
  • Number of Fireplaces: 1
  • Fireplace(s): Brick, Wood Burning
  • Appliances: Electric Oven, Dishwasher, Microwave, Refrigerator

Rooms

Bathrooms

  • Total Bathrooms: 3
  • Full Bathrooms: 2
  • Half Bathrooms: 1

Bedrooms

  • Total Bedrooms: 4

Additional Information

  • Shared Amenities: Pool

Exterior

  • Exterior Features: Private Yard, Fire Pit
  • Porch/Patio/Deck: Covered, Deck, Porch

Parking

  • Garage: Yes
  • Garage Spaces: 2
  • Total Spaces: 2
  • Parking Features: Garage

Location

  • County: Boone
  • Subdivision: Plantation Pointe
  • Driving Directions: Merge onto I-71 S/I-75 S, Use the right lane to take exit 178 for KY-536/Mt. Zion Rd, Use the right 2 lanes to take the ramp to KY-536 E/Mt Zion Rd, Use any lane to turn slightly right onto KY-536 E/Mt Zion Rd, Turn right onto Wetherington Blvd, Turn left onto Lancashire Dr, Turn left onto Cherbourg Dr, Destination will be on the left

School Information

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

Community

  • Community Name: K11 - Richwd/Un/Wal/Ver/SB
  • Association: Yes

Heating & Cooling

  • Central air: Yes
  • Air Conditioning: Yes
  • Cooling Type: Central Air Conditioning
  • Heating Type: Forced Air

Utilities

  • Sewer: Public Sewer
  • Water: Public

Structural Information

  • Architectural Style: Traditional
  • Construction: Brick Veneer
  • Basement Desc.: Full, Storage Space
  • Roof: Composition, Shingle
  • Windows: Vinyl Frames
  • Year Built: 1998

Additional Structures

  • Other Structures: Shed(s)

Lot Features

  • Lot Size (Acres): 0.46
  • Lot Size (Sq. Ft.): 20,037.6
  • Lot Size: .46
  • Lot Dimensions: Irregular
  • Lot Features: Level
  • Fencing (Description): Fenced, Full, Wood

Financial Considerations

  • Association Fee: $413
  • Assoc Fee Freq.: Annually

Disclosures and Reports

  • Property ID: 063.00-16-112.00

Meet the selling agent

Meet the selling agent
— 9738 Cherbourg Dr —

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 9738 Cherbourg Dr

School District:Boone County School District
NameGradesDistance
Erpenbeck Elementary School
US 42 9001 Wetherington Blvd, Florence, KY 41042
K-51 mi
Ockerman Middle School
8300 U.S. 42, Florence, KY 41042
6-82.2 mi
Larry A. Ryle High School
10379 U.S. 42, Union, KY 41091
9-121.4 mi
Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 9738 Cherbourg Dr

Date
Details
Price
Change
Source
10/05/2026
Sold
$415,000
-2.35%
MLS
8/14/2026
Listed
$425,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Similar Properties near 9738 Cherbourg Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

2170 Algiers St, Union, KY 41091 - Photo 1
$414,900

2170 Algiers St  Union, KY 41091

  • Single Family
  • Active
  • 4
    Beds
  • 3
    Total Baths
  • 2,370
    Sq. Ft.
488 Winchester Dr, Walton, KY 41094 - Photo 1
$419,900

488 Winchester Dr  Walton, KY 41094

  • Single Family
  • Active
  • 4
    Beds
  • 3
    Total Baths
  • 2,332
    Sq. Ft.
10737 Melbury Ct, Independence, KY 41051 - Photo 1 Price Reduced
-$9,000 (-2.15%)
$410,000

10737 Melbury Ct  #293GL  Independence, KY 41051

  • Single Family
  • Active
  • Updated 3 days ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,275
    Sq. Ft.
9510 Los Alos Ct, Florence, KY 41042 - Photo 1
$409,000

9510 Los Alos Ct  Florence, KY 41042

  • Single Family
  • Active
  • Updated 1 day ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,003
    Sq. Ft.

Just Listed near 9738 Cherbourg Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

2365 Twelve Oaks Dr, Florence, KY 41042 - Photo 1 Price Reduced
-$20,000 (-11.12%)
$159,900

2365 Twelve Oaks Dr  Florence, KY 41042

  • Condo
  • Active
  • Updated 4 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,188
    Sq. Ft.
Listed by Andre Bogle (859) 638-3885
6144 Cedar Hill Ln, Florence, KY 41042 - Photo 1 Just Listed
$389,000

6144 Cedar Hill Ln  Florence, KY 41042

  • Single Family
  • Active
  • Updated 1 day ago
  • 4
    Beds
  • 4
    Total Baths
  • 2,260
    Sq. Ft.
17 Miriam Dr, Florence, KY 41042 - Photo 1 Just Listed
$225,000
Open House

17 Miriam Dr  Florence, KY 41042

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 1
    Total Bath
  • 925
    Sq. Ft.
569 Tristan Ln, Florence, KY 41042 - Photo 1 Just Listed
$315,000

569 Tristan Ln  Florence, KY 41042

  • Condo
  • Active
  • Updated 1 day ago
  • 2
    Beds
  • 2
    Total Baths

Price Reduced near 9738 Cherbourg Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

2365 Twelve Oaks Dr, Florence, KY 41042 - Photo 1 Price Reduced
-$20,000 (-11.12%)
$159,900

2365 Twelve Oaks Dr  Florence, KY 41042

  • Condo
  • Active
  • Updated 4 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,188
    Sq. Ft.
Listed by Andre Bogle (859) 638-3885
8560 Elmcreek Ct, Florence, KY 41042 - Photo 1 Price Reduced
-$6,000 (-2.15%)
$273,000

8560 Elmcreek Ct  Florence, KY 41042

  • Single Family
  • Active
  • Updated 5 days ago
  • 4
    Beds
  • 4
    Total Baths
  • 2,308
    Sq. Ft.
20 Ridgeview Ave, Florence, KY 41042 - Photo 1 Price Reduced
-$10,000 (-4.03%)
$238,000

20 Ridgeview Ave  Florence, KY 41042

  • Single Family
  • Active
  • Updated 4 days ago
  • 4
    Beds
  • 2
    Total Baths
12 Sassafrass Ln, Florence, KY 41042 - Photo 1 Price Reduced
-$5,000 (-1.45%)
$340,000

12 Sassafrass Ln  Florence, KY 41042

  • Single Family
  • Active
  • Updated 2 days ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,223
    Sq. Ft.

Recent Sales near 9738 Cherbourg Dr

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

9513 Sapphire Ln, Union, KY 41091 - Photo 1 Sold
$375,000

9513 Sapphire Ln  Union, KY 41091

  • Single Family
  • Closed
  • 3
    Beds
  • 4
    Total Baths
  • 1,935
    Sq. Ft.
1232 Lancashire Dr, Union, KY 41091 - Photo 1 Sold
$390,000

1232 Lancashire Dr  Union, KY 41091

  • Single Family
  • Closed
  • 4
    Beds
  • 4
    Total Baths
9795 Cherbourg Dr, Union, KY 41091 - Photo 1 Sold
$427,500

9795 Cherbourg Dr  Union, KY 41091

  • Single Family
  • Closed
  • 4
    Beds
  • 4
    Total Baths
  • 2,789
    Sq. Ft.
Sold by Maria Osokina
3833 Sonata Dr, Union, KY 41091 - Photo 1 Sold
$450,000

3833 Sonata Dr  Union, KY 41091

  • Single Family
  • Closed
  • 4
    Beds
  • 4
    Total Baths
  • 2,824
    Sq. Ft.

9738 Cherbourg Drive, Union, KY 41091 (MLS# 645720) is a Single Family property that was sold at $415,000 on October 05, 2026. This property was sold by Nicole Rankin from our Northern Kentucky Office.Want to learn more about 9738 Cherbourg Drive? Do you have questions about finding other Single Family real estate for sale in Union? You can browse all Union real estate or contact a Coldwell Banker agent to request more information.