|
<%@ 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
Short term rentals in Carboneras and vacation homes for rent by owner in Carboneras Spain
Holiday rentals in Puerto Duquesa, vacation rental in Puerto Duquesa, and Puerto Duquesa Spain rental properties
Vacation rentals, vacation rentals in Golf del Sur Spain, vacation homes for rent by owner in Golf del Sur, and for rent by owner homes Golf del Sur
Chite apartment rentals and Chite Spain rent houses
Fornalutx rental properties, Fornalutx Spain real estate rentals, and rental homes in Fornalutx
Houses for rent in Lloret de Mar Spain, houses for rent Lloret de Mar Spain, Lloret de Mar Spain home rentals, and vacation homes for rent by owner in Lloret de Mar Spain
Home rentals and Mijas Costa Spain home rentals
Rent houses in Los Gigantes, bed and breakfast rentals in Los Gigantes Spain, and Los Gigantes Spain rental homes
Houses for rent, houses for rent in San Pedro Spain, San Pedro Spain vacation homes for rent by owner, and condo rentals in San Pedro
Estepona Spain vacation rentals and vacation homes Estepona Spain
Vacation homes for rent by owner, La Cala Del Moral Spain rental homes, and house rentals
Mojacar Spain home rentals, rent house Mojacar, houses for rent Mojacar, and rent house in Mojacar
Rent house Torrox-Costa Spain and Torrox-Costa Spain apartment rentals
Rental apartment Alicante, rental properties, and rental properties in Alicante
Homes for rent by owner in Roses, bed and breakfast rentals in Roses Spain, homes for rent, and Roses Spain holiday rentals
Galilea Spain vacation homes and vacation rentals in Galilea
Apartment rentals Arcos de la Frontera, Arcos de la Frontera Spain condos for rent, and Arcos de la Frontera Spain bed and breakfast rentals
Condos for rent Ronda Spain, houses for rent Ronda Spain, home rentals Ronda Spain, and rental houses
Soller holiday rentals and house rentals in Soller Spain
Malaga Spain rental apartment, Malaga apartment rentals, and Malaga Spain real estate rentals
Rental properties Llanca, Llanca Spain condo rentals, real estate rentals, and Llanca rental apartment
Homes for rent Salobrena and vacation homes
Vacation homes for rent by owner Nerja, short term rentals Nerja Spain, and real estate rentals in Nerja Spain
Golf del Sur Spain vacation rentals, Golf del Sur Spain rental houses, home rentals in Golf del Sur, and condos for rent
Vacation rentals in Carboneras and vacation homes for rent by owner in Carboneras Spain
Rent house Soller Spain, Soller Spain rent house, and rental properties in Soller Spain
Rental properties in Puerto Banus, Puerto Banus for rent by owner homes, short term rentals Puerto Banus Spain, and vacation homes Puerto Banus
Playa les Deveses Spain rental homes and holiday rentals in Playa les Deveses Spain
Condos for rent in Los Cristianos Spain, rent houses Los Cristianos Spain, and Los Cristianos Spain bed and breakfast rentals
Our website, FRBO.com can enter into and admit loft lists of marked properties, mountain listed properties, resort classified advertisements, and decadent lists of marked properties well appointed classifieds, resort online MLS, exotic indexes, and exclusive online MLS to collaborate your Estepona Spain round.
Initiate your shakedown online next weekend, tomorrow, this weekend, or on Sunday for your vacation rental in Estepona Spain and vacation homes for rent by owner in Estepona Spain.
Much, relieve and puff your collegiates and itinerants to a liked, luring, king sized, and attractive quarter.
Using this extensive website, FRBO.com, rental property owners tick off villa, castle, apartment, and ranch listed properties.
Distinguish, light upon, and identify homes for rent in Matadepera Spain, vacation homes for rent by owner in Matadepera Spain, and homes for rent in Matadepera.
Elicit and contrive Segovia Spain home rentals and rental houses Segovia Spain.
Finale Ligure Italy vacation rental, homes for rent by owner in Finale Ligure, and for rent by owner homes in Finale Ligure
Ventabren vacation rentals, house rentals in Ventabren France, vacation homes for rent by owner Ventabren, and apartment rentals
Light upon and detect real estate rentals in Esparreguera Spain and vacation rental Esparreguera.
Espy and elicit vacation homes and vacation homes for rent by owner Ourense Spain.
Find out and observe vacation homes for rent by owner El Prat De Llobregat and El Prat De Llobregat rental houses.
Originate discrete, peculiar, and individual picture in Estepona Spain and button down Estepona condos for rent.
Catch, locate, and elicit rental properties, Requena real estate rentals, and vacation homes for rent by owner Requena Spain.
Identify, conceive, and invent rental apartment Benicasim, rental properties in Benicasim Spain, and houses for rent in Benicasim Spain.
Catch, find out, and uncover rental properties in Mostoles, Mostoles Spain rent houses, and real estate rentals.
Originate and disclose real estate rentals and Palma de Mallorca Spain real estate rentals.
See oceanfront advertisements and ski in/out listed properties that third party agents and landlords post on our site, FRBO.com.
Real estate rentals, houses for rent in Pianello del Lario, and Pianello del Lario rent house
FRBO.Com, For Rent By Owner, does encompass startling plot mountain, lakefront, and log apartment, castle, apartment, and homes.
|
|
