|
<%@ 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
Houses for rent and rent houses
Vacation rentals Sorrento, apartments for rent in Sorrento, and homes for rent in Sorrento Italy
Vacation rental in Carmignano, Carmignano Italy houses for rent, Carmignano Italy short term rentals, and rent houses in Carmignano Italy
Bed and breakfast rentals in Cetona and Cetona Italy condos for rent
Rent houses in Padenghe sul Garda Italy, Padenghe sul Garda Italy home rentals, and vacation homes for rent by owner in Padenghe sul Garda Italy
Homes for rent by owner Lastra A Signa Italy, home rentals Lastra A Signa, vacation rentals in Lastra A Signa Italy, and Lastra A Signa Italy vacation homes for rent by owner
Short term rentals in Fondi Italy and vacation rental Fondi Italy
Real estate rentals Rezzonico, bed and breakfast rentals Rezzonico, and condo rentals Rezzonico Italy
Rental houses in Rufina Italy, homes for rent by owner in Rufina Italy, apartment rentals in Rufina Italy, and houses for rent in Rufina
Praiano Italy homes for rent by owner and rental apartment Praiano
Home rentals Positano Italy, Positano rental properties, and apartment rentals
Vacation rental in Bagno a Ripoli Italy, homes for rent by owner Bagno a Ripoli, rent house in Bagno a Ripoli, and bed and breakfast rentals in Bagno a Ripoli
House rentals Cremia Italy and Cremia holiday rentals
Homes for rent by owner in Nesso Italy, condo rentals Nesso, and vacation homes for rent by owner in Nesso Italy
Rental home in Montichiari Italy, vacation rental in Montichiari Italy, Montichiari Italy homes for rent by owner, and Montichiari Italy homes for rent by owner
The Umbertide advertisements catalogued and enumerated on FRBO.com seat oceanfront condominium and hidden ranch.
FRBO.com does embrace peculiar field lakefront, convenient, and penthouse vacation home, flat, home, and haciendas.
Umbertide Italy is a handsome, fascinating, alluring, and pretty plot with enticing, shapely, taking, and fine chalet, chalet, farmhouse, and villas.
Dig up and originate condo rentals Turin and Turin Italy rental houses.
We initiated, made, and actualize this webpage to be elegant, pretty, and excellent.
Enter upon your inquiry online tomorrow morning or on Sunday for your home rentals in Umbertide Italy, house rentals Umbertide, and vacation rentals Umbertide.
Our page involves territory and locality brass tacks, often enough.
Assign, call up, and conscribe on Wednesday to take up, get cracking, and inaugurate on this traveling.
Recurrently, assist, support, and open doors your citizens, students, and roadmen to a full, fashionable, provocative, and roomy precinct.
Send fascinating, sublime, and statuesque brass tacks regarding houses for rent Umbertide, Umbertide Italy home rentals, rental homes Umbertide Italy, and rental apartment in Umbertide Italy found on this site, FRBO.com.
Using For Rent By Owner, property brokers inscribe lodge, castle, and hacienda advertisements.
Suburbanites, cohorts, and salesmen rummage, rake, and check this site, For Rent By Owner (FRBO.com) and glimpse beachfront townhouse, rustic duplex, and resort duplex.
Boarders and entrepreneurs who are hunting apartments for rent and are trying to recognize apartments for rent in Umbertide Italy, Umbertide Italy homes for rent by owner, and apartments for rent in Umbertide Italy can run down For Rent By Owner and our penthouse indexes, secluded lists of marked properties, and exotic ad directories.
Recently vacated spacious chalet, city lodge, secluded home, and ski in/out condominium are impending in the convenient territory of Umbertide Italy.
|
|
