NOT LISTED FOR SALE

1604 Pickard Way Columbia, MO 65203

Columbia Area

Estimated Value: $308,000 - $329,000

3 Beds
2 Baths
1,600 Sq Ft
$200/Sq Ft Est. Value

Sale Details

Date Sold: July 8, 2022

Current estimated payment $1,981 / mo

35 Days on Market

Highlights

  • Ranch Style House
  • Partially Wooded Lot
  • No HOA
  • Fairview Elementary School Rated A-
  • Wood Flooring
  • Covered Patio or Porch

About This Home

As of July 2022

Open floor plan with wood floors and large windows! The kitchen has great counter space and cabinet storage. Plus a flex room that includes space for a home office, the laundry area and access to the crawl space where you will find the new tankless water heater. The Master suite features a large walk-in closet and full bathroom. Enjoy time on the large patio out back in the fully fenced backyard.
Seller will provide copy of current home inspection report upon request. Reduced price takes report and subsequent repairs into account.

Last Agent to Sell the Property

Jason Thornhill

Weichert, Realtors - House of Brokers License #2002001716 Listed on: 05/25/2022

Weichert, Realtors - House of Brokers

Co-Listed By

Stephanie Baehman

Weichert, Realtors - House of Brokers License #2016033737

Last Buyer's Agent

LISA SIVRET

Iron Gate Real Estate

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

  • $2,131

Year Built

  • Built in 1987 | Remodeled

Lot Details

  • Lot Dimensions are 80 x 115.21
  • Cul-De-Sac
  • Wood Fence
  • Back Yard Fenced
  • Lot Has A Rolling Slope
  • Partially Wooded Lot

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Ranch Style House
  • Traditional Architecture
  • Brick Veneer
  • Concrete Foundation
  • Poured Concrete
  • Architectural Shingle Roof
  • Vinyl Construction Material

Interior Spaces

  • 1,600 Sq Ft Home
  • Paddle Fans
  • Window Treatments
  • Wood Frame Window
  • Combination Dining and Living Room
  • Attic Fan
  • Storm Doors

Kitchen

  • Electric Range
  • Microwave
  • Dishwasher
  • Laminate Countertops
  • Disposal

Flooring

  • Wood
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet
  • 2 Full Bathrooms
  • Bathtub with Shower

Laundry

  • Laundry on main level
  • Washer and Dryer Hookup

Basement

  • Interior Basement Entry
  • Sump Pump
  • Crawl Space

Outdoor Features

  • Covered Patio or Porch

Schools

  • Fairview Elementary School
  • Smithton Middle School
  • Hickman High School

Utilities

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

Community Details

  • No Home Owners Association
  • University Park Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1651400013220001

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,131

Year Built

Built in 1987 | Remodeled

Lot Details

0 Sq Ft Lot

Parking

2

Listing Details

  • Directions: Broadway to Fairview, Right on Chapel Hill, Right on Cunningham, Right on Jake Ln, right on Pickard Way.
  • Lot Size: 80 x 115.21
  • Prop. Type: Residential
  • Bedroom 2 Level: Main
  • Dining Room Level: Main
  • Kitchen Level: Main
  • Living Room Level: Main
  • Primary Bedroom Level: Main
  • Year Built: 1987
  • BathsFull34MainLevel: 2
  • BathsFull34Total: 2
  • EnergyAuditEnergyAuditCompleted: No
  • PropertyDisclosurePropertyDisclosureToBeProvided: Yes
  • Property Sub Type: Single Family Residence
  • Road Surface Type: Paved, Public Maintained, Curbs and Gutters, Cul-de-sac
  • Co List Office Phone: 573-256-8601
  • Subdivision Name: UNIVERSITY PARK
  • Above Grade Finished Sq Ft: 1600.0
  • Architectural Style: Ranch
  • New Construction: No
  • Contract Information:Agreement Type: Exclusive Right to Sell
  • Contract Information:Lic Assisting Seller: Designated Seller's Agent
  • Contract Information:Owner_squote_s Legal Name: Tyler and Christine Lero
  • Contract Information:Title Held by: A Married Couple
  • General Property Description:AttachedDetached: Detached
  • General Property Description:Primary Style: Ranch
  • General Property Description:Sq Ft Source: Listing Agent
  • General Property Description:Age Description: 31-40 Yrs
  • General Property Description:Lot Dimensions: 80 x 115.21
  • General Property Description:Appx Fin Sq Ft Main _pound_: 1600.0
  • General Property Description:Appx Above Grade Sq: 1600.0
  • Location Tax Legal:Zoning2: Single Family Res
  • Location Tax Legal:School District2: Columbia
  • Location Tax Legal:Elementary Sch2: Fairview
  • Location Tax Legal:MiddleJr High Sch2: Smithton
  • Location Tax Legal:Senior Sch2: Hickman
  • Location Tax Legal:HOACondo3: No
  • Location Tax Legal:HOACondo Descrip2: N/A
  • Location Tax Legal:HOACondo Init3: No
  • Location Tax Legal:Condo Ext Maint: None
  • Location Tax Legal:Legal Description2: University Park Add #10 Lot 34
  • Location Tax Legal:Auction2: No
  • Location Tax Legal:Land Lease Descrip2: N/A
  • Remarks Misc:Directions: Broadway to Fairview, Right on Chapel Hill, Right on Cunningham, Right on Jake Ln, right on Pickard Way.
  • Status Change Info:Financing: Conventional
  • Status Change Info:Price Withheld: No
  • Status Change Info:Sold Status: Inner Office
  • Status Change Info:List PriceSqft: 159.38
  • Status Change Info:Sold PriceSqft: 159.38
  • Garage Type Attached: Yes
  • Cooling:Central Electric: Yes
  • Possession:At Closing: Yes
  • Foundation Material:Poured Concrete: Yes
  • RestrictionEasement:Recorded Plat: Yes
  • RestrictionEasement:Subdiv Restrictions: Yes
  • ArchStyle:Traditional: Yes
  • Dining:LivDin Combo: Yes
  • TopoLot Description:Partially Wooded: Yes
  • Roof:ArchitecturalShingle: Yes
  • Utilities:Gas-Natural: Yes
  • Will Sell:Cash: Yes
  • Will Sell:Conventional: Yes
  • Will Sell:FHA: Yes
  • Will Sell:VA: Yes
  • Zoning:R-1 One- Family Dwelling_asterisk_: Yes
  • Flooring:Tile: Yes
  • Heat Fuel:Natural Gas: Yes
  • Heat Type:Forced Air: Yes
  • Patio:Back3: Yes
  • Baths-Half:Total2: 0
  • StreetRoads:Curbs and Gutters: Yes
  • StreetRoads:Paved: Yes
  • StreetRoads:Public Maintained: Yes
  • Location Tax Legal:Actual Taxes2: 2131.02
  • Location Tax Legal:Tax Yr2: 2021
  • Location Tax Legal:Other Fees2: NO
  • Licensee PerInt Dis:Not Applicable: Yes
  • Rooms:Dining Room: Yes
  • Rooms:Living Room: Yes
  • Rooms:Other9: Yes
  • Foundation Access:Inside Entrance: Yes
  • RestrictionEasement:Zoning Regulations Apply: Yes
  • Utilities:Electric-City: Yes
  • Utilities:Sewage-City: Yes
  • Utilities:Water-City: Yes
  • Flooring:Wood2: Yes
  • Patio:Concrete2: Yes
  • StreetRoads:Cul-de-sac: Yes
  • Fence:Backyard: Yes
  • Exterior Finish:Vinyl2: Yes
  • Porch:Covered2: Yes
  • Porch:Front2: Yes
  • Foundation Type:Crawl Space: Yes
  • Fence Material:Wood5: Yes
  • Location Tax Legal:Cross Street2: Jake Ln
  • Title Co:Monarch Title Co: Yes
  • Crops:None19: Yes
  • RestrictionEasement:EasementsRightofWay: Yes
  • Fence:Full: Yes
  • Exterior Finish:Brick Veneer: Yes
  • TopoLot Description:Rolling: Yes
  • Special Features: None

Interior Features

  • Has Basement: Sump Pump, Crawl Space
  • Bedroom 3 Level: Main
  • Bedrooms Other Level: Main
  • Flooring: Wood, Tile
  • Interior Amenities: Tub/Shower, Window Treatmnts All, Walk in Closet(s), Washer/DryerConnectn, Main Lvl Master Bdrm, Attic Fan, Liv/Din Combo, Counter-Laminate, Cabinets-Wood
  • Basement YN: No
  • Full Bathrooms: 2
  • Total Bedrooms: 3
  • Door Features: Storm Door(s)
  • Living Area: 1600.0
  • Window Features: Windows-Wood
  • General Property Description:Basement: No
  • InteriorFeatures:Cable Ready: Yes
  • InteriorFeatures:CeilingPaddleFan(s): Yes
  • InteriorFeatures:Laundry-Main Floor: Yes
  • InteriorFeatures:Main Lvl Master Bdrm: Yes
  • InteriorFeatures:TubShower: Yes
  • InteriorFeatures:Walk in Closet(s): Yes
  • InteriorFeatures:WasherDryerConnectn: Yes
  • KitchenFeatures:Cabinets-Wood: Yes
  • KitchenFeatures:Dishwasher-Built In: Yes
  • KitchenFeatures:Garbage Disposal: Yes
  • KitchenFeatures:Microwave Oven: Yes
  • Rooms:Bedroom 2: Yes
  • Rooms:Bedroom 3: Yes
  • Rooms:Kitchen: Yes
  • Rooms:Master Bedroom: Yes
  • InteriorFeatures:Cable Available: Yes
  • InteriorFeatures:Remodeled: Yes
  • InteriorFeatures:Window Treatmnts All: Yes
  • KitchenFeatures:Refrigerator: Yes
  • KitchenFeatures:Range-Electric: Yes
  • KitchenFeatures:Vent Fan: Yes
  • InteriorFeatures:Storm Door(s): Yes
  • KitchenFeatures:Counter-Laminate: Yes
  • InteriorFeatures:Sump Pump: Yes
  • InteriorFeatures:Attic Fan: Yes
  • InteriorFeatures:TanklessInstant Water Heater: Yes

Exterior Features

  • Exterior Features: Driveway-Paved
  • Roof: ArchitecturalShingle
  • Fencing: Backyard, Full, Wood
  • Lot Features: Rolling Slope
  • Foundation Details: Poured Concrete
  • Other Structures: None
  • Patio And Porch Features: Concrete, Back, Front Porch
  • Property Condition: Remodeled
  • Exterior Features:Driveway-Paved: Yes
  • Exterior Features:Windows-Wood: Yes
  • Outbuildings:None16: Yes

Garage/Parking

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

Utilities

  • Utilities: Cable Available, Water-City, Cable Ready, Gas-Natural, Sewage-City, Electric-City, Trash-City
  • Cooling: Central Electric, Ceiling/PaddleFan(s)
  • Heating: Forced Air, Natural Gas
  • Laundry Features: Laundry-Main Floor
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities:Trash-City: Yes

Condo/Co-op/Association

  • Association Fee Frequency: N/A
  • Association: No

Schools

  • Elementary School: Fairview
  • Junior High Dist: Columbia
  • High School: Hickman
  • Middle Or Junior School: Smithton

Lot Info

  • Land Lease Amount Frequency: N/A
  • Land Lease: No
  • Parcel #: 1651400013220001
  • Zoning Description: R-1 One- Family Dwelling*

Tax Info

  • Tax Annual Amount: 2131.02
  • Tax Year: 2021

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 25, 2022
Closed on
Jun 30, 2022
Sold by
Lero Tyler F and Lero Christine M
Bought by
Seller's Agent
Jason Thornhill
Weichert, Realtors - House of Brokers
Buyer's Agent
LISA SIVRET
Iron Gate Real Estate
List Price
$270,000
Current Estimated Value
$319,999

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.61%
Original Mortgage
$226,000
Outstanding Balance
$211,002
Interest Rate
4.75%
Mortgage Type
New Conventional
Estimated Equity
$108,997

Purchase Details

Listed on
Feb 25, 2017
Closed on
Apr 4, 2017
Sold by
Deng Yang and Deng Dawei
Bought by
Lero Tyler F and Lero Christine M
Seller's Agent
Cindy Whitby
REMAX Boone Realty
Buyer's Agent
Jason Thornhill
Weichert, Realtors - House of Brokers
List Price
$192,500

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.87%
Original Mortgage
$183,330
Interest Rate
4.16%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jun 14, 2010
Sold by
Sherman Marion E
Bought by
Deng Yang

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$132,000
Interest Rate
5.02%
Mortgage Type
New Conventional
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
-- None Listed On Document
Lero Tyler F -- None Available
Deng Yang -- 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 $226,000
Previous Owner Lero Tyler F $183,330
Previous Owner Deng Yang $132,000
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
07/08/2022 07/08/22 Sold -- -- --
06/09/2022 06/09/22 Off Market -- -- --
06/08/2022 06/08/22 Price Changed $255,000 -5.6% $159 / Sq Ft
05/25/2022 05/25/22 For Sale $270,000 0.0% $169 / Sq Ft
05/12/2022 05/12/22 Off Market -- -- --
05/05/2022 05/05/22 For Sale $270,000 +40.3% $169 / Sq Ft
04/10/2017 04/10/17 Sold -- -- -- View Prior Sale
03/04/2017 03/04/17 Pending -- -- --
01/31/2017 01/31/17 For Sale $192,500 -- $120 / 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 $2,577 $39,349 $5,244 $34,105
2024 $2,319 $34,371 $5,244 $29,127
2023 $2,300 $34,371 $5,244 $29,127
2022 $2,127 $31,825 $5,244 $26,581
2021 $2,131 $31,825 $5,244 $26,581
2020 $2,100 $29,467 $5,244 $24,223
2019 $2,100 $29,467 $5,244 $24,223
2018 $1,958 $0 $0 $0
2017 $1,934 $27,284 $5,244 $22,040
2016 $1,985 $27,284 $5,244 $22,040
2015 $1,831 $27,284 $5,244 $22,040
2014 -- $27,284 $5,244 $22,040
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Columbia Board of REALTORS®

MLS Number: 406807

Columbia Board of REALTORS®

APN: 16-514-00-01-322-00-01

Your Personal Tour Guide

Ask me questions while you tour the home.