Apartments for rent Orenburg — Red Banner street

Rooms and Guests
Type
Price
Location 1
Other filters 1
Instant
Orenburg, Russia

Orenburg apartments for rent, Red Banner street street — book online

Your payments are protected

Vlasne guarantees security online booking:

  • contract offer
  • secure payments
  • money back guarantee

All this works only on condition online booking through the website.

Nothing
didn't fit?

Fill in search request.
We will send it to all property owners in the city.

Array (1)
адрес страницы/en/city/orenburg/street/red-banner-street/
Array (2)
time1.0036
count107
1
Array (107)
0SELECT `ws_visits`.* FROM `ws_visits` WHERE (`ws_visits`.`hash_id` = 'ec78a5c332c695570cda68132250ee9b') LIMIT 1;
1SELECT `cities`.*, ST_AsText(`cities`.location) AS `location` FROM `cities` WHERE (`cities`.`seo_link` = 'orenburg') LIMIT 1;
2SELECT `streets`.* FROM `streets` WHERE (`streets`.`url` = 'red-banner-street') AND (`streets`.`city_id` = 1490) AND (`streets`.`active` = 1) LIMIT 1;
3SELECT DISTINCT ad_id FROM n2n_estate_ad_recent WHERE session_id = "0787efni0groee0cgo8qcpk5bq" ORDER BY ctime DESC;
4SELECT `ws_config`.* FROM `ws_config` WHERE (`ws_config`.`code` = 'reservation_percent') AND (`ws_config`.`site_id` IS NULL OR `ws_config`.`site_id` = '2') LIMIT 1;
5SELECT estate_ad.score_info, estate_ad.name_en, estate_ad.description_en, estate_ad.id, estate_ad.adress_en, 2 as currency, ((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.0924 WHEN 2 THEN estate_ad.price_usd * 41.5004 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 54.8345 WHEN 5 THEN estate_ad.price_chf * 49.282 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.081605 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4077 END) / 41.5004) as price_usd, estate_ad.no_reservation, estate_ad.city_public_paused, estate_ad.lat, estate_ad.lng, estate_ad.city_id, estate_ad.country_id, estate_ad.rooms, estate_ad.images, estate_ad.type_id, estate_ad.qty_comments, estate_ad.comments_score, estate_ad.can_low_price, estate_ad.sleeping, estate_ad.city_hot_paused, estate_ad.city_hot_main_paused, estate_ad.end_hot_2, estate_ad.end_hot_main, estate_ad.end_public, estate_ad.end_hot, estate_ad.daily_fee_paid, estate_ad.recommend, estate_ad.reserv, estate_ad.partner_id, estate_ad.customer_id FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 1490 AND estate_ad.partner_id IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-14" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870) AND estate_ad.street_id IN (374459) ORDER BY estate_ad.daily_fee_paid DESC, estate_ad.daily_fee_time ASC, estate_ad.score DESC, estate_ad.id ASC LIMIT 0,26;
6SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'smoking') LIMIT 1;
7SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'children') LIMIT 1;
8SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'animals') LIMIT 1;
9SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'activity') LIMIT 1;
10SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'documents') LIMIT 1;
11SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'kamin') LIMIT 1;
12SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'sauna') LIMIT 1;
13SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'dvd') LIMIT 1;
14SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'tv') LIMIT 1;
15SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Wi-Fi') LIMIT 1;
16SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'plita') LIMIT 1;
17SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'jacoozee') LIMIT 1;
18SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'dush') LIMIT 1;
19SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'boiler') LIMIT 1;
20SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'utyug') LIMIT 1;
21SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'plasma') LIMIT 1;
22SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'fridge') LIMIT 1;
23SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'microwave') LIMIT 1;
24SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'electro_chainik') LIMIT 1;
25SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'posuda') LIMIT 1;
26SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'vanna') LIMIT 1;
27SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'stiral_machine') LIMIT 1;
28SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'cofevarka') LIMIT 1;
29SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'fen') LIMIT 1;
30SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'home_teatr') LIMIT 1;
31SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'condicioneriny') LIMIT 1;
32SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'cable_tv') LIMIT 1;
33SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'balkon') LIMIT 1;
34SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'lodjiya') LIMIT 1;
35SELECT * FROM city_pre_search WHERE (city_id = 1490 OR city_id IS NULL) AND site_id = 2 AND `public` = 1 AND (url != "streets" OR url IS NULL) AND district_id IS NULL AND districts = "" AND micro_district_id IS NULL AND metro_id IS NULL AND sight_id IS NULL AND county_id IS NULL AND rooms IS NULL AND type_id_24 = 0 AND type_id_25 = 0 AND type_id_27 = 0 AND type_id_30 = 0 AND `smoking` = 0 AND `children` = 0 AND `animals` = 0 AND `activity` = 0 AND `documents` = 0 AND `kamin` = 0 AND `sauna` = 0 AND `dvd` = 0 AND `tv` = 0 AND `wifi` = 0 AND `plita` = 0 AND `jacoozee` = 0 AND `dush` = 0 AND `boiler` = 0 AND `utyug` = 0 AND `plasma` = 0 AND `fridge` = 0 AND `microwave` = 0 AND `electro_chainik` = 0 AND `posuda` = 0 AND `vanna` = 0 AND `stiral_machine` = 0 AND `cofevarka` = 0 AND `fen` = 0 AND `home_teatr` = 0 AND `condicioner` = 0 AND `cable_tv` = 0 AND `balkon_lodjiya` = 0 AND `near_the_metro` = 0 AND `near_the_train` = 0 AND `on_weekend_selected` = 0 AND `ny_prices_selected` = 0 AND `on_may_holidays_selected` = 0 AND price_min = 0 AND min_price = 0 AND price_max = 0 AND max_price = 0 AND (ad_name = "" OR ad_name IS NULL) AND (ad_description = "" OR ad_description IS NULL) AND (sleeping_min = 0 OR sleeping_min IS NULL OR sleeping_min = "") AND (county = 0) AND (district = 0) AND (micro_district = 0) AND (metro = 0) AND (street = 1 OR street_id = 374459) AND (sight = 0) ORDER BY IF (city_id = 1490, 0, 1) ASC LIMIT 2;
36SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Квартиры посуточно') LIMIT 1;
37SELECT cities.*, ST_AsText(location) as location FROM cities WHERE city_id = 1490;
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` = 'По рейтингу') 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` = 'ad_type_id_30') 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 `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 `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'через сайт') LIMIT 1;
84SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Снять квартиру посуточно') LIMIT 1;
85SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Ничего') LIMIT 1;
86SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'не подошло') LIMIT 1;
87SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Заполните') LIMIT 1;
88SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'заявку на поиск') LIMIT 1;
89SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Мы отправим ее всем владельцам недвижимости в городе') LIMIT 1;
90SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Показать еще') LIMIT 1;
91SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Искать в радиусе') LIMIT 1;
92SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'км') LIMIT 1;
93SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'предложение') 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 `comments`.* FROM `comments` WHERE (`comments`.`public` = 1) AND (`comments`.`type` = 1) AND (`comments`.`site_id` IS NULL OR `comments`.`site_id` = '2') ORDER BY `ctime` DESC LIMIT 5;
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;
Array (1)
main1.2651
string
Memory: 14.000Mb