SELECT count(id) FROM #__estateagent as o WHERE o.cat=4 AND (
((o.publish_up >= '0000-00-00 00:00:00' AND o.publish_up <= '2024-12-08 00:55:05') AND o.publish_down >= '2024-12-08 00:55:05')
OR ((o.publish_up >= '0000-00-00 00:00:00' AND o.publish_up <= '2024-12-08 00:55:05' ) AND (o.publish_down = '0000-00-00 00:00:00' OR o.publish_down >= '2024-12-08 00:55:05'))
OR (o.publish_up = '0000-00-00 00:00:00' AND o.publish_down = '0000-00-00 00:00:00')
)
AND o.access<=0 AND o.published=1SELECT o.*, c.name AS catname, c.id AS cat_id, t.name as typename, t.id as typeid, o.price AS Value FROM #__estateagent as o LEFT JOIN #__estateagent_categories AS c ON (o.cat = c.id) LEFT JOIN #__estateagent_type AS t ON (o.type = t.id) WHERE o.cat=4 AND (
((o.publish_up >= '0000-00-00 00:00:00' AND o.publish_up <= '2024-12-08 00:55:05') AND o.publish_down >= '2024-12-08 00:55:05')
OR ((o.publish_up >= '0000-00-00 00:00:00' AND o.publish_up <= '2024-12-08 00:55:05' ) AND (o.publish_down = '0000-00-00 00:00:00' OR o.publish_down >= '2024-12-08 00:55:05'))
OR (o.publish_up = '0000-00-00 00:00:00' AND o.publish_down = '0000-00-00 00:00:00')
)
AND o.hot=1 AND o.access<=0 AND o.published=1 ORDER BY value ASC SELECT o.*, c.name AS catname, c.alias AS catalias, c.id AS cat_id, t.name as typename, t.id as typeid, o.price AS Value FROM #__estateagent as o LEFT JOIN #__estateagent_categories AS c ON (o.cat = c.id) LEFT JOIN #__estateagent_type AS t ON (o.type = t.id) WHERE o.cat=4 AND (
((o.publish_up >= '0000-00-00 00:00:00' AND o.publish_up <= '2024-12-08 00:55:05') AND o.publish_down >= '2024-12-08 00:55:05')
OR ((o.publish_up >= '0000-00-00 00:00:00' AND o.publish_up <= '2024-12-08 00:55:05' ) AND (o.publish_down = '0000-00-00 00:00:00' OR o.publish_down >= '2024-12-08 00:55:05'))
OR (o.publish_up = '0000-00-00 00:00:00' AND o.publish_down = '0000-00-00 00:00:00')
)
AND o.access<=0 AND o.published=1 ORDER BY value ASC
Terreni
|
Le nostre offerte attuali
VENDITA TERRENO EDIFICABILE UNO DEGLI ULTIMI INTROVABILI APPEZZAMENTI DI TERRENO EDIFICABILE NELLA ZONA DI DESENZANO CON DESTINAZIONE RESIDENZIALE... | ||
Tipologia Terreni -
Tipo : Vendita Desenzano ♦ BRESCIA ♦ Italia Prezzo:  € 700.000,00 |
||
Superficie mq. : 920 m² ♦
|
Nel comune di flero, posizionato in una zona molto funzionale e collegata bene con le tangenziali, corda molle, a pochi km dal casello autostradale... | ||
Tipologia Terreni -
Tipo : Vendita BRESCIA ZONA SUD ♦ BRESCIA ♦ Italia Prezzo:  € 2.200.000,00 |
||
Superficie mq. : 2,800 m² ♦
|