BEDS5
BATHS5 full 1 partial
MLS#641176
STATUS
PROPERTY TYPEResidential - Single Family
SCHOOLBoone Co Public
Property 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 of outdoor turf living and in Unions premier golf community just steps from the new Publix and Triple Crowns top tier amenities.
Property Features
Property Type: Residential - Single Family
Basement: Full Finished Bath, Finished
Basement: Yes
Cooling: See Remarks, Multi Units, Central Air
Fenced: Yes
Fireplaces: 1
Garage: 3 car attached
Heating: Natural Gas
Home Style: Other
Lot Size: 1.00 Acres
Roof Type: Metal, Shingle
Stories: 3.0
Year Built: 2025
Feature Descriptions
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
Days on Site: 2
Equipment: Home Theater, Sump Pump, Dehumidifier
Exterior: Fire Pit
Exterior: Other
Fencing: Fenced
Fireplace: Gas
Fireplace Y/N: Yes
Foundation: Poured Concrete
HOA: Yes
HOA Fee: 475/Annually
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: Cul-De-Sac, Sprinklers In Front, Sprinklers In Rear
Lot Dimensions: 1.1
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
Rooms Total: 12
Security: yes
Security: Security System, Smoke Detector(s)
Sewer: Public Sewer
Structure Type: House
Sub Type: Single Family Residence
Utilities: Underground Utilities
Water: Public
Window: Insulated Windows
Room Sizes
Great Room: 21 X 21 Level - First
Kitchen: 12 X 23 Level - First
Dining Room: 12 X 12 Level - First
Primary Bedroom: 15 X 18 Level - First
Utility Room: 14 X 7 Level - First
Bedroom 2: 12 X 11 Level - First
Bedroom 3: 13 X 12 Level - First
Bedroom 4: 12 X 12 Level - First
Gym: 13 X 17 Level - First
Other Room: 23 X 20 Level - Lower
Other Room: 18 X 29 Level - Second
Other Room: 12 X 10 Level - First
Local Schools
High School: Ryle High
Middle School: Gray Middle School
Elementary School: New Haven Elementary
School District: Boone Co Public
Listed By / Shown By
Listed By
Agency Name: Private Real Estate Collection
Agency Phone: 513-708-7770
Shown By
Agent Name: Malia K. Hughes, Realtor ® - The Malia Group
Agent Phone: Cell: (937) 935-8008
Agency Title: Key Realty
Estimate Your Payment
Estimated Payment
$ 8,828.07 per month $8,390.57 Principal & Interest $0.00 Property Tax (data not provided by mls) $437.50 Homeowner's InsuranceChange Payment Information
Privacy Policy / DMCA Notice / ADA Accessibility
This site is hosted, designed and copyright
© 1994 - 2026 by
Delta Media Group, Inc. -- Patent Pending --
Agency License Information: 1-877-539-7589 | Ohio Lic# REC.2010002888 6800 W Central Ave #B, Toledo, OH 43617 | Michigan Lic# 6505366134 8040 Summerfield Rd, Lambertville, MI 48144 | Indiana Lic# RC52400106 3029 W Smith Valley Rd #211, Greenwood, IN 46142 | West Virginia LIC# 010306 Erin Rickman, Broker. 410 Market St #3, Parkersburg, WV, 26101 | Colorado LIC# EC.100108419 603 Rood Ave, Grand Junction, CO 81501 | Nevada LIC# B.0146350.LLC 9190 Double Diamond Pwky, Reno, NV 89521 | Florida LIC# CQ1073507 16638 Mooner Plank Cir, Wimauma, FL 33598
Agent License Information: SALM.2008001822
506 Affirmed Avenue | MLS# 641176
This single family home located at 506 Affirmed Avenue, Union, KY 41091 is currently listed for sale with an asking price of $1,499,999. This property was built in 2025 and has 5 bedrooms and 5 full and 1 partial baths. Affirmed Avenue is located within the Boone Co Public school district. Search Union real estate on www.maliahughesrealtor.com today.