|
<%@ 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
Vacation rental in Cefalu Italy and homes for rent by owner Cefalu
Rental apartment Casperia, vacation homes Casperia Italy, and vacation rental Casperia
Certaldo Italy home rentals, rental houses in Certaldo Italy, houses for rent, and Certaldo Italy real estate rentals
Vacation rental in Marsciano Italy and home rentals
Rental properties, rent house Monte Verde, and for rent by owner homes in Monte Verde
Vacation rentals in San Terenziano Italy, house rentals in San Terenziano Italy, houses for rent San Terenziano Italy, and real estate rentals in San Terenziano Italy
San Casciano dei Bagni condo rentals and condos for rent
Homes for rent by owner in Umbertide, Umbertide vacation rental, and home rentals Umbertide
Calasetta Italy houses for rent, condo rentals Calasetta Italy, condos for rent in Calasetta, and holiday rentals in Calasetta Italy
Houses for rent and house rentals
Bed and breakfast rentals Gattaiola Italy, real estate rentals Gattaiola Italy, and Gattaiola condo rentals
Taormina Italy short term rentals, vacation rental in Taormina Italy, real estate rentals in Taormina, and real estate rentals in Taormina Italy
Rent house Montefalco Italy and Montefalco rent house
Rent houses in Varenna Italy, Varenna bed and breakfast rentals, and Varenna Italy rental homes
Real estate rentals in Montefalco Italy, vacation homes for rent by owner, Montefalco Italy condos for rent, and rental homes Montefalco Italy
Rent houses Aventino Testaccio and real estate rentals Aventino Testaccio Italy
Condo rentals in San Casciano dei Bagni Italy, San Casciano dei Bagni Italy real estate rentals, and holiday rentals in San Casciano dei Bagni Italy
Rent house in Livorno, real estate rentals Livorno Italy, homes for rent by owner, and house rentals in Livorno Italy
For rent by owner homes and bed and breakfast rentals Polignano A Mare
Apartment rentals in Amandola Italy, short term rentals, and vacation homes
Rental homes, holiday rentals Navona, condos for rent in Navona Italy, and rental properties in Navona Italy
Marsiliana Italy holiday rentals and house rentals Marsiliana Italy
Vacation rentals in Stintino Italy, bed and breakfast rentals in Stintino Italy, and apartment rentals in Stintino
Praiano Italy home rentals, for rent by owner homes in Praiano Italy, vacation rental Praiano Italy, and Praiano rental homes
Short term rentals in Camaiore Italy and house rentals in Camaiore
Castelfiorentino rental houses, houses for rent in Castelfiorentino, and apartment rentals in Castelfiorentino Italy
Vacation homes for rent by owner in Como, houses for rent Como, condos for rent in Como, and vacation rentals Como Italy
Rental apartment in Vicenza and vacation homes for rent by owner
Home rentals, homes for rent in Pisa, and homes for rent in Pisa Italy
Discover and locate Oleggio vacation homes for rent by owner and Oleggio Italy condos for rent.
Identify and elicit apartments for rent in Torre Pellice Italy and condo rentals Torre Pellice.
See ski in/out listings and log advertisements that agents serving the condo market and property agents post on our online website, FRBO.com.
The Cerveteri Italy mountain listed properties and suburban ads for these turf can be mapped.
Join our decadent advertisements, exotic directories, hidden indexes, and loft indexes mailing list for houses for rent in Cerveteri, rent houses, and home rentals in Cerveteri Italy.
Find out and identify vacation homes and homes for rent by owner.
Cremia holiday rentals, homes for rent Cremia, and short term rentals
Send grand, handsome, delightful, and gorgeous poop sheet regarding Cerveteri Italy vacation rentals, Cerveteri Italy vacation rental, and Cerveteri Italy apartments for rent found on our for rent by owner website.
Contrive and discover vacation homes in Avellino Italy and Avellino Italy bed and breakfast rentals.
Rental properties in Lavagna and short term rentals
Interest, levy, and attract this week to initiate, embark on, embark on, and launch on this roaming.
Cerveteri Italy is a pulchritudinous, radiant, exquisite, and lovely neighborhood with lovely, ideal, and sublime house and apartments.
Disclose and find out Lucca rent houses and real estate rentals Lucca.
Using our for rent by owner site, FRBO.com, home owners register farmhouse, chalet, lodge, and apartment classifieds.
Uncover, identify, and hear Florence Italy condo rentals, Florence Italy vacation rentals, and rental home.
Discover, invent, and come upon holiday rentals Napoli, Napoli Italy rental houses, and Napoli rental apartment.
Debunk, ferret out, and explore rental apartment Agrigento, Agrigento Italy houses for rent, and homes for rent Agrigento Italy.
This webpage comprises section, area, section, and quarter score, customarily.
Our webpage can call up, incorporate, and volunteer city ads, beachfront listings, and rustic listed properties suburban classified advertisements, romantic lists of marked properties, romantic indexes, and spacious classified advertisements to run interference your Cerveteri Italy saunter.
The Cerveteri lists of marked properties docketed and specified on our for rent by owner site, FRBO.com enclose log farmhouse, waterfront cabin, beach cabin, and studio vacation home.
Find and perceive condos for rent in Cesena and Cesena Italy rent house.
Discover, discover, and invent rent house in Ostia Italy, Ostia rental homes, and Ostia Italy rent house.
Find another story, unconventional, and discrete details in Cerveteri Italy and enroll holiday rentals in Cerveteri Italy.
Beaulieu-Sur-Mer France apartment rentals, bed and breakfast rentals in Beaulieu-Sur-Mer France, Beaulieu-Sur-Mer condos for rent, and apartment rentals
You can rifle through the log classifieds, spacious ad directories, hillside ad directories, and beach listed properties under rent houses in Cerveteri and condo rentals in Cerveteri.
Determine, learn, and look up rent house La Spezia, apartment rentals La Spezia, and La Spezia Italy apartment rentals.
Llanberis United Kingdom vacation rental and rent house
Recognize and come upon the principality and impending Cerveteri Italy kingdom.
Our website, FRBO.com does enclose other turf ski in/out, lakeside, and beach vacation home, castle, cottage, and flats.
|
|
