$444,900
NEW CONSTRUCTION

2220 Esplanade St Unit 23D Union, KY 41091

3 Beds
3 Baths
2,392 Sq Ft
$186 Price per Sq Ft

Highlights

  • New Construction
  • Open Floorplan
  • Recreation Room
  • Erpenbeck Elementary School Rated A
  • Deck
  • Traditional Architecture

About This Home

Experience comfort and convenience at Union Promenade! The Drees Brandywine is a beautifully designed ranch-style townhome offering 3 bedrooms, 3 full baths, a finished lower level with a dedicated hobby room, and a 2-car garage. The open-concept layout features 9' ceilings, quartz countertops, a spacious kitchen island, walk-in pantry, stainless steel appliances, and luxury vinyl plank flooring throughout the main living areas. The private primary suite includes a well-appointed bath with double vanities and a generous walk-in closet. Ideally located within walking distance to shopping and dining, and situated in the Boone County School District.

Listing Agent

John Heisler

Drees/Zaring Realty License #199763 Listed on: 03/24/2026

Townhouse Details

Home Type

  • Townhome

Year Built

  • Built in 2026 | New Construction

Lot Details

  • Property fronts a state road
  • Landscaped

HOA Fees

  • $275 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Front Facing Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof
  • Vinyl Siding
  • HardiePlank Type
  • Cedar
  • Stone

Interior Spaces

  • 2,392 Sq Ft Home
  • 1-Story Property
  • Open Floorplan
  • Wet Bar
  • Wired For Data
  • High Ceiling
  • Recessed Lighting
  • Fireplace
  • Vinyl Clad Windows
  • Entrance Foyer
  • Family Room
  • Dining Room
  • Recreation Room
  • Storage
  • Laundry Room

Kitchen

  • Gas Range
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Stone Countertops
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet
  • 3 Full Bathrooms
  • Double Vanity

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Basement Storage

Home Security

  • Home Security System
  • Smart Thermostat

Outdoor Features

  • Deck
  • Covered Patio or Porch

Schools

  • Erpenbeck Elementary School
  • Ockerman Middle School
  • Ryle High School

Utilities

  • Central Air
  • Heating System Uses Natural Gas
  • Heat Pump System
  • Hot Water Heating System
  • Cable TV Available

Listing and Financial Details

  • Home warranty included in the sale of the property

Community Details

Overview

  • Association fees include ground maintenance, snow removal, maintenance structure, insurance
  • Stonehenge Property Mgmt. Association, Phone Number (859) 534-0900
  • Union Promenade Subdivision

Security

  • Fire and Smoke Detector

Townhouse Details

Home Type

Townhome

Year Built

Built in 2026 | New Construction

Lot Details

0 Sq Ft Lot

HOA Fees

$275 per month

Parking

2

Listing Details

  • Cooling: Central Air
  • Property Condition: New Construction
  • Property Sub Type: Townhouse
  • Year Built: 2026
  • Lot Size: Irregular
  • Road Frontage Type: State Road
  • Road Surface Type: Paved
  • Ownership: Builder/Developer
  • Subdivision Name: Union Promenade
  • Directions: I-71/75 to south on Rt. 42 (Florence exit) to right on Children's Way, to right on Venice Street, to right on Esplanade Street.
  • Architectural Style: Traditional
  • Garage Yn: Yes
  • New Construction: Yes
  • Property Attached Yn: Yes
  • Structure Type: Multi Family
  • Contract Info:Auction YN: No
  • General Property Description:Basement YN2: Yes
  • Utilities Electric Company: Duke Energy
  • Utilities Gas Company: Duke Energy
  • Water Company: Boone County Water
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: No
  • Special Features: NewHome

Interior Features

  • Interior Amenities: Wet Bar, Recessed Lighting, High Ceilings, Wired for Data, Double Vanity, Entrance Foyer, Kitchen Island, Open Floorplan, Pantry, Smart Thermostat, Stone Counters, Storage, Walk-In Closet(s)
  • Basement: Full, Walk-Out Access, Full Finished Bath, Finished, Storage Space
  • Heating: Heat Pump, Hot Water, Natural Gas
  • Levels: One
  • Property Type: Residential
  • Appliances: Disposal, Dishwasher, Microwave, Gas Range, Stainless Steel Appliance(s)
  • Full Bathrooms: 3
  • Total Bedrooms: 3
  • Fireplace: No
  • Window Features: Insulated Windows, Vinyl Frames

Exterior Features

  • Roof: Shingle
  • Home Warranty: Yes
  • Construction Type: Brick, Cedar, Stone, Vinyl Siding, HardiPlank Type
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Deck, Porch, Patio, Covered

Garage/Parking

  • Attached Garage: Yes
  • Parking Features: Attached, Driveway, Garage Faces Front, Garage Door Opener, Garage
  • Total Parking Spaces: 2.0

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Security: Smoke Detector(s), Security System
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Cable Available, Natural Gas Available, Water Available, Sewer Available

Condo/Co-op/Association

  • Amenities: Landscaping
  • Association Fee: 275.0
  • Association Fee Frequency: Monthly
  • Association: Yes

Association/Amenities

  • Association Information:Association Management Name 1: Stonehenge Property Mgmt.
  • Association Information:Association Management Phone 1: 859-534-0900
  • Association Information:Total Yearly Fees: 3300.0

Fee Information

  • Association Fee Includes: Maintenance Grounds, Snow Removal, Maintenance Structure, Insurance

Schools

  • Elementary School: Erpenbeck Elementary
  • Junior High Dist: Boone Co Public
  • High School: Ryle High
  • Middle Or Junior School: Ockerman Middle School

Lot Info

  • Zoning Description: Residential

Map

Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
03/24/2026 03/24/26 For Sale $444,900 -- $186 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

Source: Northern Kentucky Multiple Listing Service

MLS Number: 640839

Northern Kentucky Multiple Listing Service
Kentucky Boone County Union 41091

2220 Esplanade St Unit 23D, Union, KY

For Sale

Townhouses

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Northern Kentucky Multiple Listing Service The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of NKMLS. Real estate listings held by IDX Brokerage firms other than Ten-X are marked with the Internet Data Exchange logo or the Internet Data Exchange thumbnail logo and detailed information about them includes the name of the listing Brokers.

Listing information is deemed reliable, but not guaranteed.

Copyright 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.

Nearby Homes
Listing Agent
John Heisler
Section Image
Drees/Zaring Realty
(859) 297-3901
Your Personal Tour Guide

Ask me questions while you tour the home.