For Sale62d on market
2175 Esplanade St
Union, KY, 41091 • 41091 • Boone County
$464,900
$206/sqft
Down payment assistance available
3Beds
3Baths
2,253Sqft
2026Built
Property DNA
Traditional Style
Traditional architecture
Retreat at Union Promenade
41091
Enhanced Security
Security System · Smoke Detector(s)
Outdoor Living
Covered · Deck · Patio · Porch
2-Car Garage
Attached · Garage · Garage Door Opener · Garage Faces Front
Premium Finishes
Walk-In Closet(s)
Market activity
Demand and pricing signals for this listing
30 views
People checking out this listing
62 days on market
Established listing
$206/sqft
Price per square foot
About this home
Townhouse · Built 2026
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.
Standout features identified
Our analysis highlights stainless steel appliances, large kitchen island, and finished lower level as key attractions of this home.
Estimated monthly payment
Based on current rates
$3,277/month
Principal & Interest$2,412
Property Tax$465
Insurance$155
HOA$245
Down payment20% ($92,980)
3%50%
Est. 6.75% rate · 30yr fixed · $371,920 loan
Full calculator →At a glance
Key facts and listing details
TypeTownhouse, Residential, Multi Family
Year Built2026
HeatingHot Water, Heat Pump
CoolingCentral Air
Parking2 Attached Garage spaces
HOA$245 monthly
Days on Zillow62 Days
Price/sqft$206
Property
Home typeTownhouse
Sub-typeTownhouse, Residential, Multi Family
StyleTraditional
Year built2026
Stories1
Systems
HeatingHot Water, Heat Pump
CoolingCentral Air
RoofShingle
ConstructionHardiPlank Type, Brick, Cedar, Stone, Vinyl Siding
Water / SewerPublic / Public Sewer
Parking & Outdoor
ParkingAttached, Garage, Garage Door Opener, Garage Faces Front
Garage2 spaces
BasementFull
Location & Tax
Neighborhood41091
Bathrooms & Fees
Full baths3
HOA$245/mo
Features & details
10 categories of property features
Interior Features
Interior
Kitchen Island
Walk-In Closet(s)
Storage
Stone Counters
Smart Thermostat
Pantry
Open Floorplan
Entrance Foyer
Double Vanity
High Ceilings
Recessed Lighting
Appliances
Stainless Steel Appliance(s)
Gas Range
Dishwasher
Disposal
Microwave
Heating
Hot Water
Heat Pump
Cooling
Central Air
Windows
Vinyl Frames
Exterior Features
Parking
Attached
Garage
Garage Door Opener
Garage Faces Front
Construction
HardiPlank Type
Brick
Cedar
Stone
Vinyl Siding
Patio & Porch
Covered
Deck
Patio
Porch
Security
Security System
Smoke Detector(s)
Utilities
Cable Available
Natural Gas Available
Sewer Available
Water Available
Room details
12 rooms detailed
Primary Bedroom
First14×13 ft182 sqft
Bedroom2
First11×10 ft110 sqft
Bedroom3
Lower14×12 ft168 sqft
Bathroom2
First8×6 ft48 sqft
Bathroom3
Lower9×5 ft45 sqft
Other
Lower24×13 ft312 sqft
Listing insights
Market data and value estimates
StatusFor Sale
Days on market62
Tax rate0.82%
Price/sqft$206
On marketFeb 5, 2026
PostedFeb 5, 2026
MLS updatedMar 25, 2026
Tour days6
Views30
How are the schools in Union?
3 schools rated nearby
Location
Union, KY, 41091
Price history
1 event
DateEventPrice$/sqftSource
Jan 31, 2026Listed For Sale$464,900$206Drees Homes
Listed For Sale$464,900
Jan 31, 2026•$206/sqft•Drees Homes
Nearby homes
Neighborhood details
Local context around this listing
Union, KY • Boone County
Nearby cities
BurlingtonFlorenceHebronPetersburgUnionVeronaWalton
Nearby zip codes
41091
Similar homes
The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of NKMLS. Real estate listings held by IDX Brokerage firms other than Zillow, Inc. are marked with the Internet Data Exchange logo or the Internet Data Exchange thumbnail logo and detailed information about them includes the name of the listing Brokers. Listing information is deemed reliable, but not guaranteed. Copyright 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.
No obligation · Same-day response