Movoto Real Estate
Search
About Tour Schools Neighborhood Places of interest Commute Home value Property history Market statistics
  • Exterior
  • Living
  • Other
  • Kitchen
  • Entry Way
  • Bedroom
  • Bath

2175 Esplanade St, Union, KY 41091

$464,900
  • 3

    bed

  • 3

    bath

Townhouse for sale 223 days
Learn about Union's top local Real Estate agents

About 2175 Esplanade St

Property type Townhouse
Neighborhood
Year built 2026
HOA fee $245/month
Parking 2 garage spaces
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.
Listed by
Listing Agent - John Heisler
Listing Office - Drees/Zaring Realty
Source: Northern Kentucky AOR mls logo
MLS#639679 • last updated 2 weeks ago
Movoto checked Northern Kentucky AOR for data 5 minutes ago
Request a virtual or in-person tour
Overview
Cooling/AC Central Air
Heating Natural Gas, Hot Water, Heat Pump
Levels/Style One, Traditional
MLS # 639679
SubType Townhouse
Type Residential
Status Active
New Construction (Y/N) 1
Year Built 2026
HOA Fee Monthly, 245
Interior
Total # of Bathrooms 3
# Full Baths 3
# Bedrooms 3
Basement Full
Total # of Rooms 8
Appliances Stainless Steel Appliance(s), Gas Range, Dishwasher, Disposal, Microwave
Window Features Vinyl Frames
Interior Features Kitchen Island, Walk-In Closet(s), Storage, Stone Counters, Smart Thermostat, Pantry, Open Floorplan, Entrance Foyer, Double Vanity, High Ceilings, Recessed Lighting
Exterior
Foundation Poured Concrete
Roof Shingle
Construction HardiPlank Type, Brick, Cedar, Stone, Vinyl Siding
Parking Desc Attached, Garage, Garage Door Opener, Garage Faces Front
# Parking Spaces 2
# Garage Spaces 2
Patio/ Porch Covered, Deck, Patio, Porch
Amenities / Utilities
Utilities Cable Available, Natural Gas Available, Sewer Available, Water Available
Sewer/ Septic Public Sewer
Water Source Public
Security Features Security System, Smoke Detector(s)
HOA Fee Includes Association Fees, Maintenance Grounds, Maintenance Structure, Snow Removal, Insurance
Location
County Boone
Subdivision Other
Area K11 - Richwd/Un/Wal/Ver/SB
Elementary School Erpenbeck Elementary
Middle School Ockerman Middle School
High School District Boone Co Public
High School Ryle High
Zoning Residential
Directions I-71/75 To South On Rt. 42 (Florence Exit) To Right On Children's Way To Right On La Croisette.
Tour this home
When would you like to see 2175 Esplanade St?
question
Have a question about this property? Call us at (844) 430-0869
8/10
Erpenbeck Elementary School
public Grades PK, K-5
Boone County
5/10
Ockerman Middle School
public Grades 6-8
Boone County
7/10
Larry A. Ryle High School
public Grades 9-12
Boone County
Source: GreatSchools.org © 2026. All rights reserved.

Around K11 - Richwd/un/wal/ver/sb

Explore everything this neighborhood has to offer.
View homes for sale in 41091, KY
21/100
Walk
98/100
Family
46/100
Dining
78/100
Pet
  • Real Estate
  • KY
  • Boone County
  • Union
  • 41091
  • 2175 Esplanade St

My commute

Enter a destination to see travel time and distance.
By entering my info and clicking Ask a Question below, I am providing my e-signature and express written consent to receive marketing emails, calls, and texts (including via automatic telephone dialing systems, AI generative, artificial or pre-recorded voice technology) relating to my inquiry from Movoto (and parties calling/messaging on their behalf) even if my number appears on the company, state, or national Do Not Call Registry. You also agree to ourTerms and Conditions and Privacy Policy. Consent not required to receive services (call 1-844-420-1270 to be connected without providing consent).

Nearby homes for sale in Union, KY

Nearby recently sold homes in Union, KY

Newest listings in 41091

Meet with a real estate agent today (844) 430-0869
  • Movoto Logo
  • Download IOS APP Download Android APP
The multiple listing information is provided by Northern Kentucky AOR. IDX information is provided exclusively for consumers’ personal, non-commercial use and that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed to be accurate. Buyer to verify all information. The information provided is 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. Listing information updated every 15 minutes. Terms of use & Privacy Policy, California Privacy Info. Copyright © 2005 - 2026 Movoto, Inc. All rights reserved. Equal Housing Opportunity CalDRE CalDRE #01517281
Movoto Real Estate is committed to ensuring accessibility for individuals with disabilities. We are continuously working to improve the accessibility of our web experience for everyone. We welcome feedback and accommodation requests, please submit them here.
Copyright 2026 of Northern Kentucky AOR. All rights reserved.
IDX Data is provided exclusively for consumers’ personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that data is deemed reliable but is not guaranteed accurate by the Northern Kentucky AOR.
Requests for information regarding mortgage products will be directed to Movoto.com affiliate, Lower, LLC - a licensed Mortgage Lender (NMLS #1124061), or, based on your location, may be redirected to a participating mortgage marketing partner that may pay Lower, LLC for any consumer contact information provided through this site.