$459,900
 $3,060 est/mo Sourced by Back At You

2175 Esplanade Street,Union, KY 41091

Union, KY 41091

Share:

PreviousNext

Description

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.

Details

MLS #639679
Listing TypeFor Sale
StyleTown House
HOA Dues$245
Sub-TypeResale
StatusActive
Year2026
Days On Site249
Listing Provided ByDrees/Zaring Realty | John Heisler

Features

Bed(s)3
Bath(s) 3 Total
SQ Feet2,253
Garage2
BasementY
Story(s)1
ZoningResidential

Area Information

StateKY
CountyBoone
CityUnion
Zip Code41091
AreaK11 Richwd | Un | Wal | Ver | SB
SubareaRichwd | Un | Wal | Ver | SB
Community NameOther
School DistrictBoone Co Public
Elementary SchoolErpenbeck Elementary
High SchoolBoone Co Public
Listing VS Median (in Other)
Price:
$459,900
low | high
Med:
$442,400
53.805175038052% of Average
sqft:
2,253
low | high
Med:
2,374
44.629383044829% of Average
$ / sqft:
$204
low | high
Med:
$187
58.555217915901% of Average
On site:
249
low | high
Med:
199
100% of Average
Sourced by Back At You

Market Activity 41091

Request a showing

Request a showing

Contact

Additional Information

Showing Information

Submit Form

Required Field
By submitting, you agree to receive promotional texts and/or calls from e-Merge Real Estate at the number provided. Message/data rates may apply. Consent is not a condition of purchase, and you can opt out anytime by replying STOP.
The information is being provided by Northern Kentucky MLS. Information deemed accurate but not guaranteed. Information is provided for consumers personal, non-commercial use, and may not be used for any purpose other than the identification of potential properties for purchase. Copyright 2026 Northern Kentucky MLS. All Rights Reserved.

Contact

Learn More About This Property

Carter Dominy

Carter Dominy

e-Merge Real Estate Champions

 (419) 565-9629carter.dominy@e-merge.com
StateKY
CountyBoone
CityUnion
Zip Code41091
AreaK11 Richwd | Un | Wal | Ver | SB
SubareaRichwd | Un | Wal | Ver | SB
Community NameOther
School DistrictBoone Co Public
Elementary SchoolErpenbeck Elementary
High SchoolBoone Co Public
Listing VS Median (in Other)
Price:
$459,900
low | high
Med:
$442,400
53.805175038052% of Average
sqft:
2,253
low | high
Med:
2,374
44.629383044829% of Average
$ / sqft:
$204
low | high
Med:
$187
58.555217915901% of Average
On site:
249
low | high
Med:
199
100% of Average
Sourced by Back At You
Nearby Listings (Within 1/10 mile)
Price: $344K - $574K
sqft: 1,500 - 2,500
Nearby Listings Property ImageNearby Listings Details
9525 La Croisette Property Photo 1
$439,900
9525 La Croisette
Union, KY 41091
2244 Esplanade Street Property Photo 1
$444,900
2244 Esplanade Street
Union, KY 41091
Listing Updated: October 1, 2026 at 9:47:41 AM PDT
Carter Dominy
(419) 565-9629
e-Merge Real Estate Champions Mansfield - 104 S Main St.
Mansfield, OH 44902

Carter Dominy - e-Merge Real Estate Champions Mansfield - e-Merge Real Estate