|
<%@ 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
Real estate rentals Jocotepec and rent house
Rental homes in Playa del Secreto Mexico, vacation homes for rent by owner Playa del Secreto, and real estate rentals in Playa del Secreto
For rent by owner homes, La Paz Mexico apartments for rent, La Paz Mexico homes for rent, and vacation homes for rent by owner La Paz Mexico
Apartments for rent in Cancun Mexico and vacation homes in Cancun
Rental properties Tankah, Tankah houses for rent, and homes for rent Tankah
Bed and breakfast rentals in Merida Mexico, Merida houses for rent, rental homes in Merida, and vacation homes Merida Mexico
House rentals El Pescadero and bed and breakfast rentals in El Pescadero
House rentals, vacation homes for rent by owner Tzintzuntzan Mexico, and Tzintzuntzan Mexico real estate rentals
Vacation rental in Los Cabos Corridor Mexico, house rentals in Los Cabos Corridor Mexico, rental homes in Los Cabos Corridor Mexico, and Los Cabos Corridor Mexico rental houses
San Carlos Mexico rental properties and condos for rent in San Carlos Mexico
Villas del Mar Mexico rental home, Villas del Mar Mexico vacation rentals, and for rent by owner homes in Villas del Mar Mexico
Condos for rent in Ensenada, apartments for rent in Ensenada Mexico, rental houses Ensenada Mexico, and rental home Ensenada
Holiday rentals Punta de Mita Mexico and condo rentals Punta de Mita
Condos for rent, Mexico City Mexico rent houses, and Mexico City Mexico bed and breakfast rentals
Apartment rentals Puerto Escondido Mexico, Puerto Escondido Mexico rent houses, Puerto Escondido vacation rental, and Puerto Escondido Mexico home rentals
El Placer holiday rentals and vacation homes
Kantenah Mexico apartment rentals, bed and breakfast rentals Kantenah, and Kantenah Mexico real estate rentals
House rentals in La Paloma Mexico, rent house in La Paloma Mexico, homes for rent in La Paloma Mexico, and real estate rentals La Paloma
For rent by owner homes and houses for rent
Los Frailes Mexico apartment rentals, vacation rental, and vacation homes for rent by owner in Los Frailes Mexico
Homes for rent by owner Playa del Secreto, Playa del Secreto Mexico real estate rentals, Playa del Secreto Mexico rental homes, and short term rentals in Playa del Secreto Mexico
Costa Careyes vacation homes for rent by owner and for rent by owner homes Costa Careyes Mexico
Homes for rent in Melaque, Melaque Mexico homes for rent by owner, and Melaque Mexico vacation rental
Troncones for rent by owner homes, rental properties Troncones, vacation rentals in Troncones Mexico, and condo rentals in Troncones
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
|
|
