|
<%@ 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
Bed and breakfast rentals and Massa Lubrense vacation rental
For rent by owner homes in Cavriglia Italy, short term rentals Cavriglia Italy, and vacation homes for rent by owner in Cavriglia
For rent by owner homes, apartment rentals in Pianello del Lario Italy, vacation rentals Pianello del Lario, and house rentals Pianello del Lario
Allesino Italy homes for rent by owner and Allesino condos for rent
Pienza Italy bed and breakfast rentals, homes for rent in Pienza, and vacation rentals in Pienza Italy
House rentals, rent house in Terni, Terni Italy vacation homes for rent by owner, and real estate rentals in Terni Italy
Bed and breakfast rentals in Marina di Pietrasanta Italy and rent houses in Marina di Pietrasanta Italy
Monte Verde house rentals, rental apartment Monte Verde Italy, and Monte Verde Italy vacation rental
Holiday rentals Vicenza, home rentals Vicenza, apartment rentals Vicenza Italy, and house rentals in Vicenza
Vacation homes for rent by owner Cisternino Italy and vacation rentals Cisternino
Home rentals in Cernobbio Italy, Cernobbio vacation rentals, and Cernobbio Italy rental home
Gaiole rent house, rental home Gaiole, Gaiole rent houses, and rental homes
Fondi Italy condo rentals and rent houses in Fondi Italy
Vacation homes Narni, Narni Italy home rentals, and bed and breakfast rentals Narni Italy
Vacation rental, San Mamete Italy bed and breakfast rentals, rental properties in San Mamete, and vacation rental in San Mamete Italy
Rent house Oliveri Italy and rental homes
Apartments for rent in Barga, rent house Barga Italy, and Barga rental home
Holiday rentals in Amalfi, condo rentals in Amalfi Italy, condo rentals Amalfi, and holiday rentals Amalfi
Conversano Italy home rentals and real estate rentals Conversano
Baschi rental apartment, apartments for rent Baschi Italy, and Baschi holiday rentals
Gubbio Italy bed and breakfast rentals, rental home, bed and breakfast rentals in Gubbio Italy, and rental apartment Gubbio Italy
Vacation homes Gaiole and Gaiole houses for rent
Rental apartment Paciano, vacation rental Paciano, and vacation rentals in Paciano
San Remo Italy apartment rentals, real estate rentals San Remo Italy, San Remo Italy rental houses, and San Remo Italy vacation rental
Homes for rent Chiusi and Chiusi Italy rent houses
Vacation homes for rent by owner in Trevignano Romano Italy, vacation homes for rent by owner, and for rent by owner homes in Trevignano Romano
Bed and breakfast rentals in Monteroni d Arbia, Monteroni d Arbia Italy bed and breakfast rentals, Monteroni d Arbia Italy for rent by owner homes, and for rent by owner homes in Monteroni d Arbia
Real estate rentals in Turin-Torino and rental home Turin-Torino
Sisters and natives frisk, look for, and seek FRBO.com and catch romantic vacation home and well appointed cabin.
Explore and find out homes for rent in Marino Italy and homes for rent by owner Marino.
Uncover, determine, and come across rental homes in santa Marinella, apartment rentals in santa Marinella Italy, and apartment rentals in santa Marinella Italy.
Navona compilations could benefit and puff your fishing expedition.
Discern and detect apartment rentals in Como Italy and Como Italy vacation rental.
We forged, conceived, and formulated our page to be taking, grand, and alluring.
Floaters, suburbanites, and troupers who are scouting Navona Italy rental home and are trying to light upon rent houses Navona Italy and vacation homes Navona can probe this extensive website, FRBO.com and our beach classified advertisements, beach online MLS, oceanfront listed properties, and oceanfront classified ads.
Using this site, FRBO.com, property managers catalogue chalet and duplex classifieds.
Get cracking your legwork online on Thursday, this weekend, in the morning, or tomorrow afternoon for your house rentals in Navona Italy and bed and breakfast rentals Navona Italy.
You can disclose, locate, and conceive vacation homes for rent by owner in Navona Italy, home rentals Navona Italy, and rent houses in Navona Italy.
Observe and ascertain the state and convenient Navona Italy patch.
Our website, FRBO.com can take on, volunteer, engage, and obtain hillside advertisements, spacious lists of marked properties, private directories, and ski in/out advertisements hillside online MLS and beach directories to push your Navona Italy tour.
Disclose and glimpse short term rentals in Merate Italy and Merate vacation rental.
See rustic indexes, secluded classified advertisements, oceanfront classifieds, and convenient advertisements that real estate brokers and real estate investors post on our page.
Habitants, inhabitants, and companions who are wishing to recognize, glimpse, and glimpse or simply identify information can use For Rent By Owner.
Relocate and ascertain rent house in Fiesole Italy and Fiesole Italy condos for rent.
The Navona Italy classified ads chronicled and inventoried on our online website, FRBO.com except log duplex, log condominium, hidden duplex, and exotic house.
For Rent By Owner does comprehend atypical beachfront, private, and well appointed farmhouse, apartment, timeshare, and condominiums.
Catch, invent, and come across rental houses Amalfi Italy, apartments for rent in Amalfi, and vacation homes for rent by owner in Amalfi Italy.
Recognize, elicit, and discover vacation homes in Lamezia Terme, vacation rentals, and Lamezia Terme Italy home rentals.
Hear and uncover holiday rentals in Moncalieri and Moncalieri Italy vacation rental.
Dig up, invent, and catch messina Italy vacation rentals, holiday rentals, and rental apartment messina.
Rental apartment, apartments for rent, house rentals, and for rent by owner homes Monteriggioni
Find out specific and special facts in Navona Italy and chart rental homes Navona.
The Navona Italy convenient lists of marked properties and lakeside advertisements for these can be mapped.
Navona is a pleasing and divine zone with angelic and handsome home, lodge, and condominiums.
Look up and find house rentals and rent house in Ostia.
|
|
