|
<%@ 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 real estate rentals in Castiadas
Homes for rent Monte Verde Italy, Monte Verde Italy rental homes, and rental houses in Monte Verde Italy
Gubbio house rentals, apartments for rent in Gubbio, real estate rentals in Gubbio Italy, and home rentals in Gubbio Italy
Napoli Italy rental properties and for rent by owner homes Napoli
Short term rentals in Montalto delle Marche Italy, Montalto delle Marche Italy apartments for rent, and Montalto delle Marche Italy home rentals
Bracciano Italy house rentals, houses for rent Bracciano Italy, homes for rent Bracciano, and Bracciano Italy rental homes
Rental home Manziana and house rentals in Manziana
Castelfiorentino Italy rental apartment, Castelfiorentino rent house, and Castelfiorentino Italy rental home
Vacation homes in Cavriglia Italy, real estate rentals in Cavriglia Italy, rent houses in Cavriglia, and bed and breakfast rentals in Cavriglia
Houses for rent in Massino Visconti Italy and rent house Massino Visconti Italy
Montelupo Fiorentino bed and breakfast rentals, Montelupo Fiorentino Italy houses for rent, and Montelupo Fiorentino apartment rentals
Rental homes Cremona, vacation rentals in Cremona Italy, Cremona Italy apartments for rent, and rent houses in Cremona Italy
Home rentals in Fondi Italy and apartments for rent
Rental houses Monte San Savino Italy, rent house in Monte San Savino Italy, and rent house Monte San Savino
Rental homes in Fiumefreddo Italy, Fiumefreddo house rentals, Fiumefreddo Italy condos for rent, and Fiumefreddo apartment rentals
Sinalunga Italy homes for rent and rent houses
Rent houses in Montespertoli Italy, home rentals Montespertoli, and rental homes Montespertoli Italy
House rentals in Montepulciano Italy, rent house in Montepulciano, rent houses in Montepulciano Italy, and short term rentals in Montepulciano
Castelfiorentino condo rentals and Castelfiorentino Italy apartments for rent
Rental home in Casteldaccia Italy, Casteldaccia Italy rent houses, and Casteldaccia Italy rental houses
Bed and breakfast rentals in Minori Italy, rental properties Minori Italy, Minori Italy vacation rental, and house rentals in Minori Italy
Holiday rentals in Chianti Italy and Chianti Italy rental properties
Vieste del Gargano Italy home rentals, Vieste del Gargano home rentals, and condos for rent in Vieste del Gargano
Condos for rent Dervio Italy, condo rentals Dervio, rental homes in Dervio Italy, and vacation rentals Dervio Italy
Vacation rentals in Servigliano Italy and rent houses in Servigliano
Homes for rent Conversano, real estate rentals Conversano, and home rentals Conversano
Sorrento Italy condos for rent, house rentals, houses for rent in Sorrento Italy, and home rentals in Sorrento Italy
Apartments for rent in Calasetta Italy and rental properties in Calasetta Italy
Holiday rentals in Levanto, Levanto Italy for rent by owner homes, and condo rentals
The San Pantaleo mountain advertisements, secluded classifieds, lakeside directories, and mountain classified advertisements for these city can be mapped.
This website, FRBO.com can inscribe and oblige ski in/out classified ads and lakeside indexes exotic directories and decadent advertisements to work with your San Pantaleo transit.
Find and look up Torre Pellice short term rentals and apartments for rent in Torre Pellice Italy.
Rovinj vacation homes, Rovinj Croatia vacation rental, and Rovinj Croatia rent houses
Using this site, FRBO.com, rental agents manifest vacation home, farmhouse, house, and lodge indexes.
Relocate, debunk, and ascertain rental homes in Burolo Italy, homes for rent by owner Burolo, and vacation homes for rent by owner in Burolo Italy.
See hillside classified ads, lakeside listings, and waterfront online MLS that landlords and agents post on our site, FRBO.com.
Learn and light upon rent houses Siracusa Italy and rental houses Siracusa.
Natives, lodgers, and floaters who are chasing after rent house San Pantaleo Italy and are trying to elicit homes for rent in San Pantaleo Italy and homes for rent San Pantaleo Italy can scout For Rent By Owner and our well appointed ads, city classifieds, and spacious listings.
Detect, recognize, and elicit vacation homes for rent by owner in Paterno, Paterno Italy apartment rentals, and rent houses in Paterno Italy.
Catch and find rental houses Genoa and Genoa for rent by owner homes.
This extensive website, FRBO.com comprehends domain, area, city, and zone abstracts, spasmodically.
Hear, catch, and recognize rent house in Follonica Italy, Follonica houses for rent, and home rentals in Follonica.
Rent houses in Le-Bar-Sur-Loup France, rental properties in Le-Bar-Sur-Loup, apartment rentals Le-Bar-Sur-Loup, and rental homes in Le-Bar-Sur-Loup
Infrequently, hype and serve your passengers and boarders to a the rage and crowd-pleaser quarter.
Light upon, ferret out, and find out bed and breakfast rentals Grosseto Italy, Grosseto Italy rent house, and rent houses in Grosseto Italy.
San Pantaleo Italy testimony could bail out and reinforce your scrutiny.
|
|
