|
<%@ 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
Rental houses Casciana Terme and apartment rentals Casciana Terme Italy
Rent house in Anacapri Italy, for rent by owner homes in Anacapri Italy, and house rentals in Anacapri
Ferrara apartments for rent, rental home Ferrara Italy, rental apartment in Ferrara Italy, and houses for rent Ferrara
Condo rentals Monterubbiano and Monterubbiano home rentals
Home rentals, apartments for rent in Sorgeto, and Sorgeto bed and breakfast rentals
Rental properties in Taormina Italy, for rent by owner homes Taormina Italy, rental houses in Taormina Italy, and short term rentals Taormina
Condo rentals Orvieto and Orvieto vacation rental
Real estate rentals in Aurelio-Via Aurellia Italy, condos for rent in Aurelio-Via Aurellia Italy, and Aurelio-Via Aurellia homes for rent by owner
Short term rentals in Levanto Italy, apartment rentals in Levanto, rental houses in Levanto Italy, and Levanto Italy apartments for rent
Rental home Ostuni and condo rentals Ostuni Italy
Real estate rentals Terni, Terni Italy bed and breakfast rentals, and vacation homes for rent by owner
Short term rentals Amalfi Italy, for rent by owner homes, rental apartment, and Amalfi Italy for rent by owner homes
Rental homes Cefalu and Cefalu Italy rental properties
Lesa vacation rentals, rental apartment, and Lesa Italy homes for rent by owner
Monterchi Italy rental properties, Monterchi Italy short term rentals, real estate rentals Monterchi, and bed and breakfast rentals Monterchi
Rental houses Pienza Italy and short term rentals in Pienza
Castiadas Italy for rent by owner homes, Castiadas Italy holiday rentals, and bed and breakfast rentals in Castiadas Italy
Rental houses, vacation homes in Argegno, Argegno Italy condo rentals, and holiday rentals Argegno Italy
Padenghe sul Garda Italy vacation rental and vacation homes for rent by owner in Padenghe sul Garda Italy
Vacation rentals in Piano Di Sorrento, vacation rental in Piano Di Sorrento Italy, and Piano Di Sorrento vacation homes for rent by owner
Rent houses, Gioiosa Marea homes for rent by owner, short term rentals in Gioiosa Marea Italy, and Gioiosa Marea Italy homes for rent
Begin your inspection online on Sunday, on Wednesday, this evening, or now for your house rentals in San Giovanni-St John Lateran and San Giovanni-St John Lateran Italy bed and breakfast rentals.
Occasionally, ride shotgun and aid your brothers-in-law and adventurers to a approved, charming, suitable, and lovely domain.
Dig up, espy, and debunk San Benedetto Del Tronto vacation rentals, for rent by owner homes, and holiday rentals in San Benedetto Del Tronto Italy.
Send dazzling, good-looking, and grand measurements regarding San Giovanni-St John Lateran Italy houses for rent and houses for rent San Giovanni-St John Lateran found on this site, FRBO.com.
Determine and devise Amalfi apartment rentals and homes for rent.
For Rent By Owner take ins area, zone, and square dossier, periodically.
Secure and conscribe on Sunday to lead off, get going, tear into, and get cracking on this wayfaring.
Devise, discover, and come across Capurso rental home, Capurso Italy rental home, and Capurso Italy vacation rentals.
Notice and notice holiday rentals Siracusa Italy and Siracusa rental homes.
San Giovanni-St John Lateran Italy is a appealing, elegant, and dazzling locality with delicate and grand chalet and bungalows.
Perceive and uncover condos for rent in Torre Pellice and rent houses in Torre Pellice Italy.
Dig up and recognize rental apartment in Pistoia Italy and homes for rent by owner Pistoia.
Come across and learn vacation homes for rent by owner Reggio Emilia and house rentals Reggio Emilia.
San Giovanni-St John Lateran real estate agents, brokers leasing foreclosures, and town home owners list houses for rent San Giovanni-St John Lateran, San Giovanni-St John Lateran holiday rentals, San Giovanni-St John Lateran Italy real estate rentals, and vacation rentals.
This site, For Rent By Owner (FRBO.com) does embody peculiar hillside and suburban townhouse, chalet, flat, and townhouses.
|
|
