2224 Esplanade St, Union, KY 41091
What's special
- 133 days |
- 38 |
- 2 |
Zillow last checked: 8 hours ago
Listing updated: October 27, 2025 at 07:08am
John Heisler 859-468-9032,
Drees/Zaring Realty
Travel times
Schedule tour
Select your preferred tour type — either in-person or real-time video tour — then discuss available options with the builder representative you're connected with.
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 3
Primary bedroom
- Description: 9' ceiling; carpet; w/i closet; bath adjoining
- Level: First
- Area: 182
- Dimensions: 14 x 13
Other
- Description: 9' ceiling; carpet; wet bar; walkout to patio
- Level: Lower
- Area: 360
- Dimensions: 24 x 15
Dining room
- Description: 9' ceiling; LVP flooring
- Level: First
- Area: 144
- Dimensions: 16 x 9
Entry
- Description: 9' ceiling; LVP flooring; b/i bench
- Level: First
- Area: 28
- Dimensions: 7 x 4
Family room
- Description: 9' ceiling; LVP flooring
- Level: First
- Area: 224
- Dimensions: 16 x 14
Kitchen
- Description: 9' ceiling; large island; LVP flooring; quartz countertops; walk-in pantry; SS appliances
- Level: First
- Area: 176
- Dimensions: 16 x 11
Laundry
- Description: LVP flooring
- Level: First
- Area: 55
- Dimensions: 11 x 5
Primary bath
- Description: 9' ceiling; double bowl vanity; quartz countertops; tall vanity; comfort height commode; w/i shower w/tile surround
- Level: First
- Area: 108
- Dimensions: 12 x 9
Heating
- Hot Water, Heat Pump
Cooling
- Central Air
Appliances
- Included: Stainless Steel Appliance(s), Gas Range, Dishwasher, Disposal, Microwave
Features
- Kitchen Island, Wet Bar, Walk-In Closet(s), Storage, Stone Counters, Smart Thermostat, Pantry, Open Floorplan, Entrance Foyer, Double Vanity, High Ceilings, Recessed Lighting, Wired for Data
- Windows: Vinyl Frames
- Has basement: Yes
Interior area
- Total structure area: 2,124
- Total interior livable area: 2,124 sqft
Property
Parking
- Total spaces: 2
- Parking features: Attached, Driveway, Garage, Garage Door Opener, Garage Faces Front
- Attached garage spaces: 2
- Has uncovered spaces: Yes
Features
- Levels: One
- Stories: 1
- Patio & porch: Covered, Deck, Patio, Porch
- Exterior features: Lighting
Details
- Zoning description: Residential
Construction
Type & style
- Home type: Townhouse
- Architectural style: Traditional
- Property subtype: Townhouse, Residential, Multi Family
- Attached to another structure: Yes
Materials
- HardiPlank Type, Brick, Cedar, Stone, Vinyl Siding
- Foundation: Poured Concrete
- Roof: Shingle
Condition
- New construction: Yes
- Year built: 2025
Details
- Builder name: Drees Homes
- Warranty included: Yes
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Available, Natural Gas Available, Sewer Available, Water Available
Community & HOA
Community
- Security: Security System, Smoke Detector(s)
- Subdivision: Retreat at Union Promenade
HOA
- Has HOA: Yes
- Amenities included: Landscaping
- Services included: Maintenance Grounds, Maintenance Structure, Snow Removal
- HOA fee: $275 monthly
Location
- Region: Union
Financial & listing details
- Price per square foot: $212/sqft
- Date on market: 7/31/2025
- Cumulative days on market: 134 days
About the community
Source: Drees Homes
6 homes in this community
Available homes
| Listing | Price | Bed / bath | Status |
|---|---|---|---|
Current home: 2224 Esplanade St | $449,900 | 3 bed / 3 bath | Available |
| 9518 La Croisette St | $432,900 | 3 bed / 3 bath | Available |
| 9522 La Croisette St | $439,900 | 3 bed / 3 bath | Available |
| 2220 Esplanade St | $459,900 | 3 bed / 3 bath | Available |
| 9644 Venice St | $422,500 | 3 bed / 3 bath | Pending |
| 9505 La Croisette St | $449,900 | 3 bed / 3 bath | Pending |
Source: Drees Homes
Contact builder

By pressing Contact builder, you agree that Zillow Group and other real estate professionals may call/text you about your inquiry, which may involve use of automated means and prerecorded/artificial voices and applies even if you are registered on a national or state Do Not Call list. You don't need to consent as a condition of buying any property, goods, or services. Message/data rates may apply. You also agree to our Terms of Use.
Learn how to advertise your homesEstimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 7/27/2025 | Listed for sale | $449,900$212/sqft |
Source: | ||
Public tax history
Monthly payment
Neighborhood: 41091
Nearby schools
GreatSchools rating
- 8/10Erpenbeck Elementary SchoolGrades: PK-5Distance: 1 mi
- 5/10Ockerman Middle SchoolGrades: 6-8Distance: 2.2 mi
- 9/10Larry A. Ryle High SchoolGrades: 9-12Distance: 1.6 mi
Schools provided by the builder
- Elementary: Erpenbeck Elementary
- Middle: Ockerman Middle School
- High: Ryle High School
- District: Boone County
Source: Drees Homes. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.






