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 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 bjbrake, more information is available at http://www.flickr.com/photos/bjbrake/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 bjbrake, more information is available at http://www.flickr.com/photos/bjbrake/ 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-nd/3.0/  The owner of this picture is traceyakeat, more information is available at http://www.flickr.com/photos/taz_wales/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 traceyakeat, more information is available at http://www.flickr.com/photos/taz_wales/ 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 ScubaBeer, more information is available at http://www.flickr.com/photos/scuba_beer/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 ScubaBeer, more information is available at http://www.flickr.com/photos/scuba_beer/ 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 josephp, more information is available at http://www.flickr.com/photos/sumsinnow/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 josephp, more information is available at http://www.flickr.com/photos/sumsinnow/
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-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 gripso_banana_prune, more information is available at http://www.flickr.com/photos/antonystanley/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 gripso_banana_prune, more information is available at http://www.flickr.com/photos/antonystanley/ 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 unincorporated, more information is available at http://www.flickr.com/photos/unincorporated/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 unincorporated, more information is available at http://www.flickr.com/photos/unincorporated/ 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 My Sweetheart The Drunk, more information is available at http://www.flickr.com/photos/kamerakyriaki/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 My Sweetheart The Drunk, more information is available at http://www.flickr.com/photos/kamerakyriaki/ 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 pixie_bebe, more information is available at http://www.flickr.com/photos/pixie_bebe/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 pixie_bebe, more information is available at http://www.flickr.com/photos/pixie_bebe/

Hotels in L'estartit

Emporda Golf Hotel & Spa Score 8.525 from 133 reviews
Carretera De Palafrugell A Torroella, S/N 8.53/10
There are 5 function rooms that can be combined in a variety of different ways. They are all fitted with the necessary facilities for any type of event, such as cocktail parties, catered receptions, working lunches, coffee breaks, wedding receptions and banquets. The rooms can hold up to 350 people. The 36-hole golf course is divided into 2 routes of 18 holes each: Links, among dunes and ponds in the most pure Scottish style, and Forest, among pines and lakes, with a more Mediterranean look. Advanced and amateur players can choose among different programmes depending on the days. There is also a golf school with introduction courses and lessons for children. ... more
 
Apartamentos Els Salats Score 5.275 from 7 reviews
Garrotxa 20 5.28/10
The interiors are bright and airy with cooling tiled floors and pine furniture. Enjoy cheerful Mediterranean details in the fabrics and perhaps a private balcony. The apartments are composed of a lounge with a double sofa-bed and one double room. There is a well-equipped kitchen one bathroom and a furnished terrace. Apartments for 5 people also have an extra single bed. ... more
 
Sa Punta Score 8.45 from 35 reviews
Urbanización Sa Punta 8.45/10
The hotel’s wellness facilities include a small spa centre, sauna and fitness equipment. ... more
 
Hotel Aatu Score 7.925 from 2 reviews
Afueras, s/n 7.93/10
Hotel Aatu is a rural hotel with 30,000m² of gardens and 2 outdoor swimming pools. It is set in the Medieval village of Peratallada, a 15-minute drive from the Costa Brava. This small hotel has traditional features, including stone walls and wooden beams. Rooms are spacious and bright, with a balcony. They all have a ceiling fan, satellite TV and a seating area. The Aatu Hotel is an ideal base for walking, cycling and golf. The attractive villages of Palafrugell and Begur are just a short drive away. The hotel offers free private parking on site. There is also an transfer service from Girona Airport, just 45km away. The hotel has a restaurant, serving typical local cuisine. There is also a bar and lounges. Free internet access is available in public areas. The Aatu's reception offers a tour desk and shiatsu massage service. ... more
 
Hotel Marisqueria Cal Tet Score 8.75 from 84 reviews
Santa Anna, 38 8.75/10
The dining room has been reformed and given a modern touch while conserving its antique stone wall structure that creates a homely atmosphere. It also functions as a good meeting point and a place to taste some seafood tapas within a relaxed, professional and upbeat atmosphere. ... more
 
More hotels in L'estartit

Granada Airport Private Arrival Transfer 30 minutes

Granada Airport Private Arrival Transfer

Travel from Granada Airport to your Granada city hotel. Transfer services are available 24 hours a day, 7 days a week. This is a private transfer service so the price remains the same for:

  • 1 - 3 people
  • 4 - 6 people
  • 7 people

When making a booking, you will need to advise your flight details and your Granada city hotel details. Your transfer will be confirmed within 24 hours, subject to availability. Upon confirmation you will be provided with a travel voucher to present to the driver.

It's that easy!

Don't forget to book your Granada Airport Departure Transfer, simply type the product code 3443GRXHTLAPT 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


Catalan Festivals and Culture: Summer Human Castle Festival 8.5 hours

Catalan Festivals and Culture: Summer Human Castle Festival

Head inland to a medieval town, famous for the wine and cava industry. While the surrounding vineyards create the impression of a dusty sleepy world, the center of this town bursts with vitality. After morning mass, the atmosphere becomes electric and the festival kicks off in full swing. Different folkloric dances, which stem from traditions that are over seven hundred years old, can be seen. The strange but stunning choreography include Giants, Big heads, Eagles, Circle Dancers and Shepherds. Where do these ritual type traditions come from? Come along and find out!

An hour later and the tension in the main town square reaches fever pitch as the Human Castle team congregates in the main square. This town is the heart and soul of this spectacular tradition and the biggest Human Castles are built at this annual festival. A sea of colored shirts steadily forms into an organized huddle of bodies. Slowly but surely, a tower emerges from the hundreds of people beneath. The strain is visible on everybody's face as maximum concentration is used by all to keep the castle stable as it grows up to ten stories high.

You might not be building Human Castles but you will have had time to build up an appetite. Next stop is a traditional Catalan restaurant, specializing in local cuisine. Sample char-grilled meats, bread with tomato and garlic and wine from a glass container with a spout, called a "Purro".

Click here for more information and Booking Details


Palafolls Marineland 8 hours

Palafolls Marineland

Palafolls' Marineland, located between the Costa Brava and the Maresme coast, combines a Dolphinarium with a Marine Zoo and an Aquatic Park. That's two parks in one, great for the whole family!

The marine zoo section includes a Dolphinarium, which has been one of the most successful in Europe at breeding these wonderful creatures. There are regular dolphin and sea lion shows, as well as others featuring free-flying parrots and birds of prey. In addition, there are several collections of underwater creatures indigenous to the Catalan area.

In the water park there are a wide range of swimming pools and water slides, including the rather scary-sounding Black Hole and Kamikaze. For the smaller kiddies, there's a special Children's Water Park. There are also plenty of open green spaces to relax in. So whether you want to splash around yourself or just leave that to the dolphins, the park is well worth a visit.

Click here for more information and Booking Details


Leisure Pro Gear

Leisure Pro Gear
Leisure Pro Gear