$169,900
SOLD NOV 16, 2018
Last list price

5401 Gemstone Dr Columbia, MO 65202

3 Beds
2 Baths
1,570 Sq Ft
0.27 Acres

Recently Sold

$108 Per Sq Ft

82 Days on Market

Highlights

  • Ranch Style House
  • No HOA
  • 2 Car Attached Garage
  • Wood Flooring
  • Covered Patio or Porch
  • Brick Veneer

About This Home

As of August 2019

Check out this wonderful corner-lot, one-level home with open layout and amazing yard! You'll love the vaulted ceilings and open concept of this lovely 3-bedroom, 2-bath house. Beautiful hardwood floors, vaulted ceilings, fireplace and large master suite make this house the perfect place to call home. Relax and enjoy the covered patio and spacious yard- perfect for both kids and pets! Check out this amazing house in person and fall in love as soon as you step a foot in the door!

Last Agent to Sell the Property

Billy Dexheimer

North Star Real Estate License #2015019891 Listed on: 07/29/2018

Last Buyer's Agent

DAVID URSERY

Iron Gate Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $1,864

Year Built

  • Built in 2005

Lot Details

  • South Facing Home
  • Wood Fence
  • Back Yard Fenced
  • Zoning described as R-S Single Family Residential

Parking

  • 2 Car Attached Garage
  • Driveway

Home Design

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

Interior Spaces

  • 1,570 Sq Ft Home
  • Wired For Data
  • Ceiling Fan
  • Paddle Fans
  • Gas Fireplace
  • Vinyl Clad Windows
  • Family Room with Fireplace
  • Living Room with Fireplace
  • Combination Kitchen and Dining Room
  • Fire and Smoke Detector

Kitchen

  • Microwave
  • Laminate Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

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

Outdoor Features

  • Covered Patio or Porch

Schools

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

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas

Community Details

  • No Home Owners Association
  • Built by Vantage Custon Home
  • Greystone Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1720200070510001

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,864

Year Built

Built in 2005

Lot Details

0

Parking

2

Listing Details

  • Directions: St. Charles to Lake of the Woods, LEFT on Kelsey, RIGHT on Shamrock. House is on corner of Shamrock and Gemstone.
  • Lot Size: 128.5 × 90
  • Prop. Type: Residential
  • Bedroom 2 Level: Main
  • Kitchen Level: Main
  • Living Room Level: Main
  • Primary Bedroom Level: Main
  • Year Built: 2005
  • BathsFull34MainLevel: 2
  • BathsFull34Total: 2
  • Property Sub Type: Single Family Residence
  • Road Surface Type: Paved, Public Maintained, Curbs and Gutters
  • Subdivision Name: GREYSTONE
  • Above Grade Finished Sq Ft: 1570.0
  • Architectural Style: Ranch
  • Garage Type Attached: Yes
  • Cooling:Central Electric: Yes
  • Foundation Material:Poured Concrete: Yes
  • ArchStyle:Traditional: Yes
  • Roof:ArchitecturalShingle: Yes
  • Utilities:Gas-Natural: Yes
  • Flooring:Carpet: Yes
  • Flooring:Tile: Yes
  • Heat Fuel:Natural Gas: Yes
  • Heat Type:Forced Air: Yes
  • Patio:Back3: Yes
  • Rooms:Living Room: Yes
  • Dining:KitDin Combo: Yes
  • Utilities:Electric-City: Yes
  • Utilities:Sewage-City: Yes
  • Utilities:Water-City: Yes
  • Flooring:Wood2: Yes
  • Patio:Concrete2: Yes
  • Patio:Covered3: Yes
  • Fence:Backyard: Yes
  • Exterior Finish:Vinyl2: Yes
  • Fence Material:Wood5: Yes
  • Foundation Type:Slab: Yes
  • Fence:Full: Yes
  • Exterior Finish:Brick Veneer: Yes
  • Special Features: None

Interior Features

  • Bedroom 3 Level: Main
  • Flooring: Wood, Carpet, Tile
  • Interior Amenities: Tub/Shower, Tub-Garden, Walk in Closet(s), Main Lvl Master Bdrm, Ceiling/PaddleFan(s), Data Wiring, Smoke Detector(s), Kit/Din Combo, Counter-Laminate, Cabinets-Wood
  • Basement YN: No
  • Full Bathrooms: 2
  • Total Bedrooms: 3
  • Fireplace Features: In Living Room, Gas, In Family Room
  • Fireplace: Yes
  • Living Area: 1570.0
  • Fireplace:Gas: Yes
  • Fireplace:In Family Room: Yes
  • InteriorFeatures:CeilingPaddleFan(s): Yes
  • InteriorFeatures:Main Lvl Master Bdrm: Yes
  • InteriorFeatures:Smoke Detector(s): Yes
  • InteriorFeatures:Tub-Garden: Yes
  • InteriorFeatures:TubShower: Yes
  • InteriorFeatures:Walk in Closet(s): Yes
  • KitchenFeatures:Cabinets-Wood: Yes
  • KitchenFeatures:Garbage Disposal: Yes
  • KitchenFeatures:Microwave Oven: Yes
  • Fireplace:In Living Room: Yes
  • InteriorFeatures:Data Wiring: Yes
  • KitchenFeatures:Vent Fan: Yes
  • KitchenFeatures:Counter-Laminate: Yes

Exterior Features

  • Builder Name: Vantage Custon Home
  • Exterior Features: Driveway-Paved, Windows-Vinyl
  • Roof: ArchitecturalShingle
  • Fencing: Backyard, Full, Wood
  • Direction Faces: South
  • Foundation Details: Poured Concrete, Slab
  • Patio And Porch Features: Concrete, Back, Covered
  • 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

  • Utilities: Water-City, Gas-Natural, Sewage-City, Electric-City, Trash-City
  • Cooling: Central Electric
  • Heating: Forced Air, Natural Gas
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Association: No

Schools

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

Lot Info

  • Land Lease Amount Frequency: N/A
  • Land Lease: No
  • Parcel #: 1720200070510001
  • Zoning Description: R-S Single Family Residential

Tax Info

  • Tax Annual Amount: 1864.19
  • Tax Year: 2017

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 28, 2019
Closed on
Aug 30, 2019
Sold by
Heinz Nick
Bought by
Liebman Elizabeth
Seller's Agent
David Ursery
CoMo Realty
Buyer's Agent
Dennis Jordan
American Jewell Realty LLC
List Price
$169,950
Current Estimated Value
$282,473

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.75%
Original Mortgage
$161,453
Interest Rate
3.8%
Mortgage Type
New Conventional

Purchase Details

Listed on
Jul 29, 2018
Closed on
Nov 16, 2018
Sold by
Backes Chad Michael and Backes Kimberly D
Bought by
Heinz Nick
Seller's Agent
Billy Dexheimer
North Star Real Estate
Buyer's Agent
DAVID URSERY
Iron Gate Real Estate
List Price
$169,900

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.02%
Original Mortgage
$162,960
Interest Rate
4.7%
Mortgage Type
New Conventional

Purchase Details

Closed on
Oct 19, 2016
Sold by
Backes Chad Michael
Bought by
Backes Chad Michael and Backes Kimberly D

Home Financials for this Owner

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

Purchase Details

Closed on
Oct 1, 2009
Sold by
Elgin Amanda L
Bought by
Backes Chad Michael

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$140,409
Interest Rate
5.12%
Mortgage Type
FHA

Purchase Details

Closed on
Aug 11, 2006
Sold by
Vantage Custom Homes Llc
Bought by
Elgin Amanda L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$118,915
Interest Rate
6.78%
Mortgage Type
Future Advance Clause Open End Mortgage
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 Type Sale Price Title Company
Warranty Deed -- Boone Central Title Company
Warranty Deed -- Boone Central Title Co
Interfamily Deed Transfer -- Boston National Title
Warranty Deed -- Boone Central Title Company
Warranty Deed -- None Available
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $166,315 New Conventional
Closed $161,453 New Conventional
Previous Owner $162,960 New Conventional
Previous Owner $127,500 New Conventional
Previous Owner $140,409 FHA
Previous Owner $127,500 Unknown
Previous Owner $129,000 New Conventional
Previous Owner $118,915 Future Advance Clause Open End Mortgage
Previous Owner $127,500 Future Advance Clause Open End Mortgage
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/30/2019 08/30/19 Sold -- -- --
08/03/2019 08/03/19 Pending -- -- --
07/28/2019 07/28/19 For Sale $169,950 0.0% $108 / Sq Ft
11/16/2018 11/16/18 Sold -- -- --
10/20/2018 10/20/18 Pending -- -- --
07/29/2018 07/29/18 For Sale $169,900 -- $108 / 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 $1,919 $32,566 $5,320 $27,246
2024 $1,919 $28,443 $5,320 $23,123
2023 $1,903 $28,443 $5,320 $23,123
2022 $1,827 $27,341 $5,320 $22,021
2021 $1,831 $27,341 $5,320 $22,021
2020 $1,874 $26,296 $5,320 $20,976
2019 $1,874 $26,296 $5,320 $20,976
2018 $1,887 $0 $0 $0
2017 $1,864 $26,296 $5,320 $20,976
2016 $1,861 $26,296 $5,320 $20,976
2015 $1,709 $26,296 $5,320 $20,976
2014 -- $26,296 $5,320 $20,976
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Columbia Board of REALTORS®

MLS Number: 379861

Columbia Board of REALTORS®

APN: 17-202-00-07-051-00-01