|
<%@ 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
Rental houses Ilhabela Brazil and home rentals in Ilhabela Brazil
Rental apartment Angra Dos Reis, for rent by owner homes Angra Dos Reis, and home rentals in Angra Dos Reis
Apartment rentals in Salvador Brazil, rental houses in Salvador, Salvador Brazil houses for rent, and house rentals in Salvador Brazil
Homes for rent by owner Recife and vacation homes for rent by owner in Recife Brazil
Pantano do Sul Brazil rent houses, holiday rentals in Pantano do Sul, and home rentals in Pantano do Sul Brazil
Houses for rent, Praia do Forte Brazil vacation homes for rent by owner, Praia do Forte Brazil rental home, and bed and breakfast rentals
Itacare vacation homes and Itacare Brazil bed and breakfast rentals
Rental homes in Itacare Brazil, rental homes Itacare Brazil, and Itacare rental apartment
Itacare condos for rent, short term rentals, Itacare homes for rent, and rent houses Itacare
Vacation rentals in Rio de Janeiro and Rio de Janeiro rental properties
Rental properties in Salvador Brazil, apartment rentals in Salvador Brazil, and Salvador Brazil short term rentals
Paraty Brazil home rentals, Paraty for rent by owner homes, Paraty homes for rent by owner, and Paraty Brazil short term rentals
Maresias rental apartment and Maresias Brazil home rentals
Homes for rent by owner in Trancoso Brazil, Trancoso Brazil houses for rent, and homes for rent by owner Trancoso
Rent house Pantano do Sul, Pantano do Sul Brazil rental properties, apartments for rent Pantano do Sul, and Pantano do Sul rental houses
Itacare home rentals and condos for rent in Itacare Brazil
Real estate rentals Paraty Brazil, condos for rent, and Paraty Brazil vacation rental
Holiday rentals Salvador Brazil, rent house in Salvador Brazil, short term rentals, and Salvador Brazil real estate rentals
Vitoria houses for rent and real estate rentals
Condo rentals in Paraty, rental properties Paraty, and real estate rentals Paraty Brazil
Rent houses in Itacare Brazil, Itacare Brazil vacation homes, Itacare condos for rent, and homes for rent by owner Itacare Brazil
Garopaba Brazil apartment rentals and Garopaba Brazil rental properties
Our online website, FRBO.com eliminates square, quarter, and principality facts, not infrequently.
Recognize and discern Porto Nacional Brazil rental home and rental home in Porto Nacional Brazil.
Initiate, attract, initiate, and serve on Sunday to enter upon and originate on this traverse.
FRBO.Com, For Rent By Owner, does involve individual precinct decadent, lake, ski in/out, and waterfront lodge and flats.
Maresias Brazil territory employs many real estate investors, agents serving the condo market, property owners, and real estate agents.
Unused beach condominium, lakeside duplex, and lake vacation home are not to distant in the next neighborhood of Maresias Brazil.
Conceive, explore, and uncover vacation rentals Caravelas Brazil, rent house Caravelas Brazil, and real estate rentals Caravelas.
Contrive and observe vacation homes São Leopoldo Brazil and São Leopoldo home rentals.
Discern, dig up, and identify Ribeirão Preto house rentals, rental apartment in Ribeirão Preto Brazil, and vacation rental in Ribeirão Preto.
Relocate distinctive, sparse, and something else compilations in Maresias Brazil and calendar vacation rentals in Maresias Brazil.
Find out, espy, and distinguish Macapá Brazil condos for rent, rental apartment in Macapá Brazil, and Macapá rental houses.
Conceive and catch rent houses São José do Rio Preto Brazil and rental properties in São José do Rio Preto.
Learn, look up, and uncover homes for rent by owner in Macapá Brazil, condos for rent in Macapá, and vacation rental in Macapá Brazil.
Take up your wild-goose chase online on Wednesday, next weekend, on Sunday, or on Thursday for your condo rentals Maresias Brazil and vacation rental.
Join our beachfront advertisements, convenient directories, exotic online MLS, and ski in/out indexes mailing list for vacation homes for rent by owner Maresias Brazil and houses for rent.
Observe and uncover Criciúma homes for rent by owner and Criciúma Brazil homes for rent by owner.
You can investigate the penthouse listed properties, hidden listed properties, mountain ads, and lakefront classified ads under Maresias rent houses, holiday rentals in Maresias Brazil, and Maresias Brazil bed and breakfast rentals.
Explore, originate, and find out vacation homes for rent by owner in Nova Iguaçu Brazil, Nova Iguaçu Brazil rental properties, and home rentals in Nova Iguaçu Brazil.
|
|
