Sold356d on market
2260 Esplanade St
Union, KY, 41091 • 41091 • Boone County
$460,000
$175/sqft
3Beds
3Baths
2,629Sqft
2024Built
Property DNA
Waterfront Property
Direct water access
Pond Views
Pond
Ranch Style
Built 2024 · 2 years of history
Outdoor Living
Covered · Deck · Patio · Porch
2-Car Garage
Attached · Driveway · Garage · Garage Door Opener · Garage Faces Front
Premium Finishes
Walk-In Closet(s)
$257/mo HOA
Other · Parking · Landscaping
Market activity
Demand and pricing signals for this listing
3 views
People checking out this listing
356 days on market
Established listing
$175/sqft
Price per square foot
About this home
Condo · Built 2024
Located in the highly anticipated Union Promenade Entertainment District! New Drees ranch-style townhome with a finished lower level and 2 car attached garage. The Waverly offers 3 bedrooms and 3 baths. It has an open concept design with features like 9' smooth ceilings, quartz countertops, a large kitchen island, walk-in pantry, painted cabinets, luxury vinyl plank flooring, stainless steel appliances, double ovens, double vanity sinks in the primary bath and a luxurious super shower! It's also equipped with DreeSmart technology, which includes a video doorbell, programable thermostat, wireless router, home automation hub, and smart lock. Enjoy a quick walk to a variety of shopping and dining. All within Boone Country school district.
Standout features identified
Our analysis highlights huge rec room, two-car garage, and media room as key attractions of this home.
Estimated monthly payment
Based on current rates
$3,257/month
Principal & Interest$2,387
Property Tax$460
Insurance$153
HOA$257
Down payment20% ($92,000)
3%50%
Est. 6.75% rate · 30yr fixed · $368,000 loan
Full calculator →At a glance
Key facts and listing details
TypeCondominium, Residential
Year Built2024
HeatingForced Air
CoolingCentral Air
Parking2 Attached Garage spaces
HOA$257 monthly
Property
Home typeCondo
Sub-typeCondominium, Residential
StyleRanch
ConditionNew Construction
Year built2024
Stories1
Systems
HeatingForced Air
CoolingCentral Air
RoofShingle
ConstructionHardiPlank Type, Brick, Cedar, Stone, Vinyl Siding
Water / SewerPublic / Public Sewer
Parking & Outdoor
ParkingAttached, Driveway, Garage, Garage Door Opener, Garage Faces Front
Garage2 spaces
Location & Tax
Neighborhood41091
Bathrooms & Fees
Full baths3
HOA$257/mo
Features & details
13 categories of property features
Interior Features
Interior
Kitchen Island
Wet Bar
Walk-In Closet(s)
Storage
Stone Counters
Smart Thermostat
Smart Home
Pantry
Open Floorplan
Double Vanity
Ceiling Fan(s)
High Ceilings
Recessed Lighting
Wired for Data
Appliances
Stainless Steel Appliance(s)
Electric Range
Gas Cooktop
Gas Oven
Dishwasher
Double Oven
Microwave
Heating
Forced Air
Cooling
Central Air
Windows
Vinyl Frames
Exterior Features
Exterior
Balcony
Lighting
Parking
Attached
Driveway
Garage
Garage Door Opener
Garage Faces Front
Construction
HardiPlank Type
Brick
Cedar
Stone
Vinyl Siding
Patio & Porch
Covered
Deck
Patio
Porch
Lot Features
Rolling Slope
Security
Smoke Detector(s)
Views
Pond
Utilities
Cable Available
Natural Gas Available
Sewer Available
Water Available
Room details
13 rooms detailed
Primary Bedroom
First16×13 ft208 sqft
Carpet FlooringWalk-In Closet(s)Bath Adjoins
Bedroom2
First14×11 ft154 sqft
Carpet FlooringWalk-In Closet(s)
Bedroom3
Basement14×11 ft154 sqft
Carpet FlooringWalk-In Closet(s)
Bathroom2
First7×5 ft35 sqft
Tub With Shower
Bathroom3
Basement8×5 ft40 sqft
ShowerLuxury Vinyl Flooring
Other
Basement30×17 ft510 sqft
Walk-Out AccessCarpet FlooringSee Remarks
Listing insights
Market data and value estimates
StatusSold
Days on market356
Est. value$471,800
Est. rent$2,998/mo
Tax rate0.82%
Price/sqft$175
On marketMay 4, 2025
PostedMay 4, 2025
Last sold$460,000
MLS updatedApr 21, 2025
Tour days6
Views3
How are the schools in Union?
3 schools rated nearby
Location
Union, KY, 41091
Price history
4 events
DateEventPrice$/sqftSource
Apr 17, 2025Sold$460,000$175NKMLS
Mar 19, 2025Pending Sale$470,000$179NKMLS
Mar 3, 2025Price Change$470,000$179NKMLS
Sep 27, 2024Listed For Sale$479,900$183Drees Homes
Sold$460,000
Apr 17, 2025•$175/sqft•NKMLS
Pending Sale$470,000
Mar 19, 2025•$179/sqft•NKMLS
Price Change$470,000
Mar 3, 2025•$179/sqft•NKMLS
Listed For Sale$479,900
Sep 27, 2024•$183/sqft•Drees Homes
Nearby homes
Neighborhood details
Local context around this listing
Union, KY • Boone County
Nearby cities
BurlingtonFlorenceHebronPetersburgUnionVeronaWalton
Nearby zip codes
41091
Similar homes
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 Zillow, Inc. 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.
No obligation · Same-day response