Компания «Крепость» - агентство недвижимости в Анапе, строительная компания
Недвижимость в Анапе, строительство в Анапе,
квартиры в Анапе, недвижимость от застройщика.

Контактная информация

8 (86133) 60-518
8 988 33-60-518
     60518@mail.ru
Тест для поисковиков и браузеров не поддерживающих плагины

Продажа квартир в Анапе

Ищете квартиры в Анапе? Мы поможем недорого купить недвижимости в Анапе и Анапском районе, это будет гораздо дешевле с учетом траты времени и возможных рисков. В нашем каталоге представлены однокомнатные, двухкомнатные, трехкомнатные квартиры, комнаты, а также дома и коммерческая недвижимость в новостройках и вторичном жилье – смотрите фото и цены!

Вторичное жилье

Поможем купить квартиру на вторичном рынке жилья. Смотрите все предложения, цены и фотографии реальных объектов. 

Дома, Дачи, Коттеджи

Поможем купить дом на вторичном рынке жилья. Смотрите все предложения, цены и фотографии реальных объектов. 

Новостройки

Ищете квартиры в Анапе в новостройках? Посмотрите наш каталог! Мы подбираем для своих покупателей только лучшее – убедитесь сами.

Коммерческая недвижимость

В нашем каталоге коммерческой недвижимости представлены офисы, торговые и производственные помещения, а также отели, гостиницы и рестораны Анапы и анапского района. Все предложения актуальны!

Цена: 8 700 000 рублей
Цена: 5 500 000 рублей

Компания «Крепость»– агентство недвижимости в Анапе и строительная компания. Покупка, продажа домов, квартир, земельных участков, недвижимости в Анапе и Краснодарском крае. Новостройки.Строительство домов и гостиниц в Анапе и на Черноморском побережье.

Компания «Крепость»- на протяжении нескольких лет успешно работает на рынке недвижимости в Анапе и Черноморском побережье Краснодарского края.Основными направлениями деятельности компании является строительство, купля, продажа, недвижимости в г.Анапа такой, как:

Новостройки в Анапе (квартиры от инвесторов, долевое участие, квартиры от застройщика)

Квартиры в Анапе (однокомнатные, двухкомнатные, трехкомнатные, четырехкомнатные многокомнатные малосемейки)

Дома и домовладения в Анапе ( одноэтажные, двухэтажные, трехэтажные и более).

 

Земельные участки в Анапе и Анапском районе (участки для строительства, участки для производства).

Коммерческая недвижимость в Анапе (офисы, производственная недвижимость, отели, гостиницы, торговля, кафе, рестораны).

Аренда квартир в Анапе, домов и коммерческой недвижимости в Анапе .

 

Строительство домов и гостиниц в Анапе. Купить квартиру, дом, земельный участок, коммерческую недвижимость в Анапе и Анапском районе.

2015 © Строительная компания "КРЕПОСТЬ"

Агентство недвижимости, Анапа

Контактная информация Карта сайта Яндекс.Метрика   Разработка интернет-сайтов, мобильных приложений и систем автоматизации
(default) 51 queries took 189 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT COUNT(*) AS `count` FROM `anapakrepost`.`advertisements` AS `Advertisement` WHERE `Advertisement`.`deleted` IS NULL AND `Advertisement`.`rieltor_id` IS NULL AND `Advertisement`.`parsed` = '0'116
2SELECT COUNT(*) AS `count` FROM `anapakrepost`.`advertisements` AS `Advertisement` WHERE `Advertisement`.`deleted` IS NULL AND `Advertisement`.`created` > '2018-06-19 11:59:35' AND `Advertisement`.`parsed` = '0'117
3SELECT `Node`.`id`, `Node`.`parent_id`, `Node`.`user_id`, `Node`.`title`, `Node`.`slug`, `Node`.`body`, `Node`.`excerpt`, `Node`.`status`, `Node`.`mime_type`, `Node`.`comment_status`, `Node`.`comment_count`, `Node`.`promote`, `Node`.`path`, `Node`.`terms`, `Node`.`sticky`, `Node`.`lft`, `Node`.`rght`, `Node`.`visibility_roles`, `Node`.`type`, `Node`.`updated`, `Node`.`created`, `User`.`id`, `User`.`role_id`, `User`.`manager_id`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`email`, `User`.`website`, `User`.`activation_key`, `User`.`image`, `User`.`bio`, `User`.`timezone`, `User`.`status`, `User`.`updated`, `User`.`created`, `User`.`phone` FROM `anapakrepost`.`nodes` AS `Node` LEFT JOIN `anapakrepost`.`users` AS `User` ON (`Node`.`user_id` = `User`.`id`) WHERE `Node`.`status` = '1' AND ((`Node`.`visibility_roles` = '') OR (`Node`.`visibility_roles` LIKE '%\"3\"%')) AND `Node`.`type` = 'blog' ORDER BY `Node`.`id` DESC LIMIT 5000
4SELECT `CategoryParamType`.`id`, `CategoryParamType`.`name`, `CategoryParamType`.`alias`, `CategoryParamType`.`type`, `CategoryParamType`.`data` FROM `anapakrepost`.`category_param_types` AS `CategoryParamType` WHERE `CategoryParamType`.`alias` = 'area' LIMIT 1110
5SELECT `Advertisement`.`id`, `Advertisement`.`contractor_id`, `Advertisement`.`price`, `Advertisement`.`title`, `Advertisement`.`primary`, `Advertisement`.`moderated`, `Advertisement`.`text`, `Advertisement`.`sender_name`, `Advertisement`.`rieltor_id`, `Advertisement`.`note`, `Advertisement`.`state_id`, `Advertisement`.`state_history`, `Advertisement`.`state_confirmed`, `Advertisement`.`sell`, `Advertisement`.`street`, `Advertisement`.`house`, `Advertisement`.`client_phone`, `Advertisement`.`commission`, `Advertisement`.`source_id`, `Advertisement`.`ext_client_phone`, `Advertisement`.`deleted`, `Advertisement`.`id_last_modification_user`, `Advertisement`.`category_id`, `Advertisement`.`date`, `Advertisement`.`phone`, `Advertisement`.`created`, `Advertisement`.`time_of_sale`, `Advertisement`.`show_in_hot`, `Advertisement`.`show_in_new_buildings`, `Advertisement`.`count_views`, `Advertisement`.`native_identifier`, `Advertisement`.`elite`, `Advertisement`.`parsed`, `Advertisement`.`show_in_slider`, ( SELECT CASE WHEN (`pv`.`data_int` IS NOT NULL) THEN `pv`.`data_int` ELSE `pv`.`data_str` END FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` WHERE advertisement_id = `Advertisement`.`id` AND `cpt`.`alias` = 'area' ) AS `Advertisement__area`, `Category`.`title`, `Category`.`id`, `Rieltor`.`id`, `Rieltor`.`role_id`, `Rieltor`.`manager_id`, `Rieltor`.`username`, `Rieltor`.`password`, `Rieltor`.`name`, `Rieltor`.`email`, `Rieltor`.`website`, `Rieltor`.`activation_key`, `Rieltor`.`image`, `Rieltor`.`bio`, `Rieltor`.`timezone`, `Rieltor`.`status`, `Rieltor`.`updated`, `Rieltor`.`created`, `Rieltor`.`phone`, `State`.`id`, `State`.`title`, `State`.`stopped`, `State`.`reset_realtor`, `State`.`parent_id`, `State`.`lft`, `State`.`rght` FROM `anapakrepost`.`advertisements` AS `Advertisement` LEFT JOIN `anapakrepost`.`categories` AS `Category` ON (`Advertisement`.`category_id` = `Category`.`id`) LEFT JOIN `anapakrepost`.`users` AS `Rieltor` ON (`Advertisement`.`rieltor_id` = `Rieltor`.`id`) LEFT JOIN `anapakrepost`.`states` AS `State` ON (`Advertisement`.`state_id` = `State`.`id`) WHERE `show_in_hot` = '1' AND `moderated` = '1' AND `deleted` IS NULL AND `Advertisement`.`parsed` = '0' ORDER BY `Advertisement`.`created` desc LIMIT 1616162
6SELECT `AdvertisementPicture`.`id`, `AdvertisementPicture`.`advertisement_id`, `AdvertisementPicture`.`main`, `AdvertisementPicture`.`picture`, `AdvertisementPicture`.`picture_small` FROM `anapakrepost`.`advertisement_pictures` AS `AdvertisementPicture` WHERE `AdvertisementPicture`.`advertisement_id` IN (62703, 62679, 62151, 62149, 62144, 62122, 61979, 61161, 61160, 61157, 60514, 60513, 60512, 60511, 60510, 60509) ORDER BY `AdvertisementPicture`.`main` desc 2392391
7SELECT `CategoryParamValue`.`id`, `CategoryParamValue`.`advertisement_id`, `CategoryParamValue`.`category_param_id`, `CategoryParamValue`.`data_str`, `CategoryParamValue`.`data_int` FROM `anapakrepost`.`category_param_values` AS `CategoryParamValue` WHERE `CategoryParamValue`.`advertisement_id` IN (62703, 62679, 62151, 62149, 62144, 62122, 61979, 61161, 61160, 61157, 60514, 60513, 60512, 60511, 60510, 60509) 1071071
8SELECT `Advertisement`.`id`, `Advertisement`.`contractor_id`, `Advertisement`.`price`, `Advertisement`.`title`, `Advertisement`.`primary`, `Advertisement`.`moderated`, `Advertisement`.`text`, `Advertisement`.`sender_name`, `Advertisement`.`rieltor_id`, `Advertisement`.`note`, `Advertisement`.`state_id`, `Advertisement`.`state_history`, `Advertisement`.`state_confirmed`, `Advertisement`.`sell`, `Advertisement`.`street`, `Advertisement`.`house`, `Advertisement`.`client_phone`, `Advertisement`.`commission`, `Advertisement`.`source_id`, `Advertisement`.`ext_client_phone`, `Advertisement`.`deleted`, `Advertisement`.`id_last_modification_user`, `Advertisement`.`category_id`, `Advertisement`.`date`, `Advertisement`.`phone`, `Advertisement`.`created`, `Advertisement`.`time_of_sale`, `Advertisement`.`show_in_hot`, `Advertisement`.`show_in_new_buildings`, `Advertisement`.`count_views`, `Advertisement`.`native_identifier`, `Advertisement`.`elite`, `Advertisement`.`parsed`, `Advertisement`.`show_in_slider`, ( SELECT CASE WHEN (`pv`.`data_int` IS NOT NULL) THEN `pv`.`data_int` ELSE `pv`.`data_str` END FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` WHERE advertisement_id = `Advertisement`.`id` AND `cpt`.`alias` = 'area' ) AS `Advertisement__area`, `Category`.`title`, `Category`.`id`, `Rieltor`.`id`, `Rieltor`.`role_id`, `Rieltor`.`manager_id`, `Rieltor`.`username`, `Rieltor`.`password`, `Rieltor`.`name`, `Rieltor`.`email`, `Rieltor`.`website`, `Rieltor`.`activation_key`, `Rieltor`.`image`, `Rieltor`.`bio`, `Rieltor`.`timezone`, `Rieltor`.`status`, `Rieltor`.`updated`, `Rieltor`.`created`, `Rieltor`.`phone`, `State`.`id`, `State`.`title`, `State`.`stopped`, `State`.`reset_realtor`, `State`.`parent_id`, `State`.`lft`, `State`.`rght` FROM `anapakrepost`.`advertisements` AS `Advertisement` LEFT JOIN `anapakrepost`.`categories` AS `Category` ON (`Advertisement`.`category_id` = `Category`.`id`) LEFT JOIN `anapakrepost`.`users` AS `Rieltor` ON (`Advertisement`.`rieltor_id` = `Rieltor`.`id`) LEFT JOIN `anapakrepost`.`states` AS `State` ON (`Advertisement`.`state_id` = `State`.`id`) WHERE `Advertisement`.`moderated` = '1' AND `Advertisement`.`deleted` IS NULL AND `Advertisement`.`parsed` = '0' ORDER BY `Advertisement`.`created` desc LIMIT 5559
9SELECT `AdvertisementPicture`.`id`, `AdvertisementPicture`.`advertisement_id`, `AdvertisementPicture`.`main`, `AdvertisementPicture`.`picture`, `AdvertisementPicture`.`picture_small` FROM `anapakrepost`.`advertisement_pictures` AS `AdvertisementPicture` WHERE `AdvertisementPicture`.`advertisement_id` IN (62739, 62738, 62737, 62736, 62735) ORDER BY `AdvertisementPicture`.`main` desc 44440
10SELECT `CategoryParamValue`.`id`, `CategoryParamValue`.`advertisement_id`, `CategoryParamValue`.`category_param_id`, `CategoryParamValue`.`data_str`, `CategoryParamValue`.`data_int` FROM `anapakrepost`.`category_param_values` AS `CategoryParamValue` WHERE `CategoryParamValue`.`advertisement_id` IN (62739, 62738, 62737, 62736, 62735) 27270
11SELECT `Dictionary`.`id`, `Dictionary`.`model` FROM `anapakrepost`.`dictionaries` AS `Dictionary` WHERE 1 = 120200
12SELECT `CategoryParamType`.`alias`, `CategoryParamType`.`id` FROM `anapakrepost`.`category_param_types` AS `CategoryParamType` WHERE 1 = 128280
13SELECT `AdRegion`.`id`, `AdRegion`.`name` FROM `anapakrepost`.`ad_regions` AS `AdRegion` WHERE 1 = 1 ORDER BY `AdRegion`.`id` ASC38380
14SELECT `LandRegion`.`id`, `LandRegion`.`name` FROM `anapakrepost`.`land_regions` AS `LandRegion` WHERE 1 = 114140
15SELECT `ApartmentType`.`id`, `ApartmentType`.`name` FROM `anapakrepost`.`apartment_types` AS `ApartmentType` WHERE 1 = 1 ORDER BY `ApartmentType`.`lft` ASC220
16SELECT `CommercialType`.`id`, `CommercialType`.`name` FROM `anapakrepost`.`commercial_types` AS `CommercialType` WHERE 1 = 1550
17SELECT `Material`.`id`, `Material`.`name` FROM `anapakrepost`.`materials` AS `Material` WHERE 1 = 1330
18SELECT `ApartmentProject`.`id`, `ApartmentProject`.`name` FROM `anapakrepost`.`apartment_projects` AS `ApartmentProject` WHERE 1 = 114140
19SELECT `Room`.`id`, `Room`.`name` FROM `anapakrepost`.`rooms` AS `Room` WHERE 1 = 1660
20SELECT `State`.`id`, `State`.`title` FROM `anapakrepost`.`states` AS `State` WHERE 1 = 1440
21SELECT `Appointment`.`id`, `Appointment`.`name` FROM `anapakrepost`.`appointments` AS `Appointment` WHERE 1 = 1330
22SELECT `Category`.`id`, `Category`.`title` FROM `anapakrepost`.`categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`lft` ASC10100
23SELECT `Metro`.`id`, `Metro`.`name` FROM `anapakrepost`.`metros` AS `Metro` WHERE 1 = 1 ORDER BY `name` ASC1921921
24SELECT `Source`.`id`, `Source`.`title` FROM `anapakrepost`.`sources` AS `Source` WHERE 1 = 113130
25SELECT `BidStatus`.`id`, `BidStatus`.`name` FROM `anapakrepost`.`bid_statuses` AS `BidStatus` WHERE 1 = 1440
26SELECT `CountryHouseType`.`id`, `CountryHouseType`.`name` FROM `anapakrepost`.`country_house_types` AS `CountryHouseType` WHERE 1 = 1220
27SELECT `BuildingType`.`id`, `BuildingType`.`title` FROM `anapakrepost`.`building_types` AS `BuildingType` WHERE 1 = 1220
28SELECT `WcType`.`id`, `WcType`.`title` FROM `anapakrepost`.`wc_types` AS `WcType` WHERE 1 = 1220
29SELECT `WindowLocation`.`id`, `WindowLocation`.`title` FROM `anapakrepost`.`window_locations` AS `WindowLocation` WHERE 1 = 1220
30SELECT `Location`.`id`, `Location`.`name` FROM `anapakrepost`.`locations` AS `Location` WHERE 1 = 1330
31SELECT `Garage`.`id`, `Garage`.`title` FROM `anapakrepost`.`garages` AS `Garage` WHERE 1 = 1330
32SELECT `Heating`.`id`, `Heating`.`name` FROM `anapakrepost`.`heatings` AS `Heating` WHERE 1 = 1220
33SELECT `CategoryParamType`.`id`, `CategoryParamType`.`name`, `CategoryParamType`.`alias`, `CategoryParamType`.`type`, `CategoryParamType`.`data` FROM `anapakrepost`.`category_param_types` AS `CategoryParamType` WHERE `CategoryParamType`.`alias` = 'rooms_num' LIMIT 1110
34SELECT `Advertisement`.`id`, `Advertisement`.`contractor_id`, `Advertisement`.`price`, `Advertisement`.`title`, `Advertisement`.`primary`, `Advertisement`.`moderated`, `Advertisement`.`text`, `Advertisement`.`sender_name`, `Advertisement`.`rieltor_id`, `Advertisement`.`note`, `Advertisement`.`state_id`, `Advertisement`.`state_history`, `Advertisement`.`state_confirmed`, `Advertisement`.`sell`, `Advertisement`.`street`, `Advertisement`.`house`, `Advertisement`.`client_phone`, `Advertisement`.`commission`, `Advertisement`.`source_id`, `Advertisement`.`ext_client_phone`, `Advertisement`.`deleted`, `Advertisement`.`id_last_modification_user`, `Advertisement`.`category_id`, `Advertisement`.`date`, `Advertisement`.`phone`, `Advertisement`.`created`, `Advertisement`.`time_of_sale`, `Advertisement`.`show_in_hot`, `Advertisement`.`show_in_new_buildings`, `Advertisement`.`count_views`, `Advertisement`.`native_identifier`, `Advertisement`.`elite`, `Advertisement`.`parsed`, `Advertisement`.`show_in_slider`, ( SELECT CASE WHEN (`pv`.`data_int` IS NOT NULL) THEN `pv`.`data_int` ELSE `pv`.`data_str` END FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` WHERE advertisement_id = `Advertisement`.`id` AND `cpt`.`alias` = 'area' ) AS `Advertisement__area`, ( SELECT `ft`.`name` FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` INNER JOIN rooms AS ft ON `ft`.`id` = `pv`.`data_int` WHERE advertisement_id = `Advertisement`.`id` AND `pv`.`data_int` = `ft`.`id` AND `cpt`.`alias` = 'rooms_num' ) AS `Advertisement__rooms_num` FROM `anapakrepost`.`advertisements` AS `Advertisement` WHERE `moderated` = '1' AND `deleted` IS NULL AND `category_id` = 7 AND ( SELECT `ft`.`name` FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` INNER JOIN rooms AS ft ON `ft`.`id` = `pv`.`data_int` WHERE advertisement_id = `Advertisement`.`id` AND `pv`.`data_int` = `ft`.`id` AND `cpt`.`alias` = 'rooms_num' ) = '1-комн.' AND `Advertisement`.`parsed` = '0' ORDER BY `Advertisement`.`created` desc LIMIT 66640
35SELECT `AdvertisementPicture`.`id`, `AdvertisementPicture`.`advertisement_id`, `AdvertisementPicture`.`main`, `AdvertisementPicture`.`picture`, `AdvertisementPicture`.`picture_small` FROM `anapakrepost`.`advertisement_pictures` AS `AdvertisementPicture` WHERE `AdvertisementPicture`.`advertisement_id` IN (62739, 62738, 62737, 62736, 62733, 62731) ORDER BY `AdvertisementPicture`.`main` desc 30300
36SELECT `Advertisement`.`id`, `Advertisement`.`contractor_id`, `Advertisement`.`price`, `Advertisement`.`title`, `Advertisement`.`primary`, `Advertisement`.`moderated`, `Advertisement`.`text`, `Advertisement`.`sender_name`, `Advertisement`.`rieltor_id`, `Advertisement`.`note`, `Advertisement`.`state_id`, `Advertisement`.`state_history`, `Advertisement`.`state_confirmed`, `Advertisement`.`sell`, `Advertisement`.`street`, `Advertisement`.`house`, `Advertisement`.`client_phone`, `Advertisement`.`commission`, `Advertisement`.`source_id`, `Advertisement`.`ext_client_phone`, `Advertisement`.`deleted`, `Advertisement`.`id_last_modification_user`, `Advertisement`.`category_id`, `Advertisement`.`date`, `Advertisement`.`phone`, `Advertisement`.`created`, `Advertisement`.`time_of_sale`, `Advertisement`.`show_in_hot`, `Advertisement`.`show_in_new_buildings`, `Advertisement`.`count_views`, `Advertisement`.`native_identifier`, `Advertisement`.`elite`, `Advertisement`.`parsed`, `Advertisement`.`show_in_slider`, ( SELECT CASE WHEN (`pv`.`data_int` IS NOT NULL) THEN `pv`.`data_int` ELSE `pv`.`data_str` END FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` WHERE advertisement_id = `Advertisement`.`id` AND `cpt`.`alias` = 'area' ) AS `Advertisement__area`, ( SELECT `ft`.`name` FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` INNER JOIN rooms AS ft ON `ft`.`id` = `pv`.`data_int` WHERE advertisement_id = `Advertisement`.`id` AND `pv`.`data_int` = `ft`.`id` AND `cpt`.`alias` = 'rooms_num' ) AS `Advertisement__rooms_num` FROM `anapakrepost`.`advertisements` AS `Advertisement` WHERE `moderated` = '1' AND `deleted` IS NULL AND `category_id` = 7 AND ( SELECT `ft`.`name` FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` INNER JOIN rooms AS ft ON `ft`.`id` = `pv`.`data_int` WHERE advertisement_id = `Advertisement`.`id` AND `pv`.`data_int` = `ft`.`id` AND `cpt`.`alias` = 'rooms_num' ) = '2-комн.' AND `Advertisement`.`parsed` = '0' ORDER BY `Advertisement`.`created` desc LIMIT 66638
37SELECT `AdvertisementPicture`.`id`, `AdvertisementPicture`.`advertisement_id`, `AdvertisementPicture`.`main`, `AdvertisementPicture`.`picture`, `AdvertisementPicture`.`picture_small` FROM `anapakrepost`.`advertisement_pictures` AS `AdvertisementPicture` WHERE `AdvertisementPicture`.`advertisement_id` IN (62707, 62693, 62691, 62684, 62682, 62670) ORDER BY `AdvertisementPicture`.`main` desc 63630
38SELECT `Advertisement`.`id`, `Advertisement`.`contractor_id`, `Advertisement`.`price`, `Advertisement`.`title`, `Advertisement`.`primary`, `Advertisement`.`moderated`, `Advertisement`.`text`, `Advertisement`.`sender_name`, `Advertisement`.`rieltor_id`, `Advertisement`.`note`, `Advertisement`.`state_id`, `Advertisement`.`state_history`, `Advertisement`.`state_confirmed`, `Advertisement`.`sell`, `Advertisement`.`street`, `Advertisement`.`house`, `Advertisement`.`client_phone`, `Advertisement`.`commission`, `Advertisement`.`source_id`, `Advertisement`.`ext_client_phone`, `Advertisement`.`deleted`, `Advertisement`.`id_last_modification_user`, `Advertisement`.`category_id`, `Advertisement`.`date`, `Advertisement`.`phone`, `Advertisement`.`created`, `Advertisement`.`time_of_sale`, `Advertisement`.`show_in_hot`, `Advertisement`.`show_in_new_buildings`, `Advertisement`.`count_views`, `Advertisement`.`native_identifier`, `Advertisement`.`elite`, `Advertisement`.`parsed`, `Advertisement`.`show_in_slider`, ( SELECT CASE WHEN (`pv`.`data_int` IS NOT NULL) THEN `pv`.`data_int` ELSE `pv`.`data_str` END FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` WHERE advertisement_id = `Advertisement`.`id` AND `cpt`.`alias` = 'area' ) AS `Advertisement__area`, ( SELECT `ft`.`name` FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` INNER JOIN rooms AS ft ON `ft`.`id` = `pv`.`data_int` WHERE advertisement_id = `Advertisement`.`id` AND `pv`.`data_int` = `ft`.`id` AND `cpt`.`alias` = 'rooms_num' ) AS `Advertisement__rooms_num` FROM `anapakrepost`.`advertisements` AS `Advertisement` WHERE `moderated` = '1' AND `deleted` IS NULL AND `category_id` = 7 AND ( SELECT `ft`.`name` FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` INNER JOIN rooms AS ft ON `ft`.`id` = `pv`.`data_int` WHERE advertisement_id = `Advertisement`.`id` AND `pv`.`data_int` = `ft`.`id` AND `cpt`.`alias` = 'rooms_num' ) = '3-комн.' AND `Advertisement`.`parsed` = '0' ORDER BY `Advertisement`.`created` desc LIMIT 66641
39SELECT `AdvertisementPicture`.`id`, `AdvertisementPicture`.`advertisement_id`, `AdvertisementPicture`.`main`, `AdvertisementPicture`.`picture`, `AdvertisementPicture`.`picture_small` FROM `anapakrepost`.`advertisement_pictures` AS `AdvertisementPicture` WHERE `AdvertisementPicture`.`advertisement_id` IN (62665, 59469, 58396, 58063, 57690, 57066) ORDER BY `AdvertisementPicture`.`main` desc 70701
40SELECT `Advertisement`.`id`, `Advertisement`.`contractor_id`, `Advertisement`.`price`, `Advertisement`.`title`, `Advertisement`.`primary`, `Advertisement`.`moderated`, `Advertisement`.`text`, `Advertisement`.`sender_name`, `Advertisement`.`rieltor_id`, `Advertisement`.`note`, `Advertisement`.`state_id`, `Advertisement`.`state_history`, `Advertisement`.`state_confirmed`, `Advertisement`.`sell`, `Advertisement`.`street`, `Advertisement`.`house`, `Advertisement`.`client_phone`, `Advertisement`.`commission`, `Advertisement`.`source_id`, `Advertisement`.`ext_client_phone`, `Advertisement`.`deleted`, `Advertisement`.`id_last_modification_user`, `Advertisement`.`category_id`, `Advertisement`.`date`, `Advertisement`.`phone`, `Advertisement`.`created`, `Advertisement`.`time_of_sale`, `Advertisement`.`show_in_hot`, `Advertisement`.`show_in_new_buildings`, `Advertisement`.`count_views`, `Advertisement`.`native_identifier`, `Advertisement`.`elite`, `Advertisement`.`parsed`, `Advertisement`.`show_in_slider`, ( SELECT CASE WHEN (`pv`.`data_int` IS NOT NULL) THEN `pv`.`data_int` ELSE `pv`.`data_str` END FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` WHERE advertisement_id = `Advertisement`.`id` AND `cpt`.`alias` = 'area' ) AS `Advertisement__area`, ( SELECT `ft`.`name` FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` INNER JOIN rooms AS ft ON `ft`.`id` = `pv`.`data_int` WHERE advertisement_id = `Advertisement`.`id` AND `pv`.`data_int` = `ft`.`id` AND `cpt`.`alias` = 'rooms_num' ) AS `Advertisement__rooms_num` FROM `anapakrepost`.`advertisements` AS `Advertisement` WHERE `moderated` = '1' AND `deleted` IS NULL AND `category_id` = 35 AND `Advertisement`.`parsed` = '0' ORDER BY `Advertisement`.`created` desc LIMIT 6661
41SELECT `AdvertisementPicture`.`id`, `AdvertisementPicture`.`advertisement_id`, `AdvertisementPicture`.`main`, `AdvertisementPicture`.`picture`, `AdvertisementPicture`.`picture_small` FROM `anapakrepost`.`advertisement_pictures` AS `AdvertisementPicture` WHERE `AdvertisementPicture`.`advertisement_id` IN (60176, 47690, 47554, 47269, 45127, 40685) ORDER BY `AdvertisementPicture`.`main` desc 25250
42SELECT `Advertisement`.`id`, `Advertisement`.`contractor_id`, `Advertisement`.`price`, `Advertisement`.`title`, `Advertisement`.`primary`, `Advertisement`.`moderated`, `Advertisement`.`text`, `Advertisement`.`sender_name`, `Advertisement`.`rieltor_id`, `Advertisement`.`note`, `Advertisement`.`state_id`, `Advertisement`.`state_history`, `Advertisement`.`state_confirmed`, `Advertisement`.`sell`, `Advertisement`.`street`, `Advertisement`.`house`, `Advertisement`.`client_phone`, `Advertisement`.`commission`, `Advertisement`.`source_id`, `Advertisement`.`ext_client_phone`, `Advertisement`.`deleted`, `Advertisement`.`id_last_modification_user`, `Advertisement`.`category_id`, `Advertisement`.`date`, `Advertisement`.`phone`, `Advertisement`.`created`, `Advertisement`.`time_of_sale`, `Advertisement`.`show_in_hot`, `Advertisement`.`show_in_new_buildings`, `Advertisement`.`count_views`, `Advertisement`.`native_identifier`, `Advertisement`.`elite`, `Advertisement`.`parsed`, `Advertisement`.`show_in_slider`, ( SELECT CASE WHEN (`pv`.`data_int` IS NOT NULL) THEN `pv`.`data_int` ELSE `pv`.`data_str` END FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` WHERE advertisement_id = `Advertisement`.`id` AND `cpt`.`alias` = 'area' ) AS `Advertisement__area`, ( SELECT `ft`.`name` FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` INNER JOIN rooms AS ft ON `ft`.`id` = `pv`.`data_int` WHERE advertisement_id = `Advertisement`.`id` AND `pv`.`data_int` = `ft`.`id` AND `cpt`.`alias` = 'rooms_num' ) AS `Advertisement__rooms_num` FROM `anapakrepost`.`advertisements` AS `Advertisement` WHERE `moderated` = '1' AND `deleted` IS NULL AND `category_id` = 35 AND ( SELECT `ft`.`name` FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` INNER JOIN rooms AS ft ON `ft`.`id` = `pv`.`data_int` WHERE advertisement_id = `Advertisement`.`id` AND `pv`.`data_int` = `ft`.`id` AND `cpt`.`alias` = 'rooms_num' ) = '1-комн.' AND `Advertisement`.`parsed` = '0' ORDER BY `Advertisement`.`created` desc LIMIT 6001
43SELECT `Advertisement`.`id`, `Advertisement`.`contractor_id`, `Advertisement`.`price`, `Advertisement`.`title`, `Advertisement`.`primary`, `Advertisement`.`moderated`, `Advertisement`.`text`, `Advertisement`.`sender_name`, `Advertisement`.`rieltor_id`, `Advertisement`.`note`, `Advertisement`.`state_id`, `Advertisement`.`state_history`, `Advertisement`.`state_confirmed`, `Advertisement`.`sell`, `Advertisement`.`street`, `Advertisement`.`house`, `Advertisement`.`client_phone`, `Advertisement`.`commission`, `Advertisement`.`source_id`, `Advertisement`.`ext_client_phone`, `Advertisement`.`deleted`, `Advertisement`.`id_last_modification_user`, `Advertisement`.`category_id`, `Advertisement`.`date`, `Advertisement`.`phone`, `Advertisement`.`created`, `Advertisement`.`time_of_sale`, `Advertisement`.`show_in_hot`, `Advertisement`.`show_in_new_buildings`, `Advertisement`.`count_views`, `Advertisement`.`native_identifier`, `Advertisement`.`elite`, `Advertisement`.`parsed`, `Advertisement`.`show_in_slider`, ( SELECT CASE WHEN (`pv`.`data_int` IS NOT NULL) THEN `pv`.`data_int` ELSE `pv`.`data_str` END FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` WHERE advertisement_id = `Advertisement`.`id` AND `cpt`.`alias` = 'area' ) AS `Advertisement__area`, ( SELECT `ft`.`name` FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` INNER JOIN rooms AS ft ON `ft`.`id` = `pv`.`data_int` WHERE advertisement_id = `Advertisement`.`id` AND `pv`.`data_int` = `ft`.`id` AND `cpt`.`alias` = 'rooms_num' ) AS `Advertisement__rooms_num` FROM `anapakrepost`.`advertisements` AS `Advertisement` WHERE `moderated` = '1' AND `deleted` IS NULL AND `category_id` = 35 AND ( SELECT `ft`.`name` FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` INNER JOIN rooms AS ft ON `ft`.`id` = `pv`.`data_int` WHERE advertisement_id = `Advertisement`.`id` AND `pv`.`data_int` = `ft`.`id` AND `cpt`.`alias` = 'rooms_num' ) = '2-комн.' AND `Advertisement`.`parsed` = '0' ORDER BY `Advertisement`.`created` desc LIMIT 6001
44SELECT `Advertisement`.`id`, `Advertisement`.`contractor_id`, `Advertisement`.`price`, `Advertisement`.`title`, `Advertisement`.`primary`, `Advertisement`.`moderated`, `Advertisement`.`text`, `Advertisement`.`sender_name`, `Advertisement`.`rieltor_id`, `Advertisement`.`note`, `Advertisement`.`state_id`, `Advertisement`.`state_history`, `Advertisement`.`state_confirmed`, `Advertisement`.`sell`, `Advertisement`.`street`, `Advertisement`.`house`, `Advertisement`.`client_phone`, `Advertisement`.`commission`, `Advertisement`.`source_id`, `Advertisement`.`ext_client_phone`, `Advertisement`.`deleted`, `Advertisement`.`id_last_modification_user`, `Advertisement`.`category_id`, `Advertisement`.`date`, `Advertisement`.`phone`, `Advertisement`.`created`, `Advertisement`.`time_of_sale`, `Advertisement`.`show_in_hot`, `Advertisement`.`show_in_new_buildings`, `Advertisement`.`count_views`, `Advertisement`.`native_identifier`, `Advertisement`.`elite`, `Advertisement`.`parsed`, `Advertisement`.`show_in_slider`, ( SELECT CASE WHEN (`pv`.`data_int` IS NOT NULL) THEN `pv`.`data_int` ELSE `pv`.`data_str` END FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` WHERE advertisement_id = `Advertisement`.`id` AND `cpt`.`alias` = 'area' ) AS `Advertisement__area`, ( SELECT `ft`.`name` FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` INNER JOIN rooms AS ft ON `ft`.`id` = `pv`.`data_int` WHERE advertisement_id = `Advertisement`.`id` AND `pv`.`data_int` = `ft`.`id` AND `cpt`.`alias` = 'rooms_num' ) AS `Advertisement__rooms_num` FROM `anapakrepost`.`advertisements` AS `Advertisement` WHERE `moderated` = '1' AND `deleted` IS NULL AND `category_id` = 35 AND ( SELECT `ft`.`name` FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` INNER JOIN rooms AS ft ON `ft`.`id` = `pv`.`data_int` WHERE advertisement_id = `Advertisement`.`id` AND `pv`.`data_int` = `ft`.`id` AND `cpt`.`alias` = 'rooms_num' ) = '3-комн.' AND `Advertisement`.`parsed` = '0' ORDER BY `Advertisement`.`created` desc LIMIT 6001
45SELECT `Advertisement`.`id`, `Advertisement`.`contractor_id`, `Advertisement`.`price`, `Advertisement`.`title`, `Advertisement`.`primary`, `Advertisement`.`moderated`, `Advertisement`.`text`, `Advertisement`.`sender_name`, `Advertisement`.`rieltor_id`, `Advertisement`.`note`, `Advertisement`.`state_id`, `Advertisement`.`state_history`, `Advertisement`.`state_confirmed`, `Advertisement`.`sell`, `Advertisement`.`street`, `Advertisement`.`house`, `Advertisement`.`client_phone`, `Advertisement`.`commission`, `Advertisement`.`source_id`, `Advertisement`.`ext_client_phone`, `Advertisement`.`deleted`, `Advertisement`.`id_last_modification_user`, `Advertisement`.`category_id`, `Advertisement`.`date`, `Advertisement`.`phone`, `Advertisement`.`created`, `Advertisement`.`time_of_sale`, `Advertisement`.`show_in_hot`, `Advertisement`.`show_in_new_buildings`, `Advertisement`.`count_views`, `Advertisement`.`native_identifier`, `Advertisement`.`elite`, `Advertisement`.`parsed`, `Advertisement`.`show_in_slider`, ( SELECT CASE WHEN (`pv`.`data_int` IS NOT NULL) THEN `pv`.`data_int` ELSE `pv`.`data_str` END FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` WHERE advertisement_id = `Advertisement`.`id` AND `cpt`.`alias` = 'area' ) AS `Advertisement__area`, ( SELECT `ft`.`name` FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` INNER JOIN rooms AS ft ON `ft`.`id` = `pv`.`data_int` WHERE advertisement_id = `Advertisement`.`id` AND `pv`.`data_int` = `ft`.`id` AND `cpt`.`alias` = 'rooms_num' ) AS `Advertisement__rooms_num` FROM `anapakrepost`.`advertisements` AS `Advertisement` WHERE `moderated` = '1' AND `deleted` IS NULL AND `category_id` = 2 AND `Advertisement`.`parsed` = '0' ORDER BY `Advertisement`.`created` desc LIMIT 6669
46SELECT `AdvertisementPicture`.`id`, `AdvertisementPicture`.`advertisement_id`, `AdvertisementPicture`.`main`, `AdvertisementPicture`.`picture`, `AdvertisementPicture`.`picture_small` FROM `anapakrepost`.`advertisement_pictures` AS `AdvertisementPicture` WHERE `AdvertisementPicture`.`advertisement_id` IN (62703, 62643, 48526, 47448, 47094, 37330) ORDER BY `AdvertisementPicture`.`main` desc 50501
47SELECT `Advertisement`.`id`, `Advertisement`.`contractor_id`, `Advertisement`.`price`, `Advertisement`.`title`, `Advertisement`.`primary`, `Advertisement`.`moderated`, `Advertisement`.`text`, `Advertisement`.`sender_name`, `Advertisement`.`rieltor_id`, `Advertisement`.`note`, `Advertisement`.`state_id`, `Advertisement`.`state_history`, `Advertisement`.`state_confirmed`, `Advertisement`.`sell`, `Advertisement`.`street`, `Advertisement`.`house`, `Advertisement`.`client_phone`, `Advertisement`.`commission`, `Advertisement`.`source_id`, `Advertisement`.`ext_client_phone`, `Advertisement`.`deleted`, `Advertisement`.`id_last_modification_user`, `Advertisement`.`category_id`, `Advertisement`.`date`, `Advertisement`.`phone`, `Advertisement`.`created`, `Advertisement`.`time_of_sale`, `Advertisement`.`show_in_hot`, `Advertisement`.`show_in_new_buildings`, `Advertisement`.`count_views`, `Advertisement`.`native_identifier`, `Advertisement`.`elite`, `Advertisement`.`parsed`, `Advertisement`.`show_in_slider`, ( SELECT CASE WHEN (`pv`.`data_int` IS NOT NULL) THEN `pv`.`data_int` ELSE `pv`.`data_str` END FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` WHERE advertisement_id = `Advertisement`.`id` AND `cpt`.`alias` = 'area' ) AS `Advertisement__area`, ( SELECT `ft`.`name` FROM category_param_values AS pv INNER JOIN category_params AS cp ON `pv`.`category_param_id` = `cp`.`id` INNER JOIN category_param_types AS cpt ON `cp`.`category_param_type_id` = `cpt`.`id` INNER JOIN rooms AS ft ON `ft`.`id` = `pv`.`data_int` WHERE advertisement_id = `Advertisement`.`id` AND `pv`.`data_int` = `ft`.`id` AND `cpt`.`alias` = 'rooms_num' ) AS `Advertisement__rooms_num` FROM `anapakrepost`.`advertisements` AS `Advertisement` WHERE `moderated` = '1' AND `deleted` IS NULL AND `category_id` = 4 AND `Advertisement`.`parsed` = '0' ORDER BY `Advertisement`.`created` desc LIMIT 66617
48SELECT `AdvertisementPicture`.`id`, `AdvertisementPicture`.`advertisement_id`, `AdvertisementPicture`.`main`, `AdvertisementPicture`.`picture`, `AdvertisementPicture`.`picture_small` FROM `anapakrepost`.`advertisement_pictures` AS `AdvertisementPicture` WHERE `AdvertisementPicture`.`advertisement_id` IN (62735, 62724, 62723, 62711, 62701, 62695) ORDER BY `AdvertisementPicture`.`main` desc 80801
49SELECT `Category`.`id`, `Category`.`title`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`show_radio` FROM `anapakrepost`.`categories` AS `Category` WHERE `parent_id` = 0 ORDER BY `Category`.`lft` ASC10100
50SELECT `Advertisement`.`category_id` FROM `anapakrepost`.`advertisements` AS `Advertisement` WHERE `Advertisement`.`deleted` IS NULL AND `Advertisement`.`moderated` = '1' AND `Advertisement`.`parsed` = '0' ORDER BY `Advertisement`.`created` desc103510359
51SELECT `CategoryParam`.`id`, `CategoryParam`.`category_id`, `CategoryParam`.`category_param_type_id`, `CategoryParam`.`filter`, `CategoryParam`.`parent_id`, `CategoryParam`.`lft`, `CategoryParam`.`rght`, `CategoryParam`.`required`, `CategoryParam`.`show_in_list`, `CategoryParam`.`use_for_search`, `CategoryParam`.`show_on_main`, `CategoryParam`.`client_can_edit`, `CategoryParam`.`show_in_menu`, `Category`.`id`, `Category`.`title`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`show_radio`, `CategoryParamType`.`id`, `CategoryParamType`.`name`, `CategoryParamType`.`alias`, `CategoryParamType`.`type`, `CategoryParamType`.`data` FROM `anapakrepost`.`category_params` AS `CategoryParam` LEFT JOIN `anapakrepost`.`categories` AS `Category` ON (`CategoryParam`.`category_id` = `Category`.`id`) LEFT JOIN `anapakrepost`.`category_param_types` AS `CategoryParamType` ON (`CategoryParam`.`category_param_type_id` = `CategoryParamType`.`id`) WHERE 1 = 1 ORDER BY `CategoryParam`.`category_id` ASC, `CategoryParam`.`lft` ASC74741