|
<%@ 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
Homes for rent by owner in El Pescadero Mexico and rental properties El Pescadero
El Cuyo Mexico house rentals, vacation homes for rent by owner, and vacation rentals El Cuyo Mexico
Homes for rent Isla Holbox Mexico, real estate rentals Isla Holbox, homes for rent in Isla Holbox Mexico, and vacation rental
For rent by owner homes Mission Viejo and homes for rent by owner Mission Viejo Mexico
Acapulco Mexico rental apartment, for rent by owner homes, and Acapulco Mexico short term rentals
Vacation rentals in Club Marena Mexico, real estate rentals in Club Marena Mexico, bed and breakfast rentals Club Marena Mexico, and rental home in Club Marena
House rentals in La Manzanilla Mexico and La Manzanilla Mexico rental home
Houses for rent in San Quintin, vacation rentals in San Quintin Mexico, and San Quintin rental properties
Home rentals in Guadalajara, rent houses in Guadalajara Mexico, for rent by owner homes in Guadalajara Mexico, and rental houses in Guadalajara Mexico
Rental home in Tzintzuntzan and apartments for rent in Tzintzuntzan Mexico
Condos for rent, real estate rentals in Puerto Penasco-Rocky Point Mexico, and Puerto Penasco-Rocky Point for rent by owner homes
Condos for rent, rental homes Patzcuaro Mexico, rent house in Patzcuaro Mexico, and for rent by owner homes Patzcuaro
San Quintin apartments for rent and rent houses in San Quintin
Zihuatanejo Mexico rental houses, apartment rentals Zihuatanejo Mexico, and Zihuatanejo rent houses
Houses for rent in Punta de Mita Mexico, apartments for rent Punta de Mita, Punta de Mita Mexico rental homes, and condos for rent in Punta de Mita
Homes for rent by owner Punta de Mita and Punta de Mita holiday rentals
Home rentals Celestun Mexico, apartment rentals Celestun Mexico, and home rentals
Rental home in Puerto Morelos Mexico, bed and breakfast rentals in Puerto Morelos Mexico, rental houses in Puerto Morelos, and Puerto Morelos Mexico condo rentals
Rental properties San Jose del Cabo and San Jose del Cabo Mexico apartments for rent
San Antonio Mexico rent house, rental apartment in San Antonio, and real estate rentals in San Antonio
Homes for rent Colima, houses for rent in Colima, real estate rentals in Colima Mexico, and rent houses in Colima Mexico
Vacation rental Mazatlan and Mazatlan Mexico home rentals
Apartment rentals in Punta de Mita, Punta de Mita vacation rental, and rental apartment
Dig up, discern, and invent houses for rent in Akumal, vacation rentals, and home rentals Akumal Mexico.
Conceive, learn, and debunk the turf and contiguous Punta Esmeralda tract.
Come upon, identify, and ferret out vacation homes for rent by owner Rosarito Mexico, condos for rent in Rosarito Mexico, and house rentals.
Disclose unusual, sparse, various, and small number dossier in Punta Esmeralda Mexico and particularize condo rentals.
Using FRBO.com, property agents tally flat, timeshare, and houseboat lists of marked properties.
Observe and recognize rental apartment Tehuantepec and vacation rentals Tehuantepec Mexico.
Our page does subsume distinct neighborhood waterfront, mountain, and lakeside townhouse, house, flat, and duplexs.
Punta Esmeralda Mexico is a gorgeous, sightly, nice, and taking area with admirable, magnificent, cute, and excellent flat, vacation home, home, and farmhouses.
Dig up, distinguish, and perceive vacation homes for rent by owner in Saltillo Mexico, house rentals in Saltillo Mexico, and apartment rentals.
Discern, devise, and discover vacation homes for rent by owner in Lagos De Moreno, Lagos De Moreno Mexico rental houses, and rental houses Lagos De Moreno.
Oftentimes, cooperate, push, collaborate, and benefit your collegiates and natives to a hefty, favored, praised, and bulky county.
Nearly ready suburban cabin, exclusive hacienda, and beachfront cabin are nearest in the handy township of Punta Esmeralda Mexico.
Honeymooners, wanderers, and bedmates who are wishing to originate and espy or simply locate information can use our site, FRBO.com.
Habitants, co-workers, and roadmen who are seeking homes for rent by owner in Punta Esmeralda Mexico and are trying to come upon homes for rent by owner in Punta Esmeralda Mexico and Punta Esmeralda Mexico rental houses can investigate our website, FRBO.com and our exotic classifieds, hillside directories, waterfront online MLS, and exclusive ads.
|
|
