With Transportselect distinct(main_price_attribute_id) from product_price_attributes where product_id='80' 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
Let us take you back to the medieval times with the knights of the realm on horseback, jousting for the hand of the fair maiden.
RRP Price € 49.00
Price From € 47.00
KAYAKS 2HR LOS GIGANTES
from Los Gigantes to the Bay Of El Eco enjoy time out also have a swim and snorkle.
Price From € 25.00
Teide by Night with Stargazing Experience
Unforgettable experience for everyone, a chance to see beyond the horizon and be part of something great. The Universe is open to you while on the excursion with your team. They will take you up on Mount Teide and show you the night sky like you`ve never seen before. With their professional telescopes and astrophotography equipment you will be able to see the planets of our Solar System, distant galaxies, nebulas, clusters and so much more. Knowledgeable guides will explain the observations to you, tell you amazing stories and facts about our Universe as well as show you how to take breathtaking astro pictures withyour camera and even a cell phone through their telescopes. The evening will start with solar observations and the most magnificent view of the Sunset from Mount Teide, celebrated with a glass of champagne and commemorative photos. A warm Italian meal with red wine and refreshments will then follow before we mover further up Teide to begin the night sky observations. Awarded as the most luxurious excursion by the Luxury Travel Guide, the stargazing Experience covers everything. Direct hotel pickups in 9 seater cars from the South of Tenerife. delicious meal with red wine and refreshment, polar jackets and blankets, tea and coffee are given to keep you warm while making observations, as well as champagne to celebrate your discoveries. Commemorative pictures taken during stargazing will be available for you to download (Free)
Price From € 85.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
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
3hrs Luxury 5star motorised catamaran to see whales and dolphins
RRP Price € 65.00