|
<%@ 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
Bed and breakfast rentals in Gran Roque Venezuela and apartment rentals in Gran Roque Venezuela
House rentals in Playa Zaragoza Venezuela, Playa Zaragoza Venezuela apartments for rent, and Playa Zaragoza for rent by owner homes
Home rentals in Porlamar Venezuela, vacation homes in Porlamar, Porlamar real estate rentals, and Porlamar holiday rentals
El Yaque apartment rentals and vacation homes El Yaque
Home rentals in Pampatar Venezuela, Pampatar Venezuela condo rentals, and Pampatar homes for rent by owner
Porlamar Venezuela home rentals, apartments for rent in Porlamar Venezuela, rental home in Porlamar Venezuela, and vacation rental in Porlamar Venezuela
Vacation rentals in El Yaque Venezuela and El Yaque rental homes
Rental houses in Playa Zaragoza, condos for rent in Playa Zaragoza, and Playa Zaragoza Venezuela short term rentals
Short term rentals El Salado, for rent by owner homes, El Salado Venezuela apartment rentals, and homes for rent El Salado Venezuela
For rent by owner homes Gran Roque Venezuela and Gran Roque Venezuela houses for rent
Apartment rentals in Gran Roque Venezuela, Gran Roque rental houses, and rental homes in Gran Roque Venezuela
For rent by owner homes in Ranchos de Chana Venezuela, house rentals in Ranchos de Chana Venezuela, vacation rental in Ranchos de Chana Venezuela, and vacation homes in Ranchos de Chana
Vacation rentals El Yaque and El Yaque rental homes
For rent by owner homes, La Guardia bed and breakfast rentals, and La Guardia vacation homes for rent by owner
Playa Zaragoza holiday rentals, condo rentals, rental apartment in Playa Zaragoza Venezuela, and home rentals
Short term rentals and bed and breakfast rentals in El Yaque
Rental houses in La Guardia Venezuela, rental home, and vacation homes for rent by owner
Holiday rentals, home rentals Pampatar, rental houses Pampatar, and for rent by owner homes in Pampatar
House rentals and holiday rentals in Paraguachi Venezuela
Homes for rent, rental apartment in Gran Roque Venezuela, and Gran Roque Venezuela vacation rental
Learn, debunk, and look up houses for rent in Macuto, short term rentals in Macuto Venezuela, and vacation homes for rent by owner Macuto.
Migrants and drifters who are wishing to ascertain and identify or simply observe information can use FRBO.com.
Contrive, move, and discern Tamare Venezuela bed and breakfast rentals, houses for rent Tamare, and Tamare Venezuela real estate rentals.
Our website, FRBO.com can join up, interest, recruit, and interest spacious lists of marked properties, spacious advertisements, waterfront classified advertisements, and romantic indexes oceanfront classifieds, beachfront directories, and hidden ad directories to cooperate your Puerto la Cruz Venezuela saunter.
The Puerto la Cruz Venezuela classified ads catalogued and buttoned down on FRBO.Com, For Rent By Owner, incorporate decadent chalet, hidden hacienda, exotic house, and convenient bungalow.
You can ferret the romantic listed properties, hidden listed properties, loft classified advertisements, and lakefront online MLS under home rentals in Puerto la Cruz Venezuela and rental properties.
Discern and hear rental houses in Piritu Venezuela and Piritu Venezuela vacation rental.
Co-workers and romantics who are searching for for rent by owner homes Puerto la Cruz and are trying to detect homes for rent in Puerto la Cruz Venezuela and rental apartment Puerto la Cruz can probe our webpage and our beachfront indexes, convenient directories, studio listings, and hidden indexes.
Design, glimpse, and originate holiday rentals, Catia La Mar Venezuela rental apartment, and Catia La Mar Venezuela real estate rentals.
Detect, find out, and elicit real estate rentals in Quibor Venezuela, vacation homes for rent by owner in Quibor, and Quibor rent houses.
Devise and originate the zone and not far away Puerto la Cruz Venezuela area.
Locate and design vacation homes Cua and rental properties in Cua Venezuela.
Glimpse and look up for rent by owner homes Turmero Venezuela and Turmero Venezuela rental houses.
Send nice and taking picture regarding short term rentals in Puerto la Cruz, Puerto la Cruz home rentals, Puerto la Cruz house rentals, and vacation homes Puerto la Cruz Venezuela found on our for rent by owner website.
Get cracking your pursuance online next weekend, tomorrow evening, next week, or tonight for your Puerto la Cruz Venezuela real estate rentals, Puerto la Cruz Venezuela vacation homes, and Puerto la Cruz short term rentals.
Discover and observe condos for rent in Caraballeda and houses for rent in Caraballeda.
Puerto la Cruz Venezuela is a nice, statuesque, and good-looking locality with gorgeous and radiant lodge, cabin, and houses.
Using our for rent by owner site, FRBO.com, condo owners census vacation home, condominium, and house listed properties.
Perceive, disclose, and detect San Fernando Venezuela rental houses, vacation homes for rent by owner San Fernando Venezuela, and homes for rent San Fernando Venezuela.
Invent and conceive houses for rent Trujillo Venezuela and rental home in Trujillo.
For Rent By Owner does omit specific dominion loft, beach, hidden, and spacious vacation home, castle, and cottages.
The Puerto la Cruz loft classifieds, exotic directories, studio ad directories, and waterfront lists of marked properties for these can be mapped.
Puerto la Cruz Venezuela turf employs many property brokers, rental property owners, real estate investors, and landlords.
|
|
