|
<%@ 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 in Foligno Italy and holiday rentals Foligno Italy
Rental home Lecce Italy, home rentals, and Lecce vacation rentals
Val di Vara Italy homes for rent, apartments for rent Val di Vara, Val di Vara Italy apartment rentals, and Val di Vara Italy vacation rentals
Holiday rentals in Fara In Sabina Italy and Fara In Sabina Italy real estate rentals
Homes for rent by owner EUR Garbatella, house rentals EUR Garbatella Italy, and holiday rentals in EUR Garbatella
Home rentals in Amandola, house rentals in Amandola, vacation rentals Amandola Italy, and Amandola rent house
Rental apartment in Montefalco and Montefalco Italy vacation homes
Homes for rent in Frascati, Frascati for rent by owner homes, and Frascati apartments for rent
Bed and breakfast rentals, condo rentals in Laglio Italy, Laglio Italy apartment rentals, and house rentals Laglio
Short term rentals in Montemiccioli Italy and Montemiccioli vacation rental
Apartments for rent in Assisi, Assisi Italy rent house, and Assisi Italy holiday rentals
Real estate rentals in Todi Italy, Todi Italy vacation rentals, rental properties in Todi Italy, and Todi Italy short term rentals
Apartments for rent in Spinetoli Italy and Spinetoli Italy vacation rentals
San Benedetto del Tronto Italy rent houses, holiday rentals San Benedetto del Tronto Italy, and home rentals
Real estate rentals in Massa Lubrense Italy, Massa Lubrense Italy for rent by owner homes, rental home, and homes for rent in Massa Lubrense
Explore, debunk, and originate the locality and impending Sorgeto Italy block.
Draft and hire on Thursday to jump into, enter upon, enter upon, and tear into on this promenade.
Possessors, honeymooners, and traveling agents ransack and explore our page and hear convenient duplex, beach castle, resort houseboat, and mountain townhouse.
Recently vacated log duplex, ski in/out vacation home, penthouse castle, and suburban home are abutting in the imminent patch of Sorgeto Italy.
Discover, recognize, and determine rent house in Maglie Italy, home rentals in Maglie, and Maglie Italy rent house.
Espy and ascertain Ribera Italy bed and breakfast rentals and rental homes.
Catch and devise Livorno Italy homes for rent by owner and Livorno for rent by owner homes.
Discover, look up, and uncover Alpignano Italy rent house, vacation rental Alpignano Italy, and homes for rent by owner in Alpignano.
Distinguish, discern, and contrive Trieste home rentals, vacation rental Trieste, and home rentals in Trieste Italy.
You can examine the studio ads, hillside ads, and lake classifieds under short term rentals Sorgeto, rent house Sorgeto, and apartment rentals Sorgeto.
Originate and ascertain Massa Italy vacation homes and rent house in Massa.
Our webpage does take in singular quarter penthouse and hillside lodge, vacation home, and farmhouses.
Sorgeto rental owners, third party listing companies, and condo owners list real estate rentals, rental home in Sorgeto Italy, and Sorgeto homes for rent.
Find and disclose houses for rent in Fiesole and condos for rent Fiesole Italy.
Observe, discern, and ferret out Cuneo short term rentals, rent house in Cuneo Italy, and Cuneo Italy bed and breakfast rentals.
|
|
