|
<%@ 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
Panicale Italy rent houses and apartments for rent in Panicale
Vacation homes in Montalto delle Marche, Montalto delle Marche Italy rent houses, and Montalto delle Marche Italy home rentals
Marsiliana Italy condo rentals, real estate rentals in Marsiliana Italy, homes for rent in Marsiliana Italy, and Marsiliana Italy home rentals
Short term rentals Perugia and Perugia Italy rental properties
Short term rentals Calasetta Italy, rental houses, and holiday rentals Calasetta Italy
House rentals Pescaglia Italy, rental apartment in Pescaglia Italy, short term rentals in Pescaglia Italy, and Pescaglia Italy rental apartment
Montepulciano condos for rent and homes for rent
Palau Italy rental apartment, condos for rent Palau Italy, and house rentals
Homes for rent by owner in San Siro-formerly Santa Maria Rezzonico Italy, rental properties in San Siro-formerly Santa Maria Rezzonico Italy, vacation homes San Siro-formerly Santa Maria Rezzonico, and San Siro-formerly Santa Maria Rezzonico rent houses
Vacation rentals in Gaiole and Gaiole Italy home rentals
Terricciola Italy rental houses, Terricciola bed and breakfast rentals, and Terricciola Italy holiday rentals
Houses for rent in Alghero, bed and breakfast rentals Alghero Italy, rent houses Alghero, and Alghero Italy short term rentals
Condos for rent and Casteldaccia Italy real estate rentals
Bucine homes for rent by owner, bed and breakfast rentals in Bucine, and Bucine Italy rental properties
Pelago Italy rental home, Pelago Italy short term rentals, condo rentals Pelago Italy, and house rentals in Pelago
Foligno Italy rental homes and rental homes Foligno Italy
Vacation homes, condo rentals, and homes for rent by owner
Flaminio-Piazza del Popolo & Parioli home rentals, rent houses Flaminio-Piazza del Popolo & Parioli Italy, home rentals in Flaminio-Piazza del Popolo & Parioli Italy, and Flaminio-Piazza del Popolo & Parioli Italy rental houses
Pariana Italy rent house and homes for rent in Pariana Italy
Light upon and conceive Selargius homes for rent by owner and rental homes in Selargius Italy.
Open your frisking online tomorrow morning or on Thursday for your real estate rentals in Pescaglia and Pescaglia Italy condo rentals.
Identify and design houses for rent in Foligno and apartment rentals in Foligno Italy.
Pescaglia domain employs many rental owners, town home owners, and home owners.
Using our for rent by owner website, real estate investors classify flat, townhouse, apartment, and ranch ads.
See lakeside listed properties, private lists of marked properties, beachfront listed properties, and resort listed properties that third party agents and town home owners post on this webpage.
Come upon, recognize, and come upon Bordighera Italy rental properties, rental home Bordighera, and Bordighera Italy short term rentals.
The Pescaglia Italy ad directories particularized and manifested on our site, FRBO.com arrange hillside duplex, beach condominium, hillside townhouse, and beach timeshare.
Recognize, espy, and glimpse house rentals in Modena Italy, Modena Italy homes for rent, and rental properties in Modena Italy.
The Pescaglia beachfront ad directories, rustic lists of marked properties, beachfront listed properties, and loft ads for these domain can be mapped.
Ferret out, elicit, and identify homes for rent in Caserta Italy, vacation rental, and homes for rent by owner in Caserta Italy.
We effected and planned FRBO.Com, For Rent By Owner, to be alluring and refined.
You can uncover, discern, and glimpse condos for rent in Pescaglia, homes for rent by owner, and Pescaglia condos for rent.
Invent, identify, and light upon the state and not far away Pescaglia Italy tract.
Come upon and debunk homes for rent by owner and rent houses Rovigo.
You can poke into the spacious classifieds, mountain listings, rustic online MLS, and well appointed classifieds under Pescaglia holiday rentals and Pescaglia vacation rental.
Traveling women and renters comb, chase after, and scrutinize FRBO.com and hear resort timeshare, ski in/out bungalow, and log apartment.
Pescaglia Italy experiments could stump, facilitate, and push your inspection.
|
|
