<%@ page language="java" %> <%@ page import="java.util.*" %> <%@ page import="java.sql.*" %> <%@ page import="java.io.*" %> <%@ page import="tripindya.constants.*" %> <%@ page import="tripindya.util.*" %> <% Connection con=null; Statement stmt=null; PreparedStatement pstmt=null; ResultSet rs1=null; //////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////// %> A Trip To Indya - offer Incredible India, India Hotels, Packages Tours, Luxury Hotels, Five Star Hotels, Goa Hotels, Kerala Hotels, Royal Hotel Booking, Luxury Travel Tours
cheap airfare agents india
Hotels In India, Travel Agent In India, Hotel Reservation In India, Hotel Booking In India, Tour Packages of India, Vacation In India.
Honeymoon destinations agent


India Travel Agent


Exploring India . . . . . . . ,

Frank Hospitalities established in year 2002 as the best Delhi travel & Hotels Booking agents. We all are very Enthusiastic, Energetic and willing to give a different vision of travel to all our clients to experience the best and go for the best. Our management philosophy is based on a simple concept to deliver the highest level of customer services with the best possible price.

Here Nationalism reflecting the example of world’s largest democracy!

international flights booking weekend tour packages agents Ayurveda kerala tour agents
cheap airfare agents india
A Trip To Indya Packages


Goa Tour
Goa Tour

Goa Honeymoon Tour 10 Days
Culture In Goa 08 Days
Goa Beach Tour 12 Days
Goa Holiday Tour 05 Days

cheap airfare agents india


Kerala Tour
Kerala Tour

Exotic Kerala Tour 13 Days
Kerala Backwaters Tours 12 Days
Kerala Honeymoon Tour 11 Days
Kerala Houseboat Tour 05 Days
Kerala City Tour 07 Days
Culture In Kerala11 Days

cheap airfare agents india


Golden Triangle
Golden Triangle TOur

Golden Triangle Goa 13 Days
Golden Triangle Agra 07 Days
Golden Triangle Pushkar 07 Days
Golden Triangle Srinagar 10 Days

cheap airfare agents india


Rajasthan Tours
Rajasthan India Jaipur Travel Agent

Rajasthan Culture Tour 14 Days
Royal Rajasthan Tour
07 Days
Rajasthan Fort Palace 13 Days
The Heritage Rajasthan 16 Days
Rajasthan Rural Tour 10 Days
Rajasthan Camel Safari 14 Days

cheap airfare agents india


Cultural Tours
Culture Tour

Cultural In Rajasthan 16 Days
Culture In Goa 08 Days
Culture In Kerala 12 Days
Culture In India 07 Days
Culture Holiday Package 11 Days
Best India Culture Tour 15 Days

Yoga Holiday Travel Packages vacation packages agent guide cheap Flight tickets agency
honeymoon vacation packages india
air india travel tickets agents

Ayurveda day trips tour packages

romantic holidays getaways destinations breaks


tourist offices shopping centers india


More Sites
Utilize Your Vacation
Goa packages

Himachal Tour Packages

Summer Holidays In Uttaranchal

For more Packages ...

Hotels In India
Yoga Holiday Travel Packages vacation packages agent guide cheap Flight tickets agency

More Sites

Frank Hospitalities

Mice Conferences

A Trip Planner

Conference In India

Goa Holiday Packages

The Indian Tours

India Mumbai Hotel

Yoga Holiday Travel Packages vacation packages agent guide cheap Flight tickets agency
<%@ include file="../jsp/clientSearch.jsp" %>
<% int city_id=0; String city_name=null; //String city=null; try { con = DBConnection.getConnect(); //String SqlHotelSearch = "select city.city_name from city,hotel_information where city.city_name=hotel_information.city_name order by city.city_name"; //String SqlHotelSearch = "select city.city_name,city.city_id from city where exists (select hotel_information.city_name,hotel_information.hotel_id from hotel_information where city.city_name=hotel_information.city_name) order by city.city_name"; String SqlHotelSearch = "SELECT DISTINCT hotel_id, city_name FROM hotel_information GROUP BY city_name ORDER BY city_name LIMIT 0,20"; pstmt = con.prepareStatement(SqlHotelSearch); //pstmt.setString(2,city); rs1 = pstmt.executeQuery(); if(!rs1.next()) { out.println("

"); out.println("
"); out.println(""); out.println("

No Hotel found for this search criteria.

"); } else { do { city_name = rs1.getString("city_name"); //city_id = rs1.getInt("city_id"); %> <%=city_name%> | <% // } // end of if valid_type 1,2,3 }while(rs1.next()); // end of while } // end odf else } catch(Exception e) { out.println("Exception Occurred......."); out.println(e.getMessage()); } finally { DBConnection.closeResources(con,rs1,pstmt,null); } %>



Online International
Flights Booking


Sipritual Tour

Wildlife in India

Beach tour Adventure tour


Leh Ladakh Tour Ayurveda & Spa In India Train Tour In India Incentive & Conferences

India is a great location for a corporate
, incentive trip, venue to hold
a business
and More


About Us | Currency Converter | Airlines Availability | India Major Cities | Contact Us | Query | Sitemap | Email | Links

Copyright@ Frank Hospitalities all right reserved. Website Designed & Maintained by Mind Source