Business space 1.0 vani

L1056 Details

Type: Business space
Floor: N.D.
Property status: New
Share with your friends:  


Back to the list of all properties in this category, or perform a new search.

New search


Comfort and Services

  • Box
  • Lift
  • Cellar
  • Swimming pool
  • Garden
  • Lake View
  • Terrace
  • Boat Place
The following query has failed:

SELECT `id`,`categoria`,`tipologia`,`stato`,`provincia`,`comune`,`riferimento`,`titolo_en`,`descrizione_en`,`mq`,`vani`,`prezzo`,`bagni` FROM `immobili` WHERE `categoria`='locazione' AND `cap` IN (6573,6574,6572,6802,6595,6579,6596,6598,6594,6648,6597,6575,6804,6575,6600,6600,6571,6646,6805,6805,6593,6599,6600,6602,6601,6604,6516,6576,6806,6515) AND `pubblica`='y' AND `id` NOT IN (,1056) ORDER BY `data_inserimento` DESC,`prezzo` ASC LIMIT 4

 due to 

 - MySQL Error Code: 0

We stay in touch...

CHARMINGHOMES is Social! Discover more content on our Social Media.

If you wish more information about this property, please fill out the form on the side (fields marked with * are required) or contact us using the contact details below.

Address: Stabile Orchidea
Via Pian Scairolo, 23
6912 Lugano Pazzallo (TI)
Switzerland (CH)
Telephone: +41 76 4139446 E-mail:

ISending in progress! Please wait...
Thank you for contacting us! We will get back to you as soon as possible!

Attention: The following errors have occurred:

Come and visit Your Charming Estate

Discover our proposals, contact now your CharmingHomes realtor: