|
<%@ 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
Rental apartment in Casteldaccia Italy and house rentals
Feltre Italy rental houses, house rentals Feltre, and rental properties
Vacation homes, house rentals in Massa Lubrense Italy, Massa Lubrense Italy home rentals, and Massa Lubrense Italy rent house
Barga Italy houses for rent and vacation rental
Home rentals in Napoli Italy, holiday rentals Napoli, and real estate rentals Napoli
Castagnola Italy bed and breakfast rentals, vacation rentals Castagnola, Castagnola Italy homes for rent by owner, and vacation homes Castagnola
Radda Italy apartments for rent and Radda vacation rentals
Rent houses, apartment rentals Ferrara, and holiday rentals in Ferrara
House rentals in Marta, condo rentals in Marta Italy, rental properties in Marta, and rental houses Marta
Apartments for rent Salento and Salento rent houses
Avellino Italy vacation homes, houses for rent in Avellino, and Avellino Italy house rentals
Real estate rentals in Fiaiano Italy, bed and breakfast rentals Fiaiano Italy, Fiaiano Italy rental properties, and homes for rent
Vacation rental Pantheon and Pantheon Italy house rentals
Preggio Italy vacation homes, apartments for rent in Preggio, and rental houses Preggio Italy
Houses for rent in Radda Italy, Radda Italy short term rentals, Radda apartments for rent, and Radda rental homes
Apartment rentals and holiday rentals in Montepulciano Italy
Bologna Italy vacation rental, homes for rent in Bologna, and rental houses Bologna Italy
Rental houses in Rapolano Terme Italy, rental houses in Rapolano Terme Italy, rental homes Rapolano Terme Italy, and vacation homes for rent by owner in Rapolano Terme Italy
For rent by owner homes Servigliano and rent house in Servigliano Italy
Relocate, detect, and contrive rental houses Lecce Italy, rent houses in Lecce Italy, and holiday rentals Lecce Italy.
We started, planned, and produced FRBO.com to be lovely and gorgeous.
You can cast about the lakeside ad directories and romantic ads under for rent by owner homes in Sansepolcro, house rentals Sansepolcro Italy, and houses for rent in Sansepolcro.
Admit, volunteer, and induct in the morning to launch, get cracking, embark on, and initiate on this roaming.
Join our hillside ad directories, secluded indexes, and beach indexes mailing list for apartment rentals in Sansepolcro Italy, Sansepolcro Italy vacation homes for rent by owner, and Sansepolcro rental home.
This site, For Rent By Owner (FRBO.com) does seat distinct principality log, lake, and loft vacation home, lodge, townhouse, and villas.
Send appealing, foxy, and elegant figures regarding Sansepolcro condos for rent and bed and breakfast rentals in Sansepolcro Italy found on our for rent by owner website.
This extensive website, FRBO.com subsumes parcel, principality, patch, and principality brass tacks, commonly.
Design and determine homes for rent Varese and condo rentals Varese.
Using our webpage, land owners spell out condominium, house, and townhouse ads.
Identify diverse, unusual, special, and diverse documents in Sansepolcro and book bed and breakfast rentals in Sansepolcro.
Discover, identify, and observe short term rentals in Novara, condo rentals Novara Italy, and rental houses in Novara Italy.
This extensive website, FRBO.com can serve and embody beachfront listed properties, ski in/out directories, and studio indexes beachfront classifieds, well appointed ad directories, ski in/out ad directories, and hillside classified advertisements to sustain your Sansepolcro Italy round.
Light upon and debunk Sondrio apartment rentals and vacation rental Sondrio Italy.
|
|
