This condo is a must see! 2023 updated included new LVP flooring throughout (except bathroom), paint, new appliances, backsplash, light fixtures/ceiling fans. Custom cabinets. Private deck to watch the squirrels and relax or relax by the condo pool! Special assessment fee paid for new roof and retaining wall in 2024. HVAC replaced 2022. This condo is move in ready and good to go for years to come.
Sold on 11/24/25
Street View
Price Unknown
804 S Fairview Rd APT B7, Columbia, MO 65203
2beds
888sqft
Condominium
Built in ----
-- sqft lot
$172,400 Zestimate®
$--/sqft
$1,097 Estimated rent
Home value
$172,400
$164,000 - $181,000
$1,097/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: November 25, 2025 at 10:04am
Listed by:
Christina Smith 573-999-6650,
Weichert, Realtors - House of Brokers 573-446-6767
Bought with:
John Lohmann, 2016039607
Home Realty Group
Source: CBORMLS,MLS#: 429517
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 1
- Full bathrooms: 1
Bedroom 1
- Level: Main
Bedroom 2
- Level: Main
Full bathroom
- Level: Main
Dining room
- Level: Main
Kitchen
- Level: Main
Living room
- Level: Main
Heating
- Forced Air, Natural Gas
Cooling
- Central Electric
Features
- High Speed Internet, Tub/Shower, Walk-In Closet(s), Smart Thermostat, Kit/Din Combo, Cabinets-Custom Blt, Laminate Counters
- Flooring: Tile, Vinyl
- Windows: Some Window Treatments
- Has basement: Yes
- Has fireplace: No
Interior area
- Total structure area: 888
- Total interior livable area: 888 sqft
- Finished area below ground: 0
Property
Parking
- Parking features: No Garage, Paved
- Has uncovered spaces: Yes
Features
- Patio & porch: Back, Deck
- Exterior features: Balcony
- Fencing: None
Details
- Additional structures: None
- Parcel number: 1651100012650001
- Zoning description: R-MF Multiple-Family Dwelling*
Construction
Type & style
- Home type: Condo
- Architectural style: Other
- Property subtype: Condominium
Materials
- Foundation: Concrete Perimeter
- Roof: ArchitecturalShingle
Utilities & green energy
- Electric: City
- Gas: Gas-Natural
- Sewer: City
- Water: Public
- Utilities for property: Natural Gas Connected, Trash-City
Community & neighborhood
Location
- Region: Columbia
- Subdivision: Lakeshore Est
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $280 monthly
Other
Other facts
- Road surface type: Paved
Price history
| Date | Event | Price |
|---|---|---|
| 11/24/2025 | Sold | -- |
Source:  CBORMLS #429517 | ||
| 11/7/2025 | Pending sale | $175,000$197/sqft |
Source: CBORMLS #429517 | ||
| 11/6/2025 | Listed for sale | $175,000$197/sqft |
Source: CBORMLS #429517 | ||
| 10/26/2025 | Pending sale | $175,000$197/sqft |
Source: CBORMLS #429517 | ||
| 9/25/2025 | Price change | $175,000-2.2%$197/sqft |
Source: CBORMLS #429517 | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $981 +0.8% | $14,535 |
| 2023 | $972 +8.2% | $14,535 +8.1% |
| 2022 | $899 -0.2% | $13,452 |
Find assessor info on the county website
Neighborhood: Lakeshore Estates
Nearby schools
GreatSchools rating
- 9/10Fairview Elementary SchoolGrades: PK-5Distance: 0.1 mi
- 5/10Smithton Middle SchoolGrades: 6-8Distance: 1 mi
- 7/10David H. Hickman High SchoolGrades: PK,9-12Distance: 2.8 mi
Schools provided by the listing agent
- Elementary: Fairview
- Middle: Smithton
- High: Hickman
Source: CBORMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.