- Overview
- Description
- Property Details
- Location
- HOA Management
- Facts & Features
- Getting Around
- Nearby Homes
New Construction
Street View
$459,900
Monthly Est:$2,289
3 Beds
3 Baths3 full baths
2,253sqft
2175 Esplanade St, Union, KY 41091
$459,900
$2,289/moEst:
Get Pre-Approved
Townhouse
Built in 2026
$245/mo HOA
-- sqft lot
$204/sq.ft
Description
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.
- Houzeo last checked: 7 minutes ago
- Listing updated: October 1, 2026 at 2:40 pm
- Listing Provided by: John Heisler (859) 468-9032 DRE #199763 | Drees/Zaring Realty (859) 578-4200
- Source: Northern Kentucky Multiple Listing Service | MLS#: 639679
Property Details
Status
Active
Type
Townhouse
No. of Stories
-
County
City
Neighborhood
--
Year Built
2026
HOA Fees
$245/mo
Finished Area
2,253 sqft
Lot Size
-- sqft lot
Basement Area
- sqft
MLS Name
Northern Kentucky Multiple Listing Service
MLS Number
639679
MLS Status
Active
Days on Market
273
Cumulative Days on Market
238
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
HOA Management
N/A
HOA Fees
$245/ Monthly
Amenities
Amenities and services may be covered by one or multiple associations and service providers.
Maintenance
Insurance
Snow Removal
Association Fees
Disclaimer: Amenities are based on third-party information and may vary; buyers must independently verify all amenities, as information is deemed reliable but not guaranteed.
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 3
Bathrooms: 3
Interior
Window Features
Vinyl Frames
Heating
Natural Gas, Hot Water, Heat Pump
Cooling
Central Air
Interior Features
Kitchen Island, Walk In Closet(s), Storage, Stone Counters, Smart Thermostat, Pantry, Open Floorplan, Entrance Foyer, Double Vanity, High Ceilings, Recessed Lighting
Sewer
Public Sewer
Appliances
Stainless Steel Appliance(s), Gas Range, Dishwasher, Disposal, Microwave
Construction
Year Built
Year Built: 2026
Home type
Townhouse
Construction Materials
Hardi Plank Type, Brick, Cedar, Stone, Vinyl Siding
Roof
Shingle
Architectural Style
Traditional
Foundation Details
Poured Concrete
Utilities & Energy
Utilities
Cable Available, Natural Gas Available, Sewer Available, Water Available
Basement
Full
Security Features
Security System, Smoke Detector(s)
Parking Features
Attached, Garage, Garage Door Opener, Garage Faces Front
Water Source
Public
Other Features
Subdivision Name
Other
Patio And Porch Features
Covered, Deck, Patio, Porch
Price History
| Date | Event | Price |
|---|---|---|
02/05/2026 Source: | Price Decreased | $459,900 -1.08% $204/sqft |
02/05/2026 Source: | Listed for Sale | $464,900 $206/sqft |
Nearby Homes
Find Homes by Property Features in Union, KY
Based on information from the Northern Kentucky Multiple Listing Service, Inc. through Nov 05, 2026, 06:45PM. Information is provided exclusively for consumers’ personal, non-commercial use. It may not be used for any purpose other than to identify prospective properties that consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed accurate by the MLS. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. © 2026 Northern Kentucky Multiple Listing Service, Inc. All Rights Reserved.
Advertising Broker: Donna Mink | Mink Realty
