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

Last listed at $895, closed on mar 2023

—

•

872

sq ft

814 S Fairview Rd Unit B, Columbia, MO 65203

About this home

Multi-familyProperty Type

1968Year Built

$1Price/Sq.Ft.

1 car garageParking

Listed by Lori Holliday • REMAX Boone Realty

Bought with Lori Holliday • REMAX Boone Realty

Redfin checked: a minute ago

•Source:CBORMLS #411412

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

Public record

Public record
Zoning

Beds

—

Baths

—

Stories

—

Lot width

135 ft.

Lot depth

125 ft.

Lot size

—

Year renovated

—

Sq. Ft.

—

Year built

—

Style

Multi-Family (2-4 Unit)

County

Boone County

APN

1651100012050001

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

Interior

Bathroom Information
# of Full Bathrooms: 1

Interior Features
Furnished: Unfurnished

Room Information
# of Rooms Total: 7
Has Basement
Basement Details: Full, Unfinished

Exterior

Building Information
Sq. Ft.: 872.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: Broadway to Fairview.
Subdivision Name: LAKESHORE EST
Cross Street: Broadway

Public facts

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

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.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

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

2 beds2 baths1,100 sq ft

104 E Green Meadows Rd, Columbia, MO 65203

Pool access • Quiet condo complex • Built 1985

$2,800

4 beds2 baths1,456 sq ft

201 N West Blvd, Columbia, MO 65203

Fully furnished • Utilities included • Private deck

$2,800

3 beds2 baths1,456 sq ft

202 Wheaton Ct, Columbia, MO 65203

Updated interiors • Laundry facilities • Built 1975

$1,795

1 bed1 bath— sq ft

1612 Richardson St #1, Columbia, MO 65201

Utilities included • Vibrant neighborhood • Easy access to shops

$1,695

1 bed1 bath456 sq ft

105 N Garth Ave #03, Columbia, MO 65203

Private decks • Patio access • Pool

$1,495

4 beds3 baths1,420 sq ft

1405 Greensboro Dr, Columbia, MO 65202

Listed 49 days

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

Data from public records.

Address	Redfin Estimate
804 S Fairview Road, Columbia, MO 2 Beds \| 1 Baths \| 888 Sq. Ft.	$171,878
804 S Fairview Road #B6S, Columbia, MO 2 Beds \| 1 Baths \| 888 Sq. Ft.	$124,443
810 S Fairview Road #A, Columbia, MO 3 Beds \| 1.5 Baths \| 1461 Sq. Ft.	$227,595
804 S Fairview Road #B8S, Columbia, MO 2 Beds \| 1 Baths \| 888 Sq. Ft.	$124,428
804 S Fairview Road #A3S, Columbia, MO 2 Beds \| 1 Baths \| 888 Sq. Ft.	$124,511
814 S Fairview Road #S, Columbia, MO 4 Beds \| 2 Baths \| 1744 Sq. Ft.	—
806 S Fairview Road, Columbia, MO 3 Beds \| 1.5 Baths \| 1540 Sq. Ft.	$220,002

Address	Redfin Estimate
804 S Fairview Road #B7S, Columbia, MO 2 Beds \| 1 Baths \| 888 Sq. Ft.	$124,441
804 S Fairview Road #A4S, Columbia, MO 2 Beds \| 1 Baths \| 888 Sq. Ft.	$127,552
806 S Fairview Road #A, Columbia, MO 3 Beds \| 1.5 Baths \| 1461 Sq. Ft.	$203,918
804 S Fairview Road #A2S, Columbia, MO 2 Beds \| 1 Baths \| 888 Sq. Ft.	$117,813
820 S Fairview Road #S, Columbia, MO 4 Beds \| 2.5 Baths \| 1960 Sq. Ft.	—
814A B N Fairview Road, Columbia, MO 2 Beds \| 1 Baths \| 800 Sq. Ft.	—
810 S Fairview Road, Columbia, MO 3 Beds \| 1.5 Baths \| 1501 Sq. Ft.	$213,453

Address	Redfin Estimate
804 S Fairview Road #B5S, Columbia, MO 2 Beds \| 1 Baths \| 888 Sq. Ft.	$124,506
804 S Fairview Road #A1S, Columbia, MO 2 Beds \| 1 Baths \| 888 Sq. Ft.	$121,689
806 S Fairview Road #B, Columbia, MO 3 Beds \| 1.5 Baths \| 1461 Sq. Ft.	$204,886
810 S Fairview Road #B, Columbia, MO 3 Beds \| 1.5 Baths \| 1461 Sq. Ft.	$181,690
815 S Fairview Road #S, Columbia, MO 6 Beds \| 3 Baths \| 2784 Sq. Ft.	—
820 S Fairview Road #A & B, Columbia, MO - Beds \| - Baths \| - Sq. Ft.	—
804 S Fairview Road #A2, Columbia, MO 2 Beds \| 1 Baths \| 888 Sq. Ft.	$172,493

Property information provided by CBORMLS when last listed in 2023. 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
Boonville homes for sale