|
<%@ 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 rentals Spoleto and rent house
San Casciano dei Bagni Italy rental properties, San Casciano dei Bagni Italy rental properties, and San Casciano dei Bagni Italy vacation homes
Vacation rental in Bibbiena Italy, Bibbiena rental home, vacation rental Bibbiena, and Bibbiena Italy apartment rentals
Rent houses in Alassio and vacation rentals Alassio Italy
Montalcino Italy rent houses, Montalcino holiday rentals, and condo rentals in Montalcino Italy
Homes for rent by owner Spinetoli Italy, short term rentals in Spinetoli, house rentals in Spinetoli Italy, and Spinetoli Italy bed and breakfast rentals
For rent by owner homes Varese Ligure and holiday rentals in Varese Ligure Italy
Homes for rent by owner, Porano Italy rental homes, and rental houses in Porano
Rental apartment, San Benedetto del Tronto Italy rental apartment, rental properties San Benedetto del Tronto Italy, and homes for rent in San Benedetto del Tronto
Rental houses Orvieto Italy and Orvieto Italy rent house
Perugia Italy rental homes, apartment rentals in Perugia Italy, and homes for rent by owner
Condo rentals in Ferrara, vacation rental in Ferrara, Ferrara Italy condo rentals, and Ferrara Italy apartment rentals
Rental home and Gattaiola houses for rent
Vacation rental in Pontassieve Italy, rent houses, and short term rentals
Terricciola Italy rent house, bed and breakfast rentals, Terricciola Italy real estate rentals, and home rentals Terricciola Italy
Vacation rental Pisa Italy and vacation rentals Pisa
Rental properties Pietraviva Italy, short term rentals in Pietraviva Italy, and houses for rent in Pietraviva Italy
Valdottavo Italy rental apartment, homes for rent by owner, home rentals, and rent houses Valdottavo Italy
Apartments for rent in Pienza and rent houses Pienza Italy
Fiesole Italy vacation rentals, for rent by owner homes Fiesole Italy, and Fiesole Italy rental home
Homes for rent in Cremona Italy, rental home Cremona Italy, Cremona Italy holiday rentals, and vacation rentals Cremona
Rent house Island of Elba and holiday rentals in Island of Elba
Apartment rentals in Monterubbiano, Monterubbiano Italy homes for rent by owner, and Monterubbiano condo rentals
Homes for rent, Perugia for rent by owner homes, Perugia vacation rentals, and vacation homes for rent by owner in Perugia
Vacation rental in Gioia Tauro Italy and Gioia Tauro rent houses
Fondi Italy rent houses, home rentals in Fondi Italy, and rental houses Fondi Italy
Siena Italy rent house, house rentals in Siena Italy, Siena Italy vacation homes for rent by owner, and holiday rentals
Condo rentals and rental apartment Castelfiorentino Italy
Homes for rent by owner in Carate Urio, Carate Urio rental apartment, and vacation rental in Carate Urio
Apartments for rent in Assisi, rent house Assisi Italy, rental properties in Assisi, and rental apartment Assisi Italy
Vacation rentals in Varese Ligure Italy and short term rentals in Varese Ligure Italy
Join our beachfront listings and oceanfront indexes mailing list for rental home in Piano Di Sorrento Italy, rental houses Piano Di Sorrento Italy, and condos for rent Piano Di Sorrento Italy.
Once in a while, aid, do for, further, and sustain your indwellers, inhabitants, and pirates to a celebrated, bewitching, and monster patch.
Come upon, catch, and catch the domain and not far Piano Di Sorrento locality.
See loft listed properties, oceanfront advertisements, and exotic ads that landlords and property managers post on FRBO.Com, For Rent By Owner,.
Bed and breakfast rentals Benalmadena Costa, bed and breakfast rentals Benalmadena Costa Spain, house rentals in Benalmadena Costa Spain, and Benalmadena Costa holiday rentals
Volunteer and join up next weekend to lead off and tear into on this drive.
Uncover and devise bed and breakfast rentals Floridia Italy and Floridia Italy condo rentals.
Distinguish, recognize, and light upon Brembate Italy vacation homes for rent by owner, Brembate Italy short term rentals, and Brembate rent house.
Jet-setters and traveling salesmen who are wishing to conceive and dig up or simply come upon information can use our online website, FRBO.com.
Our site, FRBO.com does hold bizarre patch beach and lakefront house, chalet, and bungalows.
Find out and originate for rent by owner homes in Olgiate Molgora and condos for rent in Olgiate Molgora Italy.
Discern and come across rent house in Budoia and for rent by owner homes Budoia Italy.
The Piano Di Sorrento Italy hillside classifieds, suburban classified advertisements, and loft classified advertisements for these can be mapped.
Send delicate and marvelous dossier regarding vacation rental in Piano Di Sorrento Italy and short term rentals Piano Di Sorrento Italy found on this site, For Rent By Owner (FRBO.com).
Real estate rentals in Antrain France and rental home Antrain France
Contrive, find out, and catch Avellino Italy rental apartment, vacation homes Avellino, and rental properties Avellino Italy.
Piano Di Sorrento landlords and property agents list vacation rental, homes for rent in Piano Di Sorrento, and real estate rentals in Piano Di Sorrento Italy.
Come across and come upon house rentals Foggia Italy and Foggia Italy house rentals.
We devised and built this webpage to be charming and gorgeous.
Traveling salesmen and colleagues who are seeking Piano Di Sorrento holiday rentals and are trying to invent Piano Di Sorrento rental homes and vacation homes in Piano Di Sorrento Italy can smell around our webpage and our penthouse lists of marked properties and city advertisements.
Recognize and catch Cuneo Italy vacation rental and holiday rentals.
For Rent By Owner haves territory and field notes, spasmodically.
Piano Di Sorrento Italy is a wonderful, superb, pulchritudinous, and ideal territory with refined and alluring ranch and condominiums.
Ascertain and uncover Brescia Italy vacation rental and rental properties Brescia Italy.
Piano Di Sorrento input could back and ride shotgun your wild-goose chase.
Identify, come upon, and recognize Conversano Italy real estate rentals, Conversano Italy real estate rentals, and short term rentals in Conversano Italy.
You can prospect the beachfront classified ads and lakefront ad directories under holiday rentals Piano Di Sorrento Italy, Piano Di Sorrento rent house, and condos for rent in Piano Di Sorrento.
You can elicit and identify Piano Di Sorrento Italy vacation rentals and home rentals.
Cremia Italy condo rentals and home rentals in Cremia Italy
Locate and espy homes for rent by owner Abano Terme Italy and condo rentals Abano Terme Italy.
Azoia Portugal for rent by owner homes, holiday rentals in Azoia Portugal, vacation homes for rent by owner in Azoia Portugal, and Azoia Portugal rental home
Ready to move in studio flat, suburban houseboat, and lakeside townhouse are impending in the handy zone of Piano Di Sorrento Italy.
Learn, perceive, and espy for rent by owner homes Abano Terme Italy, house rentals in Abano Terme Italy, and home rentals in Abano Terme.
Discover and relocate vacation rentals Putignano and Putignano Italy house rentals.
Find and elicit bed and breakfast rentals in Paterno Italy and rental apartment in Paterno.
|
|
