NOT LISTED FOR SALE

5404 Gemstone Way Columbia, MO 65202

Estimated Value: $255,000 - $305,000

3 Beds
2 Baths
1,422 Sq Ft
$194/Sq Ft Est. Value

Last Sold September 01, 2023

Current estimated payment $1,614/month

4 Days on Market

Highlights

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

About This Home

As of September 2023

WELCOME HOME! This gorgeous 2014 home offers a spacious floor plan with kitchen/dining combo & a large pantry. Spacious master bedroom with double vanities in the master bath. Large fenced in yard that backs up to trees. Schedule your showing today.

Last Agent to Sell the Property

Sean Moore

RE/MAX Boone Realty License #2004031970 Listed on: 07/24/2023

RE/MAX Boone Realty

Co-Listed By

Shelby Brandt

RE/MAX Boone Realty License #2020024754

Last Buyer's Agent

Samantha Gage

ReeceNichols Mid Missouri

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $1,871

Year Built

  • Built in 2014

Lot Details

  • North Facing Home
  • Privacy Fence
  • 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,422 Sq Ft Home
  • Ceiling Fan
  • Paddle Fans
  • Vinyl Clad Windows
  • Window Treatments
  • Combination Kitchen and Dining Room
  • Laundry on main level

Kitchen

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

Flooring

  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 2 Full Bathrooms

Home Security

  • Exterior Cameras
  • Video Cameras

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
  • High Speed Internet
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Built by On Point
  • Greystone Subdivision

Listing and Financial Details

  • Assessor Parcel Number 17-202-00-07-048.00 01

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,871

Year Built

Built in 2014

Lot Details

0

Parking

2

Listing Details

  • Directions: Lake of the Woods to Kelsey, right on Shamrock, right on Gemstone. Home is on the right.
  • FencePrivacy: Yes
  • Lot Size: 80.00 × 120.00
  • Prop. Type: Residential
  • Year Built: 2014
  • Property Sub Type: Single Family Residence
  • Co List Office Mls Id: 510000010
  • Co List Office Phone: 573-442-6121
  • Subdivision Name: GREYSTONE
  • Above Grade Finished Sq Ft: 1422.0
  • Architectural Style: Ranch
  • Garage Type Attached: Yes
  • Cooling:Central Electric: Yes
  • Foundation Material:Poured Concrete: Yes
  • ArchStyle:Traditional: Yes
  • Roof:ArchitecturalShingle: Yes
  • Flooring:Carpet: Yes
  • Flooring:Tile: Yes
  • Heat Fuel:Natural Gas: Yes
  • Heat Type:Forced Air: Yes
  • Patio:Back3: Yes
  • Dining:KitDin Combo: 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

  • Flooring: Carpet, Tile
  • Interior Amenities: High Spd Int Access, Laundry-Main Floor, Window Treatmnts All, Main Lvl Master Bdrm, Cable Available, Ceiling/PaddleFan(s), Kit/Din Combo, Counter-Laminate, Cabinets-Wood
  • Basement YN: No
  • Full Bathrooms: 2
  • Total Bedrooms: 3
  • Living Area: 1422.0
  • InteriorFeatures:CeilingPaddleFan(s): Yes
  • InteriorFeatures:High Spd Int Access: Yes
  • InteriorFeatures:Laundry-Main Floor: Yes
  • InteriorFeatures:Main Lvl Master Bdrm: Yes
  • KitchenFeatures:Cabinets-Wood: Yes
  • KitchenFeatures:Dishwasher-Built In: Yes
  • KitchenFeatures:Garbage Disposal: Yes
  • KitchenFeatures:Microwave Oven: Yes
  • InteriorFeatures:Cable Available: Yes
  • InteriorFeatures:Window Treatmnts All: Yes
  • KitchenFeatures:Range-Electric: Yes
  • KitchenFeatures:Counter-Laminate: Yes

Exterior Features

  • Builder Name: On Point
  • Exterior Features: Security Cameras, Driveway-Paved, Windows-Vinyl
  • Roof: ArchitecturalShingle
  • Fencing: Backyard, Full, Privacy, Wood
  • Direction Faces: North
  • Foundation Details: Poured Concrete, Slab
  • Patio And Porch Features: Back, Covered
  • Exterior Features:Driveway-Paved: Yes
  • Exterior Features:Windows-Vinyl: Yes
  • Exterior Features:Security Cameras: Yes

Garage/Parking

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

Utilities

  • 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 #: 17-202-00-07-048.00 01
  • Zoning Description: R-S Single Family Residential

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 24, 2023
Closed on
Sep 1, 2023
Sold by
Miller Justin and Miller Whitney
Bought by
Baker Evan D and Schultz Kara N
Seller's Agent
Sean Moore
RE/MAX Boone Realty
Buyer's Agent
Samantha Gage
ReeceNichols Mid Missouri
List Price
$225,000
Views
9
Current Estimated Value
$275,979

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
9.25%
Original Mortgage
$225,834
Outstanding Balance
$220,881
Interest Rate
6.78%
Mortgage Type
FHA
Estimated Equity
$55,098

Purchase Details

Closed on
Jun 18, 2021
Sold by
Janes Larry M and Janes Judy K
Bought by
Miller Justin and Miller Whitney

Home Financials for this Owner

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

Purchase Details

Closed on
Jul 11, 2018
Sold by
The Secretary Of Veterans Affairs
Bought by
Janes Larry M and Janes Judy K

Purchase Details

Closed on
May 7, 2018
Sold by
Pennymac Loan Services Llc
Bought by
Secretar Of Veterans Affairs

Purchase Details

Closed on
Mar 19, 2018
Sold by
Peterson Lonnie R and Peterson Nicole
Bought by
Penny Mac Loan Services Llc

Purchase Details

Closed on
Oct 6, 2014
Sold by
Texas Tea Llc
Bought by
Peterson Lonnie R

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$149,500
Interest Rate
4.13%
Mortgage Type
VA
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
Baker Evan D -- Central Title
Miller Justin -- Boone Central Title Company
Janes Larry M -- None Available
Secretar Of Veterans Affairs -- None Available
Penny Mac Loan Services Llc -- None Available
Peterson Lonnie R -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Baker Evan D $225,834
Previous Owner Miller Justin $177,650
Previous Owner Peterson Lonnie R $149,500
Previous Owner Texas Tea Llc $119,325
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
09/01/2023 09/01/23 Sold -- -- --
07/28/2023 07/28/23 Pending -- -- --
07/23/2023 07/23/23 For Sale $225,000 -- $158 / 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,871 $31,768 $5,320 $26,448
2024 $1,871 $27,740 $5,320 $22,420
2023 $1,856 $27,740 $5,320 $22,420
2022 $1,783 $26,676 $5,320 $21,356
2021 $1,786 $26,676 $5,320 $21,356
2020 $1,828 $25,650 $5,320 $20,330
2019 $1,828 $25,650 $5,320 $20,330
2018 $1,841 $0 $0 $0
2017 $1,815 $25,650 $5,320 $20,330
2016 $1,815 $25,650 $5,320 $20,330
2015 $1,667 $25,650 $5,320 $20,330
2014 $139 $2,128 $2,128 $0
Source: Public Records

Agents Affiliated with this Home

  • Sean Moore

    Seller's Agent in 2023

    Sean Moore

    RE/MAX

    (573) 424-7420

    723 Total Sales

    Sean Moore
    Section Image
  • Shelby Brandt

    Seller Co-Listing Agent in 2023

    Shelby Brandt

    RE/MAX

    170 Total Sales

    Shelby Brandt
    Section Image

  • S

    Buyer's Agent in 2023

    Samantha Gage

    ReeceNichols Mid Missouri

See All Agents

Map

Source: Columbia Board of REALTORS®

MLS Number: 414983

Columbia Board of REALTORS®

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

Missouri Boone County Columbia 65202

5404 Gemstone Way, Columbia, MO

This home is located at 5404 Gemstone Way, Columbia, MO 65202 since 24 July 2023 and is currently estimated at $275,979, approximately $194 per square foot. This property was built in 2014. 5404 Gemstone Way is a home located in Boone County with nearby schools including Eliot Battle Elementary School, John B. Lange Middle School, and Muriel W. Battle High School.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Columbia Board of REALTORS® IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

Nearby Homes