=now() and ST>0 order by Price")); $sql_sale = @mysql_query(cUE("select * from data where IC5=1 and (Type2='売地' or Type2='マンション' or Type2='一戸建て') and K_Limit>=now() and ST>0 order by Price")); //1x $sql[1] = @mysql_query(cUE("select * from data where IC5=1 and (Mado like '1%' or Mado like '１%') and (Type2='貸アパート' or Type2='貸マンション') and K_Limit>=now() and ST>0 $plz order by Up desc")); //2x $sql[2] = @mysql_query(cUE("select * from data where IC5=1 and (Mado like '2%' or Mado like '２%') and (Type2='貸アパート' or Type2='貸マンション') and K_Limit>=now() and ST>0 $plz order by Up desc")); //3x $sql[3] = @mysql_query(cUE("select * from data where IC5=1 and (Mado like '3%' or Mado like '３%') and (Type2='貸アパート' or Type2='貸マンション') and K_Limit>=now() and ST>0 $plz order by Up desc")); //他 $sql[4] = @mysql_query(cUE("select * from data where IC5=1 and (Mado not like '1%' and Mado not like '2%' and Mado not like '3%' and Mado not like '１%' and Mado not like '２%' and Mado not like '３%') and (Type2='貸アパート' or Type2='貸マンション') and K_Limit>=now() and ST>0 $plz order by Up desc")); //1x $sql[5] = @mysql_query(cUE("select * from data where IC5=1 and (Mado like '1%' or Mado like '１%') and (Type2='貸家') and K_Limit>=now() and ST>0 $plz order by Up desc")); //2x $sql[6] = @mysql_query(cUE("select * from data where IC5=1 and (Mado like '2%' or Mado like '２%') and (Type2='貸家') and K_Limit>=now() and ST>0 $plz order by Up desc")); //3x $sql[7] = @mysql_query(cUE("select * from data where IC5=1 and (Mado like '3%' or Mado like '３%') and (Type2='貸家') and K_Limit>=now() and ST>0 $plz order by Up desc")); //他 $sql[8] = @mysql_query(cUE("select * from data where IC5=1 and (Mado not like '1%' and Mado not like '2%' and Mado not like '3%' and Mado not like '１%' and Mado not like '２%' and Mado not like '３%') and (Type2='貸家') and K_Limit>=now() and ST>0 $plz order by Up desc")); ?> HOME｜ランドマーク不動産 | 宮城県柴田郡、大河原町、柴田町、村田町、白石市、角田市、亘理町、蔵王町の不動産情報満載!

宮城県柴田郡、大河原町、柴田町、村田町、白石市、角田市、亘理町、蔵王町の不動産情報満載

おすすめ物件

賃貸物件
$sql_rent){ switch($key){ case "1": if(@mysql_num_rows($sql_rent)) echo "
賃貸アパート・マンション：1R/1K/1DK/1LDK
    "; break; case "2": if(@mysql_num_rows($sql_rent)) echo "
    賃貸アパート・マンション：2K/2DK/2LDK
      "; break; case "3": if(@mysql_num_rows($sql_rent)) echo "
      賃貸アパート・マンション：3K/3DK/3LDK
        "; break; case "4": if(@mysql_num_rows($sql_rent)) echo "
        賃貸アパート・マンション：それ以上
          "; break; case "5": if(@mysql_num_rows($sql_rent)) echo "
          貸家：1R/1K/1DK/1LDK
            "; break; case "6": if(@mysql_num_rows($sql_rent)) echo "
            貸家：2K/2DK/2LDK
              "; break; case "7": if(@mysql_num_rows($sql_rent)) echo "
              貸家：3K/3DK/3LDK
                "; break; case "8": if(@mysql_num_rows($sql_rent)) echo "
                貸家：それ以上
                  "; break; } while($row=@mysql_fetch_array($sql_rent)){ echo '
                • 詳細
                    '.getICON(1,$row["IC1"]).' '.getICON(2,$row["IC2"]).' '.getICON(3,$row["IC3"]).' '.getICON(4,$row["IC4"]).' '.getICON(5,$row["IC5"]).' '.getICON(6,$row["IC6"]).' '.getICON(7,$row["IC7"]).' '.getICON(8,$row["IC8"]).' '.getICON(9,$row["IC9"]).' '.getICON(10,$row["IC10"]).' '.getICON(11,$row["IC11"]).' '.getICON(12,$row["IC12"]).' '.getICON(13,$row["IC13"]).' '.getICON(14,$row["IC14"]).' '.getICON(15,$row["IC15"]).' '.getICON(16,$row["IC16"]).'

                  '.cEU($row["Mado"]).'

                  '.cEU($row['Title1']).' '.cEU($row["Title2"]).'

                  '.cEU($row['Addr2']).'

                  '.@number_format($row['Price']).'円

                  '.cEU($row["NWhen"]).'

                  • '; } echo "
                "; } ?>
売買物件
  • 詳細
      '.getICON(1,$row["IC1"]).' '.getICON(2,$row["IC2"]).' '.getICON(3,$row["IC3"]).' '.getICON(4,$row["IC4"]).' '.getICON(5,$row["IC5"]).' '.getICON(6,$row["IC6"]).' '.getICON(7,$row["IC7"]).' '.getICON(8,$row["IC8"]).' '.getICON(9,$row["IC9"]).' '.getICON(10,$row["IC10"]).' '.getICON(11,$row["IC11"]).' '.getICON(12,$row["IC12"]).' '.getICON(13,$row["IC13"]).' '.getICON(14,$row["IC14"]).' '.getICON(15,$row["IC15"]).' '.getICON(16,$row["IC16"]).'

    '.cEU($row['Type2']).' '.cEU($row['Title1']).' '.cEU($row["Title2"]).'

    '.cEU($row['Addr2']).'

    '.@number_format(@round($row['Price']/10000)).'万円

    '.$info.'

    • '; } ?>

お知らせ

0224-52-0466

お問い合わせ