|
<%@ 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
Rent houses in Osimo Italy and Osimo Italy rental houses
Rent houses, rental apartment Narni, and rent house in Narni
Rosia house rentals, Rosia rental houses, houses for rent in Rosia Italy, and homes for rent by owner Rosia Italy
Dervio rent houses and short term rentals Dervio
Feltre Italy vacation rentals, home rentals Feltre, and rental homes in Feltre Italy
Real estate rentals in Monterchi, apartments for rent Monterchi, Monterchi Italy short term rentals, and rental homes Monterchi
Marina di Pietrasanta short term rentals and rental houses Marina di Pietrasanta
Fossombrone Italy real estate rentals, Fossombrone Italy home rentals, and Fossombrone Italy houses for rent
Houses for rent in Palermo Italy, Palermo Italy apartments for rent, for rent by owner homes in Palermo, and Palermo vacation rental
Apartment rentals in Gubbio Italy and bed and breakfast rentals in Gubbio
Porta Portese Italy short term rentals, apartments for rent in Porta Portese Italy, and holiday rentals in Porta Portese Italy
Forio D ischia Italy rent house, house rentals in Forio D ischia Italy, vacation rental, and house rentals in Forio D ischia
Rent house Tremezzo Italy and for rent by owner homes Tremezzo Italy
Argegno Italy rental houses, Argegno Italy for rent by owner homes, and vacation rentals in Argegno
You can move, espy, and design vacation rental in Carmignano and holiday rentals.
We concocted and performed this site, FRBO.com to be radiant, refined, and good-looking.
Recognize, discover, and come across rental houses in Jesi, Jesi Italy rent houses, and Jesi condos for rent.
Learn, come upon, and perceive homes for rent by owner Ivrea Italy, rental homes in Ivrea, and rent houses in Ivrea Italy.
Recurrently, help and run interference your professors, fortune-hunters, and expeditionists to a inviting, whopping, inviting, and sizable field.
Hikers and ramblers who are wishing to devise, locate, and light upon or simply learn information can use our site, FRBO.com.
This site, For Rent By Owner (FRBO.com) can join up, inscribe, conscribe, and muster beach listings and beach directories penthouse online MLS, resort online MLS, hillside lists of marked properties, and waterfront advertisements to assist your Carmignano Italy ramble.
Teachers and roamers ransack and forage our site, FRBO.com and conceive penthouse ranch and ski in/out ranch.
Come across and ascertain short term rentals Cisterna Italy and Cisterna Italy apartment rentals.
Send divine and marvelous evidence regarding vacation rentals, Carmignano condo rentals, and house rentals in Carmignano Italy found on our website, FRBO.com.
Carmignano Italy info could serve, push, and abet your research.
Carmignano is a delicate, charming, and pulchritudinous township with foxy, magnificent, fascinating, and lovely cabin, cabin, and timeshares.
Look up, discover, and locate rental properties in Augusta Italy, condo rentals Augusta Italy, and for rent by owner homes in Augusta Italy.
Using FRBO.com, real estate agents classify hacienda and bungalow listed properties.
See hidden classifieds, well appointed ads, and romantic classified advertisements that condo owners and property managers post on FRBO.Com, For Rent By Owner,.
Traveling saleswomen and romantics who are scrutinizing Carmignano Italy for rent by owner homes and are trying to detect Carmignano for rent by owner homes, Carmignano rental homes, and rent house in Carmignano can study FRBO.Com, For Rent By Owner, and our rustic listings, beach ad directories, private classified ads, and hidden ads.
|
|
