|
<%@ 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 properties Torrox-Costa Spain and rental homes Torrox-Costa
Holiday rentals Estepona Spain, Estepona real estate rentals, and Estepona Spain rental home
Homes for rent in Mojacar Spain, homes for rent by owner in Mojacar Spain, vacation homes for rent by owner in Mojacar, and Mojacar Spain rent house
Rent house in Torrevieja Spain and rent houses Torrevieja Spain
Houses for rent Playa del Ingles Spain, houses for rent in Playa del Ingles Spain, and Playa del Ingles Spain bed and breakfast rentals
Rental homes Mijas Costa, rent house in Mijas Costa Spain, Mijas Costa rental apartment, and Mijas Costa Spain real estate rentals
Madrid Spain rental properties and vacation rentals in Madrid
Rental apartment in Puerto Duquesa, condos for rent in Puerto Duquesa, and vacation rentals Puerto Duquesa
Los Gigantes homes for rent by owner, homes for rent in Los Gigantes Spain, Los Gigantes Spain rental properties, and house rentals in Los Gigantes Spain
Mijas Costa Spain apartment rentals and rent house in Mijas Costa
Home rentals San Carlos, homes for rent by owner, and rental homes
Ronda Spain vacation rentals, Ronda rental apartment, for rent by owner homes, and Ronda Spain homes for rent
Vacation rentals Seville Spain and vacation homes for rent by owner in Seville Spain
Rental homes, for rent by owner homes Alicante, and vacation rentals Alicante Spain
Vacation homes Moraira Spain, rent houses Moraira Spain, rental properties Moraira, and rent houses in Moraira Spain
Puerto Duquesa Spain vacation homes and rent house in Puerto Duquesa Spain
El Paraiso Spain holiday rentals, El Paraiso Spain rental houses, and home rentals El Paraiso Spain
Homes for rent by owner Montefrio, vacation homes, rental houses, and holiday rentals in Montefrio Spain
Playa les Deveses rental houses and Playa les Deveses Spain rental properties
Homes for rent by owner, home rentals Estepona Spain, and short term rentals Estepona Spain
Gaucin Spain houses for rent, apartments for rent Gaucin Spain, vacation rentals in Gaucin Spain, and bed and breakfast rentals in Gaucin Spain
Short term rentals in Los Cristianos Spain and Los Cristianos short term rentals
Mojacar short term rentals, holiday rentals Mojacar, and rental home Mojacar
Condo rentals Los Gigantes, holiday rentals, Los Gigantes Spain real estate rentals, and rental houses in Los Gigantes Spain
Alicante Spain rent house and apartment rentals in Alicante
Casares homes for rent, vacation homes in Casares Spain, and apartments for rent in Casares
Vacation homes for rent by owner in Madrid Spain, rent houses in Madrid Spain, vacation rentals Madrid, and Madrid condos for rent
Homes for rent and rental houses in Cartagena Spain
Short term rentals L Ampolla, vacation homes for rent by owner L Ampolla Spain, and L Ampolla Spain condo rentals
Light upon, detect, and identify short term rentals in Palma de Mallorca Spain, Palma de Mallorca condos for rent, and house rentals Palma de Mallorca Spain.
Identify, devise, and look up bed and breakfast rentals Reus, vacation rental Reus Spain, and vacation rental Reus Spain.
Disclose and uncover apartment rentals and Benicasim rental apartment.
Get cracking your inspection online on Thursday, this weekend, or on Sunday for your apartment rentals in Sotogrande, condos for rent in Sotogrande Spain, and Sotogrande vacation homes.
Dig up, find out, and disclose house rentals Madrid Spain, Madrid Spain rental home, and rental homes.
Short term rentals and Galilea Spain houses for rent
Pre-rented lakeside home, decadent villa, suburban farmhouse, and convenient ranch are not remote in the not far away quarter of Sotogrande Spain.
Relocate and distinguish vacation homes in Torrevieja Spain and homes for rent by owner.
The Sotogrande beachfront classified advertisements and log online MLS for these block can be mapped.
Sotogrande Spain neighborhood employs many home owners, real estate brokers, third party listing companies, and brokers leasing foreclosures.
Condo rentals in Salobrena and rental properties in Salobrena Spain
Determine and recognize Sabadell Spain rental home and condo rentals Sabadell Spain.
You can look over the lakeside classifieds, waterfront indexes, waterfront online MLS, and log ads under apartment rentals Sotogrande, Sotogrande Spain real estate rentals, and Sotogrande Spain rent house.
Adventurers, renters, and opportunists who are wishing to identify, identify, and recognize or simply observe information can use our for rent by owner site, FRBO.com.
Perceive, ascertain, and catch vacation homes for rent by owner in Balaguer, vacation homes for rent by owner Balaguer Spain, and apartments for rent Balaguer Spain.
For Rent By Owner does enclose particular convenient, well appointed, and lakefront hacienda, cottage, and condominiums.
Tremezzo Italy homes for rent, Tremezzo Italy homes for rent by owner, Tremezzo Italy houses for rent, and rental properties in Tremezzo Italy
You can light upon and explore Sotogrande Spain rental properties, apartments for rent, and Sotogrande Spain real estate rentals.
|
|
