+91-8929175340 AI Powered Plan A Trip

SELECT pkg_id, image, title, default_img_slno, small_height, small_width, big_height, big_width FROM pkg_image WHERE pkg_id = '237917' and big_width>'350' ORDER BY main_image_status DESC

select sum(rating) as rsum, count(*) as rnum from testimonials use index (member_id) where member_id='1757884' && status='A' && tml_type IN ('D','P')

select * from package_price where price_package_id=237917

select count(*) from testimonials where member_id='1757884' && status='A' && tml_type IN ('D','P')

select c.codeID, c.zscName, c.zsc_flnm, pcc.hotspot_id from pkg_city_state_cross as pcc inner join country_tbl as c on pcc.city=c.codeID where pcc.pkg_id='237917' && pcc.status='Y'

9 Nights - 10 Days Nepal Tour Package

Gangtok - Darjeeling - Kathmandu - Pokhara - Goa City

select IF(price_currency_unit='INR',round(price_amount,0),round(price_amount*92.50,0)) pc, IF(price_currency_unit='USD',round(price_amount,0),round(price_amount/92.50,0)) pc_usd from package_price where price_package_id='237917' && price_category='101'
  • 30,000 Price (per person)
  • 10D / 9N Tour Duration
  • Budget Tour Type
Whatsapp

Package Overview

Nepal, officially the Federal Democratic Republic of Nepal, is a landlocked country in South Asia. It is mainly situated in the Himalayas, but also includes parts of the Indo-Gangetic Plain.

Contact Agent Plan A Trip Text Me

select * from toursdaystbl where tourspckgID='237917' && daysDesc!='' order by daysNo asc

Day wise Itinerary

  • Day 1 Unleash Your Wanderlust – Eat, Drink, Shop, And Make Memories At Your Own


    select m.* from daywise_keyword_master as m inner join package_daywise_highlights as h on m.slno=h.keyword_slno && h.pckg_slno='237917' && h.days_slno='1846114' && h.activeStatus='Y'

    select pc.pkg_catg_name,pc.pkg_catg_filename from pkg_category_tbl as pc inner join pkg_category_days_cross as pcc on pc.pkg_catg_id=pcc.pkg_catg_id && pcc.pkg_id='237917' && pcc.day_no='1' && pcc.cross_update_status='Y'

    select * from pkg_image where pkg_id='237917' and daynum='1'

    Your Personal Journey of Eating, Drinking, Shopping, and Making Memories On This Full Day.

    FOOD -On this Day you can explore Goa on your own by tasting local Goan Cuisine Dive into the world of flavours as you savour delectable seafood by the beach or relish traditional Goan cuisine at a local eaterie.

    SHOPPING -For those with a penchant for shopping, Goa's bustling markets are a treasure trove of souvenirs, clothing, jewellery, and crafts. Explore the bustling Anjuna Flea Market, the vibrant Mapusa Market, or the charming boutiques of Panaji.

    Goa invites you to embrace the freedom to explore and experience this coastal paradise your way. Craft your own adventure and leave with a heart full of memories and a soul renewed by the charm of Goa.

    Activities : Sightseeing

  • Day 2 Kathmandu Sightseeing & Stay


    select m.* from daywise_keyword_master as m inner join package_daywise_highlights as h on m.slno=h.keyword_slno && h.pckg_slno='237917' && h.days_slno='1846115' && h.activeStatus='Y'

    select travel_guide_flnm from country_tbl where codeID='11246'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '34862' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='34862' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (11246,11146) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='11246'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '34858' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='34858' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (11246,11146) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='11246'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '34859' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='34859' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (11246,11146) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='11246'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '38359' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='38359' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (11246,11146) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='11246'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '38360' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='38360' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (11246,11146) order by c1.city_level asc
    Pashupatinath TempleBoudhanath StupaSwayambhunath TempleKathmandu Durbar SquareHanuman Dhoka

    select pc.pkg_catg_name,pc.pkg_catg_filename from pkg_category_tbl as pc inner join pkg_category_days_cross as pcc on pc.pkg_catg_id=pcc.pkg_catg_id && pcc.pkg_id='237917' && pcc.day_no='2' && pcc.cross_update_status='Y'

    select * from pkg_image where pkg_id='237917' and daynum='2'

    select * from hotspots_images_tbl where hotspots_slno='34862' and active_status='Y'
    Pashupatinath Temple

    select * from hotspots_images_tbl where hotspots_slno='34858' and active_status='Y'
    Boudhanath Stupa

    select * from hotspots_images_tbl where hotspots_slno='34859' and active_status='Y'
    Swayambhunath Temple

    select * from hotspots_images_tbl where hotspots_slno='38359' and active_status='Y'
    Kathmandu Durbar Square

    select * from hotspots_images_tbl where hotspots_slno='38360' and active_status='Y'
    Hanuman Dhoka

    Kathmandu-

    Kathmandu, Nepal's capital, is set in a valley surrounded by the Himalayan mountains. At the heart of the old city’s mazelike alleys is Durbar Square, which becomes frenetic during Indra Jatra, a religious festival featuring masked dances. Many of the city's historic sites were damaged or destroyed by a 2015 earthquake. Durbar Square's palace, Hanuman Dhoka, and Kasthamandap, a wooden Hindu temple, are being rebuilt

    Pashupatinath Temple
    Buddha Stupa
    Swoyambhu Mahachaitya
    Kathmandu Durbar Square


    Hotel Pashupati Darshan
    Hotel Yala Peak
    Kathmandu Nomad Hotel
    Hotel Peace Mountain

    Activities : Sightseeing

  • Day 3 Pokhara Sightseeing & Stay


    select m.* from daywise_keyword_master as m inner join package_daywise_highlights as h on m.slno=h.keyword_slno && h.pckg_slno='237917' && h.days_slno='1846116' && h.activeStatus='Y'

    select travel_guide_flnm from country_tbl where codeID='11247'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '34867' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='34867' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (11247,11146) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='11247'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '34866' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='34866' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (11247,11146) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='11247'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '38383' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='38383' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (11247,11146) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='11247'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '38384' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='38384' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (11247,11146) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='11247'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '38386' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='38386' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (11247,11146) order by c1.city_level asc
    Phewa Tal (Fewa Lake)Peace TempleInternational Mountain MuseumBarahi TemplePhewa Lake

    select pc.pkg_catg_name,pc.pkg_catg_filename from pkg_category_tbl as pc inner join pkg_category_days_cross as pcc on pc.pkg_catg_id=pcc.pkg_catg_id && pcc.pkg_id='237917' && pcc.day_no='3' && pcc.cross_update_status='Y'

    select * from pkg_image where pkg_id='237917' and daynum='3'

    select * from hotspots_images_tbl where hotspots_slno='34867' and active_status='Y'
    Phewa Tal (Fewa Lake)

    select * from hotspots_images_tbl where hotspots_slno='34866' and active_status='Y'
    Peace Temple

    select * from hotspots_images_tbl where hotspots_slno='38383' and active_status='Y'
    International Mountain Museum

    select * from hotspots_images_tbl where hotspots_slno='38384' and active_status='Y'
    Barahi Temple

    select * from hotspots_images_tbl where hotspots_slno='38386' and active_status='Y'
    Phewa Lake

    Pokhara-

    Pokhara is a city on Phewa Lake, in central Nepal. It’s known as -a gateway to the Annapurna Circuit, a popular trail in the Himalayas. Tal Barahi Temple, a 2-story pagoda, sits on an island in the lake. On the eastern shore, the Lakeside district has yoga centers and restaurants. In the city’s south, the International Mountain Museum has exhibits on the history of mountaineering and the people of the Himalayas.

    Phewa Lake
    Peace Temple


    Hotel Atrium
    Gorgeous Village Guest House
    Hotel golden lake
    New Pokhara Lodge

    Activities : Sightseeing

  • Day 4 Pokhara Sightseeing & Stay


    select m.* from daywise_keyword_master as m inner join package_daywise_highlights as h on m.slno=h.keyword_slno && h.pckg_slno='237917' && h.days_slno='1846117' && h.activeStatus='Y'

    select travel_guide_flnm from country_tbl where codeID='11247'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '41010' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='41010' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (11247,11146) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='11247'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '41011' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='41011' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (11247,11146) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='11247'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '41012' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='41012' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (11247,11146) order by c1.city_level asc
    Pokhara Main MarketBat CaveSarangkot

    select pc.pkg_catg_name,pc.pkg_catg_filename from pkg_category_tbl as pc inner join pkg_category_days_cross as pcc on pc.pkg_catg_id=pcc.pkg_catg_id && pcc.pkg_id='237917' && pcc.day_no='4' && pcc.cross_update_status='Y'

    select * from pkg_image where pkg_id='237917' and daynum='4'

    select * from hotspots_images_tbl where hotspots_slno='41010' and active_status='Y'
    Pokhara Main Market

    select * from hotspots_images_tbl where hotspots_slno='41011' and active_status='Y'
    Bat Cave

    select * from hotspots_images_tbl where hotspots_slno='41012' and active_status='Y'
    Sarangkot

    After a satisfying breakfast at the hotel, you can proceed to discover the remaining enchanting sights that Pokhara has to offer. Please refer to the list below for the remaining attractions.

    Pumdikot Shiv Temple
    Pokhara Main Market
    Davi's Fall & Gupteshwar Cave
    Bat Cave
    Sarangkot
    Seti River Gorge

    Activities : Sightseeing

  • Day 5 Kathmandu Sightseeing & Stay


    select m.* from daywise_keyword_master as m inner join package_daywise_highlights as h on m.slno=h.keyword_slno && h.pckg_slno='237917' && h.days_slno='1846118' && h.activeStatus='Y'

    select travel_guide_flnm from country_tbl where codeID='11246'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '34860' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='34860' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (11246,11146) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='11246'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '38360' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='38360' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (11246,11146) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='11246'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '38363' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='38363' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (11246,11146) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='11246'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '38367' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='38367' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (11246,11146) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='11246'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '41007' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='41007' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (11246,11146) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='11246'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '41008' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='41008' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (11246,11146) order by c1.city_level asc
    Kopan MonasteryHanuman DhokaNarayanhiti PalaceNational Museum of NepalPatan Darbar SquareAsan Bazar

    select pc.pkg_catg_name,pc.pkg_catg_filename from pkg_category_tbl as pc inner join pkg_category_days_cross as pcc on pc.pkg_catg_id=pcc.pkg_catg_id && pcc.pkg_id='237917' && pcc.day_no='5' && pcc.cross_update_status='Y'

    select * from pkg_image where pkg_id='237917' and daynum='5'

    select * from hotspots_images_tbl where hotspots_slno='34860' and active_status='Y'
    Kopan Monastery

    select * from hotspots_images_tbl where hotspots_slno='38360' and active_status='Y'
    Hanuman Dhoka

    select * from hotspots_images_tbl where hotspots_slno='38363' and active_status='Y'
    Narayanhiti Palace

    select * from hotspots_images_tbl where hotspots_slno='38367' and active_status='Y'
    National Museum of Nepal

    select * from hotspots_images_tbl where hotspots_slno='41007' and active_status='Y'
    Patan Darbar Square

    select * from hotspots_images_tbl where hotspots_slno='41008' and active_status='Y'
    Asan Bazar

    After a satisfying breakfast at the hotel, you can proceed to discover the remaining enchanting sights that Delhi has to offer. Please refer to the list below for the remaining attractions-

    Hanuman Dhoka
    Asan Bazar
    Patan Darbar Square
    National Museum of Nepal
    Narayanhiti Palace Museum
    Kopan Monastery

    After concluding your sightseeing adventures, return to the hotel to relax and unwind for the remainder of the day.

    Activities : Museums

  • Day 6 Darjeeling Sightseeing & Stay


    select m.* from daywise_keyword_master as m inner join package_daywise_highlights as h on m.slno=h.keyword_slno && h.pckg_slno='237917' && h.days_slno='1846119' && h.activeStatus='Y'

    select travel_guide_flnm from country_tbl where codeID='10405'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '35139' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='35139' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (10405,101) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='10405'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '35141' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='35141' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (10405,101) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='10405'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '27568' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='27568' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (10405,101) order by c1.city_level asc
    Tiger HillPeace Pagoda, DarjeelingDarjeeling Himalayan Railway

    select pc.pkg_catg_name,pc.pkg_catg_filename from pkg_category_tbl as pc inner join pkg_category_days_cross as pcc on pc.pkg_catg_id=pcc.pkg_catg_id && pcc.pkg_id='237917' && pcc.day_no='6' && pcc.cross_update_status='Y'

    select * from pkg_image where pkg_id='237917' and daynum='6'

    select * from hotspots_images_tbl where hotspots_slno='35139' and active_status='Y'
    Tiger Hill, Darjeeling

    select * from hotspots_images_tbl where hotspots_slno='35141' and active_status='Y'
    Peace Pagoda, Darjeeling

    select * from hotspots_images_tbl where hotspots_slno='27568' and active_status='Y'

    Darjeeling is a town in the Indian state of West Bengal, located in the Lesser Himalayas. It's famous for its picturesque beauty, tea plantations, and cool climate. Darjeeling is a popular hill station and tourist destination known for its panoramic views of the Himalayan mountains, including the iconic Mount Kanchenjunga. The town is also known for its colonial-era architecture, Buddhist monasteries, and the Darjeeling Himalayan Railway, a UNESCO World Heritage Site.

    Tiger hills
    Peace pagoda


    CHAS Sanderling Hotel
    Hill Crown Retreat
    Hotel Darjeeling Palace
    Hill Crown Retreat

    Activities : Mountaineering

  • Day 7 Darjeeling Sightseeing & Stay


    select m.* from daywise_keyword_master as m inner join package_daywise_highlights as h on m.slno=h.keyword_slno && h.pckg_slno='237917' && h.days_slno='1846120' && h.activeStatus='Y'

    select travel_guide_flnm from country_tbl where codeID='10405'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '27568' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='27568' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (10405,101) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='10405'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '36221' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='36221' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (10405,101) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='10405'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '41006' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='41006' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (10405,101) order by c1.city_level asc
    Mahakal Temple, Darjeeling Batasia Eco GardenDarjeeling Himalayan RailwayMahakal TempleHimalayan Mountaineering Institute

    select pc.pkg_catg_name,pc.pkg_catg_filename from pkg_category_tbl as pc inner join pkg_category_days_cross as pcc on pc.pkg_catg_id=pcc.pkg_catg_id && pcc.pkg_id='237917' && pcc.day_no='7' && pcc.cross_update_status='Y'

    select * from pkg_image where pkg_id='237917' and daynum='7'

    select * from hotspots_images_tbl where hotspots_slno='27568' and active_status='Y'

    select * from hotspots_images_tbl where hotspots_slno='36221' and active_status='Y'
    Mahakal Temple

    select * from hotspots_images_tbl where hotspots_slno='41006' and active_status='Y'
    Himalayan Mountaineering Institute

    After a satisfying breakfast at the hotel, you can proceed to discover the remaining enchanting sights that Darjeeling has to offer. Please refer to the list below for the remaining attractions.

    Mahakal temple
    Batasia Eco Garden
    Toy train
    Himalayan Mountaineering Institutes
    After concluding your sightseeing adventures, return to the hotel to relax and unwind for the remainder of the day.

    Activities : Mountaineering , Sightseeing

  • Day 8 Gangtok Sightseeing & Stay


    select m.* from daywise_keyword_master as m inner join package_daywise_highlights as h on m.slno=h.keyword_slno && h.pckg_slno='237917' && h.days_slno='1846121' && h.activeStatus='Y'

    select travel_guide_flnm from country_tbl where codeID='10401'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '27353' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='27353' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (10401,101) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='10401'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '41004' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='41004' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (10401,101) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='10401'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '41005' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='41005' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (10401,101) order by c1.city_level asc
    Ganesh TokGangtok RopewayMG Road

    select pc.pkg_catg_name,pc.pkg_catg_filename from pkg_category_tbl as pc inner join pkg_category_days_cross as pcc on pc.pkg_catg_id=pcc.pkg_catg_id && pcc.pkg_id='237917' && pcc.day_no='8' && pcc.cross_update_status='Y'

    select * from pkg_image where pkg_id='237917' and daynum='8'

    select * from hotspots_images_tbl where hotspots_slno='27353' and active_status='Y'

    select * from hotspots_images_tbl where hotspots_slno='41004' and active_status='Y'
    Gangtok Ropeway

    select * from hotspots_images_tbl where hotspots_slno='41005' and active_status='Y'
    MG Road

    Gangtok is the capital of the mountainous northern Indian state of Sikkim. Established as a Buddhist pilgrimage site in the 1840s, the city became capital of an independent monarchy after British rule ended, but joined India in 1975. Today, it remains a Tibetan Buddhist center and a base for hikers organizing permits and transport for treks through Sikkim’s Himalayan mountain ranges.

    Ganesh Tok
    MG road
    Gangtok Ropeway


    Alpine Crest
    Alpine Crest
    Himalayan Retreat Cum Resort
    Hotel Madhawi

    Activities : Mountaineering

  • Day 9 Gangtok Sightseeing & Stay


    select m.* from daywise_keyword_master as m inner join package_daywise_highlights as h on m.slno=h.keyword_slno && h.pckg_slno='237917' && h.days_slno='1846122' && h.activeStatus='Y'

    select travel_guide_flnm from country_tbl where codeID='10401'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '27356' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='27356' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (10401,101) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='10401'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '27352' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='27352' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (10401,101) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='10401'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '41002' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='41002' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (10401,101) order by c1.city_level asc

    select travel_guide_flnm from country_tbl where codeID='10401'

    select slno, catg_url, vanity_url, flnm from hotspots_detl where slno = '41003' and activestatus='Y'

    select zsc_city, zsc_country from hotspots_detl where slno='41003' && activestatus='Y'

    select c2.codeID, c1.zsc_flnm as city_fname, c2.zsc_flnm as state_fname from country_tbl c1 inner join country_tbl c2 on c1.catgSubCode = c2.codeID where c1.codeID in (10401,101) order by c1.city_level asc
    Enchey MonasteryHanuman TokTashi View PointHimalayan Zoological park Zoo

    select pc.pkg_catg_name,pc.pkg_catg_filename from pkg_category_tbl as pc inner join pkg_category_days_cross as pcc on pc.pkg_catg_id=pcc.pkg_catg_id && pcc.pkg_id='237917' && pcc.day_no='9' && pcc.cross_update_status='Y'

    select * from pkg_image where pkg_id='237917' and daynum='9'

    select * from hotspots_images_tbl where hotspots_slno='27356' and active_status='Y'
    Enchey Monastery

    select * from hotspots_images_tbl where hotspots_slno='27352' and active_status='Y'

    select * from hotspots_images_tbl where hotspots_slno='41002' and active_status='Y'
    Tashi View Point

    select * from hotspots_images_tbl where hotspots_slno='41003' and active_status='Y'
    Himalayan Zoological park Zoo

    After a satisfying breakfast at the hotel, you can proceed to discover the remaining enchanting sights that Gangtok has to offer. Please refer to the list below for the remaining attractions.

    Rumtek Dharma Chakra Centre
    Enchey Monastery
    Hanuman Temple
    Himalayan Zoological park Zoo
    Tashi View Point
    After concluding your sightseeing adventures, return to the hotel to relax and unwind for the remainder of the day.

    Activities : Mountaineering , Sightseeing

  • Day 10 Departure -cherish The Memories


    select m.* from daywise_keyword_master as m inner join package_daywise_highlights as h on m.slno=h.keyword_slno && h.pckg_slno='237917' && h.days_slno='1846123' && h.activeStatus='Y'

    select pc.pkg_catg_name,pc.pkg_catg_filename from pkg_category_tbl as pc inner join pkg_category_days_cross as pcc on pc.pkg_catg_id=pcc.pkg_catg_id && pcc.pkg_id='237917' && pcc.day_no='10' && pcc.cross_update_status='Y'

    select * from pkg_image where pkg_id='237917' and daynum='10'

    After taking your Breakfast, complete the procedure of Hotel and pack your bags Catch your return Train/ Flight or Volvo and have a safe and Joyful return Journey.

    As your journey with us comes to an end, we extend our heartfelt gratitude for choosing us for this remarkable adventure. We hope the experiences you've collected and the memories you've woven into your heart will accompany you on your onward journey. The time has come to say goodbye to the places you've explored, the cultures you've embraced, and the stories you've lived.

    Activities : Sightseeing


select theme_id from pkg_theme_cross where pkg_id ='237917'
  • Inclusions
  • Exclusions
  • Accommodation in Standard Hotels / Similar .
  • Pickup & Drop from Airport / Railway Station & transfer to Hotel
  • 1 Room with complimentary services.
  • Meals : Breakfast Included as per the itinerary.
  • Transportation: All inter transfer & sightseeing as per Itinerary by Suitable Vehicle.
  • Sightseeing: As outlined in the Itinerary will be escorted with our representative.
  • Airfare, Train Fare, Insurance Premium etc
  • Personal expenses such as room service, internet charge, laundry, drink, fax, telephone call, optional activities, etc.
  • Gratuities, tips to guides, drivers, bellboys.
  • Goods and Services Tax.
  • Entry Fee to Any Monument, Park, Museum, Monastery or any other visiting places.
  • Any expenses incurred due to exigencies. Package is not valid for Blackout Days
  • Expenses incurred due to mishap, landslide, strikes, political unrest etc. In such cases extra will be charged as per actual Inclusions

Price & Rates

No of pax Age Limit Price per pax (Rs)
Adult Above 12 years 30000 / Adult( With Tax )
* Mentioned prices may vary depending upon date of travel, hotel availability, surge pricing and seasonal rush.

select c.zsc_tree_name from pkg_city_state_cross_start m inner join country_tbl c on c.codeID = m.city where m.pkg_id='237917' and m.city > 0

Package Start From

  • Goa City, Goa, India, Asia

select pkg_title, pkg_desc from pkg_terms_cond_tbl where pkg_id='237917'

PACKAGE COST

  • Package COST: INR Na/- (This cost is valid for today)
  • Selected Payment Mode: Online

Terms & Conditions

Payment Terms & Methods :

* 20% Advance Percentage of total booking amount

Cancellation & Refund Policy :

* Upon cancellation, refund will be made after deducting the Retention Amount.

This Tour is Offered by

Kerala Holiday Package By SSP
View Profile
0/5
  • Sector 63 Noida up, Noida Extension, Noida, Uttar Pradesh, India - 201306
  • 08047019570
  • XXXXXXXXXX@googlemail.com View Mail ID

    • select webAddress from paidservice where member_id ='1757884' && active_status='Y' && source_type='paid_mem'

About Kerala Holiday Package By SSP


SELECT travelDesc FROM travels where memberID ='1757884'

We deal in Tour Operator Services. Know more..

Contact Agent Plan A Trip Text Me

select * from testimonials where member_id='1757884' && status='A' && tml_type IN ('D','P') order by curr_date desc limit 0,3

select static_url, static_page_title, dest_loc from static_pkg_url_tbl where dest_loc IN (10401,10405,11246,11247,11555) && active_status='Y' && static_page_title!='' order by url_id desc

select comp_logo, logo_width,logo_height from travels where memberID='1757884'

select c.zscName, c.zsc_flnm from member_deals_location_city_tbl as md inner join country_tbl as c on c.codeID = md.city_id where md.member_id='1757884' && md.city_id > 0 group by c.codeID

select c.codeID, c.zscName, pcc.hotspot_id from pkg_city_state_cross as pcc inner join country_tbl as c on pcc.city=c.codeID where pcc.pkg_id='237917' && pcc.status='Y'

select capTitle from hotspots_detl where slno IN (27353,27356,27568) && activestatus='Y'

Tour Package by

Kerala Holiday Package By SSP

Member Since 2024


select count(*) as cnt from packagetbl where activeStatus='Y' and member_id='1757884'

select * from testimonials where member_id='1757884' && status='A' && tml_type IN ('D','P')
22 Months
Plan A Trip

select p.*, m.file_name, m.memberID, m.compName, m.yourName, m.paid_status, m.new_mobile_phone, m.contact_visibility_status, m.mobilePhone, m.phone, m.fax, m.memberType, i.pkg_id, i.image, i.title, i.default_img_slno from packagetbl p inner join members m on m.memberID = p.member_id and m.activeStatus in ('Y','B') left join pkg_image i on i.pkg_id = p.slno && i.main_image_status='Y' where p.member_id='1757884' and p.slno!='237917' && p.activeStatus = 'Y' group by p.slno order by p.slno desc limit 0,9

More Packages by Kerala Holiday Package By SSP


    select * from pkg_image where status='1' and pkg_id=237932 order by main_image_status desc limit 0,1
  • 5 Days Kathmandu - Pokhara Tour Package

    5 Days Kathmandu - Pokhara Tour Package


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='237932'

    select * from pkg_city_state_cross_error where pkg_id='237932' && city!=''

    Kathmandu - Pokhara

    5 Days / 4 Nights

    08047019570 Get Quote

    • select * from pkg_image where status='1' and pkg_id=237931 order by main_image_status desc limit 0,1
  • 7N 8D Varanasi - Ayodhya - Lumbini - Pokhara - Kathmandu Tour

    7N 8D Varanasi - Ayodhya - Lumbini - Pokhara - Kathmandu Tour


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='237931'

    select * from pkg_city_state_cross_error where pkg_id='237931' && city!=''

    Varanasi - Ayodhya - Kathmandu - Pokhara - Lumbini

    8 Days / 7 Nights

    08047019570 Get Quote

    • select * from pkg_image where status='1' and pkg_id=237930 order by main_image_status desc limit 0,1
  • 11N - 12D Nepal Tour Package

    11N - 12D Nepal Tour Package


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='237930'

    select * from pkg_city_state_cross_error where pkg_id='237930' && city!=''

    Prayagraj - Gorakhpur - Varanasi - Ayodhya - Kathmandu - Pokhara - Chitwan - janakpur

    12 Days / 11 Nights

    08047019570 Get Quote

    • select * from pkg_image where status='1' and pkg_id=237929 order by main_image_status desc limit 0,1
  • 6N Allahabad - Ayodhya - Varanasi - Bodhgaya - Kathmandu Tour

    6N Allahabad - Ayodhya - Varanasi - Bodhgaya - Kathmandu Tour


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='237929'

    select * from pkg_city_state_cross_error where pkg_id='237929' && city!=''

    Prayagraj - Varanasi - Bodhgaya - Ayodhya - Kathmandu

    7 Days / 6 Nights

    08047019570 Get Quote

    • select * from pkg_image where status='1' and pkg_id=237928 order by main_image_status desc limit 0,1
  • 7N Gorakhpur - Pokhara - Kathmandu - Chitwan - Janakpur Tour

    7N Gorakhpur - Pokhara - Kathmandu - Chitwan - Janakpur Tour


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='237928'

    select * from pkg_city_state_cross_error where pkg_id='237928' && city!=''

    Gorakhpur - Kathmandu - Pokhara - Chitwan - janakpur

    8 Days / 7 Nights

    08047019570 Get Quote

    • select * from pkg_image where status='1' and pkg_id=237927 order by main_image_status desc limit 0,1
  • 11N 12D Nepal Tour Package

    11N 12D Nepal Tour Package


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='237927'

    select * from pkg_city_state_cross_error where pkg_id='237927' && city!=''

    Prayagraj - Varanasi - Bodhgaya - Ayodhya - Pokhara - Chitwan - Parsa

    12 Days / 11 Nights

    08047019570 Get Quote

    • select * from pkg_image where status='1' and pkg_id=237926 order by main_image_status desc limit 0,1
  • 7D Kathmandu - Patan - Pokhara - Lumbini - Gorakhpur Tour

    7D Kathmandu - Patan - Pokhara - Lumbini - Gorakhpur Tour


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='237926'

    select * from pkg_city_state_cross_error where pkg_id='237926' && city!=''

    Gorakhpur - Kathmandu - Pokhara - Lumbini - Patan

    7 Days / 6 Nights

    08047019570 Get Quote

    • select * from pkg_image where status='1' and pkg_id=237925 order by main_image_status desc limit 0,1
  • 6 Nights Kathmandu - Pokhara - Nagarkot Tour

    6 Nights Kathmandu - Pokhara - Nagarkot Tour


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='237925'

    select * from pkg_city_state_cross_error where pkg_id='237925' && city!=''

    Kathmandu - Pokhara - Nagarkot

    7 Days / 6 Nights

    08047019570 Get Quote

    • select * from pkg_image where status='1' and pkg_id=237924 order by main_image_status desc limit 0,1
  • 5 Night 6 Days Kathmandu - Pokhara Tour

    5 Night 6 Days Kathmandu - Pokhara Tour


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='237924'

    select * from pkg_city_state_cross_error where pkg_id='237924' && city!=''

    Kathmandu - Pokhara

    6 Days / 5 Nights

    08047019570 Get Quote
http://172.31.26.90:8987/solr/ttw-package/select?q=*:*&fl=*&fq=pkg_duration_days:10&fq=pkg_duration_nights:9&fq=pkg_img_status:Y&start=0&rows=50&indent=on&wt=xml&sort=pkg_comp_status+desc,pkg_paid_status+desc,pkg_price+desc,pkg_total_inquiry+desc,pkg_total_views+desc,random_+asc&defType=edismax&group=true&group.field=member_id&group.ngroups=true
select p.*, m.file_name, m.memberID, m.compName, m.yourName, m.paid_status, m.new_mobile_phone, m.contact_visibility_status, m.mobilePhone, m.phone, m.fax, m.memberType, i.pkg_id, i.image, i.title, i.default_img_slno from packagetbl p inner join members m on m.memberID = p.member_id left join pkg_image i on i.pkg_id = p.slno && i.main_image_status='Y' where m.activeStatus IN ('Y','B') && m.test_status!='1' && p.slno IN (85518,46117,126357,17008,163316,42262,116702,129225,53499,159066,185849,145353,34048,68711,61208,26507,91460,119962,7243,24338,36751,31213,163596,43988,73231,84043,7055,97373,33279,58814,863,144166,14095,15443,37097,128066,133383,23917,33762,135666,98634,3732,59363,114798,28080,60061,54475,36526,102588,111574) group by p.slno order by FIELD(p.slno,85518,46117,126357,17008,163316,42262,116702,129225,53499,159066,185849,145353,34048,68711,61208,26507,91460,119962,7243,24338,36751,31213,163596,43988,73231,84043,7055,97373,33279,58814,863,144166,14095,15443,37097,128066,133383,23917,33762,135666,98634,3732,59363,114798,28080,60061,54475,36526,102588,111574) limit 0,9

Tour Packages for 10 Days and 9 Nights


    select * from pkg_image where status='1' and pkg_id=85518 order by main_image_status desc limit 0,1
  • Golfing Itinerary Tour

    Golfing Itinerary Tour


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='85518'

    select * from pkg_city_state_cross_error where pkg_id='85518' && city!=''

    Nairobi - Nakuru - Mombasa - Nanyuki - Naivasha

    10 Days / 9 Nights

    View Contact Get Quote

    • select * from pkg_image where status='1' and pkg_id=46117 order by main_image_status desc limit 0,1
  • South India - Kerala & Tamil nadu- 9 N/10D Tour

    South India - Kerala & Tamil nadu- 9 N/10D Tour


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='46117'

    select * from pkg_city_state_cross_error where pkg_id='46117' && city!=''

    Kovalam - Munnar - Alleppey - Madurai - Kochi - Kumarakom Thekkady

    10 Days / 9 Nights

    08049671478 Get Quote

    • select * from pkg_image where status='1' and pkg_id=126357 order by main_image_status desc limit 0,1
  • Vaishno Devi Tour & Kashmir

    Vaishno Devi Tour & Kashmir


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='126357'

    select * from pkg_city_state_cross_error where pkg_id='126357' && city!=''

    Srinagar - Anantnag - Patnitop - Jammu - Baramulla

    10 Days / 9 Nights

    View Contact Get Quote

    • select * from pkg_image where status='1' and pkg_id=17008 order by main_image_status desc limit 0,1
  • Amazing Australia Tour

    Amazing Australia Tour


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='17008'

    select * from pkg_city_state_cross_error where pkg_id='17008' && city!=''

    Sydney - Melbourne - Gold Coast - Gold Coast

    10 Days / 9 Nights

    08047016390 Get Quote

    • select * from pkg_image where status='1' and pkg_id=163316 order by main_image_status desc limit 0,1
  • Footsteps of Buddha Tour

    Footsteps of Buddha Tour


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='163316'

    select * from pkg_city_state_cross_error where pkg_id='163316' && city!=''

    New Delhi - Varanasi - Bodhgaya - Rajgir - Nalanda - Patna - Vaishali - Kushinagar ..

    10 Days / 9 Nights

    08048772512 Get Quote

    • select * from pkg_image where status='1' and pkg_id=42262 order by main_image_status desc limit 0,1
  • Australian Highlights -3N Gold Coast / 3N Cairns / 3N Sydney

    Australian Highlights -3N Gold Coast / 3N Cairns / 3N Sydney


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='42262'

    select * from pkg_city_state_cross_error where pkg_id='42262' && city!=''

    Cairns - Sydney

    10 Days / 9 Nights

    08047018993 Get Quote

    • select * from pkg_image where status='1' and pkg_id=116702 order by main_image_status desc limit 0,1
  • Kinnaur - Kaza - Spiti Romantic Package

    Kinnaur - Kaza - Spiti Romantic Package


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='116702'

    select * from pkg_city_state_cross_error where pkg_id='116702' && city!=''

    Chandigarh City - Shimla - Kinnaur - Kaza - Digboi

    10 Days / 9 Nights

    View Contact Get Quote

    • select * from pkg_image where status='1' and pkg_id=129225 order by main_image_status desc limit 0,1
  • Lakes Of Ladakh Package

    Lakes Of Ladakh Package


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='129225'

    select * from pkg_city_state_cross_error where pkg_id='129225' && city!=''

    Leh Ladakh

    10 Days / 9 Nights

    08048771260 Get Quote

    • select * from pkg_image where status='1' and pkg_id=53499 order by main_image_status desc limit 0,1
  • Ladakh Tour

    Ladakh Tour


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='53499'

    select * from pkg_city_state_cross_error where pkg_id='53499' && city!=''

    Leh Ladakh

    10 Days / 9 Nights

    08047021402 Get Quote
http://172.31.26.90:8987/solr/ttw-package/select?q=*:*&fl=*&fq=pkg_city_id:(10401+OR+10405+OR+11246+OR+11247+OR+11555)&start=0&rows=50&indent=on&wt=xml&sort=pkg_comp_status+desc,pkg_paid_status+desc,pkg_price+desc,pkg_total_inquiry+desc,pkg_total_views+desc,random_+asc&defType=edismax&group=true&group.field=member_id&group.ngroups=true
select p.*, m.file_name, m.memberID, m.compName, m.yourName, m.paid_status, m.new_mobile_phone, m.contact_visibility_status, m.mobilePhone, m.phone, m.fax, m.memberType, i.pkg_id, i.image, i.title, i.default_img_slno, i.small_height, i.small_width, i.big_height, i.big_width, p.slno, p.pckgTitle from packagetbl p inner join members m on m.memberID = p.member_id and m.activeStatus IN ('Y','B') left join pkg_image i on i.pkg_id = p.slno && i.main_image_status='Y' where p.activeStatus = 'Y' && m.test_status!='1' && p.slno IN (236828,237927,236730,236909,227883,236201,246727,238196,248159,235400,181654,254853,256628,263660,239139,241391,234564,252940,256071,267526,251391,263914,257752,200460,214618,255099,239216,253700,252373,163314,236419,250262,267083,215405,240721,207774,21117,241867,262753,218084,73134,241217,221155,234584,245161,230295,127480,255275,232930,233936) group by p.slno order by FIELD(p.slno,236828,237927,236730,236909,227883,236201,246727,238196,248159,235400,181654,254853,256628,263660,239139,241391,234564,252940,256071,267526,251391,263914,257752,200460,214618,255099,239216,253700,252373,163314,236419,250262,267083,215405,240721,207774,21117,241867,262753,218084,73134,241217,221155,234584,245161,230295,127480,255275,232930,233936) limit 0,9

Gangtok, Darjeeling, Kathmandu, Pokhara, Goa City, Ganesh Tok, Enchey Monastery, Darjeeling Himalayan Railway City Tour Package


    select * from pkg_image where status='1' and pkg_id=236828 order by main_image_status desc limit 0,1
  • 11 Nights - 12 Days Nepal Tour From Gorakhpur

    11 Nights - 12 Days Nepal Tour From Gorakhpur


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='236828'

    select * from pkg_city_state_cross_error where pkg_id='236828' && city!=''

    Prayagraj - Gorakhpur - Varanasi - Ayodhya - Kathmandu - Pokhara - Chitwan - janakpur

    12 Days / 11 Nights

    08047018023 Get Quote

    • select * from pkg_image where status='1' and pkg_id=237927 order by main_image_status desc limit 0,1
  • 11N 12D Nepal Tour Package

    11N 12D Nepal Tour Package


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='237927'

    select * from pkg_city_state_cross_error where pkg_id='237927' && city!=''

    Prayagraj - Varanasi - Bodhgaya - Ayodhya - Pokhara - Chitwan - Parsa

    12 Days / 11 Nights

    08047019570 Get Quote

    • select * from pkg_image where status='1' and pkg_id=236730 order by main_image_status desc limit 0,1
  • 11 Nights - 12 Days Nepal Tour From Gorakhpur

    11 Nights - 12 Days Nepal Tour From Gorakhpur


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='236730'

    select * from pkg_city_state_cross_error where pkg_id='236730' && city!=''

    Prayagraj - Gorakhpur - Varanasi - Ayodhya - Kathmandu - Pokhara - Chitwan - janakpur

    12 Days / 11 Nights

    08047017437 Get Quote

    • select * from pkg_image where status='1' and pkg_id=236909 order by main_image_status desc limit 0,1
  • 8D Kathmandu - Chitwan - Pokhara - Lumbini - Janakpur Tour

    8D Kathmandu - Chitwan - Pokhara - Lumbini - Janakpur Tour


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='236909'

    select * from pkg_city_state_cross_error where pkg_id='236909' && city!=''

    Kathmandu - Pokhara - Lumbini - Chitwan - janakpur

    8 Days / 7 Nights

    08047017530 Get Quote

    • select * from pkg_image where status='1' and pkg_id=227883 order by main_image_status desc limit 0,1
  • 6 Night - 7 Days Goa Tour Package

    6 Night - 7 Days Goa Tour Package


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='227883'

    select * from pkg_city_state_cross_error where pkg_id='227883' && city!=''

    Panaji - Calangute - North Goa - South Goa - Goa City

    7 Days / 6 Nights

    08047019833 Get Quote

    • select * from pkg_image where status='1' and pkg_id=236201 order by main_image_status desc limit 0,1
  • 6 Night - 7 Days Goa Tour Package

    6 Night - 7 Days Goa Tour Package


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='236201'

    select * from pkg_city_state_cross_error where pkg_id='236201' && city!=''

    Panaji - Calangute - North Goa - South Goa - Goa City

    7 Days / 6 Nights

    08047016253 Get Quote

    • select * from pkg_image where status='1' and pkg_id=238196 order by main_image_status desc limit 0,1
  • 4 Nights North Goa - South Goa - Dudhsagar Package

    4 Nights North Goa - South Goa - Dudhsagar Package


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='238196'

    select * from pkg_city_state_cross_error where pkg_id='238196' && city!=''

    Panaji - Goa City - North Goa - South Goa

    5 Days / 4 Nights

    08048428839 Get Quote

    • select * from pkg_image where status='1' and pkg_id=248159 order by main_image_status desc limit 0,1
  • 3 Night 4 Days -Goa Package

    3 Night 4 Days -Goa Package


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='248159'

    select * from pkg_city_state_cross_error where pkg_id='248159' && city!=''

    Goa City - North Goa - South Goa - Old Goa

    4 Days / 3 Nights

    View Contact Get Quote

    • select * from pkg_image where status='1' and pkg_id=235400 order by main_image_status desc limit 0,1
  • 2 Night - 3 Days Kathmandu Tour

    2 Night - 3 Days Kathmandu Tour


    select c.zscDisplayName, c.zscName, c.travel_guide_flnm, c.zsc_flnm, h.slno, h.pkg_page_filename, h.pkg_page_title from country_tbl c inner join pkg_city_state_cross cc on cc.city=c.codeID and cc.city > 0 left join hotspots_detl h on h.slno = cc.hotspot_id where cc.pkg_id='235400'

    select * from pkg_city_state_cross_error where pkg_id='235400' && city!=''

    Kathmandu

    3 Days / 2 Nights

    08048774718 Get Quote

select bp.post_title,bp.post_file_name from cblog_links_display bl inner join cblog_post bp on bl.post_id = bp.post_id where page_url = 'https://www.tourtravelworld.com/packages/9nights-10days-nepal-tour-package-237917.html?display_query=y&xdebug=y' limit 12

select f.*, fc.faq_cross_answer from mem_faq_tbl as f inner join mem_faq_cross as fc on f.faq_id=fc.faq_id && fc.ttw_url='/packages/9nights-10days-nepal-tour-package-237917.html' && f.faq_status='Y' order by fc.disp_order asc
Chat with Expert
TourTravelWorld!
We have some impressive deals for you. Which place are you planning to visit?
Today, 09:31 PM
TourTravelWorld!
Great! When are you planning to go?

Have you finalized your trip dates?
Today, 09:31 PM
TourTravelWorld!
Which city is the starting point of your travel?
Today, 09:31 PM
TourTravelWorld!
Looks great! Please share your Email id so that we can contact you.
Today, 09:31 PM
TourTravelWorld!
Please provide your contact number.
Today, 09:31 PM
TourTravelWorld!
May we know the number of travelers?
Today, 09:31 PM
TourTravelWorld!
Share your Hotel Star Preference?
Today, 09:31 PM
TourTravelWorld!
Provide your per person estimated budget for the trip.
Today, 09:31 PM
TourTravelWorld!
Your NAME would help us to serve you better.
Today, 09:31 PM
TourTravelWorld!
Enter OTP code sent on your mobile.
Today, 09:31 PM
Thank You
We have received your requirements and will get back to you shortly!
Today, 09:31 PM
Send
Send
Send
Send
Send

Powered by TourTrvelWorld

Popular Post

About the Site

Tour Packages

Popular Destination