Views - Eco Friendly
Address
960 Dustwhirl Drive, Union, KY
Price
$ 774,000
Property Attributes
- MLS#646184
- TypeSingle Family
- Listing Status Active
- CountyBoone
- CityUnion
- AreaRichwd-Un-Wal-Ver-SB
- NeighborhoodTriple Crown Country Club
- Zip41091
- StyleTraditional
- Year Built1995
- Price$ 774,000
- Bedrooms4
- Full Bathrooms2
- Half Bathrooms1
- Sqr Footage4400
- Lot Size0.57 Acres
Data Source:
Northern Kentucky MLS (NKAR)
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*Some Pics Are AI Staged
| Elementary School | Middle School | High School |
|---|---|---|
| Shirley Mann School Elementary School | Gray Middle School Middle School | Ryle High High School |
| Price History | |
|---|---|
| 8/31/2026 | Listed $774,000 |
General Features
| Living Area | 4400 |
|---|---|
| Sewer | Public Sewer |
| Heating | Natural Gas |
| Cooling | Central Air |
| Utilities | Cable Available,Natural Gas Available,Sewer Available,Water Available |
| Roof | Shingle |
| HOA Fee | 500 |
| Garage Spaces | 3 |
| Patio/Porch Features | Covered,Enclosed,Patio,Porch |
| Architectural Style | Traditional |
| Pool Features | In Ground |
| Security Features | Security System,Smoke Detector(s) |
| Construction Materials | Brick,Vinyl Siding |
| Year Built | 1995 |
| Electric | 220 Volts |
| View | Golf Course |
| Levels | Two |
| Property Subtype | Single Family Residence |
| Assoc Fee Paid Per | Annually |
| County | Boone |
| New Construction | false |
| Property Type | Residential |
| Association Amenities | Landscaping,Dog Park,Playground,Tennis Court(s),Management |
| HOA | true |
| Attached Garage | true |
| Energy Efficient | Water Heater |
| Subdivision Name | Triple Crown Country Club |
| Garage Y/N | true |
| Green Water Conservation | Efficient Hot Water Distribution |
| Other Structures | Gazebo |
| Total Rooms | 14 |
| Status | Active |
| Directions | I 75 South to Richwood Exit, Right off Exit, Right On Triple Crown, Left on Whirlaway, Left on Arcaro, Left on Dustwhirl, Home on Left |
| High School | Ryle High |
| City | Union |
| Zoning Description | Residential |
| MLS Area | K11 - Richwd/Un/Wal/Ver/SB |
| Lot Size Units | Acres |
| Lot Size Square Feet | 24829 |
| Elementary School | Shirley Mann School |
| Property Attached Y/N | false |
| Middle/Junior High School | Gray Middle School |
| Property Condition | Existing Structure |
| MLS Area Minor | K11 - Richwd/Un/Wal/Ver/SB |
| Structure Type | House |
| Standard Status | Active |
Interior Features
| Interior Amenities | Kitchen Island,Walk-In Closet(s),Stone Counters,Soaking Tub,Pantry,Open Floorplan,Entrance Foyer,Eat-in Kitchen,Double Vanity,Crown Molding,Chandelier,Bidet,Ceiling Fan(s),High Ceilings,Multi Panel Doors,Recessed Lighting,Vaulted Ceiling(s) |
|---|---|
| Basement | Full,Finished,Storage Space,Unfinished |
| Total Fireplaces | 1 |
| Fireplace Features | Stone,Brick,Gas,Wood Burning |
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Window Features | Insulated Windows,Picture Window(s) |
| Fireplace Y/N | true |
| Laundry Features | Electric Dryer Hookup,Main Level,Washer Hookup |
| Total Baths | 3 |
Exterior Features
| Exterior Amenities | Private Yard,Fire Pit,Fountain,Hot Tub,Lighting,Outdoor Grill |
|---|---|
| Fencing | Aluminum,Metal |
| Parking Features | Attached,Driveway,Garage,Garage Door Opener,Garage Faces Side,Off Street,Oversized |
| Lot Features | On Golf Course,Sprinklers In Front,Sprinklers In Rear |
| Water Source | Public |
| Lot Size Area | 0.57 |
| Foundation Details | Poured Concrete |
| Lot Dimensions | irregular |
| Lot Size Acres | 0.57 |
| Road Surface Type | Paved |
| Door Features | French Doors,Sliding Doors,Storm Door(s) |
| Road Frontage Type | City Street |
| Other Equipment | Sump Pump,Humidifier |
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
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 eXp Realty in Northern Kentucky 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
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
