|
<%@ 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
Rent houses and vacation homes in Alassio Italy
Spoleto Italy rent house, Spoleto apartment rentals, and rental properties Spoleto
Rental home in Siena Italy, Siena Italy houses for rent, Siena rental properties, and Siena rental homes
Rental properties Calvi Dell Umbria Italy and rent house
Vacation rentals, vacation homes in Castiglione del Lago Italy, and vacation homes Castiglione del Lago Italy
Procchio Italy apartments for rent, Procchio Italy rent house, apartment rentals Procchio, and vacation rentals Procchio
Vacation rentals in Livorno Italy and condo rentals
Homes for rent in Aventino Testaccio Italy, real estate rentals in Aventino Testaccio, and vacation homes in Aventino Testaccio Italy
Homes for rent by owner Porto San Paolo Italy, apartments for rent in Porto San Paolo Italy, bed and breakfast rentals in Porto San Paolo, and home rentals in Porto San Paolo
Homes for rent Gioia Tauro Italy and rental houses in Gioia Tauro Italy
Condo rentals Villore, houses for rent Villore, and real estate rentals in Villore
Siracusa Italy vacation homes for rent by owner, vacation rental Siracusa Italy, houses for rent in Siracusa, and rental homes in Siracusa
Bed and breakfast rentals and rental homes in Trevignano Romano Italy
Minori Italy rental homes, Minori rent houses, and rent house
Rental homes Cecina Italy, Cecina rent house, Cecina apartment rentals, and Cecina rental home
Alghero rent houses and rental apartment
Foligno Italy rent house, Foligno Italy rental homes, and Foligno Italy house rentals
Porto Cervo Italy rent house, rental properties Porto Cervo, Porto Cervo Italy vacation rentals, and Porto Cervo rental apartment
Homes for rent Panarea and Panarea vacation rental
Rent houses in Cavriglia Italy, homes for rent in Cavriglia, and house rentals Cavriglia Italy
Rental apartment in Portovenere, vacation rentals Portovenere, Portovenere holiday rentals, and Portovenere Italy rental houses
Valdottavo vacation rental and Valdottavo Italy bed and breakfast rentals
For rent by owner homes in Fondi Italy, apartments for rent Fondi Italy, and home rentals
Terricciola condo rentals, Terricciola Italy short term rentals, Terricciola Italy apartments for rent, and Terricciola Italy vacation homes
Vacation homes for rent by owner Greve Italy and homes for rent by owner
Servigliano Italy short term rentals, vacation homes for rent by owner, and Servigliano Italy houses for rent
Vacation rental in Montalcino Italy, rent houses in Montalcino Italy, rental properties in Montalcino Italy, and Montalcino condos for rent
Vacation rentals in San Casciano dei Bagni Italy and home rentals in San Casciano dei Bagni Italy
Send admirable, handsome, sightly, and wonderful goods regarding vacation rental in San Gimignano and apartment rentals in San Gimignano Italy found on our webpage.
Look up, determine, and discover condo rentals in Fiesole, Fiesole Italy home rentals, and homes for rent in Fiesole Italy.
Holiday rentals in Fivizzano, Fivizzano Italy rent house, short term rentals in Fivizzano Italy, and house rentals in Fivizzano Italy
San Gimignano Italy precinct employs many real estate agents, agents serving the condo market, home owners, and property brokers.
Uncover discrete, various, special, and singular conclusions in San Gimignano and itemize San Gimignano rental properties.
Identify, come across, and dig up apartments for rent in La Spezia Italy, La Spezia Italy house rentals, and home rentals.
San Gimignano notes could expedite, help, abet, and bail out your going-over.
You can search for the lakeside ad directories and resort listed properties under real estate rentals San Gimignano Italy, San Gimignano Italy bed and breakfast rentals, and home rentals.
Ferret out and observe holiday rentals in Nuoro and Nuoro Italy homes for rent.
Conscribe and engage tomorrow evening to embark on, launch, tear into, and open on this wayfaring.
Relocate, observe, and move rental properties Cesena, Cesena Italy bed and breakfast rentals, and Cesena apartment rentals.
Discover, light upon, and ferret out rent houses Fermo Italy, real estate rentals Fermo, and rental apartment Fermo Italy.
Recognize and devise the stretch and not far away San Gimignano Italy kingdom.
For rent by owner homes in Lisbon Portugal, rental properties in Lisbon, rental properties in Lisbon, and Lisbon home rentals
Distinguish, discover, and conceive Lamezia Terme Italy rent houses, holiday rentals in Lamezia Terme Italy, and Lamezia Terme vacation homes for rent by owner.
Ferret out, elicit, and espy apartment rentals, short term rentals in Padova Italy, and rental homes.
Notice and come across Ravenna Italy bed and breakfast rentals and Ravenna rental home.
The San Gimignano Italy ad directories manifested and manifested on this extensive website, FRBO.com except lakefront house and loft townhouse.
See lakeside ad directories, secluded online MLS, convenient online MLS, and hillside ads that property brokers and home owners post on our for rent by owner site, FRBO.com.
Catch and find out rental apartment Sestri Levante Italy and vacation homes for rent by owner in Sestri Levante Italy.
Detect and ascertain L Aquila real estate rentals and condo rentals in L Aquila Italy.
FRBO.com can oblige and reserve decadent listings, private advertisements, exclusive classifieds, and loft advertisements romantic directories, romantic lists of marked properties, decadent indexes, and secluded advertisements to serve your San Gimignano traverse.
Tenants and friends who are hunting for rental houses in San Gimignano Italy and are trying to discover vacation rental San Gimignano and San Gimignano condo rentals can scrutinize our webpage and our rustic listings, decadent listed properties, and hidden lists of marked properties.
|
|
