2504 SNOWBERRY CIR, COLUMBIA, MO 65201 (MLS# 435001)

2504 SNOWBERRY CIR, COLUMBIA, MO 65201

$899,900

Virtual Tour

https://www.zillow.com/view-imx/0758ad2e-730e-41f4-a0f2-776ce8392129?wl=true&setAttribution=mls&initialViewType=pano

Property Type: Residential Bedrooms: 5 Baths: 4 Square Footage: 5,010 Lot Size (sq. ft.): 87,120 Status: Active

Current Price: $899,900 List Date: 6/02/2026 Last Modified: 8/31/2026

Overview

Description

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.

Listing Details MLS# 435001

Location, Tax & Legal

Area: Southeast
Street No #: 2504
Street: SNOWBERRY
Street Suffix: CIR
County: Boone
State/Province: MO
Zip Code: 65201
Subdivision: BLUFFCREEK EST
Mapping ID #: 1740400030010001

General Property Description

Type: Single Family Residence
Attached/Detached: Detached
Primary Style: 2 Story
# of Bedrooms: 5
# of Bedrooms Above Grade: 3
Baths Full: 3
# of Baths-Half: Yes
Total Bathrooms: 4
Garage Capacity: 3
Age Description: 21-30 Yrs
# of Acres: 2
Sq Ft Source: Listing Agent
Appx Fin Sq Ft Main #: 2020
Appx Fin Sq Ft Lower #: 1645
Appx Fin Sq Ft Upper #: 1345
Appx Fin Sq Ft Total #: 5010
Appx UnFin Sq Ft Lower #: 1210
Appx UnFin Sq Ft Total #: 1210
Year Built: 2002
House Faces: NW

Status Change Info

List Price/Sqft: 179.62
Status Change Date: 2026-06-02
Kickout Contract Dte: 2026-10-31

Property Disclosure

Property Disclosure To Be Provided: Yes

Rooms

Bedroom 2 Level: Upper
Bedroom 3 Level: Upper
Bedroom 4 Level: Lower
Dining Room Level: Main
Exercise Room Level: Lower
Family Room Level: Lower
Foyer Level: Main
Full Bathroom Level: Upper
Half Bathroom Level: Main
Hearth Room Level: Main
Kitchen Level: Main
Laundry Room Level: Main
Master Bathroom Level: Upper
Master Bedroom Level: Upper
Office Level: Main
Recreation Room Level: Lower
Workshop Level: Lower

More Information

Property Features

Basement: Full; Partially Finished; Walk-Out Access Cooling: Zoned; Central Electric Deck: Back; Concrete Dining: Breakfast Room; Formal Dining Exterior Finish: Stone Veneer; Synthetic Stucco Fencing: None Fireplace: In Living Room; Wood Burning Flooring: Carpet; Concrete; Slate; Wood Foundation Details: Poured Concrete Heating: Forced Air; Natural Gas Appliances: Dishwasher; Double Oven; Exhaust Fan; Gas Range Patio: Back; Concrete; Covered Porch: Covered; Front Possession: At Closing Roof: Architectural Shingle Road Responsibility: Public Maintained Road Road Surface Type: Paved Lot Features: Partial Sprinklers Rooms: Bedroom 2; Bedroom 3; Bedroom 4; Dining Room; Exercise Room; Family Room; Foyer; Full Bathroom; Half Bathroom; Hearth Room; Kitchen; Master Bathroom; Master Bedroom; Office; Recreation Room; Workshop Water Source: Public Sewer: Public Utilities: Electric-City of Columbia; Fiber Optic Internet; Gas - Natural; Trash-City Parking Features: Driveway; Paved Zoning: R-1 One- Family Dwelling*

Room Information

Room Name	Level
Full Bathroom	Upper
Full Bathroom	Upper
Full Bathroom	Lower
Half Bathroom	Main
Foyer	Main
Kitchen	Main
Hearth Room	Main
Office	Main
Dining Room	Main
Laundry	Main
Master Bedroom	Upper
Master Bathroom	Upper
Bedroom 2	Upper
Bedroom 3	Upper
Recreation Room	Lower
Family Room	Lower
Bedroom 4	Lower
Workshop	Lower
Exercise Room	Lower