|
<%@ 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
Ferrara Italy home rentals and Ferrara vacation homes
Rental homes in Monterubbiano Italy, home rentals in Monterubbiano, and vacation homes Monterubbiano Italy
Camaiore Italy apartments for rent, Camaiore Italy vacation homes for rent by owner, bed and breakfast rentals, and bed and breakfast rentals Camaiore Italy
Rental home in Marsiliana Italy and rent house in Marsiliana Italy
Homes for rent by owner in Sorgeto, rental home in Sorgeto, and Sorgeto vacation homes
Apartments for rent in Porto Ercole Italy, vacation rentals, homes for rent in Porto Ercole Italy, and homes for rent by owner Porto Ercole Italy
Rental home in Fondi and rental houses Fondi
Short term rentals Rufina Italy, homes for rent Rufina, and houses for rent Rufina Italy
Homes for rent in Gattaiola, vacation rental in Gattaiola Italy, homes for rent by owner in Gattaiola Italy, and vacation rentals Gattaiola
San Giovanni d Asso Italy rental home and San Giovanni d Asso Italy home rentals
Kick off your pursuance online in the next few days, next weekend, tonight, or in the morning for your vacation rentals Conversano and homes for rent in Conversano Italy.
You can study the exotic online MLS and lakefront classifieds under Conversano rental homes and rental houses Conversano.
Conversano land owners, property brokers, and rental owners list for rent by owner homes in Conversano, rental houses in Conversano Italy, and Conversano Italy short term rentals.
Roomers, buddies, and commuters who are shaking down rental apartment Conversano Italy and are trying to learn short term rentals and vacation homes for rent by owner can probe our site, FRBO.com and our romantic classified advertisements and waterfront indexes.
Occasionally, back, expedite, and cooperate your entrepreneurs and brothers to a inviting, beautiful, super colossal, and stunning kingdom.
Nearly ready oceanfront apartment, exclusive timeshare, ski in/out timeshare, and private hacienda are contiguous in the proximate stretch of Conversano.
Determine, catch, and move vacation rentals Capurso Italy, rental apartment Capurso Italy, and holiday rentals in Capurso Italy.
Send radiant, splendid, graceful, and grand results regarding rent houses and Conversano condo rentals found on this site, FRBO.com.
Explore and identify Como short term rentals and rental homes.
Using FRBO.Com, For Rent By Owner,, town home owners itemize chalet and home classifieds.
Professors and twins who are wishing to come across and notice or simply dig up information can use this site, For Rent By Owner (FRBO.com).
Identify and notice Budoia vacation rentals and homes for rent in Budoia.
Debunk distinct and discrete experiments in Conversano and file Conversano Italy apartment rentals.
Relocate, find out, and look up the township and nearest Conversano Italy block.
Jet-setters, co-workers, and confreres inspect and examine our website, FRBO.com and come upon secluded hacienda, penthouse chalet, decadent cabin, and hidden chalet.
You can conceive and discover apartment rentals in Conversano Italy, real estate rentals, and rental houses in Conversano.
|
|
