【9月11日より内覧開始】平成21年築の4LDK戸建が姿を変えて登場する。東南角地に佇み、燦燦と輝く太陽が家族を照らす。家族と送る、明るい未来を一緒に想像しませんか？
4LDK+小屋裏収納+カースペース1台
敷地面積：82.97m2 建物面積：87.24m2
6,599万円
見学予約受付中
| 価格 | 6,599万円 |
|---|---|
| 所在地 | 中野区鷺宮6丁目 |
| 権利 | 所有権 |
| 敷地面積 | 82.97㎡ |
| 建物面積 | 87.24㎡ |
| 建物構造 | 木造2階建 |
| 間取り | 4LDK+小屋裏収納+カースペース1台 |
| 築年月 | 2009年10月 |
| 建築確認番号 | ※省略 |
| 設備 | 公営水道・本下水・東京ガス・東京電力 |
| リフォーム有無 | 有 |
| リフォーム履歴内容 | ■キッチン(ガスコンロ、浄水器一体型水栓) ■浴室(鏡、シャワーヘッドホース) ■洗面室(洗面化粧台、洗濯用水栓、洗濯パン) ■トイレ(温水洗浄便座一体型:1.2F) ■その他(照明器具、建具、スイッチコンセント、給湯器、玄関収納) ■床:フローリング上貼(LDK、洋室全室)、フロアタイル貼(トイレ、洗面所) ■壁･天井クロス貼 ■ハウスクリーニング |
| 接道状況 | 東側約4.0ｍ公道 南側約3.2～4.0ｍ公道 |
| 都市計画 | 市街化区域 |
| 用途地域 | 第一種低層住居専用地域 |
|---|---|
| 高度地区 | 第一種高度地区 |
| 防火指定 | 準防火地域 |
| 建ぺい率/ 容積率 |
50％／150％ |
| 引渡時期 | 即日 |
| 取引態様 | 媒介 |
| 建物仕様 | ◆対面キッチン ◆浄水器 ◆洗浄便座 ◆追焚機能 ◆浴室乾燥機 ◆トイレ2ヶ所 ◆床暖房 ◆収納豊富 |
| ポイント | ●リノベーション戸建 |
| 指定学校区 | 中野区立武蔵台小学校 中野区立北中野中学校 |
| 備考 | ●アフターサービス保証付 |
中野区立武蔵台小学校 約500m 徒歩7分
中野区立北中野中学校 約700m 徒歩9分
ちどり幼稚園 約500m 徒歩7分
オーケー 鷺宮店 約500m 徒歩7分
西友下井草店 約600m 徒歩8分
ファミリーマート 下井草駅南口店 約600m 徒歩8分
ローソン 下井草駅前店 約650m 徒歩9分
ウエルシア中野さぎの宮店 約1000m 徒歩13分
見学予約受付中
見学予約受付中
エリア検索
路線検索
会員限定物件
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.
