10664 Turcotte Court, Union, KY 41091

• 5 beds |
• 5 baths |
• 5,256 sqft

Property Description

OFFERING THE ULTIMATE LIFESTYLE! Magnificent 5 Bedroom, 4.5 Bath, 3 Car Oversized Side Entry Garage, Masterpiece! Award Winning New Haven Elementary, Gray Middle, & Ryle High School District/Hard to Find Residence Located in a Spectacular Custom Section of Desirable, Triple Crown Country Club Neighborhood/Surrounded by Upscale, High-End Homes w/Estate Lots Boasting a Quick Walk to the Pool, Clubhouse, & Golf Course/Large, Level Cul-De-Sac Homesite w/Private Setting & Split Rail Fencing/Additional Land Extends Beyond the Fence/Expansive, Maintenance Free Polymer Decking/Wired for Outdoor Sound System/Quality All Brick Construction/3 Finished Levels w/Approximately 5,256 Square Feet of Finished Living Space/Massive 2 Story Entry has Crown Molding, Large Chandelier, Ceramic Flooring, Beautiful Decorative Window & Transom/Incredible Great Room w/ Soaring Ceilings, Wall of Windows, & Gas Fireplace/Gourmet Kitchen w/Double Oven, Granite Counters, Upscale 42 inch Cabinetry, Counter Bar, Island, Pantry, & Inviting Breakfast Area/Fabulous 1ST Floor Primary Suite w/Fireplace, 2 Large Closets, & a Luxurious Bathroom w/Granite Vanity Tops, Raised Vanities, Vessel Sinks, Separate Soaking Tub & Shower, & Water Closet/1ST Floor Study has French Doors with Transoms & Gorgeous Windows w/Transoms Allowing for Lots of Natural Light/Relaxing Dining Room w/Tray Ceiling & Crown Molding/1ST Floor Laundry RM has Utility Tub & Cabinetry/Generously Sized Rooms/Additional Suite Offers an En Suite Bathroom & a Walk-In Closet/Plushly Finished Lower Level Perfect for Flexible Living Arrangements Boasting a Large Living Area, Huge Safe Room/Walk-In Closet, Kitchen, Breakfast Area, Bedroom, & Full Bathroom in Lower Level/Lower Level French Patio Door Walkout to Rear Yard/Fantastic, Custom Wooden Shutters/Elaborate Crown Moldings & Detailed Millwork/Custom Appointments Throughout/All Bath Mirrors Over Sinks Stay/Meticulously Kept/Irrigation System in Front & Rear/Low County Tax Rate/+ MUCH MORE!

Listing Status:

Pending

Data Last Updated:

February 14, 2026 at 4:38PM

Listing Office:

RE/MAX Victory + Affiliates : 859-372-6000

Listing Agent:

Jane Ashcraft-West : 859-344-5766

MLS ID:

639455

Interior

• General: Built-in FeaturesWet BarCeiling Fan(s)Recessed LightingAttic StorageMulti Panel DoorsHigh CeilingsCrown MoldingCathedral Ceiling(s)Vaulted Ceiling(s)Recess Ceiling(s)Breakfast BarChandelierDouble VanityEat-in KitchenEntrance FoyerGranite CountersKitchen IslandPantrySoaking TubStone CountersStorageTray Ceiling(s)Walk-In Closet(s)See Remarks
• Appliances: DisposalDouble OvenDishwasherMicrowaveRefrigeratorStainless Steel Appliance(s)See Remarks
• Laundry: Laundry Room
• Basement: FullWalk-Out AccessFull Finished BathFinishedKitchenSee RemarksStorage Space
• A/C: Central Air
• Heating: Forced AirNatural Gas
• Fireplace: GasFireplaceFireplaces: 2

Exterior

• General: LightingSee RemarksPrivate Yard
• Style: Transitional
• Parking: AttachedDrivewayOff StreetGarage Faces SideOversizedGarage Door OpenerGarage

Construction

• Roofing: CompositionShingle
• Windows: Insulated WindowsVinyl Frames
• General: BrickTwoPoured Concrete

Location

• HOA Amenities: Tennis Court(s)PlaygroundTrail(s)Dog ParkManagement475.0Annually
• Originating MLS: Northern Kentucky Multiple Listing Service
• School District: Boone Co Public
• County: Boone

Lot

• Zoning: 064.13-07-026.00
• View: Trees/WoodsView
• Fencing: WoodSplit RailFenced

Utilities

• Utilities: Underground Utilities
• Water: Public
• Sewer: Public Sewer

Financial

• Source: Northern Kentucky Multiple Listing Service