Sign In

Close

x
Showing 1 of 0
X
Save
506 Affirmed Avenue Union KY 41091US5 Bed, 6.00 Bath (5 Full Bath , 1 Half Bath), 633375
506 Affirmed Avenue UnionKY41091
1750000.0000 1/1/1900 12:00:00 AM
Huff Realty - Florence
1 /

Courtesy of: Donna Berling, Huff Realty - Florence, dberling@huff.com

506 Affirmed Avenue
Union KY 41091 US

Save
1 /

Courtesy of: Donna Berling, Huff Realty - Florence, dberling@huff.com

Get more info about this property

506 Affirmed Avenue
Union KY 41091 US

$1,750,000

Active Listing ID 633375
bed icon
5 bed
bath icon
6.00 Bath (5 Full , 1 Half)
lot icon
Lot: 1.01 Acres
home icon
Single Family Residence

$1,750,000

Active Listing ID 633375
Save
3d icon
Maps

506 Affirmed Avenue 2025 Showcase Home buy it before 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. Be the one to own this Showcase Home before it takes center stage at the Showcase of Homes at Triple Crown!

Collapse all

Property Features

  • Facts
  • Lot Size: 1.01 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 5
  • 1/2 Bathrooms: 1
  • Cooling System: Central Air
  • Exterior Finish: Cul-de-sac, Outdoor Kitchen, Private Yard, Fire Pit, Lighting, Patio
  • Roof Type: Shingle
  • Heating Fuels: Fireplace(s)
  • Additional Features
  • Fireplace
  • Patio

School Information

  • School
  • New Haven Elementary(Elementary)
  • Gray Middle School(MiddleSchool)
  • Ryle High(HighSchool)

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 1750000
  • unparsedaddress: 506 Affirmed Avenue
  • postalcity: Union
  • stateorprovince: KY
  • country: US
  • postalcode: 41091
  • bathroomsfull: 5
  • bathroomshalf: 1
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 1.01
  • lotsizeunits: Acres
  • lotsizearea: 1.01
  • livingarea: 0
  • livingareaunits: Square Feet
  • latitude: 38.915789
  • longitude: -84.637636
  • listagentfullname: Donna Berling
  • listagentemail: dberling@huff.com
  • listagentkey: 3yd-NKARKY-432509096
  • listagentmlsid: 432509096
  • listagentpreferredphone: 8592406544
  • listagentofficephone: 8595257900
  • listofficekey: 3yd-NKARKY-o432500054
  • listofficemlsid: o432500054
  • disclaimer: Copyright © 2025 Northern Kentucky MLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: NKARKY
  • yearbuilt: 2025
  • listingcontractdate: 2025-06-11
  • listagenturl: http://www.huff.com
  • countyorparish: Boone
  • elementaryschool: New Haven Elementary
  • highschool: Ryle High
  • elementaryschooldistrict: Boone Co Public
  • middleorjuniorschooldistrict: Boone Co Public
  • highschooldistrict: Boone Co Public
  • appliances: Dishwasher, Garbage Disposer, Oven - Convection, Refrigerator, Washer
  • cooling: Central Air
  • heating: Fireplace(s)
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 0
  • parkingfeatures: Garage
  • roof: Shingle
  • waterfrontyn: False
  • interiorfeatures: Kitchen Island, Walk-in Closet(s), Storage, Stone Counters, Pantry, Open Floorplan, Granite Counters, Entrance Foyer, Eat-in Kitchen, Double Vanity, Crown Molding, Beamed Ceilings, Butler's Pantry, Cathedral Ceiling(s), High Ceilings, Multi Panel Doors, Recessed Lighting, Vaulted Ceiling(s), Master Downstairs
  • exteriorfeatures: Cul-de-sac, Outdoor Kitchen, Private Yard, Fire Pit, Lighting, Patio
  • architecturalstyle: Other
  • rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bathroom 5, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Dining Room, Great Room, Gym, Kitchen, Utility Room
  • otherstructures: Outdoor Kitchen
  • patioandporchfeatures: Patio
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -84.637634, 38.91579
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"HUFF Realty, LLC", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "Expenses":[{"ExpenseCategory":"Home Owner Assessments Fee", "ExpenseFrequency":"Annually", "ExpenseValue":475}], "GeocodeOptions":null, "LeadRoutingEmail":"dberling@huff.com", "ListBrokerageCity":"Ft. Mitchell", "ListBrokerageCountry":"US", "ListBrokerageEmail":"itdept@huff.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/NKARKY/7a5e1300bf2e11de97d200065bf395fa/20091119110931853.gif", "ListBrokerageName":"HUFF Realty, LLC", "ListBrokeragePhone":"(859) 344-4616", "ListBrokeragePostalCode":"41017", "ListBrokerageStateOrProvince":"KY", "ListBrokerageUnitNumber":"Suite 500", "ListBrokerageUnparsedAddress":"334 Beechwood Rd.", "ListBrokerageWebsiteUrl":"http://www.huff.com", "ListOfficeAddress1":"60 Cavalier Blvd.", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"432500761", "ListOfficeCity":"Florence", "ListOfficeCountry":"US", "ListOfficeEmail":"susan@susanhuff.com", "ListOfficePostalCode":"41042", "ListOfficeStateOrProvince":"KY", "ListPriceCurrencyType":"USD", "ListingTitle":"Transitional, Single Family Residence - Union, KY", "ListingURL":"https://listings.listhub.net/pages/NKARKY/633375/?channel=rexren", "MLSModificationTimestamp":null, "Neighborhoods":[{"Description":null, "Name":"K11 - Richwd/Un/Wal/Ver/SB"}], "PostalCode":null, "RawPropertySubType":"Single Family Residence", "RawPropertyType":"Residential", "RoomCount":12, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 7/29/2025 1:01:30 AM GMT
Source Updated Date: 12/8/2025 12:55:19 PM GMT

Courtesy of: Donna Berling, Huff Realty - Florence, dberling@huff.com

Copyright © 2025 Northern Kentucky MLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Contact