Debbie Steiner

Please reload the page to update with the latest MLS information available.

Please reload the page to update with the latest MLS information available.

Please reload the page to update with the latest MLS information available.

Reload
 
Listing provided courtesy of RE/MAX Victory + Affiliates- MLS# 639455 Sold by Comey & Shepherd, LLCMLS Provider

10664 Turcotte CourtUnion, KY 41091

Single Family · 5 Beds · 4 Full Baths · 1 Half Bath · 5,256 Sq. ft. | 0.46 Acres
$839,000 Sold
Sold on 3/20/2026

10664 Turcotte Court Overview

Visits:
13

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!

Love this property?
Create a profile to receive updates on this property when it's back on the market!
View Map

10664 Turcotte Court Facts & Features

  • Type Single Family
  • Sq. ft. 5,256
  • Price/Sq.ft. $160
  • Lot 0.46 Acres

Details

General

Association/HOA

  • Association Fee: 475.0
  • Association Fee Frequency: Annually
  • Association Fee Includes: Management
  • Association: Yes

School Information

  • Elementary School: New Haven Elementary
  • Middle Or Junior School: Gray Middle School
  • High School: Ryle High

Building Information

  • New Construction: No
  • Security Features: Smoke Detector: true
  • Sewer: Public Sewer: true
  • Year Built: 2006

Location/Region

  • County Or Parish: Boone
  • MLS Area Major: K11 - Richwd/Un/Wal/Ver/SB
  • MLS Area Minor: K11 - Richwd/Un/Wal/Ver/SB

Parking Information

  • Parking Features: Attached: true
  • Parking Features: Garage Door Opener: true
  • Parking Features: Garage Faces Side: true

General Information

  • Parcel Number: 064.13-07-026.00
  • Property Sub Type: Single Family Residence
  • Property Type: Residential

Interior

Building Information

  • Cooling: Central Air: true
  • Heating: Forced Air: true

Parking Information

  • Garage Spaces: 3.0
  • Garage: Yes

Beds/Baths

  • Bathrooms Full: 4
  • Bathrooms Half: 1
  • Bathrooms Total: 5
  • Bedrooms Total: 5

Building Interior

  • Building Area Total: 5256.0
  • Interior Features: Ceiling Fan: true
  • Interior Features: Crown Molding: true
  • Interior Features: Granite Counters: true
  • Interior Features: High Ceilings: true
  • Interior Features: Recessed Lighting: true
  • Interior Features: Stone Counters: true
  • Interior Features: Tray Ceiling: true
  • Interior Features: Vaulted Ceiling: true

General Information

  • Appliances: See Remarks, Stainless Steel Appliance(s), Dishwasher, Disposal, Double Oven, Microwave, Refrigerator
  • Fireplace Features: Gas
  • Fireplace: Yes
  • Fireplaces Total: 2
  • Foundation Details: Poured Concrete
  • 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)
  • Laundry Features: Laundry Room
  • Living Area: 5256.0
  • Living Area Units: Square Feet
  • Rooms Total: 11
  • Security Features: Smoke Detector(s)

Exterior

Parking Information

  • Parking Features: Attached, Driveway, Garage, Garage Door Opener, Garage Faces Side, Off Street, Oversized

Lot Information

  • Lot Features: Cul-De-Sac, Sprinklers In Front, Sprinklers In Rear, Wooded
  • Lot Size Acres: 0.46
  • Lot Size Area: 0.46
  • Lot Size Dimensions: .4558
  • Lot Size Source: Realist
  • Lot Size Square Feet: 19855.0
  • Lot Size Units: Acres
  • Water Source: Public

Waterfront/View

  • View: Trees/Woods
  • View: TreesWoods: true

Building Exterior/Construction

  • Attached Garage: Yes
  • Construction Materials: Brick
  • Exterior Features: Lighting: true
  • Patio And Porch Features: Covered, Deck, Porch
  • Property Attached: No
  • Roof: Composition, Shingle

General Information

  • Exterior Features: Private Yard, Lighting, Other
  • Fencing: Fenced, Split Rail, Wood
  • Sewer: Public Sewer
  • Utilities: Underground Utilities

10664 Turcotte Court Neighborhood

Community

41091 (Union) Demographics

38
Median Age
411
Population Density (per sq. mile)
56%
College Educated
$120,826
Estimated Median Income
6,226
Estimated Total Home Owners
451
Estimated Total Renters
93% / 7%
Estimated Owner / Renter Divide
3
Estimated Average Household Size
Community data courtesy of LiveBy, Inc.

Schools

School data courtesy of LiveBy, Inc. School ratings are based on a scale of 1-5, with 5 being the highest rating and 1 being the lowest rating.

10664 Turcotte Court Market Data

Based on the last 30 days in this zip code

$584,928
Average List Price
$299
Average Price per Square Foot
52
Properties Sold
66
Average Days on Market
222
Properties for Sale
Calculations provided by Reliance Network

10664 Turcotte Court History

Date Event Value Agent
3/30/2026Source: Northern Kentucky MLS Status Change
Sold
2/7/2026Source: Northern Kentucky MLS Status Change
Pending
1/23/2026Source: Northern Kentucky MLS Added to Database
January 23, 2026