|
<%@ 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
Apartments for rent and real estate rentals Alba Adriatica Italy
Borgo a Mozzano Italy condos for rent, rental home in Borgo a Mozzano, and home rentals in Borgo a Mozzano
Amelia Italy rent houses, vacation homes in Amelia, Amelia vacation homes for rent by owner, and Amelia Italy apartment rentals
Real estate rentals Amandola Italy and houses for rent in Amandola Italy
Home rentals Convalle, short term rentals in Convalle, and Convalle condos for rent
Condo rentals in Lido Italy, vacation rental in Lido Italy, vacation homes for rent by owner in Lido, and Lido Italy house rentals
Allesino Italy vacation rentals and home rentals Allesino Italy
Casteldaccia homes for rent, rental homes in Casteldaccia Italy, and Casteldaccia Italy real estate rentals
Rental home Bolsena, home rentals in Bolsena, rental home in Bolsena Italy, and for rent by owner homes in Bolsena
Rent houses in Lecce and house rentals Lecce Italy
Houses for rent Montemiccioli, Montemiccioli Italy vacation rental, and houses for rent Montemiccioli
Island of Elba Italy short term rentals, vacation homes, Island of Elba home rentals, and house rentals Island of Elba Italy
Homes for rent by owner in Trevignano Romano Italy and house rentals in Trevignano Romano Italy
Vieste del Gargano home rentals, rental homes in Vieste del Gargano Italy, and apartment rentals in Vieste del Gargano Italy
Houses for rent in Barga, rental apartment Barga Italy, vacation homes, and Barga Italy apartment rentals
Griante Italy houses for rent and condo rentals in Griante Italy
Vacation homes for rent by owner, apartment rentals in Lido, and Lido Italy condos for rent
Cerveteri vacation homes for rent by owner, vacation rental in Cerveteri Italy, Cerveteri Italy apartments for rent, and vacation homes in Cerveteri Italy
Vacation rental Capo Vaticano Italy and short term rentals in Capo Vaticano Italy
Rent houses, rent house Amalfi, and rental homes in Amalfi Italy
Come upon and discern condos for rent Ravenna Italy and home rentals Ravenna.
Light upon, learn, and ferret out homes for rent by owner in Cecina Italy, rent house in Cecina Italy, and real estate rentals in Cecina Italy.
Invent and catch holiday rentals Alpignano Italy and real estate rentals.
Begin your expedition online on Thursday, tomorrow morning, in the morning, or tomorrow morning for your vacation homes for rent by owner Avellino, Avellino bed and breakfast rentals, and house rentals in Avellino.
Avellino principality employs many property brokers, landlords, brokers leasing foreclosures, and rental agents.
Elicit, elicit, and observe real estate rentals Pinerolo, vacation homes, and rental home Pinerolo.
For Rent By Owner can conscribe, recruit, obtain, and induct city classifieds, beach directories, spacious classified advertisements, and secluded ads city ads, convenient indexes, and suburban ads to bail out your Avellino Italy patrol.
See exclusive classified advertisements, resort directories, beach advertisements, and lake lists of marked properties that agents serving the condo market and landlords post on this webpage.
The Avellino Italy ads registered and enrolled on this extensive website, FRBO.com arrange suburban home and decadent chalet.
Our online website, FRBO.com embraces county and square details, once in a while.
Our page does comprise sundry domain exotic, hidden, and oceanfront ranch, flat, and condominiums.
Join our convenient directories and log lists of marked properties mailing list for Avellino apartment rentals and apartments for rent in Avellino Italy.
Discern, elicit, and relocate home rentals in Sala Biellese, rent house Sala Biellese Italy, and Sala Biellese vacation homes.
Disclose, perceive, and come across bed and breakfast rentals in Napoli Italy, real estate rentals Napoli, and vacation rental Napoli.
Catch and relocate short term rentals in Alghero Italy and condos for rent Alghero Italy.
Peers, honeymooners, and deadheads who are wishing to light upon and recognize or simply find information can use this extensive website, FRBO.com.
Learn and elicit Cattolica Italy houses for rent and houses for rent Cattolica.
The Avellino Italy lakefront ad directories and loft online MLS for these turf can be mapped.
|
|
