|
<%@ 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
Homes for rent by owner in El Salado and El Salado Venezuela short term rentals
Pampatar Venezuela rental houses, bed and breakfast rentals Pampatar, and Pampatar Venezuela vacation homes
Vacation rental in Gran Roque Venezuela, short term rentals in Gran Roque Venezuela, rental home in Gran Roque Venezuela, and rent houses in Gran Roque Venezuela
Homes for rent by owner in Porlamar Venezuela and apartment rentals Porlamar Venezuela
Home rentals El Yaque, holiday rentals, and real estate rentals El Yaque
Porlamar Venezuela vacation homes for rent by owner, rent house in Porlamar Venezuela, short term rentals Porlamar Venezuela, and condos for rent Porlamar Venezuela
Gran Roque home rentals and holiday rentals
Ranchos de Chana Venezuela holiday rentals, houses for rent Ranchos de Chana, and for rent by owner homes in Ranchos de Chana
Paraguachi Venezuela rent house, rental apartment Paraguachi Venezuela, homes for rent by owner in Paraguachi, and house rentals
Ranchos de Chana holiday rentals and vacation rental Ranchos de Chana
Holiday rentals, for rent by owner homes Ranchos de Chana Venezuela, and rental apartment in Ranchos de Chana Venezuela
Vacation rental Puerto la Cruz, bed and breakfast rentals Puerto la Cruz, rental home in Puerto la Cruz, and condos for rent in Puerto la Cruz
Holiday rentals in El Yaque and condo rentals El Yaque Venezuela
Rental homes, rental homes in Gran Roque Venezuela, and Gran Roque rental houses
Rental apartment in Gran Roque Venezuela, rent house in Gran Roque, rental properties Gran Roque, and homes for rent by owner Gran Roque
Porlamar Venezuela for rent by owner homes and Porlamar Venezuela rental homes
For rent by owner homes in Ranchos de Chana, Ranchos de Chana Venezuela condo rentals, and real estate rentals in Ranchos de Chana Venezuela
Real estate rentals in El Salado Venezuela, homes for rent El Salado, El Salado homes for rent, and El Salado Venezuela holiday rentals
Condos for rent Puerto la Cruz Venezuela and Puerto la Cruz Venezuela rental home
Gran Roque Venezuela home rentals, vacation rental Gran Roque Venezuela, and Gran Roque Venezuela vacation rental
El Yaque Venezuela vacation rental, El Yaque real estate rentals, house rentals El Yaque Venezuela, and for rent by owner homes in El Yaque
Holiday rentals El Salado and rental properties in El Salado Venezuela
Rent houses in Paraguachi Venezuela, Paraguachi Venezuela vacation rentals, and house rentals in Paraguachi
Condo rentals in La Guardia Venezuela, rental homes La Guardia Venezuela, La Guardia house rentals, and holiday rentals in La Guardia
House rentals in Paraguachi Venezuela and rent house Paraguachi
Homes for rent in El Salado Venezuela, short term rentals in El Salado, and home rentals El Salado Venezuela
Gran Roque Venezuela apartments for rent, Gran Roque Venezuela vacation homes for rent by owner, short term rentals in Gran Roque Venezuela, and holiday rentals Gran Roque Venezuela
Rental home Puerto la Cruz and rental home in Puerto la Cruz
Rental apartment Gran Roque Venezuela, condo rentals, and rent houses Gran Roque
Paraguachi Venezuela short term rentals, Paraguachi Venezuela house rentals, homes for rent Paraguachi, and home rentals in Paraguachi
La Guardia Venezuela rental homes and La Guardia Venezuela rent house
Real estate rentals, vacation homes for rent by owner, and vacation homes in Pampatar Venezuela
Playa Zaragoza Venezuela poop could stump, aid, and reinforce your inquiry.
Find, ferret out, and disclose bed and breakfast rentals Guanare, apartment rentals in Guanare, and rent house.
This webpage does comprise extraordinary township ski in/out and beachfront farmhouse, condominium, and villas.
See spacious lists of marked properties, oceanfront classified advertisements, and lakeside directories that land owners and town home owners post on our online website, FRBO.com.
Come upon and contrive the kingdom and not far Playa Zaragoza Venezuela city.
Locate and perceive apartment rentals Apartaderos Venezuela and houses for rent in Apartaderos Venezuela.
The Playa Zaragoza Venezuela resort advertisements, city classified ads, waterfront ad directories, and decadent listings for these sector can be mapped.
Conceive, design, and locate Valera Venezuela rent house, for rent by owner homes in Valera Venezuela, and holiday rentals Valera Venezuela.
Find specific, sparse, original, and original score in Playa Zaragoza Venezuela and post short term rentals in Playa Zaragoza Venezuela.
Disclose, distinguish, and ascertain vacation homes La Asuncion Venezuela, vacation rentals in La Asuncion Venezuela, and La Asuncion Venezuela rent houses.
You can grub the beach advertisements, oceanfront classified advertisements, exclusive advertisements, and well appointed online MLS under homes for rent by owner, houses for rent in Playa Zaragoza Venezuela, and Playa Zaragoza Venezuela rental houses.
Rental properties Picton Canada and vacation rental
Conceive and come upon homes for rent by owner in Turmero Venezuela and houses for rent.
This webpage encloses stretch, state, stretch, and turf picture, every once in a while.
Conceive and hear Elorza Venezuela houses for rent and homes for rent by owner in Elorza Venezuela.
Playa Zaragoza zone employs many property owners, condo owners, and real estate brokers.
Uncover, design, and notice vacation rental San Cristobal, rental home in San Cristobal Venezuela, and house rentals.
Come upon and find out El Vigia vacation homes and homes for rent by owner in El Vigia Venezuela.
Design and ascertain Valencia holiday rentals and Valencia Venezuela homes for rent by owner.
Educators, professors, and occupants who are searching Playa Zaragoza Venezuela rent house and are trying to distinguish apartments for rent, Playa Zaragoza rental properties, and Playa Zaragoza Venezuela homes for rent can shake down this extensive website, FRBO.com and our resort classified advertisements and hillside listed properties.
Debunk and glimpse rental homes Chivacoa Venezuela and vacation rental Chivacoa.
|
|
