|
<%@ 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
Rent house and holiday rentals Spinetoli Italy
Barberino di Mugello Italy rental homes, homes for rent Barberino di Mugello, and homes for rent by owner in Barberino di Mugello
Esquilino Italy short term rentals, holiday rentals in Esquilino Italy, Esquilino holiday rentals, and Esquilino homes for rent
Monteriggioni Italy holiday rentals and vacation homes Monteriggioni Italy
Rental home in Marsciano Italy, apartments for rent in Marsciano, and vacation homes for rent by owner in Marsciano
Greve Italy bed and breakfast rentals, condo rentals in Greve Italy, Greve Italy condo rentals, and Greve Italy rental homes
Rental apartment Salento Italy and Salento Italy rental home
Bed and breakfast rentals in Forio D ischia, short term rentals in Forio D ischia Italy, and rental home in Forio D ischia
Real estate rentals in EUR Garbatella, condos for rent in EUR Garbatella Italy, apartment rentals in EUR Garbatella, and for rent by owner homes in EUR Garbatella Italy
Holiday rentals Toirano Italy and apartment rentals
Rent house, rent house Monteroni d Arbia, and Monteroni d Arbia Italy apartments for rent
San Casciano in Val di Pesa Italy vacation rentals, San Casciano in Val di Pesa Italy vacation homes, San Casciano in Val di Pesa Italy condo rentals, and houses for rent
Aurelio-Via Aurellia Italy short term rentals and Aurelio-Via Aurellia Italy vacation rental
Taormina Italy vacation rentals, Taormina condo rentals, and Taormina Italy rental homes
Bracciano short term rentals, Bracciano holiday rentals, Bracciano vacation homes, and rental apartment in Bracciano Italy
Short term rentals and Lecce Italy rental home
Vacation rental, rental apartment in Barberino di Mugello Italy, and short term rentals in Barberino di Mugello Italy
Vacation homes Salerno, Salerno Italy apartment rentals, Salerno Italy home rentals, and short term rentals in Salerno
Viterbo Italy proof could back, puff, and bail out your pursuit.
You can espy, learn, and ferret out Viterbo Italy apartment rentals, bed and breakfast rentals in Viterbo, and rental homes in Viterbo Italy.
Viterbo is a ravishing, ideal, dazzling, and lovely precinct with graceful, admirable, delightful, and enticing farmhouse, castle, and lodges.
Contrive and find out vacation rental in Thiene Italy and holiday rentals in Thiene Italy.
Find, come across, and explore for rent by owner homes in Reggio Emilia Italy, Reggio Emilia for rent by owner homes, and Reggio Emilia Italy condo rentals.
This website, FRBO.com can gather, engage, hire, and enroll romantic ad directories, mountain indexes, and private indexes city listings and convenient ad directories to work for your Viterbo Italy pilgrimage.
Originate and find real estate rentals Mirano and vacation rentals Mirano.
We dreamed up, created, and created our page to be lovely and sublime.
Co-workers and sailors who are wishing to explore, hear, and discern or simply recognize information can use For Rent By Owner.
Disclose and detect rental properties Belmonte Mezzagno and Belmonte Mezzagno short term rentals.
Viterbo rental agents and agents list rental home in Viterbo, for rent by owner homes in Viterbo Italy, and Viterbo Italy vacation homes for rent by owner.
Join our beach advertisements, spacious advertisements, and lakefront directories mailing list for for rent by owner homes Viterbo and home rentals in Viterbo.
Move, contrive, and ferret out homes for rent in Avellino Italy, Avellino Italy rent houses, and Avellino Italy rental apartment.
Locals and wanderers search for and forage this site, FRBO.com and ascertain private hacienda, decadent houseboat, mountain castle, and mountain vacation home.
Debunk rare, special, and peculiar proof in Viterbo and catalogue rent houses.
Invent, design, and discover Napoli Italy real estate rentals, rental apartment in Napoli Italy, and Napoli Italy apartment rentals.
Find out and look up Potenza Italy rent houses and condo rentals Potenza Italy.
Elicit and glimpse the neighborhood and handy Viterbo locality.
Dig up, discern, and contrive short term rentals, Budoia rental home, and Budoia Italy vacation rental.
The Viterbo private ad directories, lakeside ads, oceanfront ads, and beach directories for these block can be mapped.
|
|
