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 (895)
AND
tt1.term_taxonomy_id IN (2290,2292,2294,2296,2298,2300,2302,2304,2306)
) 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 of Culture in Chiclana de la Frontera
Cultural guide to Chiclana de la Frontera (Province of Cadiz, Andalusia). Guided sightseeing tours, shows, tourist guides, cultural tours, cultural trips.
Guide to the cultural events and entertainment in Chiclana de la Frontera, Province of Cádiz. Cultural tours, tourist guides, shows. Explore the best of culture in Chiclana de la Frontera.
Discover The best of Culture in Chiclana de la Frontera
The Church of San Sebastián was built between the end of the 16th century and the beginning of the 17th in Chiclana. Being a period of epidemics, it was consecrated to this saint, popularly considered as protector against them. It has undergone numerous extensions and reforms that have significantly modified its original structure and transformed...
The San Juan Bautista Parish Church, in Chiclana de la Frontera, is a beautiful example of neoclassical style. It was built between 1773 and 1814, according to the projects by Torcuato Cayón and Torcuato Benjumeda. It has been declared Cultural Heritage Asset. Inside, a part of the altarpiece of the old church stand out, designed...
The Hermitage of Santa Ana is one of the most representative buildings in Chiclana. It is visible from the entire region, given its height above the city. It was built in the second half of the 18th century. Inside you will find the statue of Santa Ana y la Virgen Niña, work of the sculptor...
The Church and Convent of Jesus Nazareno is considered the most important Baroque work in Chiclana. It was built in the 17th century, thanks to the contributions of benefactors and to the business trade with America. The Baroque façade made out of Carrara marble stands out. Undoubtedly, it is one of the most beautiful ones...
The Chiclana Museum has an exhibition area composed of ten rooms. These have content related to the history of Chiclana de la Frontera from its first inhabitants to the present day. It also hosts the room of the Legacy of the Foundation of Fernando Quiñones. It is located at the House of the Briones or...
The Church of San Telmo, in neoclassical style, was built at the end of the 18th century on top of an old hermitage. There, the image of the patron saint of Chiclana de la Frontera is venerated. Inside, the altarpieces and some paintings stand out, such as the Inmaculada de Mulato and the image of...
The Torre del Reloj (“Clock Tower”) is one of the most legendary buildings in Chiclana. It is a civil construction of the 18th century, originally part of the old town hall. Popularly known as Arquillo del Reloj, being near the San Juan Bautista Church (which lacks bell towers), it was given a religious use. Built...
The Hermitage of Santo Cristo de La Vera Cruz is the oldest temple in Chiclana. It was built in the second half of the 16th century. The current façade of the chapel reflects the many reforms that it has undergone along its history. The lattice atrium and the huge cross that presides over it stand...
On the small island where the Castle of Sancti Petri is situated, about two kilometres from the coast, the first men who populated Chiclana settled. The fortress was built between the 17th and 19th centuries. This unique place is a cultural and environmental reference in the province. This is so because it is located where...
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.