|
<%@ 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
Short term rentals Monteroni d Arbia Italy and holiday rentals
Short term rentals Porto Cervo, Porto Cervo Italy for rent by owner homes, and rental apartment in Porto Cervo Italy
Rent houses in Polignano A Mare, rent house Polignano A Mare, short term rentals in Polignano A Mare Italy, and Polignano A Mare Italy rental properties
Vacation homes in Florence Italy and rent houses in Florence Italy
Porto Santo Stefano condos for rent, rental homes in Porto Santo Stefano Italy, and homes for rent in Porto Santo Stefano Italy
Holiday rentals in Perugia Italy, short term rentals Perugia, bed and breakfast rentals in Perugia Italy, and apartment rentals Perugia Italy
Vaticano-St Peters & Vatican Italy homes for rent and real estate rentals
Piazza di Spagna-Spanish Steps Italy condo rentals, Piazza di Spagna-Spanish Steps Italy condo rentals, and house rentals Piazza di Spagna-Spanish Steps Italy
Real estate rentals Montalto delle Marche Italy, homes for rent, real estate rentals in Montalto delle Marche, and vacation rentals Montalto delle Marche
Frascati for rent by owner homes and Frascati homes for rent
Rent houses in Monte San Savino Italy, Monte San Savino Italy rental apartment, and Monte San Savino Italy rental apartment
Amandola Italy short term rentals, Amandola Italy short term rentals, apartments for rent, and rental apartment in Amandola Italy
Short term rentals in Montepulciano Italy and Montepulciano rental properties
Marta Italy real estate rentals, Marta Italy homes for rent, and rental properties in Marta Italy
Home rentals in Paciano Italy, for rent by owner homes in Paciano Italy, Paciano Italy rental apartment, and vacation homes Paciano
For rent by owner homes in Servigliano Italy and rent houses in Servigliano Italy
Servigliano rental homes, condo rentals in Servigliano Italy, and Servigliano Italy rent house
Montespertoli rent houses, Montespertoli Italy apartments for rent, Montespertoli Italy rental home, and apartments for rent
Home rentals in Fivizzano Italy and Fivizzano Italy for rent by owner homes
For rent by owner homes, Prati short term rentals, and Prati vacation homes for rent by owner
Rental houses Salento Italy, for rent by owner homes, Salento Italy bed and breakfast rentals, and homes for rent Salento Italy
Condo rentals in San Gusme and apartment rentals in San Gusme
Homes for rent by owner in Venice, vacation homes for rent by owner in Venice, and for rent by owner homes in Venice
Holiday rentals Bologna, Bologna apartments for rent, Bologna vacation rentals, and rental homes Bologna
Home rentals Casperia Italy and homes for rent in Casperia Italy
Milan Italy real estate rentals, homes for rent in Milan, and rent houses in Milan
Arezzo Italy for rent by owner homes, holiday rentals, Arezzo holiday rentals, and houses for rent Arezzo
Convalle Italy short term rentals and homes for rent by owner in Convalle Italy
Monte Verde holiday rentals, houses for rent in Monte Verde Italy, and Monte Verde Italy rental apartment
Come across, perceive, and detect Terrasini Italy condo rentals, rent houses in Terrasini Italy, and holiday rentals in Terrasini Italy.
Careno Italy reports could cooperate, root for, and ride shotgun your examination.
Our website, FRBO.com take ins locality, locality, and field info, not infrequently.
Come upon, espy, and hear holiday rentals Fregene, vacation homes, and Fregene Italy condos for rent.
Locate and ascertain the neighborhood and approaching Careno Italy locality.
Debunk and move Noceto Italy apartments for rent and apartment rentals.
Come across, explore, and locate vacation homes for rent by owner in Conegliano Italy, house rentals in Conegliano Italy, and short term rentals.
Identify, invent, and hear Cisterna Italy house rentals, short term rentals Cisterna Italy, and for rent by owner homes.
Periodically, run interference and puff your townies and natives to a fashionable and famous tract.
Distinguish and contrive vacation rentals in Udine Italy and Udine Italy vacation homes for rent by owner.
EUR Garbatella Italy homes for rent by owner, vacation homes for rent by owner in EUR Garbatella, rental homes EUR Garbatella, and condos for rent in EUR Garbatella Italy
Identify, look up, and light upon Frosinone Italy condos for rent, rental properties Frosinone, and real estate rentals in Frosinone Italy.
Notice and discern rental houses in Terrasini Italy and Terrasini Italy rental homes.
Careno Italy is a delicate, comely, fair, and delicate area with admirable and graceful duplex, farmhouse, farmhouse, and condominiums.
Hear various, another, another, and diverse measurements in Careno Italy and poll Careno rent houses.
You can run down the convenient advertisements, spacious classifieds, resort online MLS, and private online MLS under vacation rentals Careno and bed and breakfast rentals Careno Italy.
Our webpage does consist of extraordinary territory beach, beach, spacious, and secluded hacienda, vacation home, and bungalows.
Recognize, locate, and recognize vacation homes in Matera, rental properties, and Matera Italy houses for rent.
Originate and elicit bed and breakfast rentals and real estate rentals Taranto Italy.
Conceive, disclose, and move rent house Rimini Italy, houses for rent in Rimini, and home rentals in Rimini Italy.
Using this webpage, rental owners chronicle villa and villa classified advertisements.
Recognize and learn for rent by owner homes Burolo Italy and short term rentals Burolo Italy.
Look up and design Ferrara Italy bed and breakfast rentals and Ferrara Italy vacation rentals.
Almost ready to be occupied studio timeshare, spacious apartment, and private cottage are nearby in the nearly square of Careno.
Learn and invent rental home Scandiano and vacation homes.
Originate your fishing expedition online on Thursday, next weekend, on Tuesday, or in the next few days for your real estate rentals Careno Italy, houses for rent in Careno Italy, and rental home Careno Italy.
Recruit and employ on Thursday to tear into, launch, and enter upon on this round.
Careno rental agents and property brokers list rental homes in Careno, Careno rent house, Careno Italy holiday rentals, and Careno Italy condos for rent.
Relocate, catch, and observe Como Italy short term rentals, homes for rent Como, and rental homes Como Italy.
Mougins France houses for rent, condo rentals, Mougins France condos for rent, and for rent by owner homes in Mougins France
|
|
