Google street view image for 815 S Fairview Rd, Columbia, MO 65203

Last listed at $210,000, CLOSED ON Aug 2021

—

•

— ba

•

2,784

sq ft

815 S Fairview Rd, Columbia, MO 65203

About this home

Multi-familyProperty Type

9,600 sq ftLot Size

$75Price/Sq.Ft.

Listed by Paul Bunch • Century 21 Community

Bought with John Sorensen • REMAX Boone Realty

Redfin checked: a few seconds ago

•Source:CBORMLS #400708

Redfin Estimate

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

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 3 HRS AGO
$495,000
5 beds3 baths2,950 sq ft
3005 Greenbriar Dr, Columbia, MO 65203
NEW 14 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 815 S Fairview Rd

Public record

Public record
Zoning

Beds

—

Baths

—

Stories

—

Lot width

80 ft.

Lot depth

120 ft.

Lot size

—

Year renovated

—

Sq. Ft.

—

Year built

—

Style

Multi-Family (2-4 Unit)

County

Boone County

APN

1651000020050001

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Dec 19, 2023.

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

Interior

Heating & Cooling
Has Heating
Heating: Forced Air, Natural Gas

Room Information
Has Basement
Basement Details: Full, Partially Finished

Exterior

Building Information
Sq. Ft.: 2784.0

Property Information
Property Type: Residential Income
Property Sub Type: Duplex
Raw Mls Property Sub Type: Duplex

Lot Information
Lot Size Dimensions: 80 x 120
Zoning Description: R-2 Two- Family Dwelling*

Location

Schools Information
Elementary School: Fairview
Middle Or Junior School: Smithton
High School District: Columbia
High School: Hickman

Location Information
Directions: Broadway to S on Fairview Rd.
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: 1651000020050001

Home facts updated by county records on Dec 19, 2023

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

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

Nearby similar homes

$1,495

4 beds3 baths1,402 sq ft

1516 Citadel Dr, Columbia, MO 65202

$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,650

4 beds2 baths1,541 sq ft

3319 Dove Dr, Columbia, MO 65202

3D WALKTHROUGH

$1,800

3 beds2 baths2,000 sq ft

3252 Wind River Cir, Columbia, MO 65203

New listings for sale in 65203

NEW 3 HRS AGO3D WALKTHROUGH

$495,000

5 beds3 baths2,950 sq ft

3005 Greenbriar Dr, Columbia, MO 65203

NEW 14 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 815 S Fairview Rd

Data from public records.

Address	Redfin Estimate
805 South Fairview Rd Apt S, Columbia, MO 4 Beds \| 3 Baths \| 2535 Sq. Ft.	—
810 South Fairview Rd Apt A, Columbia, MO 3 Beds \| 1.5 Baths \| 1461 Sq. Ft.	$265,086

Address	Redfin Estimate
807 South Fairview Rd Apt S, Columbia, MO 4 Beds \| 3 Baths \| 2520 Sq. Ft.	—
806 South Fairview Rd Apt A, Columbia, MO 3 Beds \| 1.5 Baths \| 1461 Sq. Ft.	$222,226

Address	Redfin Estimate
811 South Fairview Rd Apt S, Columbia, MO 6 Beds \| 3 Baths \| 2296 Sq. Ft.	—
806 South Fairview Rd Apt B, Columbia, MO 3 Beds \| 1.5 Baths \| 1461 Sq. Ft.	$210,705

Property information provided by CBORMLS when last listed in 2021. 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 815 S Fairview Rd

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 65203

Home values near 815 S Fairview Rd

More real estate resources