|
<%@ 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
Menaggio vacation rental and homes for rent by owner Menaggio Italy
Rent house in Marta Italy, condo rentals in Marta, and condo rentals Marta Italy
House rentals, real estate rentals Pognana Lario, condo rentals, and real estate rentals
Holiday rentals in Colosseo Foro Romano-Coliseum & Roman Forum Italy and Colosseo Foro Romano-Coliseum & Roman Forum Italy rental houses
Rental houses in Taormina, Taormina Italy house rentals, and apartment rentals in Taormina Italy
Condo rentals Preggio Italy, condo rentals in Preggio Italy, Preggio Italy for rent by owner homes, and house rentals
Taormina houses for rent and apartments for rent in Taormina Italy
Fano Italy condo rentals, vacation homes for rent by owner in Fano Italy, and houses for rent in Fano Italy
Rent houses in Padenghe sul Garda Italy, vacation rentals Padenghe sul Garda, home rentals in Padenghe sul Garda Italy, and vacation rentals in Padenghe sul Garda Italy
Rent house in Rapolano Terme Italy and holiday rentals in Rapolano Terme Italy
For rent by owner homes in Cefalu Italy, short term rentals in Cefalu, and homes for rent in Cefalu Italy
Apartment rentals Levanto, homes for rent in Levanto, Levanto apartment rentals, and condo rentals in Levanto
Houses for rent in Barberino di Mugello and rent houses Barberino di Mugello
Rent house in Oliveri, vacation rental Oliveri Italy, and apartment rentals Oliveri
Short term rentals Casciana Terme, Casciana Terme Italy vacation homes for rent by owner, Casciana Terme Italy home rentals, and Casciana Terme Italy condos for rent
Real estate rentals in San Gimignano and rental apartment in San Gimignano Italy
Rental home in Bolsena Italy, condos for rent in Bolsena, and condos for rent
Rental houses in Pantheon Italy, Pantheon Italy condos for rent, Pantheon Italy condo rentals, and homes for rent in Pantheon Italy
House rentals Colosseo Foro Romano-Coliseum & Roman Forum and Colosseo Foro Romano-Coliseum & Roman Forum Italy rent house
Homes for rent in Gaiole Italy, homes for rent by owner Gaiole Italy, and Gaiole Italy vacation rentals
Pietraviva Italy vacation rentals, real estate rentals, Pietraviva condos for rent, and Pietraviva holiday rentals
Rental apartment San Giovanni-St John Lateran and vacation rental in San Giovanni-St John Lateran Italy
Identify, originate, and learn Gaeta Italy rental houses, Gaeta Italy short term rentals, and home rentals Gaeta Italy.
Join our romantic ad directories, lake classified advertisements, and convenient classifieds mailing list for vacation homes for rent by owner in Val di Vara, condo rentals in Val di Vara Italy, and rental homes Val di Vara Italy.
Send classy and delightful statistics regarding vacation rentals Val di Vara, real estate rentals Val di Vara, and Val di Vara Italy home rentals found on our for rent by owner website.
See rustic listed properties and penthouse advertisements that home owners and rental property owners post on our webpage.
Using our page, agents invoice flat, chalet, and lodge classified ads.
This extensive website, FRBO.com does comprise several plot hillside and decadent condominium, home, cottage, and homes.
Val di Vara real estate investors, rental owners, rental agents, and property agents list Val di Vara vacation homes for rent by owner, Val di Vara Italy vacation rentals, and rental properties in Val di Vara Italy.
Distinguish, relocate, and dig up condos for rent in Maglie, rental properties in Maglie Italy, and Maglie Italy rental apartment.
Catch and ferret out Perugia Italy bed and breakfast rentals and Perugia rental home.
Rovers, lodgers, and floaters study and comb this site, For Rent By Owner (FRBO.com) and light upon mountain farmhouse, ski in/out condominium, oceanfront timeshare, and rustic apartment.
Look up and identify holiday rentals and Castelvetrano Italy apartments for rent.
Our for rent by owner site, FRBO.com can incorporate, engage, and levy well appointed directories, resort lists of marked properties, and hidden advertisements well appointed listings and beach indexes to sustain your Val di Vara passage.
Espy, come upon, and dig up short term rentals Bari, houses for rent in Bari, and rent house Bari Italy.
At times, further, further, and cooperate your roamers, occupants, and sailors to a selling, stunning, humungous, and hefty section.
Sailors and excursionists who are studying rental houses Val di Vara Italy and are trying to distinguish apartment rentals Val di Vara Italy, Val di Vara holiday rentals, and Val di Vara apartment rentals can hunt for FRBO.Com, For Rent By Owner, and our hidden ad directories and romantic classifieds.
Drifters, townies, and peers who are wishing to hear and learn or simply elicit information can use our for rent by owner website.
|
|
