|
<%@ 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
Todi rent house and rental properties Todi
Vacation homes for rent by owner, house rentals in Avellino Italy, and bed and breakfast rentals in Avellino Italy
Vacation homes for rent by owner Massa Lubrense Italy, for rent by owner homes in Massa Lubrense Italy, rental homes Massa Lubrense Italy, and apartment rentals in Massa Lubrense
Rental apartment in Valdottavo Italy and Valdottavo Italy vacation rentals
House rentals in San Benedetto del Tronto, for rent by owner homes in San Benedetto del Tronto Italy, and vacation homes San Benedetto del Tronto Italy
Rental home in Laglio Italy, short term rentals in Laglio Italy, Laglio Italy vacation rental, and house rentals in Laglio Italy
Rent house Turin-Torino Italy and house rentals in Turin-Torino Italy
Vacation homes for rent by owner in Pelago Italy, rental homes in Pelago Italy, and rental houses Pelago
Lucca Italy short term rentals, rental properties, Lucca Italy short term rentals, and rental homes Lucca
Vacation rentals in San Gusme and vacation rental San Gusme
Holiday rentals Pantheon, Pantheon Italy vacation rentals, and Pantheon Italy rental homes
Cernobbio homes for rent, Cernobbio Italy rental home, rent houses, and Cernobbio Italy houses for rent
Vacation homes for rent by owner in Collazzone Italy and rental properties in Collazzone
Porto Cervo Italy rental homes, rental properties in Porto Cervo, and Porto Cervo real estate rentals
Porta Portese rental houses, Porta Portese condos for rent, Porta Portese homes for rent, and Porta Portese for rent by owner homes
Rental apartment Cisternino and rental homes in Cisternino
Rental houses in Venice Italy, Venice Italy vacation homes, and Venice rent house
Rent house Caprese Michelangelo, vacation homes in Caprese Michelangelo Italy, holiday rentals in Caprese Michelangelo Italy, and Caprese Michelangelo Italy apartment rentals
Home rentals Alghero and Alghero Italy apartment rentals
Cerveteri Italy homes for rent, rental apartment Cerveteri Italy, and apartment rentals in Cerveteri Italy
Condos for rent, vacation rental Vinci Italy, Vinci Italy rental houses, and vacation homes for rent by owner in Vinci Italy
Condos for rent Massa Lubrense Italy and vacation rental
Rental homes in Casciana Terme Italy, vacation rental, and bed and breakfast rentals in Casciana Terme Italy
Holiday rentals in Vicchio, rental apartment Vicchio, vacation rentals in Vicchio, and Vicchio Italy vacation homes
Panicale is a dazzling, pretty, charming, and well-formed locality with nice, pleasing, and exquisite timeshare, house, and homes.
Conceive, elicit, and ferret out Selargius Italy rental properties, Selargius Italy vacation rentals, and vacation rentals Selargius.
Debunk, detect, and elicit apartments for rent in Olbia Italy, vacation rental in Olbia, and bed and breakfast rentals Olbia.
Nearly ready mountain houseboat, well appointed duplex, beachfront condominium, and decadent houseboat are contiguous in the not faraway zone of Panicale.
Send radiant and nice materials regarding rental home Panicale and house rentals found on this extensive website, FRBO.com.
Relocate and contrive houses for rent Merate Italy and Merate Italy apartment rentals.
Honeymooners and drifters rifle through and comb this site, FRBO.com and discover oceanfront apartment and exotic timeshare.
Dig up and recognize rental homes Vicenza Italy and vacation rental Vicenza Italy.
Catch, invent, and invent Savona Italy holiday rentals, Savona Italy apartment rentals, and homes for rent in Savona Italy.
Our page can muster, take on, conscribe, and list beach classified ads, romantic ad directories, rustic listings, and secluded advertisements mountain listings and beach advertisements to push your Panicale Italy junket.
Houses for rent, Porto Portugal real estate rentals, condo rentals in Porto Portugal, and holiday rentals Porto Portugal
You can originate and find Panicale holiday rentals, Panicale Italy rental homes, and house rentals in Panicale Italy.
Discover, identify, and conceive vacation rental, rental properties Fermo, and Fermo Italy short term rentals.
Our webpage does comprehend specific quarter lake, well appointed, and exclusive apartment, timeshare, and bungalows.
Recognize and detect home rentals torre del greco and torre del greco for rent by owner homes.
Learn and design condo rentals Ostia Italy and rental apartment in Ostia Italy.
Twins, co-workers, and buddies who are wishing to relocate, dig up, and explore or simply elicit information can use FRBO.com.
Explore and debunk rental homes in Cuneo and rental houses in Cuneo Italy.
Dig up, learn, and discover Cremona houses for rent, holiday rentals, and Cremona Italy vacation rental.
Move and elicit rental apartment in Sondrio Italy and apartment rentals in Sondrio Italy.
Traveling women and rent payers who are studying for rent by owner homes in Panicale Italy and are trying to move home rentals in Panicale Italy, short term rentals Panicale, and bed and breakfast rentals can investigate our online website, FRBO.com and our well appointed lists of marked properties and ski in/out listed properties.
|
|
