Sold25d on market
10664 Turcotte Ct
Union, KY, 41091 • 41091 • Boone County
$839,000
$160/sqft
5Beds
5Baths
5,256Sqft
0.46 acLot
2006Built
Property DNA
Trees/Woods Views
Trees/Woods
Transitional Style
Built 2006 · 20 years of history
Outdoor Living
Covered · Deck · Porch
2 Fireplaces
Gas
3-Car Garage
Attached · Driveway · Garage · Garage Door Opener · Garage Faces Side · Off Street · Oversized
Premium Finishes
Walk-In Closet(s) · Granite Counters · Crown Molding
$40/mo HOA
Dog Park · Playground · Tennis Court(s) · Trail(s)
This home is in high demand
Listed 25 days ago · 118 views · Top 9% likely to sell soon
Market activity
Demand and pricing signals for this listing
118 views
People checking out this listing
25 days on market
Recently listed
$160/sqft
Price per square foot
Selling Soon Prediction
Very HighThis home ranks in the top 9% of listings most likely to go under contract soon, based on market activity and demand signals.
Likelihood score
Want the full market analysis?
Get the detailed selling prediction score, comparable sales data, and price trend forecast for this property.
Free · Delivered to your inbox in minutes
About this home
Single Family · Built 2006
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!
Standout features identified
Our analysis highlights fantastic custom wooden shutters, quality all brick construction, and generously sized rooms as key attractions of this home.
Estimated monthly payment
Based on current rates
$5,512/month
Principal & Interest$4,353
Property Tax$839
Insurance$280
HOA$40
Down payment20% ($167,800)
3%50%
Est. 6.75% rate · 30yr fixed · $671,200 loan
Full calculator →At a glance
Key facts and listing details
TypeSingle Family Residence, Residential
Year Built2006
HeatingForced Air
CoolingCentral Air
Parking3 Attached Garage spaces
HOA$475 annually
Lot0.46 Acres
Property
Home typeSingle Family
Sub-typeSingle Family Residence, Residential
StyleTransitional
Year built2006
Stories2
Systems
HeatingForced Air
CoolingCentral Air
RoofComposition,Shingle
ConstructionBrick
Water / SewerPublic / Public Sewer
Parking & Outdoor
ParkingAttached, Driveway, Garage, Garage Door Opener, Garage Faces Side, Off Street, Oversized
Garage3 spaces
BasementSee Remarks,Full
Fireplaces2
FencingSplit Rail,Wood
Lot0.46 Acres
Location & Tax
Neighborhood41091
Annual tax$6,559
Parcel064130702600
Bathrooms & Fees
Full baths4
HOA$40/mo
Features & details
15 categories of property features
Interior Features
Interior
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
Cathedral Ceiling(s)
Ceiling Fan(s)
High Ceilings
Recess Ceiling(s)
Recessed Lighting
Vaulted Ceiling(s)
Appliances
See Remarks
Stainless Steel Appliance(s)
Dishwasher
Disposal
Double Oven
Microwave
Refrigerator
Heating
Forced Air
Cooling
Central Air
Laundry
Laundry Room
Fireplace
Gas
Windows
Vinyl Frames
Exterior Features
Exterior
Private Yard
Lighting
Parking
Attached
Driveway
Garage
Garage Door Opener
Garage Faces Side
Off Street
Oversized
Construction
Brick
Patio & Porch
Covered
Deck
Porch
Lot Features
Cul-De-Sac
Sprinklers In Front
Sprinklers In Rear
Wooded
Security
Smoke Detector(s)
Views
Trees/Woods
Utilities
Underground Utilities
Room details
19 rooms detailed
Primary Bedroom
First21×14 ft294 sqft
Bath AdjoinsCeiling Fan(s)Carpet FlooringDressing AreaSee RemarksTray Ceiling(s)Walk-In Closet(s)
Bedroom2
Second15×14 ft210 sqft
Bath AdjoinsCarpet FlooringSee RemarksWalk-In Closet(s)Ceiling Fan(s)
Bedroom3
Second14×12 ft168 sqft
Ceiling Fan(s)Carpet FlooringSee Remarks
Bedroom4
Second14×12 ft168 sqft
Ceiling Fan(s)Carpet FlooringSee Remarks
Bedroom5
Lower20×16 ft320 sqft
Carpet FlooringSee RemarksWalk-In Closet(s)
Bathroom2
Second7×5 ft35 sqft
Full Finished BathSee RemarksShowerTubTile FlooringTub With Shower
Listing insights
Market data and value estimates
StatusSold
Days on market25
Est. value$839,500
Est. rent$4,531/mo
Tax rate0.82%
Price/sqft$160
On marketMar 15, 2026
PostedMar 15, 2026
Last sold$839,000
MLS updatedMar 30, 2026
Tour days6
Views118
How are the schools in Union?
3 schools rated nearby
Location
Union, KY, 41091
Price history
11 events
DateEventPrice$/sqftSource
Mar 20, 2026Sold$839,000$160NKMLS
Feb 7, 2026Pending Sale$839,800$160NKMLS
Jan 23, 2026Listed For Sale$839,800$160NKMLS
Nov 27, 2017Sold$548,050$104Public Record
Sep 19, 2017Price Change$585,000$111RE/MAX AFFILIATES
Jul 20, 2017Price Change$589,800$112RE/MAX Affiliates
May 22, 2017Price Change$599,800$114RE/MAX Affiliates
Apr 5, 2017Price Change$609,800$116RE/MAX Affiliates
Feb 14, 2017Listed For Sale$619,800$118RE/MAX Affiliates
Oct 13, 2006Sold$512,000$97Public Record
May 26, 2006Sold$96,000$18Public Record
Sold$839,000
Mar 20, 2026•$160/sqft•NKMLS
Pending Sale$839,800
Feb 7, 2026•$160/sqft•NKMLS
Listed For Sale$839,800
Jan 23, 2026•$160/sqft•NKMLS
Sold$548,050
Nov 27, 2017•$104/sqft•Public Record
Price Change$585,000
Sep 19, 2017•$111/sqft•RE/MAX AFFILIATES
Price Change$589,800
Jul 20, 2017•$112/sqft•RE/MAX Affiliates
Price Change$599,800
May 22, 2017•$114/sqft•RE/MAX Affiliates
Price Change$609,800
Apr 5, 2017•$116/sqft•RE/MAX Affiliates
Listed For Sale$619,800
Feb 14, 2017•$118/sqft•RE/MAX Affiliates
Sold$512,000
Oct 13, 2006•$97/sqft•Public Record
Sold$96,000
May 26, 2006•$18/sqft•Public Record
Tax history
13 years of records
YearTax paidAssessed value
Apr 15, 2023$6,559$569,800
Apr 15, 2022$6,397$569,800
Apr 15, 2021$6,166$548,100
Apr 15, 2020$6,350$548,100
Apr 15, 2019$6,350$548,100
Apr 15, 2018$6,329$548,100
Apr 15, 2017$5,840$511,850
Apr 15, 2015$5,840$511,850
Apr 15, 2013$5,661$511,850
Apr 15, 2012—$511,850
Apr 15, 2011—$511,850
Apr 15, 2010—$511,850
Apr 15, 2009—$511,850
Nearby homes
Neighborhood details
Local context around this listing
Union, KY • Boone County
Nearby cities
BurlingtonCovingtonElsmereErlangerFlorenceHebronIndependenceUnion
Nearby zip codes
41094
Similar homes
The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of NKMLS. Real estate listings held by IDX Brokerage firms other than Zillow, Inc. are marked with the Internet Data Exchange logo or the Internet Data Exchange thumbnail logo and detailed information about them includes the name of the listing Brokers. Listing information is deemed reliable, but not guaranteed. Copyright 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.
No obligation · Same-day response