|
<%@ 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
Rental houses and apartments for rent in Sayulita Mexico
Progreso Mexico houses for rent, short term rentals Progreso, and vacation homes
Dolores Hidalgo Mexico homes for rent by owner, vacation homes for rent by owner in Dolores Hidalgo, houses for rent, and rent houses in Dolores Hidalgo Mexico
Home rentals Valle De Bravo Mexico and condos for rent in Valle De Bravo Mexico
Homes for rent by owner Playa del Secreto Mexico, Playa del Secreto Mexico for rent by owner homes, and Playa del Secreto holiday rentals
Rent house Alamos Mexico, vacation homes for rent by owner Alamos Mexico, Alamos rental apartment, and rental apartment in Alamos Mexico
Rental homes in Rose and Rose Mexico vacation rentals
Oaxaca vacation rentals, homes for rent by owner in Oaxaca, and rent house Oaxaca
Rental home, Ajijic rental properties, Ajijic Mexico rental houses, and short term rentals in Ajijic
Club Marena homes for rent by owner and Club Marena Mexico vacation rental
Playa Las Tortugas-Turtle Beach Mexico condos for rent, Playa Las Tortugas-Turtle Beach Mexico vacation homes for rent by owner, and home rentals in Playa Las Tortugas-Turtle Beach Mexico
La Paz short term rentals, condo rentals La Paz Mexico, bed and breakfast rentals in La Paz, and condos for rent
Rental apartment in San Pablo Etla Mexico and vacation homes for rent by owner in San Pablo Etla Mexico
La Jolla de Rosarito for rent by owner homes, rent houses in La Jolla de Rosarito Mexico, and homes for rent La Jolla de Rosarito
Rent house in Los Cabos Corridor Mexico, apartments for rent in Los Cabos Corridor, Los Cabos Corridor bed and breakfast rentals, and for rent by owner homes in Los Cabos Corridor
La Jolla de Rosarito vacation rentals and bed and breakfast rentals in La Jolla de Rosarito Mexico
Short term rentals in Los Frailes, Los Frailes Mexico apartment rentals, and real estate rentals in Los Frailes Mexico
Bacalar houses for rent, condos for rent, Bacalar Mexico rental apartment, and rental properties in Bacalar Mexico
La Cruz de Huanacaxtle vacation rental and real estate rentals La Cruz de Huanacaxtle Mexico
Short term rentals Bacalar, vacation homes Bacalar, and house rentals in Bacalar
Playa Paraiso Mexico rental homes, rental properties in Playa Paraiso, Playa Paraiso Mexico condo rentals, and home rentals in Playa Paraiso
Rental homes in La Mision and short term rentals in La Mision Mexico
Rental home Mar de Coral Mexico, Mar de Coral Mexico short term rentals, and rental properties
Rent houses in Corona Del Mar, condo rentals in Corona Del Mar Mexico, real estate rentals, and vacation homes for rent by owner Corona Del Mar Mexico
For rent by owner homes in Calafia and vacation rentals in Calafia
Punta del Burro Mexico holiday rentals, Punta del Burro Mexico for rent by owner homes, and vacation rental in Punta del Burro
Homes for rent by owner El Pescadero Mexico, El Pescadero Mexico bed and breakfast rentals, El Pescadero Mexico rental houses, and El Pescadero Mexico condos for rent
Home rentals in Cozumel Island Mexico and rental apartment Cozumel Island
La Ventana Mexico vacation rental, homes for rent by owner in La Ventana Mexico, and rental houses in La Ventana
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
|
|
