Объекты | Вторичное жилье
В продаже
4-к. квартира, 70 м²
Вторичное жилье, Сахалинская обл.,г. Южно-Сахалинск,с. Санаторное,ул. Санаторная,д. 23
6,4 млн ₽
Жилая площадь 49 м²
Кухня 9
Этаж 1
Отделка С отделкой
Ипотека ДВ ипотека
О квартире

Возможно приобрести по дальневосточной ипотеке под 2%!


 


Предлагается к продаже 4х комнатная квартира 70 м2 на 1м этаже в с. Санаторное. До центра Южно-Сахалинска 30 минут на машине. В шаговой доступности магазины, детский сад, игровые площадки, скейт парк. До школы ходит школьный автобус. Квартира располагается в панельном доме 138 серии 1984 года постройки. Квартира теплая, светлая, комнаты все изолированные, санузел раздельный, просторная кухня. Мебель остается по договоренности. Квартира без обременений, долей, несовершеннолетних собственников.


 


Специалист по недвижимости Копцева Оксана Владимировна


"Ключ к недвижимости" - нам доверяют тысячи клиентов, которым мы помогли с одобрением ипотеки по самым выгодным условиям. Звоните!

MySQL статистика (20)
Query Rows Time Cached
SET SESSION sql_mode = '' - 0.000058 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.001923 false
SELECT * FROM catalog_categories WHERE deleted is null 10 0.000400 false
SELECT products.* FROM catalog_products as products WHERE products.id = '133' AND products.category_id in ('3', '4', '5', '6', '7', '8', '9', '10', '11', '12') AND products.hidden is null AND products.deleted is null LIMIT 0, 1 1 0.000431 false
SELECT * FROM db_files as files WHERE master_object_class = 'Catalog_Product' AND master_object_id in ('133') 8 0.000382 false
SELECT id, level, parent_id FROM catalog_categories WHERE hidden is null AND deleted is null ORDER BY level ASC 8 0.001418 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.000507 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 ('133') ORDER BY cpa.product_id, ka.sort_order ASC, ka.name ASC 1 0.000579 false
SELECT seo_settings.* FROM seo_settings ORDER BY id desc LIMIT 0, 1 1 0.000353 false
update seo_settings set individual_seo_settings = 'a:0:{}' - 0.000279 false
SELECT db_files.* FROM db_files WHERE (db_files.id = '846') LIMIT 0, 1 1 0.000335 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.000572 false
SELECT action_id, kluch_actions.name, kluch_actions.url, kluch_actions.description FROM kluch_product_actions JOIN kluch_actions ON kluch_product_actions.action_id = kluch_actions.id WHERE product_id = '133' AND kluch_actions.is_active = 1 1 0.000412 false
SELECT name FROM catalog_product_types WHERE id = '1' 1 0.000262 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.000342 false
SELECT admin_menus.* FROM admin_menus WHERE (admin_menus.code = 'main') LIMIT 0, 1 1 0.000356 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.000888 false
SELECT admin_menu_items.* FROM admin_menu_items ORDER BY sort_order 44 0.000647 false
SELECT admin_menus.* FROM admin_menus WHERE (admin_menus.id = '1') LIMIT 0, 1 1 0.000299 false