Thanks Tom for helping out.
The following have been added to the USBA list of 3-Cushion Rooms:
Cue and Cushion
Raytown Recreation
We also retired (sadly) Big Daddy's which will continue to appear but with a big ugly red message - no three cushion table.
In addition... we have enhanced the search feature. You can now search by Room Name, City or State (Spell all or a portion of any key word) We went away from state abbreviations because a search for partial words makes it easier for folks to find things.... and searching for "IL" would bring up every room with the word "Billiards" in it due to the partial match.
At the bottom of the list is a drop-down box where you can select the number of rooms to display on a page. One of the choices is "ALL"
If you click on the title of any column it will sort... first in ascending order... click again... then descending order.
So... it is possible to display all rooms on one page... then sort the list by state and see everything that way... or sort and display alphabetically by name... or grouped by city... well... you get the picture.
If you don't like your search criteria... click reset and the whole list comes back.
Clicking on any one room displays the room page which provides details including a map and pictures if we have them (hurry up - send pictures!) If there are upcoming or recently completed (within the month) tournaments at that location they will be displayed. Clicking on the tournament name will take you to the tournament listing where you can see all the details of the event that have been reported to USBA by the organizer. If the tournament is complete you can click on the results link and see the cross tables.
I think that about covers it... if I missed something... someone please remind me...
Here is the link to the room finder page. If you don't find your room listed... send me the details in a PM and I will add it.
http://www.usba.net/tournaments/where-to-play/locations