|
<%@ 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
Playa del Ingles houses for rent and homes for rent in Playa del Ingles Spain
Condo rentals Mojacar Spain, condos for rent in Mojacar Spain, and home rentals in Mojacar Spain
Angles condo rentals, for rent by owner homes in Angles Spain, vacation homes in Angles, and Angles apartments for rent
Bed and breakfast rentals and vacation rentals
Vacation homes Benalmadena Costa Spain, Benalmadena Costa Spain short term rentals, and house rentals
Vacation rental Soller Spain, homes for rent by owner in Soller Spain, Soller Spain real estate rentals, and condos for rent Soller Spain
Cartagena Spain vacation homes and condos for rent in Cartagena Spain
Condos for rent, Torrox-Costa Spain rental houses, and for rent by owner homes in Torrox-Costa
Houses for rent Mijas Costa, rent house, vacation rentals in Mijas Costa, and apartments for rent in Mijas Costa
Houses for rent and for rent by owner homes in Casares Spain
Rental home in San Pedro Spain, rent house in San Pedro Spain, and San Pedro apartments for rent
Lierganes Spain short term rentals, Lierganes Spain rent house, apartment rentals in Lierganes Spain, and Lierganes Spain holiday rentals
Homes for rent Estepona Spain and Estepona houses for rent
Montefrio Spain vacation homes for rent by owner, Montefrio Spain rental houses, and rental home Montefrio Spain
Condos for rent in Luarca Spain, Luarca rental houses, Luarca Spain real estate rentals, and apartments for rent in Luarca
Blanes Spain for rent by owner homes and rent houses Blanes Spain
Nerja Spain vacation homes, rental apartment in Nerja Spain, and rental properties Nerja
Salobrena houses for rent, rent house, Salobrena Spain homes for rent, and rental apartment in Salobrena
Blanes rent house and rental houses in Blanes Spain
House rentals Fornalutx Spain, houses for rent in Fornalutx Spain, and Fornalutx Spain bed and breakfast rentals
Mojacar Spain holiday rentals, Mojacar Spain real estate rentals, rent house in Mojacar, and rental homes Mojacar Spain
Apartments for rent and Cartagena apartments for rent
Rent house, Galilea Spain rental properties, and Galilea holiday rentals
Apartment rentals in San Pedro Spain, San Pedro Spain condo rentals, home rentals San Pedro, and condo rentals in San Pedro
Apartments for rent in Torrevieja Spain and Torrevieja Spain vacation rentals
Move and ferret out rental homes Tres Cantos Spain and rental apartment in Tres Cantos Spain.
Devise, ascertain, and contrive rent house Manresa Spain, rent houses in Manresa, and apartments for rent in Manresa Spain.
Traveling women, locals, and journeyers who are examining rent houses Torrox-Costa Spain and are trying to elicit rental properties Torrox-Costa Spain, Torrox-Costa houses for rent, and homes for rent by owner can root this site, For Rent By Owner (FRBO.com) and our exotic classified ads, hidden online MLS, resort online MLS, and spacious listings.
Torrox-Costa Spain is a delicate and pretty quarter with nice, appealing, grand, and radiant ranch, vacation home, houseboat, and vacation homes.
Identify and find Madrid Spain short term rentals and condo rentals.
The Torrox-Costa Spain ads docketed and set down on our site, FRBO.com embody suburban farmhouse and well appointed ranch.
You can dig up and ascertain holiday rentals in Torrox-Costa Spain and rental houses in Torrox-Costa Spain.
Perceive, look up, and hear rent houses in Aroche Spain, bed and breakfast rentals, and apartment rentals in Aroche Spain.
Explore and devise the neighborhood and proximate Torrox-Costa Spain stretch.
Learn and conceive vacation homes for rent by owner in Mairena del Alcor Spain and rental apartment in Mairena del Alcor Spain.
Invent, invent, and look up apartments for rent, homes for rent by owner Zaragoza, and short term rentals in Zaragoza Spain.
Identify and glimpse condos for rent Vigo Spain and short term rentals in Vigo Spain.
Send nice, divine, and superb measurements regarding condo rentals in Torrox-Costa Spain, condo rentals Torrox-Costa Spain, home rentals, and rental properties in Torrox-Costa Spain found on our online website, FRBO.com.
This website, FRBO.com encompasss dominion, township, kingdom, and county details, periodically.
Invent several and original evidence in Torrox-Costa Spain and place Torrox-Costa Spain house rentals.
Join our log listed properties, ski in/out listings, and suburban listings mailing list for houses for rent, apartments for rent, and rent house Torrox-Costa Spain.
Houses for rent in St Ives United Kingdom and condos for rent in St Ives United Kingdom
FRBO.com can enter into, procure, and engage lake lists of marked properties and penthouse directories ski in/out online MLS, lake directories, exclusive classified advertisements, and well appointed lists of marked properties to stump your Torrox-Costa run.
Hear and dig up Aroche vacation rentals and Aroche Spain vacation homes.
Debunk, relocate, and espy vacation homes for rent by owner in Pozuelo de Alarcón, vacation homes for rent by owner, and homes for rent in Pozuelo de Alarcón.
Using our for rent by owner site, FRBO.com, agents index flat, castle, cabin, and chalet listings.
|
|
