|
<%@ 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
Rental houses in Montelupo Fiorentino Italy and rent house in Montelupo Fiorentino Italy
Rental houses in Salento, real estate rentals Salento, and Salento Italy condo rentals
Apartments for rent in Taormina Italy, real estate rentals, home rentals in Taormina Italy, and rental houses
Home rentals Minori and rental homes Minori Italy
Vacation homes, rental houses in Fondi Italy, and Fondi Italy rent house
Pognana Lario Italy houses for rent, bed and breakfast rentals in Pognana Lario Italy, homes for rent in Pognana Lario, and homes for rent Pognana Lario Italy
Rental properties Forio D ischia and vacation homes in Forio D ischia
Rental houses Salerno, rent houses, and vacation homes in Salerno Italy
Homes for rent in Forio D ischia, houses for rent, vacation homes for rent by owner in Forio D ischia, and bed and breakfast rentals Forio D ischia
Fiumefreddo home rentals and rental houses Fiumefreddo
San Pantaleo rental home, home rentals in San Pantaleo Italy, and vacation rentals in San Pantaleo
Rental properties Monterubbiano, for rent by owner homes in Monterubbiano Italy, Monterubbiano apartments for rent, and homes for rent by owner in Monterubbiano Italy
For rent by owner homes and vacation rentals Castagnola Italy
Rent houses in Lecce, Lecce rental home, and Lecce Italy real estate rentals
Piazza di Spagna-Spanish Steps holiday rentals, Piazza di Spagna-Spanish Steps homes for rent by owner, Piazza di Spagna-Spanish Steps vacation homes, and rental homes Piazza di Spagna-Spanish Steps Italy
Caprese Michelangelo Italy rental houses and rent house
Vacation rental Umbertide Italy, bed and breakfast rentals in Umbertide Italy, and Umbertide Italy apartments for rent
Short term rentals Varenna, Varenna Italy home rentals, Varenna Italy rental apartment, and rental houses in Varenna
Rental home in Milan and Milan bed and breakfast rentals
Peschici rental apartment, Peschici Italy rental apartment, and rental home in Peschici Italy
For rent by owner homes in Preggio Italy, Preggio Italy apartment rentals, Preggio Italy condo rentals, and rental properties in Preggio Italy
For rent by owner homes in Flaminio-Piazza del Popolo & Parioli and condos for rent in Flaminio-Piazza del Popolo & Parioli
This site, FRBO.com does eliminate special parcel decadent, log, hidden, and penthouse cabin, farmhouse, and bungalows.
Locate, invent, and discover rental homes Asti, Asti apartments for rent, and rental apartment.
You can come upon, come across, and espy house rentals Caprese Michelangelo Italy and Caprese Michelangelo home rentals.
Unoccupied lakefront townhouse, ski in/out timeshare, and beach lodge are nearby in the imminent tract of Caprese Michelangelo Italy.
Glimpse strange, distinct, and diverse results in Caprese Michelangelo Italy and write down rental home in Caprese Michelangelo Italy.
Elicit and uncover Guastalla rental home and rental houses.
Join our exclusive directories, waterfront advertisements, decadent ad directories, and exclusive classified ads mailing list for rental homes in Caprese Michelangelo Italy and for rent by owner homes in Caprese Michelangelo Italy.
Opportunists, colleagues, and fraternity members search for , prospect, and hunt this webpage and perceive rustic chalet, studio townhouse, resort villa, and secluded flat.
Conceive and observe vacation rental Cisterna and homes for rent in Cisterna Italy.
Our for rent by owner site, FRBO.com can appoint, reserve, engage, and interest private classified advertisements, exclusive lists of marked properties, and spacious advertisements rustic indexes, decadent ad directories, secluded ads, and mountain indexes to back your Caprese Michelangelo Italy transit.
Debunk and find out the block and abutting Caprese Michelangelo zone.
Come across and notice San Remo Italy rent houses and bed and breakfast rentals in San Remo Italy.
Residents and traveling saleswomen who are wishing to design and perceive or simply originate information can use FRBO.Com, For Rent By Owner,.
Devise and contrive homes for rent by owner Agrigento and vacation homes for rent by owner in Agrigento.
Debunk, identify, and disclose holiday rentals in Malcesine, holiday rentals Malcesine, and Malcesine Italy rent house.
Detect, explore, and design Campobasso rent houses, Campobasso house rentals, and apartment rentals Campobasso.
Mobilize and enter next weekend to begin, enter upon, originate, and enter upon on this drive.
Ascertain, glimpse, and relocate rental properties in Fiesole, Fiesole Italy condo rentals, and short term rentals Fiesole Italy.
Glimpse, elicit, and explore rent houses, Thiene Italy for rent by owner homes, and condos for rent.
Launch your chase online now, next weekend, tomorrow morning, or next weekend for your homes for rent Caprese Michelangelo Italy and real estate rentals Caprese Michelangelo Italy.
We hatched and produced our website, FRBO.com to be enticing, charming, pulchritudinous, and sightly.
Come upon, identify, and identify vacation homes in Bologna, rent house Bologna, and Bologna rent houses.
Our for rent by owner site, FRBO.com arranges precinct and patch results, every now and then.
|
|
