<?php
include("badmin/settei.php");

//GETデータ読み込み
$empty = $GET = array();
//foreach ($HTTP_GET_VARS as $varname => $varvalue) {
foreach ($empty as $varname => $varvalue) {
$$varname=$varvalue;
}

//POSTデータ読み込み
$empty = $POST = array();
//foreach ($HTTP_POST_VARS as $varname => $varvalue) {
foreach ($empty as $varname => $varvalue) {
$$varname=$varvalue;
}

//検索
$sql="select *,seibu_bukken.id as id from seibu_bukken,m_area_middle where m_area_middle.id=seibu_bukken.area_m_id and type='1' and jyotai='成約済'";

//エリア
if($area1!="" or $area2!="" or $area3!="" or $area4!="" or $area5!="" or $area6!="" or $area7!="" or $area8!="" or $area9!="" or $area10!="" or $area11!=""){

$sql.=" and (";

if($area1!=""){ $mtitle=$area1; $sql2.="area_m_id='$area1'"; $sql.=$sql2; }

if($sql2!="" and $area2!=""){ $sql2=" or "; $sql.=$sql2; }
if($area2!=""){ $mtitle=$area2; $sql2="area_m_id='$area2'"; $sql.=$sql2; }

if($sql2!="" and $area3!=""){ $sql2=" or "; $sql.=$sql2; }
if($area3!=""){ $mtitle=$area3; $sql2="area_m_id='$area3'"; $sql.=$sql2; }

if($sql2!="" and $area4!=""){ $sql2=" or "; $sql.=$sql2; }
if($area4!=""){ $mtitle=$area4; $sql2="area_m_id='$area4'"; $sql.=$sql2; }

if($sql2!="" and $area5!=""){ $sql2=" or "; $sql.=$sql2; }
if($area5!=""){ $mtitle=$area5; $sql2="area_m_id='$area5'"; $sql.=$sql2; }

if($sql2!="" and $area6!=""){ $sql2=" or "; $sql.=$sql2; }
if($area6!=""){ $mtitle=$area6; $sql2="area_m_id='$area6'"; $sql.=$sql2; }

if($sql2!="" and $area7!=""){ $sql2=" or "; $sql.=$sql2; }
if($area7!=""){ $mtitle=$area7; $sql2="area_m_id='$area7'"; $sql.=$sql2; }

if($sql2!="" and $area8!=""){ $sql2=" or "; $sql.=$sql2; }
if($area8!=""){ $mtitle=$area8; $sql2="area_m_id='35' or area_m_id='71' or area_m_id='72' or area_m_id='81' or area_m_id='82' or area_m_id='83' or area_m_id='84' or area_m_id='85' or area_m_id='86' or area_m_id='71' or area_m_id='72' or area_m_id='110' or area_m_id='111' or area_m_id='112' or area_m_id='113' or area_m_id='114' or area_m_id='115' or area_m_id='116'"; $sql.=$sql2; }

if($sql2!="" and $area9!=""){ $sql2=" or "; $sql.=$sql2; }
if($area9!=""){ $mtitle=$area9; $sql2="area_m_id='38' or area_m_id='39' or area_m_id='40' or area_m_id='41' or area_m_id='42' or area_m_id='43' or area_m_id='44' or area_m_id='33' or area_m_id='47' or area_m_id='36' or area_m_id='117' or area_m_id='125' or area_m_id='101' or area_m_id='102' or area_m_id='103' or area_m_id='104' or area_m_id='45' or area_m_id='46' or area_m_id='48' or area_m_id='49' or area_m_id='50' or area_m_id='51' or area_m_id='52' or area_m_id='92' or area_m_id='93' or area_m_id='94' or area_m_id='95' or area_m_id='96' or area_m_id='97' or area_m_id='98' or area_m_id='99' or area_m_id='100' or area_m_id='105' or area_m_id='106' or area_m_id='107' or area_m_id='108' or area_m_id='109'"; $sql.=$sql2; }

if($sql2!="" and $area10!=""){ $sql2=" or "; $sql.=$sql2; }
if($area10!=""){ $mtitle=$area10; $sql2="area_m_id='34' or area_m_id='31' or area_m_id='37' or area_m_id='32' or area_m_id='30' or area_m_id='29' or area_m_id='73' or area_m_id='74' or area_m_id='75' or area_m_id='20' or area_m_id='76' or area_m_id='119' or area_m_id='16' or area_m_id='15' or area_m_id='24' or area_m_id='78' or area_m_id='79' or area_m_id='80' or area_m_id='81' or area_m_id='82' or area_m_id='83' or area_m_id='84' or area_m_id='85' or area_m_id='86' or area_m_id='87' or area_m_id='88' or area_m_id='89' or area_m_id='90' or area_m_id='91'"; $sql.=$sql2; }

if($sql2!="" and $area11!=""){ $sql2=" or "; $sql.=$sql2; }
if($area11!=""){ $mtitle=$area11; $sql2="area_m_id='1' or area_m_id='2' or area_m_id='3' or area_m_id='4' or area_m_id='5' or area_m_id='6' or area_m_id='7' or area_m_id='121' or area_m_id='18' or area_m_id='19' or area_m_id='17' or area_m_id='21' or area_m_id='22' or area_m_id='28' or area_m_id='53' or area_m_id='54' or area_m_id='55' or area_m_id='56' or area_m_id='57' or area_m_id='58' or area_m_id='59' or area_m_id='60' or area_m_id='61' or area_m_id='62' or area_m_id='63' or area_m_id='64' or area_m_id='77'"; $sql.=$sql2; }

$sql.=")";
}

//マンション名もしくは町名
if($kensakuname!=""){
	$sql.=" and (meisyou like '%".$kensakuname."%' or addr like '%".$kensakuname."%')";
}

//通常物件一覧からのリンク
if($_GET['bids']!=""){

    $sql="select *,seibu_bukken.id as id from seibu_bukken,m_area_middle where m_area_middle.id=seibu_bukken.area_m_id and type='1' and jyotai='成約済'";
	$sql.=" and (";
    
    for($i=0;$i<sizeof($_GET[bids]);$i++){
    	$sql.="seibu_bukken.id=".$_GET[bids][$i];
        if($_GET[bids][($i+1)]!=""){ $sql.=" or "; }
    }
    
    $sql.=")";
    
}

$sql2=$sql."group by meisyou order by kousinbi";
$db = mysqli_connect("localhost:3306", "w8470511115915_seibu-r-com00001_u" ,"tU70wu3^1");
$result=mysqli_query($db, $sql2);
$ken=mysqli_num_rows($result);

//ページ設定
$page_cnt=(int)($ken/20);
$ken_su=($ken/20);
if(!is_int($ken_su)){ $page_cnt=$page_cnt+1; }
if($page==""){ $page=0; }
$hyouji=($page*20);

//20件未満の場合
if($ken<20){ $kazu=$ken; }else{ $kazu=($page*20)+20; }
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ja" lang="ja" dir="ltr">
<head>
	<meta http-equiv="Content-Language" content="ja" />
	<meta http-equiv="Content-Type" content="text/html; charset=EUC-JP" />
	<title>福岡の中古マンション一覧｜西部リゾート株式会社</title>
	<meta name="Description" content="福岡県内の中古マンションが販売に出たら、お知らせするサービスです。" />
	<meta name="Keywords" content="中古マンション,福岡,リクエスト,探している" />
	<!-- for legacy browser -->
	<link rel="stylesheet" type="text/css" href="cssjs/legacy.css" />
	<!-- for modern browser -->
	<link rel="stylesheet" type="text/css" href="cssjs/modern.css" media="screen,print" />
	<link href="cssjs/master.css" rel="stylesheet" type="text/css" />
	<link rel="stylesheet" type="text/css" href="cssjs/bukken.css" media="screen,print" />
	<!-- load JavaScript -->
	<script type="text/javascript" src="cssjs/common.js"></script>
	<script type="text/javascript" src="cssjs/smooth.pack.js"></script>
    <script>
	function formSub(a){
		document.form.page.value=a;
		document.form.action='pinlist.html';
		document.form.submit();
		return true;
	}
	</script>
</head>

<body>

	<!-- anchor pagetop/ -->
	<a name="pagetop" id="pagetop">ページの先頭です</a>
	<!-- /anchor pagetop -->
	

	  <div id="headding">
	    <div id="head_box">
	      <h1>西部リゾートは、福岡の中古マンション、中古一戸建てを中心に毎週オープンハウスを開催しています。</h1>
		   <div id="top_tel"><img src="img/common/top_tel.png" alt="お電話でのお問い合わせは：092-473-6710" width="218" height="108" border="0" usemap="#Map" />
<map name="Map" id="Map"><area shape="rect" coords="7,68,214,99" href="inquiry.html" />
</map></div>
        </div>
	   
</div>
	  <div id="container">
	<div id="headSec"><!--headSec-->
	    <h2><a href="index.html"><img src="img/common/logo.gif" alt="西部リゾート株式会社" width="287" height="48" border="0" /></a></h2>
		<p><a href="index.html"><img src="img/common/home_link.png" alt="ホーム" width="83" height="36" border="0" class="imgover" /></a></p>
	    
	  
	  <!--headSec END--></div>
	  
	  	<div id="gNavi">
	  	  <ul class="clearfix">
	  	  <li><a href="http://www.seibu-r.com/bukken/list1.html"><img src="img/common/g01.png" alt="売買物件情報" width="119" height="56" border="0" class="imgover" /></a></li>
		  <li><a href="com.html"><img src="img/common/g02.png" alt="西部リゾートについて" width="165" height="56" border="0" class="imgover" /></a></li>
	      <li><a href="taisetu.html"><img src="img/common/g03.png" alt="私たちが大切にしていること" width="207" height="56" border="0" class="imgover" /></a></li>
	      <li><a href="open.html"><img src="img/common/g04.png" alt="オープンハウスに行こう！" width="122" height="56" border="0" class="imgover" /></a></li>
	      <li><a href="column.html"><img src="img/common/g05.png" alt="不動産コラム" width="119" height="56" border="0" class="imgover" /></a></li>
	      <li><a href="tisiki.html"><img src="img/common/g06.png" alt="不動産の知識" width="121" height="56" border="0" class="imgover" /></a></li>
	      </ul>
  	    </div>
  
	<div id="bodySec" class="clearfix"><!--bodySec--><!--beta END-->
	  
      <div class="m-t2 m-b2"><img src="img/pin/listm1.gif" align="absbottom" /> ほしいマンションの販売活動等が確認され次第お知らせ致します。</div>
      <div><img src="img/pin/pin2.gif" /></div>
      <div class="pinback">
      	
        <table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><div class="m1">福岡の中古マンション一覧(該当<? echo $ken; ?>件)</div></td>
    <td width="25%" align="right"><a href="pin.html"><img src="img/pin/kensakumodoru.png" width="172" height="28" class="imgover" /></a></td>
  </tr>
</table>
        
        
<form name="form" method="POST" action="pinlist.html">
<input type="hidden" name="page">
<input type="hidden" name="kensakuname" value="<? echo $kensakuname; ?>" />
<input type="hidden" name="area1" value="<? echo $area1; ?>" />
<input type="hidden" name="area2" value="<? echo $area2; ?>" />
<input type="hidden" name="area3" value="<? echo $area3; ?>" />
<input type="hidden" name="area4" value="<? echo $area4; ?>" />
<input type="hidden" name="area5" value="<? echo $area5; ?>" />
<input type="hidden" name="area6" value="<? echo $area6; ?>" />
<input type="hidden" name="area7" value="<? echo $area7; ?>" />
<input type="hidden" name="area8" value="<? echo $area8; ?>" />
<input type="hidden" name="area9" value="<? echo $area9; ?>" />
<input type="hidden" name="area10" value="<? echo $area10; ?>" />
<input type="hidden" name="area11" value="<? echo $area11; ?>" />


  <table width="100%" border="0" cellspacing="0" cellpadding="0" class="m-t2 tbl m-b2">
  <tr>
    <th width="90" height="50" align="center" valign="middle"><center>写　真</center></th>
    <th width="220" valign="middle">マンション名<br />
      所在地</th>
    <th width="200" valign="middle">交通<br />
      学校区</th>
    <th width="245" valign="middle">構造<br />
      築年数</th>
    <th width="50" align="center" valign="middle"><center>詳細</center></th>
  </tr>
  <?
  $sql.=" group by meisyou limit $hyouji,20";
  $db = mysqli_connect("localhost:3306", "w8470511115915_seibu-r-com00001_u" ,"tU70wu3^1");
  $result=mysqli_query($db, $sql);
  //while($data=mysqli_fetch_array($result, MYSQLI_NUM)){
while ($data = mysqli_fetch_array($result, MYSQLI_NUM)) {
    var_dump($data);  // デバッグ用に出力
    // ここで $data を処理
}
  ?>
  <tr>
    <td align="center">
    <a href="bukken/detail<? echo $data[id]; ?>.html" target="_blank"><?
    $sql2="select * from seibu_picture where bukken_id='$data[uid]' and p_type='写真' order by date desc limit 0,1";
    $result2=mysql_query($sql2);
    $data2=mysql_fetch_array($result2);
    
    if($data2[id]!=""){
    echo "<img src=badmin/".$data2[pic]."_small.jpg>";
    }else{
    echo "<img src=img/bukken/noimage.gif>";
    }
    ?>
    </a>
    </td>
    <td><a href="bukken/detail<? echo $data[id]; ?>.html" target="_blank"><b><? echo ereg_replace("\n","<br>",$data[meisyou]); ?></b></a>
    <?
    $tatesql="select id,meisyou,jyotai from seibu_bukken where meisyou='$data[meisyou]' and jyotai!='非表示' order by id desc";
    $tateresult=mysql_query($tatesql);
    $tatedata=mysql_fetch_array($tateresult);
    if($tatedata[jyotai]!="成約済"){
    echo "<img src='img/pin/hanbai.png' align='absmiddle'>";
    }
    ?>
    <br />
	<? if($data[area_name]!="その他"){ echo $data[area_m_name].$data[addr]; }else{ echo $data[addr]; } ?>
    </td>
    <td>
    <?
    if($data[koutu1]!=""){
    echo $data[koutu1].$data[koutu2].$data[koutu3].$data[koutu4];
    }
    ?>
    <br />
    <?
    if($data[syougaku]!=""){
    echo $data[syougaku]."小学校";
    echo "、".$data[chugaku]."中学校";
    }
    ?>
    </td>
    <td>
    <? echo $data[kozo];
    if($data[kibo]!=""){ echo $data[kibo]."階建"; } ?>
    <br />
    <? echo $data[tiku_nengou]; echo $data[tiku_nen]."年".$data[tiku_tuki]."月"; ?>
    </td>
    <td align="center"><a href="bukken/detail<? echo $data[id]; ?>.html" target="_blank">詳細</a></td>
  </tr>
  <?
  //}
  ?>
  </table>
        
    <?
	if($kazu!=0){
	?>
	<div id="pageCount">
	  <ul>
		<?
		//パターン調べ
		if($page<10){ if(10<$page_cnt){ $max=10; }else{ $max=$page_cnt; } $min=1; }
		if(6<=$page){ $max=5+$page; if($page_cnt<$max){ $min=$page-($max-$page_cnt+4); $max=$page_cnt; }else{ $min=$page-4; } }
		
		//←
		if($page!=0){
		?>
		<li id="nextPage"><a href="javascript:formSub(<? echo ($page-1); ?>)">前のページへ</a></li>
	<?
		}
		
		//echo "Page ";
		for($i=$min;$i<=$max;$i++){
		if(($i-1)!=$page and -1<($i-1)){ echo "<li><a href=\"javascript:formSub(".($i-1).")\">".$i."</a></li>"; }
		elseif(-1<($i-1)){ echo $i." "; }
		}
		
		if($page_cnt!=$page+1){
		?>
		<li id="nextPage"><a href="javascript:formSub(<? echo ($page+1); ?>)">次のページへ</a></li>
	<?
		}
	?>
		  </ul>
	    </div>
	<?
	}
	?>
        
        
	</form>
      
      </div>
      <div><img src="img/pin/pin4.gif" /></div>


<!--bodySec END--></div>
  
	<div id="footSec" class="clearfix"><!--footSec-->
	  <div>
	    <ul>
	      <li><a href="index.html">HOME</a></li>
	      <li><a href="http://www.seibu-r.com/bukken/list1.html">売買物件情報</a></li><li><a href="com.html">西部リゾートについて</a></li>
	      <li><a href="taisetu.html">私たちが大切にしていること</a></li>
	      <li><a href="open.html">オープンハウスに行こう！</a></li>
	      <li><a href="column.html">不動産コラム</a></li>
	      <li><a href="tisiki.html">不動産の知識</a></li>
	      <li class="b_none"><a href="https://sv61.wadax.ne.jp/~seibu-r-com/inquiry.html">お問合せ</a></li>
        </ul>


<!-- seoparts --><div class="floatLeft" align="center" style="width:300px;height:30px; margin-top:10px;"><ul style="margin:0;padding:0;list-style:none;font-size:12px;width:100%;height:15px;overflow:hidden;line-height:100%;" id="seoparts"><li style="float:left;padding:0;"><a href="http://seoparts.com/"><img src="http://seoparts.com/u80.gif" width="80" height="15" border="0" alt="seo"></a></li></ul><script type="text/javascript" src="http://escape-u.seoparts.com/u.js?1/5/" charset="euc-jp"></script></div><!-- /seoparts --> 

      </div>
	  <p class="floatRight p-t15"><a href="#pagetop"><img src="img/common/pagetop.gif" alt="このページのトップへ戻る" width="123" height="26" class="imgover" /></a></p>
	  <!--footSec END--></div>
	  <!--container END--></div>
	  
	  <div id="footer_box" class="clearfix">
	    <div id="footer_com" class="clearfix">
	        <div class="floatLeft clearfix p-t2 p-b15" style="width: 640px;">
	          <p class="floatLeft"><img src="img/common/f_logo.gif" alt="西部リゾート株式会社" width="249" height="31" /></p>
	          <p class="floatRight" style="width: 370px;">宅地建物取引業者免許 福岡県知事(4)第13510号 <br />
	            〒812-0016 福岡市博多区博多駅南1-7-14</p>
          </div>
          <p class="floatRight p-t2"><img src="img/common/f_tel.gif" alt="お電話でのお問い合わせは：092-473-6710" width="166" height="40" /></p>
        </div>
	  <!--footer_box END--></div>
	
	  <div id="copy">
	    <p><img src="img/common/copyright.gif" alt="&lt;空&gt;" width="239" height="11" /></p>
      </div>


	  <script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
try {
var pageTracker = _gat._getTracker("UA-7728070-1");
pageTracker._trackPageview();
} catch(err) {}</script>
</body>
</html>