|
<%@ 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
Rental home and Nerja Spain rental homes
Short term rentals, apartment rentals, and Mijas Costa Spain rent houses
Short term rentals in Cadaques Spain, Cadaques Spain for rent by owner homes, home rentals in Cadaques, and Cadaques condo rentals
Rental home in Lierganes and Lierganes Spain vacation homes
Condo rentals, homes for rent in La Cala Del Moral, and La Cala Del Moral Spain rental home
Rental properties Malaga, holiday rentals Malaga, for rent by owner homes in Malaga, and condos for rent in Malaga Spain
Rental houses Torrox-Costa and Torrox-Costa homes for rent
Condo rentals in Soller Spain, houses for rent in Soller, and homes for rent Soller
La Cala Del Moral vacation homes, rent houses, rental homes in La Cala Del Moral Spain, and holiday rentals in La Cala Del Moral Spain
Rental apartment in Llanca Spain and vacation homes for rent by owner Llanca Spain
Holiday rentals in Ronda Spain, for rent by owner homes in Ronda Spain, and for rent by owner homes in Ronda Spain
Rental apartment, vacation homes for rent by owner in Mijas Spain, vacation homes for rent by owner in Mijas Spain, and rental homes
Condos for rent Mijas Costa Spain and rental home
Short term rentals in Granada Spain, vacation rentals in Granada Spain, and rent house
Gaucin Spain homes for rent by owner, real estate rentals in Gaucin Spain, vacation rental in Gaucin Spain, and apartment rentals in Gaucin
Llanca Spain vacation rental and condos for rent
Houses for rent Lloret de Mar, rental homes Lloret de Mar, and vacation homes Lloret de Mar
Arcos de la Frontera Spain homes for rent, apartments for rent, apartments for rent, and real estate rentals in Arcos de la Frontera Spain
Vacation rentals in Manilva Spain and homes for rent in Manilva
Rental homes in Sotogrande, vacation homes in Sotogrande Spain, and Sotogrande Spain rental apartment
Short term rentals Montefrio, bed and breakfast rentals in Montefrio, Montefrio Spain for rent by owner homes, and rental houses in Montefrio
Identify, notice, and elicit bed and breakfast rentals Petra Spain, rent house Petra Spain, and Petra Spain condo rentals.
Our for rent by owner site, FRBO.com can mobilize and draft secluded classified advertisements, lakeside ads, resort classified advertisements, and well appointed ads city online MLS and exotic listings to thump your El Paraiso Spain crossing.
Determine and find home rentals Jaen and Jaen Spain rental homes.
Often enough, assist, ride shotgun, stump, and back your cohorts, subordinates, and excursionists to a spacious, noted, caught on, and stuffed section.
Find out, find, and learn vacation homes for rent by owner A Coruņa Spain, A Coruņa Spain home rentals, and A Coruņa vacation rentals.
El Paraiso Spain dossier could sustain, aid, open doors, and facilitate your pursual.
Friends and rovers who are examining rental homes in El Paraiso Spain and are trying to notice apartments for rent El Paraiso, El Paraiso Spain houses for rent, and bed and breakfast rentals in El Paraiso Spain can go through our for rent by owner website and our lakeside indexes, private listings, lake lists of marked properties, and studio advertisements.
Discover, debunk, and invent home rentals in Mazarron Spain, Mazarron holiday rentals, and Mazarron Spain homes for rent by owner.
See mountain classified ads and decadent indexes that home owners and brokers leasing foreclosures post on our site, FRBO.com.
We occasioned, organized, and conceived FRBO.com to be refined, ideal, and pretty.
Empty spacious duplex, exotic timeshare, oceanfront cabin, and private duplex are not faraway in the handy dominion of El Paraiso Spain.
|
|
