Address
9738 Cherbourg Drive, Union, KY
Price
$ 425,000
Property Attributes
- MLS#645720
- TypeSingle Family
- Listing Status Pending
- CountyBoone
- CityUnion
- AreaRichwd-Un-Wal-Ver-SB
- NeighborhoodPlantation Pointe
- Zip41091
- StyleTraditional
- Year Built1998
- Price$ 425,000
- Bedrooms4
- Full Bathrooms2
- Half Bathrooms1
- Lot Size0.46 Acres
Data Source:
Northern Kentucky MLS (NKAR)
Property Description
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.
| Elementary School | Middle School | High School |
|---|---|---|
| Erpenbeck Elementary Elementary School | Ockerman Middle School Middle School | Ryle High High School |
| Price History | |
|---|---|
| 8/14/2026 | Listed $425,000 |
General Features
| 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
Property vs Single Family Average in 41091
Price
Year Built
Data last updated: September 18, 2026 7:49 PM UTC and updating occurs daily
The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of Metro Search, Inc. Real estate listings held by brokerage firms other than United Real Estate Bluegrass are marked with the Internet Data Exchange logo or the Internet Data Exchange thumbnail logo and detailed information about each listing includes the name of the listing broker.
© 2026 Metro Search, Inc.
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information 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. The data relating
The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program. Real estate listings held by IDX Brokerage firms other than United Real Estate Bluegrass 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 IDX Brokers. This information is provided exclusively for personal, non-commercial use and may not be used for any purpose other than to
REALTOR® Association of Southern Kentucky All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may
Heart of Kentucky Association of REALTORS® All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating
