TBS Boats Penton Hook

+44 (0)1932 570055

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='ISloep' AND b.CabinNo > -1 AND b.HeadNo > -1 ORDER BY b.Price DESC

Receive Stock Updates

Join our Mailing Lists