Studio in Galata

1-rooms. apartment for 2 guests, 50 m2

29
euro
per day
Dates
Check in
Check out
Select a check-in time
Check in time
Close
Number of guests
Adults
Children Age 2 — 12
Maximum 2 guests (not counting infants)
Close
Message
Departure date must be later than the arrival date.
Please fill in the fields "Check in" and "Check out."
Unfortunately, the object is not available for the chosen dates.
You can choose other dates or other objects.
You have already sent a request for these dates.
Wait for a response from the owner, or send a request to other dates.
Minimum stay period for this ad — 1 day
Booking for one day is possible one day prior to arrival or on the day of arrival
Minimum stay for this period —
Please select guests
Maximum 2 guests (not counting infants)
View similar object
You won’t be charged yet
29
euro
per day
ava

On the site since july 2015 Rent

Contact the owner
Communicate only through Vlasne. For security reasons, never transfer money and do not communicate outside the site
Request booking
29 per day
Request booking

The owner

ava

On the site since july 2015 Rent

Contact the owner
Communicate only through Vlasne. For security reasons, never transfer money and do not communicate outside the site

flat description

Studio in Galata, complex "Rosalitsa" (a luxury residential gated). Landscaped park, swimming pool. Equipped kitchen, bedroom, bathroom, terrace with panoramic views. Convenient rest two adults and two children. The kitchen has a cooker with ceramic hob, fridge, hood, and also mikrovarnova oven, kettle and washing machine.

The apartment has a sofa (sofa bed), table, plasma TV, double bed, wardrobe and cupboards. There is air conditioning. The complex offers an outdoor pool and a section for children, landscaped garden, free parking, permanent security, shops. The price of the rent includes electricity, water, pool, parking, maintenance of common areas and a garden.

Show full description

Amenities

Rent terms and conditions

Check-in
after 11:00
Check out
up to 10:00
Pledge
No
Children
Conditions of cancellation
Animals
Smoking
Parties
Documents
Check-in/out terms

Reviews (0)

No reviews have been submitted so far.

Location

Array (1)
адрес страницы/en/city/varna/realt/35052/
Array (2)
time1.4505
count150
1
Array (150)
0SELECT `countries`.*, ST_AsText(`countries`.location) AS `location` FROM `countries` WHERE (`countries`.`subdomain` = 'bulgaria') LIMIT 1;
1SELECT `ws_visits`.* FROM `ws_visits` WHERE (`ws_visits`.`hash_id` = '29e08e19bb0a9a5e3fb27e3cf06325c9') LIMIT 1;
2SELECT `cities`.*, ST_AsText(`cities`.location) AS `location` FROM `cities` WHERE (`cities`.`seo_link` = 'varna') LIMIT 1;
3SELECT `estate_ad`.* FROM `estate_ad` WHERE (`estate_ad`.`id` = '35052');
4SELECT country_id FROM country_polygons WHERE St_Contains(polygon, POINT(-83.0061, 39.9625)) LIMIT 1;
5SELECT city_id FROM city_polygons WHERE St_Contains(polygon, POINT(-83.0061, 39.9625)) LIMIT 1;
6SELECT city_id FROM cities WHERE country_id = 75 AND ( name = "Колумбус" OR name_en = "Columbus");
7UPDATE estate_ad SET visits = (visits + 1) WHERE id = 35052;
8SELECT id FROM estate_ad_visit_days WHERE ad_id = 35052 AND yearmonthday = 20250513;
9UPDATE estate_ad_visit_days SET visits = (visits + 1), roomer = (roomer + 0) WHERE id = 62095941;
10SELECT id FROM estate_ad_visit_month WHERE ad_id = 35052 AND yearmonth = 202505;
11UPDATE estate_ad_visit_month SET visits = (visits + 1), roomer = (roomer + 0) WHERE id = 3408651;
12SELECT `estate_ad_visit`.* FROM `estate_ad_visit` WHERE (`estate_ad_visit`.`session_id` = 'fria8eba8bqusjdanm6r3notvk') AND (`estate_ad_visit`.`roomer` = 0) AND (utime >= "2025-05-13 22:53:25") ORDER BY `utime` DESC LIMIT 1;
13SELECT `cities`.*, ST_AsText(`cities`.location) AS `location` FROM `cities` WHERE (`cities`.`pay` = 1) ORDER BY `sequence` DESC, `name` ASC;
14INSERT INTO `estate_ad_visit` SET `ad_id` = 35052, `session_id` = 'fria8eba8bqusjdanm6r3notvk', `ctime` = '2025-05-13 23:23:25', `utime` = '2025-05-13 23:23:25', `paid_ad` = 1, `city_id` = 5973, `country_id` = 75, `ip` = '3.16.215.186', `user_agent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', `c` = 1, `year` = 2025, `yearmonth` = 202505, `yearmonthday` = 20250513, `ad_city_id` = 2948, `owner_id` = 97140;
15SELECT * FROM estate_media WHERE ad_id = 35052 AND `type` = "image" ORDER BY sequence ASC LIMIT 1;
16SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 35052;
17SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Вернуться') LIMIT 1;
18SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'В этом месяце все даты заняты') LIMIT 1;
19SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Прибытие') LIMIT 1;
20SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Очистить все даты') LIMIT 1;
21SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Минимальная продолжительность бронирования не фиксирована') LIMIT 1;
22SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Выезд') LIMIT 1;
23SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Выберите время заселения') LIMIT 1;
24SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Время заезда') LIMIT 1;
25SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Закрыть') LIMIT 1;
26SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Количество гостей') LIMIT 1;
27SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Выбрать гостей') LIMIT 1;
28SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'гость') LIMIT 1;
29SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Взрослые') LIMIT 1;
30SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Дети') LIMIT 1;
31SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Возраст') LIMIT 1;
32SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Для мероприятий') LIMIT 1;
33SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Максимум') LIMIT 1;
34SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'не считая младенцев') LIMIT 1;
35SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Сообщение') LIMIT 1;
36SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Дата выезда должна быть позднее даты заезда.') LIMIT 1;
37SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Пожалуйста, заполните поля \"Заезд\" и \"Выезд.\"') LIMIT 1;
38SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'К сожалению, объект недоступен на выбранные даты.') LIMIT 1;
39SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Вы можете выбрать другие даты или другие объекты.') LIMIT 1;
40SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Вы уже отправляли запрос на эти даты.') LIMIT 1;
41SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Дождитесь ответа от владельца или отправьте запрос на другие даты.') LIMIT 1;
42SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Минимальный период проживания для этого объявления') LIMIT 1;
43SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'день') LIMIT 1;
44SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'дня') LIMIT 1;
45SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'дней') LIMIT 1;
46SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Бронирование на одни сутки возможно за день до заезда или в день заезда') LIMIT 1;
47SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Минимальный срок проживания для этого периода') LIMIT 1;
48SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Пожалуйста, выберите гостей') LIMIT 1;
49SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Написать сообщение') LIMIT 1;
50SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Проверить занятость') LIMIT 1;
51SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Посмотреть похожие объекты') LIMIT 1;
52SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Пока Вы ни за что не платите') LIMIT 1;
53SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Многие пользователи мечтают жить здесь') LIMIT 1;
54SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'За прошлую неделю это объявление посмотрели') LIMIT 1;
55SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'раз') LIMIT 1;
56SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Это редкая находка') LIMIT 1;
57SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Жилье владельца') LIMIT 1;
58SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'обычно забронировано') LIMIT 1;
59SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Путешественники ищут жилье по соседству') LIMIT 1;
60SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'На сайте с') LIMIT 1;
61SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Jan') LIMIT 1;
62SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Feb') LIMIT 1;
63SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Mar') LIMIT 1;
64SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Apr') LIMIT 1;
65SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'May_short') LIMIT 1;
66SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Jun') LIMIT 1;
67SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Jul') LIMIT 1;
68SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Aug') LIMIT 1;
69SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Sep') LIMIT 1;
70SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Oct') LIMIT 1;
71SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Dec') LIMIT 1;
72SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'January') LIMIT 1;
73SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'February') LIMIT 1;
74SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'March') LIMIT 1;
75SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'April') LIMIT 1;
76SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'May') LIMIT 1;
77SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'July') LIMIT 1;
78SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'August') LIMIT 1;
79SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'September') LIMIT 1;
80SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'October') LIMIT 1;
81SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'November') LIMIT 1;
82SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'December') LIMIT 1;
83SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'January_sklon') LIMIT 1;
84SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'February_sklon') LIMIT 1;
85SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'March_sklon') LIMIT 1;
86SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'April_sklon') LIMIT 1;
87SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'May_sklon') LIMIT 1;
88SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'June_sklon') LIMIT 1;
89SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'July_sklon') LIMIT 1;
90SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'August_sklon') LIMIT 1;
91SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'September_sklon') LIMIT 1;
92SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'November_sklon') LIMIT 1;
93SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'December_sklon') LIMIT 1;
94SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Сдает') LIMIT 1;
95SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'квартиру') LIMIT 1;
96SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'квартиры') LIMIT 1;
97SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'квартир') LIMIT 1;
98SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Успешные бронирования') LIMIT 1;
99SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Время ответа на запрос') LIMIT 1;
100SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'менее часа') LIMIT 1;
101SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'час') LIMIT 1;
102SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'часа') LIMIT 1;
103SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'часов') LIMIT 1;
104SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Написать владельцу') LIMIT 1;
105SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Общайтесь только через') LIMIT 1;
106SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'В целях безопасности никогда не переводите деньги и не общайтесь за пределами сайта') LIMIT 1;
107SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Фото') LIMIT 1;
108SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Описание') LIMIT 1;
109SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Удобства') LIMIT 1;
110SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Условия') LIMIT 1;
111SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Карта') LIMIT 1;
112SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Хозяин') LIMIT 1;
113SELECT *, CASE WHEN `type` = "image" THEN 1 WHEN `type` = "video" THEN 2 WHEN vcode IS NOT NULL AND vcode <> "" then 3 END as ordered FROM estate_media WHERE ad_id = 35052 AND IF(`type` = "image", IF (small IS NULL OR small = "", false, true), true) ORDER BY ordered ASC, sequence ASC;
114SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'квартира посуточно') LIMIT 1;
115SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Владелец квартиры') LIMIT 1;
116SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'описание квартиры') LIMIT 1;
117SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Показать описание полностью') LIMIT 1;
118SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'удобства') LIMIT 1;
119SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Заезд') LIMIT 1;
120SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'после') LIMIT 1;
121SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'до') LIMIT 1;
122SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Залог') LIMIT 1;
123SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'нет') LIMIT 1;
124SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Условия отмены брони') LIMIT 1;
125SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Животные') LIMIT 1;
126SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Курение') LIMIT 1;
127SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Вечеринки') LIMIT 1;
128SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Документы') LIMIT 1;
129SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Условия заезда и выезда') LIMIT 1;
130SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Отзывы') LIMIT 1;
131SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Добавить отзыв') LIMIT 1;
132SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Ответ принят и будет опубликован после модерации') LIMIT 1;
133SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Пока никто не оставлял отзывов.') LIMIT 1;
134SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Месторасположение') LIMIT 1;
135SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Увеличить карту') LIMIT 1;
136SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Уменьшить карту') LIMIT 1;
137SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Показать/скрыть меню') LIMIT 1;
138SELECT DISTINCT ad_id FROM n2n_estate_ad_recent WHERE session_id = "fria8eba8bqusjdanm6r3notvk" ORDER BY ctime DESC;
139SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Вход') LIMIT 1;
140SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Весь сайт') LIMIT 1;
141SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Сдать жилье') LIMIT 1;
142SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Все права защищены') LIMIT 1;
143SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Правила и условия') LIMIT 1;
144SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Политика конфиденциальности') LIMIT 1;
145SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Социальные сети') LIMIT 1;
146SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Приглашай друзей и зарабатывай!') LIMIT 1;
147SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Пригласить') LIMIT 1;
148SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Запросы на бронирование') LIMIT 1;
149SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Новые сообщения') LIMIT 1;
Array (1)
main1.7181
string
Memory: 16.000Mb