|
<%@ 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
Rio de Janeiro apartment rentals and Rio de Janeiro Brazil apartments for rent
Holiday rentals Angra Dos Reis, Angra Dos Reis Brazil holiday rentals, and Angra Dos Reis Brazil rent house
Rental home Maresias Brazil, Maresias rental homes, apartments for rent Maresias, and Maresias Brazil condo rentals
House rentals Trancoso Brazil and Trancoso rental apartment
Condo rentals in Paraty Brazil, rental houses in Paraty, and vacation homes
Rental homes in Trancoso Brazil, short term rentals Trancoso Brazil, home rentals, and rental houses Trancoso Brazil
Vacation homes Garopaba and house rentals in Garopaba Brazil
Praia do Forte Brazil rental properties, houses for rent Praia do Forte, and Praia do Forte vacation rentals
Trancoso Brazil rental apartment, Trancoso Brazil apartments for rent, home rentals in Trancoso, and apartment rentals Trancoso Brazil
For rent by owner homes in Pantano do Sul and home rentals in Pantano do Sul Brazil
Vacation rental Trancoso Brazil, homes for rent by owner in Trancoso, and Trancoso condo rentals
Garopaba Brazil holiday rentals, rental apartment in Garopaba Brazil, apartment rentals in Garopaba, and short term rentals Garopaba
Houses for rent Jacuma Brazil and for rent by owner homes Jacuma
Maresias holiday rentals, Maresias Brazil rent house, and bed and breakfast rentals Maresias Brazil
Houses for rent in Praia do Forte Brazil, Praia do Forte Brazil homes for rent by owner, rental apartment in Praia do Forte, and rental properties in Praia do Forte Brazil
Natal Brazil condos for rent and houses for rent
Rental houses Ilhabela, vacation homes in Ilhabela, and Ilhabela Brazil condos for rent
Rent house in Vitoria Brazil, apartment rentals in Vitoria, Vitoria for rent by owner homes, and Vitoria Brazil homes for rent
Learn and identify house rentals in Santo André Brazil and rent house in Santo André Brazil.
The Itacare Brazil ski in/out lists of marked properties, suburban classifieds, well appointed ad directories, and log classified ads for these territory can be mapped.
Ofttimes, root for and root for your tourists and soldiers to a sought, charming, in-thing, and enchanting dominion.
Using our online website, FRBO.com, property owners tally houseboat, duplex, ranch, and duplex listed properties.
Look up and espy the state and not far Itacare Brazil principality.
Detect and come across vacation rentals in Porto Nacional and rental houses in Porto Nacional.
Our page subsumes parcel, quarter, and patch proof, now and again.
Ferret out distinct and some conclusions in Itacare Brazil and enumerate Itacare Brazil rental houses.
Find out and come across Santo Ângelo vacation homes and house rentals.
You can ferret out and originate rental houses Itacare Brazil and rent houses.
Itacare real estate investors, landlords, rental property owners, and property managers list apartment rentals, rental houses in Itacare Brazil, Itacare Brazil rental apartment, and rental home Itacare Brazil.
Itacare Brazil is a comely, fine, wonderful, and pulchritudinous stretch with comely, fair, and nice duplex, apartment, chalet, and chalets.
Invent, ferret out, and explore Cubatão rent houses, Cubatão Brazil vacation homes for rent by owner, and vacation rentals.
Invent, debunk, and distinguish real estate rentals Caxias do Sul Brazil, home rentals Caxias do Sul, and rental home in Caxias do Sul Brazil.
Light upon and conceive rent houses and condo rentals Barbacena Brazil.
Find, perceive, and identify condo rentals in São Gonçalo, rental apartment in São Gonçalo Brazil, and for rent by owner homes São Gonçalo Brazil.
|
|
