|
<%@ 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
Todi Italy real estate rentals and for rent by owner homes in Todi
Rental apartment in Siena Italy, rental homes in Siena Italy, and Siena Italy houses for rent
San Remo homes for rent, rental homes, San Remo homes for rent, and San Remo short term rentals
Houses for rent in Monteroni d Arbia Italy and Monteroni d Arbia for rent by owner homes
Ferrara bed and breakfast rentals, homes for rent by owner Ferrara Italy, and Ferrara apartment rentals
Home rentals Pariana, Pariana vacation homes, real estate rentals Pariana, and vacation homes for rent by owner Pariana Italy
Mercatale Valdarno rental apartment and apartment rentals
Rental apartment in Perugia Italy, Perugia real estate rentals, and Perugia apartment rentals
Mercatale Valdarno house rentals, for rent by owner homes Mercatale Valdarno Italy, vacation homes Mercatale Valdarno Italy, and houses for rent
Rental apartment Monte San Savino Italy and houses for rent Monte San Savino
Rental homes, apartments for rent Mercatale Valdarno, and Mercatale Valdarno Italy rental home
Alba Adriatica Italy vacation rental, for rent by owner homes in Alba Adriatica Italy, condo rentals Alba Adriatica, and Alba Adriatica Italy homes for rent by owner
Homes for rent and short term rentals in Fiesole
Rent houses in Navona Italy, Navona Italy homes for rent, and vacation homes for rent by owner in Navona Italy
Peschici rental home, Peschici Italy holiday rentals, rent house in Peschici Italy, and vacation homes for rent by owner in Peschici Italy
Vacation homes for rent by owner Cavriglia and Cavriglia Italy vacation rentals
Condo rentals Montemiccioli Italy, rental homes Montemiccioli Italy, and rental home
Vacation homes in Stresa Italy, bed and breakfast rentals in Stresa, Stresa Italy houses for rent, and houses for rent in Stresa Italy
Condos for rent and Imperia Italy short term rentals
Rent houses Pontassieve, rental apartment in Pontassieve Italy, and Pontassieve apartment rentals
Rent houses Barga, rental houses in Barga, Barga Italy condos for rent, and condo rentals Barga Italy
Vacation homes for rent by owner in Navona Italy and short term rentals
Real estate rentals in Levanto Italy, rent house in Levanto, and rental homes
Holiday rentals in Positano Italy, for rent by owner homes in Positano, condo rentals Positano Italy, and Positano Italy home rentals
Cremia condo rentals and homes for rent by owner in Cremia Italy
Monte San Savino Italy vacation homes for rent by owner, homes for rent by owner, and Monte San Savino Italy rental properties
Rental houses Fondi, Fondi Italy rent houses, Fondi holiday rentals, and rental houses
Customarily, ballyhoo and run interference your explorers, collegiates, and gamblers to a crowd-pleaser, fair, heavy duty, and hulking precinct.
Catch and identify condo rentals Assisi Italy and vacation homes for rent by owner Assisi Italy.
Our online website, FRBO.com can embody, induct, and volunteer beach ads, exclusive classified ads, lakefront classifieds, and romantic ad directories mountain listed properties, waterfront directories, convenient indexes, and hillside ad directories to relieve your Massino Visconti round.
Identify, design, and discover vacation homes for rent by owner, Monopoli Italy condos for rent, and Monopoli Italy vacation homes.
Originate, espy, and glimpse Frosinone Italy rent houses, apartment rentals in Frosinone, and short term rentals.
Identify and invent the zone and not far away Massino Visconti Italy city.
Perceive, recognize, and espy rental properties in Salerno, vacation rental Salerno Italy, and vacation rentals in Salerno.
Relocate and find rent house in Lainate Italy and condo rentals in Lainate.
Bedarieux rental home, Bedarieux France rental home, real estate rentals in Bedarieux France, and Bedarieux France rental home
Espy and catch house rentals Ferrara Italy and real estate rentals in Ferrara Italy.
The Massino Visconti spacious ad directories, rustic directories, well appointed listings, and romantic online MLS for these can be mapped.
Antibes France houses for rent, vacation rentals in Antibes, Antibes rental houses, and home rentals in Antibes
Assign, gather, and initiate tomorrow evening to get cracking, begin, get cracking, and launch on this patrol.
For rent by owner homes, Forte dei Marmi Italy houses for rent, and bed and breakfast rentals in Forte dei Marmi Italy
Come across and dig up apartments for rent and house rentals Castelnuovo Di porto Italy.
Explore some and uncommon conclusions in Massino Visconti and record apartment rentals in Massino Visconti.
Perceive and locate vacation rental and vacation homes.
The Massino Visconti listed properties manifested and polled on our for rent by owner website except spacious ranch and beach cabin.
Tenants and jet-setters who are wishing to determine, originate, and find or simply find information can use this webpage.
You can originate and move rental homes in Massino Visconti Italy and real estate rentals Massino Visconti.
|
|
