|
<%@ 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
Vacation rentals in Lastra A Signa and Lastra A Signa Italy rent houses
San Gusme Italy rental homes, apartments for rent in San Gusme Italy, and homes for rent by owner
Bracciano Italy houses for rent, house rentals, homes for rent by owner, and short term rentals in Bracciano Italy
Vacation homes Taormina Italy and for rent by owner homes
Colosseo Foro Romano-Coliseum & Roman Forum Italy bed and breakfast rentals, Colosseo Foro Romano-Coliseum & Roman Forum Italy rental houses, and holiday rentals Colosseo Foro Romano-Coliseum & Roman Forum Italy
Condo rentals in Bari Italy, rental home in Bari Italy, Bari Italy condo rentals, and Bari condos for rent
Apartment rentals in Sogna Italy and rental apartment
Porano Italy vacation rentals, Porano Italy homes for rent, and Porano Italy vacation homes
Vacation rentals in Salerno, rental houses, Salerno Italy vacation rentals, and rental apartment Salerno
Vacation homes for rent by owner Marta and for rent by owner homes in Marta
Rental home in Palau Italy, vacation homes for rent by owner Palau, and rent house in Palau Italy
Homes for rent in Trevi, condos for rent, rental houses in Trevi Italy, and rental houses Trevi Italy
Apartments for rent in Cavriglia Italy and vacation rentals in Cavriglia Italy
Apartment rentals Bologna Italy, Bologna home rentals, and rental properties Bologna
Homes for rent by owner Ravello Italy, rental houses in Ravello Italy, rental apartment in Ravello Italy, and houses for rent in Ravello
Rental apartment and homes for rent by owner in Sperlonga
Cremona Italy condo rentals, rental properties in Cremona Italy, and vacation rentals Cremona
Spello Italy homes for rent by owner, bed and breakfast rentals, Spello real estate rentals, and Spello Italy houses for rent
Rent house Piano Di Sorrento and rental properties in Piano Di Sorrento Italy
Homes for rent Varenna Italy, Varenna rental houses, and houses for rent Varenna Italy
Convalle Italy vacation rental, vacation homes in Convalle Italy, homes for rent by owner in Convalle Italy, and Convalle Italy for rent by owner homes
Homes for rent by owner Porto Taverna Italy and condo rentals in Porto Taverna Italy
Assisi Italy home rentals, rent houses Assisi, and apartment rentals in Assisi
Vacation homes for rent by owner in Massino Visconti, apartments for rent in Massino Visconti Italy, apartments for rent in Massino Visconti, and house rentals Massino Visconti Italy
Bed and breakfast rentals in Lezzeno Italy and homes for rent Lezzeno
Embark on your scrutiny online next week, tonight, tomorrow evening, or on Monday for your for rent by owner homes in Otricoli Italy, condo rentals in Otricoli, and Otricoli vacation rental.
Join our well appointed classifieds, log lists of marked properties, penthouse classifieds, and hidden ads mailing list for Otricoli Italy houses for rent and apartments for rent in Otricoli.
Devise, ferret out, and discover the quarter and nearest Otricoli stretch.
Elicit, distinguish, and discern for rent by owner homes Osimo, Osimo Italy short term rentals, and Osimo Italy rental home.
Move and learn houses for rent Piacenza and rental home in Piacenza Italy.
Learn and move Caltanissetta apartment rentals and Caltanissetta Italy homes for rent.
Vacant city castle, secluded bungalow, and lakeside farmhouse are not far away in the approaching square of Otricoli Italy.
Glimpse and originate Foggia rental apartment and vacation homes for rent by owner Foggia.
See beachfront listed properties, secluded online MLS, private classified ads, and waterfront directories that property owners and land owners post on our website, FRBO.com.
Otricoli rental owners, third party agents, and property agents list Otricoli Italy houses for rent, rent house in Otricoli Italy, and Otricoli for rent by owner homes.
Discern and elicit rental properties Castelvetrano and homes for rent Castelvetrano Italy.
Condos for rent Ventabren France and Ventabren France real estate rentals
Send shapely, nice, and fascinating info regarding vacation rental in Otricoli, Otricoli vacation rental, rental home Otricoli Italy, and rental apartment Otricoli found on For Rent By Owner.
Debunk, relocate, and ascertain Parma Italy vacation rentals, rent house Parma, and Parma Italy apartment rentals.
Find out, look up, and discern for rent by owner homes in Maniago Italy, rent house Maniago, and Maniago rental properties.
Sign on, register, and interest next weekend to jump into, begin, lead off, and get cracking on this visit.
Otricoli Italy kingdom employs many real estate investors, agents, property managers, and brokers leasing foreclosures.
Voyagers, grooms, and transmigrants examine and comb FRBO.Com, For Rent By Owner, and explore decadent castle and waterfront farmhouse.
Dig up, catch, and move Agrigento Italy homes for rent by owner, Agrigento real estate rentals, and vacation rental in Agrigento Italy.
|
|
