サンローヤル 【11月08日更新】
敷金ゼロ
礼金ゼロ
2階以上
バス・トイレ別
| 間取り図 | 階数 | 間取り | 面積 | 賃料 | 管理費 | 敷金 | 礼金 | お気に入り | お問合わせ |
|---|---|---|---|---|---|---|---|---|---|
| 2階 | 1K | 24.64m2 | 42,000円 | 4,000円 | 0ヶ月 | 0ヶ月 |
|
お問合わせ | |
| 3階 | 1K | 24.64m2 | 42,000円 | 4,000円 | 0ヶ月 | 0ヶ月 |
|
お問合わせ | |
| 4階 | 1K | 24.64m2 | 42,000円 | 3,000円 | 0ヶ月 | 0ヶ月 |
|
お問合わせ |
Outline 建物概要
| 物件名 | サンローヤル | ||
| 住所 | Map | ||
| 交通 | |||
| 築年月 | 1995年7月 | 総戸数 | -戸 |
| 階建 | 4階建 | 種別/構造 | RC |
| 賃料 | 42,000円 | 共益費/管理費 | 3,000円 ~ 4,000円 |
| 間取り | 1K | 専有面積 | 24.64m2 |
| 敷金 | 0ヶ月 | 礼金 | 0ヶ月 |
| 駐車場 | - | ||
| 特長 | |||
| 設備 | |||
| 備考 |
※掲載している物件がご成約している場合もございますのでご了承ください。 ※掲載詳細に相違がある場合は、弊社スタッフの情報を優先させていただきます。 ※こちらのお部屋情報の他にも空き部屋・空き予定のお部屋もございますので、メールやお電話にてお問い合わせください。 ※駐車場、駐輪場については、メールやお電話にてお問い合わせください。お客様からのお問い合わせをお待ちしています。 ※ペット相談可の物件やSOHO利用については、お部屋ごとに禁止とされている場合もございますので御注意下さい。お客様に代わって弊社スタッフが確認と交渉を行います。 |
||
| 最新情報 | サンローヤル - 最新情報 | ||
| 付近の物件 |
Notice (8): Undefined index: id [APP/Template/Element/source_link.ctp, line 13] Code Context /ILC1/ILC2/ target="_blank">
$viewFile = '/usr/share/nginx/html/spoint_sate_zeroceleb/project/src/Template/Element/source_link.ctp'
$dataForView = [
'count' => object(stdClass) {
articles => (int) 12993
rooms => (int) 23
},
'common' => object(stdClass) {
base_title => null
title => 'サンローヤル|初期費用0のゼロセレブ'
company => '株式会社 S-point (エスポイント)'
meta => object(stdClass) {}
bread => object(stdClass) {}
default => object(stdClass) {}
mobile => object(stdClass) {}
element => object(stdClass) {}
},
'shop' => object(Cake\ORM\Entity) {
'id' => (int) 6,
'flag' => (int) 2,
'title' => '部屋セレブ覚王山店',
'color' => '4DB6AC',
'tel1' => '052-757-5577',
'fax' => '052-757-5588',
'email' => 'h28h@spoint.jp',
'postcode' => '464-0841',
'address' => '名古屋市千種区覚王山通9丁目18',
'routes_id' => (int) 48,
'route' => '名古屋市営地下鉄東山線',
'stations_id' => (int) 997,
'station' => '覚王山',
'time_required' => '1',
'open_time' => '10:00~18:30',
'close_time' => null,
'comment' => '1',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [[maximum depth reached]],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'Shops'
},
'side' => [
'おすすめの物件' => [
(int) 0 => object(App\Model\Entity\Article) {},
(int) 1 => object(App\Model\Entity\Article) {},
(int) 2 => object(App\Model\Entity\Article) {},
(int) 3 => object(App\Model\Entity\Article) {},
(int) 4 => object(App\Model\Entity\Article) {}
]
],
'list' => [
'築年数が同じくらいの物件' => [
(int) 0 => object(App\Model\Entity\Article) {},
(int) 1 => object(App\Model\Entity\Article) {},
(int) 2 => object(App\Model\Entity\Article) {}
],
'賃料が同じくらいの物件' => [
(int) 0 => object(App\Model\Entity\Article) {},
(int) 1 => object(App\Model\Entity\Article) {},
(int) 2 => object(App\Model\Entity\Article) {},
(int) 3 => object(App\Model\Entity\Article) {}
],
'新着情報' => [
(int) 0 => object(App\Model\Entity\Article) {},
(int) 1 => object(App\Model\Entity\Article) {},
(int) 2 => object(App\Model\Entity\Article) {},
(int) 3 => object(App\Model\Entity\Article) {}
]
],
'room' => object(stdClass) {
number => [
[maximum depth reached]
]
layout => [
[maximum depth reached]
]
direction => [
[maximum depth reached]
]
type => [
[maximum depth reached]
]
},
'left' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT articles.id AS `articles__id`, articles.title AS `articles__title`, articles.shops_id AS `articles__shops_id`, (SELECT title FROM shops WHERE flag = 2 AND id = articles.shops_id LIMIT 1) AS `shops_title`, (SELECT title FROM routes WHERE id = articles.routes_id_1 LIMIT 1) AS `route`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_1 AND id = articles.stations_id_1 LIMIT 1) AS `station`, station_walk_1 AS `station_walk`, COALESCE((SELECT rent FROM rooms WHERE flag = 2 AND status = 2 AND articles_id = articles.id ORDER BY rent ASC LIMIT 1), 0) AS `rent_min`, COALESCE((SELECT rent FROM rooms WHERE flag = 2 AND status = 2 AND articles_id = articles.id ORDER BY rent DESC LIMIT 1), 0) AS `rent_max`, (SELECT room_number FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) ASC LIMIT 1) AS `room_number_min`, (SELECT room_number FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) DESC LIMIT 1) AS `room_number_max`, (SELECT room_layout FROM rooms WHERE flag = 2 AND status = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) ASC LIMIT 1) AS `room_layout_min`, (SELECT room_layout FROM rooms WHERE flag = 2 AND status = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) DESC LIMIT 1) AS `room_layout_max`, (SELECT area FROM rooms WHERE flag = 2 AND status = 2 AND articles_id = articles.id ORDER BY area ASC LIMIT 1) AS `room_area_min`, (SELECT area FROM rooms WHERE flag = 2 AND status = 2 AND articles_id = articles.id ORDER BY area DESC LIMIT 1) AS `room_area_max`, (SELECT COUNT(*) FROM rooms WHERE flag = 2 AND status = 2 AND articles_id = articles.id) AS `room_release`, articles.year AS `articles__year`, articles.month AS `articles__month`, COALESCE((SELECT id FROM imgs WHERE type = 1 AND flag = 2 AND trait_id = articles.id ORDER BY class = 20 DESC, display_order ASC LIMIT 1), 0) AS `imgs_id`, articles.created AS `articles__created`, (SELECT modified FROM rooms WHERE articles_id = articles.id AND status = 2 AND flag = 2 ORDER BY modified DESC LIMIT 1) AS `modified`, (SELECT __modified FROM rooms WHERE articles_id = articles.id AND status = 2 AND flag = 2 ORDER BY __modified DESC LIMIT 1) AS `__modified` FROM articles articles WHERE (articles.flag = :c0 AND articles.id IN (SELECT articles_id FROM rooms WHERE flag = 2 and status = 2)) ORDER BY imgs_id = 0 ASC, (SELECT __modified FROM rooms WHERE articles_id = articles.id AND status = 2 AND flag = 2 ORDER BY __modified DESC LIMIT 1) desc, modified desc LIMIT 8',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'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\ArticlesTable) {}
},
'entity' => object(App\Model\Entity\Article) {
'id' => (int) 12177,
'source_id' => (int) 75601,
'title' => 'サンローヤル',
'explanation' => null,
'recommend' => null,
'shops_id' => (int) 6,
'staffs_id' => (int) 0,
'address' => '愛知県長久手市砂子620',
'parking' => '{"fee": "5000", "distance": "-1", "fee_tax_flag": "2", "parking_type": "屋根付き駐車場", "parking_in_out_flag": 0}',
'routes_id_1' => (int) 28,
'routes_id_2' => (int) 28,
'routes_id_3' => (int) 28,
'routes_id_4' => (int) 0,
'routes_id_5' => (int) 0,
'stations_id_1' => (int) 680,
'stations_id_2' => (int) 679,
'stations_id_3' => (int) 678,
'stations_id_4' => (int) 0,
'stations_id_5' => (int) 0,
'station_walk_1' => (int) 10,
'station_walk_2' => (int) 14,
'station_walk_3' => (int) 24,
'station_walk_4' => (int) 0,
'station_walk_5' => (int) 0,
'bus_time_1' => (int) 0,
'bus_time_2' => (int) 0,
'bus_time_3' => (int) 0,
'bus_time_4' => (int) 0,
'bus_time_5' => (int) 0,
'bus_stop_1' => null,
'bus_stop_2' => null,
'bus_stop_3' => null,
'bus_stop_4' => null,
'bus_stop_5' => null,
'bus_stop_walk_1' => (int) 0,
'bus_stop_walk_2' => (int) 0,
'bus_stop_walk_3' => (int) 0,
'bus_stop_walk_4' => (int) 0,
'bus_stop_walk_5' => (int) 0,
'type' => (int) 30301,
'floor' => (int) 4,
'floor_under' => (int) 0,
'year' => (int) 1995,
'month' => (int) 7,
'information' => [
[maximum depth reached]
],
'rooms' => (int) 0,
'lat' => (float) 35.166949,
'lng' => (float) 137.045219,
'seo_keywords' => null,
'seo_description' => 'にあるサンローヤルは、人気の初期費用0(ゼロ)賃貸マンションです。(1995年築)こちらの物件は、11月10日現在、3件の空室があります。この物件は、愛知県長久手市砂子620にあり、リニモ 長久手古戦場駅から徒歩10分の賃貸物件です。人気の物件のため、気になる場合はお早めに部屋セレブ覚王山店にご連絡ください。',
'remarks' => '',
'room_explanation' => null,
'imgs_id' => '474348',
'route1' => 'リニモ',
'route2' => 'リニモ',
'route3' => 'リニモ',
'route4' => null,
'route5' => null,
'station1' => '長久手古戦場',
'station2' => '杁ヶ池公園',
'station3' => 'はなみずき通',
'station4' => null,
'station5' => null,
'structure' => 'RC',
'icon1' => null,
'icon2' => null,
'icon3' => null,
'icon4' => null,
'icon5' => null,
'icon6' => null,
'icon7' => null,
'created' => object(Cake\I18n\FrozenTime) {},
'modified' => object(Cake\I18n\FrozenTime) {},
'__modified' => object(Cake\I18n\FrozenTime) {},
'rooms_count' => '3',
'rooms_release_count' => '3',
'rooms_wanted_count' => '0',
'show_external_link_flag' => '2',
'rooms_floor' => '4',
'imgs' => [
[maximum depth reached]
],
'facilities' => object(stdClass) {},
'rent' => object(stdClass) {},
'maintenance' => object(stdClass) {},
'security_deposit' => object(stdClass) {},
'reward' => object(stdClass) {},
'layout' => object(stdClass) {},
'area' => object(stdClass) {},
'r' => [
[maximum depth reached]
],
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [
[maximum depth reached]
],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'Articles'
},
'recommend_link' => [
(int) 0 => object(Cake\ORM\Entity) {},
(int) 1 => object(Cake\ORM\Entity) {},
(int) 2 => object(Cake\ORM\Entity) {},
(int) 3 => object(Cake\ORM\Entity) {},
(int) 4 => object(Cake\ORM\Entity) {}
],
's_flag' => 'articles',
'article_facilities' => [
(int) 0 => object(App\Model\Entity\Facility) {},
(int) 1 => object(App\Model\Entity\Facility) {},
(int) 2 => object(App\Model\Entity\Facility) {},
(int) 3 => object(App\Model\Entity\Facility) {}
],
'room_facilities' => [
(int) 0 => object(App\Model\Entity\Facility) {},
(int) 1 => object(App\Model\Entity\Facility) {},
(int) 2 => object(App\Model\Entity\Facility) {},
(int) 3 => object(App\Model\Entity\Facility) {},
(int) 4 => object(App\Model\Entity\Facility) {},
(int) 5 => object(App\Model\Entity\Facility) {},
(int) 6 => object(App\Model\Entity\Facility) {},
(int) 7 => object(App\Model\Entity\Facility) {},
(int) 8 => object(App\Model\Entity\Facility) {},
(int) 9 => object(App\Model\Entity\Facility) {}
],
'article_features' => [
(int) 0 => object(App\Model\Entity\Facility) {},
(int) 1 => object(App\Model\Entity\Facility) {}
],
'room_features' => [
(int) 0 => object(App\Model\Entity\Facility) {},
(int) 1 => object(App\Model\Entity\Facility) {},
(int) 2 => object(App\Model\Entity\Facility) {},
(int) 3 => object(App\Model\Entity\Facility) {},
(int) 4 => object(App\Model\Entity\Facility) {},
(int) 5 => object(App\Model\Entity\Facility) {},
(int) 6 => object(App\Model\Entity\Facility) {}
],
'station_list_sort' => [
(int) 0 => [
'id' => (int) 23,
'title' => '原',
'count' => (int) 5
],
(int) 1 => [
'id' => (int) 668,
'title' => '植田',
'count' => (int) 5
],
(int) 2 => [
'id' => (int) 1048,
'title' => '塩釜口',
'count' => (int) 5
],
(int) 3 => [
'id' => (int) 678,
'title' => 'はなみずき通',
'count' => (int) 4
],
(int) 4 => [
'id' => (int) 969,
'title' => '小幡',
'count' => (int) 4
],
(int) 5 => [
'id' => (int) 970,
'title' => '喜多山',
'count' => (int) 4
],
(int) 6 => [
'id' => (int) 971,
'title' => '大森・金城学院前',
'count' => (int) 4
],
(int) 7 => [
'id' => (int) 679,
'title' => '杁ヶ池公園',
'count' => (int) 3
],
(int) 8 => [
'id' => (int) 680,
'title' => '長久手古戦場',
'count' => (int) 3
],
(int) 9 => [
'id' => (int) 901,
'title' => '中小田井',
'count' => (int) 2
]
],
'area_list_sort' => [
(int) 0 => [
'id' => '22016',
'title' => '天白区',
'count' => (int) 5
],
(int) 1 => [
'id' => '22013',
'title' => '守山区',
'count' => (int) 4
],
(int) 2 => [
'id' => '22004',
'title' => '西区',
'count' => (int) 3
],
(int) 3 => [
'id' => '22007',
'title' => '昭和区',
'count' => (int) 2
],
(int) 4 => [
'id' => '22002',
'title' => '東区',
'count' => (int) 1
],
(int) 5 => [
'id' => '22005',
'title' => '中村区',
'count' => (int) 1
],
(int) 6 => [
'id' => '22008',
'title' => '瑞穂区',
'count' => (int) 1
],
(int) 7 => [
'id' => '22010',
'title' => '中川区',
'count' => (int) 1
],
(int) 8 => [
'id' => '22012',
'title' => '南区',
'count' => (int) 1
]
],
'station_list' => [
(int) 48 => [
'id' => (int) 48,
'title' => '名古屋市営地下鉄東山線',
'count' => (int) 5,
'station' => [
[maximum depth reached]
]
],
(int) 49 => [
'id' => (int) 49,
'title' => '名古屋市営地下鉄名城線',
'count' => (int) 2,
'station' => [
[maximum depth reached]
]
],
(int) 50 => [
'id' => (int) 50,
'title' => '名古屋市営地下鉄鶴舞線',
'count' => (int) 8,
'station' => [
[maximum depth reached]
]
],
(int) 51 => [
'id' => (int) 51,
'title' => '名古屋市営地下鉄桜通線',
'count' => (int) 3,
'station' => [
[maximum depth reached]
]
],
(int) 29 => [
'id' => (int) 29,
'title' => '名鉄名古屋本線',
'count' => (int) 1,
'station' => [
[maximum depth reached]
]
],
(int) 35 => [
'id' => (int) 35,
'title' => '名鉄常滑線',
'count' => (int) 1,
'station' => [
[maximum depth reached]
]
],
(int) 42 => [
'id' => (int) 42,
'title' => '名鉄犬山線',
'count' => (int) 3,
'station' => [
[maximum depth reached]
]
],
(int) 46 => [
'id' => (int) 46,
'title' => '名鉄瀬戸線',
'count' => (int) 4,
'station' => [
[maximum depth reached]
]
],
(int) 2 => [
'id' => (int) 2,
'title' => 'JR東海道本線',
'count' => (int) 0,
'station' => [
[maximum depth reached]
]
],
(int) 14 => [
'id' => (int) 14,
'title' => 'JR関西本線',
'count' => (int) 0,
'station' => [
[maximum depth reached]
]
],
(int) 20 => [
'id' => (int) 20,
'title' => 'あおなみ線',
'count' => (int) 1,
'station' => [
[maximum depth reached]
]
],
(int) 27 => [
'id' => (int) 27,
'title' => '豊橋鉄道渥美線',
'count' => (int) 0,
'station' => [
[maximum depth reached]
]
],
(int) 28 => [
'id' => (int) 28,
'title' => 'リニモ',
'count' => (int) 4,
'station' => [
[maximum depth reached]
]
]
],
'area_list' => [
(int) 22 => [
'id' => (int) 22,
'title' => '名古屋市',
'subtitle' => '',
'city' => [
[maximum depth reached]
]
]
],
'history_c' => (int) 0,
'favorite_c' => (int) 0,
'random' => object(Cake\ORM\ResultSet) {
'items' => [
[maximum depth reached]
]
},
'api' => object(stdClass) {
default => object(stdClass) {}
google => object(stdClass) {}
},
'mobile_pc' => false
]
$count = object(stdClass) {
articles => (int) 12993
rooms => (int) 23
}
$common = object(stdClass) {
base_title => null
title => 'サンローヤル|初期費用0のゼロセレブ'
company => '株式会社 S-point (エスポイント)'
meta => object(stdClass) {}
bread => object(stdClass) {}
default => object(stdClass) {}
mobile => object(stdClass) {}
element => object(stdClass) {}
}
$shop = object(Cake\ORM\Entity) {
'id' => (int) 6,
'flag' => (int) 2,
'title' => '部屋セレブ覚王山店',
'color' => '4DB6AC',
'tel1' => '052-757-5577',
'fax' => '052-757-5588',
'email' => 'h28h@spoint.jp',
'postcode' => '464-0841',
'address' => '名古屋市千種区覚王山通9丁目18',
'routes_id' => (int) 48,
'route' => '名古屋市営地下鉄東山線',
'stations_id' => (int) 997,
'station' => '覚王山',
'time_required' => '1',
'open_time' => '10:00~18:30',
'close_time' => null,
'comment' => '1',
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Shops'
}
$side = [
'おすすめの物件' => [
(int) 0 => object(App\Model\Entity\Article) {},
(int) 1 => object(App\Model\Entity\Article) {},
(int) 2 => object(App\Model\Entity\Article) {},
(int) 3 => object(App\Model\Entity\Article) {},
(int) 4 => object(App\Model\Entity\Article) {}
]
]
$list = [
'築年数が同じくらいの物件' => [
(int) 0 => object(App\Model\Entity\Article) {},
(int) 1 => object(App\Model\Entity\Article) {},
(int) 2 => object(App\Model\Entity\Article) {}
],
'賃料が同じくらいの物件' => [
(int) 0 => object(App\Model\Entity\Article) {},
(int) 1 => object(App\Model\Entity\Article) {},
(int) 2 => object(App\Model\Entity\Article) {},
(int) 3 => object(App\Model\Entity\Article) {}
],
'新着情報' => [
(int) 0 => object(App\Model\Entity\Article) {},
(int) 1 => object(App\Model\Entity\Article) {},
(int) 2 => object(App\Model\Entity\Article) {},
(int) 3 => object(App\Model\Entity\Article) {}
]
]
$room = object(stdClass) {
number => [
(int) 0 => '-',
(int) 1 => '1',
(int) 2 => '2',
(int) 3 => '3',
(int) 4 => '4',
(int) 5 => '5',
(int) 6 => '6',
(int) 7 => '7',
(int) 8 => '8',
(int) 9 => '9',
(int) 10 => '10'
]
layout => [
(int) 0 => '-',
(int) 10 => 'R',
(int) 20 => 'K',
(int) 25 => 'SK',
(int) 30 => 'DK',
(int) 35 => 'SDK',
(int) 40 => 'LK',
(int) 45 => 'SLK',
(int) 50 => 'LDK',
(int) 55 => 'SLDK'
]
direction => [
(int) 0 => '-',
(int) 1 => '南',
(int) 2 => '南東',
(int) 3 => '東',
(int) 4 => '北東',
(int) 5 => '北',
(int) 6 => '北西',
(int) 7 => '西',
(int) 8 => '南西'
]
type => [
(int) 0 => '-',
(int) 1 => '和室',
(int) 2 => '洋室',
(int) 3 => 'リビング',
(int) 4 => 'キッチン',
(int) 5 => 'ダイニング',
(int) 6 => 'ダイニングキッチン',
(int) 7 => 'リビングダイニング',
(int) 8 => 'リビングダイニングキッチン',
(int) 9 => 'サービスルーム',
(int) 10 => 'ロフト',
(int) 11 => 'その他'
]
}
$left = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT articles.id AS `articles__id`, articles.title AS `articles__title`, articles.shops_id AS `articles__shops_id`, (SELECT title FROM shops WHERE flag = 2 AND id = articles.shops_id LIMIT 1) AS `shops_title`, (SELECT title FROM routes WHERE id = articles.routes_id_1 LIMIT 1) AS `route`, (SELECT title FROM stations WHERE routes_id = articles.routes_id_1 AND id = articles.stations_id_1 LIMIT 1) AS `station`, station_walk_1 AS `station_walk`, COALESCE((SELECT rent FROM rooms WHERE flag = 2 AND status = 2 AND articles_id = articles.id ORDER BY rent ASC LIMIT 1), 0) AS `rent_min`, COALESCE((SELECT rent FROM rooms WHERE flag = 2 AND status = 2 AND articles_id = articles.id ORDER BY rent DESC LIMIT 1), 0) AS `rent_max`, (SELECT room_number FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) ASC LIMIT 1) AS `room_number_min`, (SELECT room_number FROM rooms WHERE flag = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) DESC LIMIT 1) AS `room_number_max`, (SELECT room_layout FROM rooms WHERE flag = 2 AND status = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) ASC LIMIT 1) AS `room_layout_min`, (SELECT room_layout FROM rooms WHERE flag = 2 AND status = 2 AND articles_id = articles.id ORDER BY CAST(CONCAT(room_number, '.', room_layout) AS DECIMAL(2, 1)) DESC LIMIT 1) AS `room_layout_max`, (SELECT area FROM rooms WHERE flag = 2 AND status = 2 AND articles_id = articles.id ORDER BY area ASC LIMIT 1) AS `room_area_min`, (SELECT area FROM rooms WHERE flag = 2 AND status = 2 AND articles_id = articles.id ORDER BY area DESC LIMIT 1) AS `room_area_max`, (SELECT COUNT(*) FROM rooms WHERE flag = 2 AND status = 2 AND articles_id = articles.id) AS `room_release`, articles.year AS `articles__year`, articles.month AS `articles__month`, COALESCE((SELECT id FROM imgs WHERE type = 1 AND flag = 2 AND trait_id = articles.id ORDER BY class = 20 DESC, display_order ASC LIMIT 1), 0) AS `imgs_id`, articles.created AS `articles__created`, (SELECT modified FROM rooms WHERE articles_id = articles.id AND status = 2 AND flag = 2 ORDER BY modified DESC LIMIT 1) AS `modified`, (SELECT __modified FROM rooms WHERE articles_id = articles.id AND status = 2 AND flag = 2 ORDER BY __modified DESC LIMIT 1) AS `__modified` FROM articles articles WHERE (articles.flag = :c0 AND articles.id IN (SELECT articles_id FROM rooms WHERE flag = 2 and status = 2)) ORDER BY imgs_id = 0 ASC, (SELECT __modified FROM rooms WHERE articles_id = articles.id AND status = 2 AND flag = 2 ORDER BY __modified DESC LIMIT 1) desc, modified desc LIMIT 8',
'params' => [
':c0' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'articles__id' => 'biginteger',
'articles.id' => 'biginteger',
'id' => 'biginteger',
'articles__source_id' => 'biginteger',
'articles.source_id' => 'biginteger',
'source_id' => 'biginteger',
'articles__class' => 'integer',
'articles.class' => 'integer',
'class' => 'integer',
'articles__flag' => 'integer',
'articles.flag' => 'integer',
'flag' => 'integer',
'articles__title' => 'string',
'articles.title' => 'string',
'title' => 'string',
'articles__title_hide' => 'integer',
'articles.title_hide' => 'integer',
'title_hide' => 'integer',
'articles__title_kana' => 'string',
'articles.title_kana' => 'string',
'title_kana' => 'string',
'articles__sub_title' => 'string',
'articles.sub_title' => 'string',
'sub_title' => 'string',
'articles__explanation' => 'text',
'articles.explanation' => 'text',
'explanation' => 'text',
'articles__recommend' => 'text',
'articles.recommend' => 'text',
'recommend' => 'text',
'articles__shops_id' => 'biginteger',
'articles.shops_id' => 'biginteger',
'shops_id' => 'biginteger',
'articles__staffs_id' => 'biginteger',
'articles.staffs_id' => 'biginteger',
'staffs_id' => 'biginteger',
'articles__postcode' => 'string',
'articles.postcode' => 'string',
'postcode' => 'string',
'articles__address' => 'string',
'articles.address' => 'string',
'address' => 'string',
'articles__address_etc' => 'text',
'articles.address_etc' => 'text',
'address_etc' => 'text',
'articles__routes_id_1' => 'biginteger',
'articles.routes_id_1' => 'biginteger',
'routes_id_1' => 'biginteger',
'articles__stations_id_1' => 'biginteger',
'articles.stations_id_1' => 'biginteger',
'stations_id_1' => 'biginteger',
'articles__station_walk_1' => 'integer',
'articles.station_walk_1' => 'integer',
'station_walk_1' => 'integer',
'articles__bus_time_1' => 'integer',
'articles.bus_time_1' => 'integer',
'bus_time_1' => 'integer',
'articles__bus_stop_1' => 'string',
'articles.bus_stop_1' => 'string',
'bus_stop_1' => 'string',
'articles__bus_stop_walk_1' => 'integer',
'articles.bus_stop_walk_1' => 'integer',
'bus_stop_walk_1' => 'integer',
'articles__schools_id_1' => 'biginteger',
'articles.schools_id_1' => 'biginteger',
'schools_id_1' => 'biginteger',
'articles__schools_distance_1' => 'integer',
'articles.schools_distance_1' => 'integer',
'schools_distance_1' => 'integer',
'articles__routes_id_2' => 'biginteger',
'articles.routes_id_2' => 'biginteger',
'routes_id_2' => 'biginteger',
'articles__stations_id_2' => 'biginteger',
'articles.stations_id_2' => 'biginteger',
'stations_id_2' => 'biginteger',
'articles__station_walk_2' => 'integer',
'articles.station_walk_2' => 'integer',
'station_walk_2' => 'integer',
'articles__bus_time_2' => 'integer',
'articles.bus_time_2' => 'integer',
'bus_time_2' => 'integer',
'articles__bus_stop_2' => 'string',
'articles.bus_stop_2' => 'string',
'bus_stop_2' => 'string',
'articles__bus_stop_walk_2' => 'integer',
'articles.bus_stop_walk_2' => 'integer',
'bus_stop_walk_2' => 'integer',
'articles__schools_id_2' => 'biginteger',
'articles.schools_id_2' => 'biginteger',
'schools_id_2' => 'biginteger',
'articles__schools_distance_2' => 'integer',
'articles.schools_distance_2' => 'integer',
'schools_distance_2' => 'integer',
'articles__routes_id_3' => 'biginteger',
'articles.routes_id_3' => 'biginteger',
'routes_id_3' => 'biginteger',
'articles__stations_id_3' => 'biginteger',
'articles.stations_id_3' => 'biginteger',
'stations_id_3' => 'biginteger',
'articles__station_walk_3' => 'integer',
'articles.station_walk_3' => 'integer',
'station_walk_3' => 'integer',
'articles__bus_time_3' => 'integer',
'articles.bus_time_3' => 'integer',
'bus_time_3' => 'integer',
'articles__bus_stop_3' => 'string',
'articles.bus_stop_3' => 'string',
'bus_stop_3' => 'string',
'articles__bus_stop_walk_3' => 'integer',
'articles.bus_stop_walk_3' => 'integer',
'bus_stop_walk_3' => 'integer',
'articles__schools_id_3' => 'biginteger',
'articles.schools_id_3' => 'biginteger',
'schools_id_3' => 'biginteger',
'articles__schools_distance_3' => 'integer',
'articles.schools_distance_3' => 'integer',
'schools_distance_3' => 'integer',
'articles__routes_id_4' => 'biginteger',
'articles.routes_id_4' => 'biginteger',
'routes_id_4' => 'biginteger',
'articles__stations_id_4' => 'biginteger',
'articles.stations_id_4' => 'biginteger',
'stations_id_4' => 'biginteger',
'articles__station_walk_4' => 'integer',
'articles.station_walk_4' => 'integer',
'station_walk_4' => 'integer',
'articles__bus_time_4' => 'integer',
'articles.bus_time_4' => 'integer',
'bus_time_4' => 'integer',
'articles__bus_stop_4' => 'string',
'articles.bus_stop_4' => 'string',
'bus_stop_4' => 'string',
'articles__bus_stop_walk_4' => 'integer',
'articles.bus_stop_walk_4' => 'integer',
'bus_stop_walk_4' => 'integer',
'articles__schools_id_4' => 'biginteger',
'articles.schools_id_4' => 'biginteger',
'schools_id_4' => 'biginteger',
'articles__schools_distance_4' => 'integer',
'articles.schools_distance_4' => 'integer',
'schools_distance_4' => 'integer',
'articles__routes_id_5' => 'biginteger',
'articles.routes_id_5' => 'biginteger',
'routes_id_5' => 'biginteger',
'articles__stations_id_5' => 'biginteger',
'articles.stations_id_5' => 'biginteger',
'stations_id_5' => 'biginteger',
'articles__station_walk_5' => 'integer',
'articles.station_walk_5' => 'integer',
'station_walk_5' => 'integer',
'articles__bus_time_5' => 'integer',
'articles.bus_time_5' => 'integer',
'bus_time_5' => 'integer',
'articles__bus_stop_5' => 'string',
'articles.bus_stop_5' => 'string',
'bus_stop_5' => 'string',
'articles__bus_stop_walk_5' => 'integer',
'articles.bus_stop_walk_5' => 'integer',
'bus_stop_walk_5' => 'integer',
'articles__schools_id_5' => 'biginteger',
'articles.schools_id_5' => 'biginteger',
'schools_id_5' => 'biginteger',
'articles__schools_distance_5' => 'integer',
'articles.schools_distance_5' => 'integer',
'schools_distance_5' => 'integer',
'articles__type' => 'integer',
'articles.type' => 'integer',
'type' => 'integer',
'articles__structures_id' => 'biginteger',
'articles.structures_id' => 'biginteger',
'structures_id' => 'biginteger',
'articles__parking' => 'text',
'articles.parking' => 'text',
'parking' => 'text',
'articles__rooms' => 'integer',
'articles.rooms' => 'integer',
'rooms' => 'integer',
'articles__floor' => 'integer',
'articles.floor' => 'integer',
'floor' => 'integer',
'articles__floor_under' => 'integer',
'articles.floor_under' => 'integer',
'floor_under' => 'integer',
'articles__year' => 'integer',
'articles.year' => 'integer',
'year' => 'integer',
'articles__month' => 'integer',
'articles.month' => 'integer',
'month' => 'integer',
'articles__information' => 'json',
'articles.information' => 'json',
'information' => 'json',
'articles__media' => 'json',
'articles.media' => 'json',
'media' => 'json',
'articles__reviews' => 'json',
'articles.reviews' => 'json',
'reviews' => 'json',
'articles__remarks' => 'text',
'articles.remarks' => 'text',
'remarks' => 'text',
'articles__memo' => 'text',
'articles.memo' => 'text',
'memo' => 'text',
'articles__mcompanies_id' => 'biginteger',
'articles.mcompanies_id' => 'biginteger',
'mcompanies_id' => 'biginteger',
'articles__lat' => 'float',
'articles.lat' => 'float',
'lat' => 'float',
'articles__lng' => 'float',
'articles.lng' => 'float',
'lng' => 'float',
'articles__seo_keywords' => 'text',
'articles.seo_keywords' => 'text',
'seo_keywords' => 'text',
'articles__seo_description' => 'text',
'articles.seo_description' => 'text',
'seo_description' => 'text',
'articles__access' => 'biginteger',
'articles.access' => 'biginteger',
'access' => 'biginteger',
'articles__admins_id' => 'biginteger',
'articles.admins_id' => 'biginteger',
'admins_id' => 'biginteger',
'articles____created' => 'datetime',
'articles.__created' => 'datetime',
'__created' => 'datetime',
'articles____modified' => 'datetime',
'articles.__modified' => 'datetime',
'__modified' => 'datetime',
'articles__created' => 'datetime',
'articles.created' => 'datetime',
'created' => 'datetime',
'articles__modified' => 'datetime',
'articles.modified' => 'datetime',
'modified' => 'datetime'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\ArticlesTable) {}
}
$entity = object(App\Model\Entity\Article) {
'id' => (int) 12177,
'source_id' => (int) 75601,
'title' => 'サンローヤル',
'explanation' => null,
'recommend' => null,
'shops_id' => (int) 6,
'staffs_id' => (int) 0,
'address' => '愛知県長久手市砂子620',
'parking' => '{"fee": "5000", "distance": "-1", "fee_tax_flag": "2", "parking_type": "屋根付き駐車場", "parking_in_out_flag": 0}',
'routes_id_1' => (int) 28,
'routes_id_2' => (int) 28,
'routes_id_3' => (int) 28,
'routes_id_4' => (int) 0,
'routes_id_5' => (int) 0,
'stations_id_1' => (int) 680,
'stations_id_2' => (int) 679,
'stations_id_3' => (int) 678,
'stations_id_4' => (int) 0,
'stations_id_5' => (int) 0,
'station_walk_1' => (int) 10,
'station_walk_2' => (int) 14,
'station_walk_3' => (int) 24,
'station_walk_4' => (int) 0,
'station_walk_5' => (int) 0,
'bus_time_1' => (int) 0,
'bus_time_2' => (int) 0,
'bus_time_3' => (int) 0,
'bus_time_4' => (int) 0,
'bus_time_5' => (int) 0,
'bus_stop_1' => null,
'bus_stop_2' => null,
'bus_stop_3' => null,
'bus_stop_4' => null,
'bus_stop_5' => null,
'bus_stop_walk_1' => (int) 0,
'bus_stop_walk_2' => (int) 0,
'bus_stop_walk_3' => (int) 0,
'bus_stop_walk_4' => (int) 0,
'bus_stop_walk_5' => (int) 0,
'type' => (int) 30301,
'floor' => (int) 4,
'floor_under' => (int) 0,
'year' => (int) 1995,
'month' => (int) 7,
'information' => [
(int) 0 => object(stdClass) {},
(int) 1 => object(stdClass) {},
(int) 2 => object(stdClass) {},
(int) 3 => object(stdClass) {},
(int) 4 => object(stdClass) {},
(int) 5 => object(stdClass) {},
(int) 6 => object(stdClass) {},
(int) 7 => object(stdClass) {},
(int) 8 => object(stdClass) {},
(int) 9 => object(stdClass) {},
(int) 10 => object(stdClass) {},
(int) 11 => object(stdClass) {}
],
'rooms' => (int) 0,
'lat' => (float) 35.166949,
'lng' => (float) 137.045219,
'seo_keywords' => null,
'seo_description' => 'にあるサンローヤルは、人気の初期費用0(ゼロ)賃貸マンションです。(1995年築)こちらの物件は、11月10日現在、3件の空室があります。この物件は、愛知県長久手市砂子620にあり、リニモ 長久手古戦場駅から徒歩10分の賃貸物件です。人気の物件のため、気になる場合はお早めに部屋セレブ覚王山店にご連絡ください。',
'remarks' => '',
'room_explanation' => null,
'imgs_id' => '474348',
'route1' => 'リニモ',
'route2' => 'リニモ',
'route3' => 'リニモ',
'route4' => null,
'route5' => null,
'station1' => '長久手古戦場',
'station2' => '杁ヶ池公園',
'station3' => 'はなみずき通',
'station4' => null,
'station5' => null,
'structure' => 'RC',
'icon1' => null,
'icon2' => null,
'icon3' => null,
'icon4' => null,
'icon5' => null,
'icon6' => null,
'icon7' => null,
'created' => object(Cake\I18n\FrozenTime) {},
'modified' => object(Cake\I18n\FrozenTime) {},
'__modified' => object(Cake\I18n\FrozenTime) {},
'rooms_count' => '3',
'rooms_release_count' => '3',
'rooms_wanted_count' => '0',
'show_external_link_flag' => '2',
'rooms_floor' => '4',
'imgs' => [
(int) 0 => object(stdClass) {},
(int) 1 => object(stdClass) {},
(int) 2 => object(stdClass) {},
(int) 3 => object(stdClass) {},
(int) 4 => object(stdClass) {},
(int) 5 => object(stdClass) {},
(int) 6 => object(stdClass) {},
(int) 7 => object(stdClass) {},
(int) 8 => object(stdClass) {},
(int) 9 => object(stdClass) {},
(int) 10 => object(stdClass) {},
(int) 11 => object(stdClass) {},
(int) 12 => object(stdClass) {},
(int) 13 => object(stdClass) {},
(int) 14 => object(stdClass) {},
(int) 15 => object(stdClass) {},
(int) 16 => object(stdClass) {},
(int) 17 => object(stdClass) {},
(int) 18 => object(stdClass) {},
(int) 19 => object(stdClass) {},
(int) 20 => object(stdClass) {},
(int) 21 => object(stdClass) {},
(int) 22 => object(stdClass) {},
(int) 23 => object(stdClass) {},
(int) 24 => object(stdClass) {},
(int) 25 => object(stdClass) {},
(int) 26 => object(stdClass) {},
(int) 27 => object(stdClass) {},
(int) 28 => object(stdClass) {},
(int) 29 => object(stdClass) {},
(int) 30 => object(stdClass) {},
(int) 31 => object(stdClass) {},
(int) 32 => object(stdClass) {},
(int) 33 => object(stdClass) {},
(int) 34 => object(stdClass) {},
(int) 35 => object(stdClass) {},
(int) 36 => object(stdClass) {},
(int) 37 => object(stdClass) {},
(int) 38 => object(stdClass) {},
(int) 39 => object(stdClass) {},
(int) 40 => object(stdClass) {},
(int) 41 => object(stdClass) {}
],
'facilities' => object(stdClass) {},
'rent' => object(stdClass) {},
'maintenance' => object(stdClass) {},
'security_deposit' => object(stdClass) {},
'reward' => object(stdClass) {},
'layout' => object(stdClass) {},
'area' => object(stdClass) {},
'r' => [
(int) 0 => object(stdClass) {},
(int) 1 => object(stdClass) {},
(int) 2 => object(stdClass) {}
],
'[new]' => false,
'[accessible]' => [
'*' => true,
'id' => false
],
'[dirty]' => [
'imgs' => true,
'information' => true,
'facilities' => true,
'seo_description' => true,
'rent' => true,
'maintenance' => true,
'security_deposit' => true,
'reward' => true,
'layout' => true,
'area' => true,
'r' => true
],
'[original]' => [
'information' => '[{"type": "4", "image": "nears/75601/near1.jpeg", "title": "セブンイレブン長久手山野田店", "distance": "216"}, {"type": "2", "image": "nears/75601/near2.jpeg", "title": "イオンモール長久手", "distance": "854"}, {"type": "3", "image": "nears/75601/near3.jpeg", "title": "アピタ長久手店", "distance": "866"}, {"type": "10", "image": "nears/75601/near4.jpeg", "title": "長久手市立南小学校", "distance": "352"}, {"type": "9", "image": "nears/75601/near5.jpeg", "title": "長久手市立南中学校", "distance": "418"}, {"type": "13", "image": "nears/75601/near6.jpeg", "title": "医療法人福友会福友病院", "distance": "1289"}, {"type": "5", "image": "", "title": "ドラッグスギヤマ長久手店", "distance": "479"}, {"type": "17", "image": "", "title": "愛知銀行長久手支店", "distance": "520"}, {"type": "15", "image": "", "title": "長久手市役所", "distance": "1880"}, {"type": "14", "image": "", "title": "長久手片平郵便局", "distance": "1184"}, {"type": "19", "image": "", "title": "杁ケ池公園", "distance": "754"}, {"type": "11", "image": "", "title": "長久手市立長湫南保育園", "distance": "276"}]',
'facilities' => [
[maximum depth reached]
],
'seo_description' => null
],
'[virtual]' => [],
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Articles'
}
$recommend_link = [
(int) 0 => object(Cake\ORM\Entity) {
'id' => (int) 1,
'title' => '名古屋市中村区の初期費用0賃貸',
'link' => 'https://www.heyaceleb.com/search/CTY22005/ILC3/',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [[maximum depth reached]],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'Linkadmins'
},
(int) 1 => object(Cake\ORM\Entity) {
'id' => (int) 2,
'title' => '名古屋市西区の初期費用0賃貸',
'link' => 'https://www.heyaceleb.com/search/CTY22004/ILC3/',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [[maximum depth reached]],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'Linkadmins'
},
(int) 2 => object(Cake\ORM\Entity) {
'id' => (int) 3,
'title' => '名古屋市守山区の初期費用0賃貸',
'link' => 'https://www.heyaceleb.com/search/CTY22013/ILC3/',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [[maximum depth reached]],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'Linkadmins'
},
(int) 3 => object(Cake\ORM\Entity) {
'id' => (int) 4,
'title' => '名古屋市瑞穂区の初期費用0賃貸',
'link' => 'https://www.heyaceleb.com/search/CTY22008/ILC3/',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [[maximum depth reached]],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'Linkadmins'
},
(int) 4 => object(Cake\ORM\Entity) {
'id' => (int) 5,
'title' => '名古屋市南区の初期費用0賃貸',
'link' => 'https://www.heyaceleb.com/search/CTY22012/ILC3/',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [[maximum depth reached]],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'Linkadmins'
}
]
$s_flag = 'articles'
$article_facilities = [
(int) 0 => object(App\Model\Entity\Facility) {
'id' => (int) 37,
'title' => '駐輪場',
'display_order' => null,
'url' => '/search/AFA37',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
},
(int) 1 => object(App\Model\Entity\Facility) {
'id' => (int) 13,
'title' => 'エレベーター',
'display_order' => null,
'url' => '/search/AFA13',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
},
(int) 2 => object(App\Model\Entity\Facility) {
'id' => (int) 33,
'title' => '宅配ボックス',
'display_order' => null,
'url' => '/search/AFA33',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
},
(int) 3 => object(App\Model\Entity\Facility) {
'id' => (int) 35,
'title' => '専用ゴミ置き場あり',
'display_order' => null,
'url' => '/search/AFA35',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
}
]
$room_facilities = [
(int) 0 => object(App\Model\Entity\Facility) {
'id' => (int) 282,
'title' => '床暖房',
'display_order' => null,
'url' => '/search/RFA282',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
},
(int) 1 => object(App\Model\Entity\Facility) {
'id' => (int) 209,
'title' => 'シャワー',
'display_order' => null,
'url' => '/search/RFA209',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
},
(int) 2 => object(App\Model\Entity\Facility) {
'id' => (int) 210,
'title' => '追い焚き',
'display_order' => null,
'url' => '/search/RFA210',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
},
(int) 3 => object(App\Model\Entity\Facility) {
'id' => (int) 231,
'title' => '洗面所独立',
'display_order' => null,
'url' => '/search/RFA231',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
},
(int) 4 => object(App\Model\Entity\Facility) {
'id' => (int) 108,
'title' => 'オートロック',
'display_order' => null,
'url' => '/search/RFA108',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
},
(int) 5 => object(App\Model\Entity\Facility) {
'id' => (int) 136,
'title' => 'フローリング',
'display_order' => null,
'url' => '/search/RFA136',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
},
(int) 6 => object(App\Model\Entity\Facility) {
'id' => (int) 283,
'title' => '24H換気システム',
'display_order' => null,
'url' => '/search/RFA283',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
},
(int) 7 => object(App\Model\Entity\Facility) {
'id' => (int) 206,
'title' => 'バス・トイレ別室',
'display_order' => null,
'url' => '/search/RFA206',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
},
(int) 8 => object(App\Model\Entity\Facility) {
'id' => (int) 236,
'title' => '洗濯機置き場(室内)',
'display_order' => null,
'url' => '/search/RFA236',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
},
(int) 9 => object(App\Model\Entity\Facility) {
'id' => (int) 96,
'title' => 'インターホン(TVモニター付)',
'display_order' => null,
'url' => '/search/RFA96',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
}
]
$article_features = [
(int) 0 => object(App\Model\Entity\Facility) {
'id' => (int) 14,
'title' => '閑静な住宅街',
'display_order' => null,
'url' => '/search/AFE14',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
},
(int) 1 => object(App\Model\Entity\Facility) {
'id' => (int) 30002,
'title' => 'おすすめ',
'display_order' => null,
'url' => '/search/AFE30002',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
}
]
$room_features = [
(int) 0 => object(App\Model\Entity\Facility) {
'id' => (int) 61,
'title' => '楽器可',
'display_order' => null,
'url' => '/search/RFE61',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
},
(int) 1 => object(App\Model\Entity\Facility) {
'id' => (int) 62,
'title' => '事務所可',
'display_order' => null,
'url' => '/search/RFE62',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
},
(int) 2 => object(App\Model\Entity\Facility) {
'id' => (int) 65,
'title' => '分譲賃貸',
'display_order' => null,
'url' => '/search/RFE65',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
},
(int) 3 => object(App\Model\Entity\Facility) {
'id' => (int) 80,
'title' => 'ペット可',
'display_order' => null,
'url' => '/search/RFE80',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
},
(int) 4 => object(App\Model\Entity\Facility) {
'id' => (int) 344,
'title' => '高級賃貸',
'display_order' => null,
'url' => '/search/RFE344',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
},
(int) 5 => object(App\Model\Entity\Facility) {
'id' => (int) 91,
'title' => '生活保護者対応',
'display_order' => null,
'url' => '/search/RFE91',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
},
(int) 6 => object(App\Model\Entity\Facility) {
'id' => (int) 127,
'title' => 'デザイナーズ',
'display_order' => null,
'url' => '/search/RFE127',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'facilities'
}
]
$station_list_sort = [
(int) 0 => [
'id' => (int) 23,
'title' => '原',
'count' => (int) 5
],
(int) 1 => [
'id' => (int) 668,
'title' => '植田',
'count' => (int) 5
],
(int) 2 => [
'id' => (int) 1048,
'title' => '塩釜口',
'count' => (int) 5
],
(int) 3 => [
'id' => (int) 678,
'title' => 'はなみずき通',
'count' => (int) 4
],
(int) 4 => [
'id' => (int) 969,
'title' => '小幡',
'count' => (int) 4
],
(int) 5 => [
'id' => (int) 970,
'title' => '喜多山',
'count' => (int) 4
],
(int) 6 => [
'id' => (int) 971,
'title' => '大森・金城学院前',
'count' => (int) 4
],
(int) 7 => [
'id' => (int) 679,
'title' => '杁ヶ池公園',
'count' => (int) 3
],
(int) 8 => [
'id' => (int) 680,
'title' => '長久手古戦場',
'count' => (int) 3
],
(int) 9 => [
'id' => (int) 901,
'title' => '中小田井',
'count' => (int) 2
]
]
$area_list_sort = [
(int) 0 => [
'id' => '22016',
'title' => '天白区',
'count' => (int) 5
],
(int) 1 => [
'id' => '22013',
'title' => '守山区',
'count' => (int) 4
],
(int) 2 => [
'id' => '22004',
'title' => '西区',
'count' => (int) 3
],
(int) 3 => [
'id' => '22007',
'title' => '昭和区',
'count' => (int) 2
],
(int) 4 => [
'id' => '22002',
'title' => '東区',
'count' => (int) 1
],
(int) 5 => [
'id' => '22005',
'title' => '中村区',
'count' => (int) 1
],
(int) 6 => [
'id' => '22008',
'title' => '瑞穂区',
'count' => (int) 1
],
(int) 7 => [
'id' => '22010',
'title' => '中川区',
'count' => (int) 1
],
(int) 8 => [
'id' => '22012',
'title' => '南区',
'count' => (int) 1
]
]
$station_list = [
(int) 48 => [
'id' => (int) 48,
'title' => '名古屋市営地下鉄東山線',
'count' => (int) 5,
'station' => [
(int) 983 => [
[maximum depth reached]
],
(int) 460 => [
[maximum depth reached]
],
(int) 988 => [
[maximum depth reached]
],
(int) 992 => [
[maximum depth reached]
],
(int) 993 => [
[maximum depth reached]
],
(int) 997 => [
[maximum depth reached]
],
(int) 998 => [
[maximum depth reached]
],
(int) 677 => [
[maximum depth reached]
]
]
],
(int) 49 => [
'id' => (int) 49,
'title' => '名古屋市営地下鉄名城線',
'count' => (int) 2,
'station' => [
(int) 1007 => [
[maximum depth reached]
],
(int) 992 => [
[maximum depth reached]
],
(int) 998 => [
[maximum depth reached]
]
]
],
(int) 50 => [
'id' => (int) 50,
'title' => '名古屋市営地下鉄鶴舞線',
'count' => (int) 8,
'station' => [
(int) 902 => [
[maximum depth reached]
],
(int) 1034 => [
[maximum depth reached]
],
(int) 1035 => [
[maximum depth reached]
],
(int) 1043 => [
[maximum depth reached]
],
(int) 1044 => [
[maximum depth reached]
],
(int) 1048 => [
[maximum depth reached]
],
(int) 668 => [
[maximum depth reached]
],
(int) 23 => [
[maximum depth reached]
]
]
],
(int) 51 => [
'id' => (int) 51,
'title' => '名古屋市営地下鉄桜通線',
'count' => (int) 3,
'station' => [
(int) 1058 => [
[maximum depth reached]
],
(int) 1044 => [
[maximum depth reached]
],
(int) 1063 => [
[maximum depth reached]
],
(int) 1064 => [
[maximum depth reached]
]
]
],
(int) 29 => [
'id' => (int) 29,
'title' => '名鉄名古屋本線',
'count' => (int) 1,
'station' => [
(int) 722 => [
[maximum depth reached]
],
(int) 723 => [
[maximum depth reached]
]
]
],
(int) 35 => [
'id' => (int) 35,
'title' => '名鉄常滑線',
'count' => (int) 1,
'station' => [
(int) 811 => [
[maximum depth reached]
],
(int) 812 => [
[maximum depth reached]
],
(int) 813 => [
[maximum depth reached]
]
]
],
(int) 42 => [
'id' => (int) 42,
'title' => '名鉄犬山線',
'count' => (int) 3,
'station' => [
(int) 722 => [
[maximum depth reached]
],
(int) 723 => [
[maximum depth reached]
],
(int) 900 => [
[maximum depth reached]
],
(int) 901 => [
[maximum depth reached]
],
(int) 902 => [
[maximum depth reached]
]
]
],
(int) 46 => [
'id' => (int) 46,
'title' => '名鉄瀬戸線',
'count' => (int) 4,
'station' => [
(int) 969 => [
[maximum depth reached]
],
(int) 970 => [
[maximum depth reached]
],
(int) 971 => [
[maximum depth reached]
]
]
],
(int) 2 => [
'id' => (int) 2,
'title' => 'JR東海道本線',
'count' => (int) 0,
'station' => [
(int) 23 => [
[maximum depth reached]
]
]
],
(int) 14 => [
'id' => (int) 14,
'title' => 'JR関西本線',
'count' => (int) 0,
'station' => [
(int) 460 => [
[maximum depth reached]
]
]
],
(int) 20 => [
'id' => (int) 20,
'title' => 'あおなみ線',
'count' => (int) 1,
'station' => [
(int) 563 => [
[maximum depth reached]
]
]
],
(int) 27 => [
'id' => (int) 27,
'title' => '豊橋鉄道渥美線',
'count' => (int) 0,
'station' => [
(int) 668 => [
[maximum depth reached]
]
]
],
(int) 28 => [
'id' => (int) 28,
'title' => 'リニモ',
'count' => (int) 4,
'station' => [
(int) 677 => [
[maximum depth reached]
],
(int) 678 => [
[maximum depth reached]
],
(int) 679 => [
[maximum depth reached]
],
(int) 680 => [
[maximum depth reached]
]
]
]
]
$area_list = [
(int) 22 => [
'id' => (int) 22,
'title' => '名古屋市',
'subtitle' => '',
'city' => [
(int) 22002 => [
[maximum depth reached]
],
(int) 22004 => [
[maximum depth reached]
],
(int) 22005 => [
[maximum depth reached]
],
(int) 22007 => [
[maximum depth reached]
],
(int) 22008 => [
[maximum depth reached]
],
(int) 22010 => [
[maximum depth reached]
],
(int) 22012 => [
[maximum depth reached]
],
(int) 22013 => [
[maximum depth reached]
],
(int) 22016 => [
[maximum depth reached]
]
]
]
]
$history_c = (int) 0
$favorite_c = (int) 0
$random = object(Cake\ORM\ResultSet) {
'items' => [
(int) 0 => object(App\Model\Entity\Article) {},
(int) 1 => object(App\Model\Entity\Article) {},
(int) 2 => object(App\Model\Entity\Article) {},
(int) 3 => object(App\Model\Entity\Article) {},
(int) 4 => object(App\Model\Entity\Article) {},
(int) 5 => object(App\Model\Entity\Article) {},
(int) 6 => object(App\Model\Entity\Article) {},
(int) 7 => object(App\Model\Entity\Article) {},
(int) 8 => object(App\Model\Entity\Article) {},
(int) 9 => object(App\Model\Entity\Article) {},
(int) 10 => object(App\Model\Entity\Article) {},
(int) 11 => object(App\Model\Entity\Article) {},
(int) 12 => object(App\Model\Entity\Article) {},
(int) 13 => object(App\Model\Entity\Article) {}
]
}
$api = object(stdClass) {
default => object(stdClass) {}
google => object(stdClass) {}
}
$mobile_pc = falseinclude - APP/Template/Element/source_link.ctp, line 13 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1025 Cake\View\View::_render() - CORE/src/View/View.php, line 986 Cake\View\View::_renderElement() - CORE/src/View/View.php, line 1372 Cake\View\View::element() - CORE/src/View/View.php, line 513 include - APP/Template/Articles/index.ctp, line 236 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1025 Cake\View\View::_render() - CORE/src/View/View.php, line 986 Cake\View\View::render() - CORE/src/View/View.php, line 610 App\View\AppView::render() - APP/View/AppView.php, line 79 Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 623 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 125 Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 93 Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 78 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 59 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Notice (8): Undefined index: title [APP/Template/Element/source_link.ctp, line 14]× 賃貸 × 敷金・礼金0 |
||
サンローヤル
「サンローヤル」は、愛知県長久手市砂子620にある1995年築の
賃貸マンション
こちらの物件は、11月11日現在、空室が3室ございますので、ご内見をご希望の際は、お気軽にお問い合わせください。
この『サンローヤル』は【敷金ゼロ】【礼金ゼロ】でさらにお得に契約が可能!お引越しの初期費用がお得なイチオシ物件です!!
【部屋セレブに相談するメリット】
・初期費用をできるだけ安く!
・初期費用以外の面でも費用をできる限り抑えます!
・保証人のご相談も!
お部屋探しなら物件数・実績No.1の「部屋セレブ」へ
担当店舗:部屋セレブ覚王山店
TEL:052-757-5577
営業時間:10:00~18:30
定休日:年末年始 お盆休み
※地図上に表示される物件のアイコンは付近住所に所在することを表すものであり、実際の物件所在地とは異なる場合がございます。
サンローヤルの周辺施設
セブンイレブン長久手山野田店
216m
イオンモール長久手
854m
アピタ長久手店
866m
長久手市立南小学校
352m
長久手市立南中学校
418m
医療法人福友会福友病院
1289m
ドラッグスギヤマ長久手店
479m
愛知銀行長久手支店
520m
長久手市役所
1880m
長久手片平郵便局
1184m
杁ケ池公園
754m
長久手市立長湫南保育園
276m
-
更新 11/08
- サンローヤル
- 空室:3 部屋
- 面積:24.64m²
リニモ
『長久手古戦場駅』徒歩10分
間取り:1K
賃料:4.2万円
-
更新 11/09
- 桜山アネックス
- 空室:1 部屋
- 面積:31.03m²
名古屋市営地下鉄桜通線
『桜山駅』徒歩2分
間取り:1R
賃料:4.6万円
-
更新 11/08
- AKKNO1ビル
- 空室:1 部屋
- 面積:19.80m²
名古屋市営地下鉄鶴舞線
『庄内通駅』徒歩13分
間取り:1K
賃料:3.7万円
-
更新 11/09
- ベルメゾン中川Ⅱ
- 空室:1 部屋
- 面積:17.00m²
名古屋市営地下鉄鶴舞線
『荒畑駅』徒歩8分
間取り:1R
賃料:3.8万円
-
更新 11/09
- マーベラス柴田 A棟
- 空室:1 部屋
- 面積:24.92m²
名鉄常滑線
『柴田駅』徒歩4分
間取り:1K
賃料:4.6万円
-
更新 11/08
- イトーマンション
- 空室:1 部屋
- 面積:26.00m²
名古屋市営地下鉄東山線
『高畑駅』徒歩1分
間取り:1DK
賃料:4.1万円
-
更新 11/08
- シャトレ上小田井
- 空室:1 部屋
- 面積:24.90m²
名鉄犬山線
『中小田井駅』徒歩7分
間取り:1K
賃料:4.7万円
-
更新 11/09
- アメニティ植田
- 空室:5 部屋
- 面積:18.00m²
名古屋市営地下鉄鶴舞線
『塩釜口駅』徒歩14分
間取り:1K
賃料:2.5万円
-
更新 11/09
- SuccessⅢ
- 空室:1 部屋
- 面積:22.76m²
名鉄犬山線
間取り:1R
賃料:5.9万円
-
更新 11/09
- サンハイツ喜多山
- 空室:4 部屋
- 面積:19.44m²
名鉄瀬戸線
『喜多山駅』徒歩6分
間取り:1K
賃料:3.0万円~3.2万円
-
更新 11/09
- ビラ三秀神村
- 空室:1 部屋
- 面積:16.56m²
名古屋市営地下鉄名城線
間取り:1R
賃料:2.9万円
部屋セレブ覚王山店
名古屋市千種区覚王山通9丁目18
営業時間:10:00~18:30
定休日:年末年始 お盆休み
-
更新 11/09
- ベルメゾン中川Ⅱ
- 空室:1 部屋
- 面積:17.00m²
名古屋市営地下鉄鶴舞線
『荒畑駅』徒歩8分
間取り:1R
賃料:3.8万円
-
更新 11/08
- SuccessⅤ
- 空室:1 部屋
- 面積:29.75m²
名鉄犬山線
『中小田井駅』徒歩10分
間取り:1SK
賃料:5.8万円
-
更新 11/09
- マーベラス柴田 A棟
- 空室:1 部屋
- 面積:24.92m²
名鉄常滑線
『柴田駅』徒歩4分
間取り:1K
賃料:4.6万円
-
更新 11/09
- アメニティ植田
- 空室:5 部屋
- 面積:18.00m²
名古屋市営地下鉄鶴舞線
『塩釜口駅』徒歩14分
間取り:1K
賃料:2.5万円
-
更新 11/09
- 桜山アネックス
- 空室:1 部屋
- 面積:31.03m²
名古屋市営地下鉄桜通線
『桜山駅』徒歩2分
間取り:1R
賃料:4.6万円
担当スタッフ
担当店舗の部屋セレブ覚王山店です。
サンローヤルは、最寄り駅の「長久手古戦場駅」から徒歩10分にある、初期費用をできる限り抑えたい方向けの賃貸マンションです。
ただいま空室が3室ございます。
この物件には、バス・トイレ別室、エアコン(1台)の設備があります。
ただいま 敷金ゼロ もしくは 礼金ゼロ の空室がありますので、引っ越し費用を節約できます。
内見や掲載されていない情報等については、お気軽に”部屋セレブ覚王山店”までご連絡ください!