construccions@grupsais.net|
» Homes (7/-) |
» Flats (9/-) |
» Local (1/-) |
» Parking (-/-) |
|
» Masias (1/-) |
» Chalets (1/-) |
» New Works (8/-) |
» (-/-) |
|
» (-/-) |
» (-/-) |
» (-/-) |
.jpg&width=250&height=250&quality=90 "PI0038") PASEO DEL MAR PENTHOUSE OCEAN VIEW - PI0038300000 €
Beautiful penthouse overlooking the sea and the promenade in St Feliu, downtown. Has 2 bedrooms, 1 bathroom, living roo... [+info]
|
|||
 TOWN HOUSE FULLY RENOVATED WITH GARAGE - CA0028315000 €
Beautiful house CON4 bedrooms, living room, 2 bathrooms, garage, terrace with barbacoa.Calefacción,, Ideal for living a... [+info]
|
|||
.JPG&width=250&height=250&quality=90 "PI0101") FRONTLINE APARTMENT VIEWS - PI0101316000 €
Apartment in the center of Sant Feliu Murlo the building, comprising two double bedrooms and one suite. Living room wit... [+info]
|
|||
 - CA0061316000 €
|
|||
 OPORTUNITAD VILLAGE HOUSE WITH OPTION TO BUSINESS - CA0019320000 €
Opportunity business sale and retirement housing. Town House of 214m2 on two floors and a small garden. Ground floor d... [+info]
|
.JPG "APARTAMENTO EN PRIMERA LINEA FANTASTICAS VISTAS")
| Powered by Sigsiu.NET | |
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:11' 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:11' 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
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:11' 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