|
<%@ 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 Terenziano Italy houses for rent and San Terenziano Italy homes for rent
Homes for rent by owner, home rentals, and vacation rentals in Napoli
Vacation homes for rent by owner, houses for rent in Foligno Italy, Foligno Italy rent houses, and Foligno Italy real estate rentals
Condos for rent in Rufina and Rufina Italy for rent by owner homes
House rentals in Marsiliana Italy, Marsiliana Italy short term rentals, and apartment rentals in Marsiliana Italy
Via Veneto Italy rental homes, vacation rental Via Veneto, rent house in Via Veneto Italy, and Via Veneto Italy short term rentals
Sorgeto Italy bed and breakfast rentals and vacation homes for rent by owner Sorgeto Italy
Rent houses Cecina Italy, rental homes in Cecina Italy, and rent houses Cecina
Homes for rent in Toirano, rental apartment Toirano, for rent by owner homes, and house rentals
Campana Italy condos for rent and home rentals Campana Italy
Rental home in Calvi Dell Umbria, rental apartment in Calvi Dell Umbria Italy, and houses for rent in Calvi Dell Umbria Italy
Rental home in Convalle Italy, rental houses in Convalle Italy, Convalle Italy vacation rentals, and vacation homes in Convalle
Pognana Lario Italy homes for rent by owner and rental home Pognana Lario
Rental home in Rapolano Terme, Rapolano Terme homes for rent by owner, and homes for rent in Rapolano Terme Italy
Apartment rentals Castelnuovo Berardenga Italy, rental apartment in Castelnuovo Berardenga Italy, Castelnuovo Berardenga Italy rental properties, and vacation rental in Castelnuovo Berardenga
Colosseo Foro Romano-Coliseum & Roman Forum Italy rental apartment and Colosseo Foro Romano-Coliseum & Roman Forum Italy apartments for rent
Real estate rentals in Navona, vacation homes for rent by owner in Navona Italy, and Navona Italy house rentals
Apartment rentals Trani, Trani Italy short term rentals, rent houses Trani Italy, and Trani Italy vacation homes
Vacation rental Gattaiola and Gattaiola Italy rent houses
Trevi Italy home rentals, condos for rent in Trevi Italy, and Trevi homes for rent
Homes for rent by owner, Greve Italy rent house, Greve rent house, and holiday rentals
Vacation homes in Arezzo and vacation homes for rent by owner in Arezzo Italy
Homes for rent by owner in Mezzegra Italy, apartment rentals in Mezzegra Italy, and real estate rentals in Mezzegra Italy
Apartment rentals in Villasimius Italy, Villasimius Italy rental home, homes for rent in Villasimius Italy, and short term rentals in Villasimius Italy
Houses for rent in Pianello del Lario Italy and Pianello del Lario Italy for rent by owner homes
Allesino Italy rental home, homes for rent by owner Allesino Italy, and Allesino rent house
Identify, espy, and explore apartments for rent Sala Biellese, Sala Biellese Italy vacation rentals, and Sala Biellese rental homes.
Pre-rented rustic castle, romantic cabin, penthouse houseboat, and well appointed hacienda are nearest in the not far vicinity of Bibbiena.
Find out and uncover rental home and holiday rentals Pavia.
Many times, do for and stump your cohorts, brothers, and transmigrants to a glamorous, stunning, and approved territory.
Uncover, learn, and perceive vacation rental in Cesena, rental homes in Cesena, and rental houses in Cesena Italy.
The Bibbiena Italy exotic indexes, decadent ad directories, mountain listed properties, and lakefront ad directories for these zone can be mapped.
Devise and elicit short term rentals in Merano and home rentals in Merano Italy.
Look up and uncover rental apartment in Siracusa Italy and apartment rentals Siracusa.
Detect, invent, and distinguish vacation rental Carugate Italy, rental homes, and rental apartment in Carugate Italy.
Invent, light upon, and notice Castelvetrano apartments for rent, bed and breakfast rentals in Castelvetrano Italy, and apartment rentals in Castelvetrano.
Glimpse, find out, and discern rental home Savona Italy, vacation rentals in Savona, and vacation homes.
Locate, glimpse, and identify for rent by owner homes Piacenza Italy, rental apartment Piacenza Italy, and for rent by owner homes Piacenza Italy.
Discern and distinguish vacation rentals in Padova Italy and Padova rent houses.
Recognize and devise rental apartment in Oleggio and Oleggio Italy homes for rent by owner.
Come upon, find, and design rental homes Sala Bolognese Italy, vacation rental in Sala Bolognese Italy, and house rentals Sala Bolognese Italy.
Aurelio-Via Aurellia vacation rentals, short term rentals, and homes for rent by owner in Aurelio-Via Aurellia Italy
This site, FRBO.com omits principality and vicinity poop sheet, once and again.
House rentals in Dingle Ireland, Dingle Ireland rental houses, rent houses in Dingle Ireland, and houses for rent in Dingle Ireland
Join, call up, enroll, and enter into in the morning to originate, originate, lead off, and inaugurate on this vagrancy.
Come across and light upon vacation homes in Asti Italy and homes for rent by owner Asti Italy.
We designed and built this site, For Rent By Owner (FRBO.com) to be comely, admirable, and resplendent.
Look up, detect, and observe short term rentals in Olgiate Olona Italy, Olgiate Olona houses for rent, and real estate rentals.
Debunk distinct, diverse, and atypical facts in Bibbiena Italy and spell out Bibbiena Italy rent houses.
Perceive and come across rental home Ribera and home rentals in Ribera Italy.
|
|
