Vietnam a beautiful country with many enjoyable destinations.It seems that all that beautiful things are gathered on Tet Holiday.famous breath-taking landscapes, amazing place that you should not miss in your wish
SELECT wp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_postmeta price_meta2 WHERE price_meta2.post_id=wp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2023-06-04:2025-06-04' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_postmeta price_meta3 WHERE price_meta3.post_id=wp_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'accommodation_location_post_id' AND wp_postmeta.meta_value IN ('10852') )
) AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_posts.post_title ASC
Unfortunately no accommodations were found.
Unfortunately no tours were found.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.
Tour Highlighted : Arrival In Vietnam-
7 Day Best Explore Vietnam Tour Details
DAY 1. ARRIVAL – HANOI CITY TOUR (-)
Arriving in Hanoi and explore the Old District, Hoan Kiem: its old 36 streets corporation & also the Lake of the Restored Sword, through a unique walking tour.
DAY 2. HANOI – HALONG, Overnight cruise (B, L, D)
Transfer to Halong Bay, one unique sightseeing in the world classified at UNESCO. Exploration of Lan Ha – less crowed than Cat Ba – its emerald waters and thousands of towering limestone islands. Overnight cruise.
DAY 3. HALONG – NOI BAI AIRPORT – HUE (B)
Wake up with a beautiful panorama to enjoy morning activities on board. The, transfer to Noi Bai Airport to fly for Hue, the seat of Nguyen Dynasty emperors and national capital until 1945.
DAY 4. HUE, Full day sightseeing (B)
Full day sightseeing between culture (with the Pagoda of the Celestial Lady along the Perfume River), history (with the Citadel), & assist to sunset on the lake in eating fresh fish & shrimps.
DAY 5. HUE – DANANG – HOI AN (B)
Transfer by car & superb spots for photo shoots on the way: lagoons, turquoise sea, Hai Van (the Cloud Pass)… & first exploration of the romantic Hoi An.
DAY 6. HOI AN – Full day sightseeing – Romantic Dinner on a Raft (B)
Exploration of the charming city & a unique itinerary that we designed to experience taste of Hoi An Old district. Private romantic dinner on a raft or among rice fields.