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

Last listed at $420,000, closed on nov 2020

—

•

4,193

sq ft

1800 S Fairview Rd, Columbia, MO 65203

About this home

Looking for the home with acreage right in the middle of an estate neighborhood? Very private. Unique floor plan, not your traditional look. Large beautiful kitchen with a deck right off it to relax and drink coffee. Formal dining room. The family room has a 2-story ceiling and windows from floor to ceiling. There is also another family room that could easily be used like a theatre room and playroom. There are cabinets to store all the games and toys to keep everything nice and tidy. Rare to find 4 bedrooms on one level! There is a large living area on the main level with glass doors.

Single-familyProperty Type

1977Year Built

2.5 acresLot Size

$100Price/Sq.Ft.

Listed by Kim Schwartz • Weichert, Realtors - House of Brokers

Bought with Adam Curtis • Iron Gate Real Estate

Redfin checked: a minute ago

•Source:CBORMLS #395747

Redfin Estimate

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

Earn from this home

Rent

$2,544/mo

Redfin rental estimate

List your home for rent

Market trends in 65203, MO

Last updated October 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-list price

93.9%

4.9% MoM

Median sale price

$342K

$2K MoM

Avg. days on market

39d

4 days MoM

Recently sold homes

287

37 MoM

New listings for sale

FOR SALE BY OWNER
$379,900
3 beds2 baths2,240 sq ft
1253 W Route K, Columbia, MO 65203
COMING SOON
$155,000
3 beds2 baths3,780 sq ft
509 Banks Ave, 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 baths2,368 sq ft
2801 W Broadway Unit T-4, Columbia, MO 65203
$125,000
3 beds3 baths2,434 sq ft
108 Heather Ln, Columbia, MO 65203
$1,250
3 beds2 baths1,250 sq ft
5625 Hilltop Dr, Columbia, MO 65203
$399,900
4 beds2.5 baths2,174 sq ft
500 Brewer Dr, Columbia, MO 65203
$950
1 bed1 bath1,256 sq ft
104 Defoe Ct, Columbia, MO 65203
See all

Provided by Redfin

Sale history for 1800 S Fairview Rd

Year

Property tax

Land + Additions

Assessment*

2025

$3,860 (+11.1%)

$6,536 + $52,402

$58,938

2024

$3,472 (+0.8%)

$6,536 + $52,402

$58,938

2023

$3,444 (+8.1%)

$6,536 + $44,935

$51,471

2022

$3,185 (−0.2%)

$6,536 + $44,935

$51,471

2021

$3,191 (+1.5%)

$6,536 + $41,116

$47,652

2020

$3,144

$6,536 + $41,116

$47,652

2019

$3,144 (+7.2%)

$6,536 + $37,582

$44,118

2018

$2,931 (+1.2%)

$6,536 + $37,582

$44,118

2017

$2,896 (−2.6%)

$6,536 + $34,314

$40,850

2016

$2,972 (+8.4%)

$6,536 + $34,314

$40,850

2015

$2,742 (−0.5%)

$6,536 + $34,314

$40,850

2014

$2,757

$6,536 + $34,314

$40,850

Tax history for 1800 S Fairview Rd

Year

Property tax

Land + Additions

Assessment*

2025

$3,860 (+11.1%)

$6,536 + $52,402

$58,938

2024

$3,472 (+0.8%)

$6,536 + $52,402

$58,938

2023

$3,444 (+8.1%)

$6,536 + $44,935

$51,471

2022

$3,185 (−0.2%)

$6,536 + $44,935

$51,471

2021

$3,191 (+1.5%)

$6,536 + $41,116

$47,652

2020

$3,144

$6,536 + $41,116

$47,652

2019

$3,144 (+7.2%)

$6,536 + $37,582

$44,118

2018

$2,931 (+1.2%)

$6,536 + $37,582

$44,118

2017

$2,896 (−2.6%)

$6,536 + $34,314

$40,850

2016

$2,972 (+8.4%)

$6,536 + $34,314

$40,850

2015

$2,742 (−0.5%)

$6,536 + $34,314

$40,850

2014

$2,757

$6,536 + $34,314

$40,850

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

Public record

Public record
Zoning
Permits

Beds

Baths

3.5

Stories

Lot width

—

Lot depth

—

Lot size

2.5 Acres

Year renovated

—

Sq. Ft.

4,193

Year built

1977

Style

Single Family Residential

County

Boone County

APN

1651500040010001

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Sep 9, 2026.

R-1

One-Family Dwelling District

This district is intended to promote and preserve safe and attractive urban one-family residential neighborhoods. The principal land use is a one-family dwelling unit per lot. Some public recreational uses, religious facilities, educational facilities, and uses incidental or accessory to dwellings are included, as shown in Table 29-3.1 (Permitted Use Table).

Permitted uses

Include but are not limited to:

Community / recreation center
Religious facility
Garden center
Housing-Group
Housing-Single unit
Educational/school
Fire house
Police station
Golf related
Park & open space

Property details

Parking

Parking/Garage Information
Has Carport
Parking Features: Carport, Paved, Driveway

Interior

Virtual Tour

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

Heating & Cooling
Has Cooling
Cooling: Central Air, Zoned
Has Heating
Heating: Electric, Forced Air, Heat Pump, Wood, Fireplace Insert

Interior Features
Interior Features: Eat-in Kitchen, Soaking Tub, Smart Thermostat, Granite Counters, Kitchen Island, Pantry, Walk-In Closet(s), Ceiling Fan(s)
Window Features: Window Treatments
Appliances: Water Softener Owned, Dishwasher, Disposal, Microwave, Refrigerator, ENERGY STAR Qualified Appliances
Flooring: Carpet, Concrete, Tile, Vinyl, Wood
Has Fireplace
Fireplace Features: Insert, Family Room, Wood Burning

Room Information
# of Rooms Total: 11
Has Basement
Basement Details: Partial, Exterior Entry, Walk-Out Access, Finished, Crawl Space

Exterior

Exterior Features
Exterior Features: Balcony
Patio And Porch Features: Rear Porch

Building Information
Direction Faces: Northwest
Sq. Ft.: 4193.0
Below Grade Finished Area: 1,991
Construction Materials: Fiber Cement

Property Features
Security Features: Smoke Detector(s)

Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Raw Mls Property Sub Type: Single Family Residence
Property Condition: Updated/Remodeled

Land Information
Vegetation: Partially Wooded

Lot Information
Lot Features: Cul-De-Sac, Wooded
Lot Size : 2.5
Lot Size Area: 2.5
Lot Size Units: Acres
Lot Size Acres: 2.5
Zoning: Single Family Res
Zoning Description: R-S Single Family Residential

Financial

Tax Information
Tax Annual Amount: $3,143.99

Utilities

Utility Information
Water Source: Public
Utilities: Electricity Available

Location

Schools Information
Elementary School: Fairview
Middle Or Junior School: Gentry
High School District: Columbia
High School: Rock Bridge

Location Information
Directions: Forum to Chapel Hill to south on Fairview or Broadway to south on Fairview
Subdivision Name: ATKINS SUB
Cross Street: Chapel Wood Rd

Public facts

Beds: 5
Baths: 3.5
Sq. Ft.: 4,193
Stories: 1.0
Lot Size: 2.5 acres
Style: Single Family Residential
Year Built: 1977
Year Renovated: —
County: Boone County
APN: 1651500040010001

Home facts updated by county records on Sep 9, 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.8mi

9/10

Ann Hawkins Gentry Middle School

Public 6-8 • Assigned • 2.8mi

7/10

Rock Bridge Senior High School

Public 9-12 • Assigned • 3.2mi

9/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

$950

1 bed1 bath1,256 sq ft

104 Defoe Ct, Columbia, MO 65203

0.44 acre lot • Built 1966 • Listed 2 days

$1,200

2 beds2 baths— sq ft

3003 Lake Town Dr, Columbia, MO 65203

Fenced backyard • Close to parks • Close to trails

$1,995

3 beds2 baths1,119 sq ft

211 Bourn Ave, Columbia, MO 65203

Ranch style home • Unfinished basement • Wood stove

3D WALKTHROUGH

$455,000

3 beds2 baths2,165 sq ft

820 Angels Rest Way, Columbia, MO 65203

Updated landscaping • Arborvitae trees • One-level living

$474,900

5 beds2.5 baths2,512 sq ft

3014 Appalachian Dr, Columbia, MO 65203

Cul-de-sac • 2 garage spots • Built 1993

3D WALKTHROUGH

$2,750,000

6 beds6.5 baths9,887 sq ft

3081 W Picket Post St, Columbia, MO 65203

Home theater • Gym • Pool room

New listings for sale in 65203

FOR SALE BY OWNER

$379,900

3 beds2 baths2,240 sq ft

1253 W Route K, Columbia, MO 65203

Pool slab • Playset • Apple trees

COMING SOON

$155,000

3 beds2 baths3,780 sq ft

509 Banks Ave, Columbia, MO 65203

7,500 sq ft lot • Built 2008

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

$200,000

2 beds2.5 baths2,368 sq ft

2801 W Broadway Unit T-4, Columbia, MO 65203

New lvp flooring • Fresh paint • New appliances

$125,000

3 beds3 baths2,434 sq ft

108 Heather Ln, Columbia, MO 65203

0.26 acre lot • 2 garage spots • Built 1977

$1,250

3 beds2 baths1,250 sq ft

5625 Hilltop Dr, Columbia, MO 65203

Built 1977 • Listed 2 days

$399,900

4 beds2.5 baths2,174 sq ft

500 Brewer Dr, Columbia, MO 65203

Open living area • Newer roof • Newer cabinets

Home values near 1800 S Fairview Rd

Data from public records.

Address	Redfin Estimate
1708 South Fairview Rd, Columbia, MO 3 Beds \| 2.5 Baths \| 1914 Sq. Ft.	—
1801 South Fairview Rd, Columbia, MO 3 Beds \| 3 Baths \| 3668 Sq. Ft.	—
1809 South Fairview Rd, Columbia, MO 4 Beds \| 4 Baths \| 4390 Sq. Ft.	—
1808 South Fairview Rd, Columbia, MO 5 Beds \| 3.5 Baths \| 3342 Sq. Ft.	—
1800 Chapel Wood Rd, Columbia, MO 4 Beds \| 2.5 Baths \| 3498 Sq. Ft.	—
2708 Chapel Wood Ter, Columbia, MO 4 Beds \| 3.5 Baths \| 3855 Sq. Ft.	—
1901 Chapel Wood Rd, Columbia, MO 3 Beds \| 3.5 Baths \| 4000 Sq. Ft.	—

Address	Redfin Estimate
1704 South Fairview Rd, Columbia, MO 5 Beds \| 3 Baths \| - Sq. Ft.	$525,191
1709 South Fairview Rd, Columbia, MO 4 Beds \| 3 Baths \| 3032 Sq. Ft.	—
1900 South Fairview Rd, Columbia, MO 5 Beds \| 3.5 Baths \| 3984 Sq. Ft.	—
1711 South Fairview Rd, Columbia, MO 4 Beds \| 3.5 Baths \| 3975 Sq. Ft.	—
1805 Chapel Wood Rd, Columbia, MO 4 Beds \| 3.5 Baths \| 3210 Sq. Ft.	—
1909 Chapel Wood Rd, Columbia, MO 4 Beds \| 3.5 Baths \| 4448 Sq. Ft.	—
1709 Chapel Wood Rd, Columbia, MO 4 Beds \| 3.5 Baths \| 3465 Sq. Ft.	—

Address	Redfin Estimate
1705 South Fairview Rd, Columbia, MO 4 Beds \| 3 Baths \| - Sq. Ft.	$485,897
1902 South Fairview Rd, Columbia, MO 5 Beds \| 3.5 Baths \| 4359 Sq. Ft.	—
1806 South Fairview Rd, Columbia, MO 4 Beds \| 2.5 Baths \| 3918 Sq. Ft.	—
1701 Chapel Wood Rd, Columbia, MO 5 Beds \| 4.5 Baths \| 4411 Sq. Ft.	—
2712 Chapel Wood Vw, Columbia, MO 4 Beds \| 3.5 Baths \| 3783 Sq. Ft.	—
1801 Chapel Wood Rd, Columbia, MO 5 Beds \| 4.5 Baths \| 4223 Sq. Ft.	—
1809 Chapel Wood Rd, Columbia, MO 5 Beds \| 4.5 Baths \| 4544 Sq. Ft.	—

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

About this home

Redfin Estimate

Earn from this home

Market trends in 65203, MO

Sale history for 1800 S Fairview Rd

Tax history for 1800 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 1800 S Fairview Rd

More real estate resources