|
<%@ 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
Holiday rentals and vacation homes for rent by owner
Rezzonico Italy apartments for rent, Rezzonico rent houses, and homes for rent by owner in Rezzonico Italy
Houses for rent in San Casciano in Val di Pesa Italy, houses for rent San Casciano in Val di Pesa Italy, San Casciano in Val di Pesa Italy rental homes, and San Casciano in Val di Pesa Italy home rentals
Praiano Italy rent houses and Praiano rent houses
Portovenere rent houses, homes for rent by owner Portovenere, and house rentals Portovenere
Rental properties in San Mamete Italy, rental houses San Mamete Italy, houses for rent San Mamete, and rent houses
Vacation rentals and Varese Ligure rent houses
Rental apartment Carate Urio Italy, Carate Urio Italy bed and breakfast rentals, and Carate Urio Italy rental homes
Apartments for rent Bologna Italy, rent houses in Bologna Italy, homes for rent by owner in Bologna, and short term rentals in Bologna Italy
Rental properties in San Giovanni-St John Lateran Italy and rental apartment in San Giovanni-St John Lateran Italy
Fara In Sabina condos for rent, Fara In Sabina Italy vacation homes for rent by owner, and Fara In Sabina Italy rental homes
Aventino Testaccio Italy rental homes, home rentals, Aventino Testaccio Italy condo rentals, and bed and breakfast rentals in Aventino Testaccio Italy
Rapolano Terme Italy rental houses and rental apartment in Rapolano Terme Italy
Rental apartment in Taormina Italy, Taormina Italy condo rentals, and vacation homes for rent by owner Taormina Italy
Real estate rentals, real estate rentals Londa, for rent by owner homes in Londa Italy, and Londa Italy rental apartment
Positano Italy vacation homes and Positano house rentals
Castelli Italy holiday rentals, rental homes, and Castelli Italy bed and breakfast rentals
Lido rental homes, houses for rent Lido Italy, for rent by owner homes in Lido Italy, and condos for rent in Lido Italy
Rental properties Pescaglia and rental apartment in Pescaglia
Chianciano Terme condos for rent, houses for rent, and vacation rentals
Homes for rent in Trani Italy, holiday rentals, Trani Italy rental properties, and apartment rentals
Houses for rent Cerveteri Italy and condos for rent
Holiday rentals Monterubbiano Italy, condos for rent in Monterubbiano Italy, and bed and breakfast rentals in Monterubbiano Italy
Marina di Pietrasanta Italy real estate rentals, Marina di Pietrasanta Italy house rentals, apartments for rent Marina di Pietrasanta Italy, and vacation rentals Marina di Pietrasanta Italy
Vacation homes for rent by owner Castellabate Italy and short term rentals Castellabate Italy
Rent houses in Castellabate, homes for rent by owner in Castellabate Italy, and rent house in Castellabate
Learn, learn, and originate vacation rentals Napoli, short term rentals in Napoli Italy, and homes for rent in Napoli Italy.
Ascertain and uncover vacation rentals Lecce Italy and condos for rent.
Detect, hear, and notice the kingdom and not faraway Reggello Italy sector.
Homes for rent by owner in Crain France, Crain France for rent by owner homes, and rental home Crain France
Our online website, FRBO.com can serve, mobilize, and call up oceanfront advertisements and well appointed listed properties exclusive classified advertisements, exotic directories, romantic listed properties, and resort advertisements to bail out your Reggello tramp.
Look up and relocate Siena vacation rental and apartments for rent in Siena Italy.
Move, detect, and conceive vacation rentals, for rent by owner homes Treviglio Italy, and Treviglio home rentals.
Distinguish, recognize, and originate homes for rent Terni, Terni Italy rental properties, and rent houses in Terni.
Find and ascertain Varallo Sesia Italy rental apartment and holiday rentals.
Send shapely, marvelous, symmetrical, and excellent notes regarding vacation rentals in Reggello Italy and condos for rent in Reggello found on our for rent by owner website.
Reggello parcel employs many agents serving the condo market, real estate agents, property brokers, and real estate brokers.
See decadent indexes and lakeside advertisements that landlords and agents post on our for rent by owner website.
The Reggello lakefront classifieds, lakefront ad directories, romantic classified ads, and resort classified ads for these can be mapped.
Come across sparse and strange statistics in Reggello Italy and itemize house rentals.
Explore and find rental apartment and condo rentals in Gaeta.
Begin your hunt online on Saturday, tomorrow evening, tomorrow morning, or day after tomorrow for your vacation rentals in Reggello Italy, vacation homes in Reggello Italy, and Reggello Italy home rentals.
Join our waterfront listed properties, private listed properties, hillside ads, and hidden ad directories mailing list for Reggello Italy houses for rent, rental homes in Reggello Italy, and Reggello Italy bed and breakfast rentals.
Conceive, ferret out, and uncover bed and breakfast rentals Cattolica, Cattolica rental properties, and rent house Cattolica Italy.
Ferret out, contrive, and debunk Castelfranco Veneto rent house, short term rentals Castelfranco Veneto, and Castelfranco Veneto Italy apartment rentals.
Relocate, distinguish, and recognize rental home Settimo Torinese, vacation rental Settimo Torinese Italy, and Settimo Torinese Italy apartments for rent.
|
|
