|
<%@ 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
Playa les Deveses Spain vacation homes and rent house in Playa les Deveses Spain
Holiday rentals in Calahonda Spain, real estate rentals, and condo rentals
Sant Feliu De Guixols Spain rent houses, rental apartment in Sant Feliu De Guixols, short term rentals in Sant Feliu De Guixols Spain, and Sant Feliu De Guixols vacation rentals
Salobrena Spain rent houses and houses for rent
Houses for rent San Antonia Abad, rent house San Antonia Abad, and San Antonia Abad homes for rent
Golf del Sur Spain apartment rentals, Golf del Sur apartment rentals, homes for rent, and condos for rent
Puerto Banus condo rentals and Puerto Banus real estate rentals
Homes for rent Barcelona Spain, Barcelona Spain for rent by owner homes, and real estate rentals in Barcelona Spain
Rental houses in Estepona Spain, Estepona homes for rent by owner, vacation rentals, and home rentals Estepona Spain
Rent house in Saifores Spain and short term rentals Saifores
Soller vacation rentals, vacation homes for rent by owner in Soller Spain, and Soller Spain vacation homes for rent by owner
Homes for rent by owner, Ronda rent houses, rental houses in Ronda Spain, and house rentals Ronda
Holiday rentals Manilva and rental apartment in Manilva
Houses for rent in Sant Feliu De Guixols Spain, apartments for rent in Sant Feliu De Guixols, and Sant Feliu De Guixols Spain apartments for rent
La Cala Del Moral Spain vacation rentals, short term rentals in La Cala Del Moral, rental houses, and La Cala Del Moral Spain vacation homes
San Antonia Abad Spain houses for rent and rental apartment in San Antonia Abad Spain
Seville Spain rental apartment, condo rentals in Seville Spain, and vacation rental Seville
Rent house Chite Spain, Chite Spain rental homes, apartment rentals, and Chite Spain holiday rentals
House rentals in Sotogrande and Sotogrande Spain house rentals
Rental houses in Angles Spain, for rent by owner homes in Angles Spain, and apartment rentals Angles Spain
Apartments for rent, condo rentals in Angles Spain, rent house in Angles, and apartment rentals Angles
Rental homes in Salobrena Spain and Salobrena rental home
Rental apartment Gaucin, vacation rentals Gaucin Spain, and rental homes Gaucin Spain
Vacation homes in Granada, rental houses in Granada, Granada Spain homes for rent by owner, and Granada Spain rental homes
Salobrena rental owners, real estate brokers, rental owners, and third party agents list rental apartment in Salobrena Spain, Salobrena Spain rent house, bed and breakfast rentals, and rental home in Salobrena Spain.
Look up, invent, and catch rental apartment Santander Spain, vacation homes Santander, and Santander homes for rent by owner.
Sightseers and subordinates who are raking short term rentals and are trying to invent bed and breakfast rentals in Salobrena and houses for rent in Salobrena Spain can examine our webpage and our resort ads, hidden advertisements, hillside advertisements, and beachfront classified ads.
Discern, move, and dig up Granada Spain house rentals, real estate rentals in Granada Spain, and Granada Spain real estate rentals.
Salobrena Spain is a marvelous, sublime, classy, and admirable section with admirable, beauteous, and magnificent houseboat, farmhouse, and apartments.
Send stunning, alluring, superb, and sightly testimony regarding Salobrena Spain bed and breakfast rentals and Salobrena condos for rent found on this webpage.
Originate and explore rental properties Barcelona Spain and Barcelona for rent by owner homes.
You can invent and design rental apartment in Salobrena Spain, house rentals Salobrena, and rent houses in Salobrena Spain.
Embark on your going-over online in the next few days, day after tomorrow, on Saturday, or next week for your Salobrena apartment rentals, house rentals Salobrena, and for rent by owner homes in Salobrena.
Move and notice Las Palmas for rent by owner homes and Las Palmas Spain vacation rentals.
|
|
