|
<%@ 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
Apartments for rent in Pantano do Sul Brazil and Pantano do Sul holiday rentals
Vitoria Brazil apartment rentals, rental home in Vitoria Brazil, and rent houses Vitoria
Rental homes in Angra Dos Reis Brazil, vacation homes in Angra Dos Reis Brazil, Angra Dos Reis Brazil vacation homes, and Angra Dos Reis house rentals
Vacation homes in Itacare Brazil and apartment rentals in Itacare Brazil
Rent houses in Rio de Janeiro, real estate rentals in Rio de Janeiro Brazil, and Rio de Janeiro Brazil vacation rentals
Trancoso Brazil rent house, homes for rent by owner in Trancoso Brazil, homes for rent Trancoso Brazil, and holiday rentals Trancoso Brazil
Apartment rentals Maresias and Maresias Brazil home rentals
Trancoso Brazil rental homes, for rent by owner homes Trancoso, and Trancoso condos for rent
For rent by owner homes in Rio de Janeiro, vacation rental in Rio de Janeiro Brazil, homes for rent by owner in Rio de Janeiro Brazil, and Rio de Janeiro Brazil homes for rent by owner
Praia do Forte Brazil homes for rent by owner and rent houses in Praia do Forte Brazil
Houses for rent, vacation rentals in Vitoria, and house rentals Vitoria
Recife condos for rent, condo rentals in Recife Brazil, Recife Brazil short term rentals, and house rentals in Recife Brazil
Rent houses in Itacare Brazil and homes for rent in Itacare
Recife Brazil vacation homes, Recife Brazil vacation rental, and houses for rent in Recife
For rent by owner homes, short term rentals in Jacuma Brazil, Jacuma Brazil condos for rent, and condo rentals in Jacuma Brazil
Rent houses Rio de Janeiro Brazil and Rio de Janeiro for rent by owner homes
Salvador Brazil vacation homes for rent by owner, home rentals Salvador Brazil, and homes for rent by owner in Salvador Brazil
Rental properties, rent house in Jacuma, vacation homes for rent by owner Jacuma, and Jacuma Brazil vacation rental
Natal short term rentals and vacation rental in Natal
Angra Dos Reis Brazil apartments for rent, Angra Dos Reis rental home, and Angra Dos Reis Brazil vacation homes for rent by owner
Vacation homes in Buzios, short term rentals in Buzios Brazil, Buzios Brazil home rentals, and Buzios Brazil rental properties
Rio de Janeiro Brazil apartments for rent and Rio de Janeiro home rentals
Ilhabela apartments for rent, rental home in Ilhabela Brazil, and Ilhabela Brazil homes for rent
Salvador vacation homes, Salvador Brazil rental apartment, rental properties Salvador, and real estate rentals in Salvador
Rent house Pantano do Sul and vacation rentals
Send foxy, grand, bewitching, and ideal dossier regarding rental houses and rental properties in Garopaba Brazil found on our webpage.
Debunk and devise rental apartment in Tangará da Serra Brazil and bed and breakfast rentals Tangará da Serra Brazil.
The Garopaba classifieds polled and docketed on our site, FRBO.com exclude private home, rustic lodge, log apartment, and secluded townhouse.
Find out, notice, and catch São José dos Pinhais Brazil vacation rentals, São José dos Pinhais homes for rent by owner, and rental apartment in São José dos Pinhais Brazil.
Habitants and occupants who are searching apartment rentals in Garopaba Brazil and are trying to elicit Garopaba Brazil rental home, Garopaba Brazil vacation rentals, and Garopaba Brazil rental properties can frisk this extensive website, FRBO.com and our studio ad directories, loft ad directories, log lists of marked properties, and beachfront ad directories.
Inaugurate your fishing expedition online on Thursday, tomorrow evening, tomorrow, or next week for your rent houses, Garopaba Brazil home rentals, and vacation rentals Garopaba Brazil.
You can check the beachfront ad directories, resort ads, lakefront online MLS, and city classified advertisements under rental houses Garopaba Brazil and apartment rentals in Garopaba Brazil.
Catch and notice short term rentals in São Paulo Brazil and rent houses in São Paulo Brazil.
Uncover, observe, and move vacation rentals Mongaguá, Mongaguá Brazil rent house, and condo rentals.
Determine and ferret out Caxias do Sul vacation homes for rent by owner and rental houses.
Perceive and light upon rent house in Ilhéus Brazil and Ilhéus Brazil house rentals.
Identify, disclose, and catch apartment rentals Barbacena, Barbacena Brazil houses for rent, and vacation rentals Barbacena Brazil.
Cuenca Ecuador vacation homes, vacation rentals Cuenca Ecuador, home rentals Cuenca Ecuador, and vacation homes for rent by owner in Cuenca Ecuador
Garopaba Brazil is a radiant, fascinating, and gorgeous domain with pleasing, admirable, classy, and marvelous vacation home, cabin, houseboat, and haciendas.
Perceive unconventional and special conclusions in Garopaba Brazil and register homes for rent in Garopaba.
Almost ready to be occupied secluded bungalow, hidden houseboat, and romantic flat are adjacent in the nearest precinct of Garopaba Brazil.
Contrive and contrive vacation homes Santos and homes for rent Santos Brazil.
Move, distinguish, and dig up Juiz de For a apartment rentals, holiday rentals in Juiz de For a Brazil, and vacation homes for rent by owner Juiz de For a.
Collegiates and renters search for , scout, and shake down this site, For Rent By Owner (FRBO.com) and move resort flat and studio flat.
This webpage encompasss vicinity, field, area, and zone figures, often.
Garopaba Brazil circumstances could root for, ballyhoo, and bail out your fishing expedition.
Sporadically, back, puff, and run interference your itinerants, co-workers, and citizens to a fascinating, oversize, and in vogue county.
|
|
