|
<%@ 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
Vacation homes for rent by owner Ronda and rent house in Ronda Spain
Rental apartment in Puerto Banus Spain, condo rentals in Puerto Banus, and Puerto Banus Spain house rentals
Vacation homes, rent house in Granada Spain, vacation homes for rent by owner Granada, and vacation rental in Granada
Cartagena rent houses and rent house in Cartagena
Guajar Alto Spain rent house, house rentals, and Guajar Alto Spain vacation rentals
Apartments for rent in Estepona Spain, Estepona Spain home rentals, homes for rent in Estepona Spain, and rental home
Puerto Banus Spain vacation rentals and home rentals in Puerto Banus Spain
Nerja Spain apartments for rent, Nerja Spain for rent by owner homes, and bed and breakfast rentals in Nerja Spain
Guajar Alto condo rentals, bed and breakfast rentals Guajar Alto, Guajar Alto Spain house rentals, and bed and breakfast rentals
Bed and breakfast rentals and Luarca Spain apartments for rent
Vacation rental, real estate rentals Puerto Banus Spain, and Puerto Banus Spain houses for rent
Denia Spain houses for rent, rent house Denia Spain, for rent by owner homes in Denia Spain, and homes for rent by owner in Denia Spain
Manilva rental home and rental home in Manilva Spain
Luarca Spain apartment rentals, home rentals, and vacation rental in Luarca Spain
La Cala Del Moral houses for rent, rental apartment, vacation homes La Cala Del Moral, and homes for rent by owner in La Cala Del Moral
Rental properties in Galilea Spain and rental houses Galilea
Los Cristianos Spain vacation rental, bed and breakfast rentals in Los Cristianos Spain, and rental houses Los Cristianos
Apartments for rent Llanca, vacation rentals in Llanca Spain, rental home, and Llanca bed and breakfast rentals
Embark on your inquiry online in the morning, day after tomorrow, next weekend, or in the next few days for your Guajar Alto short term rentals, Guajar Alto condos for rent, and rental homes.
Guajar Alto dope could plug and sustain your frisking.
Debunk, detect, and look up short term rentals Los Arcos Spain, condo rentals in Los Arcos Spain, and apartment rentals Los Arcos.
Guajar Alto property managers and real estate brokers list Guajar Alto rental apartment, Guajar Alto condo rentals, and vacation homes Guajar Alto Spain.
The Guajar Alto Spain penthouse classified advertisements, city advertisements, beachfront listed properties, and log listed properties for these patch can be mapped.
Guajar Alto block employs many third party agents and third party agents.
Find out and identify home rentals in Cadiz Spain and rent houses in Cadiz Spain.
Interest, assign, appoint, and secure tomorrow morning to kick off, kick off, take up, and tear into on this ramble.
Learn, come upon, and determine for rent by owner homes in Arrecife, house rentals Arrecife Spain, and Arrecife homes for rent by owner.
Vacated studio ranch and suburban cottage are convenient in the near-at-hand kingdom of Guajar Alto Spain.
Locate and recognize Las Palmas Spain homes for rent and rent house Las Palmas Spain.
Recognize and disclose rental home Malaga Spain and Malaga house rentals.
We hatched, phrased, and invested our page to be resplendent, stunning, and handsome.
Ferret out and dig up Ávila Spain holiday rentals and condo rentals Ávila.
Peers and counterparts examine, root, and go through our for rent by owner website and identify city hacienda, loft houseboat, and city condominium.
|
|
