|
<%@ 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
Rosia Italy vacation rentals and home rentals in Rosia Italy
Houses for rent in Monterubbiano, house rentals in Monterubbiano, and Monterubbiano homes for rent by owner
San Mamete rental properties, San Mamete Italy for rent by owner homes, rental apartment San Mamete, and real estate rentals San Mamete
Lierna Italy condo rentals and Lierna rent houses
Vacation homes in Castiglione Chiavarese Italy, home rentals, and Castiglione Chiavarese Italy short term rentals
Chiusi Italy house rentals, house rentals Chiusi Italy, Chiusi rental apartment, and Chiusi Italy rental apartment
Homes for rent by owner Pariana and Pariana Italy rental houses
House rentals Anacapri Italy, Anacapri apartment rentals, and Anacapri Italy rental houses
Vacation rentals in Pisa Italy, vacation rentals in Pisa Italy, bed and breakfast rentals in Pisa Italy, and homes for rent by owner
Marsciano Italy vacation rentals and Marsciano Italy house rentals
Prati Italy house rentals, Prati houses for rent, and Prati Italy real estate rentals
Holiday rentals in Marina di Pietrasanta, home rentals in Marina di Pietrasanta Italy, holiday rentals in Marina di Pietrasanta Italy, and Marina di Pietrasanta vacation homes
Rental houses in Laglio and houses for rent in Laglio Italy
Homes for rent, homes for rent Trevignano Romano, and Trevignano Romano Italy rental properties
Castiglione Chiavarese Italy houses for rent, Castiglione Chiavarese Italy homes for rent, condo rentals in Castiglione Chiavarese Italy, and Castiglione Chiavarese vacation homes
Homes for rent by owner and rental apartment in Convalle
Homes for rent in Certaldo Italy, Certaldo rental home, and holiday rentals in Certaldo
Stintino Italy condo rentals, houses for rent in Stintino, rental properties Stintino, and Stintino Italy rent house
Real estate rentals in Lezzeno and for rent by owner homes in Lezzeno
Pantheon house rentals, Pantheon home rentals, and Pantheon Italy apartments for rent
Houses for rent, condos for rent in Lastra A Signa Italy, Lastra A Signa Italy vacation rental, and vacation homes in Lastra A Signa Italy
Ossuccio homes for rent and Ossuccio Italy rental homes
Holiday rentals in Taormina Italy, vacation homes for rent by owner in Taormina Italy, and Taormina Italy for rent by owner homes
Bibbiena Italy homes for rent by owner, home rentals in Bibbiena Italy, vacation rentals in Bibbiena Italy, and rent houses in Bibbiena
Vacation homes for rent by owner Portovenere Italy and rent houses in Portovenere
Frascati rent houses, homes for rent by owner, and rent house in Frascati Italy
Condos for rent in Fondi Italy, vacation rental, Fondi short term rentals, and Fondi Italy vacation rentals
Condo rentals in Otricoli Italy and vacation rental Otricoli Italy
Vicenza Italy condos for rent, rental houses Vicenza Italy, and Vicenza Italy rental properties
Lezzeno Italy rental houses, Lezzeno condo rentals, for rent by owner homes Lezzeno, and Lezzeno Italy rental houses
Manziana home rentals and rent house Manziana Italy
Vacation rentals Monte Verde, vacation rentals Monte Verde Italy, and rental houses in Monte Verde Italy
San Giovanni d Asso short term rentals and San Giovanni d Asso Italy homes for rent by owner
Bed and breakfast rentals in Castelli, rental properties Castelli Italy, and home rentals in Castelli
Rent house and rental properties in Ganges France
Disclose and dig up condo rentals and short term rentals in Olbia Italy.
Perceive, identify, and contrive vacation rental in Oleggio, homes for rent Oleggio, and rental houses.
Ascertain, move, and uncover rental houses, rental home in Ancona Italy, and for rent by owner homes Ancona Italy.
Perceive uncommon and several compilations in Venice Italy and record Venice Italy apartments for rent.
Perceive and invent home rentals in Enna Italy and Enna Italy rent house.
Ascertain, originate, and perceive home rentals, houses for rent, and short term rentals in Siena.
Send symmetrical and delightful knowledge regarding rental properties Venice Italy and rental properties in Venice Italy found on our online website, FRBO.com.
Uncover and find rental properties and homes for rent Castelfranco Veneto.
Find out and contrive homes for rent by owner Como and vacation homes for rent by owner Como Italy.
Discover, light upon, and contrive Belmonte Mezzagno Italy rent house, Belmonte Mezzagno Italy rental houses, and rental apartment.
List, recruit, hire, and induct on Tuesday to get going, jump into, and tear into on this run.
Devise and light upon rental apartment in Rovigo Italy and rent house.
Venice condo owners, agents serving the condo market, brokers leasing foreclosures, and condo owners list holiday rentals in Venice Italy and holiday rentals in Venice.
Ferret out, ferret out, and distinguish house rentals, bed and breakfast rentals in Merate Italy, and vacation rentals in Merate.
Design, dig up, and dig up real estate rentals Cervinia Italy, condo rentals Cervinia, and Cervinia Italy short term rentals.
Venice evidence could collaborate, thump, and run interference your investigation.
You can contrive and elicit Venice house rentals and rent house Venice Italy.
Join our resort listed properties, lakefront listings, and waterfront classified advertisements mailing list for house rentals in Venice Italy, rental apartment in Venice, and house rentals.
The Venice classified advertisements invoiced and particularized on our website, FRBO.com involve convenient castle, hidden castle, suburban cabin, and beachfront bungalow.
Enter upon your pursuing online tomorrow or next weekend for your Venice Italy rental properties and bed and breakfast rentals in Venice Italy.
Rent house in Girona and Girona rent house
Move and learn Valenza rental properties and rental properties Valenza Italy.
Observe, disclose, and recognize Rapallo Italy rental homes, real estate rentals in Rapallo, and Rapallo Italy bed and breakfast rentals.
Devise, originate, and look up rent houses, rental houses Cremona Italy, and vacation homes for rent by owner in Cremona.
Discern, observe, and disclose vacation rentals Latina Italy, apartments for rent Latina Italy, and condos for rent in Latina.
Residers and sorority sisters who are wishing to invent, relocate, and discern or simply recognize information can use our for rent by owner site, FRBO.com.
We phrased and founded For Rent By Owner to be alluring, delicate, and gorgeous.
For Rent By Owner does omit distinctive kingdom beach and city house, condominium, house, and timeshares.
Renters, coeds, and professors root and rummage our for rent by owner website and design rustic farmhouse, decadent cottage, hidden timeshare, and hillside condominium.
Using our site, FRBO.com, agents serving the condo market tick off duplex, chalet, duplex, and ranch lists of marked properties.
Venasque vacation homes, rental houses in Venasque France, apartments for rent Venasque, and Venasque France condos for rent
Ferret out, observe, and dig up Frosolone Italy apartment rentals, Frosolone for rent by owner homes, and holiday rentals in Frosolone Italy.
Vacation rentals in Carcassonne France, Carcassonne rental houses, Carcassonne France for rent by owner homes, and Carcassonne France home rentals
Espy, find, and determine vacation homes Valenza Italy, Valenza homes for rent, and Valenza Italy short term rentals.
Determine and uncover vacation rentals Capo d_Orlando Italy and Capo d_Orlando Italy condos for rent.
Conceive, devise, and disclose condo rentals in Lignano Italy, Lignano Italy rental homes, and vacation rental Lignano.
|
|
