NOT LISTED FOR SALE

1702 S Fairview Rd Columbia, MO 65203

Columbia Area

Estimated Value: $551,619

4 Beds
3.5 Baths
4,428 Sq Ft
$125/Sq Ft Est. Value

Sale Details

Date Sold: May 21, 2026

Current estimated payment $3,604 / mo

5 Days on Market

Highlights

  • Deck
  • Partially Wooded Lot
  • Wood Flooring
  • Fairview Elementary School Rated A-
  • Traditional Architecture
  • Steam Shower

About This Home

As of May 2026

Fantastic 4-bed, 3.5-bath, 3-car garage, 4,428 sq ft 1.5-story home situated on a spacious 0.77-acre lot in Chapel Hill Estates. This property offers timeless curb appeal you simply can't replicate with new construction, featuring mature landscaping, a beautiful partially wooded lot, expansive deck, brick patio, and fully fenced backyard--perfect for entertaining family and friends. Step inside the foyer and be welcomed by a beautiful staircase and rich wood floors. The main level offers an office, a formal dining room for memorable gatherings, plus an updated kitchen with custom cabinetry, granite countertops, center island, and stainless steel appliances. The kitchen flows seamlessly into the connected living room, creating an ideal space for everyday living and entertaining. Upstairs, enjoy the privacy of having all bedrooms separate from the main living areas. The upper level includes a spacious primary suite, three additional bedrooms, and a second full bath. The primary suite features a walk-in closet, dual sinks, stand-alone shower, and large soaking tub. The lower level adds even more living space with a family room, theater/bonus room, and an incredible spa-like tiled bathroom complete with steam shower and large tub. This exceptional home combines space, character, and amenities in an established neighborhood.

Last Agent to Sell the Property

Sharon Bennett

REMAX Boone Realty License #1999080282 Listed on: 05/01/2026

Last Buyer's Agent

Bailey Langworthy

Atrium Realty, LLC License #2018013481

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,671

Year Built

  • Built in 1994

Lot Details

  • 33,541 Sq Ft Lot
  • Wood Fence
  • Back Yard Fenced
  • Sprinkler System
  • Partially Wooded Lot

HOA Fees

  • $17 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Traditional Architecture
  • Brick Veneer
  • Concrete Foundation
  • Poured Concrete
  • Architectural Shingle Roof

Interior Spaces

  • Wet Bar
  • Bar
  • Paddle Fans
  • Self Contained Fireplace Unit Or Insert
  • Screen For Fireplace
  • Gas Fireplace
  • Vinyl Clad Windows
  • Window Treatments
  • Family Room with Fireplace
  • Living Room with Fireplace
  • Formal Dining Room
  • Fire and Smoke Detector

Kitchen

  • Eat-In Kitchen
  • Electric Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Solid Surface Countertops
  • Utility Sink
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Bathroom on Main Level
  • Soaking Tub
  • Bathtub with Shower
  • Shower
  • Steam Shower
  • Garden Bath

Laundry

  • Laundry on main level
  • Washer and Dryer Hookup

Finished Basement

  • Walk-Out Basement
  • Interior Basement Entry

Outdoor Features

  • Deck
  • Covered Patio or Porch

Schools

  • Russell Boulevard Elementary School
  • Gentry Middle School
  • Rock Bridge High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Cable TV Available

Community Details

  • Chapel Hill Est Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1651500050020001

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,671

Year Built

Built in 1994

Lot Details

0.77 Acres

HOA Fees

$17 per month

Parking

3

Listing Details

  • Directions: Chapel Hill Rd to S Fairview Rd
  • Prop. Type: Residential
  • Full Bathroom Level: Upper
  • Half Bathroom Level: Main
  • Year Built: 1994
  • PropertyDisclosurePropertyDisclosureToBeProvided: Yes
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.77
  • Road Surface Type: Paved
  • Subdivision Name: CHAPEL HILL EST
  • Above Grade Finished Sq Ft: 3028.0
  • Architectural Style: Traditional
  • Garage Yn: Yes
  • Contract Information:Agreement Type: Exclusive Right to Sell
  • Contract Information:Lic Assisting Seller: Designated Seller's Agent
  • Contract Information:Owner_squote_s Legal Name: Andrew & Mary Elizabeth Jones
  • Contract Information:Title Held by: A Married Couple
  • General Property Description:AttachedDetached: Detached
  • General Property Description:Primary Style: 1.5 Story
  • General Property Description:Sq Ft Source: County Records
  • General Property Description:Age Description: 31-40 Yrs
  • General Property Description:Appx Fin Sq Ft Main _pound_: 1700.0
  • General Property Description:Appx Fin Sq Ft Lower _pound_: 1400.0
  • General Property Description:Appx Fin Sq Ft Upper _pound_: 1328.0
  • General Property Description:Appx Above Grade Sq: 3028.0
  • Location Tax Legal:Zoning2: Single Family Res
  • Location Tax Legal:School District2: Columbia
  • Location Tax Legal:Elementary Sch2: Russell Boulevard
  • Location Tax Legal:MiddleJr High Sch2: Gentry
  • Location Tax Legal:Senior Sch2: Rock Bridge
  • Location Tax Legal:HOACondo3: Yes
  • Location Tax Legal:HOACondo4: 200.0
  • Location Tax Legal:HOACondo Descrip2: Annual
  • Location Tax Legal:HOACondo Init3: No
  • Location Tax Legal:Condo Ext Maint: None
  • Location Tax Legal:Legal Description2: CHAPEL HILL ESTATES PLAT 1 LOT 2
  • Location Tax Legal:Auction2: No
  • Location Tax Legal:Land Lease Descrip2: N/A
  • Remarks Misc:Directions: Chapel Hill Rd to S Fairview Rd
  • Status Change Info:Financing: Conventional
  • Status Change Info:Price Withheld: No
  • Status Change Info:Sold Status: Board Mbr
  • Status Change Info:List PriceSqft: 123.76
  • Status Change Info:Sold PriceSqft: 123.76
  • Garage Type Attached: Yes
  • Cooling:Central Electric: Yes
  • Foundation Access:Walkout: Yes
  • Possession:At Closing: Yes
  • Foundation Material:Poured Concrete: Yes
  • RestrictionEasement:Recorded Plat: Yes
  • RestrictionEasement:Subdiv Restrictions: Yes
  • ArchStyle:Traditional: Yes
  • Deck:Back: Yes
  • TopoLot Description:Partially Wooded: Yes
  • Title Co:Boone Central Title Co: Yes
  • Roof:ArchitecturalShingle: Yes
  • Utilities:Gas-Natural: Yes
  • Will Sell:Cash: Yes
  • Will Sell:Conventional: Yes
  • Zoning:R-1 One- Family Dwelling_asterisk_: Yes
  • Flooring:Carpet: Yes
  • Flooring:Tile: Yes
  • Patio:Back3: Yes
  • General Property Description:_pound_ of Acres: 0.77
  • Location Tax Legal:Actual Taxes2: 5671.04
  • Location Tax Legal:Tax Yr2: 2025
  • Licensee PerInt Dis:Not Applicable: Yes
  • Foundation Access:Inside Entrance: Yes
  • Dining:Eat-In Kitchen: Yes
  • Dining:Formal Dining: Yes
  • Utilities:Electric-City: Yes
  • Flooring:Wood2: Yes
  • Porch:Covered2: Yes
  • Porch:Front2: Yes
  • Location Tax Legal:Cross Street2: Chapel Hill Rd
  • Foundation Type:Full Bsmt Full Fin: Yes
  • Crops:None19: Yes
  • Exterior Finish:Brick Veneer: Yes
  • Patio:Brick3: Yes
  • Location Tax Legal:Land Lease3: No
  • Location Tax Legal Senior Community: No
  • DelayedMarketingYN: No
  • Location Tax Legal:Located within City of Columbia2: Yes
  • Appliances:Dishwasher-Built In: Yes
  • Appliances:Garbage Disposal: Yes
  • Appliances:Microwave Oven: Yes
  • Fencing:Backyard: Yes
  • Fencing:Full: Yes
  • Road Responsibility:Public Maintained: Yes
  • Road Surface Type:Paved: Yes
  • Appliances:Range-Electric: Yes
  • Fencing:Wood5: Yes
  • Sewer:Public2: Yes
  • Lot Features: Full Sprinklers: Yes
  • OriginatingSystemPlatformID: T00000052
  • OriginatingSystemPlatformName: Flexmls
  • SourceSystemPlatformID: T00000052
  • SourceSystemPlatformName: Flexmls
  • Special Features: None

Interior Features

  • Has Basement: Full Bsmt Full Fin
  • Flooring: Wood, Carpet, Tile
  • Interior Amenities: Tub/Shower, Stand AloneShwr/MBR, Tub-Garden, WindowTreatmnts Some, Walk in Closet(s), Washer/DryerConnectn, Bar, Bar-Wet Bar, FireplaceScreenDr(s), Eat-in Kitchen, Formal Dining, Counter-SolidSurface, Cabinets-Wood, Kitchen Island, Pantry
  • Appliances: Microwave, Electric Range, Disposal, Dishwasher
  • Basement YN: Yes
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 1400.0
  • Fireplace Features: In Living Room, Gas, Fireplace Insert, In Family Room
  • Fireplace: Yes
  • Living Area: 4428.0
  • Window Features: Windows-Vinyl
  • General Property Description:_pound_ of Baths-Half: 1
  • General Property Description:Basement: Yes
  • Fireplace:Gas: Yes
  • Fireplace:In Family Room: Yes
  • InteriorFeatures:Cable Ready: Yes
  • InteriorFeatures:CeilingPaddleFan(s): Yes
  • InteriorFeatures:Laundry-Main Floor: Yes
  • InteriorFeatures:Smoke Detector(s): Yes
  • InteriorFeatures:Tub-Garden: Yes
  • InteriorFeatures:TubShower: Yes
  • InteriorFeatures:Walk in Closet(s): Yes
  • InteriorFeatures:WasherDryerConnectn: Yes
  • KitchenFeatures:Cabinets-Wood: Yes
  • KitchenFeatures:Counter-SolidSurface: Yes
  • KitchenFeatures:Island: Yes
  • Kitchen Features Pantry: Yes
  • Fireplace:In Living Room: Yes
  • InteriorFeatures:Bar-Wet Bar: Yes
  • InteriorFeatures:Stand AloneShwrMBR: Yes
  • InteriorFeatures:Utility Sink: Yes
  • Fireplace:Fireplace Insert: Yes
  • InteriorFeatures:FireplaceScreenDr(s): Yes
  • Rooms:Full Bathroom: Yes
  • InteriorFeatures:WindowTreatmnts Some: Yes
  • InteriorFeatures:Bar: Yes
  • Rooms:Half Bathroom: Yes
  • General Property Description:_pound_ of Bedrooms Above Grade: 4.0

Exterior Features

  • Exterior Features: Driveway-Paved
  • Roof: ArchitecturalShingle
  • Fencing: Backyard, Full, Wood
  • Lot Features: Sprinkler-In Ground
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Covered, Back, Brick, Deck, Front Porch
  • Exterior Features:Driveway-Paved: Yes
  • Exterior Features:Windows-Vinyl: Yes

Garage/Parking

  • Garage Spaces: 3.0
  • Parking Features: Garage Dr Opener(s), Attached
  • General Property Description:Garage Capacity: 3
  • InteriorFeatures:Garage Dr Opener(s): Yes

Utilities

  • Utilities: Water-City, Cable Ready, Electric-City, Trash-City
  • Cooling: Central Electric, Ceiling/PaddleFan(s)
  • Heating: Forced Air, Natural Gas
  • Laundry Features: Utility Sink, Laundry-Main Floor
  • Security: Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities:Trash-City: Yes
  • Heating:Forced Air: Yes
  • Heating:Natural Gas: Yes
  • Water Source: Public: Yes

Condo/Co-op/Association

  • Senior Community: No
  • Association Fee: 200.0
  • Association Fee Frequency: Annual
  • Association: Yes

Schools

  • Elementary School: Russell Boulevard
  • Junior High Dist: Columbia
  • High School: Rock Bridge
  • Middle Or Junior School: Gentry

Lot Info

  • Zoning: Single Family Res
  • Land Lease Amount Frequency: N/A
  • Land Lease: No
  • Lot Size Sq Ft: 33541.2
  • Parcel #: 1651500050020001
  • Zoning Description: R-1 One- Family Dwelling*

Tax Info

  • Tax Annual Amount: 5671.04
  • Tax Year: 2025

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
May 1, 2026
Closed on
May 21, 2026
Sold by
Elizabeth Jones and Elizabeth Mary
Bought by
Seller's Agent
Sharon Bennett
REMAX Boone Realty
Buyer's Agent
Bailey Langworthy
Atrium Realty, LLC
List Price
$548,000
Views
19
Current Estimated Value
$551,619

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
1.95%
Original Mortgage
$248,000
Outstanding Balance
$247,307
Interest Rate
6.37%
Mortgage Type
New Conventional
Estimated Equity
$304,312

Purchase Details

Listed on
Sep 6, 2019
Closed on
Feb 4, 2020
Sold by
Atkins Lori F and Atkins David F
Bought by
Jones Andrew and Jones Mary Elizabeth
Seller's Agent
Freddy Spencer
Iron Gate Real Estate
Buyer's Agent
C. Scott Rutter
Weichert, Realtors - House of Brokers
List Price
$460,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.47%
Original Mortgage
$332,800
Interest Rate
3.74%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jun 18, 2013
Sold by
Kreisel Eldon A
Bought by
Steinerfiend Investments Llc

Purchase Details

Closed on
Jul 20, 2008
Sold by
Atkins David F and Atkins Lori F
Bought by
Atkins David F and Atkins Lori F
Source: Public Records

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
-- Boone Central Title
Jones Andrew -- None Available
Steinerfiend Investments Llc -- None Available
Steinerfiend Investments Llc -- None Available
Atkins David F -- None Available
Atkins Lori F -- None Available
Atkins David F -- None Available
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open $248,000
Previous Owner Jones Andrew $332,800
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft Prior Sale
05/21/2026 05/21/26 Sold -- -- --
05/06/2026 05/06/26 Pending -- -- --
05/01/2026 05/01/26 For Sale $548,000 +19.1% $124 / Sq Ft
02/04/2020 02/04/20 Sold -- -- -- View Prior Sale
12/24/2019 12/24/19 Pending -- -- --
09/06/2019 09/06/19 For Sale $460,000 -- $104 / Sq Ft
Source: Columbia Board of REALTORS®

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $5,671 $86,602 $9,500 $77,102
2024 $5,103 $75,639 $9,500 $66,139
2023 $5,061 $75,639 $9,500 $66,139
2022 $4,861 $72,732 $9,500 $63,232
2021 $4,870 $72,732 $9,500 $63,232
2020 $4,984 $69,939 $9,500 $60,439
2019 $4,984 $69,939 $9,500 $60,439
2018 $5,019 $0 $0 $0
2017 $4,958 $69,939 $9,500 $60,439
2016 $5,928 $69,939 $9,500 $60,439
2015 $4,695 $69,939 $9,500 $60,439
2014 -- $69,939 $9,500 $60,439
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Columbia Board of REALTORS®

MLS Number: 434328

Columbia Board of REALTORS®

APN: 16-515-00-05-002-00-01

Your Personal Tour Guide

Ask me questions while you tour the home.