テーマ __HTML; }else */ if($list_com[72]==2 or $list_com[73]==2 or $list_com[74]==2){ $foot_path=<<<__HTML 物件一覧 __HTML; } //print_r($list); //オススメ if($list[23]){ if(ereg("
",$list[23])){ $osusume_text = $list[23]; }else{ $osusume_text = nl2br($list[23]); } } //設備アイコン if($list[138]){ $setsubi_array = explode('/', $list[138]); $where_d=array(); foreach ( $setsubi_array as $value ){ $value_d=ereg_replace("_", "", $value); $sql_setsubi = "select * from M_SETSUBI where a00 = $value_d"; $res_setsubi =mysql_query("$sql_setsubi") or error("SQL失敗"); $list_setsubi = mysql_fetch_array($res_setsubi); array_push($where_d,$list_setsubi[0]); } sort($where_d); foreach ( $where_d as $value ){ $sql_setsubi = "select * from M_SETSUBI where a00 = $value"; $res_setsubi =mysql_query("$sql_setsubi") or error("SQL失敗"); $list_setsubi = mysql_fetch_array($res_setsubi); $setsubi_icon.=<<<__HTML
$list_setsubi[2]
__HTML; } } //周辺施設1 if($list[324]){ $sql_shisetsu01 = "select * from M_SHISETSU where a00 = '$list[324]'"; $res_shisetsu01 =mysql_query("$sql_shisetsu01") or die("SQL失敗2"); $list_shisetsu01 = mysql_fetch_array($res_shisetsu01); $a324=$list_shisetsu01[2]."
"; if($list[325]){$jikan01="{$list[325]}";} if($list[326]){$jikan01.=":{$list[326]}分
";} if($list[327]){$kyori01="距離:{$list[327]}m";} //画像1 $photo_file_s1="../user_data/image/$list[324]_1_s.jpg"; if(is_file($photo_file_s1)){ $size = image_resize("100","100",$photo_file_s1); $photo_s1=<<<__HTML $list_shisetsu01[2] __HTML; }else{ $photo_s1=<<<__HTML $list_shisetsu05[2] __HTML; } $shisetsu01=<<<__HTML
$photo_s1$a324$jikan01$kyori01
__HTML; } //周辺施設2 if($list[328]){ $sql_shisetsu02 = "select * from M_SHISETSU where a00 = '$list[328]'"; $res_shisetsu02 =mysql_query("$sql_shisetsu02") or die("SQL失敗2"); $list_shisetsu02 = mysql_fetch_array($res_shisetsu02); $a328=$list_shisetsu02[2]."
"; if($list[329]){$jikan02="{$list[329]}";} if($list[330]){$jikan02.=":{$list[330]}分
";} if($list[331]){$kyori02="距離:{$list[331]}m";} //画像2 $photo_file_s2="../user_data/image/$list[328]_1_s.jpg"; if(is_file($photo_file_s2)){ $size = image_resize("100","100",$photo_file_s2); $photo_s2=<<<__HTML $list_shisetsu02[2] __HTML; }else{ $photo_s2=<<<__HTML $list_shisetsu05[2] __HTML; } $shisetsu02=<<<__HTML
$photo_s2$a328$jikan02$kyori02
__HTML; } //周辺施設3 if($list[332]){ $sql_shisetsu03 = "select * from M_SHISETSU where a00 = '$list[332]'"; $res_shisetsu03 =mysql_query("$sql_shisetsu03") or die("SQL失敗2"); $list_shisetsu03 = mysql_fetch_array($res_shisetsu03); $a332=$list_shisetsu03[2]."
"; if($list[333]){$jikan03="{$list[333]}";} if($list[334]){$jikan03.=":{$list[334]}分
";} if($list[335]){$kyori03="距離:{$list[335]}m";} //画像2 $photo_file_s3="../user_data/image/$list[332]_1_s.jpg"; if(is_file($photo_file_s3)){ $size = image_resize("100","100",$photo_file_s3); $photo_s3=<<<__HTML $list_shisetsu03[2] __HTML; }else{ $photo_s3=<<<__HTML $list_shisetsu05[2] __HTML; } $shisetsu03=<<<__HTML
$photo_s3$a332$jikan03$kyori03
__HTML; } //周辺施設4 if($list[336]){ $sql_shisetsu04 = "select * from M_SHISETSU where a00 = '$list[336]'"; $res_shisetsu04 =mysql_query("$sql_shisetsu04") or die("SQL失敗2"); $list_shisetsu04 = mysql_fetch_array($res_shisetsu04); $a336=$list_shisetsu04[2]."
"; if($list[337]){$jikan04="{$list[337]}";} if($list[338]){$jikan04.=":{$list[338]}分
";} if($list[339]){$kyori04="距離:{$list[339]}m";} //画像2 $photo_file_s4="../user_data/image/$list[336]_1_s.jpg"; if(is_file($photo_file_s4)){ $size = image_resize("100","100",$photo_file_s4); $photo_s4=<<<__HTML $list_shisetsu04[2] __HTML; }else{ $photo_s4=<<<__HTML $list_shisetsu05[2] __HTML; } $shisetsu04=<<<__HTML
$photo_s4$a336$jikan04$kyori04
__HTML; } //周辺施設5 if($list[340]){ $sql_shisetsu05 = "select * from M_SHISETSU where a00 = '$list[340]'"; $res_shisetsu05 =mysql_query("$sql_shisetsu05") or die("SQL失敗2"); $list_shisetsu05 = mysql_fetch_array($res_shisetsu05); $a340=$list_shisetsu05[2]."
"; if($list[341]){$jikan05="{$list[341]}";} if($list[342]){$jikan05.=":{$list[342]}分
";} if($list[343]){$kyori05="距離:{$list[343]}m";} //画像2 $photo_file_s5="../user_data/image/$list[340]_1_s.jpg"; if(is_file($photo_file_s5)){ $size = image_resize("100","100",$photo_file_s5); $photo_s5=<<<__HTML $list_shisetsu05[2] __HTML; }else{ $photo_s5=<<<__HTML $list_shisetsu05[2] __HTML; } $shisetsu05=<<<__HTML
$photo_s5$a340$jikan05$kyori05
__HTML; } if($list[324] or $list[328] or $list[332] or $list[336] or $list[340]){ $shisetsu=<<<__HTML

周辺施設

$shisetsu01 $shisetsu02 $shisetsu03 $shisetsu04 $shisetsu05
__HTML; } //小学校名 $sql_element = "select * from M_SCHOOL where (a00 = '$list[317]') and a03='1'"; $res_element =mysql_query("$sql_element") or die("SQL失敗2"); $list_element = mysql_fetch_array($res_element); $school1=$list_element[2] ; //小学校画像 $photo_sc1="../user_data/school_image/$list[317]_1_s.jpg"; if(is_file($photo_sc1)){ $size = image_resize("100","100",$photo_sc1); $shisetsu_sc1=<<<__HTML __HTML; }else{ $shisetsu_sc1=<<<__HTML $list_shisetsu05[2] __HTML; } if($list[319]){$sc_time1 = "
徒歩:".$list[319]."分";} if($list[318]){$sc_far1 = "
距離:".$list[318]."m";} if($list[317]){ $shisetsu_sc01=<<<__HTML
{$shisetsu_sc1}{$school1}学校{$sc_time1}{$sc_far1}
__HTML; }else{$shisetsu_sc02="";} //中学校名 $sql_element = "select * from M_SCHOOL where (a00 = '$list[320]') and a03='2'"; $res_element =mysql_query("$sql_element") or die("SQL失敗2"); $list_element = mysql_fetch_array($res_element); $school2=$list_element[2] ; //中学校画像 $photo_sc2="../user_data/school_image/$list[320]_1_s.jpg"; if(is_file($photo_sc2)){ $size = image_resize("100","100",$photo_sc2); $shisetsu_sc2=<<<__HTML __HTML; }else{ $shisetsu_sc2=<<<__HTML $list_shisetsu05[2] __HTML; } if($list[322]){$sc_time2 = "
徒歩:".$list[322]."分";} if($list[321]){$sc_far2 = "
距離:".$list[321]."m";} if($list[320]){ $shisetsu_sc02=<<<__HTML
{$shisetsu_sc2}{$school2}学校{$sc_time2}{$sc_far2}
__HTML; }else{$shisetsu_sc02="";} if($school1 or $school2){ $shisetsu_sc=<<<__HTML

学校施設

$shisetsu_sc01 $shisetsu_sc02
__HTML; } //外観画像2 $photo_file2="../sch_h/img/$list[0]_2_s.jpg"; $photo_file2L="../sch_h/img/$list[0]_2_l.jpg"; if(is_file($photo_file2)){ $size = image_resize("78","78",$photo_file2); $text382=mb_strimwidth("$list[382]", 0, 13, "..."); $photo2=<<<__HTML
物件外観

$text382

__HTML; } //外観画像3 $photo_file3="../sch_h/img/$list[0]_3_s.jpg"; $photo_file3L="../sch_h/img/$list[0]_3_l.jpg"; if(is_file($photo_file3)){ $size = image_resize("78","78",$photo_file3); $text383=mb_strimwidth("$list[383]", 0, 13, "..."); $photo3=<<<__HTML
物件外観

$text383

__HTML; } //外観画像4 $photo_file4="../sch_h/img/$list[0]_4_s.jpg"; $photo_file4L="../sch_h/img/$list[0]_4_l.jpg"; if(is_file($photo_file4)){ $size = image_resize("78","78",$photo_file4); $text384=mb_strimwidth("$list[384]", 0, 13, "..."); $photo4=<<<__HTML
物件外観

$text384

__HTML; } //外観画像5 $photo_file5="../sch_h/img/$list[0]_5_s.jpg"; $photo_file5L="../sch_h/img/$list[0]_5_l.jpg"; if(is_file($photo_file5)){ $size = image_resize("78","78",$photo_file5); $text385=mb_strimwidth("$list[385]", 0, 13, "..."); $photo5=<<<__HTML
物件外観

$text385

__HTML; } //外観画像6 $photo_file6="../sch_h/img/$list[0]_26_s.jpg"; $photo_file6L="../sch_h/img/$list[0]_26_l.jpg"; if(is_file($photo_file6)){ $size = image_resize("78","78",$photo_file6); $text387=mb_strimwidth("$list[387]", 0, 13, "..."); $photo6=<<<__HTML
物件外観

$text387

__HTML; } //外観画像7 $photo_file7="../sch_h/img/$list[0]_27_s.jpg"; $photo_file7L="../sch_h/img/$list[0]_27_l.jpg"; if(is_file($photo_file7)){ $size = image_resize("78","78",$photo_file7); $text388=mb_strimwidth("$list[388]", 0, 13, "..."); $photo7=<<<__HTML
物件外観

$text388

__HTML; } //外観画像8 $photo_file8="../sch_h/img/$list[0]_28_s.jpg"; $photo_file8L="../sch_h/img/$list[0]_28_l.jpg"; if(is_file($photo_file8)){ $size = image_resize("78","78",$photo_file8); $text389=mb_strimwidth("$list[389]", 0, 13, "..."); $photo8=<<<__HTML
物件外観

$text389

__HTML; } //外観画像9 $photo_file9="../sch_h/img/$list[0]_29_s.jpg"; $photo_file9L="../sch_h/img/$list[0]_29_l.jpg"; if(is_file($photo_file9)){ $size = image_resize("78","78",$photo_file9); $text401=mb_strimwidth("$list[401]", 0, 13, "..."); $photo9=<<<__HTML
物件外観

$text401

__HTML; } //外観画像10 $photo_file10="../sch_h/img/$list[0]_30_s.jpg"; $photo_file10L="../sch_h/img/$list[0]_30_l.jpg"; if(is_file($photo_file10)){ $size = image_resize("78","78",$photo_file10); $text402=mb_strimwidth("$list[402]", 0, 13, "..."); $photo10=<<<__HTML
物件外観

$text402

__HTML; } //内観画像1 $photo_file11="../sch_h/img/$list[0]_11_s.jpg"; $photo_file11L="../sch_h/img/$list[0]_11_l.jpg"; if(is_file($photo_file11)){ $size = image_resize("78","78",$photo_file11); $text391=mb_strimwidth("$list[391]", 0, 13, "..."); $photo11=<<<__HTML
物件外観

$text391

__HTML; } //内観画像2 $photo_file12="../sch_h/img/$list[0]_12_s.jpg"; $photo_file12L="../sch_h/img/$list[0]_12_l.jpg"; if(is_file($photo_file12)){ $size = image_resize("78","78",$photo_file12); $text392=mb_strimwidth("$list[392]", 0, 13, "..."); $photo12=<<<__HTML
物件外観

$text392

__HTML; } //内観画像3 $photo_file13="../sch_h/img/$list[0]_13_s.jpg"; $photo_file13L="../sch_h/img/$list[0]_13_l.jpg"; if(is_file($photo_file13)){ $size = image_resize("78","78",$photo_file13); $text393=mb_strimwidth("$list[393]", 0, 13, "..."); $photo13=<<<__HTML
物件外観

$text393

__HTML; } //内観画像4 $photo_file14="../sch_h/img/$list[0]_14_s.jpg"; $photo_file14L="../sch_h/img/$list[0]_14_l.jpg"; if(is_file($photo_file14)){ $size = image_resize("78","78",$photo_file14); $text394=mb_strimwidth("$list[394]", 0, 13, "..."); $photo14=<<<__HTML
物件外観

$text394

__HTML; } //内観画像5 $photo_file15="../sch_h/img/$list[0]_15_s.jpg"; $photo_file15L="../sch_h/img/$list[0]_15_l.jpg"; if(is_file($photo_file15)){ $size = image_resize("78","78",$photo_file15); $text395=mb_strimwidth("$list[395]", 0, 13, "..."); $photo15=<<<__HTML
物件外観

$text395

__HTML; } //内観画像6 $photo_file16="../sch_h/img/$list[0]_16_s.jpg"; $photo_file16L="../sch_h/img/$list[0]_16_l.jpg"; if(is_file($photo_file16)){ $size = image_resize("78","78",$photo_file16); $text396=mb_strimwidth("$list[396]", 0, 13, "..."); $photo16=<<<__HTML
物件外観

$text396

__HTML; } //内観画像7 $photo_file17="../sch_h/img/$list[0]_17_s.jpg"; $photo_file17L="../sch_h/img/$list[0]_17_l.jpg"; if(is_file($photo_file17)){ $size = image_resize("78","78",$photo_file17); $text397=mb_strimwidth("$list[397]", 0, 13, "..."); $photo17=<<<__HTML
物件外観

$text397

__HTML; } //内観画像8 $photo_file18="../sch_h/img/$list[0]_18_s.jpg"; $photo_file18L="../sch_h/img/$list[0]_18_l.jpg"; if(is_file($photo_file18)){ $size = image_resize("78","78",$photo_file18); $text398=mb_strimwidth("$list[398]", 0, 13, "..."); $photo18=<<<__HTML
物件外観

$text398

__HTML; } //内観画像9 $photo_file19="../sch_h/img/$list[0]_19_s.jpg"; $photo_file19L="../sch_h/img/$list[0]_19_l.jpg"; if(is_file($photo_file19)){ $size = image_resize("78","78",$photo_file19); $text399=mb_strimwidth("$list[399]", 0, 13, "..."); $photo19=<<<__HTML
物件外観

$text399

__HTML; } //内観画像10 $photo_file20="../sch_h/img/$list[0]_20_s.jpg"; $photo_file20L="../sch_h/img/$list[0]_20_l.jpg"; if(is_file($photo_file20)){ $size = image_resize("78","78",$photo_file20); $text400=mb_strimwidth("$list[400]", 0, 13, "..."); $photo20=<<<__HTML
物件外観

$text400

__HTML; } //間取り図1 $photo_mitorizu1="../sch_h/img/$list[0]_6_l.jpg"; if(is_file($photo_mitorizu1)){ $size = image_resize("300","300",$photo_mitorizu1); $mitorizu1=<<<__HTML
物件まどり

$list[386]

__HTML; }else{ $mitorizu1=""; } /* //間取り図2 $photo_mitorizu2="../sch_h/img/$list[0]_7_s.jpg"; $photo_mitorizu2L="../sch_h/img/$list[0]_7_l.jpg"; if(is_file($photo_mitorizu2)){ $size = image_resize("78","78",$photo_mitorizu2); $mitorizu2=<<<__HTML
物件内装
__HTML; } //間取り図3 $photo_mitorizu3="../sch_h/img/$list[0]_8_s.jpg"; $photo_mitorizu3L="../sch_h/img/$list[0]_8_l.jpg"; if(is_file($photo_mitorizu3)){ $size = image_resize("78","78",$photo_mitorizu3); $mitorizu3=<<<__HTML
物件内装
__HTML; } //間取り図4 $photo_mitorizu4="../sch_h/img/$list[0]_9_s.jpg"; $photo_mitorizu4L="../sch_h/img/$list[0]_9_l.jpg"; if(is_file($photo_mitorizu4)){ $size = image_resize("78","78",$photo_mitorizu4); $mitorizu4=<<<__HTML
物件内装
__HTML; } */ //周辺地図 if($list_com[76] == 2){ $photo_file_shuhen="../sch_h/img/$list[0]_10_l.jpg"; if(is_file($photo_file_shuhen)){ $size = image_resize("300","300",$photo_file_shuhen); $photo_shuhen=<<<__HTML
周辺地図

$list[390]

__HTML; }else{ $photo_shuhen=""; } } //画像1 $photo_file1="../sch_h/img/$list[0]_1_l.jpg";//外観 if(is_file($photo_file1)){ $size = image_resize("300","300",$photo_file1); $photo1_d=<<<__HTML
物件外観
__HTML; }else{ if($mitorizu1 or $photo_shuhen){ $photo1_d=""; }else{ $photo1_d=<<<__HTML
物件外観
__HTML; } } //オススメテーマアイコン $cate_theme = array(); $cate_theme_str = str_replace("_","",$list[139]); $cate_theme = split("/",$cate_theme_str); //カテゴリーの表示順並べ替え $cate_theme_num = array(); $i = 0; foreach ( $cate_theme as $num_value ){ $sql_category_num = "select * from M_CATEGORY where a00 = '$num_value' "; $res_category_num =mysql_query("$sql_category_num") or die("SQL失敗1"); $list_category_num = mysql_fetch_array($res_category_num); //$num_keyに$list_category_num[6]を格納。 //keyの値が重複すると新しいものに書き換えられてしまうので、「.x」を追加して小数点以下を追加。 //小数点以下の値はカウントアップする$i $num_key = $list_category_num[6].".".$i; $cate_theme_num[$num_key] = $num_value; //小数点以下カウントアップ $i++; } //a06の表示順(と小数点以下)で配列をソート ksort($cate_theme_num); // print_r($cate_theme_num); $theme_icon = ""; foreach ( $cate_theme_num as $value ){ $theme_icon_data="../user_data/theme_img/{$value}_2_s.jpg"; //テーマアイコン if(is_file($theme_icon_data)){ //カテゴリー名の取得 $sql_category_s = "select * from M_CATEGORY where a00 = '$value' "; $res_category_s =mysql_query("$sql_category_s") or die("SQL失敗1"); $list_category_s = mysql_fetch_array($res_category_s); $size = image_resize("50","50",$theme_icon_data); $theme_icon .=<<<__HTML $list_category_s[2] __HTML; } } /* $sql_element = "select * from M_CATEGORY where (a00 = '$list[317]') and a03='1'"; $res_element =mysql_query("$sql_element") or die("SQL失敗2"); $list_element = mysql_fetch_array($res_element); $school1=$list_element[2] ; */ //更新日時 $koushin_date=date("Y年m月d日 ",$list[429]); //表部分読み込み //物件タイプ if($cate == 1){require_once("detail/table_h_b.php");} //売買戸建て elseif($cate == 4){require_once("detail/table_h_c.php");} //賃貸戸建て elseif($cate == 2){require_once("detail/table_m_b.php");} //売買マンション elseif($cate == 5){require_once("detail/table_m_c.php");} //賃貸マンション elseif($cate == 3){require_once("detail/table_t_b.php");} //売買土地 elseif($cate == 6){require_once("detail/table_t_c.php");} //賃貸土地 $script_js=<<<__HTML __HTML; Header_base(); if($list[311] and $list[312] and $list[12]==1){ if($list[313]){$houi = $list[313];}else{$houi =0;} if($list[314]){$kakudo = $list[314];}else{$kakudo =0;} if($list[315]){$zoom = $list[315];}else{$zoom =0;} //会員物件 if($list[238] == 2){ $mem_bukken ="< 会員物件 >"; }else{ $mem_bukken = ""; } if($cate == 1){ $type_name= "\"売買戸建\""; $gmap_cate = "google_map_v3_h.js"; } //売買戸建て else if($cate ==4){ //賃貸戸建て $type_name= "\"賃貸戸建\""; $gmap_cate = "google_map_v3_h.js"; } else if($cate ==2){ //売買マンション $type_name= "\"売買マンション\""; $gmap_cate = "google_map_v3_m.js"; } else if($cate ==5){ //賃貸マンション $type_name= "\"賃貸マンション\""; $gmap_cate = "google_map_v3_m.js"; } else if($cate ==3){ //売買土地 $type_name= "\"売買土地\""; $gmap_cate = "google_map_v3_t.js"; } else if($cate ==6){ //賃貸土地 $type_name= "\"賃貸土地\""; $gmap_cate = "google_map_v3_t.js"; } $google_maps =<<<__HTML

緯度経度情報等の誤差により、実際の場所と異なる場合があります。

__HTML; }else{$google_maps = "";} //資料請求リストへ if($list_com[71]==2 or ($list_com[71]==3 and $_SESSION['mem_login']==1)){ $to_list=<<<__HTML

この物件の資料を請求する

__HTML; $to_list_w="w_330"; }else{ $to_list_w="w_130"; } //マンション号室 if($list[16]){$mansion_room_no =" $list[16]";} //会員のみの場合 if(!$_SESSION['mem_login'] and $list[238]==2 and $pre!=1){ print<<<__HTML




ご覧の物件は会員限定の公開物件です。

会員の方はこちらからログインして下さい。



__HTML; //非公開の場合 }elseif((($list[238]!=1 and $list[238]!=2) or !$list[238]) and $pre!=1){ print<<<__HTML




申しわけございません。この物件は非公開物件となっております。



__HTML; //それ以外 }else{ //お気に入り登録 if($_SESSION['mem_login']==1 and $list_com[126]==2 ){ //会員情報 $sql_mem = "select * from M_KOKYAKU where a02='$id' and a03='$pass'"; $res_mem =mysql_query("$sql_mem") or error("SQL失敗12"); $list_mem = mysql_fetch_array($res_mem); $bukken_no=$list[0]; $type=$list[2]; $sql_f = "select * from D_BOOKMARK where a01 = '$list_mem[0]' and a03 = '$bukken_no'"; $res_f =mysql_query("$sql_f") or error("SQL失敗"); if(mysql_num_rows($res_f)){ $favorite_img = "images/btn_favorite_del.jpg"; $book_list_fn = "sch_bookBtn_on"; $favorite_btn = <<<__HTML

__HTML; }else{ $favorite_img = "images/btn_favorite.jpg"; $book_list_fn = "sch_bookBtn"; $favorite_btn = <<<__HTML

__HTML; } }else{ $favorite_btn = ""; } print<<<__HTML

物件詳細

検索結果に戻る $to_list

$list[502]{$type_name}【お問い合せNo:$list[1]】$list[15]{$mansion_room_no}$mem_bukken

印刷

$favorite_btn

$theme_icon
$photo1_d

$list[381]

$photo2 $photo3 $photo4 $photo5 $photo6 $photo7 $photo8 $photo9 $photo10 $photo11 $photo12 $photo13 $photo14 $photo15 $photo16 $photo17 $photo18 $photo19 $photo20 $photo_shuhen $mitorizu1 $mitorizu2 $mitorizu3 $mitorizu4
__HTML; } require_once("../lib_data/footer.php"); ?>