[SELECT se_listing.lid, se_listing.company, se_listing.mailing_address, se_listing.mailing_city, se_listing.mailing_state, se_listing.mailing_zip, se_listing.tel, se_listing.web, se_listing_directory.image1, se_listing_directory.competitions_host, se_listing_directory.sales_msg, se_listing.inactive_flag, se_listing.directory_city, se_listing.directory_state, se_listing.online_enh_flag, se_listing.online_enhanced_start_date , se_listing.online_enhanced_end_date, se_listing.is_serviceprovider FROM se_listing LEFT JOIN se_listing_directory ON se_listing.lid = se_listing_directory.lid WHERE (`inactive_flag` = '0' AND `is_serviceprovider` = '1' ) ORDER BY `company` ASC ]
Find a Destination
Novi, Michigan
TRAVELING TEAMS® is a full-service agency and a leading provider of integrated event housing services. Celebrating more than 20 years, we serve sports facilities, event directors and youth teams nationwide. Our experts negotiate with hotels on behalf of your event and deliver a seamless booking experience for all participants! Contact us today!! Sponsorship@TravelingTeams.com
Hasbrouck Heights, New Jersey
Vancouver, British Columbia