|
<%@ 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
Condos for rent in Chacala Mexico and Chacala homes for rent
Homes for rent in Puerto Aventuras, homes for rent in Puerto Aventuras, and house rentals in Puerto Aventuras Mexico
Real estate rentals, Las Gaviotas condo rentals, Las Gaviotas Mexico rent houses, and rent houses Las Gaviotas
Vacation rental in Cuernavaca and Cuernavaca Mexico house rentals
Rent house in Merida Mexico, Merida Mexico apartments for rent, and house rentals in Merida Mexico
Condos for rent, rental apartment in Soliman Bay, apartments for rent in Soliman Bay Mexico, and holiday rentals
Rental apartment and Progreso apartments for rent
Apartment rentals in Punta Esmeralda, vacation homes for rent by owner in Punta Esmeralda, and Punta Esmeralda Mexico for rent by owner homes
Holiday rentals in Zihuatanejo Mexico, real estate rentals Zihuatanejo Mexico, real estate rentals in Zihuatanejo, and houses for rent in Zihuatanejo Mexico
Rental apartment in Ixtapa Mexico and vacation homes Ixtapa Mexico
House rentals in Morelia, rental houses in Morelia Mexico, and Morelia house rentals
Tulum house rentals, vacation rentals Tulum Mexico, Tulum Mexico homes for rent by owner, and rental home Tulum Mexico
For rent by owner homes in Baja del Mar Mexico and home rentals in Baja del Mar Mexico
Apartment rentals in Corona Del Mar Mexico, house rentals Corona Del Mar Mexico, and Corona Del Mar Mexico vacation rentals
Colima holiday rentals, Colima houses for rent, houses for rent Colima, and rental houses in Colima
House rentals in Punta del Burro Mexico and Punta del Burro Mexico rental properties
Homes for rent by owner Tankah Mexico, Tankah homes for rent, and Tankah vacation rental
Rental homes in La Ribera Mexico, home rentals La Ribera Mexico, apartment rentals La Ribera Mexico, and vacation homes
Bed and breakfast rentals in Chacala Mexico and Chacala bed and breakfast rentals
Chicxulub Mexico house rentals, Chicxulub Mexico homes for rent by owner, and Chicxulub rent houses
Bed and breakfast rentals, homes for rent by owner, Ixtapa Mexico holiday rentals, and holiday rentals in Ixtapa Mexico
Tepoztlan Mexico home rentals and Tepoztlan Mexico apartments for rent
Rental properties Club Marena Mexico, bed and breakfast rentals in Club Marena, and rental properties in Club Marena Mexico
Rental apartment in Barra de Navidad Mexico, rent houses Barra de Navidad Mexico, Barra de Navidad Mexico rental houses, and Barra de Navidad for rent by owner homes
San Antonio del Mar Mexico rent house and San Antonio del Mar Mexico houses for rent
Guadalajara homes for rent, condo rentals in Guadalajara Mexico, and Guadalajara Mexico apartment rentals
Homes for rent La Jolla de Rosarito Mexico, rent house in La Jolla de Rosarito, condos for rent, and vacation homes for rent by owner in La Jolla de Rosarito Mexico
Real estate rentals and Dolores Hidalgo Mexico vacation homes
Aticama Mexico apartment rentals, Aticama Mexico apartment rentals, and Aticama Mexico vacation homes for rent by owner
Real estate rentals in San Francisco-San Pancho Mexico, rental properties in San Francisco-San Pancho Mexico, rent houses, and homes for rent by owner in San Francisco-San Pancho
#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
|
|
