Apartment in the center

2-rooms. apartment for 3 guests, 50 m2,
5 floor 14 -storey building

742
uah
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 3 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 3 guests (not counting infants)
View similar object
You won’t be charged yet
742
uah
per day
ava

On the site since july 2019 Rent

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

The owner

ava

On the site since july 2019 Rent

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

flat description

The apartment is in the center of the city, in the area of the terminal of the railway station. We have clean posts, bench hammers. documents, receipts (single web, 3 groups)

Amenities

Rent terms and conditions

Check-in
after 14:00
Check out
up to 12:00
Pledge
450 uah
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/town/rovno/apt/81841/
Array (2)
time14.1671
count85
1
Array (85)
0SELECT `ws_visits`.* FROM `ws_visits` WHERE (`ws_visits`.`hash_id` = '3a9e7059125ed9be09aa66bad310470c') LIMIT 1;
1SELECT `cities`.*, ST_AsText(`cities`.location) AS `location` FROM `cities` WHERE (`cities`.`seo_link` = 'rovno') LIMIT 1;
2SELECT * FROM regions WHERE region_id = 701;
3SELECT `seo_redirects`.* FROM `seo_redirects` WHERE (`seo_redirects`.`site_id` IS NULL OR `seo_redirects`.`site_id` = '16');
4SELECT `estate_ad`.* FROM `estate_ad` WHERE (`estate_ad`.`id` = '81841');
5SELECT cities.*, ST_AsText(location) as location FROM cities WHERE city_id = 10020;
6SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'посуточно') LIMIT 1;
7SELECT country_id FROM country_polygons WHERE St_Contains(polygon, POINT(-83.0061, 39.9625)) LIMIT 1;
8SELECT city_id FROM city_polygons WHERE St_Contains(polygon, POINT(-83.0061, 39.9625)) LIMIT 1;
9SELECT city_id FROM cities WHERE country_id = 75 AND ( name = "Колумбус" OR name_en = "Columbus");
10UPDATE estate_ad SET visits = (visits + 1) WHERE id = 81841;
11SELECT id FROM estate_ad_visit_days WHERE ad_id = 81841 AND yearmonthday = 20250512;
12UPDATE estate_ad_visit_days SET visits = (visits + 1), roomer = (roomer + 0) WHERE id = 62063470;
13SELECT id FROM estate_ad_visit_month WHERE ad_id = 81841 AND yearmonth = 202505;
14UPDATE estate_ad_visit_month SET visits = (visits + 1), roomer = (roomer + 0) WHERE id = 3388024;
15SELECT `estate_ad_visit`.* FROM `estate_ad_visit` WHERE (`estate_ad_visit`.`session_id` = '31ioqrue5s8bc6gfjdsetvafj7') AND (`estate_ad_visit`.`roomer` = 0) AND (utime >= "2025-05-12 19:38:50") ORDER BY `utime` DESC LIMIT 1;
16SELECT `cities`.*, ST_AsText(`cities`.location) AS `location` FROM `cities` WHERE (`cities`.`pay` = 1) ORDER BY `sequence` DESC, `name` ASC;
17INSERT INTO `estate_ad_visit` SET `ad_id` = 81841, `session_id` = '31ioqrue5s8bc6gfjdsetvafj7', `ctime` = '2025-05-12 20:08:50', `utime` = '2025-05-12 20:08:50', `paid_city` = 1, `city_id` = 5973, `country_id` = 75, `ip` = '3.135.236.134', `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` = 20250512, `ad_city_id` = 10020, `owner_id` = 354997;
18SELECT * FROM ws_customers WHERE id = 354997;
19SELECT * FROM estate_media WHERE ad_id = 81841 AND `type` = "image" ORDER BY sequence ASC LIMIT 1;
20SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 81841;
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` = 'Jan') LIMIT 1;
34SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Feb') LIMIT 1;
35SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Mar') LIMIT 1;
36SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Apr') LIMIT 1;
37SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'May_short') LIMIT 1;
38SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Jun') LIMIT 1;
39SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Jul') LIMIT 1;
40SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Aug') LIMIT 1;
41SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Sep') LIMIT 1;
42SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Oct') LIMIT 1;
43SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Nov') LIMIT 1;
44SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Dec') LIMIT 1;
45SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'January_sklon') LIMIT 1;
46SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'March_sklon') LIMIT 1;
47SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'April_sklon') LIMIT 1;
48SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'May_sklon') LIMIT 1;
49SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'June_sklon') LIMIT 1;
50SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'July_sklon') LIMIT 1;
51SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'August_sklon') LIMIT 1;
52SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'September_sklon') LIMIT 1;
53SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'October_sklon') LIMIT 1;
54SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'November_sklon') 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` = 'часов') LIMIT 1;
62SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Написать владельцу') LIMIT 1;
63SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Общайтесь только через') LIMIT 1;
64SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'В целях безопасности никогда не переводите деньги и не общайтесь за пределами сайта') LIMIT 1;
65SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Описание') LIMIT 1;
66SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Удобства') LIMIT 1;
67SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Условия') LIMIT 1;
68SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Карта') LIMIT 1;
69SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Хозяин') LIMIT 1;
70SELECT *, 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 = 81841 AND IF(`type` = "image", IF (small IS NULL OR small = "", false, true), true) ORDER BY ordered ASC, sequence ASC;
71SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Посмотреть все') LIMIT 1;
72SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'квартира посуточно') LIMIT 1;
73SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Владелец квартиры') LIMIT 1;
74SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Время ответа') LIMIT 1;
75SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'условия сдачи') LIMIT 1;
76SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'после') LIMIT 1;
77SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Залог') LIMIT 1;
78SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Животные') LIMIT 1;
79SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Курение') LIMIT 1;
80SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Вечеринки') LIMIT 1;
81SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Увеличить карту') LIMIT 1;
82SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Уменьшить карту') LIMIT 1;
83SELECT DISTINCT ad_id FROM n2n_estate_ad_recent WHERE session_id = "31ioqrue5s8bc6gfjdsetvafj7" ORDER BY ctime DESC;
84SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Новые сообщения') LIMIT 1;
Array (1)
main16.0818
string
Memory: 18.000Mb