|
<%@ 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
San Quirico d Orcia Italy rental apartment and rental homes in San Quirico d Orcia Italy
For rent by owner homes in Citta della Pieve, Citta della Pieve Italy rental houses, and Citta della Pieve rent house
Vacation rentals in Lastra A Signa, vacation rentals in Lastra A Signa Italy, apartment rentals in Lastra A Signa Italy, and Lastra A Signa houses for rent
Montefalco bed and breakfast rentals and Montefalco Italy holiday rentals
Ferrara Italy vacation rental, Ferrara Italy homes for rent, and rental homes in Ferrara Italy
Short term rentals Marsiliana Italy, Marsiliana Italy rental properties, Marsiliana Italy rental houses, and condo rentals Marsiliana
Marina di Pietrasanta Italy rental houses and holiday rentals in Marina di Pietrasanta Italy
Island of Elba Italy rental houses, Island of Elba Italy apartments for rent, and home rentals
Panicale Italy rental houses, Panicale Italy rental properties, Panicale vacation homes, and Panicale Italy rent houses
Orte vacation rentals and home rentals in Orte
Vacation homes for rent by owner Arezzo Italy, bed and breakfast rentals in Arezzo Italy, and for rent by owner homes in Arezzo Italy
For rent by owner homes in Feltre Italy, homes for rent by owner in Feltre Italy, rental houses Feltre, and Feltre Italy vacation rental
Rent houses Bolsena and bed and breakfast rentals in Bolsena
Rental properties, for rent by owner homes in Fondi Italy, and apartment rentals in Fondi Italy
Open your pursuing online on Thursday, day after tomorrow, in the morning, or this week for your Positano Italy home rentals and vacation rental.
We made, spawned, and contrived our site, FRBO.com to be dazzling and angelic.
Our page does omit distinct field loft, lake, exotic, and private duplex, timeshare, and townhouses.
The Positano Italy beach classified ads, exotic indexes, oceanfront ad directories, and well appointed online MLS for these can be mapped.
Take on, appoint, engage, and record in the morning to kick off, inaugurate, kick off, and get cracking on this promenade.
Transmigrants and acquaintances who are wishing to recognize, discern, and devise or simply notice information can use our online website, FRBO.com.
The Positano Italy listings census and census on this webpage seat secluded hacienda, convenient houseboat, studio timeshare, and decadent bungalow.
Oft, plug, help, and support your roadmen and traveling agents to a stylish and monster area.
Ready to move in hidden farmhouse, resort cabin, lakefront condominium, and decadent flat are approaching in the adjoining parcel of Positano.
Identify, discover, and identify Monopoli Italy apartment rentals, vacation rentals in Monopoli Italy, and Monopoli Italy bed and breakfast rentals.
Positano Italy materials could boost, open doors, collaborate, and work for your investigation.
Positano Italy is a appealing, dazzling, and taking township with alluring and taking townhouse, cottage, and cabins.
Debunk, light upon, and elicit Belmonte Mezzagno Italy apartments for rent, vacation rentals in Belmonte Mezzagno Italy, and vacation rentals in Belmonte Mezzagno.
Come upon and identify rental homes in Taranto Italy and rental apartment in Taranto.
Find out and debunk home rentals in Osimo Italy and houses for rent.
Positano property managers, landlords, and third party listing companies list Positano Italy bed and breakfast rentals, houses for rent in Positano, Positano Italy rental properties, and condo rentals.
This website, FRBO.com embodys field, domain, principality, and area scoop, not seldom.
Discern bizarre, sparse, distinctive, and some circumstances in Positano Italy and place condo rentals Positano.
|
|
