Coldwell Banker Home Page
Skip to main contentColdwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Realty
Property view
Listing view 2
Listing view 3

506 Affirmed Avenue, 
Union, KY 41091

$1,399,900

5

Beds

6

Baths

5,200

Sq Ft

Single Family

Virtual Tour

Pending

Listed by

Nicole Hayden

, 

Heather Herr

Side Realty LLC.

Last updated:

May 23, 2026, 07:28 AM

MLS#

641176

Source:

KY NKMLS

About This Home

506 Affirmed Avenue

Showcase of Homes, Custom built residence built by Our Farmer House. Perfectly positioned this new 5,200+ sq ft modern european-inspired farmhouse 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. 3-car garage, designer finishes, and a professionally landscaped backyard oasis. Set on the largest lot in community at 1.1 acres. 1200 sq ft of outdoor turf living and in Union's premier golf community just steps from the new Publix and Triple Crown's top tier amenities.

Home Facts

Single Family

6 Baths

5 Bedrooms

Built in 2025

Price Summary

1,399,900

$269 per Sq. Ft.

MLS #:

641176

Last Updated:

May 23, 2026, 07:28 AM

Added:

1 month(s) ago

Rooms & Interior

Bedrooms

Total Bedrooms:

5

Bathrooms

Total Bathrooms:

6

Full Bathrooms:

5

Interior

Living Area:

5,200 Sq. Ft.

Structure

Structure

Building Area:

5,200 Sq. Ft.

Year Built:

2025

Lot

Lot Size (Sq. Ft):

43,560

Finances & Disclosures

Finances

Price:

$1,399,900

Price per Sq. Ft:

$269 per Sq. Ft.

Source:KY NKMLS
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 Coldwell Banker 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.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, 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 a Coldwell Banker 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®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, 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 a Coldwell Banker 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®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.