|
<%@ 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 homes in Fara In Sabina Italy and rental properties in Fara In Sabina Italy
Condos for rent in Cetona, rental houses Cetona Italy, and apartments for rent Cetona
Castagnola Italy apartment rentals, apartments for rent, real estate rentals, and vacation rental Castagnola
Monterchi Italy short term rentals and rental properties in Monterchi Italy
Houses for rent in Via Veneto, Via Veneto vacation homes, and house rentals
Lavagna rental houses, rental houses, condos for rent Lavagna Italy, and Lavagna bed and breakfast rentals
Apartments for rent Montespertoli and short term rentals Montespertoli Italy
Moneglia Italy rent house, Moneglia Italy homes for rent by owner, and rent house in Moneglia
Condos for rent Aurelio-Via Aurellia Italy, rent house, Aurelio-Via Aurellia Italy rent houses, and rental properties Aurelio-Via Aurellia Italy
Home rentals Porto Santo Stefano and Porto Santo Stefano Italy rental apartment
Vacation homes for rent by owner in Amandola Italy, house rentals Amandola, and Amandola homes for rent by owner
Sorrento Italy short term rentals, apartment rentals, home rentals, and houses for rent in Sorrento Italy
Apartment rentals in Assisi Italy and rental apartment in Assisi
Short term rentals in Flaminio-Piazza del Popolo & Parioli Italy, rent houses Flaminio-Piazza del Popolo & Parioli Italy, and holiday rentals in Flaminio-Piazza del Popolo & Parioli
Pelago Italy homes for rent by owner, condo rentals in Pelago Italy, apartment rentals in Pelago Italy, and rental properties in Pelago Italy
Home rentals and rent houses in Narni Italy
Malcesine rental homes, Malcesine apartment rentals, and condos for rent Malcesine Italy
Val di Vara Italy vacation rentals, rent houses Val di Vara Italy, rental home in Val di Vara, and vacation homes for rent by owner in Val di Vara Italy
House rentals in Massa Lubrense Italy and Massa Lubrense Italy rental houses
Homes for rent by owner Monterchi Italy, apartment rentals in Monterchi Italy, and rental apartment
Real estate rentals, vacation rental in Montemiccioli, Montemiccioli rent houses, and homes for rent by owner in Montemiccioli Italy
Vacation rental and Panarea Italy apartments for rent
Rental properties Gioiosa Marea Italy, homes for rent, and vacation homes Gioiosa Marea
Porto Cervo home rentals, rental houses Porto Cervo Italy, rental properties Porto Cervo, and Porto Cervo rental houses
Casperia Italy rent house and bed and breakfast rentals
Lido Italy vacation homes, rental homes, and Lido Italy condos for rent
Baschi rental apartment, home rentals Baschi, vacation rental, and home rentals
Bed and breakfast rentals Minori and Minori Italy bed and breakfast rentals
Detect and come across condos for rent in Cosenza Italy and real estate rentals in Cosenza.
Vacation rental, Chite Spain apartment rentals, Chite Spain vacation homes, and home rentals in Chite Spain
Dig up and recognize condo rentals Lissone and Lissone Italy short term rentals.
Design, ferret out, and hear vacation homes in Venice Italy, vacation rentals in Venice, and vacation homes in Venice Italy.
Contrive and come across Napoli Italy vacation homes for rent by owner and condo rentals.
Castelnuovo Berardenga Italy results could help, hype, cooperate, and sustain your frisking.
House rentals Richelieu and Richelieu France apartment rentals
House rentals in Letterkenny, Letterkenny rental properties, rental home in Letterkenny Ireland, and condos for rent Letterkenny Ireland
Villefranche-sur-Mer houses for rent and apartment rentals in Villefranche-sur-Mer
Tear into your quest online tonight, tonight, in the next few days, or on Wednesday for your Castelnuovo Berardenga vacation rental, vacation rentals Castelnuovo Berardenga, and apartments for rent Castelnuovo Berardenga Italy.
Using this site, FRBO.com, real estate agents particularize flat and farmhouse ad directories.
Castelnuovo Berardenga Italy square employs many property agents and home owners.
Determine, detect, and look up the sector and contiguous Castelnuovo Berardenga Italy county.
Send exquisite, statuesque, and grand picture regarding holiday rentals in Castelnuovo Berardenga Italy, vacation rentals Castelnuovo Berardenga, and Castelnuovo Berardenga vacation rentals found on our site, FRBO.com.
Tourists and roamers ransack and hunt for our website, FRBO.com and debunk ski in/out houseboat and hidden houseboat.
Hear and find home rentals Scandiano Italy and vacation homes.
Relocate, debunk, and contrive Imola Italy homes for rent by owner, Imola homes for rent, and Imola Italy short term rentals.
Castelnuovo Berardenga home owners, land owners, property agents, and home owners list condo rentals in Castelnuovo Berardenga Italy and for rent by owner homes in Castelnuovo Berardenga.
FRBO.Com, For Rent By Owner, can register and hitch romantic listed properties, decadent ads, and well appointed indexes city indexes, well appointed listings, beachfront advertisements, and loft classifieds to work for your Castelnuovo Berardenga promenade.
Debunk, uncover, and discern homes for rent Modena, vacation rental in Modena, and real estate rentals in Modena Italy.
The Castelnuovo Berardenga Italy beach directories, spacious ads, secluded listed properties, and romantic classifieds for these can be mapped.
Explore and contrive vacation homes Bordighera Italy and Bordighera Italy rental properties.
Habitants and better halves who are scanning vacation rental in Castelnuovo Berardenga and are trying to dig up condos for rent Castelnuovo Berardenga Italy and condos for rent can scrutinize our webpage and our penthouse ad directories, beach ad directories, hillside classified advertisements, and resort indexes.
For rent by owner homes, rental apartment in Stratford-upon-Avon United Kingdom, and home rentals Stratford-upon-Avon
Identify, observe, and discern short term rentals Massa Italy, for rent by owner homes in Massa Italy, and rental home in Massa Italy.
|
|
