Updated Duplex with Full
New
For Sale
$297,500
1221-1223 S ROSETA AVE, Columbia, MO 65201
One residence is vacant after interior updates, while the adjoining unit remains tenant occupied.
Property Size2,264 SF
Price / SF$131.40
Days on Market6
Property Features for 1221-1223 S ROSETA AVE
General Information
Standard status
Active
Size
2,264 SF
Property subtype
Multi-Family
Additional Details
Gross Income
$9,600
Multifamily Units
2
Building Details
Year Built
1986
Buildings
1
Listing Agency:
Weichert, Realtors - House Of Brokers
Listed By:
Russell Boyt Real Estate Group
(573) 510-2050
Source:
Livelovemissouri
Added: Sep 29
Changed: Oct 3
Last Checked: Oct 2 at 7:49PM
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 Weichert, Realtors - House Of Brokers
Investment Insights
Based on property information with market context.
This Columbia duplex contains 2,264 finished square feet across two residences, with six bedrooms and four bathrooms overall. A full basement adds to the property’s existing space. Unit 1221 is vacant and was refreshed with new paint and flooring, kitchen and bath updates, a new HVAC system, and a new water heater. Unit 1223 is tenant occupied and generates $800 per month in rental income.
Built in 1986, the property combines a recently updated vacant residence with an occupied second unit. The two-unit configuration and basement are key physical features of the offering.
Built in 1986, the property combines a recently updated vacant residence with an occupied second unit. The two-unit configuration and basement are key physical features of the offering.
Key Highlights
- 2,264 finished square feet with 6 bedrooms and 4 bathrooms
- Unit 1221 is vacant; updates include paint, flooring, kitchen and baths, HVAC, and water heater
- Unit 1223 is tenant occupied and produces $800/month
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.28%
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
NOI $18,671 @ 7.0% cap · market cap 6.28%
Second Best
Apartment 5plus
$250.1K
$218.9K – $291.8K
NOI $17,510 @ 7.0% cap · market cap 5.89%
Theoretical Best
Warehouse
$351.0K
$307.1K – $409.5K
NOI $24,571 @ 7.0% cap · market cap 8.26%
Zoning and permitted uses should be independently verified with authorities.
Property Analytics
Current Use
Lease Details
2
Residential units
Location Intelligence
Trade Area within ½ mile
68
Businesses Nearby
Explore this area
Business Placement
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
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 - One residence is vacant after interior updates, while the adjoining unit remains tenant occupied.
Where is this duplex located?
The property is located at 1221-1223 S ROSETA AVE Columbia, MO.
What is the asking price?
The asking price for this property is $297,500.
What are key features of this property?
This property features: 2,264 finished square feet with 6 bedrooms and 4 bathrooms; Unit 1221 is vacant; updates include paint, flooring, kitchen and baths, HVAC, and water heater; Unit 1223 is tenant occupied and produces $800/month
