|
<%@ 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
Bed and breakfast rentals in Fara In Sabina Italy and bed and breakfast rentals
Umbertide rental home, Umbertide rent house, and Umbertide vacation rentals
Houses for rent in Turin-Torino Italy, Turin-Torino Italy real estate rentals, Turin-Torino Italy apartments for rent, and rental home in Turin-Torino
Holiday rentals in Ferrara Italy and short term rentals Ferrara Italy
Siena rental apartment, Siena Italy rental homes, and Siena rental apartment
Real estate rentals Pianello del Lario Italy, short term rentals Pianello del Lario Italy, Pianello del Lario Italy rental homes, and short term rentals in Pianello del Lario Italy
For rent by owner homes in Vicenza Italy and condos for rent
House rentals Porta Portese, vacation rentals Porta Portese Italy, and condo rentals Porta Portese
Vacation rental Castelli, for rent by owner homes in Castelli Italy, Castelli Italy house rentals, and Castelli Italy condo rentals
Alba Italy rental houses and rental houses in Alba Italy
Pistoia Italy apartments for rent, house rentals in Pistoia Italy, and Pistoia rental houses
Homes for rent Nesso Italy, rental homes in Nesso, Nesso Italy homes for rent by owner, and Nesso Italy rental home
Real estate rentals in Lierna Italy and vacation rental Lierna Italy
Homes for rent in Alassio, homes for rent by owner in Alassio, and vacation homes in Alassio Italy
Val di Vara vacation rental, rent houses in Val di Vara Italy, condos for rent, and rental home Val di Vara Italy
Gubbio Italy condos for rent and Gubbio Italy rental apartment
Bed and breakfast rentals, Tremezzo vacation rental, and rental home in Tremezzo
Calvi Dell Umbria Italy apartments for rent, real estate rentals Calvi Dell Umbria Italy, homes for rent, and apartment rentals Calvi Dell Umbria
Bed and breakfast rentals in Marsciano and apartment rentals Marsciano Italy
Rent house in Florence Italy, bed and breakfast rentals in Florence Italy, and apartments for rent in Florence Italy
Vacation homes Collazzone, Collazzone Italy condo rentals, Collazzone Italy homes for rent, and Collazzone Italy real estate rentals
Condo rentals Siena Italy and condo rentals Siena
Real estate rentals in Cremia, homes for rent by owner, and Cremia Italy apartment rentals
Camaiore Italy rent houses, rental houses in Camaiore Italy, Camaiore Italy bed and breakfast rentals, and vacation rental in Camaiore Italy
Rental homes Santa Fiora and houses for rent Santa Fiora
Houses for rent Foligno, home rentals Foligno Italy, and house rentals in Foligno
Home rentals Amalfi, apartment rentals, Amalfi houses for rent, and rental home in Amalfi Italy
Anghiari rental homes and homes for rent by owner in Anghiari Italy
Vacation rental in Montalcino Italy, homes for rent, and holiday rentals in Montalcino
Our online website, FRBO.com does eliminate peculiar romantic and exclusive vacation home, vacation home, and condominiums.
Lead off your witch hunt online on Monday, this week, or in the next few days for your short term rentals in Cecina Italy, apartment rentals in Cecina Italy, and Cecina Italy apartments for rent.
Discover something else, specialized, and specific circumstances in Cecina Italy and button down holiday rentals Cecina.
You can find, identify, and hear rental houses in Cecina Italy, Cecina Italy apartments for rent, and vacation homes in Cecina Italy.
Move, relocate, and explore vacation homes for rent by owner, rental homes in Merano Italy, and Merano Italy home rentals.
Conceive and identify homes for rent by owner in Alagna Valsesia Italy and Alagna Valsesia rent houses.
Join our rustic classified advertisements, loft ad directories, suburban lists of marked properties, and rustic listings mailing list for house rentals in Cecina Italy and Cecina apartments for rent.
Cecina property agents, third party agents, and rental property owners list Cecina rental home, for rent by owner homes in Cecina Italy, and Cecina Italy vacation homes.
Apartments for rent in Aventino Testaccio Italy and real estate rentals Aventino Testaccio Italy
Golfe du Morbihan France rental houses, Golfe du Morbihan France condo rentals, Golfe du Morbihan condo rentals, and apartments for rent in Golfe du Morbihan France
We erected, fathered, and established our webpage to be ravishing, comely, and sightly.
Hear, conceive, and light upon Terrasini Italy vacation homes, vacation homes for rent by owner Terrasini Italy, and rental apartment in Terrasini Italy.
Cecina Italy domain employs many condo owners and real estate agents.
Glimpse, observe, and discover houses for rent Agrigento Italy, short term rentals in Agrigento, and vacation rental in Agrigento Italy.
Pre-leased lakefront chalet and rustic lodge are not far away in the proximate area of Cecina.
Cecina Italy is a pulchritudinous, radiant, and superb precinct with divine, fair, splendid, and statuesque townhouse, chalet, and bungalows.
Homes for rent Salobrena, rental homes in Salobrena, and Salobrena Spain real estate rentals
Rent houses in Alentejo Portugal and Alentejo rental homes
Cecina Italy scoop could hype and further your shakedown.
Notice and look up Vigevano Italy homes for rent and apartment rentals Vigevano.
Come upon, recognize, and uncover rental apartment in Biella, Biella Italy houses for rent, and Biella Italy condo rentals.
Join up, appoint, and register on Saturday to jump into, get cracking, kick off, and get cracking on this travel.
Rental home in Fiesole, Fiesole Italy holiday rentals, and Fiesole house rentals
Contrive and find out Paterno Italy rent houses and rental homes in Paterno.
Uncover, espy, and relocate Nuoro Italy bed and breakfast rentals, rental properties in Nuoro Italy, and Nuoro Italy apartments for rent.
Detect, devise, and distinguish Ribera Italy vacation rental, Ribera Italy holiday rentals, and apartment rentals.
|
|
