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-sa/3.0/  The owner of this picture is Velo Steve, more information is available at http://www.flickr.com/photos/juniorvelo/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 Velo Steve, more information is available at http://www.flickr.com/photos/juniorvelo/ 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 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 richard ling, more information is available at http://www.flickr.com/photos/rling/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 richard ling, more information is available at http://www.flickr.com/photos/rling/ 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 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 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-sa/3.0/  The owner of this picture is ZacharyTirrell, more information is available at http://www.flickr.com/photos/tirrell/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 ZacharyTirrell, more information is available at http://www.flickr.com/photos/tirrell/
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 fearlessRich, more information is available at http://www.flickr.com/photos/96483949@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 fearlessRich, more information is available at http://www.flickr.com/photos/96483949@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 CharlesLam, more information is available at http://www.flickr.com/photos/kclama/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 CharlesLam, more information is available at http://www.flickr.com/photos/kclama/ 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 scmikeburton, more information is available at http://www.flickr.com/photos/scmikeburton/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 scmikeburton, more information is available at http://www.flickr.com/photos/scmikeburton/ 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 aokettun, more information is available at http://www.flickr.com/photos/aok/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 aokettun, more information is available at http://www.flickr.com/photos/aok/ 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 Gaetan Lee, more information is available at http://www.flickr.com/photos/gaetanlee/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 Gaetan Lee, more information is available at http://www.flickr.com/photos/gaetanlee/ 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/

Hotels in L'estartit

Emporium Score 7.425 from 29 reviews
Santa Clara 31 7.43/10
Emporium is a family-run hotel in the historic centre of Castelló d’Empúries, in Catalonia’s Alt Empordà region. It offers a gourmet restaurant with an award-winning wine cellar. The hotel is just 4km from the beaches of the Costa Brava and Empuriabrava Marina. The area around Castelló is part of the Aiguamolls de l’Empordà Natural Park. There is easy access by road to Girona, with free parking at the hotel. Bedrooms at the Emporium Hotel are bright and comfortable. They all have free Wi-Fi and satellite TV. The hotel also has a relaxing lounge and a café-bar, serving drinks and snacks all day. The hotel’s elegant Empòrium restaurant serves typical regional cuisine. It offers tasting menus and a daily set menu, as well as à la carte dishes. The extensive wine list includes many local wines. ... 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
 
Hotel Canet Score 8.4 from 181 reviews
Plaça Joc de la Pilota, 2 8.4/10
This traditional hotel dates from the early 20th century and offers fantastic views over the beautiful Bay of Roses, in northern Catalonia. Located in the small coastal town of Castelló d'Empúries, the Hotel Canet dates back to 1924 and still retains a historic charm. The outdoor swimming pool lies in the shade of an ancient clock tower of the former convent beside the hotel. Also, in the hotel restaurant you can try traditional Catalan cuisine, served on the terrace or in amongst the arches of the dining room. The surrounding area of the Alt Empordà is one of the most beautiful in all of Catalonia. It boasts secluded cove beaches and impressive small cities such as Figueres and Roses – famous for both their art and cuisine. ... more
 
Hotel Trias Score 8.675 from 74 reviews
Passeig Del Mar s/n 8.68/10
Hotel is geared towards guest's comfort offering great facilities whether for business or leisure travellers. The hotel boasts a well-equipped conference room. Conference room with capacity up to 45 people. We arrange coffee breaks, business meals and company meetings. ... more
 
Aigua Blava Score 8.75 from 154 reviews
Platja De Fornells, s/n 8.75/10
Set on the Mediterranean seafront, this hotel overlooks the beautiful bays of Fornells and Aiguablava – part of Spain’s idyllic Costa Brava coastline. The Hotel Aiguablava’s 85 rooms are spread over several small buildings surrounded by magnificent tropical gardens. Throughout the property you can admire the fantastic views over the crystal-clear waters of the Mediterranean Sea. When not relaxing on the secluded local beaches you can take a dip in the hotel’s outdoor swimming pool or sunbathe on the sun loungers. There is also a tennis court and children’s play area for more active pastimes. At the hotel restaurant you can try some of the local specialities whilst taking in the panoramic views of the sea, coves, beaches and forests. You can even choose to dine on the green lawns which surround the hotel. ... more
 
More hotels in L'estartit

Cadiz City Hop On Hop Off Tour 24 Hours

Cadiz City Hop On Hop Off Tour

Once a launching point for ships sailing to the New World, the 3,000 year old City of Cadiz is now famous for the picturesque, Moorish charm of its old central quarter. Your open-top double-decker bus provides convenient stops for the beautiful Cathedral, the Central quarter enclosed within the City walls and the bay area.

You can hop on and off as many times as you like aboard this open-top double-decker bus. There are 9 stops in total, and the entire route takes approximately 1 hour and 15 minutes. The bus departs every 30 minutes from each stop. Tickets are valid for 24 hours from first use.

Click here for more information and Booking Details


Seville to Malaga Private Transfer Varies

Seville to Malaga Private Transfer

Travel from Seville to Malaga. Transfer services are available 24 hours a day, 7 days a week. This is a private transfer so the price is the same for groups of:

  • 1 to 4 people
  • 5 to 7 people

When making a booking, you will need to advise your pick up and drop off 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!

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

  • Departure Address
  • Drop-off Address
  • Departure Time

Click here for more information and Booking Details


Ronda and Tajo Gorge 10 hours

View of Tajo Gorge from the beautiful town of Ronda

Ronda is situated on top of a plateau which is divided in two by a plunging river gorge known as El Tajo. A bridge built in the 18th century spans the width of the gorge, joining the two sides.

On arrival enjoy a sightseeing tour of this beautiful Andalucian town of Celtic origin, with the Cathedral (Roman, Arabic and Gothic styles), the Old Quarter, the Bull Ring (oldest one in Spain) and of course, the magnificent Tajo Gorge.

Enjoy lunch at a local restaurant (not included), and some free time before returning to your hotel with a short stop at the fashionable marina of Puerto Banus.

Click here for more information and Booking Details


Leisure Pro Gear

Leisure Pro Gear
Leisure Pro Gear