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 = 'bilocale-in-centro-san-bernardino' AND content.enabled = 1
- - ImmoSwiss.ch
Rent and buy real estate in Swizerland
This website uses profiling cookies to offer you a better experience. By continuing navigation you agree to the use of cookies. For more information and to change your preferences see our cookie policy Authorize
