New Construction
New Construction
Description
Discover the Brandywine II, a luxurious ranch townhome. Upon entering the home, view a wide open dining area, well-equipped kitchen with serving island and family room. A covered deck off the family room lets you expand your living space to the outdoors. A secluded primary suite will be your private oasis with its luxury bath with walk-in shower and sizable walk-in closet. A second bedroom with adjacent full bath on the first floor is perfect for overnight guests. From the garage entrance into the...Discover the Brandywine II, a luxurious ranch townhome. Upon entering the home, view a wide open dining area, well-equipped kitchen with serving island and family room. A covered deck off the family room lets you expand your living space to the outdoors. A secluded primary suite will be your private oasis with its luxury bath with walk-in shower and sizable walk-in closet. A second bedroom with adjacent full bath on the first floor is perfect for overnight guests. From the garage entrance into the home, you'll appreciate the family foyer, which offers a great space for doing laundry and for storing your personal items. A finished lower level offers a recreation room opening to a covered patio, a bedroom and a full bath. Enjoy the convenience of walking to shopping, dining, and entertainment, all while living in the award-winning Boone County School District.
- Listed by John Heisler • Drees/Zaring RealtyP: (859)-468-9032 C: (859)-468-9032 jheisler@dreeshomes.com
Property Details for 2244 Esplanade Street
Architectural Style
Traditional
Zoning DescriptionResidential
Subdivision NameUnion Promenade
LISTING UPDATED: 07/09/2026 11:38 AM
Property Details for 2244 Esplanade Street
| Status | Active |
|---|---|
| MLS # | 644467 |
| Days on Market | 6 |
| Taxes | - |
| HOA Fees | $275 / month |
| Condo/Co-op Fees | - |
| Property Type | Townhouse |
| MLS Type | Residential / Townhouse |
| Year Built | 2026 |
| Lot Size | - |
| County | Boone County |
Location
Listing Courtesy of Drees/Zaring Realty
Add your commute
Building Information for 2244 Esplanade Street
Stories-Residences-Year Built2026Lot Size-
Payment Calculator
$2,492 per month
30 year fixed, 6.36% Interest
Principal and Interest
$2,217
Property Taxes
$0
HOA Dues
$275
The Payment Calculator is for illustrative purposes only.
Know your buying power with a preapproval and custom rate in minutes
1Property Information for 2244 Esplanade Street
Summary
Location and General Information
- Longitude: -84.679455
- Latitude: 38.955857
- Directions: I-71/75 to south on Rt. 42 (Florence exit), to right on Children's Way, to right on Venice Street, to right on Esplanade Street.
- MLSArea Major: K11 - Richwd/Un/Wal/Ver/SB
- MLSArea Minor: K11 - Richwd/Un/Wal/Ver/SB
- Year Built Known: Yes
- No Disclosure Type: New Construction
- Property Condition Disclosure: No
- SIC: UN - Union- Boone Cty
Taxes and HOA
- Association Fee Includes: Maintenance Grounds, Snow Removal, Maintenance Structure, Insurance
- Association: Yes
- Association Fee Frequency: Monthly
- Association Fee: $275
- Total Yearly Fees: $3,300.00
- Degree Complete: New Construction
- Tax Rate: $13.12
School Information
- High School District: Boone Co Public
- Elementary School: Erpenbeck Elementary
- Middle Or Junior School: Ockerman Middle School
- High School: Ryle High
Parking
- Parking Features: Attached, Driveway, Garage Faces Front, Garage Door Opener, Garage
- Attached Garage: Yes
- Garage: Yes
- Parking Total: 2.0
- Garage Spaces: 2.0
Property
Lot Information
- Lot Size Source: Builder
- Lot Size Dimensions: Irregular
Property and Assessments
- New Construction: Yes
- Year Built: 2026
- Building Area Total: 2124.0
- Property Condition: New Construction
- Living Area Source: Builder
- Property Attached: Yes
Building Features
- Levels: One
- Structure Type: Multi Family
- Foundation Details: Poured Concrete
- Construction Materials: Brick, Cedar, Stone, Vinyl Siding, Hardi Plank Type
Utilities
- Utilities: Cable Available, Natural Gas Available, Water Available, Sewer Available
- Sewer: Public Sewer
- Water Source: Public
- Gas Company: Duke Energy
- Electric Company: Duke Energy
- Water Company: Boone County Water
- Sanitation Company: Sanitation District No. 1
Interior and Exterior Features
Interior Features
- Bathrooms: 3
- Appliances: Disposal, Dishwasher, Microwave, Gas Range, Stainless Steel Appliance(s)
- Cooling: Central Air
- Security Features: Smoke Detector(s), Security System
- Fireplace: No
- Window Features: Vinyl Frames
- Has Heating: Yes
- Has Cooling: Yes
- Basement: Full, Walk-Out Access, Finished, Storage Space
- Interior Features: Recessed Lighting, High Ceilings, Wired for Data, Double Vanity, Entrance Foyer, Kitchen Island, Open Floorplan, Pantry, Smart Thermostat, Stone Counters, Storage, Walk-In Closet(s), Wet Bar
- Rooms Total: 12
- Heating: Heat Pump, Hot Water, Natural Gas
Exterior Features
- Patio And Porch Features: Deck, Porch, Patio, Covered
- Association Amenities: Landscaping
- Roof: Shingle
Room Information
Room 1
- Room Type: Entry
- Room Length: 7.0
- Room Level: First
- Room Width: 4.0
- Room Dimensions: 7 x 4
- Room Description: 9' smooth ceiling; LVP flooring; bench
Room 2
- Room Type: Family Room
- Room Length: 16.0
- Room Level: First
- Room Width: 14.0
- Room Dimensions: 16 x 14
- Room Description: 9' ceiling; LVP flooring
Room 3
- Room Type: Dining Room
- Room Length: 16.0
- Room Level: First
- Room Width: 9.0
- Room Dimensions: 16 x 9
- Room Description: 9' ceiling; LVP flooring
Room 4
- Room Type: Kitchen
- Room Length: 16.0
- Room Level: First
- Room Width: 11.0
- Room Dimensions: 16 x 11
- Room Description: 9' ceiling; large island; LVP flooring; quartz counters; w/i pantry; SS appliances
Room 5
- Room Type: Laundry
- Room Length: 11.0
- Room Level: First
- Room Width: 5.0
- Room Dimensions: 11 x 5
- Room Description: LVP flooring
Room 6
- Room Type: Primary Bedroom
- Room Length: 14.0
- Room Level: First
- Room Width: 13.0
- Room Dimensions: 14 x 13
- Room Description: 9' ceiling; carpet; w/i closet; adjoining bath
Room 7
- Room Type: Bedroom 2
- Room Length: 11.0
- Room Level: First
- Room Width: 10.0
- Room Dimensions: 11 x 10
- Room Description: 9' ceiling; carpet; large closet; French doors
Room 8
- Room Type: Primary Bath
- Room Length: 12.0
- Room Level: First
- Room Width: 9.0
- Room Dimensions: 12 x 9
- Room Description: 9' ceiling; double bowl vanity; quartz counters; tall vanity; comfort height commode; w/i shower with tile surround
Room 9
- Room Type: Bathroom 2
- Room Length: 7.0
- Room Level: First
- Room Width: 5.0
- Room Dimensions: 7 x 5
- Room Description: 9' ceiling; quartz counters; tall vanity; tub/shower combo; comfort height commode
Room 10
- Room Type: Bedroom 3
- Room Length: 12.0
- Room Level: Lower
- Room Width: 12.0
- Room Dimensions: 12 x 12
- Room Description: 9' ceiling; carpet; w/i closet
Room 11
- Room Type: Bathroom 3
- Room Length: 8.0
- Room Level: Lower
- Room Width: 5.0
- Room Dimensions: 8 x 5
- Room Description: Quartz counters; LVP flooring; w/i shower
Room 12
- Room Type: Recreation Room
- Room Length: 24.0
- Room Level: Lower
- Room Width: 15.0
- Room Dimensions: 24 x 15
- Room Description: 9' ceiling; carpet; wet bar; walkout to covered patio
Property History for 2244 Esplanade Street
| Date | Event & Source | Price | Appreciation |
|---|---|---|---|
| Jul 9, 2026 | Listed (Active) Northern Kentucky Multiple Listing Service #644467 | $444,900 | — |
| Date | Event & Source | Price |
|---|---|---|
| 07/09/2026 | Listed (Active) Northern Kentucky Multiple Listing Service #644467 | $444,900 |
For completeness, we often displays two records for one sale: the MLS record and the public record.
Schools near 2244 Esplanade Street
This home is within Boone County.
Rating | School | Type | Grades | Distance |
|---|---|---|---|---|
| Public - | PK to 5 | |||
| Public - | 6 to 8 | |||
| Public - | 9 to 12 | |||
| Public - | 6 to 12 |
Rating | School | Distance |
|---|---|---|
Erpenbeck Elementary School PublicPK to 5 | ||
Ockerman Middle School Public6 to 8 | ||
Larry A. Ryle High School Public9 to 12 | ||
RISE Academy Public6 to 12 |
School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.
Similar Homes
Explore Nearby Homes
- Hampshire Homes for Sale
- Pleasant Valley Homes for Sale
- Posey Township - Switzerland County Homes for Sale
- Rabbit Hash Homes for Sale
- Randolph Township - Ohio County Homes for Sale
- Devon Homes for Sale
- Belleview Homes for Sale
- Oakbrook Homes for Sale
- Hopeful Heights Homes for Sale
- Central Florence Homes for Sale
- Elsmere Homes for Sale
- Cotton Township - Switzerland County Homes for Sale
- Cass Township - Ohio County Homes for Sale
- Union Township - Ohio County Homes for Sale
- York Township - Switzerland County Homes for Sale
- Union Homes for Sale
- Rising Sun Homes for Sale
- Florence Homes for Sale
- Burlington Homes for Sale
- Independence Homes for Sale
- Walton Homes for Sale
- Patriot Homes for Sale
- Verona Homes for Sale
- Hebron Homes for Sale
- Erlanger Homes for Sale
- Bennington Homes for Sale
- Petersburg Homes for Sale
- Latonia Homes for Sale
- Covington Homes for Sale
- Aurora Homes for Sale
- 41094 Homes for Sale
- 47040 Homes for Sale
- 47038 Homes for Sale
- 41092 Homes for Sale
- 41095 Homes for Sale
- 41005 Homes for Sale
- 41042 Homes for Sale
- 47001 Homes for Sale
- 41051 Homes for Sale
- 41080 Homes for Sale
- 41018 Homes for Sale
- 41048 Homes for Sale
- 47011 Homes for Sale
- 41030 Homes for Sale
- 47020 Homes for Sale
No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.
Listing Courtesy of Drees/Zaring Realty
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 Compass and its related brokerages 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.
