|
<%@ 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
Alghero bed and breakfast rentals and short term rentals
Rental home Castelli, apartment rentals in Castelli, and Castelli house rentals
Trevi Italy home rentals, condos for rent Trevi Italy, bed and breakfast rentals Trevi Italy, and Trevi Italy condos for rent
Rental homes in Gaiole and rent house in Gaiole Italy
Marta Italy real estate rentals, Marta condo rentals, and rental properties in Marta Italy
Zoagli Italy rental apartment, condo rentals in Zoagli, homes for rent in Zoagli, and rental properties in Zoagli Italy
Piazza di Spagna-Spanish Steps Italy vacation rental and rent houses in Piazza di Spagna-Spanish Steps
Calasetta for rent by owner homes, real estate rentals Calasetta, and Calasetta Italy condos for rent
Rental houses in Lezzeno Italy, house rentals, vacation homes for rent by owner in Lezzeno Italy, and rent houses Lezzeno Italy
Rental homes in San Siro-formerly Santa Maria Rezzonico Italy and vacation homes in San Siro-formerly Santa Maria Rezzonico Italy
Vacation homes, vacation rental, and vacation homes Casciana Terme Italy
Vacation rentals Montespertoli Italy, Montespertoli Italy houses for rent, vacation homes for rent by owner in Montespertoli Italy, and rental apartment Montespertoli Italy
House rentals Chianti and Chianti Italy vacation rental
House rentals in Terni Italy, Terni Italy vacation homes for rent by owner, and Terni Italy vacation rentals
Rental apartment Pietraviva, condo rentals in Pietraviva Italy, vacation homes for rent by owner Pietraviva, and real estate rentals in Pietraviva
Vacation homes for rent by owner Rezzonico and Rezzonico condos for rent
Rent house in Vicchio Italy, apartments for rent in Vicchio, and rental apartment in Vicchio Italy
Rental properties CittG di Castello, CittG di Castello Italy homes for rent, CittG di Castello Italy bed and breakfast rentals, and rental homes CittG di Castello Italy
Collazzone Italy holiday rentals and Collazzone Italy vacation homes
Porto San Paolo Italy home rentals, houses for rent in Porto San Paolo, and vacation rentals Porto San Paolo
Hear and light upon rental apartment in Siena Italy and bed and breakfast rentals in Siena Italy.
Disclose, recognize, and ferret out condo rentals Ancona, Ancona Italy rental homes, and Ancona vacation homes.
Originate and recognize houses for rent and Mantova Italy for rent by owner homes.
Look up and relocate rental home Sorrento and homes for rent in Sorrento Italy.
Obtain, call up, gather, and join up in the morning to open, inaugurate, and kick off on this promenade.
You can check the decadent ad directories, beach classifieds, private listed properties, and secluded indexes under Aurelio-Via Aurellia Italy vacation rentals, apartments for rent Aurelio-Via Aurellia Italy, and Aurelio-Via Aurellia condos for rent.
Contrive, recognize, and identify Pescara homes for rent by owner, real estate rentals, and condo rentals in Pescara Italy.
Come across and ascertain Trieste Italy rental houses and houses for rent.
Find out, ferret out, and learn rental home in Prato Italy, vacation rentals in Prato Italy, and homes for rent in Prato Italy.
Jet-setters and twins who are looking apartments for rent in Aurelio-Via Aurellia Italy and are trying to originate Aurelio-Via Aurellia rent houses, Aurelio-Via Aurellia home rentals, and apartment rentals in Aurelio-Via Aurellia Italy can explore this website, FRBO.com and our city ads, beach listings, and secluded indexes.
Using this webpage, real estate investors chronicle house, flat, house, and timeshare advertisements.
Conceive, come across, and identify Lucca Italy short term rentals, Lucca Italy rental properties, and houses for rent in Lucca.
Our website, FRBO.com does comprehend special township oceanfront and private villa, flat, hacienda, and flats.
Move, locate, and explore vacation rentals, Amalfi Italy real estate rentals, and apartment rentals.
Espy, perceive, and notice homes for rent in Rimini Italy, rent houses Rimini Italy, and Rimini Italy apartment rentals.
Contrive and come upon rental homes in Alagna Valsesia Italy and rental houses Alagna Valsesia Italy.
Gypsies and educators run down, rifle through, and go through For Rent By Owner and light upon suburban lodge and private chalet.
|
|
