Google street view image for 801 Fairview Rd Unit B, Columbia, MO 65203

Last listed at $650, closed on apr 2019

—

•

1,200

sq ft

801 Fairview Rd Unit B, Columbia, MO 65203

About this home

Well maintained 2 bedroom 1.5 bath 1 car garage duplex within walking distance to Fairview school. Living room, kitchen and 1/2 bath on main level. 2 BRs and 1 full bath on upper level. Finished basement can be a play area or office area or for storage. Washer and dryer included. 1 detached garage. Walk to school, grocery store, and restaurants. Lawn care is tenant's responsibility. NO Pets, No smokers, no gov't assistance for rent. Background check and credit check required.

Multi-familyProperty Type

$1Price/Sq.Ft.

1 car garageParking

Listed by Paul Bunch • Century 21 Community

Listed by Ling Bunch • Century 21 Community

Bought with Ling Bunch • Century 21 Community

Redfin checked: a few seconds ago

•Source:CBORMLS #383811

Redfin Estimate

Unfortunately, we don't have enough data to generate an accurate Estimate at this time.

Market trends in 65203, MO

Last updated October 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-list price

96.0%

+2.2% MoM

Median sale price

$350K

$8K MoM

Avg. days on market

35d

4 days MoM

Recently sold homes

239

42 MoM

New listings for sale

NEW 3 HRS AGO
$204,499
3 beds1 bath1,188 sq ft
12 Switzler St, Columbia, MO 65203
NEW 4 HRS AGO
$495,000
4 beds3 baths2,384 sq ft
3814 Ivanhoe Blvd, Columbia, MO 65203
$950,000
4 beds4.5 baths4,432 sq ft
3702 Woodrail ON The Green Grn, Columbia, MO 65203
$155,000
3 beds2 baths3,780 sq ft
509 Banks Ave, Columbia, MO 65203
OPEN SUN, 12PM TO 1PM
$365,000
4 beds3 baths2,796 sq ft
901 Westport Dr, Columbia, MO 65203
FOR SALE BY OWNER
$379,900
3 beds2 baths2,240 sq ft
1253 W Route K, Columbia, MO 65203
3D WALKTHROUGH
$330,000
4 beds3 baths2,344 sq ft
1514 S Waterford Dr, Columbia, MO 65203
$325,000
3 beds2.5 baths2,108 sq ft
1200 Subella Dr, Columbia, MO 65203
$345,000
3 beds2.5 baths2,008 sq ft
3005 Lake Town Dr, Columbia, MO 65203
$200,000
2 beds2.5 baths1,184 sq ft
2801 W Broadway Unit T-4, Columbia, MO 65203
See all

Provided by Redfin

Sale history for 801 Fairview Rd Unit B

Public record

Public record
Zoning

Beds

—

Baths

—

Stories

—

Lot width

120 ft.

Lot depth

88 ft.

Lot size

—

Year renovated

—

Sq. Ft.

—

Year built

—

Style

Multi-Family (2-4 Unit)

County

Boone County

APN

—

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Sep 14, 2026.

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: Detached

Interior

Bathroom Information
# of Full Bathrooms: 1
# of Half Bathrooms: 1

Interior Features
Furnished: Unfurnished

Room Information
Has Basement
Basement Details: Full, Partially Finished

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: SW corner of Fairview & Rollins
Subdivision Name: COLONIAL GARDENS
Cross Street: Rollins

Public facts

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

Home facts updated by county records on Sep 14, 2026

Other

Listing Information
List AOR: Columbia Board of REALTORS®

Around this home

Schools

K - 12
Preschool & daycare

Fairview Elementary School

Public PreK-5 • Assigned • 0.2mi

9/10

Smithton Middle School

Public 6-8 • Assigned • 1.0mi

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

Try the sun simulator tool to see how light moves across the property at different times of day and year.

Provided by Shadowmap

Sell confidently with a local market expert in Columbia. 3 minutes to get started.

Nearby similar homes

$2,800

3 beds2 baths1,456 sq ft

202 Wheaton Ct, Columbia, MO 65203

Updated interiors • Laundry facilities • Built 1975

$2,800

4 beds2 baths1,456 sq ft

201 N West Blvd, Columbia, MO 65203

Fully furnished • Utilities included • Private deck

$1,800

4 beds2 baths3,218 sq ft

5304 Tessa Way, Columbia, MO 65203

Listed 27 days

$2,000

2 beds2 baths1,100 sq ft

104 E Green Meadows Rd, Columbia, MO 65203

Pool access • Quiet condo complex • Built 1985

$3,000

3 beds2 baths2,000 sq ft

3509 Augusta Dr, Columbia, MO 65203

Back deck • Formal dining room • Sun room

$3,200

4 beds2 baths1,659 sq ft

1415 Paris Rd Unit A, Columbia, MO 65201

Fully furnished • Unbeatable location • Large living room

New listings for sale in 65203

NEW 3 HRS AGO3D WALKTHROUGH

$204,499

3 beds1 bath1,188 sq ft

12 Switzler St, Columbia, MO 65203

Remodeled kitchen • Farmhouse sink • Newer roof

NEW 4 HRS AGO

$495,000

4 beds3 baths2,384 sq ft

3814 Ivanhoe Blvd, Columbia, MO 65203

Custom gas fireplace • Walk-in closet • Large composite deck

$950,000

4 beds4.5 baths4,432 sq ft

3702 Woodrail ON The Green Grn, Columbia, MO 65203

Water view • Golf course • Composite deck

$155,000

3 beds2 baths3,780 sq ft

509 Banks Ave, Columbia, MO 65203

7,500 sq ft lot • Built 2008

OPEN SUN, 12PM TO 1PM

$365,000

4 beds3 baths2,796 sq ft

901 Westport Dr, Columbia, MO 65203

Oversized back deck • Mature trees • Natural views

FOR SALE BY OWNER

$379,900

3 beds2 baths2,240 sq ft

1253 W Route K, Columbia, MO 65203

Pool slab • Playset • Apple trees

3D WALKTHROUGH

$330,000

4 beds3 baths2,344 sq ft

1514 S Waterford Dr, Columbia, MO 65203

Corner lot • Mature trees • Stone fireplace

$325,000

3 beds2.5 baths2,108 sq ft

1200 Subella Dr, Columbia, MO 65203

Brick curb appeal • Corner lot • Tiered deck

$345,000

3 beds2.5 baths2,008 sq ft

3005 Lake Town Dr, Columbia, MO 65203

Move in ready • Freshly repainted • 9,700 sq ft lot

Home values near 801 Fairview Rd Unit B

Data from public records.

Address	Redfin Estimate
805 South Fairview Rd Apartment S, Columbia, MO 4 Beds \| 3 Baths \| 2535 Sq. Ft.	—
801 South Fairview Rd Apartment S, Columbia, MO 4 Beds \| 3 Baths \| 2520 Sq. Ft.	—
811 South Fairview Rd, Columbia, MO - Beds \| - Baths \| 2296 Sq. Ft.	—
802C10 South Fairview Rd, Columbia, MO 2 Beds \| 1 Baths \| 814 Sq. Ft.	$183,186
2806 Rollins Rd Apartment A2, Columbia, MO 2 Beds \| 1 Baths \| - Sq. Ft.	$152,012
2806 Rollins Rd Apartment B6, Columbia, MO 2 Beds \| 1 Baths \| 925 Sq. Ft.	$141,561
804 Cambridge Dr, Columbia, MO 4 Beds \| 3 Baths \| 2308 Sq. Ft.	$316,300

Address	Redfin Estimate
807 South Fairview Rd Apartment S, Columbia, MO 4 Beds \| 3 Baths \| 2520 Sq. Ft.	—
805 South Fairview Rd, Columbia, MO 4 Beds \| 3 Baths \| 2581 Sq. Ft.	—
802 D15 South Fairview Rd, Columbia, MO 2 Beds \| 1 Baths \| 850 Sq. Ft.	$164,810
807 South Fairview Rd Apartment A & B, Columbia, MO - Beds \| - Baths \| - Sq. Ft.	—
2806 Rollins Rd Apartment A3W, Columbia, MO 2 Beds \| 1 Baths \| 925 Sq. Ft.	$149,547
806 Cambridge Dr, Columbia, MO 3 Beds \| 2 Baths \| 1475 Sq. Ft.	$279,274
2806 Rollins Rd Apartment B7, Columbia, MO 2 Beds \| 1 Baths \| 925 Sq. Ft.	$158,147

Address	Redfin Estimate
811 South Fairview Rd Apartment S, Columbia, MO 6 Beds \| 3 Baths \| 2296 Sq. Ft.	—
801 South Fairview Rd, Columbia, MO - Beds \| - Baths \| 2520 Sq. Ft.	—
802C12 North Fairview Rd, Columbia, MO 2 Beds \| 1 Baths \| 814 Sq. Ft.	$160,456
801 South Fairview Rd Apartment A, Columbia, MO 2 Beds \| 1.5 Baths \| 1200 Sq. Ft.	—
2806 Rollins Rd Apartment B5, Columbia, MO 2 Beds \| 1 Baths \| 850 Sq. Ft.	$119,598
2806 Rollins Rd Apartment A4, Columbia, MO 2 Beds \| 1 Baths \| 925 Sq. Ft.	$149,772
800 Cambridge Dr, Columbia, MO 3 Beds \| 2 Baths \| 1200 Sq. Ft.	$277,343

Property information provided by CBORMLS when last listed in 2019. 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.

Redfin Brokerage Licenses

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
Holts Summit homes for sale