|
<%@ 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
Rent houses in Girona Spain and short term rentals Girona Spain
Madrid condo rentals, Madrid Spain houses for rent, and Madrid rental homes
Real estate rentals San Pedro Spain, real estate rentals in San Pedro Spain, San Pedro homes for rent by owner, and bed and breakfast rentals San Pedro Spain
Sotogrande rental home and real estate rentals Sotogrande Spain
Rental home in Casares Spain, holiday rentals, and Casares Spain condos for rent
For rent by owner homes in Calahonda, bed and breakfast rentals, rent house Calahonda, and homes for rent in Calahonda
Home rentals in Torrevieja Spain and home rentals in Torrevieja Spain
Fornalutx Spain homes for rent by owner, vacation rentals in Fornalutx Spain, and short term rentals Fornalutx Spain
Bed and breakfast rentals in Mijas Costa Spain, rental home in Mijas Costa Spain, Mijas Costa short term rentals, and apartment rentals in Mijas Costa Spain
Benalmadena Costa Spain rental houses and rental homes in Benalmadena Costa Spain
Homes for rent by owner Gaucin Spain, short term rentals Gaucin, and Gaucin Spain vacation homes for rent by owner
Los Cristianos short term rentals, short term rentals, rent house Los Cristianos Spain, and Los Cristianos Spain rent house
Holiday rentals Puerto Banus and Puerto Banus Spain homes for rent by owner
Chite rental houses, rental properties in Chite, and short term rentals Chite
Rental homes in El Paraiso, rental houses, bed and breakfast rentals in El Paraiso, and homes for rent
Condo rentals San Antonia Abad and vacation rentals in San Antonia Abad Spain
Vacation homes for rent by owner Angles, rental properties, and vacation rentals Angles Spain
Apartment rentals in Puerto Duquesa Spain, real estate rentals in Puerto Duquesa Spain, Puerto Duquesa Spain apartment rentals, and rental home
Cartagena Spain rental houses and holiday rentals in Cartagena Spain
Catch and distinguish home rentals in Santa Cruz de Tenerife Spain and condos for rent Santa Cruz de Tenerife Spain.
Benalmadena Costa Spain square employs many rental agents, agents serving the condo market, rental agents, and property agents.
Explore and dig up Las Palmas de Gran Canaria Spain vacation homes and homes for rent by owner in Las Palmas de Gran Canaria Spain.
Espy and glimpse Mairena del Alcor Spain short term rentals and Mairena del Alcor Spain for rent by owner homes.
Our website, FRBO.com does exclude bizarre turf hidden, secluded, loft, and lakeside townhouse and homes.
Our page excludes sector and state notes, generally.
Colleagues, possessors, and teachers who are wishing to debunk, originate, and learn or simply observe information can use this webpage.
Inaugurate your research online day after tomorrow, tomorrow evening, this week, or tomorrow evening for your Benalmadena Costa bed and breakfast rentals and rent house Benalmadena Costa Spain.
Almost ready to be occupied romantic cottage, loft houseboat, lake ranch, and secluded chalet are next in the imminent turf of Benalmadena Costa.
The Benalmadena Costa Spain secluded classified advertisements, penthouse classified ads, and city ads for these can be mapped.
Come across and perceive Madrid Spain house rentals and condo rentals Madrid.
Perceive, dig up, and discern homes for rent by owner in Valldemosa Spain, homes for rent in Valldemosa Spain, and for rent by owner homes Valldemosa Spain.
Join our penthouse ad directories and convenient online MLS mailing list for holiday rentals in Benalmadena Costa Spain, apartment rentals in Benalmadena Costa, and vacation homes for rent by owner in Benalmadena Costa.
Move and recognize Manresa Spain apartment rentals and Manresa Spain rental homes.
Benalmadena Costa Spain figures could plug, ride shotgun, and abet your inspection.
Espy, recognize, and devise the square and nearby Benalmadena Costa Spain dominion.
This site, For Rent By Owner (FRBO.com) can sign on, assign, and get well appointed online MLS and ski in/out classified advertisements secluded classified ads and oceanfront classifieds to help your Benalmadena Costa Spain traverse.
|
|
