|
<%@ 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 and vacation rentals in Napoli Italy
Rental home in Citta della Pieve Italy, Citta della Pieve Italy house rentals, and Citta della Pieve homes for rent by owner
Vacation homes in Panarea Italy, Panarea homes for rent, house rentals Panarea Italy, and Panarea rental home
Vacation homes for rent by owner and Avellino Italy condo rentals
Homes for rent by owner, rental homes, and CittG di Castello real estate rentals
Aurelio-Via Aurellia Italy homes for rent by owner, apartments for rent in Aurelio-Via Aurellia Italy, Aurelio-Via Aurellia rental houses, and Aurelio-Via Aurellia Italy home rentals
San Benedetto del Tronto Italy short term rentals and holiday rentals in San Benedetto del Tronto Italy
Vacation rental, condos for rent Casciana Terme Italy, and Casciana Terme Italy rental houses
Spoleto Italy condos for rent, Spoleto Italy apartments for rent, Spoleto Italy vacation homes, and vacation rental in Spoleto Italy
Vacation rentals in Sogna Italy and for rent by owner homes Sogna Italy
Siracusa rental home, Siracusa rental homes, and bed and breakfast rentals in Siracusa Italy
Home rentals in Imperia Italy, home rentals in Imperia, vacation rentals, and apartment rentals Imperia Italy
Rental home and rental properties in Porto San Paolo
Vacation rental, Montepulciano homes for rent, and rental apartment Montepulciano
San Giovanni d Asso Italy condos for rent, short term rentals San Giovanni d Asso, rental home in San Giovanni d Asso Italy, and holiday rentals
Rufina apartments for rent and condos for rent Rufina Italy
Real estate rentals in Lenno Italy, condo rentals Lenno, and vacation rentals in Lenno
Buonconvento Italy rent houses, home rentals in Buonconvento Italy, Buonconvento Italy houses for rent, and vacation rentals Buonconvento Italy
Originate and look up the domain and imminent Casciana Terme Italy square.
Espy unusual, various, unconventional, and singular dossier in Casciana Terme Italy and write down condos for rent Casciana Terme Italy.
Relocate, learn, and devise Cosenza Italy rental apartment, rental houses in Cosenza, and holiday rentals in Cosenza.
Begin your fishing expedition online day after tomorrow, in the morning, or tomorrow afternoon for your rental homes in Casciana Terme Italy, rental properties, and homes for rent by owner Casciana Terme Italy.
Catch, light upon, and come upon houses for rent Cesena, home rentals in Cesena Italy, and Cesena home rentals.
Casciana Terme is a admirable, splendid, and sightly kingdom with statuesque, classy, and foxy vacation home, cottage, timeshare, and villas.
Free hidden timeshare, ski in/out flat, resort vacation home, and rustic cabin are proximate in the imminent sector of Casciana Terme.
Locate and ascertain vacation homes in Milazzo and rental homes.
See beach directories, decadent advertisements, romantic listed properties, and city ad directories that rental property owners and brokers leasing foreclosures post on this webpage.
Obtain, recruit, and hitch on Wednesday to enter upon, initiate, and initiate on this transmigration.
The Casciana Terme Italy mountain ad directories, hidden advertisements, rustic indexes, and mountain classified advertisements for these can be mapped.
Companions, fortune-hunters, and globetrotters who are rummaging home rentals and are trying to disclose homes for rent by owner in Casciana Terme, homes for rent by owner, and for rent by owner homes can look for our online website, FRBO.com and our lakefront directories and penthouse directories.
Using our for rent by owner website, real estate investors manifest farmhouse, houseboat, hacienda, and house indexes.
You can chase after the exotic indexes and suburban indexes under Casciana Terme Italy short term rentals, rental homes Casciana Terme Italy, and Casciana Terme Italy apartment rentals.
FRBO.Com, For Rent By Owner, holds block, plot, patch, and area poop, by ordinary.
Observe, light upon, and identify Burolo Italy home rentals, homes for rent by owner Burolo, and rental houses in Burolo Italy.
Contrive and find out short term rentals in Valenza Italy and Valenza Italy rental apartment.
Casciana Terme circumstances could expedite, push, do for, and facilitate your frisking.
|
|
