2175 Esplanade StUnionKY41091
INVESTMENT ANALYSIS
Investment Verdict
Steady Equity BuilderSteady, low-maintenance, and fundable: 2175 Esplanade St, Union, KY, 41091 in Union at $464,900. Rental yield 7.14%. The 7.14% yield and 1.32 DSCR put this right in the range Ziffy Mortgage approves for non-U.S. investors without W-2s or domestic credit. Appreciation at 5%/yr is projected to add $128,443 by year five, and $4,282/yr in principal reduction steadily grows the investor's stake. Total projected cumulative return: $157,257.
| This Property | City Avg | |
|---|---|---|
| Gross Rental Yield | 7.1% | 5.1% |
| Monthly Cash Flow | $(310) | $285 |
City averages based on Union market data in our database. Property projections are estimates.
DSCR Loan Qualification
| Monthly Rental Income | $2,765 |
| Total Monthly Debt Service | $2,889 |
| DSCR Ratio | 0.96x |
Ziffy Mortgage typically prefers a DSCR of 1.0+, but in some cases you may qualify with a DSCR below 1. To explore if this deal qualifies for an investment mortgage, book time with your loan officer →
Estimates assume 6.0% rate / 30-yr fixed, 30% down, 1% tax, 0.5% insurance. Not a commitment to lend.
Townhouse
Built in 2026
N/A lot
$N/A/sqft
$245 monthly HOA
Neighborhood Data
Neighborhood data shown for ZIP Code: 41091, Union, KY area.
Housing Distribution
Housing Statistics
| Category | Value |
|---|---|
| Total HU (Housing Units) | 9,118 (100%) |
| Owner Occupied HU | 7,864 (86.2%) |
| Renter Occupied HU | 821 ( 9.0%) |
| Vacant Housing Units | 433 ( 4.7%) |
| Median Home Value | $410,432 |
| Average Home Value | $452,431 |
Housing Distribution
Address Breakdown
Residential
9,443
Single Family
9,443
Multi-Family
0
Businesses
277
Nearby investment properties with comparable rents
Nearby investment properties with comparable prices
Ziffy AI Summary
A quick, investor-focused snapshot highlighting income strength, yield potential.
| Key metrics | Value |
|---|---|
| Price | $399,900 |
| Est. Rent | $3,200/mo |
| ROI | 18% |
- Attractive rent-to-price ratio for income stability
- Good fit for DSCR financing with healthy coverage
Townhouse
Built in 2026
N/A lot
$N/A/sqft
$245 monthly HOA
Neighborhood Data
Neighborhood data shown for ZIP Code: 41091, Union, KY area.
Housing Distribution
Housing Statistics
| Category | Value |
|---|---|
| Total HU (Housing Units) | 9,118 (100%) |
| Owner Occupied HU | 7,864 (86.2%) |
| Renter Occupied HU | 821 ( 9.0%) |
| Vacant Housing Units | 433 ( 4.7%) |
| Median Home Value | $410,432 |
| Average Home Value | $452,431 |
Housing Distribution
Address Breakdown
Residential
9,443
Single Family
9,443
Multi-Family
0
Businesses
277
Nearby investment properties with comparable rents
Nearby investment properties with comparable prices
Listed by: John Heisler • Drees/Zaring Realty
Mls Name: NKMLS
Mls Provider:
Mls ID: #639679
Disclaimer: 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.