NOT LISTED FOR SALE

5817 Geyser Blvd Columbia, MO 65202

Columbia Area

Estimated Value: $267,000 - $280,000

3 Beds
2 Baths
1,408 Sq Ft
$195/Sq Ft Est. Value

Sale Details

Date Sold: July 31, 2025

Current estimated payment $1,712 / mo

Highlights

  • Ranch Style House
  • Living Room
  • Dining Room
  • 2 Car Attached Garage
  • Bathroom on Main Level

About This Home

As of August 2025

Shows like New! Single Family Home with fully fenced backyard. 3 bedroom 2 bath 2 car garage. Shows like new! Just 7.5 miles to University of MO, Less than 4.5 miles to shopping area, about 1.5 mile to Schnucks grocery store and Exit 131 of I-70. Pet neg. - one only, less than 30lbs, $500 refundable pet deposit, $25/month extra rent for pet. Credit and background check required. Min. credit score required is 660, qualifying income is 3x the rent. Must have confirmed appt to show. No smoking. All Utilities and lawn care are tenants responsibility.

Last Agent to Rent the Property

Paul Bunch

Century 21 Community License #2003013502 Listed on: 08/01/2025

Century 21 Community

Co-Listed By

Kaili Li

Century 21 Community License #2022006134

Century 21 Community

Last Renter's Agent

Kaili Li

Century 21 Community License #2022006134

Century 21 Community

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

Year Built

  • Built in 2020

Parking

  • 2 Car Attached Garage

Home Design

  • Ranch Style House
  • Slab Foundation

Interior Spaces

  • 1,408 Sq Ft Home
  • Living Room
  • Dining Room

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Bathroom on Main Level
  • 2 Full Bathrooms

Schools

  • Battle Elementary School
  • Lange Middle School
  • Battle High School

Community Details

  • Forest Hills Subdivision

Listing and Financial Details

  • Property Available on 8/1/25
  • 12 Month Lease Term
  • Assessor Parcel Number 17-202-00-09-027.00 01

Home Details

Home Type

Single Family

Year Built

Built in 2020

Lot Details

0 Sq Ft Lot

Parking

2

Rental Info

  • Lease Term: 1 Yr
  • Available Date: 2025-08-01

Listing Details

  • Directions: I-70 to Exit 131, turn North, right on St charles, left on Lake of woods, left o Geyser.
  • Prop. Type: Rental Res-Multi Fam
  • Bedroom 2 Level: Main
  • Dining Room Level: Main
  • Full Bathroom Level: Main
  • Kitchen Level: Main
  • Living Room Level: Main
  • Primary Bedroom Level: Main
  • Year Built: 2020
  • Property Sub Type: Detached
  • Co List Office Phone: 573-777-5555
  • Subdivision Name: FOREST HILLS
  • Architectural Style: Ranch
  • Contract Information:Agreement Type: Exclusive Right to Rent
  • Contract Information:Owner_squote_s Legal Name: Feng Feng
  • Contract Information:Title Held by: A Single Person
  • Location Tax Legal:Elementary Sch2: Battle
  • Location Tax Legal:MiddleJr High Sch2: Lange
  • Location Tax Legal:Senior Sch2: Battle
  • Location Tax Legal:Legal Description2: FOREST HILLS PLAT NO. 1 LOT 127
  • Remarks Misc:Directions: I-70 to Exit 131, turn North, right on St charles, left on Lake of woods, left o Geyser.
  • Garage Type Attached: Yes
  • Licensee PerInt Dis:Not Applicable: Yes
  • Rooms:Dining Room: Yes
  • Rooms:Living Room: Yes
  • Contract Information:Lic Asst OwnLandlrd: Owner/Landlord Agent
  • General Property Description:Unit Type: Ranch
  • General Property Description:Vacant: Yes
  • General Property Description:Lead Paint Disc: No
  • General Property Description:Fenced: Yes
  • General Property Description:Security Deposit: 1775.0
  • General Property Description:Storage: YES
  • General Property Description:Pets Allowed: Negotiable
  • General Property Description:Pet Deposit2: 500.0
  • General Property Description:Refundable: Yes
  • General Property Description:Term of Lease: 1 Yr
  • General Property Description:Application Fee: 35.0
  • Location Tax Legal:Cross Street2: Lake of Woods
  • Foundation Type:Slab: Yes
  • General Property Description Rental Service: Other
  • Special Features: None

Interior Features

  • Bedroom 3 Level: Main
  • Basement YN: No
  • Full Bathrooms: 2
  • Total Bedrooms: 3
  • General Property Description:Basement: No
  • Rooms:Bedroom 2: Yes
  • Rooms:Bedroom 3: Yes
  • Rooms:Kitchen: Yes
  • Rooms:Master Bedroom: Yes
  • General Property Description:Furnished: Unfurnished
  • Rooms:Full Bathroom: Yes

Exterior Features

  • Foundation Details: Slab

Garage/Parking

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

Schools

  • Elementary School: Battle
  • High School: Battle
  • Middle Or Junior School: Lange

Lot Info

  • Parcel #: 17-202-00-09-027.00 01

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
Aug 1, 2025
Closed on
Jul 31, 2025
Sold by
Hummel Ellen
Bought by
Seller's Agent
Paul Bunch
Century 21 Community
Buyer's Agent
Kaili Li
Century 21 Community
Views
43
Current Estimated Value
$275,222

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.76%
Original Mortgage
$200,000
Outstanding Balance
$198,074
Interest Rate
6.81%
Mortgage Type
New Conventional
Estimated Equity
$77,148

Purchase Details

Listed on
Mar 8, 2020
Closed on
Jun 29, 2020
Sold by
Dn Joint Ventures Llc
Bought by
Hummel Ellen
Seller's Agent
Michael Huggans
REMAX Boone Realty
Buyer's Agent
Adrienne Ganz
REMAX Boone Realty
List Price
$174,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
8.97%
Original Mortgage
$169,265
Interest Rate
3.2%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jul 25, 2018
Sold by
D & D Investments Of Columbia Llc
Bought by
Dn Joint Ventures Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$148,750
Interest Rate
4.6%
Mortgage Type
Commercial
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
Hummel Ellen -- Boone Central Title Company
Dn Joint Ventures Llc -- Boone Central Title Co
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 $200,000
Previous Owner Hummel Ellen $169,265
Previous Owner Dn Joint Ventures Llc $148,750
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
08/05/2025 08/05/25 Rented $1,775 0.0% --
08/01/2025 08/01/25 For Rent $1,775 0.0% --
07/31/2025 07/31/25 Sold -- -- -- View Prior Sale
06/13/2025 06/13/25 Pending -- -- --
06/12/2025 06/12/25 For Sale $265,000 +51.9% $188 / Sq Ft
07/01/2020 07/01/20 Sold -- -- -- View Prior Sale
05/19/2020 05/19/20 Pending -- -- --
01/01/2020 01/01/20 For Sale $174,500 -- $124 / 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,327 $35,530 $4,750 $30,780
2024 $2,093 $31,027 $4,750 $26,277
2023 $2,076 $31,027 $4,750 $26,277
2022 $2,074 $31,027 $4,750 $26,277
2021 $2,078 $31,027 $4,750 $26,277
2020 $2,211 $31,027 $4,750 $26,277
2019 $2,211 $31,027 $4,750 $26,277
2018 $39 $0 $0 $0
2017 $39 $549 $549 $0
2016 $39 $549 $549 $0
2015 $36 $549 $549 $0
2014 $149 $2,280 $2,280 $0
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: 428887

Columbia Board of REALTORS®

APN: 17-202-00-09-027-00-01

Your Personal Tour Guide

Ask me questions while you tour the home.