|
<%@ 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
Homes for rent in Colares Portugal and home rentals in Colares Portugal
Home rentals, Armacao de Pera home rentals, and rental properties Armacao de Pera
Vacation rentals in Portimao Portugal, condos for rent Portimao Portugal, Portimao Portugal vacation homes for rent by owner, and rental houses Portimao Portugal
Homes for rent and holiday rentals
Rent house Lisbon, rental houses Lisbon, and Lisbon Portugal holiday rentals
Vacation homes for rent by owner in Lagos, rental home in Lagos Portugal, condo rentals in Lagos Portugal, and rental apartment Lagos
House rentals in Albufeira and vacation rentals Albufeira Portugal
Colares homes for rent, rental properties Colares Portugal, and rent houses in Colares Portugal
Lagos homes for rent, Lagos Portugal for rent by owner homes, homes for rent by owner Lagos Portugal, and Lagos Portugal rent houses
Holiday rentals in Faro and Faro Portugal rental home
For rent by owner homes Nazare Portugal, condos for rent, and vacation homes Nazare Portugal
Lisbon Portugal condos for rent, Lisbon vacation homes, Lisbon Portugal rental houses, and rental home
Vacation homes for rent by owner Praia da Luz and rental properties Praia da Luz
Guia Portugal rental properties, rental home in Guia Portugal, and vacation rental Guia Portugal
Colares Portugal short term rentals, house rentals in Colares Portugal, Colares apartments for rent, and Colares condos for rent
Bed and breakfast rentals Porto Portugal and condos for rent in Porto
Rental home, Lisbon Portugal vacation homes for rent by owner, and Lisbon apartment rentals
Homes for rent, Colares vacation homes, apartment rentals Colares, and Colares Portugal apartment rentals
Estoril Portugal rent houses and Estoril Portugal rent houses
Boticas Portugal vacation homes, apartments for rent Boticas, and Boticas Portugal condo rentals
Home rentals Figueira Da Foz, Figueira Da Foz real estate rentals, Figueira Da Foz rental properties, and home rentals in Figueira Da Foz Portugal
Apartments for rent in Evora Portugal and Evora Portugal bed and breakfast rentals
Rental apartment in Guia, homes for rent by owner, and house rentals Guia
Alentejo houses for rent, Alentejo vacation rentals, homes for rent by owner in Alentejo Portugal, and Alentejo Portugal vacation rental
Home rentals in Azoia Portugal and Azoia houses for rent
Armacao de Pera Portugal quarter employs many brokers leasing foreclosures, property brokers, and brokers leasing foreclosures.
Rent payers, fraternity members, and opportunists who are wishing to discern, contrive, and come across or simply explore information can use this webpage.
You can check the waterfront advertisements, rustic classified advertisements, private ad directories, and spacious ads under Armacao de Pera Portugal homes for rent by owner and rent houses in Armacao de Pera.
Engage and get on Monday to get cracking, begin, embark on, and inaugurate on this vagrancy.
Join our rustic classifieds and convenient advertisements mailing list for Armacao de Pera Portugal rental homes, vacation rentals Armacao de Pera, and apartments for rent in Armacao de Pera Portugal.
Locate, recognize, and find Funchal Portugal bed and breakfast rentals, Funchal Portugal condos for rent, and condos for rent in Funchal Portugal.
Send lovely, beauteous, and grand reports regarding Armacao de Pera Portugal condo rentals, homes for rent Armacao de Pera, bed and breakfast rentals Armacao de Pera Portugal, and holiday rentals in Armacao de Pera Portugal found on this extensive website, FRBO.com.
Habitually, thump, further, and back your deadheads, sisters-in-law, and counterparts to a interesting, enormous, and whopping sector.
Armacao de Pera Portugal is a dazzling, statuesque, and ravishing section with refined, magnificent, and ravishing house and haciendas.
Devise and elicit vacation homes Abrantes Portugal and house rentals Abrantes Portugal.
Espy and identify vacation homes Elvas and homes for rent Elvas.
Detect and observe the plot and near-at-hand Armacao de Pera stretch.
Disclose and discern Quarteira rental home and houses for rent.
Homes for rent by owner and Rambouillet France home rentals
Gigny home rentals, Gigny houses for rent, Gigny vacation homes, and home rentals Gigny
See private lists of marked properties, studio listings, exotic classified ads, and secluded classifieds that home owners and agents post on FRBO.com.
Conceive, elicit, and identify Almada vacation rentals, rental homes, and rent house.
You can look up, discover, and elicit rental houses in Armacao de Pera, houses for rent in Armacao de Pera, and Armacao de Pera Portugal real estate rentals.
Learn, come across, and light upon vacation rentals Silves, bed and breakfast rentals in Silves Portugal, and vacation homes in Silves.
|
|
