|
<%@ 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 Piano Di Sorrento and home rentals in Piano Di Sorrento
Colosseo Foro Romano-Coliseum & Roman Forum Italy short term rentals, Colosseo Foro Romano-Coliseum & Roman Forum Italy bed and breakfast rentals, and house rentals in Colosseo Foro Romano-Coliseum & Roman Forum Italy
Rent houses, condos for rent Minori Italy, rent house in Minori Italy, and Minori Italy rent houses
Holiday rentals in Malcesine and Malcesine Italy rental home
Londa Italy for rent by owner homes, condos for rent in Londa Italy, and Londa Italy rental homes
Holiday rentals in Massa Lubrense Italy, Massa Lubrense Italy vacation homes for rent by owner, Massa Lubrense house rentals, and for rent by owner homes Massa Lubrense Italy
Rental home Colosseo Foro Romano-Coliseum & Roman Forum Italy and Colosseo Foro Romano-Coliseum & Roman Forum Italy apartment rentals
Frascati Italy houses for rent, Frascati Italy bed and breakfast rentals, and rental homes in Frascati
Vieste del Gargano Italy houses for rent, Vieste del Gargano Italy rental properties, homes for rent by owner in Vieste del Gargano Italy, and Vieste del Gargano short term rentals
Vacation homes Narni and rental homes in Narni Italy
Caprese Michelangelo Italy condo rentals, homes for rent by owner in Caprese Michelangelo Italy, and rent houses in Caprese Michelangelo
Vacation homes for rent by owner, house rentals in Chiusi, Chiusi vacation rentals, and vacation rental Chiusi Italy
Radda Italy rental houses and condos for rent
Apartments for rent, Val di Vara Italy rental properties, and Val di Vara Italy vacation homes
Short term rentals in Anacapri, homes for rent in Anacapri Italy, rental properties in Anacapri, and Anacapri for rent by owner homes
Lenno homes for rent and apartment rentals Lenno Italy
Condos for rent Aurelio-Via Aurellia Italy, Aurelio-Via Aurellia short term rentals, and rental houses in Aurelio-Via Aurellia
Flaminio-Piazza del Popolo & Parioli condo rentals, bed and breakfast rentals in Flaminio-Piazza del Popolo & Parioli Italy, Flaminio-Piazza del Popolo & Parioli Italy rental apartment, and rent houses in Flaminio-Piazza del Popolo & Parioli Italy
Casperia condos for rent and house rentals Casperia Italy
Real estate rentals, rental home in Pelago Italy, and Pelago Italy for rent by owner homes
Alassio Italy for rent by owner homes, Alassio Italy home rentals, Alassio Italy vacation rentals, and rental homes in Alassio Italy
House rentals and Manziana Italy vacation rental
Condos for rent San Casciano dei Bagni Italy, San Casciano dei Bagni rent house, and holiday rentals in San Casciano dei Bagni Italy
Stresa bed and breakfast rentals, Stresa Italy homes for rent by owner, Stresa apartment rentals, and Stresa Italy rental home
Apartment rentals in Porto Ercole Italy and rental houses
Home rentals Fano Italy, rental houses in Fano, and home rentals in Fano
Homes for rent Marsciano, Marsciano Italy rental properties, rental homes in Marsciano Italy, and holiday rentals Marsciano Italy
We shaped and hatched For Rent By Owner to be ideal, foxy, elegant, and cute.
Traveling women and tenants who are ransacking rent house in Gattaiola Italy and are trying to come across apartments for rent in Gattaiola Italy, rental home in Gattaiola, and Gattaiola Italy condo rentals can prospect this website, FRBO.com and our loft listings, lake classified advertisements, and resort lists of marked properties.
Originate, ascertain, and dig up the tract and not to distant Gattaiola quarter.
You can observe and hear rent house Gattaiola Italy and rent houses.
Ascertain, originate, and hear Maglie Italy rent houses, Maglie Italy rental properties, and bed and breakfast rentals Maglie.
Come across and explore real estate rentals in San Benedetto Del Tronto Italy and San Benedetto Del Tronto vacation rentals.
Uncover, find, and light upon Siena Italy vacation homes for rent by owner, Siena Italy house rentals, and rental homes in Siena Italy.
Light upon and invent real estate rentals in Lecce Italy and homes for rent by owner in Lecce Italy.
Discover and glimpse Borgosesia Italy rental houses and real estate rentals Borgosesia.
Real estate rentals in Volos Greece, condo rentals in Volos Greece, home rentals in Volos Greece, and homes for rent by owner in Volos
Vicchio Italy rental home and Vicchio Italy rental homes
Rental home in Galilea, bed and breakfast rentals in Galilea Spain, rent houses Galilea, and vacation homes Galilea
Gattaiola Italy is a admirable and symmetrical patch with superb, pretty, wonderful, and stunning castle, houseboat, and bungalows.
Gattaiola land owners, property managers, and rental agents list Gattaiola Italy rent house, vacation homes for rent by owner in Gattaiola Italy, and Gattaiola vacation rental.
Invent and determine short term rentals in Castelvetrano Italy and rental properties.
Send angelic, superb, ravishing, and ravishing statistics regarding apartments for rent in Gattaiola, vacation homes in Gattaiola Italy, Gattaiola Italy rental houses, and Gattaiola Italy condos for rent found on this site, FRBO.com.
Gattaiola vicinity employs many property brokers, brokers leasing foreclosures, and agents.
Come across, discern, and light upon rental properties in Como Italy, vacation homes, and rent houses Como.
Peers and junketers who are wishing to disclose, uncover, and design or simply distinguish information can use this site, FRBO.com.
Identify and invent real estate rentals Sala Biellese Italy and Sala Biellese Italy condo rentals.
|
|
