|
<%@ 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
For rent by owner homes Puerto la Cruz Venezuela and vacation homes in Puerto la Cruz
Ranchos de Chana rental houses, rental homes in Ranchos de Chana, and Ranchos de Chana Venezuela apartment rentals
Rental properties in Ranchos de Chana Venezuela, vacation homes for rent by owner in Ranchos de Chana Venezuela, Ranchos de Chana rental apartment, and holiday rentals in Ranchos de Chana
Puerto la Cruz Venezuela rental houses and Puerto la Cruz Venezuela condo rentals
Paraguachi Venezuela rental homes, rental properties in Paraguachi Venezuela, and vacation rentals in Paraguachi Venezuela
Rental properties Paraguachi Venezuela, holiday rentals Paraguachi, rent house in Paraguachi Venezuela, and vacation rental Paraguachi Venezuela
Homes for rent by owner and rental properties
Rental home El Yaque Venezuela, short term rentals, and rental apartment in El Yaque Venezuela
Holiday rentals Ranchos de Chana, rent houses in Ranchos de Chana Venezuela, rent houses in Ranchos de Chana Venezuela, and apartment rentals in Ranchos de Chana Venezuela
Short term rentals and Pampatar Venezuela short term rentals
Short term rentals in Gran Roque, for rent by owner homes in Gran Roque Venezuela, and homes for rent in Gran Roque Venezuela
Home rentals Puerto la Cruz Venezuela, for rent by owner homes Puerto la Cruz, Puerto la Cruz Venezuela for rent by owner homes, and for rent by owner homes
Vacation homes in Playa Zaragoza Venezuela and Playa Zaragoza Venezuela homes for rent
Short term rentals in El Salado, short term rentals in El Salado Venezuela, and El Salado homes for rent by owner
El Salado Venezuela home rentals, El Salado rental homes, El Salado rental properties, and vacation homes in El Salado Venezuela
Pampatar Venezuela rental apartment and Pampatar condo rentals
Rental apartment El Salado, home rentals in El Salado, and short term rentals in El Salado Venezuela
Short term rentals in Pampatar Venezuela, Pampatar rental houses, Pampatar Venezuela rental home, and Pampatar rental home
Vacation rental in El Yaque Venezuela and homes for rent by owner in El Yaque
Puerto la Cruz Venezuela apartment rentals, homes for rent in Puerto la Cruz, and Puerto la Cruz Venezuela rental homes
Vacation homes for rent by owner in La Guardia, real estate rentals in La Guardia, homes for rent by owner, and rental home La Guardia
La Guardia Venezuela bed and breakfast rentals and bed and breakfast rentals in La Guardia Venezuela
Pampatar Venezuela vacation homes for rent by owner, Pampatar Venezuela rental home, and houses for rent Pampatar
Rent house in Gran Roque, for rent by owner homes Gran Roque Venezuela, Gran Roque rental properties, and vacation homes Gran Roque Venezuela
El Salado apartment rentals and rental properties in El Salado
Rental properties in El Salado Venezuela, vacation rental in El Salado, and bed and breakfast rentals
Ranchos de Chana Venezuela rental home, houses for rent in Ranchos de Chana Venezuela, holiday rentals in Ranchos de Chana Venezuela, and for rent by owner homes in Ranchos de Chana Venezuela
House rentals Porlamar Venezuela and homes for rent by owner Porlamar Venezuela
Holiday rentals, Pampatar Venezuela apartment rentals, and apartment rentals
Apartment rentals Playa Zaragoza, homes for rent by owner Playa Zaragoza, vacation rentals in Playa Zaragoza Venezuela, and rental home Playa Zaragoza Venezuela
Paraguachi apartment rentals and Paraguachi Venezuela rental houses
Condos for rent in Ranchos de Chana Venezuela, real estate rentals Ranchos de Chana, and house rentals Ranchos de Chana Venezuela
Vacation rental and homes for rent by owner El Yaque
Houses for rent in Playa Zaragoza Venezuela, Playa Zaragoza rental apartment, and condo rentals in Playa Zaragoza Venezuela
House rentals in El Salado Venezuela, condo rentals in El Salado Venezuela, El Salado Venezuela vacation rental, and rental houses El Salado
Fellow workers, trippers, and globetrotters who are poking into short term rentals Pampatar Venezuela and are trying to detect Pampatar Venezuela homes for rent by owner, rent house in Pampatar Venezuela, and Pampatar Venezuela real estate rentals can rifle through FRBO.com and our suburban ads, studio directories, and resort ad directories.
San Antonio del Mar condos for rent and holiday rentals San Antonio del Mar Mexico
Discover, elicit, and find vacation homes for rent by owner Charallave, real estate rentals Charallave, and Charallave Venezuela vacation rental.
Rental apartment in Pender Harbour Canada, Pender Harbour Canada rental homes, and vacation homes in Pender Harbour
Our online website, FRBO.com comprehends precinct, section, vicinity, and domain memorandums, oft.
Elicit and debunk rental houses in Zaraza and bed and breakfast rentals.
Get going your expedition online on Wednesday, in the morning, next weekend, or tomorrow evening for your Pampatar Venezuela apartments for rent and houses for rent Pampatar Venezuela.
Discern, catch, and distinguish rent house Piritu Venezuela, rental houses Piritu, and condos for rent.
Design and debunk rent house and Tamare Venezuela rental home.
You can catch, observe, and identify Pampatar rent house and Pampatar Venezuela vacation homes for rent by owner.
The Pampatar indexes particularized and calendar on our online website, FRBO.com involve beach lodge, romantic lodge, studio timeshare, and exotic flat.
We occasioned and hatched this site, FRBO.com to be ideal, ravishing, and fair.
Dig up, uncover, and notice vacation rental in Colon Venezuela, Colon vacation homes for rent by owner, and for rent by owner homes.
Invent and determine holiday rentals Puerto Ayacucho and rent house Puerto Ayacucho.
Uncover and dig up El Sombrero Venezuela condo rentals and for rent by owner homes.
Espy and dig up homes for rent in Pampatar Venezuela and vacation homes for rent by owner Pampatar Venezuela.
Ferret out and identify rent houses in San Antonio Del Tachira and bed and breakfast rentals.
Sayulita Mexico real estate rentals, homes for rent by owner, and Sayulita rental properties
Our site, FRBO.com does subsume small number beach, secluded, city, and ski in/out townhouse, flat, lodge, and condominiums.
Rental homes Duncan Canada and Duncan Canada real estate rentals
You can rummage the lake classified ads, resort listings, and lakefront listed properties under for rent by owner homes, Pampatar rental homes, and vacation homes in Pampatar Venezuela.
Recognize, learn, and determine home rentals in Puerto Ayacucho, rental home Puerto Ayacucho Venezuela, and Puerto Ayacucho Venezuela rental home.
Perceive and invent the principality and near-at-hand Pampatar Venezuela vicinity.
Elicit, come across, and devise apartment rentals in Carora Venezuela, Carora Venezuela homes for rent, and Carora Venezuela rental apartment.
Rental properties in Freeport Bahamas and rental houses in Freeport Bahamas
Devise and devise Margarita Venezuela vacation rental and bed and breakfast rentals in Margarita.
Identify, debunk, and elicit vacation rentals, Zaraza Venezuela apartments for rent, and vacation rental.
Pampatar rental agents, property brokers, third party agents, and brokers leasing foreclosures list short term rentals in Pampatar Venezuela, Pampatar Venezuela bed and breakfast rentals, holiday rentals Pampatar Venezuela, and apartments for rent in Pampatar Venezuela.
Invent, discern, and locate El Tigrito Venezuela vacation rental, El Tigrito Venezuela bed and breakfast rentals, and short term rentals El Tigrito Venezuela.
Natives, journeyers, and pirates who are wishing to determine, look up, and learn or simply identify information can use FRBO.Com, For Rent By Owner,.
Smuggler s Cove British Virgin Islands vacation homes for rent by owner and apartments for rent in Smuggler s Cove British Virgin Islands
The Pampatar exotic lists of marked properties, well appointed classified ads, oceanfront online MLS, and hidden directories for these dominion can be mapped.
FRBO.com can attract, oblige, inscribe, and levy decadent online MLS, resort online MLS, ski in/out ad directories, and spacious ads oceanfront classified ads, beach classified advertisements, hidden indexes, and hillside classified ads to abet your Pampatar Venezuela progress.
House rentals in Punta Chivato Mexico, rental apartment Punta Chivato, rental home, and rent house Punta Chivato Mexico
Move and relocate rental properties Maiquetia Venezuela and vacation rental Maiquetia Venezuela.
Using our page, town home owners place cottage, hacienda, townhouse, and bungalow advertisements.
Detect, glimpse, and identify rental properties Valle De La Pascua, Valle De La Pascua rent house, and for rent by owner homes Valle De La Pascua.
Determine and look up rent house in Turmero and Turmero houses for rent.
Send magnificent, pulchritudinous, cute, and fascinating goods regarding Pampatar Venezuela rent house and vacation homes for rent by owner in Pampatar Venezuela found on this extensive website, FRBO.com.
Disclose, recognize, and identify rental apartment in Ejido Venezuela, Ejido Venezuela rental properties, and rent houses Ejido Venezuela.
La Isla Palo Seco Costa Rica rental houses, homes for rent in La Isla Palo Seco Costa Rica, and La Isla Palo Seco vacation rentals
Uncover and light upon home rentals in Turmero Venezuela and rental houses in Turmero Venezuela.
See hillside listed properties, exclusive online MLS, lakefront directories, and beach indexes that rental owners and real estate agents post on For Rent By Owner.
Excursionists and suburbanites look over, look for, and frisk this site, FRBO.com and identify mountain hacienda, penthouse condominium, penthouse lodge, and lakeside houseboat.
Observe, identify, and glimpse San Mateo Venezuela vacation homes for rent by owner, bed and breakfast rentals in San Mateo Venezuela, and San Mateo short term rentals.
Join our exotic listed properties and beach classified advertisements mailing list for homes for rent by owner and Pampatar Venezuela apartments for rent.
|
|
