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) 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 (2294)
) AND (
( wp_postmeta.meta_key = 'premium' AND wp_postmeta.meta_value = '1' )
( wp_postmeta.meta_key = 'premium' AND wp_postmeta.meta_value = '0' )
( 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','listing','acf-field-group','cookielawinfo','g','comarcas' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','listing','acf-field-group','cookielawinfo','g','comarcas' ) ) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value DESC, RAND() DESC LIMIT 0, 10
Iglesia de San Miguel, Plaza Alameda, Villaluenga del Rosario, España
The Church of San Miguel Arcangel is an 18th-century temple built with a Mudejar and Baroque dome plant. It is located in Villaluega del Rosario city centre, next to the Alameda. Inaugurated on November 21, 1733, a document refers to it citing it several centuries before. It is composed of three ships separated by cylindrical...
Iglesia Parroquial de San Jorge, Plaza San Jorge, Alcalá de los Gazules, España
The Main Church of San Jorge, in Alcalá de los Gazules, was built on a Muslim mosque. This current church has a Latin cross plan and was built during the 16th and 18th centuries. The Church is in Gothic style, although most of the altarpieces are baroque. Pieces of great value stand out, such as...
Iglesia de San Miguel, Plaza San Miguel, Jerez de la Frontera, España
The Iglesia de San Miguel (Church of San Miguel in Jerez) is a beautiful temple built during the 15th to the 18th centuries. It contains elements of three architectural styles of each era: Gothic, Renaissance and Baroque. Of the outside, the side portals stand out. These are dedicated to la Immaculada (Evangelic) and San José (Epistle,...
The Church of La Pastora was built to host the archconfraternity of the same name in Cadiz. It has a Greek-cross plan and you can see a marble statue of the Divina Pastora on the façade. The interior altarpiece was built in 1753. It occupies all the chancel, and its large proportions contrast with the...
Parroquia San Francisco de Asis, Calle San Francisco, Arcos de la Frontera, España
The Church of San Francisco, in Arcos de la Frontera, was part of the Franciscan Convent built in the 16th century. It covers the area of the Hermitage of San Antonio. After the confiscation of Mendizabal, only the church remained. We should mention the tile base of the Sevillian School of the fifteenth century, the...
Hospital de Mujeres, Calle Hospital de Mujeres, Cádiz, España
The Hospital de Mujeres and Chapel of Nuestra Señora del Carmen dates from the 18th century. There is an interesting collection of works of art, emphasizing on how the canvas La Visión de San Francisco con el Compañero de Espalda, dated around 1601. It is a work of El Greco, which belonged to the private...
Basílica Menor de Santa María de la Asunción, Plaza del Cabildo, Arcos de la Frontera, España
The Santa María Minor Basilica is the biggest and the main church of Arcos de la Frontera. It was built between the 13th and 14th centuries on the remains of the old Arab Mosque, and it mixes different styles. Outside, the façade is in Gothic-plateresque style and the tower of the side façade is in...
Parroquia Santa María de las Virtudes, Calle Subida de la Iglesia, Villamartin, España
Santa Maria de las Virtudes Parish Church is a beautiful Mudejar temple built in the early 16th century. Its construction began to life shortly after the founding of Villamartin. The funds that the Church preserves are very valuable. We especially highlight the main altarpiece from the 17th century, featuring sculptures by Pedro Roldán. We should...
Plaza Andalucia, 12, Castellar de la Frontera, España
The Santísimo Cristo Almoraima Sanctuary is the main church of the New Town of Castellar. It is located in Plaza de Andalucía, known for its modern architecture, and especially for its bell tower made out of concrete. The interior keeps the venerated statue of the Holy Christ of La Almoraima. This is a carved piece...
Iglesia Colegial del Divino Salvador, Plaza del Salvador, Sevilla, España
Church of El Salvador (literally “Church of the Saviour”) is the second largest Catholic church in Seville (Andalusia, Spain), surpassed only by the Seville Cathedral. Located in Plaza del Salvador, it is considered a Cultural and Historical Heritage of Spain. It is not only its historical and cultural heritage which stands out, but also its...
Privacy & Cookies Policy
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.