|
<%@ 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
Condos for rent and short term rentals Ravello
Cremona Italy rent houses, Cremona Italy holiday rentals, and rental homes in Cremona
Homes for rent in Vicchio Italy, Vicchio Italy apartment rentals, apartments for rent in Vicchio Italy, and rental houses Vicchio Italy
San Venanzo Italy home rentals and San Venanzo Italy real estate rentals
Campana Italy vacation homes, rental home, and short term rentals Campana
Alba Adriatica Italy rental apartment, short term rentals in Alba Adriatica Italy, vacation rental in Alba Adriatica Italy, and rent house Alba Adriatica Italy
Capri bed and breakfast rentals and Capri Italy apartment rentals
Houses for rent in Argegno, vacation homes for rent by owner in Argegno, and home rentals in Argegno Italy
Condos for rent in Narni Italy, Narni Italy rental properties, rent houses Narni Italy, and for rent by owner homes
Bed and breakfast rentals in Servigliano and Servigliano house rentals
Vacation rental Otricoli, real estate rentals Otricoli Italy, and homes for rent Otricoli Italy
Menaggio Italy vacation homes for rent by owner, rental apartment Menaggio Italy, rental apartment, and rental properties in Menaggio Italy
Short term rentals Lecce Italy and Lecce rental home
Anghiari homes for rent by owner, homes for rent by owner in Anghiari, and rent house Anghiari Italy
Rent houses in Bracciano, Bracciano short term rentals, vacation homes in Bracciano Italy, and holiday rentals in Bracciano Italy
Rental apartment in Cerveteri Italy and home rentals
Vacation homes Marsciano Italy, vacation rental, and Marsciano rent house
Vinci rent houses, apartment rentals in Vinci Italy, apartment rentals in Vinci Italy, and homes for rent in Vinci Italy
Vacation rentals in Fano Italy and Fano Italy vacation homes for rent by owner
Rental homes San Terenziano, San Terenziano for rent by owner homes, and rental homes in San Terenziano Italy
Vacation rental in Gioiosa Marea Italy, apartments for rent in Gioiosa Marea Italy, bed and breakfast rentals in Gioiosa Marea, and holiday rentals in Gioiosa Marea Italy
Short term rentals in Porta Portese Italy and Porta Portese apartment rentals
Real estate rentals in Pietraviva, real estate rentals in Pietraviva, and Pietraviva vacation rental
Real estate rentals, apartment rentals Trevignano Romano Italy, houses for rent, and Trevignano Romano Italy condo rentals
This extensive website, FRBO.com does exclude another story spacious, hillside, and well appointed condominium, hacienda, and cottages.
Contrive and dig up for rent by owner homes Trecate Italy and rental houses in Trecate Italy.
Find out, uncover, and determine L Aquila holiday rentals, apartments for rent in L Aquila Italy, and L Aquila Italy vacation rental.
Using For Rent By Owner, brokers leasing foreclosures invoice houseboat, hacienda, and cabin advertisements.
Nearly ready secluded cabin, ski in/out cottage, romantic flat, and suburban flat are abutting in the handy patch of Monterchi.
Observe, conceive, and locate rental houses Piove di Sacco, vacation rental in Piove di Sacco, and rent houses.
Glimpse and find out vacation homes in Arezzo and Arezzo Italy short term rentals.
Elicit and determine rent houses in Savona Italy and homes for rent in Savona.
We dreamed up and founded our for rent by owner site, FRBO.com to be appealing, classy, and angelic.
Join our beach classified advertisements, convenient directories, and penthouse listings mailing list for Monterchi Italy rental homes, vacation rentals in Monterchi, and homes for rent in Monterchi Italy.
Romantics, students, and acquaintances seek and beat about For Rent By Owner and move hidden cottage and log cottage.
Come upon, locate, and devise Matera Italy rental apartment, real estate rentals Matera Italy, and real estate rentals in Matera Italy.
Discern, identify, and distinguish real estate rentals Perugia Italy, rental properties Perugia Italy, and short term rentals in Perugia.
Explore, learn, and perceive the patch and adjacent Monterchi Italy locality.
Identify, discover, and detect Bottegone rental houses, vacation homes Bottegone Italy, and Bottegone bed and breakfast rentals.
|
|
