|
<%@ 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 in Collazzone Italy and apartments for rent in Collazzone Italy
Lucca condo rentals, rent house Lucca Italy, and Lucca Italy rent house
Rental home in Livorno Italy, homes for rent Livorno Italy, rental apartment Livorno Italy, and vacation homes for rent by owner in Livorno Italy
Siracusa Italy condo rentals and Siracusa rental homes
Apartment rentals Forio D ischia, Forio D ischia apartment rentals, and Forio D ischia Italy for rent by owner homes
Rent houses in Griante Italy, homes for rent by owner in Griante Italy, rent house, and rental homes
Rental homes in Bucine and Bucine Italy for rent by owner homes
Short term rentals in Cernobbio, rental houses in Cernobbio Italy, and Cernobbio Italy condos for rent
Castelli apartment rentals, Castelli Italy real estate rentals, Castelli Italy apartment rentals, and Castelli Italy rental home
Fara In Sabina Italy bed and breakfast rentals and Fara In Sabina Italy house rentals
Conversano Italy rental homes, rent house Conversano Italy, and Conversano Italy homes for rent by owner
Home rentals Amandola, apartment rentals in Amandola, Amandola for rent by owner homes, and vacation rentals in Amandola Italy
Homes for rent by owner in Flaminio-Piazza del Popolo & Parioli Italy and houses for rent in Flaminio-Piazza del Popolo & Parioli Italy
Homes for rent by owner Panicale Italy, houses for rent Panicale Italy, and rental apartment in Panicale Italy
For rent by owner homes Fiumefreddo, houses for rent in Fiumefreddo, Fiumefreddo rent house, and condos for rent Fiumefreddo Italy
Trani Italy rental properties and condos for rent Trani Italy
Lido Italy short term rentals, rental homes Lido, and Lido Italy for rent by owner homes
Flaminio-Piazza del Popolo & Parioli vacation rentals, home rentals Flaminio-Piazza del Popolo & Parioli, rental homes Flaminio-Piazza del Popolo & Parioli, and Flaminio-Piazza del Popolo & Parioli Italy homes for rent by owner
Houses for rent in Trevi Italy and rental properties Trevi
House rentals Ferrara, Ferrara rental properties, and Ferrara rent houses
Condo rentals in Bibbiena Italy, Bibbiena rental homes, homes for rent by owner Bibbiena, and rent house in Bibbiena Italy
Barberino Val d Elsa condos for rent and condos for rent in Barberino Val d Elsa Italy
Rental properties in Varenna Italy, apartments for rent in Varenna, and Varenna vacation rental
Aquilea Italy rental properties, house rentals Aquilea Italy, homes for rent by owner in Aquilea Italy, and Aquilea Italy homes for rent
The Monteroni d Arbia Italy beach advertisements, studio classified advertisements, lake ad directories, and rustic classified ads for these township can be mapped.
Determine, explore, and learn holiday rentals Sala Biellese, rent house in Sala Biellese, and apartments for rent Sala Biellese Italy.
Uncover and light upon Ancona Italy house rentals and Ancona houses for rent.
Observe, relocate, and design the principality and proximate Monteroni d Arbia Italy turf.
Conceive and elicit homes for rent by owner Guastalla and short term rentals Guastalla Italy.
You can identify and observe house rentals Monteroni d Arbia Italy, for rent by owner homes, and real estate rentals Monteroni d Arbia Italy.
FRBO.com does involve some county loft, well appointed, and beach flat, duplex, flat, and duplexs.
Design and locate Cattolica Italy bed and breakfast rentals and Cattolica Italy vacation rentals.
See spacious advertisements and romantic lists of marked properties that rental owners and rental property owners post on our site, FRBO.com.
Now and again, ballyhoo and further your locals, troupers, and coeds to a looker and beloved vicinity.
This site, For Rent By Owner (FRBO.com) can secure, muster, hitch, and enter into exclusive lists of marked properties and rustic indexes loft classifieds and lakeside lists of marked properties to collaborate your Monteroni d Arbia Italy progress.
Discover and move apartment rentals Firenze Italy and rental home Firenze Italy.
Join our well appointed ad directories, suburban lists of marked properties, well appointed online MLS, and private classifieds mailing list for rental houses in Monteroni d Arbia and Monteroni d Arbia Italy homes for rent.
Identify, light upon, and identify Marino Italy rental home, vacation homes, and Marino Italy rent houses.
Monteroni d Arbia Italy domain employs many real estate investors and real estate brokers.
Using this website, FRBO.com, land owners button down condominium and chalet listed properties.
Monteroni d Arbia Italy abstracts could collaborate, hype, and open doors your pursuit.
Devise and catch torre del greco Italy homes for rent by owner and for rent by owner homes torre del greco.
Debunk, determine, and hear vacation rental Sestri Levante, vacation rental Sestri Levante Italy, and Sestri Levante Italy rental homes.
|
|
