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 <= 1632355200 AND check_out_timestamp >= 1632355200 ) OR ( check_in_timestamp >= 1632355200 AND check_in_timestamp <= 1632355200 ) ) 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 >= 1632355200 AND check_out <= 1632355200 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 <= 1632441600 AND check_out_timestamp >= 1632441600 ) OR ( check_in_timestamp >= 1632441600 AND check_in_timestamp <= 1632441600 ) ) 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 >= 1632441600 AND check_out <= 1632441600 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 <= 1632528000 AND check_out_timestamp >= 1632528000 ) OR ( check_in_timestamp >= 1632528000 AND check_in_timestamp <= 1632528000 ) ) 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 >= 1632528000 AND check_out <= 1632528000 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 <= 1632614400 AND check_out_timestamp >= 1632614400 ) OR ( check_in_timestamp >= 1632614400 AND check_in_timestamp <= 1632614400 ) ) 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 >= 1632614400 AND check_out <= 1632614400 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 <= 1632700800 AND check_out_timestamp >= 1632700800 ) OR ( check_in_timestamp >= 1632700800 AND check_in_timestamp <= 1632700800 ) ) 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 >= 1632700800 AND check_out <= 1632700800 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 <= 1632787200 AND check_out_timestamp >= 1632787200 ) OR ( check_in_timestamp >= 1632787200 AND check_in_timestamp <= 1632787200 ) ) 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 >= 1632787200 AND check_out <= 1632787200 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 <= 1632873600 AND check_out_timestamp >= 1632873600 ) OR ( check_in_timestamp >= 1632873600 AND check_in_timestamp <= 1632873600 ) ) 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 >= 1632873600 AND check_out <= 1632873600 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 <= 1632960000 AND check_out_timestamp >= 1632960000 ) OR ( check_in_timestamp >= 1632960000 AND check_in_timestamp <= 1632960000 ) ) 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 >= 1632960000 AND check_out <= 1632960000 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 <= 1633046400 AND check_out_timestamp >= 1633046400 ) OR ( check_in_timestamp >= 1633046400 AND check_in_timestamp <= 1633046400 ) ) 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 >= 1633046400 AND check_out <= 1633046400 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 <= 1633132800 AND check_out_timestamp >= 1633132800 ) OR ( check_in_timestamp >= 1633132800 AND check_in_timestamp <= 1633132800 ) ) 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 >= 1633132800 AND check_out <= 1633132800 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 <= 1633219200 AND check_out_timestamp >= 1633219200 ) OR ( check_in_timestamp >= 1633219200 AND check_in_timestamp <= 1633219200 ) ) 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 >= 1633219200 AND check_out <= 1633219200 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 <= 1633305600 AND check_out_timestamp >= 1633305600 ) OR ( check_in_timestamp >= 1633305600 AND check_in_timestamp <= 1633305600 ) ) 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 >= 1633305600 AND check_out <= 1633305600 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 <= 1633392000 AND check_out_timestamp >= 1633392000 ) OR ( check_in_timestamp >= 1633392000 AND check_in_timestamp <= 1633392000 ) ) 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 >= 1633392000 AND check_out <= 1633392000 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 <= 1633478400 AND check_out_timestamp >= 1633478400 ) OR ( check_in_timestamp >= 1633478400 AND check_in_timestamp <= 1633478400 ) ) 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 >= 1633478400 AND check_out <= 1633478400 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 <= 1633564800 AND check_out_timestamp >= 1633564800 ) OR ( check_in_timestamp >= 1633564800 AND check_in_timestamp <= 1633564800 ) ) 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 >= 1633564800 AND check_out <= 1633564800 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 <= 1633651200 AND check_out_timestamp >= 1633651200 ) OR ( check_in_timestamp >= 1633651200 AND check_in_timestamp <= 1633651200 ) ) 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 >= 1633651200 AND check_out <= 1633651200 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 <= 1633651200 AND check_out_timestamp >= 1633651200 ) OR ( check_in_timestamp >= 1633651200 AND check_in_timestamp <= 1633651200 ) ) 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 >= 1633651200 AND check_out <= 1633651200 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