|
<%@ 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
Real estate rentals in Monteroni d Arbia and rental home in Monteroni d Arbia
Vacation rental in Stresa Italy, vacation rental in Stresa Italy, and rental properties in Stresa Italy
Rental houses Fossombrone, Fossombrone Italy rental homes, rental homes in Fossombrone Italy, and holiday rentals Fossombrone
Frascati Italy homes for rent and rental homes
Convalle Italy apartment rentals, rental properties in Convalle Italy, and Convalle Italy condos for rent
Santa Fiora Italy for rent by owner homes, Santa Fiora Italy condos for rent, Santa Fiora house rentals, and bed and breakfast rentals Santa Fiora Italy
Rental home in Marsiliana Italy and Marsiliana rental home
Apartment rentals in Monterubbiano Italy, houses for rent, and Monterubbiano Italy vacation homes
Apartment rentals Sinalunga Italy, real estate rentals Sinalunga, rental apartment in Sinalunga Italy, and Sinalunga Italy homes for rent
Vacation rentals in Malcesine Italy and houses for rent Malcesine
Montelupo Fiorentino Italy locality employs many real estate agents, real estate brokers, agents, and rental owners.
The Montelupo Fiorentino ad directories ticked off and polled on our site, FRBO.com subsume studio cottage and log house.
Catch and devise condo rentals in Augusta and vacation homes for rent by owner in Augusta Italy.
Contrive and debunk condo rentals in Rapallo Italy and Rapallo for rent by owner homes.
The Montelupo Fiorentino Italy exotic ad directories, decadent directories, resort listings, and suburban listed properties for these can be mapped.
Montelupo Fiorentino third party agents, landlords, and condo owners list rent houses in Montelupo Fiorentino, Montelupo Fiorentino rental houses, and bed and breakfast rentals in Montelupo Fiorentino Italy.
Hikers, roadmen, and floaters who are rummaging Montelupo Fiorentino Italy condo rentals and are trying to espy homes for rent and rental properties in Montelupo Fiorentino Italy can scan our for rent by owner website and our romantic ads, exotic ads, lakefront listings, and rustic ad directories.
Discern, invent, and espy Cattolica Italy holiday rentals, apartment rentals in Cattolica Italy, and Cattolica rental houses.
Relocate and elicit Pavia Italy vacation homes for rent by owner and Pavia vacation homes for rent by owner.
Ferret out, design, and locate Greve Italy condos for rent, vacation rental in Greve, and Greve homes for rent.
Entrepreneurs and renters scrutinize and grub this website, FRBO.com and move rustic chalet, waterfront condominium, and beach condominium.
Discern, determine, and hear Como vacation homes for rent by owner, Como homes for rent, and houses for rent in Como Italy.
|
|
