<% Param = Request.QueryString("Param") Data = Request.QueryString("Data") %> <% If IsObject(Session("watercraft_conn")) Then Set conn = Session("watercraft_conn") Else Set conn = Server.CreateObject("ADODB.Connection") conn.open "watercraft","","" Set Session("watercraft_conn") = conn End If %> <% sql = "SELECT Dealers.CustomerID, Dealers.CompanyName, Dealers.Address, Dealers.City, Dealers.State, Dealers.Zip, Dealers.Country, Dealers.PhoneNumber, Dealers.FaxNumber, Dealers.TollFree, Dealers.EmailAddress, Dealers.Description, Dealers.Brands, Dealers.WebAddress, Dealers.BoatDealer, Dealers.PWCDealer, Dealers.Accessories, Dealers.BoatBuilder, Dealers.CanoeDealer, Dealers.InflatableDealer, Dealers.OutboardMotor, Dealers.PWCRental, Dealers.HBRental, Dealers.Tour, Dealers.YachtDealer, Dealers.Repair FROM Dealers WHERE (((Dealers.State)='az') AND ((Dealers.PWCDealer)=Yes)) " If cstr(Param) <> "" And cstr(Data) <> "" Then sql = sql & " And [" & cstr(Param) & "] = " & cstr(Data) End If sql = sql & " ORDER BY Dealers.City " Set rs = Server.CreateObject("ADODB.Recordset") rs.Open sql, conn, 3, 3 %>

 

USAWatercraft your one stop recource for all your boating and water sport recreation needs.MastheadRightNeon.gif (3284 bytes)

NEW River Cam Check it out today. Live pictures from the Colorado River!
Arizona PWC Dealers
QuoteVert.gif (7785 bytes) PWC Dealers
(personal watercraft)
California, Arizona, Nevada,  Classifieds, PWC Quote

Boat Dealers
California, Arizona, Nevada,  International

 Manufacturers
Boats, PWCs, Motors		 QuoteVert.gif (7785 bytes)
Check out our newest service. Dealers, get the details and signup now for PWC Quote®, don't miss your next sale!
<% On Error Resume Next rs.MoveFirst do while Not rs.eof %> <% rs.MoveNext loop%>
Arizona Motorsports Group
Premier motorcycle, ATV, personal watercraft, and boat multi-line dealership group. Parts, accessories, clothing and service for all makes and models. Hundreds of used bikes, all terrain vehicles, jetskis and boats in stock at all times.		 offsite.gif (627 bytes)
Arctic Circle Motor Sports
3880 Old Rt. 66, Flagstaff, AZ
Sales, Rentals, Parts, Service & Accessories		 928-526-1665
Aztec Marine & Cycle
16202 N. Cave Creek Road, Phoenix, AZ 85032
Princecraft Deckboats, Sunbird, Zodiac, Avon, OMC
Evinrude, Johnson, MerCruiser, Chrysler, Force, Achilles		 602 867-3570
Arizona Aquatics
1535 El Camino Way Lake Havasu City, Az.
Polaris Watercraft		 928 880-4151
Bullhead Bike Center
2140 Hwy 95 Bullhead City, Az.
Kawasaki Jet Ski, Yamaha WaveRunner, Polaris		 928 758-3200
The Boat Brokers Inc
1686 Industrial Blvd Lake Havasu City Az. 86403-3639
Sea Doo Watercraft		 928 453-8833
Hale's Motors
534 Madison Ave. Prescott, Az. 86301
Offering Honda, Kawasaki & Suzuki brands. Street Cruisers, ATV's Jet Skies and Genrators.

928 445-5730
Kawasaki Suzuki of Yuma
2029 So. Arizona Ave. Yuma, Az. 85363
Kawasaki Jet Skis & Jets Boats by Cutter Marine		 928 329-9611
Outdoor Sports of Prescott Valley
9100 E Valley Rd. Prescott Valley, Arizona 86314
Bayliner, Avanti, Capri, Maxum, Yamaha, Myacht, Regal		 928 772-0575
Outdoor Sports of Page-Lake Powell
861 Vista Ave Page, Arizona 86040
Bayliner, Avanti, Capri, Maxum, Yamaha, Myacht, Regal		 928 645-8141
Primetime Watersports
2170 Rio Grande, Bullhead CIty, Az
CraigCat Rentals and Sales		 928 758-3339
Star Island Motorsports
6550 E. 6th Street, Prescott Valley, AZ 86314
Full line of accessories for PWC's, ATV's, Snowmobiles,
Lawn and Graden Equipment		 928 772-0855
Walts Yamaha-Kawasaki Plus
1551 So. Palo Verde Lake Havasu City, Az.
Yamaha WaveRunners, Kawasaki Jet Ski		 928 855-5019
HAVASU CYCLE & WATERCRAFT
1928 W. ACOMA LN. UNIT C LAKE HAVASU CITY, AZ 86403		 928 - 680 - 6664  

Looking for a little excitement on or off the road. 
mc-link.gif (4435 bytes)
Check out our USAMotorcycle site for great bikes and information.