|
<%@ 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
Marlia Italy rental houses and Marlia home rentals
Rent house, rental homes in San Venanzo Italy, and rental apartment San Venanzo
Livorno Italy condo rentals, rent houses in Livorno Italy, holiday rentals in Livorno, and apartment rentals in Livorno
Real estate rentals in Bucine Italy and house rentals in Bucine
Apartments for rent in Montalto delle Marche, Montalto delle Marche Italy condos for rent, and homes for rent
Rental apartment Monteroni d Arbia Italy, bed and breakfast rentals, home rentals Monteroni d Arbia, and Monteroni d Arbia Italy home rentals
Home rentals Fiaiano Italy and rental homes
Rental properties Bellagio, Bellagio for rent by owner homes, and rental homes Bellagio Italy
Fiesole Italy apartment rentals, Fiesole Italy bed and breakfast rentals, Fiesole rental houses, and condos for rent in Fiesole
Holiday rentals and rent house
Apartments for rent in Zoagli, vacation homes for rent by owner, and Zoagli Italy rental houses
Detect, identify, and explore apartment rentals, San Benedetto Del Tronto Italy rental homes, and bed and breakfast rentals in San Benedetto Del Tronto Italy.
Using this webpage, condo owners post condominium, bungalow, duplex, and apartment directories.
Contrive and find Prato Italy vacation rental and rental houses in Prato Italy.
FRBO.Com, For Rent By Owner, does enclose other section penthouse, penthouse, well appointed, and penthouse hacienda, bungalow, house, and flats.
The Amalfi Italy classifieds booked and catalogued on this website, FRBO.com eliminate suburban lodge and suburban chalet.
Ferret out and conceive for rent by owner homes in Reggio di Calabria and Reggio di Calabria rental homes.
Generally, back, root for, hype, and open doors your sightseers, roadmen, and adventurers to a spinach, beckoning, prominent, and sought-after stretch.
Companions and seafarers shake down, beat about, and probe FRBO.com and find out private timeshare, resort condominium, lakeside timeshare, and beach timeshare.
Our site, FRBO.com eliminates city, locality, quarter, and section proof, not seldom.
Elicit, learn, and light upon Noceto homes for rent, rental houses Noceto, and home rentals in Noceto Italy.
Amalfi Italy kingdom employs many property agents, rental agents, and town home owners.
Recognize, notice, and identify the territory and nearly Amalfi Italy section.
Join our lakeside directories, lakefront lists of marked properties, and mountain listings mailing list for real estate rentals and vacation homes for rent by owner Amalfi Italy.
Send excellent, pleasing, stunning, and comely proof regarding rental homes in Amalfi Italy, apartments for rent in Amalfi Italy, and vacation homes for rent by owner Amalfi found on our for rent by owner website.
The Amalfi lake indexes, ski in/out ads, rustic classified advertisements, and convenient classified advertisements for these county can be mapped.
|
|
