Search
Two-Unit Duplex
New
For Sale
$280,000

1201-03 S ROSETA AVE, Columbia, MO 65201

Built in 1986, the property offers an established residential income configuration with leases extending into 2027.

Property Size2,264 SF
Price / SF$123.67
Days on Market7

Property Features for 1201-03 S ROSETA AVE

General Information

Standard status Active
Size 2,264 SF
Property subtype Multi-Family

Building Details

Year Built 1986
Listing Agency: Iron Gate Real Estate
Listed By: Teresa Gomez
Source: Heartlandnetwork-midmo
Added: Sep 16 Changed: Sep 21 Last Checked: Sep 21 at 6:10AM

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 Iron Gate Real Estate

Investment Insights

Based on property information with market context.

The duplex contains 2,264 square feet and was built in 1986. It is configured as two residences at 1201-03 S ROSETA AVE. Both units are currently leased, with the 1201 lease running through April 2027 and the 1203 lease continuing through October 2027. The 1203 unit also includes a washer/dryer lease, providing an additional existing lease component within the property.

Key Highlights

  • Two‑unit duplex at 1201‑03 S ROSETA AVE, Columbia, MO 65201
  • 2264 SF property built in 1986
  • Both units are fully rented

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
$18,671
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
6.67%
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%
$373,420 $373.4K
Cap Rate 7%
$266,729 $266.7K
Cap Rate 9%
$207,456 $207.5K
Market Conditions
NOI Build-Up for 2,264 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
$28.5K $12.60/SF
− Vacancy
−$1.9K −$0.82/SF
EGI
$26.7K $11.78/SF
− OpEx
−$8.0K −$3.53/SF
NOI
$18.7K $8.25/SF
Area
Columbia, MO
Vacancy
6.50%
Lease Rate
$12.60 /SF/Yr
Expense Ratio
30.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%
$373,420
Cap Rate 7%
$266,729
Cap Rate 9%
$207,456

Alternative Uses

Best Use
Multifamily LT 5
$266.7K
$233.4K – $311.2K (±1% cap)
NOI $18,671 @ 7.0% cap · market cap 6.67%
Second Best
Apartment 5plus
$250.1K
$218.9K – $291.8K (±1% cap)
NOI $17,510 @ 7.0% cap · market cap 6.25%
Theoretical Best
Warehouse
$351.0K
$307.1K – $409.5K (±1% cap)
NOI $24,571 @ 7.0% cap · market cap 8.78%
Zoning and permitted uses should be independently verified with authorities.

Property Analytics

Current Use

Duplexes

Suggested Use

Top Pick Electrical Service Bakery Storage Facility (Bike/Boat/Book/etc) Store Big Box & Wholesale Store Home Appliance Store

Score = modeled unmet demand for each use within ~1 mi (higher = bigger opportunity). Zoning and permitted uses should be independently verified with local authorities.

Location Intelligence

Trade Area within ½ mile

68
Businesses Nearby

Demographics for 65201, MO

48,734
Population
21,239
Households
2.3
Avg Household Size
26
Median Age
54%
College-Educated
95%
High-School Grad
87.4 sq mi
ZIP Area
558
Density / Sq Mi
$46,177
Median Household Income
$18,709
Median Earnings
$1,078
Median Rent
$229,300
Median Home Value

Market

Vacancy Rate% for Multifamily in Midwest region

6.5% 2022
7.5% 2023
7.8% 2024
8% 2025
Rey
Questions? Ask Rey
Realmo’s AI knows this listing — price, zoning, demand, history. Ask anything.

Frequently Asked Questions

What type of property is this?
Duplex - Built in 1986, the property offers an established residential income configuration with leases extending into 2027.
Where is this duplex located?
The property is located at 1201-03 S ROSETA AVE Columbia, MO.
What is the asking price?
The asking price for this property is $280,000.
What are key features of this property?
This property features: Two‑unit duplex at 1201‑03 S ROSETA AVE, Columbia, MO 65201; 2264 SF property built in 1986; Both units are fully rented
More about this property
Thanks! Your message was sent.
Error! Your message wasn't sent.
Please enter your name
Please enter email
Please enter the email in the correct format
Please enter phone
Please enter the number in the correct format
Please enter message