Search Results

SELECT b.BoatID FROM boatdetails b JOIN permalinks p ON p.BoatID=b.BoatID WHERE (b.Status='Active' OR b.Status='Sale Pending') AND b.NewUsed='Used' AND b.Make='Quicksilver' AND b.OfficeID<>16450 AND b.CabinNo > -1 AND b.HeadNo > -1 ORDER BY b.Price DESC

Register for our Newsletters