|
<%@ 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 La Mision Mexico and rental apartment La Mision Mexico
Vacation rental in San Blas, vacation homes in San Blas Mexico, and condo rentals
San Luis Potosi Mexico homes for rent by owner, homes for rent in San Luis Potosi Mexico, rental houses in San Luis Potosi Mexico, and San Luis Potosi homes for rent by owner
Condos for rent and Valle De Bravo apartments for rent
Houses for rent Barra de Navidad Mexico, Barra de Navidad rental houses, and Barra de Navidad Mexico rent houses
Rincon de Guayabitos Mexico home rentals, homes for rent Rincon de Guayabitos, Rincon de Guayabitos rent house, and vacation homes for rent by owner Rincon de Guayabitos
House rentals in Costa Careyes and vacation rental in Costa Careyes Mexico
Ajijic Mexico vacation rental, condo rentals in Ajijic Mexico, and bed and breakfast rentals in Ajijic Mexico
Apartments for rent Los Cabos Corridor, condo rentals in Los Cabos Corridor, bed and breakfast rentals Los Cabos Corridor, and vacation homes in Los Cabos Corridor Mexico
San Blas Mexico real estate rentals and San Blas Mexico real estate rentals
Ajijic short term rentals, Ajijic Mexico apartment rentals, and apartment rentals in Ajijic Mexico
Holiday rentals, for rent by owner homes in El Placer, El Placer Mexico rent houses, and El Placer Mexico bed and breakfast rentals
La Mision Mexico rental properties and houses for rent
Apartments for rent, house rentals, and real estate rentals Punta Chivato
Apartments for rent El Placer, rental properties in El Placer Mexico, rental homes, and for rent by owner homes in El Placer Mexico
Rental home in Montecristo Estates and Montecristo Estates Mexico rental houses
Home rentals in Chapala Mexico, house rentals in Chapala Mexico, and bed and breakfast rentals Chapala Mexico
Oaxaca Mexico bed and breakfast rentals, Oaxaca Mexico vacation homes, rental houses in Oaxaca Mexico, and homes for rent by owner in Oaxaca Mexico
Vacation homes in Aticama Mexico and apartments for rent Aticama Mexico
Puerto Penasco-Rocky Point apartments for rent, apartments for rent in Puerto Penasco-Rocky Point Mexico, and Puerto Penasco-Rocky Point Mexico rent houses
Real estate rentals, rent house in Bajamar Mexico, houses for rent, and vacation homes for rent by owner in Bajamar Mexico
Rent house in Telchac Puerto Mexico and apartments for rent Telchac Puerto Mexico
For rent by owner homes in Celestun Mexico, rent houses Celestun Mexico, and Celestun rental houses
Home rentals in La Mision Mexico, vacation rental, vacation rentals in La Mision Mexico, and rental homes in La Mision 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
|
|
