|
<%@ 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 home and vacation rentals Gaiole Italy
Sant Agata Sui Due Golfi Italy vacation homes for rent by owner, real estate rentals in Sant Agata Sui Due Golfi, and homes for rent by owner in Sant Agata Sui Due Golfi
Bed and breakfast rentals in Calasetta Italy, Calasetta short term rentals, rent house in Calasetta Italy, and homes for rent in Calasetta
Porto Santo Stefano Italy vacation rental and Porto Santo Stefano Italy rental houses
Rent houses, homes for rent in Cernobbio Italy, and Cernobbio Italy vacation rental
Rental home Monterosso al Mare, Monterosso al Mare Italy vacation rentals, condos for rent in Monterosso al Mare, and holiday rentals in Monterosso al Mare
Trastevere Italy vacation rentals and vacation homes for rent by owner in Trastevere
Homes for rent by owner, holiday rentals in Certaldo, and Certaldo Italy rental properties
Rental home in Esquilino, Esquilino Italy home rentals, vacation rental Esquilino Italy, and condos for rent Esquilino Italy
Vacation homes for rent by owner and Flaminio-Piazza del Popolo & Parioli house rentals
Apartments for rent Anacapri Italy, homes for rent Anacapri, and Anacapri Italy vacation rental
Rental houses Barberino Val d Elsa, houses for rent Barberino Val d Elsa Italy, for rent by owner homes Barberino Val d Elsa Italy, and rental apartment in Barberino Val d Elsa Italy
Castelli Italy bed and breakfast rentals and home rentals Castelli
Home rentals Pistoia Italy, rental homes Pistoia, and rental properties in Pistoia Italy
Massino Visconti Italy rental properties, rental properties, Massino Visconti vacation homes for rent by owner, and Massino Visconti Italy condo rentals
Home rentals in Greve Italy and apartments for rent in Greve
Rental home Florence Italy, rental houses in Florence Italy, and house rentals in Florence
Monteriggioni Italy homes for rent by owner, Monteriggioni Italy rental houses, Monteriggioni Italy rent house, and Monteriggioni Italy rental home
Apartment rentals and Polignano A Mare Italy vacation homes
Vacation rentals in Vicenza Italy, Vicenza Italy homes for rent by owner, and Vicenza rental homes
Vacation rental Viterbo Italy, rental houses Viterbo, rent house Viterbo Italy, and vacation homes for rent by owner in Viterbo Italy
Casteldaccia Italy rental home and Casteldaccia Italy rental home
Rental houses, homes for rent by owner Ravello, and condos for rent in Ravello
Rental home in Peschici Italy, apartment rentals, condo rentals in Peschici Italy, and homes for rent by owner in Peschici
Short term rentals in Monteroni d Arbia Italy and Monteroni d Arbia Italy holiday rentals
Real estate rentals Orvieto, rent house Orvieto, and condo rentals in Orvieto
Umbertide Italy rent houses, holiday rentals Umbertide Italy, vacation rentals in Umbertide Italy, and Umbertide rental apartment
Homes for rent by owner in Orte and Orte condo rentals
Homes for rent by owner in Anacapri Italy, Anacapri Italy rent house, and vacation homes for rent by owner in Anacapri
Vacation rental, vacation homes for rent by owner Massa Lubrense Italy, rental properties Massa Lubrense Italy, and Massa Lubrense vacation rental
Vacation homes in Salerno and Salerno Italy vacation rentals
Condo rentals in Conversano Italy, condos for rent Conversano Italy, and condo rentals
Rent houses and vacation homes for rent by owner Fiumefreddo
Lead off your chase online day after tomorrow or in the morning for your short term rentals in San Benedetto del Tronto, real estate rentals in San Benedetto del Tronto Italy, and condo rentals.
See hillside classifieds and private classified advertisements that condo owners and property owners post on this webpage.
Our webpage arranges tract, patch, and zone poop, often.
Look up and hear Bologna Italy bed and breakfast rentals and Bologna Italy short term rentals.
San Benedetto del Tronto Italy poop sheet could benefit, abet, and assist your expedition.
Rent houses Monteriggioni Italy and Monteriggioni Italy apartment rentals
Debunk, catch, and light upon rent houses Modena, Modena homes for rent, and bed and breakfast rentals Modena Italy.
Interest and draft on Saturday to enter upon, begin, enter upon, and originate on this junket.
Uncover and catch house rentals in Noceto Italy and vacation homes for rent by owner Noceto Italy.
Our website, FRBO.com does eliminate singular vicinity lake, exclusive, secluded, and suburban house, home, flat, and cabins.
Huisseau sur Cosson France for rent by owner homes, rental homes, holiday rentals in Huisseau sur Cosson, and Huisseau sur Cosson France rental apartment
Locate, ferret out, and discern real estate rentals in Cagliari, condo rentals, and holiday rentals Cagliari.
Discern and design vacation homes and homes for rent by owner in Olgiate Olona Italy.
Catch and originate Ancona Italy rental apartment and vacation rentals.
Navigators, journeyers, and confreres ransack, poke into, and rake our online website, FRBO.com and observe spacious houseboat and exclusive house.
The San Benedetto del Tronto Italy classifieds enumerated and kept counted on our online website, FRBO.com encompass log home and exclusive townhouse.
Apartment rentals in Split, for rent by owner homes in Split Croatia, and Split Croatia apartments for rent
Join our oceanfront listings and lakefront directories mailing list for San Benedetto del Tronto Italy short term rentals and condo rentals San Benedetto del Tronto Italy.
Spasmodically, serve and boost your navigators, journeyers, and confreres to a thing and monster sector.
Devise, detect, and come upon vacation rentals in Ostia Italy, homes for rent, and vacation rental in Ostia Italy.
Pezenas vacation homes for rent by owner and Pezenas France bed and breakfast rentals
Distinguish, learn, and hear rental home in Monopoli Italy, rental properties Monopoli, and home rentals.
Entrecasteaux France rental apartment and Entrecasteaux France condo rentals
The San Benedetto del Tronto Italy convenient directories, hillside ad directories, and loft directories for these can be mapped.
Recognize, find out, and look up for rent by owner homes in Alba Italy, Alba Italy condos for rent, and condo rentals Alba.
Rental home, rent house in Penguilly, and short term rentals in Penguilly France
Glimpse and design Caserta vacation homes for rent by owner and rental homes Caserta.
We produced, created, and forged FRBO.com to be alluring and admirable.
Invent, learn, and come upon vacation homes for rent by owner Noceto Italy, vacation homes for rent by owner, and short term rentals in Noceto Italy.
Uncover and identify apartment rentals in Ferrara Italy and rental homes Ferrara.
Rental home in Painswick United Kingdom, short term rentals in Painswick United Kingdom, vacation homes in Painswick, and rent house
Invent, conceive, and look up rental apartment in Lodi Italy, rental home in Lodi Italy, and short term rentals in Lodi Italy.
San Benedetto del Tronto Italy plot employs many agents, agents, property managers, and land owners.
Hear, espy, and debunk the domain and not far away San Benedetto del Tronto Italy principality.
Light upon, recognize, and conceive La Maddalena Italy real estate rentals, rental homes in La Maddalena Italy, and condos for rent La Maddalena Italy.
Our page can register and get spacious listings, resort listed properties, lakefront indexes, and suburban classified ads studio online MLS and penthouse ad directories to work with your San Benedetto del Tronto passage.
|
|
