Ask how you can lock your interest rate on this home today! Live in the highly anticipated Union Promenade! The Drees Brandywine is a brand new ranch-style townhome with 3 bedrooms, 3 full baths, a finished lower level, and a 2-car attached garage. The open-concept design features 9' smooth ceilings, quartz countertops, a large kitchen island, a walk-in pantry, luxury vinyl plank flooring, stainless steel appliances, and double ovens. The primary suite offers a bath with double vanities and a spacious walk-in closet. Plus, enjoy being just a short walk from shops and restaurants, all within the Boone County school district.
Sold for $402,494 on 07/11/25
$402,494
2268 Esplanade St, Union, KY 41091
3beds
2,124sqft
Condominium, Residential
Built in 2025
-- sqft lot
$404,200 Zestimate®
$189/sqft
$-- Estimated rent
What's special
Zillow last checked: 7 hours ago
Listing updated: July 16, 2025 at 05:05am
Listed by:
John Heisler 859-468-9032,
Drees/Zaring Realty
Bought with:
Lena Keith, 270151
Pivot Realty Group
Source: NKMLS,MLS#: 629547
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 3
Primary bedroom
- Features: Bath Adjoins, Carpet Flooring, Walk-In Closet(s)
- Level: First
- Area: 182
- Dimensions: 14 x 13
Bedroom 2
- Features: Carpet Flooring
- Level: First
- Area: 110
- Dimensions: 11 x 10
Bedroom 3
- Features: Carpet Flooring, Walk-In Closet(s)
- Level: Basement
- Area: 144
- Dimensions: 12 x 12
Bathroom 2
- Features: Tub With Shower
- Level: First
- Area: 35
- Dimensions: 7 x 5
Bathroom 3
- Features: Shower, Luxury Vinyl Flooring
- Level: Basement
- Area: 40
- Dimensions: 8 x 5
Other
- Description: Wet Bar
- Features: See Remarks, Walk-Out Access
- Level: Basement
- Area: 360
- Dimensions: 24 x 15
Dining room
- Features: Luxury Vinyl Flooring
- Level: First
- Area: 144
- Dimensions: 16 x 9
Entry
- Features: Luxury Vinyl Flooring
- Level: First
- Area: 28
- Dimensions: 7 x 4
Family room
- Features: Luxury Vinyl Flooring
- Level: First
- Area: 224
- Dimensions: 16 x 14
Kitchen
- Features: Kitchen Island, Pantry, Luxury Vinyl Flooring
- Level: First
- Area: 176
- Dimensions: 16 x 11
Laundry
- Features: Luxury Vinyl Flooring
- Level: First
- Area: 55
- Dimensions: 11 x 5
Primary bath
- Features: Double Vanity, Shower
- Level: First
- Area: 108
- Dimensions: 12 x 9
Heating
- Hot Water
Cooling
- Central Air
Appliances
- Included: Stainless Steel Appliance(s), Gas Cooktop, Dishwasher, Disposal, Double Oven, 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
- Has view: Yes
- View description: Pond
- Has water view: Yes
- Water view: Pond
Details
- Zoning description: Residential
Construction
Type & style
- Home type: Condo
- Architectural style: Ranch
- Property subtype: Condominium, Residential
- Attached to another structure: Yes
Materials
- HardiPlank Type, Brick, Cedar, Stone, Vinyl Siding
- Foundation: Poured Concrete
- Roof: Shingle
Condition
- New Construction
- 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 & neighborhood
Security
- Security features: Security System, Smoke Detector(s)
Location
- Region: Union
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $275 monthly
- Amenities included: Landscaping
- Services included: Maintenance Grounds, Maintenance Structure, Snow Removal
Other
Other facts
- Road surface type: Paved
Services availability
Sell for more on Zillow
Get a free Zillow Showcase℠ listing and you could sell for .
$404,200
2% more+ $8,084
With Zillow Showcase(estimated)
$412,284