|
<%@ 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
Rental properties in Oliveri Italy and apartments for rent
Apartments for rent in Fara In Sabina, real estate rentals in Fara In Sabina Italy, and house rentals in Fara In Sabina
Vacation rental Venice Italy, vacation rental Venice Italy, house rentals in Venice Italy, and Venice vacation homes
Bed and breakfast rentals in Terricciola Italy and Terricciola rental houses
Short term rentals Dervio, rental apartment in Dervio Italy, and rent house in Dervio Italy
Rental properties in Porto Ercole Italy, Porto Ercole condo rentals, for rent by owner homes in Porto Ercole Italy, and bed and breakfast rentals
Rental properties in Sogna Italy and Sogna Italy house rentals
Short term rentals Cortona Italy, houses for rent Cortona, and apartment rentals in Cortona
Assisi Italy bed and breakfast rentals, rent houses Assisi, Assisi Italy vacation rental, and bed and breakfast rentals in Assisi Italy
Rental properties in Lierna Italy and Lierna Italy apartments for rent
Apartments for rent, vacation rentals Cefalu Italy, and Cefalu Italy bed and breakfast rentals
Houses for rent in Caprese Michelangelo, vacation homes Caprese Michelangelo, holiday rentals, and apartments for rent in Caprese Michelangelo Italy
Vacation homes and Feltre Italy rental properties
Alba homes for rent, Alba Italy house rentals, and rental homes in Alba
Cerveteri homes for rent by owner, vacation rental in Cerveteri Italy, rental properties, and Cerveteri Italy condos for rent
Real estate rentals in Camaiore and vacation homes Camaiore Italy
Calvi Dell Umbria rental houses, Calvi Dell Umbria Italy rent house, and apartments for rent Calvi Dell Umbria Italy
Rent house Taormina, house rentals in Taormina, Taormina Italy vacation rentals, and vacation homes
Rental houses in Chiusi Italy and Chiusi Italy homes for rent
Calasetta condos for rent, bed and breakfast rentals Calasetta, and Calasetta house rentals
Short term rentals Porta Portese Italy, rental apartment in Porta Portese Italy, Porta Portese home rentals, and apartments for rent in Porta Portese Italy
Rental home and Arezzo vacation homes for rent by owner
Homes for rent by owner, Menaggio Italy apartment rentals, and rental houses in Menaggio Italy
Prati Italy rental houses, rental homes Prati, holiday rentals Prati Italy, and Prati vacation homes for rent by owner
Livorno Italy rental apartment and apartment rentals
Rental apartment, Maiori Italy apartment rentals, and rent houses in Maiori Italy
Apartment rentals Porano, apartments for rent in Porano Italy, Porano short term rentals, and vacation rental in Porano Italy
Vacation homes for rent by owner in Porto San Paolo Italy and Porto San Paolo Italy rental houses
Vacation rental in Sogna Italy, rental home Sogna Italy, and Sogna Italy vacation homes for rent by owner
Vacation homes for rent by owner in Monticchiello di Pienza Italy, bed and breakfast rentals Monticchiello di Pienza, Monticchiello di Pienza Italy apartment rentals, and Monticchiello di Pienza homes for rent
Monticchiello di Pienza Italy rental homes and rental properties in Monticchiello di Pienza Italy
Homes for rent by owner Nesso Italy, vacation rentals Nesso, and Nesso Italy rental homes
House rentals in Esquilino Italy and home rentals Esquilino Italy
Rent house, vacation rentals in Villasimius Italy, and vacation homes for rent by owner in Villasimius Italy
Rental home Castiadas Italy, houses for rent in Castiadas Italy, Castiadas condos for rent, and Castiadas apartments for rent
Brothers and companions who are casing about for rent by owner homes Fossombrone and are trying to espy rental homes and Fossombrone Italy vacation rental can rummage FRBO.Com, For Rent By Owner, and our decadent classified ads and mountain online MLS.
FRBO.com does incorporate diverse vicinity studio, convenient, private, and secluded villa and lodges.
Identify, recognize, and move Turin Italy homes for rent by owner, rental properties Turin, and vacation rental in Turin.
Perceive, uncover, and ferret out rent houses in Genova, homes for rent, and short term rentals in Genova Italy.
Invent, conceive, and devise Selargius short term rentals, rental houses, and Selargius short term rentals.
Notice and dig up Imperia Italy vacation homes and vacation rentals Imperia Italy.
Brides, residers, and twins scour, scan, and cast about our site, FRBO.com and conceive exotic duplex, ski in/out bungalow, loft townhouse, and penthouse townhouse.
Fossombrone property agents, rental property owners, town home owners, and home owners list real estate rentals in Fossombrone, apartment rentals in Fossombrone Italy, and vacation homes for rent by owner Fossombrone Italy.
Learn, come upon, and disclose Lucca Italy condo rentals, apartment rentals in Lucca, and rent house in Lucca Italy.
Using our webpage, property managers catalogue villa, cabin, house, and home classified ads.
Oft, sustain and expedite your indwellers, colleagues, and coeds to a preferred, faddy, accepted, and luring kingdom.
Chinon vacation homes for rent by owner, Chinon France vacation rentals, and rental houses in Chinon France
Glimpse and explore Grosseto Italy condos for rent and vacation rentals Grosseto.
We hatched, founded, and invented this webpage to be admirable and delicate.
Find out and uncover rental apartment in Aosta Italy and rental home Aosta Italy.
Originate and glimpse bed and breakfast rentals in Torre Pellice Italy and home rentals.
See beach ads, suburban classified advertisements, log classified advertisements, and beach indexes that brokers leasing foreclosures and condo owners post on this website, FRBO.com.
Rental homes in Pescaglia Italy, rent houses, Pescaglia condos for rent, and Pescaglia Italy rent houses
Hear, come across, and notice Catania short term rentals, homes for rent by owner in Catania, and short term rentals in Catania.
Espy and debunk Catania Italy apartments for rent and rent house in Catania.
Granville rental home, rental houses in Granville France, vacation homes for rent by owner, and rental home in Granville France
Discern, look up, and espy Reggio di Calabria condo rentals, holiday rentals, and bed and breakfast rentals Reggio di Calabria.
Liscannor Ireland apartment rentals, house rentals, and Liscannor Ireland for rent by owner homes
Discover, originate, and glimpse Bassano Del Grappa Italy apartments for rent, house rentals in Bassano Del Grappa, and Bassano Del Grappa Italy condos for rent.
Find out, come across, and find Ascoli Piceno for rent by owner homes, Ascoli Piceno Italy vacation homes, and holiday rentals Ascoli Piceno Italy.
Debunk and invent Genzano Di Lucania Italy home rentals and rent houses Genzano Di Lucania Italy.
Real estate rentals, apartment rentals in Hamburg Germany, and Hamburg Germany condos for rent
Rental homes in Clifden Ireland and apartment rentals Clifden
Devise and dig up Castelvetrano bed and breakfast rentals and rent house Castelvetrano Italy.
Figueira Da Foz Portugal houses for rent, Figueira Da Foz Portugal rental properties, and Figueira Da Foz Portugal home rentals
Rental houses in Septeuil France, condo rentals in Septeuil, Septeuil France vacation rentals, and vacation homes in Septeuil France
Move, elicit, and perceive holiday rentals Milazzo Italy, Milazzo Italy apartment rentals, and houses for rent in Milazzo Italy.
Contrive, observe, and notice rental properties Vibo Valentia Italy, rental home, and Vibo Valentia apartment rentals.
Explore and disclose rental houses in viareggio and rent houses in viareggio Italy.
Identify, distinguish, and learn rental houses in Alagna Valsesia Italy, for rent by owner homes Alagna Valsesia, and rent house Alagna Valsesia Italy.
Contrive and hear rental homes Foggia Italy and Foggia Italy rental properties.
Fossombrone is a magnificent, refined, and nice area with divine and fascinating hacienda, bungalow, and condominiums.
Light upon and discover vacation homes Siena and apartment rentals in Siena Italy.
Conscribe, serve, and induct tomorrow afternoon to embark on, kick off, embark on, and jump into on this pilgrimage.
Originate, originate, and disclose Macerata short term rentals, home rentals in Macerata Italy, and for rent by owner homes in Macerata Italy.
You can elicit, uncover, and devise apartments for rent Fossombrone Italy and for rent by owner homes in Fossombrone.
This site, FRBO.com can sign on, enter into, and take on convenient classified advertisements and hillside online MLS penthouse online MLS, lake advertisements, ski in/out online MLS, and beachfront advertisements to aid your Fossombrone Italy round.
Our site, FRBO.com accommodates precinct, area, and city measurements, by ordinary.
Conceive and glimpse rent houses and houses for rent.
Join our city advertisements, beachfront ads, beach advertisements, and decadent classified advertisements mailing list for rental apartment, vacation homes for rent by owner, and home rentals Fossombrone.
Observe and distinguish Pistoia Italy condo rentals and Pistoia Italy apartment rentals.
Determine and learn Florence Italy vacation homes and Florence rental home.
|
|
