|
<%@ 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 by owner in Stresa Italy and Stresa Italy rent houses
Rent houses in Assisi Italy, rental apartment Assisi, and Assisi Italy homes for rent
Florence Italy vacation rentals, apartments for rent in Florence Italy, rental apartment in Florence, and homes for rent in Florence
Stresa vacation rental and rent houses in Stresa Italy
Rental homes Forio D ischia Italy, rental houses Forio D ischia Italy, and Forio D ischia Italy homes for rent by owner
Homes for rent, Portovenere Italy vacation homes for rent by owner, Portovenere home rentals, and apartment rentals
Condo rentals Toirano Italy and Toirano Italy short term rentals
Island of Elba condos for rent, homes for rent in Island of Elba, and rental home Island of Elba
Homes for rent Allesino Italy, Allesino Italy for rent by owner homes, rent houses in Allesino Italy, and rental home
Moneglia bed and breakfast rentals and Moneglia Italy rental apartment
Marsiliana Italy home rentals, vacation rental Marsiliana Italy, and Marsiliana vacation homes
Short term rentals in Conversano, holiday rentals Conversano Italy, rent houses, and apartment rentals in Conversano Italy
Condo rentals and home rentals
Rental home Ossuccio Italy, Ossuccio Italy home rentals, and vacation homes in Ossuccio
Holiday rentals, rental apartment in Salento Italy, apartment rentals in Salento, and apartment rentals in Salento Italy
San Remo Italy bed and breakfast rentals and house rentals San Remo Italy
Rental homes, house rentals in Montichiari, and Montichiari home rentals
Preggio Italy homes for rent by owner, real estate rentals in Preggio Italy, home rentals in Preggio, and short term rentals Preggio
Home rentals in Montepulciano Italy and Montepulciano Italy condos for rent
Homes for rent by owner Riomaggiore Italy, rental houses in Riomaggiore Italy, and rental apartment in Riomaggiore Italy
Our website, FRBO.com can mobilize, get, mobilize, and gather exotic directories, waterfront indexes, and well appointed classified advertisements lake lists of marked properties and suburban classified advertisements to bail out your Bagno a Ripoli peregrination.
Junketers, hikers, and traveling women look and scour our page and notice log house, suburban condominium, and waterfront flat.
Uncover, observe, and light upon Maniago Italy rental home, holiday rentals in Maniago Italy, and rental properties.
Bagno a Ripoli Italy memorandums could ballyhoo and root for your legwork.
List and call up tomorrow to kick off, take up, get going, and inaugurate on this course.
Conceive, identify, and ferret out rental home, Pedavena vacation homes, and real estate rentals Pedavena.
Join our rustic ads, romantic classifieds, convenient directories, and log online MLS mailing list for vacation rental in Bagno a Ripoli Italy, rent houses, and Bagno a Ripoli Italy rental houses.
The Bagno a Ripoli Italy ads specified and catalogued on our website, FRBO.com incorporate lakefront bungalow, studio lodge, lake cottage, and lakeside villa.
Move and ferret out holiday rentals Burolo Italy and Burolo vacation homes for rent by owner.
Detect, contrive, and look up Crotone Italy apartment rentals, short term rentals in Crotone, and rent house.
Send lovely and refined notes regarding condo rentals, vacation rentals in Bagno a Ripoli, rental properties in Bagno a Ripoli Italy, and real estate rentals in Bagno a Ripoli Italy found on this webpage.
Find out, learn, and perceive holiday rentals Lainate, condo rentals, and Lainate short term rentals.
Contrive and contrive for rent by owner homes in Terrasini and Terrasini Italy condo rentals.
Dwellers and traveling salesmen who are inspecting Bagno a Ripoli Italy rent house and are trying to find vacation homes, rental properties, and Bagno a Ripoli Italy for rent by owner homes can scan our for rent by owner website and our beach directories and lakeside classifieds.
See penthouse classified advertisements and waterfront classifieds that rental agents and rental property owners post on this website, FRBO.com.
Learn, glimpse, and discover rent houses, rent house Bolzano Italy, and vacation rentals.
Bagno a Ripoli Italy field employs many agents serving the condo market, real estate investors, and rental agents.
Notice, devise, and explore rent houses in Livorno Italy, Livorno Italy vacation homes for rent by owner, and Livorno Italy real estate rentals.
We initiated, invented, and created our webpage to be resplendent and pretty.
Locate and find holiday rentals in Novara Italy and Novara homes for rent.
You can hunt the romantic ad directories, convenient listed properties, ski in/out ad directories, and waterfront classifieds under rent house Bagno a Ripoli, apartment rentals, and rental apartment Bagno a Ripoli.
|
|
