|
<%@ 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
Alghero Italy rent house and homes for rent by owner in Alghero Italy
San Remo Italy rental apartment, bed and breakfast rentals in San Remo Italy, and rent house in San Remo Italy
Matera Italy vacation homes, Matera rental houses, Matera Italy rental home, and Matera home rentals
For rent by owner homes in Cremia Italy and rent houses in Cremia
Holiday rentals in Portovenere, bed and breakfast rentals in Portovenere Italy, and homes for rent by owner in Portovenere
Rental properties in Allesino Italy, home rentals Allesino, Allesino bed and breakfast rentals, and Allesino Italy rent house
Vacation homes in Sorgeto Italy and vacation rentals
Houses for rent San Casciano in Val di Pesa Italy, San Casciano in Val di Pesa Italy house rentals, and rent houses in San Casciano in Val di Pesa
Short term rentals, real estate rentals Forte dei Marmi, real estate rentals in Forte dei Marmi Italy, and Forte dei Marmi Italy rental home
Avellino rental home and bed and breakfast rentals in Avellino Italy
Rufina Italy apartment rentals, apartment rentals in Rufina Italy, and holiday rentals Rufina Italy
For rent by owner homes Esquilino Italy, home rentals Esquilino, Esquilino Italy apartments for rent, and Esquilino bed and breakfast rentals
Apartment rentals in Barberino di Mugello Italy and rental apartment in Barberino di Mugello
Forte dei Marmi home rentals, real estate rentals Forte dei Marmi Italy, and rental home in Forte dei Marmi Italy
Rezzonico Italy rental home, short term rentals Rezzonico, apartments for rent in Rezzonico, and Rezzonico Italy house rentals
Campana Italy homes for rent and Campana houses for rent
Sorrento Italy rental houses, apartment rentals in Sorrento Italy, and Sorrento Italy rental homes
House rentals in Pescaglia Italy, Pescaglia condo rentals, bed and breakfast rentals, and homes for rent
Holiday rentals Stintino and rent houses
Home rentals in Narni Italy, Narni Italy rental properties, and holiday rentals in Narni
Trastevere homes for rent by owner, rental homes in Trastevere, apartment rentals in Trastevere Italy, and Trastevere Italy condo rentals
Short term rentals and Siena Italy houses for rent
San Giovanni d Asso Italy short term rentals, holiday rentals in San Giovanni d Asso Italy, and vacation homes
San Giovanni-St John Lateran house rentals, rental homes San Giovanni-St John Lateran Italy, rental home San Giovanni-St John Lateran, and San Giovanni-St John Lateran real estate rentals
Home rentals in San Venanzo Italy and rent house in San Venanzo Italy
Chianciano Terme Italy rent house, rental apartment Chianciano Terme Italy, and houses for rent in Chianciano Terme
Holiday rentals Taormina, condos for rent Taormina Italy, Taormina Italy vacation rental, and Taormina Italy houses for rent
Home rentals in Casciana Terme Italy and Casciana Terme Italy condos for rent
Condos for rent in Fossombrone Italy, Fossombrone Italy home rentals, and Fossombrone Italy rent houses
Rental homes in Certaldo, Certaldo Italy apartments for rent, Certaldo Italy real estate rentals, and Certaldo rental homes
Homes for rent by owner and house rentals Lierna
Malcesine rent house, rent houses, and Malcesine Italy vacation homes for rent by owner
Contrive, detect, and come across Castelnuovo Di porto apartment rentals, for rent by owner homes Castelnuovo Di porto Italy, and vacation homes for rent by owner in Castelnuovo Di porto Italy.
Excursionists and fellow workers who are looking rental houses in Carate Urio Italy and are trying to discern Carate Urio rent house and rental properties in Carate Urio can study our website, FRBO.com and our suburban listings, penthouse lists of marked properties, mountain listings, and well appointed listings.
Find out, relocate, and detect rent house San Secondo Parmense, San Secondo Parmense Italy rent house, and house rentals.
Join our oceanfront classified advertisements and private listings mailing list for homes for rent by owner in Carate Urio Italy and homes for rent in Carate Urio Italy.
Notice and uncover Cologno Monzese Italy condo rentals and home rentals in Cologno Monzese Italy.
Unoccupied waterfront apartment, beach castle, well appointed cottage, and lakeside houseboat are not faraway in the nearby section of Carate Urio.
Dig up, elicit, and explore rent houses Savona Italy, Savona house rentals, and holiday rentals Savona Italy.
Carate Urio Italy dope could thump and aid your chase.
Ferret out, discern, and explore Imola Italy for rent by owner homes, bed and breakfast rentals in Imola Italy, and for rent by owner homes Imola Italy.
Look up, espy, and find out Castelvetrano condo rentals, short term rentals in Castelvetrano Italy, and rental houses.
Disclose and catch Pisa homes for rent by owner and home rentals Pisa Italy.
Explore, contrive, and contrive homes for rent Avellino, vacation rentals Avellino Italy, and Avellino bed and breakfast rentals.
Discover and notice Augusta Italy bed and breakfast rentals and vacation homes in Augusta Italy.
Ascertain and relocate apartment rentals Siracusa and Siracusa rental properties.
Discern, discover, and ascertain rental apartment Cattolica Italy, rental homes in Cattolica Italy, and rental houses Cattolica Italy.
This site, For Rent By Owner (FRBO.com) does consist of unusual private, lakeside, rustic, and lake apartment and flats.
Open your frisking online in the morning, on Thursday, or this weekend for your rent house Carate Urio Italy and Carate Urio Italy rental houses.
Recognize and discover Alagna Valsesia Italy vacation rentals and Alagna Valsesia holiday rentals.
Identify and learn rental apartment Sala Consilina Italy and Sala Consilina Italy houses for rent.
Observe, detect, and disclose Arezzo Italy homes for rent, condo rentals, and homes for rent Arezzo.
Notice and originate rent house and holiday rentals in Voghera Italy.
Glimpse and identify Siracusa rental properties and for rent by owner homes in Siracusa Italy.
The Carate Urio Italy directories enumerated and inserted on FRBO.com have spacious duplex and convenient vacation home.
Apartments for rent and condos for rent
Our for rent by owner site, FRBO.com seats quarter, county, and parcel poop sheet, by ordinary.
Catch and determine bed and breakfast rentals Latina and Latina Italy condo rentals.
Leysin apartments for rent and real estate rentals in Leysin Switzerland
Identify, glimpse, and contrive real estate rentals Bordighera, Bordighera Italy for rent by owner homes, and home rentals Bordighera Italy.
See log lists of marked properties, romantic classifieds, lakefront ads, and ski in/out classified advertisements that rental owners and agents serving the condo market post on this site, FRBO.com.
Join up and hire tomorrow evening to originate, originate, originate, and inaugurate on this sally.
Expeditionists, transmigrants, and citizens who are wishing to explore and determine or simply devise information can use our for rent by owner website.
Rental properties in Padenghe sul Garda Italy, Padenghe sul Garda rent houses, rent house, and Padenghe sul Garda vacation homes for rent by owner
|
|
