construccions@grupsais.net|
» Homes (7/-) |
» Flats (9/-) |
» Local (1/-) |
» Parking (-/-) |
|
» Masias (1/-) |
» Chalets (1/-) |
» New Works (8/-) |
» (-/-) |
|
» (-/-) |
» (-/-) |
» (-/-) |
"THE HACIENDA" - MA00112350000 €
Luxury villa on two floors with sea views. 4 bedrooms one with fireplace, 5 baths, whirlpool, lounge, dining room, dres... [+info]
|
|||
VILLA WITH SEA - MA00062650000 €
New villa in a quiet area. House of 612m2 distributed in living room with fireplace, kitchen, laundry, 4 bedrooms, 3 ba... [+info]
|
|||
HOUSE WITH PANORAMIC VIEWS - CA00713000000 €
1300m2 Plot, 700m2 const sup 7 bedrooms, garage, elevator. Panoramic sea views. Large windows
|
|||
EXCLUSIVE VILLA IN RESIDENTIAL AREA - MA00024200000 €
Vila located in Punta Brava residential area, just 300m from the beach. Restored in 2008 the house has 3 levels. Is co... [+info]
|
|||
BEAUTIFUL HOME IN EXCLUSIVE AREA - CA00744800000 €
Plot with an area of 1252m2 and 600m2 house. Is composed of 5 bedrooms including 4 suites, 1 guest toilet, a dining roo... [+info]
|
| 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:21' 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:21' 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:21' 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