Hanoi
Hanoi is the capital and second-most populous city of Vietnam. The name "Hanoi" translates to "inside the river," – Hanoi is bordered by the Red and Black Rivers
SELECT NL_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM NL_postmeta price_meta2 WHERE price_meta2.post_id=NL_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2025-01-23:2027-01-23' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM NL_postmeta price_meta3 WHERE price_meta3.post_id=NL_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM NL_posts INNER JOIN NL_postmeta ON ( NL_posts.ID = NL_postmeta.post_id )
WHERE 1=1 AND (
( NL_postmeta.meta_key = 'accommodation_location_post_id' AND NL_postmeta.meta_value IN ('2101') )
) AND NL_posts.post_type = 'accommodation' AND ((NL_posts.post_status = 'publish'))
GROUP BY NL_posts.ID HAVING 1=1
ORDER BY NL_posts.post_title ASC
Unfortunately no accommodations were found.
8 DAYS – IMPRESSION OF VIETNAM
Hanoi, Ninh Binh, Ha Long Bay, Hoian, Ho Chi Minh, Mekong Delta
From
$
On this custom tailored 8 Day Impression of Vietnam itinerary, you will visit Ninh Binh, discover the breathtaking scenery of Halong Bay. Then, move to Da Nang, of the best beaches of Vietnam. Finish the trip in Ho Chi Minh and enjoy Mekong Delta.
Unfortunately no cruises were found.
