|
<%@ 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
Estoril Portugal real estate rentals and Estoril Portugal homes for rent by owner
Portimao holiday rentals, Portimao vacation rental, and Portimao Portugal vacation rental
For rent by owner homes in Porto Portugal, real estate rentals in Porto, holiday rentals in Porto, and Porto Portugal bed and breakfast rentals
Vilamoura Portugal bed and breakfast rentals and Vilamoura Portugal rent houses
For rent by owner homes Lagos, Lagos Portugal rental homes, and short term rentals
Figueira Da Foz Portugal vacation homes for rent by owner, vacation homes for rent by owner in Figueira Da Foz, apartments for rent in Figueira Da Foz Portugal, and Figueira Da Foz Portugal rent houses
Porto Portugal vacation rental and rental properties Porto
Holiday rentals in Carvoeiro Portugal, rental home Carvoeiro, and homes for rent Carvoeiro Portugal
Condo rentals in Madeira Island, Madeira Island Portugal houses for rent, Madeira Island Portugal house rentals, and apartments for rent in Madeira Island Portugal
Boticas Portugal short term rentals and Boticas rental homes
Rent house, apartments for rent Vilamoura Portugal, and rental houses Vilamoura
Home rentals Lisbon, vacation rental in Lisbon Portugal, condo rentals in Lisbon Portugal, and condo rentals
Loule vacation homes for rent by owner and apartment rentals Loule Portugal
Apartments for rent in Lagos, apartments for rent in Lagos Portugal, and Lagos Portugal vacation homes for rent by owner
Armacao de Pera Portugal short term rentals, homes for rent by owner, house rentals in Armacao de Pera Portugal, and condo rentals in Armacao de Pera Portugal
Boticas Portugal rental apartment and Boticas Portugal holiday rentals
Rental houses Vilamoura, Vilamoura bed and breakfast rentals, and Vilamoura Portugal rental properties
Home rentals in Faro Portugal, vacation rental, rental properties Faro Portugal, and home rentals Faro Portugal
Evora Portugal rental properties and rental houses in Evora
Boticas Portugal rent houses, Boticas Portugal vacation rentals, and Boticas Portugal condos for rent
Rental houses in Penedo Portugal, bed and breakfast rentals Penedo, rental apartment in Penedo Portugal, and homes for rent Penedo Portugal
Rent houses in Carvoeiro and Carvoeiro Portugal rental apartment
This extensive website, FRBO.com can obtain and appoint private classified ads and beachfront lists of marked properties lakeside indexes, lakeside advertisements, lakeside listings, and beach listings to ride shotgun your Carvoeiro migration.
Recognize, distinguish, and originate short term rentals Funchal Portugal, short term rentals in Funchal Portugal, and condo rentals in Funchal Portugal.
Recognize, detect, and identify real estate rentals Mangualde, condos for rent in Mangualde, and Mangualde apartment rentals.
Contrive, dig up, and locate Oporto Portugal rental apartment, Oporto Portugal vacation homes, and home rentals.
Carvoeiro agents serving the condo market and rental property owners list real estate rentals in Carvoeiro Portugal, rental apartment in Carvoeiro Portugal, and rent houses Carvoeiro.
Our for rent by owner site, FRBO.com does exclude some township lakefront and exotic farmhouse, villa, castle, and condominiums.
Carvoeiro Portugal field employs many condo owners and agents serving the condo market.
Light upon and distinguish Cascais Portugal vacation rental and condos for rent in Cascais.
Ferret out, relocate, and uncover Oporto apartment rentals, Oporto condo rentals, and bed and breakfast rentals in Oporto Portugal.
Hear and determine apartment rentals Carcavelos Portugal and rental houses.
Contrive, find, and detect rental home in Santo Joćo da Madeira Portugal, homes for rent in Santo Joćo da Madeira, and Santo Joćo da Madeira real estate rentals.
Sisters-in-law, confidants, and navigators who are wishing to discover and contrive or simply find information can use FRBO.Com, For Rent By Owner,.
Find and originate Massama for rent by owner homes and vacation homes Massama.
Observe, notice, and uncover vacation rentals, Faro Portugal vacation rentals, and rent house in Faro Portugal.
|
|
