$297,000

5501 Gemstone Way Columbia, MO 65202

Columbia Area

Estimated payment $1,809/month

Total Views 328
3 Beds
2 Baths
1,555 Sq Ft
$191 Price per Sq Ft

Highlights

  • Traditional Architecture
  • No HOA
  • Formal Dining Room
  • Main Floor Primary Bedroom
  • Covered Patio or Porch
  • 2 Car Attached Garage

About This Home

This move-in-ready ranch offers a split-bedroom floor plan with 3 bedrooms and 2 bathrooms, situated on a large corner lot. The home features a spacious kitchen with formal and informal dining areas. The large living room has a gas fireplace. The primary bedroom includes a walk-in closet, dual vanities, and plenty of space to unwind. Outside, enjoy the covered patio overlooking a fully fenced backyard.

Listing Agent

David Wilson

Weichert, Realtors - House of Brokers License #2019047463 Listed on: 08/12/2026

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,126

Year Built

  • Built in 2005

Lot Details

  • Lot Dimensions are 115.71 x 92.73
  • South Facing Home
  • Wood Fence
  • Back Yard Fenced

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Home Design

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

Interior Spaces

  • 1,555 Sq Ft Home
  • Paddle Fans
  • Gas Fireplace
  • Vinyl Clad Windows
  • Window Treatments
  • Living Room with Fireplace
  • Formal Dining Room
  • Fire and Smoke Detector

Kitchen

  • Eat-In Kitchen
  • Electric Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Laminate Countertops

Flooring

  • Carpet
  • Tile
  • Vinyl Plank

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Primary Bedroom on Main
  • Split Bedroom Floorplan
  • Walk-In Closet
  • Bathroom on Main Level
  • 2 Full Bathrooms
  • Bathtub with Shower

Laundry

  • Laundry on main level
  • Washer and Dryer Hookup

Outdoor Features

  • Covered Patio or Porch

Schools

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

Utilities

  • Cooling Available
  • Forced Air Heating System
  • Heating System Uses Natural Gas
  • High Speed Internet
  • Internet Available
  • 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

$2,126

Year Built

Built in 2005

Lot Details

0 Sq Ft Lot

Parking

2

Listing Details

  • Directions: Lake of the Woods Road left on Kelsey Drive. Right on Shamrock Drive to Gemstone Way.
  • Lot Size: 115.71 x 92.73
  • Prop. Type: Residential
  • Full Bathroom Level: Main
  • Year Built: 2005
  • Property Sub Type: Single Family Residence
  • Road Surface Type: Paved
  • Subdivision Name: GREYSTONE
  • Above Grade Finished Sq Ft: 1555.0
  • Architectural Style: Traditional
  • Garage Type Attached: Yes
  • ArchStyle:Traditional: Yes
  • Roof:ArchitecturalShingle: Yes
  • Utilities:Electric-County: Yes
  • Utilities:Gas-Natural: Yes
  • Flooring:Carpet: Yes
  • Flooring:Tile: Yes
  • Patio:Back3: Yes
  • Dining:Eat-In Kitchen: Yes
  • Dining:Formal Dining: Yes
  • Patio:Concrete2: Yes
  • Patio:Covered3: Yes
  • Exterior Finish:Vinyl2: Yes
  • Porch:Covered2: Yes
  • Porch:Front2: Yes
  • Exterior Finish:Brick Veneer: Yes
  • Appliances:Dishwasher-Built In: Yes
  • Appliances:Microwave Oven: Yes
  • Fencing:Backyard: Yes
  • Appliances:Range-Electric: Yes
  • Fencing:Wood5: Yes
  • Sewer:Public2: Yes
  • Special Features: None

Interior Features

  • Flooring: Vinyl Plank, Carpet, Tile
  • Interior Amenities: Primary Downstairs, High Spd Int Access, Tub/Shower, Split Bedroom Design, Walk in Closet(s), Washer/DryerConnectn, Eat-in Kitchen, Formal Dining, Counter-Laminate, Cabinets-Wood, Kitchen Island
  • Appliances: Refrigerator, Microwave, Electric Range, Dishwasher
  • Basement YN: No
  • Full Bathrooms: 2
  • Total Bedrooms: 3
  • Fireplace Features: In Living Room, Gas
  • Fireplace: Yes
  • Living Area: 1555.0
  • Window Features: Window Treatments Some, Windows-Vinyl
  • Fireplace:Gas: Yes
  • InteriorFeatures:Cable Ready: Yes
  • InteriorFeatures:CeilingPaddleFan(s): Yes
  • InteriorFeatures:High Spd Int Access: Yes
  • InteriorFeatures:Laundry-Main Floor: Yes
  • InteriorFeatures:Main Lvl Master Bdrm: Yes
  • InteriorFeatures:Smoke Detector(s): Yes
  • InteriorFeatures:Split Bedroom Design: Yes
  • InteriorFeatures:TubShower: Yes
  • InteriorFeatures:Walk in Closet(s): Yes
  • InteriorFeatures:WasherDryerConnectn: Yes
  • KitchenFeatures:Cabinets-Wood: Yes
  • KitchenFeatures:Island: Yes
  • Fireplace:In Living Room: Yes
  • InteriorFeatures:Cable Available: Yes
  • InteriorFeatures:WindowTreatmnts Some: Yes
  • KitchenFeatures:Counter-Laminate: Yes
  • Flooring: Vinyl Plank: Yes

Exterior Features

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

Garage/Parking

  • Garage Spaces: 2.0
  • Parking Features: Garage Door Opener, Attached, Driveway, Paved
  • General Property Description:Garage Capacity: 2
  • InteriorFeatures:Garage Dr Opener(s): Yes

Utilities

  • Utilities: Fiber Optic Internet, Broadband/Cable Internet, Cable Available, Water-City, Cable Ready, Electric-County, Trash-City
  • Cooling: Ceiling/PaddleFan(s)
  • Heating: Forced Air, Natural Gas
  • Laundry Features: Laundry-Main Floor
  • Security: Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Heating:Forced Air: Yes
  • Heating:Natural Gas: Yes
  • Utilities: Fiber Optic Internet: Yes
  • Utilities: Broadband/Cable Internet: Yes

Condo/Co-op/Association

  • Senior Community: No
  • Association: No

Schools

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

Lot Info

  • Zoning: Single Family Res
  • Land Lease Amount Frequency: N/A
  • Land Lease: No
  • Parcel #: 1720200070610001
  • Zoning Description: R-1 One- Family Dwelling*

Tax Info

  • Tax Annual Amount: 2126.33
  • Tax Year: 2025

Map

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

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,126 $32,471 $5,320 $27,151
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

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/12/2026 08/12/26 For Sale $297,000 +16.5% $191 / Sq Ft
06/16/2023 06/16/23 Sold -- -- -- View Prior Sale
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®

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 Type Sale Price Title Company
Warranty Deed -- Boone Central Title
Warranty Deed -- Boone Central Title Co
Warranty Deed -- 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 Loan Amount Loan Type
Open $204,000 New Conventional
Previous Owner $130,400 New Conventional
Previous Owner $151,400 New Conventional
Source: Public Records

About the Listing Agent

David Wilson
David Wilson

Weichert, Realtors - House of Brokers

(573) 995-2831

Section Image

View David's Profile

David's Other Listings

  • 1503 Spiros Dr Unit D, Columbia, MO 65202

    $214,500 $11K PRICE DROP

    • 4 Beds
    • 2.5 Baths
    • 2,100 Sq Ft
    • 1503 Spiros Dr
    • Unit D
    • Columbia, MO

    Perfect place for a first time homebuyer! This spacious 4-bedroom, 2.5 bath condo offers 2,100 square feet of comfortable living in a convenient Columbia location. The generous floor plan provides plenty of room to grow, with multiple bedrooms ideal for guests, a home office, or shared living. Enjoy low maintenance living with access to community amenities including a pool. Conveniently located

    David Wilson Weichert, Realtors - House of Brokers

  • 0 N Elkin Rd, Hallsville, MO 65255

    $90,000 Pending

    • Land
    • 5.09 Acres
    • $17,682 per Acre
    • 0 N Elkin Rd
    • Hallsville, MO

    Land is suitable for a ranch or walkout home.

    David Wilson Weichert, Realtors - House of Brokers

  • 2700 Squire Cir, Columbia, MO 65202

    $230,000 Sold Nov 24, 2025

    • 4 Beds
    • 2 Baths
    • 2,024 Sq Ft
    • 2700 Squire Cir
    • Columbia, MO

    Well maintained home on a quiet cul-de-sac just minutes from downtown and local shopping! The main level features a spacious living room and three comfortable bedrooms. The finished lower level offers a large family room, perfect for entertaining or relaxing, and an additional bedroom, providing plenty of space for guests or a home office.

    David Wilson Weichert, Realtors - House of Brokers

  • 4205 Grant Ln, Columbia, MO 65203

    $875,000 Sold Mar 09, 2026

    • 5 Beds
    • 3.5 Baths
    • 5,357 Sq Ft
    • 4205 Grant Ln
    • Columbia, MO

    This spacious and meticulously maintained 5,415 sq. ft. home offer 5 bedroom, 3.5 baths, and over 2,373 sq. ft. of unfinished space-perfect for storage or future expansion. The generously sized primary bedroom includes a large walk-in closet and a recently updated en-suite bath featuring a standalone jetted tub, and a spacious shower. The updated kitchen features quartz countertops, a double

    David Wilson Weichert, Realtors - House of Brokers

  • 0 Tract 5a Hwy Uu Unit 425511, Columbia, MO 65203

    $550,000 Sold Sep 26, 2025

    • Land
    • 13.36 Acres Lot
    • 0 Tract 5a Hwy Uu
    • Unit 425511
    • Columbia, MO

    This beautiful piece of land is located in the Scenic View Estates subdivision, which is just west of Columbia. The subdivision offers a gated entrance, providing extra security for its residence. One of the main attractions is the large lake which adds to the areas natural beauty. Essential services like high-speed Internet, electricity, and water are already set up on this tract of land. Making

    David Wilson Weichert, Realtors - House of Brokers

  • 7402 W Sandalwood Ct, Columbia, MO 65202

    $299,000 Sold Dec 02, 2025

    • 3 Beds
    • 3 Baths
    • 2,088 Sq Ft
    • 7402 W Sandalwood Ct
    • Columbia, MO

    This beautifully maintained home is just minutes from Columbia and offers a perfect blend of modern updates and serene surroundings. The kitchen features granite countertops and a stylish glass tile backsplash, while the primary bedroom boasts a freshly updated bathroom (2025). Major improvements include a new roof, gutters, and siding in 2022. Step outside to a spacious deck overlooking the

    David Wilson Weichert, Realtors - House of Brokers

  • 100 Peterson Ln, Ashland, MO 65010

    $574,900 Sold Aug 12, 2026

    • 5 Beds
    • 3.5 Baths
    • 3,315 Sq Ft
    • 100 Peterson Ln
    • Ashland, MO

    This well-maintained 5-bedroom, 3.5-bath home in the desirable Eagle Lakes subdivision offers spacious, open living with abundant natural light throughout. Theliving room features a gas fireplace with a stone surround, creating a warm and welcoming focal point. The kitchen is built for connection, featuring granitecountertops, a large island, and a spacious pantry that keeps everything organized

    David Wilson Weichert, Realtors - House of Brokers

  • 213 Dix Rd, Jefferson City, MO 65109

    $189,000 Sold Aug 26, 2025

    • 3 Beds
    • 2 Baths
    • 1,760 Sq Ft
    • 213 Dix Rd
    • Jefferson City, MO

    Charming older home located near schools and shopping. This 3-bedroom 2-bath home features hardwood floors, lots of kitchen cabinet space, family room located in partially finished basement, and plenty of storage space in the unfinished area of the basement. Home to be sold AS-IS.

    David Wilson Weichert, Realtors - House of Brokers

Source: Columbia Board of REALTORS®

MLS Number: 436545

Columbia Board of REALTORS®

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

Missouri Boone County Columbia 65202

5501 Gemstone Way, Columbia, MO

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
David Wilson
Listing Agent
David Wilson
Section Image
Weichert, Realtors - House of Brokers
(573) 995-2831
Your Personal Tour Guide

Ask me questions while you tour the home.