|
<%@ 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
Houses for rent and Paraty homes for rent by owner
Rental apartment in Garopaba Brazil, Garopaba Brazil vacation rentals, and rent houses
Home rentals in Itacare, rental homes, condo rentals in Itacare Brazil, and Itacare vacation homes for rent by owner
Vacation homes in Pantano do Sul Brazil and homes for rent by owner in Pantano do Sul
Vitoria Brazil real estate rentals, holiday rentals in Vitoria Brazil, and homes for rent by owner in Vitoria Brazil
Rental properties Paraty, Paraty real estate rentals, houses for rent in Paraty Brazil, and short term rentals in Paraty Brazil
Home rentals in Ilhabela and Ilhabela Brazil vacation rentals
Rent house in Recife Brazil, rental apartment in Recife Brazil, and Recife Brazil vacation rental
Homes for rent in Maresias Brazil, rental home in Maresias, vacation homes Maresias, and rental apartment in Maresias Brazil
House rentals in Natal Brazil and condos for rent in Natal
Homes for rent by owner Jacuma Brazil, Jacuma Brazil bed and breakfast rentals, and rental properties in Jacuma
Short term rentals Angra Dos Reis, house rentals in Angra Dos Reis Brazil, holiday rentals in Angra Dos Reis Brazil, and home rentals
Houses for rent Jacuma Brazil and condo rentals Jacuma
For rent by owner homes, Recife Brazil rental properties, and for rent by owner homes in Recife Brazil
Homes for rent Vitoria, rent houses in Vitoria Brazil, homes for rent Vitoria Brazil, and rental houses
Holiday rentals in Natal Brazil and short term rentals in Natal Brazil
Jacuma Brazil condo rentals, house rentals Jacuma Brazil, and house rentals Jacuma
Trancoso Brazil vacation homes, homes for rent by owner Trancoso, house rentals Trancoso, and Trancoso Brazil house rentals
Vacation homes for rent by owner Angra Dos Reis and Angra Dos Reis Brazil rental houses
Natal real estate investors and landlords list Natal Brazil house rentals, house rentals in Natal, and Natal rent house.
The Natal Brazil classified ads tabbed and recorded on this extensive website, FRBO.com comprehend decadent hacienda and waterfront townhouse.
Relocate and hear Niterói Brazil holiday rentals and rental apartment.
Espy and determine condos for rent and rent house in Nova Iguaçu Brazil.
The Natal Brazil suburban listed properties, spacious indexes, lakefront classified advertisements, and well appointed online MLS for these can be mapped.
Dig up and locate Porto Nacional condos for rent and Porto Nacional condo rentals.
Recognize, debunk, and perceive short term rentals in Sete Lagoas Brazil, vacation homes in Sete Lagoas Brazil, and rent house in Sete Lagoas.
Find, originate, and locate vacation homes for rent by owner Limeira, Limeira rent house, and Limeira condos for rent.
Renters, entrepreneurs, and traveling women who are running down houses for rent Natal Brazil and are trying to contrive rental home in Natal Brazil and rent house in Natal Brazil can inspect this website, FRBO.com and our private directories, log directories, secluded lists of marked properties, and lake directories.
Glimpse and detect condo rentals in Pelotas Brazil and rental houses in Pelotas Brazil.
Move and look up Garanhuns Brazil rent houses and condos for rent Garanhuns Brazil.
Join our penthouse indexes, penthouse classified ads, well appointed classified advertisements, and beachfront ad directories mailing list for rental homes in Natal, home rentals Natal, and Natal Brazil condo rentals.
Hikers and trekkers scan and root our page and relocate exclusive timeshare, city cabin, ski in/out hacienda, and log cabin.
Natal area employs many brokers leasing foreclosures, rental owners, and brokers leasing foreclosures.
|
|
