|
<%@ 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 houses Pianello del Lario Italy and Pianello del Lario rental homes
Anacapri rental houses, vacation rental Anacapri, and rental apartment Anacapri Italy
Homes for rent in Piazza di Spagna-Spanish Steps, homes for rent in Piazza di Spagna-Spanish Steps, home rentals in Piazza di Spagna-Spanish Steps Italy, and rent houses in Piazza di Spagna-Spanish Steps
Barberino di Mugello rent house and holiday rentals in Barberino di Mugello Italy
Real estate rentals Fano, Fano Italy rent houses, and homes for rent Fano Italy
Paciano Italy rental homes, Paciano Italy homes for rent by owner, vacation homes Paciano Italy, and condo rentals Paciano
Rental apartment in Bari and holiday rentals in Bari
House rentals in Moneglia, homes for rent by owner in Moneglia Italy, and condo rentals in Moneglia
Alba Adriatica Italy rental properties, rental apartment in Alba Adriatica Italy, rent house Alba Adriatica, and bed and breakfast rentals Alba Adriatica
Rental houses in Trastevere and vacation homes for rent by owner in Trastevere Italy
Short term rentals Vaticano-St Peters & Vatican, bed and breakfast rentals in Vaticano-St Peters & Vatican Italy, and rental properties
Apartments for rent in Matera, real estate rentals in Matera Italy, condos for rent Matera Italy, and rent houses Matera Italy
Narni house rentals and real estate rentals
Condos for rent, Massa Lubrense Italy bed and breakfast rentals, and Massa Lubrense Italy real estate rentals
Pognana Lario condo rentals, bed and breakfast rentals Pognana Lario Italy, vacation homes for rent by owner in Pognana Lario, and house rentals Pognana Lario
Rental homes in Pietraviva and holiday rentals in Pietraviva
Rental homes in Colosseo Foro Romano-Coliseum & Roman Forum Italy, rental properties in Colosseo Foro Romano-Coliseum & Roman Forum Italy, and Colosseo Foro Romano-Coliseum & Roman Forum Italy apartment rentals
Holiday rentals in Oliveri Italy, rental homes, rental homes, and rental apartment Oliveri Italy
Rezzonico vacation homes for rent by owner and vacation rental Rezzonico
Rental properties Padenghe sul Garda Italy, homes for rent by owner in Padenghe sul Garda Italy, and rent houses Padenghe sul Garda Italy
Holiday rentals Via Veneto, Via Veneto rental houses, Via Veneto Italy bed and breakfast rentals, and Via Veneto Italy home rentals
Apartments for rent in Argegno Italy and house rentals Argegno
Real estate rentals in Vicchio Italy, Vicchio Italy rent houses, and apartment rentals in Vicchio Italy
Anacapri holiday rentals, Anacapri rent houses, Anacapri vacation homes for rent by owner, and Anacapri Italy bed and breakfast rentals
Rental apartment in Fiaiano Italy and Fiaiano vacation rental
Apartment rentals in Porto Santo Stefano Italy, rental homes, and rental homes Porto Santo Stefano
For rent by owner homes Bologna, apartment rentals, Bologna Italy condos for rent, and Bologna Italy real estate rentals
Gattaiola Italy condo rentals and Gattaiola homes for rent
Vacation rental Cefalu Italy, Cefalu rent houses, and Cefalu Italy vacation rentals
Sorgeto Italy rental houses, Sorgeto Italy vacation homes, vacation homes in Sorgeto Italy, and rent house in Sorgeto Italy
Island of Elba Italy rent house and houses for rent in Island of Elba Italy
Cremia Italy homes for rent, rental homes in Cremia Italy, and vacation homes for rent by owner Cremia Italy
Apartments for rent in Fondi and condo rentals Fondi Italy
Look up and identify Cecina condo rentals and vacation rentals in Cecina.
Salernes France real estate rentals, vacation rental Salernes France, and short term rentals Salernes
Homes for rent Lamballe, vacation homes for rent by owner in Lamballe, Lamballe France home rentals, and homes for rent by owner Lamballe
Design and disclose rental homes and bed and breakfast rentals in Asti Italy.
Locate and learn holiday rentals in Alba and Alba rent house.
Holiday rentals in Hyeres, rental homes in Hyeres, homes for rent, and Hyeres rental apartment
Bed and breakfast rentals in Ventry Ireland, rental houses Ventry, and house rentals in Ventry Ireland
Come upon, notice, and design Lissone houses for rent, Lissone Italy apartments for rent, and condos for rent in Lissone.
Contrive, relocate, and ascertain house rentals Olgiate Olona, Olgiate Olona rental homes, and houses for rent.
Houses for rent Anghiari Italy and holiday rentals Anghiari
Townies and seafarers beat about and look over this webpage and invent oceanfront flat, rustic cabin, beach bungalow, and penthouse chalet.
FRBO.com does consist of something else exotic, city, and resort chalet, townhouse, house, and lodges.
Come upon, disclose, and ferret out rental home, Lamezia Terme Italy rental houses, and rental apartment.
Enter into and employ tomorrow morning to get cracking, begin, embark on, and lead off on this transmigration.
Using FRBO.Com, For Rent By Owner,, real estate investors invoice hacienda, home, castle, and ranch ad directories.
Move and catch for rent by owner homes and Maglie Italy for rent by owner homes.
We organized, performed, and organized this extensive website, FRBO.com to be delicate, refined, and fair.
Ferret out and light upon Merano Italy bed and breakfast rentals and condos for rent in Merano.
Jump into your research online this weekend or tomorrow afternoon for your vacation rental in Cremia, Cremia Italy vacation homes for rent by owner, and Cremia Italy vacation rentals.
The Cremia Italy ad directories inserted and placed on FRBO.Com, For Rent By Owner, comprehend city duplex, loft lodge, mountain chalet, and rustic flat.
Design and look up Lodi Italy for rent by owner homes and vacation homes in Lodi Italy.
Light upon, discover, and learn rental home in Frosolone, Frosolone condos for rent, and Frosolone Italy house rentals.
Ready to move in rustic castle and log castle are not to distant in the next neighborhood of Cremia Italy.
Contrive and originate rental properties and rental apartment in Novara Italy.
Conceive, find, and dig up rental homes in La Maddalena Italy, house rentals in La Maddalena Italy, and La Maddalena Italy vacation rental.
Learn sparse, strange, rare, and some materials in Cremia and run down rental home Cremia.
Light upon and catch Pescara condo rentals and house rentals Pescara.
Condo rentals in Monterubbiano and bed and breakfast rentals Monterubbiano
Find and look up home rentals Bottegone and rent houses.
Ascertain, discover, and contrive Sassari Italy houses for rent, rent houses in Sassari, and houses for rent Sassari.
Move and hear rent house in Pinerolo Italy and for rent by owner homes.
Cremia scoop could hype, ballyhoo, and root for your inspection.
Observe and contrive Cisterna homes for rent by owner and Cisterna Italy bed and breakfast rentals.
Originate, come across, and relocate for rent by owner homes in Piove di Sacco Italy, Piove di Sacco Italy condo rentals, and apartments for rent.
Move and contrive vacation homes for rent by owner in Varallo Sesia Italy and apartment rentals in Varallo Sesia Italy.
Glimpse, determine, and contrive Cologno Monzese Italy rental apartment, holiday rentals in Cologno Monzese Italy, and house rentals.
Hear, determine, and devise Guidonia Italy condos for rent, apartments for rent in Guidonia Italy, and rental apartment Guidonia.
You can shake down the suburban lists of marked properties, hidden classified advertisements, suburban directories, and private classifieds under homes for rent in Cremia Italy and Cremia Italy rent house.
|
|
