|
<%@ 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
Short term rentals in Turin-Torino and rental apartment in Turin-Torino
Vacation homes in Palau Italy, bed and breakfast rentals in Palau, and Palau Italy apartment rentals
Bed and breakfast rentals in Pietraviva Italy, homes for rent in Pietraviva, rental houses Pietraviva, and Pietraviva Italy vacation rental
Apartment rentals in Cefalu and vacation rental Cefalu
Rental homes in Bibbiena Italy, apartments for rent Bibbiena Italy, and rent house Bibbiena Italy
Vacation rentals in Pisa, rental homes, Pisa Italy condos for rent, and Pisa Italy rent house
Anacapri Italy homes for rent by owner and short term rentals Anacapri Italy
Condo rentals in Venice Italy, Venice Italy rental homes, and condos for rent
Riomaggiore apartments for rent, holiday rentals in Riomaggiore Italy, apartments for rent, and Riomaggiore Italy vacation rentals
Rental houses Orte Italy and Orte Italy home rentals
Vacation homes Praiano Italy, vacation homes for rent by owner in Praiano, and homes for rent in Praiano
Orte Italy vacation rentals, house rentals in Orte Italy, apartments for rent in Orte, and for rent by owner homes in Orte
Vaticano-St Peters & Vatican Italy houses for rent and vacation homes Vaticano-St Peters & Vatican
Rent houses in Monte Verde Italy, rental homes in Monte Verde Italy, and apartments for rent in Monte Verde
House rentals in Casciana Terme Italy, rent houses, rent house in Casciana Terme Italy, and Casciana Terme vacation rental
Begin your examination online on Friday, tomorrow afternoon, or next week for your Porto Taverna Italy holiday rentals and Porto Taverna Italy holiday rentals.
Porto Taverna turf employs many third party listing companies, town home owners, real estate brokers, and home owners.
You can look the lake classifieds and convenient listings under Porto Taverna Italy apartment rentals and apartments for rent Porto Taverna.
Light upon, locate, and observe condo rentals, Torre Pellice Italy rental homes, and houses for rent Torre Pellice Italy.
Come across and explore rent houses in Pedavena Italy and holiday rentals in Pedavena Italy.
This extensive website, FRBO.com can take on, serve, volunteer, and obtain spacious directories and lakefront directories rustic indexes, ski in/out ad directories, waterfront advertisements, and suburban classifieds to expedite your Porto Taverna Italy traverse.
Our website, FRBO.com embraces patch and parcel goods, customarily.
Move and come across vacation homes Cardano al Campo Italy and vacation rental Cardano al Campo Italy.
Porto Taverna poop could benefit, ballyhoo, thump, and help your pursual.
See rustic listed properties and exclusive listings that land owners and property managers post on this site, FRBO.com.
We built, instituted, and erected this site, For Rent By Owner (FRBO.com) to be refined and beauteous.
This extensive website, FRBO.com does take in something else sector resort, well appointed, studio, and well appointed condominium, castle, farmhouse, and apartments.
Determine and relocate rental houses Mantova Italy and Mantova rental properties.
Debunk, observe, and devise home rentals in Genzano Di Lucania Italy, Genzano Di Lucania Italy real estate rentals, and apartments for rent in Genzano Di Lucania.
|
|
