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 <= 1643328000 AND check_out_timestamp >= 1643328000 ) OR ( check_in_timestamp >= 1643328000 AND check_in_timestamp <= 1643328000 ) ) 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 >= 1643328000 AND check_out <= 1643328000 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 <= 1643414400 AND check_out_timestamp >= 1643414400 ) OR ( check_in_timestamp >= 1643414400 AND check_in_timestamp <= 1643414400 ) ) 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 >= 1643414400 AND check_out <= 1643414400 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 <= 1643500800 AND check_out_timestamp >= 1643500800 ) OR ( check_in_timestamp >= 1643500800 AND check_in_timestamp <= 1643500800 ) ) 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 >= 1643500800 AND check_out <= 1643500800 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 <= 1643587200 AND check_out_timestamp >= 1643587200 ) OR ( check_in_timestamp >= 1643587200 AND check_in_timestamp <= 1643587200 ) ) 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 >= 1643587200 AND check_out <= 1643587200 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 <= 1643673600 AND check_out_timestamp >= 1643673600 ) OR ( check_in_timestamp >= 1643673600 AND check_in_timestamp <= 1643673600 ) ) 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 >= 1643673600 AND check_out <= 1643673600 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 <= 1643760000 AND check_out_timestamp >= 1643760000 ) OR ( check_in_timestamp >= 1643760000 AND check_in_timestamp <= 1643760000 ) ) 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 >= 1643760000 AND check_out <= 1643760000 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 <= 1643846400 AND check_out_timestamp >= 1643846400 ) OR ( check_in_timestamp >= 1643846400 AND check_in_timestamp <= 1643846400 ) ) 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 >= 1643846400 AND check_out <= 1643846400 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 <= 1643932800 AND check_out_timestamp >= 1643932800 ) OR ( check_in_timestamp >= 1643932800 AND check_in_timestamp <= 1643932800 ) ) 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 >= 1643932800 AND check_out <= 1643932800 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 <= 1644019200 AND check_out_timestamp >= 1644019200 ) OR ( check_in_timestamp >= 1644019200 AND check_in_timestamp <= 1644019200 ) ) 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 >= 1644019200 AND check_out <= 1644019200 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 <= 1644105600 AND check_out_timestamp >= 1644105600 ) OR ( check_in_timestamp >= 1644105600 AND check_in_timestamp <= 1644105600 ) ) 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 >= 1644105600 AND check_out <= 1644105600 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 <= 1644192000 AND check_out_timestamp >= 1644192000 ) OR ( check_in_timestamp >= 1644192000 AND check_in_timestamp <= 1644192000 ) ) 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 >= 1644192000 AND check_out <= 1644192000 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 <= 1644278400 AND check_out_timestamp >= 1644278400 ) OR ( check_in_timestamp >= 1644278400 AND check_in_timestamp <= 1644278400 ) ) 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 >= 1644278400 AND check_out <= 1644278400 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 <= 1644364800 AND check_out_timestamp >= 1644364800 ) OR ( check_in_timestamp >= 1644364800 AND check_in_timestamp <= 1644364800 ) ) 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 >= 1644364800 AND check_out <= 1644364800 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 <= 1644451200 AND check_out_timestamp >= 1644451200 ) OR ( check_in_timestamp >= 1644451200 AND check_in_timestamp <= 1644451200 ) ) 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 >= 1644451200 AND check_out <= 1644451200 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 <= 1644537600 AND check_out_timestamp >= 1644537600 ) OR ( check_in_timestamp >= 1644537600 AND check_in_timestamp <= 1644537600 ) ) 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 >= 1644537600 AND check_out <= 1644537600 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 <= 1644624000 AND check_out_timestamp >= 1644624000 ) OR ( check_in_timestamp >= 1644624000 AND check_in_timestamp <= 1644624000 ) ) 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 >= 1644624000 AND check_out <= 1644624000 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 <= 1644624000 AND check_out_timestamp >= 1644624000 ) OR ( check_in_timestamp >= 1644624000 AND check_in_timestamp <= 1644624000 ) ) 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 >= 1644624000 AND check_out <= 1644624000 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