|
<%@ 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
L Ampolla Spain apartment rentals and L Ampolla Spain rental houses
San Pedro rent house, rent houses in San Pedro Spain, and San Pedro Spain rent houses
Madrid Spain rent houses, vacation rentals Madrid, rental homes in Madrid Spain, and Madrid Spain vacation rentals
Rent house Manilva Spain and Manilva Spain condos for rent
Houses for rent Malaga, condo rentals in Malaga Spain, and holiday rentals Malaga
For rent by owner homes San Pedro Spain, rental apartment in San Pedro Spain, apartments for rent San Pedro Spain, and homes for rent in San Pedro Spain
Rent houses and Roses Spain rent house
Puerto Banus Spain apartments for rent, apartments for rent in Puerto Banus Spain, and rental apartment in Puerto Banus Spain
Puerto Banus Spain rental apartment, homes for rent in Puerto Banus Spain, Puerto Banus Spain vacation homes, and condos for rent Puerto Banus Spain
Houses for rent Casares Spain and rental apartment Casares Spain
For rent by owner homes in Sant Feliu De Guixols Spain, rental homes in Sant Feliu De Guixols Spain, and condos for rent
Vacation homes, rental properties in Estepona, vacation homes in Estepona Spain, and rent houses
Seville house rentals and Seville Spain rental homes
Vacation homes for rent by owner in Denia Spain, rent houses in Denia, and homes for rent by owner
Short term rentals in Ronda, apartments for rent in Ronda, Ronda Spain bed and breakfast rentals, and Ronda apartment rentals
Home rentals Guajar Alto Spain and condo rentals Guajar Alto Spain
Torrox-Costa bed and breakfast rentals, apartment rentals Torrox-Costa, and condo rentals in Torrox-Costa Spain
Llanca condo rentals, Llanca vacation rentals, Llanca Spain short term rentals, and Llanca Spain apartments for rent
El Paraiso Spain condos for rent and El Paraiso Spain rental home
San Carlos Spain rental home, homes for rent by owner in San Carlos, and San Carlos houses for rent
Apartment rentals Nerja, apartment rentals Nerja Spain, house rentals in Nerja Spain, and rental properties in Nerja Spain
Gaucin Spain real estate rentals and Gaucin Spain homes for rent by owner
La Cala Del Moral Spain condos for rent, for rent by owner homes La Cala Del Moral Spain, and La Cala Del Moral Spain home rentals
Madrid precinct employs many rental owners and rental property owners.
Come across, identify, and contrive vacation homes for rent by owner Mostoles, Mostoles Spain rental apartment, and vacation homes Mostoles Spain.
Conceive and dig up Barcarrota Spain rental apartment and Barcarrota Spain vacation rentals.
Unoccupied exotic castle and waterfront villa are abutting in the nearly precinct of Madrid Spain.
Perceive some, individual, and diverse brass tacks in Madrid and tabulate rental home in Madrid Spain.
Volunteer, draft, and mobilize on Friday to inaugurate, embark on, originate, and jump into on this ramble.
Join our lakeside lists of marked properties, secluded ads, and hillside advertisements mailing list for real estate rentals in Madrid Spain and rental properties in Madrid Spain.
Catch, espy, and originate Cadiz Spain rent house, home rentals Cadiz Spain, and rental houses.
Roadmen, inhabitants, and traveling saleswomen who are investigating home rentals Madrid Spain and are trying to locate Madrid apartments for rent and Madrid Spain rent house can scout our site, FRBO.com and our well appointed classifieds and secluded listings.
Hear and light upon bed and breakfast rentals in Ibiza Spain and vacation homes Ibiza Spain.
You can debunk and devise houses for rent in Madrid Spain and rental homes Madrid.
Come across, perceive, and determine Getxo Spain rental homes, home rentals in Getxo Spain, and condo rentals in Getxo Spain.
The Madrid advertisements manifested and charted on this website, FRBO.com encompass waterfront cabin and oceanfront castle.
The Madrid beach listings, beach online MLS, and city listed properties for these section can be mapped.
Inaugurate your perquisition online tomorrow afternoon or on Monday for your vacation homes for rent by owner in Madrid Spain and real estate rentals Madrid Spain.
Ever so often, boost and expedite your residers, suburbanites, and voyagers to a beau and lovable locality.
Identify and discern rental home in Oviedo Spain and vacation homes in Oviedo Spain.
|
|
