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 (girona)%' and parentlist like '%,5,-1'' at line 1
select parent_cat_name from scuba_diving_cat where cat_name like 'L'estartit (girona)%' and parentlist like '%,5,-1'
scubish.com: Scuba diving L'estartit (girona) - Spain - Europe


L'estartit (girona)


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 carnikke, more information is available at http://www.flickr.com/photos/carnikke/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 carnikke, more information is available at http://www.flickr.com/photos/carnikke/ 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-sa/3.0/  The owner of this picture is chicatan, more information is available at http://www.flickr.com/photos/chicatan/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 chicatan, more information is available at http://www.flickr.com/photos/chicatan/ 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 chicatan, more information is available at http://www.flickr.com/photos/chicatan/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 chicatan, more information is available at http://www.flickr.com/photos/chicatan/ 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 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 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 Aaron P, more information is available at http://www.flickr.com/photos/pratts/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 Aaron P, more information is available at http://www.flickr.com/photos/pratts/
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/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-sa/3.0/  The owner of this picture is Merelymel13, more information is available at http://www.flickr.com/photos/merelymel/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 Merelymel13, more information is available at http://www.flickr.com/photos/merelymel/ 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 Kevin Pelletier, more information is available at http://www.flickr.com/photos/metali/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 Kevin Pelletier, more information is available at http://www.flickr.com/photos/metali/ 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 Serge Melki, more information is available at http://www.flickr.com/photos/sergemelki/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 Serge Melki, more information is available at http://www.flickr.com/photos/sergemelki/ 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 chicatan, more information is available at http://www.flickr.com/photos/chicatan/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 chicatan, more information is available at http://www.flickr.com/photos/chicatan/

Hotels in L'estartit (girona)

Apartamentos Mestral Score 8.675 from 23 reviews
Enric Serra 8.68/10
Mestral’s apartments all measure approximately 60 m² and sleep between 4 and 6 people. Each comes with 2 bedrooms, bathroom, lounge-diner and a living area with sofa bed. The kitchen comes with glass ceramic worktops, an oven, washer-dryer, dishwasher, microwave and refrigerator. The rates include the cost of water, electricity and gas, as well as bed linen (changed weekly). Heaters are available for an extra fee of EUR 50 per week. Please note that the photographs shown are representative of the kind of accommodation offered. Interior decoration may vary. ... more
 
Xaloc Score 7.4 from 9 reviews
Cala Rovira, 9 7.4/10
An in-room safe is available for a daily surcharge or a weekly deposit. Those guests wishing to add an extra bed should contact the hotel directly using the Comments box when booking. ... more
 
Les Illes Score 7.05 from 38 reviews
Illes, 55 7.05/10
This hotel is especially designed for scuba divers, offering: • A special room to wash, dry and store the equipment, charge batteries and carry out small reparations. Showers and toilet present. • Screening of diving videos. • Subscription to specialized diving magazines. • Free equipment transportation service to the boat. • A meeting/convention room. ... more
 
Hotel Bulevard Score 7.325 from 107 reviews
Avenida S'Agaró, 14 7.33/10
Ideal for enjoying the beaches of the Costa Brava, this modern hotel is located in the heart of the lively resort of Platja d’Aro. The Bulevard is surrounded by the shops, bars, clubs and restaurants of this Catalan seaside town. This setting, combined with the hotel’s location just 50 metres from the sandy beach, makes this property ideal for a fun and sun-filled holiday beside the Mediterranean Sea. Air-conditioned guestrooms come with en-suite bathrooms, TVs and safes, providing a comfortable base for your relaxing beach holiday. ... more
 
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
 
More hotels in L'estartit (girona)

Madrid Tapas Evening Walking Tour 4 hours

Tantalize the taste buds with traditional Spanish Tapas in Madrid

Combine an introduction to the real Madrileno lifestyle with traditional Spanish food and drink. The aim is to leave you with a lasting feeling for the city and its people, whilst feasting on fabulous food and drink. Visit four traditional bars/restaurants to try authentic Spanish delicacies, which may include chorizo in cider, octopus from Galicia, cider from Asturias, sherry from Andalucia and other regional specialties.

You will be taken to some of the hidden corners of central Madrid to sample traditional Spanish food and drink. Amongst authentic settings your guide will explain the tradition of the food and wine whilst advising on local specialties. Along the way they will also assist with the language and translation , while providing interesting local facts about the tradition, history and myths of Madrid. Who better to give advice on the local sights, than those who live and breathe magnificent Madrid each and every day.

At the first bar visited, your tour includes the first drink and Tapas. After that you can decide if you want to splash out or not and can choose what you eat and drink at all other bars/restaurants visited throughout the evening.

Click here for more information and Booking Details


Island Circle Tour 7 hours

Island Circle Tour

This tour starts in the north of Trinidad and proceeds southwards along the West coast, alluring you to the spectacular scenery of the Gulf of Paris.

Continuing via the Central Plains and Point-a-Pierre, you will visit San Fernando, the second largest city of Trinidad and the commercial hub of the Southland.

The journey then takes you eastward, into areas overlooking the lush coconut palms which fringe the 14 mile Mayaro Beach. On the return, travel through Manzanilla, Cocoa Plantations and Virgin Forest all on the East Coast of the island.

Along the East-West corridor your journey will conclude with some magnificent views of the rural villages below.

Click here for more information and Booking Details


Grand Tour of Lanzarote with Wine Tasting at La Geria 8 - 9 hours

Grand Tour of Lanzarote with Wine Tasting at La Geria

Travel towards the south of the island, passing through Uga, where you will visit the Mountains of Fire, and experience a camel ride (optional, not included in tour price). Continue to Timanfaya National Park to see geothermal demonstrations and the Volcano Route.

You will then continue to the south of the island to admire La Costa de la Lava with panoramic views of the Janubio salt mines and Los Hervideros. Along the way there will be a stop for lunch.

After lunch, you will cross Lanzarote's most important vine-growing region, La Geria, where you will visit a typical cellar and join a wine tasting session. You then continue towards the north, passing through Teguise which was once the island's capital, Los Valles and Haria with a view of the Valley of the Thousand Palm Trees.

You will visit Los Jameos del Agua, before returning via Guatiza.

Click here for more information and Booking Details