Google street view image for 820 S Fairview Rd Unit A, Columbia, MO 65203

Last listed at $1,300, CLOSED ON Aug 2025

—

•

1,200

sq ft

820 S Fairview Rd Unit A, Columbia, MO 65203

About this home

Multi-familyProperty Type

1967Year Built

$1Price/Sq.Ft.

1 car garageParking

Listed by David Townsend • REMAX Boone Realty

Bought with Karen Turner • Weichert, Realtors - House of Brokers

Redfin checked: a few seconds ago

•Source:CBORMLS #428811

Redfin Estimate

There isn’t enough information to generate an accurate estimate at this time. Learn More

Market trends in 65203, MO

Last updated August 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

98.7%

+0.3% MoM

Median sale price

$397K

$3K MoM

Avg. days on market

26d

8 days MoM

Recently sold homes

257

29 MoM

New listings for sale

NEW 4 HRS AGO
$495,000
5 beds3 baths2,950 sq ft
3005 Greenbriar Dr, Columbia, MO 65203
NEW 15 HRS AGO
$2,195
3 beds2 baths1,636 sq ft
5007 Whitefish Ct, Columbia, MO 65203
COMING SOON
608 Corsair Ct, Columbia, MO 65203
$475,000
4 beds2 baths2,178 sq ft
608 Corsair Ct, Columbia, MO 65203
$179,900
4 beds1 bath1,440 sq ft
6 Cardinal Ct, Columbia, MO 65203
3D WALKTHROUGH
$448,000
5 beds4 baths3,376 sq ft
1209 Hulen Dr, Columbia, MO 65203
$899,900
5 beds3 baths3,807 sq ft
7320 Sella Ct, Columbia, MO 65203
COMING SOON
$885,000
5 beds4 baths5,628 sq ft
6013 Dornagh Ct, Columbia, MO 65203
3D WALKTHROUGH
$1,550
3 beds2 baths1,700 sq ft
5000 Carrie Ridge Dr, Columbia, MO 65203
3D WALKTHROUGH
$1,800
3 beds2 baths2,000 sq ft
3252 Wind River Cir, Columbia, MO 65203
3D WALKTHROUGH
$439,900
4 beds3.5 baths3,297 sq ft
3900 Daylily Ct, Columbia, MO 65203
See all

Provided by Redfin

Sale history for 820 S Fairview Rd Unit A

Date

Event

Price

APPFOLIO #1

Aug 16, 2025

Rental Removed

$1,300

$1/sq ft

Aug 4, 2025

Listed for Rent

$1,300

$1/sq ft

CBORMLS #428811

Aug 3, 2025

Rental Removed

$1,300

$1/sq ft

Aug 3, 2025

Sold

—

Jul 30, 2025

Listed for Rent

$1,300

$1/sq ft

Jul 29, 2025

Listed

$1,300

$1/sq ft

CBORMLS #398239

Mar 12, 2021

Sold

—

Mar 8, 2021

Listed

$850

$1/sq ft

CBORMLS #384125

Apr 2, 2019

Sold

—

Mar 24, 2019

Listed

$800

$1/sq ft

Public record

Public record
Zoning

Beds

—

Baths

—

Stories

—

Lot width

130 ft.

Lot depth

168 ft.

Lot size

—

Year renovated

—

Sq. Ft.

—

Year built

—

Style

Multi-Family (5+ Unit)

County

Boone County

APN

—

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jul 30, 2025.

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.

Permitted uses

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
# of Rooms Total: 1
Has Basement
Basement Details: Full, Unfinished

Exterior

Building Information
Sq. Ft.: 1200.0

Property Features
Pets Allowed: No

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 Broadway, South on S. Fairview Rd.
Subdivision Name: LAKESHORE EST
Cross Street: West Broadway

Public facts

Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: —
Style: Multi-Family (5+ Unit)
Year Built: —
Year Renovated: —
County: Boone County
APN: —

Home facts updated by county records on Jul 30, 2025

Other

Listing Information
List AOR: Columbia Board of REALTORS®

Around this home

Schools

Fairview Elementary School

Public PreK-5 • Assigned • 0.1mi

9/10

Smithton Middle School

Public 6-8 • Assigned • 1.1mi

6/10

David H. Hickman High School

Public 9-12 • Assigned • 2.9mi

7/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

4/10 Heat Factor

7 days above 107° expected this year, 19 days in 30 years

2/10 Wind Factor

Minor risk of severe winds over next 30 years

2/10 Air Factor

1 unhealthy days expected this year, 1 days in 30 years

Provided by First Street

Historical weather

Columbia, MO • 65203

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

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.

9.8 hrs

4.4 hrs

JuneDecember

Provided by Shadowmap

Is this your home?

Track this home’s value and nearby sales activity

Nearby similar homes

$1,250

3 beds1.5 baths1,242 sq ft

4242 E Santa Barbara Dr, Columbia, MO 65201

$1,700

1 bed1 bath— sq ft

505 Fay ST St #204, Columbia, MO 65201

$1,050

1 bed1 bath— sq ft

1612 Richardson St #5, Columbia, MO 65201

$1,050

1 bed1 bath— sq ft

1612 Richardson St #6, Columbia, MO 65201

$975

1 bed1 bath456 sq ft

105 N Garth Ave #33, Columbia, MO 65203

$1,125

1 bed1 bath715 sq ft

3408 Balboa Ln #45, Columbia, MO 65203

New listings for sale in 65203

NEW 4 HRS AGO3D WALKTHROUGH

$495,000

5 beds3 baths2,950 sq ft

3005 Greenbriar Dr, Columbia, MO 65203

NEW 15 HRS AGO

$2,195

3 beds2 baths1,636 sq ft

5007 Whitefish Ct, Columbia, MO 65203

COMING SOON

$475,000

4 beds2 baths2,178 sq ft

608 Corsair Ct, Columbia, MO 65203

$179,900

4 beds1 bath1,440 sq ft

6 Cardinal Ct, Columbia, MO 65203

3D WALKTHROUGH

$448,000

5 beds4 baths3,376 sq ft

1209 Hulen Dr, Columbia, MO 65203

$899,900

5 beds3 baths3,807 sq ft

7320 Sella Ct, Columbia, MO 65203

COMING SOON

$885,000

5 beds4 baths5,628 sq ft

6013 Dornagh Ct, Columbia, MO 65203

3D WALKTHROUGH

$1,550

3 beds2 baths1,700 sq ft

5000 Carrie Ridge Dr, Columbia, MO 65203

3D WALKTHROUGH

$1,800

3 beds2 baths2,000 sq ft

3252 Wind River Cir, Columbia, MO 65203

Home values near 820 S Fairview Rd Unit A

Data from public records.

Address	Redfin Estimate
804 S Fairview Road #B7S, Columbia, MO 2 Beds \| 1 Baths \| 888 Sq. Ft.	$127,610
804 S Fairview Road #A4S, Columbia, MO 2 Beds \| 1 Baths \| 888 Sq. Ft.	$126,857

Address	Redfin Estimate
804 S Fairview Road #B5S, Columbia, MO 2 Beds \| 1 Baths \| 888 Sq. Ft.	$125,661
804 S Fairview Road #A1S, Columbia, MO 2 Beds \| 1 Baths \| 888 Sq. Ft.	$126,211

Address	Redfin Estimate
804 S Fairview Road #B6S, Columbia, MO 2 Beds \| 1 Baths \| 888 Sq. Ft.	$127,611
810 S Fairview Road #A, Columbia, MO 3 Beds \| 1.5 Baths \| 1461 Sq. Ft.	$265,086

Property information provided by CBORMLS when last listed in 2025. This data may not match . Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

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.

GreatSchools Ratings provided by GreatSchools.org.

65255 homes for sale
65279 homes for sale
65201 homes for sale
65202 homes for sale
65203 homes for sale

Houses for rent in Columbia	Agents near me	Lee's Summit, MO homes for sale	Columbia Housing Market
Houses for sale near me	St. Louis, MO homes for sale	Chesterfield, MO homes for sale
Land for sale near me	Kansas City, MO homes for sale	Independence, MO homes for sale
Open Houses near me	Springfield, MO homes for sale	Columbia Property Records
Condos for sale near me	St. Charles, MO homes for sale	MO New Listings

Fulton homes for sale
Jefferson City homes for sale
Boonville homes for sale

About this home

Redfin Estimate

Market trends in 65203, MO

Sale history for 820 S Fairview Rd Unit A

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Is this your home?

Nearby similar homes

New listings for sale in 65203

Home values near 820 S Fairview Rd Unit A

More real estate resources