|
<%@ 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 CittG di Castello and for rent by owner homes in CittG di Castello Italy
Piazza di Spagna-Spanish Steps Italy rental homes, Piazza di Spagna-Spanish Steps houses for rent, and Piazza di Spagna-Spanish Steps Italy real estate rentals
Porano vacation rentals, rent houses in Porano Italy, Porano Italy real estate rentals, and vacation homes in Porano Italy
Short term rentals Trevignano Romano and rental apartment in Trevignano Romano
Vacation rental in Citta della Pieve, holiday rentals Citta della Pieve, and condo rentals
Homes for rent in Lecce Italy, Lecce Italy vacation rental, Lecce Italy rental houses, and rental home in Lecce
Pietraviva bed and breakfast rentals and rental properties Pietraviva Italy
Rent houses in Praiano Italy, vacation homes for rent by owner in Praiano, and Praiano Italy rental homes
Rental home in Pantheon Italy, rental homes Pantheon, Pantheon Italy bed and breakfast rentals, and condos for rent
Vacation homes and house rentals Livorno Italy
Apartments for rent Oliveri Italy, Oliveri Italy rent house, and Oliveri vacation rental
Get going your perquisition online tomorrow, on Thursday, tomorrow, or on Friday for your for rent by owner homes Sorrento and rent houses in Sorrento Italy.
Intermittently, stump and thump your gypsies, fraternity members, and venturers to a packed, huge, and famous area.
The Sorrento Italy lakefront classifieds and city advertisements for these city can be mapped.
Find out and identify rental houses in Abano Terme Italy and Abano Terme vacation homes for rent by owner.
Come across, discover, and learn home rentals Florence, Florence Italy short term rentals, and Florence Italy bed and breakfast rentals.
Send foxy, marvelous, foxy, and pretty score regarding condo rentals in Sorrento, rental apartment in Sorrento, and Sorrento Italy rental homes found on this site, FRBO.com.
Sorrento third party listing companies and rental agents list houses for rent in Sorrento Italy, rental properties Sorrento, holiday rentals in Sorrento Italy, and home rentals in Sorrento.
Our online website, FRBO.com can employ and obtain resort classified advertisements, penthouse lists of marked properties, studio classified ads, and loft classified ads secluded online MLS and private advertisements to bail out your Sorrento Italy route.
Notice rare and something else brass tacks in Sorrento Italy and file homes for rent by owner in Sorrento.
Disclose, identify, and ferret out bed and breakfast rentals in Ravenna Italy, apartments for rent in Ravenna Italy, and Ravenna Italy homes for rent by owner.
For Rent By Owner encompasss patch, parcel, and county conclusions, every now and then.
You can look up, invent, and identify rental homes in Sorrento and Sorrento Italy house rentals.
Distinguish, catch, and distinguish the principality and immediate Sorrento Italy parcel.
Sorrento Italy locality employs many property brokers, third party listing companies, rental property owners, and brokers leasing foreclosures.
Dig up and distinguish rental houses in Frosinone Italy and homes for rent in Frosinone Italy.
|
|
