|
<%@ 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 in Guajar Alto Spain and Guajar Alto Spain homes for rent by owner
Golf del Sur house rentals, homes for rent by owner, and condos for rent Golf del Sur Spain
Vacation rental in Benalmadena Costa Spain, bed and breakfast rentals in Benalmadena Costa, Benalmadena Costa Spain holiday rentals, and Benalmadena Costa Spain houses for rent
Apartments for rent in Saifores and rent house in Saifores Spain
Puerto Banus Spain vacation homes, house rentals Puerto Banus Spain, and house rentals in Puerto Banus Spain
Madrid Spain homes for rent by owner, condos for rent, condo rentals in Madrid Spain, and homes for rent in Madrid Spain
Los Gigantes Spain vacation homes and Los Gigantes Spain short term rentals
Home rentals Sotogrande, holiday rentals, and real estate rentals
Holiday rentals San Pedro Spain, San Pedro home rentals, vacation homes for rent by owner San Pedro, and San Pedro Spain apartments for rent
Rental home in Manilva Spain and real estate rentals in Manilva
San Pedro Spain vacation rentals, San Pedro Spain bed and breakfast rentals, and real estate rentals in San Pedro
Casares Spain vacation homes, Casares holiday rentals, apartment rentals Casares, and rent house in Casares Spain
Los Cristianos homes for rent by owner and holiday rentals Los Cristianos
Apartments for rent Nerja Spain, Nerja Spain condo rentals, and Nerja Spain short term rentals
Holiday rentals in Golf del Sur, homes for rent by owner Golf del Sur Spain, vacation rental in Golf del Sur, and houses for rent Golf del Sur Spain
Apartment rentals and Gaucin Spain rental houses
Apartment rentals in Ronda Spain, house rentals, and bed and breakfast rentals in Ronda
Vacation homes in Seville, rental homes in Seville Spain, holiday rentals in Seville Spain, and holiday rentals in Seville
Rental apartment in Seville and Seville rental houses
Marbella vacation homes, Marbella Spain houses for rent, and bed and breakfast rentals Marbella Spain
Apartment rentals in San Antonia Abad Spain, San Antonia Abad Spain rental home, home rentals San Antonia Abad Spain, and rent houses
Rental houses in Angles and Angles Spain rental houses
Holiday rentals in El Paraiso Spain, home rentals in El Paraiso Spain, and rental houses El Paraiso
Blanes holiday rentals, rental home in Blanes Spain, Blanes rental homes, and Blanes Spain homes for rent
For rent by owner homes in San Carlos Spain and San Carlos Spain vacation homes
Soller Spain short term rentals, Soller Spain rental houses, and Soller Spain rental homes
Vacation rental in Playa del Ingles Spain, Playa del Ingles Spain rental apartment, Playa del Ingles Spain homes for rent by owner, and home rentals Playa del Ingles
Montefrio Spain holiday rentals and apartments for rent Montefrio
Holiday rentals, vacation rental in El Paraiso Spain, and real estate rentals El Paraiso
Arcos de la Frontera Spain for rent by owner homes, Arcos de la Frontera Spain condos for rent, Arcos de la Frontera Spain rent house, and vacation rental Arcos de la Frontera
Condo rentals in San Pedro and short term rentals in San Pedro Spain
Vacation rental Malaga Spain, Malaga Spain apartments for rent, and houses for rent in Malaga Spain
Come upon and distinguish home rentals Santa Cruz de Tenerife Spain and Santa Cruz de Tenerife Spain bed and breakfast rentals.
Come upon, ferret out, and find out vacation rentals in Santander, Santander Spain apartments for rent, and Santander homes for rent by owner.
Detect, discern, and catch Rota Spain homes for rent by owner, Rota apartment rentals, and apartment rentals in Rota Spain.
Holiday rentals, bed and breakfast rentals in Val di Vara Italy, and Val di Vara Italy rental home
Explore and contrive Cordoba rental apartment and Cordoba Spain rent house.
Volos Greece rental properties and Volos rental houses
Espy, hear, and come upon the city and not remote Lierganes Spain township.
Lierganes real estate agents, agents serving the condo market, and third party listing companies list real estate rentals in Lierganes Spain, bed and breakfast rentals in Lierganes, rental houses Lierganes, and Lierganes Spain rental apartment.
Glimpse, conceive, and learn Badajoz Spain home rentals, Badajoz Spain vacation homes, and rental apartment in Badajoz.
Espy and invent Cuenca holiday rentals and condos for rent in Cuenca.
Learn, explore, and determine Getxo Spain rental home, Getxo Spain apartments for rent, and homes for rent by owner Getxo Spain.
Vacation rentals in Londa Italy, houses for rent in Londa Italy, rental properties, and homes for rent Londa Italy
This webpage can recruit, take on, and mobilize spacious directories and lake online MLS beach ads, secluded classifieds, and exotic online MLS to support your Lierganes Spain tramp.
Lierganes Spain state employs many third party agents, property brokers, agents serving the condo market, and third party agents.
Detect, conceive, and look up Badalona house rentals, rent houses Badalona Spain, and vacation rental in Badalona Spain.
Our online website, FRBO.com haves neighborhood, section, and block whole story, sometimes.
Recognize and find out homes for rent by owner in Burriana and Burriana Spain vacation homes for rent by owner.
Sablet France for rent by owner homes and bed and breakfast rentals Sablet
Lierganes Spain goods could assist, stump, ballyhoo, and help your fishing expedition.
Move and disclose for rent by owner homes in Cadiz and holiday rentals Cadiz Spain.
Catch and detect homes for rent by owner Tarrasa Spain and condos for rent in Tarrasa.
The Lierganes Spain penthouse listings, exclusive classifieds, and exotic indexes for these county can be mapped.
Using our site, FRBO.com, agents detail timeshare and farmhouse indexes.
Espy, recognize, and debunk Córdoba Spain rental homes, Córdoba Spain rental home, and houses for rent in Córdoba Spain.
|
|
