正直に駅からは遠い、現場にお越しいただいた皆さまはその徒歩分数に懸念を持つことでしょう。ただ、この地の良さ「緑豊かな街並みが形勢されている」この雰囲気にスペシャリティを感じられることも考えられる。住環境の良い南西角のポジションに注がれる太陽の光は、とても気持ちの良いものに映ることでしょう。
3LDK+カースペース1台
敷地面積：70.22m2 建物面積：70.08m2
6,780万円
見学予約受付中
| 価格 | 6,780万円 |
|---|---|
| 所在地 | 杉並区松ノ木1丁目 |
| 権利 | 所有権 |
| 敷地面積 | 70.22㎡ |
| 建物面積 | 70.08㎡ |
| 建物構造 | 木造2階建 |
| 間取り | 3LDK+カースペース1台 |
| 築年月 | 2013年7月 |
| 建築確認番号 | ※省略 |
| 設備 | 公営水道・本下水・東京ガス・東京電力 |
| リフォーム有無 | 有 |
| リフォーム履歴内容 | ■交換 システムキッチン、ウォシュレット付トイレ、ユニットバス、洗面台、インターホン、給湯器、階段手摺 ■張替 全室クロス、床水回り(CF) ■網戸貼替 ■全床フロアタイル仕上げ ■各照明･ダウンライト取付 ■ハウスクリーニング etc |
| 接道状況 | 南側約4ｍ区道・西側約3.9ｍ区道 |
| 都市計画 | 市街化区域 |
| 用途地域 | 第一種低層住居専用地域 |
|---|---|
| 高度地区 | 第一種高度地区 |
| 防火指定 | |
| 建ぺい率/ 容積率 |
50％／100％ |
| 引渡時期 | 即日 |
| 取引態様 | 媒介 |
| 建物仕様 | ◆各居室収納 ◆リビング収納 ◆リビングカウンター付き ◆システムキッチン |
| ポイント | ●リノベーション戸建 |
| 指定学校区 | 杉並区立松ノ木小学校 杉並区立松ノ木中学校 |
| 備考 |
杉並区立松ノ木小学校 約350m 徒歩5分
杉並区立松ノ木中学校 約280m 徒歩4分
もりのなかま保育園 松ノ木園 約350m 徒歩5分
にじのいるか保育園 杉並松の木 約400m 徒歩5分
大宮幼稚園 約1000m 徒歩13分
ファミリーマート 杉並松ノ木一丁目店 約110m 徒歩2分
ウエルシア杉並松ノ木店 約500m 徒歩7分
サミットストア 成田東店 約650m 徒歩9分
セブン-イレブン 杉並成田東１丁目店 約650m 徒歩9分
和田堀公園 約550m 徒歩7分
和田堀公園 約550m 徒歩7分
和田堀公園 約550m 徒歩7分
杉並児童交通公園 約950m 徒歩12分
杉並児童交通公園 約950m 徒歩12分
善福寺川緑地 約1400m 自転車5分
善福寺川緑地 約1400m 自転車5分
見学予約受付中
見学予約受付中
エリア検索
路線検索
会員限定物件
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' => '40', 'CtM' => '16' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '18', 'CtM' => '1' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '8', 'CtM' => '0' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '3', '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' => '2', 'CtM' => '0' ], (int) 8 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 9 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '4', 'CtM' => '0' ], (int) 10 => [ 'area_id' => '33', 'name' => '狛江市', 'Ct' => '1', 'CtM' => '0' ], (int) 11 => [ 'area_id' => '35', 'name' => '東久留米市', 'Ct' => '1', 'CtM' => '0' ] ], 'railway_results' => [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '3' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '60' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '5' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '2' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '31' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '53' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '13' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '29' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '5' ], (int) 10 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '23' ], (int) 11 => [ 'rway' => '28004', 'name' => '東京メトロ東西線', 'ct' => '1' ], (int) 12 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 13 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '5' ], (int) 14 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ], 'OptionCT' => [ 'railway' => (int) 21, 'pet' => (int) 9, 'life' => (int) 58, 'space' => (int) 19 ], 'user' => null, 'NoList' => true, 'members_total' => '18' ] $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' => '40', 'CtM' => '16' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '18', 'CtM' => '1' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '8', 'CtM' => '0' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '3', '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' => '2', 'CtM' => '0' ], (int) 8 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 9 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '4', 'CtM' => '0' ], (int) 10 => [ 'area_id' => '33', 'name' => '狛江市', 'Ct' => '1', 'CtM' => '0' ], (int) 11 => [ 'area_id' => '35', 'name' => '東久留米市', 'Ct' => '1', 'CtM' => '0' ] ] $railway_results = [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '3' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '60' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '5' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '2' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '31' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '53' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '13' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '29' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '5' ], (int) 10 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '23' ], (int) 11 => [ 'rway' => '28004', 'name' => '東京メトロ東西線', 'ct' => '1' ], (int) 12 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 13 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '5' ], (int) 14 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ] $OptionCT = [ 'railway' => (int) 21, 'pet' => (int) 9, 'life' => (int) 58, 'space' => (int) 19 ] $user = null $NoList = true $members_total = '18' $dat = [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] $key = (int) 14 $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' => '40', 'CtM' => '16' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '18', 'CtM' => '1' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '8', 'CtM' => '0' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '3', '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' => '2', 'CtM' => '0' ], (int) 8 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 9 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '4', 'CtM' => '0' ], (int) 10 => [ 'area_id' => '33', 'name' => '狛江市', 'Ct' => '1', 'CtM' => '0' ], (int) 11 => [ 'area_id' => '35', 'name' => '東久留米市', 'Ct' => '1', 'CtM' => '0' ] ], 'railway_results' => [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '3' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '60' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '5' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '2' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '31' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '53' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '13' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '29' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '5' ], (int) 10 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '23' ], (int) 11 => [ 'rway' => '28004', 'name' => '東京メトロ東西線', 'ct' => '1' ], (int) 12 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 13 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '5' ], (int) 14 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ], 'OptionCT' => [ 'railway' => (int) 21, 'pet' => (int) 9, 'life' => (int) 58, 'space' => (int) 19 ], 'user' => null, 'NoList' => true, 'members_total' => '18' ] $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' => '40', 'CtM' => '16' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '18', 'CtM' => '1' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '8', 'CtM' => '0' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '3', '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' => '2', 'CtM' => '0' ], (int) 8 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 9 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '4', 'CtM' => '0' ], (int) 10 => [ 'area_id' => '33', 'name' => '狛江市', 'Ct' => '1', 'CtM' => '0' ], (int) 11 => [ 'area_id' => '35', 'name' => '東久留米市', 'Ct' => '1', 'CtM' => '0' ] ] $railway_results = [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '3' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '60' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '5' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '2' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '31' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '53' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '13' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '29' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '5' ], (int) 10 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '23' ], (int) 11 => [ 'rway' => '28004', 'name' => '東京メトロ東西線', 'ct' => '1' ], (int) 12 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 13 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '5' ], (int) 14 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ] $OptionCT = [ 'railway' => (int) 21, 'pet' => (int) 9, 'life' => (int) 58, 'space' => (int) 19 ] $user = null $NoList = true $members_total = '18' $dat = [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] $key = (int) 14 $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.
