- 0
- 9
- Overview
- Description
- Property Details
- Location
- HOA Management
- Facts & Features
- Getting Around
- Nearby Homes
New Construction
Street View
$464,900
Monthly Est:$2,314
3 Beds
3 Baths3 full baths
2,253sqft
2175 Esplanade St, Union, KY 41091
$464,900
$2,314/moEst:
Get Pre-Approved
Townhouse
Built in 2026
$245/mo HOA
-- sqft lot
$206/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 scho...
Continue Reading- Houzeo last checked: 1 hour ago
- Listing updated: September 1, 2026 at 1:21 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
228
Cumulative Days on Market
208
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
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.
Insurance
Snow Removal
Maintenance
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
Heating
Natural Gas, Hot Water, Heat Pump
Sewer
Public Sewer
Interior Features
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
Cooling
Central Air
Window Features
Vinyl Frames
Construction
Year Built
Year Built: 2026
Home type
Townhouse
Roof
Shingle
Architectural Style
Traditional
Foundation Details
Poured Concrete
Construction Materials
Hardi Plank Type, Brick, Cedar, Stone, Vinyl Siding
Utilities & Energy
Parking Features
Attached, Garage, Garage Door Opener, Garage Faces Front
Security Features
Security System, Smoke Detector(s)
Basement
Full
Utilities
Cable Available, Natural Gas Available, Sewer Available, Water Available
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: | 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 Sep 21, 2026, 10:45AM. 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
Love this home?
Here's 4 things you can do
Your local real estate expert. Speak directly with agent about the home & pricing.
Book your private tour
as early as Today at 11:00 AM
Rates starting from 6.3%. Secure financing early to move quickly when you're ready.
Fastest way to get your offer in. Speak directly with agent to negotiate the offer.
Houzeo Corp. holds real estate brokerage licenses in Alabama (License No. 000157023 - 0) and Texas (License No. 9013396)
TREC: Info About Brokerage Services, Consumer Protection Notice.
§ 442‑H New York Standard Operating Procedure.
New York State Fair Housing Notice.
