Aliquet eget per venenatis dis non mus ut rhoncus ullamcorper posuere malesuada sociosqu habitasse vitae

Avatar

Oliver Ross

on The Benjamin hotel in New York
Trust & Safety

Risus id aliquam proin urna mollis dolor interdum morbi natoque

Best Destinations

Imperdiet nec nisl bibendum fames nec nam curae dapibus erat

Best Travel Agent

In integer posuere velit nascetur tortor cras metus ante elit

Best Destinations

Imperdiet nec nisl bibendum fames nec nam curae dapibus erat

WordPress database error: [Column 'status' in where clause is ambiguous]
SELECT room.post_id, room.room_parent, room.discount_rate FROM wpwq_hotel_room AS room INNER JOIN wpwq_st_hotel AS hotel ON hotel.post_id = room.room_parent WHERE CAST( room.discount_rate AS UNSIGNED ) > 0 AND room.post_id NOT IN ( SELECT room_id FROM ( SELECT od.room_id, room1.number_room, od.room_num_search, sum(od.room_num_search), cast( room1.number_room AS UNSIGNED ) FROM wpwq_st_order_item_meta AS od INNER JOIN wpwq_hotel_room AS room1 ON room1.post_id = od.room_id WHERE 1 = 1 AND ( ( check_in_timestamp <= 1656547200 AND check_out_timestamp >= 1656547200 ) OR ( check_in_timestamp >= 1656547200 AND check_in_timestamp <= 1656547200 ) ) AND od.check_out_timestamp AND `status` NOT IN ('trash', 'canceled') AND od.st_booking_post_type = 'st_hotel' GROUP BY od.room_id HAVING sum(od.room_num_search) >= cast( room1.number_room AS UNSIGNED ) ) AS room_id ) AND room.post_id NOT IN ( SELECT post_id FROM wpwq_st_availability WHERE 1 = 1 AND ( check_in >= 1656547200 AND check_out <= 1656547200 AND `status` = 'unavailable' ) AND post_type = 'hotel_room' ) ORDER BY room.discount_rate DESC LIMIT 0, 1

WordPress database error: [Column 'status' in where clause is ambiguous]
SELECT room.post_id, room.room_parent, room.discount_rate FROM wpwq_hotel_room AS room INNER JOIN wpwq_st_hotel AS hotel ON hotel.post_id = room.room_parent WHERE CAST( room.discount_rate AS UNSIGNED ) > 0 AND room.post_id NOT IN ( SELECT room_id FROM ( SELECT od.room_id, room1.number_room, od.room_num_search, sum(od.room_num_search), cast( room1.number_room AS UNSIGNED ) FROM wpwq_st_order_item_meta AS od INNER JOIN wpwq_hotel_room AS room1 ON room1.post_id = od.room_id WHERE 1 = 1 AND ( ( check_in_timestamp <= 1656633600 AND check_out_timestamp >= 1656633600 ) OR ( check_in_timestamp >= 1656633600 AND check_in_timestamp <= 1656633600 ) ) AND od.check_out_timestamp AND `status` NOT IN ('trash', 'canceled') AND od.st_booking_post_type = 'st_hotel' GROUP BY od.room_id HAVING sum(od.room_num_search) >= cast( room1.number_room AS UNSIGNED ) ) AS room_id ) AND room.post_id NOT IN ( SELECT post_id FROM wpwq_st_availability WHERE 1 = 1 AND ( check_in >= 1656633600 AND check_out <= 1656633600 AND `status` = 'unavailable' ) AND post_type = 'hotel_room' ) ORDER BY room.discount_rate DESC LIMIT 0, 1

WordPress database error: [Column 'status' in where clause is ambiguous]
SELECT room.post_id, room.room_parent, room.discount_rate FROM wpwq_hotel_room AS room INNER JOIN wpwq_st_hotel AS hotel ON hotel.post_id = room.room_parent WHERE CAST( room.discount_rate AS UNSIGNED ) > 0 AND room.post_id NOT IN ( SELECT room_id FROM ( SELECT od.room_id, room1.number_room, od.room_num_search, sum(od.room_num_search), cast( room1.number_room AS UNSIGNED ) FROM wpwq_st_order_item_meta AS od INNER JOIN wpwq_hotel_room AS room1 ON room1.post_id = od.room_id WHERE 1 = 1 AND ( ( check_in_timestamp <= 1656720000 AND check_out_timestamp >= 1656720000 ) OR ( check_in_timestamp >= 1656720000 AND check_in_timestamp <= 1656720000 ) ) AND od.check_out_timestamp AND `status` NOT IN ('trash', 'canceled') AND od.st_booking_post_type = 'st_hotel' GROUP BY od.room_id HAVING sum(od.room_num_search) >= cast( room1.number_room AS UNSIGNED ) ) AS room_id ) AND room.post_id NOT IN ( SELECT post_id FROM wpwq_st_availability WHERE 1 = 1 AND ( check_in >= 1656720000 AND check_out <= 1656720000 AND `status` = 'unavailable' ) AND post_type = 'hotel_room' ) ORDER BY room.discount_rate DESC LIMIT 0, 1

WordPress database error: [Column 'status' in where clause is ambiguous]
SELECT room.post_id, room.room_parent, room.discount_rate FROM wpwq_hotel_room AS room INNER JOIN wpwq_st_hotel AS hotel ON hotel.post_id = room.room_parent WHERE CAST( room.discount_rate AS UNSIGNED ) > 0 AND room.post_id NOT IN ( SELECT room_id FROM ( SELECT od.room_id, room1.number_room, od.room_num_search, sum(od.room_num_search), cast( room1.number_room AS UNSIGNED ) FROM wpwq_st_order_item_meta AS od INNER JOIN wpwq_hotel_room AS room1 ON room1.post_id = od.room_id WHERE 1 = 1 AND ( ( check_in_timestamp <= 1656806400 AND check_out_timestamp >= 1656806400 ) OR ( check_in_timestamp >= 1656806400 AND check_in_timestamp <= 1656806400 ) ) AND od.check_out_timestamp AND `status` NOT IN ('trash', 'canceled') AND od.st_booking_post_type = 'st_hotel' GROUP BY od.room_id HAVING sum(od.room_num_search) >= cast( room1.number_room AS UNSIGNED ) ) AS room_id ) AND room.post_id NOT IN ( SELECT post_id FROM wpwq_st_availability WHERE 1 = 1 AND ( check_in >= 1656806400 AND check_out <= 1656806400 AND `status` = 'unavailable' ) AND post_type = 'hotel_room' ) ORDER BY room.discount_rate DESC LIMIT 0, 1

WordPress database error: [Column 'status' in where clause is ambiguous]
SELECT room.post_id, room.room_parent, room.discount_rate FROM wpwq_hotel_room AS room INNER JOIN wpwq_st_hotel AS hotel ON hotel.post_id = room.room_parent WHERE CAST( room.discount_rate AS UNSIGNED ) > 0 AND room.post_id NOT IN ( SELECT room_id FROM ( SELECT od.room_id, room1.number_room, od.room_num_search, sum(od.room_num_search), cast( room1.number_room AS UNSIGNED ) FROM wpwq_st_order_item_meta AS od INNER JOIN wpwq_hotel_room AS room1 ON room1.post_id = od.room_id WHERE 1 = 1 AND ( ( check_in_timestamp <= 1656892800 AND check_out_timestamp >= 1656892800 ) OR ( check_in_timestamp >= 1656892800 AND check_in_timestamp <= 1656892800 ) ) AND od.check_out_timestamp AND `status` NOT IN ('trash', 'canceled') AND od.st_booking_post_type = 'st_hotel' GROUP BY od.room_id HAVING sum(od.room_num_search) >= cast( room1.number_room AS UNSIGNED ) ) AS room_id ) AND room.post_id NOT IN ( SELECT post_id FROM wpwq_st_availability WHERE 1 = 1 AND ( check_in >= 1656892800 AND check_out <= 1656892800 AND `status` = 'unavailable' ) AND post_type = 'hotel_room' ) ORDER BY room.discount_rate DESC LIMIT 0, 1

WordPress database error: [Column 'status' in where clause is ambiguous]
SELECT room.post_id, room.room_parent, room.discount_rate FROM wpwq_hotel_room AS room INNER JOIN wpwq_st_hotel AS hotel ON hotel.post_id = room.room_parent WHERE CAST( room.discount_rate AS UNSIGNED ) > 0 AND room.post_id NOT IN ( SELECT room_id FROM ( SELECT od.room_id, room1.number_room, od.room_num_search, sum(od.room_num_search), cast( room1.number_room AS UNSIGNED ) FROM wpwq_st_order_item_meta AS od INNER JOIN wpwq_hotel_room AS room1 ON room1.post_id = od.room_id WHERE 1 = 1 AND ( ( check_in_timestamp <= 1656979200 AND check_out_timestamp >= 1656979200 ) OR ( check_in_timestamp >= 1656979200 AND check_in_timestamp <= 1656979200 ) ) AND od.check_out_timestamp AND `status` NOT IN ('trash', 'canceled') AND od.st_booking_post_type = 'st_hotel' GROUP BY od.room_id HAVING sum(od.room_num_search) >= cast( room1.number_room AS UNSIGNED ) ) AS room_id ) AND room.post_id NOT IN ( SELECT post_id FROM wpwq_st_availability WHERE 1 = 1 AND ( check_in >= 1656979200 AND check_out <= 1656979200 AND `status` = 'unavailable' ) AND post_type = 'hotel_room' ) ORDER BY room.discount_rate DESC LIMIT 0, 1

WordPress database error: [Column 'status' in where clause is ambiguous]
SELECT room.post_id, room.room_parent, room.discount_rate FROM wpwq_hotel_room AS room INNER JOIN wpwq_st_hotel AS hotel ON hotel.post_id = room.room_parent WHERE CAST( room.discount_rate AS UNSIGNED ) > 0 AND room.post_id NOT IN ( SELECT room_id FROM ( SELECT od.room_id, room1.number_room, od.room_num_search, sum(od.room_num_search), cast( room1.number_room AS UNSIGNED ) FROM wpwq_st_order_item_meta AS od INNER JOIN wpwq_hotel_room AS room1 ON room1.post_id = od.room_id WHERE 1 = 1 AND ( ( check_in_timestamp <= 1657065600 AND check_out_timestamp >= 1657065600 ) OR ( check_in_timestamp >= 1657065600 AND check_in_timestamp <= 1657065600 ) ) AND od.check_out_timestamp AND `status` NOT IN ('trash', 'canceled') AND od.st_booking_post_type = 'st_hotel' GROUP BY od.room_id HAVING sum(od.room_num_search) >= cast( room1.number_room AS UNSIGNED ) ) AS room_id ) AND room.post_id NOT IN ( SELECT post_id FROM wpwq_st_availability WHERE 1 = 1 AND ( check_in >= 1657065600 AND check_out <= 1657065600 AND `status` = 'unavailable' ) AND post_type = 'hotel_room' ) ORDER BY room.discount_rate DESC LIMIT 0, 1

WordPress database error: [Column 'status' in where clause is ambiguous]
SELECT room.post_id, room.room_parent, room.discount_rate FROM wpwq_hotel_room AS room INNER JOIN wpwq_st_hotel AS hotel ON hotel.post_id = room.room_parent WHERE CAST( room.discount_rate AS UNSIGNED ) > 0 AND room.post_id NOT IN ( SELECT room_id FROM ( SELECT od.room_id, room1.number_room, od.room_num_search, sum(od.room_num_search), cast( room1.number_room AS UNSIGNED ) FROM wpwq_st_order_item_meta AS od INNER JOIN wpwq_hotel_room AS room1 ON room1.post_id = od.room_id WHERE 1 = 1 AND ( ( check_in_timestamp <= 1657152000 AND check_out_timestamp >= 1657152000 ) OR ( check_in_timestamp >= 1657152000 AND check_in_timestamp <= 1657152000 ) ) AND od.check_out_timestamp AND `status` NOT IN ('trash', 'canceled') AND od.st_booking_post_type = 'st_hotel' GROUP BY od.room_id HAVING sum(od.room_num_search) >= cast( room1.number_room AS UNSIGNED ) ) AS room_id ) AND room.post_id NOT IN ( SELECT post_id FROM wpwq_st_availability WHERE 1 = 1 AND ( check_in >= 1657152000 AND check_out <= 1657152000 AND `status` = 'unavailable' ) AND post_type = 'hotel_room' ) ORDER BY room.discount_rate DESC LIMIT 0, 1

WordPress database error: [Column 'status' in where clause is ambiguous]
SELECT room.post_id, room.room_parent, room.discount_rate FROM wpwq_hotel_room AS room INNER JOIN wpwq_st_hotel AS hotel ON hotel.post_id = room.room_parent WHERE CAST( room.discount_rate AS UNSIGNED ) > 0 AND room.post_id NOT IN ( SELECT room_id FROM ( SELECT od.room_id, room1.number_room, od.room_num_search, sum(od.room_num_search), cast( room1.number_room AS UNSIGNED ) FROM wpwq_st_order_item_meta AS od INNER JOIN wpwq_hotel_room AS room1 ON room1.post_id = od.room_id WHERE 1 = 1 AND ( ( check_in_timestamp <= 1657238400 AND check_out_timestamp >= 1657238400 ) OR ( check_in_timestamp >= 1657238400 AND check_in_timestamp <= 1657238400 ) ) AND od.check_out_timestamp AND `status` NOT IN ('trash', 'canceled') AND od.st_booking_post_type = 'st_hotel' GROUP BY od.room_id HAVING sum(od.room_num_search) >= cast( room1.number_room AS UNSIGNED ) ) AS room_id ) AND room.post_id NOT IN ( SELECT post_id FROM wpwq_st_availability WHERE 1 = 1 AND ( check_in >= 1657238400 AND check_out <= 1657238400 AND `status` = 'unavailable' ) AND post_type = 'hotel_room' ) ORDER BY room.discount_rate DESC LIMIT 0, 1

WordPress database error: [Column 'status' in where clause is ambiguous]
SELECT room.post_id, room.room_parent, room.discount_rate FROM wpwq_hotel_room AS room INNER JOIN wpwq_st_hotel AS hotel ON hotel.post_id = room.room_parent WHERE CAST( room.discount_rate AS UNSIGNED ) > 0 AND room.post_id NOT IN ( SELECT room_id FROM ( SELECT od.room_id, room1.number_room, od.room_num_search, sum(od.room_num_search), cast( room1.number_room AS UNSIGNED ) FROM wpwq_st_order_item_meta AS od INNER JOIN wpwq_hotel_room AS room1 ON room1.post_id = od.room_id WHERE 1 = 1 AND ( ( check_in_timestamp <= 1657324800 AND check_out_timestamp >= 1657324800 ) OR ( check_in_timestamp >= 1657324800 AND check_in_timestamp <= 1657324800 ) ) AND od.check_out_timestamp AND `status` NOT IN ('trash', 'canceled') AND od.st_booking_post_type = 'st_hotel' GROUP BY od.room_id HAVING sum(od.room_num_search) >= cast( room1.number_room AS UNSIGNED ) ) AS room_id ) AND room.post_id NOT IN ( SELECT post_id FROM wpwq_st_availability WHERE 1 = 1 AND ( check_in >= 1657324800 AND check_out <= 1657324800 AND `status` = 'unavailable' ) AND post_type = 'hotel_room' ) ORDER BY room.discount_rate DESC LIMIT 0, 1

WordPress database error: [Column 'status' in where clause is ambiguous]
SELECT room.post_id, room.room_parent, room.discount_rate FROM wpwq_hotel_room AS room INNER JOIN wpwq_st_hotel AS hotel ON hotel.post_id = room.room_parent WHERE CAST( room.discount_rate AS UNSIGNED ) > 0 AND room.post_id NOT IN ( SELECT room_id FROM ( SELECT od.room_id, room1.number_room, od.room_num_search, sum(od.room_num_search), cast( room1.number_room AS UNSIGNED ) FROM wpwq_st_order_item_meta AS od INNER JOIN wpwq_hotel_room AS room1 ON room1.post_id = od.room_id WHERE 1 = 1 AND ( ( check_in_timestamp <= 1657411200 AND check_out_timestamp >= 1657411200 ) OR ( check_in_timestamp >= 1657411200 AND check_in_timestamp <= 1657411200 ) ) AND od.check_out_timestamp AND `status` NOT IN ('trash', 'canceled') AND od.st_booking_post_type = 'st_hotel' GROUP BY od.room_id HAVING sum(od.room_num_search) >= cast( room1.number_room AS UNSIGNED ) ) AS room_id ) AND room.post_id NOT IN ( SELECT post_id FROM wpwq_st_availability WHERE 1 = 1 AND ( check_in >= 1657411200 AND check_out <= 1657411200 AND `status` = 'unavailable' ) AND post_type = 'hotel_room' ) ORDER BY room.discount_rate DESC LIMIT 0, 1

WordPress database error: [Column 'status' in where clause is ambiguous]
SELECT room.post_id, room.room_parent, room.discount_rate FROM wpwq_hotel_room AS room INNER JOIN wpwq_st_hotel AS hotel ON hotel.post_id = room.room_parent WHERE CAST( room.discount_rate AS UNSIGNED ) > 0 AND room.post_id NOT IN ( SELECT room_id FROM ( SELECT od.room_id, room1.number_room, od.room_num_search, sum(od.room_num_search), cast( room1.number_room AS UNSIGNED ) FROM wpwq_st_order_item_meta AS od INNER JOIN wpwq_hotel_room AS room1 ON room1.post_id = od.room_id WHERE 1 = 1 AND ( ( check_in_timestamp <= 1657497600 AND check_out_timestamp >= 1657497600 ) OR ( check_in_timestamp >= 1657497600 AND check_in_timestamp <= 1657497600 ) ) AND od.check_out_timestamp AND `status` NOT IN ('trash', 'canceled') AND od.st_booking_post_type = 'st_hotel' GROUP BY od.room_id HAVING sum(od.room_num_search) >= cast( room1.number_room AS UNSIGNED ) ) AS room_id ) AND room.post_id NOT IN ( SELECT post_id FROM wpwq_st_availability WHERE 1 = 1 AND ( check_in >= 1657497600 AND check_out <= 1657497600 AND `status` = 'unavailable' ) AND post_type = 'hotel_room' ) ORDER BY room.discount_rate DESC LIMIT 0, 1

WordPress database error: [Column 'status' in where clause is ambiguous]
SELECT room.post_id, room.room_parent, room.discount_rate FROM wpwq_hotel_room AS room INNER JOIN wpwq_st_hotel AS hotel ON hotel.post_id = room.room_parent WHERE CAST( room.discount_rate AS UNSIGNED ) > 0 AND room.post_id NOT IN ( SELECT room_id FROM ( SELECT od.room_id, room1.number_room, od.room_num_search, sum(od.room_num_search), cast( room1.number_room AS UNSIGNED ) FROM wpwq_st_order_item_meta AS od INNER JOIN wpwq_hotel_room AS room1 ON room1.post_id = od.room_id WHERE 1 = 1 AND ( ( check_in_timestamp <= 1657584000 AND check_out_timestamp >= 1657584000 ) OR ( check_in_timestamp >= 1657584000 AND check_in_timestamp <= 1657584000 ) ) AND od.check_out_timestamp AND `status` NOT IN ('trash', 'canceled') AND od.st_booking_post_type = 'st_hotel' GROUP BY od.room_id HAVING sum(od.room_num_search) >= cast( room1.number_room AS UNSIGNED ) ) AS room_id ) AND room.post_id NOT IN ( SELECT post_id FROM wpwq_st_availability WHERE 1 = 1 AND ( check_in >= 1657584000 AND check_out <= 1657584000 AND `status` = 'unavailable' ) AND post_type = 'hotel_room' ) ORDER BY room.discount_rate DESC LIMIT 0, 1

WordPress database error: [Column 'status' in where clause is ambiguous]
SELECT room.post_id, room.room_parent, room.discount_rate FROM wpwq_hotel_room AS room INNER JOIN wpwq_st_hotel AS hotel ON hotel.post_id = room.room_parent WHERE CAST( room.discount_rate AS UNSIGNED ) > 0 AND room.post_id NOT IN ( SELECT room_id FROM ( SELECT od.room_id, room1.number_room, od.room_num_search, sum(od.room_num_search), cast( room1.number_room AS UNSIGNED ) FROM wpwq_st_order_item_meta AS od INNER JOIN wpwq_hotel_room AS room1 ON room1.post_id = od.room_id WHERE 1 = 1 AND ( ( check_in_timestamp <= 1657670400 AND check_out_timestamp >= 1657670400 ) OR ( check_in_timestamp >= 1657670400 AND check_in_timestamp <= 1657670400 ) ) AND od.check_out_timestamp AND `status` NOT IN ('trash', 'canceled') AND od.st_booking_post_type = 'st_hotel' GROUP BY od.room_id HAVING sum(od.room_num_search) >= cast( room1.number_room AS UNSIGNED ) ) AS room_id ) AND room.post_id NOT IN ( SELECT post_id FROM wpwq_st_availability WHERE 1 = 1 AND ( check_in >= 1657670400 AND check_out <= 1657670400 AND `status` = 'unavailable' ) AND post_type = 'hotel_room' ) ORDER BY room.discount_rate DESC LIMIT 0, 1

WordPress database error: [Column 'status' in where clause is ambiguous]
SELECT room.post_id, room.room_parent, room.discount_rate FROM wpwq_hotel_room AS room INNER JOIN wpwq_st_hotel AS hotel ON hotel.post_id = room.room_parent WHERE CAST( room.discount_rate AS UNSIGNED ) > 0 AND room.post_id NOT IN ( SELECT room_id FROM ( SELECT od.room_id, room1.number_room, od.room_num_search, sum(od.room_num_search), cast( room1.number_room AS UNSIGNED ) FROM wpwq_st_order_item_meta AS od INNER JOIN wpwq_hotel_room AS room1 ON room1.post_id = od.room_id WHERE 1 = 1 AND ( ( check_in_timestamp <= 1657756800 AND check_out_timestamp >= 1657756800 ) OR ( check_in_timestamp >= 1657756800 AND check_in_timestamp <= 1657756800 ) ) AND od.check_out_timestamp AND `status` NOT IN ('trash', 'canceled') AND od.st_booking_post_type = 'st_hotel' GROUP BY od.room_id HAVING sum(od.room_num_search) >= cast( room1.number_room AS UNSIGNED ) ) AS room_id ) AND room.post_id NOT IN ( SELECT post_id FROM wpwq_st_availability WHERE 1 = 1 AND ( check_in >= 1657756800 AND check_out <= 1657756800 AND `status` = 'unavailable' ) AND post_type = 'hotel_room' ) ORDER BY room.discount_rate DESC LIMIT 0, 1

WordPress database error: [Column 'status' in where clause is ambiguous]
SELECT room.post_id, room.room_parent, room.discount_rate FROM wpwq_hotel_room AS room INNER JOIN wpwq_st_hotel AS hotel ON hotel.post_id = room.room_parent WHERE CAST( room.discount_rate AS UNSIGNED ) > 0 AND room.post_id NOT IN ( SELECT room_id FROM ( SELECT od.room_id, room1.number_room, od.room_num_search, sum(od.room_num_search), cast( room1.number_room AS UNSIGNED ) FROM wpwq_st_order_item_meta AS od INNER JOIN wpwq_hotel_room AS room1 ON room1.post_id = od.room_id WHERE 1 = 1 AND ( ( check_in_timestamp <= 1657843200 AND check_out_timestamp >= 1657843200 ) OR ( check_in_timestamp >= 1657843200 AND check_in_timestamp <= 1657843200 ) ) AND od.check_out_timestamp AND `status` NOT IN ('trash', 'canceled') AND od.st_booking_post_type = 'st_hotel' GROUP BY od.room_id HAVING sum(od.room_num_search) >= cast( room1.number_room AS UNSIGNED ) ) AS room_id ) AND room.post_id NOT IN ( SELECT post_id FROM wpwq_st_availability WHERE 1 = 1 AND ( check_in >= 1657843200 AND check_out <= 1657843200 AND `status` = 'unavailable' ) AND post_type = 'hotel_room' ) ORDER BY room.discount_rate DESC LIMIT 0, 1

WordPress database error: [Column 'status' in where clause is ambiguous]
SELECT room.post_id, room.room_parent, room.discount_rate FROM wpwq_hotel_room AS room INNER JOIN wpwq_st_hotel AS hotel ON hotel.post_id = room.room_parent WHERE CAST( room.discount_rate AS UNSIGNED ) > 0 AND room.post_id NOT IN ( SELECT room_id FROM ( SELECT od.room_id, room1.number_room, od.room_num_search, sum(od.room_num_search), cast( room1.number_room AS UNSIGNED ) FROM wpwq_st_order_item_meta AS od INNER JOIN wpwq_hotel_room AS room1 ON room1.post_id = od.room_id WHERE 1 = 1 AND ( ( check_in_timestamp <= 1657843200 AND check_out_timestamp >= 1657843200 ) OR ( check_in_timestamp >= 1657843200 AND check_in_timestamp <= 1657843200 ) ) AND od.check_out_timestamp AND `status` NOT IN ('trash', 'canceled') AND od.st_booking_post_type = 'st_hotel' GROUP BY od.room_id HAVING sum(od.room_num_search) >= cast( room1.number_room AS UNSIGNED ) ) AS room_id ) AND room.post_id NOT IN ( SELECT post_id FROM wpwq_st_availability WHERE 1 = 1 AND ( check_in >= 1657843200 AND check_out <= 1657843200 AND `status` = 'unavailable' ) AND post_type = 'hotel_room' ) ORDER BY room.discount_rate DESC LIMIT 0, 1

Top Destinations

Magoroto Forest

Magoroto Forest Estate is Tanzania’s newest forest retreat situated near Muheza, Tanga about 6 hours drive from Dar es Salaam.

Saadani National Park

Saadani is where the beach meets the bush. The only wildlife sanctuary in East Africa to boast for an Indian Ocean beachfront

Serengeti National Park

The Serengeti, home to the greatest wildlife spectacle on earth - the great migration of wildebeest and zebra.

Mikumi National Park

Mikumi is Tanzania’s fourth-largest national park. It’s also the most accessible from Dar es Salaam.

Need Help? Chat with us