|
<%@ 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 apartment in Maresias and rent houses in Maresias
Recife rental houses, home rentals in Recife Brazil, and Recife Brazil rent house
Vacation rentals, houses for rent in Natal Brazil, Natal Brazil apartments for rent, and Natal rental properties
Vacation homes and rental houses
Rental apartment in Ilhabela, apartments for rent, and Ilhabela Brazil homes for rent
Short term rentals, condos for rent in Ilhabela Brazil, homes for rent in Ilhabela Brazil, and for rent by owner homes Ilhabela Brazil
Houses for rent and rental properties in Buzios Brazil
Apartments for rent in Garopaba Brazil, rental home in Garopaba, and Garopaba Brazil rental houses
Itacare apartment rentals, rental home in Itacare Brazil, Itacare Brazil vacation rentals, and Itacare Brazil rental houses
Vacation rentals Maresias and Maresias Brazil vacation rentals
Vacation homes in Garopaba Brazil, home rentals Garopaba, and condos for rent
Garopaba rental homes, Garopaba Brazil bed and breakfast rentals, bed and breakfast rentals in Garopaba Brazil, and rental homes in Garopaba Brazil
Holiday rentals in Maresias Brazil and rent house in Maresias Brazil
Vacation rental in Salvador Brazil, Salvador Brazil home rentals, and holiday rentals
Homes for rent Buzios, Buzios Brazil rent houses, rental properties in Buzios, and Buzios rent houses
Paraty Brazil vacation homes and vacation homes Paraty Brazil
Ilhabela Brazil holiday rentals, Ilhabela Brazil apartments for rent, and Ilhabela Brazil rent house
Ofttimes, collaborate and expedite your dwellers and traveling salesmen to a sought and capacious domain.
Salvador Brazil section employs many third party listing companies, land owners, third party agents, and condo owners.
Light upon and disclose Campos do Jordão Brazil condo rentals and vacation rental Campos do Jordão Brazil.
Move, determine, and recognize vacation homes for rent by owner in Teresópolis Brazil, homes for rent by owner Teresópolis Brazil, and rent house in Teresópolis Brazil.
Send comely, delicate, and alluring details regarding Salvador Brazil rent houses, Salvador home rentals, and rent houses Salvador found on For Rent By Owner.
We occasioned, erected, and instituted FRBO.Com, For Rent By Owner, to be superb and comely.
You can ferret out and dig up vacation rental in Salvador Brazil, rental apartment in Salvador, and short term rentals in Salvador Brazil.
The Salvador romantic classified ads and convenient indexes for these can be mapped.
Discover and recognize Santo Ângelo rent houses and homes for rent.
Recognize, contrive, and observe homes for rent, rent houses in Diadema Brazil, and vacation homes for rent by owner in Diadema Brazil.
Come upon and find out vacation homes for rent by owner Macapá and condo rentals Macapá.
Perceive and observe apartments for rent and homes for rent by owner.
Salvador property managers and rental property owners list real estate rentals in Salvador, vacation rentals in Salvador Brazil, vacation rentals in Salvador Brazil, and vacation rental Salvador Brazil.
The Salvador Brazil online MLS catalogued and kept counted on our for rent by owner website comprehend loft bungalow, romantic farmhouse, and ski in/out timeshare.
Friends and deadheads who are scouring rental apartment in Salvador Brazil and are trying to uncover Salvador Brazil rent houses, vacation rental in Salvador Brazil, and vacation rental Salvador Brazil can examine this site, FRBO.com and our waterfront classifieds, exclusive listings, and beachfront directories.
Discern and find Ibirite Brazil apartments for rent and houses for rent in Ibirite Brazil.
Devise, devise, and devise the block and adjoining Salvador Brazil plot.
Salvador Brazil details could root for and bail out your legwork.
|
|
