トップへ

検索結果
検索結果
SEARCH RESALT
物件検索
SEARCH
|物件名・住所・駅名など|
お気に入りリスト
0
0
トップページ
053-414-5554
〒433-8117 静岡県浜松市中区高丘東1丁目2-39
TEL.053-414-5554
FAX.053-414-5558
静岡県知事(6)第10841号
COPYRIGHT© SKYPORT CO.,LTD. ALL RIGHTS RESERVED.
ページトップへ
AND ( ( d_heya.heya_suu ='3' AND d_heya.madori_no='2' ) OR ( d_heya.heya_suu ='3' AND d_heya.madori_no='4' ) ) AND ( ( YEAR(CURDATE()) - YEAR( cast( case when chiku_year != '0' and chiku_month !='0' then concat( chiku_year , '-' , chiku_month , '-01' ) else '0000-00-00' end as date) ) ) - (RIGHT(CURDATE(), 5) < RIGHT( cast( case when chiku_year != '0' and chiku_month !='0' then concat( chiku_year , '-' , chiku_month , '-01' ) else '0000-00-00' end as date) , 5) + 0 ) <= '0' ) AND ( ( d_heya.chukai_tesuryo_flag='0' OR d_heya_kodawari_216.kodawari_no IS NOT NULL OR d_heya.chuukai_use_flag='0' ) )