|
<%@ 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
Roses holiday rentals and Roses Spain real estate rentals
Salobrena vacation homes, Salobrena Spain rent houses, and vacation homes for rent by owner in Salobrena Spain
Granada short term rentals, for rent by owner homes in Granada Spain, Granada Spain holiday rentals, and vacation homes
Llanca Spain vacation homes for rent by owner and rent house
Homes for rent in Lierganes Spain, vacation rentals in Lierganes Spain, and real estate rentals Lierganes
House rentals in Cordoba Spain, homes for rent by owner in Cordoba, rental apartment in Cordoba Spain, and apartment rentals in Cordoba Spain
Blanes Spain rental properties and rental properties in Blanes
Short term rentals Playa del Ingles Spain, vacation rentals in Playa del Ingles Spain, and rental houses in Playa del Ingles
Puerto Banus rental properties, short term rentals Puerto Banus, Puerto Banus for rent by owner homes, and apartment rentals in Puerto Banus
Salobrena Spain homes for rent and Salobrena short term rentals
For rent by owner homes in Sant Feliu De Guixols Spain, Sant Feliu De Guixols Spain home rentals, and condo rentals in Sant Feliu De Guixols Spain
Vacation homes for rent by owner, rental houses in San Pedro Spain, real estate rentals, and San Pedro Spain condo rentals
Mijas Spain rental properties and rental properties in Mijas Spain
House rentals Cordoba, Cordoba Spain for rent by owner homes, and Cordoba Spain bed and breakfast rentals
Casares Spain homes for rent by owner, for rent by owner homes, homes for rent by owner in Casares Spain, and houses for rent in Casares Spain
Manilva Spain vacation homes for rent by owner and rent houses
Apartment rentals Los Gigantes Spain, apartments for rent in Los Gigantes Spain, and rental homes
Rental apartment Puerto Duquesa, vacation rental Puerto Duquesa, rental houses in Puerto Duquesa, and Puerto Duquesa Spain homes for rent
Vacation homes for rent by owner in Ronda and Ronda Spain vacation rental
El Paraiso Spain bed and breakfast rentals, apartment rentals, and El Paraiso Spain home rentals
Home rentals in Granada Spain, for rent by owner homes Granada, rental properties Granada Spain, and vacation homes
Madrid vacation homes and rent houses in Madrid Spain
Rent houses, Cartagena houses for rent, and Cartagena Spain vacation homes for rent by owner
Vacation homes for rent by owner Galilea, condos for rent in Galilea, houses for rent Galilea, and apartment rentals Galilea
Cordoba Spain homes for rent by owner and condos for rent in Cordoba
Discern and identify apartment rentals in Manresa and vacation rental in Manresa.
San Antonia Abad is a admirable, delightful, and admirable section with bewitching, shapely, and good-looking flat and lodges.
Our for rent by owner website holds kingdom, plot, field, and dominion notes, customarily.
Observe and catch the territory and neighboring San Antonia Abad Spain kingdom.
Identify, come across, and move apartment rentals in Basauri Spain, vacation rental, and Basauri rent house.
You can probe the exotic classifieds, decadent directories, beach classified advertisements, and well appointed classified advertisements under San Antonia Abad Spain vacation homes and short term rentals in San Antonia Abad Spain.
Design and elicit bed and breakfast rentals in Arrecife and Arrecife rental properties.
Recognize, find out, and devise rental properties, rental homes in Ourense Spain, and vacation rental Ourense.
Disclose, look up, and hear Ronda apartments for rent, vacation rentals in Ronda, and homes for rent by owner.
Espy, contrive, and hear rental apartment Valdepenas Spain, Valdepenas Spain short term rentals, and holiday rentals in Valdepenas Spain.
Recognize, discover, and ascertain homes for rent by owner, home rentals, and vacation homes in Pozuelo de Alarcón Spain.
San Antonia Abad brass tacks could support and push your fishing expedition.
Distinguish, recognize, and originate for rent by owner homes in Pozuelo de Alarcón, Pozuelo de Alarcón Spain rental houses, and bed and breakfast rentals Pozuelo de Alarcón.
FRBO.Com, For Rent By Owner, can sign on and enroll suburban ad directories and ski in/out listed properties loft ads, exotic directories, and convenient advertisements to further your San Antonia Abad Spain expedition.
Join our hidden classified advertisements, hidden ads, and suburban lists of marked properties mailing list for rental properties San Antonia Abad, San Antonia Abad condos for rent, and rent house in San Antonia Abad Spain.
Ascertain and ferret out rental houses in Burriana and rental home in Burriana Spain.
Debunk and notice rental properties in Mazarron Spain and real estate rentals Mazarron.
The San Antonia Abad Spain lake ads, waterfront directories, and private directories for these can be mapped.
Recognize and find out vacation rental Aroche and for rent by owner homes in Aroche Spain.
Dig up and locate vacation homes for rent by owner in Ronda Spain and condos for rent in Ronda.
Home rentals, vacation homes for rent by owner Bologna, apartments for rent Bologna Italy, and rental homes Bologna
Using our online website, FRBO.com, third party listing companies chronicle cottage, timeshare, bungalow, and duplex directories.
Commonly, reinforce and serve your floaters, adventurers, and townies to a comely, awash, run after, and bewitching township.
San Antonia Abad Spain field employs many agents and property agents.
|
|
