SELECT count(id) FROM #__estateagent as o WHERE o.cat=6 AND ( ((o.publish_up >= '0000-00-00 00:00:00' AND o.publish_up <= '2025-07-14 20:45:45') AND o.publish_down >= '2025-07-14 20:45:45') OR ((o.publish_up >= '0000-00-00 00:00:00' AND o.publish_up <= '2025-07-14 20:45:45' ) AND (o.publish_down = '0000-00-00 00:00:00' OR o.publish_down >= '2025-07-14 20:45:45')) 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=6 AND ( ((o.publish_up >= '0000-00-00 00:00:00' AND o.publish_up <= '2025-07-14 20:45:45') AND o.publish_down >= '2025-07-14 20:45:45') OR ((o.publish_up >= '0000-00-00 00:00:00' AND o.publish_up <= '2025-07-14 20:45:45' ) AND (o.publish_down = '0000-00-00 00:00:00' OR o.publish_down >= '2025-07-14 20:45:45')) 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=6 AND ( ((o.publish_up >= '0000-00-00 00:00:00' AND o.publish_up <= '2025-07-14 20:45:45') AND o.publish_down >= '2025-07-14 20:45:45') OR ((o.publish_up >= '0000-00-00 00:00:00' AND o.publish_up <= '2025-07-14 20:45:45' ) AND (o.publish_down = '0000-00-00 00:00:00' OR o.publish_down >= '2025-07-14 20:45:45')) 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
vendo Bar
Nel centro storico di Brescia, in posizione di altissimo passaggio troviamo questo Bar - Caffetteria internamente completamente ristrutturato da soli 6 mesi, all' esterno c' è la possibilità di mettere 6 tavolini , pagando al comune il suolo pubblico per il costo di euro 650,00 annui, cassetto giornaliero circa 250,00 euro, il canone d' affitto mensile del negozio e' di 1.300 euro , spese comprese con esclusione delle utenze di elettricita', acqua calda e riscaldamento

Le nostre offerte attuali
IN POSIZIONE E' STRATEGICA A 20 MT DALLA FERMATA DELLA METROPOLITA, I SERVIZI DI PRIMA NECESSITA' A DUE PASSI, ATTUALMENTE IL NEGOZIO E' ADIBITO A ...
Tipologia vendo Bar - Tipo : Vendita
BRESCIA SUD ♦ Brescia ♦ Italia
Prezzo:  € 200.000,00
Superficie mq. : 100 m² ♦ 

Ricerca Veloce

Alcune proprietà


Vendita terreno edi...

Prezzo:  € 700.000,00
ea_dendena21_175075884612
VILLA VENDITA

Prezzo:  € 450.000,00
ea_carocci6_17431599726
QUADRILOCALE VENDITA

Prezzo:  € 445.000,00
ea_levi3_17308275854
QUADRILOCALE VENDITA

Prezzo:  € 225.000,00
ea_mereu19_174669726825
QUADRILOCALE VENDITA

Prezzo:  € 185.000,00
ea_simeoni5_17092811911
PORZIONE CIELO E TERRA

Prezzo:  € 170.000,00
ea_campi14_17472291651
BILOCALE VENDITA

Prezzo:  € 158.000,00
ea_peroni24_17458483631
TRILOCALE VENDITA

Prezzo:  € 148.000,00
ea_baraldinegozionuovo7_16818020111
NEGOZIO AFFITTO

Prezzo:  € 2.400,00
ea_baraldi_uff_3_5_14425879321
AFFITTO UFFICIO

Prezzo:  € 1.300,00
ea_baraldi_uff_45_5_14425858001
AFFITTO UFFICIO

Prezzo:  € 1.100,00
ea_uffbaraldi_2_10_14425850501
AFFITTO UFFICIO

Prezzo:  € 1.000,00