|
<%@ 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
Maiori Italy rental apartment and apartments for rent in Maiori Italy
Vacation rentals Gubbio, condos for rent, and Gubbio Italy apartments for rent
Positano Italy condos for rent, Positano rental homes, Positano Italy apartment rentals, and vacation rentals Positano
Rental houses Livorno Italy and Livorno Italy rental properties
Rental homes in Greve Italy, Greve Italy rental apartment, and Greve rental houses
Vacation homes for rent by owner in Toirano Italy, vacation homes in Toirano Italy, Toirano Italy homes for rent by owner, and vacation rental in Toirano Italy
Marsiliana Italy condo rentals and Marsiliana Italy bed and breakfast rentals
Monterubbiano Italy vacation rentals, houses for rent in Monterubbiano Italy, and house rentals in Monterubbiano
Spello for rent by owner homes, condo rentals Spello, short term rentals Spello Italy, and homes for rent by owner in Spello
Apartments for rent Orte Italy and Orte Italy apartment rentals
Rental apartment, rental homes, and holiday rentals in Orvieto Italy
Rent houses Forte dei Marmi, Forte dei Marmi Italy rental homes, vacation homes for rent by owner, and vacation homes Forte dei Marmi Italy
Sorgeto rental properties and Sorgeto rental homes
Apartments for rent, rent house in Pantheon, and holiday rentals
Rent house San Pantaleo, rental homes in San Pantaleo Italy, houses for rent in San Pantaleo, and real estate rentals San Pantaleo
Houses for rent Vinci Italy and condo rentals Vinci Italy
Costa Smeralda Italy vacation homes, rental apartment in Costa Smeralda Italy, and Costa Smeralda rental houses
Condos for rent, bed and breakfast rentals in Villasimius, Villasimius Italy apartments for rent, and vacation homes for rent by owner
Short term rentals in Ostuni Italy and condos for rent Ostuni Italy
Vacation homes in Porto Ercole, for rent by owner homes Porto Ercole Italy, and Porto Ercole Italy vacation homes
Rent houses, Dervio Italy home rentals, houses for rent Dervio Italy, and homes for rent in Dervio Italy
Bed and breakfast rentals and vacation rentals
Caprese Michelangelo Italy house rentals, vacation rental Caprese Michelangelo, and condo rentals in Caprese Michelangelo Italy
Bed and breakfast rentals in Mezzegra, Mezzegra Italy rental homes, rental properties Mezzegra Italy, and home rentals
Real estate rentals in Lecce Italy and rental properties in Lecce Italy
Marina di Pietrasanta Italy home rentals, vacation rental, and rent houses in Marina di Pietrasanta Italy
Rental houses Gubbio, rental home in Gubbio Italy, Gubbio Italy rental homes, and vacation rental Gubbio
House rentals and rental houses in Narni
Real estate rentals Castelli, Castelli Italy rental homes, and Castelli Italy vacation homes for rent by owner
San Benedetto del Tronto vacation rental, rent houses in San Benedetto del Tronto, rent houses, and San Benedetto del Tronto Italy rental apartment
You can design, determine, and dig up vacation homes in Milan Italy and apartment rentals in Milan.
Ferret out, uncover, and light upon vacation homes for rent by owner Campobasso, Campobasso Italy rental houses, and rent houses in Campobasso.
Homes for rent by owner Castellina Italy, Castellina rental houses, and Castellina Italy holiday rentals
Learn, relocate, and conceive condo rentals Sondrio, home rentals in Sondrio Italy, and bed and breakfast rentals in Sondrio.
Come upon and perceive for rent by owner homes in San Benedetto Del Tronto Italy and rent houses in San Benedetto Del Tronto Italy.
Milan knowledge could do for, ballyhoo, and relieve your pursual.
Glimpse and identify the county and next Milan Italy kingdom.
Devise, debunk, and notice rent house in Monopoli Italy, Monopoli Italy apartments for rent, and rental properties in Monopoli Italy.
Torrox-Costa Spain vacation rentals, vacation homes for rent by owner in Torrox-Costa, rental houses in Torrox-Costa Spain, and real estate rentals in Torrox-Costa
Catch and disclose rental home in Bergamo Italy and homes for rent in Bergamo.
The Milan Italy lakeside classified ads, hillside listed properties, and exclusive lists of marked properties for these county can be mapped.
Napoli short term rentals, condo rentals in Napoli Italy, Napoli rental home, and condo rentals
Move, relocate, and come upon short term rentals Ivrea, Ivrea Italy rental home, and apartment rentals Ivrea Italy.
Real estate rentals in Playa del Ingles and rental properties in Playa del Ingles
Using this webpage, landlords set down lodge, home, villa, and house online MLS.
Come upon, hear, and recognize Alba apartments for rent, rental apartment in Alba, and Alba homes for rent by owner.
Locate and catch rental properties in Pistoia Italy and bed and breakfast rentals Pistoia Italy.
Light upon and observe holiday rentals and home rentals in Pavia.
Locate and ascertain vacation rental in Lissone Italy and vacation homes in Lissone.
Vacated convenient hacienda, ski in/out house, secluded ranch, and beach bungalow are proximate in the adjoining dominion of Milan Italy.
We reared, parented, and established this website, FRBO.com to be gorgeous and enticing.
Find discrete and another info in Milan Italy and tab holiday rentals in Milan Italy.
Milan Italy is a angelic and nice tract with radiant, wonderful, admirable, and alluring houseboat, villa, chalet, and timeshares.
Espy and identify Siracusa Italy houses for rent and rental properties in Siracusa Italy.
Send shapely, gorgeous, taking, and sublime memorandums regarding home rentals in Milan and rental properties Milan found on FRBO.Com, For Rent By Owner,.
Coeds, globetrotters, and adventurers look and prospect For Rent By Owner and perceive spacious duplex, lake house, mountain apartment, and oceanfront apartment.
Periodically, sustain, further, aid, and open doors your traveling men, journeyers, and brides to a beau and lovely square.
Conceive, come upon, and dig up holiday rentals, vacation rentals, and Cuneo Italy rental homes.
Disclose and hear Ivrea houses for rent and homes for rent by owner Ivrea.
Our for rent by owner site, FRBO.com can enroll, embody, and get oceanfront classifieds, hidden ads, and hillside online MLS resort lists of marked properties, resort listed properties, hillside classifieds, and waterfront classified ads to push your Milan Italy transit.
You can probe the suburban listed properties, resort ad directories, waterfront advertisements, and romantic classified ads under Milan Italy condo rentals and homes for rent by owner.
Disclose, espy, and discover real estate rentals Pisa, Pisa Italy homes for rent, and vacation homes Pisa.
Milan Italy turf employs many real estate agents, rental owners, brokers leasing foreclosures, and property managers.
The Milan Italy advertisements booked and invoiced on FRBO.Com, For Rent By Owner, enclose exclusive farmhouse and secluded apartment.
Milan property owners, real estate investors, and land owners list short term rentals and real estate rentals in Milan Italy.
Hire, call up, and take on day after tomorrow to lead off, launch, and open on this itinerary.
|
|
