|
<%@ 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
La Guardia Venezuela short term rentals and homes for rent by owner in La Guardia Venezuela
Rental properties in Playa Zaragoza Venezuela, Playa Zaragoza rental houses, and rental properties in Playa Zaragoza Venezuela
Rental properties in Pampatar Venezuela, Pampatar short term rentals, vacation rental Pampatar Venezuela, and vacation rentals in Pampatar Venezuela
Rental apartment in Pampatar Venezuela and vacation rental in Pampatar Venezuela
Rent houses in El Yaque Venezuela, homes for rent by owner El Yaque Venezuela, and El Yaque condo rentals
Porlamar Venezuela short term rentals, rental homes in Porlamar, condo rentals Porlamar Venezuela, and vacation homes in Porlamar Venezuela
Bed and breakfast rentals in Sabana de Guacuco and Sabana de Guacuco short term rentals
Holiday rentals in Gran Roque, rental apartment in Gran Roque, and vacation homes
Rental properties, vacation homes for rent by owner in Ranchos de Chana Venezuela, homes for rent in Ranchos de Chana, and real estate rentals in Ranchos de Chana Venezuela
Vacation rentals in Ranchos de Chana Venezuela and rent houses Ranchos de Chana
Rental home in Pampatar Venezuela, home rentals in Pampatar Venezuela, and real estate rentals in Pampatar Venezuela
Rental homes in Gran Roque, vacation homes for rent by owner, house rentals Gran Roque Venezuela, and vacation rental in Gran Roque Venezuela
El Yaque Venezuela vacation homes and apartments for rent in El Yaque
Rent house in El Yaque Venezuela, rental home in El Yaque Venezuela, and apartment rentals
Puerto la Cruz Venezuela vacation rental, vacation homes, Puerto la Cruz vacation homes, and Puerto la Cruz Venezuela rental houses
Rental apartment Sabana de Guacuco and bed and breakfast rentals in Sabana de Guacuco
Vacation homes Pampatar Venezuela, condo rentals Pampatar Venezuela, and rental properties
Rent houses Playa Zaragoza, rent house Playa Zaragoza, apartment rentals in Playa Zaragoza Venezuela, and Playa Zaragoza Venezuela rent houses
Ranchos de Chana Venezuela vacation rental and vacation homes Ranchos de Chana Venezuela
Porlamar rental properties, Porlamar short term rentals, and home rentals in Porlamar Venezuela
Homes for rent in Playa Zaragoza Venezuela, rent house in Playa Zaragoza, rental houses, and Playa Zaragoza Venezuela vacation rentals
Discern, design, and identify La Guaira Venezuela rental houses, real estate rentals, and house rentals La Guaira Venezuela.
Relocate and detect bed and breakfast rentals and apartment rentals.
Look up, ascertain, and detect for rent by owner homes in San Antonio Del Tachira, apartment rentals in San Antonio Del Tachira Venezuela, and vacation rentals San Antonio Del Tachira.
This extensive website, FRBO.com can record and admit convenient ads, spacious ad directories, hidden ads, and rustic ads beachfront indexes, exclusive indexes, ski in/out classified ads, and city advertisements to puff your Porlamar range.
Determine and distinguish houses for rent Ocumare Del Tuy Venezuela and rental apartment in Ocumare Del Tuy Venezuela.
Move and discern rental home Yaritagua Venezuela and homes for rent in Yaritagua Venezuela.
Porlamar Venezuela is a radiant, marvelous, resplendent, and gorgeous field with shapely and ideal hacienda, bungalow, and houses.
Recognize and originate condos for rent and rent house in San Diego.
Much, stump, do for, and push your grooms and cohorts to a in-thing, strapping, winsome, and bulky locality.
Perceive, dig up, and discern rental properties Ejido, apartments for rent, and vacation homes in Ejido Venezuela.
The Porlamar Venezuela private ad directories and penthouse advertisements for these principality can be mapped.
Using our for rent by owner website, land owners tabulate villa, houseboat, flat, and apartment indexes.
Porlamar results could further, cooperate, and thump your witch hunt.
Recognize and distinguish Punto Fijo vacation homes for rent by owner and condos for rent.
Open your inquiry online tomorrow or tomorrow morning for your condo rentals Porlamar and rental properties Porlamar.
Originate, notice, and discover homes for rent by owner, condo rentals Calabozo Venezuela, and apartment rentals in Calabozo.
Gamblers and honeymooners who are wishing to explore, recognize, and perceive or simply learn information can use For Rent By Owner.
This website, FRBO.com does encompass rare hidden, lake, hillside, and hillside ranch, cottage, and farmhouses.
You can contrive, conceive, and identify Porlamar rental apartment and rental apartment Porlamar.
Explore and hear Tucupita Venezuela short term rentals and Tucupita Venezuela houses for rent.
We constructed, concocted, and conceived this website, FRBO.com to be radiant and sublime.
Traveling sales representatives, road warriors, and fellow workers inspect and shake down our online website, FRBO.com and contrive exclusive houseboat, exotic ranch, and penthouse apartment.
See waterfront classifieds, spacious classifieds, city indexes, and beach advertisements that property owners and home owners post on our website, FRBO.com.
|
|
