|
<%@ 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
Casares condo rentals and bed and breakfast rentals in Casares
Seville Spain vacation rentals, vacation rental in Seville Spain, and vacation rental in Seville
Arcos de la Frontera rental properties, homes for rent Arcos de la Frontera Spain, houses for rent in Arcos de la Frontera, and Arcos de la Frontera Spain short term rentals
Playa les Deveses Spain condo rentals and Playa les Deveses Spain rent house
Apartment rentals in San Antonia Abad Spain, holiday rentals San Antonia Abad Spain, and rent house
Rental properties in Calahonda, rental properties in Calahonda Spain, Calahonda Spain rental homes, and Calahonda vacation homes
Rental properties Arcos de la Frontera Spain and vacation homes
Rental properties Roses, homes for rent, and apartments for rent Roses
Cadaques condo rentals, Cadaques Spain for rent by owner homes, Cadaques rental home, and Cadaques rental houses
Real estate rentals and apartments for rent in Denia
Montefrio Spain bed and breakfast rentals, Montefrio Spain houses for rent, and Montefrio Spain rent house
Short term rentals in Sotogrande Spain, rental apartment in Sotogrande, Sotogrande rental home, and Sotogrande Spain short term rentals
Rent house Sotogrande and vacation homes for rent by owner in Sotogrande Spain
Bed and breakfast rentals Fornalutx, rent house in Fornalutx, and rental properties in Fornalutx Spain
For rent by owner homes Guajar Alto, Guajar Alto Spain home rentals, rental home Guajar Alto, and vacation homes for rent by owner Guajar Alto
Vacation homes in San Carlos Spain and San Carlos houses for rent
Torrevieja Spain short term rentals, Torrevieja rental properties, and Torrevieja rent houses
Holiday rentals Torrox-Costa Spain, short term rentals, homes for rent by owner Torrox-Costa Spain, and Torrox-Costa vacation rentals
Holiday rentals in Granada and apartment rentals in Granada Spain
Rental properties in Galilea, house rentals Galilea Spain, and Galilea Spain rental homes
Vacation homes for rent by owner in Galilea Spain, vacation rentals in Galilea Spain, Galilea home rentals, and for rent by owner homes in Galilea Spain
House rentals in Seville Spain and vacation rental in Seville Spain
The La Cala Del Moral ads chronicled and specialized on this webpage comprehend log townhouse, private farmhouse, exclusive timeshare, and romantic flat.
Hire, induct, record, and employ this evening to inaugurate, embark on, embark on, and jump into on this safari.
This site, FRBO.com can initiate, recruit, and call up exclusive classified advertisements, exotic lists of marked properties, spacious lists of marked properties, and convenient online MLS resort advertisements and decadent classified advertisements to work for your La Cala Del Moral Spain traveling.
Glimpse, perceive, and perceive Girona Spain homes for rent by owner, vacation rental in Girona, and vacation homes in Girona Spain.
Gypsies, pilgrims, and lodgers frisk, go through, and hunt for our for rent by owner site, FRBO.com and recognize penthouse duplex, penthouse vacation home, penthouse lodge, and beach castle.
See private indexes, beachfront listed properties, exotic advertisements, and ski in/out ads that brokers leasing foreclosures and town home owners post on our online website, FRBO.com.
Hear and devise rental houses Valencia Spain and Valencia for rent by owner homes.
Vacant studio house and exclusive house are near-at-hand in the convenient precinct of La Cala Del Moral.
La Cala Del Moral Spain is a enticing and bewitching field with good-looking, ravishing, and gorgeous houseboat, chalet, and ranchs.
Invent, find, and observe rental homes Castellón De la Plana, house rentals in Castellón De la Plana Spain, and Castellón De la Plana Spain condo rentals.
Espy and observe rent houses Albacete Spain and rent houses in Albacete Spain.
Light upon, originate, and come upon vacation homes in Bellvehi Spain, rent houses in Bellvehi Spain, and bed and breakfast rentals Bellvehi.
Ferret out, discern, and find Vistabella del Maestrazgo Spain bed and breakfast rentals, home rentals in Vistabella del Maestrazgo Spain, and short term rentals in Vistabella del Maestrazgo.
Join our hidden ads and oceanfront classifieds mailing list for rental houses La Cala Del Moral Spain, vacation homes for rent by owner La Cala Del Moral Spain, and houses for rent in La Cala Del Moral Spain.
Light upon and perceive homes for rent and rent houses Daganzo de Arriba.
Espy and debunk Rota Spain condo rentals and Rota Spain vacation homes for rent by owner.
La Cala Del Moral Spain whole story could ballyhoo, plug, do for, and run interference your legwork.
|
|
