960 Dustwhirl Drive, Union, KY 41091

• 4 beds |
• 3 baths |
• 3,468 sqft

Property Description

Fairway-Front Entertainer's Haven*This Stunning Custom Built Home Sits In A Super Quiet CDS Street W/ The Perfect View of Hole #8 with a Side Panorama of Hole #9, In Prestigious Triple Crown CC*This Sun-Filled Retreat Is Built For Outdoor Families & Golf Enthusiasts-Where Morning Tee Times Roll Into Splashy Afternoons & Relaxed Evenings Under The Lights*The Resort-Style Backyard Is The Star: A 21,000-Gallon Heated Fiberglass Pool w/ Automatic Electric Cover (2023), New Dolphin Cleaner, New Chlorinator, And a 10-foot slide-Plus a Hot Tub (new motor 2024) Enclosed In The Screened In Porch*A 2nd Water Feature- Boulder-lined Fountain Pond w/ a 12-foot run-Sets a Tranquil Backdrop For Grill Nights & Gatherings*Outdoor Wood Burning Fireplace With 2 Woodpile Boxes*Amish Gazebo*Retractable Awning!*Extensive Landscape Lighting & a 67-Head Irrigation System Keep Everything Dialed-In and Game-Day Ready*Leaf Guard Screened Gutters*New Garage Door Motor Installed In June On Large Garage Door (w/5 yr warranty)*Inside, Fresh Professional Painting on the 1st & 2nd Floors (13k)*The Chef's Kitchen Features a 2023 Refrigerator, Dual Ovens, A Stovetop w/ Microwave (2012), & Updated Quartz countertops (2007)* Practical Upgrades--New HVAC ($24k), a Tankless Hot Water Heater (2014), and Whole-Home Water Filtration (2015)--Make Ownership Effortless*The 3-car Garage Is Fully Outfitted w/ Custom Cabinets, Upgraded Flooring, Storage Racks ($13k), And New Garage Doors (4K)* 7 window boxes with Automatic Irrigation Bring Vibrant Curb Appeal, & A Newer Washer & Dryer (2024) Add Everyday Convenience*Master Bath Also Comes With a Steam Shower (8k)*With Over $160,000 In Improvements, This Home Is Turnkey, & Built For Entertaining* Where Golf-Side Living Meets Backyard Adventure--Ready For Long Summers, Lively Weekends,& Easy Hosting*ADT Alarm System*Basement Is Partially Finished And Has Rough In.

Listing Status:

Active

Data Last Updated:

July 4, 2026 at 11:38PM

Listing Office:

Keller Williams Realty Service : 859-240-0727

Listing Agent:

The Vories Team : 859-240-0727

MLS ID:

644186

Interior

• General: Ceiling Fan(s)Recessed LightingMulti Panel DoorsHigh CeilingsCrown MoldingVaulted Ceiling(s)BidetChandelierDouble VanityEat-in KitchenEntrance FoyerKitchen IslandOpen FloorplanPantrySoaking TubStone CountersWalk-In Closet(s)
• Appliances: DisposalDouble OvenDryerDishwasherMicrowaveRefrigeratorWasherWater SoftenerTankless Water HeaterGas RangeGas Oven
• Laundry: Electric Dryer HookupMain LevelWasher Hookup
• Basement: FullUnfinishedFinishedStorage Space
• A/C: Central Air
• Heating: Natural Gas
• Fireplace: GasBrickWood BurningStoneFireplaceFireplaces: 2
• Eco/Green Feature: Water Heater

Exterior

• General: LightingHot TubFountainOutdoor GrillFire PitPrivate YardGazebo
• Style: Traditional
• Pool: In Ground
• Parking: AttachedDrivewayOff StreetGarage Faces SideOversizedGarage Door OpenerGarage

Construction

• Roofing: Shingle
• Windows: Insulated WindowsPicture Window(s)
• General: BrickVinyl SidingTwoPoured Concrete

Location

• Road/Access: City Street
• HOA Amenities: Tennis Court(s)PlaygroundDog ParkLandscapingManagement500.0Annually
• Originating MLS: Northern Kentucky Multiple Listing Service
• School District: Boone Co Public
• County: Boone

Lot

• Zoning: 064.04-07-210.00
• View: Golf CourseView
• Fencing: AluminumMetal

Utilities

• Utilities: Cable AvailableNatural Gas AvailableWater AvailableSewer Available0
• Water: Public
• Sewer: Public Sewer

Financial

• Source: Northern Kentucky Multiple Listing Service