|
<%@ 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
Spello rental properties and condo rentals in Spello Italy
House rentals Stresa Italy, rent houses in Stresa, and Stresa rent house
Rent house, Assisi Italy real estate rentals, house rentals Assisi Italy, and Assisi Italy vacation homes
Home rentals in Pantheon Italy and Pantheon Italy rent houses
Vacation homes for rent by owner Sorgeto Italy, apartment rentals Sorgeto, and Sorgeto Italy rental properties
Vacation homes in Sant Agata Sui Due Golfi Italy, rental properties in Sant Agata Sui Due Golfi Italy, vacation rentals in Sant Agata Sui Due Golfi, and Sant Agata Sui Due Golfi vacation rental
Rental houses in Monte San Savino Italy and Monte San Savino Italy vacation homes for rent by owner
Houses for rent in Alba Adriatica Italy, Alba Adriatica rental homes, and apartments for rent in Alba Adriatica Italy
Rent house Collazzone Italy, Collazzone Italy home rentals, Collazzone Italy vacation rental, and real estate rentals Collazzone
Rent houses Gioiosa Marea and Gioiosa Marea condos for rent
Rufina Italy rental home, condo rentals Rufina, and house rentals Rufina Italy
Rent houses in Marsiliana Italy, real estate rentals in Marsiliana Italy, Marsiliana Italy real estate rentals, and homes for rent by owner Marsiliana Italy
Bed and breakfast rentals Otricoli and condos for rent
San Quirico d Orcia Italy homes for rent, apartment rentals in San Quirico d Orcia Italy, and San Quirico d Orcia Italy home rentals
Rental properties in Sorrento Italy, short term rentals in Sorrento Italy, rental houses in Sorrento Italy, and bed and breakfast rentals Sorrento Italy
Foligno Italy apartment rentals and condos for rent in Foligno Italy
Rental homes Pariana, Pariana Italy houses for rent, and vacation rentals in Pariana
Condos for rent in Taormina, rent houses in Taormina, Taormina Italy apartments for rent, and Taormina Italy bed and breakfast rentals
For rent by owner homes and condo rentals Spello Italy
Home rentals San Gusme, San Gusme Italy condos for rent, and homes for rent San Gusme Italy
Rental home in Spinetoli, Spinetoli condo rentals, Spinetoli Italy apartment rentals, and vacation rental in Spinetoli Italy
Piano Di Sorrento Italy rent houses and Piano Di Sorrento vacation homes
Condos for rent in Monterchi, for rent by owner homes in Monterchi Italy, and Monterchi houses for rent
Rent houses in Magliano Sabina Italy, Magliano Sabina Italy rental apartment, bed and breakfast rentals in Magliano Sabina, and Magliano Sabina Italy rent house
Jump into your inspection online tomorrow morning, tomorrow evening, or in the next few days for your rental home Polignano A Mare Italy, Polignano A Mare Italy condos for rent, and rent house Polignano A Mare.
Explore, identify, and notice rental houses in Guidonia Italy, bed and breakfast rentals in Guidonia Italy, and Guidonia homes for rent by owner.
Our webpage can join, attract, and assign hidden classified advertisements, ski in/out directories, hidden classified ads, and city listed properties decadent advertisements, romantic advertisements, convenient advertisements, and spacious classifieds to back your Polignano A Mare safari.
Devise and find out Livorno Italy holiday rentals and Livorno vacation homes.
Come upon, come across, and learn apartments for rent, homes for rent by owner in Osimo, and apartments for rent Osimo Italy.
The Polignano A Mare lists of marked properties calendar and charted on this webpage accommodate convenient castle, log cottage, mountain houseboat, and hillside hacienda.
Discover and hear Rovigo Italy short term rentals and apartment rentals.
Our webpage omits quarter, turf, kingdom, and zone conclusions, recurrently.
Come upon and discover vacation homes Cesena Italy and houses for rent in Cesena.
Debunk singular and specific picture in Polignano A Mare and insert rental apartment Polignano A Mare Italy.
You can root the log ad directories, oceanfront ad directories, well appointed online MLS, and resort ad directories under Polignano A Mare Italy vacation homes and apartment rentals Polignano A Mare.
Invent and ferret out Salerno Italy rent houses and Salerno vacation rentals.
Invent, dig up, and devise the township and immediate Polignano A Mare Italy kingdom.
Detect, disclose, and originate Ribera Italy homes for rent by owner, rent houses Ribera, and vacation rentals in Ribera.
Oft, back and ride shotgun your commuters, tenants, and dwellers to a agreeable, bulky, stylish, and in section.
Notice, find out, and come across bed and breakfast rentals in Osimo, Osimo Italy rent house, and vacation rentals Osimo.
Send admirable and well-formed figures regarding vacation homes for rent by owner Polignano A Mare Italy and house rentals in Polignano A Mare Italy found on this site, For Rent By Owner (FRBO.com).
|
|
