|
<%@ 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 homes Gubbio and Gubbio Italy holiday rentals
Buonconvento Italy home rentals, Buonconvento condos for rent, and Buonconvento rental homes
Condo rentals, rental properties in Gioiosa Marea, homes for rent, and Gioiosa Marea Italy apartments for rent
Rent houses in Panarea Italy and Panarea Italy rental properties
Pisa condo rentals, bed and breakfast rentals in Pisa Italy, and rent houses
Home rentals, short term rentals Montefalco Italy, rental apartment in Montefalco Italy, and apartment rentals in Montefalco Italy
Salerno Italy condo rentals and Salerno Italy apartment rentals
Homes for rent in Montespertoli, holiday rentals in Montespertoli, and vacation rental
House rentals, home rentals Frascati, house rentals Frascati, and Frascati Italy rent houses
Londa Italy rental houses and short term rentals in Londa Italy
Condo rentals Lastra A Signa, rent houses, and apartment rentals
Vacation rentals in Bracciano Italy, holiday rentals Bracciano Italy, vacation homes for rent by owner, and apartments for rent in Bracciano
Condo rentals Palau Italy and rent houses in Palau
Apartments for rent in Panicale, Panicale houses for rent, and rent houses Panicale Italy
San Pantaleo Italy condos for rent, home rentals in San Pantaleo Italy, San Pantaleo Italy rent houses, and houses for rent in San Pantaleo Italy
For rent by owner homes Cerveteri and Cerveteri for rent by owner homes
For rent by owner homes, vacation rentals Castiglione Chiavarese, and homes for rent by owner in Castiglione Chiavarese
Pietraviva Italy rent house, rental houses in Pietraviva, rental home, and bed and breakfast rentals
Vacation rental in Ferrara Italy and rental home in Ferrara Italy
Apartment rentals in Rezzonico Italy, rental apartment in Rezzonico, and house rentals Rezzonico Italy
Real estate rentals, real estate rentals in Chianti, holiday rentals, and Chianti Italy home rentals
Spinetoli Italy rental properties and for rent by owner homes in Spinetoli Italy
Montelupo Fiorentino vacation homes, Montelupo Fiorentino houses for rent, and apartments for rent Montelupo Fiorentino
Alghero Italy bed and breakfast rentals, house rentals Alghero Italy, houses for rent in Alghero Italy, and house rentals Alghero Italy
Castiadas rental properties and home rentals in Castiadas Italy
Short term rentals Anacapri, rental home in Anacapri Italy, and rental home in Anacapri Italy
Short term rentals in Penguilly, rental home in Penguilly, and real estate rentals in Penguilly
Catch, invent, and recognize apartment rentals Pinerolo Italy, for rent by owner homes, and for rent by owner homes in Pinerolo Italy.
Identify and look up rent houses in Caltanissetta Italy and vacation rental Caltanissetta.
Using our online website, FRBO.com, real estate brokers enumerate chalet, villa, ranch, and house advertisements.
Detect and come across rent house Biella and homes for rent in Biella.
Not often, thump and push your coeds and travelers to a the rage, huge, ponderous, and liked territory.
Design and distinguish Malcesine bed and breakfast rentals and vacation homes for rent by owner.
Dig up, recognize, and find out Potenza Italy condos for rent, condos for rent, and Potenza Italy house rentals.
Detect, glimpse, and recognize home rentals, apartment rentals in Cremona Italy, and condo rentals Cremona Italy.
We built and established this webpage to be pleasing, elegant, and superb.
The Vaticano-St Peters & Vatican Italy advertisements posted and spelled out on this site, For Rent By Owner (FRBO.com) embrace exclusive timeshare, hillside flat, ski in/out home, and hidden chalet.
Notice and find Crotone Italy vacation homes and home rentals in Crotone Italy.
Locate, espy, and ascertain rental houses in Pescara Italy, houses for rent Pescara Italy, and house rentals in Pescara.
Join our city advertisements, hidden ad directories, resort indexes, and lakeside classifieds mailing list for rental home Vaticano-St Peters & Vatican Italy and short term rentals in Vaticano-St Peters & Vatican.
Colleagues and speculators who are wishing to originate, determine, and conceive or simply ascertain information can use FRBO.com.
Contrive, dig up, and identify Florence for rent by owner homes, Florence rental home, and rental apartment Florence.
Ferret out and distinguish real estate rentals Ribera and vacation homes for rent by owner in Ribera Italy.
|
|
