This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
$415,000
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
Property Description
If space and storage are at the top of your list, this is the one you've been waiting for! Boasting nearly 3,000 square feet on the first two floors alone, plus a finished lower level complete with a wet bar, this home offers room for everyone to spread out and enjoy. A versatile loft area adds even more flexibility--perfect for a second living space, home office, playroom, or cozy retreat. Each bedroom features its own walk-in closet, giving you the storage you've always wanted. The oversized garage provides even more functionality. Step outside to a nicely fenced yard perfect for relaxing, entertaining, or playtime. Located in a sought-after pool community, you can truly vacation at home all summer long! With major updates already done--including newer HVAC (5 years), roof and water heater (6 years), and brand-new windows and patio door, new pump, plus numerous additional upgrades throughout, this home offers peace of mind and incredible value. Spacious, updated, and truly move-in ready--don't miss your chance to call this one home!
Full Property Details
Full Property Details for 9788 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: 642152
- Added to Site: 49 day(s) ago
Interior
- Number of Rooms: 14
- Interior Features: Wet Bar, Walk-In Closet(s), Storage, Pantry, Eat-in Kitchen, Double Vanity, Built-in Features, Ceiling Fan(s), High Ceilings, Recessed Lighting
- Appliances: Stainless Steel Appliance(s), Electric Oven, Electric Range, Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Washer
Rooms
Bathrooms
- Total Bathrooms: 4
- Full Bathrooms: 3
- Half Bathrooms: 1
Bedrooms
- Total Bedrooms: 4
Other Rooms
- Laundry: Laundry Room, Main Level
Additional Information
- Shared Amenities: Landscaping, Playground, Pool, Trail(s)
Exterior
- Porch/Patio/Deck: Patio, Porch
Parking
- Garage: Yes
- Garage Spaces: 2
- Parking Features: Driveway, Garage
Location
- County: Boone
- Driving Directions: Mt. Zion Rd OR US-42 to Wetherington to Lancashire to Cherbourg.
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
- Assoc. Fees Include: Association Fees, Maintenance Grounds, Management
Heating & Cooling
- Central air: Yes
- Air Conditioning: Yes
- Cooling Type: Central Air Conditioning
- Heating Type: Natural Gas, Forced Air
Utilities
- Sewer: Public Sewer
- Water: Public
- Cable Available: Yes
- Utility Description: Cable Available, Natural Gas Available
Structural Information
- Architectural Style: Traditional
- Construction: Brick, Vinyl Siding
- Basement Desc.: Full, Finished, Storage Space
- Roof: Shingle
- Windows: Insulated Windows
- Square Feet: 2,925
- Living Area: 2,925 Sq. Ft.
- Year Built: 2002
- Property Condition: Existing Structure
Lot Features
- Lot Size (Acres): 0.23
- Lot Size (Sq. Ft.): 10,019
- Lot Size: .23
- Lot Size Source: Realist
- Lot Dimensions: 71 x 142
- Lot Features: Cleared
- Zoning: Residential
- Fencing (Description): Wood
Financial Considerations
- Association Fee: $413
- Assoc Fee Freq.: Annually
Disclosures and Reports
- Property ID: 063.00-16-143.00
Listed by Huff Realty - Ft. Mitchell, Lauren Smith
Sold by Pivot Realty Group, Mandy Kaplan
Get Pre-Approved Today
Schools
Schools serving 9788 Cherbourg Dr
School District:Boone County School District
| Name | Grades | Distance |
|---|---|---|
Erpenbeck Elementary School US 42 9001 Wetherington Blvd, Florence, KY 41042 | K-5 | 0.9 mi |
Ockerman Middle School 8300 U.S. 42, Florence, KY 41042 | 6-8 | 2.1 mi |
Larry A. Ryle High School 10379 U.S. 42, Union, KY 41091 | 9-12 | 1.5 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 9788 Cherbourg Dr
Date
Details
Price
Change
Source
6/15/2026
Sold
$415,000
-2.35%
MLS
5/01/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.
9788 Cherbourg Drive, Union, KY 41091 (MLS# 642152) is a Single Family property that was sold at $415,000 on June 15, 2026. Want to learn more about 9788 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.

