This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
$1,499,999 Just Listed
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
Full Property Details for 506 Affirmed Ave
General
- Price: $1,499,999
- HOA FEE: $40/month
- HOA FEE FREQ.: Annually
- Status: Active
- Type: Single Family
- Source: Northern_Kentucky
- MLS ID: 641176
- Updated: Today (4/3/2026)
- Added to Site: Today
Interior
- Number of Rooms: 12
- 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
- Fireplace: Yes
- Number of Fireplaces: 1
- Fireplace(s): Gas
- Appliances: Stainless Steel Appliance(s), Gas Cooktop, Convection Oven, Dishwasher, Disposal, Dryer, Refrigerator, Washer
Rooms
Bathrooms
- Total Bathrooms: 6
- Full Bathrooms: 5
- Half Bathrooms: 1
Bedrooms
- Total Bedrooms: 5
Other Rooms
- Laundry: Main Level
Additional Information
- Shared Amenities: Dog Park, Golf Course, Playground, Tennis Court(s), Clubhouse
- Security/Safety: Security System, Smoke Detector(s)
- Equipment: Home Theater, Sump Pump, Dehumidifier
Exterior
- Exterior Features: Fire Pit
- Porch/Patio/Deck: Patio
Parking
- Garage: Yes
- Attached garage: Yes
- Garage Spaces: 3
- Total Spaces: 10
- Parking Features: Attached, Driveway, Garage, Garage Door Opener, Garage Faces Side
Location
- County: Boone
- Driving Directions: 171/75 to west on Richwood Rd. Take the first traffic circle onto Triple Crown Blvd. to the first right onto Affirmed Ave.
School Information
- Elementary School: New Haven Elementary
- Middle School: Gray Middle School
- High School: Ryle High
Community
- Community Name: K11 - Richwd/Un/Wal/Ver/SB
- Association: Yes
- Assoc. Fees Include: Association Fees, Management
Heating & Cooling
- Central air: Yes
- Air Conditioning: Yes
- Cooling Type: See Remarks, Multi Units, Central Air Conditioning
- Heating Type: Natural Gas
Utilities
- Sewer: Public Sewer
- Water: Public
- Utility Description: Underground Utilities
Structural Information
- Architectural Style: Other
- Construction: Other
- Basement Desc.: Full Finished Bath, Finished
- Roof: Metal, Shingle
- Windows: Insulated Windows
- Year Built: 2025
- Property Condition: New Construction
Lot Features
- Lot Size (Acres): 1
- Lot Size (Sq. Ft.): 43,804
- Lot Size: 1
- Lot Size Source: Builder
- Lot Dimensions: 1.1
- Lot Features: Cul-De-Sac, Sprinklers In Front, Sprinklers In Rear
- Zoning: Residential
- Fencing (Description): Fenced
Financial Considerations
- Association Fee: $475
- Assoc Fee Freq.: Annually
Disclosures and Reports
- Property ID: 064.35-07-011.00
Listed by Private Real Estate Collection, Nicole Hayden and Private Real Estate Collection, Heather Herr
Schools serving 506 Affirmed Ave
| Name | Grades | Distance |
|---|---|---|
New Haven Elementary School 10854 U.S. 42, Union, KY 41091 | K-5 | 2.3 mi |
Gray Middle School 10400 U.S. 42, Union, KY 41091 | 6-8 | 2.4 mi |
Larry A. Ryle High School 10379 U.S. 42, Union, KY 41091 | 9-12 | 2.4 mi |
Price & Sales History for 506 Affirmed Ave
Tax History for 506 Affirmed Ave
Estimate the Cost for 506 Affirmed Ave
506 Affirmed Avenue, Union, KY 41091 (MLS# 641176) is a Single Family property with 5 bedrooms, 5 full bathrooms and 1 partial bathroom. 506 Affirmed Avenue is currently listed for $1,499,999 and was received on April 03, 2026. Want to learn more about 506 Affirmed Avenue? Do you have questions about finding other Single Family real estate for sale in Union? You can browse all Union real estate or contact a Coldwell Banker agent to request more information.

