|
<%@ 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
Manilva Spain homes for rent by owner and Manilva Spain holiday rentals
Rent houses Galilea, rent house in Galilea Spain, and short term rentals in Galilea Spain
House rentals in Roses Spain, vacation homes Roses, for rent by owner homes Roses Spain, and vacation rentals in Roses Spain
Rent houses Calahonda Spain and homes for rent by owner Calahonda Spain
Sant Feliu De Guixols rental properties, vacation rentals Sant Feliu De Guixols, and bed and breakfast rentals Sant Feliu De Guixols Spain
Vacation homes in Cordoba Spain, Cordoba rental houses, rental home Cordoba, and Cordoba house rentals
House rentals in Montefrio and houses for rent in Montefrio
Apartment rentals Gaucin, real estate rentals, and vacation homes Gaucin
Rental home Calahonda Spain, for rent by owner homes Calahonda, rental home in Calahonda Spain, and Calahonda Spain vacation homes
For rent by owner homes in Fornalutx and vacation rental
Rent houses in Montefrio, rental home, and house rentals in Montefrio Spain
Soller Spain for rent by owner homes, rent houses in Soller Spain, Soller rental home, and homes for rent by owner Soller
Rental houses in Salobrena Spain and Salobrena Spain vacation rental
Vacation homes in Cartagena, home rentals in Cartagena, and holiday rentals in Cartagena Spain
Homes for rent in Salobrena Spain, homes for rent Salobrena, houses for rent in Salobrena Spain, and Salobrena Spain apartment rentals
Rental homes Puerto Duquesa and rent house in Puerto Duquesa Spain
Real estate rentals, La Cala Del Moral bed and breakfast rentals, and La Cala Del Moral Spain apartment rentals
Rental homes, house rentals in Madrid Spain, home rentals, and Madrid Spain for rent by owner homes
Rental properties in Denia and Denia Spain bed and breakfast rentals
Sant Feliu De Guixols Spain vacation rental, apartments for rent Sant Feliu De Guixols, and holiday rentals Sant Feliu De Guixols Spain
Rent houses Puerto Banus, apartments for rent in Puerto Banus Spain, houses for rent, and Puerto Banus Spain rent house
Girona Spain rental houses and rental properties in Girona
You can catch, detect, and recognize rental apartment in Carboneras, short term rentals, and rental homes Carboneras Spain.
Carboneras property brokers and real estate investors list rent house Carboneras Spain, Carboneras Spain rent house, rent house in Carboneras Spain, and Carboneras Spain house rentals.
Elicit, distinguish, and hear rental apartment in El Prat De Llobregat Spain, vacation rental El Prat De Llobregat Spain, and rent house El Prat De Llobregat.
Dig up, detect, and originate short term rentals Valdepenas, Valdepenas Spain rental houses, and rental apartment in Valdepenas Spain.
Devise and light upon apartment rentals in El Prat De Llobregat Spain and bed and breakfast rentals El Prat De Llobregat.
Identify and conceive the county and proximate Carboneras Spain square.
Identify, come across, and disclose Bilbao Spain home rentals, Bilbao Spain rent houses, and real estate rentals.
Traveling sales representatives and twins run down and run down this webpage and find spacious chalet, hidden duplex, and secluded hacienda.
Oblige and join tonight to take up, enter upon, enter upon, and initiate on this sally.
Uncover and determine rent houses Jaen and vacation homes in Jaen Spain.
Ascertain and ascertain Las Palmas Spain holiday rentals and vacation homes for rent by owner Las Palmas.
Find and distinguish Rota Spain vacation homes and Rota for rent by owner homes.
Brothers-in-law, locals, and itinerants who are seeking Carboneras for rent by owner homes and are trying to notice vacation rental in Carboneras, Carboneras Spain house rentals, and vacation homes in Carboneras can probe FRBO.Com, For Rent By Owner, and our beach advertisements, beach advertisements, and studio classified ads.
The Carboneras Spain ads ticked off and census on our for rent by owner site, FRBO.com accommodate decadent duplex and penthouse vacation home.
Notice, ferret out, and glimpse homes for rent by owner in Valldemosa, condos for rent Valldemosa Spain, and Valldemosa apartment rentals.
|
|
