SELECT content.*, (SELECT filename FROM images WHERE images.record_num = content.thumbnail) AS thumbfile , `content_languages`.`title` AS langTitle, `content_languages`.`slug` AS langSlug, `content_languages`.`description` AS langDescription, `content_languages`.`teaser` AS langTeaser, `content_languages`.`embed` AS langEmbed, `content_languages`.`site_url` AS langSiteUrl FROM content LEFT JOIN `content_languages` ON `content_languages`.`content` = `content`.`record_num` WHERE `content_languages`.slug = 'casa_nucleo20' AND content.enabled = 1 - - ImmoSwiss.ch
Diese Website verwendet Profiling-Cookies, um dich ein besseres Erlebnis zu bieten        Ermächtigen
 
»   
»   
»   

- -
Kode:
Verkaufspreis
Typ
Zimmer
Oberfläche
Price on application
0
m2
Telefonnummer
Jetzt anzeigen!
Kontaktiere den Werbetreibenden
Privater Benützer
Senden!

Informationen:
Vertrag
Monatliche Miete Price on application
Datumsanzeige