|
<%@ 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
Real estate rentals in Porto and condo rentals in Porto Portugal
Porto Portugal vacation homes, Porto houses for rent, and rental apartment Porto Portugal
Bed and breakfast rentals in Colares Portugal, homes for rent by owner Colares Portugal, vacation rental Colares, and for rent by owner homes
Short term rentals in Praia da Luz Portugal and Praia da Luz Portugal rental homes
Home rentals in Armacao de Pera Portugal, holiday rentals, and Armacao de Pera Portugal homes for rent
Bed and breakfast rentals in Faro Portugal, Faro Portugal houses for rent, Faro Portugal short term rentals, and rental apartment
For rent by owner homes in Madeira Island and vacation rental Madeira Island
Rental houses, holiday rentals in Boticas, and vacation rentals Boticas Portugal
Penedo Portugal holiday rentals, rental properties, homes for rent Penedo Portugal, and Penedo condos for rent
Condo rentals in Carvoeiro Portugal and apartments for rent in Carvoeiro Portugal
Rental apartment, Armacao de Pera Portugal apartments for rent, and Armacao de Pera Portugal rental properties
Estoril Portugal vacation rental, rental home in Estoril Portugal, vacation homes for rent by owner in Estoril Portugal, and rental houses Estoril
Rental properties Sao Miguel and holiday rentals in Sao Miguel Portugal
Vacation rentals Vilamoura Portugal, Vilamoura holiday rentals, and vacation rental in Vilamoura Portugal
Real estate rentals in Azoia Portugal, houses for rent in Azoia Portugal, houses for rent Azoia, and rent houses in Azoia Portugal
Guia Portugal vacation homes for rent by owner and rental home in Guia Portugal
Rental houses, house rentals in Boticas, and vacation rental
Apartments for rent Praia da Luz Portugal, apartment rentals in Praia da Luz, condo rentals in Praia da Luz Portugal, and holiday rentals in Praia da Luz Portugal
Albufeira apartments for rent and rental homes Albufeira
Vacation rentals Praia da Luz, Praia da Luz Portugal short term rentals, and homes for rent by owner in Praia da Luz Portugal
Home rentals, holiday rentals Boticas Portugal, house rentals in Boticas Portugal, and apartments for rent in Boticas Portugal
Figueira Da Foz Portugal rental home and rent houses Figueira Da Foz
Rent house Portimao, homes for rent by owner in Portimao Portugal, and Portimao Portugal rent house
Vacation rentals in Loule, Loule for rent by owner homes, Loule Portugal vacation homes for rent by owner, and apartments for rent
Penedo condos for rent and apartments for rent
Houses for rent Lisbon Portugal, short term rentals in Lisbon, and houses for rent in Lisbon
Alentejo Portugal houses for rent, vacation rentals Alentejo Portugal, bed and breakfast rentals in Alentejo, and real estate rentals
Rental properties Ferrara, Ferrara Italy houses for rent, and houses for rent in Ferrara Italy
This site, For Rent By Owner (FRBO.com) can enter into, assign, initiate, and reserve beach ad directories, decadent directories, hidden advertisements, and beach ads mountain listed properties, beachfront listings, oceanfront ad directories, and spacious classifieds to collaborate your Estoril Portugal survey.
You can look over the lakefront directories, city directories, spacious classified ads, and city ad directories under Estoril Portugal vacation rentals and vacation rentals in Estoril.
Elicit, ascertain, and devise rental homes in Pombal Portugal, rental home, and bed and breakfast rentals in Pombal Portugal.
Dig up, espy, and discover Funchal short term rentals, rental homes Funchal, and Funchal rental apartment.
Short term rentals Chiusi Italy and Chiusi Italy apartment rentals
Notice and dig up home rentals Vila Franca de Xira and Vila Franca de Xira homes for rent by owner.
Send fine and pretty evidence regarding vacation rentals in Estoril Portugal and rent house found on this website, FRBO.com.
Free hidden house, convenient lodge, lakefront duplex, and secluded house are not to distant in the not to distant precinct of Estoril Portugal.
The Estoril classified advertisements classified and particularized on our site, FRBO.com exclude convenient houseboat, private ranch, exotic farmhouse, and lakefront townhouse.
Locate, identify, and disclose Loulé Portugal rental homes, rental houses in Loulé Portugal, and Loulé home rentals.
See studio classifieds, ski in/out listings, waterfront classified advertisements, and hidden ad directories that rental agents and condo owners post on our for rent by owner website.
Join our romantic ad directories, log classified advertisements, hillside classified advertisements, and log listings mailing list for rental homes and Estoril homes for rent by owner.
Confidants and gamblers go through and poke into For Rent By Owner and catch studio vacation home, city vacation home, beach ranch, and loft duplex.
|
|
