Matthew Bremer

9738 Cherbourg Drive

Union, KY
$ 425,000 Beds 4 Baths 2.5
Monthly Estimate* How much can I afford?

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.

Pending

  • Price
  • $ 425,000
  • City
  • Union
  • Bedrooms
  • 4
  • Full Bathrooms
  • 2
  • County
  • Boone
  • Half Bathrooms
  • 1
  • Area
  • Richwd-Un-Wal-Ver-SB
  • Lot Size
  • 0.46 Acres
  • Zip
  • 41091
  • Year Built
  • 1998
  • Style
  • Traditional
  • MLS#
  • 645720
Listed By: Keller Williams Realty Service - 859-240-0727
Data Source: Northern Kentucky MLS (NKAR)

Features

General

Sewer Public Sewer
Heating Forced Air
Cooling Central Air
Roof Composition,Shingle
HOA Fee 413
Garage Spaces 2
Patio/Porch Features Covered,Deck,Porch
Architectural Style Traditional
Construction Materials Brick Veneer
Year Built 1998
Levels Two
Property Subtype Single Family Residence
Additional Parcels Description 063.00-16-086.02
Assoc Fee Paid Per Annually
County Boone
New Construction false
Property Type Residential
Association Amenities Pool
HOA true
Attached Garage false
Subdivision Name Plantation Pointe
Garage Y/N true
Other Structures Shed(s)
Total Rooms 11
Status Pending
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
High School Ryle High
City Union
MLS Area K11 - Richwd/Un/Wal/Ver/SB
Lot Size Units Acres
Lot Size Square Feet 20037.6
Elementary School Erpenbeck Elementary
Property Attached Y/N false
Middle/Junior High School Ockerman Middle School
MLS Area Minor K11 - Richwd/Un/Wal/Ver/SB
Living Area Units Square Feet
Standard Status Pending

Interior Features

Interior Amenities 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
Basement Full,Storage Space
Total Fireplaces 1
Fireplace Features Brick,Wood Burning
Air Conditioning Y/N true
Heating Y/N true
Window Features Vinyl Frames
Fireplace Y/N true
Total Baths 3

Exterior Features

Exterior Amenities Private Yard,Fire Pit
Fencing Fenced,Full,Wood
Parking Features Garage
Lot Features Level
Water Source Public
Total Parking 2
Lot Size Area 0.46
Foundation Details Poured Concrete
Lot Dimensions Irregular
Lot Size Acres 0.46

Amenities

  • Foreclosure
  • Views
  • Short Sale
  • New Construction
  • Adult 55+
  • Lease To Own
  • No HOA Fees
  • Furnished
  • Primary On Main
  • Air Conditioning
  • Seller Finance
  • Green
  • Fixer Upper
  • Horse
  • Golf
  • Fireplace
  • Deck
  • Garage
  • Basement
  • Pool

Affordability Calculator

$3,786

Per Month

Based on the average sale price from the Fort Thomas, KY office

  • Monthly Principal & interest $2,658
  • Monthly Property Taxes $1,062
  • Monthly Home Insurance $67
Adjust Payment Options
Agent Photo

Let's determine your purchasing power. Working with my mortgage partner, you'll have the information you need to shop for a home with confidence.

Default based on a 30-year fixed rate of 6.49% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Your individual rate may vary. Rates may differ for FHA, VA, or jumbo loans.

Mortgage calculator provided courtesy of Inside Real Estate.

Schools

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

Price History

8/14/2026 Listed $425,000

Property vs Zip Code Average in 41091

Price
AVG $610K
$430K
Year Built
AVG 2014
1998

In The Neighborhood

Areas That We Cover

9738 Cherbourg Drive Union, KY is a Single Family Home for sale at $425000 and a lot size of 0.46 Acres Acre(s). 9738 Cherbourg Drive Union has 4 bedrooms, 2 baths and was built in 1998. The property's zip code is 41091 which is in Union, KY

*Information deemed reliable but not guaranteed.

Financial calculator disclaimer: Default based on a 30-year fixed rate of 6.49% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Your individual rate may vary. Rates may differ for FHA, VA or jumbo loans.

Mortgage calculator provided courtesy of Inside Real Estate.

All information deemed reliable, but not guaranteed, and should be independently verified. The real estate information and related content displayed on this site is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Matthew Bremer

Matthew Bremer

REALTOR®

859-468-7724

By pressing Contact Me, you agree that Weichert® may contact you via phone about your inquiry, which may involve the use of automated means. You are not required to consent as a condition of purchasing any property, goods or services. For any other information please read our Privacy Policy