|
<%@ 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
Real estate rentals Seville Spain and Seville Spain short term rentals
Torrevieja homes for rent, Torrevieja Spain for rent by owner homes, and Torrevieja apartment rentals
Vacation rental in Blanes Spain, rental homes in Blanes, rent house in Blanes Spain, and houses for rent in Blanes Spain
Rent house Lierganes and rent houses Lierganes
Rental homes in Luarca, Luarca Spain bed and breakfast rentals, and Luarca Spain real estate rentals
Rental properties Malaga Spain, Malaga house rentals, rental apartment Malaga Spain, and Malaga Spain real estate rentals
For rent by owner homes in San Antonia Abad and home rentals in San Antonia Abad Spain
Rental houses in Sant Feliu De Guixols Spain, Sant Feliu De Guixols Spain rental houses, and condos for rent in Sant Feliu De Guixols Spain
Rental properties in Manilva, Manilva Spain home rentals, condo rentals Manilva, and rental houses in Manilva Spain
Galilea real estate rentals and short term rentals Galilea
Condo rentals in Torrevieja Spain, Torrevieja Spain rental houses, and Torrevieja Spain bed and breakfast rentals
House rentals Puerto Duquesa Spain, Puerto Duquesa Spain for rent by owner homes, for rent by owner homes in Puerto Duquesa, and holiday rentals Puerto Duquesa Spain
Rental homes San Carlos Spain and homes for rent by owner San Carlos
Sant Feliu De Guixols vacation homes, Sant Feliu De Guixols homes for rent, and rental houses in Sant Feliu De Guixols Spain
Rental houses Golf del Sur Spain, rental properties in Golf del Sur Spain, Golf del Sur rental homes, and short term rentals in Golf del Sur Spain
Rent houses in Los Gigantes Spain and condo rentals Los Gigantes
Galilea short term rentals, condo rentals in Galilea Spain, and Galilea Spain real estate rentals
Short term rentals in Manilva Spain, Manilva Spain vacation rentals, Manilva Spain vacation rental, and Manilva Spain vacation homes for rent by owner
Apartment rentals Montefrio and short term rentals Montefrio
San Carlos real estate brokers, agents serving the condo market, property managers, and agents serving the condo market list homes for rent by owner in San Carlos Spain, San Carlos Spain condo rentals, and rental home in San Carlos Spain.
Determine, originate, and locate Matadepera Spain homes for rent, rental properties in Matadepera Spain, and Matadepera Spain vacation homes.
San Carlos Spain block employs many condo owners and property owners.
The San Carlos Spain secluded indexes, loft listed properties, rustic advertisements, and exclusive ad directories for these neighborhood can be mapped.
Join our studio classified ads, mountain classified advertisements, beach classified ads, and rustic directories mailing list for San Carlos Spain homes for rent, real estate rentals San Carlos Spain, and vacation rental San Carlos Spain.
Come upon and explore vacation homes for rent by owner Oviedo and real estate rentals in Oviedo.
Perceive, devise, and come upon apartment rentals, home rentals, and Ronda Spain rental home.
Perceive, explore, and ferret out home rentals in Mollerusa, Mollerusa Spain vacation rentals, and Mollerusa Spain vacation rentals.
The San Carlos Spain ad directories inscribed and set down on For Rent By Owner comprehend hidden vacation home, hidden hacienda, ski in/out lodge, and decadent bungalow.
Explore, relocate, and come upon rent house in Valdepenas Spain, rent house in Valdepenas Spain, and rent house.
Send classy, stunning, and symmetrical details regarding houses for rent in San Carlos Spain, apartment rentals San Carlos Spain, rental home in San Carlos Spain, and holiday rentals found on our online website, FRBO.com.
Recognize, come across, and move rental properties Barcarrota, Barcarrota vacation homes, and vacation homes for rent by owner Barcarrota Spain.
Debunk and come across houses for rent in Barcelona and houses for rent in Barcelona Spain.
|
|
