$469,900
PENDING NEW CONSTRUCTION

2179 Esplanade St Union, KY 41091

Union Area

Estimated payment $3,275/month

Total Views 213
3 Beds
3 Baths
2,629 Sq Ft
$179 Price per Sq Ft

Highlights

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

About This Home

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 Agent

John Heisler

Drees/Zaring Realty License #199763 Listed on: 02/05/2026

Townhouse Details

Home Type

  • Townhome

Year Built

  • Built in 2025 | New Construction

HOA Fees

  • $245 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,629 Sq Ft Home
  • 1-Story Property
  • Open Floorplan
  • Wired For Data
  • High Ceiling
  • Recessed Lighting
  • Fireplace
  • Vinyl Clad Windows
  • Entrance Foyer
  • Family Room
  • Dining Room
  • Recreation Room
  • Storage
  • Laundry Room
  • Basement Fills Entire Space Under The House

Kitchen

  • Double Oven
  • Gas Cooktop
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Stone Countertops
  • Disposal

Bedrooms and Bathrooms

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

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
  • 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
  • Stonegate Property Mgmt. Association, Phone Number (859) 534-0900

Security

  • Fire and Smoke Detector

Townhouse Details

Home Type

Townhome

Year Built

Built in 2025 | New Construction

Lot Details

0 Sq Ft Lot

HOA Fees

$245 per month

Parking

2

Listing Details

  • Cooling: Central Air
  • Property Condition: New Construction
  • Property Sub Type: Townhouse
  • Year Built: 2025
  • Lot Size: Irregular
  • Ownership: Builder/Developer
  • Directions: I-71/75 to south on Rt. 42 (Florence exit,) to right on Children's Way, to right on LaCroisette 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
  • Property Ownership:Property Ownership: Builder/Developer
  • Special Features: NewHome

Interior Features

  • Interior Amenities: 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
  • Heating: Hot Water, Natural Gas
  • Levels: One
  • Property Type: Residential
  • Appliances: Disposal, Double Oven, Dishwasher, Microwave, Stainless Steel Appliance(s), Gas Cooktop
  • Full Bathrooms: 3
  • Total Bedrooms: 3
  • Fireplace: No
  • Window Features: 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

  • Association Fee: 245.0
  • Association Fee Frequency: Monthly
  • Association: Yes

Association/Amenities

  • Association Information:Association Management Name 1: Stonegate Property Mgmt.
  • Association Information:Association Management Phone 1: 859-534-0900
  • Association Information:Total Yearly Fees: 2940.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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft Prior Sale
07/08/2026 07/08/26 Sold $469,900 0.0% $179 / Sq Ft View Prior Sale
07/03/2026 07/03/26 Off Market $469,900 -- --
02/01/2026 02/01/26 Price Changed $469,900 0.0% $179 / Sq Ft
01/11/2026 01/11/26 For Sale $469,900 -- $179 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

Source: Northern Kentucky Multiple Listing Service

MLS Number: 639659

Northern Kentucky Multiple Listing Service
Kentucky Boone County Union 41091

2179 Esplanade St, Union, KY

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) 809-3023
Your Personal Tour Guide

Ask me questions while you tour the home.