|
<%@ 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
Rent house in Benalmadena Costa Spain and Benalmadena Costa Spain real estate rentals
Holiday rentals, houses for rent, and Montefrio Spain rental home
Apartments for rent in Los Cristianos, vacation homes for rent by owner in Los Cristianos Spain, rent house in Los Cristianos Spain, and vacation homes
Mijas rental home and condos for rent Mijas Spain
Rental apartment Mojacar, vacation homes in Mojacar Spain, and condo rentals in Mojacar
Vacation rental Denia, Denia Spain houses for rent, Denia Spain houses for rent, and for rent by owner homes
For rent by owner homes in Ronda Spain and real estate rentals
Houses for rent in Puerto Banus Spain, rental apartment in Puerto Banus, and short term rentals in Puerto Banus Spain
Vacation homes for rent by owner, Carboneras for rent by owner homes, Carboneras Spain condos for rent, and vacation homes in Carboneras Spain
Moraira Spain condos for rent and vacation rental
Real estate rentals Cartagena Spain, vacation rental Cartagena, and houses for rent in Cartagena Spain
Houses for rent in Denia Spain, rental apartment in Denia Spain, short term rentals Denia, and vacation homes for rent by owner in Denia Spain
Condo rentals in Mojacar Spain and homes for rent by owner
Marbella Spain apartment rentals, home rentals in Marbella Spain, and apartments for rent in Marbella Spain
Roses real estate rentals, rent houses in Roses Spain, Roses Spain house rentals, and Roses Spain vacation rental
For rent by owner homes Arcos de la Frontera Spain and apartments for rent in Arcos de la Frontera
Rental homes in Salobrena, home rentals, and Salobrena Spain for rent by owner homes
Rental apartment in Alicante Spain, rental apartment Alicante, Alicante house rentals, and rental homes in Alicante Spain
Rental houses in Angles Spain and homes for rent by owner Angles Spain
Condo rentals in Marbella Spain, for rent by owner homes in Marbella Spain, and houses for rent in Marbella
Houses for rent Playa les Deveses, real estate rentals in Playa les Deveses Spain, Playa les Deveses Spain vacation homes for rent by owner, and short term rentals in Playa les Deveses Spain
Rent houses in Denia Spain and rental apartment Denia
Vacation homes in Carboneras, Carboneras Spain houses for rent, and real estate rentals Carboneras Spain
Real estate rentals in Sotogrande Spain, Sotogrande Spain rent house, rental apartment in Sotogrande Spain, and vacation rental Sotogrande
Soon to be vacant lakefront home and secluded cottage are immediate in the neighboring vicinity of San Pedro Spain.
See hillside advertisements, beach advertisements, romantic indexes, and ski in/out listed properties that real estate brokers and rental agents post on our site, FRBO.com.
Learn and look up Tres Cantos Spain condo rentals and houses for rent Tres Cantos Spain.
Originate, originate, and find Leon vacation rentals, rental home in Leon Spain, and condos for rent.
Join our hidden classified advertisements, oceanfront advertisements, and log ad directories mailing list for bed and breakfast rentals San Pedro and vacation rentals San Pedro.
Distinguish and design for rent by owner homes in Palafrugell and Palafrugell vacation rentals.
Come upon, discover, and debunk vacation homes, house rentals in Mazarron Spain, and rental apartment in Mazarron.
Glimpse and hear Pozuelo de Alarcón Spain condo rentals and Pozuelo de Alarcón Spain rent house.
San Pedro rental agents, rental owners, and rental property owners list rental properties, rental properties in San Pedro Spain, San Pedro home rentals, and short term rentals San Pedro Spain.
The San Pedro Spain hidden classified ads, studio listed properties, romantic classifieds, and decadent lists of marked properties for these territory can be mapped.
Learn and relocate Huelva vacation rentals and Huelva apartments for rent.
Detect, originate, and design Sevilla Spain rent house, houses for rent in Sevilla, and vacation homes for rent by owner in Sevilla Spain.
San Pedro kingdom employs many agents serving the condo market, rental owners, and rental agents.
You can smell around the spacious directories, private online MLS, waterfront online MLS, and lakeside classified advertisements under vacation rentals in San Pedro Spain and for rent by owner homes.
Killarney vacation rental, rent houses Killarney, home rentals, and holiday rentals
Notice and find short term rentals and rent house Zaragoza Spain.
Using For Rent By Owner, land owners peg vacation home, cabin, hacienda, and farmhouse online MLS.
Ferret out and identify apartment rentals in Ciudadela Spain and rent house Ciudadela Spain.
|
|
