NOT LISTED FOR SALE

5501 Gemstone Way Columbia, MO 65202

Estimated Value: $233,000 - $336,000

3 Beds
2 Baths
1,576 Sq Ft
$176/Sq Ft Est. Value

Last Sold June 16, 2023

Current estimated payment $1,711/month

2 Days on Market

Highlights

  • Ranch Style House
  • Covered patio or porch
  • Attached Garage
  • No HOA
  • Formal Dining Room
  • Eat-In Kitchen

About This Home

As of June 2023

This stunning property features a spacious OPEN floor plan, perfect for entertaining guests. The privacy fenced-in yard offers a tranquil retreat where you can relax and enjoy the outdoors in complete privacy. This house is sure to exceed expectations. Don't miss out on this rare opportunity to own a truly exceptional property-schedule your viewing today! Showings start Friday, May12th at 5 pm.

-Seller intends to replace all curtains rods- due to the current ones being wedding gifts.

Last Agent to Sell the Property

Cameron Cotten

RE/MAX Jefferson City License #2018025272 Listed on: 05/12/2023

RE/MAX Jefferson City

Last Buyer's Agent

Lori Brockman

Weichert, Realtors - First Tier License #2002020294

Weichert, Realtors - First Tier

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $1,914

Year Built

  • Built in 2005

Lot Details

  • Lot Dimensions are 115.71 x 92.73
  • South Facing Home
  • Privacy Fence
  • Wood Fence
  • Back Yard Fenced
  • Zoning described as R-S Single Family Residential

Home Design

  • Ranch Style House
  • Brick Veneer
  • Concrete Foundation
  • Slab Foundation
  • Poured Concrete
  • Vinyl Construction Material

Interior Spaces

  • 1,576 Sq Ft Home
  • Wired For Data
  • Ceiling Fan
  • Paddle Fans
  • Gas Fireplace
  • Vinyl Clad Windows
  • Window Treatments
  • Living Room with Fireplace
  • Formal Dining Room

Kitchen

  • Eat-In Kitchen
  • Convection Oven
  • Convection Microwave
  • Disposal

Flooring

  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet
  • 2 Full Bathrooms

Laundry

  • Laundry on main level
  • Washer and Dryer Hookup

Home Security

  • Home Security System
  • Fire and Smoke Detector

Parking

  • Attached Garage
  • Garage Door Opener
  • Driveway

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 Vantage Custom Homes
  • Greystone Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1720200070610001

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,914

Year Built

Built in 2005

Lot Details

0

Listing Details

  • Directions: Lake of the woods to left on Kelsey, right on Shamrock to right on Greystone Way.
  • FencePrivacy: Yes
  • Lot Size: 115.71 x 92.73
  • Prop. Type: Residential
  • Bedroom 2 Level: Main
  • Dining Room Level: Main
  • Kitchen Level: Main
  • Living Room Level: Main
  • Primary Bedroom Level: Main
  • Year Built: 2005
  • Property Sub Type: Single Family Residence
  • Subdivision Name: GREYSTONE
  • Above Grade Finished Sq Ft: 1576.0
  • Architectural Style: Ranch
  • Garage Type Attached: Yes
  • Cooling:Central Electric: Yes
  • Foundation Material:Poured Concrete: Yes
  • Utilities:Electric-County: 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:Dining Room: Yes
  • Rooms:Living Room: Yes
  • Dining:Eat-In Kitchen: Yes
  • Dining:Formal Dining: Yes
  • Utilities:Sewage-City: Yes
  • Utilities:Water-City: Yes
  • Patio:Concrete2: Yes
  • Patio:Covered3: Yes
  • Fence:Backyard: Yes
  • Exterior Finish:Vinyl2: Yes
  • Porch:Covered2: Yes
  • Porch:Front2: 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
  • Bedrooms Other Level: Main
  • Flooring: Carpet, Tile
  • Interior Amenities: High Spd Int Access, Laundry-Main Floor, Window Treatmnts All, Walk in Closet(s), Washer/DryerConnectn, Cable Available, Ceiling/PaddleFan(s), Cable Ready, Data Wiring, Security System, Smoke Detector(s), Garage Dr Opener(s), Eat-in Kitchen, Formal Dining
  • Basement YN: No
  • Full Bathrooms: 2
  • Total Bedrooms: 3
  • Fireplace Features: In Living Room, Gas
  • Fireplace: Yes
  • Living Area: 1576.0
  • Fireplace:Gas: Yes
  • InteriorFeatures:Cable Ready: Yes
  • InteriorFeatures:CeilingPaddleFan(s): Yes
  • InteriorFeatures:High Spd Int Access: Yes
  • InteriorFeatures:Laundry-Main Floor: Yes
  • InteriorFeatures:Smoke Detector(s): Yes
  • InteriorFeatures:Walk in Closet(s): Yes
  • InteriorFeatures:WasherDryerConnectn: Yes
  • KitchenFeatures:Garbage Disposal: Yes
  • Fireplace:In Living Room: Yes
  • InteriorFeatures:Cable Available: Yes
  • InteriorFeatures:Data Wiring: Yes
  • InteriorFeatures:Security System: Yes
  • InteriorFeatures:Window Treatmnts All: Yes
  • KitchenFeatures:Microwave - Convection: Yes
  • KitchenFeatures:Refrigerator: Yes
  • KitchenFeatures:Convection Oven: Yes

Exterior Features

  • Builder Name: Vantage Custom Homes
  • Exterior Features: Driveway-Paved, Windows-Vinyl
  • Fencing: Backyard, Full, Privacy, Wood
  • Direction Faces: South
  • Foundation Details: Poured Concrete, Slab
  • Other Structures: None
  • Patio And Porch Features: Concrete, Back, Covered, Front Porch
  • Exterior Features:Driveway-Paved: Yes
  • Exterior Features:Windows-Vinyl: Yes

Garage/Parking

  • Parking Features: Attached
  • InteriorFeatures:Garage Dr Opener(s): Yes

Utilities

  • Utilities: Water-City, Electric-County, Gas-Natural, Sewage-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 #: 1720200070610001
  • Zoning Description: R-S Single Family Residential

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 12, 2023
Closed on
Jun 16, 2023
Sold by
Huck Alexander and Huck Emma
Bought by
Splinter Christopher and Splinter Jamie
Seller's Agent
Cameron Cotten
RE/MAX Jefferson City
Buyer's Agent
Lori Brockman
Weichert, Realtors - First Tier
List Price
$254,900
Sold Price
$259,000
Premium/Discount to List
$4,100
1.61%
Total Days on Market
2
Views
224
Current Estimated Value
$277,649

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$18,649
Avg. Annual Appreciation
3.54%
Original Mortgage
$204,000
Outstanding Balance
$199,615
Interest Rate
6.39%
Mortgage Type
New Conventional
Estimated Equity
$78,034

Purchase Details

Closed on
Jun 30, 2016
Sold by
Martin Brian and Martin Kyle Christine
Bought by
Huck Alexander

Home Financials for this Owner

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

Purchase Details

Closed on
Oct 21, 2005
Sold by
Vantage Custome Homes Llc
Bought by
Martin Brian and Martin Kyle Christine

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$151,400
Interest Rate
5.69%
Mortgage Type
New Conventional
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
  • 5908 Huntington Ct, Columbia, MO 65202

    $315,000

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

    This beautiful 2023 one level Ranch sits in Mallard Pointe Subdivision. Built by Wilcoxson Homes, 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 entertaining this is a must see!

    Sean Moore 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
  • 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
  • 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
  • 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
  • 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
Splinter Christopher -- Boone Central Title
Huck Alexander -- Boone Central Title Co
Martin Brian -- Boone Central Title Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Splinter Christopher $204,000
Previous Owner Huck Alexander $121,550
Previous Owner Huck Alexander $130,400
Previous Owner Martin Brian $140,000
Previous Owner Martin Brian $151,400
Previous Owner Vantage Custom Homes Llc $127,500
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/16/2023 06/16/23 Sold -- -- --
05/15/2023 05/15/23 Pending -- -- --
05/12/2023 05/12/23 For Sale $254,900 -- $162 / 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,914 $28,367 $5,320 $23,047
2023 $1,898 $28,367 $5,320 $23,047
2022 $1,824 $27,284 $5,320 $21,964
2021 $1,827 $27,284 $5,320 $21,964
2020 $1,870 $26,239 $5,320 $20,919
2019 $1,870 $26,239 $5,320 $20,919
2018 $1,883 $0 $0 $0
2017 $1,860 $26,239 $5,320 $20,919
2016 $1,857 $26,239 $5,320 $20,919
2015 $1,705 $26,239 $5,320 $20,919
2014 $1,711 $26,239 $5,320 $20,919
Source: Public Records

Agents Affiliated with this Home

  • C

    Seller's Agent in 2023

    Cameron Cotten

    RE/MAX

    (573) 761-3497

    142 Total Sales

    Cameron Cotten
    Section Image

  • L

    Buyer's Agent in 2023

    Lori Brockman

    Weichert, Realtors - First Tier

    (573) 864-4702

    309 Total Sales

    Lori Brockman
    Section Image
See All Agents

Map

Source: Columbia Board of REALTORS®

MLS Number: 413418

Columbia Board of REALTORS®

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

Missouri Boone County Columbia 65202

5501 Gemstone Way, Columbia, MO

This home is located at 5501 Gemstone Way, Columbia, MO 65202 since 12 May 2023 and is currently estimated at $277,649, approximately $176 per square foot. This property was built in 2005. 5501 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