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

2504 SNOWBERRY CIR, COLUMBIA, MO 65201

New Listing

$950,000

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: $950,000 List Date: 6/02/2026 Last Modified: 6/02/2026

Overview

Description

This Frank Lloyd Wright-inspired custom 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, a 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. 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
Appx Fin Other Sq Ft #: 0
Basement: Yes
Appx UnFin Sq Ft Main #: 0
Appx UnFin Sq Ft Upper #: 0
Appx UnFin Other Sq Ft #: 0

Status Change Info

List Price/Sqft: 189.62
Status Change Date: 2026-06-02

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
Bedroom 2: Yes
Bedroom 3: Yes
Bedroom 4: Yes
Dining Room: Yes
Exercise Room: Yes
Family Room: Yes
Foyer: Yes
Full Bathroom: Yes
Half Bathroom: Yes
Hearth Room: Yes
Kitchen: Yes
Master Bathroom: Yes
Master Bedroom: Yes
Office: Yes
Recreation Room: Yes
Workshop: Yes

More Information

Location Tax & Legal

Cross Street: Lacewook Drive
Zoning: Single Family Res
Actual Taxes $: 10672.09
Tax Yr: 2025
School District: Columbia
Elementary Sch: New Haven
Middle/Jr High Sch: Gentry
Senior Sch: Rock Bridge
HOA/Condo: Yes
HOA/Condo $: 640
HOA/Condo Descrip: Annual
HOA/Condo Init: No
Condo Ext Maint: None
Legal Description: Bluff Creek Estates PLat 2-8 Lot 226
Auction: No
Land Lease: No
Land Lease Descrip: N/A
Located within City of Columbia: Yes

Remarks & Misc

Directions: From Grindstone, take Bluff Creek Drive to LEFT on Lacewood. Road curves into Snowberry and house is on the RIGHT.

Licensee Per/Int Dis

Not Applicable: Yes

Foundation Type

Full Bsmt Part Fin: Yes
Walkout Basement: Yes

Foundation Access

Walkout: Yes

Foundation Material

Poured Concrete: Yes

Appliances

Dishwasher: Yes
Double Oven: Yes
Exhaust Fan: Yes
Gas Range: Yes

Cooling

Central Electric: Yes

Fencing

None: Yes

Heating

Forced Air: Yes
Natural Gas: Yes

Roof

ArchitecturalShingle: Yes

Exterior Finish

Stone Veneer: Yes
Synthetic Stucco: Yes

Arch./Style

Traditional: Yes

Lot Features

Partial Sprinklers: Yes

Possession

At Closing: Yes

Restriction/Easement

Recorded Plat: Yes
Subdiv Restrictions: Yes

Deck

Back: Yes
Concrete: Yes

Water Source

Public: Yes

Sewer

Public: Yes

Dining

Breakfast Room: Yes
Formal Dining: Yes

Utilities

Electric-City of Columbia: Yes
Fiber Optic Internet: Yes
Gas - Natural: Yes
Trash-City: Yes

Road Responsibility

Public Maintained Road: Yes

Road Surface Type

Paved: Yes

Exterior Features

Driveway-Paved: Yes

Fireplace

In Living Room: Yes
Wood Burning: Yes

Flooring

Carpet: Yes
Concrete: Yes
Slate: Yes
Wood: Yes

Zoning

R-1 One- Family Dwelling*: Yes

Interior/Features

Cable Available: Yes
Ceiling/PaddleFan(s): Yes
Dual Zone Control HVAC: Yes
FireplaceScreenDr(s): Yes
Garage Dr Opener(s): Yes
High Spd Int Access: Yes
Laundry-Main Floor: Yes
Programmable Thermostat(s): Yes
Safe Room: Yes
Smart Home: Yes
Smoke Detector(s): Yes
Sound System: Yes
Stand AloneShwr/MBR: Yes
Tub/Built In Jetted: Yes
Tub/Shower: Yes
Utility Sink: Yes
Walk in Closet(s): Yes
Washer/DryerConnectn: Yes

Kitchen/Features

Cabinets-Custom Blt: Yes
Island: Yes
Pantry: Yes

Patio

Back: Yes
Concrete: Yes
Covered: Yes

Porch

Covered: Yes
Front: Yes

Property Features

Foundation Type: Full Bsmt Part Fin; Walkout Basement Cooling: Central Electric Deck: Back; Concrete Dining: Breakfast Room; Formal Dining Exterior Features: Driveway-Paved Exterior Finish: Stone Veneer; Synthetic Stucco Fencing: None Fireplace: In Living Room; Wood Burning Flooring: Carpet; Concrete; Slate; Wood Foundation Access: Walkout Foundation Material: 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: ArchitecturalShingle 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 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

Documents

Occupancy Disclosure ›

Listing Office: North Star Real Estate

Listing Agent: Adam Curtis

Co Listing Agent: Billy Dexheimer

Last Updated: June - 02 - 2026

Information deemed reliable but not guaranteed.

Property Info