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=190) and (outfitter_trip.outfitter_id=outfitter.outfitter_id) and (outfitter_trip.destination_id=destination.destination_id) order by outfitter_trip.
;
Cannot perform query.

The Boundary Waters Canoe Area of Minnesota and the Quetico Provincial Park of Canada are two million acre wilderness areas set aside for you to enjoy solely by way of canoe. There are no roads, or power lines, or motorized craft allowed inside these pristine areas. No one lives in these areas so you will share it only with a handful of other canoeists. It is an area of pine forests, crystal clear lakes, and high granite cliffs... where moose roam the woods while bald eagles soar overhead and the loons beckon to you from the lake
About Us |
Privacy Policy |
Contact Us
© Copyright 1999-2005 GetOutdoors, All rights reserved.
 |
| Contact Information |
Seagull Outfitters
Email:
Phone: (218) 388-2216
12208 Gunflint Trail
Grand Marais MN, 55604
United States
|
|
|
 |