Cozy apartment in the center of Orenburg

1-rooms. apartment for 4 guests, 40 m2,
3 floor 7-s -storey building

1150
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 — 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 4 guests (not counting infants)
View similar object
You won’t be charged yet
1150
rub
per day
ava

On the site since may 2017 Rent

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

The owner

ava

On the site since may 2017 Rent

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

flat description

The apartment is located in the Central District of Orenburg, which is a great convenience for the business travelers and guests who arrived in the city on a business trip. Within walking distance of the recreation center "GAZOVIK", Regional Children's Hospital. RIACENTR, TH SUNRISE, PRESIDENT KADETSKY school, military unit at KHARKOVSKY 2.

Nearby there are cafes, restaurants, supermarkets around the clock, pharmacy banks, telegraph, post office, sports club, stadium, Perovskogo, amusement and recreation park "Poplar", the cinema center "Cosmos", polyclinics. In walking distance GAZPROM NEFT ORENBURG, FAMILY PLANNING CENTER There are public transport stops connecting the transport routes to all districts of Orenburg within a three-minute walk from the house. Nearby there is a parking lot. Travel documents in the form of 3G.

Show full description

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/city/orenburg/realt/52160/
Array (2)
time7.7705
count79
1
Array (79)
0SELECT `ws_visits`.* FROM `ws_visits` WHERE (`ws_visits`.`hash_id` = 'ce9a82e1b5347d385a59bd73a981708a') LIMIT 1;
1SELECT `cities`.*, ST_AsText(`cities`.location) AS `location` FROM `cities` WHERE (`cities`.`seo_link` = 'orenburg') LIMIT 1;
2SELECT `estate_ad`.* FROM `estate_ad` WHERE (`estate_ad`.`id` = '52160');
3SELECT cities.*, ST_AsText(location) as location FROM cities WHERE city_id = 1490;
4SELECT `streets`.* FROM `streets` WHERE (`streets`.`id` = '374459');
5SELECT country_id FROM country_polygons WHERE St_Contains(polygon, POINT(-83.0061, 39.9625)) LIMIT 1;
6SELECT city_id FROM city_polygons WHERE St_Contains(polygon, POINT(-83.0061, 39.9625)) LIMIT 1;
7SELECT city_id FROM cities WHERE country_id = 75 AND ( name = "Колумбус" OR name_en = "Columbus");
8UPDATE estate_ad SET visits = (visits + 1) WHERE id = 52160;
9SELECT id FROM estate_ad_visit_days WHERE ad_id = 52160 AND yearmonthday = 20250514;
10UPDATE estate_ad_visit_days SET visits = (visits + 1), roomer = (roomer + 0) WHERE id = 62114908;
11SELECT id FROM estate_ad_visit_month WHERE ad_id = 52160 AND yearmonth = 202505;
12UPDATE estate_ad_visit_month SET visits = (visits + 1), roomer = (roomer + 0) WHERE id = 3409112;
13SELECT `estate_ad_visit`.* FROM `estate_ad_visit` WHERE (`estate_ad_visit`.`session_id` = 'eprvma333ad36ig2r8pomrp6fk') AND (`estate_ad_visit`.`roomer` = 0) AND (utime >= "2025-05-14 09:00:17") ORDER BY `utime` DESC LIMIT 1;
14SELECT `cities`.*, ST_AsText(`cities`.location) AS `location` FROM `cities` WHERE (`cities`.`pay` = 1) ORDER BY `sequence` DESC, `name` ASC;
15INSERT INTO `estate_ad_visit` SET `ad_id` = 52160, `session_id` = 'eprvma333ad36ig2r8pomrp6fk', `ctime` = '2025-05-14 09:30:17', `utime` = '2025-05-14 09:30:17', `referer` = 'https://vlasne.ru/ru/user/changelang/lang/en/currency/2/?uri=%2Fcity%2Forenburg%2Frealt%2F52160%2F', `paid_ad` = 1, `city_id` = 5973, `country_id` = 75, `ip` = '3.142.201.222', `user_agent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])', `c` = 1, `year` = 2025, `yearmonth` = 202505, `yearmonthday` = 20250514, `ad_city_id` = 1490, `owner_id` = 195402;
16SELECT * FROM ws_customers WHERE id = 195402;
17SELECT * FROM estate_media WHERE ad_id = 52160 AND `type` = "image" ORDER BY sequence ASC LIMIT 1;
18SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 52160;
19SELECT * FROM districts WHERE id = 617;
20SELECT `streets`.* FROM `streets` WHERE (`streets`.`id` = '374459') LIMIT 1;
21SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
22SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
23SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
24SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
25SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
26SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
27SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
28SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
29SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
30SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
31SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
32SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
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` = 'April_sklon') LIMIT 1;
38SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'May_sklon') LIMIT 1;
39SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'June_sklon') LIMIT 1;
40SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'July_sklon') LIMIT 1;
41SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'August_sklon') LIMIT 1;
42SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'September_sklon') LIMIT 1;
43SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'October_sklon') LIMIT 1;
44SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'December_sklon') 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 *, 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 = 52160 AND IF(`type` = "image", IF (small IS NULL OR small = "", false, true), true) ORDER BY ordered ASC, sequence ASC;
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 `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Документы') LIMIT 1;
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 DISTINCT ad_id FROM n2n_estate_ad_recent WHERE session_id = "eprvma333ad36ig2r8pomrp6fk" ORDER BY ctime DESC;
77SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Запросы на бронирование') LIMIT 1;
78SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Новые сообщения') LIMIT 1;
Array (1)
main8.6697
string
Memory: 16.000Mb