|
<%@ 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
Vacation rentals Como and rental properties Como
For rent by owner homes in Costa Smeralda Italy, Costa Smeralda bed and breakfast rentals, and short term rentals in Costa Smeralda
Apartments for rent in Villore Italy, rental apartment, rental apartment in Villore Italy, and rental apartment Villore
Short term rentals and home rentals Convalle Italy
Condo rentals San Siro-formerly Santa Maria Rezzonico Italy, homes for rent San Siro-formerly Santa Maria Rezzonico, and house rentals San Siro-formerly Santa Maria Rezzonico
Condo rentals Trastevere Italy, Trastevere Italy vacation homes, holiday rentals in Trastevere, and vacation rentals Trastevere
Apartment rentals in Castelli Italy and rental home Castelli
Narni Italy short term rentals, rental apartment in Narni Italy, and vacation homes for rent by owner in Narni Italy
Rent house, bed and breakfast rentals in Servigliano Italy, Servigliano Italy short term rentals, and Servigliano Italy bed and breakfast rentals
Rental apartment in Castelli Italy and rental properties in Castelli Italy
Flaminio-Piazza del Popolo & Parioli homes for rent, Flaminio-Piazza del Popolo & Parioli rental houses, and Flaminio-Piazza del Popolo & Parioli for rent by owner homes
Terni Italy homes for rent by owner, vacation rental in Terni Italy, homes for rent by owner in Terni, and rental properties in Terni
Rent houses in Sperlonga and Sperlonga Italy rental apartment
Porto Taverna Italy homes for rent by owner, homes for rent by owner in Porto Taverna, and vacation rentals
Vacation rentals in Montefalco, vacation rentals in Montefalco Italy, rent houses in Montefalco, and Montefalco rental properties
For rent by owner homes Fossombrone Italy and apartments for rent in Fossombrone Italy
Vacation homes, homes for rent Castiglione del Lago, and apartments for rent Castiglione del Lago Italy
Rosia rental home, home rentals Rosia Italy, rental properties in Rosia Italy, and Rosia house rentals
Real estate rentals in Barberino Val d Elsa and for rent by owner homes
Apartment rentals in Lesa Italy, apartments for rent Lesa Italy, and Lesa Italy real estate rentals
Pelago apartments for rent, Pelago Italy apartments for rent, condo rentals Pelago, and home rentals in Pelago Italy
Radda Italy homes for rent and Radda apartments for rent
Holiday rentals, Esquilino apartment rentals, and Esquilino Italy home rentals
Bolsena for rent by owner homes, Bolsena Italy vacation homes, Bolsena holiday rentals, and vacation rental in Bolsena Italy
Padenghe sul Garda Italy vacation homes and short term rentals in Padenghe sul Garda Italy
Rent house in San Quirico d Orcia, San Quirico d Orcia Italy rent houses, and apartments for rent San Quirico d Orcia
Sogna rental home, apartments for rent in Sogna Italy, apartment rentals in Sogna Italy, and bed and breakfast rentals Sogna Italy
Short term rentals Pistoia Italy and condo rentals in Pistoia
Conceive, find out, and debunk for rent by owner homes in Caltanissetta Italy, rental houses in Caltanissetta, and Caltanissetta Italy holiday rentals.
Peers, citizens, and navigators forage, search for , and ransack this website, FRBO.com and learn lakeside chalet, lakefront duplex, and resort vacation home.
Pianello del Lario figures could benefit and run interference your quest.
Move and determine Imperia vacation rental and Imperia vacation rental.
You can learn, identify, and relocate Pianello del Lario Italy homes for rent by owner and home rentals.
Home rentals in Evora Portugal, house rentals in Evora Portugal, vacation rentals, and home rentals
Rovers and acquaintances who are wishing to come across and hear or simply elicit information can use our website, FRBO.com.
Holiday rentals in Sogna Italy and rent houses Sogna
Pianello del Lario is a bewitching, pulchritudinous, angelic, and resplendent vicinity with marvelous, charming, wonderful, and divine condominium, cottage, house, and flats.
FRBO.com can conscribe, volunteer, embody, and obtain exotic classified advertisements, ski in/out ad directories, spacious listings, and resort advertisements beach ads, secluded classifieds, mountain online MLS, and log advertisements to aid your Pianello del Lario Italy traveling.
Apartments for rent, rental home Valbonne, vacation rentals in Valbonne France, and Valbonne vacation rental
Discover, distinguish, and find out short term rentals Civitavecchia Italy, homes for rent by owner in Civitavecchia Italy, and Civitavecchia Italy home rentals.
You can scour the exclusive directories and studio ad directories under bed and breakfast rentals Pianello del Lario Italy, Pianello del Lario Italy real estate rentals, and Pianello del Lario vacation rentals.
Design and catch the area and imminent Pianello del Lario quarter.
Devise and perceive homes for rent and Modena rent house.
Recognize, invent, and detect for rent by owner homes in Pordenone, Pordenone Italy vacation rentals, and Pordenone houses for rent.
Look up, glimpse, and discern vacation homes for rent by owner in Rapallo, Rapallo Italy vacation rental, and apartments for rent in Rapallo.
Light upon, come across, and devise holiday rentals Olgiate Olona Italy, rental home in Olgiate Olona, and rent houses in Olgiate Olona.
Recognize and contrive rental home and for rent by owner homes in Belmonte Mezzagno Italy.
Identify, notice, and find out homes for rent by owner, vacation rentals Alba, and Alba short term rentals.
Design, disclose, and debunk Voghera Italy short term rentals, real estate rentals, and short term rentals.
Pianello del Lario landlords, real estate brokers, and third party listing companies list condo rentals Pianello del Lario Italy, Pianello del Lario Italy condos for rent, homes for rent in Pianello del Lario Italy, and rental home in Pianello del Lario Italy.
The Pianello del Lario Italy online MLS entered and inventoried on our page incorporate mountain duplex, ski in/out villa, resort hacienda, and hillside house.
Periodically, further, support, and plug your students, displaced persons, and wanderers to a ample, adorable, and okay stretch.
Register, assign, mobilize, and induct tomorrow evening to inaugurate and kick off on this migration.
Dig up and come upon Merano Italy home rentals and for rent by owner homes in Merano Italy.
The Pianello del Lario lakeside directories, private ads, studio advertisements, and hidden directories for these block can be mapped.
See suburban lists of marked properties, penthouse advertisements, waterfront ads, and private ad directories that property owners and property owners post on our page.
|
|
