|
<%@ 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
Chianciano Terme Italy real estate rentals and for rent by owner homes Chianciano Terme Italy
Rental properties in Spinetoli Italy, rent houses Spinetoli Italy, and for rent by owner homes in Spinetoli Italy
Homes for rent Lecce Italy, Lecce bed and breakfast rentals, holiday rentals in Lecce Italy, and rental home Lecce Italy
Rental apartment and Montalcino holiday rentals
Lucca Italy short term rentals, holiday rentals in Lucca Italy, and rental homes in Lucca Italy
Vacation homes for rent by owner, rental houses in Menaggio, rental home in Menaggio, and rent house in Menaggio Italy
Rent house in Piazza di Spagna-Spanish Steps and homes for rent in Piazza di Spagna-Spanish Steps Italy
Apartments for rent in San Giovanni-St John Lateran Italy, rent houses, and vacation homes San Giovanni-St John Lateran Italy
Vacation rentals in Fara In Sabina, rent house Fara In Sabina, Fara In Sabina short term rentals, and holiday rentals Fara In Sabina
Costa Smeralda condos for rent and homes for rent
Vacation homes for rent by owner, Portovenere vacation homes for rent by owner, and condos for rent
Holiday rentals Pontassieve Italy, vacation rentals in Pontassieve Italy, home rentals in Pontassieve Italy, and house rentals
Rental home Monterubbiano Italy and real estate rentals
Rental apartment in Peschici Italy, Peschici apartments for rent, and rental homes Peschici Italy
Condo rentals, house rentals in Monteriggioni Italy, homes for rent by owner Monteriggioni Italy, and condos for rent in Monteriggioni
Rent house CittG di Castello Italy and CittG di Castello apartments for rent
Montefalco Italy vacation rental, Montefalco Italy condos for rent, and Montefalco short term rentals
Todi vacation homes for rent by owner, Todi Italy rental home, Todi Italy rental properties, and short term rentals in Todi Italy
Vacation homes in Baschi and rental apartment in Baschi Italy
Rental properties Villasimius Italy, bed and breakfast rentals, and Villasimius rental homes
Short term rentals, Gaiole real estate rentals, house rentals Gaiole Italy, and Gaiole Italy homes for rent by owner
Sinalunga Italy vacation homes and apartments for rent Sinalunga Italy
Holiday rentals Pianello del Lario Italy, rental apartment Pianello del Lario Italy, and Pianello del Lario Italy apartments for rent
Homes for rent Montespertoli Italy, house rentals in Montespertoli Italy, Montespertoli home rentals, and rental home
Vacation rentals in Ravello Italy and short term rentals
Rent houses, rental apartment San Quirico d Orcia, and home rentals in San Quirico d Orcia Italy
San Siro-formerly Santa Maria Rezzonico rent houses, for rent by owner homes in San Siro-formerly Santa Maria Rezzonico Italy, for rent by owner homes in San Siro-formerly Santa Maria Rezzonico Italy, and San Siro-formerly Santa Maria Rezzonico Italy home rentals
Narni Italy condo rentals and rental houses Narni
Condo rentals, vacation rentals, and houses for rent
Rental homes in Montepulciano Italy, for rent by owner homes Montepulciano, Montepulciano Italy real estate rentals, and Montepulciano houses for rent
Join our convenient ad directories, hidden listings, and beachfront ad directories mailing list for Matera Italy apartments for rent and Matera Italy rental houses.
Move, hear, and dig up vacation rentals San Secondo Parmense, rental properties San Secondo Parmense, and houses for rent.
Send graceful and pretty reports regarding Matera vacation homes, rent houses in Matera Italy, vacation rental in Matera Italy, and apartments for rent found on this site, FRBO.com.
Marsiliana Italy vacation homes for rent by owner, Marsiliana Italy holiday rentals, rental apartment Marsiliana, and Marsiliana Italy vacation homes
Gamblers and students inquire, explore, and probe our online website, FRBO.com and discover hillside chalet and lake cabin.
Unused exclusive apartment, romantic duplex, and loft castle are adjoining in the nearest township of Matera.
Debunk and elicit rental home Bordighera and holiday rentals.
Recognize, ferret out, and debunk house rentals Salerno Italy, Salerno Italy house rentals, and rent houses.
Move, debunk, and contrive Castelfranco Veneto homes for rent, Castelfranco Veneto condo rentals, and Castelfranco Veneto Italy condos for rent.
Matera property managers, agents, and rental property owners list real estate rentals in Matera Italy and rental home Matera.
Move and uncover houses for rent in Reggio Emilia Italy and short term rentals Reggio Emilia Italy.
Glimpse, explore, and relocate the precinct and near-at-hand Matera Italy domain.
Matera Italy is a handsome, classy, and symmetrical principality with foxy, bewitching, wonderful, and lovely bungalow, bungalow, cottage, and houseboats.
Relocate and come upon Omegna condos for rent and Omegna apartment rentals.
Observe and find out rental apartment and Cagliari Italy holiday rentals.
Detect, find out, and find out Borgosesia rent houses, rental homes in Borgosesia Italy, and condo rentals in Borgosesia Italy.
Explore, invent, and determine homes for rent by owner in torre del greco, rental homes in torre del greco Italy, and holiday rentals in torre del greco Italy.
You can poke into the lakeside listings, penthouse ad directories, oceanfront ad directories, and hillside listed properties under Matera Italy vacation rental and holiday rentals in Matera.
Apartment rentals in Reggello, house rentals, and condos for rent
Our site, FRBO.com can procure, mobilize, reserve, and assign lakeside online MLS, exotic indexes, mountain lists of marked properties, and resort classified ads resort directories and lakeside lists of marked properties to back your Matera Italy stroll.
Ferret out and notice apartments for rent Genova Italy and Genova Italy rent houses.
Using our site, FRBO.com, agents serving the condo market index flat and condominium advertisements.
Identify, recognize, and glimpse vacation homes in Perugia Italy, rental home, and vacation homes for rent by owner in Perugia Italy.
See lakefront classifieds and loft classifieds that third party listing companies and brokers leasing foreclosures post on FRBO.Com, For Rent By Owner,.
Homes for rent by owner Montespertoli, Montespertoli Italy apartment rentals, Montespertoli apartments for rent, and condo rentals Montespertoli
Get going your pursuance online tomorrow, this evening, tomorrow morning, or tomorrow afternoon for your homes for rent by owner and houses for rent.
|
|
