静岡県の藤枝、吉田、焼津、島田、大井川の土地、一戸建て、マンション等の不動産情報ならアイブロス不動産

トップ > 賃貸物件情報

藤枝市

select * from rental where (`view` = 1) and (`city` = "藤枝市") and ((`type` = 5) or (`type` = 6)) order by regdate desc

物件名	空き区画数	住所	賃料	敷金	礼金	詳細	資料
大東町駐車場	1	大東町	3,000円	-	-	詳細	資料

焼津市

select * from rental where (`view` = 1) and (`city` = "焼津市") and ((`type` = 5) or (`type` = 6)) order by regdate desc

島田市

select * from rental where (`view` = 1) and (`city` = "島田市") and ((`type` = 5) or (`type` = 6)) order by regdate desc

牧之原市

select * from rental where (`view` = 1) and (`city` = "牧之原市") and ((`type` = 5) or (`type` = 6)) order by regdate desc

御前崎市

select * from rental where (`view` = 1) and (`city` = "御前崎市") and ((`type` = 5) or (`type` = 6)) order by regdate desc

吉田町

select * from rental where (`view` = 1) and (`city` = "吉田町") and ((`type` = 5) or (`type` = 6)) order by regdate desc

その他

select * from rental where (`view` = 1) and (`city` = "その他") and ((`type` = 5) or (`type` = 6)) order by regdate desc