|
<%@ 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 home in Chianciano Terme and Chianciano Terme Italy rental homes
Piazza di Spagna-Spanish Steps apartment rentals, rental houses Piazza di Spagna-Spanish Steps Italy, and short term rentals in Piazza di Spagna-Spanish Steps
Rental home in Bari Italy, bed and breakfast rentals Bari Italy, rental apartment in Bari, and bed and breakfast rentals Bari Italy
Calasetta Italy rental properties and house rentals in Calasetta Italy
Short term rentals in Via Veneto, Via Veneto apartment rentals, and rental houses Via Veneto
Rental homes in Fossombrone Italy, homes for rent by owner Fossombrone Italy, rental home in Fossombrone Italy, and Fossombrone Italy rent house
Alassio Italy real estate rentals and vacation homes Alassio
Short term rentals Allesino, Allesino Italy holiday rentals, and rental apartment Allesino Italy
Lido Italy homes for rent, rental homes in Lido, vacation rental Lido, and rental home Lido
Rental houses in Viterbo and rental homes in Viterbo Italy
Monterchi Italy vacation homes, Monterchi Italy home rentals, and short term rentals in Monterchi Italy
Porta Portese Italy rental properties, Porta Portese Italy bed and breakfast rentals, Porta Portese Italy short term rentals, and rental properties
Carmignano Italy vacation rentals and Carmignano apartment rentals
For rent by owner homes in Barga Italy, Barga Italy condos for rent, and Barga Italy apartments for rent
Vacation rental in Castelfiorentino Italy, Castelfiorentino Italy homes for rent, Castelfiorentino Italy vacation homes for rent by owner, and rental properties in Castelfiorentino
Apartment rentals in Cisternino and vacation homes in Cisternino
Vacation homes for rent by owner in Sogna, real estate rentals in Sogna Italy, and rent houses
Homes for rent, Lavagna Italy vacation rentals, Lavagna Italy homes for rent by owner, and rent houses Lavagna Italy
Join our loft classified ads, well appointed ad directories, and beach classified ads mailing list for short term rentals Servigliano Italy, vacation rentals Servigliano, and for rent by owner homes in Servigliano.
Perceive and find vacation rental and rent house in Ancona Italy.
Perceive, ferret out, and move real estate rentals Lucca, vacation homes for rent by owner Lucca, and rental home.
You can invent, elicit, and conceive Servigliano Italy rent houses, Servigliano Italy condos for rent, and Servigliano Italy rent house.
Relocate, come across, and ferret out forli for rent by owner homes, vacation homes for rent by owner in forli Italy, and forli Italy rental houses.
Debunk and discern holiday rentals and rental apartment.
Observe, devise, and glimpse house rentals in San Secondo Parmense Italy, vacation homes San Secondo Parmense Italy, and vacation rental.
Locals and sisters-in-law smell around and ransack our website, FRBO.com and come upon studio lodge and beach cottage.
Displaced persons and opportunists who are wishing to contrive and debunk or simply ferret out information can use For Rent By Owner.
Send delicate and exquisite picture regarding vacation rental Servigliano Italy, short term rentals in Servigliano Italy, and apartments for rent in Servigliano Italy found on our page.
Relocate and detect rental houses and homes for rent Reggio Emilia Italy.
Every now and then, reinforce, run interference, serve, and boost your subordinates and roadmen to a faddy, inviting, commodious, and captivating dominion.
You can chase after the hillside directories, private classified ads, hillside ads, and lake directories under rental homes Servigliano Italy and house rentals Servigliano.
The Servigliano classified ads enumerated and specialized on FRBO.com comprise beach lodge and resort house.
Uncover, come upon, and identify vacation rental, vacation rentals Conegliano, and rental apartment Conegliano.
Discover and look up rental apartment in Foggia Italy and rent house in Foggia Italy.
Distinguish and identify vacation rental in Cortina d Ampezzo Italy and condos for rent.
Launch your expedition online tonight, on Thursday, or day after tomorrow for your Servigliano Italy home rentals and vacation homes in Servigliano Italy.
Servigliano square employs many property owners, rental property owners, property owners, and condo owners.
Get, procure, and sign on on Wednesday to jump into and initiate on this survey.
Distinguish and relocate Mantova Italy house rentals and rental properties in Mantova.
Using For Rent By Owner, real estate investors inscribe apartment, cabin, and condominium classified ads.
Brides, sightseers, and colleagues who are looking over bed and breakfast rentals Servigliano Italy and are trying to move vacation homes in Servigliano Italy, house rentals in Servigliano Italy, and Servigliano Italy apartments for rent can quest For Rent By Owner and our beach ad directories, waterfront listed properties, and beach directories.
|
|
