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-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 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 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 D'Arcy Norman, more information is available at http://www.flickr.com/photos/dnorman/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 D'Arcy Norman, more information is available at http://www.flickr.com/photos/dnorman/ 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 chrisbernardi, more information is available at http://www.flickr.com/photos/chrisbernardi/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 chrisbernardi, more information is available at http://www.flickr.com/photos/chrisbernardi/ 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 hemflock, more information is available at http://www.flickr.com/photos/hemflock/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 hemflock, more information is available at http://www.flickr.com/photos/hemflock/ 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 Charmaine Tham, more information is available at http://www.flickr.com/photos/charmainetham/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 Charmaine Tham, more information is available at http://www.flickr.com/photos/charmainetham/ 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 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/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-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 ruhel, more information is available at http://www.flickr.com/photos/ruhel/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 ruhel, more information is available at http://www.flickr.com/photos/ruhel/

Hotels in L'estartit

Mas Roig Score 8.7 from 9 reviews
Ctra De Pals A Torroella De Montgrí 8.7/10
The hotel has 9 rooms with capacity just for two people. ... more
 
Hotel Flamingo Score 7.475 from 105 reviews
Esglèsia 112 7.48/10
The Hotel Flamingo is a welcoming hotel with a family atmosphere. It is situated 300 mts from the beach and very close to the shopping centre. It is located conveniently for diving activities because in L'Estartit you have the natural reserve- The Medas Islands. Also within a few km there are 3 Golf Courses. The hotel bedrooms are ensuite, aire conditioned, with balcony, telephone and TV. The hotel also have a lift, parking, 2 bars, out door pool with solarium. ... more
 
Aiguaclara Score 9.375 from 43 reviews
Sant Miquel, 2 9.38/10
This colonial mansion was built by Buenaventura Caner Bataller in 1866 on his return from Cuba, where he emigrated to in search of fortune. The house has been restored keeping the original layout and features. The rooms have been decorated with antiques and furniture has been restored by the owners themselves. ... 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
 
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

Gerona (Girona) Airport to Costa Brava Shared Arrival Transfer 45 - 60 minutes

Gerona (Girona) Airport to Costa Brava Shared Arrival Transfer

Travel from Gerona (Girona) Airport to your Costa Brava Hotel. Transfer services are available 24 hours a day, 7 days a week.

Transfers are available to:

  • Group A - Tossa de Mar, Malgrat de Mar/Santa Susanna or Pineda Calella
  • Group B - Lloret de Mar or Blanes

When making a booking, you will need to advise your flight details and your Costa Brava Hotel details. Your transfer will be confirmed instantaneously and you will be provided with a travel voucher to present to the driver.

It's that easy!

Don't forget to book your Gerona (Girona) Airport Departure Transfer, simply type the product code 3042GROHTLAPTS into the Keyword Box.

At time of booking, YOU MUST include the following flight and hotel details in the "Special Requirements" box:

  • Airline
  • Flight Number
  • Departing City / Arrival City
  • Arrival Time
  • Hotel Name
  • Hotel Address

Click here for more information and Booking Details


Benidorm Palace Show 3 hours

Benidorm Palace Show

Night wears its more glamorous dress in the Benidorm Palace!

Vedette shows, dances, magic and many other different shows will turn the night into a very pleasant and fun time. The legendary song contest of Benidorm has its birthplace here. Many important singers and comedians have performed on this stage, like Montserrat Caballe or Rudolf Nureyev, and singing groups like The Platters, Los Panchos, The Supremes and more.

Benidorm Palace has produced some of the best known shows in Europe, with more than 1,500 seats available for important contests like the election of Miss Espana, the Forum Europeo de las Artes (Arts European Forum) and plenty of conferences and congresses.

Click here for more information and Booking Details


Half Day El Escorial and Valley of the Fallen Tour 5 hours

El Escorial Monastery

To commemorate the battle "San Quintin" and to locate the remains of his dead father The Emperor Charles V, Philip II ordered the construction of El Escorial Monastery, considered as a temple, austere Royal residence and Pantheon for Kings.

The Monastery is a real symbol of Spanish power from the 16th Century. The construction was focussing on sense, symmetry and balance, keeping in all cases the exposure for the Renaissance style. The pictorial and sculptural importance is also great. Your experienced guide will take you for a tour to Austria's Palace, Pantheons of Kings and Infants, Chapters Rooms and Basilica.

Located 6 miles (9.5 kilometers) north of El Escorial lies the Valley of the Fallen, a vast Basilica excavated from the inside of a mountain, on top of which looms a gigantic granite cross standing at 492 feet (150 meters) high. This monument was built by General Franco to remember the dead of Spain's Civil War. The entire complex is surrounded by a landscape of exquisite beauty. Enjoy a guided tour inside the Basilica.

Click here for more information and Booking Details


Leisure Pro Gear

Leisure Pro Gear
Leisure Pro Gear