construccions@grupsais.net|
» Homes (7/-) |
» Flats (9/-) |
» Local (1/-) |
» Parking (-/-) |
|
» Masias (1/-) |
» Chalets (1/-) |
» New Works (8/-) |
» (-/-) |
|
» (-/-) |
» (-/-) |
» (-/-) |
.JPG&width=250&height=250&quality=90 "PI0042") 139 m2 FLOOR WITH TERRACE AND SEA VIEWS - PI0042250000 €
139m2 floor overlooking the sea. Has 4 bedrooms, three of them dobles.una room with terrace,, two full bathrooms, Kitch... [+info]
|
|||
 NEW BUILDING IN THE CENTER - PI0077251000 €
Composite floor room with access to balcony and kitchen with high quality and fully equipped,, Three double bedrooms wit... [+info]
|
|||
.jpg&width=250&height=250&quality=90 "CA0050") FULL HOUSE TO RENOVATE - CA0050252000 €
To totally reform land area 140m2. Built area 84m2
|
|||
.jpg&width=250&height=250&quality=90 "CA0052") HOUSE TO REFORM IN THE HEART-A-MINUTE BEACH - CA0052260000 €
House to reform of 1863. 140m2 distributed on two floors, with five bedrooms, a bathroom and toilet. Dining room and k... [+info]
|
|||
 FABULOUS APARTMENT COMMUNITY ZONE - PI0069260000 €
55 m2 apartment terraza.Completamente renovated, 2 bedrooms, living room with exit to the terrace, Kitchenette,, bathroo... [+info]
|
.JPG "PISO CON VISTAS AL MAR")
.JPG "CASA PARA REHABILITAR TOTALMENTE")
| 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:20:51' 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:20:51' 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:20:51' 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