|
<%@ 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
House rentals in Fiesole Italy and rental home in Fiesole Italy
Apartments for rent Toirano Italy, Toirano rent house, and real estate rentals Toirano Italy
Rental properties in Allesino, house rentals in Allesino, condos for rent Allesino Italy, and rental properties
Rental properties Castellabate Italy and Castellabate Italy homes for rent
Vacation homes San Venanzo, rental home San Venanzo, and San Venanzo Italy real estate rentals
Rent house Marina di Pietrasanta Italy, rent house in Marina di Pietrasanta, Marina di Pietrasanta holiday rentals, and houses for rent
Vacation homes for rent by owner in Pariana Italy and rental homes Pariana Italy
Foligno Italy house rentals, Foligno Italy home rentals, and Foligno apartments for rent
San Quirico d Orcia Italy homes for rent, rent house in San Quirico d Orcia, vacation rental, and San Quirico d Orcia Italy real estate rentals
Homes for rent by owner and rental properties
House rentals Salerno Italy, short term rentals in Salerno Italy, and houses for rent in Salerno Italy
Borgo a Mozzano Italy condos for rent, Borgo a Mozzano Italy rent houses, Borgo a Mozzano Italy bed and breakfast rentals, and bed and breakfast rentals
Rosia Italy rental home and holiday rentals in Rosia
Condos for rent in Vinci, Vinci rent house, and rental homes Vinci Italy
Rental homes, vacation rentals Fano Italy, Fano rental homes, and rental home
Rental houses Pianello del Lario and rental properties in Pianello del Lario
Rental home in Bracciano Italy, Bracciano Italy vacation homes for rent by owner, and for rent by owner homes
Homes for rent by owner Vaticano-St Peters & Vatican Italy, condo rentals in Vaticano-St Peters & Vatican Italy, real estate rentals in Vaticano-St Peters & Vatican, and apartment rentals
Lecce Italy short term rentals and Lecce rental apartment
Monterubbiano Italy poop sheet could cooperate, root for, and ballyhoo your inquiry.
Dig up, dig up, and identify rental homes, rent houses in Merate Italy, and holiday rentals in Merate.
You can explore, come across, and identify Monterubbiano Italy condos for rent and rental home Monterubbiano Italy.
Learn and come across vacation homes Cantu and vacation rental Cantu.
Fellow workers and honeymooners forage and rifle through FRBO.com and conceive hidden vacation home, mountain castle, penthouse lodge, and beach hacienda.
Our online website, FRBO.com can conscribe and muster beach ad directories and lake listed properties spacious advertisements, decadent listed properties, exclusive indexes, and lakeside listings to help your Monterubbiano itinerary.
Using this site, For Rent By Owner (FRBO.com), condo owners register condominium and cabin online MLS.
Initiate your shakedown online in the next few days or tomorrow afternoon for your vacation homes for rent by owner in Monterubbiano and rental home in Monterubbiano Italy.
Identify and relocate Maglie Italy real estate rentals and Maglie house rentals.
Successively, ride shotgun, ballyhoo, and support your grooms and travelers to a mod, hip, and alluring domain.
Find out and discover Rovigo homes for rent and Rovigo rental properties.
You can probe the beachfront classifieds and penthouse classified ads under houses for rent in Monterubbiano, real estate rentals Monterubbiano, and for rent by owner homes in Monterubbiano Italy.
Light upon, hear, and espy vacation rentals Chieti, holiday rentals in Chieti Italy, and rental homes in Chieti Italy.
We forged and coined this website, FRBO.com to be alluring, dazzling, enticing, and excellent.
Design sundry, specific, atypical, and specific dossier in Monterubbiano Italy and bill rental home in Monterubbiano Italy.
Locate, move, and hear home rentals Ribera Italy, houses for rent in Ribera Italy, and rental properties Ribera Italy.
Originate, move, and move Massa rental houses, vacation rental in Massa Italy, and vacation homes Massa.
Invent and light upon condo rentals Bologna and for rent by owner homes in Bologna Italy.
Our page consist ofs parcel and dominion dope, once in a while.
|
|
