Spanish Catalan English French German Italian Russian
Josep Sais S.L.
E-mail: construccions@grupsais.net
Tlf. 972 32 82 70

» Homes (7/-)

» Flats (9/-)

» Local (1/-)

» Parking (-/-)

» Masias (1/-)

» Chalets (1/-)

» New Works (8/-)

»  (-/-)

»  (-/-)

»  (-/-)

»  (-/-)

 
 Disponemos de más de 174 inmuebles... ...
RSS Feeds

TE0001

LAND DEVELOPMENT - TE0001

150000 €
Building plot of 1300m2
0Comentarios: 0

VERY WELL LOCATED ATTIC - PI0090

150000 €
Penthouse with three bedrooms, two bathrooms, one with bath, large dining room with access to balcony with good views, l... [+info]
0Comentarios: 0

CA0060

- CA0060

150000 €
0Comentarios: 0

GROUND FLOOR OPPORTUNITY WITH OUTPUT - PI0105

155000 €
Ground floor 85m2 living room with fireplace and balcony, kitchen with terrace of 25m2, three bedrooms, bathroom. Alumi... [+info]
0Comentarios: 0

BEAUTIFUL APARTMENT WITH TERRACE - PI0106

158000 €
80m2 apartment with large living room with fireplace. Very modern kitchen, bathroom and two double bedrooms with fitted... [+info]
0Comentarios: 0
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>
Powered by Sigsiu.NET RSS Feeds

Featured properties

No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY RAND() LIMIT 10' at line 3 SQL=SELECT item.`itemid`, item.`title`, item.`icon`, item.`image`, item.`hits`, item.`last_update`, cf_itemid.`itemid` FROM `jos_sobi2_fields_data` AS cf_itemid, `jos_sobi2_item` AS item WHERE cf_itemid.`fieldid`='40' AND cf_itemid.`data_txt` LIKE '%' AND item.`itemid`=cf_itemid.`itemid` AND (item.`published`='1' AND item.`approved`='1' AND (item.`publish_down`>'12-05-21 12:19:44' OR item.`publish_down`='0000-00-00 00:00:00')) AND item.itemid IN (SELECT scir.itemid from jos_sobi2_cat_items_relations as scir WHERE catid = ) ORDER BY RAND() LIMIT 10

Warning: Database Error 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY RAND() LIMIT 10' at line 3 SQL=SELECT item.`itemid`, item.`title`, item.`icon`, item.`image`, item.`hits`, item.`last_update`, cf_itemid.`itemid` FROM `jos_sobi2_fields_data` AS cf_itemid, `jos_sobi2_item` AS item WHERE cf_itemid.`fieldid`='40' AND cf_itemid.`data_txt` LIKE '%' AND item.`itemid`=cf_itemid.`itemid` AND (item.`published`='1' AND item.`approved`='1' AND (item.`publish_down`>'12-05-21 12:19:44' OR item.`publish_down`='0000-00-00 00:00:00')) AND item.itemid IN (SELECT scir.itemid from jos_sobi2_cat_items_relations as scir WHERE catid = ) ORDER BY RAND() LIMIT 10 in /var/www/grupsais.net/datos/web/modules/mod_sobi2simplefeatured/helper.php on line 450

PROPERTY PORTFOLIO Menu