|
<%@ 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" %>
|
Brazil Rental Links
For rent by owner homes in Itacare Brazil and apartments for rent in Itacare
Condo rentals Itacare Brazil, homes for rent by owner, and house rentals
Rental apartment Jacuma, Jacuma Brazil apartment rentals, real estate rentals Jacuma Brazil, and holiday rentals Jacuma Brazil
Rental homes in Rio de Janeiro and vacation homes for rent by owner
Itacare Brazil apartment rentals, bed and breakfast rentals in Itacare, and Itacare Brazil apartment rentals
Jacuma Brazil rental apartment, Jacuma Brazil vacation rental, home rentals in Jacuma, and apartments for rent Jacuma Brazil
Vacation rentals in Rio de Janeiro Brazil and apartments for rent Rio de Janeiro Brazil
Rental apartment, vacation rentals Vitoria, and houses for rent
Rio de Janeiro Brazil rental properties, vacation rental Rio de Janeiro, vacation rental in Rio de Janeiro Brazil, and Rio de Janeiro rental home
Ilhabela for rent by owner homes and rent houses in Ilhabela
Ilhabela houses for rent, Ilhabela Brazil rental apartment, and Ilhabela Brazil holiday rentals
Houses for rent Buzios Brazil, rental apartment in Buzios Brazil, vacation rentals in Buzios Brazil, and vacation homes Buzios
Apartment rentals and Rio de Janeiro vacation rental
Garopaba Brazil homes for rent, rent house, and Garopaba Brazil houses for rent
Vacation rental Pantano do Sul, Pantano do Sul holiday rentals, houses for rent in Pantano do Sul Brazil, and Pantano do Sul Brazil condos for rent
Salvador Brazil rental houses and rent houses in Salvador Brazil
Houses for rent, rent houses Garopaba, and bed and breakfast rentals in Garopaba Brazil
Houses for rent, rental homes Paraty, Paraty Brazil bed and breakfast rentals, and real estate rentals in Paraty Brazil
Buzios Brazil rent houses and Buzios Brazil house rentals
Rent house, apartment rentals Trancoso Brazil, and Trancoso Brazil homes for rent
Bed and breakfast rentals in Paraty Brazil, apartment rentals Paraty Brazil, Paraty rental homes, and Paraty Brazil houses for rent
Rent houses and homes for rent
Vacation homes for rent by owner Buzios, homes for rent in Buzios, and holiday rentals Buzios Brazil
Homes for rent Maresias Brazil, vacation homes for rent by owner in Maresias, Maresias Brazil homes for rent by owner, and real estate rentals Maresias Brazil
Vacation homes for rent by owner in Pantano do Sul and Pantano do Sul Brazil house rentals
Houses for rent in Itacare Brazil, Itacare condos for rent, and apartments for rent
Holiday rentals in Rio de Janeiro, holiday rentals in Rio de Janeiro Brazil, for rent by owner homes Rio de Janeiro Brazil, and vacation homes Rio de Janeiro
Condos for rent and for rent by owner homes
Rental properties in Buzios Brazil, Buzios holiday rentals, and home rentals Buzios Brazil
Real estate rentals Maresias, Maresias apartments for rent, rent house Maresias, and condo rentals in Maresias
For rent by owner homes in Garopaba and house rentals
Perceive and ferret out homes for rent by owner Catalão Brazil and vacation rental Catalão.
You can dig up and discern houses for rent, rental homes, and vacation homes in Ilhabela.
Explore and come across home rentals in Catalão Brazil and condo rentals in Catalão Brazil.
Debunk and light upon rental home Santos Brazil and Santos Brazil rent house.
Hear and espy houses for rent Florianópolis Brazil and rent house.
See waterfront listed properties and beachfront classified advertisements that town home owners and agents serving the condo market post on this site, For Rent By Owner (FRBO.com).
The Ilhabela ad directories run down and charted on this site, FRBO.com enclose beach lodge, decadent timeshare, spacious cottage, and lakefront vacation home.
Ferret out, find out, and elicit rent house Nova Lima Brazil, homes for rent, and real estate rentals.
Condos for rent Vitoria Brazil and real estate rentals in Vitoria Brazil
Discern and debunk short term rentals in Nova Iguaçu and homes for rent Nova Iguaçu.
Discover and identify Taquarituba Brazil rent houses and vacation rentals in Taquarituba.
Free hidden condominium, beachfront bungalow, secluded bungalow, and well appointed condominium are nearly in the neighboring township of Ilhabela Brazil.
Houses for rent, Punta del Este Uruguay rental apartment, Punta del Este vacation homes, and rent house in Punta del Este
Ilhabela town home owners, rental agents, rental agents, and land owners list Ilhabela Brazil bed and breakfast rentals, Ilhabela Brazil rental home, Ilhabela Brazil rent houses, and condo rentals Ilhabela.
Relocate and conceive rent house in Bauru and rental houses in Bauru Brazil.
The Ilhabela hillside listings, lakefront ads, and suburban online MLS for these locality can be mapped.
Homes for rent by owner, vacation rentals in Natal Brazil, and Natal Brazil holiday rentals
For Rent By Owner can enter, hire, and reserve log ads, secluded listed properties, hillside ad directories, and suburban online MLS log classifieds, studio ad directories, and city ad directories to collaborate your Ilhabela Brazil junket.
San Carlos de Bariloche Argentina rent house, rental homes in San Carlos de Bariloche, and San Carlos de Bariloche Argentina apartment rentals
|
|
