Con transporteselect 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
Dejese llevar a los tiempos medievales con los caballeros del reino, luchando entre ellos por la mano de la doncella.
P.V.P. € 49.00
Desde € 47.00
KAYAKS 2HR LOS GIGANTES
from Los Gigantes to the Bay Of El Eco enjoy time out also have a swim and snorkle.
Desde € 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)
Desde € 85.00
Freebird One VIP - 3 Horas
Unase a Freebird One para ver las ballenas y delfines viajando en este catamaran de estilo prestigioso y moderno.
P.V.P. € 47.00
Desde € 40.00
Freebird One - One4U - 3 Horas
Navegue a traves de las aguas azules y profundas del Oceano Atlantico desde Puerto Colon en busca de ballenas y delfines, en este crucero de 3 horas fabuloso.
P.V.P. € 69.00
Desde € 55.00
3hrs Luxury 5star motorised catamaran to see whales and dolphins
P.V.P. € 65.00