This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
$429,900
Get directions
View more dates
Join us at 2224 Esplanade Street on:
- Open House: 1:00 PM - 4:00 PM
Saturday 4/18 1:00 PM - 4:00 PM
2224 Esplanade Street,Union, KY 410912224 Esplanade StreetUnionKY41091 - Open House: 1:00 PM - 4:00 PM
Sunday 4/19 1:00 PM - 4:00 PM
2224 Esplanade Street,Union, KY 410912224 Esplanade StreetUnionKY41091 - Open House: 1:00 PM - 4:00 PM
Saturday 4/25 1:00 PM - 4:00 PM
2224 Esplanade Street,Union, KY 410912224 Esplanade StreetUnionKY41091 - Open House: 1:00 PM - 4:00 PM
Sunday 4/26 1:00 PM - 4:00 PM
2224 Esplanade Street,Union, KY 410912224 Esplanade StreetUnionKY41091 - Open House: 1:00 PM - 4:00 PM
Saturday 5/2 1:00 PM - 4:00 PM
2224 Esplanade Street,Union, KY 410912224 Esplanade StreetUnionKY41091 - Open House: 1:00 PM - 4:00 PM
Sunday 5/3 1:00 PM - 4:00 PM
2224 Esplanade Street,Union, KY 410912224 Esplanade StreetUnionKY41091 - Open House: 1:00 PM - 4:00 PM
Saturday 5/9 1:00 PM - 4:00 PM
2224 Esplanade Street,Union, KY 410912224 Esplanade StreetUnionKY41091 - Open House: 1:00 PM - 4:00 PM
Sunday 5/10 1:00 PM - 4:00 PM
2224 Esplanade Street,Union, KY 410912224 Esplanade StreetUnionKY41091 - Open House: 1:00 PM - 4:00 PM
Saturday 5/16 1:00 PM - 4:00 PM
2224 Esplanade Street,Union, KY 410912224 Esplanade StreetUnionKY41091 - Open House: 1:00 PM - 4:00 PM
Sunday 5/17 1:00 PM - 4:00 PM
2224 Esplanade Street,Union, KY 410912224 Esplanade StreetUnionKY41091 - Open House: 1:00 PM - 4:00 PM
Saturday 5/23 1:00 PM - 4:00 PM
2224 Esplanade Street,Union, KY 410912224 Esplanade StreetUnionKY41091 - Open House: 1:00 PM - 4:00 PM
Sunday 5/24 1:00 PM - 4:00 PM
2224 Esplanade Street,Union, KY 410912224 Esplanade StreetUnionKY41091 - Open House: 1:00 PM - 4:00 PM
Saturday 5/30 1:00 PM - 4:00 PM
2224 Esplanade Street,Union, KY 410912224 Esplanade StreetUnionKY41091 - Open House: 1:00 PM - 4:00 PM
Sunday 5/31 1:00 PM - 4:00 PM
2224 Esplanade Street,Union, KY 410912224 Esplanade StreetUnionKY41091 - Open House: 1:00 PM - 4:00 PM
Saturday 6/6 1:00 PM - 4:00 PM
2224 Esplanade Street,Union, KY 410912224 Esplanade StreetUnionKY41091 - Open House: 1:00 PM - 4:00 PM
Sunday 6/7 1:00 PM - 4:00 PM
2224 Esplanade Street,Union, KY 410912224 Esplanade StreetUnionKY41091 - Open House: 1:00 PM - 4:00 PM
Saturday 6/13 1:00 PM - 4:00 PM
2224 Esplanade Street,Union, KY 410912224 Esplanade StreetUnionKY41091 - Open House: 1:00 PM - 4:00 PM
Sunday 6/14 1:00 PM - 4:00 PM
2224 Esplanade Street,Union, KY 410912224 Esplanade StreetUnionKY41091 - Open House: 1:00 PM - 4:00 PM
Saturday 6/20 1:00 PM - 4:00 PM
2224 Esplanade Street,Union, KY 410912224 Esplanade StreetUnionKY41091 - Open House: 1:00 PM - 4:00 PM
Sunday 6/21 1:00 PM - 4:00 PM
2224 Esplanade Street,Union, KY 410912224 Esplanade StreetUnionKY41091 - Open House: 1:00 PM - 4:00 PM
Saturday 6/27 1:00 PM - 4:00 PM
2224 Esplanade Street,Union, KY 410912224 Esplanade StreetUnionKY41091 - Open House: 1:00 PM - 4:00 PM
Sunday 6/28 1:00 PM - 4:00 PM
2224 Esplanade Street,Union, KY 410912224 Esplanade StreetUnionKY41091
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
Full Property Details for 2224 Esplanade St
General
- Price: $429,900
- HOA FEE: $275/month
- Status: Active
- Type: Townhouse
- Source: Northern_Kentucky
- MLS ID: 634856
- Updated: 3/27/2026
- Added to Site: 254 day(s) ago
Interior
- Number of Rooms: 8
- Interior 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
- Appliances: Stainless Steel Appliance(s), Gas Range, Dishwasher, Disposal, Microwave
Rooms
Bathrooms
- Total Bathrooms: 3
- Full Bathrooms: 3
Bedrooms
- Total Bedrooms: 3
Additional Information
- Shared Amenities: Landscaping
- Security/Safety: Security System, Smoke Detector(s)
Exterior
- Exterior Features: Lighting
- Porch/Patio/Deck: Covered, Deck, Patio, Porch
Parking
- Garage: Yes
- Attached garage: Yes
- Garage Spaces: 2
- Total Spaces: 2
- Parking Features: Attached, Driveway, Garage, Garage Door Opener, Garage Faces Front
Location
- County: Boone
- Subdivision: Retreat at Union Promenade
- Driving Directions: I-71/75 to south on Rt. 42 (Florence exit), to right on Children's Way, to right on Venice Street, to right on Esplanade Street.
School Information
- Elementary School: Erpenbeck Elementary
- Middle School: Ockerman Middle School
- High School: Ryle High
Community
- Community Name: K11 - Richwd/Un/Wal/Ver/SB
- Association: Yes
- Assoc. Fees Include: Maintenance Grounds, Maintenance Structure, Snow Removal, Insurance
Heating & Cooling
- Central air: Yes
- Air Conditioning: Yes
- Cooling Type: Central Air Conditioning
- Heating Type: Natural Gas, Hot Water, Heat Pump
Utilities
- Sewer: Public Sewer
- Water: Public
- Cable Available: Yes
- Utility Description: Cable Available, Natural Gas Available, Sewer Available, Water Available
Structural Information
- Architectural Style: Traditional
- Construction: HardiPlank Type, Brick, Cedar, Stone, Vinyl Siding
- Basement Desc.: Full Finished Bath, Finished, Storage Space, Walk-Out Access
- Roof: Shingle
- Windows: Vinyl Frames
- Year Built: 2025
Lot Features
- Lot Size Source: Builder
- Lot Dimensions: Irregular
- Zoning: Residential
Financial Considerations
- Association Fee: $275
- Assoc Fee Freq.: Monthly
Listed by Drees/Zaring Realty, John Heisler
Schools serving 2224 Esplanade St
| Name | Grades | Distance |
|---|---|---|
Erpenbeck Elementary School US 42 9001 Wetherington Blvd, Florence, KY 41042 | K-5 | 1 mi |
Ockerman Middle School 8300 U.S. 42, Florence, KY 41042 | 6-8 | 2.2 mi |
Larry A. Ryle High School 10379 U.S. 42, Union, KY 41091 | 9-12 | 1.6 mi |
Price & Sales History for 2224 Esplanade St
Estimate the Cost for 2224 Esplanade St
Home Warranty : Included
2224 Esplanade Street, Union, KY 41091 (MLS# 634856) is a Townhouse property with 3 bedrooms and 3 full bathrooms. 2224 Esplanade Street is currently listed for $429,900 and was received on July 31, 2025. Want to learn more about 2224 Esplanade Street? Do you have questions about finding other Townhouse real estate for sale in Union? You can browse all Union real estate or contact a Coldwell Banker agent to request more information.

