|
<%@ 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
Apartment rentals in Fivizzano and Fivizzano Italy rental houses
Foligno Italy rent houses, Foligno rental apartment, and apartments for rent in Foligno Italy
Apartment rentals Bellagio Italy, real estate rentals, houses for rent in Bellagio, and vacation rental Bellagio Italy
San Casciano dei Bagni Italy rental houses and San Casciano dei Bagni Italy rental home
Vacation homes for rent by owner Chiusi, short term rentals, and rental apartment in Chiusi Italy
Borgo a Mozzano Italy rent houses, rent houses Borgo a Mozzano, Borgo a Mozzano Italy rental houses, and Borgo a Mozzano Italy rental apartment
Houses for rent in Lesa and Lesa homes for rent by owner
Homes for rent by owner, Vicchio Italy holiday rentals, and vacation rentals in Vicchio
Vacation homes, rent house Cefalu Italy, vacation homes, and Cefalu Italy short term rentals
Rental properties in Stresa and apartment rentals Stresa Italy
Monteroni d Arbia Italy vacation homes, Monteroni d Arbia rental apartment, and rental homes Monteroni d Arbia
Real estate rentals in Rapolano Terme Italy, homes for rent in Rapolano Terme Italy, rental houses Rapolano Terme Italy, and rental apartment in Rapolano Terme Italy
Rental home Servigliano Italy and rent house in Servigliano
Condos for rent in Chianciano Terme Italy, Chianciano Terme Italy rental homes, and Chianciano Terme homes for rent
Vacation homes for rent by owner in Trani Italy, home rentals in Trani Italy, Trani rental houses, and for rent by owner homes in Trani
Bed and breakfast rentals and apartments for rent Cisternino
Rent house Pantheon, houses for rent Pantheon Italy, and houses for rent in Pantheon Italy
Holiday rentals, Toirano Italy rental home, vacation homes for rent by owner in Toirano Italy, and vacation rentals in Toirano
Rental apartment in Fara In Sabina Italy and vacation homes Fara In Sabina Italy
Short term rentals in Monteriggioni Italy, Monteriggioni condos for rent, and homes for rent in Monteriggioni Italy
Home rentals Lesa Italy, Lesa condo rentals, vacation rentals Lesa, and Lesa homes for rent by owner
Real estate rentals in Pistoia and rent houses
Riomaggiore Italy rental properties, vacation rental in Riomaggiore, and short term rentals Riomaggiore
Houses for rent, San Pantaleo Italy holiday rentals, rent house in San Pantaleo Italy, and homes for rent San Pantaleo Italy
Alba Adriatica Italy rental properties and Alba Adriatica Italy apartment rentals
Apartments for rent in Careno, rental home Careno, and Careno Italy short term rentals
Real estate rentals in CittG di Castello Italy, holiday rentals, CittG di Castello Italy condo rentals, and CittG di Castello Italy vacation rental
Explore and notice vacation homes and condo rentals in Matera Italy.
Buonconvento Italy patch employs many rental owners, agents, and third party agents.
Find out, hear, and ferret out Milano Italy homes for rent, Milano apartment rentals, and vacation homes for rent by owner.
Short term rentals in Meyrargues France, rental home in Meyrargues, and Meyrargues France short term rentals
This website, FRBO.com consist ofs state, domain, field, and tract facts, sporadically.
Find, notice, and discover home rentals in Cardano al Campo Italy, Cardano al Campo Italy apartments for rent, and apartments for rent Cardano al Campo Italy.
Our for rent by owner website does take in other kingdom beach and secluded hacienda, home, farmhouse, and vacation homes.
For rent by owner homes in Kitzbuhel and homes for rent
Open your going-over online tomorrow evening, on Friday, next weekend, or tomorrow for your rent houses in Buonconvento Italy, rental properties in Buonconvento Italy, and rental homes in Buonconvento Italy.
See hillside listings, mountain online MLS, and exotic ad directories that property managers and property owners post on our webpage.
Uncover and find Trento Italy bed and breakfast rentals and rent houses in Trento Italy.
Using our for rent by owner site, FRBO.com, real estate investors classify hacienda, apartment, apartment, and houseboat ad directories.
Catch, hear, and glimpse Valtournenche Italy house rentals, vacation homes in Valtournenche Italy, and Valtournenche Italy for rent by owner homes.
Discern, disclose, and locate Imola Italy vacation rental, Imola house rentals, and vacation rental Imola Italy.
Light upon and conceive apartment rentals in Sala Biellese Italy and vacation homes for rent by owner in Sala Biellese Italy.
Learn and originate rental apartment Brescia and real estate rentals in Brescia Italy.
Contrive, hear, and originate Sorrento Italy vacation rentals, Sorrento Italy house rentals, and Sorrento condo rentals.
We built, shaped, and erected this extensive website, FRBO.com to be shapely and symmetrical.
Design and design for rent by owner homes and homes for rent by owner Rimini Italy.
Send divine and cute materials regarding homes for rent by owner in Buonconvento, Buonconvento Italy rental apartment, bed and breakfast rentals in Buonconvento Italy, and homes for rent by owner in Buonconvento Italy found on FRBO.Com, For Rent By Owner,.
Condo rentals, Oughterard Ireland holiday rentals, condo rentals Oughterard, and short term rentals Oughterard
|
|
