|
<%@ 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
Rent houses Avellino and house rentals Avellino Italy
Homes for rent in Como, Como Italy condos for rent, and vacation rentals in Como Italy
Vacation homes in Matera Italy, homes for rent by owner in Matera, rent houses, and vacation homes Matera
House rentals in Mercatale Valdarno Italy and Mercatale Valdarno Italy homes for rent
Bed and breakfast rentals Villasimius, vacation homes in Villasimius, and apartments for rent Villasimius Italy
Cavriglia for rent by owner homes, rental houses Cavriglia Italy, Cavriglia vacation rentals, and condo rentals
Vacation homes for rent by owner in Siena and Siena condos for rent
Homes for rent by owner, Val di Vara condo rentals, and Val di Vara real estate rentals
Rental homes in Alghero Italy, Alghero real estate rentals, Alghero Italy houses for rent, and vacation rentals in Alghero Italy
Rent houses and Gaiole Italy vacation homes for rent by owner
Vacation rentals Griante, homes for rent by owner in Griante Italy, and for rent by owner homes
Montespertoli rental apartment, vacation rental in Montespertoli, short term rentals Montespertoli Italy, and rental properties Montespertoli Italy
Cecina rent house and houses for rent
Homes for rent by owner in Prati, Prati real estate rentals, and Prati Italy homes for rent
Florence Italy condos for rent, Florence rental properties, Florence Italy apartments for rent, and condo rentals in Florence
San Benedetto del Tronto vacation rentals and San Benedetto del Tronto rental homes
Rental homes in Praiano, homes for rent by owner Praiano, and rental houses in Praiano
Short term rentals in Pariana Italy, rental apartment Pariana Italy, Pariana Italy rental home, and homes for rent Pariana Italy
Short term rentals Fivizzano Italy and Fivizzano rent house
Vacation rental in Costa Smeralda Italy, Costa Smeralda condo rentals, and Costa Smeralda Italy homes for rent
Rent houses in Foligno Italy, Foligno Italy apartments for rent, vacation homes Foligno Italy, and Foligno rental properties
Homes for rent in Sogna and Sogna houses for rent
Londa rental houses, holiday rentals in Londa Italy, and condos for rent in Londa
Vacation rentals in San Terenziano Italy, house rentals San Terenziano, San Terenziano Italy condos for rent, and San Terenziano Italy vacation homes
Anghiari Italy rent houses and rental homes Anghiari
Como Italy bed and breakfast rentals, Como Italy house rentals, and rent houses in Como Italy
Apartments for rent, vacation homes in Marina di Pietrasanta Italy, rental houses in Marina di Pietrasanta Italy, and rental homes Marina di Pietrasanta
Bolsena Italy vacation homes and vacation homes for rent by owner in Bolsena Italy
Elicit and contrive Lecco Italy condos for rent and Lecco Italy real estate rentals.
Villasimius Italy is a sublime, resplendent, and excellent zone with cute, divine, and radiant home, houseboat, vacation home, and houseboats.
Home rentals Ste Maxime and for rent by owner homes in Ste Maxime
Castelfiorentino Italy homes for rent, Castelfiorentino Italy apartments for rent, Castelfiorentino apartments for rent, and vacation homes
The Villasimius Italy resort indexes and ski in/out classifieds for these can be mapped.
Elicit ad hoc, singular, and novel compilations in Villasimius Italy and invoice vacation rental in Villasimius.
Espy, invent, and distinguish Castelnuovo Di porto Italy homes for rent by owner, Castelnuovo Di porto Italy rental home, and bed and breakfast rentals Castelnuovo Di porto.
Devise, distinguish, and catch Piacenza Italy condos for rent, houses for rent Piacenza Italy, and Piacenza vacation rentals.
Using our webpage, agents particularize flat, cottage, townhouse, and condominium advertisements.
Homes for rent by owner and for rent by owner homes in Bracciano Italy
House rentals in Rognes, Rognes home rentals, and Rognes France homes for rent by owner
Villasimius Italy reports could ride shotgun and cooperate your pursual.
Explore and light upon homes for rent Vicenza and apartments for rent Vicenza.
Find, ascertain, and perceive bed and breakfast rentals Pistoia, vacation rental Pistoia Italy, and real estate rentals Pistoia Italy.
Find out, discover, and locate Massa Italy holiday rentals, short term rentals in Massa Italy, and real estate rentals.
Debunk and look up houses for rent in Olbia and Olbia homes for rent.
|
|
