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
 
 
WORLD EUROPE SPAIN L'ESTARTIT

L'estartit


Diveshops in 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 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 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-nd/3.0/  The owner of this picture is joseph_valentino, more information is available at http://www.flickr.com/photos/7875/ 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 jorgempf, more information is available at http://www.flickr.com/photos/jorgempf/
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-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 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
Ronda Score 7.9 from 79 reviews
Avenida Salvador Dalí,17 7.9/10
The hotel offers a ample and private car park as well as a secure indoor garage. ... more
 
Sant Roc Score 8.65 from 19 reviews
Plaça de l'Atlàntic 8.65/10
This quiet family hotel has a wonderful terrace and a steep garden with many trees, offering a view over Calella de Palafrugell and its coves. There is also a meeting room available. ... more
 
Apartamentos Illa Mar d'Or Score 7.325 from 3 reviews
Les Deveses 7.33/10
All flats are fully furnished and equipped, and will be clean and in perfect conditions for your arrival. Room rate includes use of water, electricity and gas, bed linen and weekly change. The apartments may be occupied from 17:00 to 19:00 on day of arrival and left before 10:00 on day of departure. Damage deposit: EUR 200 (or the equivalent in foreign currency) is payable on arrival and refundable at the end of your stay, once the property has been checked by the agency staff. Torrent Api will not reserve the property for more than 48 hours after the expected day of arrival, unless the delay has been expressly notified before hand, with the understanding that this will not produce any reduction on the stipulated rental fee. The photographs shown are representative of a kind of accommodation. Interior decoration may vary. ... more
 
Mas Ses Vinyes Score 8.95 from 33 reviews
Ctra Palafrugell a Begur, Km 5.7 8.95/10
During your stay you can spend some time in the drawing room with TV or in the garden. There is a swimming pool on site as well as private parking. ... more
 
Arcs De Monells Score 7.65 from 14 reviews
Vilanova, 1 7.65/10
The hotel is one of the most symbolic buildings in this small village as it was originally a hospital founded in 1364. The outbuildings of this Catalan building have all been lovingly restored and renovated into exclusive rooms, each one dedicated to Catalan historical figures such as Salvador Dalí and retain much of the original allure. The accommodation is comfortable, modern and well equipped with lots of character, set in a picturesque countryside environment, together with good food makes the hotel a great choice for a relaxing stay. There is communal lounge with TV, library and an Internet corner. As well as a Café, bar and swimming pool and parking, all of which are set in 3 acres of garden. ... more
 
More hotels in L'estartit

Madrid Vision Hop On Hop Off Bus Tour 1 or 2 days

Madrid Vision Hop On Hop Off Bus

Get a unique view of Madrid aboard this open-top double-decker bus. There are 2 tours covering all of the city's highlights, from historical sites and monuments to the modern Madrid of skyscrapers and cosmopolitan architecture. The tour enables complete flexibility to hop on and off as many times as you like aboard this open-top double-decker bus. This is a fantastic way to see all of the major sights Madrid has to offer the visitor.

Your Madrid Vision Hop On Hop Off Bus Ticket

  • Anatomical seats
  • Open-top buses for an incomparable view
  • Adapted for passengers with reduced mobility
  • Multi-language audio-guides: Spanish, English, French, German, Italian, Japanese, Portuguese and Russian
  • Environmental commitment: Diesel Euro III engines (EURO 3 standard on particle emissions) and 100% recyclable aluminum bodywork

Route 1 - Historical Madrid (75 minutes)
Philip III and Philip IV enlarged and embellished the city but the Bourbons brought new cultural and architectural tastes. It is to them Madrid owes the spectacular Royal Palace, the Paseo del Prado and the Puerta de Alcal?. A drive down the Gran V?a, the capital's most important road during the first half of the last century, gives us an insight into its unique architectural diversity and outstanding examples of the Belle Epoque, such as the Casino de Madrid and the Palace Hotel.

Route 2 - Modern Madrid (75 minutes)
The 19th century saw Madrid expand. The Salamanca neighborhood was built, a residential area and the site of the first bourgeois homes. The Paseo de la Castellana was developed, where the city's palatial mansions give way to modern skyscrapers of great architectural value, and which are a testament to Madrid's position as one of Europe's most cosmopolitan, attractive and modern cities.

Click here for more information and Booking Details


Barcelona Port Private Arrival Transfer 30 minutes

Barcelona Port Private Departure Transfer

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

  • 1 - 3 in a private car
  • 4 - 6 in a private minivan

When making a booking, you will need to advise your flight details and your Barcelona 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 Barcelona Port Departure Transfer, simply type the product code 2140BCNHTLPRT into the Keyword Box.

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



La Siesta Dinner and Show 4 hours

La Siesta Dinner and Show

La Siesta is an old Catalan Farmhouse dating back to the 17th century which was originally called "Mas de Dalt". It is built of stones from the surrounding areas which gives the exterior a spectacular appearance.

Upon arrival you will be served appetizers and sangria in the outdoor garden. Once inside, enjoy the typical supper consisting on salad, grilled meat served with wine and soft drinks.

The main room is a dinning room which holds 850 people and was built in the same style as the farm house. Its original decoration in wood and stone gives it a warm friendly atmosphere.

As you admire the spectacular show "Spain Ole" enjoy dessert with sparkling wine. The dinner concludes with "Cremat Català", the typical drink of the Costa Brava's fishermen (hot rum with coffee beans and lemon peel).

Next you can enjoy the new show, which combines the best of the Spanish tradition with spectacular new tendencies and technology. The result is a beautiful show of great quality ideal for an unforgettable evening. Top off a fun night by joining in with the dancing to traditional Spanish music.

Click here for more information and Booking Details






Submit a link |
Errors? Mistakes?
contact us

Missing a feature?
Please let us know in our Feedback forum



Tell a friend:

ADD TO DEL.ICIO.US   ADD TO DIGG   ADD TO FURL   ADD TO REDDIT   ADD TO STUMBLEUPON   ADD TO TECHNORATI FAVORITES   ADD TO WINDOWS LIVE   ADD TO YAHOO MYWEB   ADD TO GOOGLE






(c)2007 Scubish Inc | All Rights Reserved | Terms and Conditions | Copyright Notices