A member has produced three books that cover the entire U.S. as DSDP Don mentioned. They are updated occasionally.
You can buy one or all by calling:
Carmichael,CA Elks Lodge at (916) 489-2103.
We have stayed at about a dozen lodges in California and several across the country as we went to Florida. 99% of our trips are to explore various areas so staying in a really nice campground is not important for us although there are some pretty nice ones.
A good thing about staying at the Elks is we never worry about anybody stealing anything plus you can talk to the local Elks people to get good information on what to do and see.
I've checked on joining the Moose lodge but their RV facilities are nowhere as plentiful as are the Elks.