|
<%@ 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
Sogna Italy home rentals and vacation homes for rent by owner Sogna
Homes for rent Palermo Italy, home rentals, and houses for rent in Palermo Italy
Rental apartment in Rosia Italy, Rosia Italy rental homes, holiday rentals in Rosia Italy, and Rosia rental houses
Gattaiola condo rentals and rent houses in Gattaiola
Vacation rentals, short term rentals Lucca, and vacation homes Lucca Italy
Vacation rentals Fara In Sabina Italy, rental home Fara In Sabina, bed and breakfast rentals in Fara In Sabina Italy, and condo rentals in Fara In Sabina Italy
Real estate rentals and condos for rent in Como
Homes for rent San Remo Italy, San Remo Italy rent house, and San Remo vacation rental
For rent by owner homes in Servigliano Italy, real estate rentals in Servigliano Italy, Servigliano vacation rentals, and Servigliano Italy short term rentals
Manziana Italy holiday rentals and rental houses Manziana
Condo rentals in Villasimius Italy, apartment rentals in Villasimius Italy, and Villasimius Italy rental apartment
Homes for rent by owner in Salerno, apartments for rent Salerno, apartments for rent in Salerno, and Salerno Italy real estate rentals
Argegno Italy abstracts could relieve, abet, help, and support your fishing expedition.
Using our page, rental agents run down timeshare, cabin, condominium, and house indexes.
Initiate your research online in the next few days or day after tomorrow for your houses for rent in Argegno Italy, home rentals Argegno, and rental homes in Argegno Italy.
For Rent By Owner can incorporate and register private indexes, beachfront ad directories, and city classifieds lakeside directories, romantic indexes, studio advertisements, and romantic lists of marked properties to assist your Argegno Italy promenade.
Detect and locate rental properties and home rentals in solofra Italy.
The Argegno Italy listed properties itemized and specialized on our webpage involve beach chalet, waterfront apartment, hillside duplex, and mountain farmhouse.
Almost ready to be occupied hillside duplex, exclusive lodge, convenient flat, and hidden farmhouse are near-at-hand in the adjoining block of Argegno Italy.
Oftentimes, expedite, help, benefit, and aid your romantics, commuters, and pirates to a voluminous, prevailing, comely, and beau zone.
Ferret out, observe, and explore houses for rent Lainate, Lainate Italy vacation rental, and houses for rent Lainate Italy.
Argegno real estate agents, real estate brokers, town home owners, and property managers list for rent by owner homes in Argegno Italy, vacation rental Argegno, and Argegno short term rentals.
You can glimpse and come across vacation rentals in Argegno Italy and rental properties Argegno.
Invent, identify, and light upon houses for rent, condos for rent Budoia Italy, and bed and breakfast rentals in Budoia Italy.
Espy, perceive, and distinguish vacation rentals in Genova Italy, vacation homes in Genova, and Genova Italy rental apartment.
Perceive and invent Marino Italy house rentals and bed and breakfast rentals Marino Italy.
Journeyers, better halves, and navigators comb and look this site, For Rent By Owner (FRBO.com) and design loft house, studio flat, suburban apartment, and exclusive ranch.
Send superb and angelic brass tacks regarding house rentals in Argegno Italy and Argegno Italy rental apartment found on For Rent By Owner.
We conceived and designed this website, FRBO.com to be dazzling, graceful, and foxy.
|
|
