2175 Esplanade St, Union, KY 41091
Property image
Property image
FOR SALE
NEW CONSTRUCTION
QUICK MOVE-IN

$464,900

  • 3 Beds
  • 3 Baths
  • 2,253 sqft

2175 Esplanade St, Union, KY 41091

Est. Mortgage $3,097/mo*
Get Pre-Qualified

Home Highlights

Townhouse
Built in 2026
$206/sqft
2 Car Garage
HOA $245/mo

Local Information

  • Map ViewExplore the area around 2175 Esplanade St.
  • Schools1 Preschool School1 Elementary School1 Middle School1 High School
  • Shop & Eat
-- mins to
Commute Destination

About this House

Live in the highly anticipated Union Promenade! The Drees Medford is a stunning ranch-style townhome designed for modern living. With a finished lower level and a 2-car attached garage, this home features 3 spacious bedrooms and 3 full baths. The open concept design boasts 9' ceilings, quartz countertops, a large kitchen island, and a walk-in pantry--perfect for culinary creativity. Enjoy luxury vinyl plank flooring, stainless steel appliances, and a gas range. The primary suite is your private retreat, with double vanities and a walk-in closet that dreams are made of. Plus, you're just a short walk from a variety of shops and restaurants, all within the Boone County school district.
Contact this Building
Property Website
Last check for updates: about 4 hours ago
Listing courtesy of John Heisler, (859) 468-9032
Drees/Zaring Realty
Source: NKMLS, MLS#639679
Also Listed on Drees Homes, NKMLS.

Home Details for 2175 Esplanade St

Interior Features

Heating & Cooling
Heating: Hot Water, Heat PumpAir ConditioningCooling System: Central AirHeating Fuel: Hot Water
Levels, Entrance, & Accessibility
Stories: 1
Interior Details
Number of Rooms: 12Types of Rooms: Primary Bedroom, Bedroom 2, Bedroom 3, Bathroom 2, Bathroom 3, Dining Room, Entry, Family Room, Kitchen, Laundry, Primary Bath
Appliances & Utilities
DishwasherDisposalMicrowave

Exterior Features

Exterior Home Features
Roof: ShingleFoundation Type: Poured Concrete
Parking & Garage
GarageParking Spaces: 2Parking: Attached Garage Garage Door Opener Garage Faces Front

Property Information

Year Built
Year Built: 2026
Property Type / Style
Property Type: TownhouseArchitecture: Traditional

Price & Status

Price
Price Per Sqft: $206

Agent Information

Listing Agent
MLS/Source ID: 639679

HOA

HOA Fee: $245/Monthly

All New Homes in Retreat at Union Promenade

Quick Move-in Homes (2)

All (2)
3 bd (2)
2244 Esplanade St
3bd
3ba
2,124 sqft
$444,900
Check Availability
2175 Esplanade St
3bd
3ba
2,253 sqft
$464,900
Check Availability
Quick Move-In Homes provided by NKMLS

Buildable Plans (6)

All (6)
2 bd (5)
3 bd (1)
CALABASAS II Plan
2bd
2ba
1,396 sqft
$312,500+
Check Availability
BRANDYWINE II Plan
2bd
2ba
2,392 sqft
$387,000+
Check Availability
VENTURA Plan
3bd
3ba
2,505 sqft
$390,000+
Check Availability
WAVERLY II Plan
2bd
2ba
2,629 sqft
$430,000+
Check Availability
MEDFORD II Plan
2bd
2ba
1,958 sqft
$430,000+
Check Availability
ASTORIA Plan
2bd
2ba
2,144 sqft
$439,900+
Check Availability
Buildable Plans provided by Drees Homes

Community Description

Embrace an easy lifestyle with Drees at Union Promenade! Centrally located within vibrant Union, Kentucky this new townhome neighborhood boasts luxurious ranch townhomes with stylish finishes and everything you desire for carefree living. Open and spacious townhomes offer one level living in an airy, open layout. Residents will enjoy the security and convenience of an attached two-car garage. Some floor plans also offer lower levels, which can be finished to provide extra storage and living space. This location can't be beat! Imagine living in a convenient walkable area, steps from the Union Promenade entertainment district featuring dining, fitness and more. Don't miss your chance to live in the heart of this exciting community!
Contact this Building
Learn more about this community

Office Hours

Sales Office
2264 Esplanade Street
Union, KY 41091
Sun-Mon 12:00 PM-6:00 PM; Tue-Sat 11:00 AM-6:00 PM;

Around this home

What Locals Say about Union

At least 100 Trulia users voted on each feature.

  • 92 % Say it's dog friendly

  • 92 % Say parking is easy

  • 90 % Say car is needed

  • 87 % Say there are sidewalks

  • 85 % Say it's quiet

  • 84 % Say people would walk alone at night

  • 83 % Say there's holiday spirit

  • 80 % Say yards are well-kept

  • 80 % Say kids play outside

  • 73 % Say streets are well-lit

  • 66 % Say there's wildlife

  • 62 % Say neighbors are friendly

  • 58 % Say they plan to stay for at least 5 years

  • 48 % Say there are community events

  • 38 % Say it's walkable to grocery stores

  • 24 % Say it's walkable to restaurants

Sourced by Trulia users. Learn more about our methodology.
  • Kjvn264th7
    "The schools are very good and lots of families in every neighborhood with children of all ages. Most neighborhoods are pretty safe for children to play outside and small parks to use. "
    0
    Flag
  • Sarahdamron
    "Limited public transit available. Car required, even to just get to the bus stop in most areas. Lots of traffic if you commute to downtown Cincinnati."
    0
    Flag
  • Psholtz2000
    "Lots of dogs in the neighborhood and people walking their animals. We plan on eventually getting a dog ourselves. "
    0
    Flag
  • Sammy M.
    "Lots of families live here. Good schools. Quiet streets. Our neighborhood has two pools, two ponds, two tennis courts, half a basketball court and a playground"
    0
    Flag
  • Sammy M.
    "Commute wise you have to have a car. If desperate you could walk to Kroger and some other business nearby but the road is currently under construction 7/2020 so there is no side walk available for a large portion to Kroger. It’s about 25 minutes to downtown Cincinnati by car. You basically have to have a car to get around. You do have to contend with I71/75 traffic if you have to get to work (unless you work in Florence which is the neighboring town, not many jobs in Union outside of retail and restaurant) which is notorious for a lot of traffic and major delays. But if you need to you can hop on to I-275 and take that to I471 and you will make it to the city. Or you can get off several exits after I-275 to take back roads through Covington to get to downtown Cincinnati. Now if for some reason you have to drive south of Union you will have very little traffic pending an accident or bad weather as most people commute north. "
    0
    Flag
  • Sammy M.
    "Lots of kids. good schools. Low crime rate. Lots of activities to join. Library close by. Lots of restaurants and shops short drive. "
    0
    Flag
  • Sammy M.
    "There are lots of families. Good public schools Ryle, Grey, Mann. Very safe community. Houses are well taken care of"
    0
    Flag
  • Smbreitling
    "I drive my kids to catholic school 20 minutes north on I 75/71. The majority of their activities are north of the I 275 loop, off I75. There are A LOT of semi trucks on the interstate. It takes 12 minutes to drive to the closest grocery store. I have lived in Union 15 yrs & the population is growing & so is the traffic. The roads aren’t ready for all the traffic. So, overall I really dislike the commute to anywhere I need to go, including restaurants & shopping. I’m ready to move 15 miles north. "
    0
    Flag
  • Zevelyc1
    "It can be a rough ride to Downtown in peak hours. They are redoing Richwood road so that will help. With no traffic the ride into Cincinnati is easy. With traffic though there are lots of ways around."
    1
    Flag
  • Xrzv.00
    "Very easy access to main highway, unfortunately mostly congested but it appears improvements are being made."
    0
    Flag
  • Angela P.
    "The commute is quite simple. Just minutes away from local major grocery stores, drugstores, and the major interstates. "
    1
    Flag
  • Mdvguest
    "Great schools and family oriented. A short commute to Cincinnati but a secluded and surrounded by farmland. "
    0
    Flag
  • hahaha
    "there are parades occasionally and there is a lot of development in the area. it will be booming within the next decade"
    0
    Flag
  • Jacklynemink
    "Please be careful around the road people tend to speed. Family neighborhood with nice parks and pools"
    0
    Flag
  • Markls42
    "I lived in this neighborhood for 9 years and we love this area. Great people and a great neighborhood to live in."
    0
    Flag
  • Anthony S.
    "there was a stabbing the other day with air care........................it wasn't a good sight really made us think. there's a lot of dirty in rich neighborhoods "
    0
    Flag
  • Ehodzic429
    "Walking their dogs outside in the manly parks that we have here. People clean up after their dogs. They have a dog park. "
    0
    Flag
  • Elysialee883
    "It’s laid back & almost suburban but country at the same time. I honestly love it . The greatest place"
    0
    Flag
  • Kayla A.
    "Great neighborhood, very safe, great community, young ones can grow up well with all the schools nearby."
    0
    Flag
  • Leslie S.
    "Family friendly. Very safe environment. Close to everything. Can’t get lost. Always something going on near by. "
    0
    Flag
  • Mfrancis1127
    "I have lived in this neighborhood for over one year and I love it. It is the kind of community would want to raise your family"
    0
    Flag
  • Mfrancis1127
    "I’ve lived in this neighborhood for almost a year and I have gotten to know quite a few of the neighbors. I love the setting and very happy to be here."
    0
    Flag
  • remy e.
    "Union is a lovely little town with the charm of a small community but the convenience of the mall down the road and the city 20 minutes away. Boone County was voted the healthiest county in the state and the Ryle High School District is fantastic."
    0
    Flag
  • Awinitaky
    "Union is a small town but close to big cities. It is central to everything needed and freeway accessible. It is growing very fast out here so traffic is a little congested at peak travel times (week days to and from work) but not enough to discourage moving here. We have beautiful well kept subdivisions in and around Union with great neighbors. Perfect for families who care about their homes."
    0
    Flag

Market trends in Union

Last updated July 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
$464K
$12.48KMoM
Sale-to-List Price
99.2%
0.6%MoM
Price per sq ft
$185
$4MoM
Available listings
130

Home Value

Trulia Estimate
$462K
Since last month
Increased$51K (+12.5%)
Since last year
Increased$6K (+1.2%)
Learn more about this home's value by checking out its Trulia Estimate, the value of nearby homes, and how much similar homes have sold for.

Trulia Estimate

The of this home's value increased by +1% in the last 10 years
MonthEstimated value
2026
September 2026$462K
August 2026$424K
July 2026$411K
June 2026$417K
May 2026$423K
April 2026$417K
March 2026$416K
February 2026$457K

Comparable sales

These are recently sold homes that have a similar location or other similar features to this home, like bedrooms, bathrooms, and square footage. Get a sense of the expected prices in the area by viewing these homes.
Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
2220 Esplanade St #23D, Union, KY
0.04
Townhouse
$434,900
06/26/26
3
3
2,392
9521 La Croisette St, Union, KY
0.01
Townhouse
$462,400
07/07/26
3
3
2,629
2179 Esplanade St, Union, KY
0.01
Townhouse
$469,900
08/11/26
3
3
2,629
2224 Esplanade St, Union, KY
0.05
Townhouse
$415,700
08/11/26
3
3
2,124
2228 Esplanade St, Union, KY
0.05
Townhouse
$440,947
01/16/26
3
3
2,124
9644 Venice St, Union, KY
0.11
Townhouse
$417,500
12/17/25
3
3
2,505
9637 Venice St, Union, KY
0.12
Townhouse
$446,000
05/04/26
3
3
2,392
9651 Soaring Breezes, Union, KY
0.33
Townhouse
$285,000
05/18/26
3
2.5
1,902
9514 Lacroisette St, Union, KY
0.04
Townhouse
$357,500
12/10/25
2
2
1,396
9526 La Croisette St, Union, KY
0.05
Townhouse
$350,416
11/25/25
2
2
1,396

Nearby home prices

Get a sense of expected prices in the area by checking the value of nearby homes.
Address
Distance
Price
Bed
Bath
Sqft
Status
2179 Esplanade St, Union, KY 41091
0.01
$469,900
3
3
2,629
Recently Sold
9521 La Croisette St, Union, KY 41091
0.01
$462,400
3
3
2,629
Recently Sold
9509 La Croisette St, Union, KY 41091
0.01
$439,200
3
3
2,270
Off Market
2183 Esplanade St, Union, KY 41091
0.01
$472,000
3
3
2,657
Off Market
9633 Venice St #19D, Union, KY 41091
0.02
$477,300
3
3
2,629
Off Market
2260 Esplanade St, Union, KY 41091
0.02
$468,700
3
3
2,629
Off Market
9525 La Croisette St, Union, KY 41091
0.03
$437,300
3
3
2,285
Off Market
9526 La Croisette St, Union, KY 41091
0.05
$350,416
2
2
1,396
Recently Sold
9514 La Croisette Steet, Union, KY 41091
0.04
$337,800
2
2
1,396
Off Market
9514 Lacroisette St, Union, KY 41091
0.04
$357,500
2
2
1,396
Recently Sold
9505 La Croisette St, Union, KY 41091
0.05
$429,900
3
3
2,629
Recently Sold

Price and Tax history

DateEventPrice
Jan 31, 2026
Source: Drees Homes
Listed For Sale
$464,900

LGBTQ Local Legal Protections

John Heisler, Drees/Zaring Realty
Agent Phone: (859) 468-9032
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.

Similar Homes You May Like

Skip to last item
Skip to first item

New Listings near 2175 Esplanade St

Skip to last item
Skip to first item

Frequently asked questions about 2175 Esplanade St

  • What is the estimated monthly payment for 2175 Esplanade St?
    Based on a $464,900 list price with 20% down at today's rates, the estimated monthly payment for 2175 Esplanade St in Union, KY is approximately $2,898 (about $2,505 principal & interest, $318 property taxes, and $75 homeowner's insurance). This is an estimate. Actual payment depends on your loan terms.
  • How does the list price for 2175 Esplanade St compare to homes in Union?
    2175 Esplanade St in Union, KY is listed at $464,900. The median sale price in Union is $464K.
  • What do residents say about Union?
    Residents describe Union, KY as dog-friendly, easy to park in, and pedestrian-friendly. See homes for sale in Union, KY.
  • What are the closest schools to 2175 Esplanade St?
    The closest schools to 2175 Esplanade St in Union, KY are Erpenbeck Elementary School (Pre-K, rated 8/10), Larry A. Ryle High School (rated 9/10), Ockerman Middle School (rated 4/10).
  • Does 2175 Esplanade St have air conditioning?
    Yes, 2175 Esplanade St in Union, KY has air conditioning.
  • Does 2175 Esplanade St have laundry facilities?
    Yes, 2175 Esplanade St in Union, KY has laundry facilities.
2175 Esplanade St, Union, KY 41091 is a 3 bedroom, 3 bathroom, 2,253 sqft townhouse built in 2026. This property is currently available for sale and was listed by NKMLS on Feb 5, 2026. The MLS # for this home is MLS# 639679.