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

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

8 (86133) 60-518
8 988 33-60-518
     60518@mail.ru
Тест для поисковиков и браузеров не поддерживающих плагины
Объект Фото Район Стоимость Подробнее
62707 Продаю 2-х комнатную квартиру в самом центре Анапы Анапа 4 650 000 Подробнее
62693 Продаю 2-х комнатную квартиру Анапа 3 300 000 Подробнее
62691 Продаю 2-х комнатную квартиру в новом доме Анапа 2 900 000 Подробнее
62684 Продаю 2-х комнатную квартиру Анапа 3 300 000 Подробнее
62682 Продаю 2-х комнатную квартиру Анапа 3 500 000 Подробнее
62670 Продаю 2-х комнатную квартиру Анапа 4 950 000 Подробнее
62640 2-комнатная квартира в новом доме с потрясающим видом на город и море! Анапа 3 800 000 Подробнее
62227 Продаю 2-х комнатную квартиру Анапа 3 100 000 Подробнее
62165 Продаю 2-х комнатную квартиру Анапа 2 750 000 Подробнее
62149 2-комнатная квартира на Ленина Анапа 3 950 000 Подробнее
1 2 3 4 5 6 7 8 9
Строительство домов и гостиниц в Анапе. Купить квартиру, дом, земельный участок, коммерческую недвижимость в Анапе и Анапском районе.

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

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

Контактная информация Карта сайта Яндекс.Метрика   Разработка интернет-сайтов, мобильных приложений и систем автоматизации
(default) 40 queries took 72 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'110
2SELECT COUNT(*) AS `count` FROM `anapakrepost`.`advertisements` AS `Advertisement` WHERE `Advertisement`.`deleted` IS NULL AND `Advertisement`.`created` > '2018-06-19 12:01:53' AND `Advertisement`.`parsed` = '0'116
3SELECT `Block`.`id`, `Block`.`region_id`, `Block`.`title`, `Block`.`alias`, `Block`.`body`, `Block`.`show_title`, `Block`.`class`, `Block`.`status`, `Block`.`weight`, `Block`.`element`, `Block`.`visibility_roles`, `Block`.`visibility_paths`, `Block`.`visibility_php`, `Block`.`params`, `Block`.`updated`, `Block`.`created` FROM `anapakrepost`.`blocks` AS `Block` WHERE `Block`.`status` = '1' AND `Block`.`region_id` = 4 AND ((((`Block`.`visibility_roles` = '') OR (`Block`.`visibility_roles` LIKE '%\"3\"%'))) AND (((`Block`.`visibility_paths` = '') OR (`Block`.`visibility_paths` LIKE '%\"/agency/realty/search/q:7;7:3:2;2-%D0%BA%D0%BE%D0%BC%D0%BD.\"%')))) ORDER BY `Block`.`weight` ASC660
4SELECT `Block`.`id`, `Block`.`region_id`, `Block`.`title`, `Block`.`alias`, `Block`.`body`, `Block`.`show_title`, `Block`.`class`, `Block`.`status`, `Block`.`weight`, `Block`.`element`, `Block`.`visibility_roles`, `Block`.`visibility_paths`, `Block`.`visibility_php`, `Block`.`params`, `Block`.`updated`, `Block`.`created` FROM `anapakrepost`.`blocks` AS `Block` WHERE `Block`.`status` = '1' AND `Block`.`region_id` = 19 AND ((((`Block`.`visibility_roles` = '') OR (`Block`.`visibility_roles` LIKE '%\"3\"%'))) AND (((`Block`.`visibility_paths` = '') OR (`Block`.`visibility_paths` LIKE '%\"/agency/realty/search/q:7;7:3:2;2-%D0%BA%D0%BE%D0%BC%D0%BD.\"%')))) ORDER BY `Block`.`weight` ASC110
5SELECT `Block`.`id`, `Block`.`region_id`, `Block`.`title`, `Block`.`alias`, `Block`.`body`, `Block`.`show_title`, `Block`.`class`, `Block`.`status`, `Block`.`weight`, `Block`.`element`, `Block`.`visibility_roles`, `Block`.`visibility_paths`, `Block`.`visibility_php`, `Block`.`params`, `Block`.`updated`, `Block`.`created` FROM `anapakrepost`.`blocks` AS `Block` WHERE `Block`.`status` = '1' AND `Block`.`region_id` = 20 AND ((((`Block`.`visibility_roles` = '') OR (`Block`.`visibility_roles` LIKE '%\"3\"%'))) AND (((`Block`.`visibility_paths` = '') OR (`Block`.`visibility_paths` LIKE '%\"/agency/realty/search/q:7;7:3:2;2-%D0%BA%D0%BE%D0%BC%D0%BD.\"%')))) ORDER BY `Block`.`weight` ASC12120
6SELECT `Block`.`id`, `Block`.`region_id`, `Block`.`title`, `Block`.`alias`, `Block`.`body`, `Block`.`show_title`, `Block`.`class`, `Block`.`status`, `Block`.`weight`, `Block`.`element`, `Block`.`visibility_roles`, `Block`.`visibility_paths`, `Block`.`visibility_php`, `Block`.`params`, `Block`.`updated`, `Block`.`created` FROM `anapakrepost`.`blocks` AS `Block` WHERE `Block`.`status` = '1' AND `Block`.`region_id` = 21 AND ((((`Block`.`visibility_roles` = '') OR (`Block`.`visibility_roles` LIKE '%\"3\"%'))) AND (((`Block`.`visibility_paths` = '') OR (`Block`.`visibility_paths` LIKE '%\"/agency/realty/search/q:7;7:3:2;2-%D0%BA%D0%BE%D0%BC%D0%BD.\"%')))) ORDER BY `Block`.`weight` ASC110
7SELECT `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
8SELECT `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 `category_id` = 7 AND `filter` = '1' ORDER BY `CategoryParam`.`category_id` ASC, `CategoryParam`.`lft` ASC551
9SELECT `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
10SELECT `Role`.`id`, `Role`.`alias` FROM `anapakrepost`.`roles` AS `Role` WHERE 1 = 1880
11SELECT `Category`.`title` FROM `anapakrepost`.`categories` AS `Category` WHERE `id` = 7 ORDER BY `Category`.`lft` ASC LIMIT 1110
12SELECT `Dictionary`.`id`, `Dictionary`.`model` FROM `anapakrepost`.`dictionaries` AS `Dictionary` WHERE 1 = 120200
13SELECT `CategoryParamType`.`alias`, `CategoryParamType`.`id` FROM `anapakrepost`.`category_param_types` AS `CategoryParamType` WHERE 1 = 128280
14SELECT `AdRegion`.`id`, `AdRegion`.`name` FROM `anapakrepost`.`ad_regions` AS `AdRegion` WHERE 1 = 1 ORDER BY `AdRegion`.`id` ASC38380
15SELECT `LandRegion`.`id`, `LandRegion`.`name` FROM `anapakrepost`.`land_regions` AS `LandRegion` WHERE 1 = 114140
16SELECT `ApartmentType`.`id`, `ApartmentType`.`name` FROM `anapakrepost`.`apartment_types` AS `ApartmentType` WHERE 1 = 1 ORDER BY `ApartmentType`.`lft` ASC220
17SELECT `CommercialType`.`id`, `CommercialType`.`name` FROM `anapakrepost`.`commercial_types` AS `CommercialType` WHERE 1 = 1550
18SELECT `Material`.`id`, `Material`.`name` FROM `anapakrepost`.`materials` AS `Material` WHERE 1 = 1330
19SELECT `ApartmentProject`.`id`, `ApartmentProject`.`name` FROM `anapakrepost`.`apartment_projects` AS `ApartmentProject` WHERE 1 = 114140
20SELECT `Room`.`id`, `Room`.`name` FROM `anapakrepost`.`rooms` AS `Room` WHERE 1 = 1660
21SELECT `State`.`id`, `State`.`title` FROM `anapakrepost`.`states` AS `State` WHERE 1 = 1440
22SELECT `Appointment`.`id`, `Appointment`.`name` FROM `anapakrepost`.`appointments` AS `Appointment` WHERE 1 = 1330
23SELECT `Category`.`id`, `Category`.`title` FROM `anapakrepost`.`categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`lft` ASC10100
24SELECT `Metro`.`id`, `Metro`.`name` FROM `anapakrepost`.`metros` AS `Metro` WHERE 1 = 1 ORDER BY `name` ASC1921921
25SELECT `Source`.`id`, `Source`.`title` FROM `anapakrepost`.`sources` AS `Source` WHERE 1 = 113130
26SELECT `BidStatus`.`id`, `BidStatus`.`name` FROM `anapakrepost`.`bid_statuses` AS `BidStatus` WHERE 1 = 1440
27SELECT `CountryHouseType`.`id`, `CountryHouseType`.`name` FROM `anapakrepost`.`country_house_types` AS `CountryHouseType` WHERE 1 = 1220
28SELECT `BuildingType`.`id`, `BuildingType`.`title` FROM `anapakrepost`.`building_types` AS `BuildingType` WHERE 1 = 1220
29SELECT `WcType`.`id`, `WcType`.`title` FROM `anapakrepost`.`wc_types` AS `WcType` WHERE 1 = 1220
30SELECT `WindowLocation`.`id`, `WindowLocation`.`title` FROM `anapakrepost`.`window_locations` AS `WindowLocation` WHERE 1 = 1220
31SELECT `Location`.`id`, `Location`.`name` FROM `anapakrepost`.`locations` AS `Location` WHERE 1 = 1330
32SELECT `Garage`.`id`, `Garage`.`title` FROM `anapakrepost`.`garages` AS `Garage` WHERE 1 = 1330
33SELECT `Heating`.`id`, `Heating`.`name` FROM `anapakrepost`.`heatings` AS `Heating` WHERE 1 = 1220
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`, `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`.`deleted` IS NULL AND `moderated` = '1' AND `Advertisement`.`category_id` = 7 AND ((`Advertisement`.`id` in (select advertisement_id from category_param_values where (category_param_id = 3 AND (data_int = 2)))) or `Advertisement`.`id` not in (select advertisement_id from category_param_values where category_param_id = 3)) AND `Advertisement`.`parsed` = '0' ORDER BY `Advertisement`.`created` desc LIMIT 10101031
35SELECT `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, 62640, 62227, 62165, 62149) ORDER BY `AdvertisementPicture`.`main` desc 91911
36SELECT `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 (62707, 62693, 62691, 62684, 62682, 62670, 62640, 62227, 62165, 62149) 55550
37SELECT COUNT(*) AS `count` 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`) LEFT JOIN `anapakrepost`.`sources` AS `Source` ON (`Advertisement`.`source_id` = `Source`.`id`) LEFT JOIN `anapakrepost`.`users` AS `LastModificationUser` ON (`Advertisement`.`id_last_modification_user` = `LastModificationUser`.`id`) LEFT JOIN `anapakrepost`.`contractors` AS `Contractor` ON (`Advertisement`.`contractor_id` = `Contractor`.`id`) LEFT JOIN `anapakrepost`.`deleting_comments` AS `DeletingComment` ON (`DeletingComment`.`advertisement_id` = `Advertisement`.`id`) WHERE `Advertisement`.`deleted` IS NULL AND `moderated` = '1' AND `Advertisement`.`category_id` = 7 AND ((`Advertisement`.`id` in (select advertisement_id from category_param_values where (category_param_id = 3 AND (data_int = 2)))) or `Advertisement`.`id` not in (select advertisement_id from category_param_values where category_param_id = 3)) AND `Advertisement`.`parsed` = '0'1132
38SELECT `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
39SELECT `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` desc103510350
40SELECT `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` ASC74740