海ホテルの宿泊プラン一覧｜海ホテルの宿泊プランは城崎温泉 お宿とれとれ

お宿とれとれ（城崎温泉）の「海ホテル」宿泊プラン一覧のページです。


お宿くらべ

お宿の価格帯や特徴からあなたにピッタリの宿を見つけてください！
城崎温泉旅館予約トップ > 海ホテル > プラン一覧
array(5) { ["Select"]=> string(105) "MIN(tr.nPlanRate) AS MinPlanRate1, CASE WHEN th.nYadoNo > 0 THEN 1 ELSE 0 END as preHoliday, tr.dPlanDate" ["From"]=> string(114) "FROM tPlanRateTbl AS tr LEFT JOIN tPreHoliday AS th ON (tr.dPlanDate = th.dPreHoliday) AND tr.nYadoNo = th.nYadoNo" ["Where"]=> string(253) "WHERE tr.nYadoNo = :YadoNo AND tr.nPlanNo = :PlanNo AND tr.nAgentNo = 1 AND tr.nPlanRate > 0 AND tr.dPlanDate >= :ymd AND tr.nStockNo IN ( SELECT nStockNo FROM tPlanSale WHERE nYadoNo = :YadoNo AND nPlanNo = :PlanNo AND nAgentNo = 1 AND bPlanSleep = 0) " ["OrderBy"]=> string(39) "GROUP BY preHoliday ORDER BY preHoliday" ["Params"]=> array(3) { ["YadoNo"]=> string(3) "379" ["PlanNo"]=> string(2) "12" ["ymd"]=> string(19) "2025-06-12 00:00:00" } } array(0) { } int(-1) int(-1)