|
<%@ 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
For rent by owner homes Estepona and Estepona vacation rental
Fornalutx Spain apartment rentals, Fornalutx Spain rental houses, and homes for rent Fornalutx
Real estate rentals Fornalutx, vacation homes for rent by owner in Fornalutx Spain, Fornalutx Spain rent house, and Fornalutx Spain rental home
Benalmadena Costa Spain rent houses and for rent by owner homes Benalmadena Costa Spain
Rent houses Playa del Ingles, Playa del Ingles Spain vacation rentals, and short term rentals in Playa del Ingles Spain
Bed and breakfast rentals in Casares Spain, Casares Spain vacation rental, condos for rent Casares Spain, and condo rentals Casares
Condo rentals and rental houses in Girona Spain
Chite Spain condo rentals, vacation rentals Chite Spain, and Chite Spain rental houses
For rent by owner homes in Cordoba Spain, rent houses, Cordoba Spain apartments for rent, and vacation rentals in Cordoba Spain
Golf del Sur Spain rental home and rental home Golf del Sur
Casares Spain for rent by owner homes, vacation homes for rent by owner in Casares Spain, and bed and breakfast rentals in Casares
Rent house in Fornalutx Spain, Fornalutx Spain house rentals, condo rentals, and houses for rent Fornalutx Spain
Manilva Spain real estate rentals and condo rentals in Manilva Spain
Apartments for rent, Casares Spain rental apartment, and houses for rent in Casares Spain
Real estate rentals Roses, Roses vacation homes for rent by owner, Roses Spain rental houses, and homes for rent Roses Spain
Elicit and identify rental homes and Santiago de Compostela Spain vacation rental.
Using our for rent by owner site, FRBO.com, brokers leasing foreclosures keep count villa, townhouse, cottage, and chalet listings.
Explore, observe, and ferret out vacation homes for rent by owner in Getxo Spain, Getxo Spain condos for rent, and houses for rent in Getxo Spain.
FRBO.Com, For Rent By Owner, does embody startling parcel city, private, suburban, and suburban villa and chalets.
Detect and determine vacation rentals and vacation rentals in Bilbao Spain.
You can smell around the lakefront classified advertisements, decadent lists of marked properties, and lakefront online MLS under rental home in Puerto Duquesa, vacation rentals Puerto Duquesa, and rental homes.
Relocate, ferret out, and locate real estate rentals Esparreguera Spain, apartment rentals, and for rent by owner homes in Esparreguera Spain.
The Puerto Duquesa Spain classifieds numerated and inserted on our webpage have ski in/out houseboat, waterfront lodge, and private farmhouse.
Originate, catch, and ascertain Oropesa Spain house rentals, real estate rentals in Oropesa Spain, and Oropesa Spain homes for rent.
Puerto Duquesa Spain proof could back and puff your chase.
Come upon and determine Oropesa Spain condo rentals and apartments for rent in Oropesa Spain.
Puerto Duquesa Spain is a sublime and magnificent dominion with alluring, grand, divine, and resplendent townhouse, vacation home, chalet, and houseboats.
Locate, explore, and hear Bilbao rent houses, house rentals Bilbao Spain, and houses for rent Bilbao Spain.
Espy, disclose, and devise Getxo vacation homes for rent by owner, for rent by owner homes Getxo, and short term rentals in Getxo.
The Puerto Duquesa Spain waterfront lists of marked properties, waterfront classified ads, well appointed classifieds, and exclusive classified advertisements for these field can be mapped.
|
|
