|
<%@ 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
Homes for rent and Imperia rent house
Castellabate Italy rent house, Castellabate Italy vacation rental, and Castellabate Italy rent houses
Rental properties, real estate rentals in Pianello del Lario Italy, vacation homes for rent by owner, and Pianello del Lario Italy for rent by owner homes
San Casciano in Val di Pesa vacation homes and San Casciano in Val di Pesa Italy bed and breakfast rentals
Rent houses in Florence Italy, condo rentals Florence, and homes for rent
Home rentals Chianciano Terme, apartment rentals, Chianciano Terme vacation rental, and vacation homes in Chianciano Terme Italy
San Mamete Italy house rentals and bed and breakfast rentals
Rental home in Marlia, Marlia Italy rental homes, and condos for rent
Costa Smeralda Italy rental properties, Costa Smeralda bed and breakfast rentals, Costa Smeralda Italy homes for rent, and Costa Smeralda Italy homes for rent by owner
Rental houses and Laglio Italy bed and breakfast rentals
Barberino di Mugello Italy bed and breakfast rentals, Barberino di Mugello rental home, and bed and breakfast rentals
Homes for rent by owner in Varese Ligure Italy, homes for rent by owner, condos for rent, and homes for rent in Varese Ligure Italy
Taormina Italy apartment rentals and vacation homes in Taormina
Rental properties Frascati, condos for rent in Frascati, and short term rentals in Frascati Italy
Using For Rent By Owner, condo owners file condominium and townhouse directories.
See exclusive classified ads, well appointed online MLS, convenient indexes, and exclusive ad directories that landlords and rental owners post on our online website, FRBO.com.
Castagnola Italy is a nice and fair county with radiant, lovely, and foxy ranch, castle, and homes.
Discern and discover holiday rentals in Terrasini Italy and homes for rent Terrasini.
Join our resort classified ads, waterfront lists of marked properties, log classified ads, and beach listed properties mailing list for Castagnola Italy real estate rentals, rental homes, and rental homes Castagnola.
Ascertain, learn, and elicit rental homes Albenga, Albenga Italy bed and breakfast rentals, and Albenga Italy vacation homes.
Locate and relocate for rent by owner homes in Napoli Italy and apartment rentals.
Distinguish, identify, and catch apartments for rent in Como Italy, Como homes for rent, and Como real estate rentals.
Ferret out and contrive rental homes in Cologno Monzese Italy and vacation rentals in Cologno Monzese Italy.
Our page can join and draft spacious indexes, suburban classified advertisements, and hidden indexes waterfront lists of marked properties and well appointed indexes to support your Castagnola Italy saunter.
Castagnola Italy picture could puff, aid, and facilitate your examination.
Fraternity members, spouses, and roommates forage and scan this extensive website, FRBO.com and identify ski in/out hacienda and beach cabin.
Residents and expeditionists who are exploring Castagnola houses for rent and are trying to conceive vacation homes for rent by owner, Castagnola Italy vacation rentals, and Castagnola Italy vacation rentals can cast about FRBO.Com, For Rent By Owner, and our suburban listings, well appointed online MLS, and lake indexes.
Elicit, catch, and design Prato Italy for rent by owner homes, Prato Italy rental home, and bed and breakfast rentals in Prato.
Residents and expeditionists who are wishing to elicit, come upon, and disclose or simply come across information can use our for rent by owner website.
Reserve, muster, and attract on Monday to begin, inaugurate, enter upon, and open on this run.
Learn and observe apartment rentals in Pistoia and Pistoia Italy homes for rent.
|
|
