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/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 ctsnow, more information is available at http://www.flickr.com/photos/ctsnow/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 ctsnow, more information is available at http://www.flickr.com/photos/ctsnow/ 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 acme, more information is available at http://www.flickr.com/photos/acme/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 acme, more information is available at http://www.flickr.com/photos/acme/ 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-nd/3.0/  The owner of this picture is brian.w, more information is available at http://www.flickr.com/photos/method/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 brian.w, more information is available at http://www.flickr.com/photos/method/ 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 olivermccloud, more information is available at http://www.flickr.com/photos/mccloud/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 olivermccloud, more information is available at http://www.flickr.com/photos/mccloud/ 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 toddneville, more information is available at http://www.flickr.com/photos/toddneville/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 toddneville, more information is available at http://www.flickr.com/photos/toddneville/
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-sa/3.0/  The owner of this picture is benhulley, more information is available at http://www.flickr.com/photos/benhulley/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 benhulley, more information is available at http://www.flickr.com/photos/benhulley/ 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 ippei + janine, more information is available at http://www.flickr.com/photos/ippei-janine/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 ippei + janine, more information is available at http://www.flickr.com/photos/ippei-janine/ 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-nd/3.0/  The owner of this picture is Romeocat, more information is available at http://www.flickr.com/photos/romeocat/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 Romeocat, more information is available at http://www.flickr.com/photos/romeocat/ 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/3.0/  The owner of this picture is Jimp79, more information is available at http://www.flickr.com/photos/jimp79/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 Jimp79, more information is available at http://www.flickr.com/photos/jimp79/

Hotels in L'estartit

Hostal Blau Score 8.625 from 4 reviews
Forn, 2 8.63/10
Peratallada still conserves the feudal time aspect, with narrow cobbled streets and the feeling of ancient times. And it's in one of the many streets you will find our place ideal to relax and dream, surrounded by walls full of history. ... more
 
H Top Platja Park Score 6.825 from 170 reviews
Avinguda Strasbourg, 10 6.83/10
Located in the heart of the charming Catalan resort of Platja d’Aro, this family-friendly hotel is just a short walk away from the sandy beaches of the Costa Brava. The H Top Platja Park features a large leisure centre, allowing you to relax by the outdoor swimming pool and soak up the Mediterranean sun. Here you can also get involved in the wide variety of organised activities on offer. Each evening you can head to the spacious, on-site restaurant for a tasty buffet meal. The nearest golden sandy beaches are just 600 metres away from the hotel. Spend your day in the clear waters before exploring the streets of Platja d’Aro – a popular tourist destination with a buzzing nightlife. There are plenty of bars and restaurants to choose from, as well as many designer boutiques and other chic shops. ... more
 
Monterrey Score 7.85 from 51 reviews
Passeig Maritim 72-75 7.85/10
Monterrey has an ideal setting on the seafront of Roses, next to Santa Margarita Beach. It offers a heated outdoor swimming pool, a gym and a sauna. The hotel has a garden and views of Roses Bay. There is a bar and a restaurant, serving Mediterranean food. The hotel offers free Wi-Fi access. Rooms at the Monterrey have a balcony and a fan. They all have satellite TV, and an en suite bathroom with hairdryer. The hotel is set in the centre of Roses. There is good access to the Cap de Creus Natural Park and the popular village of Cadaqués. Girona is 52km away. Parking at the hotel is free from September to June. There is also free public parking nearby. ... more
 
Duran Hotel & Restaurant Score 8.675 from 341 reviews
Lasauca, 5 8.68/10
The hotel has 65 rooms, some of which are equipped for the handicapped. They are all decorated following the latest trends yet the contrasting colours and wooden furniture provide an elegant and relaxing atmosphere. They are modern and fully equipped, including internet access and an impeccable service. The bathrooms are large, functional and stylish. ... more
 
Hotel Picasso Score 7.925 from 44 reviews
Platja De La Gola 7.93/10
Restaurant opening times: Breakfast: 08:30-10:30 Lunch: 13:00-16:00 Dinner: 19:30-22:30 ... more
 
More hotels in L'estartit

Full Day Tour to Avila and Segovia 9 hours

Segovia's Alcazar

The ancient city of Avila, declared "Heritage of Mankind", keeps the oldest and most complete walled environment within its 1.5 mile (2.5 kilometer) circular wall, and has 90 semicircular towers dating back to the 11th century. It was the birthplace of the mystic writer Saint Teresa of Jesus (1515 - 1582) and has been a pilgrimage site ever since.

Stop at the hill of "los Cuatro Postes", where you can admire the best panoramic view of Avila. There is also a visit to the San Vicente Basilic. (Normally the tour would visit the Cathedral of Avila, but this is closed to tourists until October due to the exhibition "Edades del Hombre" being displayed).

Continue on to Segovia to see one of the best monuments left behind by the Romans on the whole of the Iberian Peninsula - Segovia's incredible Aqueduct. Built in the time of Augustus, it has one hundred and eighteen arches and is 10 miles (16 kilometers) in length out of which there are only 2,388 feet (728 meters) visible.

Segovia is also famous for its Alcazar, a beautiful and world famous 11th century Medieval Castle, located over a magnificent rock. Step back in time and imagine the medieval tournaments and heroic knights who once walked where you will. It is also supposed to have inspired the Disney Castle.

You will be captivated by the beautiful view of the Alcazar on your visit to the Church of Vera Cruz. Located on the outskirts of Segovia, separated from the town by the Eresma River, the Church of Vera Cruz was founded by the order of the Templar Knights in the 12th century. The architectural style represents a transition period between Roman and Gothic. Take some time to appreciate its outstanding octagonal floor.

You may wish to taste the flavors of a typical Segovian lunch at Solaire Restaurant. Menu includes castillian soup, white beans and a selection of cold cuts, followed by roasted baby pig and traditional Segovian cake.

Click here for more information and Booking Details


Three Day Barcelona Countryside Mountain Bike Tour - Caldes de Montbui 3 days / 2 nights

Three Day Cycling Barcelona Countryside - Caldes de Montbui

On this 3 day Mountain Bike tour, you will get to see the best of what Barcelona MTB trails have to offer.

The rides are between 3 to 4 hours each and all are done during the morning. In the afternoon you can take advantage of some free time to tour around the nearby villages. Perhaps you would prefer to relax in the Caldes de Montbui hot springs and enjoy one or more of the thermal treatments the spa has to offer.

If you enjoy Mountain Bike touring - this is and experience not to be missed!

Click here for more information and Booking Details


Castle Medieval Dinner and Show 4 hours

Castle Medieval Dinner and Show

Be transported back 400 years and find yourself in a castle during the Middle Ages.

Here you can enjoy a dinner and a dancing show, with the Count and Countess. The dinner consists of an aperitif, vegetable soup, chicken with oven potatoes, pork ribs, country bread, ice cream and wine, orange juice and champagne. As in the Middle Ages there will be no knives and forks, just use your hands and dig in!

As you enjoy dinner; the knights of the castle will be entertaining everybody with their exhibitions of horsemanship, jousting, dueling and hand to hand fighting with swords, shields and maces.

After dinner, dance with a live orchestra and disco music on the patio. During the intermission there will be a spectacular Spanish flamenco ballet.

Click here for more information and Booking Details


Leisure Pro Gear

Leisure Pro Gear
Leisure Pro Gear