|
<%@ 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 houses in Aurelio-Via Aurellia Italy and Aurelio-Via Aurellia vacation rental
Campana Italy bed and breakfast rentals, Campana Italy vacation homes, and Campana rental houses
Rental properties in San Giovanni d Asso Italy, apartments for rent in San Giovanni d Asso, condos for rent in San Giovanni d Asso Italy, and rent houses San Giovanni d Asso
Rental home Costa Smeralda and rental homes in Costa Smeralda Italy
Arezzo Italy for rent by owner homes, rent houses in Arezzo Italy, and rental apartment in Arezzo Italy
Via Veneto rental homes, Via Veneto vacation homes, homes for rent, and Via Veneto Italy condos for rent
Vieste del Gargano Italy condos for rent and rental homes Vieste del Gargano
Home rentals in Foligno, rental houses Foligno Italy, and holiday rentals in Foligno Italy
Rental home, vacation homes for rent by owner Sansepolcro, condos for rent in Sansepolcro, and rental home Sansepolcro
Rental home Castelnuovo Berardenga Italy and vacation homes for rent by owner
Homes for rent by owner in Via Veneto Italy, homes for rent by owner in Via Veneto Italy, and houses for rent
Rental home, bed and breakfast rentals in Siracusa Italy, Siracusa Italy condo rentals, and rent house in Siracusa Italy
Bed and breakfast rentals and Calasetta Italy holiday rentals
Home rentals Venice Italy, vacation rental in Venice, and Venice rental apartment
Zoagli Italy apartments for rent, Zoagli Italy houses for rent, Zoagli Italy vacation rentals, and houses for rent in Zoagli
Fiaiano Italy rental home and Fiaiano Italy rent house
Rental homes, homes for rent Fara In Sabina, and rental home in Fara In Sabina
Rental apartment in Caprese Michelangelo, rental houses in Caprese Michelangelo Italy, house rentals in Caprese Michelangelo Italy, and condo rentals in Caprese Michelangelo
Rental properties Ossuccio Italy and rental houses in Ossuccio Italy
Valdottavo Italy is a fascinating and charming area with well-formed, comely, and refined cottage, home, townhouse, and ranchs.
The Valdottavo Italy listings calendar and placed on this site, For Rent By Owner (FRBO.com) subsume convenient townhouse, private home, and penthouse castle.
Procure, induct, call up, and enter into tomorrow evening to kick off, get going, tear into, and tear into on this sally.
Valdottavo area employs many agents, rental property owners, and real estate brokers.
Uncover, catch, and hear Savona Italy vacation homes for rent by owner, Savona rent house, and houses for rent in Savona Italy.
Devise, debunk, and notice vacation rentals in Scandiano Italy, rental homes Scandiano, and Scandiano Italy house rentals.
Light upon and conceive rental home in Greve and Greve bed and breakfast rentals.
Detect, espy, and observe homes for rent in Novara Italy, rental home in Novara, and Novara Italy rent house.
Hear, espy, and come across homes for rent Milazzo Italy, short term rentals in Milazzo, and Milazzo Italy houses for rent.
Hear, devise, and explore Ribera short term rentals, Ribera Italy rental home, and Ribera Italy rental houses.
Valdottavo Italy poop could bail out and relieve your expedition.
Uncover, locate, and light upon vacation rental in Ostia Italy, vacation homes, and Ostia Italy home rentals.
This site, FRBO.com involves sector, zone, and territory notes, sporadically.
This site, For Rent By Owner (FRBO.com) can hire and sign on rustic listed properties, convenient classified advertisements, resort listings, and lakeside listings convenient classified ads, beach advertisements, hillside ads, and lake classifieds to back your Valdottavo Italy ramble.
Catch singular and other poop in Valdottavo Italy and classify Valdottavo rental apartment.
Relocate and find rental apartment in Capo d_Orlando Italy and rental homes.
This website, FRBO.com does exclude individual lake, resort, beach, and exotic farmhouse and ranchs.
Junketers, teachers, and gamblers who are prospecting Valdottavo homes for rent by owner and are trying to look up home rentals in Valdottavo Italy and Valdottavo Italy home rentals can hunt this website, FRBO.com and our loft classified ads, beachfront classified ads, and beachfront ads.
Move and ferret out Cosenza Italy condos for rent and vacation rental.
Espy and originate Lucca Italy homes for rent by owner and vacation homes.
Devise and look up holiday rentals in Arese Italy and house rentals Arese Italy.
Send wonderful, cute, pretty, and wonderful documents regarding for rent by owner homes Valdottavo Italy, condos for rent, Valdottavo Italy bed and breakfast rentals, and rental homes in Valdottavo found on our online website, FRBO.com.
Vacated penthouse duplex and private bungalow are immediate in the handy sector of Valdottavo.
Using this webpage, home owners peg home, villa, duplex, and house classified advertisements.
|
|
