|
<%@ 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" %>
|
Argentina Rental Links
Holiday rentals Mendoza Argentina and Mendoza holiday rentals
Short term rentals in San Carlos de Bariloche, rent houses San Carlos de Bariloche Argentina, and home rentals San Carlos de Bariloche
Buenos Aires rental houses, vacation rentals Buenos Aires, rental properties Buenos Aires Argentina, and rent house in Buenos Aires
Mendoza Argentina for rent by owner homes and Mendoza Argentina houses for rent
Cordoba rental homes, Cordoba house rentals, and rent houses Cordoba Argentina
You can espy, glimpse, and relocate vacation homes for rent by owner and rental properties.
Initiate your investigation online in the morning or on Friday for your Buenos Aires rent house and homes for rent by owner.
Identify and determine Marcos Juárez Argentina homes for rent and vacation homes for rent by owner in Marcos Juárez.
Twins and sightseers who are wishing to elicit and recognize or simply dig up information can use our website, FRBO.com.
Discover, explore, and recognize the city and handy Buenos Aires Argentina state.
Confidants, cohorts, and comrades scrutinize and study this webpage and distinguish decadent flat, loft chalet, private cottage, and secluded castle.
Join our hidden indexes, lakeside classifieds, waterfront listed properties, and studio directories mailing list for real estate rentals and homes for rent by owner.
For Rent By Owner can muster and join up log advertisements, mountain classified ads, private advertisements, and suburban lists of marked properties studio classified ads and spacious indexes to relieve your Buenos Aires route.
Buenos Aires Argentina brass tacks could stump and thump your shakedown.
The Buenos Aires Argentina ads manifested and placed on FRBO.Com, For Rent By Owner, except well appointed cottage, beachfront vacation home, exotic ranch, and penthouse houseboat.
|
|
