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

Off market

—

•

2.5 ba

•

3,348

sq ft

904 S Fairview Rd Unit S, Columbia, MO 65203

About this home

904 S Fairview Rd Unit S is a 3,348 square foot multi-family home on a 0.29 acre lot with 4 bedrooms and 2.5 bathrooms.

Multi-familyProperty Type

1968Year Built

0.29 acresLot Size

Source:Public Records

Redfin Estimate

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

Market trends in 65203, MO

Last updated September 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
$260,000
2 beds2 baths1,206 sq ft
116 Green Meadows Rd, Columbia, MO 65203
COMING SOON
$275,000
3 beds2 baths1,374 sq ft
3607 Sierra Madre, Columbia, MO 65203
NEW 15 HRS AGO
$374,900
3 beds2 baths1,678 sq ft
4004 Eagle View Ct, Columbia, MO 65203
OPEN TODAY, 4PM TO 7PM
$350,000
3 beds3 baths2,552 sq ft
406 W Walnut St, Columbia, MO 65203
NEW 17 HRS AGO
$2,100
3 beds2.5 baths1,620 sq ft
501 S Village Cir, Columbia, MO 65203
OPEN SUN, 1PM TO 2PM
$885,000
5 beds4 baths5,628 sq ft
6013 Dornagh Ct, Columbia, MO 65203
COMING SOON
$249,900
2 beds2 baths1,056 sq ft
808 N West Blvd, Columbia, MO 65203
NEW 1 DAY AGO
$349,000
3 beds2 baths1,445 sq ft
3307 Timber Run Dr, Columbia, MO 65203
NEW 1 DAY AGO
$2,150
3 beds2 baths1,536 sq ft
5105 Grayling Ct, Columbia, MO 65203
NEW 1 DAY AGO
$1,149,000
5 beds4 baths3,139 sq ft
8911 S Lagos Dr, Columbia, MO 65203
See all

Provided by Redfin

Sale history for 904 S Fairview Rd Unit S

As the MLS and public records start to fill up, we'll list the details here.

Year

Property tax

Land + Additions

Assessment*

2025

$2,700 (+6.8%)

$6,061 + $35,169

$41,230

2024

$2,529 (+0.8%)

$6,061 + $35,169

$41,230

2023

$2,508 (+8.1%)

$6,061 + $31,426

$37,487

2022

$2,320 (−0.2%)

$6,061 + $31,426

$37,487

2021

$2,324 (+1.5%)

$6,061 + $28,652

$34,713

2020

$2,290

$6,061 + $28,652

$34,713

2019

$2,290 (+7.2%)

$6,061 + $26,073

$32,134

2018

$2,135 (+1.2%)

$6,061 + $26,073

$32,134

2017

$2,109 (−2.6%)

$6,061 + $23,693

$29,754

2016

$2,165 (+8.4%)

$6,061 + $23,693

$29,754

2015

$1,997 (−0.5%)

$6,061 + $23,693

$29,754

2014

$2,008

$6,061 + $23,693

$29,754

Tax history for 904 S Fairview Rd Unit S

Year

Property tax

Land + Additions

Assessment*

2025

$2,700 (+6.8%)

$6,061 + $35,169

$41,230

2024

$2,529 (+0.8%)

$6,061 + $35,169

$41,230

2023

$2,508 (+8.1%)

$6,061 + $31,426

$37,487

2022

$2,320 (−0.2%)

$6,061 + $31,426

$37,487

2021

$2,324 (+1.5%)

$6,061 + $28,652

$34,713

2020

$2,290

$6,061 + $28,652

$34,713

2019

$2,290 (+7.2%)

$6,061 + $26,073

$32,134

2018

$2,135 (+1.2%)

$6,061 + $26,073

$32,134

2017

$2,109 (−2.6%)

$6,061 + $23,693

$29,754

2016

$2,165 (+8.4%)

$6,061 + $23,693

$29,754

2015

$1,997 (−0.5%)

$6,061 + $23,693

$29,754

2014

$2,008

$6,061 + $23,693

$29,754

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

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.

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

Basement Information
Basement Sq. Ft: 1,362
Basement Finish: Finished
Basement Type: Full

Bathroom Information
# of Full Baths: 2
# of 1/2 Baths: 1
# of Bathroom Fixtures: 10

Heating & Cooling
Heating Fuel Type: Gas
Heating Type: Warm Air

Room Information
# of Rooms: 8

Exterior

Exterior Information
Physical Condition: Good
Exterior Wall: Frame/Masonry

Property Information
Subdivision Name: LAKESHORE ESTATE
Living Sq. Ft: 3,348
Ground Floor Sq. Ft: 1,986
Building Sq. Ft: 3,348
# of Stories: 1
Legal Description: LAKESHORE ESTATE NO 2 LOT 89

Parking & Garage Information
# of Parking Spaces: 2

Lot Information
# of Buildings: 1
Land Sq. Ft: 12,500
Legal Lot Number: 89
School Tax District: COLUMBIA
Municipality Name: MISSOURI
Acres: 0.287
Depth Footage: 125
Front Footage: 100
Zoning Code: R2
County Use Description: RESIDENTIAL 2 FAM

Financial

Assessor Information
Assessment Year: 2026
Tax District County: STATE OF MISSOURI

Public facts

Beds: 4
Baths: 2.5
Sq. Ft.: 3,348
Stories: 1.0
Lot Size: 0.29 acres
Style: Multi-Family (2-4 Unit)
Year Built: 1968
Year Renovated: —
County: Boone County
APN: 1651100012080001

Home facts updated by county records on Sep 25, 2026

Around this home

Schools

Fairview Elementary School

Public PreK-5 • Assigned • 0.1mi

9/10

Smithton Middle School

Public 6-8 • Assigned • 1.2mi

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,550

4 beds2 baths1,456 sq ft

1011 W Ash St, Columbia, MO 65203

$1,950

3 beds2 baths1,535 sq ft

3401 Yellowwood 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

$2,500

3 beds2.5 baths1,757 sq ft

1201 S Old Hwy 63 #301, Columbia, MO 65201

New listings for sale in 65203

NEW 3 HRS AGO

$260,000

2 beds2 baths1,206 sq ft

116 Green Meadows Rd, Columbia, MO 65203

COMING SOON

$275,000

3 beds2 baths1,374 sq ft

3607 Sierra Madre, Columbia, MO 65203

NEW 15 HRS AGO

$374,900

3 beds2 baths1,678 sq ft

4004 Eagle View Ct, Columbia, MO 65203

OPEN TODAY, 4PM TO 7PM

$350,000

3 beds3 baths2,552 sq ft

406 W Walnut St, Columbia, MO 65203

NEW 17 HRS AGO

$2,100

3 beds2.5 baths1,620 sq ft

501 S Village Cir, Columbia, MO 65203

OPEN SUN, 1PM TO 2PM

$885,000

5 beds4 baths5,628 sq ft

6013 Dornagh Ct, Columbia, MO 65203

COMING SOON

$249,900

2 beds2 baths1,056 sq ft

808 N West Blvd, Columbia, MO 65203

NEW 1 DAY AGO3D WALKTHROUGH

$349,000

3 beds2 baths1,445 sq ft

3307 Timber Run Dr, Columbia, MO 65203

NEW 1 DAY AGO

$2,150

3 beds2 baths1,536 sq ft

5105 Grayling Ct, Columbia, MO 65203

Home values near 904 S Fairview Rd Unit S

Data from public records.

Address	Redfin Estimate
810 South Fairview Rd Apt B, Columbia, MO 3 Beds \| 1.5 Baths \| 1461 Sq. Ft.	$206,295
908 South Fairview Rd Apt S, Columbia, MO 4 Beds \| 2 Baths \| 1976 Sq. Ft.	—

Address	Redfin Estimate
820 South Fairview Rd Apt S, Columbia, MO 4 Beds \| 2.5 Baths \| 1960 Sq. Ft.	—
912 South Fairview Rd Apt S, Columbia, MO 4 Beds \| 2 Baths \| 1986 Sq. Ft.	—

Address	Redfin Estimate
900 South Fairview Rd Apt S, Columbia, MO 5 Beds \| 3 Baths \| 2400 Sq. Ft.	—
916 South Fairview Rd Apt S, Columbia, MO 4 Beds \| 2 Baths \| 1960 Sq. Ft.	—

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 904 S Fairview Rd Unit S

Tax history for 904 S Fairview Rd Unit S

Zoning

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 904 S Fairview Rd Unit S

More real estate resources