Listing provided courtesy of Side Realty LLC- MLS# 641176 Sold by Keller Williams Realty Service
Images
Request Info- 2_dsc09884
506 Affirmed AvenueUnion, KY 41091
Single Family · 5 Beds · 5 Full Baths · 1 Half Bath · 5,200 Sq. ft. | 1.00 Acres$1,200,000
Sold
Sold on 6/10/2026
506 Affirmed Avenue Overview
- Visits:
- 70
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.
Love this property?
Create a profile to receive updates on this property when it's back on the market!
View Map
506 Affirmed Avenue Facts & Features
- Type Single Family
- Sq. ft. 5,200
- Price/Sq.ft. $231
- Lot 1.00 Acres
Details
General
Association/HOA
- Association Fee: 475.0
- Association Fee Frequency: Annually
- Association Fee Includes: Association Fees, Management
- Association: Yes
School Information
- Elementary School: New Haven Elementary
- Middle Or Junior School: Gray Middle School
- High School: Ryle High
Green Features
- Green Energy Efficient: Appliances, Water Heater, Windows
Building Information
- New Construction: No
- Security Features: Security System: true
- Security Features: Smoke Detector: true
- Sewer: Public Sewer: true
- Year Built: 2025
Location/Region
- County Or Parish: Boone
- MLS Area Major: K11 - Richwd/Un/Wal/Ver/SB
- MLS Area Minor: K11 - Richwd/Un/Wal/Ver/SB
Parking Information
- Parking Features: Attached: true
- Parking Features: Garage Door Opener: true
- Parking Features: Garage Faces Side: true
General Information
- Parcel Number: 064.35-07-011.00
- Property Condition: New Construction
- Property Sub Type: Single Family Residence
- Property Type: Residential
Interior
Building Information
- Cooling: Central Air: true
- Cooling: Multi Units: true
Parking Information
- Garage Spaces: 3.0
- Garage: Yes
Beds/Baths
- Bathrooms Full: 5
- Bathrooms Half: 1
- Bathrooms Total: 6
- Bedrooms Total: 5
Building Interior
- Building Area Total: 5200.0
- FloorPlansChangeTimestamp: 2026-04-03T14:34:29Z
- Interior Features: Beamed Ceilings: true
- Interior Features: Ceiling Fan: true
- Interior Features: Crown Molding: true
- Interior Features: Granite Counters: true
- Interior Features: High Ceilings: true
- Interior Features: Open Floorplan: true
- Interior Features: Recessed Lighting: true
- Interior Features: Stone Counters: true
- Interior Features: Track Lighting: true
- Interior Features: Vaulted Ceiling: true
- Laundry Features: Main Level: true
General Information
- Appliances: Stainless Steel Appliance(s), Gas Cooktop, Convection Oven, Dishwasher, Disposal, Dryer, Refrigerator, Washer
- Electric: 200+ Amp Service, Generator
- Fireplace Features: Gas
- Fireplace: Yes
- Fireplaces Total: 1
- Foundation Details: Poured Concrete
- Interior Features: 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
- Laundry Features: Main Level
- Living Area Units: Square Feet
- Rooms Total: 12
- Security Features: Security System, Smoke Detector(s)
Exterior
Parking Information
- Parking Features: Attached, Driveway, Garage, Garage Door Opener, Garage Faces Side
Lot Information
- Lot Features: Cul-De-Sac, Sprinklers In Front, Sprinklers In Rear
- Lot Size Acres: 1.0
- Lot Size Area: 1.0
- Lot Size Dimensions: 1.1
- Lot Size Source: Builder
- Lot Size Square Feet: 43804.0
- Lot Size Units: Acres
- Road Surface Type: Paved
- Water Source: Public
Building Exterior/Construction
- Attached Garage: Yes
- Construction Materials: Other
- Patio And Porch Features: Patio
- Property Attached: No
- Roof: Metal, Shingle
General Information
- Exterior Features: Fire Pit
- Fencing: Fenced
- Sewer: Public Sewer
- Utilities: Underground Utilities
506 Affirmed Avenue Neighborhood
Community
41091 (UNION) Demographics
38
Median Age
411
Population Density (per sq. mile)
56%
College Educated
$120,826
Estimated Median Income
6,226
Estimated Total Home Owners
451
Estimated Total Renters
93% / 7%
Estimated Owner / Renter Divide
3
Estimated Average Household Size
Schools
School data courtesy of LiveBy, Inc. School ratings are based on a scale of 1-5, with 5 being the highest rating and 1 being the lowest rating.506 Affirmed Avenue Market Data
Based on the last 30 days in this zip code
$584,928
Average List Price
$299
Average Price per Square Foot
52
Properties Sold
66
Average Days on Market
222
Properties for Sale
506 Affirmed Avenue History
| Date | Value | Agent |
|---|---|---|
| 6/12/2026Source: Northern Kentucky MLS | Sold |
|
| 5/13/2026Source: Northern Kentucky MLS | Pending |
|
| 4/29/2026Source: Northern Kentucky MLS | $1,399,900 -5.1% |
|
| 4/24/2026Source: Northern Kentucky MLS | $1,474,999 -1.7% |
|
| 4/3/2026Source: Northern Kentucky MLS | April 03, 2026 |