|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Mexico Rental Links
Vacation rentals in Akumal Mexico and apartment rentals in Akumal Mexico
Vacation rental in Tepoztlan Mexico, Tepoztlan Mexico homes for rent, and Tepoztlan Mexico apartment rentals
Ajijic holiday rentals, Ajijic Mexico rental homes, Ajijic Mexico holiday rentals, and Ajijic Mexico rent houses
Alamos Mexico house rentals and condos for rent in Alamos Mexico
Rental apartment Punta Banda Mexico, rent houses in Punta Banda Mexico, and rental houses
Los Cabos-Blanco Mexico vacation rentals, rental houses in Los Cabos-Blanco Mexico, Los Cabos-Blanco Mexico rental properties, and rent house in Los Cabos-Blanco
Bed and breakfast rentals and apartments for rent Las Gaviotas
Holiday rentals in Isla Mujeres Mexico, Isla Mujeres Mexico vacation homes, and rental properties
Zihuatanejo Mexico house rentals, Zihuatanejo Mexico homes for rent, Zihuatanejo Mexico rental apartment, and apartment rentals in Zihuatanejo
Mission Viejo Mexico bed and breakfast rentals and bed and breakfast rentals in Mission Viejo Mexico
House rentals in Ajijic Mexico, Ajijic vacation homes, and house rentals in Ajijic Mexico
Rincon de Guayabitos Mexico rental apartment, Rincon de Guayabitos Mexico vacation rental, Rincon de Guayabitos rental houses, and Rincon de Guayabitos Mexico vacation rentals
For rent by owner homes Manzanillo and Manzanillo Mexico rental home
Rental properties Puerto Vallarta Mexico, home rentals Puerto Vallarta, and rental home in Puerto Vallarta Mexico
Nuevo Vallarta rental houses, rental apartment in Nuevo Vallarta, house rentals Nuevo Vallarta, and Nuevo Vallarta Mexico condo rentals
Homes for rent Tepoztlan Mexico and vacation homes for rent by owner in Tepoztlan Mexico
Puerto Vallarta Mexico rent houses, Puerto Vallarta Mexico bed and breakfast rentals, and houses for rent in Puerto Vallarta
Real estate rentals, Chicxulub Mexico rental apartment, rental apartment, and Chicxulub holiday rentals
Rent house in Huatulco and home rentals in Huatulco Mexico
Condo rentals, apartments for rent in Huatulco Mexico, and rental home Huatulco Mexico
Condo rentals in Alamos Mexico, bed and breakfast rentals Alamos Mexico, Alamos Mexico short term rentals, and for rent by owner homes Alamos Mexico
Condo rentals in Valle De Bravo Mexico and Valle De Bravo Mexico short term rentals
Vacation homes for rent by owner in Cuernavaca Mexico, Cuernavaca rental homes, and Cuernavaca Mexico short term rentals
Rental apartment Barra de Navidad, Barra de Navidad Mexico vacation homes, rent houses in Barra de Navidad Mexico, and home rentals in Barra de Navidad
Short term rentals San Pablo Etla Mexico and homes for rent by owner San Pablo Etla Mexico
Los Barriles Mexico rental home, Los Barriles Mexico for rent by owner homes, and houses for rent
Vacation homes in Queretaro Mexico, Queretaro for rent by owner homes, vacation rental in Queretaro, and Queretaro vacation homes for rent by owner
House rentals in Chapala Mexico and rental houses in Chapala Mexico
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
|
|
