10605 Pimlico Park, Union, KY 41091

Local realty services provided by:ERA Real Solutions Realty
10605 Pimlico Park,Union, KY 41091
$945,000
  • 3 Beds
  • 3 Baths
  • 4,285 sq. ft.
  • Single family
  • Active
Listed by: susan huff, maria huff schilling
Office: huff realty - florence
MLS#:647043
Source:KY_NKMLS

Price summary

  • Price:$945,000
  • Price per sq. ft.:$220.54
  • Monthly HOA dues:$435

About this home

Stunning custom-built ranch by EGC overlooking the #12 green and fairway at Triple Crown Country Club! This 3-bedroom, 3-bath home offers easy living in an HOA-maintained community. The open, bright floor plan features a gourmet kitchen with beautiful cabinetry, and abundant natural light. The primary suite includes a walk-in shower, while the finished lower level provides additional living space and a walkout to the patio. A 3-car garage offers plenty of room for vehicles and storage. Completely updated and move-in ready, with numerous 2026 improvements including a new furnace, landscaping, kitchen and pantry flooring, refinished main-level floors, completely renovated guest bath, new staircase carpet, dishwasher, updated several light fixtures, fresh interior paint throughout, and a new bar refrigerator. Enjoy beautiful golf-course views and the convenience of maintenance-free living in one of Triple Crown's desirable communities.

Contact an agent

contact an agent

Yes, I would like more information. Please use and/or share my information with an ERA®  affiliated agent to contact me about my real estate needs. By clicking Send message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an ERA®  affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE® , CENTURY 21® , Coldwell Banker® , Corcoran® , Sotheby's International Realty® ).
 I acknowledge that I have read and agree to theTerms of useandPrivacy notice

Home facts

  • Year built:2004
  • Subdivision & Development:Triple Crown Country Club
  • Listing ID #:647043
  • Added:2 day(s) ago
  • Updated:October 01, 2026 at 04:40 PM

Rooms and interior

  • Bedrooms:3
  • Total bathrooms:3
  • Full bathrooms:3
  • Rooms Total:13
  • Kitchen Description:Convection Oven, Dishwasher, Disposal, Eat-in Kitchen, Gas Cooktop, Kitchen Island, Microwave, Pantry, Stainless Steel Appliance(s)
  • Bedroom Description:Master Downstairs
  • Basement Description:Finished, Full, Walk-Out Access
  • Living area:4,285 sq. ft.

Heating and cooling

  • Cooling:Central Air
  • Heating:Forced Air
  • Central air:Yes

Structure and exterior

  • Year built:2004
  • Building area:4,285 sq. ft.
  • Lot area:0.14 Acres
  • Architectural Style:Ranch
  • Construction Materials:Brick
  • Exterior Features:Covered, Deck, Patio, Porch
  • Foundation Description:Poured Concrete

Schools

  • High school:Boone County High
  • Middle school:Gray Middle School
  • Elementary school:New Haven Elementary

Utilities

  • Water:Public
  • Sewer:Public Sewer

Finances and disclosures

  • Price:$945,000
  • Price per sq. ft.:$220.54

Features and amenities

  • Appliances:Microwave
  • Laundry features:Main Level
  • Amenities:Ceiling Fan(s), Crown Molding, Granite Counters, High Ceilings, Landscaping, Master Downstairs, Multi Panel Doors, Recess Ceiling(s), Recessed Lighting, Wired for Sound

Parking

  • Garage:Yes
  • Garage spaces:3
Information Deemed Reliable but Not Guaranteed. 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 ERA Real Solutions Realty 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. Copyright 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.