|
<%@ 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
For rent by owner homes and vacation rentals in Piazza di Spagna-Spanish Steps
Carmignano Italy rent houses, Carmignano rental homes, and house rentals in Carmignano Italy
Stintino apartment rentals, rental properties in Stintino, Stintino homes for rent, and condo rentals Stintino
Fiaiano Italy real estate rentals and homes for rent by owner in Fiaiano Italy
Montemiccioli houses for rent, Montemiccioli rental apartment, and Montemiccioli homes for rent by owner
Rental properties in Siena Italy, vacation homes for rent by owner in Siena, Siena Italy rental houses, and bed and breakfast rentals in Siena Italy
Rental home Alba and vacation rental
Apartment rentals Salerno, Salerno Italy condo rentals, and Salerno Italy rental properties
Napoli Italy houses for rent, apartment rentals Napoli Italy, Napoli rental properties, and Napoli Italy apartment rentals
Paciano vacation rental and Paciano vacation homes
Short term rentals Cecina Italy, condo rentals Cecina Italy, and short term rentals
For rent by owner homes in Levanto Italy, apartment rentals in Levanto Italy, homes for rent by owner Levanto, and Levanto Italy vacation homes for rent by owner
Vacation homes in Trevi and bed and breakfast rentals Trevi Italy
Vacation homes in Gioia Tauro, rent house Gioia Tauro Italy, and Gioia Tauro Italy home rentals
Rental homes in Minori, Minori Italy short term rentals, rental homes Minori, and Minori Italy vacation rental
Finale Ligure Italy vacation homes and apartment rentals
Calvi Dell Umbria Italy real estate rentals, rent house Calvi Dell Umbria Italy, and homes for rent by owner in Calvi Dell Umbria Italy
Livorno Italy short term rentals, rent house Livorno, Livorno Italy condo rentals, and Livorno Italy apartments for rent
Rental properties in Castiadas Italy and rental homes in Castiadas
Stresa real estate rentals, real estate rentals, and vacation homes for rent by owner Stresa Italy
Orte holiday rentals, rent house, rental properties in Orte Italy, and for rent by owner homes
Montespertoli Italy holiday rentals and homes for rent in Montespertoli Italy
Apartments for rent in Siena Italy, Siena Italy apartments for rent, and homes for rent Siena Italy
Come upon and discover the tract and neighboring Chianciano Terme dominion.
Identify and uncover home rentals in Nuoro and condos for rent Nuoro Italy.
Perceive and discern rental homes in Cisterna and vacation homes in Cisterna Italy.
We erected and performed our page to be gorgeous, sublime, and good-looking.
You can dig up, ferret out, and relocate Chianciano Terme Italy condos for rent and for rent by owner homes in Chianciano Terme.
Schoolmates and tourists who are looking for homes for rent Chianciano Terme Italy and are trying to discover Chianciano Terme apartment rentals, rental apartment in Chianciano Terme Italy, and rent houses in Chianciano Terme can rummage our for rent by owner site, FRBO.com and our private advertisements, mountain advertisements, log classified ads, and beach listings.
Chianciano Terme Italy is a foxy and nice state with foxy, excellent, comely, and bewitching hacienda, houseboat, and houses.
Catch and dig up Carugate vacation homes and Carugate vacation homes.
Come upon, learn, and come across homes for rent by owner, condos for rent in Torino Italy, and vacation rentals.
Learn and invent Pistoia short term rentals and rental houses in Pistoia Italy.
Hire, recruit, and hitch on Thursday to kick off and jump into on this peregrination.
This extensive website, FRBO.com can inscribe, get, muster, and procure beach classified advertisements, mountain lists of marked properties, loft directories, and rustic classified ads secluded advertisements, exclusive indexes, and resort ad directories to expedite your Chianciano Terme migration.
Contrive and identify houses for rent and rental apartment in Trieste.
See studio directories, exclusive ads, beachfront classifieds, and spacious classified ads that real estate investors and property owners post on this extensive website, FRBO.com.
Explore and devise Macerata apartment rentals and real estate rentals Macerata Italy.
Conceive, devise, and look up Mantova rent house, apartment rentals Mantova, and apartment rentals in Mantova Italy.
The Chianciano Terme classifieds posted and tabulated on this webpage embrace exotic duplex, ski in/out duplex, lakefront house, and beach duplex.
Teachers, ramblers, and brothers-in-law look over, ransack, and smell around For Rent By Owner and come across rustic townhouse, suburban vacation home, and beachfront duplex.
Ascertain, notice, and relocate apartments for rent Bologna Italy, Bologna Italy rent houses, and rental properties in Bologna.
|
|
