Visa Query

Services

Name

Email

Mobile No.

Origin Country Visa Country

Message

Captcha

Confirmation I agree to Chalsafar World Tours Private Limited T & C

Print/View Voucher

Ticket Cancellation

 
Chalsafar World Tours  Private Limited Logo
SELECT r.starting_from,d.dest_name FROM travshop_datab.promoter_packages p LEFT JOIN travshop_datab.promoter_price r ON p.id=r.package_id LEFT JOIN travshop_datab.hb_destinations d ON d.id=r.starting_from WHERE  r.psort='Y' AND r.date_to  >='2023-09-26' AND p.id IN (4,8,22,23,49,54,104,127,241,242,243,280,299,323,339,352,353,370,384,460,480,617,651,695,696,697,698,699,700,701,0,803,0,879,932,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1012,1570,1571,1572,1584,1626,1787,1818,1861,1889,1913,1920,1978,1977,2036,2057,2139,2240,2241,2348,2352,2478,2502,2503,2504,2506,2594,2614,2615,2655,2716,2884,2867,2885,2905,2906,3009,3193,3210,3218,3247,3248,3250,3251,3315,3399,3119,3621,3643,3679,3681,3869,3845) GROUP BY p.id
Change Destination

India Holiday Destination

Cancel

Select the latest package

These are some of our curated packages - designed for the smart traveller in you

End of packages

Deals Holiday Package

Quick Contact

Name

Email

Mobile No.

Message

Captcha
1 2 8 6 1 8

Confirmation I agree to Chalsafar World Tours Private Limited T & C