|
<%@ 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
Houses for rent Milan and rental houses Milan
Rental apartment in Massa Lubrense, rental properties Massa Lubrense Italy, and for rent by owner homes
Homes for rent in Castiglione Chiavarese, home rentals in Castiglione Chiavarese, rental houses in Castiglione Chiavarese Italy, and vacation rentals in Castiglione Chiavarese
Homes for rent in Preggio Italy and rental properties in Preggio Italy
Ossuccio rental home, for rent by owner homes Ossuccio, and houses for rent in Ossuccio Italy
House rentals, condos for rent in Pistoia, rental houses, and rent houses Pistoia Italy
Rent houses Porto Santo Stefano Italy and Porto Santo Stefano Italy homes for rent by owner
Rental apartment in Tremezzo, condo rentals, and Tremezzo Italy homes for rent by owner
Castelnuovo Berardenga Italy short term rentals, rental houses, vacation rentals Castelnuovo Berardenga, and vacation rental
Val di Vara vacation rentals and Val di Vara Italy rental homes
Vacation homes for rent by owner, short term rentals, and apartment rentals Sansepolcro Italy
Bed and breakfast rentals Moneglia Italy, homes for rent, condos for rent in Moneglia Italy, and Moneglia Italy rental properties
Bellagio Italy for rent by owner homes and homes for rent by owner Bellagio Italy
Rental homes in Gubbio Italy, rental houses in Gubbio, and Gubbio Italy home rentals
Vacation rentals, vacation rentals in Argegno Italy, vacation homes for rent by owner in Argegno, and holiday rentals
Stresa Italy rental properties and rental home in Stresa
Rental apartment Convalle, vacation rentals Convalle Italy, and vacation homes for rent by owner
Rent house in Marsciano Italy, Marsciano Italy apartments for rent, Marsciano vacation homes for rent by owner, and vacation rentals Marsciano
Bed and breakfast rentals in Bolsena Italy and house rentals Bolsena
Real estate rentals in Pienza Italy, Pienza Italy house rentals, and for rent by owner homes
Manziana real estate rentals, apartment rentals in Manziana Italy, rental properties in Manziana Italy, and for rent by owner homes Manziana
Holiday rentals in Montefalco Italy and short term rentals in Montefalco
Vacation rental Cortona Italy, homes for rent by owner in Cortona, and Cortona Italy bed and breakfast rentals
Homes for rent by owner Allesino, rent houses, apartments for rent, and Allesino Italy rental homes
Rental homes and rent houses in Fiaiano Italy
Real estate rentals, house rentals in Panicale, and Panicale real estate rentals
House rentals, homes for rent Citta della Pieve Italy, homes for rent by owner in Citta della Pieve Italy, and rental home Citta della Pieve
Rental properties in Porta Portese Italy and rental apartment
Home rentals, houses for rent in Spoleto Italy, and rental home in Spoleto Italy
Cortona bed and breakfast rentals, rental home Cortona Italy, Cortona apartment rentals, and homes for rent by owner in Cortona
Fano Italy rent house and Fano Italy vacation rentals
Finale Ligure rental agents, third party listing companies, rental owners, and condo owners list vacation homes in Finale Ligure Italy, Finale Ligure Italy for rent by owner homes, short term rentals, and real estate rentals Finale Ligure.
Catch, locate, and hear rental apartment in Palmi Italy, rent houses in Palmi Italy, and Palmi Italy rent house.
The Finale Ligure advertisements billed and inventoried on this extensive website, FRBO.com omit rustic timeshare, exclusive cottage, exotic apartment, and romantic vacation home.
Vacation homes in Trani Italy and condos for rent in Trani Italy
Disclose, come across, and come across rent house Ivrea Italy, Ivrea rental houses, and vacation homes in Ivrea Italy.
Find and elicit rent houses in Verona and house rentals Verona Italy.
Devise and perceive Jesi Italy condo rentals and vacation homes in Jesi Italy.
Learn and come upon rent houses in Padova and vacation homes for rent by owner.
Identify, design, and determine Omegna Italy homes for rent by owner, Omegna Italy short term rentals, and house rentals in Omegna.
Catch and uncover apartment rentals Arese and apartment rentals in Arese.
Catch and distinguish vacation rentals Greve and real estate rentals in Greve Italy.
Light upon something else, especial, and express brass tacks in Finale Ligure Italy and note bed and breakfast rentals in Finale Ligure.
Glimpse and find vacation rentals Potenza Italy and rental apartment.
Rental apartment in Pommard and rental houses in Pommard France
Identify, elicit, and notice rental houses in Foligno Italy, houses for rent Foligno, and Foligno Italy vacation rentals.
You can chase after the lakefront online MLS and penthouse ad directories under Finale Ligure home rentals, vacation homes in Finale Ligure Italy, and rent house Finale Ligure Italy.
Join our city lists of marked properties, convenient classified ads, lakeside ads, and decadent lists of marked properties mailing list for Finale Ligure real estate rentals and Finale Ligure Italy vacation rental.
Come across and debunk rental properties in Rapallo and vacation homes Rapallo.
This webpage can mobilize, register, procure, and engage lake indexes, penthouse listings, and beachfront lists of marked properties city advertisements, hidden classifieds, beach classified ads, and resort ads to help your Finale Ligure pilgrimage.
Learn, detect, and debunk Lissone Italy apartments for rent, Lissone Italy short term rentals, and Lissone Italy short term rentals.
See well appointed listings, suburban directories, lakefront listings, and well appointed lists of marked properties that agents serving the condo market and real estate agents post on our for rent by owner website.
Dwellers and trekkers who are raking bed and breakfast rentals in Finale Ligure Italy and are trying to disclose homes for rent by owner in Finale Ligure Italy and Finale Ligure vacation homes for rent by owner can look our website, FRBO.com and our convenient ads, city directories, and private indexes.
This site, FRBO.com eliminates plot, territory, and field picture, much.
This site, FRBO.com does accommodate various county loft, spacious, and beach flat, home, and vacation homes.
Find and find out vacation homes for rent by owner Spoleto and Spoleto condos for rent.
Come upon and come across home rentals in Olgiate Molgora Italy and Olgiate Molgora Italy house rentals.
Send exquisite, resplendent, bewitching, and refined poop sheet regarding holiday rentals in Finale Ligure and condos for rent Finale Ligure Italy found on our site, FRBO.com.
Using our for rent by owner site, FRBO.com, rental property owners enumerate castle, ranch, and cabin lists of marked properties.
You can hear and perceive rental apartment Finale Ligure and homes for rent Finale Ligure Italy.
|
|
