$464,900

2175 Esplanade Street, Union, KY 41091

3 beds |
3 baths |
2,253 sqft

Town Home
Built in 2026
—— sqft lot
2 car garage
$206/sqft
Listed 9 days ago

Property 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.

Listing Status:: Active
Data Last Updated:: February 14, 2026 at 7:37AM
Listing Office:: Drees/Zaring Realty : 859-578-4200
Listing Agent:: John Heisler : 859-468-9032
MLS ID:: 639679

General: Recessed LightingHigh CeilingsDouble VanityEntrance FoyerKitchen IslandOpen FloorplanPantrySmart ThermostatStone CountersStorageWalk-In Closet(s)
Appliances: DisposalDishwasherMicrowaveGas RangeStainless Steel Appliance(s)
Basement: Full
A/C: Central Air
Heating: Heat PumpHot WaterNatural Gas

Style: Traditional
Parking: AttachedGarage Faces FrontGarage Door OpenerGarage

Roofing: Shingle
Windows: Vinyl Frames
General: BrickCedarStoneVinyl SidingHardiPlank TypeOnePoured Concrete

HOA Amenities: Maintenance GroundsSnow RemovalAssociation FeesMaintenance StructureInsurance245.0Monthly
Originating MLS: Northern Kentucky Multiple Listing Service
School District: Boone Co Public
County: Boone

Utilities: Cable AvailableNatural Gas AvailableWater AvailableSewer Available
Water: Public
Sewer: Public Sewer

Source: Northern Kentucky Multiple Listing Service

This listing courtesy of John Heisler , Drees/Zaring Realty

Monthly Payment

$Est. Payment

Principal & Interest $
Property Taxes $
Home Insurance $
VA Funding Fee $

Ready to Start a VA Loan?

Get Started

NMLS #1907 ^†

Get Prequalified »

Interest rates used in the VA mortgage calculator are shown for illustrative purposes only. Your rate may differ based on a variety of factors, including your credit score and the current market conditions. To get your personalized interest rate, start your quote online.

Location

Schools Nearby

Erpenbeck Elementary School

9001 Wetherington Blvd # US42, Florence, KY, 41042

Grades KG-5

3.17 miles away

Ockerman Middle School

8300 US Highway 42, Florence, KY, 41042

Grades 6-8

4.45 miles away

Larry A. Ryle High School

10379 US 42, Union, KY, 41091

Grades 9-12

0.98 miles away

Disclaimer: School and School District information courtesy of the National Center for Education Statistics (NCES). School boundaries may change. Proximity to listed schools does not guarantee enrollment eligibility. Contact the school district for more information and exact boundaries.