Notice (8): Undefined index: MInquiryDial [APP/Controller/AppController.php, line 34]
Notice (8): Undefined index: MInquiryDial [APP/Controller/AppController.php, line 35]
Warning (2): file_put_contents(/var/www/html/chintai/fudosan/www/app/tmp/logs/error.log) [http://php.net/function.file-put-contents]: failed to open stream: Permission denied [CORE/Cake/Log/Engine/FileLog.php, line 142]
レスピール三鷹 7階 701号室 | 学生賃貸組合
三鷹市の家具家電付プランも同時提案中♪
物件ID 02200-0913350
月額賃料 73,000
敷金/礼金 0ヶ月 / 0ヶ月
管理/共益費 8,000円 / ---
種別 マンション
面積/間取り 18.61平米 / ワンルーム
築年/向き 47年/西向き
階建/階数 9階 / 7階
住所 東京都三鷹市下連雀2丁目21
最寄駅 中央線 三鷹駅 徒歩13分
中央線 吉祥寺駅 徒歩24分
エアコン付きバス・トイレ別BSアンテナ収納スペースウォークインクローゼットIHコンロ室内洗濯機置場室内洗濯機置場エレベーターモニタ付きインタホン宅配ボックス駐輪場あり

こちらの物件は空き状況の確認が必要でございます。
ご入居中の場合でも空き予定日をお調べしたり、同じ建物の他のお部屋や似た条件の物件をご紹介できます。
ぜひお問い合わせください!

物件情報

部屋情報

物件概要

住所 東京都三鷹市下連雀2丁目21
交通機関 中央線 三鷹駅 徒歩13分
中央線 吉祥寺駅 徒歩24分
物件種目 マンション 構造 鉄骨鉄筋コンクリート(SRC)
賃料 73,000 管理費 8,000
敷金 0ヶ月 礼金 0ヶ月
間取り ワンルーム
面積 18.61平米
階 / 階建 7階 / 9階建 築年月 1973年3月(築47年)
入居日 即時 契約期間 2年年
駐輪場 有り 駐車場 無し
設備等
(default) 25 queries took 1125 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `MAreaDistrict`.`id`, `MAreaDistrict`.`name` FROM `fudosan`.`app_m_area_districts` AS `MAreaDistrict` WHERE `MAreaDistrict`.`is_disabled` = '0' AND `MAreaDistrict`.`is_deleted` = '0'660
2SELECT `MAreaPrefecture`.`id`, `MAreaPrefecture`.`name` FROM `fudosan`.`app_m_area_prefectures` AS `MAreaPrefecture` WHERE `MAreaPrefecture`.`id` IN (8, 11, 12, 13, 14)550
3SELECT `MAreaCity`.`id`, `MAreaCity`.`name` FROM `fudosan`.`app_m_area_cities` AS `MAreaCity` WHERE `MAreaCity`.`is_disabled` = '0' AND `MAreaCity`.`is_deleted` = '0'2572570
4SELECT `MAreaLine`.`id`, `MAreaLine`.`name` FROM `fudosan`.`app_m_area_lines` AS `MAreaLine` WHERE `MAreaLine`.`is_disabled` = '0' AND `MAreaLine`.`is_deleted` = '0'1321320
5SELECT `MPropertyRentalType`.`id`, `MPropertyRentalType`.`name` FROM `fudosan`.`app_m_property_rental_types` AS `MPropertyRentalType` WHERE `MPropertyRentalType`.`is_disabled` = '0' AND `MPropertyRentalType`.`is_deleted` = '0'220
6SELECT `MPropertyContractType`.`id`, `MPropertyContractType`.`name` FROM `fudosan`.`app_m_property_contract_types` AS `MPropertyContractType` WHERE `MPropertyContractType`.`is_disabled` = '0' AND `MPropertyContractType`.`is_deleted` = '0'550
7SELECT `MPropertyBuildingType`.`id`, `MPropertyBuildingType`.`name` FROM `fudosan`.`app_m_property_building_types` AS `MPropertyBuildingType` WHERE `MPropertyBuildingType`.`is_disabled` = '0' AND `MPropertyBuildingType`.`is_deleted` = '0'440
8SELECT `MPropertyBuildingStructure`.`id`, `MPropertyBuildingStructure`.`name` FROM `fudosan`.`app_m_property_building_structures` AS `MPropertyBuildingStructure` WHERE `MPropertyBuildingStructure`.`is_disabled` = '0' AND `MPropertyBuildingStructure`.`is_deleted` = '0'660
9SELECT `MPropertyInformationModelType`.`id`, `MPropertyInformationModelType`.`name` FROM `fudosan`.`app_m_property_information_model_types` AS `MPropertyInformationModelType` WHERE `MPropertyInformationModelType`.`is_disabled` = '0' AND `MPropertyInformationModelType`.`is_deleted` = '0'10100
10SELECT `MPropertyStatus`.`id`, `MPropertyStatus`.`name` FROM `fudosan`.`app_m_property_statuses` AS `MPropertyStatus` WHERE `MPropertyStatus`.`is_disabled` = '0' AND `MPropertyStatus`.`is_deleted` = '0'330
11SELECT `MPropertyFeatureCategory`.`id`, `MPropertyFeatureCategory`.`name`, `MPropertyFeatureCategory`.`order`, `MPropertyFeatureCategory`.`is_disabled`, `MPropertyFeatureCategory`.`is_deleted`, `MPropertyFeatureCategory`.`created`, `MPropertyFeatureCategory`.`modified` FROM `fudosan`.`app_m_property_feature_categories` AS `MPropertyFeatureCategory` WHERE `MPropertyFeatureCategory`.`id` > 1 ORDER BY `MPropertyFeatureCategory`.`id` asc10100
12SELECT `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_m_property_features` AS `MPropertyFeature` WHERE `MPropertyFeature`.`m_property_feature_category_id` IN (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)75750
13SELECT `MInquiryDial`.`id`, `MInquiryDial`.`name`, `MInquiryDial`.`display_name`, `MInquiryDial`.`order`, `MInquiryDial`.`is_disabled`, `MInquiryDial`.`is_deleted`, `MInquiryDial`.`created`, `MInquiryDial`.`modified` FROM `fudosan`.`app_m_inquiry_dials` AS `MInquiryDial` WHERE `MInquiryDial`.`is_disabled` = '0' AND `MInquiryDial`.`is_deleted` = '0' AND `MInquiryDial`.`id` = 30 LIMIT 1000
14SELECT COUNT(*) AS `count` FROM `fudosan`.`app_property_informations` AS `PropertyInformation` WHERE `PropertyInformation`.`id` = 913350110
15SELECT `PropertyInformation`.`id`, `PropertyInformation`.`name`, `PropertyInformation`.`pronunciation_of_name`, `PropertyInformation`.`unique_key`, `PropertyInformation`.`order`, `PropertyInformation`.`url`, `PropertyInformation`.`room_number`, `PropertyInformation`.`start_date`, `PropertyInformation`.`update_date`, `PropertyInformation`.`end_date`, `PropertyInformation`.`move_on_same_day`, `PropertyInformation`.`moving_date`, `PropertyInformation`.`leaving_date`, `PropertyInformation`.`rent`, `PropertyInformation`.`security_deposit`, `PropertyInformation`.`sinking_security_deposit`, `PropertyInformation`.`key_money`, `PropertyInformation`.`addon_key_money`, `PropertyInformation`.`deposit`, `PropertyInformation`.`premium`, `PropertyInformation`.`maintenance_fee`, `PropertyInformation`.`common_area_fee`, `PropertyInformation`.`commission`, `PropertyInformation`.`cost_note`, `PropertyInformation`.`renewal_fee`, `PropertyInformation`.`renewable`, `PropertyInformation`.`termination_note`, `PropertyInformation`.`ad`, `PropertyInformation`.`reward_note`, `PropertyInformation`.`free_rent`, `PropertyInformation`.`require_insurance`, `PropertyInformation`.`insuarance_note`, `PropertyInformation`.`require_guarantee`, `PropertyInformation`.`guarantee_note`, `PropertyInformation`.`duration_of_contract`, `PropertyInformation`.`amenities`, `PropertyInformation`.`comments`, `PropertyInformation`.`floor_space`, `PropertyInformation`.`space_note`, `PropertyInformation`.`number_of_floors`, `PropertyInformation`.`direction`, `PropertyInformation`.`m_property_information_model_type_id`, `PropertyInformation`.`model_type_note`, `PropertyInformation`.`reform_note`, `PropertyInformation`.`drawing_file`, `PropertyInformation`.`text_for_search`, `PropertyInformation`.`note`, `PropertyInformation`.`has_owner`, `PropertyInformation`.`postal_code`, `PropertyInformation`.`address`, `PropertyInformation`.`latitude`, `PropertyInformation`.`longitude`, `PropertyInformation`.`year_of_completion`, `PropertyInformation`.`month_of_completion`, `PropertyInformation`.`land_space`, `PropertyInformation`.`total_number_of_floors`, `PropertyInformation`.`total_number_of_households`, `PropertyInformation`.`parking`, `PropertyInformation`.`parking_available`, `PropertyInformation`.`parking_note`, `PropertyInformation`.`walk_for`, `PropertyInformation`.`access_note`, `PropertyInformation`.`nearby_train_route`, `PropertyInformation`.`nearby_train_station`, `PropertyInformation`.`surrounding_note`, `PropertyInformation`.`key_open_text`, `PropertyInformation`.`key_location_address`, `PropertyInformation`.`approval_for_publish`, `PropertyInformation`.`approval_for_use_image`, `PropertyInformation`.`reproduce_type_id`, `PropertyInformation`.`is_disabled`, `PropertyInformation`.`is_deleted`, `PropertyInformation`.`client_like_count`, `PropertyInformation`.`image_count`, `PropertyInformation`.`display_image_count`, `PropertyInformation`.`account_information_id`, `PropertyInformation`.`m_property_status_id`, `PropertyInformation`.`m_property_rental_type_id`, `PropertyInformation`.`m_property_owner_contract_type_id`, `PropertyInformation`.`m_area_district_id`, `PropertyInformation`.`m_area_prefecture_id`, `PropertyInformation`.`m_area_city_id`, `PropertyInformation`.`m_area_town_id`, `PropertyInformation`.`m_area_region_id`, `PropertyInformation`.`m_owner_id`, `PropertyInformation`.`m_property_building_id`, `PropertyInformation`.`m_property_building_type_id`, `PropertyInformation`.`m_property_building_structure_id`, `PropertyInformation`.`m_property_resource_id`, `PropertyInformation`.`created`, `PropertyInformation`.`modified`, `MPropertyBuilding`.`id`, `MPropertyBuilding`.`name`, `MPropertyBuilding`.`pronunciation_of_name`, `MPropertyBuilding`.`unique_key`, `MPropertyBuilding`.`order`, `MPropertyBuilding`.`url`, `MPropertyBuilding`.`postal_code`, `MPropertyBuilding`.`address`, `MPropertyBuilding`.`latitude`, `MPropertyBuilding`.`longitude`, `MPropertyBuilding`.`year_of_completion`, `MPropertyBuilding`.`month_of_completion`, `MPropertyBuilding`.`land_space`, `MPropertyBuilding`.`floor_space`, `MPropertyBuilding`.`total_number_of_floors`, `MPropertyBuilding`.`total_number_of_households`, `MPropertyBuilding`.`parking`, `MPropertyBuilding`.`parking_available`, `MPropertyBuilding`.`parking_note`, `MPropertyBuilding`.`building_coverage_ratio`, `MPropertyBuilding`.`floor_area_ratio`, `MPropertyBuilding`.`walk_for`, `MPropertyBuilding`.`access_note`, `MPropertyBuilding`.`nearby_train_route`, `MPropertyBuilding`.`nearby_train_station`, `MPropertyBuilding`.`surrounding_note`, `MPropertyBuilding`.`approval_for_publish`, `MPropertyBuilding`.`approval_for_use_image`, `MPropertyBuilding`.`is_disabled`, `MPropertyBuilding`.`is_deleted`, `MPropertyBuilding`.`account_information_id`, `MPropertyBuilding`.`property_information_count`, `MPropertyBuilding`.`m_property_empty_information_count`, `MPropertyBuilding`.`m_area_district_id`, `MPropertyBuilding`.`m_area_prefecture_id`, `MPropertyBuilding`.`m_area_city_id`, `MPropertyBuilding`.`m_area_town_id`, `MPropertyBuilding`.`m_area_region_id`, `MPropertyBuilding`.`m_owner_id`, `MPropertyBuilding`.`m_property_building_type_id`, `MPropertyBuilding`.`m_property_building_structure_id`, `MPropertyBuilding`.`m_property_resource_id`, `MPropertyBuilding`.`created`, `MPropertyBuilding`.`modified` FROM `fudosan`.`app_property_informations` AS `PropertyInformation` LEFT JOIN `fudosan`.`app_m_property_buildings` AS `MPropertyBuilding` ON (`PropertyInformation`.`m_property_building_id` = `MPropertyBuilding`.`id`) WHERE `PropertyInformation`.`id` = 913350 LIMIT 1111
16SELECT `PropertyInformationFeature`.`id`, `PropertyInformationFeature`.`property_information_id`, `PropertyInformationFeature`.`m_property_feature_id`, `PropertyInformationFeature`.`is_deleted`, `PropertyInformationFeature`.`created`, `PropertyInformationFeature`.`modified`, `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` LEFT JOIN `fudosan`.`app_m_property_features` AS `MPropertyFeature` ON (`PropertyInformationFeature`.`m_property_feature_id` = `MPropertyFeature`.`id`) WHERE `PropertyInformationFeature`.`property_information_id` = 913350 ORDER BY `PropertyInformationFeature`.`id` asc12121
17SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 518615 ORDER BY `MPropertyBuildingStation`.`id` asc221
18SELECT `PropertyInformation`.`id`, `PropertyInformation`.`name`, `PropertyInformation`.`pronunciation_of_name`, `PropertyInformation`.`unique_key`, `PropertyInformation`.`order`, `PropertyInformation`.`url`, `PropertyInformation`.`room_number`, `PropertyInformation`.`start_date`, `PropertyInformation`.`update_date`, `PropertyInformation`.`end_date`, `PropertyInformation`.`move_on_same_day`, `PropertyInformation`.`moving_date`, `PropertyInformation`.`leaving_date`, `PropertyInformation`.`rent`, `PropertyInformation`.`security_deposit`, `PropertyInformation`.`sinking_security_deposit`, `PropertyInformation`.`key_money`, `PropertyInformation`.`addon_key_money`, `PropertyInformation`.`deposit`, `PropertyInformation`.`premium`, `PropertyInformation`.`maintenance_fee`, `PropertyInformation`.`common_area_fee`, `PropertyInformation`.`commission`, `PropertyInformation`.`cost_note`, `PropertyInformation`.`renewal_fee`, `PropertyInformation`.`renewable`, `PropertyInformation`.`termination_note`, `PropertyInformation`.`ad`, `PropertyInformation`.`reward_note`, `PropertyInformation`.`free_rent`, `PropertyInformation`.`require_insurance`, `PropertyInformation`.`insuarance_note`, `PropertyInformation`.`require_guarantee`, `PropertyInformation`.`guarantee_note`, `PropertyInformation`.`duration_of_contract`, `PropertyInformation`.`amenities`, `PropertyInformation`.`comments`, `PropertyInformation`.`floor_space`, `PropertyInformation`.`space_note`, `PropertyInformation`.`number_of_floors`, `PropertyInformation`.`direction`, `PropertyInformation`.`m_property_information_model_type_id`, `PropertyInformation`.`model_type_note`, `PropertyInformation`.`reform_note`, `PropertyInformation`.`drawing_file`, `PropertyInformation`.`text_for_search`, `PropertyInformation`.`note`, `PropertyInformation`.`has_owner`, `PropertyInformation`.`postal_code`, `PropertyInformation`.`address`, `PropertyInformation`.`latitude`, `PropertyInformation`.`longitude`, `PropertyInformation`.`year_of_completion`, `PropertyInformation`.`month_of_completion`, `PropertyInformation`.`land_space`, `PropertyInformation`.`total_number_of_floors`, `PropertyInformation`.`total_number_of_households`, `PropertyInformation`.`parking`, `PropertyInformation`.`parking_available`, `PropertyInformation`.`parking_note`, `PropertyInformation`.`walk_for`, `PropertyInformation`.`access_note`, `PropertyInformation`.`nearby_train_route`, `PropertyInformation`.`nearby_train_station`, `PropertyInformation`.`surrounding_note`, `PropertyInformation`.`key_open_text`, `PropertyInformation`.`key_location_address`, `PropertyInformation`.`approval_for_publish`, `PropertyInformation`.`approval_for_use_image`, `PropertyInformation`.`reproduce_type_id`, `PropertyInformation`.`is_disabled`, `PropertyInformation`.`is_deleted`, `PropertyInformation`.`client_like_count`, `PropertyInformation`.`image_count`, `PropertyInformation`.`display_image_count`, `PropertyInformation`.`account_information_id`, `PropertyInformation`.`m_property_status_id`, `PropertyInformation`.`m_property_rental_type_id`, `PropertyInformation`.`m_property_owner_contract_type_id`, `PropertyInformation`.`m_area_district_id`, `PropertyInformation`.`m_area_prefecture_id`, `PropertyInformation`.`m_area_city_id`, `PropertyInformation`.`m_area_town_id`, `PropertyInformation`.`m_area_region_id`, `PropertyInformation`.`m_owner_id`, `PropertyInformation`.`m_property_building_id`, `PropertyInformation`.`m_property_building_type_id`, `PropertyInformation`.`m_property_building_structure_id`, `PropertyInformation`.`m_property_resource_id`, `PropertyInformation`.`created`, `PropertyInformation`.`modified`, `MPropertyBuilding`.`id`, `MPropertyBuilding`.`name`, `MPropertyBuilding`.`pronunciation_of_name`, `MPropertyBuilding`.`unique_key`, `MPropertyBuilding`.`order`, `MPropertyBuilding`.`url`, `MPropertyBuilding`.`postal_code`, `MPropertyBuilding`.`address`, `MPropertyBuilding`.`latitude`, `MPropertyBuilding`.`longitude`, `MPropertyBuilding`.`year_of_completion`, `MPropertyBuilding`.`month_of_completion`, `MPropertyBuilding`.`land_space`, `MPropertyBuilding`.`floor_space`, `MPropertyBuilding`.`total_number_of_floors`, `MPropertyBuilding`.`total_number_of_households`, `MPropertyBuilding`.`parking`, `MPropertyBuilding`.`parking_available`, `MPropertyBuilding`.`parking_note`, `MPropertyBuilding`.`building_coverage_ratio`, `MPropertyBuilding`.`floor_area_ratio`, `MPropertyBuilding`.`walk_for`, `MPropertyBuilding`.`access_note`, `MPropertyBuilding`.`nearby_train_route`, `MPropertyBuilding`.`nearby_train_station`, `MPropertyBuilding`.`surrounding_note`, `MPropertyBuilding`.`approval_for_publish`, `MPropertyBuilding`.`approval_for_use_image`, `MPropertyBuilding`.`is_disabled`, `MPropertyBuilding`.`is_deleted`, `MPropertyBuilding`.`account_information_id`, `MPropertyBuilding`.`property_information_count`, `MPropertyBuilding`.`m_property_empty_information_count`, `MPropertyBuilding`.`m_area_district_id`, `MPropertyBuilding`.`m_area_prefecture_id`, `MPropertyBuilding`.`m_area_city_id`, `MPropertyBuilding`.`m_area_town_id`, `MPropertyBuilding`.`m_area_region_id`, `MPropertyBuilding`.`m_owner_id`, `MPropertyBuilding`.`m_property_building_type_id`, `MPropertyBuilding`.`m_property_building_structure_id`, `MPropertyBuilding`.`m_property_resource_id`, `MPropertyBuilding`.`created`, `MPropertyBuilding`.`modified` FROM `fudosan`.`app_property_informations` AS `PropertyInformation` LEFT JOIN `fudosan`.`app_m_property_buildings` AS `MPropertyBuilding` ON (`PropertyInformation`.`m_property_building_id` = `MPropertyBuilding`.`id`) WHERE `PropertyInformation`.`approval_for_publish` = '1' AND `PropertyInformation`.`is_disabled` = '0' AND `PropertyInformation`.`m_property_information_model_type_id` = 1 AND `PropertyInformation`.`m_area_city_id` = 27 AND `PropertyInformation`.`rent` >= 68000 AND `PropertyInformation`.`rent` <= 78000 ORDER BY `PropertyInformation`.`id` desc LIMIT 5551120
19SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 518615 ORDER BY `MPropertyBuildingStation`.`id` asc221
20SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 518615 ORDER BY `MPropertyBuildingStation`.`id` asc220
21SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 518615 ORDER BY `MPropertyBuildingStation`.`id` asc220
22SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 518615 ORDER BY `MPropertyBuildingStation`.`id` asc220
23SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 518615 ORDER BY `MPropertyBuildingStation`.`id` asc220
24SELECT `MAreaLine`.`id`, `MAreaLine`.`name` FROM `fudosan`.`app_m_area_lines` AS `MAreaLine` WHERE `MAreaLine`.`is_disabled` = '0' AND `MAreaLine`.`is_deleted` = '0'1321320
25SELECT `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified`, `MAreaLine`.`id`, `MAreaLine`.`name`, `MAreaLine`.`c_name`, `MAreaLine`.`order`, `MAreaLine`.`url`, `MAreaLine`.`is_disabled`, `MAreaLine`.`is_deleted`, `MAreaLine`.`m_area_station_count`, `MAreaLine`.`m_area_line_category_id`, `MAreaLine`.`created`, `MAreaLine`.`modified` FROM `fudosan`.`app_m_area_stations` AS `MAreaStation` LEFT JOIN `fudosan`.`app_m_area_lines` AS `MAreaLine` ON (`MAreaStation`.`m_area_line_id` = `MAreaLine`.`id`) WHERE `MAreaStation`.`is_disabled` = '0' AND `MAreaStation`.`is_deleted` = '0' AND `MAreaStation`.`m_area_city_id` = 27 ORDER BY `MAreaStation`.`m_area_line_id` asc, `MAreaStation`.`id` asc551