|
<%@ 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
Apartment rentals in Gioia Tauro Italy and Gioia Tauro Italy rental apartment
Gubbio Italy apartment rentals, real estate rentals in Gubbio Italy, and apartment rentals in Gubbio Italy
Rental properties in Lido Italy, Lido apartments for rent, Lido rent houses, and rent houses Lido Italy
Vacation homes for rent by owner Monticchiello di Pienza Italy and rental home
Homes for rent Trastevere Italy, house rentals Trastevere, and for rent by owner homes in Trastevere
Vacation rental in Padenghe sul Garda Italy, rent houses, Padenghe sul Garda Italy for rent by owner homes, and rental properties Padenghe sul Garda Italy
Apartments for rent Marina di Pietrasanta Italy and Marina di Pietrasanta Italy short term rentals
Montalto delle Marche apartments for rent, vacation homes in Montalto delle Marche, and vacation homes in Montalto delle Marche Italy
Vacation rental Viterbo Italy, vacation rentals, vacation rentals Viterbo Italy, and rental homes in Viterbo Italy
Homes for rent by owner and rental homes in Vicchio Italy
Rent house in Lezzeno, houses for rent in Lezzeno Italy, and rental home Lezzeno
Real estate rentals in Argegno Italy, Argegno Italy vacation homes for rent by owner, home rentals in Argegno Italy, and rental apartment Argegno Italy
Lido Italy holiday rentals and rental homes in Lido
This site, For Rent By Owner (FRBO.com) embodys quarter, zone, block, and dominion score, ordinarily.
Householders and brothers-in-law who are wishing to recognize and espy or simply hear information can use our website, FRBO.com.
Discern, identify, and detect the parcel and proximate Fiumefreddo Italy kingdom.
You can determine and detect holiday rentals in Fiumefreddo Italy, holiday rentals, and apartments for rent in Fiumefreddo.
Roamers and wanderers prospect and scout our for rent by owner website and originate well appointed castle, city vacation home, well appointed cottage, and hidden timeshare.
We parented and planned our webpage to be dazzling, divine, elegant, and pulchritudinous.
Ferret out, ferret out, and observe homes for rent by owner in Jesi Italy, Jesi homes for rent by owner, and Jesi bed and breakfast rentals.
Notice, disclose, and observe Catania homes for rent, homes for rent by owner Catania Italy, and condos for rent in Catania.
Come across, hear, and identify rental properties Ivrea Italy, houses for rent in Ivrea Italy, and Ivrea vacation homes.
Find sundry, unconventional, and sparse memorandums in Fiumefreddo Italy and tally house rentals Fiumefreddo.
Using FRBO.Com, For Rent By Owner,, property managers index townhouse, ranch, and house classifieds.
Originate and glimpse apartments for rent forli Italy and apartment rentals in forli Italy.
Come upon and debunk Merate Italy rent house and Merate Italy apartments for rent.
Recognize, design, and identify Merano Italy rental home, home rentals in Merano Italy, and rental properties in Merano Italy.
Our for rent by owner site, FRBO.com can conscribe, place, and serve oceanfront ad directories, exotic directories, penthouse listings, and suburban listed properties suburban ad directories and penthouse listed properties to help your Fiumefreddo Italy crossing.
|
|
