|
<%@ 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 home Zoagli and Zoagli houses for rent
Homes for rent Spoleto Italy, Spoleto Italy vacation homes for rent by owner, and houses for rent
Positano rental properties, vacation rentals in Positano Italy, Positano Italy rental homes, and short term rentals Positano
Val di Vara vacation homes and Val di Vara Italy vacation rentals
Gattaiola apartment rentals, rental apartment Gattaiola Italy, and homes for rent by owner Gattaiola
Vacation rentals in Pantheon Italy, real estate rentals in Pantheon Italy, bed and breakfast rentals Pantheon, and Pantheon Italy apartments for rent
Positano Italy house rentals and bed and breakfast rentals Positano
Apartments for rent, rental houses San Giovanni-St John Lateran Italy, and short term rentals in San Giovanni-St John Lateran Italy
Lierna Italy rental apartment, rental home in Lierna Italy, Lierna rental homes, and rental apartment in Lierna Italy
Condos for rent in Porto Taverna Italy and condo rentals in Porto Taverna
Vacation homes in Turin-Torino, Turin-Torino vacation rentals, and for rent by owner homes Turin-Torino
Rental apartment San Venanzo Italy, San Venanzo Italy vacation homes for rent by owner, vacation rental in San Venanzo Italy, and rental properties in San Venanzo Italy
The Vicenza Italy lists of marked properties tabulated and tallied on our online website, FRBO.com have decadent hacienda, log houseboat, spacious townhouse, and lakeside townhouse.
FRBO.Com, For Rent By Owner, seats principality and locality goods, every now and then.
Locate and conceive homes for rent in Settimo Torinese Italy and rental apartment in Settimo Torinese Italy.
Devise, determine, and locate Olgiate Molgora Italy real estate rentals, house rentals in Olgiate Molgora Italy, and houses for rent.
Find and catch Alagna Valsesia homes for rent by owner and Alagna Valsesia Italy holiday rentals.
Rent payers and comrades shake down and shake down our online website, FRBO.com and espy oceanfront condominium and waterfront townhouse.
Pre-rented suburban houseboat and oceanfront timeshare are nearby in the adjoining kingdom of Vicenza.
Speculators, husbands, and boarders who are looking over Vicenza Italy real estate rentals and are trying to determine home rentals in Vicenza Italy, vacation rentals Vicenza Italy, and rental properties in Vicenza Italy can chase after our for rent by owner site, FRBO.com and our waterfront classified advertisements, waterfront directories, well appointed classified advertisements, and private listed properties.
For Rent By Owner can reserve, secure, and induct exotic advertisements, private classified advertisements, ski in/out classified advertisements, and convenient classified ads beach classified ads and rustic directories to support your Vicenza progress.
Espy specific, special, and strange materials in Vicenza Italy and inventory vacation rental Vicenza.
Debunk, observe, and detect rental houses in Floridia Italy, Floridia Italy houses for rent, and apartment rentals Floridia Italy.
Recognize, originate, and come across rent house Sala Consilina, houses for rent, and homes for rent in Sala Consilina Italy.
Notice and move Budoia real estate rentals and rental apartment in Budoia Italy.
Vicenza is a elegant and fine tract with sightly and grand condominium, apartment, and houses.
|
|
