Search- Overview
- Sale & tax history
- Property details
- Neighborhood
- Climate
820 S Fairview Rd Unit B, Columbia, MO 65203
About this home
Great duplex in peaceful Lakeshore Estates. Nice back deck with lake view. One car garage with automatic opener. Available July 1st, 2021.
Redfin Estimate
Market trends in 65203, MO
Last updated September 2026
Buyer's Market
Seller's Market
Seller's market
See all
Provided by Redfin
Sale history for 820 S Fairview Rd Unit B
$1/sq ft
$1/sq ft
$1/sq ft
$1/sq ft
$1/sq ft
$1/sq ft
Available June 22nd, 2020. Nicely updated bath room, new carpet and paint. Garage with automatic door opener. Nice back deck.
$1/sq ft
$1/sq ft
As the MLS and public records start to fill up, we'll list the details here.
Public record
- Public record
- Zoning
R-2
Two-Family Dwelling District
This district is intended to provide for a blend of one-and two-family residential developments that will promote strong neighborhoods. The district is intended to accommodate both standard residential development and small pockets of affordable small lot infill cottage residential development. The cottage standards require approval by the board of adjustment pursuant to section 29-6.4(j). The principal land use is one-family or duplex residential dwellings, as shown in Table 29-3.1 (Permitted Use Table). One principal structure is allowed per lot; two or more single-family detached dwellings are not permitted on a single lot.Include but are not limited to:
- Community / recreation center
- Religious facility
- Garden center
- Housing-Group
- Housing-Single unit
- Housing-Multiple units
- Educational/school
- Fire house
- Police station
- Park & open space
Property details
Parking
- Parking/Garage Information
- Has Garage
- # of Garage Spaces: 1
- Parking Features: Attached
Interior
- Bathroom Information
- # of Full Bathrooms: 1
- Interior Features
- Furnished: Unfurnished
- Room Information
- Has Basement
- Basement Details: Full, Unfinished, Walk-Out Access
Exterior
- Building Information
- Sq. Ft.: 1000.0
- Property Information
- Property Type: Residential Income
- Property Sub Type: Duplex
- Raw Mls Property Sub Type: Duplex
Location
- Schools Information
- Elementary School: Fairview
- Middle Or Junior School: Smithton
- High School: Hickman
- Location Information
- Directions: From Stadium Blvd: West on W. Broadway to south on Fairview Rd.
- Subdivision Name: LAKESHORE EST
- Cross Street: W. Broadway
Public facts
- Beds: —
- Baths: —
- Sq. Ft.: —
- Stories: —
- Lot Size: —
- Style: Multi-Family (5+ Unit)
- Year Built: —
- Year Renovated: —
- County: Boone County
- APN: —
Other
- Listing Information
- List AOR: Columbia Board of REALTORS®
Around this home
Schools
Public PreK-5 • Assigned • 0.1mi
Public 6-8 • Assigned • 1.1mi
Public 9-12 • Assigned • 2.9mi
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
Minimal risk of a flood reaching the building in the next 30 years
Unlikely to be in a wildfire in next 30 years
7 days above 107° expected this year, 19 days in 30 years
Minor risk of severe winds over next 30 years
1 unhealthy days expected this year, 1 days in 30 years
Sun exposure
In this area, properties receive around 9.8 hours in June and 4.4 hours in December, which is comparable to the U.S. average for solar exposure.
Is this your home?
Track this home’s value and nearby sales activity
Nearby similar homes
New listings for sale in 65203
Home values near 820 S Fairview Rd Unit B
| Address | Redfin Estimate |
|---|---|
2 Beds | 1 Baths | 888 Sq. Ft. | $135,628 |
2 Beds | 1 Baths | 888 Sq. Ft. | $134,992 |
| Address | Redfin Estimate |
|---|---|
2 Beds | 1 Baths | 888 Sq. Ft. | $131,404 |
2 Beds | 1 Baths | 888 Sq. Ft. | $131,819 |
| Address | Redfin Estimate |
|---|---|
2 Beds | 1 Baths | 888 Sq. Ft. | $135,644 |
3 Beds | 1.5 Baths | 1461 Sq. Ft. | $253,989 |
More real estate resources
- Zip Codes
- Neighborhoods
- Cities
- Popular Searches
| 65255 homes for sale | |||
| 65279 homes for sale | |||
| 65201 homes for sale | |||
| 65202 homes for sale | |||
| 65203 homes for sale |
| Fourth Ward homes for sale | |||
| Broadway Farms homes for sale |
| Fulton homes for sale | |||
| Jefferson City homes for sale | |||
| Boonville homes for sale |
Find us
Subsidiaries
Affiliated Business
Copyright: © 2026 Redfin. All rights reserved.
Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.
Do not sell or share my personal information.
REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.
California DRE #01521930
Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures
New Mexico Real Estate Licenses
TREC: Info About Brokerage Services, Consumer Protection Notice
All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.
Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.
If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.
REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.
































United States
Canada