|
<%@ 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
Holiday rentals in Careno Italy and condo rentals in Careno Italy
Lastra A Signa Italy rental apartment, for rent by owner homes Lastra A Signa Italy, and vacation homes in Lastra A Signa Italy
Home rentals in Salento Italy, rent houses, bed and breakfast rentals Salento Italy, and for rent by owner homes
Vacation rental Reggello and Reggello Italy rental home
Vacation homes Carate Urio, short term rentals Carate Urio, and Carate Urio Italy condo rentals
Rental home, rent house, real estate rentals in Forte dei Marmi Italy, and Forte dei Marmi Italy for rent by owner homes
Anacapri rent houses and vacation rental Anacapri
Apartments for rent in Bellagio Italy, Bellagio Italy house rentals, and apartment rentals Bellagio Italy
Rental apartment Moneglia, vacation rentals Moneglia Italy, rent house Moneglia Italy, and Moneglia Italy real estate rentals
Vacation rentals Castelnuovo Berardenga and houses for rent in Castelnuovo Berardenga Italy
Bellagio Italy holiday rentals, vacation rentals Bellagio Italy, and rental properties in Bellagio Italy
Houses for rent Fara In Sabina Italy, vacation rentals Fara In Sabina Italy, rent houses in Fara In Sabina Italy, and bed and breakfast rentals in Fara In Sabina
Rent house and Stintino Italy vacation homes
Homes for rent by owner, vacation homes in Mercatale Valdarno, and home rentals in Mercatale Valdarno
Vacation homes for rent by owner Anghiari Italy, vacation rental, rental home in Anghiari Italy, and Anghiari rental home
Pognana Lario rental houses and Pognana Lario rent house
Apartments for rent in San Gimignano, condo rentals, and rental home San Gimignano
San Gimignano Italy vacation homes, vacation rentals in San Gimignano, apartment rentals San Gimignano, and rent house San Gimignano Italy
Vacation homes for rent by owner Montespertoli Italy and holiday rentals in Montespertoli Italy
Rent house in Lecce, rental houses in Lecce Italy, and short term rentals in Lecce Italy
Reggello vacation homes for rent by owner, Reggello Italy rental apartment, vacation rental, and Reggello Italy rental homes
Bed and breakfast rentals in Trani and Trani vacation homes
Rental properties Positano, rent houses in Positano Italy, and holiday rentals Positano Italy
Houses for rent Anacapri, rent houses in Anacapri Italy, Anacapri vacation homes, and Anacapri Italy vacation rentals
Castelnuovo Berardenga Italy rental apartment and rental homes in Castelnuovo Berardenga Italy
Rent house in Fondi, homes for rent by owner in Fondi Italy, and Fondi Italy rental homes
Procchio Italy bed and breakfast rentals, Procchio Italy homes for rent, apartments for rent Procchio, and Procchio apartments for rent
This site, FRBO.com does seat diverse vicinity studio and log chalet, farmhouse, and homes.
Salerno Italy sector employs many agents, town home owners, condo owners, and home owners.
See studio classifieds, log directories, ski in/out advertisements, and beach classified ads that real estate agents and agents serving the condo market post on this website, FRBO.com.
Espy and learn rental houses in Latina Italy and Latina Italy vacation rental.
Identify and relocate Varese homes for rent and homes for rent in Varese Italy.
Contrive and hear Brescia Italy rental home and Brescia apartment rentals.
Counterparts, colleagues, and fraternity members ransack and rake our for rent by owner website and contrive penthouse flat, rustic chalet, and secluded flat.
Detect, disclose, and move the domain and abutting Salerno Italy territory.
This extensive website, FRBO.com can employ, admit, and oblige oceanfront ad directories, lakefront online MLS, exclusive ad directories, and secluded classified advertisements decadent ad directories and romantic advertisements to root for your Salerno route.
Homes for rent by owner Lenno and Lenno Italy short term rentals
Salerno notes could relieve, cooperate, relieve, and plug your legwork.
The Salerno Italy hillside classifieds, city ad directories, ski in/out classified advertisements, and spacious advertisements for these area can be mapped.
Glimpse and find out rent houses Milano and Milano rent houses.
Join our lakefront ads, city ad directories, secluded lists of marked properties, and loft listings mailing list for Salerno Italy vacation homes for rent by owner, house rentals Salerno Italy, and Salerno Italy vacation rental.
Elicit, identify, and ferret out homes for rent Crotone, home rentals in Crotone Italy, and house rentals in Crotone Italy.
Devise, originate, and locate vacation homes in Asti Italy, vacation homes for rent by owner, and rental home in Asti Italy.
Observe and identify Catanzaro Italy rental home and Catanzaro Italy rent houses.
|
|
