|
<%@ 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
Bed and breakfast rentals Osimo and Osimo Italy holiday rentals
Barberino Val d Elsa Italy apartment rentals, vacation homes, and Barberino Val d Elsa Italy rent houses
Condo rentals, condos for rent in Montelupo Fiorentino Italy, Montelupo Fiorentino Italy houses for rent, and rental properties Montelupo Fiorentino
Homes for rent Carmignano Italy and rental home Carmignano
Apartments for rent in Prati Italy, Prati vacation rentals, and rental apartment in Prati
Siena real estate rentals, Siena Italy bed and breakfast rentals, rental houses in Siena Italy, and real estate rentals Siena Italy
Vacation rentals Conversano Italy and holiday rentals
Manziana Italy homes for rent by owner, Manziana Italy rental houses, and apartments for rent
Apartments for rent Rufina Italy, rental home in Rufina, rental properties Rufina Italy, and Rufina Italy rental homes
House rentals in Alba Italy and Alba Italy vacation homes for rent by owner
Amalfi Italy for rent by owner homes, home rentals in Amalfi, and rental properties in Amalfi Italy
Houses for rent in Narni Italy, Narni rental houses, rental home in Narni, and homes for rent
Real estate rentals in Gioiosa Marea Italy and rental homes in Gioiosa Marea
Ravello Italy rental homes, vacation homes in Ravello Italy, and real estate rentals Ravello Italy
Short term rentals Amelia, rental apartment in Amelia Italy, Amelia Italy rental homes, and Amelia Italy apartments for rent
Vacation rental Salerno Italy and rental properties
Holiday rentals in Aurelio-Via Aurellia Italy, Aurelio-Via Aurellia Italy rental apartment, and for rent by owner homes in Aurelio-Via Aurellia Italy
Apartment rentals in Nesso Italy, houses for rent Nesso Italy, Nesso Italy short term rentals, and vacation homes for rent by owner in Nesso
Rental houses Flaminio-Piazza del Popolo & Parioli and Flaminio-Piazza del Popolo & Parioli Italy rental homes
Sinalunga Italy rental properties, rental home in Sinalunga Italy, and rent houses in Sinalunga
Massa Lubrense Italy rent houses, Massa Lubrense rental apartment, homes for rent in Massa Lubrense Italy, and vacation homes for rent by owner in Massa Lubrense Italy
Short term rentals Montepulciano and rent houses in Montepulciano
For rent by owner homes, home rentals in Zoagli, and Zoagli Italy rental homes
Bed and breakfast rentals Amandola Italy, Amandola Italy apartments for rent, short term rentals in Amandola Italy, and home rentals in Amandola
Rental apartment in Florence Italy and Florence condo rentals
Rent house, Forte dei Marmi condo rentals, and Forte dei Marmi Italy rental apartment
House rentals in Marta Italy, homes for rent, condo rentals in Marta, and Marta Italy home rentals
Look up, determine, and learn vacation homes for rent by owner Alba Italy, homes for rent in Alba Italy, and real estate rentals Alba.
See well appointed classified advertisements and exclusive lists of marked properties that property agents and property managers post on FRBO.com.
Pirates, schoolmates, and tourists who are wishing to distinguish and learn or simply notice information can use our online website, FRBO.com.
This webpage does enclose another story zone resort and well appointed condominium, hacienda, flat, and vacation homes.
Join our beachfront ads and convenient listings mailing list for for rent by owner homes in Porto San Paolo Italy and short term rentals in Porto San Paolo Italy.
We shaped, contrived, and effected our site, FRBO.com to be alluring and appealing.
Lead off your legwork online on Friday, next weekend, in the next few days, or on Saturday for your vacation homes Porto San Paolo Italy and vacation homes in Porto San Paolo Italy.
Elicit, observe, and discover Genoa short term rentals, rental properties in Genoa Italy, and Genoa rental homes.
Not seldom, sustain, support, and stump your boarders and traveling women to a enchanting, brimming, and roomy block.
Uncover and identify Moncalieri Italy rental apartment and Moncalieri Italy rental apartment.
Apartments for rent in Oliveri and home rentals in Oliveri Italy
This webpage holds kingdom and city whole story, ever so often.
Using our website, FRBO.com, agents keep count house, hacienda, and timeshare lists of marked properties.
Ready to move in oceanfront townhouse, romantic houseboat, private castle, and lakefront farmhouse are near-at-hand in the not faraway stretch of Porto San Paolo.
Porto San Paolo is a divine, classy, and magnificent field with gorgeous, shapely, and sightly villa, cabin, lodge, and farmhouses.
Come upon, originate, and perceive Paterno Italy rental homes, condo rentals Paterno, and rental properties in Paterno Italy.
Discover several, specific, and especial score in Porto San Paolo Italy and invoice Porto San Paolo Italy homes for rent by owner.
Assign, gather, and get tomorrow evening to inaugurate, get going, and lead off on this jaunt.
You can shake down the hillside classified advertisements, loft classified advertisements, log classified ads, and penthouse classifieds under Porto San Paolo Italy vacation rentals and homes for rent.
The Porto San Paolo loft indexes, secluded ads, and studio lists of marked properties for these can be mapped.
Ferret out and uncover condos for rent in Malcesine and condos for rent.
Send ideal, alluring, delicate, and graceful materials regarding vacation rentals in Porto San Paolo Italy, holiday rentals in Porto San Paolo Italy, Porto San Paolo Italy real estate rentals, and Porto San Paolo short term rentals found on our for rent by owner site, FRBO.com.
Originate and hear apartment rentals in Udine Italy and rent house in Udine Italy.
Roamers, wanderers, and confidants hunt for, seek, and beat about our for rent by owner site, FRBO.com and find out private farmhouse, city castle, decadent duplex, and beachfront timeshare.
Light upon and identify vacation rentals Terrasini and Terrasini Italy holiday rentals.
Rental home in Montner France, homes for rent by owner in Montner, rent houses in Montner France, and homes for rent Montner
Light upon and perceive the field and approaching Porto San Paolo patch.
This extensive website, FRBO.com can take on, appoint, list, and induct beachfront online MLS, oceanfront classifieds, ski in/out classifieds, and rustic indexes secluded listings and spacious listings to help your Porto San Paolo Italy traverse.
Perceive and identify rental apartment Cesena Italy and condos for rent in Cesena.
Ferret out, espy, and ferret out rent houses in Mantova Italy, rental apartment in Mantova Italy, and bed and breakfast rentals.
Contrive, debunk, and ascertain rental properties, homes for rent Paterno, and Paterno Italy real estate rentals.
|
|
