506 Affirmed Avenue Union, KY 41091

PRICED AT $1,399,900

Listing Details

  • $1,399,900
  • MLS# 641176
  • Type Residential - Single Family
  • Status
  • 5 Bedrooms
  • 5 full 1 partial Bathrooms
  • 1.000 acres Lot Size
  • 2025 Year Built
  • Boone Co Public Local Schools

Description

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...read more

Features

  • Stainless Steel Appliance(s)
  • Gas Cooktop
  • Convection Oven
  • Dishwasher
  • Disposal
  • Dryer
  • Refrigerator
  • Washer
  • See Remarks, Multi Units, Central Air
  • 1 Fireplace
  • Natural Gas
  • 3.0 Stories
  • Public
  • Built in 2025
View All Features

Gallery

View Slideshow

Contact the Listing Agent

Contact the Listing Agent
Real estate agents ready to serve you | Browse homes and real estate for sale
Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 05/29/2026. The listing information on this page last changed on 05/29/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Fri 05/29/2026 12:52:25 PM EST) or Dayton MLS (last updated Fri 05/29/2026 12:47:45 PM EST) or Multiple Listing Service of Greater Cincinnati (last updated Fri 05/29/2026 12:48:44 PM EST) or NKY MLS (last updated Fri 05/29/2026 12:51:56 PM EST). Real estate listings held by brokerage firms other than Comey & Shepherd may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.
Privacy Policy / DMCA Notice / ADA Accessibility
Federal Housing Equal Opportunity Realtor
This site is hosted, designed and copyright © 1994 - 2026 by Delta Media Group, Inc. -- Patent Pending --
  

Property Image 1
Property Image 2
Property Image 3
Property Image 4
Property Image 5
Property Image 6
Property Image 7
Property Image 8
Property Image 9
Property Image 10
Property Image 11
Property Image 12
Property Image 13
Property Image 14
Property Image 15
Property Image 16
Property Image 17
Property Image 18
Property Image 19
Property Image 20
Property Image 21
Property Image 22
Property Image 23
Property Image 24
Property Image 25
Property Image 26
Property Image 27
Property Image 28
Property Image 29
Property Image 30
Property Image 31
Property Image 32
Property Image 33
Property Image 34
Property Image 35
Property Image 36
Property Image 37
Property Image 38
Property Image 39
Property Image 40
Property Image 41
Property Image 42
Property Image 43
Property Image 44
Property Image 45
Property Image 46

All Property Features

  • Property Type: Residential - Single Family
  • Appliances: Stainless Steel Appliance(s), Gas Cooktop, Convection Oven, Dishwasher, Disposal, Dryer, Refrigerator, Washer
  • Association Amenities: Dog Park, Golf Course, Playground, Tennis Court(s), Clubhouse
  • Association Fee Includes: Association Fees, Management
  • Basement: Full Finished Bath, Finished
  • Basement: Yes
  • Cooling: See Remarks, Multi Units, Central Air
  • Days on Site: 56
  • Equipment: Home Theater, Sump Pump, Dehumidifier
  • Exterior: Fire Pit
  • Exterior: Other
  • Fenced: Yes
  • Fencing: Fenced
  • Fireplace: Gas
  • Fireplaces: 1
  • Fireplace Y/N: Yes
  • Foundation: Poured Concrete
  • Garage: 3 car attached
  • Heating: Natural Gas
  • HOA: Yes
  • HOA Fee: 475/Annually
  • Home Style: Other
  • Interior: 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, Butlers Pantry, Cathedral Ceiling(s), Ceiling Fan(s), High Ceilings, Multi Panel Doors, Recessed Lighting, Vaulted Ceiling(s), Master Downstairs
  • Laundry: Main Level
  • Lot Description: Cul-De-Sac, Sprinklers In Front, Sprinklers In Rear
  • Lot Dimensions: 1.1
  • Lot Size: 1.00 Acres
  • Parcel Number: 064.35-07-011.00
  • Parking: Attached, Driveway, Garage, Garage Door Opener, Garage Faces Side
  • Parking Total: 10
  • Patio/Porch: Patio
  • Property Condition: New Construction
  • Road Surface: Paved
  • Roof Type: Metal, Shingle
  • Rooms Total: 12
  • Security: yes
  • Security: Security System, Smoke Detector(s)
  • Sewer: Public Sewer
  • Stories: 3.0
  • Structure Type: House
  • Sub Type: Single Family Residence
  • Utilities: Underground Utilities
  • Water: Public
  • Window: Insulated Windows
  • Year Built: 2025