|
<%@ 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
Houses for rent in Catemaco Mexico and for rent by owner homes Catemaco Mexico
Rent house, rental homes Kantenah Mexico, and Kantenah Mexico apartment rentals
Mazatlan Mexico condo rentals, apartments for rent Mazatlan, Mazatlan Mexico condos for rent, and holiday rentals Mazatlan
Rental home in Los Cabos Corridor Mexico and house rentals Los Cabos Corridor Mexico
Costa Bella houses for rent, Costa Bella Mexico apartments for rent, and bed and breakfast rentals
Short term rentals in Chicxulub, rental homes in Chicxulub Mexico, Chicxulub Mexico rental houses, and Chicxulub Mexico condos for rent
Rental houses El Placer Mexico and homes for rent El Placer Mexico
Vacation rentals, houses for rent Isla Holbox, and Isla Holbox Mexico rent houses
Apartment rentals San Quintin Mexico, bed and breakfast rentals San Quintin, apartments for rent in San Quintin, and rent houses in San Quintin
Rental apartment Lo De Marcos and homes for rent in Lo De Marcos
Calafia Mexico houses for rent, real estate rentals in Calafia Mexico, and rental properties in Calafia
Chapala vacation homes, Chapala Mexico rent houses, Chapala Mexico vacation homes, and home rentals in Chapala Mexico
Rent houses in Montecristo Estates Mexico and rental houses in Montecristo Estates Mexico
Rent houses, Cabo San Lucas Mexico rental houses, and vacation homes for rent by owner in Cabo San Lucas
Holiday rentals Sayulita Mexico, Sayulita condos for rent, rent house, and Sayulita Mexico condo rentals
Vacation rentals in Guanajuato and for rent by owner homes in Guanajuato Mexico
Puerto Escondido Mexico vacation rental, apartment rentals in Puerto Escondido Mexico, and Puerto Escondido real estate rentals
La Ribera short term rentals, La Ribera Mexico rental homes, houses for rent La Ribera, and condos for rent
House rentals in Playa Las Tortugas-Turtle Beach Mexico and Playa Las Tortugas-Turtle Beach for rent by owner homes
Soliman Bay Mexico rental properties, Soliman Bay Mexico vacation homes for rent by owner, and vacation homes
San Jose del Cabo Mexico real estate rentals, bed and breakfast rentals in San Jose del Cabo, San Jose del Cabo Mexico vacation homes for rent by owner, and vacation rental in San Jose del Cabo
Chicxulub apartment rentals and Chicxulub vacation homes for rent by owner
Rent house Chapala, apartment rentals in Chapala Mexico, and Chapala real estate rentals
Catemaco vacation rentals, home rentals in Catemaco, real estate rentals in Catemaco Mexico, and bed and breakfast rentals Catemaco
Chicxulub Mexico condos for rent and home rentals Chicxulub
Rent house Patzcuaro Mexico, vacation rental in Patzcuaro Mexico, and rental home in Patzcuaro Mexico
San Francisco-San Pancho Mexico apartment rentals, for rent by owner homes San Francisco-San Pancho Mexico, San Francisco-San Pancho Mexico rent house, and San Francisco-San Pancho Mexico vacation homes for rent by owner
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
|
|
