$198,880
PENDING $30K PRICE DROP

400 Auburn Ln Columbia, MO 65203

Estimated payment $1,177/month

Total Views 14,712
2 Beds
1.5 Baths
840 Sq Ft
$237 Price per Sq Ft

Highlights

  • Solar Power System
  • Traditional Architecture
  • Main Floor Primary Bedroom
  • David H. Hickman High School Rated A-
  • Wood Flooring
  • No HOA

About This Home

Discover a truly one-of-a-kind retreat in the heart of Columbia. This unique & meticulously maintained 2-bedroom, 1.5-bath home sits on a HUGE, nearly half-acre lot (131' x 150'), a rare find for such a central location. Enjoy immediate peace of mind with high-end upgrades, including Dogwood Solar panels, a Culligan HE water system, and updated electrical, windows, HVAC, and water heater. The roof is newer, and all appliances (including the washer & dryer) stay with the home. Whether you are looking for a private, tree-lined sanctuary or a strategic investment, the R-2 zoning and expansive footprint offer endless possibilities at a very affordable price. Schedule your showing soon!

Listing Agent

Aaron Rose

REMAX Boone Realty License #2001029684 Listed on: 04/14/2026

REMAX Boone Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $1,218

Year Built

  • Built in 1953

Lot Details

  • Lot Dimensions are 131.46 x 150.00
  • Cul-De-Sac
  • North Facing Home
  • Back Yard Fenced
  • Wire Fence
  • Vegetable Garden
  • Zoning described as R-2 Two- Family Dwelling*

Parking

  • 1 Car Attached Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Traditional Architecture
  • Brick Veneer
  • Slab Foundation
  • Architectural Shingle Roof
  • Vinyl Construction Material

Interior Spaces

  • 840 Sq Ft Home
  • Paddle Fans
  • Vinyl Clad Windows
  • Window Treatments
  • Combination Dining and Living Room
  • Crawl Space

Kitchen

  • Electric Range
  • Dishwasher
  • Laminate Countertops
  • Built-In or Custom Kitchen Cabinets
  • Disposal

Flooring

  • Wood
  • Vinyl

Bedrooms and Bathrooms

  • 2 Bedrooms
  • Primary Bedroom on Main
  • Bathroom on Main Level
  • Bathtub with Shower

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Home Security

  • Smart Thermostat
  • Storm Doors
  • Fire and Smoke Detector

Eco-Friendly Details

  • Solar Power System

Outdoor Features

  • Covered Patio or Porch
  • Storage Shed

Schools

  • West Boulevard Elementary School
  • West Middle School
  • Hickman High School

Utilities

  • Cooling Available
  • Forced Air Heating System
  • Heating System Uses Natural Gas
  • Baseboard Heating
  • Programmable Thermostat
  • Water Softener is Owned

Community Details

  • No Home Owners Association
  • Hunthill Sub Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1631700050330001

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,218

Year Built

Built in 1953

Lot Details

0 Sq Ft Lot

Parking

1

Listing Details

  • Directions: CHALLENGING TO FIND! PLEASE USE GOOGLE.COM/MAPS *OR* FROM THE INTERSECTION OF W WORLEY & WEST BLVD N - TRAVEL WEST ON W WORLEY. TURN LEFT (SOUTH) ON AUBURN LN *WHICH IS NOT MARKED*! PROPERTY IS LOCATED AT THE END OF AUBURN LN.
  • Lot Size: 131.46 X 150.00
  • Prop. Type: Residential
  • Full Bathroom Level: Main
  • Half Bathroom Level: Main
  • Year Built: 1953
  • Property Sub Type: Single Family Residence
  • Road Surface Type: Paved, Cul-de-sac
  • Subdivision Name: HUNTHILL SUB
  • Above Grade Finished Sq Ft: 840.0
  • Architectural Style: Traditional
  • Garage Yn: Yes
  • Green Power: Solar Panels
  • Garage Type Attached: Yes
  • ArchStyle:Traditional: Yes
  • Dining:LivDin Combo: Yes
  • Roof:ArchitecturalShingle: Yes
  • Utilities:Gas-Natural: Yes
  • Utilities:Electric-City: Yes
  • Flooring:Vinyl3: Yes
  • Flooring:Wood2: Yes
  • Exterior Finish:Vinyl2: Yes
  • Porch:Covered2: Yes
  • Porch:Front2: Yes
  • Foundation Type:Crawl Space: Yes
  • Foundation Type:Slab: Yes
  • Exterior Finish:Brick Veneer: Yes
  • Appliances:Dishwasher-Built In: Yes
  • Appliances:Garbage Disposal: Yes
  • Fencing:Backyard: Yes
  • Fencing:Full: Yes
  • Appliances:Range-Electric: Yes
  • Fencing: Chain Link: Yes
  • Appliances: Dryer: Yes
  • Lot Features: Cul-De-Sac: Yes
  • Appliances: Water Softener Owned: Yes
  • Sewer:Public2: Yes
  • Appliances:Washing Machine2: Yes
  • Special Features: None

Interior Features

  • Has Basement: Crawl Space
  • Flooring: Wood, Vinyl
  • Interior Amenities: Tub/Shower, Window Treatmnts All, Washer/DryerConnectn, Main Lvl Master Bdrm, Smart Thermostat, Liv/Din Combo, Cabinets-Custom Blt, Counter-Laminate, Cabinets-Wood
  • Appliances: Refrigerator, Electric Range, Disposal, Dishwasher, Dryer, Water Softener Owned
  • Basement YN: No
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Total Bedrooms: 2
  • Door Features: Storm Door(s)
  • Living Area: 840.0
  • Window Features: Windows-Vinyl
  • InteriorFeatures:CeilingPaddleFan(s): Yes
  • InteriorFeatures:Laundry-Main Floor: Yes
  • InteriorFeatures:Main Lvl Master Bdrm: Yes
  • InteriorFeatures:Smoke Detector(s): Yes
  • InteriorFeatures:TubShower: Yes
  • InteriorFeatures:WasherDryerConnectn: Yes
  • KitchenFeatures:Cabinets-Custom Blt: Yes
  • KitchenFeatures:Cabinets-Wood: Yes
  • InteriorFeatures:Programmable Thermostat(s): Yes
  • InteriorFeatures:Window Treatmnts All: Yes
  • InteriorFeatures:Storm Door(s): Yes
  • KitchenFeatures:Counter-Laminate: Yes

Exterior Features

  • Builder Name: UNKNOWN
  • Exterior Features: Vegetable Garden, Driveway-Paved
  • Roof: ArchitecturalShingle
  • Fencing: Backyard, Full, Wire, Chain Link
  • Direction Faces: North
  • Foundation Details: Slab
  • Other Structures: Lawn/Storage Shed
  • Patio And Porch Features: Covered, Front Porch
  • Exterior Features:Driveway-Paved: Yes
  • Exterior Features:Windows-Vinyl: Yes
  • Exterior Features:Vegetable Garden: Yes
  • Exterior Features:Solar Panels: Yes

Garage/Parking

  • Garage Spaces: 1.0
  • Parking Features: Garage Dr Opener(s), Built-In, Attached
  • General Property Description:Garage Capacity: 1
  • InteriorFeatures:Garage Dr Opener(s): Yes
  • Garage Type:Built-In: Yes
  • Foundation Access:Garage: Yes

Utilities

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

Condo/Co-op/Association

  • Senior Community: No
  • Association: No

Schools

  • Elementary School: West Boulevard
  • Junior High Dist: Columbia
  • High School: Hickman
  • Middle Or Junior School: West

Lot Info

  • Zoning: Single Family Res
  • Land Lease Amount Frequency: N/A
  • Land Lease: No
  • Parcel #: 1631700050330001
  • Zoning Description: R-2 Two- Family Dwelling*

Tax Info

  • Tax Annual Amount: 1218.06
  • Tax Year: 2025

Map

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

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 $1,218 $18,601 $5,073 $13,528
2024 $1,096 $16,245 $5,073 $11,172
2023 $1,087 $16,245 $5,073 $11,172
2022 $1,006 $15,048 $5,073 $9,975
2021 $1,008 $15,048 $5,073 $9,975
2020 $958 $13,440 $5,073 $8,367
2019 $958 $13,440 $5,073 $8,367
2018 $893 $0 $0 $0
2017 $882 $12,445 $5,073 $7,372
2016 $906 $12,445 $5,073 $7,372
2015 $835 $12,445 $5,073 $7,372
2014 -- $12,445 $5,073 $7,372
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
07/10/2026 07/10/26 Pending -- -- --
07/08/2026 07/08/26 Price Changed $198,880 -0.5% $237 / Sq Ft
06/19/2026 06/19/26 Price Changed $199,880 -2.4% $238 / Sq Ft
06/12/2026 06/12/26 Price Changed $204,880 -2.4% $244 / Sq Ft
06/05/2026 06/05/26 Price Changed $209,880 -2.3% $250 / Sq Ft
05/22/2026 05/22/26 Price Changed $214,728 -1.4% $256 / Sq Ft
05/15/2026 05/15/26 Price Changed $217,728 -0.9% $259 / Sq Ft
05/08/2026 05/08/26 Price Changed $219,728 -3.5% $262 / Sq Ft
04/14/2026 04/14/26 Price Changed $227,728 0.0% $271 / Sq Ft
04/14/2026 04/14/26 For Sale $227,728 -0.4% $271 / Sq Ft
04/08/2026 04/08/26 Pending -- -- --
04/02/2026 04/02/26 For Sale $228,728 -- $272 / Sq Ft
Source: Columbia Board of REALTORS®

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 Type Sale Price Title Company
Quit Claim Deed -- None Available
Source: Public Records

Source: Columbia Board of REALTORS®

MLS Number: 433473

Columbia Board of REALTORS®

APN: 16-317-00-05-033-00-01

Your Personal Tour Guide

Ask me questions while you tour the home.