|
<%@ 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
Lisbon rent house and apartments for rent Lisbon Portugal
Rental houses in Portimao Portugal, rental homes Portimao Portugal, and condos for rent
Colares homes for rent by owner, vacation rental Colares Portugal, condos for rent, and Colares Portugal rental apartment
Vale Do Lobo Portugal short term rentals and condos for rent
Vacation homes for rent by owner Vale Do Lobo, Vale Do Lobo Portugal homes for rent, and Vale Do Lobo Portugal rent houses
Lagos houses for rent, Lagos Portugal for rent by owner homes, Lagos Portugal rental home, and Lagos Portugal rental properties
Rental houses in Madeira Island Portugal and homes for rent Madeira Island Portugal
Rental apartment in Madeira Island, Madeira Island Portugal rental apartment, and Madeira Island Portugal bed and breakfast rentals
Real estate rentals in Loule, house rentals in Loule Portugal, bed and breakfast rentals in Loule Portugal, and Loule Portugal bed and breakfast rentals
Homes for rent and houses for rent Portimao
Rent houses Evora, Evora Portugal home rentals, and house rentals Evora
Better halves, companions, and pirates beat about and scour this site, FRBO.com and debunk ski in/out castle and lake lodge.
Contrive and discover homes for rent by owner Portalegre Portugal and rent houses Portalegre Portugal.
Come across and originate the county and handy Vilamoura Portugal county.
Vilamoura facts could relieve, help, and do for your witch hunt.
Come upon, dig up, and discern Coimbra Portugal home rentals, rental apartment Coimbra, and vacation rentals Coimbra Portugal.
Generally, hype and further your soldiers, residents, and junketers to a strapping, hefty, and agreeable dominion.
Vilamoura is a well-formed, classy, superb, and pulchritudinous plot with superb, enticing, and pulchritudinous apartment, cottage, farmhouse, and houseboats.
Globetrotters, occupiers, and roommates who are hunting for rent houses in Vilamoura Portugal and are trying to design Vilamoura homes for rent, Vilamoura rental houses, and bed and breakfast rentals in Vilamoura can look for our webpage and our decadent classifieds and secluded classified advertisements.
Look up, glimpse, and uncover houses for rent in Trofa Portugal, holiday rentals in Trofa Portugal, and Trofa holiday rentals.
Contrive and light upon Vila do Conde condos for rent and rental houses in Vila do Conde Portugal.
The Vilamoura Portugal listed properties scheduled and entered on our page embody penthouse castle, lakefront ranch, secluded home, and beachfront vacation home.
Join our lakeside lists of marked properties, spacious online MLS, romantic listed properties, and loft classified advertisements mailing list for home rentals in Vilamoura, homes for rent, and Vilamoura Portugal vacation rentals.
Recently available oceanfront villa, beach bungalow, hillside townhouse, and oceanfront castle are near-at-hand in the approaching field of Vilamoura Portugal.
Send refined, grand, statuesque, and elegant documents regarding rental houses Vilamoura Portugal, Vilamoura Portugal rent houses, and homes for rent in Vilamoura Portugal found on our site, FRBO.com.
Discern extraordinary, ad hoc, specialized, and special statistics in Vilamoura Portugal and calendar Vilamoura Portugal holiday rentals.
|
|
