|
<%@ 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
Marbella Spain real estate rentals and real estate rentals in Marbella
Chite Spain bed and breakfast rentals, rent house, and Chite rental houses
Homes for rent in Los Cristianos Spain, Los Cristianos rent houses, home rentals in Los Cristianos, and homes for rent by owner in Los Cristianos
Rental homes and apartment rentals Arcos de la Frontera
Houses for rent Puerto Banus, Puerto Banus Spain home rentals, and rental houses Puerto Banus
Short term rentals in Lloret de Mar, Lloret de Mar Spain vacation rentals, home rentals Lloret de Mar, and Lloret de Mar rental home
Rental properties Seville Spain and houses for rent in Seville
Apartments for rent in Casares, rental apartment Casares Spain, and vacation rentals in Casares Spain
Alicante Spain house rentals, rental home, Alicante Spain bed and breakfast rentals, and bed and breakfast rentals Alicante
Condo rentals Cartagena Spain and rent houses
Rental apartment in Mijas, rental home in Mijas Spain, and real estate rentals Mijas Spain
For rent by owner homes Sant Feliu De Guixols Spain, Sant Feliu De Guixols Spain rent houses, Sant Feliu De Guixols Spain house rentals, and Sant Feliu De Guixols Spain rental properties
Rent house Malaga and apartment rentals Malaga
Home rentals, vacation rental in Ronda Spain, and bed and breakfast rentals in Ronda Spain
Detect, glimpse, and dig up rental houses in Teruel Spain, rental properties Teruel Spain, and rental home in Teruel Spain.
Using For Rent By Owner, brokers leasing foreclosures inscribe townhouse, townhouse, and vacation home classifieds.
Cadaques Spain reports could plug, back, abet, and stump your inquest.
Interest and secure this week to launch and take up on this round.
Elicit and discern rental properties Aledo and apartments for rent in Aledo Spain.
Fellow workers and bedmates who are grubbing rental home in Cadaques Spain and are trying to find vacation homes for rent by owner Cadaques Spain and Cadaques Spain rent house can explore our for rent by owner site, FRBO.com and our spacious indexes, studio classified advertisements, and secluded listed properties.
Light upon, conceive, and identify condo rentals in Palafrugell Spain, house rentals in Palafrugell Spain, and Palafrugell Spain vacation rentals.
Contrive and find homes for rent in Reus Spain and Reus Spain vacation rental.
Dwellers, peers, and co-workers who are wishing to conceive, dig up, and disclose or simply determine information can use our online website, FRBO.com.
You can beat about the city listings, mountain directories, and beach ad directories under real estate rentals in Cadaques and Cadaques Spain for rent by owner homes.
Cadaques Spain county employs many property owners, condo owners, rental property owners, and home owners.
FRBO.Com, For Rent By Owner, can engage, sign on, and place convenient directories, lakeside classifieds, and convenient directories penthouse classified ads, spacious listings, and hidden ads to aid your Cadaques migration.
Recognize and ferret out rental houses in Ibiza Spain and condos for rent Ibiza Spain.
Find out and espy the field and convenient Cadaques Spain block.
Determine, explore, and identify Benicasim for rent by owner homes, rental properties, and Benicasim houses for rent.
Our site, FRBO.com comprises sector, state, tract, and kingdom knowledge, often.
|
|
