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.
Pending
$899,900
2504 Snowberry Cir, Columbia, MO 65201
5beds
5,010sqft
Single Family Residence
Built in 2002
2 Acres Lot
$862,900 Zestimate®
$180/sqft
$53/mo HOA
What's special
Media roomSecond kitchenStained-glass accentsExercise roomMissouri white oak floorsWine cellarWhole-home audio
- 146 days
- 140
- 3
Zillow last checked:
Listing updated:
Listed by:
Billy Dexheimer 573-355-7000,
North Star Real Estate 573-238-8181,
Adam Curtis 573-268-0563,
North Star Real Estate
Source: MMBOR,MLS#: 435001
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
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: $180/sqft
- Tax assessed value: $953,300
- Annual tax amount: $10,672
- Date on market: 6/2/2026
- Road surface type: Paved
Estimated market value
$862,900
$820,000 - $906,000
$4,763/mo
Price history
| Date | Event | Price |
|---|---|---|
| 9/21/2026 | Pending sale | $899,900$180/sqft |
Source:  MMBOR #435001 Report a problem | ||
| 7/24/2026 | Price change | $899,900-5.3%$180/sqft |
Source: MMBOR #435001 Report a problem | ||
| 6/2/2026 | Listed for sale | $950,000-4.5%$190/sqft |
Source: MMBOR #435001 Report a problem | ||
| 6/1/2026 | Listing removed | $995,000$199/sqft |
Source: MMBOR #431284 Report a problem | ||
| 4/9/2026 | Price change | $995,000-3.9%$199/sqft |
Source: MMBOR #431284 Report a problem | ||
| 3/13/2026 | Price change | $1,035,000-4.2%$207/sqft |
Source: MMBOR #431284 Report a problem | ||
| 12/14/2025 | Price change | $1,080,000-6.1%$216/sqft |
Source: MMBOR #431284 Report a problem | ||
| 9/12/2025 | Listed for sale | $1,150,000$230/sqft |
Source: MMBOR #429758 Report a problem | ||
| 9/1/1997 | Sold | -- |
Source: Agent Provided Report a problem | ||
Public tax history
| Year | Property taxes | Tax 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.Climate risks
Neighborhood: Bluff Creek Estates
Nearby schools
Schools provided by the listing agent
- Elementary: New Haven
- Middle: Gentry
- High: Rock Bridge
Source: MMBOR. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Similar homes
- $1,000,0005 bd5 ba5k sqft2409 Stratford Chase Pkwy, Columbia, MO 65201For Sale
MLS ID #437186, Jay Wilson, Weichert, Realtors - House of Brokers. MMBOR - $984,0004 bd4 ba4.1k sqft820 E Happy Hollow Rd, Columbia, MO 65203For Sale
MLS ID #438152, Erin Hendershott, 573 Realty, LLC. MMBOR - $935,0005 bd3 ba4.4k sqft5958 Screaming Eagle Ln, Columbia, MO 65201For Sale
MLS ID #434822, Sara Harper, Weichert, Realtors - House of Brokers. MMBOR - $895,0004 bd5 ba5.2k sqft7801 S Cave Creek Rd, Columbia, MO 65203For Sale
MLS ID #434381, Sara Harper, Weichert, Realtors - House of Brokers. MMBOR
