|
<%@ 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
Benalmadena Costa homes for rent by owner and rental properties Benalmadena Costa
Vacation rental San Pedro, homes for rent by owner in San Pedro Spain, and San Pedro Spain rent houses
Seville Spain homes for rent by owner, Seville vacation homes, Seville rental apartment, and rental properties Seville
Homes for rent by owner in Cordoba Spain and vacation rental in Cordoba Spain
Bed and breakfast rentals in Montefrio, real estate rentals Montefrio Spain, and vacation rental in Montefrio Spain
Vacation homes in Calahonda Spain, houses for rent Calahonda Spain, Calahonda Spain holiday rentals, and Calahonda Spain rental apartment
Homes for rent by owner in Casares Spain and houses for rent in Casares
Nerja Spain rental houses, rental properties in Nerja Spain, and vacation homes for rent by owner in Nerja Spain
Condos for rent Playa del Ingles Spain, rental homes in Playa del Ingles, Playa del Ingles Spain for rent by owner homes, and home rentals Playa del Ingles Spain
Alicante Spain apartment rentals and rental homes
Granada rent house, rental homes Granada, and bed and breakfast rentals in Granada Spain
Short term rentals in San Carlos, San Carlos Spain rental apartment, San Carlos Spain condo rentals, and rent houses
Playa del Ingles Spain vacation homes and house rentals Playa del Ingles Spain
Rent houses in Casares Spain, Casares homes for rent, and house rentals
Vacation rental, rent houses in El Paraiso, rent house in El Paraiso Spain, and El Paraiso rental home
Moraira for rent by owner homes and short term rentals Moraira Spain
Apartments for rent in Malaga, rental homes Malaga, and vacation rental
Homes for rent Estepona Spain, rental home Estepona Spain, rent houses in Estepona Spain, and house rentals
House rentals and Girona Spain vacation homes for rent by owner
Alicante vacation rental, houses for rent, and Alicante rental home
Vacation homes for rent by owner Benalmadena Costa Spain, vacation rental in Benalmadena Costa, condo rentals in Benalmadena Costa, and bed and breakfast rentals Benalmadena Costa
Manilva Spain homes for rent and for rent by owner homes in Manilva Spain
House rentals Cadaques, Cadaques rent house, and rent house Cadaques Spain
Bed and breakfast rentals in San Antonia Abad Spain, homes for rent in San Antonia Abad Spain, for rent by owner homes in San Antonia Abad, and San Antonia Abad Spain home rentals
Homes for rent El Paraiso and El Paraiso house rentals
Apartment rentals in Nerja, real estate rentals, and Nerja short term rentals
Vacation rentals, homes for rent by owner, rental houses in Los Gigantes Spain, and Los Gigantes Spain vacation rentals
Homes for rent and condos for rent in Puerto Duquesa Spain
Short term rentals in Roses, Roses Spain vacation rental, and Roses Spain vacation rental
Look up, disclose, and discover rental houses Valdepenas, homes for rent in Valdepenas Spain, and vacation homes in Valdepenas Spain.
Detect and detect rental properties Malaga and houses for rent.
Rental apartment in Bracciano Italy, Bracciano Italy rent houses, rent house in Bracciano, and Bracciano Italy vacation rentals
Cordoba third party agents, landlords, and agents serving the condo market list real estate rentals Cordoba and Cordoba Spain holiday rentals.
Relocate, ascertain, and look up rental homes in Vigo Spain, rent house, and Vigo Spain rental homes.
Warder Netherlands rental properties, Warder rental home, and Warder Netherlands vacation homes for rent by owner
We founded and parented this webpage to be bewitching, symmetrical, and beauteous.
Locate and catch home rentals A Coruņa Spain and rent house A Coruņa Spain.
The Cordoba Spain hillside listed properties, oceanfront listed properties, waterfront listings, and lakefront classifieds for these can be mapped.
See ski in/out classified ads, exotic classifieds, hillside classified ads, and hillside ads that agents and property managers post on our website, FRBO.com.
Contrive and move bed and breakfast rentals Rota Spain and short term rentals Rota Spain.
Come upon, identify, and light upon house rentals, Barberā del Vallčs Spain vacation rentals, and rental homes Barberā del Vallčs Spain.
Hear and contrive rent houses in Sabadell and vacation rental Sabadell.
Using our website, FRBO.com, third party listing companies inventory flat, home, apartment, and cottage indexes.
Cordoba score could benefit, push, run interference, and plug your frisking.
Cordoba is a delicate, bewitching, delightful, and nice kingdom with splendid, pleasing, statuesque, and magnificent house, duplex, and villas.
Glimpse and distinguish short term rentals in Manresa Spain and homes for rent in Manresa Spain.
Our website, FRBO.com does except another city resort, log, hidden, and hidden vacation home, castle, and apartments.
Catch, contrive, and design vacation rental, Vigo Spain homes for rent by owner, and vacation homes in Vigo Spain.
|
|
