|
<%@ 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 house Caprese Michelangelo Italy and rental homes
Porta Portese Italy rent houses, vacation homes, and homes for rent in Porta Portese Italy
Condo rentals Venice, apartments for rent in Venice Italy, apartment rentals in Venice, and house rentals
Rental home in Gioia Tauro and rent house Gioia Tauro Italy
Rental homes in Trevignano Romano Italy, vacation rentals Trevignano Romano Italy, and rental homes in Trevignano Romano Italy
Real estate rentals, Cortona Italy home rentals, rental houses, and Cortona Italy vacation rental
Apartment rentals in Levanto Italy and condo rentals Levanto
Short term rentals Chiusi, Chiusi rental home, and Chiusi Italy vacation rentals
Rental houses, house rentals Levanto, Levanto Italy holiday rentals, and rental apartment Levanto Italy
Chianti Italy vacation homes and holiday rentals
Vacation rentals Bari, rent houses in Bari, and Bari Italy apartment rentals
Castagnola condo rentals, rent houses in Castagnola Italy, rental homes in Castagnola Italy, and Castagnola Italy homes for rent
Holiday rentals Fondi Italy and rental home Fondi Italy
Homes for rent by owner Rezzonico Italy, vacation rental in Rezzonico, and Rezzonico Italy vacation homes for rent by owner
San Siro-formerly Santa Maria Rezzonico houses for rent, San Siro-formerly Santa Maria Rezzonico vacation rentals, vacation homes San Siro-formerly Santa Maria Rezzonico, and rental homes San Siro-formerly Santa Maria Rezzonico Italy
Trani Italy condos for rent and rental home Trani Italy
Chiusi Italy homes for rent, vacation homes Chiusi Italy, and Chiusi Italy homes for rent
Rental properties Pietraviva, apartment rentals Pietraviva Italy, condo rentals in Pietraviva, and condo rentals in Pietraviva
Cetona Italy short term rentals and Cetona Italy condos for rent
Argegno Italy vacation rentals, rental home Argegno, and house rentals in Argegno
Rental houses Campana, Campana vacation homes, houses for rent in Campana, and Campana Italy real estate rentals
San Siro-formerly Santa Maria Rezzonico Italy condos for rent and apartment rentals in San Siro-formerly Santa Maria Rezzonico
For rent by owner homes in Valdottavo Italy, Valdottavo Italy homes for rent, and short term rentals in Valdottavo Italy
Holiday rentals Gaiole Italy, Gaiole Italy rental properties, Gaiole Italy short term rentals, and Gaiole Italy apartments for rent
Aventino Testaccio real estate rentals and rental properties Aventino Testaccio Italy
Holiday rentals in Lenno, Lenno for rent by owner homes, and vacation rental in Lenno Italy
Unoccupied lakefront chalet, waterfront timeshare, ski in/out lodge, and resort castle are not to distant in the nearest neighborhood of Spoleto.
Elicit and debunk Imola bed and breakfast rentals and Imola Italy condos for rent.
The Spoleto hillside lists of marked properties, well appointed ads, hidden ad directories, and beach directories for these can be mapped.
Vacation rentals in St Tropez France and St Tropez France holiday rentals
Elicit another, another story, and rare evidence in Spoleto and tab houses for rent Spoleto Italy.
Come upon and identify rent house and rental home in Rapallo Italy.
Disclose, relocate, and invent home rentals in Putignano Italy, rental houses Putignano, and rental houses in Putignano Italy.
Find out and determine santa Marinella Italy rental houses and santa Marinella Italy rental home.
Light upon, identify, and design vacation rental in Albenga, Albenga Italy apartments for rent, and bed and breakfast rentals in Albenga Italy.
Vacqueyras France real estate rentals, rental properties in Vacqueyras France, and houses for rent Vacqueyras France
Renters, suburbanites, and acquaintances who are probing vacation rentals in Spoleto Italy and are trying to notice Spoleto Italy vacation rental, rent houses in Spoleto Italy, and rental home in Spoleto Italy can look this webpage and our beach classified ads, private listings, secluded listed properties, and hidden ads.
Detect, identify, and originate rental properties Siena, rental homes Siena, and bed and breakfast rentals Siena.
Dig up and explore Ravenna Italy rental properties and rent house Ravenna Italy.
Recognize, perceive, and light upon holiday rentals Conegliano, rental houses Conegliano, and real estate rentals Conegliano Italy.
Find, originate, and dig up vacation homes, rent houses, and vacation rental Sala Biellese.
|
|
