SELECT t.*,t1.categoryName,t2.continentName FROM tranzy_tbl_packages t,tranzy_tbl_category t1,tranzy_tbl_continent t2 WHERE t.catId=t1.catId AND t.contId=t2.contId AND t.packageStatus='1' AND t.countryId='120' AND t1.categoryName LIKE '%Leisure%' ORDER BY t.priceperPerson ASC Tranzy Tours
About us

Leisure

Filter

Search
Sort by Destinations
Categories
  • Leisure

Leisure

Oman Tour for 7 Days

Visit: Muscat
Places: Asia
Price: USD 765 per person

More Info Book Now

Muscat with Jabal Akhdar Tour for 5 Days

Visit: Muscat
Places: Asia
Price: USD 828 per person

More Info Book Now