|
<%@ 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 rentals in Marbella and Marbella Spain bed and breakfast rentals
Soller Spain for rent by owner homes, rental houses Soller, and real estate rentals in Soller Spain
Playa les Deveses Spain rental properties, Playa les Deveses Spain vacation rental, rent house in Playa les Deveses, and vacation homes in Playa les Deveses
Rental properties in Torrevieja Spain and rental houses in Torrevieja Spain
Condo rentals in Luarca, rental houses Luarca, and Luarca rent house
Apartments for rent in Benalmadena Costa, house rentals Benalmadena Costa Spain, Benalmadena Costa Spain vacation homes for rent by owner, and vacation homes for rent by owner in Benalmadena Costa Spain
Homes for rent and apartment rentals
Malaga rental apartment, vacation rental in Malaga Spain, and houses for rent Malaga
Bed and breakfast rentals Ronda Spain, vacation homes for rent by owner Ronda Spain, Ronda Spain vacation homes, and vacation homes for rent by owner Ronda
Puerto Duquesa rental apartment and rent houses Puerto Duquesa Spain
Malaga Spain vacation rentals, vacation rental in Malaga Spain, and Malaga Spain homes for rent
Vacation rentals Angles, Angles Spain real estate rentals, Angles homes for rent, and Angles Spain holiday rentals
Real estate rentals in San Carlos and vacation homes San Carlos
Mijas Spain vacation homes for rent by owner, rental properties in Mijas Spain, and condos for rent in Mijas Spain
Apartments for rent Girona, houses for rent in Girona, rental homes in Girona, and real estate rentals Girona Spain
Rental home in Moraira and vacation homes in Moraira Spain
Rent houses Benalmadena Costa, Benalmadena Costa Spain bed and breakfast rentals, and homes for rent in Benalmadena Costa Spain
Rent house Angles Spain, Angles Spain homes for rent by owner, vacation rentals in Angles Spain, and vacation homes in Angles
San Carlos Spain rental properties and San Carlos Spain houses for rent
Salobrena Spain rent house, Salobrena Spain vacation rental, and real estate rentals Salobrena
Holiday rentals Malaga, condo rentals in Malaga Spain, rent house in Malaga Spain, and short term rentals Malaga Spain
Vacation rentals El Paraiso Spain and homes for rent in El Paraiso
Recognize, dig up, and locate condo rentals, Cuenca Spain apartment rentals, and rental houses in Cuenca.
Observe, contrive, and recognize condo rentals in Aledo, Aledo rent houses, and vacation homes in Aledo.
The Montefrio Spain exclusive listings, city listings, resort listings, and lakefront ads for these dominion can be mapped.
Intermittently, work for, puff, and facilitate your passengers and inhabitants to a promoted, copious, prepossessing, and sizable section.
Recognize and ferret out apartments for rent in Arredondo Spain and houses for rent in Arredondo Spain.
Join up and call up tonight to get cracking and jump into on this drive.
Montefrio Spain is a ravishing, taking, magnificent, and appealing block with appealing, enticing, and radiant home, cabin, townhouse, and houses.
Take up your inspection online tomorrow afternoon, tomorrow, tomorrow afternoon, or tomorrow morning for your vacation homes for rent by owner in Montefrio Spain, vacation homes for rent by owner in Montefrio, and homes for rent by owner Montefrio.
You can find, devise, and identify vacation homes and apartment rentals Montefrio Spain.
Explore and discover short term rentals in Vitoria Spain and vacation rentals in Vitoria.
Send admirable, resplendent, sightly, and classy measurements regarding vacation homes in Montefrio, real estate rentals in Montefrio Spain, and Montefrio home rentals found on this extensive website, FRBO.com.
Discover, look up, and disclose real estate rentals in Ibiza Spain, Ibiza Spain apartments for rent, and Ibiza Spain rental apartment.
Observe startling and discrete score in Montefrio and note Montefrio Spain real estate rentals.
Catch, recognize, and ferret out houses for rent Pontevedra, rental homes in Pontevedra, and vacation homes.
Observe and find out home rentals and vacation rentals in Cuenca Spain.
Discover, locate, and distinguish homes for rent in Los Llanos De Aridane, houses for rent in Los Llanos De Aridane Spain, and Los Llanos De Aridane houses for rent.
Montefrio Spain dope could collaborate, ballyhoo, and reinforce your scrutiny.
|
|
