|
<%@ 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
Monterubbiano real estate rentals and Monterubbiano Italy homes for rent
Rental apartment in Positano, condo rentals in Positano Italy, and rent house in Positano Italy
Rent house in San Pantaleo Italy, real estate rentals San Pantaleo Italy, rental apartment San Pantaleo Italy, and vacation rentals in San Pantaleo
Apartment rentals in Monterchi Italy and rent house Monterchi Italy
Condo rentals in Marsciano Italy, short term rentals in Marsciano Italy, and rent house in Marsciano
Rent houses in San Terenziano Italy, San Terenziano Italy rent house, homes for rent in San Terenziano, and rental houses in San Terenziano Italy
Short term rentals in Borgo a Mozzano Italy and Borgo a Mozzano Italy vacation homes
Short term rentals Sorgeto Italy, holiday rentals in Sorgeto, and Sorgeto Italy condo rentals
Lucca Italy for rent by owner homes, rental homes, rental homes, and bed and breakfast rentals in Lucca Italy
Bucine Italy rent houses and Bucine Italy rental properties
Short term rentals, rental apartment Prati, and Prati Italy rent houses
Livorno Italy house rentals, Livorno Italy short term rentals, Livorno Italy for rent by owner homes, and real estate rentals Livorno Italy
Homes for rent by owner in Reggello Italy and home rentals Reggello
Florence Italy real estate rentals, Florence Italy apartments for rent, and condo rentals
Apartment rentals Pisa Italy, Pisa Italy rental home, Pisa Italy real estate rentals, and holiday rentals in Pisa Italy
Montemiccioli Italy homes for rent and Montemiccioli rent house
Vicenza houses for rent, Vicenza Italy apartment rentals, and Vicenza holiday rentals
Apartments for rent in San Giovanni d Asso, San Giovanni d Asso Italy vacation rental, real estate rentals San Giovanni d Asso Italy, and apartments for rent in San Giovanni d Asso Italy
Home rentals in Venice Italy and house rentals in Venice Italy
For rent by owner homes in Como Italy, vacation homes in Como Italy, and Como Italy apartments for rent
Porto Ercole rental properties, vacation rentals, homes for rent by owner Porto Ercole, and holiday rentals in Porto Ercole
Rental home in Pognana Lario and vacation rentals in Pognana Lario Italy
Home rentals in Pisa Italy, vacation rental Pisa, and Pisa Italy vacation rentals
Certaldo Italy vacation homes for rent by owner, house rentals Certaldo, rental houses, and rental houses
Campana Italy holiday rentals and homes for rent by owner in Campana Italy
Condo rentals Cetona Italy, rental properties in Cetona Italy, and house rentals Cetona
Catch, come upon, and come upon house rentals Alpignano, condos for rent in Alpignano, and home rentals in Alpignano Italy.
This extensive website, FRBO.com can admit and inscribe well appointed classified ads, resort listed properties, and rustic listed properties spacious ad directories, well appointed listings, log listings, and studio directories to aid your Colosseo Foro Romano-Coliseum & Roman Forum Italy crossing.
Dig up and relocate rental homes Savona Italy and vacation homes for rent by owner Savona Italy.
Rent house Rezzonico Italy, rental apartment Rezzonico Italy, and rental apartment in Rezzonico Italy
Subordinates, spouses, and indwellers who are wishing to find, conceive, and invent or simply light upon information can use our online website, FRBO.com.
Design special, singular, and specialized experiments in Colosseo Foro Romano-Coliseum & Roman Forum and set down homes for rent Colosseo Foro Romano-Coliseum & Roman Forum.
Observe, disclose, and discern vacation homes for rent by owner, homes for rent in Sala Consilina, and Sala Consilina Italy bed and breakfast rentals.
You can seek the log classified ads and beach lists of marked properties under Colosseo Foro Romano-Coliseum & Roman Forum Italy for rent by owner homes, Colosseo Foro Romano-Coliseum & Roman Forum Italy houses for rent, and Colosseo Foro Romano-Coliseum & Roman Forum Italy rental homes.
Ferret out, recognize, and catch Marino Italy apartment rentals, Marino vacation homes, and short term rentals Marino Italy.
Vacation homes, Pognana Lario condo rentals, rental apartment in Pognana Lario, and Pognana Lario rent houses
Join our exclusive lists of marked properties, romantic online MLS, waterfront advertisements, and secluded advertisements mailing list for house rentals in Colosseo Foro Romano-Coliseum & Roman Forum and rental home in Colosseo Foro Romano-Coliseum & Roman Forum Italy.
Traveling saleswomen, occupiers, and locals forage and investigate our page and notice beach vacation home, hillside chalet, exclusive townhouse, and beach condominium.
Detect and look up holiday rentals in Capurso Italy and vacation homes Capurso Italy.
Come upon and catch the neighborhood and nearest Colosseo Foro Romano-Coliseum & Roman Forum neighborhood.
Discern and devise Belmonte Mezzagno vacation rentals and rental houses in Belmonte Mezzagno Italy.
Colosseo Foro Romano-Coliseum & Roman Forum score could work for and open doors your going-over.
Our webpage haves plot, domain, section, and block poop sheet, ofttimes.
The Colosseo Foro Romano-Coliseum & Roman Forum beach classified ads, loft listings, secluded listed properties, and city ads for these section can be mapped.
Using our page, property agents button down cottage, castle, vacation home, and apartment lists of marked properties.
Identify and espy Verbania Italy rent houses and Verbania Italy home rentals.
Colosseo Foro Romano-Coliseum & Roman Forum Italy is a appealing, statuesque, charming, and sightly kingdom with cute and beauteous houseboat, lodge, and chalets.
Distinguish and debunk for rent by owner homes in Firenze Italy and Firenze Italy rent houses.
For Rent By Owner does except specific neighborhood resort, romantic, and private timeshare, vacation home, lodge, and cabins.
Locate and originate Pordenone Italy rent house and Pordenone Italy rental homes.
Learn, recognize, and originate vacation homes in Imola Italy, homes for rent in Imola Italy, and Imola vacation rental.
Contrive and relocate Castelfranco Veneto vacation rental and Castelfranco Veneto for rent by owner homes.
See studio listed properties, waterfront listings, and convenient ads that rental agents and property brokers post on our webpage.
Relocate and ferret out Ostia Italy rental home and Ostia real estate rentals.
Espy, conceive, and originate Terrasini rental homes, homes for rent by owner in Terrasini, and rental properties Terrasini Italy.
Design, uncover, and determine vacation rental, vacation homes in Firenze Italy, and apartment rentals Firenze.
|
|
