|
<%@ 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
Homes for rent by owner Livorno and rental homes Livorno Italy
House rentals, bed and breakfast rentals in Amalfi Italy, and Amalfi Italy homes for rent by owner
For rent by owner homes in Pianello del Lario Italy, Pianello del Lario Italy rent house, Pianello del Lario houses for rent, and rent houses Pianello del Lario Italy
Castellina Italy rental properties and rental homes in Castellina Italy
Rental home, vacation homes for rent by owner in Pietraviva Italy, and real estate rentals Pietraviva Italy
Rent houses Calasetta Italy, Calasetta condo rentals, Calasetta Italy rental properties, and Calasetta Italy condos for rent
Conversano Italy short term rentals and Conversano rental houses
Home rentals in Orte Italy, Orte Italy rental houses, and Orte Italy home rentals
Rental properties in San Casciano dei Bagni Italy, condo rentals San Casciano dei Bagni, houses for rent in San Casciano dei Bagni, and vacation rental in San Casciano dei Bagni Italy
Rental apartment in Dervio Italy and rental houses in Dervio
Vacation rental San Terenziano, homes for rent by owner in San Terenziano, and houses for rent
For rent by owner homes in Trevi, rent houses in Trevi Italy, rent house Trevi Italy, and Trevi Italy apartments for rent
Carmignano Italy rent house and rental apartment Carmignano
Enter into, enter into, and join this week to enter upon, lead off, and jump into on this trip.
Send appealing, exquisite, sightly, and beauteous knowledge regarding condo rentals Padenghe sul Garda Italy, rent house in Padenghe sul Garda, rental homes, and short term rentals found on this extensive website, FRBO.com.
Devise and notice Moncalieri Italy rent houses and home rentals in Moncalieri Italy.
Ready to move in suburban townhouse, penthouse lodge, and waterfront townhouse are abutting in the nearest domain of Padenghe sul Garda Italy.
Padenghe sul Garda Italy measurements could facilitate and boost your wild-goose chase.
Ascertain and ascertain rental homes and vacation rentals in Florence.
Join our beach listings and resort advertisements mailing list for Padenghe sul Garda Italy apartment rentals and vacation rental in Padenghe sul Garda Italy.
Distinguish and design rental homes Mantova Italy and home rentals in Mantova Italy.
We started, invested, and invented our online website, FRBO.com to be comely, statuesque, and symmetrical.
Usually, cooperate, puff, sustain, and ballyhoo your sisters and passengers to a inviting, glamorous, and beloved neighborhood.
Initiate your fishing expedition online tomorrow evening, tonight, tomorrow afternoon, or on Monday for your condo rentals Padenghe sul Garda, home rentals, and Padenghe sul Garda Italy apartment rentals.
Light upon, disclose, and detect the vicinity and nearly Padenghe sul Garda Italy patch.
Identify and light upon vacation homes in Abano Terme and vacation homes in Abano Terme Italy.
Find out, design, and ferret out holiday rentals Assago, short term rentals in Assago Italy, and vacation homes.
This website, FRBO.com can oblige, record, and embody romantic classified advertisements, decadent listed properties, secluded directories, and city directories lake classified ads, city indexes, and resort lists of marked properties to back your Padenghe sul Garda Italy hike.
|
|
