=now() and ST>0 ".$area["AREA_SQL"]." order by Price")); $sql_rent_house = @mysql_query(cUE("select * from data where (Type2='貸家') and K_Limit>=now() and ST>0 ".$area["AREA_SQL"]." order by Price")); //1x $sql[1] = @mysql_query(cUE("select * from data where (Mado like '1%' or Mado like '１%') and (Type2='貸アパート' or Type2='貸マンション') and K_Limit>=now() and ST>0 ".$area["AREA_SQL"]." order by Up desc")); //2x $sql[2] = @mysql_query(cUE("select * from data where (Mado like '2%' or Mado like '２%') and (Type2='貸アパート' or Type2='貸マンション') and K_Limit>=now() and ST>0 ".$area["AREA_SQL"]." order by Up desc")); //3x $sql[3] = @mysql_query(cUE("select * from data where (Mado like '3%' or Mado like '３%') and (Type2='貸アパート' or Type2='貸マンション') and K_Limit>=now() and ST>0 ".$area["AREA_SQL"]." order by Up desc")); //他 $sql[4] = @mysql_query(cUE("select * from data where (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 ".$area["AREA_SQL"]." order by Up desc")); //1x $sql2[1] = @mysql_query(cUE("select * from data where (Mado like '1%' or Mado like '１%') and (Type2='貸家') and K_Limit>=now() and ST>0 ".$area["AREA_SQL"]." order by Up desc")); //2x $sql2[2] = @mysql_query(cUE("select * from data where (Mado like '2%' or Mado like '２%') and (Type2='貸家') and K_Limit>=now() and ST>0 ".$area["AREA_SQL"]." order by Up desc")); //3x $sql2[3] = @mysql_query(cUE("select * from data where (Mado like '3%' or Mado like '３%') and (Type2='貸家') and K_Limit>=now() and ST>0 ".$area["AREA_SQL"]." order by Up desc")); //他 $sql2[4] = @mysql_query(cUE("select * from data where (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 ".$area["AREA_SQL"]." order by Up desc")); $sql_rent_ten = @mysql_query(cUE("select * from data where (Type2='テナント') and K_Limit>=now() and ST>0 ".$area["AREA_SQL"]." order by Price")); ?> 賃貸物件情報 - <?php echo ($area["NAME"]);?>｜ランドマーク不動産 | 宮城県柴田郡、大河原町、柴田町、村田町、白石市、角田市、亘理町、蔵王町の不動産情報満載!

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

賃貸物件・全地域

営業エリアのご案内

市町村名からご希望の地域を検索することが出来ます。

エリアマップ " alt="蔵王町" /> " alt="村田町" /> " alt="大河原町" /> " alt="川崎町" /> " alt="白石市" /> " alt="柴田町" /> " alt="亘理町" /> " alt="岩沼市" /> " alt="角田市" />

アパート・マンション

$sql_rent_apmn){ switch($key){ case "1": if(@mysql_num_rows($sql_rent_apmn)) echo "
1R/1K/1DK/1LDK
    "; break; case "2": if(@mysql_num_rows($sql_rent_apmn)) echo "
    2K/2DK/2LDK
      "; break; case "3": if(@mysql_num_rows($sql_rent_apmn)) echo "
      3K/3DK/3LDK
        "; break; case "4": if(@mysql_num_rows($sql_rent_apmn)) echo "
        それ以上
          "; break; } while($row=@mysql_fetch_array($sql_rent_apmn)){ 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"]).'

            '.getSetubiICON($row['No']).'
          • '; } echo "
        "; } ?>

借家

    $sql_rent_house){ switch($key){ case "1": if(@mysql_num_rows($sql_rent_house)) echo "
    1R/1K/1DK/1LDK
      "; break; case "2": if(@mysql_num_rows($sql_rent_house)) echo "
      2K/2DK/2LDK
        "; break; case "3": if(@mysql_num_rows($sql_rent_house)) echo "
        3K/3DK/3LDK
          "; break; case "4": if(@mysql_num_rows($sql_rent_house)) echo "
          それ以上
            "; break; } while($row=@mysql_fetch_array($sql_rent_house)){ 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"]).'

              '.getSetubiICON($row['No']).'
            • '; } 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["LDK_Mado"]).'

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

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

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

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

      '.getSetubiICON($row['No']).'
    • '; } ?>

駐車場

  • 詳細

    柴田郡大河原町金ヶ瀬字土手下22-3

    月額3,000円

  • 詳細

    柴田郡村田町大字沼辺字舘23−3

    月額2,000円

  • 詳細

    柴田郡大河原町大谷字町向114-1

    月額4,500円

  • 詳細

    柴田郡大河原町字新桜町2-6

    月額3,000円

  • 詳細

    柴田郡大河原町中島町4-23

    月額2,000円

  • 詳細

    柴田郡村田町大字沼辺字新小谷地7-7

    月額2,500円

  • 詳細

    柴田郡大河原町字荒町66-17

    月額3,000円

  • 詳細

    柴田郡大河原町字西町63

    月額3,000円

  • 詳細

    柴田郡大河原町字町106

    月額3,000円

ランドマーク不動産株式会社

tel. 0224-52-0466

宮城県柴田郡大河原町字西桜町2-1
ランドマークビル１Ｆ
営業時間：平日 AM9:00～PM5:30
土日祝 AM9:00～PM5:00

0224-52-0466

お問い合わせ