SELECT   wp_xucivjmcoc_posts.*
					 FROM wp_xucivjmcoc_posts  JOIN wp_xucivjmcoc_icl_translations wpml_translations
							ON wp_xucivjmcoc_posts.ID = wpml_translations.element_id
								AND wpml_translations.element_type = CONCAT('post_', wp_xucivjmcoc_posts.post_type) 
					 WHERE 1=1  AND ((wp_xucivjmcoc_posts.post_type = 'immomakler_object' AND (wp_xucivjmcoc_posts.post_status = 'publish'))) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wp_xucivjmcoc_posts.post_type  IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','salient_g_sections','immomakler_object','home_slider','nectar_slider','portfolio','wpcf7_contact_form' )  ) OR wp_xucivjmcoc_posts.post_type  NOT  IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','salient_g_sections','immomakler_object','home_slider','nectar_slider','portfolio','wpcf7_contact_form' )  )
					 GROUP BY wp_xucivjmcoc_posts.ID
					 ORDER BY wp_xucivjmcoc_posts.post_date DESC, wp_xucivjmcoc_posts.ID DESC

Unique dream home in 1130 Vienna

EXCLUSIVE LIVING IN THE VINEYARDS OF PERCHTOLDSDORF

FREE OF COMMISSION! 4 fantastic semi-detached houses in top location – 1220 Vienna

EXCLUSIVE LIVING IN THE VINEYARDS OF PERCHTOLDSDORF

Luxury penthouse with fantastic panoramic views

EXCLUSIVE LIVING IN THE VINEYARDS OF PERCHTOLDSDORF

Excellently located terraced house in Vienna’s sought-after 19th district.

EXCLUSIVE LIVING IN THE VINEYARDS OF PERCHTOLDSDORF

Fantastic attic apartment in an old building in Vienna’s 9th district

EXCLUSIVE LIVING ON THE OUTskirts of Vienna / REIHENHAUS-VILLA 4 / 6 rooms

Exclusive penthouse with great views over Vienna

NEW PRICE**COMMISSION FREE! Exquisite semi-detached house on the Mühlwasser in 1220 Vienna

EXCLUSIVE LIVING ON THE OUTskirts of Vienna / REIHENHAUS-VILLA 3 / 5 rooms

EXCLUSIVE LIVING ON THE OUTskirts of Vienna / REIHENHAUS-VILLA 1 / 5 rooms

EXCLUSIVE LIVING ON THE OUTskirts of Vienna / REIHENHAUS-VILLA 2 / 6 rooms

EXCLUSIVE LIVING ON THE OUTskirts of Vienna / REIHENHAUS-VILLA 5 / 5 rooms

First-class detached houses in 1220 Vienna – your exclusive dream home awaits you