-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Дек 14 2015 г., 18:04
-- Версия сервера: 5.5.46-0+deb7u1-log
-- Версия PHP: 5.3.3-7+squeeze28




--
-- База данных: `web_i`
--

-- --------------------------------------------------------

--
-- Структура таблицы `ivn_address`
--

CREATE TABLE IF NOT EXISTS `ivn_address` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `object_id` int(11) DEFAULT NULL,
  `country` text,
  `region` text,
  `district_region` text,
  `city` text,
  `district` text,
  `city_block` text,
  `street` text,
  `reference_point` text,
  `subway` text,
  PRIMARY KEY (`id`),
  KEY `object_id` (`object_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `ivn_advertising`
--

CREATE TABLE IF NOT EXISTS `ivn_advertising` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `object_id` int(11) DEFAULT NULL,
  `mm_name` text,
  `edition_no` text,
  `date_release` date DEFAULT NULL,
  `price` float DEFAULT NULL,
  `status` text,
  `agent` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `ivn_company_group`
--

CREATE TABLE IF NOT EXISTS `ivn_company_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `ivn_deleted_objects`
--

CREATE TABLE IF NOT EXISTS `ivn_deleted_objects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `db_id` text,
  `subject_id` int(11) DEFAULT NULL,
  `deleted_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Дамп данных таблицы `ivn_deleted_objects`
--

INSERT INTO `ivn_deleted_objects` (`id`, `db_id`, `subject_id`, `deleted_date`) VALUES
(1, 'KIEVDOMP00010000', 25298, '2015-12-14 17:59:01'),
(2, 'KIEVDOMP00010000', 30956, '2015-12-14 17:59:01'),
(3, 'KIEVDOMP00010000', 34269, '2015-12-14 17:59:22'),
(4, 'KIEVDOMP00010000', 48994, '2015-12-14 17:59:22');

-- --------------------------------------------------------

--
-- Структура таблицы `ivn_objects`
--

CREATE TABLE IF NOT EXISTS `ivn_objects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject_id` int(11) DEFAULT NULL,
  `db_id` varchar(16) DEFAULT NULL,
  `sale` int(11) DEFAULT NULL,
  `company_name` text,
  `company_address` text,
  `company_phone` text,
  `updated` int(1) DEFAULT '0',
  `urgently` int(1) DEFAULT '0',
  `view_counter` int(11) DEFAULT '0',
  `date_create` datetime DEFAULT NULL,
  `company_firm_site` text,
  `deal_type` text,
  `deal_no` text,
  `deal_date` date DEFAULT NULL,
  `deal_date_end` date DEFAULT NULL,
  `owner_partner_commission` float DEFAULT NULL,
  `owner_partner_commission_to` float DEFAULT NULL,
  `owner_partner_commission_cond` text,
  `owner_partner_commission_type` int(11) DEFAULT NULL,
  `owner_partner_commission_type_to` int(11) DEFAULT NULL,
  `owner_partner_commission_type_cond` text,
  `owner_partner_commission_type_name` text,
  `owner_is_exclusive` float DEFAULT NULL,
  `terms_sale` text,
  `electricity` text,
  `electric_power` int(11) DEFAULT NULL,
  `electric_power_to` int(11) DEFAULT NULL,
  `electric_power_cond` text,
  `electric_power_unit` text,
  `electric_power_sys_unit` text,
  `ground_area` float DEFAULT NULL,
  `ground_area_to` float DEFAULT NULL,
  `ground_area_cond` text,
  `ground_area_no` text,
  `ground_area_unit` varchar(250) DEFAULT NULL,
  `ground_area_sys_unit` varchar(250) DEFAULT NULL,
  `ground_area_actual` float DEFAULT NULL,
  `ground_area_actual_to` float DEFAULT NULL,
  `ground_area_actual_cond` text,
  `ground_area_actual_unit` text,
  `ground_area_actual_sys_unit` text,
  `ceiling_height_unit` text,
  `ceiling_height_sys_unit` text,
  `distance_to_city` int(11) DEFAULT NULL,
  `distance_to_city_to` int(11) DEFAULT NULL,
  `distance_to_city_cond` text,
  `distance_to_city_unit` text,
  `distance_to_city_sys_unit` text,
  `distance_to_sea` float DEFAULT NULL,
  `distance_to_sea_to` float DEFAULT NULL,
  `distance_to_sea_cond` text,
  `distance_to_sea_unit` text,
  `distance_to_sea_sys_unit` text,
  `garret_height` float DEFAULT NULL,
  `garret_height_to` float DEFAULT NULL,
  `garret_height_cond` text,
  `garret_height_unit` text,
  `garret_height_sys_unit` text,
  `floor_space` float DEFAULT NULL,
  `floor_space_to` float DEFAULT NULL,
  `floor_space_cond` text,
  `floor_area_unit` text,
  `floor_area_sys_unit` text,
  `total_floor_space` float DEFAULT NULL,
  `total_floor_space_to` float DEFAULT NULL,
  `total_floor_space_cond` text,
  `total_floor_area_unit` text,
  `total_floor_area_sys_unit` text,
  `kitchen_floor_space` float DEFAULT NULL,
  `kitchen_floor_space_to` float DEFAULT NULL,
  `kitchen_floor_space_cond` text,
  `kitchen_floor_area_unit` text,
  `kitchen_floor_area_sys_unit` text,
  `kitchen_note` text,
  `hall_floor_space` float DEFAULT NULL,
  `hall_floor_space_to` float DEFAULT NULL,
  `hall_floor_space_cond` text,
  `hall_floor_area_unit` text,
  `hall_floor_area_sys_unit` text,
  `site_space` float DEFAULT NULL,
  `site_space_to` float DEFAULT NULL,
  `site_space_cond` text,
  `site_space_unit` text,
  `site_space_sys_unit` text,
  `space_note` text,
  `urgently_to` int(11) DEFAULT NULL,
  `urgently_cond` text,
  `estate_type` varchar(250) DEFAULT NULL,
  `country` text,
  `region` text,
  `district_region` text,
  `city` varchar(250) DEFAULT NULL,
  `district` text,
  `city_block` text,
  `street` text,
  `subway` text,
  `realty_class` text,
  `backrooms` text,
  `balcony` text,
  `balcony_quantity` int(11) DEFAULT NULL,
  `balcony_quantity_to` int(11) DEFAULT NULL,
  `balcony_quantity_cond` text,
  `loggia` text,
  `loggia_quantity` int(11) DEFAULT NULL,
  `loggia_quantity_to` int(11) DEFAULT NULL,
  `loggia_quantity_cond` text,
  `bathroom_note` text,
  `bay_window_quantity` int(11) DEFAULT NULL,
  `bay_window_quantity_to` int(11) DEFAULT NULL,
  `bay_window_quantity_cond` text,
  `close_cause` text,
  `building_year` int(11) DEFAULT NULL,
  `building_year_to` int(11) DEFAULT NULL,
  `building_year_cond` text,
  `submission_date` date DEFAULT NULL,
  `survey_date` date DEFAULT NULL,
  `defer_to_date` date DEFAULT NULL,
  `deposit_sum` float DEFAULT NULL,
  `deposit_sum_to` float DEFAULT NULL,
  `deposit_sum_cond` text,
  `deposit_sum_currency` text,
  `legal_documents` text,
  `family_quantity` int(11) DEFAULT NULL,
  `family_quantity_to` int(11) DEFAULT NULL,
  `family_quantity_cond` text,
  `fence` text,
  `location` text,
  `flat_no` text,
  `foundation` text,
  `house_no` text,
  `house_type` text,
  `level_quantity` int(11) DEFAULT NULL,
  `level_quantity_to` int(11) DEFAULT NULL,
  `level_quantity_cond` text,
  `floor` int(11) DEFAULT NULL,
  `floor_to` int(11) DEFAULT NULL,
  `floor_cond` text,
  `number_of_storeys` int(11) DEFAULT NULL,
  `number_of_storeys_to` int(11) DEFAULT NULL,
  `number_of_storeys_cond` text,
  `reference_point` text,
  `building_type` text,
  `purpose` text,
  `ground_area_form` text,
  `owner_share` text,
  `property_type` text,
  `price_square` float DEFAULT NULL,
  `price_square_to` float DEFAULT NULL,
  `price_square_cond` text,
  `price_square_currency` text,
  `price` float DEFAULT NULL,
  `price_to` float DEFAULT NULL,
  `price_cond` text,
  `price_currency` text,
  `rent_price_day` float DEFAULT NULL,
  `rent_price_day_to` float DEFAULT NULL,
  `rent_price_day_cond` text,
  `rent_price_day_currency` text,
  `rent_price_month` float DEFAULT NULL,
  `rent_price_month_to` float DEFAULT NULL,
  `rent_price_month_cond` text,
  `rent_price_month_currency` text,
  `access_road` text,
  `terrain_site` text,
  `roof` text,
  `room_quantity` int(11) DEFAULT NULL,
  `room_quantity_to` int(11) DEFAULT NULL,
  `room_quantity_cond` text,
  `room_layout` text,
  `info_source` text,
  `status_date` date DEFAULT NULL,
  `trade_date` date DEFAULT NULL,
  `vacation` text,
  `walling_type` text,
  `window_note` text,
  `flat_type` text,
  `outhouse` text,
  `basement` text,
  `bathroom` text,
  `ceiling_finish` text,
  `front_door_type` text,
  `flooring_underlay` text,
  `floor_topping` text,
  `heat_supply` text,
  `kitchen` text,
  `gas_supply` text,
  `window_location` text,
  `stairs` text,
  `tambour` text,
  `interior_door_type` text,
  `tubing_material` text,
  `walling_finish` text,
  `lavatory_basin` text,
  `water_supply` text,
  `window_material` text,
  `window_view` text,
  `truck_access_road` int(11) DEFAULT NULL,
  `haggle` int(11) DEFAULT NULL,
  `use_for_office` int(11) DEFAULT NULL,
  `flat_layout` int(11) DEFAULT NULL,
  `original_layout` int(11) DEFAULT NULL,
  `parking` int(11) DEFAULT NULL,
  `outhouse_legality` int(11) DEFAULT NULL,
  `registration` int(11) DEFAULT NULL,
  `commercial_outhouse` text,
  `security` text,
  `block_no` text,
  `personal_estate` text,
  `account_in_rent` int(11) DEFAULT NULL,
  `state` int(11) DEFAULT NULL,
  `state_to` int(11) DEFAULT NULL,
  `state_cond` text,
  `term_of_lease` int(11) DEFAULT NULL,
  `term_of_lease_to` int(11) DEFAULT NULL,
  `term_of_lease_cond` text,
  `window_street` text,
  `window_quantity` int(11) DEFAULT NULL,
  `window_quantity_to` int(11) DEFAULT NULL,
  `window_quantity_cond` text,
  `window_front_quantity` int(11) DEFAULT NULL,
  `window_front_quantity_to` int(11) DEFAULT NULL,
  `window_front_quantity_cond` text,
  `terms_exchange` text,
  `registered_count` int(11) DEFAULT NULL,
  `registered_count_to` int(11) DEFAULT NULL,
  `registered_count_cond` text,
  `owner_count` int(11) DEFAULT NULL,
  `owner_count_to` int(11) DEFAULT NULL,
  `owner_count_cond` text,
  `change_only` int(11) DEFAULT NULL,
  `advertising` text,
  `downpayment` float DEFAULT NULL,
  `downpayment_to` float DEFAULT NULL,
  `downpayment_cond` text,
  `gobytype` text,
  `price_zone` int(11) DEFAULT NULL,
  `price_zone_to` int(11) DEFAULT NULL,
  `price_zone_cond` text,
  `building_readiness` int(11) DEFAULT NULL,
  `building_readiness_to` int(11) DEFAULT NULL,
  `building_readiness_cond` text,
  `telephone` text,
  `phone_line_quantity` int(11) DEFAULT NULL,
  `phone_line_quantity_to` int(11) DEFAULT NULL,
  `phone_line_quantity_cond` text,
  `ceiling_height` float DEFAULT NULL,
  `ceiling_height_to` float DEFAULT NULL,
  `ceiling_height_cond` text,
  `sewerage` text,
  `lading` text,
  `main_entrance_location` text,
  `condition2` text,
  `note` text,
  `object_code` text,
  `purpose_land` text,
  `purpose_use` text,
  `newbuilding` int(11) DEFAULT NULL,
  `latitude` float(10,6) DEFAULT NULL,
  `longitude` float(10,6) DEFAULT NULL,
  `fund` int(11) DEFAULT NULL,
  `fund_to` int(11) DEFAULT NULL,
  `fund_cond` text,
  `building_period` int(11) DEFAULT NULL,
  `building_period_to` int(11) DEFAULT NULL,
  `building_period_cond` text,
  `aviso_section_id` int(11) DEFAULT NULL,
  `aviso_section_id_to` int(11) DEFAULT NULL,
  `aviso_section_id_cond` text,
  `aviso_section_type` int(11) DEFAULT NULL,
  `aviso_section_type_to` int(11) DEFAULT NULL,
  `aviso_section_type_cond` text,
  `aviso_adv_type` int(11) DEFAULT NULL,
  `aviso_adv_type_to` int(11) DEFAULT NULL,
  `aviso_adv_type_cond` text,
  `aviso_foreign_city` text,
  `pub_type` text,
  `occupiers_list` text,
  `occupiers` text,
  `builder` text,
  `building_name` text,
  `date_contact` date DEFAULT NULL,
  `goods_name` text,
  `brand` text,
  `model` text,
  `release_year` int(11) DEFAULT NULL,
  `release_year_to` int(11) DEFAULT NULL,
  `release_year_cond` text,
  `goods_condition` text,
  `years_use` int(11) DEFAULT NULL,
  `years_use_to` int(11) DEFAULT NULL,
  `years_use_cond` text,
  `made_in` text,
  `quantity` int(11) DEFAULT NULL,
  `quantity_to` int(11) DEFAULT NULL,
  `quantity_cond` text,
  `mls24_migration` int(11) DEFAULT NULL,
  `mls24_migration_to` int(11) DEFAULT NULL,
  `mls24_migration_cond` text,
  `mls24_media` int(11) DEFAULT NULL,
  `mls24_media_to` int(11) DEFAULT NULL,
  `mls24_media_cond` text,
  `price_owner` float DEFAULT NULL,
  `price_owner_to` float DEFAULT NULL,
  `price_owner_cond` text,
  `bedroom_count` int(11) DEFAULT NULL,
  `bedroom_count_to` int(11) DEFAULT NULL,
  `bedroom_count_cond` text,
  `title` text,
  `description_short` text,
  `description_detail` text,
  `multimedia_link_1` text,
  `multimedia_link_2` text,
  `multimedia_link_3` text,
  `multimedia_link_4` text,
  `hypothec` int(11) DEFAULT NULL,
  `ownership_area` text,
  `encirclement` text,
  `reliability` text,
  `yard` text,
  `floor_plan` int(11) DEFAULT NULL,
  `situational_plan` int(11) DEFAULT NULL,
  `encumbrance` text,
  `bathroom_quantity` int(11) DEFAULT NULL,
  `bathroom_quantity_to` int(11) DEFAULT NULL,
  `bathroom_quantity_cond` text,
  `liquid_object` int(11) DEFAULT NULL,
  `no_commission` int(11) DEFAULT NULL,
  `price_are` float DEFAULT NULL,
  `price_are_to` float DEFAULT NULL,
  `price_are_cond` text,
  `terrace_quantity` int(11) DEFAULT NULL,
  `terrace_quantity_to` int(11) DEFAULT NULL,
  `terrace_quantity_cond` text,
  `terrace_space` float DEFAULT NULL,
  `terrace_space_to` float DEFAULT NULL,
  `terrace_space_cond` text,
  `utilities` text,
  `ownership_date` date DEFAULT NULL,
  `rent_price_square` float DEFAULT NULL,
  `rent_price_square_to` float DEFAULT NULL,
  `rent_price_square_cond` text,
  `rent_price_square_currency` text,
  `homeappliance` text,
  `agent_id` int(11) DEFAULT NULL,
  `agent_id_to` int(11) DEFAULT NULL,
  `agent_id_cond` text,
  `agent_db_id` text,
  `agent_name` text,
  `agent_photo` text,
  `agent_phone` text,
  `agent_phone_mobile` text,
  `agent_icq` text,
  `agent_dept` text,
  `agent_email` text,
  `agent_code` text,
  `agent_last_name` text,
  `agent_first_name` text,
  `sender_db_id` text,
  `modified_date` datetime DEFAULT NULL,
  `sended_date` datetime DEFAULT NULL,
  `is_newbuilding` int(1) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `is_newbuilding_flat` int(1) DEFAULT NULL,
  `client_id` int(10) DEFAULT NULL,
  `is_special_proposal` int(11) DEFAULT NULL,
  `is_special_proposal_to` int(11) DEFAULT NULL,
  `is_special_proposal_cond` text,
  `special_proposal` text,
  `pic` text,
  `doc` text,
  `contact_agent_id` int(11) DEFAULT NULL,
  `contact_agent_id_to` int(11) DEFAULT NULL,
  `contact_agent_id_cond` text,
  `contact_agent_db_id` text,
  `contact_agent_name` text,
  `contact_agent_photo` text,
  `contact_agent_phone` text,
  `contact_agent_phone_mobile` text,
  `contact_agent_icq` text,
  `contact_agent_dept` text,
  `contact_agent_email` text,
  `contact_agent_code` text,
  PRIMARY KEY (`id`),
  KEY `sale` (`sale`),
  KEY `estate_type` (`estate_type`),
  KEY `city` (`city`),
  KEY `ground_area_sys_unit` (`ground_area_sys_unit`),
  KEY `ground_area_unit` (`ground_area_unit`),
  KEY `subject_id` (`subject_id`,`db_id`),
  KEY `client_id` (`client_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

--
-- Дамп данных таблицы `ivn_objects`
--

INSERT INTO `ivn_objects` (`id`, `subject_id`, `db_id`, `sale`, `company_name`, `company_address`, `company_phone`, `updated`, `urgently`, `view_counter`, `date_create`, `company_firm_site`, `deal_type`, `deal_no`, `deal_date`, `deal_date_end`, `owner_partner_commission`, `owner_partner_commission_to`, `owner_partner_commission_cond`, `owner_partner_commission_type`, `owner_partner_commission_type_to`, `owner_partner_commission_type_cond`, `owner_partner_commission_type_name`, `owner_is_exclusive`, `terms_sale`, `electricity`, `electric_power`, `electric_power_to`, `electric_power_cond`, `electric_power_unit`, `electric_power_sys_unit`, `ground_area`, `ground_area_to`, `ground_area_cond`, `ground_area_no`, `ground_area_unit`, `ground_area_sys_unit`, `ground_area_actual`, `ground_area_actual_to`, `ground_area_actual_cond`, `ground_area_actual_unit`, `ground_area_actual_sys_unit`, `ceiling_height_unit`, `ceiling_height_sys_unit`, `distance_to_city`, `distance_to_city_to`, `distance_to_city_cond`, `distance_to_city_unit`, `distance_to_city_sys_unit`, `distance_to_sea`, `distance_to_sea_to`, `distance_to_sea_cond`, `distance_to_sea_unit`, `distance_to_sea_sys_unit`, `garret_height`, `garret_height_to`, `garret_height_cond`, `garret_height_unit`, `garret_height_sys_unit`, `floor_space`, `floor_space_to`, `floor_space_cond`, `floor_area_unit`, `floor_area_sys_unit`, `total_floor_space`, `total_floor_space_to`, `total_floor_space_cond`, `total_floor_area_unit`, `total_floor_area_sys_unit`, `kitchen_floor_space`, `kitchen_floor_space_to`, `kitchen_floor_space_cond`, `kitchen_floor_area_unit`, `kitchen_floor_area_sys_unit`, `kitchen_note`, `hall_floor_space`, `hall_floor_space_to`, `hall_floor_space_cond`, `hall_floor_area_unit`, `hall_floor_area_sys_unit`, `site_space`, `site_space_to`, `site_space_cond`, `site_space_unit`, `site_space_sys_unit`, `space_note`, `urgently_to`, `urgently_cond`, `estate_type`, `country`, `region`, `district_region`, `city`, `district`, `city_block`, `street`, `subway`, `realty_class`, `backrooms`, `balcony`, `balcony_quantity`, `balcony_quantity_to`, `balcony_quantity_cond`, `loggia`, `loggia_quantity`, `loggia_quantity_to`, `loggia_quantity_cond`, `bathroom_note`, `bay_window_quantity`, `bay_window_quantity_to`, `bay_window_quantity_cond`, `close_cause`, `building_year`, `building_year_to`, `building_year_cond`, `submission_date`, `survey_date`, `defer_to_date`, `deposit_sum`, `deposit_sum_to`, `deposit_sum_cond`, `deposit_sum_currency`, `legal_documents`, `family_quantity`, `family_quantity_to`, `family_quantity_cond`, `fence`, `location`, `flat_no`, `foundation`, `house_no`, `house_type`, `level_quantity`, `level_quantity_to`, `level_quantity_cond`, `floor`, `floor_to`, `floor_cond`, `number_of_storeys`, `number_of_storeys_to`, `number_of_storeys_cond`, `reference_point`, `building_type`, `purpose`, `ground_area_form`, `owner_share`, `property_type`, `price_square`, `price_square_to`, `price_square_cond`, `price_square_currency`, `price`, `price_to`, `price_cond`, `price_currency`, `rent_price_day`, `rent_price_day_to`, `rent_price_day_cond`, `rent_price_day_currency`, `rent_price_month`, `rent_price_month_to`, `rent_price_month_cond`, `rent_price_month_currency`, `access_road`, `terrain_site`, `roof`, `room_quantity`, `room_quantity_to`, `room_quantity_cond`, `room_layout`, `info_source`, `status_date`, `trade_date`, `vacation`, `walling_type`, `window_note`, `flat_type`, `outhouse`, `basement`, `bathroom`, `ceiling_finish`, `front_door_type`, `flooring_underlay`, `floor_topping`, `heat_supply`, `kitchen`, `gas_supply`, `window_location`, `stairs`, `tambour`, `interior_door_type`, `tubing_material`, `walling_finish`, `lavatory_basin`, `water_supply`, `window_material`, `window_view`, `truck_access_road`, `haggle`, `use_for_office`, `flat_layout`, `original_layout`, `parking`, `outhouse_legality`, `registration`, `commercial_outhouse`, `security`, `block_no`, `personal_estate`, `account_in_rent`, `state`, `state_to`, `state_cond`, `term_of_lease`, `term_of_lease_to`, `term_of_lease_cond`, `window_street`, `window_quantity`, `window_quantity_to`, `window_quantity_cond`, `window_front_quantity`, `window_front_quantity_to`, `window_front_quantity_cond`, `terms_exchange`, `registered_count`, `registered_count_to`, `registered_count_cond`, `owner_count`, `owner_count_to`, `owner_count_cond`, `change_only`, `advertising`, `downpayment`, `downpayment_to`, `downpayment_cond`, `gobytype`, `price_zone`, `price_zone_to`, `price_zone_cond`, `building_readiness`, `building_readiness_to`, `building_readiness_cond`, `telephone`, `phone_line_quantity`, `phone_line_quantity_to`, `phone_line_quantity_cond`, `ceiling_height`, `ceiling_height_to`, `ceiling_height_cond`, `sewerage`, `lading`, `main_entrance_location`, `condition2`, `note`, `object_code`, `purpose_land`, `purpose_use`, `newbuilding`, `latitude`, `longitude`, `fund`, `fund_to`, `fund_cond`, `building_period`, `building_period_to`, `building_period_cond`, `aviso_section_id`, `aviso_section_id_to`, `aviso_section_id_cond`, `aviso_section_type`, `aviso_section_type_to`, `aviso_section_type_cond`, `aviso_adv_type`, `aviso_adv_type_to`, `aviso_adv_type_cond`, `aviso_foreign_city`, `pub_type`, `occupiers_list`, `occupiers`, `builder`, `building_name`, `date_contact`, `goods_name`, `brand`, `model`, `release_year`, `release_year_to`, `release_year_cond`, `goods_condition`, `years_use`, `years_use_to`, `years_use_cond`, `made_in`, `quantity`, `quantity_to`, `quantity_cond`, `mls24_migration`, `mls24_migration_to`, `mls24_migration_cond`, `mls24_media`, `mls24_media_to`, `mls24_media_cond`, `price_owner`, `price_owner_to`, `price_owner_cond`, `bedroom_count`, `bedroom_count_to`, `bedroom_count_cond`, `title`, `description_short`, `description_detail`, `multimedia_link_1`, `multimedia_link_2`, `multimedia_link_3`, `multimedia_link_4`, `hypothec`, `ownership_area`, `encirclement`, `reliability`, `yard`, `floor_plan`, `situational_plan`, `encumbrance`, `bathroom_quantity`, `bathroom_quantity_to`, `bathroom_quantity_cond`, `liquid_object`, `no_commission`, `price_are`, `price_are_to`, `price_are_cond`, `terrace_quantity`, `terrace_quantity_to`, `terrace_quantity_cond`, `terrace_space`, `terrace_space_to`, `terrace_space_cond`, `utilities`, `ownership_date`, `rent_price_square`, `rent_price_square_to`, `rent_price_square_cond`, `rent_price_square_currency`, `homeappliance`, `agent_id`, `agent_id_to`, `agent_id_cond`, `agent_db_id`, `agent_name`, `agent_photo`, `agent_phone`, `agent_phone_mobile`, `agent_icq`, `agent_dept`, `agent_email`, `agent_code`, `agent_last_name`, `agent_first_name`, `sender_db_id`, `modified_date`, `sended_date`, `is_newbuilding`, `parent_id`, `is_newbuilding_flat`, `client_id`, `is_special_proposal`, `is_special_proposal_to`, `is_special_proposal_cond`, `special_proposal`, `pic`, `doc`, `contact_agent_id`, `contact_agent_id_to`, `contact_agent_id_cond`, `contact_agent_db_id`, `contact_agent_name`, `contact_agent_photo`, `contact_agent_phone`, `contact_agent_phone_mobile`, `contact_agent_icq`, `contact_agent_dept`, `contact_agent_email`, `contact_agent_code`) VALUES
(1, 5754, 'KIEVDOMP00010000', 0, 'Агентство недвижимости "Владис"', 'г. Владимир, пр-т Ленина, д.48', '(4922) 44-44-11', 0, NULL, 0, '2015-12-14 17:58:35', NULL, NULL, NULL, NULL, NULL, 50, NULL, NULL, 1, NULL, NULL, '%', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'м', 'm', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 43, NULL, NULL, 'кв.м', 'm2', 60, NULL, NULL, 'кв.м', 'm2', 5.6, NULL, NULL, 'кв.м', 'm2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Квартира', 'Россия', 'Владимирская обл.', 'Судогодский р-он', 'Андреево пгт.', NULL, NULL, 'Первомайская ул.', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-11-26', NULL, NULL, NULL, NULL, NULL, NULL, 'свидетельство о гос.регистрации', NULL, NULL, NULL, NULL, 'Не угловая', NULL, NULL, '15', 'брежневка', NULL, NULL, NULL, 2, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 13333.3, NULL, NULL, 'руб.', 800000, NULL, NULL, 'руб.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, 'смежно-раздельная', NULL, NULL, NULL, NULL, 'subtag', NULL, 'отдельная', NULL, NULL, 'subtag', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'чистая продажа', 0, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'не угловая, чистая продажа, балкон, кирпичный дом, комнаты на разные стороны, требует ремонта', '4498', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'нет', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1000035, NULL, NULL, 'KIEVDOMP00010000', 'Евстигнеев Лев Васильевич', NULL, '44-44-17', '8-910-670-45-24', NULL, 'офис Ленинское', NULL, '229', NULL, 'Лев', 'KIEVDOMP00010000', '2015-12-14 17:58:36', '2015-12-14 17:58:36', 0, 0, 0, 1, NULL, NULL, NULL, NULL, 'subtag', NULL, 34, NULL, NULL, 'KIEVDOMP00010000', 'Никерова Виктория Юрьевна', NULL, NULL, '8-920-909-68-00', NULL, NULL, NULL, '403'),
(2, 6301, 'KIEVDOMP00010000', 0, 'Агентство недвижимости "Владис"', 'г. Владимир, пр-т Ленина, д.48', '(4922) 44-44-11', 0, NULL, 0, '2015-12-14 17:58:36', NULL, NULL, NULL, NULL, NULL, 50, NULL, NULL, 1, NULL, NULL, '%', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'м', 'm', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 44, NULL, NULL, 'кв.м', 'm2', 71, NULL, NULL, 'кв.м', 'm2', 9, NULL, NULL, 'кв.м', 'm2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '17+15+12', NULL, NULL, 'Квартира', 'Россия', 'Владимирская обл.', 'Судогодский р-он', 'Андреево пгт.', NULL, NULL, 'Первомайская ул.', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2011-02-14', NULL, NULL, NULL, NULL, NULL, NULL, 'свидетельство о гос.регистрации', NULL, NULL, NULL, NULL, 'Угловая', NULL, NULL, '19', 'чешский проект', NULL, NULL, NULL, 5, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11971.8, NULL, NULL, 'руб.', 850000, NULL, NULL, 'руб.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, 'раздельная', NULL, NULL, NULL, NULL, 'subtag', NULL, 'отдельная', NULL, NULL, 'subtag', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'чистая продажа', 0, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'двойная лоджия, с/у раздельный, хорошее состояние, тёплая, документы все готовы, чистая продажа', '5014', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'нет', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1000035, NULL, NULL, 'KIEVDOMP00010000', 'Евстигнеев Лев Васильевич', NULL, '44-44-17', '8-910-670-45-24', NULL, 'офис Ленинское', NULL, '229', NULL, 'Лев', 'KIEVDOMP00010000', '2015-12-14 17:58:36', '2015-12-14 17:58:36', 0, 0, 0, 2, NULL, NULL, NULL, NULL, 'subtag', NULL, 34, NULL, NULL, 'KIEVDOMP00010000', 'Никерова Виктория Юрьевна', NULL, NULL, '8-920-909-68-00', NULL, NULL, NULL, '403'),
(3, 6308, 'KIEVDOMP00010000', 0, 'Агентство недвижимости "Владис"', 'г. Владимир, пр-т Ленина, д.48', '(4922) 44-44-11', 0, NULL, 0, '2015-12-14 17:58:36', NULL, NULL, NULL, NULL, NULL, 50, NULL, NULL, 1, NULL, NULL, '%', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'м', 'm', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 17.5, NULL, NULL, 'кв.м', 'm2', 32.3, NULL, NULL, 'кв.м', 'm2', 5.6, NULL, NULL, 'кв.м', 'm2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '17.5', NULL, NULL, 'Квартира', 'Россия', 'Владимирская обл.', 'Судогодский р-он', 'Андреево пгт.', NULL, NULL, 'Первомайская ул.', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2011-02-14', NULL, NULL, NULL, NULL, NULL, NULL, 'свидетельство о гос.регистрации', NULL, NULL, NULL, NULL, 'Не угловая', NULL, NULL, '5', 'хрущевка', NULL, NULL, NULL, 4, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 17027.9, NULL, NULL, 'руб.', 550000, NULL, NULL, 'руб.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 'раздельная', NULL, NULL, NULL, NULL, 'subtag', NULL, 'отдельная', NULL, NULL, 'subtag', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'чистая продажа', 0, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'не угловая, кирп. дом, крыша коньком, обычное состояние', '5021', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'нет', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1000035, NULL, NULL, 'KIEVDOMP00010000', 'Евстигнеев Лев Васильевич', NULL, '44-44-17', '8-910-670-45-24', NULL, 'офис Ленинское', NULL, '229', NULL, 'Лев', 'KIEVDOMP00010000', '2015-12-14 17:58:36', '2015-12-14 17:58:36', 0, 0, 0, 3, NULL, NULL, NULL, NULL, 'subtag', NULL, 34, NULL, NULL, 'KIEVDOMP00010000', 'Никерова Виктория Юрьевна', NULL, NULL, '8-920-909-68-00', NULL, NULL, NULL, '403'),
(4, 8400, 'KIEVDOMP00010000', 0, 'Агентство недвижимости "Владис"', 'г. Владимир, пр-т Ленина, д.48', '(4922) 44-44-11', 0, NULL, 0, '2015-12-14 17:58:36', NULL, NULL, NULL, NULL, NULL, 50, NULL, NULL, 1, NULL, NULL, '%', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'м', 'm', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 134.4, NULL, NULL, 'кв.м', 'm2', 250.7, NULL, NULL, 'кв.м', 'm2', 17.5, NULL, NULL, 'кв.м', 'm2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Квартира', 'Россия', 'Владимирская обл.', 'Владимир', 'Владимир', 'Ленинский р-он', NULL, 'Чайковского ул.', NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1996, NULL, NULL, '2011-09-29', NULL, NULL, NULL, NULL, NULL, NULL, 'готовы', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '25 - А', 'элитный дом', NULL, NULL, NULL, 8, NULL, NULL, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 51854.8, NULL, NULL, 'руб.', 13000000, NULL, NULL, 'руб.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'subtag', NULL, 'отдельная', NULL, NULL, 'subtag', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'чистая продажа', 0, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, 'Чайковского ул., кв-ру  улучшен. планировки,  в двух уровнях, два  с/узла,  с душевой кабиной и ванной,  по две лоджии на этаже, в отличном состоянии,  вложений  не требует, огороженная тер-я, парковка, документы готовы, продаю.', '7008', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 'нет', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 37, NULL, NULL, 'KIEVDOMP00010000', 'Лиханова Татьяна Николаевна', NULL, '44-44-15', '8-919-023-89-77', NULL, 'офис Октябрьское', NULL, '213', NULL, 'Татьяна', 'KIEVDOMP00010000', '2015-12-14 17:58:36', '2015-12-14 17:58:36', 0, 0, 0, 4, NULL, NULL, NULL, NULL, 'subtag', NULL, 34, NULL, NULL, 'KIEVDOMP00010000', 'Никерова Виктория Юрьевна', NULL, NULL, '8-920-909-68-00', NULL, NULL, NULL, '403'),
(5, 18897, 'KIEVDOMP00010000', 0, 'Агентство недвижимости "Владис"', 'г. Владимир, пр-т Ленина, д.48', '(4922) 44-44-11', 0, NULL, 0, '2015-12-14 17:58:36', NULL, 'Эксклюзивный договор', NULL, '2013-05-23', NULL, 100, NULL, NULL, 1, NULL, NULL, '%', 1, NULL, 'subtag', NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 'сот.', 'are', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 'км', 'km', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 'кв.м', 'm2', 200, NULL, NULL, 'кв.м', 'm2', 0, NULL, NULL, 'кв.м', 'm2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Дом', 'Россия', 'Владимирская обл.', 'Владимир', 'Владимир', 'Заклязьменский', NULL, 'Сосновая ул.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-05-29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '53', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 'Таунхаус', NULL, NULL, 'Полная', NULL, NULL, NULL, NULL, NULL, 8500000, NULL, NULL, 'руб.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'асфальт', NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'subtag', NULL, NULL, NULL, NULL, 'subtag', NULL, NULL, NULL, NULL, 'subtag', NULL, 'subtag', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'subtag', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'subtag', 'Таунхаусе в трех уровнях со строительной отделкой и гаражом.\nТаунхаус находится в жилом комплексе "Ладога", который расположился в сосновом бору на высоком берегу реки Клязьма (Старица), район турбаза "Ладога" (Заклязменский район города Владимир). \nХороший круглогодичный подъезд - асфальтовая дорога.\nКруглосуточная охрана жилого комплекса.', '16512', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Коттеджный поселок', NULL, NULL, NULL, NULL, 'нет', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1000719, NULL, NULL, 'KIEVDOMP00010000', 'загородная недвижимость', NULL, '8(4922)778-000', NULL, NULL, 'Загородная недвижимость', NULL, '1131', NULL, NULL, 'KIEVDOMP00010000', '2015-12-14 17:58:36', '2015-12-14 17:58:36', 0, 0, 0, 5, NULL, NULL, NULL, NULL, 'subtag', NULL, 34, NULL, NULL, 'KIEVDOMP00010000', 'Никерова Виктория Юрьевна', NULL, NULL, '8-920-909-68-00', NULL, NULL, NULL, '403'),
(6, 18898, 'KIEVDOMP00010000', 0, 'Агентство недвижимости "Владис"', 'г. Владимир, пр-т Ленина, д.48', '(4922) 44-44-11', 0, NULL, 0, '2015-12-14 17:59:01', NULL, 'Эксклюзивный договор', NULL, '2013-05-23', NULL, 100, NULL, NULL, 1, NULL, NULL, '%', 1, NULL, 'subtag', NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 'сот.', 'are', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 'км', 'km', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 'кв.м', 'm2', 200, NULL, NULL, 'кв.м', 'm2', 0, NULL, NULL, 'кв.м', 'm2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Дом', 'Россия', 'Владимирская обл.', 'Владимир', 'Владимир', 'Заклязьменский', NULL, 'Сосновая ул.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-05-29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '42', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 'Таунхаус', NULL, NULL, 'Полная', NULL, NULL, NULL, NULL, NULL, 11000000, NULL, NULL, 'руб.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'асфальт', NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'subtag', NULL, NULL, NULL, NULL, 'subtag', NULL, NULL, NULL, NULL, 'subtag', NULL, 'subtag', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'subtag', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'subtag', 'Продам таунхаус, с хорошей отделкой под ключ -"заезжай и живи". Полностью оборудованная кухня со встроенной бытовой техникой, 3 шкафа купе, два санузля, индивидуальная система отопления, гараж, благоустроенная прилегающая территория. \nТаунхаус расположен в черте города Владимир Заклязьменский район, в 10 минутах от центра в жилом комплексе "Ладога".  Поселок окружен сосновым лесом, находится на берегу живописного водоема.\nКруглосуточная охрана жилого комплекса. заселен на 70%.', '16513', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Коттеджный поселок', NULL, NULL, NULL, NULL, 'нет', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1000719, NULL, NULL, 'KIEVDOMP00010000', 'загородная недвижимость', NULL, '8(4922)778-000', NULL, NULL, 'Загородная недвижимость', NULL, '1131', NULL, NULL, 'KIEVDOMP00010000', '2015-12-14 17:59:01', '2015-12-14 17:59:01', 0, 0, 0, 5, NULL, NULL, NULL, NULL, 'subtag', NULL, 34, NULL, NULL, 'KIEVDOMP00010000', 'Никерова Виктория Юрьевна', NULL, NULL, '8-920-909-68-00', NULL, NULL, NULL, '403'),
(7, 18899, 'KIEVDOMP00010000', 0, 'Агентство недвижимости "Владис"', 'г. Владимир, пр-т Ленина, д.48', '(4922) 44-44-11', 0, NULL, 0, '2015-12-14 17:59:01', NULL, 'Эксклюзивный договор', NULL, '2013-05-23', NULL, 100, NULL, NULL, 1, NULL, NULL, '%', 1, NULL, 'subtag', NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 'сот.', 'are', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 'км', 'km', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 'кв.м', 'm2', 200, NULL, NULL, 'кв.м', 'm2', 0, NULL, NULL, 'кв.м', 'm2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Дом', 'Россия', 'Владимирская обл.', 'Владимир', 'Владимир', 'Заклязьменский', NULL, 'Сосновая ул.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-05-29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '50', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 'Таунхаус', NULL, NULL, 'Полная', NULL, NULL, NULL, NULL, NULL, 11800000, NULL, NULL, 'руб.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'асфальт', NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'subtag', NULL, NULL, NULL, NULL, 'subtag', NULL, NULL, NULL, NULL, 'subtag', NULL, 'subtag', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'subtag', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'subtag', 'Продам таунхаус, с хорошей отделкой под ключ -"заезжай и живи". Полностью оборудованная кухня со встроенной бытовой техникой, 3 шкафа купе, два санузля, индивидуальная система отопления, гараж, благоустроенная прилегающая территория. \nТаунхаус расположен в черте города Владимир Заклязьменский район, в 10 минутах от центра в жилом комплексе "Ладога".  Поселок окружен сосновым лесом, находится на берегу живописного водоема.\nКруглосуточная охрана жилого комплекса. заселен на 70%.', '16514', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Коттеджный поселок', NULL, NULL, NULL, NULL, 'нет', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1000719, NULL, NULL, 'KIEVDOMP00010000', 'загородная недвижимость', NULL, '8(4922)778-000', NULL, NULL, 'Загородная недвижимость', NULL, '1131', NULL, NULL, 'KIEVDOMP00010000', '2015-12-14 17:59:01', '2015-12-14 17:59:01', 0, 0, 0, 5, NULL, NULL, NULL, NULL, 'subtag', NULL, 34, NULL, NULL, 'KIEVDOMP00010000', 'Никерова Виктория Юрьевна', NULL, NULL, '8-920-909-68-00', NULL, NULL, NULL, '403'),
(8, 18900, 'KIEVDOMP00010000', 0, 'Агентство недвижимости "Владис"', 'г. Владимир, пр-т Ленина, д.48', '(4922) 44-44-11', 0, NULL, 0, '2015-12-14 17:59:01', NULL, 'Эксклюзивный договор', NULL, '2013-05-23', NULL, 100, NULL, NULL, 1, NULL, NULL, '%', 1, NULL, 'subtag', NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 'сот.', 'are', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 'км', 'km', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 'кв.м', 'm2', 200, NULL, NULL, 'кв.м', 'm2', 0, NULL, NULL, 'кв.м', 'm2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Дом', 'Россия', 'Владимирская обл.', 'Владимир', 'Владимир', 'Заклязьменский', NULL, 'Сосновая ул.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-05-29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '28-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 'Таунхаус', NULL, NULL, 'Полная', NULL, NULL, NULL, NULL, NULL, 8500000, NULL, NULL, 'руб.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'асфальт', NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'subtag', NULL, NULL, NULL, NULL, 'subtag', NULL, NULL, NULL, NULL, 'subtag', NULL, 'subtag', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'subtag', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'subtag', 'Продам квартиру в таунхаусе, в трех уровнях со строительной отделкой,  расположенную в черте города Владимир, в 10 минутах от центра в жилом комплексе.  \nВ дом заведенны все коммуникации электричество, газ, вода, канализация. В доме разведена система отопления и установлен 2-ух контурный котел.\nКоттедж с видом на сосновый бор. \nПоселок окружен сосновым лесом, находится на берегу живописного водоема на месте бывшего пионерского лагеря. Круглосуточная охрана жилого комплекса.', '16515', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Коттеджный поселок', NULL, NULL, NULL, NULL, 'нет', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1000719, NULL, NULL, 'KIEVDOMP00010000', 'загородная недвижимость', NULL, '8(4922)778-000', NULL, NULL, 'Загородная недвижимость', NULL, '1131', NULL, NULL, 'KIEVDOMP00010000', '2015-12-14 17:59:01', '2015-12-14 17:59:01', 0, 0, 0, 5, NULL, NULL, NULL, NULL, 'subtag', NULL, 34, NULL, NULL, 'KIEVDOMP00010000', 'Никерова Виктория Юрьевна', NULL, NULL, '8-920-909-68-00', NULL, NULL, NULL, '403'),
(9, 25298, 'KIEVDOMP00010000', 1, 'Агентство недвижимости "Владис"', 'г. Владимир, пр-т Ленина, д.48', '(4922) 44-44-11', 0, NULL, 0, '2015-12-14 17:59:01', NULL, NULL, NULL, '2015-02-11', NULL, 50, NULL, NULL, 1, NULL, NULL, '%', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 150, NULL, NULL, 'кв.м', 'm2', 190, NULL, NULL, 'кв.м', 'm2', 25, NULL, NULL, 'кв.м', 'm2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Квартира', 'Россия', 'Владимирская обл.', 'Владимир', 'Владимир', 'Заклязьменский', NULL, 'Сосновая ул.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-10-01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '54А', NULL, NULL, NULL, NULL, 1, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 70000, NULL, NULL, 'руб.', NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'subtag', NULL, 'многоуровневая', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'subtag', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Таунхаус в коттеджном поселке "Ладога". Новый, ранее никто не жил. Имеется встроенная кухня, холодильник, газовая плита, встроенные шкафы - купе. 3-х уровневый дом + гараж, 2 сотки земли , автономное отопление (2-х контурный газовый котел), цифровое телевидение и интернет. Сдается порядочным людям на длительный срок. Без комиссии.', '20313', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1000199, NULL, NULL, 'KIEVDOMP00010000', 'отдел аренды', NULL, '44-44-11', '8-904-595-56-11', NULL, 'Аренда', NULL, '124', NULL, NULL, 'KIEVDOMP00010000', '2015-12-14 17:59:01', '2015-12-14 17:59:01', 0, 0, 0, 6, 1, NULL, NULL, NULL, 'subtag', NULL, 34, NULL, NULL, 'KIEVDOMP00010000', 'Никерова Виктория Юрьевна', NULL, NULL, '8-920-909-68-00', NULL, NULL, NULL, '403'),
(10, 30956, 'KIEVDOMP00010000', 1, 'Агентство недвижимости "Владис"', 'г. Владимир, пр-т Ленина, д.48', '(4922) 44-44-11', 0, 1, 0, '2015-12-14 17:59:01', NULL, NULL, NULL, NULL, NULL, 50, NULL, NULL, 1, NULL, NULL, '%', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 40, NULL, NULL, 'кв.м', 'm2', 50, NULL, NULL, 'кв.м', 'm2', 10, NULL, NULL, 'кв.м', 'm2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Квартира', 'Россия', 'Владимирская обл.', 'Владимир', 'Владимир', 'Октябрьский р-он', NULL, 'Лакина ул.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2014-02-06', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '153а', NULL, NULL, NULL, NULL, 9, NULL, NULL, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14000, NULL, NULL, 'руб.', NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, '2014-12-15', NULL, NULL, 'subtag', NULL, 'отдельная', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'subtag', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Имеется вся необходимая для комфортного проживания мебель и техника.Окна ПВХ.В данный момент нет стиральной машины.Квартира на продаже.В стоимость уже включены коммунальные услуги.', '24322', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1000320, NULL, NULL, 'KIEVDOMP00010000', 'Овчинникова Анна Владимировна', NULL, '37-71-37', '8-904-959-57-88', NULL, 'Аренда', NULL, '120', NULL, 'Анна', 'KIEVDOMP00010000', '2015-12-14 17:59:01', '2015-12-14 17:59:01', 0, 0, 0, 7, NULL, NULL, NULL, NULL, 'subtag', NULL, 34, NULL, NULL, 'KIEVDOMP00010000', 'Никерова Виктория Юрьевна', NULL, NULL, '8-920-909-68-00', NULL, NULL, NULL, '403'),
(11, 34269, 'KIEVDOMP00010000', 1, 'Агентство недвижимости "Владис"', 'г. Владимир, пр-т Ленина, д.48', '(4922) 44-44-11', 1, NULL, 0, '2015-12-14 17:59:22', NULL, NULL, NULL, NULL, NULL, 50, NULL, NULL, 1, NULL, NULL, '%', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 67, NULL, NULL, 'кв.м', 'm2', 97, NULL, NULL, 'кв.м', 'm2', 14, NULL, NULL, 'кв.м', 'm2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Квартира', 'Россия', 'Владимирская обл.', 'Владимир', 'Владимир', 'Ленинский р-он', NULL, 'Фатьянова ул.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2014-03-21', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4', NULL, NULL, NULL, NULL, 8, NULL, NULL, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14000, NULL, NULL, 'руб.', NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, '2015-09-21', NULL, NULL, 'subtag', NULL, 'отдельная', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Квартира в хоршем состоянии. Отделка социальная. Две лоджии застеклены. Имеется из мебели: диван, кресло - кровать, шкафы, кухонный гарнитур. Есть и техника: телевизор, тв. Семье .', '26062', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1000320, NULL, NULL, 'KIEVDOMP00010000', 'Овчинникова Анна Владимировна', NULL, '37-71-37', '8-904-959-57-88', NULL, 'Аренда', NULL, '120', NULL, 'Анна', 'KIEVDOMP00010000', '2015-12-14 17:59:22', '2015-12-14 17:59:22', 0, 0, 0, 8, NULL, NULL, NULL, NULL, 'subtag', NULL, 34, NULL, NULL, 'KIEVDOMP00010000', 'Никерова Виктория Юрьевна', NULL, NULL, '8-920-909-68-00', NULL, NULL, NULL, '403'),
(12, 48994, 'KIEVDOMP00010000', 1, 'Агентство недвижимости "Владис"', 'г. Владимир, пр-т Ленина, д.48', '(4922) 44-44-11', 1, NULL, 0, '2015-12-14 17:59:22', NULL, NULL, NULL, NULL, NULL, 50, NULL, NULL, 1, NULL, NULL, '%', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 75, NULL, NULL, 'кв.м', 'm2', 90, NULL, NULL, 'кв.м', 'm2', 11, NULL, NULL, 'кв.м', 'm2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Квартира', 'Россия', 'Владимирская обл.', 'Владимир', 'Владимир', 'Семязино', NULL, 'Семязинская ул.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2014-10-27', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '9', NULL, NULL, NULL, NULL, 2, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 23000, NULL, NULL, 'руб.', NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'subtag', NULL, 'отдельная', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Квартира находится в коттедже. Хорошее состояние. В наличии имеется все необходимое для комфортного проживания. Мебель, техника. Дом расположен в 10 мин от магазина" Бимарт". Цена указана с учетом коммунальных платежей.', '33988', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1000671, NULL, NULL, 'KIEVDOMP00010000', 'Петрова Светлана Валерьевна', NULL, '44-44-11', '8-900-588-89-11', NULL, 'Аренда', NULL, '1000', NULL, 'Светлана', 'KIEVDOMP00010000', '2015-12-14 17:59:22', '2015-12-14 17:59:22', 0, 0, 0, 9, NULL, NULL, NULL, NULL, 'subtag', NULL, 34, NULL, NULL, 'KIEVDOMP00010000', 'Никерова Виктория Юрьевна', NULL, NULL, '8-920-909-68-00', NULL, NULL, NULL, '403');

-- --------------------------------------------------------

--
-- Структура таблицы `ivn_private_ad`
--

CREATE TABLE IF NOT EXISTS `ivn_private_ad` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `addr` text,
  `descr` text,
  `cont` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `ivn_query`
--

CREATE TABLE IF NOT EXISTS `ivn_query` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `is_new` int(1) DEFAULT '1',
  `create_date` datetime DEFAULT NULL,
  `objecttype` varchar(100) DEFAULT NULL,
  `type` int(1) DEFAULT NULL,
  `price` double DEFAULT NULL,
  `price_month` double DEFAULT NULL,
  `district` varchar(100) DEFAULT NULL,
  `street` varchar(100) DEFAULT NULL,
  `house_no` int(10) DEFAULT NULL,
  `room_quantity` int(10) DEFAULT NULL,
  `floor` int(10) DEFAULT NULL,
  `number_of_storeys` int(10) DEFAULT NULL,
  `total_space` double DEFAULT NULL,
  `floor_space` double DEFAULT NULL,
  `kitchen_space` double DEFAULT NULL,
  `owner_name` varchar(50) DEFAULT NULL,
  `owner_phone` varchar(50) DEFAULT NULL,
  `owner_email` varchar(50) DEFAULT NULL,
  `note` varchar(500) DEFAULT NULL,
  `middleman` int(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `ivn_subtags`
--

CREATE TABLE IF NOT EXISTS `ivn_subtags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `p_id` int(11) DEFAULT NULL,
  `item` text,
  `pos` int(3) DEFAULT '0',
  `note` text,
  `p_tag` text,
  `photo_type` int(3) DEFAULT NULL,
  `file_name` text,
  `file_path` text,
  `group_id` int(3) DEFAULT NULL,
  `doc_type` text,
  PRIMARY KEY (`id`),
  KEY `p_id` (`p_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=187 ;

--
-- Дамп данных таблицы `ivn_subtags`
--

INSERT INTO `ivn_subtags` (`id`, `p_id`, `item`, `pos`, `note`, `p_tag`, `photo_type`, `file_name`, `file_path`, `group_id`, `doc_type`) VALUES
(1, 1, 'кирпичный', 0, '', 'walling_type', 0, '', '', NULL, ''),
(2, 1, 'раздельный', 0, '', 'bathroom', 0, '', '', NULL, ''),
(3, 1, 'PHOTO-KIEVDOMP00010000-5754-24a5e844.jpg', 1, 'Фото 1', 'pic', 0, '', '', NULL, ''),
(4, 1, 'PHOTO-KIEVDOMP00010000-5754-aedc3690.jpg', 2, 'Фото 2', 'pic', 0, '', '', NULL, ''),
(5, 1, 'PHOTO-KIEVDOMP00010000-5754-77bc2e70.jpg', 3, 'Фото 3', 'pic', 0, '', '', NULL, ''),
(6, 1, 'PHOTO-KIEVDOMP00010000-5754-8ed02741.jpg', 4, 'Фото 4', 'pic', 0, '', '', NULL, ''),
(7, 1, 'PHOTO-KIEVDOMP00010000-5754-69d0b76c.jpg', 5, 'Фото 5', 'pic', 0, '', '', NULL, ''),
(8, 1, 'PHOTO-KIEVDOMP00010000-5754-9583caf4.jpg', 6, 'Фото 6', 'pic', 0, '', '', NULL, ''),
(9, 1, 'PHOTO-KIEVDOMP00010000-5754-0f082599.jpg', 7, 'Фото 7', 'pic', 0, '', '', NULL, ''),
(10, 2, 'панельный', 0, '', 'walling_type', 0, '', '', NULL, ''),
(11, 2, 'раздельный', 0, '', 'bathroom', 0, '', '', NULL, ''),
(12, 2, 'PHOTO-KIEVDOMP00010000-6301-cabf35fd.jpg', 3, 'Фото 3', 'pic', 0, '', '', NULL, ''),
(13, 2, 'PHOTO-KIEVDOMP00010000-6301-a684bb40.jpg', 5, 'Фото 5', 'pic', 0, '', '', NULL, ''),
(14, 2, 'PHOTO-KIEVDOMP00010000-6301-95b9bc92.jpg', 6, 'Фото 6', 'pic', 0, '', '', NULL, ''),
(15, 2, 'PHOTO-KIEVDOMP00010000-6301-a4036b80.jpg', 7, 'Фото 7', 'pic', 0, '', '', NULL, ''),
(16, 2, 'PHOTO-KIEVDOMP00010000-6301-08aa4c1b.jpg', 8, 'Фото 8', 'pic', 0, '', '', NULL, ''),
(17, 2, 'PHOTO-KIEVDOMP00010000-6301-d16f2535.jpg', 9, 'Фото 9', 'pic', 0, '', '', NULL, ''),
(18, 2, 'PHOTO-KIEVDOMP00010000-6301-223cfbb2.jpg', 10, 'Фото 10', 'pic', 0, '', '', NULL, ''),
(19, 2, 'PHOTO-KIEVDOMP00010000-6301-4a1b47e7.jpg', 11, 'Фото 11', 'pic', 0, '', '', NULL, ''),
(20, 2, 'PHOTO-KIEVDOMP00010000-6301-d3079bd1.jpg', 12, 'Фото 12', 'pic', 0, '', '', NULL, ''),
(21, 2, 'PHOTO-KIEVDOMP00010000-6301-add6a499.jpg', 13, 'Фото 13', 'pic', 0, '', '', NULL, ''),
(22, 2, 'PHOTO-KIEVDOMP00010000-6301-c94a7e4b.jpg', 14, 'Фото 14', 'pic', 0, '', '', NULL, ''),
(23, 3, 'кирпичный', 0, '', 'walling_type', 0, '', '', NULL, ''),
(24, 3, 'совмещенный', 0, '', 'bathroom', 0, '', '', NULL, ''),
(25, 3, 'PHOTO-KIEVDOMP00010000-6308-a1d9b50b.jpg', 1, 'Фото 5', 'pic', 0, '', '', NULL, ''),
(26, 3, 'PHOTO-KIEVDOMP00010000-6308-7abf6d6a.jpg', 2, 'Фото 1', 'pic', 0, '', '', NULL, ''),
(27, 3, 'PHOTO-KIEVDOMP00010000-6308-585bf731.jpg', 3, 'Фото 2', 'pic', 0, '', '', NULL, ''),
(28, 3, 'PHOTO-KIEVDOMP00010000-6308-5fbce052.jpg', 5, 'Фото 4', 'pic', 0, '', '', NULL, ''),
(29, 3, 'PHOTO-KIEVDOMP00010000-6308-34feb2b1.jpg', 7, 'Фото 7', 'pic', 0, '', '', NULL, ''),
(30, 3, 'PHOTO-KIEVDOMP00010000-6308-f00464c1.jpg', 8, 'Фото 8', 'pic', 0, '', '', NULL, ''),
(31, 3, 'PHOTO-KIEVDOMP00010000-6308-a47c1bac.jpg', 10, 'Фото 10', 'pic', 0, '', '', NULL, ''),
(32, 4, 'кирпичный', 0, '', 'walling_type', 0, '', '', NULL, ''),
(33, 4, 'туалет/ванна', 0, '', 'bathroom', 0, '', '', NULL, ''),
(34, 4, 'туалет/душ', 0, '', 'bathroom', 0, '', '', NULL, ''),
(35, 4, 'PHOTO-KIEVDOMP00010000-8400-7df4b1f8.jpg', 1, 'Фото 1', 'pic', 0, '', '', NULL, ''),
(36, 4, 'PHOTO-KIEVDOMP00010000-8400-471768d7.jpg', 2, 'Фото 2', 'pic', 0, '', '', NULL, ''),
(37, 4, 'PHOTO-KIEVDOMP00010000-8400-a2c513a8.jpg', 3, 'Фото 3', 'pic', 0, '', '', NULL, ''),
(38, 4, 'PHOTO-KIEVDOMP00010000-8400-8ed85960.jpg', 4, 'Фото 4', 'pic', 0, '', '', NULL, ''),
(39, 4, 'PHOTO-KIEVDOMP00010000-8400-1215257b.jpg', 5, 'Фото 5', 'pic', 0, '', '', NULL, ''),
(40, 4, 'PHOTO-KIEVDOMP00010000-8400-66127634.jpg', 6, 'Фото 6', 'pic', 0, '', '', NULL, ''),
(41, 4, 'PHOTO-KIEVDOMP00010000-8400-47311f59.jpg', 7, 'Фото 7', 'pic', 0, '', '', NULL, ''),
(42, 4, 'PHOTO-KIEVDOMP00010000-8400-e442d7d6.jpg', 8, 'Фото 8', 'pic', 0, '', '', NULL, ''),
(43, 4, 'PHOTO-KIEVDOMP00010000-8400-4a0b2eb3.jpg', 9, 'Фото 9', 'pic', 0, '', '', NULL, ''),
(44, 4, 'PHOTO-KIEVDOMP00010000-8400-6415eab4.jpg', 10, 'Фото 10', 'pic', 0, '', '', NULL, ''),
(45, 4, 'PHOTO-KIEVDOMP00010000-8400-27321078.jpg', 11, 'Фото 11', 'pic', 0, '', '', NULL, ''),
(46, 4, 'PHOTO-KIEVDOMP00010000-8400-50baf3ce.jpg', 12, 'Фото 12', 'pic', 0, '', '', NULL, ''),
(47, 4, 'PHOTO-KIEVDOMP00010000-8400-c0cba92c.jpg', 13, 'Фото 13', 'pic', 0, '', '', NULL, ''),
(48, 4, 'PHOTO-KIEVDOMP00010000-8400-3daaaf1c.jpg', 14, 'Фото 14', 'pic', 0, '', '', NULL, ''),
(49, 4, 'PHOTO-KIEVDOMP00010000-8400-49639630.jpg', 15, 'Фото 15', 'pic', 0, '', '', NULL, ''),
(50, 4, 'PHOTO-KIEVDOMP00010000-8400-3053bc77.jpg', 16, 'Фото 16', 'pic', 0, '', '', NULL, ''),
(51, 4, 'PHOTO-KIEVDOMP00010000-8400-584bb859.jpg', 17, 'Фото 17', 'pic', 0, '', '', NULL, ''),
(52, 4, 'PHOTO-KIEVDOMP00010000-8400-299f38af.jpg', 18, 'Фото 18', 'pic', 0, '', '', NULL, ''),
(53, 4, 'PHOTO-KIEVDOMP00010000-8400-a2012a17.jpg', 19, 'Фото 19', 'pic', 0, '', '', NULL, ''),
(54, 4, 'PHOTO-KIEVDOMP00010000-8400-0b250716.jpg', 20, 'Фото 20', 'pic', 0, '', '', NULL, ''),
(55, 4, 'PHOTO-KIEVDOMP00010000-8400-4f998096.jpg', 21, 'Фото 21', 'pic', 0, '', '', NULL, ''),
(56, 4, 'PHOTO-KIEVDOMP00010000-8400-e003d670.jpg', 22, 'Фото 22', 'pic', 0, '', '', NULL, ''),
(57, 4, 'PHOTO-KIEVDOMP00010000-8400-a5dfc9f3.jpg', 23, 'Фото 23', 'pic', 0, '', '', NULL, ''),
(58, 4, 'PHOTO-KIEVDOMP00010000-8400-b16abe9b.jpg', 24, 'Фото 24', 'pic', 0, '', '', NULL, ''),
(59, 4, 'PHOTO-KIEVDOMP00010000-8400-c8a7b9a9.jpg', 25, 'Фото 25', 'pic', 0, '', '', NULL, ''),
(60, 4, 'PHOTO-KIEVDOMP00010000-8400-48d5801d.jpg', 26, 'Фото 26', 'pic', 0, '', '', NULL, ''),
(61, 4, 'PHOTO-KIEVDOMP00010000-8400-38bc4fa5.jpg', 27, 'Фото 27', 'pic', 0, '', '', NULL, ''),
(62, 4, 'PHOTO-KIEVDOMP00010000-8400-6e111eb5.jpg', 28, 'Фото 28', 'pic', 0, '', '', NULL, ''),
(63, 4, 'PHOTO-KIEVDOMP00010000-8400-4388d642.jpg', 29, 'Фото 29', 'pic', 0, '', '', NULL, ''),
(64, 4, 'PHOTO-KIEVDOMP00010000-8400-bef3d464.jpg', 30, 'Фото 30', 'pic', 0, '', '', NULL, ''),
(65, 4, 'PHOTO-KIEVDOMP00010000-8400-ed30899a.jpg', 31, 'Фото 31', 'pic', 0, '', '', NULL, ''),
(66, 4, 'PHOTO-KIEVDOMP00010000-8400-ad926829.jpg', 32, 'Фото 32', 'pic', 0, '', '', NULL, ''),
(67, 4, 'PHOTO-KIEVDOMP00010000-8400-1cbebba0.jpg', 33, 'Фото 33', 'pic', 0, '', '', NULL, ''),
(68, 4, 'PHOTO-KIEVDOMP00010000-8400-f01fe2d2.jpg', 34, 'Фото 34', 'pic', 0, '', '', NULL, ''),
(69, 5, 'подключено', 0, '', 'electricity', 0, '', '', NULL, ''),
(70, 5, 'кирпичный', 0, '', 'walling_type', 0, '', '', NULL, ''),
(71, 5, 'в доме', 0, '', 'bathroom', 0, '', '', NULL, ''),
(72, 5, 'индивидуальный  газовый котел', 0, '', 'heat_supply', 0, '', '', NULL, ''),
(73, 5, 'подведено', 0, '', 'gas_supply', 0, '', '', NULL, ''),
(74, 5, 'Холодная (водопровод)', 0, '', 'water_supply', 0, '', '', NULL, ''),
(75, 5, 'Горячая (бойлер)', 0, '', 'water_supply', 0, '', '', NULL, ''),
(76, 5, 'Горячая (АГВ)', 0, '', 'water_supply', 0, '', '', NULL, ''),
(77, 5, 'строительная отделка', 0, '', 'condition2', 0, '', '', NULL, ''),
(78, 5, 'PHOTO-KIEVDOMP00010000-18897-25016978.jpg', 1, 'Фото 5', 'pic', 0, '', '', NULL, ''),
(79, 5, 'PHOTO-KIEVDOMP00010000-18897-ef3b223f.jpg', 6, 'Фото 7', 'pic', 0, '', '', NULL, ''),
(80, 5, 'PHOTO-KIEVDOMP00010000-18897-155ec472.jpg', 8, 'Фото 8', 'pic', 0, '', '', NULL, ''),
(81, 5, 'PHOTO-KIEVDOMP00010000-18897-a7a5b051.jpg', 9, 'Фото 9', 'pic', 0, '', '', NULL, ''),
(82, 5, 'PHOTO-KIEVDOMP00010000-18897-984d9e2d.jpg', 10, 'Фото 10', 'pic', 0, '', '', NULL, ''),
(83, 5, 'PHOTO-KIEVDOMP00010000-18897-6a426ea3.jpg', 11, 'Фото 11', 'pic', 0, '', '', NULL, ''),
(84, 5, 'PHOTO-KIEVDOMP00010000-18897-cbaa4da6.jpg', 12, 'Фото 3', 'pic', 0, '', '', NULL, ''),
(85, 6, 'подключено', 0, '', 'electricity', 0, '', '', NULL, ''),
(86, 6, 'кирпичный', 0, '', 'walling_type', 0, '', '', NULL, ''),
(87, 6, 'в доме', 0, '', 'bathroom', 0, '', '', NULL, ''),
(88, 6, 'индивидуальный  газовый котел', 0, '', 'heat_supply', 0, '', '', NULL, ''),
(89, 6, 'подведено', 0, '', 'gas_supply', 0, '', '', NULL, ''),
(90, 6, 'Холодная (водопровод)', 0, '', 'water_supply', 0, '', '', NULL, ''),
(91, 6, 'строительная отделка', 0, '', 'condition2', 0, '', '', NULL, ''),
(92, 6, 'PHOTO-KIEVDOMP00010000-18898-26fbb013.jpg', 1, 'Фото 12', 'pic', 0, '', '', NULL, ''),
(93, 6, 'PHOTO-KIEVDOMP00010000-18898-8787404a.jpg', 5, 'Фото 13', 'pic', 0, '', '', NULL, ''),
(94, 6, 'PHOTO-KIEVDOMP00010000-18898-155ec472.jpg', 9, 'Фото 8', 'pic', 0, '', '', NULL, ''),
(95, 6, 'PHOTO-KIEVDOMP00010000-18898-1194ea07.jpg', 10, 'Фото 18', 'pic', 0, '', '', NULL, ''),
(96, 6, 'PHOTO-KIEVDOMP00010000-18898-c726363c.jpg', 11, 'Фото 14', 'pic', 0, '', '', NULL, ''),
(97, 6, 'PHOTO-KIEVDOMP00010000-18898-0a0db288.jpg', 13, 'Фото 15', 'pic', 0, '', '', NULL, ''),
(98, 6, 'PHOTO-KIEVDOMP00010000-18898-31f2de9d.jpg', 14, 'Фото 16', 'pic', 0, '', '', NULL, ''),
(99, 6, 'PHOTO-KIEVDOMP00010000-18898-04e45f2b.jpg', 15, 'Фото 17', 'pic', 0, '', '', NULL, ''),
(100, 6, 'PHOTO-KIEVDOMP00010000-18898-2145f4f2.jpg', 16, 'Фото 19', 'pic', 0, '', '', NULL, ''),
(101, 6, 'PHOTO-KIEVDOMP00010000-18898-a7a5b051.jpg', 17, 'Фото 9', 'pic', 0, '', '', NULL, ''),
(102, 6, 'PHOTO-KIEVDOMP00010000-18898-984d9e2d.jpg', 18, 'Фото 10', 'pic', 0, '', '', NULL, ''),
(103, 6, 'PHOTO-KIEVDOMP00010000-18898-6a426ea3.jpg', 19, 'Фото 11', 'pic', 0, '', '', NULL, ''),
(104, 7, 'подключено', 0, '', 'electricity', 0, '', '', NULL, ''),
(105, 7, 'кирпичный', 0, '', 'walling_type', 0, '', '', NULL, ''),
(106, 7, 'в доме', 0, '', 'bathroom', 0, '', '', NULL, ''),
(107, 7, 'индивидуальный  газовый котел', 0, '', 'heat_supply', 0, '', '', NULL, ''),
(108, 7, 'подведено', 0, '', 'gas_supply', 0, '', '', NULL, ''),
(109, 7, 'Холодная (водопровод)', 0, '', 'water_supply', 0, '', '', NULL, ''),
(110, 7, 'строительная отделка', 0, '', 'condition2', 0, '', '', NULL, ''),
(111, 7, 'PHOTO-KIEVDOMP00010000-18899-331ce7f4.jpg', 1, 'Фото 21', 'pic', 0, '', '', NULL, ''),
(112, 7, 'PHOTO-KIEVDOMP00010000-18899-26fbb013.jpg', 5, 'Фото 12', 'pic', 0, '', '', NULL, ''),
(113, 7, 'PHOTO-KIEVDOMP00010000-18899-25016978.jpg', 6, 'Фото 5', 'pic', 0, '', '', NULL, ''),
(114, 7, 'PHOTO-KIEVDOMP00010000-18899-ef3b223f.jpg', 8, 'Фото 7', 'pic', 0, '', '', NULL, ''),
(115, 7, 'PHOTO-KIEVDOMP00010000-18899-155ec472.jpg', 9, 'Фото 8', 'pic', 0, '', '', NULL, ''),
(116, 7, 'PHOTO-KIEVDOMP00010000-18899-a7a5b051.jpg', 10, 'Фото 9', 'pic', 0, '', '', NULL, ''),
(117, 7, 'PHOTO-KIEVDOMP00010000-18899-1194ea07.jpg', 11, 'Фото 19', 'pic', 0, '', '', NULL, ''),
(118, 7, 'PHOTO-KIEVDOMP00010000-18899-984d9e2d.jpg', 12, 'Фото 10', 'pic', 0, '', '', NULL, ''),
(119, 7, 'PHOTO-KIEVDOMP00010000-18899-6a426ea3.jpg', 13, 'Фото 11', 'pic', 0, '', '', NULL, ''),
(120, 7, 'PHOTO-KIEVDOMP00010000-18899-cbaa4da6.jpg', 14, 'Фото 3', 'pic', 0, '', '', NULL, ''),
(121, 7, 'PHOTO-KIEVDOMP00010000-18899-529b451d.jpg', 15, 'Фото 13', 'pic', 0, '', '', NULL, ''),
(122, 7, 'PHOTO-KIEVDOMP00010000-18899-1ac28b56.jpg', 16, 'Фото 14', 'pic', 0, '', '', NULL, ''),
(123, 7, 'PHOTO-KIEVDOMP00010000-18899-c726363c.jpg', 17, 'Фото 15', 'pic', 0, '', '', NULL, ''),
(124, 7, 'PHOTO-KIEVDOMP00010000-18899-9158387a.jpg', 18, 'Фото 16', 'pic', 0, '', '', NULL, ''),
(125, 7, 'PHOTO-KIEVDOMP00010000-18899-b7ff4e77.jpg', 19, 'Фото 17', 'pic', 0, '', '', NULL, ''),
(126, 7, 'PHOTO-KIEVDOMP00010000-18899-31f2de9d.jpg', 20, 'Фото 18', 'pic', 0, '', '', NULL, ''),
(127, 7, 'PHOTO-KIEVDOMP00010000-18899-2145f4f2.jpg', 21, 'Фото 20', 'pic', 0, '', '', NULL, ''),
(128, 7, 'PHOTO-KIEVDOMP00010000-18899-eaee5e43.jpg', 22, 'Фото 22', 'pic', 0, '', '', NULL, ''),
(129, 7, 'PHOTO-KIEVDOMP00010000-18899-36acd29e.jpg', 23, 'Фото 23', 'pic', 0, '', '', NULL, ''),
(130, 8, 'подключено', 0, '', 'electricity', 0, '', '', NULL, ''),
(131, 8, 'кирпичный', 0, '', 'walling_type', 0, '', '', NULL, ''),
(132, 8, 'в доме', 0, '', 'bathroom', 0, '', '', NULL, ''),
(133, 8, 'индивидуальный  газовый котел', 0, '', 'heat_supply', 0, '', '', NULL, ''),
(134, 8, 'подведено', 0, '', 'gas_supply', 0, '', '', NULL, ''),
(135, 8, 'Холодная (водопровод)', 0, '', 'water_supply', 0, '', '', NULL, ''),
(136, 8, 'строительная отделка', 0, '', 'condition2', 0, '', '', NULL, ''),
(137, 8, 'PHOTO-KIEVDOMP00010000-18900-15614ed0.jpg', 5, 'Фото 12', 'pic', 0, '', '', NULL, ''),
(138, 8, 'PHOTO-KIEVDOMP00010000-18900-25016978.jpg', 6, 'Фото 5', 'pic', 0, '', '', NULL, ''),
(139, 8, 'PHOTO-KIEVDOMP00010000-18900-ef3b223f.jpg', 8, 'Фото 7', 'pic', 0, '', '', NULL, ''),
(140, 8, 'PHOTO-KIEVDOMP00010000-18900-587ccfa6.jpg', 9, 'Фото 13', 'pic', 0, '', '', NULL, ''),
(141, 8, 'PHOTO-KIEVDOMP00010000-18900-155ec472.jpg', 10, 'Фото 8', 'pic', 0, '', '', NULL, ''),
(142, 8, 'PHOTO-KIEVDOMP00010000-18900-a7a5b051.jpg', 11, 'Фото 9', 'pic', 0, '', '', NULL, ''),
(143, 8, 'PHOTO-KIEVDOMP00010000-18900-984d9e2d.jpg', 12, 'Фото 10', 'pic', 0, '', '', NULL, ''),
(144, 8, 'PHOTO-KIEVDOMP00010000-18900-6a426ea3.jpg', 13, 'Фото 11', 'pic', 0, '', '', NULL, ''),
(145, 8, 'PHOTO-KIEVDOMP00010000-18900-cbaa4da6.jpg', 14, 'Фото 3', 'pic', 0, '', '', NULL, ''),
(146, 8, 'PHOTO-KIEVDOMP00010000-18900-89e3c823.jpg', 15, 'Фото 14', 'pic', 0, '', '', NULL, ''),
(147, 9, 'кирпичный', 0, '', 'walling_type', 0, '', '', NULL, ''),
(148, 9, 'нет', 0, '', 'personal_estate', 0, '', '', NULL, ''),
(149, 9, 'шкаф', 0, '', 'personal_estate', 0, '', '', NULL, ''),
(150, 9, 'PHOTO-KIEVDOMP00010000-25298-47afebc7.jpg', 1, 'Фото 14', 'pic', 0, '', '', NULL, ''),
(151, 9, 'PHOTO-KIEVDOMP00010000-25298-becd6195.jpg', 2, 'Фото 1', 'pic', 0, '', '', NULL, ''),
(152, 9, 'PHOTO-KIEVDOMP00010000-25298-15f1c90c.jpg', 3, 'Фото 2', 'pic', 0, '', '', NULL, ''),
(153, 9, 'PHOTO-KIEVDOMP00010000-25298-b8f3e02c.jpg', 4, 'Фото 3', 'pic', 0, '', '', NULL, ''),
(154, 9, 'PHOTO-KIEVDOMP00010000-25298-23bef412.jpg', 5, 'Фото 4', 'pic', 0, '', '', NULL, ''),
(155, 9, 'PHOTO-KIEVDOMP00010000-25298-fc9bfbdb.jpg', 6, 'Фото 5', 'pic', 0, '', '', NULL, ''),
(156, 9, 'PHOTO-KIEVDOMP00010000-25298-8b41e9f2.jpg', 7, 'Фото 6', 'pic', 0, '', '', NULL, ''),
(157, 9, 'PHOTO-KIEVDOMP00010000-25298-e59daf85.jpg', 8, 'Фото 7', 'pic', 0, '', '', NULL, ''),
(158, 9, 'PHOTO-KIEVDOMP00010000-25298-61dd398c.jpg', 9, 'Фото 8', 'pic', 0, '', '', NULL, ''),
(159, 9, 'PHOTO-KIEVDOMP00010000-25298-494fa8dd.jpg', 10, 'Фото 9', 'pic', 0, '', '', NULL, ''),
(160, 9, 'PHOTO-KIEVDOMP00010000-25298-d71be233.jpg', 11, 'Фото 10', 'pic', 0, '', '', NULL, ''),
(161, 9, 'PHOTO-KIEVDOMP00010000-25298-2e3e0206.jpg', 12, 'Фото 11', 'pic', 0, '', '', NULL, ''),
(162, 9, 'PHOTO-KIEVDOMP00010000-25298-375a8f5b.jpg', 13, 'Фото 12', 'pic', 0, '', '', NULL, ''),
(163, 9, 'PHOTO-KIEVDOMP00010000-25298-1b67cfe7.jpg', 14, 'Фото 13', 'pic', 0, '', '', NULL, ''),
(164, 9, 'PHOTO-KIEVDOMP00010000-25298-992904f1.jpg', 15, 'Фото 15', 'pic', 0, '', '', NULL, ''),
(165, 9, 'PHOTO-KIEVDOMP00010000-25298-44de40d4.jpg', 16, 'Фото 16', 'pic', 0, '', '', NULL, ''),
(166, 10, 'кирпичный', 0, '', 'walling_type', 0, '', '', NULL, ''),
(167, 10, 'есть', 0, '', 'personal_estate', 0, '', '', NULL, ''),
(168, 10, 'PHOTO-KIEVDOMP00010000-30956-02f2d1d4.jpg', 2, 'Фото 4', 'pic', 0, '', '', NULL, ''),
(169, 10, 'PHOTO-KIEVDOMP00010000-30956-214a84d4.jpg', 3, 'Фото 2', 'pic', 0, '', '', NULL, ''),
(170, 10, 'PHOTO-KIEVDOMP00010000-30956-e2506a49.jpg', 4, 'Фото 3', 'pic', 0, '', '', NULL, ''),
(171, 10, 'PHOTO-KIEVDOMP00010000-30956-4d9ebba0.jpg', 5, 'Фото 5', 'pic', 0, '', '', NULL, ''),
(172, 10, 'PHOTO-KIEVDOMP00010000-30956-53b0b250.jpg', 6, 'Фото 6', 'pic', 0, '', '', NULL, ''),
(173, 10, 'PHOTO-KIEVDOMP00010000-30956-3461eab7.jpg', 7, 'Фото 7', 'pic', 0, '', '', NULL, ''),
(174, 10, 'PHOTO-KIEVDOMP00010000-30956-12019a84.jpg', 8, 'Фото 8', 'pic', 0, '', '', NULL, ''),
(175, 11, 'монолитный', 0, '', 'walling_type', 0, '', '', NULL, ''),
(176, 11, 'PHOTO-KIEVDOMP00010000-34269-949cbfde.jpg', 2, 'Фото 2', 'pic', 0, '', '', NULL, ''),
(177, 11, 'PHOTO-KIEVDOMP00010000-34269-fd06c7af.jpg', 3, 'Фото 3', 'pic', 0, '', '', NULL, ''),
(178, 11, 'PHOTO-KIEVDOMP00010000-34269-fa2859e9.jpg', 5, 'Фото 5', 'pic', 0, '', '', NULL, ''),
(179, 11, 'PHOTO-KIEVDOMP00010000-34269-3e30fc37.jpg', 6, 'Фото 6', 'pic', 0, '', '', NULL, ''),
(180, 11, 'PHOTO-KIEVDOMP00010000-34269-dcdf5ce7.jpg', 7, 'Фото 7', 'pic', 0, '', '', NULL, ''),
(181, 11, 'PHOTO-KIEVDOMP00010000-34269-e43103cc.jpg', 8, 'Фото 8', 'pic', 0, '', '', NULL, ''),
(182, 11, 'PHOTO-KIEVDOMP00010000-34269-bdd09940.jpg', 9, 'Фото 9', 'pic', 0, '', '', NULL, ''),
(183, 11, 'PHOTO-KIEVDOMP00010000-34269-898389ef.jpg', 10, 'Фото 10', 'pic', 0, '', '', NULL, ''),
(184, 11, 'PHOTO-KIEVDOMP00010000-34269-fb9f1a75.jpg', 11, 'Фото 11', 'pic', 0, '', '', NULL, ''),
(185, 12, 'кирпичный', 0, '', 'walling_type', 0, '', '', NULL, ''),
(186, 12, 'PHOTO-KIEVDOMP00010000-48994-27019ee2.jpg', 1, 'Фото 1', 'pic', 0, '', '', NULL, '');

-- --------------------------------------------------------

--
-- Структура таблицы `ivn_user_access`
--

CREATE TABLE IF NOT EXISTS `ivn_user_access` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `access_name` varchar(80) NOT NULL,
  `access_value` int(1) unsigned NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Ограничения внешнего ключа сохраненных таблиц
--

--
-- Ограничения внешнего ключа таблицы `ivn_objects`
--
ALTER TABLE `ivn_objects`
  ADD CONSTRAINT `ivn_objects_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `ivn_clients` (`id`);

--
-- Ограничения внешнего ключа таблицы `ivn_user_access`
--
ALTER TABLE `ivn_user_access`
  ADD CONSTRAINT `ivn_user_access_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `ivn_user` (`id`) ON DELETE CASCADE;

