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 <= 1624060800 AND check_out_timestamp >= 1624060800 ) OR ( check_in_timestamp >= 1624060800 AND check_in_timestamp <= 1624060800 ) ) 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 >= 1624060800 AND check_out <= 1624060800 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 <= 1624147200 AND check_out_timestamp >= 1624147200 ) OR ( check_in_timestamp >= 1624147200 AND check_in_timestamp <= 1624147200 ) ) 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 >= 1624147200 AND check_out <= 1624147200 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 <= 1624233600 AND check_out_timestamp >= 1624233600 ) OR ( check_in_timestamp >= 1624233600 AND check_in_timestamp <= 1624233600 ) ) 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 >= 1624233600 AND check_out <= 1624233600 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 <= 1624320000 AND check_out_timestamp >= 1624320000 ) OR ( check_in_timestamp >= 1624320000 AND check_in_timestamp <= 1624320000 ) ) 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 >= 1624320000 AND check_out <= 1624320000 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 <= 1624406400 AND check_out_timestamp >= 1624406400 ) OR ( check_in_timestamp >= 1624406400 AND check_in_timestamp <= 1624406400 ) ) 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 >= 1624406400 AND check_out <= 1624406400 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 <= 1624492800 AND check_out_timestamp >= 1624492800 ) OR ( check_in_timestamp >= 1624492800 AND check_in_timestamp <= 1624492800 ) ) 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 >= 1624492800 AND check_out <= 1624492800 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 <= 1624579200 AND check_out_timestamp >= 1624579200 ) OR ( check_in_timestamp >= 1624579200 AND check_in_timestamp <= 1624579200 ) ) 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 >= 1624579200 AND check_out <= 1624579200 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 <= 1624665600 AND check_out_timestamp >= 1624665600 ) OR ( check_in_timestamp >= 1624665600 AND check_in_timestamp <= 1624665600 ) ) 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 >= 1624665600 AND check_out <= 1624665600 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 <= 1624752000 AND check_out_timestamp >= 1624752000 ) OR ( check_in_timestamp >= 1624752000 AND check_in_timestamp <= 1624752000 ) ) 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 >= 1624752000 AND check_out <= 1624752000 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 <= 1624838400 AND check_out_timestamp >= 1624838400 ) OR ( check_in_timestamp >= 1624838400 AND check_in_timestamp <= 1624838400 ) ) 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 >= 1624838400 AND check_out <= 1624838400 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 <= 1624924800 AND check_out_timestamp >= 1624924800 ) OR ( check_in_timestamp >= 1624924800 AND check_in_timestamp <= 1624924800 ) ) 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 >= 1624924800 AND check_out <= 1624924800 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 <= 1625011200 AND check_out_timestamp >= 1625011200 ) OR ( check_in_timestamp >= 1625011200 AND check_in_timestamp <= 1625011200 ) ) 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 >= 1625011200 AND check_out <= 1625011200 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 <= 1625097600 AND check_out_timestamp >= 1625097600 ) OR ( check_in_timestamp >= 1625097600 AND check_in_timestamp <= 1625097600 ) ) 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 >= 1625097600 AND check_out <= 1625097600 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 <= 1625184000 AND check_out_timestamp >= 1625184000 ) OR ( check_in_timestamp >= 1625184000 AND check_in_timestamp <= 1625184000 ) ) 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 >= 1625184000 AND check_out <= 1625184000 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 <= 1625270400 AND check_out_timestamp >= 1625270400 ) OR ( check_in_timestamp >= 1625270400 AND check_in_timestamp <= 1625270400 ) ) 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 >= 1625270400 AND check_out <= 1625270400 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 <= 1625356800 AND check_out_timestamp >= 1625356800 ) OR ( check_in_timestamp >= 1625356800 AND check_in_timestamp <= 1625356800 ) ) 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 >= 1625356800 AND check_out <= 1625356800 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 <= 1625356800 AND check_out_timestamp >= 1625356800 ) OR ( check_in_timestamp >= 1625356800 AND check_in_timestamp <= 1625356800 ) ) 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 >= 1625356800 AND check_out <= 1625356800 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