Skip main navigation
For sale by owner
  • $297,000

    5501 Gemstone Dr, Columbia, MO 65202

    3beds
    1,555sqft
    : 
    Loading
    Get pre-qualified
    SingleFamily
    Built in 2005
    10,729 Square Feet Lot
    $-- Zestimate®
    $191/sqft
    $-- HOA

    What's special

    Open concept kitchen
    **OPEN HOUSE THIS SUNDAY, July 12th, 2026, from 3 pm to 5 pm** Welcome to your new home! Stepping in the front door, you'll be greeted by a large living room with a fireplace that is just begging for cozy movie nights on the couch! From the living room you have access to the open concept kitchen complete with an island that is perfect for all those homecooked meals. The master bedroom offers a walk in closet and the attached master bath boasts a dual sink vanity and bathroom closet. The spare bedrooms are perfectly spacious for whatever you envision whether that be a guest suite, nursery, office, or anything else! The bonus room to the front of the house could also serve as an office with the big windows allowing in natural light or as a formal dining room. Let's not forget the spacious backyard! Complete with a privacy fence that encloses the entire backyard, it is perfect for pets, kids, gardening, etc. Not to mention, the covered cement patio in the backyard serves as a great place to set up some patio furniture and enjoy those beautiful fall nights or to set up a grill for a nice summer BBQ! As a bonus, the subdivision is home to many families creating a nice place for walks through the subdivision or even bike riding. It still gets better, as just a short walk brings you to Indian Hills Park, which has several playgrounds, a dog park, an 0.8 mile trail loop, an 18-hole disc golf course, and so much more. Whatever your plans for the future, this home can make those dreams come true!
    37 days
    |
    815
    |
    41
    |
    Listed by:

    Property Owner (563) 542-4538

    This property is for sale by owner and Zillow, Inc. is displaying it at the owner's request. It is not subject to a listing agreement with Zillow, Inc. or its affiliates.

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 2
      • Full bathrooms: 2
      Heating
      • Other
      Cooling
      • Central
      Appliances
      • Included: Dishwasher, Dryer, Garbage disposal, Microwave, Range / Oven, Refrigerator, Washer
      Features
      • Basement: None
      Interior area
      • Total interior livable area: 1,555 sqft

      Property

      Parking
      • Parking features: Garage - Attached
      Features
      • Exterior features: Wood
      Lot
      • Size: 10,729 Square Feet
      Details
      • Parcel number: 1720200070610001

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Conventional
      Materials
      • Frame
      Condition
      • New construction: No
      • Year built: 2005

      Community & HOA

      Location
      • Region: Columbia

      Financial & listing details

      • Price per square foot: $191/sqft
      • Tax assessed value: $170,900
      • Date on market: 6/12/2026

        Estimated market value

        Not available

        Estimated sales range

        Not available

        $1,935/mo

        Price history

        DateEventPrice
        6/12/2026Listed for sale$297,000+16.5%$191/sqft
        Source: Owner Report a problem
        6/16/2023Sold--
        Source: JCMLS #10065378 Report a problem
        5/16/2023Pending sale$254,900$164/sqft
        Source: JCMLS #10065378 Report a problem
        5/12/2023Listed for sale$254,900$164/sqft
        Source: CBORMLS #413418 Report a problem
        6/30/2016Sold--
        Source: CBORMLS #520001_363877 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025-- $32,471 +14.5%
        2024$1,914 +0.8%$28,367
        2023$1,898 +4.1%$28,367 +4%
        2022$1,824 -0.2%$27,284
        2021$1,827 -2.3%$27,284 +4%
        2020$1,870 0%$26,239
        2019$1,870 -0.7%$26,239
        2018$1,883 +1.2%$26,239
        2017$1,860 +0.2%$26,239
        2016$1,857 $26,239
        2015$1,857 +8.9%$26,239
        2014$1,705 $26,239
        2013-- $26,239
        2012-- $26,239
        2011-- $26,239
        2010-- $26,239
        2009-- $26,239
        2008-- $26,239
        2007-- --
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 65202

        Getting around

        4 / 100
        Car-Dependent
        18 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts

        Similar homes