Property photo 1
Property photo 2
Property photo 3
Property photo 4
Property photo 5
0 Baths
2,264 sqft

$297,500

1221-1223 S ROSETA AVE, COLUMBIA MO, 65201

Price per sqft$131.40
Built in1986
Property size2,264 sqft
Property typeMulti-family

Overview

Active

Listed Sep 28, 2026

Updated 4 days ago

Live in one side and let the other help pay the mortgage! This 6-bedroom, 4-bath Columbia duplex offers 2,264 finished sq ft and a fantastic opportunity for an owner-occupant or investor. Unit 1221 is vacant and move-in ready following an extensive refresh with new paint and flooring, updated kitchen and baths, plus new HVAC and water heater. Unit 1223 is tenant occupied and currently producing $800/month in rental income. Move into the renovated side while collecting rent next door, or add a versatile income-producing property to your portfolio. With a full basement, spacious floor plan and immediate income already in place, this property offers a compelling combination of updated living space, flexibility and investment potential.

$1,979/mo

Est. mortgage payment based on a $297,500 home price.

All estimates are provided by Luxury Presence for informational purposes only. Actual amounts may vary.

Additional information

MLS® ID
437596

Interior Features

Bathrooms
0
Cooling
Yes
Heating
Yes
Basement
Yes

Exterior Features

Lot Size
0.37 Acres

Other Property Details

Taxes
$1,932
Tax Frequency
Annually
Garage
Yes
MLS provider logo

Listed by Sean Moore with REMAX Boone Realty
Listing Contact: 573-424-7420 

The IDX display contains information sourced from the Columbia Board Of REALTORS® as of 10/9/2026. This data is intended solely for personal, non-commercial use and is not to be utilized for any other purposes except to identify potential properties for purchase. Although the MLS data displayed is typically considered reliable, it is not guaranteed to be accurate by the MLS. Buyers are responsible for verifying the accuracy of all information and are advised to conduct their own investigations or seek professional assistance. Other sources besides the Listing Agent may have contributed to the MLS data presented. Unless expressly specified in writing, the Broker/Agent has not confirmed any information obtained from external sources. The Broker/Agent may or may not have acted as the Listing and/or Selling Agent and cannot guarantee the accuracy of property locations displayed on any map. Any compensation offers are solely made to participants of the MLS where the listing is registered.

©2026 Columbia Board Of REALTORS® all rights reserved.

Data last updated on 10/9/2026 at 2:40 AM UTC

Powered by Luxury Presence