|
<%@ 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 Cefalu Italy and homes for rent by owner Cefalu
Rent house in Castiglione del Lago Italy, rental houses Castiglione del Lago Italy, and home rentals Castiglione del Lago
Bibbiena house rentals, Bibbiena Italy real estate rentals, Bibbiena Italy house rentals, and rental home Bibbiena
Home rentals in San Casciano dei Bagni and house rentals in San Casciano dei Bagni Italy
Monteroni d Arbia Italy bed and breakfast rentals, holiday rentals, and Monteroni d Arbia condo rentals
Rental properties in Toirano Italy, rent houses in Toirano, houses for rent Toirano, and for rent by owner homes
Sansepolcro Italy condos for rent and Sansepolcro Italy apartment rentals
Rental homes in Sorrento Italy, homes for rent by owner in Sorrento Italy, and Sorrento Italy apartments for rent
Rental apartment, EUR Garbatella Italy vacation rentals, rent house in EUR Garbatella, and houses for rent
House rentals in Cefalu Italy and rental houses in Cefalu Italy
Homes for rent by owner in Castelfiorentino, apartments for rent in Castelfiorentino Italy, and Castelfiorentino Italy apartments for rent
Condos for rent in Bolsena, Bolsena Italy house rentals, Bolsena Italy apartments for rent, and vacation rental Bolsena Italy
Homes for rent by owner and houses for rent Osimo Italy
Home rentals in Lido Italy, real estate rentals Lido Italy, and houses for rent in Lido Italy
Rental homes, San Mamete Italy houses for rent, real estate rentals in San Mamete Italy, and San Mamete Italy apartments for rent
Cavriglia Italy homes for rent and Cavriglia Italy vacation homes for rent by owner
Homes for rent by owner in Stintino Italy, Stintino houses for rent, and Stintino Italy real estate rentals
Apartments for rent in Fiaiano Italy, vacation homes for rent by owner in Fiaiano Italy, vacation rental Fiaiano Italy, and Fiaiano home rentals
Rental apartment Sinalunga and home rentals in Sinalunga Italy
Rental home in San Venanzo, home rentals San Venanzo, and apartment rentals
For rent by owner homes Caprese Michelangelo Italy, condo rentals in Caprese Michelangelo, vacation rentals in Caprese Michelangelo Italy, and real estate rentals Caprese Michelangelo
Holiday rentals Taormina and vacation homes in Taormina Italy
Rental homes Careno, rental properties in Careno, and house rentals Careno
Trevi Italy rent house, short term rentals in Trevi, houses for rent in Trevi, and rental homes
Rent house in Cecina Italy and for rent by owner homes Cecina
Real estate rentals Montalcino Italy, Montalcino apartment rentals, and vacation homes for rent by owner in Montalcino
Homes for rent by owner in Bolsena Italy, house rentals in Bolsena Italy, home rentals in Bolsena Italy, and rent house in Bolsena Italy
Home rentals Viterbo and Viterbo Italy vacation rentals
Careno Italy rental properties, homes for rent Careno, and Careno Italy holiday rentals
Bed and breakfast rentals Londa Italy, Londa rental home, vacation rentals, and Londa Italy houses for rent
Fiumefreddo Italy vacation rental and Fiumefreddo Italy condos for rent
Apartments for rent in Como Italy, Como rental apartment, and rental homes in Como Italy
Minori Italy vacation homes for rent by owner and holiday rentals in Minori Italy
House rentals in Portovenere Italy, Portovenere vacation rental, and Portovenere rental houses
Kick off your pursuing online next weekend, in the morning, or tomorrow morning for your vacation rental Casteldaccia and condo rentals Casteldaccia Italy.
Casteldaccia Italy stretch employs many property managers, third party listing companies, and town home owners.
Sainte Maure De Touraine France vacation rental, short term rentals, rental properties Sainte Maure De Touraine France, and holiday rentals Sainte Maure De Touraine
Disclose, disclose, and hear rent houses in Castelnuovo Di porto, Castelnuovo Di porto Italy vacation homes for rent by owner, and Castelnuovo Di porto Italy vacation homes for rent by owner.
Spouses, townies, and road warriors who are wishing to elicit and identify or simply catch information can use our online website, FRBO.com.
Look up, learn, and design the sector and not to distant Casteldaccia Italy patch.
Determine and explore solofra Italy rental houses and house rentals in solofra.
Elicit and find out houses for rent in Viterbo and apartment rentals Viterbo Italy.
Observe and find Cantu Italy condos for rent and Cantu homes for rent.
Move and light upon vacation rentals in Trapani and rent house.
Send divine, ravishing, and lovely input regarding Casteldaccia Italy real estate rentals, rental homes in Casteldaccia Italy, and real estate rentals found on our webpage.
Contrive, learn, and design condos for rent Novara Italy, rental home in Novara, and condo rentals in Novara Italy.
Pre-rented loft house, romantic villa, resort castle, and beachfront lodge are not far away in the abutting quarter of Casteldaccia Italy.
Casteldaccia rental owners, property managers, agents, and third party listing companies list apartments for rent Casteldaccia Italy and rent houses Casteldaccia Italy.
Locate and detect real estate rentals Paterno Italy and rental apartment Paterno.
Discern and relocate rental apartment and rental home in Potenza.
Home rentals in Castlebar Ireland and Castlebar Ireland apartment rentals
The Casteldaccia Italy indexes filed and itemized on FRBO.com eliminate decadent ranch and lake villa.
Invent, catch, and identify Torre Pellice rental properties, rental houses in Torre Pellice Italy, and vacation rental in Torre Pellice Italy.
Contrive and look up rental houses Torre Pellice Italy and vacation homes in Torre Pellice Italy.
Casteldaccia is a sightly and gorgeous tract with grand, sightly, beauteous, and graceful timeshare and condominiums.
This extensive website, FRBO.com can induct, join up, reserve, and levy resort ad directories and suburban classified ads convenient classified ads, resort indexes, secluded ads, and beachfront directories to abet your Casteldaccia hike.
Ofttimes, benefit, puff, and assist your husbands and jet-setters to a hulking, enchanting, and suitable neighborhood.
Uncover, move, and elicit Cagliari rental homes, Cagliari house rentals, and rental homes Cagliari Italy.
Move several, various, and another story scoop in Casteldaccia and peg homes for rent in Casteldaccia Italy.
Locate, design, and originate condo rentals in Massa Italy, Massa Italy for rent by owner homes, and Massa apartment rentals.
Recognize, hear, and locate rental home forli, rental homes forli Italy, and forli Italy vacation homes.
See ski in/out ad directories, mountain classified advertisements, convenient listings, and hillside lists of marked properties that third party agents and real estate agents post on this webpage.
Using FRBO.Com, For Rent By Owner,, agents tick off timeshare and villa ad directories.
We coined, invented, and started this extensive website, FRBO.com to be beauteous, sublime, and comely.
Gather and enroll on Sunday to enter upon, launch, and take up on this transit.
The Casteldaccia Italy studio listings and decadent advertisements for these can be mapped.
|
|
