2-rooms. apartment for 4 guests, 42 m2

3450
rub
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 4 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 — 2 days
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 4 guests (not counting infants)
You won’t be charged yet
3450
rub
per day
ava

On the site since august 2017 Rent

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

The owner

ava

On the site since august 2017 Rent

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

flat description

Dear guests, take a seat in the most pretentious house of the city in the central square. Read more on our website abazhurhotel. Infrastructure: - Gazprom. - Administration. - Department of Internal Affairs. - Yugorsk Regional Electric Grid Company. - Museum of Nature and Man. - YSU and the Arts Center for gifted children of the North.

Stop Transport agency. Ideal for arriving on intercity bus. In the house there is a grocery store at the entrance to the entrance, pharmacies, banks, ticket office. Spacious parking. Nearby dining room, cafe, trading house. Two separate rooms with separate entrance and door each. Two modern TVs with cable channels. Wide beds with snow-white linen will make your sleep sound and healthy. The price includes: - Laundry and ironing of bed linen. - Wireless Internet and cable television. - Use of household appliances. Washing machine, iron, refrigerator, kettle, microwave, hairdryer. - Provision of dishes and cutlery. - One way transfer 500 rub. For a car. The minimum stay is two days. Insurance deposit 2000 rub. Returned when leaving after inspecting the apartment and handing over the keys. Office Pionerskaya, 70. Call, write, book!

Show full description

Amenities

Rent terms and conditions

Check-in
after 12:00
Check out
up to 11:00
Pledge
2000 rub
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/khanty-mansiysk-tyumen-region/realt/53221/
Array (2)
time0.351
count21
1
Array (21)
0SELECT `ws_visits`.* FROM `ws_visits` WHERE (`ws_visits`.`hash_id` = '900e713e22b7dc9e23fb51cc58c781ab') LIMIT 1;
1SELECT `cities`.*, ST_AsText(`cities`.location) AS `location` FROM `cities` WHERE (`cities`.`seo_link` = 'khanty-mansiysk-tyumen-region') LIMIT 1;
2SELECT `estate_ad`.* FROM `estate_ad` WHERE (`estate_ad`.`id` = '53221');
3SELECT `streets`.* FROM `streets` WHERE (`streets`.`id` = '423458');
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 = 53221;
8SELECT id FROM estate_ad_visit_days WHERE ad_id = 53221 AND yearmonthday = 20250515;
9UPDATE estate_ad_visit_days SET visits = (visits + 1), roomer = (roomer + 0) WHERE id = 62133765;
10SELECT id FROM estate_ad_visit_month WHERE ad_id = 53221 AND yearmonth = 202505;
11UPDATE estate_ad_visit_month SET visits = (visits + 1), roomer = (roomer + 0) WHERE id = 3405783;
12SELECT `estate_ad_visit`.* FROM `estate_ad_visit` WHERE (`estate_ad_visit`.`session_id` = 'e7j8djtk3lhmvdsq3lthg2jml2') AND (`estate_ad_visit`.`roomer` = 0) AND (utime >= "2025-05-15 11:31:16") 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` = 53221, `session_id` = 'e7j8djtk3lhmvdsq3lthg2jml2', `ctime` = '2025-05-15 12:01:16', `utime` = '2025-05-15 12:01:16', `paid_ad` = 1, `city_id` = 5973, `country_id` = 75, `ip` = '3.147.79.68', `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` = 20250515, `ad_city_id` = 2273, `owner_id` = 211725;
15SELECT * FROM ws_customers WHERE id = 211725;
16SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 53221;
17SELECT `streets`.* FROM `streets` WHERE (`streets`.`id` = '423458') LIMIT 1;
18SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Очистить все даты') LIMIT 1;
19SELECT *, 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 = 53221 AND IF(`type` = "image", IF (small IS NULL OR small = "", false, true), true) ORDER BY ordered ASC, sequence ASC;
20SELECT DISTINCT ad_id FROM n2n_estate_ad_recent WHERE session_id = "e7j8djtk3lhmvdsq3lthg2jml2" ORDER BY ctime DESC;
Array (1)
main0.5219
string
Memory: 16.000Mb