|
<%@ 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
Alassio Italy condo rentals and apartments for rent in Alassio Italy
Rent house, home rentals Gioia Tauro, and vacation rental in Gioia Tauro
EUR Garbatella Italy rent house, vacation homes for rent by owner EUR Garbatella, EUR Garbatella Italy real estate rentals, and condo rentals EUR Garbatella Italy
San Giovanni d Asso Italy home rentals and homes for rent San Giovanni d Asso
Houses for rent in Sogna, vacation rentals, and apartment rentals in Sogna Italy
Reggello Italy condo rentals, rental apartment Reggello, Reggello Italy rental home, and rental properties Reggello
Montepulciano condos for rent and home rentals
Homes for rent by owner in Bolsena, houses for rent, and rent houses Bolsena Italy
Vacation rentals in Menaggio, vacation homes in Menaggio Italy, vacation homes for rent by owner in Menaggio Italy, and rental homes in Menaggio Italy
House rentals and homes for rent by owner
Apartment rentals in Feltre Italy, vacation homes in Feltre Italy, and vacation rental Feltre
For rent by owner homes Turin-Torino Italy, Turin-Torino bed and breakfast rentals, Turin-Torino houses for rent, and Turin-Torino rental houses
Rent house in Cetona and rental houses Cetona
Capo Vaticano Italy homes for rent by owner, rental homes Capo Vaticano Italy, and real estate rentals Capo Vaticano
Houses for rent Vinci Italy, vacation rentals in Vinci, Vinci Italy condo rentals, and vacation rental in Vinci
Real estate rentals in Forte dei Marmi Italy and Forte dei Marmi Italy apartment rentals
Vacation homes Casciana Terme, Casciana Terme Italy homes for rent, and rent houses in Casciana Terme Italy
Porto Cervo rent house, home rentals in Porto Cervo Italy, home rentals, and Porto Cervo real estate rentals
Vacation rental in Palermo and rent house Palermo Italy
Rental home in Lenno Italy, Lenno rent houses, and vacation rentals Lenno Italy
Condos for rent, bed and breakfast rentals, bed and breakfast rentals in San Remo Italy, and condo rentals in San Remo Italy
For rent by owner homes in Palau and vacation homes for rent by owner Palau
Rental apartment in Pognana Lario, short term rentals Pognana Lario Italy, and rental houses
Marsciano Italy vacation homes, rental apartment Marsciano Italy, Marsciano Italy condos for rent, and houses for rent in Marsciano Italy
EUR Garbatella Italy vacation rentals and rental houses in EUR Garbatella
San Pantaleo Italy homes for rent by owner, San Pantaleo apartment rentals, and San Pantaleo Italy homes for rent
Houses for rent in Pantheon Italy, rental houses, vacation homes for rent by owner Pantheon, and Pantheon Italy rental home
Feltre condos for rent and rental houses in Feltre Italy
Rental properties in Reggello Italy, rental home in Reggello Italy, and real estate rentals in Reggello Italy
Join our secluded advertisements and convenient classified advertisements mailing list for apartment rentals Baschi Italy and apartments for rent.
Uncover and hear vacation rental and rental homes in viareggio Italy.
Ascertain, relocate, and come across bed and breakfast rentals Capo d_Orlando Italy, rental apartment in Capo d_Orlando Italy, and homes for rent by owner in Capo d_Orlando.
Originate and contrive bed and breakfast rentals Mirano Italy and short term rentals in Mirano.
Baschi Italy notes could boost, work for, ballyhoo, and thump your quest.
You can shake down the spacious classifieds, hillside classifieds, romantic classified advertisements, and spacious directories under condo rentals Baschi and rent house Baschi.
Conceive and determine vacation rental and rent houses.
Move and identify vacation homes Perugia Italy and Perugia rental properties.
Light upon, discover, and recognize for rent by owner homes, home rentals in Fermo, and home rentals in Fermo Italy.
Apartment rentals Galilea, vacation rentals Galilea Spain, houses for rent Galilea Spain, and houses for rent Galilea Spain
Glimpse and elicit real estate rentals in L Aquila Italy and L Aquila rental apartment.
See log advertisements, hidden online MLS, beach classified advertisements, and secluded online MLS that agents and property brokers post on our site, FRBO.com.
Ascertain and come upon rental properties Sondrio Italy and bed and breakfast rentals in Sondrio Italy.
Bellac France house rentals, rental home, Bellac vacation rentals, and home rentals in Bellac France
Identify, originate, and notice Valtournenche Italy condos for rent, bed and breakfast rentals in Valtournenche Italy, and rental home in Valtournenche.
Identify, light upon, and identify short term rentals, rent houses in Putignano Italy, and Putignano Italy condo rentals.
Originate and elicit rental properties in Spoleto Italy and rental home in Spoleto Italy.
Available ski in/out vacation home and secluded townhouse are imminent in the not to distant quarter of Baschi Italy.
Our for rent by owner site, FRBO.com take ins quarter, vicinity, block, and principality knowledge, not seldom.
Disclose and find condos for rent and Bari rent houses.
House rentals, rent house Paciano Italy, and homes for rent by owner
Using this site, For Rent By Owner (FRBO.com), rental owners classify vacation home, ranch, and bungalow advertisements.
Successively, abet and root for your transmigrants, traveling salesmen, and citizens to a hip, beautiful, packed, and likable section.
Baschi Italy is a delicate and excellent neighborhood with pretty, cute, good-looking, and alluring lodge, bungalow, cottage, and haciendas.
|
|
