Skip main navigation
New construction
  • $449,900

    2224 Esplanade St, Union, KY 41091

    3beds
    2,124sqft
    : 
    Townhouse, Residential, Multi Family
    Built in 2025
    -- sqft lot
    $-- Zestimate®
    $212/sqft
    $275/mo HOA

    What's special

    Cozy fireplaceLarge walk-in closetStainless steel appliancesLarge kitchen islandOpen floor planQuartz countertopsWalk-in pantry
    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.
    2 days
    on Zillow
    |
    4
    |
    0
    |

    Likely to sell faster than

    Zillow last checked: 7 hours ago

    Listing updated: July 31, 2025 at 06:24am

    Listed by:

    John Heisler 859-468-9032,

    Drees/Zaring Realty

    Source: NKMLS,MLS#: 634856MLS Logo
    Travel times

    Tour with a buyer's agent

    We'll find a local expert to take you on a private tour of 2224 Esplanade St.

    Next available tour time:Today at 3pm

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 3
    • Bathrooms: 3
    • Full bathrooms: 3
    Primary bedroom
    • Description: 9' ceiling; carpet; w/i closet; bath adjoining
    • Level: First
    • Area: 182
    • Dimensions: 14 x 13
    Other
    • Description: 9' ceiling; carpet; wet bar; walkout to patio
    • Level: Lower
    • Area: 360
    • Dimensions: 24 x 15
    Dining room
    • Description: 9' ceiling; LVP flooring
    • Level: First
    • Area: 144
    • Dimensions: 16 x 9
    Entry
    • Description: 9' ceiling; LVP flooring; b/i bench
    • Level: First
    • Area: 28
    • Dimensions: 7 x 4
    Family room
    • Description: 9' ceiling; LVP flooring
    • Level: First
    • Area: 224
    • Dimensions: 16 x 14
    Kitchen
    • Description: 9' ceiling; large island; LVP flooring; quartz countertops; walk-in pantry; SS appliances
    • Level: First
    • Area: 176
    • Dimensions: 16 x 11
    Laundry
    • Description: LVP flooring
    • Level: First
    • Area: 55
    • Dimensions: 11 x 5
    Primary bath
    • Description: 9' ceiling; double bowl vanity; quartz countertops; tall vanity; comfort height commode; w/i shower w/tile surround
    • Level: First
    • Area: 108
    • Dimensions: 12 x 9
    Heating
    • Hot Water, Heat Pump
    Cooling
    • Central Air
    Appliances
    • Included: Stainless Steel Appliance(s), Gas Range, Dishwasher, Disposal, Microwave
    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
    • Windows: Vinyl Frames
    • Has basement: Yes
    Interior area
    • Total structure area: 2,124
    • Total interior livable area: 2,124 sqft

    Property

    Parking
    • Total spaces: 2
    • Parking features: Attached, Driveway, Garage, Garage Door Opener, Garage Faces Front
    • Attached garage spaces: 2
    • Has uncovered spaces: Yes
    Features
    • Levels: One
    • Stories: 1
    • Patio & porch: Covered, Deck, Patio, Porch
    • Exterior features: Lighting
    Details
    • Zoning description: Residential

    Construction

    Type & style
    • Home type: Townhouse
    • Architectural style: Traditional
    • Property subtype: Townhouse, Residential, Multi Family
    • Attached to another structure: Yes
    Materials
    • HardiPlank Type, Brick, Cedar, Stone, Vinyl Siding
    • Foundation: Poured Concrete
    • Roof: Shingle
    Condition
    • New construction: Yes
    • Year built: 2025
    Details
    • Warranty included: Yes

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: Cable Available, Natural Gas Available, Sewer Available, Water Available

    Community & HOA

    Community
    • Security: Security System, Smoke Detector(s)
    • Subdivision: Retreat at Union Promenade
    HOA
    • Has HOA: Yes
    • Amenities included: Landscaping
    • Services included: Maintenance Grounds, Maintenance Structure, Snow Removal
    • HOA fee: $275 monthly
    Location
    • Region: Union

    Financial & listing details

    • Price per square foot: $212/sqft
    • Date on market: 7/31/2025
    • Loading
    • Loading