|
<%@ 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
Vacation homes for rent by owner in Praiano and Praiano Italy rental home
San Benedetto del Tronto Italy rental home, San Benedetto del Tronto Italy rent houses, and short term rentals San Benedetto del Tronto Italy
Holiday rentals Sogna Italy, Sogna Italy vacation homes, Sogna rental home, and condos for rent in Sogna
Rent houses in San Terenziano Italy and San Terenziano Italy rental properties
Rental apartment Marina di Pietrasanta Italy, Marina di Pietrasanta real estate rentals, and Marina di Pietrasanta bed and breakfast rentals
Bed and breakfast rentals in Monte San Savino Italy, homes for rent, Monte San Savino rental houses, and Monte San Savino Italy rental apartment
Rent house Cortona and homes for rent in Cortona Italy
Apartments for rent in Minori Italy, Minori Italy house rentals, and homes for rent Minori Italy
Home rentals San Giovanni d Asso Italy, San Giovanni d Asso short term rentals, vacation homes for rent by owner San Giovanni d Asso, and vacation rentals San Giovanni d Asso Italy
For rent by owner homes in Conversano Italy and Conversano Italy vacation rentals
Riomaggiore Italy homes for rent, vacation homes for rent by owner in Riomaggiore Italy, and rental houses
Vacation homes for rent by owner Reggello, short term rentals in Reggello Italy, house rentals Reggello Italy, and rental properties in Reggello Italy
Lido Italy for rent by owner homes and condos for rent in Lido
Gubbio Italy vacation rentals, for rent by owner homes in Gubbio Italy, and vacation rentals in Gubbio Italy
Houses for rent Pietraviva Italy, Pietraviva Italy homes for rent, Pietraviva Italy homes for rent by owner, and rental homes Pietraviva
Condos for rent in Peschici and rental properties in Peschici
Real estate rentals in Spello Italy, Spello Italy apartments for rent, and rental houses in Spello Italy
Rent house in Sogna, short term rentals Sogna Italy, Sogna homes for rent by owner, and for rent by owner homes in Sogna Italy
Vacation rentals in Bucine and Bucine Italy home rentals
Sorgeto apartment rentals, rental home Sorgeto Italy, and vacation rental in Sorgeto Italy
Apartments for rent Procchio Italy, apartments for rent, Procchio bed and breakfast rentals, and Procchio Italy holiday rentals
Lesa vacation rental and rental apartment Lesa Italy
Pistoia real estate rentals, Pistoia Italy rental properties, and rent houses in Pistoia Italy
Rapolano Terme Italy vacation homes for rent by owner, house rentals in Rapolano Terme Italy, vacation homes for rent by owner Rapolano Terme, and Rapolano Terme Italy rental houses
Short term rentals Spinetoli and rental houses in Spinetoli
Argegno Italy condo rentals, Argegno Italy vacation rental, and vacation homes
Ascertain, discern, and discern rental homes in Fiesole Italy, holiday rentals Fiesole, and vacation rentals in Fiesole Italy.
Dig up and come upon rental properties Trecate and Trecate rental homes.
Look up, come across, and conceive Jesi Italy apartment rentals, Jesi Italy homes for rent, and vacation homes in Jesi Italy.
Contrive, look up, and identify house rentals, Lonate Pozzolo home rentals, and Lonate Pozzolo Italy vacation homes for rent by owner.
You can study the beach directories and beach ads under vacation homes, Dervio homes for rent by owner, and house rentals in Dervio.
Using FRBO.Com, For Rent By Owner,, landlords keep count villa and cabin listings.
Catch and contrive real estate rentals in Foggia and Foggia rent house.
Conceive and elicit Gambettola rental properties and Gambettola Italy short term rentals.
Find ad hoc, novel, and distinctive reports in Dervio Italy and spell out apartment rentals Dervio.
Perceive, relocate, and glimpse vacation homes in Valtournenche, rent houses in Valtournenche Italy, and Valtournenche vacation rental.
Dervio property owners, rental agents, and property managers list Dervio Italy house rentals, Dervio Italy rental homes, vacation rental Dervio Italy, and real estate rentals in Dervio Italy.
Roomers, displaced persons, and sightseers who are scrutinizing vacation rental in Dervio and are trying to design Dervio Italy rental home, vacation rentals Dervio, and bed and breakfast rentals in Dervio can shake down this website, FRBO.com and our romantic advertisements, lakefront directories, hillside classified ads, and convenient lists of marked properties.
This extensive website, FRBO.com does involve original private, decadent, studio, and studio apartment and duplexs.
Ferret out and uncover apartments for rent in San Secondo Parmense and condos for rent in San Secondo Parmense.
Come upon and espy rental home and homes for rent Capo d_Orlando.
Dig up, hear, and recognize Foggia apartments for rent, Foggia homes for rent, and rental houses Foggia Italy.
Observe and notice holiday rentals in Cittadella Italy and rent house Cittadella Italy.
Suburbanites and venturers look and smell around our site, FRBO.com and recognize beachfront chalet, rustic flat, well appointed flat, and exclusive vacation home.
Inaugurate your pursual online tomorrow evening, tomorrow evening, tomorrow morning, or tomorrow for your house rentals in Dervio Italy, Dervio Italy vacation homes for rent by owner, and Dervio Italy apartment rentals.
Recently vacated penthouse apartment, lakeside villa, and exotic houseboat are proximate in the convenient parcel of Dervio Italy.
Devise and elicit Abano Terme Italy vacation homes and rental houses Abano Terme.
Design and uncover home rentals and Reggio di Calabria rental apartment.
Dervio Italy proof could boost, ballyhoo, and collaborate your research.
Dig up, learn, and debunk Cuneo Italy apartments for rent, real estate rentals Cuneo, and vacation rental Cuneo.
Come upon and contrive viareggio Italy home rentals and vacation homes for rent by owner in viareggio Italy.
You can ascertain and discern homes for rent Dervio Italy and rental properties Dervio Italy.
Devise, catch, and identify rent houses in Udine Italy, Udine Italy apartment rentals, and short term rentals in Udine Italy.
Espy, recognize, and find out Ribera Italy condos for rent, rental properties, and apartment rentals Ribera Italy.
|
|
