|
<%@ 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" %>
|
Venezuela Rental Links
Rental apartment in Pampatar Venezuela and Pampatar Venezuela bed and breakfast rentals
Rent house, rent house Paraguachi Venezuela, and Paraguachi Venezuela rental homes
Short term rentals in Porlamar, apartments for rent in Porlamar Venezuela, house rentals Porlamar Venezuela, and homes for rent
Real estate rentals in Puerto la Cruz Venezuela and Puerto la Cruz rental houses
Houses for rent Sabana de Guacuco Venezuela, rent house in Sabana de Guacuco Venezuela, and homes for rent by owner Sabana de Guacuco Venezuela
Real estate rentals in Ranchos de Chana Venezuela, Ranchos de Chana Venezuela bed and breakfast rentals, Ranchos de Chana apartments for rent, and vacation rentals Ranchos de Chana
Rent house in Porlamar Venezuela and rent house in Porlamar
Condo rentals in Paraguachi, Paraguachi Venezuela real estate rentals, and Paraguachi Venezuela vacation rental
Rental properties El Salado, bed and breakfast rentals El Salado, homes for rent by owner in El Salado Venezuela, and apartment rentals in El Salado
Gran Roque Venezuela vacation homes for rent by owner and homes for rent in Gran Roque
Playa Zaragoza bed and breakfast rentals, for rent by owner homes Playa Zaragoza Venezuela, and Playa Zaragoza Venezuela rent houses
The Ranchos de Chana private directories, convenient ads, well appointed classifieds, and beach directories for these can be mapped.
For Rent By Owner can enter into, obtain, and sign on well appointed listings, hidden online MLS, and hidden online MLS suburban listings, decadent directories, ski in/out online MLS, and lake ads to abet your Ranchos de Chana sojourn.
Send fine and beauteous notes regarding Ranchos de Chana Venezuela vacation rentals and homes for rent Ranchos de Chana Venezuela found on For Rent By Owner.
The Ranchos de Chana Venezuela ad directories posted and chronicled on FRBO.com hold hillside castle, resort villa, and oceanfront villa.
Available mountain apartment, studio house, log cabin, and decadent chalet are near-at-hand in the approaching square of Ranchos de Chana Venezuela.
Oblige, join up, volunteer, and serve this week to embark on and kick off on this vagabondage.
Identify unusual, ad hoc, and bizarre whole story in Ranchos de Chana Venezuela and census house rentals in Ranchos de Chana.
Move, disclose, and elicit Tocuyito rental apartment, Tocuyito Venezuela bed and breakfast rentals, and condo rentals Tocuyito Venezuela.
Traveling sales representatives and suburbanites who are raking vacation rental and are trying to uncover Ranchos de Chana Venezuela rent houses, Ranchos de Chana Venezuela houses for rent, and houses for rent in Ranchos de Chana Venezuela can examine this extensive website, FRBO.com and our ski in/out indexes, oceanfront classified advertisements, lakeside directories, and suburban listed properties.
You can discern, glimpse, and discern Ranchos de Chana Venezuela vacation homes for rent by owner and Ranchos de Chana Venezuela rental home.
Kick off your hunt online this weekend or tomorrow for your bed and breakfast rentals in Ranchos de Chana Venezuela and for rent by owner homes.
We created, imagined, and fashioned FRBO.Com, For Rent By Owner, to be shapely, enticing, and splendid.
Devise and disclose homes for rent Maracay Venezuela and Maracay Venezuela bed and breakfast rentals.
Recognize, disclose, and glimpse home rentals Cua Venezuela, apartments for rent in Cua Venezuela, and Cua Venezuela house rentals.
Using For Rent By Owner, real estate investors place condominium, house, bungalow, and farmhouse indexes.
|
|
