Explore the most enthralling shopping places and fantastic attractions of Bangkok & nightlife of Pattaya along with the unspoiled Coral Island, try different water sports activities like snorkeling, parasailing or swimming.
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:2024-12-12:2026-12-12' 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 ('140') )
) 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
Lahore-Islamabad -Swat -Kalam- Malamjabah-Bahrain-Summer Holiday Winter Snow fall Family Couple Tour
From PKR
One of the country’s most popular holiday spots, the area offers best trekking trails, light walks, fishing and family outings to its spectacular lakes Beautiful Valley's Swat ,Malamjabbha ,Kumrat Valley.Kalam Bahrain..
THAILAND PASS is one of the requirements Needed for Traveling to Thailand During this time Book tour we will arrange for you
4 Day Bangkok Short Tour
Day 1 Arrival In Bangkok
Pick up from Bangkok Airport and transfer to chosen hotels.17:30 Chao Phraya Dinner Cruise, our representative will pick you from the hotel lobby and proceed to Check in at River City Pier 1, Siphraya (Charoen Krung 30 Rd.). Cruise will start at 19:30, enjoy the scenic night view of Bangkok City with a taste international/Indian buffet. 21:30 Return to hotel
Day 2:Bankok Dreamworld Tour
Breakfast at hotelPick from hotel to Dream World Amusement Parka place for KIDs to explore the unlimited rides and fun. Corkscrew, Bumping Cars, Swinging Viking Boat, Rollercoaster…Enjoy Shows Hollywood Action Real live thrills and spills, Hollywood-style, with spectacular special effects!.Animals Show Visit Uncle Tom’s Farm to witness the wonderful animal show. It’s great fun & always very popular with the kids.The Colours of the World Parade Don’t miss this extravaganza! Meet your favourite cartoon characters in the spectacular Colours of the World Parade. Of course, Dreamy will be in the parade too!
Day 3 Bangkok- Safrai Tour
Breakfast at hotel08:30 -15:30 Pick up to Safari World & Marine Park.
The ultimate Safari experience features hundreds of animals from all over the world. Come face-to-face with herds of Giraffes, Zebras, Tigers, Lions and many more!!!Then continue the fun in Marine Park, to see animal shows. Bird Show, Dolphin Show, Orang Uthan boxing, Sea Lion Show, Spy war stunt show and more..Enjoy the buffet lunch A short city tour overnight at hotel.