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

#23 - Out of resources when opening file '/tmp/#sql_6f4c_682.MYI' (Errcode: 24)

Two-bedroom apartment for rent in city center

PROPERTIES

Properties in Bulgaria

Още изгледи:

TWO-BEDROOM APARTMENT FOR RENT IN CITY CENTER

Property type: Apartment -> Three rooms
Property ID: 10486
Location: Varna / Top Center

Area: 100 m²

600 EUR
 

For Rent:

Furnishing:Furnished
Building:Brick built
Phone:No
Central heating:Yes
Garage:No
Lift:No
Floor:3

Send a question

Description:

Accent Invest offers to your attention two-bedroom apartment for rent in Varna, city center. The apartment has an area of 100 square meters and is located on the third floor. The flat consists of a corridor, living room, kitchen, two bedrooms, bathroom, toilet, two terraces. The apartment is fully furnished and equipped with all necessary appliances for a modern household, including dishwasher and dryer. 

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

Лого