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

Cafe/bakery/grill 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

CAFE/BAKERY/GRILL FOR RENT IN WESTERN INDUSTRIAL ZONE

Property type: Commercial estates -> Retail
Property type: Commercial estates -> Restaurant & Bar
Property ID: 21655
Location: Varna / Vuzragdane

Area: 70 m²

450 EUR
 

For Rent:

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

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

Лого