SELECT * FROM PCLNhotellist WHERE country_code = '#param2#' AND city = '#param#' WHERE country_code = 'us' AND state_code = '#param2#' AND city = '#param#' AND WCThotelid IS NOT null ORDER by hotel_name asc SELECT * FROM states WHERE st = '#param2#' SELECT * FROM PCLNhotellist WHERE country_code = '#param2#' WHERE country_code = 'us' AND state_code = '#param2#' AND WCThotelid IS NOT null ORDER by city asc

#ucase(findhotels.city)# HOTELS - #ucase(findhotels.city)# #findhotels.state_code# HOTEL REVIEWS - ACTIVITIES - RESERVATIONS FOR HOTELS IN #ucase(findhotels.city)#, #ucase(getstate.state)#

United States Hotels - International Hotels