Dawn Sheanshang

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# 634856MLS Provider

2224 Esplanade StreetUnion, KY 41091

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

2224 Esplanade Street Overview

Time on Site:
334 days
Visits:
31

Live where comfort meets convenience at Union Promenade! The Drees Brandywine is a stylish ranch-style townhome featuring 3 bedrooms, 3 full baths, a finished lower level, and a 2-car garage. Enjoy an open floor plan with 9' ceilings, a cozy fireplace, quartz countertops, a large kitchen island, walk-in pantry, stainless steel appliances, and luxury vinyl plank flooring. The spacious primary suite offers a luxury bath with double vanities and a large walk-in closet. All just a short walk from shops and dining, in 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

2224 Esplanade Street Facts & Features

  • Type Condo/Townhouse
  • Sq. ft. 2,124
  • Price/Sq.ft. $198

Details

General

Association/HOA

  • Association Fee: 275.0
  • Association Fee Frequency: Monthly
  • Association Fee Includes: 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: 2025

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: Retreat at 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: 2124.0
  • Interior Features: High Ceilings: true
  • Interior Features: Open Floorplan: true
  • Interior Features: Recessed Lighting: true
  • Interior Features: Stone Counters: true
  • Interior Features: Wired for Data: true

General Information

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

Exterior

Parking Information

  • Parking Features: Attached, Driveway, 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
  • Exterior Features: Lighting: true
  • Patio And Porch Features: Covered, Deck, Patio, Porch
  • Property Attached: Yes
  • Roof: Shingle

General Information

  • Exterior Features: Lighting
  • Sewer: Public Sewer
  • Utilities: Cable Available, Natural Gas Available, Sewer Available, Water Available

2224 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 unavailable, 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.

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

2224 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

2224 Esplanade Street History

Date Event Value Agent
6/26/2026Source: Northern Kentucky MLS Price Reduction
$419,900 -1.2%
5/15/2026Source: Northern Kentucky MLS Price Reduction
$424,900 -1.2%
3/27/2026Source: Northern Kentucky MLS Price Reduction
$429,900 -1.1%
2/28/2026Source: Northern Kentucky MLS Price Reduction
$434,900 -1.1%
1/22/2026Source: Northern Kentucky MLS Price Reduction
$439,900 -1.1%
1/2/2026Source: Northern Kentucky MLS Price Reduction
$444,900 -1.1%
7/31/2025Source: Northern Kentucky MLS Added to Database
July 31, 2025