2224 Esplanade Street, Union, KY 41091

Union
Local realty services provided by:ERA Real Solutions Realty
2224 Esplanade Street,Union, KY 41091
$415,700
  • 3 Beds
  • 3 Baths
  • - sq. ft.
  • Townhouse
  • Sold
Upcoming open houses
  • Sat, Aug 15
    01:00 pm - 04:00 pm
  • Sun, Aug 16
    01:00 pm - 04:00 pm
Listed by: john heisler
Office: drees/zaring realty
MLS#:634856
Source:KY_NKMLS

Sorry, we are unable to map this address


Price summary

  • Price:$415,700
  • Monthly HOA dues:$275

About this home

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.

Contact an agent

contact an agent

Yes, I would like more information. Please use and/or share my information with an ERA®  affiliated agent to contact me about my real estate needs. By clicking Send message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an ERA®  affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE® , CENTURY 21® , Coldwell Banker® , Corcoran® , Sotheby's International Realty® ). I acknowledge that I have read and agree to theTerms of useandPrivacy notice

Home facts

  • Year built:2025
  • Subdivision & Development:Other
  • Listing ID #:634856
  • Added:377 day(s) ago
  • Updated:August 12, 2026 at 05:46 PM

Rooms and interior

  • Bedrooms:3
  • Total bathrooms:3
  • Full bathrooms:3
  • Rooms Total:8
  • Kitchen Description:Dishwasher, Disposal, Gas Range, Kitchen Island, Microwave, Pantry, Stainless Steel Appliance(s)
  • Basement Description:Finished, Walk-Out Access

Heating and cooling

  • Cooling:Central Air
  • Heating:Heat Pump, Hot Water
  • Central air:Yes

Structure and exterior

  • Year built:2025
  • Architectural Style:Traditional
  • Construction Materials:Brick, Cedar, Stone, Vinyl Siding
  • Exterior Features:Covered, Deck, Lighting, Patio, Porch
  • Foundation Description:Poured Concrete

Schools

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

Utilities

  • Water:Public, Water Available
  • Sewer:Public Sewer, Sewer Available

Finances and disclosures

  • Price:$415,700

Features and amenities

  • Appliances:Microwave
  • Amenities:High Ceilings, Landscaping, Recessed Lighting, Security System, Smoke Detector(s), Storage, Vinyl Frames, Wired for Data

Parking

  • Total parking spaces:2
  • Garage:Yes
  • Garage spaces:2
Information Deemed Reliable but Not Guaranteed. 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 ERA Real Solutions Realty 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. Copyright 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.

New listings near 2224 Esplanade Street