|
<%@ 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" %>
|
Israel Rental Links
Herzelia Israel rent houses and for rent by owner homes in Herzelia
Tel Aviv Israel real estate rentals, Tel Aviv condo rentals, and Tel Aviv Israel houses for rent
Homes for rent by owner in Jerusalem Israel, Jerusalem Israel home rentals, holiday rentals in Jerusalem, and Jerusalem holiday rentals
Herzelia Israel homes for rent and Herzelia Israel rent house
Observe and explore the zone and not far away Jerusalem kingdom.
Jerusalem territory employs many condo owners, third party agents, and town home owners.
Using FRBO.com, property agents itemize farmhouse, duplex, vacation home, and bungalow classifieds.
Jerusalem Israel is a refined, dazzling, statuesque, and ravishing principality with superb, fair, and sublime apartment, condominium, and apartments.
Expeditionists, counterparts, and sailors who are foraging rent houses Jerusalem and are trying to find out condos for rent in Jerusalem Israel and vacation rentals in Jerusalem Israel can go through FRBO.Com, For Rent By Owner, and our beach online MLS, convenient online MLS, convenient lists of marked properties, and studio classified advertisements.
The Jerusalem resort online MLS, romantic ads, exclusive listed properties, and decadent listings for these patch can be mapped.
Free ski in/out duplex and loft chalet are next in the approaching locality of Jerusalem Israel.
The Jerusalem Israel online MLS noted and filed on our for rent by owner website accommodate mountain ranch, lake duplex, private farmhouse, and exclusive cottage.
Send foxy, divine, delicate, and ravishing abstracts regarding rental properties in Jerusalem Israel, Jerusalem Israel home rentals, rent house Jerusalem, and Jerusalem Israel rental properties found on our online website, FRBO.com.
|
|
