静かな住宅街にたたずむ、木のぬくもりを感じるおうち。ゆったりしたリビングに、空が見えるロフト。小学校や公園もすぐ近く、のびのびとした毎日がここから始まります。家族の暮らしに、やさしく寄り添う住まいです。
4LDK＋小屋裏収納＋カースペース
敷地面積：98.22m2 建物面積：93.98m2
6,280万円
見学予約受付中
| 価格 | 6,280万円 |
|---|---|
| 所在地 | 練馬区東大泉6丁目 |
| 権利 | 所有権 |
| 敷地面積 | 98.22㎡ |
| 建物面積 | 93.98㎡ |
| 建物構造 | 木造2階建 |
| 間取り | 4LDK＋小屋裏収納＋カースペース |
| 築年月 | 2009年4月 |
| 建築確認番号 | ※省略 |
| 設備 | 公営水道・本下水・東京ガス・東京電力 |
| リフォーム有無 | --- |
| リフォーム履歴内容 | |
| 接道状況 | |
| 都市計画 | 市街化区域 |
| 用途地域 | 第一種低層住居専用地域 |
|---|---|
| 高度地区 | |
| 防火指定 | |
| 建ぺい率/ 容積率 |
50%/100% |
| 引渡時期 | 相談 |
| 取引態様 | 媒介 |
| 建物仕様 | ◆三面鏡付き洗面化粧台 ◆温水洗浄便座 ◆2階洗面台 ◆床下収納 ◆2面バルコニー ◆カーポート |
| ポイント | |
| 指定学校区 | 練馬区立大泉南小学校 練馬区立大泉第二中学校 |
| 備考 |
ビッグ・エー練馬東大泉店 約450m 徒歩6分
ina21練馬東大泉店 約550m 徒歩7分
練馬区立大泉南小学校 約130m 徒歩2分
練馬区立大泉第二中学校 約450m 徒歩6分
練馬区立大泉井頭公園 約550m 徒歩7分
西武池袋線「大泉学園」駅 約960m 徒歩12分
見学予約受付中
見学予約受付中
路線検索
会員限定物件
Notice (8): Undefined variable: area_results_member [APP/Template/Element/search_Area_Railway.ctp, line 89]Code Context<?phpforeach($area_results_member as $key => $dat){?>$viewFile = '/data/WWW/rainbow/test.life-hf.co.jp/htdocs/src/Template/Element/search_Area_Railway.ctp' $dataForView = [ 'Onusedhouses' => object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Onusedhouses.id AS `Onusedhouses__id`, Onusedhouses.name AS `Onusedhouses__name`, Onusedhouses.mbAddress AS `Onusedhouses__mbAddress`, Onusedhouses.displayFlg AS `Onusedhouses__displayFlg`, Onusedhouses.statusFlg AS `Onusedhouses__statusFlg`, Onusedhouses.area_id AS `Onusedhouses__area_id`, Onusedhouses.kind_id AS `Onusedhouses__kind_id`, Onusedhouses.newoldFlg AS `Onusedhouses__newoldFlg`, Onusedhouses.tour_id AS `Onusedhouses__tour_id`, Onusedhouses.topDispFlg AS `Onusedhouses__topDispFlg`, Onusedhouses.recommFlg AS `Onusedhouses__recommFlg`, Onusedhouses.railway_id1 AS `Onusedhouses__railway_id1`, Onusedhouses.railway_id2 AS `Onusedhouses__railway_id2`, Onusedhouses.railway_id3 AS `Onusedhouses__railway_id3`, Onusedhouses.station_id1 AS `Onusedhouses__station_id1`, Onusedhouses.station_id2 AS `Onusedhouses__station_id2`, Onusedhouses.station_id3 AS `Onusedhouses__station_id3`, Onusedhouses.stwalk1 AS `Onusedhouses__stwalk1`, Onusedhouses.stwalk2 AS `Onusedhouses__stwalk2`, Onusedhouses.stwalk3 AS `Onusedhouses__stwalk3`, Onusedhouses.bswalk1 AS `Onusedhouses__bswalk1`, Onusedhouses.bswalk2 AS `Onusedhouses__bswalk2`, Onusedhouses.bswalk3 AS `Onusedhouses__bswalk3`, Onusedhouses.catchCopy AS `Onusedhouses__catchCopy`, Onusedhouses.stationStart AS `Onusedhouses__stationStart`, Onusedhouses.stationTo1 AS `Onusedhouses__stationTo1`, Onusedhouses.stationTo2 AS `Onusedhouses__stationTo2`, Onusedhouses.stationTo3 AS `Onusedhouses__stationTo3`, Onusedhouses.stationTo4 AS `Onusedhouses__stationTo4`, Onusedhouses.trainTime1 AS `Onusedhouses__trainTime1`, Onusedhouses.trainTime2 AS `Onusedhouses__trainTime2`, Onusedhouses.trainTime3 AS `Onusedhouses__trainTime3`, Onusedhouses.trainTime4 AS `Onusedhouses__trainTime4`, Onusedhouses.trainDirect1 AS `Onusedhouses__trainDirect1`, Onusedhouses.trainDirect2 AS `Onusedhouses__trainDirect2`, Onusedhouses.trainDirect3 AS `Onusedhouses__trainDirect3`, Onusedhouses.trainDirect4 AS `Onusedhouses__trainDirect4`, Onusedhouses.trainVia1 AS `Onusedhouses__trainVia1`, Onusedhouses.trainVia2 AS `Onusedhouses__trainVia2`, Onusedhouses.trainVia3 AS `Onusedhouses__trainVia3`, Onusedhouses.trainVia4 AS `Onusedhouses__trainVia4`, Onusedhouses.locationFlg AS `Onusedhouses__locationFlg`, Onusedhouses.locationTitle1 AS `Onusedhouses__locationTitle1`, Onusedhouses.locationTitle2 AS `Onusedhouses__locationTitle2`, Onusedhouses.locationTxt1 AS `Onusedhouses__locationTxt1`, Onusedhouses.locationTxt2 AS `Onusedhouses__locationTxt2`, Onusedhouses.locationTxt3 AS `Onusedhouses__locationTxt3`, Onusedhouses.locationTxt4 AS `Onusedhouses__locationTxt4`, Onusedhouses.locationTxt5 AS `Onusedhouses__locationTxt5`, Onusedhouses.locationTxt6 AS `Onusedhouses__locationTxt6`, Onusedhouses.locationTxt7 AS `Onusedhouses__locationTxt7`, Onusedhouses.locationTxt8 AS `Onusedhouses__locationTxt8`, Onusedhouses.locationTxt9 AS `Onusedhouses__locationTxt9`, Onusedhouses.locationTxt10 AS `Onusedhouses__locationTxt10`, Onusedhouses.locationTxt11 AS `Onusedhouses__locationTxt11`, Onusedhouses.locationTxt12 AS `Onusedhouses__locationTxt12`, Onusedhouses.locationTxt13 AS `Onusedhouses__locationTxt13`, Onusedhouses.locationTxt14 AS `Onusedhouses__locationTxt14`, Onusedhouses.locationTxt15 AS `Onusedhouses__locationTxt15`, Onusedhouses.locationTxt16 AS `Onusedhouses__locationTxt16`, Onusedhouses.locationTxt17 AS `Onusedhouses__locationTxt17`, Onusedhouses.locationTxt18 AS `Onusedhouses__locationTxt18`, Onusedhouses.galleryTxt1 AS `Onusedhouses__galleryTxt1`, Onusedhouses.galleryTxt2 AS `Onusedhouses__galleryTxt2`, Onusedhouses.galleryTxt3 AS `Onusedhouses__galleryTxt3`, Onusedhouses.galleryTxt4 AS `Onusedhouses__galleryTxt4`, Onusedhouses.galleryTxt5 AS `Onusedhouses__galleryTxt5`, Onusedhouses.galleryTxt6 AS `Onusedhouses__galleryTxt6`, Onusedhouses.galleryTxt7 AS `Onusedhouses__galleryTxt7`, Onusedhouses.galleryTxt8 AS `Onusedhouses__galleryTxt8`, Onusedhouses.galleryTxt9 AS `Onusedhouses__galleryTxt9`, Onusedhouses.galleryTxt10 AS `Onusedhouses__galleryTxt10`, Onusedhouses.galleryTxt11 AS `Onusedhouses__galleryTxt11`, Onusedhouses.galleryTxt12 AS `Onusedhouses__galleryTxt12`, Onusedhouses.galleryTxt13 AS `Onusedhouses__galleryTxt13`, Onusedhouses.galleryTxt14 AS `Onusedhouses__galleryTxt14`, Onusedhouses.galleryTxt15 AS `Onusedhouses__galleryTxt15`, Onusedhouses.galleryTxt16 AS `Onusedhouses__galleryTxt16`, Onusedhouses.galleryTxt17 AS `Onusedhouses__galleryTxt17`, Onusedhouses.galleryTxt18 AS `Onusedhouses__galleryTxt18`, Onusedhouses.locationTraffic AS `Onusedhouses__locationTraffic`, Onusedhouses.locationSchool AS `Onusedhouses__locationSchool`, Onusedhouses.locationLife AS `Onusedhouses__locationLife`, Onusedhouses.locationOther AS `Onusedhouses__locationOther`, Onusedhouses.planFlg AS `Onusedhouses__planFlg`, Onusedhouses.outlinePrice AS `Onusedhouses__outlinePrice`, Onusedhouses.outlinePriceNum AS `Onusedhouses__outlinePriceNum`, Onusedhouses.outlinePlace AS `Onusedhouses__outlinePlace`, Onusedhouses.outlineChiken AS `Onusedhouses__outlineChiken`, Onusedhouses.outlineLandArea AS `Onusedhouses__outlineLandArea`, Onusedhouses.outlineBuildArea AS `Onusedhouses__outlineBuildArea`, Onusedhouses.outlineConstruction AS `Onusedhouses__outlineConstruction`, Onusedhouses.outlineFloorPlan AS `Onusedhouses__outlineFloorPlan`, Onusedhouses.outlineCompTime AS `Onusedhouses__outlineCompTime`, Onusedhouses.outlineFacility AS `Onusedhouses__outlineFacility`, Onusedhouses.outlineReformYesNo AS `Onusedhouses__outlineReformYesNo`, Onusedhouses.outlineReformContents AS `Onusedhouses__outlineReformContents`, Onusedhouses.outlineApproach AS `Onusedhouses__outlineApproach`, Onusedhouses.outlineCityplan AS `Onusedhouses__outlineCityplan`, Onusedhouses.outlineUse1 AS `Onusedhouses__outlineUse1`, Onusedhouses.outlineUse2 AS `Onusedhouses__outlineUse2`, Onusedhouses.outlineAltitude1 AS `Onusedhouses__outlineAltitude1`, Onusedhouses.outlineAltitude2 AS `Onusedhouses__outlineAltitude2`, Onusedhouses.outlineFire1 AS `Onusedhouses__outlineFire1`, Onusedhouses.outlineFire2 AS `Onusedhouses__outlineFire2`, Onusedhouses.outlineVolume1 AS `Onusedhouses__outlineVolume1`, Onusedhouses.outlineVolume2 AS `Onusedhouses__outlineVolume2`, Onusedhouses.outlineBuldingNo AS `Onusedhouses__outlineBuldingNo`, Onusedhouses.outlineDelivTime AS `Onusedhouses__outlineDelivTime`, Onusedhouses.outlineTransForm AS `Onusedhouses__outlineTransForm`, Onusedhouses.outlineEquipment AS `Onusedhouses__outlineEquipment`, Onusedhouses.outlineComment AS `Onusedhouses__outlineComment`, Onusedhouses.outlineSchool AS `Onusedhouses__outlineSchool`, Onusedhouses.googleMap AS `Onusedhouses__googleMap`, Onusedhouses.memo AS `Onusedhouses__memo`, Onusedhouses.priceFlg AS `Onusedhouses__priceFlg`, Onusedhouses.newFlg AS `Onusedhouses__newFlg`, Onusedhouses.lastFlg AS `Onusedhouses__lastFlg`, Onusedhouses.topImgFlg AS `Onusedhouses__topImgFlg`, Onusedhouses.memberFlg AS `Onusedhouses__memberFlg`, Onusedhouses.deleteFlg AS `Onusedhouses__deleteFlg`, Onusedhouses.created AS `Onusedhouses__created`, Onusedhouses.modified AS `Onusedhouses__modified`, Areas.id AS `Areas__id`, Areas.areaClass_cd AS `Areas__areaClass_cd`, Areas.name AS `Areas__name`, Areas.sortPt AS `Areas__sortPt`, Areas.editDate AS `Areas__editDate`, Kinds.id AS `Kinds__id`, Kinds.name AS `Kinds__name`, Kinds.sortPt AS `Kinds__sortPt`, Kinds.editDate AS `Kinds__editDate`, Tours.id AS `Tours__id`, Tours.name AS `Tours__name`, Tours.sortPt AS `Tours__sortPt`, Tours.category AS `Tours__category`, Tours.editDate AS `Tours__editDate`, Railways1.id AS `Railways1__id`, Railways1.name AS `Railways1__name`, Railways1.sortPt AS `Railways1__sortPt`, Railways1.editDate AS `Railways1__editDate`, Railways2.id AS `Railways2__id`, Railways2.name AS `Railways2__name`, Railways2.sortPt AS `Railways2__sortPt`, Railways2.editDate AS `Railways2__editDate`, Railways3.id AS `Railways3__id`, Railways3.name AS `Railways3__name`, Railways3.sortPt AS `Railways3__sortPt`, Railways3.editDate AS `Railways3__editDate`, Stations1.id AS `Stations1__id`, Stations1.name AS `Stations1__name`, Stations1.railway_id AS `Stations1__railway_id`, Stations1.pref_cd AS `Stations1__pref_cd`, Stations1.sortPt AS `Stations1__sortPt`, Stations1.editDate AS `Stations1__editDate`, Stations2.id AS `Stations2__id`, Stations2.name AS `Stations2__name`, Stations2.railway_id AS `Stations2__railway_id`, Stations2.pref_cd AS `Stations2__pref_cd`, Stations2.sortPt AS `Stations2__sortPt`, Stations2.editDate AS `Stations2__editDate`, Stations3.id AS `Stations3__id`, Stations3.name AS `Stations3__name`, Stations3.railway_id AS `Stations3__railway_id`, Stations3.pref_cd AS `Stations3__pref_cd`, Stations3.sortPt AS `Stations3__sortPt`, Stations3.editDate AS `Stations3__editDate` FROM onusedhouses Onusedhouses INNER JOIN areas Areas ON Areas.id = (Onusedhouses.area_id) LEFT JOIN kinds Kinds ON Kinds.id = (Onusedhouses.kind_id) LEFT JOIN tours Tours ON Tours.id = (Onusedhouses.tour_id) LEFT JOIN railways Railways1 ON Railways1.id = (Onusedhouses.railway_id1) LEFT JOIN railways Railways2 ON Railways2.id = (Onusedhouses.railway_id2) LEFT JOIN railways Railways3 ON Railways3.id = (Onusedhouses.railway_id3) LEFT JOIN stations Stations1 ON Stations1.id = (Onusedhouses.station_id1) LEFT JOIN stations Stations2 ON Stations2.id = (Onusedhouses.station_id2) LEFT JOIN stations Stations3 ON Stations3.id = (Onusedhouses.station_id3) WHERE Onusedhouses.id = :c0', 'params' => [ [maximum depth reached] ], 'defaultTypes' => [ [maximum depth reached] ], 'decorators' => (int) 0, 'executed' => true, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ [maximum depth reached] ], 'matching' => [[maximum depth reached]], 'extraOptions' => [[maximum depth reached]], 'repository' => object(App\Model\Table\OnusedhousesTable) {} }, 'area_results' => [ (int) 0 => [ 'area_id' => '1', 'name' => '杉並区', 'Ct' => '44', 'CtM' => '17' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '24', 'CtM' => '1' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '7', 'CtM' => '0' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '2', 'CtM' => '0' ], (int) 4 => [ 'area_id' => '8', 'name' => '新宿区', 'Ct' => '2', 'CtM' => '0' ], (int) 5 => [ 'area_id' => '9', 'name' => '豊島区', 'Ct' => '1', 'CtM' => '0' ], (int) 6 => [ 'area_id' => '10', 'name' => '渋谷区', 'Ct' => '1', 'CtM' => '0' ], (int) 7 => [ 'area_id' => '24', 'name' => '武蔵野市', 'Ct' => '3', 'CtM' => '0' ], (int) 8 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 9 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '3', 'CtM' => '0' ] ], 'railway_results' => [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '3' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '58' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '9' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '2' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '37' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '64' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '10' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '30' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '2' ], (int) 10 => [ 'rway' => '26003', 'name' => '東急田園都市線', 'ct' => '1' ], (int) 11 => [ 'rway' => '26007', 'name' => '東急世田谷線', 'ct' => '2' ], (int) 12 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '24' ], (int) 13 => [ 'rway' => '28004', 'name' => '東京メトロ東西線', 'ct' => '1' ], (int) 14 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 15 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '5' ], (int) 16 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ], 'OptionCT' => [ 'railway' => (int) 19, 'pet' => (int) 9, 'life' => (int) 61, 'space' => (int) 18 ], 'user' => null, 'NoList' => true, 'members_total' => '19' ] $Onusedhouses = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Onusedhouses.id AS `Onusedhouses__id`, Onusedhouses.name AS `Onusedhouses__name`, Onusedhouses.mbAddress AS `Onusedhouses__mbAddress`, Onusedhouses.displayFlg AS `Onusedhouses__displayFlg`, Onusedhouses.statusFlg AS `Onusedhouses__statusFlg`, Onusedhouses.area_id AS `Onusedhouses__area_id`, Onusedhouses.kind_id AS `Onusedhouses__kind_id`, Onusedhouses.newoldFlg AS `Onusedhouses__newoldFlg`, Onusedhouses.tour_id AS `Onusedhouses__tour_id`, Onusedhouses.topDispFlg AS `Onusedhouses__topDispFlg`, Onusedhouses.recommFlg AS `Onusedhouses__recommFlg`, Onusedhouses.railway_id1 AS `Onusedhouses__railway_id1`, Onusedhouses.railway_id2 AS `Onusedhouses__railway_id2`, Onusedhouses.railway_id3 AS `Onusedhouses__railway_id3`, Onusedhouses.station_id1 AS `Onusedhouses__station_id1`, Onusedhouses.station_id2 AS `Onusedhouses__station_id2`, Onusedhouses.station_id3 AS `Onusedhouses__station_id3`, Onusedhouses.stwalk1 AS `Onusedhouses__stwalk1`, Onusedhouses.stwalk2 AS `Onusedhouses__stwalk2`, Onusedhouses.stwalk3 AS `Onusedhouses__stwalk3`, Onusedhouses.bswalk1 AS `Onusedhouses__bswalk1`, Onusedhouses.bswalk2 AS `Onusedhouses__bswalk2`, Onusedhouses.bswalk3 AS `Onusedhouses__bswalk3`, Onusedhouses.catchCopy AS `Onusedhouses__catchCopy`, Onusedhouses.stationStart AS `Onusedhouses__stationStart`, Onusedhouses.stationTo1 AS `Onusedhouses__stationTo1`, Onusedhouses.stationTo2 AS `Onusedhouses__stationTo2`, Onusedhouses.stationTo3 AS `Onusedhouses__stationTo3`, Onusedhouses.stationTo4 AS `Onusedhouses__stationTo4`, Onusedhouses.trainTime1 AS `Onusedhouses__trainTime1`, Onusedhouses.trainTime2 AS `Onusedhouses__trainTime2`, Onusedhouses.trainTime3 AS `Onusedhouses__trainTime3`, Onusedhouses.trainTime4 AS `Onusedhouses__trainTime4`, Onusedhouses.trainDirect1 AS `Onusedhouses__trainDirect1`, Onusedhouses.trainDirect2 AS `Onusedhouses__trainDirect2`, Onusedhouses.trainDirect3 AS `Onusedhouses__trainDirect3`, Onusedhouses.trainDirect4 AS `Onusedhouses__trainDirect4`, Onusedhouses.trainVia1 AS `Onusedhouses__trainVia1`, Onusedhouses.trainVia2 AS `Onusedhouses__trainVia2`, Onusedhouses.trainVia3 AS `Onusedhouses__trainVia3`, Onusedhouses.trainVia4 AS `Onusedhouses__trainVia4`, Onusedhouses.locationFlg AS `Onusedhouses__locationFlg`, Onusedhouses.locationTitle1 AS `Onusedhouses__locationTitle1`, Onusedhouses.locationTitle2 AS `Onusedhouses__locationTitle2`, Onusedhouses.locationTxt1 AS `Onusedhouses__locationTxt1`, Onusedhouses.locationTxt2 AS `Onusedhouses__locationTxt2`, Onusedhouses.locationTxt3 AS `Onusedhouses__locationTxt3`, Onusedhouses.locationTxt4 AS `Onusedhouses__locationTxt4`, Onusedhouses.locationTxt5 AS `Onusedhouses__locationTxt5`, Onusedhouses.locationTxt6 AS `Onusedhouses__locationTxt6`, Onusedhouses.locationTxt7 AS `Onusedhouses__locationTxt7`, Onusedhouses.locationTxt8 AS `Onusedhouses__locationTxt8`, Onusedhouses.locationTxt9 AS `Onusedhouses__locationTxt9`, Onusedhouses.locationTxt10 AS `Onusedhouses__locationTxt10`, Onusedhouses.locationTxt11 AS `Onusedhouses__locationTxt11`, Onusedhouses.locationTxt12 AS `Onusedhouses__locationTxt12`, Onusedhouses.locationTxt13 AS `Onusedhouses__locationTxt13`, Onusedhouses.locationTxt14 AS `Onusedhouses__locationTxt14`, Onusedhouses.locationTxt15 AS `Onusedhouses__locationTxt15`, Onusedhouses.locationTxt16 AS `Onusedhouses__locationTxt16`, Onusedhouses.locationTxt17 AS `Onusedhouses__locationTxt17`, Onusedhouses.locationTxt18 AS `Onusedhouses__locationTxt18`, Onusedhouses.galleryTxt1 AS `Onusedhouses__galleryTxt1`, Onusedhouses.galleryTxt2 AS `Onusedhouses__galleryTxt2`, Onusedhouses.galleryTxt3 AS `Onusedhouses__galleryTxt3`, Onusedhouses.galleryTxt4 AS `Onusedhouses__galleryTxt4`, Onusedhouses.galleryTxt5 AS `Onusedhouses__galleryTxt5`, Onusedhouses.galleryTxt6 AS `Onusedhouses__galleryTxt6`, Onusedhouses.galleryTxt7 AS `Onusedhouses__galleryTxt7`, Onusedhouses.galleryTxt8 AS `Onusedhouses__galleryTxt8`, Onusedhouses.galleryTxt9 AS `Onusedhouses__galleryTxt9`, Onusedhouses.galleryTxt10 AS `Onusedhouses__galleryTxt10`, Onusedhouses.galleryTxt11 AS `Onusedhouses__galleryTxt11`, Onusedhouses.galleryTxt12 AS `Onusedhouses__galleryTxt12`, Onusedhouses.galleryTxt13 AS `Onusedhouses__galleryTxt13`, Onusedhouses.galleryTxt14 AS `Onusedhouses__galleryTxt14`, Onusedhouses.galleryTxt15 AS `Onusedhouses__galleryTxt15`, Onusedhouses.galleryTxt16 AS `Onusedhouses__galleryTxt16`, Onusedhouses.galleryTxt17 AS `Onusedhouses__galleryTxt17`, Onusedhouses.galleryTxt18 AS `Onusedhouses__galleryTxt18`, Onusedhouses.locationTraffic AS `Onusedhouses__locationTraffic`, Onusedhouses.locationSchool AS `Onusedhouses__locationSchool`, Onusedhouses.locationLife AS `Onusedhouses__locationLife`, Onusedhouses.locationOther AS `Onusedhouses__locationOther`, Onusedhouses.planFlg AS `Onusedhouses__planFlg`, Onusedhouses.outlinePrice AS `Onusedhouses__outlinePrice`, Onusedhouses.outlinePriceNum AS `Onusedhouses__outlinePriceNum`, Onusedhouses.outlinePlace AS `Onusedhouses__outlinePlace`, Onusedhouses.outlineChiken AS `Onusedhouses__outlineChiken`, Onusedhouses.outlineLandArea AS `Onusedhouses__outlineLandArea`, Onusedhouses.outlineBuildArea AS `Onusedhouses__outlineBuildArea`, Onusedhouses.outlineConstruction AS `Onusedhouses__outlineConstruction`, Onusedhouses.outlineFloorPlan AS `Onusedhouses__outlineFloorPlan`, Onusedhouses.outlineCompTime AS `Onusedhouses__outlineCompTime`, Onusedhouses.outlineFacility AS `Onusedhouses__outlineFacility`, Onusedhouses.outlineReformYesNo AS `Onusedhouses__outlineReformYesNo`, Onusedhouses.outlineReformContents AS `Onusedhouses__outlineReformContents`, Onusedhouses.outlineApproach AS `Onusedhouses__outlineApproach`, Onusedhouses.outlineCityplan AS `Onusedhouses__outlineCityplan`, Onusedhouses.outlineUse1 AS `Onusedhouses__outlineUse1`, Onusedhouses.outlineUse2 AS `Onusedhouses__outlineUse2`, Onusedhouses.outlineAltitude1 AS `Onusedhouses__outlineAltitude1`, Onusedhouses.outlineAltitude2 AS `Onusedhouses__outlineAltitude2`, Onusedhouses.outlineFire1 AS `Onusedhouses__outlineFire1`, Onusedhouses.outlineFire2 AS `Onusedhouses__outlineFire2`, Onusedhouses.outlineVolume1 AS `Onusedhouses__outlineVolume1`, Onusedhouses.outlineVolume2 AS `Onusedhouses__outlineVolume2`, Onusedhouses.outlineBuldingNo AS `Onusedhouses__outlineBuldingNo`, Onusedhouses.outlineDelivTime AS `Onusedhouses__outlineDelivTime`, Onusedhouses.outlineTransForm AS `Onusedhouses__outlineTransForm`, Onusedhouses.outlineEquipment AS `Onusedhouses__outlineEquipment`, Onusedhouses.outlineComment AS `Onusedhouses__outlineComment`, Onusedhouses.outlineSchool AS `Onusedhouses__outlineSchool`, Onusedhouses.googleMap AS `Onusedhouses__googleMap`, Onusedhouses.memo AS `Onusedhouses__memo`, Onusedhouses.priceFlg AS `Onusedhouses__priceFlg`, Onusedhouses.newFlg AS `Onusedhouses__newFlg`, Onusedhouses.lastFlg AS `Onusedhouses__lastFlg`, Onusedhouses.topImgFlg AS `Onusedhouses__topImgFlg`, Onusedhouses.memberFlg AS `Onusedhouses__memberFlg`, Onusedhouses.deleteFlg AS `Onusedhouses__deleteFlg`, Onusedhouses.created AS `Onusedhouses__created`, Onusedhouses.modified AS `Onusedhouses__modified`, Areas.id AS `Areas__id`, Areas.areaClass_cd AS `Areas__areaClass_cd`, Areas.name AS `Areas__name`, Areas.sortPt AS `Areas__sortPt`, Areas.editDate AS `Areas__editDate`, Kinds.id AS `Kinds__id`, Kinds.name AS `Kinds__name`, Kinds.sortPt AS `Kinds__sortPt`, Kinds.editDate AS `Kinds__editDate`, Tours.id AS `Tours__id`, Tours.name AS `Tours__name`, Tours.sortPt AS `Tours__sortPt`, Tours.category AS `Tours__category`, Tours.editDate AS `Tours__editDate`, Railways1.id AS `Railways1__id`, Railways1.name AS `Railways1__name`, Railways1.sortPt AS `Railways1__sortPt`, Railways1.editDate AS `Railways1__editDate`, Railways2.id AS `Railways2__id`, Railways2.name AS `Railways2__name`, Railways2.sortPt AS `Railways2__sortPt`, Railways2.editDate AS `Railways2__editDate`, Railways3.id AS `Railways3__id`, Railways3.name AS `Railways3__name`, Railways3.sortPt AS `Railways3__sortPt`, Railways3.editDate AS `Railways3__editDate`, Stations1.id AS `Stations1__id`, Stations1.name AS `Stations1__name`, Stations1.railway_id AS `Stations1__railway_id`, Stations1.pref_cd AS `Stations1__pref_cd`, Stations1.sortPt AS `Stations1__sortPt`, Stations1.editDate AS `Stations1__editDate`, Stations2.id AS `Stations2__id`, Stations2.name AS `Stations2__name`, Stations2.railway_id AS `Stations2__railway_id`, Stations2.pref_cd AS `Stations2__pref_cd`, Stations2.sortPt AS `Stations2__sortPt`, Stations2.editDate AS `Stations2__editDate`, Stations3.id AS `Stations3__id`, Stations3.name AS `Stations3__name`, Stations3.railway_id AS `Stations3__railway_id`, Stations3.pref_cd AS `Stations3__pref_cd`, Stations3.sortPt AS `Stations3__sortPt`, Stations3.editDate AS `Stations3__editDate` FROM onusedhouses Onusedhouses INNER JOIN areas Areas ON Areas.id = (Onusedhouses.area_id) LEFT JOIN kinds Kinds ON Kinds.id = (Onusedhouses.kind_id) LEFT JOIN tours Tours ON Tours.id = (Onusedhouses.tour_id) LEFT JOIN railways Railways1 ON Railways1.id = (Onusedhouses.railway_id1) LEFT JOIN railways Railways2 ON Railways2.id = (Onusedhouses.railway_id2) LEFT JOIN railways Railways3 ON Railways3.id = (Onusedhouses.railway_id3) LEFT JOIN stations Stations1 ON Stations1.id = (Onusedhouses.station_id1) LEFT JOIN stations Stations2 ON Stations2.id = (Onusedhouses.station_id2) LEFT JOIN stations Stations3 ON Stations3.id = (Onusedhouses.station_id3) WHERE Onusedhouses.id = :c0', 'params' => [ ':c0' => [ [maximum depth reached] ] ], 'defaultTypes' => [ 'Onusedhouses__id' => 'integer', 'Onusedhouses.id' => 'integer', 'id' => 'integer', 'Onusedhouses__name' => 'string', 'Onusedhouses.name' => 'string', 'name' => 'string', 'Onusedhouses__mbAddress' => 'string', 'Onusedhouses.mbAddress' => 'string', 'mbAddress' => 'string', 'Onusedhouses__displayFlg' => 'tinyinteger', 'Onusedhouses.displayFlg' => 'tinyinteger', 'displayFlg' => 'tinyinteger', 'Onusedhouses__statusFlg' => 'tinyinteger', 'Onusedhouses.statusFlg' => 'tinyinteger', 'statusFlg' => 'tinyinteger', 'Onusedhouses__area_id' => 'integer', 'Onusedhouses.area_id' => 'integer', 'area_id' => 'integer', 'Onusedhouses__kind_id' => 'integer', 'Onusedhouses.kind_id' => 'integer', 'kind_id' => 'integer', 'Onusedhouses__newoldFlg' => 'tinyinteger', 'Onusedhouses.newoldFlg' => 'tinyinteger', 'newoldFlg' => 'tinyinteger', 'Onusedhouses__tour_id' => 'integer', 'Onusedhouses.tour_id' => 'integer', 'tour_id' => 'integer', 'Onusedhouses__topDispFlg' => 'tinyinteger', 'Onusedhouses.topDispFlg' => 'tinyinteger', 'topDispFlg' => 'tinyinteger', 'Onusedhouses__recommFlg' => 'tinyinteger', 'Onusedhouses.recommFlg' => 'tinyinteger', 'recommFlg' => 'tinyinteger', 'Onusedhouses__railway_id1' => 'integer', 'Onusedhouses.railway_id1' => 'integer', 'railway_id1' => 'integer', 'Onusedhouses__railway_id2' => 'integer', 'Onusedhouses.railway_id2' => 'integer', 'railway_id2' => 'integer', 'Onusedhouses__railway_id3' => 'integer', 'Onusedhouses.railway_id3' => 'integer', 'railway_id3' => 'integer', 'Onusedhouses__station_id1' => 'integer', 'Onusedhouses.station_id1' => 'integer', 'station_id1' => 'integer', 'Onusedhouses__station_id2' => 'integer', 'Onusedhouses.station_id2' => 'integer', 'station_id2' => 'integer', 'Onusedhouses__station_id3' => 'integer', 'Onusedhouses.station_id3' => 'integer', 'station_id3' => 'integer', 'Onusedhouses__stwalk1' => 'string', 'Onusedhouses.stwalk1' => 'string', 'stwalk1' => 'string', 'Onusedhouses__stwalk2' => 'string', 'Onusedhouses.stwalk2' => 'string', 'stwalk2' => 'string', 'Onusedhouses__stwalk3' => 'string', 'Onusedhouses.stwalk3' => 'string', 'stwalk3' => 'string', 'Onusedhouses__bswalk1' => 'string', 'Onusedhouses.bswalk1' => 'string', 'bswalk1' => 'string', 'Onusedhouses__bswalk2' => 'string', 'Onusedhouses.bswalk2' => 'string', 'bswalk2' => 'string', 'Onusedhouses__bswalk3' => 'string', 'Onusedhouses.bswalk3' => 'string', 'bswalk3' => 'string', 'Onusedhouses__catchCopy' => 'string', 'Onusedhouses.catchCopy' => 'string', 'catchCopy' => 'string', 'Onusedhouses__stationStart' => 'string', 'Onusedhouses.stationStart' => 'string', 'stationStart' => 'string', 'Onusedhouses__stationTo1' => 'string', 'Onusedhouses.stationTo1' => 'string', 'stationTo1' => 'string', 'Onusedhouses__stationTo2' => 'string', 'Onusedhouses.stationTo2' => 'string', 'stationTo2' => 'string', 'Onusedhouses__stationTo3' => 'string', 'Onusedhouses.stationTo3' => 'string', 'stationTo3' => 'string', 'Onusedhouses__stationTo4' => 'string', 'Onusedhouses.stationTo4' => 'string', 'stationTo4' => 'string', 'Onusedhouses__trainTime1' => 'tinyinteger', 'Onusedhouses.trainTime1' => 'tinyinteger', 'trainTime1' => 'tinyinteger', 'Onusedhouses__trainTime2' => 'tinyinteger', 'Onusedhouses.trainTime2' => 'tinyinteger', 'trainTime2' => 'tinyinteger', 'Onusedhouses__trainTime3' => 'tinyinteger', 'Onusedhouses.trainTime3' => 'tinyinteger', 'trainTime3' => 'tinyinteger', 'Onusedhouses__trainTime4' => 'tinyinteger', 'Onusedhouses.trainTime4' => 'tinyinteger', 'trainTime4' => 'tinyinteger', 'Onusedhouses__trainDirect1' => 'tinyinteger', 'Onusedhouses.trainDirect1' => 'tinyinteger', 'trainDirect1' => 'tinyinteger', 'Onusedhouses__trainDirect2' => 'tinyinteger', 'Onusedhouses.trainDirect2' => 'tinyinteger', 'trainDirect2' => 'tinyinteger', 'Onusedhouses__trainDirect3' => 'tinyinteger', 'Onusedhouses.trainDirect3' => 'tinyinteger', 'trainDirect3' => 'tinyinteger', 'Onusedhouses__trainDirect4' => 'tinyinteger', 'Onusedhouses.trainDirect4' => 'tinyinteger', 'trainDirect4' => 'tinyinteger', 'Onusedhouses__trainVia1' => 'string', 'Onusedhouses.trainVia1' => 'string', 'trainVia1' => 'string', 'Onusedhouses__trainVia2' => 'string', 'Onusedhouses.trainVia2' => 'string', 'trainVia2' => 'string', 'Onusedhouses__trainVia3' => 'string', 'Onusedhouses.trainVia3' => 'string', 'trainVia3' => 'string', 'Onusedhouses__trainVia4' => 'string', 'Onusedhouses.trainVia4' => 'string', 'trainVia4' => 'string', 'Onusedhouses__locationFlg' => 'tinyinteger', 'Onusedhouses.locationFlg' => 'tinyinteger', 'locationFlg' => 'tinyinteger', 'Onusedhouses__locationTitle1' => 'string', 'Onusedhouses.locationTitle1' => 'string', 'locationTitle1' => 'string', 'Onusedhouses__locationTitle2' => 'string', 'Onusedhouses.locationTitle2' => 'string', 'locationTitle2' => 'string', 'Onusedhouses__locationTxt1' => 'string', 'Onusedhouses.locationTxt1' => 'string', 'locationTxt1' => 'string', 'Onusedhouses__locationTxt2' => 'string', 'Onusedhouses.locationTxt2' => 'string', 'locationTxt2' => 'string', 'Onusedhouses__locationTxt3' => 'string', 'Onusedhouses.locationTxt3' => 'string', 'locationTxt3' => 'string', 'Onusedhouses__locationTxt4' => 'string', 'Onusedhouses.locationTxt4' => 'string', 'locationTxt4' => 'string', 'Onusedhouses__locationTxt5' => 'string', 'Onusedhouses.locationTxt5' => 'string', 'locationTxt5' => 'string', 'Onusedhouses__locationTxt6' => 'string', 'Onusedhouses.locationTxt6' => 'string', 'locationTxt6' => 'string', 'Onusedhouses__locationTxt7' => 'string', 'Onusedhouses.locationTxt7' => 'string', 'locationTxt7' => 'string', 'Onusedhouses__locationTxt8' => 'string', 'Onusedhouses.locationTxt8' => 'string', 'locationTxt8' => 'string', 'Onusedhouses__locationTxt9' => 'string', 'Onusedhouses.locationTxt9' => 'string', 'locationTxt9' => 'string', 'Onusedhouses__locationTxt10' => 'string', 'Onusedhouses.locationTxt10' => 'string', 'locationTxt10' => 'string', 'Onusedhouses__locationTxt11' => 'string', 'Onusedhouses.locationTxt11' => 'string', 'locationTxt11' => 'string', 'Onusedhouses__locationTxt12' => 'string', 'Onusedhouses.locationTxt12' => 'string', 'locationTxt12' => 'string', 'Onusedhouses__locationTxt13' => 'string', 'Onusedhouses.locationTxt13' => 'string', 'locationTxt13' => 'string', 'Onusedhouses__locationTxt14' => 'string', 'Onusedhouses.locationTxt14' => 'string', 'locationTxt14' => 'string', 'Onusedhouses__locationTxt15' => 'string', 'Onusedhouses.locationTxt15' => 'string', 'locationTxt15' => 'string', 'Onusedhouses__locationTxt16' => 'string', 'Onusedhouses.locationTxt16' => 'string', 'locationTxt16' => 'string', 'Onusedhouses__locationTxt17' => 'string', 'Onusedhouses.locationTxt17' => 'string', 'locationTxt17' => 'string', 'Onusedhouses__locationTxt18' => 'string', 'Onusedhouses.locationTxt18' => 'string', 'locationTxt18' => 'string', 'Onusedhouses__galleryTxt1' => 'string', 'Onusedhouses.galleryTxt1' => 'string', 'galleryTxt1' => 'string', 'Onusedhouses__galleryTxt2' => 'string', 'Onusedhouses.galleryTxt2' => 'string', 'galleryTxt2' => 'string', 'Onusedhouses__galleryTxt3' => 'string', 'Onusedhouses.galleryTxt3' => 'string', 'galleryTxt3' => 'string', 'Onusedhouses__galleryTxt4' => 'string', 'Onusedhouses.galleryTxt4' => 'string', 'galleryTxt4' => 'string', 'Onusedhouses__galleryTxt5' => 'string', 'Onusedhouses.galleryTxt5' => 'string', 'galleryTxt5' => 'string', 'Onusedhouses__galleryTxt6' => 'string', 'Onusedhouses.galleryTxt6' => 'string', 'galleryTxt6' => 'string', 'Onusedhouses__galleryTxt7' => 'string', 'Onusedhouses.galleryTxt7' => 'string', 'galleryTxt7' => 'string', 'Onusedhouses__galleryTxt8' => 'string', 'Onusedhouses.galleryTxt8' => 'string', 'galleryTxt8' => 'string', 'Onusedhouses__galleryTxt9' => 'string', 'Onusedhouses.galleryTxt9' => 'string', 'galleryTxt9' => 'string', 'Onusedhouses__galleryTxt10' => 'string', 'Onusedhouses.galleryTxt10' => 'string', 'galleryTxt10' => 'string', 'Onusedhouses__galleryTxt11' => 'string', 'Onusedhouses.galleryTxt11' => 'string', 'galleryTxt11' => 'string', 'Onusedhouses__galleryTxt12' => 'string', 'Onusedhouses.galleryTxt12' => 'string', 'galleryTxt12' => 'string', 'Onusedhouses__galleryTxt13' => 'string', 'Onusedhouses.galleryTxt13' => 'string', 'galleryTxt13' => 'string', 'Onusedhouses__galleryTxt14' => 'string', 'Onusedhouses.galleryTxt14' => 'string', 'galleryTxt14' => 'string', 'Onusedhouses__galleryTxt15' => 'string', 'Onusedhouses.galleryTxt15' => 'string', 'galleryTxt15' => 'string', 'Onusedhouses__galleryTxt16' => 'string', 'Onusedhouses.galleryTxt16' => 'string', 'galleryTxt16' => 'string', 'Onusedhouses__galleryTxt17' => 'string', 'Onusedhouses.galleryTxt17' => 'string', 'galleryTxt17' => 'string', 'Onusedhouses__galleryTxt18' => 'string', 'Onusedhouses.galleryTxt18' => 'string', 'galleryTxt18' => 'string', 'Onusedhouses__locationTraffic' => 'string', 'Onusedhouses.locationTraffic' => 'string', 'locationTraffic' => 'string', 'Onusedhouses__locationSchool' => 'string', 'Onusedhouses.locationSchool' => 'string', 'locationSchool' => 'string', 'Onusedhouses__locationLife' => 'string', 'Onusedhouses.locationLife' => 'string', 'locationLife' => 'string', 'Onusedhouses__locationOther' => 'string', 'Onusedhouses.locationOther' => 'string', 'locationOther' => 'string', 'Onusedhouses__planFlg' => 'tinyinteger', 'Onusedhouses.planFlg' => 'tinyinteger', 'planFlg' => 'tinyinteger', 'Onusedhouses__outlinePrice' => 'decimal', 'Onusedhouses.outlinePrice' => 'decimal', 'outlinePrice' => 'decimal', 'Onusedhouses__outlinePriceNum' => 'integer', 'Onusedhouses.outlinePriceNum' => 'integer', 'outlinePriceNum' => 'integer', 'Onusedhouses__outlinePlace' => 'string', 'Onusedhouses.outlinePlace' => 'string', 'outlinePlace' => 'string', 'Onusedhouses__outlineChiken' => 'tinyinteger', 'Onusedhouses.outlineChiken' => 'tinyinteger', 'outlineChiken' => 'tinyinteger', 'Onusedhouses__outlineLandArea' => 'decimal', 'Onusedhouses.outlineLandArea' => 'decimal', 'outlineLandArea' => 'decimal', 'Onusedhouses__outlineBuildArea' => 'decimal', 'Onusedhouses.outlineBuildArea' => 'decimal', 'outlineBuildArea' => 'decimal', 'Onusedhouses__outlineConstruction' => 'string', 'Onusedhouses.outlineConstruction' => 'string', 'outlineConstruction' => 'string', 'Onusedhouses__outlineFloorPlan' => 'string', 'Onusedhouses.outlineFloorPlan' => 'string', 'outlineFloorPlan' => 'string', 'Onusedhouses__outlineCompTime' => 'string', 'Onusedhouses.outlineCompTime' => 'string', 'outlineCompTime' => 'string', 'Onusedhouses__outlineFacility' => 'string', 'Onusedhouses.outlineFacility' => 'string', 'outlineFacility' => 'string', 'Onusedhouses__outlineReformYesNo' => 'tinyinteger', 'Onusedhouses.outlineReformYesNo' => 'tinyinteger', 'outlineReformYesNo' => 'tinyinteger', 'Onusedhouses__outlineReformContents' => 'string', 'Onusedhouses.outlineReformContents' => 'string', 'outlineReformContents' => 'string', 'Onusedhouses__outlineApproach' => 'string', 'Onusedhouses.outlineApproach' => 'string', 'outlineApproach' => 'string', 'Onusedhouses__outlineCityplan' => 'string', 'Onusedhouses.outlineCityplan' => 'string', 'outlineCityplan' => 'string', 'Onusedhouses__outlineUse1' => 'string', 'Onusedhouses.outlineUse1' => 'string', 'outlineUse1' => 'string', 'Onusedhouses__outlineUse2' => 'string', 'Onusedhouses.outlineUse2' => 'string', 'outlineUse2' => 'string', 'Onusedhouses__outlineAltitude1' => 'string', 'Onusedhouses.outlineAltitude1' => 'string', 'outlineAltitude1' => 'string', 'Onusedhouses__outlineAltitude2' => 'string', 'Onusedhouses.outlineAltitude2' => 'string', 'outlineAltitude2' => 'string', 'Onusedhouses__outlineFire1' => 'string', 'Onusedhouses.outlineFire1' => 'string', 'outlineFire1' => 'string', 'Onusedhouses__outlineFire2' => 'string', 'Onusedhouses.outlineFire2' => 'string', 'outlineFire2' => 'string', 'Onusedhouses__outlineVolume1' => 'string', 'Onusedhouses.outlineVolume1' => 'string', 'outlineVolume1' => 'string', 'Onusedhouses__outlineVolume2' => 'string', 'Onusedhouses.outlineVolume2' => 'string', 'outlineVolume2' => 'string', 'Onusedhouses__outlineBuldingNo' => 'string', 'Onusedhouses.outlineBuldingNo' => 'string', 'outlineBuldingNo' => 'string', 'Onusedhouses__outlineDelivTime' => 'string', 'Onusedhouses.outlineDelivTime' => 'string', 'outlineDelivTime' => 'string', 'Onusedhouses__outlineTransForm' => 'string', 'Onusedhouses.outlineTransForm' => 'string', 'outlineTransForm' => 'string', 'Onusedhouses__outlineEquipment' => 'string', 'Onusedhouses.outlineEquipment' => 'string', 'outlineEquipment' => 'string', 'Onusedhouses__outlineComment' => 'string', 'Onusedhouses.outlineComment' => 'string', 'outlineComment' => 'string', 'Onusedhouses__outlineSchool' => 'string', 'Onusedhouses.outlineSchool' => 'string', 'outlineSchool' => 'string', 'Onusedhouses__googleMap' => 'string', 'Onusedhouses.googleMap' => 'string', 'googleMap' => 'string', 'Onusedhouses__memo' => 'string', 'Onusedhouses.memo' => 'string', 'memo' => 'string', 'Onusedhouses__priceFlg' => 'tinyinteger', 'Onusedhouses.priceFlg' => 'tinyinteger', 'priceFlg' => 'tinyinteger', 'Onusedhouses__newFlg' => 'tinyinteger', 'Onusedhouses.newFlg' => 'tinyinteger', 'newFlg' => 'tinyinteger', 'Onusedhouses__lastFlg' => 'tinyinteger', 'Onusedhouses.lastFlg' => 'tinyinteger', 'lastFlg' => 'tinyinteger', 'Onusedhouses__topImgFlg' => 'tinyinteger', 'Onusedhouses.topImgFlg' => 'tinyinteger', 'topImgFlg' => 'tinyinteger', 'Onusedhouses__memberFlg' => 'tinyinteger', 'Onusedhouses.memberFlg' => 'tinyinteger', 'memberFlg' => 'tinyinteger', 'Onusedhouses__deleteFlg' => 'tinyinteger', 'Onusedhouses.deleteFlg' => 'tinyinteger', 'deleteFlg' => 'tinyinteger', 'Onusedhouses__created' => 'datetime', 'Onusedhouses.created' => 'datetime', 'created' => 'datetime', 'Onusedhouses__modified' => 'datetime', 'Onusedhouses.modified' => 'datetime', 'modified' => 'datetime', 'Areas__id' => 'integer', 'Areas.id' => 'integer', 'Areas__areaClass_cd' => 'tinyinteger', 'Areas.areaClass_cd' => 'tinyinteger', 'areaClass_cd' => 'tinyinteger', 'Areas__name' => 'string', 'Areas.name' => 'string', 'Areas__sortPt' => 'smallinteger', 'Areas.sortPt' => 'smallinteger', 'sortPt' => 'smallinteger', 'Areas__editDate' => 'timestamp', 'Areas.editDate' => 'timestamp', 'editDate' => 'timestamp', 'Kinds__id' => 'integer', 'Kinds.id' => 'integer', 'Kinds__name' => 'string', 'Kinds.name' => 'string', 'Kinds__sortPt' => 'smallinteger', 'Kinds.sortPt' => 'smallinteger', 'Kinds__editDate' => 'timestamp', 'Kinds.editDate' => 'timestamp', 'Tours__id' => 'integer', 'Tours.id' => 'integer', 'Tours__name' => 'string', 'Tours.name' => 'string', 'Tours__sortPt' => 'smallinteger', 'Tours.sortPt' => 'smallinteger', 'Tours__category' => 'tinyinteger', 'Tours.category' => 'tinyinteger', 'category' => 'tinyinteger', 'Tours__editDate' => 'timestamp', 'Tours.editDate' => 'timestamp', 'Railways1__id' => 'integer', 'Railways1.id' => 'integer', 'Railways1__name' => 'string', 'Railways1.name' => 'string', 'Railways1__sortPt' => 'integer', 'Railways1.sortPt' => 'integer', 'Railways1__editDate' => 'timestamp', 'Railways1.editDate' => 'timestamp', 'Railways2__id' => 'integer', 'Railways2.id' => 'integer', 'Railways2__name' => 'string', 'Railways2.name' => 'string', 'Railways2__sortPt' => 'integer', 'Railways2.sortPt' => 'integer', 'Railways2__editDate' => 'timestamp', 'Railways2.editDate' => 'timestamp', 'Railways3__id' => 'integer', 'Railways3.id' => 'integer', 'Railways3__name' => 'string', 'Railways3.name' => 'string', 'Railways3__sortPt' => 'integer', 'Railways3.sortPt' => 'integer', 'Railways3__editDate' => 'timestamp', 'Railways3.editDate' => 'timestamp', 'Stations1__id' => 'integer', 'Stations1.id' => 'integer', 'Stations1__name' => 'string', 'Stations1.name' => 'string', 'Stations1__railway_id' => 'integer', 'Stations1.railway_id' => 'integer', 'railway_id' => 'integer', 'Stations1__pref_cd' => 'tinyinteger', 'Stations1.pref_cd' => 'tinyinteger', 'pref_cd' => 'tinyinteger', 'Stations1__sortPt' => 'smallinteger', 'Stations1.sortPt' => 'smallinteger', 'Stations1__editDate' => 'timestamp', 'Stations1.editDate' => 'timestamp', 'Stations2__id' => 'integer', 'Stations2.id' => 'integer', 'Stations2__name' => 'string', 'Stations2.name' => 'string', 'Stations2__railway_id' => 'integer', 'Stations2.railway_id' => 'integer', 'Stations2__pref_cd' => 'tinyinteger', 'Stations2.pref_cd' => 'tinyinteger', 'Stations2__sortPt' => 'smallinteger', 'Stations2.sortPt' => 'smallinteger', 'Stations2__editDate' => 'timestamp', 'Stations2.editDate' => 'timestamp', 'Stations3__id' => 'integer', 'Stations3.id' => 'integer', 'Stations3__name' => 'string', 'Stations3.name' => 'string', 'Stations3__railway_id' => 'integer', 'Stations3.railway_id' => 'integer', 'Stations3__pref_cd' => 'tinyinteger', 'Stations3.pref_cd' => 'tinyinteger', 'Stations3__sortPt' => 'smallinteger', 'Stations3.sortPt' => 'smallinteger', 'Stations3__editDate' => 'timestamp', 'Stations3.editDate' => 'timestamp' ], 'decorators' => (int) 0, 'executed' => true, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'Areas' => [[maximum depth reached]], 'Kinds' => [[maximum depth reached]], 'Tours' => [[maximum depth reached]], 'Railways1' => [[maximum depth reached]], 'Railways2' => [[maximum depth reached]], 'Railways3' => [[maximum depth reached]], 'Stations1' => [[maximum depth reached]], 'Stations2' => [[maximum depth reached]], 'Stations3' => [[maximum depth reached]] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\OnusedhousesTable) {} } $area_results = [ (int) 0 => [ 'area_id' => '1', 'name' => '杉並区', 'Ct' => '44', 'CtM' => '17' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '24', 'CtM' => '1' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '7', 'CtM' => '0' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '2', 'CtM' => '0' ], (int) 4 => [ 'area_id' => '8', 'name' => '新宿区', 'Ct' => '2', 'CtM' => '0' ], (int) 5 => [ 'area_id' => '9', 'name' => '豊島区', 'Ct' => '1', 'CtM' => '0' ], (int) 6 => [ 'area_id' => '10', 'name' => '渋谷区', 'Ct' => '1', 'CtM' => '0' ], (int) 7 => [ 'area_id' => '24', 'name' => '武蔵野市', 'Ct' => '3', 'CtM' => '0' ], (int) 8 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 9 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '3', 'CtM' => '0' ] ] $railway_results = [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '3' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '58' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '9' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '2' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '37' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '64' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '10' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '30' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '2' ], (int) 10 => [ 'rway' => '26003', 'name' => '東急田園都市線', 'ct' => '1' ], (int) 11 => [ 'rway' => '26007', 'name' => '東急世田谷線', 'ct' => '2' ], (int) 12 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '24' ], (int) 13 => [ 'rway' => '28004', 'name' => '東京メトロ東西線', 'ct' => '1' ], (int) 14 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 15 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '5' ], (int) 16 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ] $OptionCT = [ 'railway' => (int) 19, 'pet' => (int) 9, 'life' => (int) 61, 'space' => (int) 18 ] $user = null $NoList = true $members_total = '19' $dat = [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] $key = (int) 16 $CtMember = ''include - APP/Template/Element/search_Area_Railway.ctp, line 89 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1420 Cake\View\View::_render() - CORE/src/View/View.php, line 1381 Cake\View\View::_renderElement() - CORE/src/View/View.php, line 1857 Cake\View\View::element() - CORE/src/View/View.php, line 782 include - APP/Template/Onusedhouses/view.ctp, line 776 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1420 Cake\View\View::_render() - CORE/src/View/View.php, line 1381 Cake\View\View::render() - CORE/src/View/View.php, line 879 Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 795 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 126 Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 94 Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 234 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Middleware\CsrfProtectionMiddleware::__invoke() - CORE/src/Http/Middleware/CsrfProtectionMiddleware.php, line 120
Warning (2): Invalid argument supplied for foreach() [APP/Template/Element/search_Area_Railway.ctp, line 89]Code Context<?phpforeach($area_results_member as $key => $dat){?>$viewFile = '/data/WWW/rainbow/test.life-hf.co.jp/htdocs/src/Template/Element/search_Area_Railway.ctp' $dataForView = [ 'Onusedhouses' => object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Onusedhouses.id AS `Onusedhouses__id`, Onusedhouses.name AS `Onusedhouses__name`, Onusedhouses.mbAddress AS `Onusedhouses__mbAddress`, Onusedhouses.displayFlg AS `Onusedhouses__displayFlg`, Onusedhouses.statusFlg AS `Onusedhouses__statusFlg`, Onusedhouses.area_id AS `Onusedhouses__area_id`, Onusedhouses.kind_id AS `Onusedhouses__kind_id`, Onusedhouses.newoldFlg AS `Onusedhouses__newoldFlg`, Onusedhouses.tour_id AS `Onusedhouses__tour_id`, Onusedhouses.topDispFlg AS `Onusedhouses__topDispFlg`, Onusedhouses.recommFlg AS `Onusedhouses__recommFlg`, Onusedhouses.railway_id1 AS `Onusedhouses__railway_id1`, Onusedhouses.railway_id2 AS `Onusedhouses__railway_id2`, Onusedhouses.railway_id3 AS `Onusedhouses__railway_id3`, Onusedhouses.station_id1 AS `Onusedhouses__station_id1`, Onusedhouses.station_id2 AS `Onusedhouses__station_id2`, Onusedhouses.station_id3 AS `Onusedhouses__station_id3`, Onusedhouses.stwalk1 AS `Onusedhouses__stwalk1`, Onusedhouses.stwalk2 AS `Onusedhouses__stwalk2`, Onusedhouses.stwalk3 AS `Onusedhouses__stwalk3`, Onusedhouses.bswalk1 AS `Onusedhouses__bswalk1`, Onusedhouses.bswalk2 AS `Onusedhouses__bswalk2`, Onusedhouses.bswalk3 AS `Onusedhouses__bswalk3`, Onusedhouses.catchCopy AS `Onusedhouses__catchCopy`, Onusedhouses.stationStart AS `Onusedhouses__stationStart`, Onusedhouses.stationTo1 AS `Onusedhouses__stationTo1`, Onusedhouses.stationTo2 AS `Onusedhouses__stationTo2`, Onusedhouses.stationTo3 AS `Onusedhouses__stationTo3`, Onusedhouses.stationTo4 AS `Onusedhouses__stationTo4`, Onusedhouses.trainTime1 AS `Onusedhouses__trainTime1`, Onusedhouses.trainTime2 AS `Onusedhouses__trainTime2`, Onusedhouses.trainTime3 AS `Onusedhouses__trainTime3`, Onusedhouses.trainTime4 AS `Onusedhouses__trainTime4`, Onusedhouses.trainDirect1 AS `Onusedhouses__trainDirect1`, Onusedhouses.trainDirect2 AS `Onusedhouses__trainDirect2`, Onusedhouses.trainDirect3 AS `Onusedhouses__trainDirect3`, Onusedhouses.trainDirect4 AS `Onusedhouses__trainDirect4`, Onusedhouses.trainVia1 AS `Onusedhouses__trainVia1`, Onusedhouses.trainVia2 AS `Onusedhouses__trainVia2`, Onusedhouses.trainVia3 AS `Onusedhouses__trainVia3`, Onusedhouses.trainVia4 AS `Onusedhouses__trainVia4`, Onusedhouses.locationFlg AS `Onusedhouses__locationFlg`, Onusedhouses.locationTitle1 AS `Onusedhouses__locationTitle1`, Onusedhouses.locationTitle2 AS `Onusedhouses__locationTitle2`, Onusedhouses.locationTxt1 AS `Onusedhouses__locationTxt1`, Onusedhouses.locationTxt2 AS `Onusedhouses__locationTxt2`, Onusedhouses.locationTxt3 AS `Onusedhouses__locationTxt3`, Onusedhouses.locationTxt4 AS `Onusedhouses__locationTxt4`, Onusedhouses.locationTxt5 AS `Onusedhouses__locationTxt5`, Onusedhouses.locationTxt6 AS `Onusedhouses__locationTxt6`, Onusedhouses.locationTxt7 AS `Onusedhouses__locationTxt7`, Onusedhouses.locationTxt8 AS `Onusedhouses__locationTxt8`, Onusedhouses.locationTxt9 AS `Onusedhouses__locationTxt9`, Onusedhouses.locationTxt10 AS `Onusedhouses__locationTxt10`, Onusedhouses.locationTxt11 AS `Onusedhouses__locationTxt11`, Onusedhouses.locationTxt12 AS `Onusedhouses__locationTxt12`, Onusedhouses.locationTxt13 AS `Onusedhouses__locationTxt13`, Onusedhouses.locationTxt14 AS `Onusedhouses__locationTxt14`, Onusedhouses.locationTxt15 AS `Onusedhouses__locationTxt15`, Onusedhouses.locationTxt16 AS `Onusedhouses__locationTxt16`, Onusedhouses.locationTxt17 AS `Onusedhouses__locationTxt17`, Onusedhouses.locationTxt18 AS `Onusedhouses__locationTxt18`, Onusedhouses.galleryTxt1 AS `Onusedhouses__galleryTxt1`, Onusedhouses.galleryTxt2 AS `Onusedhouses__galleryTxt2`, Onusedhouses.galleryTxt3 AS `Onusedhouses__galleryTxt3`, Onusedhouses.galleryTxt4 AS `Onusedhouses__galleryTxt4`, Onusedhouses.galleryTxt5 AS `Onusedhouses__galleryTxt5`, Onusedhouses.galleryTxt6 AS `Onusedhouses__galleryTxt6`, Onusedhouses.galleryTxt7 AS `Onusedhouses__galleryTxt7`, Onusedhouses.galleryTxt8 AS `Onusedhouses__galleryTxt8`, Onusedhouses.galleryTxt9 AS `Onusedhouses__galleryTxt9`, Onusedhouses.galleryTxt10 AS `Onusedhouses__galleryTxt10`, Onusedhouses.galleryTxt11 AS `Onusedhouses__galleryTxt11`, Onusedhouses.galleryTxt12 AS `Onusedhouses__galleryTxt12`, Onusedhouses.galleryTxt13 AS `Onusedhouses__galleryTxt13`, Onusedhouses.galleryTxt14 AS `Onusedhouses__galleryTxt14`, Onusedhouses.galleryTxt15 AS `Onusedhouses__galleryTxt15`, Onusedhouses.galleryTxt16 AS `Onusedhouses__galleryTxt16`, Onusedhouses.galleryTxt17 AS `Onusedhouses__galleryTxt17`, Onusedhouses.galleryTxt18 AS `Onusedhouses__galleryTxt18`, Onusedhouses.locationTraffic AS `Onusedhouses__locationTraffic`, Onusedhouses.locationSchool AS `Onusedhouses__locationSchool`, Onusedhouses.locationLife AS `Onusedhouses__locationLife`, Onusedhouses.locationOther AS `Onusedhouses__locationOther`, Onusedhouses.planFlg AS `Onusedhouses__planFlg`, Onusedhouses.outlinePrice AS `Onusedhouses__outlinePrice`, Onusedhouses.outlinePriceNum AS `Onusedhouses__outlinePriceNum`, Onusedhouses.outlinePlace AS `Onusedhouses__outlinePlace`, Onusedhouses.outlineChiken AS `Onusedhouses__outlineChiken`, Onusedhouses.outlineLandArea AS `Onusedhouses__outlineLandArea`, Onusedhouses.outlineBuildArea AS `Onusedhouses__outlineBuildArea`, Onusedhouses.outlineConstruction AS `Onusedhouses__outlineConstruction`, Onusedhouses.outlineFloorPlan AS `Onusedhouses__outlineFloorPlan`, Onusedhouses.outlineCompTime AS `Onusedhouses__outlineCompTime`, Onusedhouses.outlineFacility AS `Onusedhouses__outlineFacility`, Onusedhouses.outlineReformYesNo AS `Onusedhouses__outlineReformYesNo`, Onusedhouses.outlineReformContents AS `Onusedhouses__outlineReformContents`, Onusedhouses.outlineApproach AS `Onusedhouses__outlineApproach`, Onusedhouses.outlineCityplan AS `Onusedhouses__outlineCityplan`, Onusedhouses.outlineUse1 AS `Onusedhouses__outlineUse1`, Onusedhouses.outlineUse2 AS `Onusedhouses__outlineUse2`, Onusedhouses.outlineAltitude1 AS `Onusedhouses__outlineAltitude1`, Onusedhouses.outlineAltitude2 AS `Onusedhouses__outlineAltitude2`, Onusedhouses.outlineFire1 AS `Onusedhouses__outlineFire1`, Onusedhouses.outlineFire2 AS `Onusedhouses__outlineFire2`, Onusedhouses.outlineVolume1 AS `Onusedhouses__outlineVolume1`, Onusedhouses.outlineVolume2 AS `Onusedhouses__outlineVolume2`, Onusedhouses.outlineBuldingNo AS `Onusedhouses__outlineBuldingNo`, Onusedhouses.outlineDelivTime AS `Onusedhouses__outlineDelivTime`, Onusedhouses.outlineTransForm AS `Onusedhouses__outlineTransForm`, Onusedhouses.outlineEquipment AS `Onusedhouses__outlineEquipment`, Onusedhouses.outlineComment AS `Onusedhouses__outlineComment`, Onusedhouses.outlineSchool AS `Onusedhouses__outlineSchool`, Onusedhouses.googleMap AS `Onusedhouses__googleMap`, Onusedhouses.memo AS `Onusedhouses__memo`, Onusedhouses.priceFlg AS `Onusedhouses__priceFlg`, Onusedhouses.newFlg AS `Onusedhouses__newFlg`, Onusedhouses.lastFlg AS `Onusedhouses__lastFlg`, Onusedhouses.topImgFlg AS `Onusedhouses__topImgFlg`, Onusedhouses.memberFlg AS `Onusedhouses__memberFlg`, Onusedhouses.deleteFlg AS `Onusedhouses__deleteFlg`, Onusedhouses.created AS `Onusedhouses__created`, Onusedhouses.modified AS `Onusedhouses__modified`, Areas.id AS `Areas__id`, Areas.areaClass_cd AS `Areas__areaClass_cd`, Areas.name AS `Areas__name`, Areas.sortPt AS `Areas__sortPt`, Areas.editDate AS `Areas__editDate`, Kinds.id AS `Kinds__id`, Kinds.name AS `Kinds__name`, Kinds.sortPt AS `Kinds__sortPt`, Kinds.editDate AS `Kinds__editDate`, Tours.id AS `Tours__id`, Tours.name AS `Tours__name`, Tours.sortPt AS `Tours__sortPt`, Tours.category AS `Tours__category`, Tours.editDate AS `Tours__editDate`, Railways1.id AS `Railways1__id`, Railways1.name AS `Railways1__name`, Railways1.sortPt AS `Railways1__sortPt`, Railways1.editDate AS `Railways1__editDate`, Railways2.id AS `Railways2__id`, Railways2.name AS `Railways2__name`, Railways2.sortPt AS `Railways2__sortPt`, Railways2.editDate AS `Railways2__editDate`, Railways3.id AS `Railways3__id`, Railways3.name AS `Railways3__name`, Railways3.sortPt AS `Railways3__sortPt`, Railways3.editDate AS `Railways3__editDate`, Stations1.id AS `Stations1__id`, Stations1.name AS `Stations1__name`, Stations1.railway_id AS `Stations1__railway_id`, Stations1.pref_cd AS `Stations1__pref_cd`, Stations1.sortPt AS `Stations1__sortPt`, Stations1.editDate AS `Stations1__editDate`, Stations2.id AS `Stations2__id`, Stations2.name AS `Stations2__name`, Stations2.railway_id AS `Stations2__railway_id`, Stations2.pref_cd AS `Stations2__pref_cd`, Stations2.sortPt AS `Stations2__sortPt`, Stations2.editDate AS `Stations2__editDate`, Stations3.id AS `Stations3__id`, Stations3.name AS `Stations3__name`, Stations3.railway_id AS `Stations3__railway_id`, Stations3.pref_cd AS `Stations3__pref_cd`, Stations3.sortPt AS `Stations3__sortPt`, Stations3.editDate AS `Stations3__editDate` FROM onusedhouses Onusedhouses INNER JOIN areas Areas ON Areas.id = (Onusedhouses.area_id) LEFT JOIN kinds Kinds ON Kinds.id = (Onusedhouses.kind_id) LEFT JOIN tours Tours ON Tours.id = (Onusedhouses.tour_id) LEFT JOIN railways Railways1 ON Railways1.id = (Onusedhouses.railway_id1) LEFT JOIN railways Railways2 ON Railways2.id = (Onusedhouses.railway_id2) LEFT JOIN railways Railways3 ON Railways3.id = (Onusedhouses.railway_id3) LEFT JOIN stations Stations1 ON Stations1.id = (Onusedhouses.station_id1) LEFT JOIN stations Stations2 ON Stations2.id = (Onusedhouses.station_id2) LEFT JOIN stations Stations3 ON Stations3.id = (Onusedhouses.station_id3) WHERE Onusedhouses.id = :c0', 'params' => [ [maximum depth reached] ], 'defaultTypes' => [ [maximum depth reached] ], 'decorators' => (int) 0, 'executed' => true, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ [maximum depth reached] ], 'matching' => [[maximum depth reached]], 'extraOptions' => [[maximum depth reached]], 'repository' => object(App\Model\Table\OnusedhousesTable) {} }, 'area_results' => [ (int) 0 => [ 'area_id' => '1', 'name' => '杉並区', 'Ct' => '44', 'CtM' => '17' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '24', 'CtM' => '1' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '7', 'CtM' => '0' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '2', 'CtM' => '0' ], (int) 4 => [ 'area_id' => '8', 'name' => '新宿区', 'Ct' => '2', 'CtM' => '0' ], (int) 5 => [ 'area_id' => '9', 'name' => '豊島区', 'Ct' => '1', 'CtM' => '0' ], (int) 6 => [ 'area_id' => '10', 'name' => '渋谷区', 'Ct' => '1', 'CtM' => '0' ], (int) 7 => [ 'area_id' => '24', 'name' => '武蔵野市', 'Ct' => '3', 'CtM' => '0' ], (int) 8 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 9 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '3', 'CtM' => '0' ] ], 'railway_results' => [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '3' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '58' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '9' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '2' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '37' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '64' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '10' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '30' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '2' ], (int) 10 => [ 'rway' => '26003', 'name' => '東急田園都市線', 'ct' => '1' ], (int) 11 => [ 'rway' => '26007', 'name' => '東急世田谷線', 'ct' => '2' ], (int) 12 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '24' ], (int) 13 => [ 'rway' => '28004', 'name' => '東京メトロ東西線', 'ct' => '1' ], (int) 14 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 15 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '5' ], (int) 16 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ], 'OptionCT' => [ 'railway' => (int) 19, 'pet' => (int) 9, 'life' => (int) 61, 'space' => (int) 18 ], 'user' => null, 'NoList' => true, 'members_total' => '19' ] $Onusedhouses = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Onusedhouses.id AS `Onusedhouses__id`, Onusedhouses.name AS `Onusedhouses__name`, Onusedhouses.mbAddress AS `Onusedhouses__mbAddress`, Onusedhouses.displayFlg AS `Onusedhouses__displayFlg`, Onusedhouses.statusFlg AS `Onusedhouses__statusFlg`, Onusedhouses.area_id AS `Onusedhouses__area_id`, Onusedhouses.kind_id AS `Onusedhouses__kind_id`, Onusedhouses.newoldFlg AS `Onusedhouses__newoldFlg`, Onusedhouses.tour_id AS `Onusedhouses__tour_id`, Onusedhouses.topDispFlg AS `Onusedhouses__topDispFlg`, Onusedhouses.recommFlg AS `Onusedhouses__recommFlg`, Onusedhouses.railway_id1 AS `Onusedhouses__railway_id1`, Onusedhouses.railway_id2 AS `Onusedhouses__railway_id2`, Onusedhouses.railway_id3 AS `Onusedhouses__railway_id3`, Onusedhouses.station_id1 AS `Onusedhouses__station_id1`, Onusedhouses.station_id2 AS `Onusedhouses__station_id2`, Onusedhouses.station_id3 AS `Onusedhouses__station_id3`, Onusedhouses.stwalk1 AS `Onusedhouses__stwalk1`, Onusedhouses.stwalk2 AS `Onusedhouses__stwalk2`, Onusedhouses.stwalk3 AS `Onusedhouses__stwalk3`, Onusedhouses.bswalk1 AS `Onusedhouses__bswalk1`, Onusedhouses.bswalk2 AS `Onusedhouses__bswalk2`, Onusedhouses.bswalk3 AS `Onusedhouses__bswalk3`, Onusedhouses.catchCopy AS `Onusedhouses__catchCopy`, Onusedhouses.stationStart AS `Onusedhouses__stationStart`, Onusedhouses.stationTo1 AS `Onusedhouses__stationTo1`, Onusedhouses.stationTo2 AS `Onusedhouses__stationTo2`, Onusedhouses.stationTo3 AS `Onusedhouses__stationTo3`, Onusedhouses.stationTo4 AS `Onusedhouses__stationTo4`, Onusedhouses.trainTime1 AS `Onusedhouses__trainTime1`, Onusedhouses.trainTime2 AS `Onusedhouses__trainTime2`, Onusedhouses.trainTime3 AS `Onusedhouses__trainTime3`, Onusedhouses.trainTime4 AS `Onusedhouses__trainTime4`, Onusedhouses.trainDirect1 AS `Onusedhouses__trainDirect1`, Onusedhouses.trainDirect2 AS `Onusedhouses__trainDirect2`, Onusedhouses.trainDirect3 AS `Onusedhouses__trainDirect3`, Onusedhouses.trainDirect4 AS `Onusedhouses__trainDirect4`, Onusedhouses.trainVia1 AS `Onusedhouses__trainVia1`, Onusedhouses.trainVia2 AS `Onusedhouses__trainVia2`, Onusedhouses.trainVia3 AS `Onusedhouses__trainVia3`, Onusedhouses.trainVia4 AS `Onusedhouses__trainVia4`, Onusedhouses.locationFlg AS `Onusedhouses__locationFlg`, Onusedhouses.locationTitle1 AS `Onusedhouses__locationTitle1`, Onusedhouses.locationTitle2 AS `Onusedhouses__locationTitle2`, Onusedhouses.locationTxt1 AS `Onusedhouses__locationTxt1`, Onusedhouses.locationTxt2 AS `Onusedhouses__locationTxt2`, Onusedhouses.locationTxt3 AS `Onusedhouses__locationTxt3`, Onusedhouses.locationTxt4 AS `Onusedhouses__locationTxt4`, Onusedhouses.locationTxt5 AS `Onusedhouses__locationTxt5`, Onusedhouses.locationTxt6 AS `Onusedhouses__locationTxt6`, Onusedhouses.locationTxt7 AS `Onusedhouses__locationTxt7`, Onusedhouses.locationTxt8 AS `Onusedhouses__locationTxt8`, Onusedhouses.locationTxt9 AS `Onusedhouses__locationTxt9`, Onusedhouses.locationTxt10 AS `Onusedhouses__locationTxt10`, Onusedhouses.locationTxt11 AS `Onusedhouses__locationTxt11`, Onusedhouses.locationTxt12 AS `Onusedhouses__locationTxt12`, Onusedhouses.locationTxt13 AS `Onusedhouses__locationTxt13`, Onusedhouses.locationTxt14 AS `Onusedhouses__locationTxt14`, Onusedhouses.locationTxt15 AS `Onusedhouses__locationTxt15`, Onusedhouses.locationTxt16 AS `Onusedhouses__locationTxt16`, Onusedhouses.locationTxt17 AS `Onusedhouses__locationTxt17`, Onusedhouses.locationTxt18 AS `Onusedhouses__locationTxt18`, Onusedhouses.galleryTxt1 AS `Onusedhouses__galleryTxt1`, Onusedhouses.galleryTxt2 AS `Onusedhouses__galleryTxt2`, Onusedhouses.galleryTxt3 AS `Onusedhouses__galleryTxt3`, Onusedhouses.galleryTxt4 AS `Onusedhouses__galleryTxt4`, Onusedhouses.galleryTxt5 AS `Onusedhouses__galleryTxt5`, Onusedhouses.galleryTxt6 AS `Onusedhouses__galleryTxt6`, Onusedhouses.galleryTxt7 AS `Onusedhouses__galleryTxt7`, Onusedhouses.galleryTxt8 AS `Onusedhouses__galleryTxt8`, Onusedhouses.galleryTxt9 AS `Onusedhouses__galleryTxt9`, Onusedhouses.galleryTxt10 AS `Onusedhouses__galleryTxt10`, Onusedhouses.galleryTxt11 AS `Onusedhouses__galleryTxt11`, Onusedhouses.galleryTxt12 AS `Onusedhouses__galleryTxt12`, Onusedhouses.galleryTxt13 AS `Onusedhouses__galleryTxt13`, Onusedhouses.galleryTxt14 AS `Onusedhouses__galleryTxt14`, Onusedhouses.galleryTxt15 AS `Onusedhouses__galleryTxt15`, Onusedhouses.galleryTxt16 AS `Onusedhouses__galleryTxt16`, Onusedhouses.galleryTxt17 AS `Onusedhouses__galleryTxt17`, Onusedhouses.galleryTxt18 AS `Onusedhouses__galleryTxt18`, Onusedhouses.locationTraffic AS `Onusedhouses__locationTraffic`, Onusedhouses.locationSchool AS `Onusedhouses__locationSchool`, Onusedhouses.locationLife AS `Onusedhouses__locationLife`, Onusedhouses.locationOther AS `Onusedhouses__locationOther`, Onusedhouses.planFlg AS `Onusedhouses__planFlg`, Onusedhouses.outlinePrice AS `Onusedhouses__outlinePrice`, Onusedhouses.outlinePriceNum AS `Onusedhouses__outlinePriceNum`, Onusedhouses.outlinePlace AS `Onusedhouses__outlinePlace`, Onusedhouses.outlineChiken AS `Onusedhouses__outlineChiken`, Onusedhouses.outlineLandArea AS `Onusedhouses__outlineLandArea`, Onusedhouses.outlineBuildArea AS `Onusedhouses__outlineBuildArea`, Onusedhouses.outlineConstruction AS `Onusedhouses__outlineConstruction`, Onusedhouses.outlineFloorPlan AS `Onusedhouses__outlineFloorPlan`, Onusedhouses.outlineCompTime AS `Onusedhouses__outlineCompTime`, Onusedhouses.outlineFacility AS `Onusedhouses__outlineFacility`, Onusedhouses.outlineReformYesNo AS `Onusedhouses__outlineReformYesNo`, Onusedhouses.outlineReformContents AS `Onusedhouses__outlineReformContents`, Onusedhouses.outlineApproach AS `Onusedhouses__outlineApproach`, Onusedhouses.outlineCityplan AS `Onusedhouses__outlineCityplan`, Onusedhouses.outlineUse1 AS `Onusedhouses__outlineUse1`, Onusedhouses.outlineUse2 AS `Onusedhouses__outlineUse2`, Onusedhouses.outlineAltitude1 AS `Onusedhouses__outlineAltitude1`, Onusedhouses.outlineAltitude2 AS `Onusedhouses__outlineAltitude2`, Onusedhouses.outlineFire1 AS `Onusedhouses__outlineFire1`, Onusedhouses.outlineFire2 AS `Onusedhouses__outlineFire2`, Onusedhouses.outlineVolume1 AS `Onusedhouses__outlineVolume1`, Onusedhouses.outlineVolume2 AS `Onusedhouses__outlineVolume2`, Onusedhouses.outlineBuldingNo AS `Onusedhouses__outlineBuldingNo`, Onusedhouses.outlineDelivTime AS `Onusedhouses__outlineDelivTime`, Onusedhouses.outlineTransForm AS `Onusedhouses__outlineTransForm`, Onusedhouses.outlineEquipment AS `Onusedhouses__outlineEquipment`, Onusedhouses.outlineComment AS `Onusedhouses__outlineComment`, Onusedhouses.outlineSchool AS `Onusedhouses__outlineSchool`, Onusedhouses.googleMap AS `Onusedhouses__googleMap`, Onusedhouses.memo AS `Onusedhouses__memo`, Onusedhouses.priceFlg AS `Onusedhouses__priceFlg`, Onusedhouses.newFlg AS `Onusedhouses__newFlg`, Onusedhouses.lastFlg AS `Onusedhouses__lastFlg`, Onusedhouses.topImgFlg AS `Onusedhouses__topImgFlg`, Onusedhouses.memberFlg AS `Onusedhouses__memberFlg`, Onusedhouses.deleteFlg AS `Onusedhouses__deleteFlg`, Onusedhouses.created AS `Onusedhouses__created`, Onusedhouses.modified AS `Onusedhouses__modified`, Areas.id AS `Areas__id`, Areas.areaClass_cd AS `Areas__areaClass_cd`, Areas.name AS `Areas__name`, Areas.sortPt AS `Areas__sortPt`, Areas.editDate AS `Areas__editDate`, Kinds.id AS `Kinds__id`, Kinds.name AS `Kinds__name`, Kinds.sortPt AS `Kinds__sortPt`, Kinds.editDate AS `Kinds__editDate`, Tours.id AS `Tours__id`, Tours.name AS `Tours__name`, Tours.sortPt AS `Tours__sortPt`, Tours.category AS `Tours__category`, Tours.editDate AS `Tours__editDate`, Railways1.id AS `Railways1__id`, Railways1.name AS `Railways1__name`, Railways1.sortPt AS `Railways1__sortPt`, Railways1.editDate AS `Railways1__editDate`, Railways2.id AS `Railways2__id`, Railways2.name AS `Railways2__name`, Railways2.sortPt AS `Railways2__sortPt`, Railways2.editDate AS `Railways2__editDate`, Railways3.id AS `Railways3__id`, Railways3.name AS `Railways3__name`, Railways3.sortPt AS `Railways3__sortPt`, Railways3.editDate AS `Railways3__editDate`, Stations1.id AS `Stations1__id`, Stations1.name AS `Stations1__name`, Stations1.railway_id AS `Stations1__railway_id`, Stations1.pref_cd AS `Stations1__pref_cd`, Stations1.sortPt AS `Stations1__sortPt`, Stations1.editDate AS `Stations1__editDate`, Stations2.id AS `Stations2__id`, Stations2.name AS `Stations2__name`, Stations2.railway_id AS `Stations2__railway_id`, Stations2.pref_cd AS `Stations2__pref_cd`, Stations2.sortPt AS `Stations2__sortPt`, Stations2.editDate AS `Stations2__editDate`, Stations3.id AS `Stations3__id`, Stations3.name AS `Stations3__name`, Stations3.railway_id AS `Stations3__railway_id`, Stations3.pref_cd AS `Stations3__pref_cd`, Stations3.sortPt AS `Stations3__sortPt`, Stations3.editDate AS `Stations3__editDate` FROM onusedhouses Onusedhouses INNER JOIN areas Areas ON Areas.id = (Onusedhouses.area_id) LEFT JOIN kinds Kinds ON Kinds.id = (Onusedhouses.kind_id) LEFT JOIN tours Tours ON Tours.id = (Onusedhouses.tour_id) LEFT JOIN railways Railways1 ON Railways1.id = (Onusedhouses.railway_id1) LEFT JOIN railways Railways2 ON Railways2.id = (Onusedhouses.railway_id2) LEFT JOIN railways Railways3 ON Railways3.id = (Onusedhouses.railway_id3) LEFT JOIN stations Stations1 ON Stations1.id = (Onusedhouses.station_id1) LEFT JOIN stations Stations2 ON Stations2.id = (Onusedhouses.station_id2) LEFT JOIN stations Stations3 ON Stations3.id = (Onusedhouses.station_id3) WHERE Onusedhouses.id = :c0', 'params' => [ ':c0' => [ [maximum depth reached] ] ], 'defaultTypes' => [ 'Onusedhouses__id' => 'integer', 'Onusedhouses.id' => 'integer', 'id' => 'integer', 'Onusedhouses__name' => 'string', 'Onusedhouses.name' => 'string', 'name' => 'string', 'Onusedhouses__mbAddress' => 'string', 'Onusedhouses.mbAddress' => 'string', 'mbAddress' => 'string', 'Onusedhouses__displayFlg' => 'tinyinteger', 'Onusedhouses.displayFlg' => 'tinyinteger', 'displayFlg' => 'tinyinteger', 'Onusedhouses__statusFlg' => 'tinyinteger', 'Onusedhouses.statusFlg' => 'tinyinteger', 'statusFlg' => 'tinyinteger', 'Onusedhouses__area_id' => 'integer', 'Onusedhouses.area_id' => 'integer', 'area_id' => 'integer', 'Onusedhouses__kind_id' => 'integer', 'Onusedhouses.kind_id' => 'integer', 'kind_id' => 'integer', 'Onusedhouses__newoldFlg' => 'tinyinteger', 'Onusedhouses.newoldFlg' => 'tinyinteger', 'newoldFlg' => 'tinyinteger', 'Onusedhouses__tour_id' => 'integer', 'Onusedhouses.tour_id' => 'integer', 'tour_id' => 'integer', 'Onusedhouses__topDispFlg' => 'tinyinteger', 'Onusedhouses.topDispFlg' => 'tinyinteger', 'topDispFlg' => 'tinyinteger', 'Onusedhouses__recommFlg' => 'tinyinteger', 'Onusedhouses.recommFlg' => 'tinyinteger', 'recommFlg' => 'tinyinteger', 'Onusedhouses__railway_id1' => 'integer', 'Onusedhouses.railway_id1' => 'integer', 'railway_id1' => 'integer', 'Onusedhouses__railway_id2' => 'integer', 'Onusedhouses.railway_id2' => 'integer', 'railway_id2' => 'integer', 'Onusedhouses__railway_id3' => 'integer', 'Onusedhouses.railway_id3' => 'integer', 'railway_id3' => 'integer', 'Onusedhouses__station_id1' => 'integer', 'Onusedhouses.station_id1' => 'integer', 'station_id1' => 'integer', 'Onusedhouses__station_id2' => 'integer', 'Onusedhouses.station_id2' => 'integer', 'station_id2' => 'integer', 'Onusedhouses__station_id3' => 'integer', 'Onusedhouses.station_id3' => 'integer', 'station_id3' => 'integer', 'Onusedhouses__stwalk1' => 'string', 'Onusedhouses.stwalk1' => 'string', 'stwalk1' => 'string', 'Onusedhouses__stwalk2' => 'string', 'Onusedhouses.stwalk2' => 'string', 'stwalk2' => 'string', 'Onusedhouses__stwalk3' => 'string', 'Onusedhouses.stwalk3' => 'string', 'stwalk3' => 'string', 'Onusedhouses__bswalk1' => 'string', 'Onusedhouses.bswalk1' => 'string', 'bswalk1' => 'string', 'Onusedhouses__bswalk2' => 'string', 'Onusedhouses.bswalk2' => 'string', 'bswalk2' => 'string', 'Onusedhouses__bswalk3' => 'string', 'Onusedhouses.bswalk3' => 'string', 'bswalk3' => 'string', 'Onusedhouses__catchCopy' => 'string', 'Onusedhouses.catchCopy' => 'string', 'catchCopy' => 'string', 'Onusedhouses__stationStart' => 'string', 'Onusedhouses.stationStart' => 'string', 'stationStart' => 'string', 'Onusedhouses__stationTo1' => 'string', 'Onusedhouses.stationTo1' => 'string', 'stationTo1' => 'string', 'Onusedhouses__stationTo2' => 'string', 'Onusedhouses.stationTo2' => 'string', 'stationTo2' => 'string', 'Onusedhouses__stationTo3' => 'string', 'Onusedhouses.stationTo3' => 'string', 'stationTo3' => 'string', 'Onusedhouses__stationTo4' => 'string', 'Onusedhouses.stationTo4' => 'string', 'stationTo4' => 'string', 'Onusedhouses__trainTime1' => 'tinyinteger', 'Onusedhouses.trainTime1' => 'tinyinteger', 'trainTime1' => 'tinyinteger', 'Onusedhouses__trainTime2' => 'tinyinteger', 'Onusedhouses.trainTime2' => 'tinyinteger', 'trainTime2' => 'tinyinteger', 'Onusedhouses__trainTime3' => 'tinyinteger', 'Onusedhouses.trainTime3' => 'tinyinteger', 'trainTime3' => 'tinyinteger', 'Onusedhouses__trainTime4' => 'tinyinteger', 'Onusedhouses.trainTime4' => 'tinyinteger', 'trainTime4' => 'tinyinteger', 'Onusedhouses__trainDirect1' => 'tinyinteger', 'Onusedhouses.trainDirect1' => 'tinyinteger', 'trainDirect1' => 'tinyinteger', 'Onusedhouses__trainDirect2' => 'tinyinteger', 'Onusedhouses.trainDirect2' => 'tinyinteger', 'trainDirect2' => 'tinyinteger', 'Onusedhouses__trainDirect3' => 'tinyinteger', 'Onusedhouses.trainDirect3' => 'tinyinteger', 'trainDirect3' => 'tinyinteger', 'Onusedhouses__trainDirect4' => 'tinyinteger', 'Onusedhouses.trainDirect4' => 'tinyinteger', 'trainDirect4' => 'tinyinteger', 'Onusedhouses__trainVia1' => 'string', 'Onusedhouses.trainVia1' => 'string', 'trainVia1' => 'string', 'Onusedhouses__trainVia2' => 'string', 'Onusedhouses.trainVia2' => 'string', 'trainVia2' => 'string', 'Onusedhouses__trainVia3' => 'string', 'Onusedhouses.trainVia3' => 'string', 'trainVia3' => 'string', 'Onusedhouses__trainVia4' => 'string', 'Onusedhouses.trainVia4' => 'string', 'trainVia4' => 'string', 'Onusedhouses__locationFlg' => 'tinyinteger', 'Onusedhouses.locationFlg' => 'tinyinteger', 'locationFlg' => 'tinyinteger', 'Onusedhouses__locationTitle1' => 'string', 'Onusedhouses.locationTitle1' => 'string', 'locationTitle1' => 'string', 'Onusedhouses__locationTitle2' => 'string', 'Onusedhouses.locationTitle2' => 'string', 'locationTitle2' => 'string', 'Onusedhouses__locationTxt1' => 'string', 'Onusedhouses.locationTxt1' => 'string', 'locationTxt1' => 'string', 'Onusedhouses__locationTxt2' => 'string', 'Onusedhouses.locationTxt2' => 'string', 'locationTxt2' => 'string', 'Onusedhouses__locationTxt3' => 'string', 'Onusedhouses.locationTxt3' => 'string', 'locationTxt3' => 'string', 'Onusedhouses__locationTxt4' => 'string', 'Onusedhouses.locationTxt4' => 'string', 'locationTxt4' => 'string', 'Onusedhouses__locationTxt5' => 'string', 'Onusedhouses.locationTxt5' => 'string', 'locationTxt5' => 'string', 'Onusedhouses__locationTxt6' => 'string', 'Onusedhouses.locationTxt6' => 'string', 'locationTxt6' => 'string', 'Onusedhouses__locationTxt7' => 'string', 'Onusedhouses.locationTxt7' => 'string', 'locationTxt7' => 'string', 'Onusedhouses__locationTxt8' => 'string', 'Onusedhouses.locationTxt8' => 'string', 'locationTxt8' => 'string', 'Onusedhouses__locationTxt9' => 'string', 'Onusedhouses.locationTxt9' => 'string', 'locationTxt9' => 'string', 'Onusedhouses__locationTxt10' => 'string', 'Onusedhouses.locationTxt10' => 'string', 'locationTxt10' => 'string', 'Onusedhouses__locationTxt11' => 'string', 'Onusedhouses.locationTxt11' => 'string', 'locationTxt11' => 'string', 'Onusedhouses__locationTxt12' => 'string', 'Onusedhouses.locationTxt12' => 'string', 'locationTxt12' => 'string', 'Onusedhouses__locationTxt13' => 'string', 'Onusedhouses.locationTxt13' => 'string', 'locationTxt13' => 'string', 'Onusedhouses__locationTxt14' => 'string', 'Onusedhouses.locationTxt14' => 'string', 'locationTxt14' => 'string', 'Onusedhouses__locationTxt15' => 'string', 'Onusedhouses.locationTxt15' => 'string', 'locationTxt15' => 'string', 'Onusedhouses__locationTxt16' => 'string', 'Onusedhouses.locationTxt16' => 'string', 'locationTxt16' => 'string', 'Onusedhouses__locationTxt17' => 'string', 'Onusedhouses.locationTxt17' => 'string', 'locationTxt17' => 'string', 'Onusedhouses__locationTxt18' => 'string', 'Onusedhouses.locationTxt18' => 'string', 'locationTxt18' => 'string', 'Onusedhouses__galleryTxt1' => 'string', 'Onusedhouses.galleryTxt1' => 'string', 'galleryTxt1' => 'string', 'Onusedhouses__galleryTxt2' => 'string', 'Onusedhouses.galleryTxt2' => 'string', 'galleryTxt2' => 'string', 'Onusedhouses__galleryTxt3' => 'string', 'Onusedhouses.galleryTxt3' => 'string', 'galleryTxt3' => 'string', 'Onusedhouses__galleryTxt4' => 'string', 'Onusedhouses.galleryTxt4' => 'string', 'galleryTxt4' => 'string', 'Onusedhouses__galleryTxt5' => 'string', 'Onusedhouses.galleryTxt5' => 'string', 'galleryTxt5' => 'string', 'Onusedhouses__galleryTxt6' => 'string', 'Onusedhouses.galleryTxt6' => 'string', 'galleryTxt6' => 'string', 'Onusedhouses__galleryTxt7' => 'string', 'Onusedhouses.galleryTxt7' => 'string', 'galleryTxt7' => 'string', 'Onusedhouses__galleryTxt8' => 'string', 'Onusedhouses.galleryTxt8' => 'string', 'galleryTxt8' => 'string', 'Onusedhouses__galleryTxt9' => 'string', 'Onusedhouses.galleryTxt9' => 'string', 'galleryTxt9' => 'string', 'Onusedhouses__galleryTxt10' => 'string', 'Onusedhouses.galleryTxt10' => 'string', 'galleryTxt10' => 'string', 'Onusedhouses__galleryTxt11' => 'string', 'Onusedhouses.galleryTxt11' => 'string', 'galleryTxt11' => 'string', 'Onusedhouses__galleryTxt12' => 'string', 'Onusedhouses.galleryTxt12' => 'string', 'galleryTxt12' => 'string', 'Onusedhouses__galleryTxt13' => 'string', 'Onusedhouses.galleryTxt13' => 'string', 'galleryTxt13' => 'string', 'Onusedhouses__galleryTxt14' => 'string', 'Onusedhouses.galleryTxt14' => 'string', 'galleryTxt14' => 'string', 'Onusedhouses__galleryTxt15' => 'string', 'Onusedhouses.galleryTxt15' => 'string', 'galleryTxt15' => 'string', 'Onusedhouses__galleryTxt16' => 'string', 'Onusedhouses.galleryTxt16' => 'string', 'galleryTxt16' => 'string', 'Onusedhouses__galleryTxt17' => 'string', 'Onusedhouses.galleryTxt17' => 'string', 'galleryTxt17' => 'string', 'Onusedhouses__galleryTxt18' => 'string', 'Onusedhouses.galleryTxt18' => 'string', 'galleryTxt18' => 'string', 'Onusedhouses__locationTraffic' => 'string', 'Onusedhouses.locationTraffic' => 'string', 'locationTraffic' => 'string', 'Onusedhouses__locationSchool' => 'string', 'Onusedhouses.locationSchool' => 'string', 'locationSchool' => 'string', 'Onusedhouses__locationLife' => 'string', 'Onusedhouses.locationLife' => 'string', 'locationLife' => 'string', 'Onusedhouses__locationOther' => 'string', 'Onusedhouses.locationOther' => 'string', 'locationOther' => 'string', 'Onusedhouses__planFlg' => 'tinyinteger', 'Onusedhouses.planFlg' => 'tinyinteger', 'planFlg' => 'tinyinteger', 'Onusedhouses__outlinePrice' => 'decimal', 'Onusedhouses.outlinePrice' => 'decimal', 'outlinePrice' => 'decimal', 'Onusedhouses__outlinePriceNum' => 'integer', 'Onusedhouses.outlinePriceNum' => 'integer', 'outlinePriceNum' => 'integer', 'Onusedhouses__outlinePlace' => 'string', 'Onusedhouses.outlinePlace' => 'string', 'outlinePlace' => 'string', 'Onusedhouses__outlineChiken' => 'tinyinteger', 'Onusedhouses.outlineChiken' => 'tinyinteger', 'outlineChiken' => 'tinyinteger', 'Onusedhouses__outlineLandArea' => 'decimal', 'Onusedhouses.outlineLandArea' => 'decimal', 'outlineLandArea' => 'decimal', 'Onusedhouses__outlineBuildArea' => 'decimal', 'Onusedhouses.outlineBuildArea' => 'decimal', 'outlineBuildArea' => 'decimal', 'Onusedhouses__outlineConstruction' => 'string', 'Onusedhouses.outlineConstruction' => 'string', 'outlineConstruction' => 'string', 'Onusedhouses__outlineFloorPlan' => 'string', 'Onusedhouses.outlineFloorPlan' => 'string', 'outlineFloorPlan' => 'string', 'Onusedhouses__outlineCompTime' => 'string', 'Onusedhouses.outlineCompTime' => 'string', 'outlineCompTime' => 'string', 'Onusedhouses__outlineFacility' => 'string', 'Onusedhouses.outlineFacility' => 'string', 'outlineFacility' => 'string', 'Onusedhouses__outlineReformYesNo' => 'tinyinteger', 'Onusedhouses.outlineReformYesNo' => 'tinyinteger', 'outlineReformYesNo' => 'tinyinteger', 'Onusedhouses__outlineReformContents' => 'string', 'Onusedhouses.outlineReformContents' => 'string', 'outlineReformContents' => 'string', 'Onusedhouses__outlineApproach' => 'string', 'Onusedhouses.outlineApproach' => 'string', 'outlineApproach' => 'string', 'Onusedhouses__outlineCityplan' => 'string', 'Onusedhouses.outlineCityplan' => 'string', 'outlineCityplan' => 'string', 'Onusedhouses__outlineUse1' => 'string', 'Onusedhouses.outlineUse1' => 'string', 'outlineUse1' => 'string', 'Onusedhouses__outlineUse2' => 'string', 'Onusedhouses.outlineUse2' => 'string', 'outlineUse2' => 'string', 'Onusedhouses__outlineAltitude1' => 'string', 'Onusedhouses.outlineAltitude1' => 'string', 'outlineAltitude1' => 'string', 'Onusedhouses__outlineAltitude2' => 'string', 'Onusedhouses.outlineAltitude2' => 'string', 'outlineAltitude2' => 'string', 'Onusedhouses__outlineFire1' => 'string', 'Onusedhouses.outlineFire1' => 'string', 'outlineFire1' => 'string', 'Onusedhouses__outlineFire2' => 'string', 'Onusedhouses.outlineFire2' => 'string', 'outlineFire2' => 'string', 'Onusedhouses__outlineVolume1' => 'string', 'Onusedhouses.outlineVolume1' => 'string', 'outlineVolume1' => 'string', 'Onusedhouses__outlineVolume2' => 'string', 'Onusedhouses.outlineVolume2' => 'string', 'outlineVolume2' => 'string', 'Onusedhouses__outlineBuldingNo' => 'string', 'Onusedhouses.outlineBuldingNo' => 'string', 'outlineBuldingNo' => 'string', 'Onusedhouses__outlineDelivTime' => 'string', 'Onusedhouses.outlineDelivTime' => 'string', 'outlineDelivTime' => 'string', 'Onusedhouses__outlineTransForm' => 'string', 'Onusedhouses.outlineTransForm' => 'string', 'outlineTransForm' => 'string', 'Onusedhouses__outlineEquipment' => 'string', 'Onusedhouses.outlineEquipment' => 'string', 'outlineEquipment' => 'string', 'Onusedhouses__outlineComment' => 'string', 'Onusedhouses.outlineComment' => 'string', 'outlineComment' => 'string', 'Onusedhouses__outlineSchool' => 'string', 'Onusedhouses.outlineSchool' => 'string', 'outlineSchool' => 'string', 'Onusedhouses__googleMap' => 'string', 'Onusedhouses.googleMap' => 'string', 'googleMap' => 'string', 'Onusedhouses__memo' => 'string', 'Onusedhouses.memo' => 'string', 'memo' => 'string', 'Onusedhouses__priceFlg' => 'tinyinteger', 'Onusedhouses.priceFlg' => 'tinyinteger', 'priceFlg' => 'tinyinteger', 'Onusedhouses__newFlg' => 'tinyinteger', 'Onusedhouses.newFlg' => 'tinyinteger', 'newFlg' => 'tinyinteger', 'Onusedhouses__lastFlg' => 'tinyinteger', 'Onusedhouses.lastFlg' => 'tinyinteger', 'lastFlg' => 'tinyinteger', 'Onusedhouses__topImgFlg' => 'tinyinteger', 'Onusedhouses.topImgFlg' => 'tinyinteger', 'topImgFlg' => 'tinyinteger', 'Onusedhouses__memberFlg' => 'tinyinteger', 'Onusedhouses.memberFlg' => 'tinyinteger', 'memberFlg' => 'tinyinteger', 'Onusedhouses__deleteFlg' => 'tinyinteger', 'Onusedhouses.deleteFlg' => 'tinyinteger', 'deleteFlg' => 'tinyinteger', 'Onusedhouses__created' => 'datetime', 'Onusedhouses.created' => 'datetime', 'created' => 'datetime', 'Onusedhouses__modified' => 'datetime', 'Onusedhouses.modified' => 'datetime', 'modified' => 'datetime', 'Areas__id' => 'integer', 'Areas.id' => 'integer', 'Areas__areaClass_cd' => 'tinyinteger', 'Areas.areaClass_cd' => 'tinyinteger', 'areaClass_cd' => 'tinyinteger', 'Areas__name' => 'string', 'Areas.name' => 'string', 'Areas__sortPt' => 'smallinteger', 'Areas.sortPt' => 'smallinteger', 'sortPt' => 'smallinteger', 'Areas__editDate' => 'timestamp', 'Areas.editDate' => 'timestamp', 'editDate' => 'timestamp', 'Kinds__id' => 'integer', 'Kinds.id' => 'integer', 'Kinds__name' => 'string', 'Kinds.name' => 'string', 'Kinds__sortPt' => 'smallinteger', 'Kinds.sortPt' => 'smallinteger', 'Kinds__editDate' => 'timestamp', 'Kinds.editDate' => 'timestamp', 'Tours__id' => 'integer', 'Tours.id' => 'integer', 'Tours__name' => 'string', 'Tours.name' => 'string', 'Tours__sortPt' => 'smallinteger', 'Tours.sortPt' => 'smallinteger', 'Tours__category' => 'tinyinteger', 'Tours.category' => 'tinyinteger', 'category' => 'tinyinteger', 'Tours__editDate' => 'timestamp', 'Tours.editDate' => 'timestamp', 'Railways1__id' => 'integer', 'Railways1.id' => 'integer', 'Railways1__name' => 'string', 'Railways1.name' => 'string', 'Railways1__sortPt' => 'integer', 'Railways1.sortPt' => 'integer', 'Railways1__editDate' => 'timestamp', 'Railways1.editDate' => 'timestamp', 'Railways2__id' => 'integer', 'Railways2.id' => 'integer', 'Railways2__name' => 'string', 'Railways2.name' => 'string', 'Railways2__sortPt' => 'integer', 'Railways2.sortPt' => 'integer', 'Railways2__editDate' => 'timestamp', 'Railways2.editDate' => 'timestamp', 'Railways3__id' => 'integer', 'Railways3.id' => 'integer', 'Railways3__name' => 'string', 'Railways3.name' => 'string', 'Railways3__sortPt' => 'integer', 'Railways3.sortPt' => 'integer', 'Railways3__editDate' => 'timestamp', 'Railways3.editDate' => 'timestamp', 'Stations1__id' => 'integer', 'Stations1.id' => 'integer', 'Stations1__name' => 'string', 'Stations1.name' => 'string', 'Stations1__railway_id' => 'integer', 'Stations1.railway_id' => 'integer', 'railway_id' => 'integer', 'Stations1__pref_cd' => 'tinyinteger', 'Stations1.pref_cd' => 'tinyinteger', 'pref_cd' => 'tinyinteger', 'Stations1__sortPt' => 'smallinteger', 'Stations1.sortPt' => 'smallinteger', 'Stations1__editDate' => 'timestamp', 'Stations1.editDate' => 'timestamp', 'Stations2__id' => 'integer', 'Stations2.id' => 'integer', 'Stations2__name' => 'string', 'Stations2.name' => 'string', 'Stations2__railway_id' => 'integer', 'Stations2.railway_id' => 'integer', 'Stations2__pref_cd' => 'tinyinteger', 'Stations2.pref_cd' => 'tinyinteger', 'Stations2__sortPt' => 'smallinteger', 'Stations2.sortPt' => 'smallinteger', 'Stations2__editDate' => 'timestamp', 'Stations2.editDate' => 'timestamp', 'Stations3__id' => 'integer', 'Stations3.id' => 'integer', 'Stations3__name' => 'string', 'Stations3.name' => 'string', 'Stations3__railway_id' => 'integer', 'Stations3.railway_id' => 'integer', 'Stations3__pref_cd' => 'tinyinteger', 'Stations3.pref_cd' => 'tinyinteger', 'Stations3__sortPt' => 'smallinteger', 'Stations3.sortPt' => 'smallinteger', 'Stations3__editDate' => 'timestamp', 'Stations3.editDate' => 'timestamp' ], 'decorators' => (int) 0, 'executed' => true, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'Areas' => [[maximum depth reached]], 'Kinds' => [[maximum depth reached]], 'Tours' => [[maximum depth reached]], 'Railways1' => [[maximum depth reached]], 'Railways2' => [[maximum depth reached]], 'Railways3' => [[maximum depth reached]], 'Stations1' => [[maximum depth reached]], 'Stations2' => [[maximum depth reached]], 'Stations3' => [[maximum depth reached]] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\OnusedhousesTable) {} } $area_results = [ (int) 0 => [ 'area_id' => '1', 'name' => '杉並区', 'Ct' => '44', 'CtM' => '17' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '24', 'CtM' => '1' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '7', 'CtM' => '0' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '2', 'CtM' => '0' ], (int) 4 => [ 'area_id' => '8', 'name' => '新宿区', 'Ct' => '2', 'CtM' => '0' ], (int) 5 => [ 'area_id' => '9', 'name' => '豊島区', 'Ct' => '1', 'CtM' => '0' ], (int) 6 => [ 'area_id' => '10', 'name' => '渋谷区', 'Ct' => '1', 'CtM' => '0' ], (int) 7 => [ 'area_id' => '24', 'name' => '武蔵野市', 'Ct' => '3', 'CtM' => '0' ], (int) 8 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 9 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '3', 'CtM' => '0' ] ] $railway_results = [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '3' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '58' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '9' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '2' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '37' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '64' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '10' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '30' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '2' ], (int) 10 => [ 'rway' => '26003', 'name' => '東急田園都市線', 'ct' => '1' ], (int) 11 => [ 'rway' => '26007', 'name' => '東急世田谷線', 'ct' => '2' ], (int) 12 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '24' ], (int) 13 => [ 'rway' => '28004', 'name' => '東京メトロ東西線', 'ct' => '1' ], (int) 14 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 15 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '5' ], (int) 16 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ] $OptionCT = [ 'railway' => (int) 19, 'pet' => (int) 9, 'life' => (int) 61, 'space' => (int) 18 ] $user = null $NoList = true $members_total = '19' $dat = [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] $key = (int) 16 $CtMember = ''include - APP/Template/Element/search_Area_Railway.ctp, line 89 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1420 Cake\View\View::_render() - CORE/src/View/View.php, line 1381 Cake\View\View::_renderElement() - CORE/src/View/View.php, line 1857 Cake\View\View::element() - CORE/src/View/View.php, line 782 include - APP/Template/Onusedhouses/view.ctp, line 776 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1420 Cake\View\View::_render() - CORE/src/View/View.php, line 1381 Cake\View\View::render() - CORE/src/View/View.php, line 879 Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 795 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 126 Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 94 Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 234 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Middleware\CsrfProtectionMiddleware::__invoke() - CORE/src/Http/Middleware/CsrfProtectionMiddleware.php, line 120
Copyright©2021-2025 LHF co.,ltd.
エリア検索