Property Info

1221-1223 S ROSETA AVE, COLUMBIA, MO 65201

$297,500
Property Type: Income Square Footage: 2,264 Lot Size (sq. ft.): 16,283 Status: Active
Current Price: $297,500 List Date: 9/28/2026 Last Modified: 10/15/2026

Overview

Description

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 1223 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 1221 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.

Listing Details MLS# 437596

Location, Tax & Legal

Area
Boone Southeast
Street No #
1221-1223
Street Direction
S
Street
ROSETA
Street Suffix
AVE
County
Boone
State/Province
MO
Zip Code
65201
Subdivision
NEW HAVENS MEADOW
Mapping ID #
1751016020090001

General Property Description

Type
Duplex
Totl Grs Mo Rent
800
Year Built
1986
Age Description
41-50 Yrs
Lot Size Dimensions
121.84 x 133.64
# of Acres
0.37
Appx Lot Size SqFt
16282.7
Appx Fin Sq Ft Total #
2264

Status Change Info

Status Change Date
2026-09-27

Property Disclosure

Property Disclosure To Be Provided
Yes

More Information

Property Features

Basement: Inside Entrance; Exterior Entry; Partially Finished; Walk-Out Access Foundation Details: Poured Concrete Cooling: Central Air Heating: Forced Air; High Efficiency Furnace; Natural Gas Construction Materials: Brick Veneer; Vinyl Roof: Architectural Shingle No of Stories(Bldg): Two Parking Facilities: Parking Garage; Paved Area Parking Per Unit: More than one Appliances: All Units; Dishwasher; Disposal; Electric Range; Exhaust Fan; Refrigerator Unit Features: All Units; Balcony/Deck; Carpets; Finished Basement; High Spd Internet Ac; Kit/Din Combo; Private Bath; Private Outside Entr; Washer/Dryer Hookups Safety Features: Smoke Detector(s) Miscellaneous: Indiv Heat and Air; Indiv Water Heaters; Pet Restrictions; Separate meters Documents Available: Certificate of Compliance; Leases Water Source: Public Sewer: Public Possession: At Closing; Subject/TenantRights Will Sell: Cash; Conventional Type of Tenancy: Mo/Mo Zoning: R-M Moderate Density Residential Road Responsibility: Public Maintained Road Road Surface Type: Paved
Listing Office: REMAX Boone Realty
Listing Agent: Sean Moore
Last Updated: October - 15 - 2026
Information deemed reliable but not guaranteed.

Mortgage Calculator

$
$
%
  • Principal Amount:
  • Years:
  • Balance Payable With Interest:
  • Total With Down Payment:

Compare listings

Compare