|
<%@ 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 homes Montefalco and Montefalco house rentals
Cerveteri bed and breakfast rentals, Cerveteri vacation rentals, and homes for rent in Cerveteri Italy
Rental apartment in Castellina, Castellina Italy apartment rentals, vacation homes, and Castellina Italy rental home
Condo rentals in Sant Agata Sui Due Golfi Italy and Sant Agata Sui Due Golfi rent house
Home rentals, vacation rental Cerveteri, and Cerveteri Italy apartment rentals
Condo rentals Londa Italy, house rentals Londa Italy, home rentals in Londa Italy, and rental properties Londa Italy
Home rentals in Fivizzano and rent house in Fivizzano Italy
Short term rentals in Stintino Italy, vacation rental Stintino, and rental properties in Stintino
Rental apartment, rent house in Pontassieve, Pontassieve Italy homes for rent by owner, and Pontassieve Italy houses for rent
Rental houses Fiaiano and rental houses in Fiaiano
Homes for rent in Toirano Italy, houses for rent in Toirano, and vacation rentals in Toirano Italy
Real estate rentals Montepulciano, Montepulciano Italy rent house, Montepulciano Italy houses for rent, and Montepulciano Italy for rent by owner homes
Sogna Italy rental homes and condo rentals
For rent by owner homes in Taormina Italy, rent house in Taormina Italy, and for rent by owner homes
Homes for rent in Menaggio Italy, house rentals, Menaggio Italy rental apartment, and house rentals Menaggio
Houses for rent Florence and rent houses
Holiday rentals in Otricoli Italy, holiday rentals in Otricoli Italy, and rental properties Otricoli
Vicchio Italy homes for rent, rental properties in Vicchio Italy, Vicchio Italy home rentals, and vacation rental in Vicchio Italy
Homes for rent by owner and Arezzo vacation homes for rent by owner
For rent by owner homes in Marsiliana Italy, short term rentals in Marsiliana, and real estate rentals in Marsiliana Italy
Moneglia rent house, apartments for rent Moneglia, rent house, and Moneglia Italy rental home
Rent houses in Capri and Capri Italy rent houses
Real estate rentals Mercatale Valdarno Italy, vacation rental Mercatale Valdarno Italy, and Mercatale Valdarno Italy vacation rentals
Vacation rentals in Ostuni, rent house in Ostuni, house rentals in Ostuni Italy, and vacation rental Ostuni
Apartment rentals Fondi Italy and houses for rent Fondi Italy
Short term rentals, rental homes in Marlia, and apartments for rent in Marlia Italy
Rental apartment Livorno, Livorno Italy for rent by owner homes, for rent by owner homes in Livorno Italy, and Livorno Italy apartments for rent
Bed and breakfast rentals in Aurelio-Via Aurellia Italy and real estate rentals Aurelio-Via Aurellia
Careno rental houses, Careno Italy homes for rent, and condos for rent
Bed and breakfast rentals, vacation rentals Vaticano-St Peters & Vatican Italy, Vaticano-St Peters & Vatican Italy vacation rental, and rental homes in Vaticano-St Peters & Vatican Italy
Condos for rent in Florence Italy and vacation rentals Florence
Homes for rent, home rentals in Ferrara, and condos for rent
Rental houses in Barberino di Mugello and house rentals in Barberino di Mugello Italy
Houses for rent in Sogna Italy, vacation homes in Sogna Italy, and Sogna Italy vacation rentals
The Montalto delle Marche Italy beach lists of marked properties, suburban ads, and penthouse online MLS for these city can be mapped.
Perceive, conceive, and determine Terrasini holiday rentals, rent houses Terrasini Italy, and Terrasini Italy condos for rent.
You can look over the waterfront ads, convenient ads, exotic ad directories, and suburban classified ads under real estate rentals and vacation rental Montalto delle Marche.
Hear and locate Imperia rent houses and rental homes in Imperia Italy.
Identify, dig up, and find Sorrento vacation rentals, rental houses in Sorrento, and Sorrento Italy rent houses.
Lauzerte France vacation rentals, Lauzerte France rent house, rental properties Lauzerte France, and homes for rent by owner Lauzerte France
Elicit and distinguish Terrasini rental homes and Terrasini Italy homes for rent by owner.
Notice and explore Perugia apartment rentals and vacation rentals in Perugia Italy.
Roquebrune-Cap-Martin house rentals and rental properties Roquebrune-Cap-Martin
Montalto delle Marche Italy is a symmetrical, classy, and beauteous parcel with fascinating, radiant, and charming houseboat and vacation homes.
Identify, relocate, and detect vacation homes Guidonia, vacation homes for rent by owner, and rental apartment in Guidonia.
Debunk, perceive, and identify Ravenna apartments for rent, rental homes, and for rent by owner homes in Ravenna Italy.
Rental homes Andlau France, Andlau house rentals, Andlau France apartments for rent, and houses for rent
Colleagues, traveling sales representatives, and sorority sisters who are wishing to detect, debunk, and catch or simply distinguish information can use our for rent by owner website.
Discern, look up, and glimpse rent houses in Foggia, vacation homes, and Foggia Italy vacation rental.
Design and uncover rental homes Taranto Italy and Taranto rental properties.
Bouriege France vacation homes for rent by owner and vacation homes
Tourists and schoolmates rifle through and grub this website, FRBO.com and move lakefront farmhouse, lake cabin, and hillside villa.
We shaped and dreamed up our for rent by owner website to be dazzling and gorgeous.
Explore and detect Massa Italy rental homes and Massa Italy vacation homes.
Discover and distinguish Pinerolo vacation rental and homes for rent in Pinerolo.
Find out and identify for rent by owner homes in Brembate and Brembate home rentals.
Explore and recognize home rentals in Trento Italy and vacation homes for rent by owner Trento Italy.
Observe, debunk, and recognize vacation rental in Napoli Italy, vacation rentals in Napoli Italy, and Napoli Italy rental home.
Dig up and notice rent houses Belmonte Mezzagno and rental apartment in Belmonte Mezzagno.
For rent by owner homes in Castelnuovo Berardenga Italy, Castelnuovo Berardenga Italy bed and breakfast rentals, and rental houses in Castelnuovo Berardenga
The Montalto delle Marche Italy ads tallied and classified on FRBO.com embrace penthouse townhouse, hidden cottage, and oceanfront farmhouse.
Much, benefit and work with your roamers, fraternity members, and confreres to a mod and thundering state.
Elicit and discern Milano homes for rent by owner and Milano Italy vacation homes for rent by owner.
Come upon and dig up condo rentals and condo rentals Como Italy.
Tear into your frisking online this weekend or on Tuesday for your house rentals Montalto delle Marche, Montalto delle Marche condo rentals, and rent house.
Rental houses, homes for rent, and rental apartment in Meyrargues France
Using FRBO.com, town home owners register duplex and ranch listed properties.
Dig up, elicit, and relocate Novara Italy real estate rentals, apartments for rent in Novara, and vacation homes for rent by owner in Novara.
Send stunning, fine, and ravishing brass tacks regarding rent houses in Montalto delle Marche Italy, Montalto delle Marche Italy apartment rentals, and houses for rent Montalto delle Marche Italy found on this site, FRBO.com.
Observe, detect, and look up rental home Biella, rental properties Biella Italy, and Biella Italy rental home.
Port-Grimaud homes for rent by owner, vacation rental, and real estate rentals Port-Grimaud France
You can conceive and light upon rent houses in Montalto delle Marche Italy and vacation homes for rent by owner in Montalto delle Marche Italy.
Our page does omit particular field studio, beach, and exotic cottage, apartment, apartment, and ranchs.
|
|
