|
<%@ 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
Apartment rentals and rental houses
Condo rentals Catemaco Mexico, rental apartment Catemaco Mexico, and Catemaco Mexico rental homes
Apartments for rent Tepoztlan Mexico, bed and breakfast rentals in Tepoztlan, rental home Tepoztlan, and condo rentals in Tepoztlan Mexico
Guanajuato for rent by owner homes and Guanajuato vacation rentals
Calafia Mexico real estate rentals, homes for rent by owner Calafia, and Calafia Mexico rental properties
Las Olas de Rosarito Mexico condo rentals, vacation rentals Las Olas de Rosarito Mexico, rental homes in Las Olas de Rosarito Mexico, and rental homes in Las Olas de Rosarito Mexico
Las Gaviotas Mexico condos for rent and holiday rentals in Las Gaviotas Mexico
Condos for rent, San Francisco-San Pancho Mexico rental houses, and San Francisco-San Pancho rental houses
Houses for rent in El Cuyo, rent houses in El Cuyo, El Cuyo Mexico rental apartment, and rental home El Cuyo Mexico
Holiday rentals and Plaza Calafia Mexico home rentals
Using FRBO.com, rental agents poll chalet, castle, and duplex lists of marked properties.
Locate and detect Akumal Mexico houses for rent and Akumal Mexico condos for rent.
Ascertain and catch condos for rent in Progreso and bed and breakfast rentals Progreso Mexico.
You can ascertain and dig up real estate rentals Baja Malibu and Baja Malibu Mexico rental apartment.
Inaugurate your inquest online in the morning or in the next few days for your Baja Malibu Mexico vacation rental and Baja Malibu home rentals.
Devise and find out Zapopan Mexico rental homes and homes for rent Zapopan.
The Baja Malibu Mexico listings registered and ticked off on this webpage comprise log ranch, beach lodge, ski in/out apartment, and rustic chalet.
The Baja Malibu suburban classifieds and log indexes for these territory can be mapped.
Vacant private hacienda and beach houseboat are handy in the near-at-hand area of Baja Malibu Mexico.
Adventurers, brides, and transmigrants who are wishing to explore, find, and come upon or simply conceive information can use FRBO.com.
See exotic classifieds, beach advertisements, and lakefront ads that rental agents and rental property owners post on this webpage.
Observe, disclose, and glimpse vacation homes for rent by owner in Sayula Mexico, vacation homes for rent by owner Sayula Mexico, and Sayula Mexico rental home.
Identify, observe, and relocate condos for rent in Hidalgo, rental apartment Hidalgo, and rental homes in Hidalgo Mexico.
Uncover, move, and relocate homes for rent by owner in Salvatierra Mexico, house rentals in Salvatierra Mexico, and homes for rent in Salvatierra Mexico.
You can inquire the romantic indexes, spacious classified ads, and rustic listed properties under vacation rental in Baja Malibu Mexico, Baja Malibu bed and breakfast rentals, and homes for rent in Baja Malibu Mexico.
Baja Malibu Mexico square employs many town home owners, land owners, home owners, and property agents.
|
|
