SELECT s.selishte_id, sp.ime, s.selishte_up_id, spbg.ime, COUNT(ob.obqva_id) AS broi_ob, s.selishted FROM selishte s LEFT JOIN selishte_prevod sp ON s.selishte_id = sp.selishte_id AND sp.ezik_id = 2 LEFT JOIN selishte_prevod spbg ON s.selishte_id = spbg.selishte_id AND spbg.ezik_id = 1 LEFT JOIN obqva_selishte ob ON s.selishte_id = ob.selishte_id GROUP BY s.selishte_id, sp.ime, s.selishte_up_id, spbg.ime, s.selishted ORDER BY sp.ime

#1030 - Got error 28 from storage engine

Bistro/warehouse for rent in western industrial zone

Property ID  

Search on the Map

Банки

PROPERTIES

Properties in Bulgaria

Още изгледи:

Properties in Bulgaria
Properties in Bulgaria
Properties in Bulgaria
Properties in Bulgaria
Properties in Bulgaria
Properties in Bulgaria
Properties in Bulgaria
Properties in Bulgaria
Properties in Bulgaria
Properties in Bulgaria

BISTRO/WAREHOUSE FOR RENT IN WESTERN INDUSTRIAL ZONE

Property type: Industrial estates -> Warehouse
Property type: Commercial estates -> Restaurant & Bar -> Snack bar
Property ID: 21123
Location: Varna / West Industrial Estate

Area: 168 m²

870 EUR
 

For Rent:

Furnishing:Not furnished
Building:Brick built
Floor:Parter/8

Send a question

This offer is still in process of translation. Please come back later or switch to another language to see the detailed information.

Send a question

Contacts:

BROKER ИВАЙЛО ГЕОРГИЕВ
Phone +35952611010
Phone +35952602118
Mobile +359887377355

ACCENT INVEST
Maria Luiza Blvd.39, 9000 Varna
Phone: +359 52 61 10 10
Fax: +359 52 60 21 18
e-mail: office@accentinvest.com

Лого