|
<%@ 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 homes Isla Mujeres Mexico and home rentals Isla Mujeres Mexico
Patzcuaro Mexico houses for rent, real estate rentals in Patzcuaro Mexico, and house rentals Patzcuaro
Houses for rent in Cancun Mexico, vacation rentals Cancun, homes for rent Cancun, and rental homes
Montecristo Estates rent house and holiday rentals Montecristo Estates Mexico
Bed and breakfast rentals Tepoztlan, Tepoztlan Mexico rental houses, and for rent by owner homes in Tepoztlan Mexico
Barra de Navidad bed and breakfast rentals, rental home, real estate rentals Barra de Navidad, and bed and breakfast rentals Barra de Navidad Mexico
Tankah vacation homes and short term rentals in Tankah Mexico
Condos for rent in Mission Viejo, Mission Viejo Mexico real estate rentals, and Mission Viejo homes for rent by owner
House rentals in Playa del Secreto Mexico, house rentals in Playa del Secreto Mexico, Playa del Secreto Mexico rent houses, and Playa del Secreto Mexico rent house
Bucerias Mexico rental properties and Bucerias Mexico homes for rent by owner
For rent by owner homes Ajijic Mexico, rental properties in Ajijic Mexico, and vacation homes in Ajijic
Zihuatanejo Mexico rental homes, rent house Zihuatanejo Mexico, vacation rentals in Zihuatanejo, and rental apartment
Home rentals in Los Cabos Corridor Mexico and bed and breakfast rentals Los Cabos Corridor Mexico
Homes for rent by owner in La Mision Mexico, condo rentals La Mision, and rent house in La Mision
Telchac Puerto Mexico house rentals, rental houses in Telchac Puerto Mexico, Telchac Puerto house rentals, and Telchac Puerto vacation homes for rent by owner
Rental home and for rent by owner homes in Jocotepec Mexico
Rental apartment Zihuatanejo, Zihuatanejo Mexico vacation homes for rent by owner, and Zihuatanejo Mexico apartments for rent
Condo rentals in Rancho Leonero Mexico, Rancho Leonero Mexico home rentals, Rancho Leonero Mexico houses for rent, and homes for rent in Rancho Leonero Mexico
Condo rentals in San Antonio Mexico and bed and breakfast rentals in San Antonio
Houses for rent in Playa Paraiso, Playa Paraiso Mexico rental houses, and for rent by owner homes Playa Paraiso Mexico
Houses for rent Los Cabos-Blanco, apartments for rent in Los Cabos-Blanco, rental properties, and home rentals in Los Cabos-Blanco Mexico
Rental properties La Paloma and vacation rental in La Paloma
Rental properties, Puerto Nuevo home rentals, and short term rentals
Homes for rent by owner in San Carlos Mexico, holiday rentals in San Carlos, vacation homes in San Carlos Mexico, and rental properties in San Carlos Mexico
Rent house Xcalak Mexico and real estate rentals Xcalak Mexico
Rental apartment La Paloma Mexico, rental homes, and short term rentals La Paloma Mexico
Rental homes in Acapulco Mexico, rental home, Acapulco vacation homes, and rental houses in Acapulco Mexico
Bed and breakfast rentals Mission Viejo Mexico and Mission Viejo vacation homes
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
|
|
