NOT LISTED FOR SALE

4900 N Clearview Rd Columbia, MO 65202

Estimated Value: $266,000 - $297,000

3 Beds
2.5 Baths
1,725 Sq Ft
$167/Sq Ft Est. Value

Last Sold October 31, 2023

Current estimated payment $1,720/month

69 Days on Market

Highlights

  • Deck
  • Traditional Architecture
  • No HOA
  • Smithton Middle School Rated A-
  • Main Floor Primary Bedroom
  • Lower Floor Utility Room

About This Home

As of October 2023

This home is located at 4900 N Clearview Rd, Columbia, MO 65202 since 07 July 2023 and is currently estimated at $288,669, approximately $167 per square foot. This property was built in 2021. 4900 N Clearview Rd is a home located in Boone County with nearby schools including Parkade Elementary School, Smithton Middle School, and David H. Hickman High School.

Last Agent to Sell the Property

Mary Blunt

EPIC Real Estate Group License #2018045281 Listed on: 07/07/2023

Last Buyer's Agent

Sean Moore

RE/MAX Boone Realty License #2004031970

RE/MAX Boone Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,140

Year Built

  • Built in 2021

Lot Details

  • 7,841 Sq Ft Lot
  • West Facing Home
  • Back Yard Fenced
  • Aluminum or Metal Fence
  • Zoning described as PD- Residential*

Parking

  • 2 Car Attached Garage
  • Driveway

Home Design

  • Traditional Architecture
  • Concrete Foundation
  • Poured Concrete
  • Architectural Shingle Roof
  • Vinyl Construction Material

Interior Spaces

  • 1,725 Sq Ft Home
  • 2-Story Property
  • Ceiling Fan
  • Paddle Fans
  • Vinyl Clad Windows
  • Living Room
  • Combination Kitchen and Dining Room
  • Lower Floor Utility Room
  • Washer and Dryer Hookup
  • Utility Room
  • Unfinished Basement
  • Walk-Out Basement
  • Fire and Smoke Detector

Kitchen

  • Electric Range
  • Convection Microwave
  • Dishwasher
  • Disposal

Flooring

  • Carpet
  • Vinyl

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Primary Bedroom on Main
  • Walk-In Closet

Outdoor Features

  • Deck
  • Front Porch

Schools

  • Alpha Hart Lewis Elementary School
  • West Middle School
  • Hickman High School

Utilities

  • Forced Air Heating and Cooling System

Community Details

  • No Home Owners Association
  • Crestwood Hills Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1190725010860001

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,140

Year Built

Built in 2021

Lot Details

0

Parking

2

Listing Details

  • Directions: E Brown School Rd right onto N Clearview house on the right
  • Prop. Type: Residential
  • Bedroom 2 Level: Upper
  • Kitchen Level: Main
  • Living Room Level: Main
  • Primary Bedroom Level: Main
  • Year Built: 2021
  • BathsFull34MainLevel: 1
  • BathsFull34Total: 2
  • BathsFull34UpperLevel: 1
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.18
  • Road Surface Type: Public Maintained
  • Subdivision Name: CRESTWOOD HILLS
  • Above Grade Finished Sq Ft: 1725.0
  • Architectural Style: 2 Story
  • Garage Type Attached: Yes
  • Cooling:Central Electric: Yes
  • Foundation Access:Walkout: Yes
  • Foundation Material:Poured Concrete: Yes
  • ArchStyle:Traditional: Yes
  • Deck:Back: Yes
  • Roof:ArchitecturalShingle: Yes
  • Flooring:Carpet: Yes
  • Heat Type:Forced Air: Yes
  • Baths-Half:Main Level2: 1
  • Baths-Half:Total2: 1
  • Rooms:Living Room: Yes
  • Dining:KitDin Combo: Yes
  • Flooring:Vinyl3: Yes
  • Heat Fuel:Electricity: Yes
  • Foundation Type:Full Bsmt Unfinished: Yes
  • Fence:Backyard: Yes
  • Exterior Finish:Vinyl2: Yes
  • Porch:Front2: Yes
  • Fence Material:Metal4: Yes
  • Special Features: None

Interior Features

  • Bedroom 3 Level: Upper
  • Utility Room Level: Lower
  • Flooring: Carpet, Vinyl
  • Interior Amenities: Walk in Closet(s), Washer/DryerConnectn, Main Lvl Master Bdrm, Ceiling/PaddleFan(s), Smoke Detector(s), Kit/Din Combo
  • Basement YN: Yes
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Living Area: 1725.0
  • InteriorFeatures:CeilingPaddleFan(s): Yes
  • InteriorFeatures:Main Lvl Master Bdrm: Yes
  • InteriorFeatures:Smoke Detector(s): Yes
  • InteriorFeatures:Walk in Closet(s): Yes
  • InteriorFeatures:WasherDryerConnectn: Yes
  • KitchenFeatures:Dishwasher-Built In: Yes
  • KitchenFeatures:Garbage Disposal: Yes
  • KitchenFeatures:Microwave - Convection: Yes
  • KitchenFeatures:Refrigerator: Yes
  • KitchenFeatures:Range-Electric: Yes

Exterior Features

  • Exterior Features: Driveway-Paved, Windows-Vinyl
  • Roof: ArchitecturalShingle
  • Fencing: Backyard, Metal
  • Direction Faces: West
  • Foundation Details: Poured Concrete
  • Other Structures: None
  • Patio And Porch Features: Deck, Front Porch
  • Exterior Features:Driveway-Paved: Yes
  • Exterior Features:Windows-Vinyl: Yes

Garage/Parking

  • Garage Spaces: 2.0
  • Parking Features: Attached
  • General Property Description:Garage Capacity: 2

Utilities

  • Cooling: Central Electric
  • Heating: Forced Air, Electric
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Association: No

Schools

  • Elementary School: Alpha Hart Lewis
  • Junior High Dist: Columbia
  • High School: Hickman
  • Middle Or Junior School: West

Lot Info

  • Land Lease Amount Frequency: N/A
  • Land Lease: No
  • Lot Size Sq Ft: 7840.8
  • Parcel #: 1190725010860001
  • Zoning Description: PD- Residential*
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Annual Amount: 2139.88
  • Tax Year: 2022

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 7, 2023
Closed on
Oct 31, 2023
Sold by
Hbh Holding Company Llc
Bought by
Fredericksen Jennifer and Fredericksen Jamie
Seller's Agent
Mary Blunt
EPIC Real Estate Group
Buyer's Agent
Sean Moore
RE/MAX Boone Realty
List Price
$319,900
Views
176
Current Estimated Value
$288,669

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.65%
Original Mortgage
$269,069
Outstanding Balance
$264,090
Interest Rate
7.19%
Mortgage Type
VA
Estimated Equity
$24,579

Purchase Details

Closed on
Jun 19, 2023
Sold by
Webb Anthony
Bought by
Hbh Holding Company Llc

Purchase Details

Closed on
Oct 25, 2021
Sold by
Baker Larry and Baker Wilma J
Bought by
Webb Anthony and Coffman Mercedes Kaila

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$245,217
Interest Rate
2.8%
Mortgage Type
New Conventional

Purchase Details

Closed on
Sep 18, 2020
Sold by
Howe Ricky L
Bought by
Baker Larry and Baker Wilma J
Source: Public Records

Range of Values:

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 Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Fredericksen Jennifer -- None Listed On Document
Hbh Holding Company Llc $237,022 None Listed On Document
Hbh Holding Company Llc $237,022 None Listed On Document
Webb Anthony -- Boone Central Title Company
Baker Larry -- Boone Central Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Fredericksen Jennifer $269,069
Previous Owner Webb Anthony $245,217
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
10/31/2023 10/31/23 Sold -- -- --
09/15/2023 09/15/23 Pending -- -- --
09/12/2023 09/12/23 Price Changed $284,900 -1.7% $165 / Sq Ft
09/01/2023 09/01/23 Price Changed $289,900 -3.3% $168 / Sq Ft
07/18/2023 07/18/23 Price Changed $299,900 -6.3% $174 / Sq Ft
07/07/2023 07/07/23 For Sale $319,900 -- $185 / Sq Ft
Source: Columbia Board of REALTORS®

Tax History Compared to Growth

Source: Public Records

Tax History

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 $2,333 $35,492 $2,717 $32,775
2024 $2,333 $32,262 $2,717 $29,545
2023 $2,313 $32,262 $2,717 $29,545
2022 $2,140 $29,868 $2,717 $27,151
2021 $195 $2,717 $2,717 $0
2020 $155 $2,033 $2,033 $0
2019 $155 $2,033 $2,033 $0
2018 $156 $0 $0 $0
2017 $154 $2,033 $2,033 $0
2016 $154 $2,033 $2,033 $0
2015 $142 $2,033 $2,033 $0
2014 $142 $2,033 $2,033 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Columbia Board of REALTORS®

MLS Number: 414707

Columbia Board of REALTORS®

APN: 11-907-25-01-086-00-01