NEW 2025 Home Show Showcase Home! Designed around the power of five: 5 oversized garage spaces, 5 spacious bedrooms, 5 full baths (plus a half). Set on more than an acre with show-stopping views of Triple Crown golf course hole #4 and the lake. Enjoy a covered deck with outdoor fireplace, perfect for year-round living. Inside, discover soaring ceilings, Bosch appliances, a spa-inspired primary suite, a grilling deck, and a huge walk-through pantry. The lower level is built for entertaining with a stunning bar area and ample space for gatherings. Located just steps from the new Publix and Triple Crown's premier amenities. This home blends luxury, lifestyle, and location in one exceptional package.
New construction
$2,675,000
521 Affirmed Ave, Union, KY 41091
5beds
--sqft
Est.:
Single Family Residence, Residential
Built in 2025
-- sqft lot
$-- Zestimate®
$--/sqft
$40/mo HOA
What's special
Stunning bar areaHuge walk-through pantryBosch appliancesOversized garage spacesGrilling deckSoaring ceilingsAcre with show-stopping views
- 51 days |
- 643 |
- 23 |
Zillow last checked: 8 hours ago
Listing updated: October 27, 2025 at 11:25am
Listed by:
Donna Berling 859-240-6544,
Huff Realty - Florence
Source: NKMLS,MLS#: 637524
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 6
- Full bathrooms: 5
- 1/2 bathrooms: 1
Primary bedroom
- Level: First
- Area: 425
- Dimensions: 17 x 25
Bedroom 2
- Level: First
- Area: 180
- Dimensions: 12 x 15
Bedroom 3
- Level: First
- Area: 252
- Dimensions: 18 x 14
Bedroom 4
- Level: Lower
- Area: 240
- Dimensions: 15 x 16
Bedroom 5
- Level: Lower
- Area: 306
- Dimensions: 17 x 18
Bathroom 2
- Level: First
- Area: 55
- Dimensions: 11 x 5
Bathroom 3
- Level: First
- Area: 108
- Dimensions: 12 x 9
Bathroom 4
- Level: First
- Area: 42
- Dimensions: 7 x 6
Bathroom 4
- Level: Lower
- Area: 72
- Dimensions: 6 x 12
Bathroom 5
- Level: Lower
- Area: 84
- Dimensions: 12 x 7
Other
- Level: Lower
- Area: 726
- Dimensions: 22 x 33
Dining room
- Level: First
- Area: 272
- Dimensions: 17 x 16
Dining room
- Level: Lower
- Area: 272
- Dimensions: 17 x 16
Entry
- Level: First
- Area: 361
- Dimensions: 19 x 19
Kitchen
- Level: First
- Area: 255
- Dimensions: 17 x 15
Laundry
- Level: First
- Area: 117
- Dimensions: 13 x 9
Living room
- Level: First
- Area: 361
- Dimensions: 19 x 19
Office
- Level: First
- Area: 132
- Dimensions: 12 x 11
Other
- Level: First
- Area: 120
- Dimensions: 8 x 15
Other
- Description: Wet Bar
- Features: See Remarks
- Level: Lower
- Area: 357
- Dimensions: 17 x 21
Primary bath
- Level: First
- Area: 209
- Dimensions: 19 x 11
Heating
- Has Heating (Unspecified Type)
Cooling
- Central Air
Appliances
- Included: Stainless Steel Appliance(s), Convection Oven, Dishwasher, Disposal, Refrigerator
- Laundry: Main Level
Features
- Kitchen Island, Walk-In Closet(s), Storage, Stone Counters, Pantry, Open Floorplan, Entrance Foyer, Eat-in Kitchen, Double Vanity, Crown Molding, Beamed Ceilings, Butler's Pantry, High Ceilings, Recessed Lighting, Vaulted Ceiling(s), Wet Bar, Master Downstairs
- Doors: Pocket Door(s), Multi Panel Doors
- Has basement: Yes
- Number of fireplaces: 2
- Fireplace features: Gas
Property
Parking
- Total spaces: 5
- Parking features: Attached, Garage, Garage Faces Side
- Attached garage spaces: 5
Features
- Levels: One
- Stories: 1
- Patio & porch: Covered, Deck
- Exterior features: Private Yard, Balcony, Lighting
- Has view: Yes
- View description: Golf Course
- Waterfront features: Waterfront
Lot
- Features: On Golf Course
Details
- Zoning description: Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Transitional
- Property subtype: Single Family Residence, Residential
Materials
- Brick
- Foundation: Poured Concrete
- Roof: Shingle
Condition
- New Construction
- New construction: Yes
- Year built: 2025
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Underground Utilities
Community & HOA
HOA
- Has HOA: Yes
- Amenities included: Dog Park, Playground, Tennis Court(s), Clubhouse
- Services included: Association Fees, Management
- HOA fee: $475 annually
Location
- Region: Union
Financial & listing details
- Date on market: 10/27/2025
- Cumulative days on market: 52 days
- Road surface type: Paved
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 10/27/2025 | Listed for sale | $2,675,000 |
Source:  NKMLS #637524 Report a problem | ||
Public tax history
Public tax history
Tax history is unavailable.BuyAbility℠ payment
Est. payment
$13,199/mo
Principal & interest
$10373
Property taxes
$1850
Other costs
$976
Climate risks
Neighborhood: 41091
Nearby schools
GreatSchools rating
- 8/10New Haven Elementary SchoolGrades: PK-5Distance: 2.2 mi
- 8/10Gray Middle SchoolGrades: 6-8Distance: 2.4 mi
- 9/10Larry A. Ryle High SchoolGrades: 9-12Distance: 2.4 mi
Schools provided by the listing agent
- Elementary: New Haven Elementary
- Middle: Gray Middle School
- High: Ryle High
Source: NKMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- Loading
- Loading
