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 = 'for_rent_renovated_apartment_giubiasco' AND content.enabled = 1 - - ImmoSwiss.ch
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
  Home  
 
»   
»   
»   

- -
Code:
Selling price
Type
Rooms
Surface
Price on application
0
m2
Telephone number
Show Now!
Contact the advertiser
Private User
Send!

Informations:
Contract
Monthly rent Price on application
Date ad