|
<%@ 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
Condo rentals in Playa del Secreto Mexico and Playa del Secreto condo rentals
Rent houses Chapala, rental houses in Chapala Mexico, and home rentals Chapala Mexico
For rent by owner homes in Puerto Vallarta Mexico, condo rentals Puerto Vallarta, rental home in Puerto Vallarta Mexico, and condos for rent
Vacation homes in Catemaco Mexico and Catemaco apartment rentals
Homes for rent by owner Rincon de Guayabitos, Rincon de Guayabitos Mexico bed and breakfast rentals, and condos for rent
Bacalar apartments for rent, rental properties, apartment rentals in Bacalar, and rental homes Bacalar Mexico
Baja del Mar Mexico holiday rentals and short term rentals in Baja del Mar Mexico
Condo rentals Nuevo Vallarta Mexico, bed and breakfast rentals in Nuevo Vallarta Mexico, and apartment rentals in Nuevo Vallarta Mexico
Holiday rentals El Cuyo Mexico, El Cuyo Mexico rental houses, home rentals in El Cuyo Mexico, and for rent by owner homes in El Cuyo Mexico
Bajamar Mexico home rentals and house rentals in Bajamar Mexico
Distinguish and ferret out homes for rent by owner Zacatecas Mexico and Zacatecas Mexico house rentals.
See beach classifieds and lake ads that land owners and agents post on this extensive website, FRBO.com.
La Manzanilla condo owners and real estate investors list vacation homes, La Manzanilla Mexico bed and breakfast rentals, home rentals in La Manzanilla Mexico, and La Manzanilla Mexico apartment rentals.
Join our studio listed properties, log listed properties, and beach classifieds mailing list for rental properties in La Manzanilla, La Manzanilla rental apartment, and La Manzanilla Mexico apartment rentals.
Determine, catch, and come upon homes for rent by owner in Reynosa Mexico, rental homes, and houses for rent.
The La Manzanilla Mexico directories set down and specialized on our page consist of romantic home, waterfront vacation home, mountain farmhouse, and well appointed hacienda.
Better halves and sisters-in-law who are looking for La Manzanilla holiday rentals and are trying to find out La Manzanilla Mexico rent houses, holiday rentals in La Manzanilla Mexico, and vacation rental in La Manzanilla Mexico can investigate our webpage and our convenient listings, suburban directories, mountain directories, and loft online MLS.
Find and relocate for rent by owner homes in Guanajuato Mexico and condo rentals in Guanajuato Mexico.
|
|
