Квартири подобово Одеса — Квартири на Новий Рік

Кімнати та гості
Тип житла
Ціна
Розташування
Інші фільтри
Миттєві
Одеса, Україна

Квартири подобово на Новий Рік - Одеса

Ваші платежі захищені

Vlasne гарантує безпеку online бронювання:

  • договір оферти
  • безпечні платежі
  • гарантія повернення коштів

Все це працює тільки за умови online бронювання через сайт.

Нічого
не підійшло?

Заповніть заявку на пошук.
Ми відправимо її всім власникам нерухомості в місті

Array (1)
адрес страницы/ua-city/odessa/filter/kvartira-posutochno-novyj-god/
Array (2)
time2.7443
count89
1
Array (89)
0SELECT id FROM ws_visits WHERE hash_id = "1e413aa57aa0cf5a2090017f348c8124";
1INSERT INTO `ws_visits` SET `hash_id` = '1e413aa57aa0cf5a2090017f348c8124', `ctime` = '2025-05-14 02:15:28', `utime` = '2025-05-14 02:15:28', `total_number_of_pages` = 1, `campaignname` = NULL, `start_url` = 'http://.vlasne.ua/ua-city/odessa/filter/kvartira-posutochno-novyj-god/', `end_url` = 'http://.vlasne.ua/ua-city/odessa/filter/kvartira-posutochno-novyj-god/';
2SELECT `cities`.*, ST_AsText(`cities`.location) AS `location` FROM `cities` WHERE (`cities`.`seo_link` = 'odessa') LIMIT 1;
3SELECT DISTINCT ad_id FROM n2n_estate_ad_recent WHERE session_id = "825uqnkj1ja5uraud82ihvgoqd" ORDER BY ctime DESC;
4SELECT DISTINCT ad_id FROM estate_ad_calendar WHERE `date` IN ("2025-12-31") AND unavailable = 1;
5SELECT estate_ad.score_info, estate_ad.name_uk, estate_ad.name_en, estate_ad.description_uk, estate_ad.description_en, estate_ad.id, estate_ad.adress_uk, estate_ad.adress_en, 6 as currency, ((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.1578 WHEN 2 THEN estate_ad.price_usd * 41.5387 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 54.7418 WHEN 5 THEN estate_ad.price_chf * 49.2895 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.081062 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.4302 END)) as price_uah, 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 = 9967 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused 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.id NOT IN (46401,77372,34900,182083,143717,77212,77213,77211,77210,197546,53544,78489,255708,64468,82567,82568,50990,62916,64469,185467,37639) AND (estate_ad.no_reservation = 0 OR estate_ad.customer_id = 68087 OR estate_ad.end_public >= "2025-05-14" OR estate_ad.daily_fee_paid > 0) AND (estate_ad.reservation_until IS NULL OR estate_ad.reservation_until >= "2026-01-01") ORDER BY IF (estate_ad.end_hot_main >= "2025-05-14", IF (estate_ad.reserv = 1, 2.5, 2), IF (estate_ad.end_hot_2 >= "2025-05-14", IF (estate_ad.reserv = 1, 1.5, 1), IF (estate_ad.end_public >= "2025-05-14", IF (estate_ad.reserv = 1, 0.5, 0), -0.5))) DESC, estate_ad.score DESC, estate_ad.id ASC LIMIT 0,40;
6SELECT * FROM city_pre_search WHERE (city_id = 9967 OR city_id IS NULL) AND site_id = 1 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 street_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` = 1 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 = 0) AND (sight = 0) ORDER BY IF (city_id = 9967, 0, 1) ASC LIMIT 2;
7SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 842;
8SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '842') LIMIT 1;
9SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 8165;
10SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '8165') LIMIT 1;
11SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 53233;
12SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '53233') LIMIT 1;
13SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 69039;
14SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '69039') LIMIT 1;
15SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 82390;
16SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '82390') LIMIT 1;
17SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 293144;
18SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '293144') LIMIT 1;
19SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Снять квартиру посуточно') LIMIT 1;
20SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 293173;
21SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '293173') LIMIT 1;
22SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 44196;
23SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '44196') LIMIT 1;
24SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 44615;
25SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '44615') LIMIT 1;
26SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 42500;
27SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '42500') LIMIT 1;
28SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 48635;
29SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '48635') LIMIT 1;
30SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 50020;
31SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '50020') LIMIT 1;
32SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 64669;
33SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '64669') LIMIT 1;
34SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 7159;
35SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '7159') LIMIT 1;
36SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 50813;
37SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '50813') LIMIT 1;
38SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 52175;
39SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '52175') LIMIT 1;
40SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 197575;
41SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '197575') LIMIT 1;
42SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 1381;
43SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '1381') LIMIT 1;
44SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 264167;
45SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '264167') LIMIT 1;
46SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 83617;
47SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '83617') LIMIT 1;
48SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 265731;
49SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '265731') LIMIT 1;
50SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 29187;
51SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '29187') LIMIT 1;
52SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 11997;
53SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '11997') LIMIT 1;
54SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 43071;
55SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '43071') LIMIT 1;
56SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 64294;
57SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '64294') LIMIT 1;
58SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 64780;
59SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '64780') LIMIT 1;
60SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 66715;
61SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '66715') LIMIT 1;
62SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 277909;
63SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '277909') LIMIT 1;
64SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 453;
65SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '453') LIMIT 1;
66SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 482;
67SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '482') LIMIT 1;
68SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 483;
69SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '483') LIMIT 1;
70SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 484;
71SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '484') LIMIT 1;
72SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 485;
73SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '485') LIMIT 1;
74SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 487;
75SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '487') LIMIT 1;
76SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 495;
77SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '495') LIMIT 1;
78SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 496;
79SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '496') LIMIT 1;
80SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 503;
81SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '503') LIMIT 1;
82SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 556;
83SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '556') LIMIT 1;
84SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 562;
85SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '562') LIMIT 1;
86SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 569;
87SELECT `estate_ad_additionally`.* FROM `estate_ad_additionally` WHERE (`estate_ad_additionally`.`ad_id` = '569') LIMIT 1;
88SELECT `comments`.* FROM `comments` WHERE (`comments`.`public` = 1) AND (`comments`.`type` = 1) AND (`comments`.`site_id` IS NULL OR `comments`.`site_id` = '1') ORDER BY `ctime` DESC LIMIT 5;
Array (1)
main3.637
string
Memory: 4.000Mb