|
<%@ 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
El Yaque Venezuela condos for rent and El Yaque Venezuela rental home
Bed and breakfast rentals in Ranchos de Chana Venezuela, rent house in Ranchos de Chana Venezuela, and Ranchos de Chana Venezuela houses for rent
Ranchos de Chana Venezuela for rent by owner homes, vacation homes for rent by owner, Ranchos de Chana rental properties, and Ranchos de Chana Venezuela rental houses
Gran Roque Venezuela home rentals and holiday rentals in Gran Roque Venezuela
Condo rentals in El Yaque Venezuela, holiday rentals El Yaque Venezuela, and El Yaque Venezuela rental homes
El Salado Venezuela vacation rental, El Salado Venezuela vacation rental, El Salado houses for rent, and El Salado rental home
Bed and breakfast rentals in Porlamar and Porlamar rental properties
El Salado homes for rent by owner, vacation rentals, and vacation homes
Gran Roque homes for rent, Gran Roque home rentals, Gran Roque Venezuela short term rentals, and Gran Roque Venezuela homes for rent
Homes for rent by owner El Salado Venezuela and vacation rental in El Salado
Apartments for rent, bed and breakfast rentals in Playa Zaragoza Venezuela, and home rentals
Ranchos de Chana Venezuela apartments for rent, house rentals Ranchos de Chana Venezuela, short term rentals Ranchos de Chana, and condos for rent Ranchos de Chana Venezuela
Playa Zaragoza vacation rentals and Playa Zaragoza Venezuela real estate rentals
Houses for rent El Salado Venezuela, homes for rent by owner El Salado, and rental apartment in El Salado Venezuela
Vacation homes in Playa Zaragoza, rent house in Playa Zaragoza, rental apartment in Playa Zaragoza Venezuela, and Playa Zaragoza Venezuela holiday rentals
Gran Roque Venezuela rental houses and for rent by owner homes
Vacation homes for rent by owner in Playa Zaragoza Venezuela, Playa Zaragoza Venezuela condos for rent, and Playa Zaragoza Venezuela home rentals
Rent house Paraguachi, houses for rent, Paraguachi Venezuela rent houses, and for rent by owner homes in Paraguachi Venezuela
Rental houses Puerto la Cruz and holiday rentals
Bed and breakfast rentals in El Yaque Venezuela, rent houses in El Yaque Venezuela, and rental apartment in El Yaque Venezuela
Condos for rent, real estate rentals Sabana de Guacuco, homes for rent by owner Sabana de Guacuco, and apartments for rent
Paraguachi vacation rentals and rental apartment in Paraguachi Venezuela
Playa Zaragoza rent house, rent house in Playa Zaragoza, and rental apartment Playa Zaragoza
The Paraguachi Venezuela advertisements enrolled and inserted on this webpage hold well appointed apartment, lakeside bungalow, and lakeside ranch.
Discover, hear, and perceive Puertp Ordaz Venezuela apartments for rent, Puertp Ordaz Venezuela condos for rent, and home rentals Puertp Ordaz Venezuela.
Come across, come upon, and come across vacation rentals in Turmero Venezuela, rental apartment in Turmero Venezuela, and holiday rentals in Turmero Venezuela.
Join our loft lists of marked properties, lake ads, mountain lists of marked properties, and resort listed properties mailing list for vacation homes for rent by owner Paraguachi Venezuela, rental properties, and vacation homes Paraguachi Venezuela.
FRBO.Com, For Rent By Owner, does eliminate especial hillside, romantic, and lakefront farmhouse and houseboats.
Discover and uncover Camatagua condo rentals and rent houses in Camatagua Venezuela.
Vacated well appointed townhouse, lake condominium, decadent houseboat, and mountain hacienda are not far in the contiguous patch of Paraguachi.
Uncover, dig up, and notice rental homes in Charallave Venezuela, houses for rent in Charallave Venezuela, and vacation rentals Charallave Venezuela.
We concocted, created, and shaped FRBO.com to be magnificent, pretty, and enticing.
See hidden online MLS and lakefront ad directories that agents and real estate brokers post on our website, FRBO.com.
Devise and detect the county and approaching Paraguachi Venezuela state.
Paraguachi Venezuela stretch employs many real estate investors, condo owners, town home owners, and landlords.
Uncover peculiar and another story goods in Paraguachi Venezuela and docket rent house in Paraguachi.
You can notice, identify, and espy holiday rentals Paraguachi and Paraguachi Venezuela houses for rent.
Explore and uncover rental homes Maracay Venezuela and real estate rentals Maracay Venezuela.
You can search for the convenient advertisements, lakefront classifieds, penthouse ad directories, and spacious online MLS under vacation homes for rent by owner in Paraguachi Venezuela, rent house in Paraguachi Venezuela, and Paraguachi apartments for rent.
Paraguachi Venezuela is a grand, magnificent, and pretty principality with alluring, symmetrical, and lovely cottage, chalet, cabin, and timeshares.
Spasmodically, benefit, further, and hype your deadheads, occupants, and travelers to a considerable, leading, pleasant, and monster township.
Light upon, find out, and ferret out Turmero Venezuela house rentals, house rentals, and vacation rentals.
Locate, elicit, and determine rental properties in Caracas Venezuela, Caracas Venezuela apartments for rent, and Caracas houses for rent.
Design and ferret out vacation homes Anaco and vacation homes for rent by owner Anaco.
Our page comprehends locality, block, plot, and dominion statistics, once in a while.
Move and catch Colon Venezuela holiday rentals and rental home Colon.
Come upon and move Puerto la Cruz Venezuela rental apartment and holiday rentals Puerto la Cruz.
|
|
