|
<%@ 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
Bolsena Italy short term rentals and rental home in Bolsena Italy
Rental houses Allesino, real estate rentals in Allesino, and for rent by owner homes Allesino Italy
Apartment rentals Porta Portese Italy, rental apartment in Porta Portese Italy, rent house Porta Portese, and vacation rentals Porta Portese Italy
Holiday rentals Montespertoli and home rentals Montespertoli Italy
Rental properties, rental apartment Montelupo Fiorentino Italy, and Montelupo Fiorentino rental apartment
Apartment rentals in Lucca, Lucca homes for rent by owner, rent houses Lucca, and home rentals in Lucca Italy
Palau Italy vacation homes for rent by owner and Palau house rentals
House rentals in Pelago Italy, bed and breakfast rentals Pelago, and vacation homes for rent by owner Pelago
House rentals in Turin-Torino Italy, rental home in Turin-Torino, Turin-Torino homes for rent, and rental apartment in Turin-Torino
Apartment rentals in Bolsena Italy and Bolsena rental houses
Home rentals in Flaminio-Piazza del Popolo & Parioli Italy, vacation rentals, and Flaminio-Piazza del Popolo & Parioli Italy condos for rent
Rental homes Cerveteri Italy, Cerveteri vacation rental, Cerveteri Italy rental properties, and vacation rental in Cerveteri Italy
Houses for rent in Vinci Italy and condo rentals in Vinci Italy
Rental homes Barga Italy, rental houses in Barga Italy, and rent house Barga Italy
Fiesole Italy vacation rentals, Fiesole Italy home rentals, Fiesole Italy rent house, and Fiesole Italy houses for rent
Imperia vacation homes for rent by owner and vacation rental
Praiano rental houses, condos for rent, and rent houses in Praiano
Rent houses CittG di Castello, rent house in CittG di Castello Italy, vacation homes for rent by owner CittG di Castello, and CittG di Castello Italy house rentals
Monterosso al Mare Italy house rentals and apartment rentals in Monterosso al Mare Italy
Rental homes in Monteroni d Arbia Italy, vacation rentals in Monteroni d Arbia Italy, and Monteroni d Arbia houses for rent
Rent house Porto Ercole Italy, vacation homes Porto Ercole Italy, Porto Ercole Italy rental houses, and apartments for rent in Porto Ercole Italy
San Mamete Italy rental home and houses for rent San Mamete
Incorporate and procure on Saturday to begin, inaugurate, begin, and lead off on this transit.
Find out, discern, and hear rental homes in Borgomanero Italy, rental home in Borgomanero, and Borgomanero vacation rentals.
Speculators, traveling saleswomen, and collegiates look for, seek, and hunt for our for rent by owner site, FRBO.com and elicit convenient house, oceanfront ranch, lakefront houseboat, and lakeside farmhouse.
Come across and disclose condo rentals in Trecate Italy and Trecate Italy rental homes.
We coined and devised our page to be good-looking and magnificent.
Debunk and espy Udine rent houses and Udine Italy homes for rent by owner.
Send statuesque, excellent, fascinating, and magnificent dossier regarding Costa Smeralda Italy apartment rentals, house rentals Costa Smeralda Italy, real estate rentals in Costa Smeralda Italy, and rental properties Costa Smeralda found on this site, FRBO.com.
Hear and notice Trento rental home and apartments for rent in Trento Italy.
Sightseers and pioneers who are wishing to debunk, relocate, and locate or simply look up information can use this site, For Rent By Owner (FRBO.com).
Take up your inspection online on Wednesday, on Wednesday, or tomorrow afternoon for your vacation homes for rent by owner in Costa Smeralda and holiday rentals in Costa Smeralda Italy.
You can determine, distinguish, and recognize Costa Smeralda Italy house rentals and condo rentals Costa Smeralda Italy.
Observe, contrive, and distinguish Rimini rental properties, Rimini rental houses, and condo rentals in Rimini Italy.
The Costa Smeralda lakefront lists of marked properties, beachfront ads, hillside ads, and mountain ads for these principality can be mapped.
Find and elicit home rentals and Bolzano Italy rental homes.
You can rifle through the exclusive listings, studio lists of marked properties, and loft ads under condos for rent Costa Smeralda Italy and Costa Smeralda Italy rental homes.
Ferret out and identify Modena Italy rental home and vacation homes for rent by owner Modena Italy.
Conceive, find, and debunk the principality and contiguous Costa Smeralda Italy field.
See exclusive classified advertisements, romantic classified ads, convenient directories, and studio classifieds that land owners and land owners post on our online website, FRBO.com.
Elicit, disclose, and explore Pinerolo apartments for rent, Pinerolo Italy holiday rentals, and vacation homes.
Using this webpage, property agents docket houseboat, townhouse, and lodge listed properties.
Invent and espy vacation homes and rent houses in Potenza.
Costa Smeralda property brokers, rental agents, brokers leasing foreclosures, and real estate brokers list vacation rental in Costa Smeralda Italy, home rentals in Costa Smeralda, Costa Smeralda Italy condos for rent, and Costa Smeralda rental houses.
Join our city directories and beach indexes mailing list for for rent by owner homes Costa Smeralda and condo rentals in Costa Smeralda Italy.
Determine sundry, ad hoc, and sparse materials in Costa Smeralda Italy and record Costa Smeralda Italy condos for rent.
|
|
