צימר צימרים
אטרקציות מסעדות ספא

צימרים הכי יפים - במחירים הכי טובים

מחיר ללילה בסופ"ש :

הצג מחירים באמצ"ש

צימרים עם בריכה מחוממת רחובות  (7 מקומות אירוח)

X
חדרים לפי שעה ברחובות לחץ לרשימת חדרים לפי שעה ברחובות
SELECT cabin.name, cabin.id, cabin.phone, cabin.cabinOwner, cabin.cordes_zimmer ,cabin.first_pic_location, cabin.show_pics_nums, Cities.cordes, Cities.url, cabin.settlement, cabin.zones, cabin.address FROM cabin LEFT JOIN Cities ON cabin.zones=Cities.name WHERE cabin.sales<>'*' AND cabin.zones = 'רחובות' ORDER BY CASE WHEN cabin.price_min>0 THEN price_min ELSE 1000000 END
Array
(
    [0] => Array
        (
            [0] => 42S22
            [SQLSTATE] => 42S22
            [1] => 207
            [code] => 207
            [2] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'price_min'.
            [message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'price_min'.
        )

    [1] => Array
        (
            [0] => 42S22
            [SQLSTATE] => 42S22
            [1] => 207
            [code] => 207
            [2] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'price_min'.
            [message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'price_min'.
        )

    [2] => Array
        (
            [0] => 42000
            [SQLSTATE] => 42000
            [1] => 16945
            [code] => 16945
            [2] => [Microsoft][SQL Server Native Client 11.0][SQL Server]The cursor was not declared.
            [message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]The cursor was not declared.
        )

)