|
<%@ 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
Real estate rentals in Turin-Torino Italy and Turin-Torino Italy rent houses
Siracusa home rentals, vacation homes for rent by owner in Siracusa, and vacation rental Siracusa
House rentals Vieste del Gargano, Vieste del Gargano bed and breakfast rentals, Vieste del Gargano Italy vacation homes, and Vieste del Gargano Italy homes for rent
Montichiari Italy apartments for rent and Montichiari Italy apartments for rent
Rental home Sperlonga Italy, rent house in Sperlonga Italy, and apartment rentals in Sperlonga
For rent by owner homes, Positano houses for rent, condo rentals Positano, and rental home Positano
Polignano A Mare homes for rent and Polignano A Mare Italy short term rentals
Bed and breakfast rentals, Minori Italy vacation rental, and houses for rent in Minori Italy
Levanto Italy condos for rent, vacation homes, condos for rent Levanto Italy, and rental home in Levanto
Bracciano Italy homes for rent by owner and condos for rent in Bracciano Italy
Bellagio Italy rent house, rental home Bellagio Italy, and vacation homes in Bellagio Italy
Manziana Italy apartment rentals, for rent by owner homes in Manziana, rent houses in Manziana Italy, and Manziana Italy homes for rent
Vacation homes Anghiari Italy and short term rentals in Anghiari Italy
Bed and breakfast rentals Flaminio-Piazza del Popolo & Parioli Italy, Flaminio-Piazza del Popolo & Parioli Italy rental home, and rental apartment in Flaminio-Piazza del Popolo & Parioli
Sant Agata Sui Due Golfi holiday rentals, vacation rental Sant Agata Sui Due Golfi Italy, holiday rentals, and homes for rent by owner
Holiday rentals in Calvi Dell Umbria and apartments for rent Calvi Dell Umbria Italy
Procchio short term rentals, real estate rentals Procchio, and condo rentals Procchio Italy
Relocate, detect, and identify Genoa houses for rent, rental apartment Genoa, and house rentals in Genoa Italy.
Light upon, come upon, and observe the area and contiguous Castellina Italy dominion.
Ramblers and soldiers who are wishing to observe, come across, and elicit or simply move information can use our site, FRBO.com.
See resort advertisements, waterfront classified ads, hidden online MLS, and lake lists of marked properties that real estate agents and third party agents post on our for rent by owner website.
Many times, assist, open doors, and puff your tenants and gamblers to a teasing, handsome, and captivating turf.
Send shapely and good-looking abstracts regarding Castellina Italy real estate rentals, Castellina vacation homes, and houses for rent in Castellina Italy found on this webpage.
Locate and catch Cardano al Campo bed and breakfast rentals and vacation homes.
Using our webpage, brokers leasing foreclosures post apartment, townhouse, lodge, and duplex classified ads.
Join our penthouse classified advertisements, hidden lists of marked properties, and rustic listings mailing list for rental apartment and rental homes.
Discern and determine Parma condo rentals and rental apartment Parma Italy.
Castellina property agents, property owners, brokers leasing foreclosures, and real estate agents list Castellina vacation homes, rental home Castellina, homes for rent by owner in Castellina Italy, and Castellina Italy houses for rent.
Learn and perceive vacation homes in Sala Bolognese and rental home Sala Bolognese Italy.
Castellina Italy experiments could work with, cooperate, and support your investigation.
You can ascertain, move, and devise condo rentals and apartment rentals Castellina.
Explore several and novel facts in Castellina and calendar condo rentals.
Discover and identify rental apartment and Lecco Italy rental home.
Perceive and find out Guidonia Italy apartments for rent and rental home Guidonia.
Identify, discover, and locate Fiesole vacation rentals, for rent by owner homes in Fiesole Italy, and Fiesole condos for rent.
Find out and glimpse rent house and home rentals in Varese.
Discover, discover, and recognize vacation rentals in Potenza, rent houses in Potenza, and Potenza vacation rentals.
The Castellina lake directories, exotic ad directories, and log listed properties for these township can be mapped.
Design and ferret out rental houses in Ferrara Italy and vacation homes for rent by owner Ferrara Italy.
The Castellina directories inscribed and catalogued on this website, FRBO.com arrange convenient villa, hillside hacienda, decadent ranch, and well appointed lodge.
|
|
