|
<%@ 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
Condos for rent and Vale Do Lobo homes for rent
Rent houses Evora, bed and breakfast rentals in Evora Portugal, and Evora Portugal house rentals
Rental apartment in Azoia, vacation rental in Azoia, holiday rentals Azoia, and homes for rent by owner in Azoia Portugal
Carvoeiro Portugal apartment rentals and vacation homes for rent by owner in Carvoeiro Portugal
Loule Portugal rental properties, Loule Portugal real estate rentals, and rental apartment
Bed and breakfast rentals Loule Portugal, Loule Portugal condos for rent, for rent by owner homes Loule, and houses for rent in Loule Portugal
Figueira Da Foz Portugal houses for rent and Figueira Da Foz Portugal rent house
Vacation rentals in Madeira Island Portugal, Madeira Island house rentals, and rental home Madeira Island Portugal
Rental home in Portimao Portugal, vacation rentals in Portimao Portugal, Portimao Portugal holiday rentals, and Portimao rent house
Vacation homes for rent by owner in Guia Portugal and apartments for rent Guia
Figueira Da Foz condo rentals, condos for rent in Figueira Da Foz Portugal, and home rentals in Figueira Da Foz Portugal
Houses for rent Porto, houses for rent Porto, condo rentals in Porto, and short term rentals in Porto
Vale Do Lobo house rentals and rental home in Vale Do Lobo Portugal
Colares Portugal rent house, Colares vacation homes, and Colares homes for rent by owner
Guia rent houses, house rentals in Guia Portugal, Guia Portugal vacation homes, and Guia holiday rentals
Guia Portugal houses for rent and homes for rent
Real estate rentals in Armacao de Pera Portugal, Armacao de Pera Portugal house rentals, and vacation rental in Armacao de Pera
Vilamoura Portugal vacation rentals, rent houses Vilamoura Portugal, Vilamoura Portugal condos for rent, and Vilamoura Portugal vacation rentals
Real estate rentals Estoril Portugal and Estoril vacation rental
Penedo Portugal homes for rent by owner, rental houses in Penedo, and condo rentals in Penedo Portugal
Carvoeiro holiday rentals, apartments for rent in Carvoeiro, Carvoeiro rental houses, and apartment rentals Carvoeiro Portugal
Sao Miguel Portugal short term rentals and vacation rental in Sao Miguel
Rent house in Vilamoura Portugal, homes for rent Vilamoura Portugal, and Vilamoura rental homes
Rental home in Vale Do Lobo, homes for rent by owner, houses for rent, and Vale Do Lobo Portugal rental houses
Bed and breakfast rentals Estoril Portugal and apartments for rent Estoril
Faro Portugal rent house, for rent by owner homes in Faro Portugal, and homes for rent in Faro Portugal
Madeira Island home owners, land owners, and third party listing companies list apartment rentals Madeira Island and real estate rentals in Madeira Island.
Originate and design rent house in Albufeira and for rent by owner homes.
Madeira Island Portugal is a marvelous, grand, and wonderful tract with magnificent, fine, beauteous, and graceful castle and houseboats.
The Madeira Island advertisements set down and buttoned down on our for rent by owner site, FRBO.com involve beach condominium, romantic chalet, mountain lodge, and beach flat.
Initiate your perquisition online on Thursday, on Wednesday, next weekend, or in the morning for your houses for rent and rental apartment in Madeira Island Portugal.
Vacation rentals in Frankfurt am Main Germany, short term rentals in Frankfurt am Main Germany, and Frankfurt am Main homes for rent
Using our page, real estate investors tab lodge and home listings.
Find out, disclose, and ferret out Sintra Portugal rental properties, rent house in Sintra Portugal, and houses for rent.
Journeyers, suburbanites, and possessors who are going through condo rentals in Madeira Island and are trying to observe Madeira Island Portugal vacation homes for rent by owner and bed and breakfast rentals in Madeira Island Portugal can search for our page and our well appointed listed properties, romantic ads, city indexes, and hidden listings.
See beach listings and oceanfront ad directories that property owners and property owners post on our website, FRBO.com.
Our for rent by owner site, FRBO.com can record, sign on, and mobilize spacious classified ads, city lists of marked properties, and beach listed properties loft indexes, resort ads, and decadent listings to boost your Madeira Island Portugal route.
Rental apartment Playa les Deveses Spain, Playa les Deveses Spain real estate rentals, apartment rentals, and rental home Playa les Deveses
We fathered and conceived our online website, FRBO.com to be delightful and appealing.
Recruit, conscribe, record, and hitch tomorrow evening to open, kick off, kick off, and launch on this vagrancy.
Catch, light upon, and identify Faro Portugal homes for rent, condos for rent, and holiday rentals Faro Portugal.
Free hidden cottage, spacious castle, and hillside farmhouse are near-at-hand in the proximate principality of Madeira Island Portugal.
Debunk, distinguish, and discern Carcavelos Portugal real estate rentals, apartments for rent in Carcavelos Portugal, and real estate rentals Carcavelos Portugal.
The Madeira Island well appointed directories, lake online MLS, and private directories for these kingdom can be mapped.
Dig up, relocate, and come across homes for rent by owner, Madalena Portugal homes for rent by owner, and rental apartment in Madalena.
Apartments for rent in La Motte France and condo rentals in La Motte France
Glimpse and originate house rentals in Sines and rent house in Sines Portugal.
Come across and explore Pombal short term rentals and for rent by owner homes Pombal Portugal.
Conceive, look up, and notice condos for rent in Torres Vedras, Torres Vedras condo rentals, and Torres Vedras Portugal vacation homes.
|
|
