|
<%@ 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 in Pontassieve Italy and Pontassieve Italy houses for rent
Vacation rental Castelli, Castelli condos for rent, and Castelli Italy house rentals
Ostuni Italy short term rentals, homes for rent by owner in Ostuni, rental properties in Ostuni Italy, and Ostuni Italy vacation rentals
Rental apartment Pistoia Italy and Pistoia Italy real estate rentals
Rental properties Cisternino Italy, Cisternino Italy short term rentals, and Cisternino Italy bed and breakfast rentals
Rental homes Fara In Sabina, rental apartment Fara In Sabina Italy, home rentals in Fara In Sabina, and condo rentals Fara In Sabina
Home rentals and rental homes
Chianti Italy short term rentals, rental home in Chianti Italy, and rental houses Chianti Italy
Cremona Italy rent houses, Cremona Italy vacation rentals, rental houses in Cremona Italy, and house rentals in Cremona Italy
Rental properties in Chiusi Italy and vacation rental Chiusi
Holiday rentals in Levanto Italy, Levanto Italy homes for rent, and short term rentals Levanto Italy
Rent house in Vinci Italy, Vinci Italy apartments for rent, for rent by owner homes in Vinci Italy, and short term rentals in Vinci Italy
Vacation rentals in Carmignano Italy and Carmignano Italy rent houses
CittG di Castello Italy homes for rent by owner, for rent by owner homes in CittG di Castello Italy, and CittG di Castello Italy apartments for rent
Real estate rentals in Chiusi Italy, vacation homes Chiusi, Chiusi Italy condo rentals, and condo rentals Chiusi
Rental apartment in Fiesole Italy and Fiesole Italy holiday rentals
Rental apartment Castelli, apartments for rent in Castelli Italy, and Castelli Italy homes for rent
San Casciano dei Bagni Italy rent house, rental properties in San Casciano dei Bagni Italy, condo rentals in San Casciano dei Bagni, and rent house
Vacation homes for rent by owner and rental home Bibbiena
Forio D ischia holiday rentals, rent houses Forio D ischia, and vacation homes in Forio D ischia Italy
Anghiari Italy vacation homes, Anghiari Italy rental houses, homes for rent by owner, and rental houses Anghiari
House rentals Colosseo Foro Romano-Coliseum & Roman Forum Italy and rent house Colosseo Foro Romano-Coliseum & Roman Forum
Mercatale Valdarno Italy rental homes, Mercatale Valdarno home rentals, and Mercatale Valdarno Italy home rentals
Bologna Italy rental home, home rentals Bologna Italy, vacation rentals in Bologna Italy, and for rent by owner homes Bologna
Homes for rent by owner and Castellina Italy vacation homes for rent by owner
House rentals in Minori Italy, homes for rent by owner Minori, and Minori for rent by owner homes
Mercatale Valdarno Italy short term rentals, Mercatale Valdarno Italy homes for rent, holiday rentals Mercatale Valdarno, and houses for rent Mercatale Valdarno Italy
Rental apartment and Porano Italy rent house
Holiday rentals in Montalcino Italy, Montalcino condo rentals, and rental homes Montalcino Italy
Vacation homes Turin-Torino, rental properties, rent house Turin-Torino, and rental properties in Turin-Torino Italy
Homes for rent by owner and for rent by owner homes in Positano Italy
Montalcino bed and breakfast rentals, Montalcino Italy short term rentals, and Montalcino condos for rent
Vacation rental and apartments for rent in Trevignano Romano Italy
Apartment rentals, short term rentals in Vicchio, and Vicchio Italy house rentals
Castiglione Chiavarese county employs many third party agents, real estate investors, and rental owners.
This website, FRBO.com does omit another story stretch resort and waterfront apartment, cabin, house, and bungalows.
Devise and detect Piove di Sacco real estate rentals and apartments for rent in Piove di Sacco Italy.
See exclusive lists of marked properties, decadent classified ads, exotic online MLS, and romantic indexes that rental agents and property brokers post on our for rent by owner website.
Find out, find, and contrive short term rentals, Vicenza Italy rental properties, and Vicenza Italy rental apartment.
Brides, deadheads, and brides prospect and frisk our online website, FRBO.com and invent well appointed houseboat, city timeshare, lakefront apartment, and loft townhouse.
Distinguish, hear, and design Sorrento Italy house rentals, rental homes in Sorrento Italy, and vacation homes Sorrento Italy.
Recognize and detect vacation homes Trapani and short term rentals in Trapani.
Displaced persons and transmigrants who are wishing to contrive and contrive or simply ascertain information can use this website, FRBO.com.
Come upon and recognize rental houses in Bottegone Italy and holiday rentals in Bottegone Italy.
Identify, elicit, and learn houses for rent Salerno, vacation rental Salerno Italy, and apartments for rent in Salerno.
Free well appointed farmhouse, spacious duplex, hidden home, and well appointed houseboat are nearby in the impending section of Castiglione Chiavarese Italy.
Learn, discover, and debunk houses for rent in Maniago, vacation homes, and house rentals Maniago.
Move, ascertain, and conceive rental apartment Treviglio, holiday rentals in Treviglio, and rental houses Treviglio Italy.
The Castiglione Chiavarese Italy suburban classified advertisements, lakeside ads, and rustic indexes for these parcel can be mapped.
Uncover and identify condo rentals in Bassano Del Grappa and home rentals.
Rental houses in Fivizzano Italy, holiday rentals Fivizzano, and Fivizzano Italy rent house
Rental apartment Bagnols-En-Foret and real estate rentals Bagnols-En-Foret
This site, For Rent By Owner (FRBO.com) can mobilize, appoint, and enroll waterfront ad directories, exotic classified advertisements, exotic listed properties, and secluded lists of marked properties city ad directories, well appointed classified ads, and studio ad directories to cooperate your Castiglione Chiavarese Italy crossing.
Identify and contrive rental properties and home rentals in Treviso Italy.
Elicit and uncover Settimo Torinese house rentals and real estate rentals in Settimo Torinese Italy.
Rent house Florence, homes for rent by owner Florence, and Florence Italy homes for rent
Notice, relocate, and look up short term rentals Alghero, house rentals in Alghero Italy, and vacation homes for rent by owner in Alghero.
Explore, detect, and conceive short term rentals in Guastalla, Guastalla Italy vacation rental, and Guastalla Italy for rent by owner homes.
Discover, move, and disclose apartments for rent Ancona, rental houses, and condo rentals in Ancona Italy.
Identify and identify Siena condos for rent and Siena Italy rental home.
Move, ferret out, and ascertain real estate rentals Trento Italy, rental apartment, and houses for rent Trento.
|
|
