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 <= 1614902400 AND check_out_timestamp >= 1614902400 ) OR ( check_in_timestamp >= 1614902400 AND check_in_timestamp <= 1614902400 ) ) 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 >= 1614902400 AND check_out <= 1614902400 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 <= 1614988800 AND check_out_timestamp >= 1614988800 ) OR ( check_in_timestamp >= 1614988800 AND check_in_timestamp <= 1614988800 ) ) 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 >= 1614988800 AND check_out <= 1614988800 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 <= 1615075200 AND check_out_timestamp >= 1615075200 ) OR ( check_in_timestamp >= 1615075200 AND check_in_timestamp <= 1615075200 ) ) 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 >= 1615075200 AND check_out <= 1615075200 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 <= 1615161600 AND check_out_timestamp >= 1615161600 ) OR ( check_in_timestamp >= 1615161600 AND check_in_timestamp <= 1615161600 ) ) 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 >= 1615161600 AND check_out <= 1615161600 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 <= 1615248000 AND check_out_timestamp >= 1615248000 ) OR ( check_in_timestamp >= 1615248000 AND check_in_timestamp <= 1615248000 ) ) 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 >= 1615248000 AND check_out <= 1615248000 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 <= 1615334400 AND check_out_timestamp >= 1615334400 ) OR ( check_in_timestamp >= 1615334400 AND check_in_timestamp <= 1615334400 ) ) 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 >= 1615334400 AND check_out <= 1615334400 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 <= 1615420800 AND check_out_timestamp >= 1615420800 ) OR ( check_in_timestamp >= 1615420800 AND check_in_timestamp <= 1615420800 ) ) 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 >= 1615420800 AND check_out <= 1615420800 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 <= 1615507200 AND check_out_timestamp >= 1615507200 ) OR ( check_in_timestamp >= 1615507200 AND check_in_timestamp <= 1615507200 ) ) 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 >= 1615507200 AND check_out <= 1615507200 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 <= 1615593600 AND check_out_timestamp >= 1615593600 ) OR ( check_in_timestamp >= 1615593600 AND check_in_timestamp <= 1615593600 ) ) 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 >= 1615593600 AND check_out <= 1615593600 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 <= 1615680000 AND check_out_timestamp >= 1615680000 ) OR ( check_in_timestamp >= 1615680000 AND check_in_timestamp <= 1615680000 ) ) 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 >= 1615680000 AND check_out <= 1615680000 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 <= 1615766400 AND check_out_timestamp >= 1615766400 ) OR ( check_in_timestamp >= 1615766400 AND check_in_timestamp <= 1615766400 ) ) 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 >= 1615766400 AND check_out <= 1615766400 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 <= 1615852800 AND check_out_timestamp >= 1615852800 ) OR ( check_in_timestamp >= 1615852800 AND check_in_timestamp <= 1615852800 ) ) 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 >= 1615852800 AND check_out <= 1615852800 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 <= 1615939200 AND check_out_timestamp >= 1615939200 ) OR ( check_in_timestamp >= 1615939200 AND check_in_timestamp <= 1615939200 ) ) 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 >= 1615939200 AND check_out <= 1615939200 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 <= 1616025600 AND check_out_timestamp >= 1616025600 ) OR ( check_in_timestamp >= 1616025600 AND check_in_timestamp <= 1616025600 ) ) 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 >= 1616025600 AND check_out <= 1616025600 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 <= 1616112000 AND check_out_timestamp >= 1616112000 ) OR ( check_in_timestamp >= 1616112000 AND check_in_timestamp <= 1616112000 ) ) 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 >= 1616112000 AND check_out <= 1616112000 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 <= 1616198400 AND check_out_timestamp >= 1616198400 ) OR ( check_in_timestamp >= 1616198400 AND check_in_timestamp <= 1616198400 ) ) 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 >= 1616198400 AND check_out <= 1616198400 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 <= 1616198400 AND check_out_timestamp >= 1616198400 ) OR ( check_in_timestamp >= 1616198400 AND check_in_timestamp <= 1616198400 ) ) 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 >= 1616198400 AND check_out <= 1616198400 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