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-nd/3.0/  The owner of this picture is i121171, more information is available at http://www.flickr.com/photos/iz1crr/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 i121171, more information is available at http://www.flickr.com/photos/iz1crr/ 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 Whinging Pom, more information is available at http://www.flickr.com/photos/ohfuckkit/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 Whinging Pom, more information is available at http://www.flickr.com/photos/ohfuckkit/ 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 jp26, more information is available at http://www.flickr.com/photos/jpreen/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 jp26, more information is available at http://www.flickr.com/photos/jpreen/ 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 Whinging Pom, more information is available at http://www.flickr.com/photos/ohfuckkit/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 Whinging Pom, more information is available at http://www.flickr.com/photos/ohfuckkit/ 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 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 Shek Graham, more information is available at http://www.flickr.com/photos/shekgraham/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 Shek Graham, more information is available at http://www.flickr.com/photos/shekgraham/ 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-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 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 woofiegrrl, more information is available at http://www.flickr.com/photos/meredith/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 woofiegrrl, more information is available at http://www.flickr.com/photos/meredith/ 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-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/

Hotels in L'estartit

La Malcontenta Score 8.75 from 30 reviews
Platja De Castell, 12 8.75/10
In addition to the facilities already mentioned, the hotel has a library and lounge, a bar, meeting room, massage room and a spa. There are also 3 swimming pools where you can enjoy a relaxing dip. The hotel also has bicycles which you can use to explore the local area – the beautiful countryside surrounding the hotel. ... more
 
La Carabela Score 6.175 from 128 reviews
Plaça Catalunya, 2 6.18/10
This holiday hotel is located in the picturesque resort of Roses, only 30 metres from the beach and the beautiful bay. La Carabela boasts a central location in the Catalan resort of Roses, making it ideal for a stay in this beautiful Costa Brava resort. Before heading to the white, sandy beaches you can enjoy breakfast in the hotel, served between 08.00 and 10.30. This restaurant also opens for lunch and dinner, serving an exquisite blend of oriental and continental food. Being set close to the sea, the hotel boasts fantastic views over the whole Bay of Roses. More impressive sights can be seen in nearby Figueres, the birthplace and home city of Salvador Dalí, and the Aiguamolls de l'Empordà natural park. ... more
 
Ancora Score 7.65 from 40 reviews
Josep Pla S/N 7.65/10
The hotel's rooms are fully-equipped and offer maximum comfort. The hotel's modern facilities include a restaurant, swimming pool, tennis court, mini-golf course and bar. ... more
 
San Carlos Score 7.075 from 148 reviews
Solsones 19 7.08/10
The hotel offers free sports facilities such as a heated swimming pool (only in low season), a fitness centre, squash and tennis court, mini-golf, petanque and ping pong. The hotel is declared as a space without smoke. Althought the smokers can smoke in the outdoors, the bar of the swimming pool and on the terrace of the rooms. Sauna and jacuzzi is available at additional cost. The use of the sport facilities is not charged. ... more
 
 Can Muntaner Apartments Score 0 from 0 reviews
Enric Vinckle 15 0/10
These stylish and modern beach apartments house up to 4 people, and are ideally located in the centre of the lovely Catalan seaside town of Palamos, just 150 metres from the beach. Can Muntaner Apartments are well equipped with TVs and kitchen facilities, where you can prepare your own food. From Can Muntaner, you can stroll down to the nearby beach and relax on the fine sands, soaking up the sun and taking cooling dips in the Mediterranean Sea. Guests receive use of a free parking space for the duration of their stay when booking an apartment at Can Muntaner. ... more
 
More hotels in L'estartit

Barcelona Walking Tour - Gothic Quarter and Temple d'August 2 hours

Barcelona Walking Tour - Gothic Quarter and Temple d'August

This Barcelona Walking Tour of the Gothic Quarter and Temple d'August will show you through the streets, squares and old buildings of the city as you will learn about the areas' history and its people.

The remains of the Roman city survive in the Gothic Quarter alongside the city's medieval buildings, witnesses to a splendid past. Barcelona was the capital where the Catalan counts and monarchs held their court for 500 years.

The tour includes visits inside Temple d'August, the best preserved Roman relic in Barcelona. You will also visit The Placa del Rei where you will find the many medieval buildings, including the palantine chapel of Santa Agata.

This is a great way to gain an orientation of the city and become familiar with the lively Gothic Quarter and its many bars, restaurants and shops.

Click here for more information and Booking Details


Full Day Tour to the Monastery of Montserrat 8 - 9 hours

Full Day Tour to the Monastery of Montserrat

Montserrat is a symbol a Catalonia situated in the holy mountain outside Barcelona. This impressive Monastery contains the virgin of Montserrat "la Moreneta" (Black Madonna), the patron saint of Catalonia.

Montserrat boasts natural rock formations rising to a height of 4, 000 feet (1,224 meters). The present day community of Montserrat is made up of a hundred monks who are governed by to the rule of San Benedict (6th century). It was considered the home of the Holy Grail, and today it is a prime cultural and tourist attraction, as well as one of the most important pilgrimage places on the Iberian Peninsula.

An exhibition shows the monks daily activities and the main parts of the monastery, and the audio visual film "Montserrat behind closed doors", the everyday rules and organization of the Benedictine community. The access to the monastery is by zip train, which will offer you a spectacular and unique perspective of the mountain.

Later, visit one of the best known wine cellars in Spain to taste some exquisite wine call "Aromas de Montserrat" made since ancient times by the monks, and Crema Catalana schnapps.

Click here for more information and Booking Details


Full Day Tour to the Monastery of Montserrat 8 - 9 hours

Monserrat, Spain

Montserrat is a symbol a Catalonia situated in the holy mountain outside Barcelona. This impressive Monastery contains the virgin of Montserrat "la Moreneta" (Black Madonna), the patron saint of Catalonia.

Montserrat boasts natural rock formations rising to a height of 4, 000 feet (1,224 meters). The present day community of Montserrat is made up of a hundred monks who are governed by to the rule of San Benedict (6th century). It was considered the home of the Holy Grail, and today it is a prime cultural and tourist attraction, as well as one of the most important pilgrimage places on the Iberian Peninsula.

An exhibition shows the monks daily activities and the main parts of the monastery, and the audio visual film "Montserrat behind closed doors", the everyday rules and organization of the Benedictine community. The access to the monastery is by zip train, which will offer you a spectacular and unique perspective of the mountain.

Later, visit one of the best known wine cellars in Spain to taste some exquisite wine call "Aromas de Montserrat" made since ancient times by the monks, and Crema Catalana schnapps.

Click here for more information and Booking Details


Leisure Pro Gear

Leisure Pro Gear
Leisure Pro Gear