Mixed-Use Apartment
For Sale
$1,590,000
207 E Main St, New Albany, IN 47150
For-sale mixed-use property with apartment units and first-floor restaurant space, available by appointment with notice.
Property Size9,552 SF
Price / SF$166.46
Days on Market109
Property Features for 207 E Main St
General Information
Standard status
Active
Size
9,552 SF
Property subtype
Hospitality
Zoning
C-2
Listing Agency:
Coldwell Banker McMahan
Listed By:
Paul Kiger · License #RB14035922
(502) 314-6748
Source:
Kcrea.resimplifi
Added: May 24
Changed: Sep 8
Last Checked: Sep 9 at 6:19AM
Displayed information is deemed reliable but is not guaranteed and should be independently verified. All listing content including descriptions, pricing, images are the copyrighted material of Coldwell Banker McMahan
Investment Insights
Based on property information with market context.
This for-sale mixed-use property includes apartment units and first-floor restaurant space. The building is designed to support both residential occupancy and street-level commercial use, giving an operator or buyer a practical blend of uses within the same asset.
Located at 207 East Main Street in New Albany, Indiana, the property offers convenient access to the restaurant space for retail or food service activity. Showings require minimum 24 hours’ notice for the apartment portion, and the first-floor restaurant space is available to tour by appointment.
For tenants, the residential component can serve households seeking an apartment setting, while the commercial component is positioned for a restaurant operator that wants a dedicated ground-floor presence. For buyers, the combined residential and restaurant layout may appeal to those looking for a single ownership structure that encompasses both income-generating uses. The viewing requirements should be planned around the 24-hour notice needed for apartments and appointment scheduling for the restaurant space.
Located at 207 East Main Street in New Albany, Indiana, the property offers convenient access to the restaurant space for retail or food service activity. Showings require minimum 24 hours’ notice for the apartment portion, and the first-floor restaurant space is available to tour by appointment.
For tenants, the residential component can serve households seeking an apartment setting, while the commercial component is positioned for a restaurant operator that wants a dedicated ground-floor presence. For buyers, the combined residential and restaurant layout may appeal to those looking for a single ownership structure that encompasses both income-generating uses. The viewing requirements should be planned around the 24-hour notice needed for apartments and appointment scheduling for the restaurant space.
Key Highlights
- Mixed‑use property with apartment units and first‑floor restaurant space
- 1st‑floor restaurant space available by appointment
- Minimum 24 hours notice required for apartment showings
Financial Insights
Estimated NOI and Cap Rate
NOI = area × lease_rate × (100 − vacancy) / 100 × (1 − expense_ratio). Net Operating Income — what the owner takes home each year before mortgage payments and income tax. Effective rent (asking rent minus vacancy losses) minus operating costs (taxes, insurance, maintenance, management).
NOI / Yr
$67,642
Cap rate = NOI / list price × 100. Capitalization rate — annual return on a fully cash purchase, before financing. NOI divided by price. Higher means more income per dollar invested, but usually also more risk or older condition. 5–8% is typical for stabilized commercial property; double digits often signal distressed deals.
Cap Rate
4.25%
Suggested Prices Based on Cap Rates
Cap rates vary significantly by property type, market, and asset quality.
Typical U.S. stable-market ranges:
Multifamily — 4.5% to 6.5% (Class A in primary markets often sub-5%; Class C in secondary markets 6%+)
Industrial / Logistics — 5.0% to 7.0% (compressed heavily in recent years due to e-commerce demand)
Office — 6.5% to 9%+ (wide spread post-2020; CBD Class A vs. suburban Class B varies dramatically)
Retail — 5.5% to 8.5% (grocery-anchored on the low end, unanchored strip centers higher)
Hospitality / Hotels — 7.5% to 10%+ (higher due to operational risk)
Self-Storage — 5.5% to 7.5%
Medical Office — 6.0% to 7.5%
Net Lease (single tenant, credit) — 5.0% to 7.0% depending on tenant credit and lease term
Rules of thumb:
Primary markets (NYC, SF, LA, Boston, DC) trade at lower cap rates than secondary/tertiary markets, often by 100–200 bps (bps, aka basis points; 1 bp = 0.01%).
Class A assets trade ~50–150 bps tighter than Class B, and Class B tighter than Class C.
Cap rates move inversely with price — a lower cap rate means a higher price for the same NOI.
Spread to the 10-year Treasury is a common benchmark; historically 200–400 bps over the 10-year.
Cap Rate 5%
$1,352,840
$1.4M
Cap Rate 7%
$966,314
$966.3K
Cap Rate 9%
$751,578
$751.6K
Market Conditions
NOI Build-Up for 9,552 SF
Vacancy — income lost from leasable area expected to sit empty during the year, subtracted from gross rent.
EGI (Effective Gross Income) — gross rent minus vacancy losses, the realistic income before paying operating costs.
OpEx (Operating Expenses) — recurring costs to operate the property (property tax, insurance, utilities, maintenance, management); excludes financing and capital improvements.
NOI (Net Operating Income) — income a property generates after operating costs but before financing and taxes.
Gross rent
$131.8K $13.80/SF
− Vacancy
−$8.8K −$0.92/SF
EGI
$123.0K $12.88/SF
− OpEx
−$55.3K −$5.79/SF
NOI
$67.6K $7.08/SF
Area
Floyd County, IN
Vacancy
6.70%
Lease Rate
$13.80 /SF/Yr
Expense Ratio
45.00%
Simulate Cap Rate and NOI
Suggested Prices Based on Cap Rates
Cap rates vary significantly by property type, market, and asset quality.
Typical U.S. stable-market ranges:
Multifamily — 4.5% to 6.5% (Class A in primary markets often sub-5%; Class C in secondary markets 6%+)
Industrial / Logistics — 5.0% to 7.0% (compressed heavily in recent years due to e-commerce demand)
Office — 6.5% to 9%+ (wide spread post-2020; CBD Class A vs. suburban Class B varies dramatically)
Retail — 5.5% to 8.5% (grocery-anchored on the low end, unanchored strip centers higher)
Hospitality / Hotels — 7.5% to 10%+ (higher due to operational risk)
Self-Storage — 5.5% to 7.5%
Medical Office — 6.0% to 7.5%
Net Lease (single tenant, credit) — 5.0% to 7.0% depending on tenant credit and lease term
Rules of thumb:
Primary markets (NYC, SF, LA, Boston, DC) trade at lower cap rates than secondary/tertiary markets, often by 100–200 bps (bps, aka basis points; 1 bp = 0.01%).
Class A assets trade ~50–150 bps tighter than Class B, and Class B tighter than Class C.
Cap rates move inversely with price — a lower cap rate means a higher price for the same NOI.
Spread to the 10-year Treasury is a common benchmark; historically 200–400 bps over the 10-year.
Cap Rate 5%
$1,352,840
Cap Rate 7%
$966,314
Cap Rate 9%
$751,578
Alternative Uses
Best Use
Specialty Retail
$6.90M
$6.04M – $8.05M
NOI $483,299 @ 7.0% cap · market cap 30.40%
Second Best
Apartment 5plus
$966.3K
$845.5K – $1.13M
NOI $67,642 @ 7.0% cap · market cap 4.25%
Theoretical Best
—
—
same as Best Use
Zoning and permitted uses should be independently verified with authorities.
Property Analytics
Unlock full access to Insights
Subscribe to Realmo Intelligence
Open Analytics
Current Use
Location Intelligence
Trade Area within ½ mile
1,113
Businesses Nearby
Explore this area
Business Placement
Demographics for 47150, IN
49,395
Population
22,834
Households
2.2
Avg Household Size
39
Median Age
26%
College-Educated
91%
High-School Grad
45.0 sq mi
ZIP Area
1,098
Density / Sq Mi
$62,212
Median Household Income
$40,837
Median Earnings
$984
Median Rent
$191,800
Median Home Value
Check the figures for this property
Cap Rate, Value Estimation, Potential NOI and more
View Realmo Analytics
Market
Vacancy Rate% for Multifamily in Midwest region
Questions? Ask Rey
Realmo’s AI knows this listing — price, zoning, demand, history. Ask anything.
Frequently Asked Questions
What type of property is this?
Apartment building - For-sale mixed-use property with apartment units and first-floor restaurant space, available by appointment with notice.
Where is this apartment building located?
The property is located at 207 E Main St New Albany, IN.
What is the asking price?
The asking price for this property is $1,590,000.
What are key features of this property?
This property features: Mixed‑use property with apartment units and first‑floor restaurant space; 1st‑floor restaurant space available by appointment; Minimum 24 hours notice required for apartment showings
