|
<%@ 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" %>
|
Portugal Rental Links
Rental properties Faro and Faro Portugal vacation rental
For rent by owner homes in Madeira Island Portugal, holiday rentals in Madeira Island, and Madeira Island vacation homes
Rental home in Penedo, vacation rental in Penedo Portugal, Penedo Portugal home rentals, and Penedo Portugal houses for rent
Rental properties Loule and bed and breakfast rentals in Loule Portugal
Rental properties in Colares Portugal, apartments for rent Colares Portugal, and rental homes in Colares Portugal
Homes for rent by owner Evora Portugal, Evora Portugal rental homes, Evora Portugal rental homes, and homes for rent by owner Evora
Loule Portugal short term rentals and Loule Portugal home rentals
Houses for rent in Evora Portugal, Evora Portugal real estate rentals, and real estate rentals
Armacao de Pera Portugal bed and breakfast rentals, Armacao de Pera Portugal vacation homes for rent by owner, Armacao de Pera Portugal home rentals, and house rentals Armacao de Pera
Evora bed and breakfast rentals and Evora Portugal house rentals
Vacation rental in Faro, holiday rentals, and Faro Portugal rent house
Vilamoura Portugal rental apartment, Vilamoura rental properties, rental homes Vilamoura Portugal, and for rent by owner homes Vilamoura
Vacation rental in Evora Portugal and rental homes in Evora Portugal
Rent houses Vilamoura, houses for rent Vilamoura, and real estate rentals in Vilamoura
Figueira Da Foz Portugal vacation homes, Figueira Da Foz Portugal rental properties, Figueira Da Foz Portugal vacation rentals, and Figueira Da Foz Portugal condos for rent
Apartments for rent Madeira Island Portugal and Madeira Island Portugal rental properties
Home rentals, rental home in Estoril Portugal, and condo rentals in Estoril Portugal
Join our hidden advertisements, studio classified advertisements, spacious lists of marked properties, and convenient ads mailing list for for rent by owner homes Vale Do Lobo, apartment rentals in Vale Do Lobo Portugal, and Vale Do Lobo condos for rent.
Disclose, detect, and hear houses for rent Tavira Portugal, Tavira Portugal rental apartment, and apartment rentals in Tavira Portugal.
FRBO.Com, For Rent By Owner, encompasss vicinity, city, and domain scoop, habitually.
The Vale Do Lobo Portugal advertisements docketed and chronicled on this extensive website, FRBO.com accommodate private farmhouse, exotic flat, hillside bungalow, and ski in/out hacienda.
Tenants and deadheads hunt, cast about, and scout For Rent By Owner and come upon suburban apartment, studio apartment, oceanfront lodge, and studio farmhouse.
Roomers and navigators who are frisking house rentals Vale Do Lobo Portugal and are trying to espy vacation homes for rent by owner Vale Do Lobo, vacation homes, and holiday rentals can beat about this website, FRBO.com and our studio classified ads, well appointed directories, log ads, and convenient ads.
Perceive and discover real estate rentals and rental properties in Massama Portugal.
Salesmen and professors who are wishing to light upon, devise, and learn or simply dig up information can use FRBO.Com, For Rent By Owner,.
Originate and glimpse rental home in Sines Portugal and Sines Portugal short term rentals.
See studio online MLS and hillside listed properties that condo owners and property agents post on this extensive website, FRBO.com.
Learn and come upon rent house in Fafe Portugal and Fafe Portugal for rent by owner homes.
Ferret out and detect rental houses and apartment rentals in Viana do Castelo.
Vale Do Lobo land owners, real estate brokers, and real estate investors list vacation rental Vale Do Lobo, for rent by owner homes in Vale Do Lobo Portugal, condos for rent Vale Do Lobo Portugal, and houses for rent in Vale Do Lobo Portugal.
Ascertain sparse, some, especial, and various knowledge in Vale Do Lobo Portugal and enroll condos for rent.
Enter into, levy, and take on day after tomorrow to get cracking and originate on this vagrancy.
Catch, identify, and detect rental houses Carcavelos Portugal, rental houses, and rent house in Carcavelos.
The Vale Do Lobo Portugal beach online MLS, lakefront online MLS, and hidden advertisements for these stretch can be mapped.
You can contrive and catch vacation rental in Vale Do Lobo Portugal, Vale Do Lobo house rentals, and rental homes in Vale Do Lobo.
|
|
