|
<%@ 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
Home rentals and homes for rent in Lenno Italy
Fiesole Italy vacation rental, rent house in Fiesole Italy, and Fiesole Italy vacation rental
Castiadas Italy condos for rent, Castiadas Italy for rent by owner homes, homes for rent by owner Castiadas, and condo rentals in Castiadas Italy
Homes for rent by owner Gaiole and homes for rent by owner
Porto Santo Stefano Italy vacation rental, homes for rent, and Porto Santo Stefano Italy rental properties
Short term rentals Monteriggioni, apartment rentals in Monteriggioni Italy, apartments for rent Monteriggioni, and houses for rent Monteriggioni Italy
Arezzo Italy home rentals and rental houses in Arezzo Italy
Cisternino Italy short term rentals, vacation rental Cisternino Italy, and rental apartment in Cisternino
Colosseo Foro Romano-Coliseum & Roman Forum condos for rent, holiday rentals in Colosseo Foro Romano-Coliseum & Roman Forum Italy, Colosseo Foro Romano-Coliseum & Roman Forum Italy houses for rent, and Colosseo Foro Romano-Coliseum & Roman Forum Italy homes for rent by owner
Short term rentals Colosseo Foro Romano-Coliseum & Roman Forum Italy and Colosseo Foro Romano-Coliseum & Roman Forum homes for rent by owner
Montelupo Fiorentino Italy apartment rentals, Montelupo Fiorentino Italy holiday rentals, and rent house Montelupo Fiorentino
Real estate rentals in Flaminio-Piazza del Popolo & Parioli Italy, rental home Flaminio-Piazza del Popolo & Parioli Italy, Flaminio-Piazza del Popolo & Parioli Italy short term rentals, and bed and breakfast rentals in Flaminio-Piazza del Popolo & Parioli
Mercatale Valdarno Italy homes for rent by owner and rent houses Mercatale Valdarno
For rent by owner homes Certaldo, home rentals in Certaldo Italy, and vacation homes for rent by owner Certaldo
Barberino di Mugello bed and breakfast rentals, vacation rental Barberino di Mugello, Barberino di Mugello Italy holiday rentals, and home rentals in Barberino di Mugello
House rentals Lucca and short term rentals Lucca
Rent houses San Remo Italy, rent houses in San Remo, and San Remo Italy apartment rentals
Friends and soldiers rake, search for , and run down this webpage and hear resort vacation home, lakefront farmhouse, and lakeside castle.
Hikers and roadmen who are hunting vacation rentals in Stresa Italy and are trying to distinguish Stresa Italy vacation rental, Stresa home rentals, and home rentals Stresa Italy can root this site, FRBO.com and our suburban directories, penthouse classified advertisements, exotic lists of marked properties, and lakefront classified ads.
Join our exotic listed properties, beachfront directories, lake directories, and spacious listed properties mailing list for Stresa homes for rent by owner and bed and breakfast rentals Stresa Italy.
Recognize, uncover, and uncover Trento Italy real estate rentals, condo rentals in Trento Italy, and Trento Italy real estate rentals.
Disclose and debunk home rentals in Lucca Italy and rental homes in Lucca Italy.
See beach listings and beach advertisements that rental property owners and rental property owners post on this extensive website, FRBO.com.
Stresa brass tacks could support, bail out, help, and push your inquest.
You can rake the waterfront classified ads, beach online MLS, lakefront ad directories, and decadent listed properties under rent houses in Stresa, Stresa rental houses, and Stresa Italy apartment rentals.
Uncover and disclose bed and breakfast rentals Castelvetrano Italy and vacation homes in Castelvetrano Italy.
Using our website, FRBO.com, rental agents run down townhouse, timeshare, and cottage lists of marked properties.
Perceive and determine the state and contiguous Stresa Italy patch.
Perceive and catch homes for rent by owner Lainate and rental houses Lainate.
Enter upon your scrutiny online tomorrow, day after tomorrow, day after tomorrow, or on Wednesday for your condo rentals in Stresa Italy and rental apartment in Stresa.
Come upon and hear real estate rentals in Assisi Italy and Assisi rental home.
Determine, find out, and come across for rent by owner homes Vimercate, homes for rent by owner in Vimercate Italy, and Vimercate Italy homes for rent.
Detect, find, and learn for rent by owner homes in Modena, vacation rental Modena, and short term rentals in Modena Italy.
|
|
