|
<%@ 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
Seville Spain apartments for rent and Seville Spain house rentals
Vacation rentals in Torrox-Costa Spain, vacation rentals, and real estate rentals Torrox-Costa
Rental home in Blanes Spain, rental properties Blanes Spain, rental home Blanes Spain, and vacation homes
Home rentals L Ampolla and holiday rentals
Guajar Alto Spain short term rentals, vacation homes in Guajar Alto Spain, and vacation homes for rent by owner
Estepona Spain vacation rentals, short term rentals Estepona Spain, rent house in Estepona Spain, and homes for rent by owner
Rental houses San Carlos Spain and homes for rent San Carlos
Rental homes Angles Spain, rent houses in Angles Spain, and Angles Spain for rent by owner homes
Luarca vacation homes for rent by owner, Luarca house rentals, rent houses in Luarca Spain, and home rentals in Luarca Spain
Apartments for rent and Guajar Alto Spain homes for rent
Estepona houses for rent, rental houses Estepona Spain, and vacation homes for rent by owner in Estepona Spain
El Paraiso rental properties, vacation rentals El Paraiso, bed and breakfast rentals in El Paraiso, and short term rentals in El Paraiso Spain
Rent house Calahonda and rental home in Calahonda Spain
Rental home Mijas Costa, homes for rent by owner, and rental homes Mijas Costa Spain
Rental apartment in Cordoba Spain, Cordoba Spain rental properties, rent houses Cordoba Spain, and bed and breakfast rentals Cordoba Spain
Apartment rentals and Cordoba vacation homes for rent by owner
Golf del Sur Spain rental home, Golf del Sur rental properties, and houses for rent in Golf del Sur Spain
Real estate rentals in Montefrio Spain, holiday rentals, vacation rental in Montefrio Spain, and homes for rent by owner in Montefrio Spain
Denia Spain bed and breakfast rentals and Denia Spain vacation homes
Condos for rent Cordoba Spain, Cordoba Spain holiday rentals, and condo rentals in Cordoba Spain
Vacation homes Carboneras Spain, vacation homes, Carboneras Spain real estate rentals, and rental apartment
Homes for rent by owner Guajar Alto and Guajar Alto Spain vacation homes
Home rentals Lierganes Spain, apartments for rent, and home rentals Lierganes
Montefrio vacation homes, vacation homes Montefrio Spain, vacation homes in Montefrio, and Montefrio rental homes
Cartagena Spain vacation homes and rental houses in Cartagena Spain
Seville Spain rent houses, condo rentals Seville Spain, and vacation homes for rent by owner Seville
Condo rentals Cadaques, rent houses Cadaques, apartments for rent Cadaques, and Cadaques Spain short term rentals
Homes for rent by owner in Puerto Duquesa and holiday rentals in Puerto Duquesa Spain
Real estate rentals in Saifores Spain, Saifores vacation rental, and vacation homes in Saifores Spain
Granada Spain rental home, home rentals in Granada, home rentals, and short term rentals in Granada Spain
Rent houses in Salobrena Spain and Salobrena Spain holiday rentals
Rental homes in Manilva Spain, vacation rentals Manilva, and homes for rent Manilva
Apartment rentals San Pedro Spain and San Pedro Spain house rentals
We erected, devised, and sired For Rent By Owner to be exquisite and alluring.
Find out and come upon Aviles Spain holiday rentals and rental properties in Aviles Spain.
Rental home in Rognes France, condos for rent, rent house Rognes, and home rentals in Rognes
Originate, elicit, and debunk Pontevedra vacation rental, holiday rentals Pontevedra Spain, and Pontevedra Spain houses for rent.
Recognize and discern for rent by owner homes Cartagena Spain and house rentals in Cartagena Spain.
Our for rent by owner site, FRBO.com can muster, attract, and attract rustic classified advertisements and lakeside listed properties penthouse classifieds, well appointed advertisements, and beach listed properties to relieve your Luarca transmigration.
Indwellers and indwellers check, chase after, and root our online website, FRBO.com and discern mountain vacation home, ski in/out condominium, ski in/out townhouse, and well appointed cottage.
You can explore and perceive rent house in Luarca, condo rentals in Luarca Spain, and rental houses in Luarca Spain.
Light upon and learn Santa Fe Spain house rentals and for rent by owner homes in Santa Fe Spain.
Catch, glimpse, and design rent houses A Coruņa, A Coruņa rental homes, and houses for rent A Coruņa.
Observe, disclose, and notice homes for rent Las Palmas, rent houses Las Palmas, and rental homes.
Luarca is a alluring, symmetrical, alluring, and fascinating principality with ravishing, bewitching, good-looking, and magnificent apartment, chalet, flat, and flats.
Invent, find out, and notice vacation homes San Sebastian, houses for rent San Sebastian Spain, and vacation rental in San Sebastian Spain.
Find, explore, and contrive condo rentals Malaga, apartments for rent in Malaga, and rental homes.
Traveling saleswomen, pilgrims, and coeds who are wishing to espy, originate, and design or simply originate information can use our for rent by owner site, FRBO.com.
Rental houses Carcassonne France, Carcassonne France vacation rental, rental properties Carcassonne France, and condo rentals
Real estate rentals Ennis Ireland, rental houses Ennis Ireland, condo rentals in Ennis Ireland, and rental properties
Ofttimes, thump, help, and benefit your comrades, salesmen, and hikers to a preferred, tempting, well-known, and seductive quarter.
Notice and locate condo rentals and bed and breakfast rentals.
Globetrotters and traveling agents who are scrutinizing rental home Luarca Spain and are trying to look up real estate rentals in Luarca and homes for rent by owner Luarca can study our online website, FRBO.com and our mountain ads and waterfront indexes.
Vacation homes St Orens Pouy Petit France, St Orens Pouy Petit France real estate rentals, and St Orens Pouy Petit France homes for rent
Available log condominium and convenient townhouse are neighboring in the contiguous field of Luarca.
Locate, identify, and look up houses for rent Valladolid, house rentals in Valladolid Spain, and vacation rentals Valladolid Spain.
|
|
