Search
Updated Duplex with Full Basement

1221-1223 S ROSETA AVE, Columbia, MO 65201

For Sale
$297,500

One residence is vacant after interior updates, while the adjoining unit remains tenant occupied.

Property Size2,264 SF
Lot Size0.37 Acres
Price / SF$131.40
Days on Market53

Property Features for 1221-1223 S ROSETA AVE

General Information

Standard status Active
Size 2,264 SF
Lot size 0.37 Acres
Property subtype Multi-Family

Additional Details

Gross Income $9,600
Multifamily Units 2

Building Details

Year Built 1986
Buildings 1
Listing Agency: Berkshire Hathaway Homeservices | Vision Real Estate
Listed By: Russell Boyt Real Estate Group
Source: Livelovemissouri
Added: Sep 29 Changed: Nov 18 Last Checked: Nov 18 at 8:47AM

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 Berkshire Hathaway Homeservices | Vision Real Estate

Rey
Ask AI about this property
Review the available facts, identify missing information and prepare questions for the agent.

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.

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 / Yr
$18,671
Cap Rate
6.28%
Suggested Prices Based on Cap Rates
Cap Rate 5%
$373,420 $373.4K
Cap Rate 7%
$266,729 $266.7K
Cap Rate 9%
$207,456 $207.5K
NOI Build-Up for 2,264 SF
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)
Market Conditions
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 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.28%
Second Best
Apartment 5plus
$250.1K
$218.9K – $291.8K (±1% cap)
NOI $17,510 @ 7.0% cap · market cap 5.89%
Theoretical Best
Warehouse
$351.0K
$307.1K – $409.5K (±1% cap)
NOI $24,571 @ 7.0% cap · market cap 8.26%
Zoning and permitted uses should be independently verified with authorities. How Realmo checks its estimates

Property Analytics

Lease Details

2
Residential units

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

Properties on Market for Duplexes in Columbia

Jul
Aug
Sep
Oct

Vacancy Rate% for Multifamily in Midwest region

6.5% 2022
7.5% 2023
7.8% 2024
8% 2025

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
Research This Page with AI

Rey answers here. ChatGPT, Grok and Claude get the same data packet.

Includes: Price & PSF · Cap rate · Location · Zoning

Ask Rey → ChatGPT Grok Claude
Preferred Make Realmo a preferred source.

Our comps and market reports get this label in your Google results.

Add as a preferred source on Google One click on Google
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
Why this one?
Why hide this one?