Great investment opportunity!
Welcome to this income generating 2-bed, 1-bath duplex, Offering a turn key unit on one side with the other unit offering you an opportunity for the potential of sweat equity! This duplex is ideally located with local amenities, shopping, restaurants, and so much more! This duplex has so much to offer including a reliable monthly rental income of $2,525, This property will make a great investment for those looking to build their portfolio!
Pending
$350,000
908 S Fairview Rd, Columbia, MO 65203
4beds
2baths
1,976sqft
Est.:
Duplex
Built in 1967
-- sqft lot
$345,500 Zestimate®
$177/sqft
$228/mo HOA
What's special
- 102 days |
- 18 |
- 0 |
Zillow last checked: 8 hours ago
Listing updated: November 03, 2025 at 08:12am
Listed by:
Brady Hayes 573-777-2312,
Worth Clark Realty 314-222-0065
Source: CBORMLS,MLS#: 430088
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 2
Heating
- Natural Gas, Forced Air
Cooling
- Central Electric, Central Gas
Appliances
- Included: Dryer, All Units, Disposal, Oven/Range, Microwave, Washer, Refrigerator, Dishwasher
- Laundry: Common Area
Features
- Basement: Walk-Out Access
- Has fireplace: No
Interior area
- Total structure area: 1,976
- Total interior livable area: 1,976 sqft
Property
Features
- Stories: 1
Lot
- Size: 0.31 Acres
- Dimensions: 110.00 x 125.00
Details
- Parcel number: 1651100012090001
- Zoning description: R-2 Two- Family Dwelling*
Construction
Type & style
- Home type: MultiFamily
- Property subtype: Duplex
Materials
- Foundation: Concrete Perimeter
- Roof: ArchitecturalShingle
Condition
- Year built: 1967
Community & HOA
Community
- Subdivision: Lakeshore Est
HOA
- Amenities included: Laundry
- HOA fee: $228 monthly
Location
- Region: Columbia
Financial & listing details
- Price per square foot: $177/sqft
- Tax assessed value: $179,300
- Annual tax amount: $2,089
- Date on market: 10/2/2025
- Total actual rent: 2525
Estimated market value
$345,500
$328,000 - $363,000
$1,399/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 11/3/2025 | Pending sale | $350,000$177/sqft |
Source:  CBORMLS #430088 Report a problem | ||
| 10/2/2025 | Listed for sale | $350,000+59.1%$177/sqft |
Source: CBORMLS #430088 Report a problem | ||
| 12/11/2023 | Sold | -- |
Source: CBORMLS #416780 Report a problem | ||
| 11/7/2023 | Listed for sale | $220,000$111/sqft |
Source: CBORMLS #416780 Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $34,067 +10% |
| 2024 | $2,089 +0.8% | $30,970 |
| 2023 | $2,072 +8.1% | $30,970 +8% |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$2,291/mo
Principal & interest
$1704
Property taxes
$236
Other costs
$351
Climate risks
Neighborhood: Lakeshore Estates
Nearby schools
GreatSchools rating
- 9/10Fairview Elementary SchoolGrades: PK-5Distance: 0.1 mi
- 5/10Smithton Middle SchoolGrades: 6-8Distance: 1.1 mi
- 7/10David H. Hickman High SchoolGrades: PK,9-12Distance: 2.9 mi
Schools provided by the listing agent
- Elementary: Fairview
- Middle: Lange
- High: Hickman
Source: CBORMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- Loading
