This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
$839,000
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
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!
Full Property Details
Full Property Details for 10664 Turcotte Ct
General
- Sold For: $839,000
- HOA FEE: $40/month
- HOA FEE FREQ.: Annually
- Status: Closed
- Type: Single Family
- Source: Northern_Kentucky
- MLS ID: 639455
- Added to Site: 70 day(s) ago
Interior
- Number of Rooms: 11
- Interior Features: See Remarks, Kitchen Island, Wet Bar, Walk-In Closet(s), Tray Ceiling(s), Storage, Stone Counters, Soaking Tub, Pantry, Granite Counters, Entrance Foyer, Eat-in Kitchen, Double Vanity, Crown Molding, Chandelier, Breakfast Bar, Built-in Features, Attic Storage, Cathedral Ceiling(s), Ceiling Fan(s), High Ceilings, Multi-Panel Doors, Recess Ceiling(s), Recessed Lighting, Vaulted Ceiling(s)
- Fireplace: Yes
- Number of Fireplaces: 2
- Fireplace(s): Gas
- Appliances: See Remarks, Stainless Steel Appliance(s), Dishwasher, Disposal, Double Oven, Microwave, Refrigerator
Rooms
Bathrooms
- Total Bathrooms: 5
- Full Bathrooms: 4
- Half Bathrooms: 1
Bedrooms
- Total Bedrooms: 5
Other Rooms
- Laundry: Laundry Room
Additional Information
- Shared Amenities: Dog Park, Playground, Tennis Court(s), Trail(s)
- Security/Safety: Smoke Detector(s)
Exterior
- Exterior Features: Private Yard, Lighting, Other
- Porch/Patio/Deck: Covered, Deck, Porch
Parking
- Garage: Yes
- Attached garage: Yes
- Garage Spaces: 3
- Parking Features: Attached, Driveway, Garage, Garage Door Opener, Garage Faces Side, Off Street, Oversized
Location
- County: Boone
- Cross Streets: Secretariat
- Driving Directions: Triple Crown Blvd to Secretariat to L on Turcotte. Home is on the Left.
School Information
- Elementary School: New Haven Elementary
- Middle School: Gray Middle School
- High School: Ryle High
Community
- Community Name: K11 - Richwd/Un/Wal/Ver/SB
- Association: Yes
- Assoc. Fees Include: 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
- Utility Description: Underground Utilities
Structural Information
- Architectural Style: Transitional
- Construction: Brick
- Basement Desc.: Kitchen, Full Finished Bath, See Remarks, Full, Finished, Storage Space, Walk-Out Access
- Roof: Composition, Shingle
- Windows: Insulated Windows, Vinyl Frames
- Square Feet: 5,256
- Living Area: 5,256 Sq. Ft.
- Year Built: 2006
Lot Features
- Property View: Trees/Woods
- Lot Size (Acres): 0.46
- Lot Size (Sq. Ft.): 19,855
- Lot Size: .46
- Lot Size Source: Realist
- Lot Dimensions: .4558
- Lot Features: Cul-De-Sac, Sprinklers In Front, Sprinklers In Rear, Wooded
- Fencing (Description): Fenced, Split Rail, Wood
Financial Considerations
- Association Fee: $475
- Assoc Fee Freq.: Annually
Disclosures and Reports
- Property ID: 064.13-07-026.00
Listed by RE/MAX Victory + Affiliates, Jane Ashcraft-West
Sold by Comey & Shepherd, LLC, Robert Dorger
Get Pre-Approved Today
Schools
Schools serving 10664 Turcotte Ct
School District:Boone County School District
| Name | Grades | Distance |
|---|---|---|
New Haven Elementary School 10854 U.S. 42, Union, KY 41091 | K-5 | 2.1 mi |
Gray Middle School 10400 U.S. 42, Union, KY 41091 | 6-8 | 2 mi |
Larry A. Ryle High School 10379 U.S. 42, Union, KY 41091 | 9-12 | 1.9 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 10664 Turcotte Ct
Date
Details
Price
Change
Source
3/20/2026
Sold
$839,000
-0.1%
MLS
1/23/2026
Listed
$839,800
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
10664 Turcotte Court, Union, KY 41091 (MLS# 639455) is a Single Family property that was sold at $839,000 on March 20, 2026. Want to learn more about 10664 Turcotte Court? 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.

