|
<%@ 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
Rent houses in Costa Careyes Mexico and Costa Careyes Mexico short term rentals
Bed and breakfast rentals in San Antonio, condo rentals in San Antonio Mexico, and San Antonio Mexico bed and breakfast rentals
Teotitlan del Valle Mexico rental apartment, Teotitlan del Valle Mexico bed and breakfast rentals, home rentals Teotitlan del Valle Mexico, and Teotitlan del Valle Mexico rent houses
Apartment rentals in San Carlos and rental homes in San Carlos Mexico
Rental homes Isla Mujeres, Isla Mujeres condo rentals, and Isla Mujeres rental home
Homes for rent by owner in Manzanillo Mexico, Manzanillo holiday rentals, Manzanillo Mexico rental home, and short term rentals in Manzanillo
Punta de Mita rental apartment and homes for rent by owner in Punta de Mita Mexico
Rent houses, rent houses Colima, and homes for rent in Colima
Bed and breakfast rentals Rose, condos for rent in Rose Mexico, condo rentals in Rose Mexico, and condos for rent
Real estate rentals San Jose del Cabo Mexico and real estate rentals in San Jose del Cabo
Bed and breakfast rentals in Puerto Vallarta Mexico, Puerto Vallarta Mexico homes for rent, and Puerto Vallarta Mexico holiday rentals
El Pescadero rental properties, condo rentals El Pescadero Mexico, El Pescadero Mexico vacation homes, and rental home El Pescadero Mexico
Short term rentals and La Ribera Mexico homes for rent by owner
Condo rentals in Bahia Kino-Kino Bay Mexico, homes for rent, and Bahia Kino-Kino Bay Mexico apartment rentals
For rent by owner homes in Guanajuato, Guanajuato bed and breakfast rentals, Guanajuato Mexico homes for rent by owner, and rental homes in Guanajuato
Rental homes Los Frailes Mexico and home rentals Los Frailes
Homes for rent by owner in Puerto Penasco-Rocky Point Mexico, rental properties Puerto Penasco-Rocky Point Mexico, and rental home in Puerto Penasco-Rocky Point
Rancho Leonero Mexico home rentals, Rancho Leonero Mexico homes for rent, for rent by owner homes in Rancho Leonero Mexico, and apartment rentals
Condo rentals in San Quintin Mexico and rental properties in San Quintin
Alamos Mexico rental properties, homes for rent in Alamos Mexico, and vacation rental in Alamos Mexico
Costa Bella Mexico for rent by owner homes, house rentals Costa Bella, Costa Bella homes for rent by owner, and Costa Bella homes for rent
Nuevo Vallarta Mexico holiday rentals and Nuevo Vallarta Mexico houses for rent
Apartment rentals Lo De Marcos Mexico, houses for rent in Lo De Marcos Mexico, and Lo De Marcos Mexico house rentals
Rental properties in Jocotepec, vacation homes, rental apartment in Jocotepec Mexico, and Jocotepec Mexico vacation rentals
Short term rentals in Mulege Mexico and short term rentals in Mulege
Rent houses in San Quintin Mexico, rental properties, and house rentals in San Quintin 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
|
|
