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
© 2026 Dayton Area Board of Realtors. All rights reserved. Information deemed to be reliable but not guaranteed. The data relating to real estate for sale on this website comes from Dayton Area Board of Realtors and the Broker Reciprocity Program.sm. Real estate listings held by brokerage firms other than Comey & Shepherd, REALTORS are marked with the BR logo and detailed information about them includes the name of the listing brokers. Listing broker has attempted to offer accurate data, but
The data relating to real estate for sale on this web site comes
in part from the Broker Reciprocity™ program of the Multiple
Listing Service of Greater Cincinnati. Real estate listings held by
brokerage firms other than Comey & Shepherd, REALTORS are marked with the MLS ™ logo
(the small logo to the left) and detailed information about them includes
the name of the listing brokers. The information herein is furnished by the property owner in
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
All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawl. Neither listing broker(s) nor SE IN BD REALTORS shall be held responsible for typographical errors, misinformation, misprints and shall be held totally harmless.
