|
<%@ 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 and apartments for rent in Varese Ligure
Montelupo Fiorentino Italy rental properties, vacation rental in Montelupo Fiorentino Italy, and Montelupo Fiorentino Italy vacation homes for rent by owner
Bolsena rental homes, rental houses in Bolsena Italy, home rentals in Bolsena Italy, and Bolsena for rent by owner homes
Apartment rentals Lierna Italy and rental homes Lierna Italy
Vacation rental San Venanzo, rental apartment San Venanzo, and short term rentals San Venanzo Italy
Tremezzo Italy for rent by owner homes, rent house in Tremezzo Italy, home rentals Tremezzo, and Tremezzo Italy for rent by owner homes
Sorgeto Italy real estate rentals and Sorgeto Italy rental properties
Home rentals Anacapri Italy, Anacapri bed and breakfast rentals, and Anacapri Italy condos for rent
Vacation homes in Fiaiano, Fiaiano rental apartment, apartments for rent Fiaiano, and Fiaiano Italy condo rentals
Apartment rentals and Casciana Terme Italy rental houses
Rental home Pistoia, real estate rentals in Pistoia Italy, and Pistoia rental houses
Bari Italy short term rentals, Bari rental houses, vacation rental in Bari Italy, and Bari vacation rentals
Zoagli Italy homes for rent and Zoagli Italy rental apartment
Rental homes Palermo, Palermo Italy bed and breakfast rentals, and Palermo Italy short term rentals
Condo rentals Pisa, vacation homes in Pisa Italy, rental houses Pisa, and real estate rentals in Pisa
Identify and dig up Novara Italy rental homes and house rentals.
Vieste del Gargano Italy figures could stump, back, and assist your frisking.
Identify, catch, and invent Bari Italy rental properties, real estate rentals in Bari Italy, and vacation rentals in Bari Italy.
Available beach ranch, private flat, and lake hacienda are not far in the near-at-hand patch of Vieste del Gargano.
Join our loft classifieds, penthouse classified ads, spacious listed properties, and well appointed ads mailing list for house rentals and rental houses in Vieste del Gargano.
You can find, elicit, and light upon Vieste del Gargano Italy apartment rentals and houses for rent in Vieste del Gargano.
Come upon, ascertain, and come across rent house in santa Marinella Italy, condos for rent in santa Marinella Italy, and santa Marinella Italy houses for rent.
Move and perceive condos for rent in Guidonia Italy and home rentals Guidonia Italy.
Contrive, discern, and explore rental homes in Omegna Italy, short term rentals in Omegna, and rental properties Omegna Italy.
Identify, observe, and explore rental apartment in Alagna Valsesia Italy, vacation homes in Alagna Valsesia, and Alagna Valsesia house rentals.
Travelers and peers scan and poke into our online website, FRBO.com and identify hillside house, mountain house, rustic condominium, and oceanfront timeshare.
Hear, come upon, and explore house rentals in Udine, holiday rentals Udine Italy, and holiday rentals.
Possessors and sorority sisters who are hunting for short term rentals Vieste del Gargano and are trying to discover rental homes in Vieste del Gargano and rental houses in Vieste del Gargano Italy can scan this site, For Rent By Owner (FRBO.com) and our private lists of marked properties, waterfront ads, city listings, and hidden directories.
The Vieste del Gargano lists of marked properties written down and written down on our site, FRBO.com hold convenient duplex and beach hacienda.
|
|
