Fishing Accessories

<% 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, Dealers.Fishing FROM Dealers WHERE ((Dealers.Fishing)=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.

NEW River Cam Check it out today. Live pictures from the Colorado River!
Fishing Accessories

PWC Rental
California, Arizona, Nevada, New Mexico, Texas

PWC Dealers
(personal watercraft)
California, Arizona, Nevada, New Mexico, Texas, Classifieds, PWC Quote

Boat Dealers
California, Arizona, Nevada, New Mexico, Texas, International

Recreation Rivers, Lakes, Ocean, Camping, Tips, Locations, Adventures, Humor. Up to date information on all the hot spots.

U.S.C.G. Auxiliary, Rules, Regulations and Safety Information for Recreational Boaters.

WaterCAM Live video from around the world. See the water before you get there.

Specialty Marine Co. is your source for custom windshields, wire harnesses, splash gurads and more.

<% On Error Resume Next rs.MoveFirst do while Not rs.eof %> <% rs.MoveNext loop%>


	Dealer Description	Brands & Services
"><%=Server.HTMLEncode(rs.Fields("CompanyName").Value)%> <%=Server.HTMLEncode(rs.Fields("PhoneNumber").Value)%> <%=Server.HTMLEncode(rs.Fields("TollFree").Value)%> <%=Server.HTMLEncode(rs.Fields("Address").Value)%> <%=Server.HTMLEncode(rs.Fields("City").Value)%>, <%=Server.HTMLEncode(rs.Fields("State").Value)%>. <%=Server.HTMLEncode(rs.Fields("Zip").Value)%>	<%=Server.HTMLEncode(rs.Fields("Description").Value)%>	<%=Server.HTMLEncode(rs.Fields("Brands").Value)%>

Looking for a little excitement on or off the road. Check out our USAMotorcycle site for great bikes and information.