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='Jeanneau' AND b.CabinNo > -1 AND b.HeadNo > -1 ORDER BY b.Price DESC
Login
You must register or login to save your favourites
