|
<%@ 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
Bed and breakfast rentals Isla Navidad Mexico and homes for rent by owner Isla Navidad
Valle De Bravo Mexico vacation homes, houses for rent Valle De Bravo, and apartment rentals in Valle De Bravo Mexico
Homes for rent, El Pescadero Mexico home rentals, home rentals in El Pescadero Mexico, and El Pescadero homes for rent
Rental home and rental houses
Bed and breakfast rentals in Puerto Morelos Mexico, rent houses in Puerto Morelos Mexico, and holiday rentals in Puerto Morelos
House rentals, homes for rent Rincon de Guayabitos, home rentals in Rincon de Guayabitos Mexico, and Rincon de Guayabitos Mexico short term rentals
Manzanillo Mexico vacation rental and condo rentals Manzanillo
Punta de Mita Mexico apartments for rent, Punta de Mita Mexico vacation homes, and Punta de Mita Mexico rental houses
Rent house in Tzintzuntzan Mexico, vacation rentals in Tzintzuntzan Mexico, rental houses, and Tzintzuntzan Mexico homes for rent
Rental home Baja Malibu Mexico and homes for rent Baja Malibu Mexico
Chacala Mexico rental houses, vacation homes for rent by owner, and rental houses in Chacala Mexico
Holiday rentals Teotitlan del Valle Mexico, real estate rentals in Teotitlan del Valle Mexico, rental homes in Teotitlan del Valle Mexico, and homes for rent by owner in Teotitlan del Valle Mexico
Bahia Kino-Kino Bay rental properties and Bahia Kino-Kino Bay Mexico bed and breakfast rentals
Cuernavaca Mexico vacation rental, Cuernavaca Mexico for rent by owner homes, and Cuernavaca rental apartment
House rentals Playas de Tijuana Coronado Mexico, holiday rentals in Playas de Tijuana Coronado Mexico, Playas de Tijuana Coronado Mexico rental home, and apartment rentals Playas de Tijuana Coronado Mexico
Rental properties in Puerto Vallarta Mexico and rent house Puerto Vallarta
Apartments for rent Manzanillo, short term rentals Manzanillo Mexico, and Manzanillo Mexico rental houses
Rental houses Mazatlan Mexico, homes for rent Mazatlan Mexico, rental houses in Mazatlan Mexico, and for rent by owner homes in Mazatlan
Guanajuato apartment rentals and Guanajuato Mexico rent houses
Homes for rent in San Miguel de Allende Mexico, San Miguel de Allende vacation homes for rent by owner, and vacation rentals in San Miguel de Allende Mexico
Rental houses, home rentals, Telchac Puerto Mexico bed and breakfast rentals, and Telchac Puerto vacation homes for rent by owner
Vacation rental in Jocotepec Mexico and rental homes in Jocotepec Mexico
Huatulco apartments for rent, condo rentals, and vacation homes for rent by owner Huatulco
#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
|
|
