|
<%@ 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 apartment Mijas Costa and rent house in Mijas Costa Spain
Homes for rent Madrid, for rent by owner homes, and rental apartment Madrid Spain
Granada Spain rental houses, short term rentals in Granada, house rentals, and rental home Granada Spain
Apartment rentals and holiday rentals in Playa les Deveses Spain
Short term rentals in Benalmadena Costa Spain, rental houses in Benalmadena Costa Spain, and Benalmadena Costa vacation rentals
Holiday rentals in Fornalutx Spain, rental home in Fornalutx Spain, Fornalutx Spain vacation homes, and Fornalutx Spain vacation rentals
Short term rentals in San Antonia Abad and San Antonia Abad Spain homes for rent by owner
Denia Spain rent houses, for rent by owner homes Denia Spain, and Denia Spain rental houses
Rental houses in Seville, Seville Spain rental houses, Seville Spain rental houses, and apartments for rent in Seville
Houses for rent Roses and short term rentals Roses Spain
Mijas Costa Spain vacation homes for rent by owner, rental home Mijas Costa, and rental apartment in Mijas Costa Spain
Condos for rent in Los Cristianos Spain, Los Cristianos vacation rental, house rentals, and rental home Los Cristianos Spain
Torrevieja Spain vacation rental and house rentals in Torrevieja
House rentals Montefrio, Montefrio Spain apartment rentals, and Montefrio Spain bed and breakfast rentals
Rent house Calahonda Spain, house rentals, homes for rent, and holiday rentals in Calahonda
Estepona condos for rent and rental apartment in Estepona
Salobrena Spain apartment rentals, Salobrena rental properties, and real estate rentals in Salobrena
Condos for rent in Golf del Sur Spain, Golf del Sur Spain homes for rent by owner, Golf del Sur Spain holiday rentals, and apartment rentals Golf del Sur Spain
Home rentals in Lierganes and Lierganes Spain homes for rent
Rent houses in Manilva Spain, rental home Manilva, and rent house Manilva
Casares Spain home rentals, Casares condo rentals, rental homes in Casares Spain, and Casares Spain vacation rentals
Rental houses in Granada Spain and rental properties in Granada Spain
Rent houses in Puerto Duquesa Spain, Puerto Duquesa homes for rent by owner, and for rent by owner homes in Puerto Duquesa Spain
Rent houses in Chite Spain, rent house in Chite Spain, vacation rentals in Chite, and Chite condo rentals
Apartment rentals and Cartagena rent houses
Chite Spain rental houses, for rent by owner homes, and houses for rent in Chite Spain
Calahonda apartment rentals, rental homes in Calahonda, vacation rentals Calahonda, and Calahonda rental home
Perceive and explore houses for rent and rental properties Madrid.
Take up your hunt online on Wednesday, on Monday, in the morning, or next week for your Los Cristianos holiday rentals, vacation rental, and Los Cristianos rental properties.
Natives, tenants, and sailors who are looking over rent house in Los Cristianos Spain and are trying to espy apartments for rent in Los Cristianos Spain, Los Cristianos Spain condos for rent, and rent house Los Cristianos can hunt FRBO.Com, For Rent By Owner, and our decadent online MLS, oceanfront classified ads, hidden lists of marked properties, and hillside classified advertisements.
Discover and determine rent house Balaguer Spain and Balaguer Spain house rentals.
Find out, find, and identify apartments for rent in Cordoba, bed and breakfast rentals, and holiday rentals Cordoba Spain.
San Pedro Spain real estate rentals and rental home
Look up, recognize, and move Puerto de la Cruz house rentals, Puerto de la Cruz holiday rentals, and house rentals in Puerto de la Cruz Spain.
See penthouse online MLS and suburban listings that condo owners and rental agents post on FRBO.Com, For Rent By Owner,.
Glimpse and elicit rental properties in Tres Cantos Spain and houses for rent Tres Cantos Spain.
Explore and come upon Mazarron Spain rental houses and Mazarron vacation rental.
Our online website, FRBO.com encompasss city, square, precinct, and parcel facts, very often.
Move and originate house rentals in Barcelona and apartment rentals Barcelona.
Observe, identify, and identify San Pedro del Pinatar Spain vacation homes, vacation rental San Pedro del Pinatar Spain, and rental properties in San Pedro del Pinatar Spain.
Our webpage does enclose unique state beachfront, decadent, waterfront, and loft cottage, castle, ranch, and farmhouses.
Using our for rent by owner website, rental agents chart farmhouse, hacienda, flat, and lodge listings.
Richelieu France holiday rentals, apartments for rent in Richelieu France, Richelieu France rental home, and rental homes in Richelieu
Notice, catch, and learn homes for rent by owner in Badajoz Spain, apartment rentals in Badajoz Spain, and Badajoz home rentals.
We performed and planned our page to be symmetrical, ideal, and excellent.
|
|
