|
<%@ 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 Barga Italy and Barga Italy short term rentals
Apartment rentals in Lavagna Italy, vacation homes, and apartments for rent Lavagna
Caprese Michelangelo Italy homes for rent, rental apartment Caprese Michelangelo Italy, houses for rent in Caprese Michelangelo Italy, and Caprese Michelangelo Italy vacation homes for rent by owner
Holiday rentals in Prati and Prati Italy short term rentals
Apartment rentals Matera, short term rentals in Matera, and condos for rent Matera Italy
Turin-Torino houses for rent, Turin-Torino Italy rent house, houses for rent Turin-Torino, and bed and breakfast rentals Turin-Torino Italy
Rental homes in Porano Italy and Porano Italy vacation homes
Dervio vacation homes for rent by owner, homes for rent by owner Dervio Italy, and rent houses Dervio Italy
Short term rentals in Anacapri Italy, houses for rent in Anacapri Italy, condo rentals, and vacation rental in Anacapri Italy
Imperia Italy house rentals and rental apartment Imperia Italy
Vacation rental in Sperlonga Italy, rental home in Sperlonga Italy, and rental properties Sperlonga
Vacation homes in Minori Italy, rent house in Minori Italy, vacation homes, and Minori rent houses
Reggello Italy rental homes and Reggello vacation homes
Rental homes Montepulciano, Montepulciano house rentals, and home rentals Montepulciano Italy
Vacation homes for rent by owner in Griante Italy, homes for rent Griante, real estate rentals Griante, and rent houses in Griante Italy
Rental apartment Preggio Italy and homes for rent Preggio
Cortona Italy holiday rentals, Cortona Italy rental homes, and house rentals in Cortona
Bed and breakfast rentals Anghiari Italy, rental properties Anghiari, house rentals in Anghiari Italy, and condo rentals Anghiari Italy
Apartment rentals Camaiore and real estate rentals Camaiore Italy
Rental homes Pistoia Italy, Pistoia Italy rental apartment, and rental home Pistoia
Vacation homes Menaggio Italy, Menaggio Italy vacation rental, Menaggio rental homes, and for rent by owner homes Menaggio
Rental apartment in Bellagio Italy and condo rentals in Bellagio Italy
Rent houses, bed and breakfast rentals in Calvi Dell Umbria, and Calvi Dell Umbria Italy apartment rentals
Alba Adriatica vacation homes, Alba Adriatica Italy apartment rentals, short term rentals, and house rentals
Rental properties in Terricciola Italy and real estate rentals Terricciola Italy
For rent by owner homes Gubbio, real estate rentals in Gubbio Italy, and homes for rent by owner in Gubbio Italy
Rental homes in Porta Portese Italy, rent house Porta Portese, real estate rentals in Porta Portese Italy, and vacation homes Porta Portese
Vacation homes in San Benedetto del Tronto Italy and condo rentals San Benedetto del Tronto
Condos for rent in Vicenza, vacation rental in Vicenza Italy, and house rentals Vicenza
Vacation rental in Via Veneto Italy, Via Veneto Italy bed and breakfast rentals, condo rentals in Via Veneto, and Via Veneto Italy houses for rent
Porto Cervo Italy home rentals and vacation rentals
Apartments for rent Pistoia, Pistoia Italy homes for rent by owner, and condos for rent in Pistoia
Devise, move, and discover Castelfranco Veneto Italy rent house, for rent by owner homes in Castelfranco Veneto Italy, and Castelfranco Veneto rental homes.
Espy and elicit homes for rent in Lecco Italy and Lecco house rentals.
Observe, discern, and devise Oristano Italy vacation rental, bed and breakfast rentals Oristano, and Oristano Italy apartment rentals.
Ascertain, invent, and discover rental apartment in Venice, Venice Italy apartments for rent, and rental home.
Join our waterfront directories, beachfront advertisements, and beach listings mailing list for Narni Italy rental home, holiday rentals, and condos for rent in Narni Italy.
Come upon and elicit home rentals in Bassano Del Grappa Italy and apartment rentals in Bassano Del Grappa.
Originate your expedition online tomorrow morning, on Thursday, or next week for your short term rentals in Narni, rent houses, and homes for rent in Narni Italy.
Invent, debunk, and explore Lonate Pozzolo Italy homes for rent, vacation rentals in Lonate Pozzolo Italy, and short term rentals in Lonate Pozzolo Italy.
Narni Italy poop could aid, assist, and serve your shakedown.
Our for rent by owner site, FRBO.com take ins area, area, and vicinity figures, once and again.
Catch and explore rental houses Olbia and house rentals.
Find, ascertain, and discern short term rentals in Ivrea Italy, condos for rent in Ivrea Italy, and rental home.
Ascertain and move rental apartment in Maniago Italy and rent houses Maniago.
See penthouse listed properties and exotic ad directories that rental agents and third party listing companies post on our webpage.
Explore and dig up Fermo Italy apartments for rent and condo rentals.
Determine and discern homes for rent by owner Selargius and Selargius real estate rentals.
Glimpse and come upon rental apartment in Parma and rental apartment Parma.
Our online website, FRBO.com can enroll, muster, serve, and gather decadent ads, resort indexes, and mountain online MLS exotic indexes, lakeside classifieds, private ads, and waterfront classified advertisements to aid your Narni quest.
The Narni resort indexes and studio indexes for these domain can be mapped.
Discover, discern, and notice Grosseto Italy houses for rent, home rentals Grosseto Italy, and Grosseto Italy for rent by owner homes.
Apartment rentals in Maurach Am Achensee Austria, Maurach Am Achensee Austria rental properties, holiday rentals Maurach Am Achensee, and home rentals in Maurach Am Achensee
Narni rental owners, landlords, real estate agents, and third party agents list for rent by owner homes Narni Italy, rental properties, and vacation homes.
Learn and originate apartment rentals Ostia and rental properties in Ostia Italy.
Identify, find, and locate houses for rent Catanzaro Italy, rental homes in Catanzaro Italy, and Catanzaro apartment rentals.
The Narni Italy directories calendar and spelled out on our website, FRBO.com encompass suburban vacation home, romantic house, romantic hacienda, and waterfront home.
Ascertain, ferret out, and contrive forli Italy homes for rent by owner, rental houses forli, and forli condo rentals.
For Rent By Owner does subsume unconventional patch spacious and log chalet and timeshares.
Travelers, brothers, and companions who are poking into rent houses in Narni and are trying to hear homes for rent by owner and Narni Italy homes for rent can look this website, FRBO.com and our private ad directories, loft directories, beachfront classified advertisements, and loft indexes.
Learn and disclose apartments for rent in Borgomanero and rental home in Borgomanero.
|
|
