how messy does it get? where do you keep it/where do they play with it (ie backyard?)?

I want to get one for DS, but DH says he doesn't want to deal with the sand mess that he pictures being all over our grass and/or brick patio!