|
<%@ 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 apartment Monte Verde and short term rentals in Monte Verde Italy
Massino Visconti Italy condo rentals, bed and breakfast rentals, and bed and breakfast rentals in Massino Visconti Italy
Apartments for rent, rental home in Sansepolcro Italy, bed and breakfast rentals in Sansepolcro, and Sansepolcro Italy for rent by owner homes
Porto Ercole vacation rentals and for rent by owner homes
Apartment rentals Pontassieve Italy, rent houses, and houses for rent
Rent houses in Stresa Italy, Stresa Italy rental apartment, apartment rentals in Stresa Italy, and for rent by owner homes
House rentals in Spoleto Italy and Spoleto Italy rent houses
Lenno bed and breakfast rentals, rent houses in Lenno Italy, and short term rentals in Lenno Italy
House rentals, Navona vacation rental, apartments for rent, and rental home in Navona Italy
Apartment rentals in EUR Garbatella Italy and vacation homes for rent by owner EUR Garbatella
Rental houses in Bracciano Italy, apartment rentals, and Bracciano Italy rental houses
Rental properties in Frascati Italy, rent houses in Frascati Italy, vacation homes for rent by owner Frascati Italy, and short term rentals in Frascati Italy
For rent by owner homes in Capri and apartments for rent Capri Italy
Rental homes in Napoli Italy, Napoli Italy holiday rentals, and Napoli Italy vacation rental
Condo rentals Island of Elba, bed and breakfast rentals in Island of Elba Italy, Island of Elba Italy short term rentals, and vacation homes Island of Elba
Relocate and catch rent house in Lodi Italy and rental houses Lodi Italy.
Send good-looking, splendid, and sublime scoop regarding bed and breakfast rentals, holiday rentals Spello Italy, and homes for rent by owner in Spello Italy found on For Rent By Owner.
Join our city classified advertisements, oceanfront listed properties, city listed properties, and secluded ad directories mailing list for rent house in Spello Italy and Spello Italy house rentals.
Spello documents could support, back, and work with your hunt.
Learn and notice homes for rent in Oleggio and Oleggio Italy apartment rentals.
Move and ferret out vacation homes in Cantu and rental apartment in Cantu.
This webpage arranges section, block, state, and township conclusions, not infrequently.
Employ, hire, hire, and initiate next week to open, originate, and get cracking on this visit.
Spello area employs many property managers, real estate agents, rental property owners, and brokers leasing foreclosures.
Come upon various, atypical, special, and sparse abstracts in Spello Italy and tab Spello vacation rentals.
Subordinates and roomers who are going through homes for rent by owner Spello and are trying to dig up rental houses Spello Italy, Spello Italy houses for rent, and rent houses in Spello can grub this site, For Rent By Owner (FRBO.com) and our spacious ad directories, decadent lists of marked properties, and loft directories.
Spello agents, rental agents, property owners, and third party listing companies list houses for rent in Spello Italy, Spello Italy condo rentals, Spello Italy vacation rental, and vacation rental.
See mountain online MLS, waterfront lists of marked properties, lakeside classifieds, and waterfront classifieds that property brokers and real estate investors post on For Rent By Owner.
Explore, observe, and dig up house rentals in Borgosesia Italy, Borgosesia Italy rent house, and home rentals.
Our page does encompass sparse city and decadent houseboat, chalet, and timeshares.
Our page can incorporate and muster rustic listed properties, convenient ad directories, and hidden lists of marked properties oceanfront classified advertisements, lake ads, and decadent ad directories to support your Spello Italy run.
Dig up, identify, and identify rent house, condos for rent Albenga Italy, and Albenga Italy home rentals.
|
|
