この物件の良さを残さない手はない。用途地域の特性を活かして造られた富士を眺める屋上型バルコニー。とても広いです。広くて尚且つ南向きですから、陽当たりの感じ方は格別なものになっています。魅力ある個性を残しながらリノベーションして再び新しく披露させていただきます
4LDK+ルーフバルコニー+カースペース1台
敷地面積：81.04m2 建物面積：95.58m2
6,599万円
見学予約受付中
| 価格 | 6,599万円 |
|---|---|
| 所在地 | 練馬区富士見台4丁目 |
| 権利 | 所有権 |
| 敷地面積 | 81.04㎡ |
| 建物面積 | 95.58㎡ |
| 建物構造 | 木造2階建 |
| 間取り | 4LDK+ルーフバルコニー+カースペース1台 |
| 築年月 | 2004年10月 |
| 建築確認番号 | ※省略 |
| 設備 | 公営水道・本下水・東京ガス・東京電力 |
| リフォーム有無 | 有 |
| リフォーム履歴内容 | ～2024年11月29日完了予定～ ■システムキッチン(浄水器付) ■ユニットバス(追焚･換気乾燥機付) ■洗面化粧台、洗濯用水栓 ■温水洗浄便座付トイレ(1F･2F) ■フローリング貼(LDK、全洋室、廊下) ■フロアタイル貼(洗面室、トイレ) ■壁･天井クロス貼 ■ハウスクリーニング ■外壁･屋根塗装 |
| 接道状況 | 南側約4.0ｍ私道 |
| 都市計画 | 市街化区域 |
| 用途地域 | 第一種住居地域 |
|---|---|
| 高度地区 | |
| 防火指定 | |
| 建ぺい率/ 容積率 |
60％／160％ |
| 引渡時期 | 相談 |
| 取引態様 | 媒介 |
| 建物仕様 | ◆追焚機能 ◆浴室乾燥機 ◆洗浄便座 ◆浄水器 ◆トイレ2ヶ所 ◆全居室収納あり ◆ルーフバルコニー |
| ポイント | |
| 指定学校区 | 練馬区立富士見台小学校 練馬区立石神井東中学校 |
| 備考 | ●アフターサービス保証付 |
練馬区立富士見台小学校 約550m 徒歩7分
練馬区立石神井東中学校 約900m 徒歩12分
南光幼稚園 約240m 徒歩3分
西友高野台店 約800m 徒歩10分
ピーコックストア 高野台店 約850m 徒歩11分
ジェーソン 練馬高松店 約900m 徒歩12分
練馬区立 富士見台公園 約400m 徒歩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.
