|
<%@ 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
Holiday rentals in Vieste del Gargano Italy and short term rentals Vieste del Gargano
Vacation rentals in Pietraviva, homes for rent by owner, and vacation homes
Home rentals in Castelfiorentino Italy, condo rentals in Castelfiorentino Italy, Castelfiorentino homes for rent by owner, and Castelfiorentino Italy rental homes
House rentals in Capo Vaticano and houses for rent Capo Vaticano Italy
Apartments for rent, Panarea rental home, and vacation homes for rent by owner in Panarea Italy
Rental properties, Salento Italy short term rentals, houses for rent Salento, and Salento Italy bed and breakfast rentals
House rentals and vacation homes for rent by owner in San Giovanni d Asso Italy
Villore rent house, rental properties Villore, and rental properties in Villore Italy
Vacation homes for rent by owner in Convalle Italy, holiday rentals, Convalle Italy real estate rentals, and condo rentals
Vacation homes for rent by owner and Peschici Italy short term rentals
Vacation rentals Careno, Careno Italy apartment rentals, and holiday rentals Careno
Paciano Italy rental homes, Paciano Italy vacation homes, real estate rentals Paciano, and rental apartment in Paciano Italy
Short term rentals and Lecce Italy rent house
Casperia Italy condo rentals, for rent by owner homes in Casperia Italy, and Casperia rent house
Rental homes in Aventino Testaccio, Aventino Testaccio Italy rental homes, Aventino Testaccio Italy for rent by owner homes, and rental houses Aventino Testaccio
Rental homes in Trevi Italy and apartment rentals in Trevi Italy
Barga Italy rental apartment, Barga Italy rental apartment, and homes for rent by owner Barga Italy
Send splendid, foxy, and sightly dossier regarding houses for rent in Marsiliana Italy, condo rentals Marsiliana, and bed and breakfast rentals Marsiliana found on this site, For Rent By Owner (FRBO.com).
Marsiliana condo owners, third party listing companies, property owners, and condo owners list Marsiliana Italy vacation homes for rent by owner and Marsiliana Italy home rentals.
Enter, gather, conscribe, and induct on Saturday to get going, get cracking, and kick off on this visit.
Marsiliana stretch employs many brokers leasing foreclosures and rental property owners.
Dig up and glimpse Capo d_Orlando Italy homes for rent and vacation rental in Capo d_Orlando Italy.
Uncover, look up, and perceive Lignano rental houses, rent houses, and rental properties.
We fathered and made our webpage to be gorgeous, elegant, dazzling, and stunning.
See decadent classifieds and hillside advertisements that home owners and property agents post on this extensive website, FRBO.com.
The Marsiliana Italy online MLS manifested and docketed on our for rent by owner site, FRBO.com embody beach vacation home and log hacienda.
Join our lakeside lists of marked properties, oceanfront lists of marked properties, penthouse classified advertisements, and beach online MLS mailing list for houses for rent Marsiliana, rent house in Marsiliana Italy, and Marsiliana Italy condo rentals.
Occupants, fellow workers, and wanderers who are wishing to elicit, ferret out, and originate or simply learn information can use FRBO.Com, For Rent By Owner,.
You can hunt for the loft classified ads, waterfront ad directories, and city listings under Marsiliana Italy apartment rentals and apartments for rent Marsiliana Italy.
Glimpse and invent Lecco Italy condos for rent and Lecco home rentals.
Catch and catch rent house and Bergamo Italy apartments for rent.
Look up, debunk, and discern Ferrara rental houses, apartment rentals Ferrara, and Ferrara Italy rent house.
Debunk, discover, and elicit Thiene Italy for rent by owner homes, rental home in Thiene Italy, and Thiene rental homes.
You can identify, look up, and elicit Marsiliana vacation homes, Marsiliana Italy homes for rent, and short term rentals.
Dig up, detect, and detect homes for rent by owner, rental properties Putignano, and rental apartment.
|
|
