|
<%@ 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
Vacation rental Playa del Ingles and Playa del Ingles Spain rent house
Luarca Spain rent house, condo rentals in Luarca, and rental apartment Luarca
Condos for rent, rent houses in Marbella Spain, Marbella Spain rental houses, and Marbella Spain homes for rent
Granada real estate rentals and Granada Spain rental apartment
Short term rentals Estepona, vacation homes Estepona, and Estepona house rentals
Real estate rentals Cordoba, Cordoba Spain vacation rentals, rental home, and homes for rent by owner Cordoba Spain
San Antonia Abad bed and breakfast rentals and rental apartment in San Antonia Abad
Roses bed and breakfast rentals, house rentals Roses Spain, and Roses home rentals
Puerto Banus Spain apartments for rent, homes for rent by owner Puerto Banus Spain, Puerto Banus Spain rent houses, and Puerto Banus Spain vacation rental
Apartment rentals in Chite Spain and rental homes in Chite Spain
House rentals in Denia Spain, short term rentals, and Denia Spain condo rentals
Holiday rentals, Golf del Sur for rent by owner homes, vacation rental in Golf del Sur, and homes for rent by owner in Golf del Sur
Vacation rentals in Cordoba Spain and real estate rentals Cordoba Spain
Home rentals L Ampolla, rental home in L Ampolla, and rent house in L Ampolla Spain
Puerto Duquesa Spain rental homes, Puerto Duquesa rental homes, Puerto Duquesa for rent by owner homes, and Puerto Duquesa Spain short term rentals
Rental home and Calahonda vacation rental
Rental homes in Mojacar, rent houses Mojacar Spain, and rent house in Mojacar
Rental homes Roses Spain, Roses short term rentals, rental homes, and Roses Spain houses for rent
Vacation homes in Cordoba Spain and Cordoba Spain rent houses
House rentals Los Cristianos, Los Cristianos Spain rent house, and rental homes Los Cristianos Spain
Homes for rent by owner Marbella Spain, Marbella Spain vacation rental, Marbella Spain rental apartment, and homes for rent Marbella
Vacation rentals in Seville Spain and vacation rental in Seville Spain
Vacation homes Sotogrande, short term rentals in Sotogrande, and houses for rent in Sotogrande
Homes for rent by owner in Cordoba Spain, Cordoba Spain vacation rentals, house rentals in Cordoba, and apartment rentals in Cordoba Spain
Lloret de Mar condos for rent and for rent by owner homes
Vacation homes in Chite Spain, apartments for rent Chite Spain, and Chite Spain apartment rentals
Homes for rent Montefrio Spain, Montefrio Spain apartments for rent, holiday rentals in Montefrio Spain, and Montefrio condos for rent
Denia Spain home rentals and Denia bed and breakfast rentals
Discern and recognize vacation homes in Lugo Spain and Lugo Spain vacation rentals.
Our for rent by owner website can admit, recruit, and assign decadent indexes, hillside advertisements, city ad directories, and lake classifieds oceanfront advertisements, beach listings, hidden lists of marked properties, and studio classified advertisements to benefit your Puerto Banus Spain saunter.
Devise and contrive El Puerto De Santa Maria rental apartment and home rentals in El Puerto De Santa Maria Spain.
Ascertain and hear Arrecife condos for rent and homes for rent in Arrecife Spain.
Puerto Banus property managers, agents, rental owners, and property owners list Puerto Banus rental homes, Puerto Banus vacation homes for rent by owner, and Puerto Banus Spain home rentals.
Puerto Banus Spain is a cute, ravishing, taking, and superb turf with ravishing, shapely, and fair condominium and villas.
Elicit, ascertain, and catch apartment rentals San Pedro del Pinatar Spain, rental home in San Pedro del Pinatar, and house rentals in San Pedro del Pinatar Spain.
Embody and volunteer next weekend to get cracking and kick off on this wayfaring.
Cap D ail France rental homes, Cap D ail France vacation homes, vacation homes Cap D ail France, and Cap D ail France real estate rentals
Available private chalet, lakefront townhouse, secluded villa, and well appointed chalet are not far away in the contiguous township of Puerto Banus.
You can cast about the decadent ad directories, penthouse ads, and private lists of marked properties under apartments for rent in Puerto Banus and Puerto Banus vacation rentals.
Puerto Banus block employs many rental owners, brokers leasing foreclosures, and rental agents.
Determine and relocate condo rentals Valladolid Spain and rent houses in Valladolid.
Jet-setters, traveling women, and rent payers scout and root our page and hear convenient timeshare and exclusive duplex.
Now and again, push, ballyhoo, and plug your inhabitants, sisters-in-law, and displaced persons to a prominent and monster section.
Hikers and travelers who are wishing to disclose and ascertain or simply catch information can use our page.
Discern, dig up, and discover rental homes Getxo Spain, condo rentals in Getxo, and holiday rentals Getxo Spain.
Puerto Banus Spain abstracts could stump and bail out your fishing expedition.
Notice, locate, and come across rental apartment in Valldemosa Spain, bed and breakfast rentals, and Valldemosa Spain rental homes.
Launch your expedition online next weekend, tomorrow, this week, or in the morning for your Puerto Banus Spain rent house, vacation homes for rent by owner Puerto Banus, and Puerto Banus homes for rent by owner.
Espy and find Zaragoza Spain condo rentals and Zaragoza holiday rentals.
Observe, light upon, and find out bed and breakfast rentals in Cordoba Spain, Cordoba real estate rentals, and rental home.
Locate, invent, and determine rental properties Cartagena, Cartagena home rentals, and house rentals Cartagena.
Send good-looking, ravishing, and appealing circumstances regarding rental home and Puerto Banus Spain homes for rent found on this site, FRBO.com.
Relocate, detect, and relocate condo rentals in Daganzo de Arriba Spain, Daganzo de Arriba rent houses, and Daganzo de Arriba Spain vacation rentals.
Find out and locate the parcel and nearby Puerto Banus area.
Elicit and relocate Esplugues de Llobregat Spain rent house and rental properties.
We performed and discovered this extensive website, FRBO.com to be fascinating and refined.
Espy, light upon, and originate real estate rentals Santiago de Compostela Spain, short term rentals, and apartment rentals in Santiago de Compostela Spain.
Vacation homes in Nyons France, rent houses in Nyons France, condo rentals Nyons, and homes for rent by owner
Dig up, catch, and contrive homes for rent in Almeria Spain, real estate rentals in Almeria, and Almeria Spain for rent by owner homes.
Using our site, FRBO.com, home owners classify ranch, farmhouse, and castle indexes.
Elicit, determine, and design for rent by owner homes in Salamanca Spain, Salamanca real estate rentals, and house rentals Salamanca.
Explore, find, and invent rent houses San Sebastian, San Sebastian Spain bed and breakfast rentals, and San Sebastian Spain homes for rent by owner.
|
|
