Skip To Content

2228 Esplanade Street

Union, KY 41091
  • $449,900
  • STATUS: Active
  • ON SITE: 174 Days
  • MLS #: 634799
UPDATED: 51 min ago
$449,900
  • 3
    BEDS
  • N/A
    ACRES
  • 3
    BATHS
  • 0
    1/2 BATHS
  • 2,124
    SQFT
  • $212
    $/SQFT
Neighborhood:
Type:
Townhouse
Built:
2025
County:

School Information

Elementary School:
Middle School:
High School:
School District:

Description

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

Monthly Payment Calculator



Northern Kentucky MLS logo © 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity℠ Program of the Northern Kentucky Multiple Listing Service, Inc. Real estate listings held by brokerage firms other than Jim Simpson Realtors Inc are marked with the Broker Reciprocity℠ logo or the Broker Reciprocity℠ thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Information Deemed Reliable But Not Guaranteed. All data provided is copyrighted by the Northern Kentucky Multiple Listing Service, Inc. Its use is strictly for consumers of real estate and may only be displayed on the internet by participating members of the Northern Kentucky Multiple Listing Service. All attempts to illegally reproduce or host this data will be prosecuted to the fullest extent of the law. Data last updated: 2026-01-20T18:24:19.81.
www.jimsimpsonrealtors.com/homes/166378337
Print Image

2228 Esplanade Street Union, KY 41091

  • Price: $449,900
  • Status: Active
  • On Site: 174 Days
  • Updated: 51 min ago
  • MLS #: 634799
3
Beds
3
Baths
0
½ Baths
N/A
Acres
2,124
SQFT
$212
$/SQFT
2025
Built
Neighborhood:
Union Promenade
County:
Boone
Area:
Richwd/Un/Wal/Ver/Sb
Elementary School:
Erpenbeck Elementary
Middle School:
Ockerman Middle School
High School:
Ryle High
School District:
Boone Co Public
Property Description
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, 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.
Exterior Features

Architectural Style Traditional Attached Garage YN Yes Construction Materials HardiPlank TypeBrickCedarStoneVinyl Siding Exterior Features Lighting Foundation Details Poured Concrete Garage YN Yes Levels One Parking Features AttachedDrivewayGarageGarage Door OpenerGarage Faces Front Patio And Porch Features CoveredDeckPatioPorch Roof Shingle

Interior Features

Appliances Stainless Steel Appliance(s)Gas RangeDishwasherDisposalMicrowave Basement Full Finished BathFinishedStorage SpaceWalk-Out Access Cooling Central Air Cooling YN Yes Fireplace YN No Heating Natural GasHot WaterHeat Pump Heating YN Yes Interior Features Kitchen IslandWet BarWalk-In Closet(s)StorageStone CountersSmart ThermostatPantryOpen FloorplanEntrance FoyerDouble VanityHigh CeilingsRecessed LightingWired for Data Rooms Total 8 Window Features Vinyl Frames

Property Features

Association Amenities Landscaping Association Fee 275 Association Fee Frequency Monthly Association Fee Includes Maintenance GroundsMaintenance StructureSnow RemovalInsurance Association YN Yes Home Warranty YN Yes Lot Size Dimensions Irregular New Construction YN Yes Property Attached YN Yes Property Class Residential Property Condition New Construction Property Sub Type Townhouse Security Features Security SystemSmoke Detector(s) Sewer Public Sewer Structure Type Multi Family Utilities Cable AvailableNatural Gas AvailableSewer AvailableWater Available Water Source Public Zoning Description Residential

Northern Kentucky MLS logo Courtesy of Drees/Zaring Realty: 859-578-4200. © 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved. Information has not been verified, is not guaranteed, and subject to change.


Northern Kentucky MLS logo © 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity℠ Program of the Northern Kentucky Multiple Listing Service, Inc. Real estate listings held by brokerage firms other than Jim Simpson Realtors Inc are marked with the Broker Reciprocity℠ logo or the Broker Reciprocity℠ thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Information Deemed Reliable But Not Guaranteed. All data provided is copyrighted by the Northern Kentucky Multiple Listing Service, Inc. Its use is strictly for consumers of real estate and may only be displayed on the internet by participating members of the Northern Kentucky Multiple Listing Service. All attempts to illegally reproduce or host this data will be prosecuted to the fullest extent of the law. Data last updated: 2026-01-20T18:24:19.81.
 
https://bt-photos.global.ssl.fastly.net/nkmls/1280_boomver_1_634799-2.jpg
Logo
Jim Simpson Realtors Inc
39 Broadway
Dry Ridge KY, 41035