2-rooms. apartment for 4 guests, 40 m2,
1 floor 5 -storey building

800
uah
per day
ava

On the site since february 2017 Rent

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

The owner

ava

On the site since february 2017 Rent

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

flat description

I rent an apartment daily or weekly in a convenient area of the city. All details by phone. The price is for hourly rental during the day. The price per night is negotiated separately during conversation and depends on the number of people staying. I send a review video to Viber or WhatsApp. Contact us! I will definitely offer you options.

Amenities

Rent terms and conditions

Check-in
after 12:00
Check out
up to 11: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/arenda-izmail/apt/290650/
Array (2)
time0.2813
count18
1
Array (18)
0SELECT `ws_visits`.* FROM `ws_visits` WHERE (`ws_visits`.`hash_id` = '9d80d1751967e4cea559b5506656df7c') LIMIT 1;
1SELECT `cities`.*, ST_AsText(`cities`.location) AS `location` FROM `cities` WHERE (`cities`.`seo_link` = 'izmail') LIMIT 1;
2SELECT `estate_ad`.* FROM `estate_ad` WHERE (`estate_ad`.`id` = '290650');
3SELECT country_id FROM country_polygons WHERE St_Contains(polygon, POINT(-83.0061, 39.9625)) LIMIT 1;
4SELECT city_id FROM city_polygons WHERE St_Contains(polygon, POINT(-83.0061, 39.9625)) LIMIT 1;
5SELECT city_id FROM cities WHERE country_id = 75 AND ( name = "Колумбус" OR name_en = "Columbus");
6UPDATE estate_ad SET visits = (visits + 1) WHERE id = 290650;
7SELECT id FROM estate_ad_visit_days WHERE ad_id = 290650 AND yearmonthday = 20250512;
8UPDATE estate_ad_visit_days SET visits = (visits + 1), roomer = (roomer + 0) WHERE id = 62066326;
9SELECT id FROM estate_ad_visit_month WHERE ad_id = 290650 AND yearmonth = 202505;
10UPDATE estate_ad_visit_month SET visits = (visits + 1), roomer = (roomer + 0) WHERE id = 3397727;
11SELECT `estate_ad_visit`.* FROM `estate_ad_visit` WHERE (`estate_ad_visit`.`session_id` = 'p6k9k27qju6o3a7u246q6hl6eq') AND (`estate_ad_visit`.`roomer` = 0) AND (utime >= "2025-05-12 15:13:00") ORDER BY `utime` DESC LIMIT 1;
12SELECT `cities`.*, ST_AsText(`cities`.location) AS `location` FROM `cities` WHERE (`cities`.`pay` = 1) ORDER BY `sequence` DESC, `name` ASC;
13INSERT INTO `estate_ad_visit` SET `ad_id` = 290650, `session_id` = 'p6k9k27qju6o3a7u246q6hl6eq', `ctime` = '2025-05-12 15:43:00', `utime` = '2025-05-12 15:43:00', `referer` = 'https://posutochno.com.ua/uk/user/changelang/lang/en/currency/2/?uri=%2Fua-arenda-izmail%2Fapt%2F290650%2F', `paid_ad` = 1, `city_id` = 5973, `country_id` = 75, `ip` = '18.220.70.192', `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` = 9957, `owner_id` = 179102;
14SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 290650;
15SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = '-ти') LIMIT 1;
16SELECT *, 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 = 290650 AND IF(`type` = "image", IF (small IS NULL OR small = "", false, true), true) ORDER BY ordered ASC, sequence ASC;
17SELECT DISTINCT ad_id FROM n2n_estate_ad_recent WHERE session_id = "p6k9k27qju6o3a7u246q6hl6eq" ORDER BY ctime DESC;
Array (1)
main0.5271
string
Memory: 16.000Mb