SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,931,2733,2738,22545,22546,22547)
AND
tt1.term_taxonomy_id IN (2391)
) AND (
( wp_postmeta.meta_key = 'premium' AND wp_postmeta.meta_value = '1' )
OR
( wp_postmeta.meta_key = 'premium' AND wp_postmeta.meta_value = '0' )
OR
( wp_postmeta.meta_key = 'premium' AND wp_postmeta.meta_value = '' )
) AND wp_posts.post_type = 'listing' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','listing','popup','acf-field-group','cookielawinfo','g','comarcas' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','listing','popup','acf-field-group','cookielawinfo','g','comarcas' ) ) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value DESC, RAND() DESC LIMIT 0, 10
Share
The Best Recommendations about the Province of Cadiz
We offer you the best recommendations and travel tips on the Province of Cadiz. What to do, what to see, where to eat and where to stay.
If you are on holidays in the province of Cadiz or you live in Cadiz, let us guide you with our best recommendations on activities, places, where to eat and sleep that will make your stay a unique experience.
Located in the city centre of Medina Sidonia (Spain), the Hotel La Vista de Medina offers its customers a unique experience to enjoy their holidays. The 7 suites have been individually designed, taking care of every detail to make your stay as pleasant as possible. All rooms are designed for couples. Even so, some of...
Located in one of the most charming spots of the Port of Sotogrande, Quilla Sotogrande stands out for its Valencian and Alicante-style rice dishes. The high quality of the ingredients will leave you speechless. On its menu we can find an interesting selection of starters where salads, Iberian cured meats, foie gras, anchovies, fried foods and...
Arrozante is a restaurant that presents unique gastronomic offerings in the area, created with the guidance of two renowned chefs and paella experts: Carlos Otaola (Restaurant Otaola, Sevilla) and José Luis Chaparro (Restaurant Casa Chaparro, Valencia), whose restaurants have received prestigious awards. Located in the Barceló Costa Ballena Hotel, it is also known as “La...
The Beach Club Vistahermosa is open every day of the year and changes its opening hours according to the season. Start your day with breakfast on the sand, a little treat worth having any time of the year. Wait until lunch with a tasty bite, tapa or beer while you relax and enjoy your time...
Cortijo El Cartero is one of the most legendary and well-known places in El Palmar, a real paradise on the Cadiz coast. This “multibar” (a current Spanish concept to refer to a multipurpose establishment: Cortijo El Cartero works as a tapas bar, pub and restaurant) is located in an extraordinary spot. You will spend a...
Aguatapá Multibar is located in front of Santa María del Mar Beach. It is a top restaurant with a careful selection of wines and a modern touch in the typical dishes of Cádiz. Undoubtedly, a must on your visit to Cádiz. The establishment has a dining room with high and low tables and a wonderful...
Sajorami Beach is an accommodation in the paradisiacal setting of Zahora Beach and has direct access to the beach. The complex has double rooms, studios, apartments with one and two bedrooms and an exclusive house for 6 people with a terrace on the beach. The rooms have an original and detailed decoration with different styles....
The first thing that catches your eye when going into Venta Pinto is its evolution and history. There are not many restaurants that can boast a history that dates from 400 years back. Originally, it was an inn for travellers, located in an extraordinary spot in La Barca de Vejer de la Frontera. Nowadays, this...
Pub O’Donoghue’s Jerez is an Irish pub with an excellent selection of beers and one of the best gin and tonic in the city. It is also known as Plaza de Canterbury. At Pub O’Donoghue’s Jerez, major sporting events such as Spanish La Liga, Champions League, Premier or 6 Nations are transmitted. Moreover, many events...
Valentín Sancti Petri Hotel-Spa 4* prioritises the comfort of its guests, holiday makers and business people, and satisfy their most demanding expectations. Its location is ideal to enjoy a few relaxing days on Costa de la Luz or to attend events in a paradisiacal setting. It is surrounded by numerous golf courses, shops, restaurants and...
Load more (121 of 131)
More Filter
Sorry! No more filter found for current selections
Cookies are important to you, they influence your browsing experience. We use analytical, personalization and advertising cookies (our own) to make profiles based on browsing habits and show you personalized content. You can consult our Cookies Policy. By clicking on "Accept all ", you consent to all cookies being saved on your device or you can configure or reject their use by clicking on "Settings ". Cookies PolicySettingsAccept all
Privacy & Cookies Policy
Policy Summary
This website uses cookies to improve your experience while browsing. We use cookies that are classified as necessary. These are stored in your browser and are essential for the basic operation of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt out of receiving these cookies, but this choice may affect your browsing experience.