Property photo 1
Property photo 2
Property photo 3
Property photo 4
Property photo 5
3 Beds
3 Baths
2,253 sqft

$459,900

2175 Esplanade Street, Union KY, 41091

Price per sqft$204.13
Built in2026
Property size2,253 sqft
Property typeTownhomes

Overview

Active

Listed Feb 5, 2026

Updated 9 days ago

Live in the highly anticipated Union Promenade! The Drees Medford is a stunning ranch-style townhome designed for modern living. With a finished lower level and a 2-car attached garage, this home features 3 spacious bedrooms and 3 full baths. The open concept design boasts 9' ceilings, quartz countertops, a large kitchen island, and a walk-in pantry--perfect for culinary creativity. Enjoy luxury vinyl plank flooring, stainless steel appliances, and a gas range. The primary suite is your private retreat, with double vanities and a walk-in closet that dreams are made of. Plus, you're just a short walk from a variety of shops and restaurants, all within the Boone County school district.

$3,060/mo

Est. mortgage payment based on a $459,900 home price.

All estimates are provided by Luxury Presence for informational purposes only. Actual amounts may vary.

Additional information

MLS® ID
639679

Interior Features

Bedrooms
3
Bathrooms
3
Cooling
Yes
Heating
Yes
Basement
Yes

Other Property Details

Association Fee Frequency
Monthly
Garage
Yes
New Construction
Yes

Courtesy of Drees/Zaring Realty, John Heisler,
Listing Contact: 859-468-9032 

All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) nor Dwell Well Group shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless.

©2026 Northern Kentucky Association of REALTORS. All rights reserved.

Powered by Luxury Presence