<?
	session_cache_limiter('private, must-revalidate');
	include_once($_SERVER['DOCUMENT_ROOT']."/require.php");
	$smarty->assign("sitetop", $sitetop);
	$smarty->assign("main", $main);
	$bcode2 = $bcode[0];
	
	$smarty->assign("bcode2", $bcode2);
	
	$smarty->assign("list",$list);
	

	if($_REQUEST['k']){
		$bcode = "";
		if(strstr($_REQUEST['k'],'a')) $bcode = 1;
		if(strstr($_REQUEST['k'],'b')) $bcode = 2;
		if(strstr($_REQUEST['k'],'c')) $bcode = 3;
		if(strstr($_REQUEST['k'],'d')) $bcode = 1;
		if(strstr($_REQUEST['k'],'e')) $bcode = 2;
		if(strstr($_REQUEST['k'],'f')) $bcode = 3;
		if(strstr($_REQUEST['k'],'g')) $bcode = 14;
		if(strstr($_REQUEST['k'],'h')) $bcode = 13;
		if(strstr($_REQUEST['k'],'i')) $bcode = 12;
		if(strstr($_REQUEST['k'],'j')) $bcode = 15;
		if(strstr($_REQUEST['k'],'k')) $bcode = 11;
		if(strstr($_REQUEST['k'],'l')) $bcode = 16;
		header( "HTTP/1.1 301 Moved Permanently" ); 
		if($bcode <= 10){
			header("Location: /sell/list/${bcode}/");
		}else{
			header("Location: /rent/list/${bcode}/");
		}
	}
	
	
	$sql = "select*from tbl_bcode where bcode=\"".mysql_real_escape_string($bcode2)."\"";
	$res = mysql_query($sql);
	if(@mysql_num_rows($res)){
		$row = mysql_fetch_array($res);
		$smarty->assign("main_cd",$row['main_cd']);
	}
	
	//お気に入り・閲覧履歴
	include_once($_SERVER['DOCUMENT_ROOT']."/favorite.php");
	include_once($_SERVER['DOCUMENT_ROOT']."/history.php");
	
	if(!@$_SESSION['search']) $_SESSION['search'] = array();
	if(!@$_SESSION['search'][$bcode2]){
		$_SESSION['search'][$bcode2] = array();
		$_SESSION['search'][$bcode2]["scode_"] = array();
		$_SESSION['search'][$bcode2]["set_code_"] = array();
	}
	
	
	$ssql = "";
	$ssql2 = "";
	$ssql3 = "";
	$ssql4 = "";
	$pageroll_set = "";
	
	
	$btype = "";
	if(!($bcode2 >= 1 && $bcode2 <= 20)){
		$btype="search";
	}
	
	//セッション代入
	if($_REQUEST['search']){
		$_SESSION['search'][$bcode2]['scode_'] = $_REQUEST['scode_'];
		$_SESSION['search'][$bcode2]['matori_one'] = $_REQUEST['matori_one'];
		$_SESSION['search'][$bcode2]['matori_max'] = $_REQUEST['matori_max'];
		$_SESSION['search'][$bcode2]['matori_'] = $_REQUEST['matori_'];
		$_SESSION['search'][$bcode2]['kozo_cd'] = $_REQUEST['kozo_cd'];
		$_SESSION['search'][$bcode2]['set_code_'] = $_REQUEST['set_code_'];
		$_SESSION['search'][$bcode2]['city_name'] = $_REQUEST['city_name'];
		$_SESSION['search'][$bcode2]['chu_name'] = $_REQUEST['chu_name'];
		$_SESSION['search'][$bcode2]['sho_name'] = $_REQUEST['sho_name'];
		$_SESSION['search'][$bcode2]['kakaku_l'] = $_REQUEST['kakaku_l'];
		$_SESSION['search'][$bcode2]['kakaku_h'] = $_REQUEST['kakaku_h'];
		$_SESSION['search'][$bcode2]['rent_l'] = $_REQUEST['rent_l'];
		$_SESSION['search'][$bcode2]['rent_h'] = $_REQUEST['rent_h'];
		$_SESSION['search'][$bcode2]['reikin_off_flg'] = $_REQUEST['reikin_off_flg'];
		$_SESSION['search'][$bcode2]['shiki_off_flg'] = $_REQUEST['shiki_off_flg'];
		$_SESSION['search'][$bcode2]['l_area_l'] = $_REQUEST['l_area_l'];
		$_SESSION['search'][$bcode2]['l_area_h'] = $_REQUEST['l_area_h'];
		$_SESSION['search'][$bcode2]['l_tatemono_l'] = $_REQUEST['l_tatemono_l'];
		$_SESSION['search'][$bcode2]['l_tatemono_h'] = $_REQUEST['l_tatemono_h'];
		$_SESSION['search'][$bcode2]['period_h'] = $_REQUEST['period_h'];
		$_SESSION['search'][$bcode2]['kozo_cd'] = $_REQUEST['kozo_cd'];
		$_SESSION['search'][$bcode2]['page_disp'] = $_REQUEST['page_disp'];
		$_SESSION['search'][$bcode2]['sort_type'] = $_REQUEST['sort_type'];
		$_SESSION['search'][$bcode2]['sort_vector'] = $_REQUEST['sort_vector'];
		$_SESSION['search'][$bcode2]['list_type'] = $_REQUEST['list_type'];
		$_SESSION['search'][$bcode2]['area_'] = $_REQUEST['area_'];
		$_SESSION['search'][$bcode2]['word'] = $_REQUEST['word'];
		$_SESSION['search'][$bcode2]['min'] = $_REQUEST['min'];
		$_SESSION['search'][$bcode2]['max'] = $_REQUEST['max'];
		$_SESSION['search'][$bcode2]['tsubo_min'] = $_REQUEST['tsubo_min'];
		$_SESSION['search'][$bcode2]['tsubo_max'] = $_REQUEST['tsubo_max'];
		$_SESSION['search'][$bcode2]['jiscode'] = $_REQUEST['jiscode'];
		$_SESSION['search'][$bcode2]['istype'] = $_REQUEST['istype'];
		$_SESSION['search'][$bcode2]['bcodetype'] = $_REQUEST['bcodetype'];
	}
	if(!$_SESSION['search'][$bcode2]['sort_type'] && $list=="history"){
		$_SESSION['search'][$bcode2]['sort_type'] = "history";
	}
	if(!$_SESSION['search'][$bcode2]['sort_type'] && $list=="fav"){
		$_SESSION['search'][$bcode2]['sort_type'] = "fav";
	}
	if(!@$_SESSION['search'][$bcode2]['page_disp'])$_SESSION['search'][$bcode2]['page_disp']=30;
	if(!@$_SESSION['search'][$bcode2]['sort_type'])$_SESSION['search'][$bcode2]['sort_type']="kakaku_amt";
	if(!@$_SESSION['search'][$bcode2]['sort_vector'])$_SESSION['search'][$bcode2]['sort_vector']="asc";
	if(!@$_SESSION['search'][$bcode2]['list_type'])$_SESSION['search'][$bcode2]['list_type']="detail";
	if(!@$_SESSION['search'][$bcode2]['area_'])$_SESSION['search'][$bcode2]['area_']=array();
	
	if(@$kari_arr[3] && !$_REQUEST['search'] && !$list){
		//kari_arr3があれば、松本市ならばcity_area_cd、それ以外ならjiscodeが入っている
		$kari_arr[3] = str_replace("a","", $kari_arr[3]);
		$_SESSION['search'][$bcode2]['area_'][$kari_arr[3]] = 1;
	}
	
	if($list == "vendor" && $_REQUEST['vid']){
		$_SESSION['search'][$bcode2]['vid'] = $_REQUEST['vid'];
	}
	
	if($list=="amt" && $_REQUEST['city_area_cd']){
		$_SESSION['search'][$bcode2]['area_'][$_REQUEST['city_area_cd']] = 1;
	}
	
	
	//istypeがある
	if($_SESSION['search'][$bcode2]['istype'] && $_REQUEST['search']){
		if($_SESSION['search'][$bcode2]['istype']=="100tsubo"){
			$_SESSION['search'][$bcode2]['l_area_l'] = "";
			$_SESSION['search'][$bcode2]['l_area_h'] = "";
		}
		if($_SESSION['search'][$bcode2]['istype']=="1000yen"){
			$_SESSION['search'][$bcode2]['kakaku_h'] = 1000;
		}
		if($_SESSION['search'][$bcode2]['istype']=="pet"){
			$_SESSION['search'][$bcode2]['set_code_']['1221'] = 1;
		}
		if($_SESSION['search'][$bcode2]['istype']=="0shiki"){
			$_SESSION['search'][$bcode2]['reikin_off_flg'] = 1;
			$_SESSION['search'][$bcode2]['shiki_off_flg'] = 1;
		}
		if($_SESSION['search'][$bcode2]['istype']=="one"){
			$_SESSION['search'][$bcode2]['matori_one'] = 1;
			$_SESSION['search'][$bcode2]['matori_'][0] = 1;
		}
	}
	
	
	$disp = array();
	if(!$list || $list=="amt"){
		if($btype=="search" || ($bcode2 != 15 && $bcode2 != 16 && $bcode2 != 12)){
			$disp['scode'] = 1;
		}
		if($btype=="search" || ($bcode2 == 1 || $bcode2 == 2 || $bcode2 == 3 || $bcode2 == 11 || $bcode2 == 12)){
			$disp['tsugaku'] = 1;
		}
		if($list != "amt"){
			if(($btype=="search" && $main=="売買") || ($bcode2 == 1 || $bcode2 == 2 || $bcode2 == 3)){
				$disp['kakaku'] = 1;
			}
			if(($btype=="search" && $main=="賃貸") || ($bcode2 == 11 || $bcode2 == 12 || $bcode2 == 13 || $bcode2 == 14 || $bcode2 == 15 || $bcode2 == 16)){
				$disp['rent'] = 1;
			}
		}
		if($_SESSION['search'][$bcode2]['istype']=="0shiki" || ($btype=="search" && $main=="賃貸") || ($bcode2 == 11 || $bcode2 == 12 || $bcode2 == 13 || $bcode2 == 14)){
			if($main!="売買") $disp['reikin'] = 1;
		}
		if($btype=="search" || ($bcode2 == 1 || $bcode2 == 2 || $bcode2 == 3 || $bcode2 == 15)){
			$disp['tochi_m2'] = 1;
		}
		if($btype=="search" || ($bcode2 == 2 || $bcode2 == 13 || $bcode2 == 14)){
			$disp['tatemono_m2'] = 1;
		}
		if($btype=="search" || ($bcode2 == 2 || $bcode2 == 3 || $bcode2 == 11 || $bcode2 == 12 || $bcode2 == 13 || $bcode2 == 14)){
			$disp['year'] = 1;
		}
		if($btype=="search" || ($bcode2 == 2 || $bcode2 == 3 || $bcode2 == 11 || $bcode2 == 12 || $bcode2 == 13 || $bcode2 == 14)){
			$disp['kozo'] = 1;
		}
		if(!($type=="tochi" || $btype=="search" || $bcode2<=10 ||  $bcode2== "13" || $bcode2=="14" || $bcode2=="15" || $bcode2=="16")){
			$disp['matori'] = 1;
		}
		if($s['istype']="pet" || ($btype=="search" && $main=="売買") || ($bcode2 == 2 || $bcode2 == 3 || $bcode2 == 11 || $bcode2 == 12)){
			$disp['option'] = 1;
		}
	}
	if($list == "vendor"){
		if($_REQUEST["main_cd"] == "sell"){
			$disp['kakaku'] = 1;
		}else if($_REQUEST["main_cd"] == "rent"){
			$disp['rent'] = 1;
		}else{
			$disp['rent'] = 1;
			$smarty->assign("rent_mix","1");
		}
		$disp['bcodetype'] = 1;
	}
	if($list == "movies") $disp['bcodetype'] = 1;
	if($list == "school") $disp['scode'] = 1;
	if($list == "map"){
		$disp['scode'] = 1;
		$disp['rent'] = 1;
		$disp['reikin'] = 1;
		$disp['year'] = 1;
		$disp['kozo'] = 1;
		$disp['matori'] = 1;
	}
	if($_SESSION['search'][$bcode2]['istype']=="1000yen"){
		$disp['rent'] = 0;
		$disp['kakaku'] = 0;
	}
	if($list=="history"){
		$disp['area'] = 1;
	}
	if($list=="fav"){
		$disp['area'] = 1;
	}
	if($list || $_SESSION['search'][$bcode2]['istype']){
		$disp['city_name'] = 1;
		$disp['area'] = 1;
	}
	$disp['city_name'] = 1;
	
	if($bcode2 == 2 || $bcode2 == 3){
		$disp['matori'] = 1;
	}
	
//
//
	//if(@$kari_arr[3] && !$_REQUEST['search'] && !$list){
		$disp['area'] = 1;
	//}
//
	$bcode3 = "";
	
	if($list=="kariru"){
		$disp['rent'] = 1;
		$disp['reikin'] = 1;
		$disp['year'] = 1;
		$disp['kozo'] = 1;
		$disp['matori'] = 1;
		$disp['option'] = 1;
		$bcode3=12;
	}
	if($list=="lonely"){
		$disp['rent'] = 1;
		$disp['reikin'] = 1;
		$disp['year'] = 1;
		$disp['kozo'] = 1;
		$disp['matori'] = 1;
	}
	if($list=="ldk"){
		$disp['rent'] = 1;
		$disp['reikin'] = 1;
		$disp['year'] = 1;
		$disp['kozo'] = 1;
	}
	if($list=="mansion"){
		$disp['year'] = 1;
		$disp['kozo'] = 1;
		$disp['matori'] = 1;
	}
	if($list=="otoku"){
		$disp['year'] = 1;
		$disp['kozo'] = 1;
		$disp['matori'] = 1;
	}
	if($list=="kougaku"){
		$disp['year'] = 1;
		$disp['kozo'] = 1;
		$disp['matori'] = 1;
	}
	if($list=="inaka"){
		$disp['year'] = 1;
		$disp['kozo'] = 1;
		$disp['matori'] = 1;
	}
	if($list=="karuizawa"){
		$disp['year'] = 1;
		$disp['kozo'] = 1;
		$disp['matori'] = 1;
	}
	if($list=="otoku_tochi"){
		$disp['kakaku'] = 1;
		$disp['tsugaku'] = 1;
		$disp['tochi_m2'] = 1;
		$disp['scode'] = 1;
		$disp['option'] = 1;
		$bcode3=1;
		$btype="";
	}
	if($list=="newhouse"){
		$disp['year'] = 1;
		$disp['kozo'] = 1;
		$disp['matori'] = 1;
		$disp['scode'] = 1;
		$disp['option'] = 1;
		$bcode3=2;
		$btype="";
	}
	if($_REQUEST['istype']=="100tsubo") $disp['scode'] = "";
	if($_REQUEST['istype']=="1000yen") $disp['scode'] = "";
	if($list=="kougaku") $disp['scode'] = "";
	$smarty->assign("disp",$disp);
	
	
	//検索
	$s = $_SESSION['search'][$bcode2];
	
	$dir = "";
	if($list=="amt"){
		$tsubo = "";
		if($s['tsubo_min'] || $s['tsubo_max']) $tsubo = " 坪単価 ";
		if($type=="tochi"){
			if($tsubo){
				$dir = "".$main."物件 - 土地 坪単価 ".round($s['tsubo_min']/10000, 2)."万円～".round($s['tsubo_max']/10000, 2)."万円";
			}else{
				$dir = "".$main."物件 - 土地${tsubo} ".round($s['min']/10000, 2)."万円～".round($s['max']/10000, 2)."万円";
			}
		}else{
			if($main=="賃貸"){
				$dir = "".$main."物件 - 家賃${tsubo} ".round($s['min']/10000,2)."万円～".round($s['max']/10000, 2)."万円";
			}else{
				$dir = "".$main."物件 - 建物${tsubo} ".round($s['min']/10000,2)."万円～".round($s['max']/10000, 2)."万円";
			}
		}
	}
	if($list == "fav"){
		$dir = "お気に入り";
	}
	if($list == "history"){
		$dir = "閲覧履歴";
	}
	if($list == "vendor"){
		$sql = "select*from tbl_vender where vender_id=\"".mysql_real_escape_string($s['vid'])."\"";
		$res = mysql_query($sql);
		$row = mysql_fetch_array($res);
		$dir = "${row['vender_name']}の";
		//if($_REQUEST['bid']) $ssql .= " and bdata.bcode=\"".mysql_real_escape_string($_REQUEST['bid'])."\" ";
		if($_REQUEST['main_cd'] == "rent") $dir.="賃貸物件";
		else if($_REQUEST['main_cd'] == "sell") $dir.="売買物件";
		else $dir.="全物件";
		if($_REQUEST['bid']){
			$sql = "select*from tbl_bcode where bcode=\"".mysql_real_escape_string($_REQUEST['bid'])."\"";
			$bbres = mysql_query($sql);
			if(@mysql_num_rows($bbres)){
				$bbrow = mysql_fetch_array($bbres);
				$dir.=" - ${bbrow['bname']}";
			}
		}
	}
	if($list == "summer"){
		$dir = "夏だ！熱いぞ！不動産！";
	}
	if($list == "nesage"){
		$dir = "値下げ物件特集";
	}
	if($list == "kariru"){
		$dir = "庭付き一戸建ての貸家特集";
	}
	if($list == "mansion"){
		$dir = "ドラマのようなマンションに住みたい";
	}
	if($list == "lonely"){
		$dir = "一人暮らし向き賃貸ルーム";
	}
	if($list == "ldk"){
		$dir = "Lのある生活";
	}
	if($list == "otoku"){
		$dir = "何かとお得な売主物件！";
	}
	if($list == "kougaku"){
		$dir = "高いのにもワケがあります";
	}
	if($list == "inaka"){
		$dir = "田舎暮らし特集";
	}
	if($list == "karuizawa"){
		$dir = "軽井沢特集";
	}
	if($list == "movies"){
		$dir = "動画から探す";
	}
	if($list == "map"){
		if($_REQUEST['maptype']=="shindai") $dir = "信州大学(信大)賃貸アパート特集";
		if($_REQUEST['maptype']=="matsudai") $dir = "松本大学(松大)賃貸アパート特集";
		if($_REQUEST['maptype']=="shikadai") $dir = "松本歯科大学(歯科大)賃貸アパート特集";
	}
	if($list == "school"){
		$dir = "通学区から探す - ${schoolname}";
	}
	if($list == "tanto"){
		$sql = "select*from tbl_tanto where tanto_id=\"".mysql_real_escape_string($tantoid)."\"";
		$res = mysql_query($sql);
		$row = mysql_fetch_array($res);
		$dir = $row['tanto_name']." のコメント物件";
	}
	if($s['istype']=="pet"){
		$dir = "ペットと暮らせるアパート＆マンション";
	}
	if($s['istype']=="100tsubo"){
		$dir = "100坪以上限定!!";
	}
	if($s['istype']=="1000yen"){
		$dir = "1000万円以下の中古物件";
	}
	if($s['istype']=="one"){
		$dir = "ひとり暮らし向き賃貸ルーム";
	}
	if($list == "otoku_tochi"){
		$dir = "「取引態様＝売主」の土地特集";
	}
	if($list == "newhouse"){
		$dir = "新築住宅特集";
	}
	if(!$dir) {
		/*
		$dir = "検索結果 - ".$main."物件";
		$sql = "select*from tbl_bcode where bcode=\"${bcode2}\"";
		$res = mysql_query($sql);
		$row = mysql_fetch_array($res);
		$dir .= " - ${row['bname']}";
		*/
		$dir = "検索結果 - ";
		$dir = "";
		if($bcode2 == 1) $dir .= "土地";
		else if($bcode2 == 2) $dir .= "建物";
		else if($bcode2 == 3) $dir .= "分譲マンション";
		else if($bcode2 == 11) $dir .= "アパート・マンション";
		else if($bcode2 == 12) $dir .= "貸家";
		else if($bcode2 == 13) $dir .= "店舗・事務所";
		else if($bcode2 == 14) $dir .= "工場・倉庫";
		else if($bcode2 == 15) $dir .= "貸地";
		else if($bcode2 == 16) $dir .= "駐車場";
		else $dir .= $main."物件";
		$areas = $s['area_'];
		$areas_str = "";
		if($areas){
			while(list($key,$val)=@each($areas)){
				if($val){
					$sql = "select*from tbl_area_chimei where city_area_cd=\"${key}\"";
					$res = mysql_query($sql);
					if(@mysql_num_rows($res)){
						$row = mysql_fetch_array($res);
						if($areas_str) $areas_str .= "/";
						$areas_str .= $row['city_name'].$row['city_area_name'];
					}else{
						$sql = "select*from vt_jiscode where `jiscode`=\"${key}\"";
						$res = mysql_query($sql);
						if(@mysql_num_rows($res)){
							$row = mysql_fetch_array($res);
							if($areas_str) $areas_str .= "/";
							$areas_str .= $row['city_name_full'];
						}
					}
				}
			}
		}
		$ok2 = false;
		if($areas_str){
			if(!strstr($areas_str,'/')){
				$dir .= " ".$areas_str;
			}else{
				$ok2 = true;
			}
		}else{
			$ok2 = true;
		}
		if($ok2){
			$dir .= " - 検索結果";
		}
		$smarty->assign("search_hanyo","1");
	}
	$smarty->assign("dir",$dir);
	$smarty->assign("pagetitle1", str_replace(" - 検索結果","",$dir)." | ");
	$smarty->assign("pagetitle2", $jsite);
	$_SESSION['prev']['prev'] = $_SERVER["REQUEST_URI"];
	$_SESSION['prev']['dir'] = $dir;
	
	
	$ok = 0;
	if($s['scode_']){
		$s2 = array();
		reset($s2);
		$s2 = $s['scode_'];
		while(list($key,$val)=@each($s2)){
			if($val){
				$ok++;
			}
		}
	}
	if($s['set_code_']){
		$s2 = array();
		reset($s2);
		$s2 = $s['set_code_'];
		while(list($key,$val)=@each($s2)){
			if($val){
				$ok++;
			}
		}
	}
	if($s['matori_']){
		$s2 = array();
		reset($s2);
		$s2 = $s['matori_'];
		while(list($key,$val)=@each($s2)){
			if($val){
				$ok++;
			}
		}
	}
	if($s['istype']=="pet" && $_REQUEST['search']) $ok = 0;
	if($ok == 0){
		//$allcheck = 1;
	}
	//$smarty->assign("allcheck", $allcheck);
	$ok = 0;
	if($s['area_']){
		$s2 = array();
		reset($s2);
		$s2 = $s['area_'];
		while(list($key,$val)=@each($s2)){
			if($val){
				$ok++;
			}
		}
	}
	if($ok == 0){
		$area_check = 1;
	}
	
	
	$ssql = "";
	
	
	//価格から検索した場合
	if($list=="amt"){
		if($type=="tochi"){
			$ssql .= " and (bdata.bcode=\"1\" or bdata.bcode=\"15\" or bdata.bcode=\"16\") ";
		}else{
			$ssql .= " and (bdata.bcode!=\"1\" and bdata.bcode!=\"15\" and bdata.bcode!=\"16\") ";
		}
		if($main=="売買"){
			$ssql .= " and bdata.bcode<=\"10\" ";
		}else{
			$ssql .= " and bdata.bcode>\"10\" ";
		}
		if($s['min']){
			$ssql .= " and bdata.kakaku_amt>=\"".mysql_real_escape_string($s['min'])."\" ";
		}
		if($s['max']){
			$ssql .= " and bdata.kakaku_amt<=\"".mysql_real_escape_string($s['max'])."\" ";
		}
		if($s['tsubo_min']){
			$ssql .= " and bdata.tanka_tsubo>=\"".mysql_real_escape_string($s['tsubo_min'])."\" ";
		}
		if($s['tsubo_max']){
			$ssql .= " and bdata.tanka_tsubo<=\"".mysql_real_escape_string($s['tsubo_max'])."\" ";
		}
		if($s['jiscode']){
			$ssql .= " and bdata.jiscode = \"".mysql_real_escape_string($s['jiscode'])."\"";
		}
	}
	
	if($s['istype']=='100tsubo'){
		$ssql .= " and tochi_men_tsubo>=\"100\"";
		$ssql .= " and (scode=\"1111\" or scode=\"1114\")";
	}
	if($s['istype']=='1000yen'){
		$ssql .= " and (scode=\"1212\" or scode=\"1223\")";
	}
	if($list=='kougaku'){
		$ssql .= " and (scode=\"1212\" or scode=\"1223\")";
	}
	
	//土地面積
	if($s['l_area_l']){
		$ssql .= " and tochi_men_m2>=\"".mysql_real_escape_string($s['l_area_l'])."\"";
	}
	if($s['l_area_h']){
		$ssql .= " and tochi_men_m2<=\"".mysql_real_escape_string($s['l_area_h'])."\"";
	}
	
	//建物面積
	if($s['l_tatemono_l']){
		$ssql .= " and menseki_m2>=\"".mysql_real_escape_string($s['l_tatemono_l'])."\"";
	}
	if($s['l_tatemono_h']){
		$ssql .= " and menseki_m2<=\"".mysql_real_escape_string($s['l_tatemono_h'])."\"";
	}
	
	//築年
	if($s['period_h']){
		$y = date("Y", mktime()-(60*60*24*365*$s['period_h']));
		$ssql .= " and cast(chiku_yyyy as unsigned)>=\"${y}\"";
	}
	
	//構造
	if($s['kozo_cd']){
		$ssql .= " and kozo_cd=\"".mysql_real_escape_string($s['kozo_cd'])."\"";
	}
	
	//町名
	if($s['city_name']){
		//$ssql .= " and concat(prefecture, city_name,address1, address2, address3) like \"%".mysql_real_escape_string($s['city_name'])."%\"";
		$ssql .= " and (concat(ifnull(prefecture,''), ifnull(city_name,''),ifnull(address1,''), ifnull(address2,''), ifnull(address3,'')) collate utf8_unicode_ci like \"%".mysql_real_escape_string($s['city_name'])."%\" or prefecture like \"%".mysql_real_escape_string($s['city_name'])."%\" or city_name like \"%".mysql_real_escape_string($s['city_name'])."%\" or address1 collate utf8_unicode_ci like \"%".mysql_real_escape_string($s['city_name'])."%\" or address2 collate utf8_unicode_ci like \"%".mysql_real_escape_string($s['city_name'])."%\")";
	}
	
	//通学区
	if($s['sho_name']){
//		$ssql .= " and sho_name like \"%".mysql_real_escape_string(str_replace("小学校","",$s['sho_name']))."%\"";
		$ssql .= " and sho_name like \"%".mysql_real_escape_string(str_replace("学校","",$s['sho_name']))."%\"";
	}
	if($s['chu_name']){
//		$ssql .= " and chu_name like \"%".mysql_real_escape_string(str_replace("中学校","",$s['chu_name']))."%\"";
		$ssql .= " and chu_name like \"%".mysql_real_escape_string(str_replace("学校","",$s['chu_name']))."%\"";
	}
	
	//礼金敷金
	if($s['reikin_off_flg']){
		$ssql .= " and reikin_off_flg=\"".mysql_real_escape_string($s['reikin_off_flg'])."\"";
	}
	if($s['shiki_off_flg']){
		$ssql .= " and shiki_off_flg=\"".mysql_real_escape_string($s['shiki_off_flg'])."\"";
	}
		
	//金額
	if($s['kakaku_l']){
		$ssql .= " and kakaku_amt>=\"".mysql_real_escape_string($s['kakaku_l']*10000)."\"";
	}
	if($s['rent_l']){
		$ssql .= " and kakaku_amt>=\"".mysql_real_escape_string($s['rent_l']*10000)."\"";
	}
	if($s['kakaku_h']){
		$ssql .= " and kakaku_amt<=\"".mysql_real_escape_string($s['kakaku_h']*10000)."\"";
	}
	if($s['rent_h']){
		$ssql .= " and kakaku_amt<=\"".mysql_real_escape_string($s['rent_h']*10000)."\"";
	}
	
	//bcodeの選択
	if($disp['bcodetype']){
		$sql2 = "";
		if($_REQUEST['main_cd']=="sell"){
			$sql2 = "select*from tbl_bcode where bcode<=10 order by bcode asc";
		}else if($_REQUEST['main_cd']=="rent"){
			$sql2 = "select*from tbl_bcode where bcode>10 order by bcode asc";
		}else{
			$sql2 = "select*from tbl_bcode order by bcode asc";
		}
		$res = mysql_query($sql2);
		$sql2 = "";
		$bcode_array = "";
		while($row = mysql_fetch_array($res)){
			$bcode_array[] = $row;
			if($s['bcodetype'][$row['bcode']]==1){
				if($sql2 != "") $sql2 .= " or ";
				$sql2 .= " bdata.bcode=\"${row['bcode']}\"";
			}
		}
		if($sql2 != "") $ssql .= (" and (".$sql2.") ");
		$smarty->assign("bcode_array",$bcode_array);
	}
	
	
	//エリア
	if($disp['area']){
		$sql2 = "";
		//エリア配列
		//松本以外ではvt_jiscode
		$area_array = "";
		$sql = "select*from vt_jiscode where `site`=\"${site}\" order by `sort` desc";
		$res = mysql_query($sql);
		$i = 0;
		$ok2 = 0;
		if(@mysql_num_rows($res)){
			while($row = mysql_fetch_array($res)){
				$area_array[$i] = $row;
				$sql = "select*from tbl_area_chimei where `jiscode`=\"${row['jiscode']}\" and disp = '1' group by city_area_cd order by city_area_cd";
				$res2 = mysql_query($sql);
				$j = 0;
				if(@mysql_num_rows($res2)){
					while($row2 = mysql_fetch_array($res2)){
						$area_array[$i]['subarea'][$j] = $row2;
						if($s['area_'][$row2['city_area_cd']]){
							$sql3 = "select*from tbl_area_chimei where city_area_cd=\"${row2['city_area_cd']}\"";
							$res3 = mysql_query($sql3);
							if(@mysql_num_rows($res3)){
								while($row3 = mysql_fetch_array($res3)){
									if($sql2) $sql2 .= " or ";
									//$sql2 .= "( concat(bdata.city_name, bdata.address1, bdata.address2) collate utf8_unicode_ci like \"%".mysql_real_escape_string($row3['area_chimei'])."%\" and bdata.jiscode=\"20202\")";

//									$sql2 .= "( bdata.address1 collate utf8_unicode_ci like \"%".mysql_real_escape_string($row3['area_chimei'])."%\" and bdata.jiscode=\"20202\")";

//$sql2 .= "(concat(bdata.city_name,bdata.address1) collate utf8_unicode_ci like \"%".mysql_real_escape_string($row3['city_name'].$row3['area_chimei'])."%\" and bdata.jiscode=\"20202\")";

$sql2 .= "(concat(ifnull(bdata.city_name,''),ifnull(bdata.address1,'')) collate utf8_unicode_ci like \"%".mysql_real_escape_string($row3['city_name'].$row3['area_chimei'])."%\")";

if($row3['area_chimei']){
	if($sql2) $sql2 .= " or ";
	$sql2 .= "(concat(ifnull(bdata.city_name,''),ifnull(bdata.address1,'')) collate utf8_unicode_ci like \"%".mysql_real_escape_string($row3['city_name']."大字".$row3['area_chimei'])."%\")";
}
								}
							}
						}else{
							$ok2++;
						}
						if($area_check){
							//$area_array[$i]['subarea'][$j]['checked'] = 1;
						}
						$j++;
					}
				}
				if($s['area_'][$row['jiscode']]){
					if($sql2) $sql2 .= " or ";
					$ok = false;
					$sql2 .= "(";
					/*
					if($row['city_name1']){
						$ok = true;
						//$sql2 .= "concat(bdata.city_name, bdata.address1, bdata.address2) like \"%".mysql_real_escape_string($row['city_name1'])."%\"";
						$sql2 .= " bdata.city_name collate utf8_unicode_ci like \"%".mysql_real_escape_string($row['city_name1'])."%\"";
					}
					if($row['city_name2']){
						if($ok==true) $sql2 .= " and ";
						//$sql2 .= " concat(bdata.city_name, bdata.address1, bdata.address2) like \"%".mysql_real_escape_string($row['city_name2'])."%\"";
						$sql2 .= " bdata.address1 collate utf8_unicode_ci like \"%".mysql_real_escape_string($row['city_name2'])."%\"";
					}
					*/
					$sql2 .= " concat(ifnull(city_name,''),ifnull(address1,'')) collate utf8_unicode_ci like \"%".mysql_real_escape_string($row['city_name1'].$row['city_name2'])."%\"";
					$sql2 .= ")";
				}else if(!$area_array[$i]['subarea']){
					$ok2++;
				}
				if($area_check){
					//$area_array[$i]['checked'] = 1;
				}
				$i++;
			}
		}
		$smarty->assign("area_array", $area_array);
		if($ok2 != 0 && $sql2) $ssql .= (" and (".$sql2.")");
	}
	
	//まとり
	if($disp['matori']){
		$sql2 = "";
		$ok2 = 0;
		//matori配列
		$msql = "";
		if($list=="lonely"){
			$msql .= " and marori_cd not like \"%L%\" ";
		}
		$sql = "select*from tbl_marori_cd where marori_cd!=\"LK\" ${msql} and marori_cd!=\"LK\" and marori_cd!=\"SK\" and marori_cd!=\"SDK\" and marori_cd!=\"SLK\" and marori_cd!=\"SLDK\" order by seq asc";
		$res = mysql_query($sql);
		$data = "";
		if(@mysql_num_rows($res)){
			while($row = mysql_fetch_array($res)){
				$data[] = $row;
			}
		}
		$smarty->assign("matori_array",$data);
		$matori2 = "";
		if($list=="lonely"){
			for($i = 0; $i < 2; $i++){
				$matori2[$i] = $i+1;
			}
		}else{
			for($i = 0; $i < 4; $i++){
				$matori2[$i] = $i+1;
			}
		}
		$smarty->assign("matori2_array",$matori2);
		//if($allcheck){
			$sum = 0;
			for($i = 0; $i < @count($data); $i++){
				for($j = 0; $j < @count($matori2); $j++){
					//$matori_check[$sum] = 1;
					if($s['matori_'][$sum]){
						$str = $s['matori_'][$sum];
						$str2 = explode("-",$str);
						if($str2[0] && $str2[1]){
							if($sql2) $sql2 .= " or ";
							$sql3 = "";
							if($str2[1]=="LK") $sql3 = " and (madori_cd=\"DK\" or madori_cd=\"LK\") ";
							else $sql3 = " and (madori_cd=\"${str2[1]}\" or madori_cd=\"S${str2[1]}\") ";
							$sql2 .= "(";
							$sql2 .= " room_count=\"${str2[0]}\" ${sql3}";
							$sql2 .= ")";
						}
					}else{
						$ok2++;
					}
					
					$sum++;
				}
			}
			//$smarty->assign("matori_one","1");
			//$smarty->assign("matori_max","1");
		//}
		//$smarty->assign("matori_check",$matori_check);
		if($s['matori_one']){
			if($sql2) $sql2 .= " or ";
			$sql2 .= " madori_cd=\"ワンルーム\" ";
		}else{
			$ok2++;
		}
		if($s['matori_max']){
			if($sql2) $sql2 .= " or ";
			$sql2 .= " room_count>\"4\" ";
		}else{
			$ok2++;
		}
		if($ok2 != 0 && $sql2) $ssql .= (" and (".$sql2.")");
	}
	
	
	if($disp['scode']){
		//scode配列
		$sql2 = "";
		$ok2 = 0;
		if($bcode2 == "1" || $bcode3 == "1" || $type=="tochi"){
			//売り地はsaiteki
			$sql = "select*from tbl_saiteki_cd order by `seq` asc";
			$res = mysql_query($sql);
			$data = "";
			$i = 0;
			if(@mysql_num_rows($res)){
				while($row = mysql_fetch_array($res)){
					$data[$i] = $row;
					if($allcheck){
						//$data[$i]['checked']=1;
					}
					if($s['scode_'][$row['saiteki_cd']]){
						if ($sql2) $sql2 .= " or ";
						$sql2 .= " bdata.saiteki_cd=\"${row['saiteki_cd']}\" ";
					}else{
						$ok2++;
					}
					$i++;
				}
			}
			$smarty->assign("scode_array",$data);
			$smarty->assign("scode_saiteki",1);
		}else{
			$b3 = "";
			if($bcode3){
				$b2 =  " and bcode=\"${bcode3}\"";
			}else{
				$b2 =  " and bcode=\"${bcode2}\"";
			}
			if($btype=="search") $b2 = "";
			if($main == "売買") $b3 = " and bcode <= \"10\"";
			if($main == "賃貸") $b3 = " and bcode > \"10\"";
			if($list == "map") $b3 = " and (bcode = \"11\" or bcode = \"12\")";
			$sql = "select*from tbl_scode where bname!=\"\" ${b2} ${b3} order by scode asc";
			$res = mysql_query($sql);
			$data = "";
			$i = 0;
			if(@mysql_num_rows($res)){
				while($row = mysql_fetch_array($res)){
					$data[$i] = $row;
					if($allcheck){
						//$data[$i]['checked']=1;
					}
					if($s['scode_'][$row['scode']]){
						if ($sql2) $sql2 .= " or ";
						$sql2 .= " bdata.scode=\"${row['scode']}\" ";
					}else{
						$ok2++;
					}
					$i++;
				}
			}
			$smarty->assign("scode_array",$data);
		}
		if($ok2!=0 && $sql2) $ssql .= " and (".$sql2.") ";
	}
		
	
	if($s['word']){
		//フィールド名取得
		$sql = "select*from bdata limit 1";  
		$rs = mysql_query($sql);  
		$fields = mysql_num_fields($rs);
		$f = array();
		$f_edit = array();
		$f_edit2 = array();
		for ( $i=0; $i<$fields; $i++ ) {  
			$n = mysql_field_name($rs, $i);
			$f[$i] = mysql_field_name($rs, $i);
		}
		$q = $s['word'];
		$q = str_replace("　"," ", $q);
		$q = explode(" ",$q);
		$sql2 = "";
		for($i = 0; $i < @count($q); $i++){
			if($i > 0) $sql2 .= " and ";
			$sql2 .= "(";
			for($j = 0; $j < @count($f); $j++){
				if($j > 0) $sql2 .= " or ";
				$sql2 .= " bdata.".$f[$j]." like \"%".mysql_real_escape_string($q[$i])."%\" ";
			}
			$sql2 .= " or concat(ifnull(bdata.prefecture,''), ifnull(bdata.city_name,''), ifnull(bdata.address1,'')) collate utf8_unicode_ci like \"%".mysql_real_escape_string($q[$i])."%\" ";
			$sql2 .= " or tbl_vender.vender_name like \"%".mysql_real_escape_string($q[$i])."%\" ";
			$sql2 .= ")";
		}
		if($sql2) $ssql .= " and (".$sql2.") ";
	}
	
	
	if($list != "vendor" || $list != "nesage" || $list != "summer" || $list != "fav" || $list != "history"){
		if($main == "売買"){
			$ssql .= " and bdata.bcode <= 10 ";
		}else if($main == "賃貸"){
			$ssql .= " and bdata.bcode > 10 ";
		}
	}
	
	
	$pagelimit = $s['page_disp'];
	$sql1 = "";
	if($bcode){
		while((list($key, $value) =@each($bcode))){
			if(preg_match("/^[0-9]+$/",$value)){
				if($sql1){
					$sql1 .= "or";
				}
				$sql1 .= " bcode = '".$value."'";
			}
		}
		if($sql1){
			$sql1 = " and (".$sql1.")";
		}
	}
	
	if($s['sort_type']!="history" && $s['sort_type']!="fav"){
		if($s['sort_type']=="ins_date" || $s['sort_type']=="update_date"){
			if($s['sort_vector'] == "asc")$s['sort_vector'] = "desc";
			else $s['sort_vector'] = "asc";
		}
		$orderby = " order by ".$s['sort_type']." ".$s['sort_vector'];
		if($s['sort_type']=="menseki_m2" && $s['list_type']=="detail"){
			$orderby = " order by tochi_men_m2 ".$s['sort_vector'].", menseki_m2 ".$s['sort_vector'];
		}
		if($s['sort_type']=="city_name"){
			$orderby = " order by concat(ifnull(prefecture,''), ifnull(city_name,''), ifnull(address1,''), ifnull(address2,''), ifnull(address3,'')) ".$s['sort_vector'];
		}
	}
	//print $orderby;
	
	
	$sort_rireki1 = "";
	//お気に入り
	if($list=="fav"){
		$orderby = "";
		if(@$_COOKIE['fav']){
			$ck = $_COOKIE['fav'];
			$ck2 = explode(",",$ck);
			$sql2 = "";
			$istime = "";
			$his = array();
			for($i = 0; $i < @count($ck2); $i++){
				if($i > 30) break;
				if($sql2 != "") $sql2 .= " or ";
				$id = mb_substr($ck2[$i],0,mb_strpos($ck2[$i],"-"));
				$his[$i] = $id;
			}
			$sort_rireki1 = ", CASE ";
			for($i = 0; $i < @count($his); $i++){
				if($sql2 != "") $sql2 .= " or ";
				$sql2 .= " bdata.sid=\"${his[$i]}\" ";
				$sort_rireki1 .= " WHEN bdata.sid=\"${his[$i]}\" THEN ${i} ";
			}
			$sort_rireki1 .= " END skey";
			if($s['sort_type']=="fav"){
				$orderby = " order by skey ".$s['sort_vector'];
			}
			
		}
		if($sql2){
			$ssql .= " and (".$sql2.")";
		}else{
			$ssql .= " and bdata.bdata_id=\"0\" ";
		}
	}
	
	//履歴
	if($list=="history"){
		if(@$_COOKIE['rireki']){
			$ck = $_COOKIE['rireki'];
			$ck2 = explode(",",$ck);
			$sql2 = "";
			$istime = "";
			$n = 0;
			$i2 = 0;
			$his = array();
			//最大30
			for($i = 0; $i < @count($ck2); $i++){
				if($i2 > 30) break;
				if(mb_substr($ck2[$i],0,1)=="-") continue;
				$id = explode("-",$ck2[$i]);
				$id2 = "";
				for($j = 0; $j < @count($id); $j++){
					if(mb_strlen($id[$j])>2){
						$id2 = $id[$j];
						break;
					}
				}
				if(!$id2) continue;
				if(!strstr($str,",".$id2.",")){//重複は読み込まない
					$his[$i2] = $id2;
					$i2++;
				}
			}
			$sort_rireki1 = ", CASE ";
			for($i = 0; $i < @count($his); $i++){
				if($sql2 != "") $sql2 .= " or ";
				$sql2 .= " bdata.sid=\"${his[$i]}\" ";
				$sort_rireki1 .= " WHEN bdata.sid=\"${his[$i]}\" THEN ${i} ";
			}
			$sort_rireki1 .= " END skey";
			if($s['sort_type']=="history"){
				$orderby = " order by skey ".$s['sort_vector'];
			}
		}
		if($sql2){
			$ssql .= " and (".$sql2.")";
		}else{
			$ssql .= " and bdata.bdata_id=\"0\" ";
		}
	}
	
	//業者
	if($list == "vendor"){
		$ssql .= " and bdata.vender_id=\"".$s['vid']."\" ";
		if($_REQUEST['bid']) $ssql .= " and bdata.bcode=\"".mysql_real_escape_string($_REQUEST['bid'])."\" ";
		if($_REQUEST['main_cd'] == "rent") $ssql .= " and bdata.main_cd=\"".mysql_real_escape_string("賃貸")."\" ";
		if($_REQUEST['main_cd'] == "sell") $ssql .= " and bdata.main_cd=\"".mysql_real_escape_string("売買")."\" ";
	}
	
	//夏だ！
	if($list == "summer"){
		$ssql2 .= ",dt_keisai ke";
		$ssql .= " and (ke.deletetime=\"0000-00-00 00:00:00\" or ke.deletetime is null) and bdata.bdata_id=ke.bdata_id and ke.keisai_code=\"6\" ";
	}
	//値下げ
	if($list == "nesage"){
		$ssql2 .= ",dt_keisai ke";
		$ssql .= " and (ke.deletetime=\"0000-00-00 00:00:00\" or ke.deletetime is null) and bdata.bdata_id=ke.bdata_id and ke.keisai_code=\"7\" ";
		
	}
	//動画
	if($list == "movies"){
		$ssql2 .= ",dt_movies mov";
		$ssql .= " and bdata.bdata_id = mov.bdata_id and (mov.deletedate is null or mov.deletedate=\"0000-00-00 00:00:00\") ";
		
	}
	//通学区から探す
	if($list == "school"){
		$sql = "select*from public_landmark where disp_flag = '1' and `name`=\"".mysql_real_escape_string($schoolname)."\"";
		$res = mysql_query($sql);
		if(@mysql_num_rows($res)){
			$row = mysql_fetch_array($res);
			if($row['category']=="47"){
//				$ssql .= " and sho_name like \"%".mysql_real_escape_string(str_replace("小学校","",$schoolname))."%\"";
				$ssql .= " and sho_name like \"%".mysql_real_escape_string(str_replace("学校","",$schoolname))."%\"";
			}else{
//				$ssql .= " and chu_name like \"%".mysql_real_escape_string(str_replace("中学校","",$schoolname))."%\"";
				$ssql .= " and chu_name like \"%".mysql_real_escape_string(str_replace("学校","",$schoolname))."%\"";
			}
		}
	}
	//担当のコメントのある物件
	if($list == "tanto"){
		$ssql2 .= ", dt_tanto tan";
		$ssql .= " and tan.tanto_id=\"".mysql_real_escape_string($tantoid)."\" and tan.bdata_id=bdata.bdata_id and (tan.deletetime is null or tan.deletetime=\"0000-00-00 00:00:00\") ";
		if($main=="賃貸") $_REQUEST['main_cd'] = "rent";
		if($main=="売買") $_REQUEST['main_cd'] = "sell";
		if($_REQUEST['main_cd'] == "rent") $ssql .= " and bdata.main_cd=\"".mysql_real_escape_string("賃貸")."\" ";
		if($_REQUEST['main_cd'] == "sell") $ssql .= " and bdata.main_cd=\"".mysql_real_escape_string("売買")."\" ";
		$smarty->assign("main_cd", $_REQUEST['main_cd']);
	}
	//信大特集など
	if($list == "map"){
		$sql = "select*from public_landmark where disp_flag = '1' and name=\"${landname}\" and (deletedate=\"0000-00-00 00:00:00\" or deletedate is null)";
		$res = mysql_query($sql);
		if(!@mysql_num_rows($res)) header("Location: /");
		$row = mysql_fetch_array($res);
		$landid = $row['id'];
		$ssql2 .= ", dt_landmark land";
		$ssql .= " and land.bdata_id=bdata.bdata_id and land.landmark_cd=\"${landid}\" and (land.deletetime=\"0000-00-00 00:00:00\" or land.deletetime is null) ";
	}
	//借りるという手があった(貸家庭付き)
	if($list == "kariru"){
		$ssql2 .= ", dt_set dset, tbl_set_code mset";
		$ssql .= " and mset.set_name=\"庭\" and mset.set_code=dset.set_code and dset.bdata_id=bdata.bdata_id and bdata.bcode=\"12\" ";
		
		if(!$s['sort_vector'] || !$s['sort_type']) $orderby = " order by bdata.kakaku_amt desc ";
	}
	//Lのある生活
	if($list == "ldk"){
		$ssql .= " and bdata.madori_cd like \"%LDK%\" and (bdata.bcode=\"11\" || bdata.bcode=\"12\") ";
	}
	//一人暮らし向き賃貸ルーム
	if($list == "lonely"){
		$ssql .= " and (bdata.madori_cd=\"ワンルーム\" || CONCAT(IFNULL(bdata.room_count,''),bdata.madori_cd)=\"1K\" || CONCAT(IFNULL(bdata.room_count,''),bdata.madori_cd)=\"1DK\" || CONCAT(IFNULL(bdata.room_count,''),bdata.madori_cd)=\"1LDK\" || CONCAT(IFNULL(bdata.room_count,''),bdata.madori_cd)=\"2K\"  || CONCAT(IFNULL(bdata.room_count,''),bdata.madori_cd)=\"2DK\") and (bdata.bcode=\"11\") ";
	}
	//何かとお得な売主物件！
	if($list == "otoku"){
		$ssql .= " and ((bdata.bcode=\"2\" and (bdata.sname=\"中古住宅\" or bdata.sname=\"中古別荘\")) or bdata.bcode=\"3\") and bdata.torihiki_cd=\"売主\" ";
	}
	//ドラマに出てくるようなマンションに住みたい(高い方から30件、アパートマンション、画像3点以上)
	if($list == "mansion"){
		$ssql2 .= ",dt_image img";
		$ssql .= " and img.bdata_id=bdata.bdata_id and img.deletetime is null and img.imgdisp=\"1\" and bdata.bcode=\"11\" ";
		$ssql4 .= " having count(img.id) >= \"3\" ";
		
		$pagelimit = 30;
		$s['page_disp'] = 30;
		$_SESSION['search'][$bcode2]['bcodetype'] = 30;
		if(!$s['sort_vector'] || !$s['sort_type']) $orderby = " order by bdata.kakaku_amt desc ";
	}
	//高いのにもワケがあります(高い方から30件、中古住宅、画像3点以上)
	if($list == "kougaku"){
		$ssql2 .= ",dt_image img";
		$ssql .= " and img.bdata_id=bdata.bdata_id and img.deletetime is null and img.imgdisp=\"1\" and bdata.bcode=\"2\" ";
		$ssql4 .= " having count(img.id) >= \"3\" ";
		
		$pagelimit = 30;
		$s['page_disp'] = 30;
		$_SESSION['search'][$bcode2]['bcodetype'] = 30;
		if(!$s['sort_vector'] || !$s['sort_type']) $orderby = " order by bdata.kakaku_amt desc ";
	}
	//田舎暮らし特集
	if($list == "inaka"){
		$ssql2 .= ",dt_keisai kei";
		$ssql .= " and kei.bdata_id=bdata.bdata_id and (kei.deletetime is null or kei.deletetime=\"0000-00-00 00:00:00\") and kei.keisai_code=\"4\" ";
	}
	//軽井沢特集
	if($list == "karuizawa"){
		$ssql .= " and (bdata.city_name like \"%軽井沢%\" or bdata.address1 like \"%軽井沢%\") ";
	}
	//「取引態様＝売主」の土地特集
	if($list == "otoku_tochi"){
		$ssql .= " and bdata.bcode=\"1\" and bdata.torihiki_cd=\"売主\" ";
		if(!$s['page_disp'])$s['page_disp'] = 30;
		$pagelimit = $s['page_disp'];
		if(!$s['sort_vector'] || !$s['sort_type']) $orderby = " order by bdata.kakaku_amt desc ";
	}
	//新築住宅特集
	if($list == "newhouse"){
		$ssql .= " and bdata.bcode=\"2\" and bdata.sname=\"新築住宅\" ";
		if(!$s['page_disp'])$s['page_disp'] = 30;
		$pagelimit = $s['page_disp'];
		if(!$s['sort_vector'] || !$s['sort_type']) $orderby = " order by bdata.kakaku_amt desc ";
	}

	//オプション
	if($disp['option']){
		//setsubi配列
		$sql2 = "";
		$ok2 = 0;
		if($s['set_code_']) $ssql5 .= ", dt_set c";
		if($bcode3){
			$b2 =  " and bcode${bcode3}=\"1\"";
		}else{
			$b2 =  " and bcode${bcode2}=\"1\"";
		}
		if($btype=="search") $b2 = "";
		$sql = "select*from tbl_set_code where set_name!=\"\" ${b2} order by set_code asc";
		//print $sql;
		$res = mysql_query($sql);
		$data = "";
		$i = 0;
		$count_total = 0;
		
		$set_code_str = "";
		
		if(@mysql_num_rows($res)){
			while($row = mysql_fetch_array($res)){
				$data[$i] = $row;
				if($allcheck){
					if(!($s['istype']=="pet" && $_REQUEST['search'])){
						//$data[$i]['checked'] = "checked";
					}
				}
				if($s['set_code_'][$row['set_code']]){
					$count_total++;
					if($sql2) $sql2 .= " or ";
					$sql2 .= "(";
					$sql2 .= " c.set_code=\"${row['set_code']}\" and";
					$sql2 .= " c.bdata_id=bdata.bdata_id";
					$sql2 .= ")";
					$set_code_str .= "#".$row["set_code"]."#";
				}else{
					$ok2++;
				}
				$i++;
			}
		}
		$smarty->assign("set_code_array",$data);
		if($ok2 != 0 && $sql2) $ssql6 .= " and (".$sql2.") ";
		
		
		$sql2 = "";
		$sql = "select group_concat(distinct c.set_code order by c.set_code asc separator \"#\") set_total, bdata.bdata_id as bdataid from  bdata left join rdata on bdata.bdata_id = rdata.bdata_id, tbl_vender,tbl_jiscode${ssql2}${ssql5} where tbl_jiscode.site=\"${site}\" and bdata.status_code<=\"2\" and tbl_vender.web1_mem_flg = '1' and tbl_vender.web_disp = '1' and (tbl_vender.deletetime is null or tbl_vender.del_flg = '0') and bdata.jiscode=tbl_jiscode.jiscode and tbl_vender.vender_id = bdata.vender_id and bdata.open_flg = '1' and bdata.open_date <= '".date("Y-m-d H:i:s")."' and bdata.close_date >= '".date("Y-m-d H:i:s")."' and (bdata.done_date = '0000-00-00 00:00:00' or bdata.done_date is null) and (bdata.del_date = '0000-00-00 00:00:00' or bdata.del_date is null)".$ssql.$sql1.$ssql6." group by bdata.sid${ssql4}";
		$res = mysql_query($sql);
if($_SERVER["REMOTE_ADDR"] == "106.159.173.224"){
//		echo $sql."<br><br>".mysql_num_rows($res)."<br><br>";
}
		if(@mysql_num_rows($res)){
			while($row = mysql_fetch_array($res)){
				$row['set_total'] = str_replace("#","##",$row['set_total']);
				$row['set_total'] = "#".$row['set_total']."#";
if($_SERVER["REMOTE_ADDR"] == "210.196.94.30"){
	//print "s:".$set_code_str."<br>";
	//print "d:".$row['set_total']."<br>";
	//echo $row['set_total']."==".$count_total."<br><br>";
}

				if($set_code_str == $row['set_total']){
					if($sql2) $sql2 .= " or ";
					$sql2 .= " bdata.bdata_id=\"${row['bdataid']}\" ";
				}
			}
		}
if($_SERVER["REMOTE_ADDR"] == "106.159.173.224"){
//	echo $sql2."<br><br>";
}
		if($sql2){
			$ssql .= " and (${sql2}) ";
		}else if($count_total>0){
			$ssql .= " and bdata.bdata_id=\"0\" ";
		}
	}
if($_SERVER["REMOTE_ADDR"] == "106.159.173.224"){
//	echo $ssql."<br><br>";
}


	$sql = "select bdata.bdata_id as bdataid,bdata.bukkendata_id as old_bukkendata_id,bdata.*,rdata.*,tbl_vender.*${sort_rireki1} from  bdata left join rdata on bdata.bdata_id = rdata.bdata_id, tbl_vender,tbl_jiscode${ssql2} where tbl_jiscode.site=\"${site}\" and bdata.status_code<=\"2\" and tbl_vender.web1_mem_flg = '1' and tbl_vender.web_disp = '1' and (tbl_vender.deletetime is null or tbl_vender.del_flg = '0') and bdata.jiscode=tbl_jiscode.jiscode and tbl_vender.vender_id = bdata.vender_id and bdata.open_flg = '1' and bdata.open_date <= '".date("Y-m-d H:i:s")."' and bdata.close_date >= '".date("Y-m-d H:i:s")."' and (bdata.done_date = '0000-00-00 00:00:00' or bdata.done_date is null) and (bdata.del_date = '0000-00-00 00:00:00' or bdata.del_date is null)".$ssql.$sql1." group by bdata.sid${ssql4}";
	$result = mysql_query($sql);

if($_SERVER["REMOTE_ADDR"] == "210.196.94.30"){
		//print $sql."<hr>";
}
/*
if($_SERVER["REMOTE_ADDR"] == "106.159.173.224"){
	echo $sql;
}

if($_SERVER["REMOTE_ADDR"] == "116.81.30.7"){
echo $sql;
}
*/

	$num_all = @mysql_numrows($result);
	$smarty->assign("num_all",$num_all);

	if($_REQUEST['next']) $_REQUEST['page']++; 
	if($_REQUEST['former']) $_REQUEST['page']--; 
	$sql_p="";
	$_REQUEST['max_page'] = ceil($num_all / $pagelimit); 
	if(!$_REQUEST['page'])$_REQUEST['page'] = 1; 
	if($_REQUEST['page']>$_REQUEST['max_page'])$_REQUEST['page'] = $_REQUEST['max_max_page']; 
	$lim = ($_REQUEST['page']-1)*$pagelimit;
	if($lim < 0) $lim = 0;
	$sql_p = " limit ".$lim.", ".$pagelimit; 
	$pageroll="";
	$start = $_REQUEST['page']-8; 
	$last = $_REQUEST['page']+8;
	if($start < 1) $start = 1; 
	if($last > $_REQUEST['max_page']) $last = $_REQUEST['max_page']; 
	for($i = $start; $i <= $last; $i++){ 
		$pageroll[] = $i; 
	}
	$smarty->assign("pageroll",$pageroll);
	$pageroll="";
	$start = $_REQUEST['page']-3; 
	$last = $_REQUEST['page']+3;
	if($start < 1) $start = 1; 
	if($last > $_REQUEST['max_page']) $last = $_REQUEST['max_page']; 
	for($i = $start; $i <= $last; $i++){ 
		$pageroll[] = $i; 
	}
	$smarty->assign("pageroll2",$pageroll);


	$bukkendata1 = "";
	$sql = $sql." ".$orderby." ".$sql_p;
	
	
	$result = mysql_query($sql);
	if($num = @mysql_numrows($result)){
		while($bukkendata = mysql_fetch_array($result)){
			$bdata_id = $bukkendata["bdataid"];
			$bukkendata["bdata_id"] = $bdata_id;
			$vender_id = $bukkendata["vender_id"];

			//画像2枚
			$image = array();
			$sql = "select imgfile from dt_image where bdata_id = '".$bdata_id."' and (deletetime is null or deletetime=\"0000-00-00 00:00:00\") and imgdisp = '1' order by sort limit 2";
			$result1 = mysql_query($sql);
			if(mysql_numrows($result1)){
				while($rows = mysql_fetch_array($result1)){
					$image[] = $rows;
				}
				$bukkendata["image1"] = $image[0]["imgfile"];
				$bukkendata["image2"] = $image[1]["imgfile"];
/*
				//画像取得
				if(!@fopen($bukkenimage."/".$bukkendata["vender_id"]."/".$bdata_id."/".$bukkendata["image1"],"r")){
					if($bukkendata["old_bukkendata_id"]){
						$address = "http://www.test-fudousan.com/image/getimg2.php?bukkendata_id=".$bukkendata["old_bukkendata_id"];
						$handle = @fopen($address,"r");
						if($handle) {
							$buffer = "";
							while (!feof($handle)) {
								$buffer .= fgets($handle, 4096);
							}
							fclose($handle);
						}
					}
				}
*/
			}
			//担当データ
			$sql = "select tanto_name,tanto_gazo1 from dt_tanto,tbl_tanto where dt_tanto.tanto_id = tbl_tanto.tanto_id and dt_tanto.bdata_id = '".$bdata_id."' and (dt_tanto.deletetime is null or dt_tanto.deletetime=\"0000-00-00 00:00:00\") and tbl_tanto.deletedate is null order by sort limit 1";
			$result1 = mysql_query($sql);
			if(@mysql_numrows($result1)){
				$rows = mysql_fetch_array($result1);
				$bukkendata["tanto_name"] = $rows["tanto_name"];
				$bukkendata["tanto_gazo1"] = $rows["tanto_gazo1"];
			}else if(1==1/*$list!="vendor"*/){
				$sql = "select*from tbl_tanto where deletedate is null and vender_id=\"${bukkendata['vender_id']}\" order by tanto_bango limit 1";
				$result1 = mysql_query($sql);
				if(@mysql_numrows($result1)){
					$rows = mysql_fetch_array($result1);
					$bukkendata["tanto_name"] = $rows["tanto_name"];
					$bukkendata["tanto_gazo1"] = $rows["tanto_gazo1"];
				}
			}
			
			//新着
			$bukkendata['new']=new_check2($bukkendata['ins_date'],$bukkendata['update_date']);
			
			
			if(strstr($bukkendata['prefecture'],"長野県")) $bukkendata['prefecture'] = "";
//			if($bukkendata['address2'] && !strstr($bukkendata['address2'],"丁目")) $bukkendata['address2'] .= "丁目";
			
			
			$bukkendata1[] = $bukkendata;
		}
	}
	$smarty->assign("bukken",$bukkendata1);
	$smarty->assign("num",$num);


	//土地
	$t_arr[1] = Array("新着","画像","所在地","価格<br>(万円)","面積<br>(m&#178;)","面積<br>(坪)","地目","取扱い会社");
	$n_arr[1] = Array("s_NEW","s_IMG","s_ADD","s_KAKAKU","s_LANDM2","s_TSUBO","s_CHIMOKU","s_VENDOR");

	//建物
	$t_arr[2] = Array("新着","画像","所在地","価格<br>(万円)","土地面積<br>(m&#178;)","建物面積<br>(m&#178;)","間取り","築年数","取扱い会社");
	$n_arr[2] = Array("s_NEW","s_IMG","s_ADD","s_KAKAKU","s_LANDM2","bldg_m2","s_ROOM","kansei_yyyy","s_VENDOR");

	//マンション
	$t_arr[3] = Array("新着","画像","所在地","価格<br>(万円)","専有面積<br>(m&#178;)","建物面積<br>(m&#178;)","間取り","築年数","取扱い会社");
	$n_arr[3] = Array("s_NEW","s_IMG","s_ADD","s_KAKAKU","bldg_m2","s_ROOM","kansei_yyyy","s_VENDOR");

	//アパートマンション
	$t_arr[11] = Array("新着","画像","所在地","家賃<br>(万円)","間取","築年数","礼金","敷金","取扱い会社");
	$n_arr[11] = Array("s_NEW","s_IMG","s_ADD","s_KAKAKU","s_ROOM","kansei_yyyy","reikin","shikkin","s_VENDOR");

	//貸家
	$t_arr[12] = Array("新着","画像","所在地","家賃<br>(万円)","間取","築年数","礼金","敷金","取扱い会社");
	$n_arr[12] = Array("s_NEW","s_IMG","s_ADD","s_KAKAKU","s_ROOM","kansei_yyyy","reikin","shikkin","s_VENDOR");

	//店舗事務所
	$t_arr[13] = Array("新着","画像","所在地","家賃<br>(万円)","総床面積<br>(m&#178;)","取扱い会社");
	$n_arr[13] = Array("s_NEW","s_IMG","s_ADD","s_KAKAKU","bldg_m2","s_VENDOR");

	//工場倉庫
	$t_arr[14] = Array("新着","画像","所在地","家賃<br>(万円)","土地面積<br>(m&#178;)","建物面積<br>(m&#178;)","取扱い会社");
	$n_arr[14] = Array("s_NEW","s_IMG","s_ADD","s_KAKAKU","s_LANDM2","bldg_m2","s_VENDOR");

	//貸地
	$t_arr[15] = Array("新着","画像","所在地","賃料<br>(万円)","面積<br>(m&#178;)","面積<br>(坪)","地目","取扱い会社");
	$n_arr[15] = Array("s_NEW","s_IMG","s_ADD","s_KAKAKU","s_LANDM2","s_TSUBO","s_CHIMOKU","s_VENDOR");

	//駐車場
	$t_arr[16] = Array("新着","画像","所在地","賃料<br>(万円)","コメント","取扱い会社");
	$n_arr[16] = Array("s_NEW","s_IMG","s_ADD","s_KAKAKU","s_COMMENT","s_VENDOR");

	$smarty->assign("t_arr",$t_arr);
	$smarty->assign("n_arr",$n_arr);
	
	
	if($disp['kozo']){
		//kozo配列
		$sql = "select*from tbl_kozo_cd order by seq asc";
		$res = mysql_query($sql);
		$data = "";
		if(@mysql_num_rows($res)){
			while($row = mysql_fetch_array($res)){
				$data[] = $row;
			}
		}
		$smarty->assign("kozo_array",$data);
	}
	
	
	if($disp['tsugaku']){
		//小学・中学配列
		$sql = "select l.*,v.city_name1 from public_landmark l, vt_jiscode v where l.disp_flag = '1' and l.jiscode=v.jiscode and v.site=\"${site}\" and (l.category=\"47\" or l.category=\"48\") and (l.deletedate is null or l.deletedate=\"0000-00-00 00:00:00\") group by l.id order by l.id asc";
		$res = mysql_query($sql);
		$data1 = "";
		$data2 = "";
		if(@mysql_num_rows($res)){
			while($row = mysql_fetch_array($res)){
				if($row['category']=="47"){
					$data1[] = $row;
				}else{
					$data2[] = $row;
				}
			}
		}
		$smarty->assign("sho_array",$data1);
		$smarty->assign("chu_array",$data2);
	}
	
	
	$smarty->assign("pageroll_set",$pageroll_set);
	
	
	$smarty->display("list_box.tpl");
?>