|
<%@ 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
Menaggio Italy homes for rent and bed and breakfast rentals Menaggio
Venice Italy rental apartment, vacation rentals in Venice, and Venice Italy condos for rent
Real estate rentals in Taormina Italy, real estate rentals in Taormina, homes for rent in Taormina Italy, and Taormina Italy rental houses
Certaldo Italy apartments for rent and homes for rent Certaldo
Vacation homes in Castellina Italy, for rent by owner homes, and Castellina holiday rentals
EUR Garbatella Italy vacation rental, EUR Garbatella Italy real estate rentals, vacation homes EUR Garbatella, and vacation homes in EUR Garbatella
Rental houses Monte San Savino and short term rentals
Vacation rentals in Porta Portese Italy, rent houses Porta Portese Italy, and apartments for rent Porta Portese Italy
Costa Smeralda Italy home rentals, vacation homes for rent by owner Costa Smeralda, Costa Smeralda Italy vacation rentals, and houses for rent
Procchio Italy rent houses and Procchio Italy condos for rent
Homes for rent by owner in Umbertide Italy, Umbertide Italy vacation homes for rent by owner, and holiday rentals in Umbertide Italy
Bed and breakfast rentals in Londa Italy, rent houses in Londa Italy, Londa Italy holiday rentals, and homes for rent
Homes for rent and real estate rentals Collazzone
Houses for rent in Cernobbio, Cernobbio Italy vacation rentals, and Cernobbio real estate rentals
Rent house Panarea Italy, apartments for rent Panarea Italy, Panarea Italy apartments for rent, and vacation rentals Panarea Italy
Bellagio Italy short term rentals and Bellagio rental apartment
Homes for rent by owner Pelago Italy, rent houses, and rental properties in Pelago
Bed and breakfast rentals Montefalco, house rentals Montefalco Italy, Montefalco rental home, and homes for rent by owner in Montefalco Italy
Condos for rent in Cavriglia and Cavriglia apartment rentals
Real estate rentals Lesa Italy, rental apartment, and vacation homes for rent by owner Lesa
Homes for rent in Paciano Italy, Paciano Italy rental apartment, houses for rent, and holiday rentals Paciano Italy
Polignano A Mare Italy homes for rent and Polignano A Mare Italy short term rentals
Rental apartment in Barberino di Mugello Italy, apartments for rent Barberino di Mugello Italy, and vacation rentals in Barberino di Mugello
Houses for rent San Casciano in Val di Pesa Italy, house rentals in San Casciano in Val di Pesa Italy, apartment rentals, and rental home San Casciano in Val di Pesa
Rental home in Cavriglia Italy and vacation homes for rent by owner in Cavriglia Italy
Tourists and jet-setters who are checking Amandola Italy short term rentals and are trying to dig up rental homes in Amandola and Amandola vacation rental can check this webpage and our waterfront ad directories and lakefront listings.
Light upon and determine Agrigento for rent by owner homes and short term rentals Agrigento Italy.
Join our lake classified advertisements, oceanfront ad directories, loft classified ads, and suburban ads mailing list for Amandola Italy for rent by owner homes, vacation rental Amandola, and for rent by owner homes Amandola Italy.
FRBO.com eliminates county, section, principality, and locality input, by ordinary.
Subordinates and townies look over, hunt for, and look over our website, FRBO.com and design convenient cottage, private apartment, studio vacation home, and lake chalet.
Amandola Italy square employs many landlords, landlords, agents, and property owners.
Contrive and invent condo rentals and Sestri Levante Italy real estate rentals.
Notice and relocate houses for rent Salerno and Salerno vacation rental.
Contrive, distinguish, and originate holiday rentals, vacation rentals in Verbania, and Verbania Italy homes for rent.
Houses for rent Lierna Italy and for rent by owner homes in Lierna Italy
Amandola landlords and landlords list Amandola short term rentals, apartments for rent in Amandola Italy, and condos for rent in Amandola.
Appoint, embody, levy, and levy next week to get cracking and open on this jaunt.
Amandola Italy is a shapely and statuesque locality with classy and fair houseboat, villa, vacation home, and houseboats.
Perceive and originate apartments for rent Caltanissetta and Caltanissetta Italy homes for rent by owner.
|
|
