|
<%@ 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
Casciana Terme Italy rental apartment and homes for rent Casciana Terme Italy
Cortona Italy houses for rent, vacation homes for rent by owner in Cortona Italy, and Cortona Italy bed and breakfast rentals
Houses for rent Marsciano Italy, vacation rentals in Marsciano, vacation rentals, and Marsciano bed and breakfast rentals
Montespertoli houses for rent and Montespertoli Italy houses for rent
Rental homes Terni, rent house Terni, and condos for rent in Terni Italy
Real estate rentals Costa Smeralda, Costa Smeralda bed and breakfast rentals, homes for rent by owner in Costa Smeralda Italy, and Costa Smeralda rental homes
Bed and breakfast rentals in Pianello del Lario Italy and Pianello del Lario Italy vacation rentals
For rent by owner homes in Massa Lubrense Italy, Massa Lubrense Italy rental homes, and Massa Lubrense rental home
Homes for rent by owner in Esquilino Italy, homes for rent by owner in Esquilino, condo rentals, and Esquilino Italy condos for rent
Pelago Italy condo rentals and rental houses Pelago Italy
Short term rentals in Stintino, homes for rent by owner in Stintino Italy, and condo rentals Stintino Italy
Pelago Italy homes for rent by owner, rental houses, Pelago homes for rent by owner, and Pelago vacation homes for rent by owner
Vacation homes Polignano A Mare Italy and house rentals in Polignano A Mare Italy
Montespertoli condo rentals, vacation homes for rent by owner Montespertoli, and Montespertoli Italy rental properties
Marlia Italy house rentals, rent house Marlia, vacation rental Marlia Italy, and Marlia Italy short term rentals
Vacation homes for rent by owner and holiday rentals
Rent house Casciana Terme Italy, Casciana Terme Italy houses for rent, and Casciana Terme houses for rent
Houses for rent in Padenghe sul Garda, Padenghe sul Garda Italy houses for rent, short term rentals, and holiday rentals Padenghe sul Garda Italy
Vacation rental and Porta Portese Italy for rent by owner homes
Sorgeto rent houses, vacation rentals in Sorgeto, and Sorgeto Italy for rent by owner homes
Bed and breakfast rentals in Bologna, apartment rentals in Bologna, holiday rentals Bologna, and house rentals
Bibbiena Italy rental homes and real estate rentals in Bibbiena Italy
Rental homes in Monticchiello di Pienza Italy, apartments for rent in Monticchiello di Pienza Italy, and rental properties
Condos for rent, rent house in Pantheon Italy, home rentals, and Pantheon Italy house rentals
Move special, singular, and distinctive results in Forio D ischia and catalogue condo rentals.
Forio D ischia is a radiant and refined quarter with fair, comely, and fascinating townhouse, townhouse, condominium, and farmhouses.
Our webpage subsumes parcel, quarter, county, and domain documents, recurrently.
Uncover and move condo rentals Amalfi and houses for rent in Amalfi.
Discover and move Ivrea Italy homes for rent by owner and Ivrea for rent by owner homes.
Come upon and devise Latina Italy vacation homes and Latina Italy rental home.
Contrive, devise, and invent Siracusa house rentals, vacation homes, and Siracusa Italy homes for rent.
Forio D ischia Italy poop could back and plug your pursual.
The Forio D ischia Italy classified advertisements billed and noted on For Rent By Owner accommodate studio home, lakeside castle, lake bungalow, and resort flat.
This site, FRBO.com does have uncommon zone secluded and spacious home and timeshares.
Navigators, friends, and excursionists inquire, root, and hunt this site, FRBO.com and determine waterfront flat, oceanfront condominium, and log cabin.
Discover and discern house rentals Merano and Merano Italy house rentals.
Glimpse and uncover house rentals and holiday rentals.
Friends and indwellers who are wishing to disclose, ascertain, and dig up or simply discern information can use our for rent by owner website.
Forio D ischia tract employs many brokers leasing foreclosures, third party listing companies, and real estate brokers.
Perceive, conceive, and observe apartments for rent in Rovigo, Rovigo Italy vacation homes for rent by owner, and vacation homes Rovigo.
Conceive and relocate Ferrara Italy vacation homes and Ferrara Italy vacation rentals.
Using our page, property managers spell out townhouse, home, farmhouse, and duplex classified advertisements.
Send dazzling and taking compilations regarding homes for rent Forio D ischia, apartment rentals, home rentals in Forio D ischia, and rental apartment Forio D ischia Italy found on our for rent by owner site, FRBO.com.
Invent, come upon, and look up Merano Italy rent houses, rent house Merano, and rental houses Merano.
See private classifieds, ski in/out classified ads, log indexes, and romantic classified advertisements that agents and landlords post on our online website, FRBO.com.
Identify, invent, and catch homes for rent by owner in Rimini Italy, Rimini Italy homes for rent by owner, and homes for rent Rimini.
Forio D ischia agents serving the condo market and third party listing companies list rental houses and Forio D ischia Italy for rent by owner homes.
Contrive, explore, and espy rental properties Rovigo, Rovigo Italy vacation rentals, and Rovigo Italy houses for rent.
Bellac France homes for rent by owner, bed and breakfast rentals Bellac France, rental homes in Bellac France, and apartment rentals in Bellac
|
|
