Объекты недвижимости

7,5 млн ₽
2-к. квартира, 64 м²
Вторичное жилье, Сахалинская обл.,г. Южно-Сахалинск,22 мкр. р-н,ул. Херсонская,д. 18
7,7 млн ₽
1-к. квартира, 41 м²
Вторичное жилье, Сахалинская обл.,г. Южно-Сахалинск,14 мкр. р-н,ул. Комсомольская,д. 247
6 млн ₽
3-к. квартира, 70 м²
Вторичное жилье, Сахалинская обл.,Ногликский р-н,п.г.т. Ноглики,ул. Тымская,д. 2
1 млн ₽
2-к. квартира, 45 м²
Вторичное жилье, Сахалинская обл.,Томаринский р-н,г. Томари,ул. Юбилейная,д. 27
8,2 млн ₽
2-к. квартира, 54 м²
Вторичное жилье, Сахалинская обл.,Анивский р-н,с. Новотроицкое,ул. Новая,д. 13,кв. 5
9,3 млн ₽
3-к. квартира, 95 м²
Вторичное жилье, Сахалинская обл.,г. Южно-Сахалинск,Хомутово р-н,ул. Армейская,д. 22
590 тыс ₽
2-к. квартира, 42 м²
Вторичное жилье, Сахалинская обл.,Александровск-Сахалинский р-н,г. Александровск-Сахалинский,ул. Дзержинского,д. 23
9,4 млн ₽
2-к. квартира, 66 м²
Вторичное жилье, Сахалинская обл.,Анивский р-н,с. Новотроицкое,ул. Весенняя,д. 5
6,3 млн ₽
2-к. квартира, 58 м²
Вторичное жилье, Сахалинская обл.,г. Южно-Сахалинск,Луговое р-н,ул. 2-я Железнодорожная,д. 47
6,4 млн ₽
4-к. квартира, 70 м²
Вторичное жилье, Сахалинская обл.,г. Южно-Сахалинск,с. Санаторное,ул. Санаторная,д. 23
2,4 млн ₽
3-к. квартира, 57 м²
Вторичное жилье, Сахалинская обл.,Томаринский р-н,г. Томари,ул. Юбилейная,д. 25
5,2 млн ₽
1-к. квартира, 31 м²
Вторичное жилье, Сахалинская обл.,Невельский р-н,г. Невельск,ул. Северная,д. 14
5 млн ₽
2-к. квартира, 100 м²
Вторичное жилье, Сахалинская обл.,Невельский р-н,г. Невельск,ул. Рыбацкая,д. 4
15 млн ₽
3-к. квартира, 68 м²
Вторичное жилье, Сахалинская обл.,Курильский р-н,г. Курильск,ул. Сахалинская,д. 11
15 млн ₽
3-к. квартира, 78 м²
Вторичное жилье, Сахалинская обл.,Курильский р-н,г. Курильск,ул. Рыбоводная,д. 1
Забронировать объект
Подробнее об услуге
Нажимая кнопку «Забронировать», я соглашаюсь на обработку персональных данных в соответствии с политикой и на получение рекламных материалов
Не забывайте про капчу!
MySQL статистика (86)
Query Rows Time Cached
SET SESSION sql_mode = '' - 0.019752 false
SELECT items.id, items.parent_id, items.title, items.is_hidden_in_menu, items.sort_order, items.href, menus.code as menu_code, menus.use_code_in_links as menu_code_in_links, blocks.id as block_id, blocks.code as block_code, blocks.description, blocks.content, blocks.template, blocks.block_type, f.id as image_id, f.disk_name as image_path FROM admin_menu_items as items LEFT JOIN admin_menus as menus ON menus.id = items.menu_id LEFT JOIN admin_text_blocks as blocks ON blocks.id = items.text_block_id LEFT JOIN db_files as f ON f.master_object_id = items.id AND f.master_object_class = 'Admin_MenuItem' AND f.field = 'image' WHERE items.is_hidden is null ORDER BY items.parent_id, items.sort_order 40 0.018285 false
SELECT id FROM catalog_category_types WHERE name = 'Подъезд' LIMIT 1 1 0.025566 false
SELECT id FROM catalog_categories WHERE category_type_id = '5' AND (hidden IS NULL OR hidden = 0) AND (deleted IS NULL OR deleted = 0) 3 0.003750 false
SELECT id FROM catalog_categories WHERE LOWER(TRIM(name)) = LOWER(TRIM('Вторичное жилье')) AND (hidden IS NULL OR hidden = 0) AND (deleted IS NULL OR deleted = 0) 3 0.000687 false
SELECT * FROM catalog_categories WHERE deleted is null 10 0.006543 false
SELECT id FROM catalog_categories WHERE LOWER(TRIM(name)) = LOWER(TRIM('Вторичное жилье')) AND (hidden IS NULL OR hidden = 0) AND (deleted IS NULL OR deleted = 0) 3 0.000568 false
SELECT id FROM catalog_product_types WHERE LOWER(TRIM(name)) = LOWER(TRIM('вторичка')) 1 0.000522 false
SELECT count(*) FROM catalog_products as products WHERE products.category_id in ('3', '4', '5', '6', '7', '8', '9', '10', '11', '12') AND products.hidden is null AND products.deleted is null AND (products.hidden IS NULL OR products.hidden = 0) AND (products.deleted IS NULL OR products.deleted = 0) AND ( products.category_id IS NULL OR products.category_id IN ( SELECT c.id FROM catalog_categories c WHERE (c.hidden IS NULL OR c.hidden = 0) AND (c.deleted IS NULL OR c.deleted = 0) ) ) AND (products.category_id IN ('10','11','12') OR products.type_id IN ('1')) 1 0.001423 false
SELECT products.* FROM catalog_products as products WHERE products.category_id in ('3', '4', '5', '6', '7', '8', '9', '10', '11', '12') AND products.hidden is null AND products.deleted is null AND (products.hidden IS NULL OR products.hidden = 0) AND (products.deleted IS NULL OR products.deleted = 0) AND ( products.category_id IS NULL OR products.category_id IN ( SELECT c.id FROM catalog_categories c WHERE (c.hidden IS NULL OR c.hidden = 0) AND (c.deleted IS NULL OR c.deleted = 0) ) ) AND (products.category_id IN ('10','11','12') OR products.type_id IN ('1')) ORDER BY products.updated_at DESC LIMIT 45, 15 15 0.003380 false
SELECT * FROM db_files as files WHERE master_object_class = 'Catalog_Product' AND master_object_id in ('142', '141', '140', '139', '138', '137', '136', '135', '134', '133', '132', '131', '130', '129', '128') 164 0.006123 false
SELECT id, level, parent_id FROM catalog_categories WHERE hidden is null AND deleted is null ORDER BY level ASC 8 0.001171 false
SELECT * FROM catalog_categories WHERE id in ('10') AND deleted is null AND id in ('10', '3', '4', '5', '6', '7', '8', '9') 1 0.000500 false
SELECT cpa.product_id, ka.id AS action_id, ka.name, ka.url, ka.description, ka.sort_order FROM kluch_product_actions cpa INNER JOIN kluch_actions ka ON ka.id = cpa.action_id AND ka.is_active = 1 WHERE cpa.product_id IN ('142','141','140','139','138','137','136','135','134','133','132','131','130','129','128') ORDER BY cpa.product_id, ka.sort_order ASC, ka.name ASC 3 0.001227 false
SELECT seo_settings.* FROM seo_settings ORDER BY id desc LIMIT 0, 1 1 0.000409 false
update seo_settings set individual_seo_settings = 'a:0:{}' - 0.000235 false
SELECT db_files.* FROM db_files WHERE (db_files.id = '952') LIMIT 0, 1 1 0.000356 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.004636 false
WITH RECURSIVE tree AS ( SELECT id, parent_id, name, 0 AS depth FROM catalog_categories WHERE id = '10' UNION ALL SELECT c.id, c.parent_id, c.name, tree.depth + 1 AS depth FROM catalog_categories c INNER JOIN tree ON tree.parent_id = c.id ) SELECT name FROM tree ORDER BY depth DESC LIMIT 1 1 0.015538 false
SELECT db_files.* FROM db_files WHERE (db_files.id = '943') LIMIT 0, 1 1 0.034363 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000422 false
WITH RECURSIVE tree AS ( SELECT id, parent_id, name, 0 AS depth FROM catalog_categories WHERE id = '10' UNION ALL SELECT c.id, c.parent_id, c.name, tree.depth + 1 AS depth FROM catalog_categories c INNER JOIN tree ON tree.parent_id = c.id ) SELECT name FROM tree ORDER BY depth DESC LIMIT 1 1 0.007950 false
SELECT db_files.* FROM db_files WHERE (db_files.id = '932') LIMIT 0, 1 1 0.000483 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000348 false
WITH RECURSIVE tree AS ( SELECT id, parent_id, name, 0 AS depth FROM catalog_categories WHERE id = '10' UNION ALL SELECT c.id, c.parent_id, c.name, tree.depth + 1 AS depth FROM catalog_categories c INNER JOIN tree ON tree.parent_id = c.id ) SELECT name FROM tree ORDER BY depth DESC LIMIT 1 1 0.009940 false
SELECT db_files.* FROM db_files WHERE (db_files.id = '914') LIMIT 0, 1 1 0.000461 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000449 false
WITH RECURSIVE tree AS ( SELECT id, parent_id, name, 0 AS depth FROM catalog_categories WHERE id = '10' UNION ALL SELECT c.id, c.parent_id, c.name, tree.depth + 1 AS depth FROM catalog_categories c INNER JOIN tree ON tree.parent_id = c.id ) SELECT name FROM tree ORDER BY depth DESC LIMIT 1 1 0.000530 false
SELECT db_files.* FROM db_files WHERE (db_files.id = '896') LIMIT 0, 1 1 0.000470 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000410 false
WITH RECURSIVE tree AS ( SELECT id, parent_id, name, 0 AS depth FROM catalog_categories WHERE id = '10' UNION ALL SELECT c.id, c.parent_id, c.name, tree.depth + 1 AS depth FROM catalog_categories c INNER JOIN tree ON tree.parent_id = c.id ) SELECT name FROM tree ORDER BY depth DESC LIMIT 1 1 0.000602 false
SELECT db_files.* FROM db_files WHERE (db_files.id = '881') LIMIT 0, 1 1 0.000711 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000510 false
WITH RECURSIVE tree AS ( SELECT id, parent_id, name, 0 AS depth FROM catalog_categories WHERE id = '10' UNION ALL SELECT c.id, c.parent_id, c.name, tree.depth + 1 AS depth FROM catalog_categories c INNER JOIN tree ON tree.parent_id = c.id ) SELECT name FROM tree ORDER BY depth DESC LIMIT 1 1 0.003601 false
SELECT db_files.* FROM db_files WHERE (db_files.id = '875') LIMIT 0, 1 1 0.008938 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.006627 false
WITH RECURSIVE tree AS ( SELECT id, parent_id, name, 0 AS depth FROM catalog_categories WHERE id = '10' UNION ALL SELECT c.id, c.parent_id, c.name, tree.depth + 1 AS depth FROM catalog_categories c INNER JOIN tree ON tree.parent_id = c.id ) SELECT name FROM tree ORDER BY depth DESC LIMIT 1 1 0.006665 false
SELECT db_files.* FROM db_files WHERE (db_files.id = '863') LIMIT 0, 1 1 0.000621 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000976 false
WITH RECURSIVE tree AS ( SELECT id, parent_id, name, 0 AS depth FROM catalog_categories WHERE id = '10' UNION ALL SELECT c.id, c.parent_id, c.name, tree.depth + 1 AS depth FROM catalog_categories c INNER JOIN tree ON tree.parent_id = c.id ) SELECT name FROM tree ORDER BY depth DESC LIMIT 1 1 0.001056 false
SELECT db_files.* FROM db_files WHERE (db_files.id = '854') LIMIT 0, 1 1 0.000470 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000353 false
WITH RECURSIVE tree AS ( SELECT id, parent_id, name, 0 AS depth FROM catalog_categories WHERE id = '10' UNION ALL SELECT c.id, c.parent_id, c.name, tree.depth + 1 AS depth FROM catalog_categories c INNER JOIN tree ON tree.parent_id = c.id ) SELECT name FROM tree ORDER BY depth DESC LIMIT 1 1 0.000491 false
SELECT db_files.* FROM db_files WHERE (db_files.id = '846') LIMIT 0, 1 1 0.004019 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.003521 false
WITH RECURSIVE tree AS ( SELECT id, parent_id, name, 0 AS depth FROM catalog_categories WHERE id = '10' UNION ALL SELECT c.id, c.parent_id, c.name, tree.depth + 1 AS depth FROM catalog_categories c INNER JOIN tree ON tree.parent_id = c.id ) SELECT name FROM tree ORDER BY depth DESC LIMIT 1 1 0.000680 false
SELECT db_files.* FROM db_files WHERE (db_files.id = '832') LIMIT 0, 1 1 0.000877 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000375 false
WITH RECURSIVE tree AS ( SELECT id, parent_id, name, 0 AS depth FROM catalog_categories WHERE id = '10' UNION ALL SELECT c.id, c.parent_id, c.name, tree.depth + 1 AS depth FROM catalog_categories c INNER JOIN tree ON tree.parent_id = c.id ) SELECT name FROM tree ORDER BY depth DESC LIMIT 1 1 0.000581 false
SELECT db_files.* FROM db_files WHERE (db_files.id = '829') LIMIT 0, 1 1 0.000466 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000319 false
WITH RECURSIVE tree AS ( SELECT id, parent_id, name, 0 AS depth FROM catalog_categories WHERE id = '10' UNION ALL SELECT c.id, c.parent_id, c.name, tree.depth + 1 AS depth FROM catalog_categories c INNER JOIN tree ON tree.parent_id = c.id ) SELECT name FROM tree ORDER BY depth DESC LIMIT 1 1 0.005008 false
SELECT db_files.* FROM db_files WHERE (db_files.id = '828') LIMIT 0, 1 1 0.000903 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.029704 false
WITH RECURSIVE tree AS ( SELECT id, parent_id, name, 0 AS depth FROM catalog_categories WHERE id = '10' UNION ALL SELECT c.id, c.parent_id, c.name, tree.depth + 1 AS depth FROM catalog_categories c INNER JOIN tree ON tree.parent_id = c.id ) SELECT name FROM tree ORDER BY depth DESC LIMIT 1 1 0.000939 false
SELECT db_files.* FROM db_files WHERE (db_files.id = '813') LIMIT 0, 1 1 0.012096 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.004931 false
WITH RECURSIVE tree AS ( SELECT id, parent_id, name, 0 AS depth FROM catalog_categories WHERE id = '10' UNION ALL SELECT c.id, c.parent_id, c.name, tree.depth + 1 AS depth FROM catalog_categories c INNER JOIN tree ON tree.parent_id = c.id ) SELECT name FROM tree ORDER BY depth DESC LIMIT 1 1 0.000708 false
SELECT db_files.* FROM db_files WHERE (db_files.id = '800') LIMIT 0, 1 1 0.000499 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000632 false
WITH RECURSIVE tree AS ( SELECT id, parent_id, name, 0 AS depth FROM catalog_categories WHERE id = '10' UNION ALL SELECT c.id, c.parent_id, c.name, tree.depth + 1 AS depth FROM catalog_categories c INNER JOIN tree ON tree.parent_id = c.id ) SELECT name FROM tree ORDER BY depth DESC LIMIT 1 1 0.003604 false
SELECT id FROM catalog_categories WHERE LOWER(TRIM(name)) = LOWER(TRIM('Вторичное жилье')) AND (hidden IS NULL OR hidden = 0) AND (deleted IS NULL OR deleted = 0) 3 0.002291 false
SELECT id FROM catalog_product_types WHERE LOWER(TRIM(name)) = LOWER(TRIM('вторичка')) 1 0.000287 false
SELECT MIN(p.price) AS minv, MAX(p.price) AS maxv FROM catalog_products p LEFT JOIN catalog_categories c ON c.id = p.category_id WHERE (p.category_id IN ('10','11','12') OR p.type_id IN ('1')) AND (p.hidden IS NULL OR p.hidden = 0) AND (p.deleted IS NULL OR p.deleted = 0) AND (c.id IS NULL OR (c.hidden IS NULL OR c.hidden = 0)) AND (c.id IS NULL OR (c.deleted IS NULL OR c.deleted = 0)) AND p.price IS NOT NULL AND p.price > 0 1 0.001067 false
SELECT id FROM catalog_category_types WHERE name = 'Город' LIMIT 1 1 0.000359 false
SELECT id, name FROM catalog_categories WHERE category_type_id = '1' AND (hidden IS NULL OR hidden = 0) AND (deleted IS NULL OR deleted = 0) ORDER BY sort_order ASC, name ASC 1 0.000471 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000356 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.006132 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000405 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000321 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000362 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.006547 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000546 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000309 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000310 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000292 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000289 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000293 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.003527 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000410 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000323 false
SELECT admin_module_settings.* FROM admin_module_settings WHERE (admin_module_settings.module_id='admin') AND (admin_module_settings.form_id='default') LIMIT 0, 1 1 0.000865 false
SELECT admin_menus.* FROM admin_menus WHERE (admin_menus.code = 'main') LIMIT 0, 1 1 0.000513 false
SELECT (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.menu_id = '1') AND (admin_menu_items.parent_id is null and (admin_menu_items.is_hidden is null or admin_menu_items.is_hidden=0) and (admin_menu_items.is_hidden_in_menu is null or admin_menu_items.is_hidden_in_menu=0)) ORDER BY group_name, sort_order 6 0.001947 false
SELECT admin_menu_items.* FROM admin_menu_items ORDER BY sort_order 44 0.005039 false
SELECT admin_menus.* FROM admin_menus WHERE (admin_menus.id = '1') LIMIT 0, 1 1 0.000448 false