NOT LISTED FOR SALE

5404 Gemstone Way Columbia, MO 65202

Estimated Value: $217,000 - $318,000

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

Last Sold September 01, 2023

Current estimated payment $1,550/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
Sold Price
$230,000
Premium/Discount to List
$5,000
2.22%
Total Days on Market
4
Views
9
Current Estimated Value
$262,721

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$32,721
Avg. Annual Appreciation
7.71%
Original Mortgage
$225,834
Outstanding Balance
$221,968
Interest Rate
6.78%
Mortgage Type
FHA
Estimated Equity
$40,753

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

Similar Homes in Columbia, MO

  • 5803 Kelsey Dr, Columbia, MO 65202

    $314,900

    • 3 Beds
    • 2 Baths
    • 2,047 Sq Ft
    • 5803 Kelsey Dr
    • Columbia, MO

    So many positive reasons to buy this home including the size and a surprise 3rd car garage behind front garages. Garage was planned as a workshop with extra electrical outlets and yet it would make a perfect exercise or craft room. Entrance from side street could be used for recreational vehicles, etc. Recent piering by Helitech ensures you are buying a solid home that is not going to move with

    Jane Boles RE/MAX Boone Realty

    Section Image
  • 5817 Geyser Blvd, Columbia, MO 65202

    $265,000

    • 3 Beds
    • 2 Baths
    • 1,408 Sq Ft
    • 5817 Geyser Blvd
    • Columbia, MO

    Welcome to this beautifully maintained 3-bedroom, 2-bathroom, 2-car garage slab home in Forest Hills Subdivision. As you step inside, you'll immediately be impressed by the spaciousness and airy feel of the living area, enhanced by tall ceilings that create an open and inviting atmosphere. The kitchen is a standout feature, offering stainless steel appliances, a stylish tile backsplash, and

    Adrienne Ganz RE/MAX Boone Realty

    Section Image
  • 5908 Huntington Ct, Columbia, MO 65202

    $315,000

    • 3 Beds
    • 2 Baths
    • 1,450 Sq Ft
    • 5908 Huntington Ct
    • Columbia, MO

    This one level Ranch sits in Mallard Pointe Subdivision on a cul de sac and backing to a church built by Wilcoxson Homes in 2023. It offers an amazing floor plan with 3 bedrooms, 2 full baths, and an attached 2 car garage. Take advantage of the split bedroom floor plan, luxury master suite with dual vanities, covered patio, and vaulted ceilings throughout. With a large level back yard perfect for

    Sean Moore RE/MAX Boone Realty

    Section Image
  • 6001 E Molly Ln, Columbia, MO 65202

    $279,900

    • 4 Beds
    • 2.5 Baths
    • 2,228 Sq Ft
    • 6001 E Molly Ln
    • Columbia, MO

    Spacious Split-Level Home on an Extra-Large Lot! Welcome to this inviting split-level home offering room to spread out both inside and out! Featuring two living spaces, this home is ideal for entertaining, relaxing, or creating a home office or playroom. The extra-large lot provides plenty of space for outdoor enjoyment, including plenty of room for a vegetable garden. Primary bedroom is very

    Jennifer Lincoln RE/MAX Boone Realty

    Section Image
  • 3151 N Lake of the Woods Rd, Columbia, MO 65202

    $295,000

    • 3 Beds
    • 2 Baths
    • 1,565 Sq Ft
    • 3151 N Lake of the Woods Rd
    • Columbia, MO

    Enjoy the perfect blend of privacy, space, and convenience with this well-maintained 3-bedroom, 2-bath home on 2.33 acres—just minutes from I-70. Step inside to find a bright and functional layout featuring a spacious primary suite with a private en suite bath and large walk-in closet. The kitchen offers warm wood cabinetry, a stainless steel refrigerator, and plenty of storage for all your

    Shannon Drewing House of Brokers Realty, Inc.

    Section Image
  • 4812 Orchard Ln, Columbia, MO 65202

    $245,000

    • 3 Beds
    • 2 Baths
    • 1,282 Sq Ft
    • 4812 Orchard Ln
    • Columbia, MO

    Welcome home to this charming, move-in ready 3 bed, 2 bath ranch nestled just minutes from everything Columbia has to offer. Enjoy the ease of one-level living with a cozy, functional layout that includes spacious bedrooms and walk-in closets. Step outside to what might be the best backyard and deck in the neighborhood—perfect for spring and summer gatherings, morning coffee, or simply relaxing

    Megan Walters EXP Realty LLC

    Section Image
  • 2616 Frazier Loop, Columbia, MO 65202

    $244,900

    • 3 Beds
    • 2 Baths
    • 1,254 Sq Ft
    • 2616 Frazier Loop
    • Columbia, MO

    Don't rent when you can own this beautiful, newly built home. This property features durable luxury vinyl plank flooring throughout, offering both elegance and easy maintenance. The layout includes an attached one-car garage and well-designed living spaces that maximize every square foot. Located close to the new Schnucks grocery store and nearby amenities, this home is perfectly positioned for

    Jay Wilson Weichert, Realtors - First Tier

    Section Image
  • 2621 Frazier Loop, Columbia, MO 65202

    $244,900

    • 3 Beds
    • 2 Baths
    • 1,254 Sq Ft
    • 2621 Frazier Loop
    • Columbia, MO

    Don't rent when you can own this beautiful, newly built home. This property features durable luxury vinyl plank flooring throughout, offering both elegance and easy maintenance. The layout includes an attached one-car garage and well-designed living spaces that maximize every square foot. Located close to the new Schnucks grocery store and nearby amenities, this home is perfectly positioned for

    Jay Wilson Weichert, Realtors - First Tier

    Section Image
  • 2319 Windmill Ct, Columbia, MO 65202

    $210,000

    • 3 Beds
    • 2 Baths
    • 1,812 Sq Ft
    • 2319 Windmill Ct
    • Columbia, MO

    Don't miss this spacious three bedroom two bathroom home with so much to offer. Convenient access to I-70 and Highway 63. Schedule a viewing today!

    Cale Childers Century 21 Access

    Section Image
See All Homes in Columbia

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
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

    720 Total Sales

    Sean Moore
    Section Image
  • Shelby Brandt

    Seller Co-Listing Agent in 2023

    Shelby Brandt

    RE/MAX

    159 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 $262,721, approximately $184 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