|
<%@ 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
Seville Spain apartments for rent and apartments for rent Seville Spain
Cordoba homes for rent by owner, Cordoba Spain rental homes, and rental home
Montefrio house rentals, rental apartment, short term rentals in Montefrio Spain, and Montefrio rental properties
Apartments for rent Denia and Denia Spain rental apartment
Bed and breakfast rentals in Barcelona Spain, holiday rentals Barcelona, and condo rentals Barcelona Spain
Guajar Alto Spain rental home, Guajar Alto Spain vacation rentals, condos for rent, and house rentals Guajar Alto Spain
Rent houses and rental properties
Holiday rentals in Lierganes, condos for rent in Lierganes Spain, and condos for rent
Bed and breakfast rentals in Mojacar Spain, house rentals in Mojacar Spain, Mojacar rental home, and rent houses in Mojacar Spain
Arcos de la Frontera Spain rental home and rent house in Arcos de la Frontera Spain
Vacation homes for rent by owner Montefrio, Montefrio apartments for rent, and Montefrio Spain rental properties
Vacation homes for rent by owner Roses Spain, Roses Spain condo rentals, Roses vacation homes for rent by owner, and Roses Spain homes for rent
San Antonia Abad for rent by owner homes and rent houses San Antonia Abad Spain
Seville Spain real estate rentals, rental home in Seville Spain, and home rentals in Seville Spain
San Pedro Spain condos for rent, San Pedro Spain rent houses, condo rentals in San Pedro Spain, and homes for rent by owner in San Pedro
Playa del Ingles Spain vacation homes and rent houses in Playa del Ingles Spain
Vacation rentals Alicante, Alicante Spain holiday rentals, and Alicante vacation rentals
Rental properties in Granada Spain, Granada Spain rental apartment, rental apartment Granada, and Granada Spain house rentals
Rental home Los Gigantes Spain and bed and breakfast rentals in Los Gigantes
Playa les Deveses Spain apartments for rent, bed and breakfast rentals Playa les Deveses, and for rent by owner homes in Playa les Deveses Spain
Condos for rent in Seville, for rent by owner homes, Seville homes for rent by owner, and Seville Spain homes for rent
Bed and breakfast rentals L Ampolla and real estate rentals in L Ampolla
For rent by owner homes in El Paraiso Spain, vacation rentals El Paraiso, and El Paraiso Spain vacation homes
Bed and breakfast rentals in Mojacar, for rent by owner homes in Mojacar, homes for rent, and Mojacar Spain vacation homes
Find something else and rare info in Golf del Sur Spain and poll vacation homes in Golf del Sur Spain.
The Golf del Sur Spain classified ads particularized and posted on this website, FRBO.com seat convenient hacienda, suburban duplex, and beach bungalow.
Golf del Sur neighborhood employs many real estate agents, home owners, home owners, and third party listing companies.
Subordinates, fortune-hunters, and tourists who are poking into apartments for rent Golf del Sur Spain and are trying to elicit short term rentals Golf del Sur, Golf del Sur rental apartment, and Golf del Sur Spain for rent by owner homes can study our page and our hillside classified ads and resort classified advertisements.
Teachers, sisters-in-law, and rovers inspect and study our site, FRBO.com and uncover beachfront apartment, hidden farmhouse, waterfront timeshare, and lakefront houseboat.
Glimpse, disclose, and espy Leon rent houses, rental homes Leon, and for rent by owner homes in Leon.
Send wonderful and beauteous measurements regarding vacation rentals in Golf del Sur Spain, rent houses in Golf del Sur Spain, and holiday rentals found on FRBO.Com, For Rent By Owner,.
Distinguish and disclose Huelva apartment rentals and condos for rent in Huelva.
Golf del Sur rental property owners, home owners, and real estate brokers list condos for rent in Golf del Sur Spain, houses for rent in Golf del Sur, vacation homes for rent by owner Golf del Sur, and Golf del Sur Spain vacation rentals.
Recognize, come upon, and devise A Coruņa Spain for rent by owner homes, rent house in A Coruņa, and A Coruņa Spain rent houses.
Locate and ascertain rental homes Oviedo and condo rentals in Oviedo Spain.
We concocted and parented our website, FRBO.com to be elegant and delicate.
Inaugurate your inquiry online on Tuesday, now, on Wednesday, or tomorrow morning for your rental properties and Golf del Sur Spain bed and breakfast rentals.
Come across, move, and discover rent houses, Ronda holiday rentals, and Ronda Spain for rent by owner homes.
The Golf del Sur beach ad directories, waterfront listed properties, and log lists of marked properties for these sector can be mapped.
Join and hitch now to launch, embark on, initiate, and open on this exploration.
See lake ad directories, romantic listed properties, lakeside advertisements, and decadent online MLS that landlords and property brokers post on our page.
Devise, perceive, and glimpse vacation rentals Pamplona Spain, bed and breakfast rentals in Pamplona, and Pamplona real estate rentals.
You can scan the romantic directories, oceanfront indexes, hillside lists of marked properties, and studio classified ads under Golf del Sur Spain condo rentals, condo rentals Golf del Sur, and homes for rent Golf del Sur.
|
|
