Catamaranselect distinct(main_price_attribute_id) from product_price_attributes where product_id='369' order by npkExpression #1 of ORDER BY clause is not in SELECT list, references column 'web73_db.product_price_attributes.npk' which is not in SELECT list; this is incompatible with DISTINCT
Abrazo Luxury 3 Hour Sailing
Take a trip on our fantastic luxury sailing catamaran. Holding only twelve people this is the ultimate in luxury sailing! Free pick up from Los Cristianos and Las Americas.
RRP Price € 69.00
Price From € 55.00
Freebird 3 Hour Sailing
Join us on one of our Freebird catamarans in some whale watching and dolphin spotting on Europe's most prestigious, modern style catamarans.
RRP Price € 47.00
Price From € 40.00
Freebird One VIP - 4 1/2Hour Sail
Join Freebird One on this fabulous 4 1/2 hour sail around the west coast of Tenerife to take in the magnificent Los Gigantes cliffs and the picturesque bay of Masca.
RRP Price € 54.00
Price From € 47.00
Bonadea 2 Hour Sail
A fabulous and intimate catamaran sailing. Join us for a 2 hour sail in search of whales and dolphins.
RRP Price € 28.00
Price From € 25.00
Eden 2 Hour Sail
Join us for 2 hours on this luxury catamaran sailing in search of whale and dolphin sightings.
RRP Price € 25.00
Price From € 21.00
Eden 3 Hour Sail
Join us aboard our luxury 50 seater catamaran for a spot of whale and dolphin watching.
RRP Price € 37.00