select outfitter_trip.outfitter_trip_id as id,outfitter_trip.name,outfitter_trip.city,outfitter_trip.state,outfitter_trip.short_description as dsc,outfitter_trip.fee,outfitter_trip.outfitter_id,outfitter.name as outfitter_name,outfitter.image_logo as image,outfitter_trip.destination_id,destination.name as destination_name from outfitter_trip,outfitter,destination where (outfitter_trip.outfitter_id=183) and (outfitter_trip.outfitter_id=outfitter.outfitter_id) and (outfitter_trip.destination_id=destination.destination_id) order by outfitter_trip.
 |
;Cannot perform query.
Since 1985 Rim Tours has earned its reputation by offering the very best professionally guided mountain bike trips to Utah's Canyon country, Colorado's Rocky Mountains, Arizona's Grand Canyon, and Hawaii's island of Molokai. Our tours showcase the most beautiful and pristine backcountry locations in the United States. We have pioneered backcountry biking tours with your safety and enjoyment as our highest priority. Our backcountry ethic assures minimal impact from our travels so others may return time and again to unspoiled wilderness. A Rim Tours experience is like no other and we invite you to give us a call to see why.
