Skip main navigation
For sale
    • $950,000

    2504 Snowberry Cir, Columbia, MO 65201

    5beds
    5,010sqft
    : 
    Loading
    Get pre-qualified
    Single Family Residence
    Built in 2002
    2 Acres Lot
    $927,600 Zestimate®
    $190/sqft
    $53/mo HOA

    What's special

    Media roomSecond kitchenStained-glass accentsExercise roomMissouri white oak floorsWine cellarWhole-home audio
    This Frank Lloyd Wright-inspired estate was built with a level of craftsmanship rarely found today. Situated on 2 acres in Bluff Creek Estates, the home features Missouri white oak floors, solid red oak trim and doors, stained-glass accents, limestone fireplace sourced from the Missouri State Capitol, whole-home audio, wine cellar, media room, library, exercise room, second kitchen, and over 5,000 finished square feet. Recent roof, gutters, and downspouts already completed. A remarkable home for buyers who appreciate architecture, craftsmanship, and homes with a story. Fifth bedroom is non-conforming. If 2 acres aren't enough, you're 1 mile from amazing trail access for exercise and enjoying nature. Schedule your private tour and experience firsthand what makes this home truly exceptional.
    50 days
    |
    518
    |
    23
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Adam Curtis 573-268-0563,

    North Star Real Estate 573-238-8181,

    Billy Dexheimer 573-355-7000,

    North Star Real Estate

    Source: CBORMLS,MLS#: 435001MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 5
      • Bathrooms: 4
      • Full bathrooms: 3
      • 1/2 bathrooms: 1
      Primary bedroom
      • Level: Upper
      Bedroom 2
      • Level: Upper
      Bedroom 3
      • Level: Upper
      Bedroom 4
      • Level: Lower
      Primary bathroom
      • Level: Upper
      Full bathroom
      • Level: Upper
      Full bathroom
      • Level: Upper
      Full bathroom
      • Level: Lower
      Half bathroom
      • Level: Main
      Other
      • Level: Main
      Dining room
      • Level: Main
      Exercise room
      • Level: Lower
      Family room
      • Level: Lower
      Foyer
      • Level: Main
      Hearth room
      • Level: Main
      Kitchen
      • Level: Main
      Office
      • Level: Main
      Recreation room
      • Level: Lower
      Workshop
      • Level: Lower
      Heating
      • Forced Air, Natural Gas
      Cooling
      • Central Electric
      Appliances
      • Included: Dishwasher
      • Laundry: Washer/Dryer Hookup
      Features
      • High Speed Internet, Tub/Shower, Stand AloneShwr/MBR, Walk-In Closet(s), Breakfast Room, Formal Dining, Cabinets-Custom Blt, Kitchen Island, Pantry
      • Flooring: Wood, Carpet, Concrete, Slate
      • Basement: Walk-Out Access
      • Has fireplace: Yes
      • Fireplace features: Living Room, Wood Burning, Screen
      Interior area
      • Total structure area: 5,010
      • Total interior livable area: 5,010 sqft
      • Finished area below ground: 1,645
      Video & virtual tour

      Property

      Parking
      • Total spaces: 3
      • Parking features: Attached, Paved
      • Attached garage spaces: 3
      Features
      • Patio & porch: Covered, Concrete, Back, Deck, Front Porch
      • Has spa: Yes
      • Spa features: Tub/Built In Jetted
      Lot
      • Size: 2 Acres
      • Features: Partial Sprinklers
      Details
      • Parcel number: 1740400030010001
      • Zoning description: R-1 One- Family Dwelling*

      Construction

      Type & style
      • Home type: SingleFamily
      • Property subtype: Single Family Residence
      Materials
      • Foundation: Concrete Perimeter
      • Roof: ArchitecturalShingle
      Condition
      • Year built: 2002

      Utilities & green energy

      • Utilities for property: Trash-City

      Community & HOA

      Community
      • Subdivision: Bluffcreek Est
      HOA
      • Has HOA: Yes
      • HOA fee: $640 annually
      Location
      • Region: Columbia

      Financial & listing details

      • Price per square foot: $190/sqft
      • Tax assessed value: $953,300
      • Annual tax amount: $10,672
      • Date on market: 6/2/2026
      • Road surface type: Paved

        Estimated market value

        $927,600

        $881,000 - $974,000

        $4,673/mo

        Price history

        DateEventPrice
        6/2/2026Listed for sale$950,000-4.5%$190/sqft
        Source: CBORMLS #435001 Report a problem
        6/1/2026Listing removed$995,000$199/sqft
        Source: CBORMLS #431284 Report a problem
        4/9/2026Price change$995,000-3.9%$199/sqft
        Source: CBORMLS #431284 Report a problem
        3/13/2026Price change$1,035,000-4.2%$207/sqft
        Source: CBORMLS #431284 Report a problem
        12/14/2025Price change$1,080,000-6.1%$216/sqft
        Source: CBORMLS #431284 Report a problem
        9/12/2025Listed for sale$1,150,000$230/sqft
        Source: CBORMLS #429758 Report a problem
        9/1/1997Sold--
        Source: Agent Provided Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025-- $181,127 +14.5%
        2024$10,672 +0.8%$158,194
        2023$10,584 +4.1%$158,194 +4%
        2022$10,167 -0.2%$152,114
        2021$10,186 -2.3%$152,114 +4%
        2020$10,423 0%$146,262
        2019$10,423 -0.7%$146,262
        2018$10,496 +1.2%$146,262
        2017$10,369 +0.2%$146,262
        2016$10,351 $146,262
        2015$10,351 +8.9%$146,262
        2014$9,506 $146,262
        2013-- $146,262
        2012-- $146,262
        2011-- $146,262
        2010-- $146,262
        2009-- $146,262
        2008-- $146,262
        2007-- --
        2003-- $51,890
        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.
        Get pre-qualified

        Climate risks

        Neighborhood: Bluff Creek Estates

        Getting around

        16 / 100
        Car-Dependent
        40 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: New Haven
        • Middle: Gentry
        • High: Rock Bridge

        Source: CBORMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        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

              Nearby cities

              Nearby neighborhoods

              Nearby zip codes

              Other Columbia Topics

                Search
                Updates
                Favorites
                Plan
                Inbox