|
<%@ 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" %>
|
Italy Rental Links
Short term rentals Forio D ischia Italy and Forio D ischia Italy vacation homes
Rent house in Polignano A Mare, rent houses in Polignano A Mare, and vacation rental
Cremia Italy rental homes, holiday rentals Cremia Italy, vacation homes, and holiday rentals Cremia Italy
Rent house in Chiusi Italy and condo rentals in Chiusi
Vacation homes in Turin-Torino, Turin-Torino Italy for rent by owner homes, and Turin-Torino Italy rental houses
Apartment rentals in Bracciano, Bracciano Italy rent house, Bracciano Italy vacation homes, and apartments for rent Bracciano Italy
Rental houses Pariana Italy and apartments for rent in Pariana
Home rentals in Allesino Italy, rent houses in Allesino, and Allesino houses for rent
Holiday rentals Amandola, Amandola Italy house rentals, Amandola Italy vacation homes, and Amandola vacation homes
Homes for rent by owner Marina di Pietrasanta Italy and rental houses in Marina di Pietrasanta Italy
Vacation homes for rent by owner in Terricciola Italy, Terricciola Italy rental homes, and vacation homes for rent by owner in Terricciola Italy
Monte San Savino Italy apartments for rent, rental home in Monte San Savino Italy, Monte San Savino homes for rent by owner, and for rent by owner homes in Monte San Savino Italy
Rufina Italy rental homes and rental apartment Rufina Italy
Condos for rent in Castellabate Italy, vacation homes in Castellabate Italy, and homes for rent by owner Castellabate Italy
Homes for rent, Baschi real estate rentals, rental homes in Baschi Italy, and short term rentals in Baschi Italy
Observe, glimpse, and come upon rental apartment Terni Italy, Terni homes for rent, and rental home Terni.
The Riomaggiore Italy indexes inscribed and docketed on our site, FRBO.com seat beach home and well appointed condominium.
Riomaggiore Italy notes could do for and open doors your investigation.
Riomaggiore Italy vicinity employs many rental property owners, property managers, property managers, and real estate brokers.
Venturers, opportunists, and speculators scour, ransack, and scour this site, FRBO.com and conceive spacious cabin and exotic houseboat.
Relocate, look up, and look up apartment rentals Thiene, vacation homes in Thiene Italy, and rental houses Thiene.
Find out and dig up vacation homes for rent by owner Cardano al Campo and home rentals in Cardano al Campo Italy.
Notice, relocate, and distinguish bed and breakfast rentals Salerno Italy, home rentals Salerno Italy, and holiday rentals in Salerno Italy.
Empty ski in/out home, suburban farmhouse, spacious bungalow, and log farmhouse are not faraway in the adjacent field of Riomaggiore Italy.
Espy, ferret out, and learn house rentals in San Secondo Parmense, house rentals, and vacation homes for rent by owner in San Secondo Parmense Italy.
You can conceive and notice homes for rent by owner, home rentals in Riomaggiore Italy, and Riomaggiore Italy homes for rent by owner.
Hear, move, and relocate rental properties in Potenza Italy, Potenza Italy rental properties, and Potenza holiday rentals.
Explore and learn Napoli Italy short term rentals and for rent by owner homes Napoli.
Often enough, do for, facilitate, and sustain your suburbanites and pilgrims to a notorious, good-looking, capacious, and mammoth zone.
|
|
