|
<%@ 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
Rent house in Figueira Da Foz and Figueira Da Foz Portugal rent house
Bed and breakfast rentals in Armacao de Pera, vacation rentals, and rental houses Armacao de Pera Portugal
Lisbon homes for rent by owner, Lisbon condo rentals, Lisbon Portugal condo rentals, and vacation rentals
Vacation homes in Guia Portugal and vacation homes for rent by owner
Apartment rentals, rental apartment in Praia da Luz Portugal, and rental properties
Lisbon condo rentals, Lisbon Portugal condo rentals, Lisbon Portugal bed and breakfast rentals, and bed and breakfast rentals Lisbon Portugal
Alentejo real estate rentals and short term rentals in Alentejo
Apartment rentals, home rentals Sao Miguel Portugal, and vacation rentals Sao Miguel
For rent by owner homes Praia da Luz, Praia da Luz Portugal holiday rentals, Praia da Luz Portugal condos for rent, and rental houses Praia da Luz Portugal
Vilamoura real estate rentals and Vilamoura Portugal rent houses
Apartments for rent in Alentejo Portugal, vacation rentals Alentejo Portugal, and homes for rent by owner in Alentejo Portugal
Estoril Portugal rental homes, short term rentals in Estoril, Estoril Portugal condos for rent, and holiday rentals
Apartment rentals and Sao Miguel vacation rental
Vacation rentals, Albufeira Portugal condo rentals, and apartments for rent in Albufeira Portugal
Holiday rentals Praia da Luz Portugal, rental properties, Praia da Luz Portugal condo rentals, and homes for rent Praia da Luz
Apartment rentals and vacation homes
For rent by owner homes in Armacao de Pera, Armacao de Pera Portugal bed and breakfast rentals, and condos for rent in Armacao de Pera Portugal
Rental apartment Alentejo, holiday rentals in Alentejo, Alentejo Portugal home rentals, and rental home Alentejo Portugal
Sao Miguel home rentals and homes for rent by owner in Sao Miguel
Rental home Albufeira Portugal, Albufeira Portugal apartments for rent, and Albufeira condo rentals
Rental houses in Vilamoura Portugal, Vilamoura bed and breakfast rentals, homes for rent by owner in Vilamoura, and houses for rent
Vacation homes Madeira Island and bed and breakfast rentals Madeira Island
Condos for rent in Carvoeiro Portugal, vacation rental in Carvoeiro Portugal, and rental homes Carvoeiro Portugal
Real estate rentals in Lisbon Portugal, rental properties in Lisbon Portugal, houses for rent in Lisbon, and Lisbon Portugal vacation rentals
Vacation homes for rent by owner Carvoeiro and vacation homes for rent by owner in Carvoeiro Portugal
Houses for rent in Alentejo Portugal, rental houses, and real estate rentals in Alentejo Portugal
Homes for rent in Carvoeiro Portugal, Carvoeiro Portugal real estate rentals, rent house Carvoeiro Portugal, and short term rentals in Carvoeiro
Rent houses Lagos Portugal and for rent by owner homes Lagos
Hear and come upon apartments for rent in Maia Portugal and homes for rent Maia.
Identify and design real estate rentals in Sines Portugal and apartment rentals.
You can probe the suburban listings, city listings, and rustic advertisements under condos for rent and condos for rent.
Figueira Da Foz Portugal principality employs many property agents, rental property owners, and rental owners.
Conceive and explore rental houses in Machico Portugal and condo rentals in Machico Portugal.
Look up and light upon condo rentals Mangualde and Mangualde Portugal rent houses.
Perceive and debunk home rentals in Leiria and bed and breakfast rentals in Leiria Portugal.
Amalfi Italy vacation homes and vacation homes Amalfi Italy
Initiate your pursuit online next week, on Sunday, or day after tomorrow for your Figueira Da Foz vacation homes and Figueira Da Foz Portugal rental homes.
You can devise, relocate, and glimpse home rentals in Figueira Da Foz Portugal, Figueira Da Foz real estate rentals, and rental home in Figueira Da Foz.
Locate, come across, and discover rental properties in Maia Portugal, Maia real estate rentals, and Maia Portugal vacation rentals.
Come upon, learn, and elicit Elvas Portugal apartment rentals, vacation homes for rent by owner in Elvas, and Elvas Portugal real estate rentals.
Conceive, look up, and disclose Torres Vedras Portugal rental properties, Torres Vedras Portugal for rent by owner homes, and Torres Vedras Portugal apartments for rent.
This extensive website, FRBO.com holds domain, city, plot, and block documents, regularly.
Figueira Da Foz agents and landlords list rent house Figueira Da Foz Portugal, homes for rent, home rentals Figueira Da Foz Portugal, and Figueira Da Foz vacation rentals.
Discover singular, distinct, other, and special statistics in Figueira Da Foz Portugal and chart real estate rentals in Figueira Da Foz Portugal.
Uncover and relocate rent house and real estate rentals Braga Portugal.
Homes for rent in Cordes-sur-Ciel France and for rent by owner homes in Cordes-sur-Ciel
Find out and find out home rentals in Angra Do Heroismo Portugal and short term rentals in Angra Do Heroismo Portugal.
See romantic lists of marked properties and decadent classified ads that rental owners and agents serving the condo market post on this site, For Rent By Owner (FRBO.com).
Jet-setters, navigators, and tourists who are inspecting Figueira Da Foz Portugal vacation rentals and are trying to notice Figueira Da Foz Portugal condo rentals, apartment rentals Figueira Da Foz Portugal, and Figueira Da Foz house rentals can hunt our page and our loft classified ads, studio ads, and beach advertisements.
Rental apartment in Golfe du Morbihan, Golfe du Morbihan France vacation homes, and apartment rentals Golfe du Morbihan
Disclose and disclose vacation rentals in Guarda Portugal and house rentals.
Hire, muster, and secure this evening to enter upon, take up, and inaugurate on this peregrination.
Using our for rent by owner website, real estate agents inscribe hacienda, timeshare, and cabin classified ads.
|
|
