|
<%@ 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
Nerja Spain rental houses and bed and breakfast rentals in Nerja Spain
Vacation rental in Calahonda Spain, Calahonda Spain apartments for rent, and homes for rent in Calahonda Spain
Bed and breakfast rentals Lierganes, homes for rent in Lierganes Spain, Lierganes Spain holiday rentals, and rental homes Lierganes
Short term rentals in Llanca Spain and short term rentals in Llanca
Short term rentals, Madrid real estate rentals, and Madrid homes for rent
Chite Spain rental apartment, Chite home rentals, homes for rent in Chite Spain, and vacation rentals Chite Spain
Short term rentals Los Gigantes Spain and Los Gigantes for rent by owner homes
Malaga Spain for rent by owner homes, condo rentals in Malaga Spain, and Malaga condos for rent
Rental apartment, condos for rent in Sotogrande Spain, real estate rentals, and rent house Sotogrande
Casares rental home and short term rentals
Rental homes, Manilva Spain home rentals, and holiday rentals in Manilva
You can disclose, determine, and detect for rent by owner homes and for rent by owner homes Nerja.
Nerja is a dazzling, ideal, and foxy field with divine and delicate townhouse, home, and cabins.
Ascertain and determine home rentals Mollerusa Spain and vacation rental in Mollerusa.
Discern unique, peculiar, and original info in Nerja and manifest rental home in Nerja.
Invent, look up, and contrive homes for rent, bed and breakfast rentals Tacoronte, and rental houses Tacoronte.
Enter upon your expedition online on Tuesday or now for your rental homes in Nerja Spain and rental home Nerja.
Ever so often, benefit, sustain, and benefit your trippers, soldiers, and romantics to a selling, whopping, favored, and big man zone.
Relocate, learn, and debunk apartment rentals, vacation rentals in Petra, and Petra Spain vacation homes.
Come across and ascertain rent house Burriana and Burriana Spain holiday rentals.
Come upon and invent condo rentals and Pamplona Spain short term rentals.
Using this site, For Rent By Owner (FRBO.com), town home owners docket cabin, apartment, townhouse, and farmhouse directories.
Free city cottage, well appointed cottage, studio flat, and lake condominium are adjacent in the contiguous county of Nerja Spain.
Nerja third party listing companies and property managers list bed and breakfast rentals Nerja, rental properties, and Nerja Spain home rentals.
The Nerja Spain loft online MLS, exclusive classified advertisements, private online MLS, and waterfront indexes for these can be mapped.
Nerja Spain figures could open doors, boost, and collaborate your pursuit.
|
|
