I have only seen sand in saltwater tanks. I can't see why you couldn't use sand in a freshwater tank, though. Just be careful because a lot of the aquarium sand pet stores sell is treated with bacteria meant for saltwater tanks. I'm not sure how it would affect a freshwater setup.