You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'estartit%' and parentlist like '%,5,-1'' at line 1
select parent_cat_name from scuba_diving_cat where cat_name like 'L'estartit%' and parentlist like '%,5,-1'
 scubish.com: Scuba diving L'estartit - Spain - Europe


L'estartit


This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-sa/3.0/  The owner of this picture is corvettediver, more information is available at http://www.flickr.com/photos/70349997@N00/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-sa/3.0/  The owner of this picture is corvettediver, more information is available at http://www.flickr.com/photos/70349997@N00/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is Tigerzeye, more information is available at http://www.flickr.com/photos/tigerzeye/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is Tigerzeye, more information is available at http://www.flickr.com/photos/tigerzeye/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-nd/3.0/  The owner of this picture is yangwave, more information is available at http://www.flickr.com/photos/apt8/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-nd/3.0/  The owner of this picture is yangwave, more information is available at http://www.flickr.com/photos/apt8/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-sa/3.0/  The owner of this picture is corvettediver, more information is available at http://www.flickr.com/photos/70349997@N00/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-sa/3.0/  The owner of this picture is corvettediver, more information is available at http://www.flickr.com/photos/70349997@N00/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is zophos, more information is available at http://www.flickr.com/photos/zophos/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is zophos, more information is available at http://www.flickr.com/photos/zophos/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is eddythesasquatch, more information is available at http://www.flickr.com/photos/sasquatch_eds/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is eddythesasquatch, more information is available at http://www.flickr.com/photos/sasquatch_eds/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is eddythesasquatch, more information is available at http://www.flickr.com/photos/sasquatch_eds/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is eddythesasquatch, more information is available at http://www.flickr.com/photos/sasquatch_eds/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is noelweathers, more information is available at http://www.flickr.com/photos/77454909@N00/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is noelweathers, more information is available at http://www.flickr.com/photos/77454909@N00/
This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-sa/3.0/  The owner of this picture is Velo Steve, more information is available at http://www.flickr.com/photos/juniorvelo/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by-sa/3.0/  The owner of this picture is Velo Steve, more information is available at http://www.flickr.com/photos/juniorvelo/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is Gaetan Lee, more information is available at http://www.flickr.com/photos/gaetanlee/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is Gaetan Lee, more information is available at http://www.flickr.com/photos/gaetanlee/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is noelweathers, more information is available at http://www.flickr.com/photos/77454909@N00/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is noelweathers, more information is available at http://www.flickr.com/photos/77454909@N00/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is laszlo-photo, more information is available at http://www.flickr.com/photos/laszlo-photo/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is laszlo-photo, more information is available at http://www.flickr.com/photos/laszlo-photo/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is noelweathers, more information is available at http://www.flickr.com/photos/77454909@N00/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is noelweathers, more information is available at http://www.flickr.com/photos/77454909@N00/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is dphershman, more information is available at http://www.flickr.com/photos/hershman/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is dphershman, more information is available at http://www.flickr.com/photos/hershman/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is noelweathers, more information is available at http://www.flickr.com/photos/77454909@N00/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is noelweathers, more information is available at http://www.flickr.com/photos/77454909@N00/ This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is eddythesasquatch, more information is available at http://www.flickr.com/photos/sasquatch_eds/This picture is licensed under the Creative Commons License (http://creativecommons.org/). Type of license:http://creativecommons.org/licenses/by/3.0/  The owner of this picture is eddythesasquatch, more information is available at http://www.flickr.com/photos/sasquatch_eds/

Hotels in L'estartit

Hotel President Score 7.9 from 25 reviews
Avinguda Salvador Dalí, 82 7.9/10
This well-equipped hotel is only 500 metres from the famous Dalí Museum in Figueres. The Hotel President offers free Wi-Fi in public areas. All rooms at the hotel are air conditioned and soundproofed. They have an en suite bathroom with amenities. There is also a minibar, TV and work desk. The President also offers non-smoking and family rooms. The hotel has a nice terrace. There is also a restaurant and a bar on site. 24-hour reception is available. ... more
 
Tropic Score 6.25 from 6 reviews
De La Gola, 16 6.25/10
After soaking up the sunshine, cool off in the pool or with a refreshing drink from the bar. ... more
 
Terramar Score 8.325 from 59 reviews
Passeig Cipsela, 1 8.33/10
The hotel comes equipped with a small fitness centre and a solarium. In the hotel lobby you will find an internet point where you can access the web (surcharges apply). ... more
 
Hotel & Spa Cala del Pí Score 9.075 from 178 reviews
Avenida Cavall Bernat 160 9.08/10
This luxurious hotel is located right on the beach and has a fantastic spa and aqua-zone. Enjoy meals in the à la carte restaurant with a great wine selection. Wake up to splendid views from the private balcony of your bedroom in the Hotel & Spa Cala del Pí. After a morning dip in the Mediterranean you can enjoy a wholesome breakfast. Spend your holiday taking advantage of the Hotel & Spa Cala del Pís wonderful facilities. You can enjoy a swim in the outdoor pool after soaking up the glorious sunshine on the poolside loungers. Then head inside for a session in the spa where you will find a sauna and steam room. Treat yourself to a relaxing massage or one of many beauty treatments. ... more
 
Hotel Ramblamar Score 7.775 from 262 reviews
Avenida de Rhode, 153 7.78/10
In addition to the facilities already mentioned, this hotel has free Wi-Fi internet connection. ... more
 
More hotels in L'estartit

Fuerteventura's Family Adventure Cruise to Los Lobos 3 - 5 hours

Fuerteventura's Family Adventure Cruise to Los Lobos

After being met at your hotel or meeting point, you will be transferred to the harbor in Corralejo where you will board the Catamaran.

While sailing you can help the crew with the sailing or have a go at being the captain at the helm and steer the boat.

The boat will anchor off the desert island of Los Lobos, just off the north-east tip of Fuerteventura). At this point, steps are lowered into the water for you to be able to get in and out to swim. There is snorkeling equipment provided for all ages/sizes and a spin around the bay on a jet-ski is included.

Lunch is served while you are anchored at Los Lobos. This consists of pasta with a tomato and tuna sauce (tomato and vegetable for those who don't like tuna) cheese, bread and butter and salad.

Throughout the sailing there is a free bar and drinks are unlimited. The drinks available on board are red, white and rose wines, beer, coca cola, diet coke, fanta orange, fanta lemon, sprite, still water and sparkling water.

Once it's time to set sail back to Fuerteventura, again, you may join in and help the crew or just sit back, relax and let the crew bring drinks to you. On arrival back in Fuerteventura, you will be transferred back to your hotel.

This particular boat has been featured on Wish You Were Here, GMTV, Sky Travel channel and recently featured in OK magazine (Kian from Westlife said it was the only way to travel on the sea).

Click here for more information and Booking Details


Blue Spirit Cruise from Gran Canaria 2 hours

Blue Spirit Cruise from Gran Canaria

After you are collected from your Gran Canaria hotel, you will be transferred to Puerto Rico to board the boat.

Depending on sea and weather conditions, you will sail the Southwestern route along the coast.

There is snorkeling equipment on board for use at the stops during the cruise.

Click here for more information and Booking Details


Full Day Tour to Girona, Figueras and Dali Museum 10 hours

Dali Museum, Figueres

Your first stop is the historical city of Girona. The houses situated at the very edge of the Onyar river and the bridges which span it, are no doubt one of the most authentic and spectacular sights of Girona.

While here, you will visit the impressive Cathedral whose location has been a place of worship since the Roman occupation. It was founded in 1038, however most of the present building dates from the 14th and 15th centuries, therefore it is the result of various superimposed styles; Romantic and Gothic. The interior contains numerous works of art, Gothic tombs and baroque altar paintings. The renowned Tapestry of the Creation (11th Century), The Beatus (10th Century) and a rich collection of medieval gold and silver works are exhibited in the Capitular Museum. The steep narrow street housed the Jewish community of Girona in medieval times.

Explore the Arabian baths, Roman building inspired by the Roman public baths with three rooms, each with a different temperature of water in their swimming pools. In spite of the presence of elements of Muslim origin, the construction corresponds to Romanesque.

After your visit you will continue to Figueres, hometown of Salvador Dali. Lunch is followed by a visit to the Dali Museum, which houses one of the largest collections of Dali's work in the world. The building itself can be considered a work of art.

Click here for more information and Booking Details


Leisure Pro Gear

Leisure Pro Gear
Leisure Pro Gear