• Office Phone - 513.644.4833
  • Cell - 513.404.4082

Please reload the page to update with the latest MLS information available.

Please reload the page to update with the latest MLS information available.

Please reload the page to update with the latest MLS information available.

Reload
 
Listing provided courtesy of Drees/Zaring Realty- MLS# 639679MLS Provider

2175 Esplanade StreetUnion, KY 41091

Condo/Townhouse · 3 Beds · 3 Full Baths · 2,253 Sq. ft.
$464,900 Active

2175 Esplanade Street Overview

Time on Site:
145 days
Visits:
6

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.

Love this property?
Create a profile so you can receive updates on this property as soon as they happen!
View Map

2175 Esplanade Street Facts & Features

  • Type Condo/Townhouse
  • Sq. ft. 2,253
  • Price/Sq.ft. $206

Details

General

Association/HOA

  • Association Fee: 245.0
  • Association Fee Frequency: Monthly
  • Association Fee Includes: Association Fees, Maintenance Grounds, Maintenance Structure, Snow Removal, Insurance
  • Association: Yes

School Information

  • Elementary School: Erpenbeck Elementary
  • Middle Or Junior School: Ockerman Middle School
  • High School: Ryle High

Building Information

  • New Construction: Yes
  • Security Features: Security System: true
  • Security Features: Smoke Detector: true
  • Sewer: Public Sewer: true
  • Year Built: 2026

Location/Region

  • County Or Parish: Boone
  • MLS Area Major: K11 - Richwd/Un/Wal/Ver/SB
  • MLS Area Minor: K11 - Richwd/Un/Wal/Ver/SB
  • Subdivision Name: Union Promenade

Parking Information

  • Parking Features: Attached: true
  • Parking Features: Garage Door Opener: true
  • Parking Features: Garage Faces Front: true

General Information

  • Property Sub Type: Townhouse
  • Property Type: Residential

Interior

Building Information

  • Cooling: Central Air: true
  • Heating: Heat Pump: true

Parking Information

  • Garage Spaces: 2.0
  • Garage: Yes

Beds/Baths

  • Bathrooms Full: 3
  • Bathrooms Half: 0
  • Bathrooms Total: 3
  • Bedrooms Total: 3

Building Interior

  • Building Area Total: 2253.0
  • Interior Features: High Ceilings: true
  • Interior Features: Open Floorplan: true
  • Interior Features: Recessed Lighting: true
  • Interior Features: Stone Counters: true

General Information

  • Appliances: Stainless Steel Appliance(s), Gas Range, Dishwasher, Disposal, Microwave
  • Fireplace: No
  • Foundation Details: Poured Concrete
  • Interior Features: Kitchen Island, Walk-In Closet(s), Storage, Stone Counters, Smart Thermostat, Pantry, Open Floorplan, Entrance Foyer, Double Vanity, High Ceilings, Recessed Lighting
  • Rooms Total: 8
  • Security Features: Security System, Smoke Detector(s)

Exterior

Parking Information

  • Parking Features: Attached, Garage, Garage Door Opener, Garage Faces Front

Lot Information

  • Lot Size Dimensions: Irregular
  • Lot Size Source: Builder
  • Water Source: Public

Building Exterior/Construction

  • Attached Garage: Yes
  • Construction Materials: HardiPlank Type, Brick, Cedar, Stone, Vinyl Siding
  • Patio And Porch Features: Covered, Deck, Patio, Porch
  • Property Attached: Yes
  • Roof: Shingle

General Information

  • Sewer: Public Sewer
  • Utilities: Cable Available, Natural Gas Available, Sewer Available, Water Available

2175 Esplanade Street Neighborhood

Community

41091 (Union) Demographics

38
Median Age
411
Population Density (per sq. mile)
56%
College Educated
$120,826
Estimated Median Income
6,226
Estimated Total Home Owners
451
Estimated Total Renters
93% / 7%
Estimated Owner / Renter Divide
3
Estimated Average Household Size
Community data courtesy of LiveBy, Inc.

Schools

School data courtesy of LiveBy, Inc. School ratings are based on a scale of 1-5, with 5 being the highest rating and 1 being the lowest rating.

2175 Esplanade Street Monthly Cost

$
$ %
%
$
$
* All calculations are estimates and provided by Reliance Network, for informational purposes only. Actual amounts may vary. ** Assumes 6.50% APR, 20% down payment, and conventional 30-year fixed rate first mortgage. Rates cited are for instructional purposes only; current rates are subject to change at any time without notice. You should not make any decisions based simply on the information provided. Additional required amounts such as taxes, insurance, homeowner association dues, assessments, mortgage insurance premiums, flood insurance or other such required payments should also be considered. Contact your mortgage company for current rates and additional information. Any mortgage broker or insurance agent that may appear is independent and is not affiliated with, endorsed by, or provided by the MLS.

2175 Esplanade Street Market Data

Based on the last 30 days in this zip code

$584,928
Average List Price
$299
Average Price per Square Foot
52
Properties Sold
66
Average Days on Market
222
Properties for Sale
Calculations provided by Reliance Network

2175 Esplanade Street History

Date Event Value Agent
2/5/2026Source: Northern Kentucky MLS Added to Database
February 05, 2026