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), 641176
506 Affirmed Avenue UnionKY41091
1499999.0000 1/1/1900 12:00:00 AM
Private Real Estate Collection

506 Affirmed Avenue
Union KY 41091 US

Save
1 /

Courtesy of: Nicole Hayden, Private Real Estate Collection, nikki@teamherr.com

Get more info about this property

506 Affirmed Avenue
Union KY 41091 US

$1,499,999

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

$1,499,999

Active Listing ID 641176
Save
3d icon
Maps

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.

Collapse all

Property Features

  • Facts
  • Lot Size: 1.00 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 5
  • 1/2 Bathrooms: 1
  • Cooling System: Central Air, Multi Units
  • Exterior Finish: Fire Pit
  • Roof Type: Shingle, Metal
  • Heating Fuels: Natural Gas
  • Additional Features
  • Basement
  • Fireplace
  • Patio

School Information

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

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 1499999
  • unparsedaddress: 506 Affirmed Avenue
  • postalcity: Union
  • stateorprovince: KY
  • country: US
  • postalcode: 41091
  • bathroomsfull: 5
  • bathroomshalf: 1
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 1
  • lotsizeunits: Acres
  • lotsizearea: 1
  • livingarea: 5200
  • livingareaunits: Square Feet
  • latitude: 38.915791
  • longitude: -84.637648
  • listagentfullname: Nicole Hayden
  • listagentemail: nikki@teamherr.com
  • listagentkey: 3yd-NKARKY-656026108
  • listagentmlsid: 656026108
  • listagentpreferredphone: 5132402127
  • listagentofficephone: 5137087770
  • listofficekey: 3yd-NKARKY-432501877
  • listagentstatelicense: 268094
  • listofficemlsid: 432501877
  • disclaimer: Copyright © 2026 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: 2026-04-03
  • countyorparish: Boone
  • parcelnumber: 064.35-07-011.00
  • elementaryschool: New Haven Elementary
  • highschool: Ryle High
  • elementaryschooldistrict: Boone Co Public
  • middleorjuniorschooldistrict: Boone Co Public
  • highschooldistrict: Boone Co Public
  • appliances: Stainless Steel Appliance(s), Gas Cooktop, Convection Oven, Dishwasher, Disposal, Dryer, Refrigerator, Washer
  • cooling: Central Air, Multi Units
  • heating: Natural Gas
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 3
  • parkingtotal: 10
  • parkingfeatures: Garage, Open, Driveway
  • roof: Shingle, Metal
  • waterfrontyn: False
  • franchiseaffiliation: None
  • interiorfeatures: Kitchen Island, Walk-In Closet(s), Track Lighting, Storage, Stone Counters, Sound System, Pantry, Open Floorplan, Granite Counters, Entrance Foyer, Eat-in Kitchen, Double Vanity, Crown Molding, Chandelier, Built-in Features, Beamed Ceilings, Butler's Pantry, Cathedral Ceiling(s), Ceiling Fan(s), High Ceilings, Multi Panel Doors, Recessed Lighting, Vaulted Ceiling(s), Master Downstairs
  • exteriorfeatures: Fire Pit
  • windowfeatures: Insulated Windows
  • rooms: Bedroom 4, Bathroom 1, Bathroom 2, Bathroom 5, Bathroom 6, Dining Room, Bedroom 1, Utility Room, Bathroom 3, Bedroom 5, Bathroom 4, Bedroom 3, Exercise Room, Laundry Room, Basement, Bedroom 2
  • securityfeatures: Security System
  • otherstructures: Storage
  • patioandporchfeatures: Patio
  • basement: Finished, Full
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • fencing: Fenced
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: False
  • internetconsumercommentyn: False
  • location: -84.63765, 38.91579
  • openhouse: { "AppointmentRequiredYN": false, "ListingKey": "3yd-NKARKY-641176", "OpenHouseEndTime": "2026-04-04 16:00:00", "OpenHouseId": "2871154", "OpenHouseRemarks": null, "OpenHouseStartTime": "2026-04-04 14:00:00", "OpenHouseType": null, "VirtualOpenHouseURL": null }
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Century 21 Brooks Wells Ent.", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"nikki@teamherr.com", "ListBrokerageCity":"Ashland", "ListBrokerageCountry":"US", "ListBrokerageEmail":null, "ListBrokerageLogoUrl":null, "ListBrokerageName":"Century 21 Brooks Wells Ent.", "ListBrokeragePhone":"(606) 329-8000", "ListBrokeragePostalCode":null, "ListBrokerageStateOrProvince":"KY", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"P.O. Box 628", "ListBrokerageWebsiteUrl":null, "ListOfficeAddress1":"312 S 4th St Ste 700 ", "ListOfficeAddress2":"", "ListOfficeBrokerMlsId":"432501877", "ListOfficeCity":"Louisville", "ListOfficeCountry":"USA", "ListOfficeEmail":null, "ListOfficePostalCode":"40202", "ListOfficeStateOrProvince":"KY", "ListPriceCurrencyType":"USD", "ListingTitle":"SINGLE_FAMILY - Union, KY", "ListingURL":null, "MLSModificationTimestamp":"2026-04-03 15:46:19", "Neighborhoods":[{"Description":null, "Name":"K11 - Richwd/Un/Wal/Ver/SB"}], "PostalCode":null, "RoomCount":12, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 4/3/2026 4:11:39 PM GMT
Source Updated Date: 4/4/2026 6:53:29 PM GMT

Courtesy of: Nicole Hayden, Private Real Estate Collection, nikki@teamherr.com

Copyright © 2026 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