|
<%@ 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
Forio D ischia Italy homes for rent and houses for rent in Forio D ischia Italy
Rent house, bed and breakfast rentals, and rental houses in Lenno
Vicenza Italy rental apartment, Vicenza Italy houses for rent, for rent by owner homes, and Vicenza Italy rental properties
San Gimignano holiday rentals and houses for rent in San Gimignano Italy
Apartment rentals in Venice Italy, bed and breakfast rentals Venice Italy, and rental properties Venice
Padenghe sul Garda Italy condos for rent, short term rentals Padenghe sul Garda, house rentals in Padenghe sul Garda, and Padenghe sul Garda condo rentals
Homes for rent Greve Italy and short term rentals
Holiday rentals Rapolano Terme, house rentals Rapolano Terme, and home rentals
Castellabate Italy rent house, rental apartment in Castellabate Italy, Castellabate rent house, and Castellabate Italy apartments for rent
Holiday rentals Chiusi and Chiusi Italy vacation rentals
Holiday rentals in Trastevere Italy, real estate rentals, and Trastevere house rentals
Padenghe sul Garda condos for rent, Padenghe sul Garda Italy home rentals, rent house Padenghe sul Garda Italy, and holiday rentals in Padenghe sul Garda Italy
Homes for rent in Piano Di Sorrento Italy and vacation rentals Piano Di Sorrento
Homes for rent by owner in Convalle, bed and breakfast rentals Convalle Italy, and vacation rental in Convalle
Chianciano Terme Italy homes for rent, Chianciano Terme condos for rent, rental properties in Chianciano Terme Italy, and vacation rental in Chianciano Terme
Citta della Pieve houses for rent and for rent by owner homes in Citta della Pieve Italy
Hear, identify, and light upon house rentals Lecce, apartment rentals Lecce, and house rentals in Lecce.
Observe and contrive rental home in Treviglio and rental homes Treviglio.
Espy and find the square and adjacent Trevignano Romano Italy locality.
Look up, detect, and relocate short term rentals Verona Italy, Verona apartment rentals, and short term rentals in Verona Italy.
Globetrotters, sorority sisters, and venturers frisk and poke into this webpage and uncover decadent ranch and mountain castle.
Our for rent by owner site, FRBO.com can sign on, list, and gather beachfront classifieds, well appointed indexes, and studio classifieds decadent ads and exotic lists of marked properties to cooperate your Trevignano Romano peregrination.
Using this site, FRBO.com, rental property owners classify hacienda, flat, and timeshare lists of marked properties.
Trevignano Romano agents serving the condo market, property managers, brokers leasing foreclosures, and property agents list vacation homes for rent by owner Trevignano Romano, home rentals in Trevignano Romano Italy, and for rent by owner homes in Trevignano Romano.
Relocate, distinguish, and come across rental apartment in Arese Italy, apartment rentals Arese Italy, and vacation homes for rent by owner.
Locate and distinguish Ostia Italy rental houses and Ostia vacation rentals.
You can inspect the ski in/out online MLS and lakeside listings under Trevignano Romano Italy for rent by owner homes, Trevignano Romano house rentals, and Trevignano Romano Italy vacation homes for rent by owner.
Sporadically, expedite, run interference, and support your collegiates and adventurers to a substantial and luring county.
|
|
