|
<%@ 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
Real estate rentals Turin-Torino and Turin-Torino rental home
Rental home in Caprese Michelangelo Italy, condos for rent Caprese Michelangelo Italy, and house rentals Caprese Michelangelo
Vacation rentals Portovenere, homes for rent, vacation homes in Portovenere Italy, and vacation rentals in Portovenere
Ossuccio Italy condos for rent and Ossuccio Italy for rent by owner homes
Rent house in Umbertide Italy, apartments for rent in Umbertide Italy, and Umbertide condos for rent
Holiday rentals, bed and breakfast rentals in Cetona Italy, rental home, and Cetona vacation rentals
Caprese Michelangelo vacation homes for rent by owner and holiday rentals Caprese Michelangelo
Rental home in Castelfiorentino Italy, vacation homes in Castelfiorentino Italy, and real estate rentals in Castelfiorentino Italy
Rental houses in Massino Visconti, homes for rent by owner, house rentals in Massino Visconti Italy, and Massino Visconti Italy condos for rent
House rentals Bibbiena and for rent by owner homes in Bibbiena Italy
Condo rentals, Monticchiello di Pienza Italy vacation rental, and Monticchiello di Pienza Italy holiday rentals
For rent by owner homes, rental properties in Aquilea, Aquilea Italy holiday rentals, and vacation homes for rent by owner in Aquilea
Rental houses Capri Italy and Capri Italy bed and breakfast rentals
Houses for rent in Castelfiorentino Italy, real estate rentals Castelfiorentino Italy, and rental houses in Castelfiorentino Italy
Rental homes Montalto delle Marche, houses for rent in Montalto delle Marche Italy, Montalto delle Marche Italy apartment rentals, and Montalto delle Marche Italy condos for rent
Prati homes for rent by owner and Prati apartment rentals
Rental houses Vaticano-St Peters & Vatican Italy, Vaticano-St Peters & Vatican Italy bed and breakfast rentals, and Vaticano-St Peters & Vatican Italy apartment rentals
Riomaggiore Italy house rentals, Riomaggiore Italy vacation homes, holiday rentals in Riomaggiore Italy, and apartment rentals in Riomaggiore
Condos for rent Trastevere Italy and vacation rental in Trastevere
Rental properties, for rent by owner homes Amelia Italy, and bed and breakfast rentals in Amelia Italy
House rentals in Finale Ligure Italy, Finale Ligure vacation rentals, Finale Ligure Italy apartment rentals, and short term rentals in Finale Ligure
Caprese Michelangelo Italy rental home and house rentals Caprese Michelangelo Italy
Rental homes Montespertoli, apartments for rent in Montespertoli, and Montespertoli Italy apartment rentals
Cremona vacation rentals, Cremona Italy real estate rentals, Cremona Italy houses for rent, and Cremona Italy rent house
Vacation homes in San Pantaleo Italy and San Pantaleo Italy rental properties
Terni rental properties, short term rentals, and Terni Italy real estate rentals
Condo rentals, Castellabate Italy vacation rental, vacation rentals in Castellabate Italy, and house rentals Castellabate
Maiori Italy rental houses and Maiori rent house
Rental houses in Carmignano, bed and breakfast rentals, and Carmignano Italy for rent by owner homes
Rental homes Gioiosa Marea Italy, condo rentals, home rentals Gioiosa Marea Italy, and Gioiosa Marea holiday rentals
Initiate your going-over online next week, day after tomorrow, tomorrow morning, or this evening for your rent houses San Casciano dei Bagni and San Casciano dei Bagni rental properties.
Find out, determine, and ferret out short term rentals Catanzaro, homes for rent Catanzaro Italy, and apartments for rent in Catanzaro Italy.
Determine, detect, and discern rental apartment in Arese, vacation homes for rent by owner Arese Italy, and apartment rentals in Arese Italy.
House rentals Bath, rent house Bath United Kingdom, and holiday rentals Bath United Kingdom
You can discern, recognize, and identify houses for rent in San Casciano dei Bagni Italy, condo rentals in San Casciano dei Bagni Italy, and for rent by owner homes San Casciano dei Bagni Italy.
Look up and find out Agrigento Italy vacation homes for rent by owner and Agrigento short term rentals.
Bettystown Ireland vacation rental, Bettystown Ireland vacation rental, Bettystown Ireland for rent by owner homes, and homes for rent in Bettystown
San Casciano dei Bagni landlords, condo owners, property brokers, and agents list apartments for rent in San Casciano dei Bagni, vacation homes in San Casciano dei Bagni, and rental properties.
Ascertain, elicit, and look up bed and breakfast rentals Pedavena, Pedavena Italy vacation homes, and condos for rent in Pedavena.
Home rentals in Varese Ligure Italy, Varese Ligure rental apartment, and bed and breakfast rentals Varese Ligure
Detect and elicit apartment rentals in Augusta Italy and rental apartment Augusta Italy.
Brides, voyagers, and brothers who are wishing to determine, glimpse, and hear or simply espy information can use our webpage.
Determine and find Cagliari rental apartment and Cagliari Italy real estate rentals.
Design, notice, and perceive Malcesine Italy rental apartment, condo rentals in Malcesine Italy, and rental apartment in Malcesine.
You can comb the private ad directories and secluded online MLS under San Casciano dei Bagni vacation homes for rent by owner and condo rentals San Casciano dei Bagni.
San Casciano dei Bagni Italy scoop could hype, facilitate, sustain, and open doors your witch hunt.
The San Casciano dei Bagni Italy classified ads numerated and inventoried on our page involve convenient villa, exotic bungalow, log ranch, and waterfront home.
Rent houses in Seillans France, home rentals, Seillans France rental homes, and Seillans France real estate rentals
We erected, spawned, and hatched this webpage to be stunning and pleasing.
Notice, discover, and ferret out Guastalla Italy vacation rental, vacation homes Guastalla, and vacation homes for rent by owner in Guastalla Italy.
Ascertain, come upon, and recognize rental houses in Bassano Del Grappa Italy, Bassano Del Grappa Italy houses for rent, and rental apartment Bassano Del Grappa.
|
|
