Warning: Undefined array key "eki" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 71

Warning: Undefined array key "ensen_id" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 72

Warning: Undefined array key "area_id" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 73

Warning: Undefined array key "shurui" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 74

Warning: Undefined array key "toho_f" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 75

Warning: Undefined array key "mon_row" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 76

Warning: Undefined array key "mon_high" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 77

Warning: Undefined array key "sort" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 78

Warning: Undefined array key "tikunen" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 79

Warning: Undefined array key "mado" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 80

Warning: Undefined array key "menseki" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 81

Warning: Undefined array key "cyukai" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 82

Warning: Undefined array key "pict_bt" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 83

Warning: Undefined array key "pict_ea" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 84

Warning: Undefined array key "pict_shuno" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 85

Warning: Undefined array key "pict_at" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 86

Warning: Undefined array key "pict_car" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 87

Warning: Undefined array key "pict_roft" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 88

Warning: Undefined array key "pict_fro" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 89

Warning: Undefined array key "pict_sen" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 90

Warning: Undefined array key "pict_gas" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 91

Warning: Undefined array key "pict_oi" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 92

Warning: Undefined array key "pict_nikai" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 93

Warning: Undefined array key "pict_toshi" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 94

Warning: Undefined array key "pict_pet" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 95

Warning: Undefined array key "pict_pano" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 96

Warning: Undefined array key "pict_catv" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 97

Warning: Undefined array key "pict_churin" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 98

Warning: Undefined array key "pict_sone" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 99

Warning: Undefined array key "pict_rone" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 100

Warning: Undefined array key "pict_gaikan" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 101

Warning: Undefined array key "joken_sort2_flgbox" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 102

Warning: Undefined array key "pg_counter" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 103

Warning: Undefined array key "sort_no" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 104

Warning: Undefined array key "joken_w1" in /home/yokohamakoyo/yokohamakoyo.xbiz.jp/public_html/search/rent_list.php on line 105

すまいを借りたい

TOP > すまいを借りたい > エリア検索

SELECT ycode as 家主コード, bcode as 物件コード , rno as 部屋番号 , badd1 as 住所1, badd2 as 住所2, badd3 as 住所3, lcode1 as 沿線, scode1 as 駅, toho1 as 徒歩, bus1 as バス, teiho1 as 停歩時間, rsuu as 部屋数, rmado as 間取り, rmen as 面積, rmone as 家賃, rkan as 管理費, rsiki_kbn as 敷金単位区分, rsiki as 敷金額, rrei_kbn as 礼金単位区分, rrei as 礼金額, rhskin_kbn as 保証金単位区分, rhskin as 保証金額, rtsuwari as 仲介手数料 FROM RMAST2 WHERE rmoku = 1 AND (rmone >= 0 AND rmone <= 99999999) AND (((badd2 like '%横浜市保土ヶ谷区%') and (badd3 like '%和田%')) or ((badd2 like '%横浜市保土ヶ谷区%') and (badd3 like '%星川%')) or ((badd2 like '%横浜市保土ヶ谷区%') and (badd3 like '%上星川%')) or ((badd2 like '%横浜市神奈川区%') and (badd3 like '%三ツ沢上町%'))) AND ((toho1 >= 0) and (toho1 <= 999)) AND (btiku1 >= 0) AND (rmen >= 0) AND ((btbetu >= 0) AND (aircon >= 0) AND (parking_kbn >= 0) AND (autolock >= 0) AND (woodenfloor >= 0) AND (room_laundryarea >= 0) AND (konrokbn >= 0) AND (oidaki >= 0) AND (rkai1 >= 0) AND (bgas >= 0) AND (storagespace >= 0) AND (loft >= 0) AND (pet >= 0) AND (gakki >= 0) AND (catv >= 0) AND (motorcycle >= 0) AND (bicycle >= 0) AND (rsiki_month >= 0) AND (rrei_month >= 0) AND (rtsuwari >= 0) AND (renovation_kbn >= 0)) ORDER BY (rmone)

物件一覧

0件該当しました

検索条件

[ 種目 ] 指定なし [ 賃料 ] 下限なし ～ 上限なし [ 徒歩 ] 指定なし [ 面積 ] 指定なし [ 築年 ] 指定なし [ 間取り ] [ その他 ] 横浜国大生向け物件

沿線/駅沿線で並び替え 駅(バス停)
から徒歩徒歩時間で並び替え		 賃料賃料で並び替え 共益費共益費で並び替え 敷金
保証金敷金で並び替え		 礼金礼金で並び替え 間取り間取りで並び替え 面積面積で並び替え 所在地所在地で並び替え 仲介手数料

賃料・共益費は小数点以下３位未満を切捨てしています。

  1. トップに戻る
  2. 先頭に戻る
  3. 検索条件に戻る
  4. 沿線検索
  5. エリア検索