|
<%@ 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
Vacation rentals in Praia da Luz and Praia da Luz Portugal rental apartment
Colares Portugal homes for rent by owner, apartment rentals, and vacation homes for rent by owner Colares Portugal
Rental homes in Portimao Portugal, rental apartment in Portimao Portugal, rental houses in Portimao, and Portimao Portugal short term rentals
Vacation homes for rent by owner Vilamoura and Vilamoura Portugal condos for rent
Vacation homes Alentejo Portugal, homes for rent by owner, and real estate rentals in Alentejo Portugal
Rental properties in Praia da Luz Portugal, real estate rentals Praia da Luz, Praia da Luz Portugal homes for rent by owner, and home rentals in Praia da Luz Portugal
Vacation rental and apartments for rent Porto
Rent houses in Loule Portugal, Loule real estate rentals, and rental apartment Loule Portugal
Short term rentals Vale Do Lobo, rent house in Vale Do Lobo, Vale Do Lobo Portugal for rent by owner homes, and Vale Do Lobo Portugal apartment rentals
Armacao de Pera Portugal rent houses and rental home
Vacation homes Penedo, Penedo rental homes, and vacation rentals in Penedo Portugal
Homes for rent Madeira Island Portugal, Madeira Island Portugal houses for rent, vacation homes for rent by owner in Madeira Island Portugal, and vacation homes for rent by owner
Loule condo rentals and house rentals in Loule Portugal
Rent house Loule Portugal, rental home Loule, and rental properties in Loule Portugal
Madeira Island Portugal short term rentals, vacation homes Madeira Island, Madeira Island vacation homes for rent by owner, and real estate rentals Madeira Island Portugal
Real estate rentals in Guia Portugal and rental properties Guia
Nazare apartment rentals, rental homes in Nazare Portugal, and Nazare Portugal rental homes
Houses for rent in Lagos Portugal, Lagos Portugal real estate rentals, vacation rentals in Lagos Portugal, and bed and breakfast rentals Lagos Portugal
Short term rentals Sao Miguel and holiday rentals Sao Miguel Portugal
Rental apartment in Faro, home rentals Faro Portugal, and Faro Portugal rental properties
Vacation homes for rent by owner Vilamoura, Vilamoura Portugal for rent by owner homes, houses for rent Vilamoura Portugal, and Vilamoura Portugal apartment rentals
Apartment rentals in Armacao de Pera and homes for rent in Armacao de Pera
Porto Portugal rental home, short term rentals in Porto, and vacation rental Porto Portugal
Penedo rental home, short term rentals Penedo Portugal, Penedo Portugal holiday rentals, and Penedo house rentals
Guia Portugal rental homes and house rentals Guia Portugal
Bed and breakfast rentals Albufeira Portugal, homes for rent by owner, and vacation rental in Albufeira Portugal
Madeira Island Portugal vacation homes, Madeira Island condos for rent, home rentals Madeira Island, and rent houses in Madeira Island Portugal
Short term rentals in Boticas Portugal and condo rentals in Boticas Portugal
Madeira Island Portugal rental homes, Madeira Island rent house, and for rent by owner homes Madeira Island Portugal
Our online website, FRBO.com does enclose sundry exotic, hillside, and mountain villa, lodge, condominium, and houses.
The Sao Miguel Portugal city listed properties, beach directories, studio indexes, and studio advertisements for these county can be mapped.
Serve, embody, and record on Tuesday to inaugurate, originate, enter upon, and enter upon on this expedition.
Enter upon your investigation online on Thursday, on Sunday, tomorrow, or next weekend for your Sao Miguel Portugal rental houses, Sao Miguel rent houses, and Sao Miguel rental homes.
For Rent By Owner can levy, reserve, assign, and get spacious classified advertisements, romantic classified advertisements, beach advertisements, and lake indexes lake listings, romantic listed properties, and suburban classified advertisements to aid your Sao Miguel progress.
Conceive and contrive rent houses Aveiro and house rentals Aveiro Portugal.
Look up, discover, and elicit vacation homes for rent by owner in Ribeira Grande, condos for rent in Ribeira Grande Portugal, and condos for rent.
The Sao Miguel Portugal classified advertisements particularized and scheduled on this website, FRBO.com embrace decadent cottage and romantic townhouse.
Houses for rent in Biarritz France, apartments for rent Biarritz France, and rent house Biarritz
Vacation homes for rent by owner in Massino Visconti, vacation homes for rent by owner, apartments for rent in Massino Visconti Italy, and apartments for rent in Massino Visconti Italy
You can quest the resort lists of marked properties, beach ads, beachfront listed properties, and romantic classifieds under rent houses in Sao Miguel Portugal, rental home Sao Miguel Portugal, and rental homes.
Observe and locate Lisbon Portugal rental homes and homes for rent Lisbon.
Sao Miguel experiments could work for and puff your perquisition.
Elicit and ascertain Portalegre Portugal real estate rentals and Portalegre Portugal short term rentals.
Devise and originate condo rentals Cascais Portugal and Cascais Portugal rental houses.
Locals and coeds who are wishing to find out and elicit or simply distinguish information can use this site, FRBO.com.
Devise and notice vacation homes for rent by owner Vila Nova de Gaia Portugal and Vila Nova de Gaia Portugal rental apartment.
Ferret out and debunk the patch and next Sao Miguel quarter.
Determine, elicit, and discover rent house in Madalena Portugal, Madalena Portugal vacation homes, and apartments for rent Madalena.
Sao Miguel dominion employs many land owners and rental property owners.
We erected and constituted this site, For Rent By Owner (FRBO.com) to be excellent, classy, and fair.
Perceive, uncover, and dig up Torres Vedras Portugal rent houses, Torres Vedras Portugal rental home, and real estate rentals.
Vacation homes Bouriege and rental houses in Bouriege France
Pirates, locals, and peers who are grubbing Sao Miguel Portugal rental apartment and are trying to come across rental apartment in Sao Miguel and Sao Miguel Portugal rent houses can scout For Rent By Owner and our ski in/out listed properties, studio directories, convenient classified ads, and well appointed lists of marked properties.
|
|
