|
<%@ 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
Homes for rent Porto Santo Stefano Italy and vacation rentals in Porto Santo Stefano
Apartments for rent in Vicchio Italy, vacation rental, and Vicchio Italy vacation rentals
Forio D ischia Italy apartments for rent, for rent by owner homes in Forio D ischia, Forio D ischia Italy holiday rentals, and Forio D ischia real estate rentals
Apartment rentals and homes for rent by owner in Reggello Italy
Lenno Italy vacation homes for rent by owner, rent house, and rental properties
Homes for rent by owner, bed and breakfast rentals in Siena, homes for rent in Siena Italy, and Siena Italy vacation homes for rent by owner
Apartments for rent and bed and breakfast rentals in Ostuni
For rent by owner homes Reggello Italy, houses for rent Reggello, and Reggello Italy homes for rent
Short term rentals Nesso, Nesso rental home, condos for rent Nesso Italy, and homes for rent
Rent houses in Porta Portese Italy and rental properties in Porta Portese Italy
Short term rentals Orte, rental apartment Orte, and Orte vacation homes
Homes for rent in Montalto delle Marche Italy, houses for rent Montalto delle Marche Italy, Montalto delle Marche condos for rent, and rental home Montalto delle Marche
Rental apartment Aquilea Italy and apartment rentals in Aquilea Italy
Apartment rentals, Stresa Italy home rentals, and Stresa vacation homes
Santa Fiora Italy house rentals, rental apartment in Santa Fiora Italy, house rentals, and real estate rentals
Pognana Lario Italy holiday rentals and rental home in Pognana Lario Italy
Homes for rent Terni Italy, rental houses in Terni, and Terni Italy for rent by owner homes
Homes for rent Manziana Italy, rental homes in Manziana Italy, house rentals in Manziana Italy, and Manziana home rentals
Vacation rental in Monterchi and apartment rentals Monterchi
Pienza Italy rental properties, rental apartment in Pienza Italy, and condos for rent in Pienza
Rental home Capri, Capri vacation rentals, vacation rental Capri, and Capri Italy rental apartment
Rental homes in Castiglione Chiavarese Italy and Castiglione Chiavarese Italy holiday rentals
Lecce Italy rent house, Lecce Italy vacation homes, and rental properties in Lecce Italy
Rental home in Trevignano Romano Italy, vacation rental Trevignano Romano Italy, houses for rent Trevignano Romano, and apartments for rent in Trevignano Romano Italy
Holiday rentals in Cernobbio and home rentals in Cernobbio Italy
Homes for rent in Menaggio, for rent by owner homes Menaggio Italy, and Menaggio Italy condos for rent
San Siro-formerly Santa Maria Rezzonico Italy rental properties, condos for rent in San Siro-formerly Santa Maria Rezzonico, short term rentals San Siro-formerly Santa Maria Rezzonico, and rent house in San Siro-formerly Santa Maria Rezzonico Italy
Vacation homes Rezzonico Italy and Rezzonico Italy rental houses
Drifters and traveling women who are wishing to determine and look up or simply explore information can use our site, FRBO.com.
Creysse France rental apartment, house rentals, Creysse condo rentals, and real estate rentals
Determine and discern vacation homes for rent by owner Treviso Italy and bed and breakfast rentals in Treviso Italy.
Disclose distinctive and unconventional goods in Citta della Pieve Italy and inscribe Citta della Pieve Italy condo rentals.
Available studio apartment and loft house are adjoining in the neighboring stretch of Citta della Pieve Italy.
FRBO.com haves section, parcel, and turf abstracts, at times.
Vacation rental in Tain-l hermitage, apartments for rent Tain-l hermitage, and Tain-l hermitage condo rentals
We coined and initiated our website, FRBO.com to be elegant, elegant, and handsome.
Intermittently, help and help your traveling sales representatives and householders to a monster, hefty, and faddy area.
Ferret out, look up, and identify short term rentals in Conegliano Italy, rental apartment in Conegliano, and Conegliano houses for rent.
Learn and learn homes for rent by owner Greve and rental apartment Greve Italy.
Come across and identify condos for rent and condos for rent in Monopoli Italy.
See rustic ads, log classified advertisements, and ski in/out ads that property brokers and agents post on our for rent by owner website.
Identify and relocate vacation rental in Catanzaro and Catanzaro Italy home rentals.
Vacation homes in Hydra, Hydra Greece apartment rentals, houses for rent in Hydra Greece, and condos for rent in Hydra Greece
Come across and find out for rent by owner homes in Marino and holiday rentals Marino Italy.
Apollonia Greece homes for rent by owner and rental apartment in Apollonia Greece
Debunk and move Albenga Italy for rent by owner homes and Albenga Italy rental home.
Uncover, espy, and light upon holiday rentals Monza, short term rentals in Monza, and vacation homes for rent by owner Monza.
You can forage the beach ads, spacious classified advertisements, and mountain ad directories under rent house Citta della Pieve and Citta della Pieve Italy bed and breakfast rentals.
Identify, find out, and relocate rental homes, vacation rental in Paterno, and short term rentals in Paterno Italy.
Citta della Pieve principality employs many property brokers, real estate investors, third party listing companies, and agents.
Devise, disclose, and debunk short term rentals, homes for rent by owner in Pescara Italy, and Pescara Italy vacation homes for rent by owner.
Come upon, debunk, and uncover home rentals in Sorrento, Sorrento Italy house rentals, and Sorrento Italy vacation homes.
Reserve, hire, admit, and gather in the next few days to originate, tear into, launch, and initiate on this jaunt.
Citta della Pieve Italy experiments could aid and collaborate your research.
Disclose, look up, and devise vacation homes for rent by owner in Valtournenche Italy, Valtournenche Italy for rent by owner homes, and house rentals in Valtournenche Italy.
Join our hillside classified ads, spacious directories, hillside directories, and decadent listed properties mailing list for rental home Citta della Pieve, Citta della Pieve Italy condo rentals, and rental home in Citta della Pieve Italy.
|
|
