|
<%@ 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
Short term rentals in Fiumefreddo and houses for rent
Homes for rent by owner in Lastra A Signa Italy, Lastra A Signa Italy house rentals, and Lastra A Signa Italy apartment rentals
Allesino rent house, rental homes, vacation rentals Allesino, and Allesino rental apartment
Rental apartment in Rufina and rent houses in Rufina Italy
Florence Italy apartments for rent, vacation rental in Florence Italy, and Florence houses for rent
Conversano Italy apartment rentals, Conversano homes for rent, homes for rent by owner Conversano, and vacation homes for rent by owner in Conversano
Vacation rentals in Perugia Italy and for rent by owner homes
Homes for rent in Montelupo Fiorentino Italy, Montelupo Fiorentino Italy rental houses, and homes for rent by owner in Montelupo Fiorentino
Houses for rent in Fano Italy, for rent by owner homes in Fano Italy, Fano Italy condos for rent, and apartments for rent Fano
Certaldo Italy vacation rentals and Certaldo Italy apartments for rent
Amalfi rent house, Amalfi Italy condos for rent, and Amalfi Italy rent house
For rent by owner homes, condo rentals, vacation rentals in Maiori Italy, and homes for rent by owner in Maiori
Apartments for rent in Calvi Dell Umbria Italy and condos for rent in Calvi Dell Umbria Italy
Vacation rental in Aventino Testaccio, vacation rentals Aventino Testaccio, and Aventino Testaccio Italy rental home
Real estate rentals Massa Lubrense, vacation rental in Massa Lubrense, vacation rentals Massa Lubrense, and rental apartment in Massa Lubrense Italy
Rental properties Turin-Torino Italy and homes for rent in Turin-Torino
Lead off your shakedown online tomorrow morning, tomorrow evening, tomorrow evening, or this evening for your house rentals in Barberino di Mugello Italy, rental home Barberino di Mugello, and for rent by owner homes in Barberino di Mugello.
See romantic advertisements, waterfront lists of marked properties, and loft listed properties that rental property owners and property brokers post on this site, For Rent By Owner (FRBO.com).
This site, For Rent By Owner (FRBO.com) subsumes square and parcel figures, once and again.
Catch and catch holiday rentals and homes for rent by owner.
You can seek the loft indexes, exotic lists of marked properties, exclusive listed properties, and decadent online MLS under short term rentals and homes for rent by owner in Barberino di Mugello Italy.
You can find out, catch, and espy rental properties in Barberino di Mugello, vacation homes, and apartments for rent Barberino di Mugello.
This extensive website, FRBO.com does encompass sundry oceanfront, lakeside, exotic, and penthouse farmhouse, ranch, cabin, and chalets.
Barberino di Mugello compilations could abet and further your research.
The Barberino di Mugello Italy advertisements buttoned down and spelled out on our for rent by owner site, FRBO.com embrace hidden cottage, convenient condominium, decadent townhouse, and secluded ranch.
Originate and identify house rentals Maglie and houses for rent.
Notice, notice, and locate rental houses in Moncalieri Italy, rent houses in Moncalieri, and real estate rentals.
Our webpage can get, call up, and induct well appointed advertisements, lakeside online MLS, well appointed online MLS, and waterfront indexes spacious ad directories, spacious ad directories, oceanfront classifieds, and mountain listed properties to collaborate your Barberino di Mugello Italy stroll.
Ferret out, determine, and learn condo rentals, holiday rentals in Crotone, and rental homes in Crotone Italy.
Perceive and explore Malcesine vacation rentals and vacation rentals Malcesine Italy.
Devise, espy, and ascertain Cesena for rent by owner homes, vacation rental, and Cesena vacation homes for rent by owner.
Espy, glimpse, and hear rental homes in Udine Italy, vacation rentals in Udine, and Udine Italy homes for rent.
Vacant hidden chalet, hidden flat, secluded condominium, and loft apartment are convenient in the not far away stretch of Barberino di Mugello.
|
|
