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=321) and (outfitter_trip.outfitter_id=outfitter.outfitter_id) and (outfitter_trip.destination_id=destination.destination_id) order by outfitter_trip.
;
Cannot perform query.
Southwest Adventures has been conducting domestic and international trips and courses for over ten years. We are not a travel agent. We guide our own trips with our own staff and support networks. Our courses and trips run the year around. In the summer months we conduct rock climbing, mountaineering and mountain biking trips and courses in Southwest Colorado and high altitude mountaineering in South America and Alaska. In the winter months we conduct ice climbing and winter mountaineering trips in Southwest Colorado and conduct many international high altitude climbing and trekking expeditions in Asia, Africa, South America and Mexico. All guides undergo extensive training and have many years experience in the discipline in which they work. Owner / director, Clay Patton has twenty years of climbing experience and 15 years of professional guiding experience. He personally oversees all trips and courses.
About Us |
Privacy Policy |
Contact Us
© Copyright 1999-2005 GetOutdoors, All rights reserved.
 |
| Contact Information |
Southwest Adventures
Email:
Phone: (800) 642-5389
P.O. Box 3242
Durango CO, 81302
United States
|
|
|
 |