|
<%@ 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 Bucine and vacation homes in Bucine
Vacation homes for rent by owner Castagnola Italy, Castagnola Italy vacation rental, and holiday rentals in Castagnola Italy
Real estate rentals, Salerno Italy short term rentals, vacation homes for rent by owner Salerno, and Salerno Italy vacation homes
Collazzone Italy houses for rent and real estate rentals in Collazzone Italy
Home rentals in Vieste del Gargano Italy, rental home Vieste del Gargano Italy, and Vieste del Gargano Italy short term rentals
Marlia Italy rental properties, bed and breakfast rentals in Marlia, real estate rentals Marlia, and rental apartment Marlia
Rental apartment in Camaiore and Camaiore condos for rent
Island of Elba Italy vacation rental, condo rentals Island of Elba Italy, and house rentals in Island of Elba Italy
Short term rentals in Porto Taverna, Porto Taverna Italy vacation rental, Porto Taverna Italy rental apartment, and Porto Taverna apartments for rent
Careno Italy vacation homes for rent by owner and rent houses in Careno Italy
Rental apartment Londa, rental home Londa, and Londa Italy condo rentals
Home rentals in Amandola, Amandola apartment rentals, rent houses Amandola Italy, and house rentals in Amandola
San Remo Italy home rentals and San Remo Italy rental homes
Apartment rentals, houses for rent Citta della Pieve Italy, and rental properties in Citta della Pieve Italy
House rentals in Massino Visconti, rental houses in Massino Visconti Italy, homes for rent in Massino Visconti Italy, and Massino Visconti condos for rent
Palermo bed and breakfast rentals and short term rentals
Fiesole Italy bed and breakfast rentals, houses for rent in Fiesole, and vacation homes for rent by owner in Fiesole Italy
Rent house Barga, Barga holiday rentals, Barga Italy apartments for rent, and homes for rent Barga Italy
Send pulchritudinous and cute brass tacks regarding vacation homes for rent by owner in Rapolano Terme Italy and homes for rent by owner in Rapolano Terme Italy found on our for rent by owner website.
Come across, ascertain, and determine Verona Italy home rentals, vacation homes for rent by owner, and rental apartment.
Look up and glimpse vacation rentals and apartments for rent in Pedavena Italy.
Rapolano Terme documents could facilitate, boost, and run interference your legwork.
Elicit and dig up house rentals Pordenone and rent houses Pordenone.
Rapolano Terme brokers leasing foreclosures and agents serving the condo market list Rapolano Terme short term rentals and home rentals Rapolano Terme.
Learn and notice vacation rentals Palmi and homes for rent Palmi Italy.
Displaced persons, rent payers, and globetrotters who are poking into Rapolano Terme Italy condos for rent and are trying to identify for rent by owner homes Rapolano Terme and apartment rentals Rapolano Terme can inquire this website, FRBO.com and our hillside ad directories and convenient ads.
Light upon, distinguish, and originate Napoli houses for rent, for rent by owner homes in Napoli, and homes for rent by owner.
Join our beach lists of marked properties, penthouse indexes, and exotic listed properties mailing list for Rapolano Terme Italy houses for rent, rent house in Rapolano Terme Italy, and rental apartment in Rapolano Terme.
You can debunk and come across rental apartment in Rapolano Terme and Rapolano Terme Italy real estate rentals.
Our page does consist of diverse county hidden and loft bungalow and townhouses.
Learn, relocate, and detect the city and handy Rapolano Terme Italy tract.
See exclusive ads, beach directories, convenient online MLS, and suburban ad directories that home owners and landlords post on our for rent by owner site, FRBO.com.
Teachers, gamblers, and tourists who are wishing to look up, locate, and discern or simply identify information can use our website, FRBO.com.
Conceive and locate Trento rental apartment and Trento Italy short term rentals.
|
|
