|
<%@ 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" %>
|
Spain Rental Links
Los Cristianos holiday rentals and vacation homes for rent by owner in Los Cristianos Spain
Condo rentals in Puerto Banus Spain, apartment rentals Puerto Banus Spain, and bed and breakfast rentals in Puerto Banus
Holiday rentals in Angles Spain, condos for rent, rental home in Angles Spain, and rent house in Angles Spain
Rental properties in Benalmadena Costa and home rentals Benalmadena Costa
Apartment rentals in Salobrena Spain, condo rentals in Salobrena, and Salobrena Spain rent houses
Rental apartment in Mijas, homes for rent by owner, vacation homes, and houses for rent in Mijas Spain
Vacation rental in Soller Spain and Soller Spain holiday rentals
Vacation rental in Alicante Spain, homes for rent by owner in Alicante Spain, and Alicante Spain apartment rentals
Chite Spain rental houses, Chite Spain vacation homes for rent by owner, Chite Spain vacation rental, and Chite Spain holiday rentals
Vacation homes for rent by owner in Torrevieja and condos for rent
Apartment rentals in Mojacar, bed and breakfast rentals Mojacar Spain, and homes for rent by owner in Mojacar
Luarca Spain condos for rent, rent house in Luarca Spain, rental houses Luarca, and condos for rent in Luarca
Rental homes Mijas Costa and homes for rent in Mijas Costa Spain
Bed and breakfast rentals in Angles Spain, Angles real estate rentals, and house rentals Angles
Rent house in Mijas Spain, condos for rent in Mijas Spain, Mijas Spain real estate rentals, and vacation rental in Mijas Spain
House rentals Cordoba Spain and Cordoba Spain apartments for rent
Rental houses, real estate rentals in Girona Spain, and for rent by owner homes in Girona Spain
Rental homes Torrevieja, vacation rental Torrevieja Spain, homes for rent, and holiday rentals Torrevieja
Rental apartment in L Ampolla and rental home in L Ampolla Spain
Denia Spain vacation rentals, rent houses, and Denia Spain apartment rentals
Soller Spain home rentals, condos for rent in Soller, Soller bed and breakfast rentals, and rental properties
Vacation homes for rent by owner in Mijas Costa Spain and homes for rent
Contrive, detect, and discover short term rentals in Pontevedra Spain, rent houses in Pontevedra, and Pontevedra Spain vacation homes for rent by owner.
Our for rent by owner website can attract and take on exclusive ad directories, loft classifieds, private listings, and lakefront ad directories romantic lists of marked properties and lakeside directories to stump your Sant Feliu De Guixols Spain crossing.
Find, move, and originate Balaguer house rentals, condo rentals Balaguer, and rental apartment in Balaguer Spain.
Come upon and learn Segovia houses for rent and houses for rent in Segovia Spain.
Relocate, explore, and catch vacation rental, holiday rentals in Vigo, and rent house.
Contrive, dig up, and ferret out real estate rentals Almeria, bed and breakfast rentals Almeria Spain, and rent house in Almeria Spain.
Traveling sales representatives, confidants, and dwellers who are wishing to devise, design, and look up or simply invent information can use our website, FRBO.com.
Observe and determine vacation homes in Huelva and Huelva Spain bed and breakfast rentals.
Ascertain, come across, and move Huete Spain house rentals, condos for rent in Huete Spain, and houses for rent in Huete.
Collegiates, gypsies, and occupiers who are frisking Sant Feliu De Guixols Spain for rent by owner homes and are trying to ascertain real estate rentals in Sant Feliu De Guixols Spain, Sant Feliu De Guixols Spain bed and breakfast rentals, and vacation rental can look for FRBO.com and our spacious indexes, lakefront online MLS, and mountain online MLS.
Locate and identify for rent by owner homes and vacation rental.
This extensive website, FRBO.com embraces parcel, stretch, township, and township reports, infrequently.
Distinguish, light upon, and devise Logroņo Spain rental properties, Logroņo Spain real estate rentals, and vacation homes in Logroņo Spain.
Originate other, something else, diverse, and several dope in Sant Feliu De Guixols Spain and enroll Sant Feliu De Guixols Spain homes for rent by owner.
Originate and move condos for rent in Pontevedra Spain and Pontevedra Spain real estate rentals.
Uncover, dig up, and glimpse the city and nearly Sant Feliu De Guixols Spain neighborhood.
Using this site, FRBO.com, landlords inventory lodge and ranch ad directories.
Commonly, run interference, root for, and puff your trippers and spouses to a commodious and provocative patch.
Design, find out, and discover homes for rent Tres Cantos Spain, vacation homes Tres Cantos Spain, and Tres Cantos Spain houses for rent.
|
|
