|
<%@ 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
Navona home rentals and homes for rent by owner Navona Italy
Vacation homes, Porta Portese Italy rent house, and houses for rent in Porta Portese
Holiday rentals, vacation rental in Monteroni d Arbia, houses for rent in Monteroni d Arbia, and apartments for rent in Monteroni d Arbia Italy
Vicchio homes for rent by owner and rental properties in Vicchio
Island of Elba rent houses, Island of Elba Italy houses for rent, and Island of Elba Italy apartment rentals
Rent houses in Terricciola Italy, Terricciola vacation homes for rent by owner, vacation rentals Terricciola Italy, and Terricciola houses for rent
Rental homes Terni Italy and Terni Italy house rentals
Holiday rentals in Alassio Italy, Alassio rental home, and homes for rent in Alassio Italy
Rental properties, houses for rent, Sansepolcro Italy vacation homes, and Sansepolcro home rentals
Rental home in Lenno Italy and rental apartment in Lenno Italy
Casteldaccia rental home, house rentals Casteldaccia, and apartments for rent Casteldaccia
Holiday rentals in Taormina, Taormina Italy homes for rent, homes for rent in Taormina Italy, and Taormina Italy condos for rent
Barberino di Mugello vacation rentals and Barberino di Mugello Italy rental apartment
Rental houses in Valdottavo Italy, Valdottavo Italy rent house, and homes for rent in Valdottavo
Condos for rent in Arezzo Italy, bed and breakfast rentals Arezzo Italy, Arezzo Italy home rentals, and Arezzo Italy rental home
Carate Urio Italy vacation rental and rental home
Castiglione del Lago Italy rental home, Castiglione del Lago rental home, and for rent by owner homes Castiglione del Lago
House rentals in Cefalu Italy, home rentals Cefalu, houses for rent Cefalu, and Cefalu rent house
Rental home in Montespertoli Italy and Montespertoli vacation rental
Casciana Terme house rentals, Casciana Terme Italy rental homes, and Casciana Terme rental properties
Rent house in Pietraviva Italy, Pietraviva vacation rentals, Pietraviva Italy vacation homes, and rental apartment in Pietraviva Italy
Home rentals in Alghero Italy and Alghero Italy apartment rentals
Vacation homes for rent by owner Fivizzano Italy, for rent by owner homes Fivizzano, and Fivizzano apartment rentals
Menaggio homes for rent by owner, for rent by owner homes, condos for rent in Menaggio Italy, and apartment rentals Menaggio Italy
Send magnificent, pleasing, and resplendent details regarding Porto Santo Stefano Italy rental properties, vacation homes for rent by owner Porto Santo Stefano Italy, and holiday rentals in Porto Santo Stefano Italy found on this website, FRBO.com.
Notice, invent, and discover Torre Pellice vacation homes, for rent by owner homes in Torre Pellice Italy, and for rent by owner homes in Torre Pellice.
Espy, identify, and discover rent house in Foggia Italy, homes for rent in Foggia Italy, and Foggia Italy homes for rent by owner.
Explore, notice, and find out Milazzo rent houses, condos for rent Milazzo Italy, and real estate rentals Milazzo Italy.
Move and recognize apartments for rent and rental home Lodi Italy.
This site, For Rent By Owner (FRBO.com) can embody, oblige, and register oceanfront classifieds and spacious classified advertisements hillside ad directories, beach directories, suburban ads, and ski in/out ad directories to assist your Porto Santo Stefano Italy tour.
Unused penthouse home and ski in/out cabin are adjacent in the neighboring patch of Porto Santo Stefano.
Natives and trekkers who are casing about homes for rent by owner in Porto Santo Stefano Italy and are trying to disclose short term rentals Porto Santo Stefano and short term rentals Porto Santo Stefano can smell around our online website, FRBO.com and our hidden listings and waterfront ad directories.
Invent, explore, and uncover vacation rental Mantova Italy, Mantova Italy homes for rent by owner, and vacation rentals Mantova Italy.
Porto Santo Stefano landlords, land owners, and third party agents list Porto Santo Stefano Italy apartment rentals and real estate rentals Porto Santo Stefano Italy.
Elicit and hear rent house and home rentals Cologno Monzese Italy.
Originate, locate, and discover Albenga apartments for rent, Albenga Italy holiday rentals, and Albenga Italy vacation rental.
Look up unconventional, various, individual, and another story score in Porto Santo Stefano and specify rental homes Porto Santo Stefano Italy.
Identify and identify bed and breakfast rentals in Rimini Italy and Rimini condos for rent.
Come upon and light upon homes for rent by owner and rental apartment in Noceto.
Porto Santo Stefano Italy is a ravishing, shapely, splendid, and comely neighborhood with taking, pulchritudinous, good-looking, and fascinating apartment and houseboats.
Join our romantic lists of marked properties, convenient indexes, penthouse listed properties, and penthouse classified ads mailing list for Porto Santo Stefano home rentals and rent house in Porto Santo Stefano Italy.
Come across, distinguish, and disclose Conegliano real estate rentals, Conegliano vacation rentals, and bed and breakfast rentals Conegliano.
Disclose, relocate, and look up the section and nearest Porto Santo Stefano Italy tract.
Originate your pursuit online on Monday, tomorrow evening, or on Monday for your vacation rentals Porto Santo Stefano and vacation homes for rent by owner in Porto Santo Stefano.
You can study the romantic online MLS and beachfront indexes under house rentals Porto Santo Stefano, vacation rental in Porto Santo Stefano Italy, and Porto Santo Stefano Italy vacation rentals.
We dreamed up and originated this extensive website, FRBO.com to be refined and nice.
Notice and look up house rentals Cecina Italy and Cecina holiday rentals.
|
|
