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

• トップページ
• 売買物件情報
• 賃貸物件情報
• 会社案内
• 分譲地情報
• facebook
• お問い合わせ

select * from rental where (`view` = 1) and (`city` = "藤枝市") and ((`type` = 1) or (`type` = 2)) order by regdate desc select * from rental where (`view` = 1) and (`city` = "焼津市") and ((`type` = 1) or (`type` = 2)) order by regdate desc select * from rental where (`view` = 1) and (`city` = "島田市") and ((`type` = 1) or (`type` = 2)) order by regdate desc select * from rental where (`view` = 1) and (`city` = "牧之原市") and ((`type` = 1) or (`type` = 2)) order by regdate desc select * from rental where (`view` = 1) and (`city` = "御前崎市") and ((`type` = 1) or (`type` = 2)) order by regdate desc select * from rental where (`view` = 1) and (`city` = "吉田町") and ((`type` = 1) or (`type` = 2)) order by regdate desc select * from rental where (`view` = 1) and (`city` = "その他") and ((`type` = 1) or (`type` = 2)) order by regdate desc