$1,750,000

506 Affirmed Avenue, Union, KY 41091

  • 5 beds |
  • 6 baths
  • Property Icon Single-Family Home
  • Property Year Built Icon Built in 2025
  • Property Lot Size Icon1.01acre lot
  • Property Parking Icon 3 car garage
  • Property Price Per Square Feet Icon $——/sqft
  • Property List Date Icon Listed 4 months ago

Property Description

2025 Showcase Home from the Home Show! This brand-new 5,200+ sq ft Modern European-inspired farmhouse by Our Farmer House is a rare opportunity in Triple Crown. Designed to impress with 5 bedrooms, 5.5 baths, an oversized bunk room, private theater, and open concept living perfect for entertaining. The gourmet kitchen boasts GE Monogram appliances and a walk-in dream pantry. Vaulted ceilings with wood beams, rich hardwoods, and a spa-like primary suite add luxurious touches. Enjoy a 3-car garage, designer finishes, and a professionally landscaped backyard oasis. Set on an oversized acre lot in Union's premier golf community just steps from the new Publix and Triple Crown's top tier amenities. This Showcase Home just took center stage at the Showcase of Homes at Triple Crown!

Listing Status:
Active
Listing Office:
Huff Realty - Florence : 859-525-7900
Listing Agent:
Donna Berling : 859-240-6544
MLS ID:
633375
  • General: Recessed LightingMulti Panel DoorsHigh CeilingsCrown MoldingCathedral Ceiling(s)Vaulted Ceiling(s)Beamed CeilingsButler's PantryDouble VanityEat-in KitchenEntrance FoyerGranite CountersKitchen IslandOpen FloorplanPantryStone CountersStorageWalk-In Closet(s)
  • Appliances: DisposalDishwasherRefrigeratorConvection OvenStainless Steel Appliance(s)
  • Laundry: Main Level
  • Basement: Full Finished Bath
  • A/C: Central Air
  • Heating: Natural Gas
  • Fireplace: GasFireplaceFireplaces: 1
  • General: LightingFire PitOutdoor KitchenPrivate Yard
  • Style: Transitional
  • Parking: AttachedGarage Faces SideGarage
  • Roofing: Shingle
  • Windows: Insulated Windows
  • General: OtherTwoConcrete Perimeter
  • Road/Access: Paved
  • HOA Amenities: ClubhouseTennis Court(s)PlaygroundDog ParkManagement475.0Annually
  • Originating MLS: Northern Kentucky Multiple Listing Service
  • School District: Boone Co Public
  • County: Boone
  • Utilities: Underground Utilities
  • Water: Public
  • Sewer: Public Sewer
  • Source: Northern Kentucky Multiple Listing Service

This listing courtesy of Donna Berling, Huff Realty - Florence

Monthly Payment

$Est. Payment
  • Principal & Interest $
  • Property Taxes $
  • Home Insurance $
  • VA Funding Fee $

Ready to Start a VA Loan?

Get Started Veterans United Home LoansNMLS #1907  †
Get Prequalified »
Interest rates used in the VA mortgage calculator are shown for illustrative purposes only. Your rate may differ based on a variety of factors, including your credit score and the current market conditions. To get your personalized interest rate, start your quote online.

Location

Schools Nearby

N

New Haven Elementary School

10854 US 42, Union, KY, 41091

Grades PK-5

1.73 miles away

G

Gray Middle School

10400 US 42, Union, KY, 41091

Grades 6-8

1.92 miles away

L

Larry A. Ryle High School

10379 US 42, Union, KY, 41091

Grades 9-12

1.91 miles away

Disclaimer: School and School District information courtesy of the National Center for Education Statistics (NCES). School boundaries may change. Proximity to listed schools does not guarantee enrollment eligibility. Contact the school district for more information and exact boundaries.

Similar Listing

10567 Secretariat, Union, KY 41091
Single-Family Home For Sale

$2,000,000

  • 5 bed |
  • 5 bath |
  • 0.72 acre lot
10567 Secretariat Union, KY 41091

#636538 - Keller Williams Realty Services