How would a new casino affect a community?

I am curious about how it would affect real estate/property values, as well as crime, etc. If anyone has any experience with this or knows any statistics, please let me know. Thanks!