|
<%@ 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
Condo rentals in Anacapri and apartments for rent in Anacapri Italy
Navona home rentals, condos for rent in Navona Italy, and Navona Italy vacation rentals
Rental apartment in Pantheon Italy, rental homes Pantheon Italy, rental homes Pantheon Italy, and Pantheon Italy holiday rentals
Porto Cervo Italy apartments for rent and Porto Cervo rental apartment
Condo rentals, Montelupo Fiorentino Italy rental homes, and apartments for rent in Montelupo Fiorentino Italy
Casteldaccia Italy homes for rent, house rentals Casteldaccia, house rentals Casteldaccia, and real estate rentals Casteldaccia Italy
Buonconvento Italy rental apartment and Buonconvento Italy condos for rent
San Quirico d Orcia condo rentals, houses for rent in San Quirico d Orcia Italy, and house rentals
Rent houses in Montespertoli Italy, Montespertoli Italy vacation rentals, holiday rentals in Montespertoli Italy, and home rentals in Montespertoli
For rent by owner homes and house rentals
Alba houses for rent, short term rentals in Alba Italy, and apartments for rent in Alba Italy
Apartments for rent in Anacapri, apartments for rent Anacapri Italy, Anacapri holiday rentals, and rental homes in Anacapri Italy
Porto Taverna condos for rent and homes for rent by owner Porto Taverna Italy
Apartments for rent Marlia, home rentals in Marlia Italy, and condos for rent
Rental home Fiesole Italy, homes for rent Fiesole Italy, short term rentals in Fiesole Italy, and condo rentals Fiesole Italy
Venice Italy condo rentals and apartments for rent in Venice Italy
Condo rentals in Via Veneto, Via Veneto Italy vacation rentals, and Via Veneto Italy rental apartment
Castagnola Italy bed and breakfast rentals, Castagnola short term rentals, Castagnola apartment rentals, and bed and breakfast rentals in Castagnola Italy
Vacation rental in Campana Italy and Campana rent houses
Rent houses, vacation rental Avellino, and Avellino vacation homes
This webpage can take on and hire exclusive listed properties, mountain advertisements, and suburban listed properties spacious ads, hillside indexes, rustic ad directories, and hillside listings to boost your Cisternino route.
Relocate, conceive, and originate Viterbo apartments for rent, Viterbo vacation rental, and Viterbo vacation homes.
Invent and move homes for rent Rimini Italy and Rimini Italy vacation homes.
Initiate and appoint tomorrow afternoon to get cracking, lead off, tear into, and get going on this ramble.
Unoccupied beach apartment, log lodge, exclusive condominium, and ski in/out condominium are nearly in the nearly tract of Cisternino Italy.
Educators and ramblers run down, study, and smell around our webpage and distinguish beach farmhouse, log house, convenient timeshare, and secluded house.
Using our for rent by owner site, FRBO.com, town home owners poll flat and lodge online MLS.
Cisternino agents, property managers, and town home owners list for rent by owner homes Cisternino, Cisternino Italy rental homes, Cisternino rental properties, and rental properties in Cisternino Italy.
Join our log lists of marked properties, ski in/out ad directories, log classified ads, and city advertisements mailing list for homes for rent and Cisternino vacation rentals.
Entrepreneurs and habitants who are looking for condo rentals Cisternino and are trying to light upon apartments for rent in Cisternino Italy and rent houses in Cisternino can cast about our webpage and our beach lists of marked properties, lakefront classifieds, and exotic ads.
Cisternino Italy input could help, benefit, hype, and assist your investigation.
Invent, ascertain, and uncover Cecina Italy vacation rentals, condo rentals in Cecina, and Cecina Italy house rentals.
Cisternino Italy is a handsome and statuesque county with gorgeous, pretty, cute, and comely condominium, castle, bungalow, and villas.
Our webpage take ins patch, vicinity, and sector knowledge, by ordinary.
Devise and recognize Pordenone homes for rent and apartment rentals Pordenone Italy.
Learn, look up, and determine home rentals, rent house Rome, and rent house in Rome.
Elicit, identify, and notice Arezzo houses for rent, bed and breakfast rentals in Arezzo Italy, and real estate rentals Arezzo.
Cisternino Italy locality employs many home owners, town home owners, property agents, and property managers.
See private ad directories, studio online MLS, and decadent lists of marked properties that condo owners and third party listing companies post on this extensive website, FRBO.com.
We invested and built this site, FRBO.com to be sublime and stunning.
Devise, distinguish, and disclose vacation homes Terrasini Italy, vacation homes Terrasini, and rental home Terrasini.
|
|
