5540 N Willow AveColumbia CityIN46725
INVESTMENT ANALYSIS
Investment Verdict
Solid IncomeSolid, durable, and financeable, 5540 N Willow Ave, Columbia City, IN, 46725 in Columbia City earns a 8.5% gross yield at $289,900. Rent of $2,053/mo nets $313/mo after the $1,304/mo mortgage. The 1.57 DSCR signals clean DSCR underwriting through Ziffy Mortgage, with no personal income verification required. Five-year value growth of $80,094 and $2,670/yr in equity accumulation project a total cumulative return of $129,804.
| This Property | City Avg | |
|---|---|---|
| Gross Rental Yield | 8.5% | 6.0% |
| Monthly Cash Flow | $313 | $150 |
City averages based on Columbia City market data in our database. Property projections are estimates.
DSCR Loan Qualification
| Monthly Rental Income | $2,053 |
| Total Monthly Debt Service | $1,625 |
| DSCR Ratio | 1.26x |
Ziffy Mortgage: Your DSCR most likely meets our 1.0+ requirement, so you'll most probably qualify for our standard DSCR investment loan program. To pre-qualify, 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.
Single Family
Built in 1890
5,662 sqft lot
$N/A/sqft
No HOA
Neighborhood Data
Neighborhood data shown for ZIP Code: 46725, Columbia City, IN area.
Housing Distribution
Housing Statistics
| Category | Value |
|---|---|
| Total HU (Housing Units) | 11,000 (100%) |
| Owner Occupied HU | 8,209 (74.6%) |
| Renter Occupied HU | 2,037 (18.5%) |
| Vacant Housing Units | 754 ( 6.9%) |
| Median Home Value | $235,679 |
| Average Home Value | $280,163 |
Housing Distribution
Address Breakdown
Residential
10,474
Single Family
10,069
Multi-Family
405
Businesses
694
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
Single Family
Built in 1890
5,662 sqft lot
$N/A/sqft
No HOA
Neighborhood Data
Neighborhood data shown for ZIP Code: 46725, Columbia City, IN area.
Housing Distribution
Housing Statistics
| Category | Value |
|---|---|
| Total HU (Housing Units) | 11,000 (100%) |
| Owner Occupied HU | 8,209 (74.6%) |
| Renter Occupied HU | 2,037 (18.5%) |
| Vacant Housing Units | 754 ( 6.9%) |
| Median Home Value | $235,679 |
| Average Home Value | $280,163 |
Housing Distribution
Address Breakdown
Residential
10,474
Single Family
10,069
Multi-Family
405
Businesses
694
Nearby investment properties with comparable rents
Nearby investment properties with comparable prices
Listed by: Gregory H Brown • CENTURY 21 Bradley Realty, Inc
Mls Name: IRMLS
Mls ID: #202548292