Moscow Oblast

Apartments for rent Moscow — 47 th and 47 th districts A savyolovsky district

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

Moscow apartments for rent, 47 th and 47 th districts A savyolovsky district sub-district — book online

List view On the map
Array (1)
адрес страницы/en/city/moscow/sub-district/47-th-and-47-th-a-savyolovsky/
Array (2)
time0.1167
count9
1
Array (9)
0SELECT `ws_visits`.* FROM `ws_visits` WHERE (`ws_visits`.`hash_id` = 'c04658558b7d22605ef1152cf89b01cb') LIMIT 1;
1SELECT `cities`.*, ST_AsText(`cities`.location) AS `location` FROM `cities` WHERE (`cities`.`seo_link` = 'moscow') LIMIT 1;
2SELECT `micro_districts`.* FROM `micro_districts` WHERE (`micro_districts`.`url` = '47-th-and-47-th-a-savyolovsky') AND (`micro_districts`.`city_id` = 166) AND (`micro_districts`.`active` = 1) LIMIT 1;
3SELECT DISTINCT ad_id FROM n2n_estate_ad_recent WHERE session_id = "pgqf4hlpjbfeicbukmapp7614p" ORDER BY ctime DESC;
4SELECT 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.5886 WHEN 2 THEN estate_ad.price_usd * 41.5376 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.38 WHEN 5 THEN estate_ad.price_chf * 49.6357 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.081743 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.4296 END) / 41.5376) 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 = 166 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-15" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870) AND estate_ad.micro_district_id IN (15890) 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;
5SELECT * FROM city_pre_search WHERE (city_id = 166 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 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` = 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 = 1 OR micro_district_id = 15890) AND (metro = 0) AND (street = 0) AND (sight = 0) ORDER BY IF (city_id = 166, 0, 1) ASC LIMIT 2;
6SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Снять квартиру посуточно') LIMIT 1;
7SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'предложений') LIMIT 1;
8SELECT `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;
Array (1)
main0.3488
string
Memory: 10.000Mb