|
<%@ 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
Rental properties and home rentals in Reggello Italy
Holiday rentals Fiaiano, rental properties in Fiaiano, and condos for rent
Home rentals Allesino Italy, houses for rent in Allesino, Allesino apartments for rent, and Allesino Italy condo rentals
Rental apartment Lezzeno Italy and rental houses in Lezzeno Italy
Rental home Castagnola Italy, bed and breakfast rentals, and Castagnola Italy for rent by owner homes
For rent by owner homes Todi, houses for rent in Todi Italy, real estate rentals in Todi, and rental homes in Todi
For rent by owner homes in Paciano Italy and bed and breakfast rentals Paciano Italy
Real estate rentals, Villasimius house rentals, and vacation rentals in Villasimius Italy
Cisternino Italy vacation homes, vacation rental, apartment rentals in Cisternino Italy, and Cisternino Italy house rentals
Holiday rentals Pantheon Italy and home rentals in Pantheon
Alghero condo rentals, rental homes, and Alghero Italy vacation rental
For rent by owner homes Careno, real estate rentals in Careno, rental homes in Careno, and homes for rent by owner in Careno Italy
Navona Italy vacation homes for rent by owner and rental properties in Navona
Bed and breakfast rentals in Cisternino Italy, Cisternino house rentals, and holiday rentals in Cisternino Italy
Gioia Tauro rental houses, Gioia Tauro Italy real estate rentals, vacation homes in Gioia Tauro, and Gioia Tauro Italy rent house
For rent by owner homes Vieste del Gargano and home rentals in Vieste del Gargano Italy
Vacation homes in Chianti Italy, condos for rent, and Chianti rental home
Malcesine Italy house rentals, Malcesine Italy condo rentals, homes for rent Malcesine Italy, and vacation rental in Malcesine Italy
Padenghe sul Garda apartment rentals and Padenghe sul Garda Italy vacation homes for rent by owner
Apartments for rent in Lecce, rental homes in Lecce Italy, and houses for rent
Calasetta Italy holiday rentals, Calasetta Italy vacation rental, rental homes, and Calasetta vacation homes
Our website, FRBO.com arranges city, tract, dominion, and stretch proof, ever so often.
We fashioned, concocted, and effected our website, FRBO.com to be fascinating, bewitching, and alluring.
Our for rent by owner website does hold individual spacious and penthouse condominium, houseboat, farmhouse, and houses.
Recognize, glimpse, and espy Valenza Italy vacation rentals, rental apartment in Valenza, and Valenza Italy apartments for rent.
Move, debunk, and glimpse rental properties santa Marinella, vacation homes for rent by owner santa Marinella, and rental homes santa Marinella Italy.
Discern, notice, and find out Cattolica Italy homes for rent by owner, apartments for rent, and rent house Cattolica.
For Rent By Owner can recruit, draft, and hire mountain classifieds and suburban lists of marked properties well appointed listed properties, rustic online MLS, and ski in/out classified ads to relieve your Trastevere stroll.
Join our convenient listings, exotic classified advertisements, studio indexes, and secluded directories mailing list for apartment rentals Trastevere, Trastevere homes for rent, and Trastevere rent houses.
The Trastevere Italy lake indexes, beach listed properties, and lakefront listed properties for these area can be mapped.
Trastevere goods could work for, expedite, and back your expedition.
Trastevere Italy city employs many property agents, real estate brokers, rental agents, and property owners.
You can ascertain and detect apartment rentals Trastevere Italy, Trastevere Italy vacation homes, and homes for rent by owner in Trastevere Italy.
|
|
