Find a boat Refine your search here

Nema rezultata.

Select yachts.id as brodident, yachts.charter, yachts.name, yachts.companyid, yachts.locationid, yachts.yachtcategoryid, yachts.yachtmodelname, yachts.yachtbuilderid, yachts.loa, yachts.cabins, yachts.cabinscrew, yachts.berthscabin, yachts.berthssalon, yachts.berthscrew, yachts.berthstotal, yachts.wc, yachts.wccrew, yachts.buildyear, yachts.aktivan, yachts.cijenamin, yachts.popust, yachts.ac, yachts.wifi, charteri.id as charterid, charteri.online, locations.id as locationid, locations.regionid, locations.nameen, locations.nameit, locations.namede, regije.id as regijaid, regije.countryid, builderi.name as buildernaziv from brodovi yachts inner join charteri charteri on yachts.companyid=charteri.id inner join lokacije locations on yachts.locationid=locations.id inner join brod_buileri builderi on yachts.yachtbuilderid=builderi.id left join regije regije on locations.regionid=regije.id where 1 and yachts.aktivan=1 and charteri.online=1 and yachts.cijenamin>0 and regije.countryid = 1 and locations.regionid = '1' and yachts.yachtcategoryid = '5' order by yachts.buildyear desc, yachts.id asc limit 25 offset 0
1. Choose starting date
2. Select cruise duration
2. Select cruise duration