2175 Esplanade Street

Union, KY 41091

$464,900

3 bd · 3 ba · 2,253 sqft

Type
townhouse
Year built
2026
Garage
2
HOA
$245/monthly

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.

Listed by John Heisler, Drees/Zaring Realty

Listing courtesy of Drees/Zaring Realty, John Heisler

MLS data last updated Sep 8, 2026, 10:31 PM EDT

All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of NKY MLS. Real estate listings held by brokerage firms other than The Art Realty Team may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity™ program of the Multiple Listing Service of Greater Cincinnati. Real estate listings held by brokerage firms other than The Art Realty Team are marked with the MLS™ logo and detailed information about them includes the name of the listing brokers. The information herein is furnished by the property owner in good faith but is subject to verification by the purchaser. Neither the MLS, the Broker, the Agent nor MFM guarantee or warranty the correctness therein. All information is dated and is subject to change at any time. Copyright MLS of Greater Cincinnati, Inc. All rights reserved.

Call (859) 462-2096Get home value