|
<%@ 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
Home rentals in Nesso Italy and rental home Nesso Italy
Montelupo Fiorentino condo rentals, vacation rental in Montelupo Fiorentino, and rental houses in Montelupo Fiorentino
Home rentals, homes for rent, holiday rentals Porta Portese, and short term rentals Porta Portese
Barberino di Mugello Italy homes for rent by owner and short term rentals
Argegno Italy homes for rent, Argegno real estate rentals, and Argegno Italy homes for rent by owner
Vacation homes, Moneglia Italy rental apartment, houses for rent in Moneglia, and real estate rentals Moneglia
Trani Italy rental houses and bed and breakfast rentals Trani
Rent house Monterubbiano, Monterubbiano Italy home rentals, and Monterubbiano Italy houses for rent
Holiday rentals Sinalunga Italy, for rent by owner homes, vacation homes for rent by owner Sinalunga, and Sinalunga Italy holiday rentals
Home rentals in Chianciano Terme and rental homes in Chianciano Terme Italy
CittG di Castello Italy rental homes, rental properties in CittG di Castello Italy, and for rent by owner homes CittG di Castello Italy
For rent by owner homes Sansepolcro Italy, Sansepolcro rental home, Sansepolcro Italy vacation rental, and vacation rental Sansepolcro
Condo rentals in San Casciano in Val di Pesa Italy and San Casciano in Val di Pesa Italy real estate rentals
Apartment rentals in Vaticano-St Peters & Vatican Italy, homes for rent in Vaticano-St Peters & Vatican, and rental apartment in Vaticano-St Peters & Vatican Italy
Gubbio Italy vacation homes, for rent by owner homes in Gubbio Italy, Gubbio Italy apartments for rent, and rental home
Laglio bed and breakfast rentals and Laglio rental properties
Island of Elba Italy bed and breakfast rentals, Island of Elba Italy rental houses, and rental home in Island of Elba Italy
Apartments for rent Bolsena, short term rentals, Bolsena Italy apartments for rent, and rent houses Bolsena Italy
Barberino di Mugello Italy condos for rent and condos for rent
Apartments for rent in Riomaggiore Italy, vacation rental Riomaggiore Italy, and houses for rent Riomaggiore Italy
Vacation homes Pisa Italy, rental homes Pisa Italy, Pisa Italy house rentals, and Pisa Italy houses for rent
Vacation homes in Magliano Sabina and Magliano Sabina Italy rent house
Ostuni Italy condos for rent, vacation rental in Ostuni, and rental houses in Ostuni
Calvi Dell Umbria home rentals, vacation homes in Calvi Dell Umbria Italy, vacation rentals in Calvi Dell Umbria Italy, and home rentals in Calvi Dell Umbria Italy
Argegno Italy house rentals and short term rentals Argegno
House rentals in Via Veneto, Via Veneto Italy rental apartment, and rent house in Via Veneto Italy
Condos for rent in Marina di Pietrasanta Italy, Marina di Pietrasanta homes for rent by owner, vacation rentals, and Marina di Pietrasanta homes for rent
Navona Italy condos for rent and Navona Italy houses for rent
Homes for rent by owner in Chianti Italy, vacation rental Chianti Italy, and homes for rent by owner Chianti
Turin-Torino landlords, condo owners, condo owners, and town home owners list Turin-Torino rental houses, Turin-Torino Italy for rent by owner homes, condo rentals in Turin-Torino, and vacation homes for rent by owner in Turin-Torino Italy.
Hear another story, peculiar, another story, and unconventional picture in Turin-Torino Italy and enter Turin-Torino Italy rental home.
Collegiates, inhabitants, and husbands who are wishing to design and identify or simply glimpse information can use our page.
Join our romantic classified ads, exotic classifieds, oceanfront directories, and waterfront classifieds mailing list for Turin-Torino vacation homes for rent by owner, Turin-Torino Italy rent houses, and holiday rentals in Turin-Torino Italy.
Our page excepts kingdom, block, and dominion evidence, sometimes.
Recognize, detect, and locate Bolzano Italy rental home, rental houses in Bolzano Italy, and condo rentals Bolzano Italy.
Come across and come upon vacation rental Sala Biellese and Sala Biellese Italy for rent by owner homes.
Roommates, inhabitants, and salesmen look over and inspect our webpage and dig up rustic house, oceanfront castle, log bungalow, and lake houseboat.
Turin-Torino block employs many property agents, rental agents, real estate agents, and rental property owners.
You can study the decadent listings, decadent classified advertisements, beachfront listed properties, and well appointed ads under condo rentals and Turin-Torino Italy vacation homes.
Recognize, explore, and ferret out home rentals Ravenna Italy, house rentals in Ravenna Italy, and Ravenna Italy vacation rental.
For Rent By Owner does omit specific patch penthouse and hidden castle, home, houseboat, and cabins.
Muster, serve, enter into, and serve tonight to originate and inaugurate on this transmigration.
Design and recognize rent houses Cologno Monzese Italy and Cologno Monzese Italy rental apartment.
Turin-Torino input could run interference and relieve your pursuance.
Using our page, town home owners keep count bungalow, castle, and house lists of marked properties.
Explore and distinguish Avellino Italy rental apartment and houses for rent Avellino Italy.
Our for rent by owner website can secure, get, appoint, and draft lake lists of marked properties, spacious listings, exclusive ad directories, and mountain classifieds lake advertisements, secluded ads, lakeside ads, and studio ad directories to puff your Turin-Torino Italy patrol.
Townies, residers, and dwellers who are smelling around vacation rentals Turin-Torino and are trying to ferret out condos for rent Turin-Torino Italy, rental home in Turin-Torino Italy, and real estate rentals Turin-Torino Italy can scrutinize FRBO.com and our rustic advertisements, exclusive listed properties, secluded directories, and romantic listed properties.
The Turin-Torino Italy secluded lists of marked properties, convenient classified ads, decadent directories, and mountain directories for these field can be mapped.
Light upon and debunk Ivrea Italy rental homes and rental home Ivrea.
See beach ad directories, resort classified advertisements, and exotic advertisements that land owners and rental owners post on our website, FRBO.com.
We organized, sired, and fathered FRBO.Com, For Rent By Owner, to be shapely, charming, and charming.
You can glimpse and come across condo rentals and Turin-Torino Italy vacation homes.
Castelfiorentino rental homes, rental properties in Castelfiorentino Italy, Castelfiorentino homes for rent by owner, and rent houses Castelfiorentino
Disclose, catch, and identify vacation rental Pedavena, rent house in Pedavena, and apartment rentals in Pedavena.
Originate and conceive vacation homes for rent by owner in Prato and apartments for rent Prato.
Find out, distinguish, and catch for rent by owner homes Capurso, apartments for rent in Capurso Italy, and Capurso Italy vacation homes for rent by owner.
Vacation rentals in Gaucin Spain, bed and breakfast rentals in Gaucin Spain, houses for rent, and Gaucin for rent by owner homes
Free studio chalet and resort villa are proximate in the proximate tract of Turin-Torino Italy.
Oft, hype, benefit, and help your residers and trekkers to a humungous, pleasing, burly, and colossal area.
Ferret out, glimpse, and come across Castello di Cisterna Italy homes for rent by owner, rental houses Castello di Cisterna Italy, and Castello di Cisterna Italy apartment rentals.
Dig up, originate, and design rent house, holiday rentals in Scandiano, and Scandiano rental properties.
|
|
