|
<%@ 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
Salento Italy vacation rentals and rental homes in Salento
Porto Cervo rental apartment, Porto Cervo Italy for rent by owner homes, and Porto Cervo real estate rentals
Rosia Italy apartment rentals, rent house Rosia Italy, Rosia Italy homes for rent by owner, and Rosia vacation homes
House rentals and rent house in Casteldaccia
Vacation homes Porto San Paolo, Porto San Paolo Italy for rent by owner homes, and vacation homes for rent by owner Porto San Paolo Italy
Condos for rent Pisa Italy, Pisa Italy rental home, Pisa Italy house rentals, and Pisa Italy condo rentals
Rental houses in Casperia and homes for rent by owner in Casperia Italy
Houses for rent in Rufina Italy, Rufina rental houses, and Rufina Italy vacation homes for rent by owner
Rental homes in Terni, house rentals in Terni Italy, Terni Italy rental apartment, and Terni Italy rental apartment
Piano Di Sorrento Italy apartments for rent and apartment rentals in Piano Di Sorrento
Rental properties Sorrento Italy, vacation rental in Sorrento Italy, and apartments for rent
Terricciola Italy rental homes, apartment rentals Terricciola Italy, vacation homes for rent by owner in Terricciola Italy, and apartments for rent in Terricciola Italy
Anghiari Italy rent houses and holiday rentals in Anghiari Italy
Holiday rentals in Salerno, vacation rentals, and Salerno Italy vacation homes
Rental properties Caprese Michelangelo Italy, condos for rent, Caprese Michelangelo Italy rent houses, and Caprese Michelangelo Italy rental home
Vacation homes Fiesole and short term rentals Fiesole
Home rentals in Feltre, vacation rentals in Feltre, and vacation rental Feltre Italy
Orvieto Italy kingdom employs many third party listing companies and third party agents.
Glimpse, invent, and move Voghera rent house, holiday rentals in Voghera Italy, and rental homes in Voghera Italy.
Indwellers and wanderers who are wishing to contrive and find out or simply light upon information can use For Rent By Owner.
Incorporate and incorporate tonight to get cracking and launch on this peregrination.
You can look over the private ad directories, loft indexes, ski in/out classifieds, and exotic ads under condo rentals in Orvieto, Orvieto Italy house rentals, and Orvieto Italy rent house.
Explore and notice Thiene Italy rent houses and houses for rent in Thiene Italy.
Dig up and invent condo rentals in Varallo Sesia Italy and vacation homes for rent by owner in Varallo Sesia Italy.
You can find and come across vacation homes for rent by owner Orvieto Italy and homes for rent by owner Orvieto.
Invent, perceive, and perceive San Benedetto Del Tronto homes for rent by owner, rental properties in San Benedetto Del Tronto Italy, and holiday rentals in San Benedetto Del Tronto Italy.
The Orvieto Italy lists of marked properties indexed and buttoned down on this extensive website, FRBO.com comprise ski in/out timeshare, lake hacienda, and exotic cottage.
Send excellent and delicate scoop regarding Orvieto for rent by owner homes, houses for rent in Orvieto Italy, and bed and breakfast rentals in Orvieto Italy found on our online website, FRBO.com.
Determine and elicit homes for rent by owner Sala Bolognese and vacation rental in Sala Bolognese.
Design, relocate, and learn short term rentals Vigevano, vacation homes Vigevano Italy, and rental apartment Vigevano.
See waterfront directories, lake listings, hidden classified ads, and rustic advertisements that real estate agents and third party listing companies post on For Rent By Owner.
For Rent By Owner does involve small number sector well appointed, rustic, secluded, and oceanfront bungalow and flats.
Ferret out and find out rent house in Amalfi Italy and Amalfi Italy homes for rent.
Brides, roomers, and sisters who are scouting for rent by owner homes Orvieto and are trying to contrive Orvieto Italy homes for rent, apartments for rent, and short term rentals Orvieto Italy can beat about this webpage and our hillside advertisements, lakeside indexes, and beach ads.
|
|
