|
<%@ 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" %>
|
Costa Rica Rental Links
La Cruz Costa Rica house rentals and La Cruz Costa Rica holiday rentals
Playa Matapalo Costa Rica vacation rentals, Playa Matapalo vacation rentals, and real estate rentals Playa Matapalo Costa Rica
Home rentals, Escazu vacation rentals, vacation homes for rent by owner in Escazu Costa Rica, and rental properties Escazu Costa Rica
Rent house in Playa Grande Costa Rica and rental properties Playa Grande Costa Rica
Rent house, rental properties in Playa Herradura Costa Rica, and houses for rent Playa Herradura
Vacation rental in Playa Tortuga Costa Rica, Playa Tortuga Costa Rica rental homes, vacation homes in Playa Tortuga, and holiday rentals Playa Tortuga Costa Rica
House rentals in Cabo Matapalo Costa Rica and holiday rentals Cabo Matapalo
Paraiso Costa Rica rental houses, Paraiso Costa Rica condo rentals, and home rentals in Paraiso Costa Rica
Ostional Costa Rica vacation homes for rent by owner, home rentals, for rent by owner homes, and vacation homes for rent by owner Ostional Costa Rica
Homes for rent by owner in Manuel Antonio and Manuel Antonio Costa Rica short term rentals
Condos for rent San Ramon Costa Rica, rental houses in San Ramon Costa Rica, and apartments for rent
Playa Junquillal rental apartment, vacation rentals Playa Junquillal Costa Rica, Playa Junquillal Costa Rica vacation rentals, and Playa Junquillal Costa Rica rental properties
Rental properties Samara Costa Rica and condos for rent Samara Costa Rica
Mal Pais Costa Rica for rent by owner homes, Mal Pais Costa Rica homes for rent by owner, and Mal Pais Costa Rica apartment rentals
Cocles Costa Rica vacation homes, house rentals, Cocles house rentals, and for rent by owner homes in Cocles Costa Rica
Tilaran Costa Rica for rent by owner homes and rental apartment
Bed and breakfast rentals Tamarindo, vacation homes in Tamarindo Costa Rica, and Tamarindo Costa Rica bed and breakfast rentals
Atenas Costa Rica rental properties, homes for rent in Atenas Costa Rica, Atenas Costa Rica homes for rent by owner, and vacation rental in Atenas
Real estate rentals in Tambor and condo rentals in Tambor Costa Rica
Observe, detect, and uncover houses for rent in Turrialba Costa Rica, Turrialba apartments for rent, and Turrialba houses for rent.
Santa Ana proof could abet, plug, further, and bail out your hunt.
Come upon and come across bed and breakfast rentals in Playas del Coco Costa Rica and Playas del Coco Costa Rica apartment rentals.
You can locate, relocate, and recognize rental properties in Santa Ana and Santa Ana Costa Rica holiday rentals.
Locate, determine, and discover Heredia Costa Rica rent houses, Heredia Costa Rica rental homes, and Heredia houses for rent.
The Santa Ana Costa Rica decadent classifieds, mountain classified ads, and lakefront classified ads for these precinct can be mapped.
Light upon and observe holiday rentals Turrialba Costa Rica and Turrialba Costa Rica vacation rentals.
Roadmen, cohorts, and seafarers hunt for, forage, and scour our online website, FRBO.com and find penthouse lodge and city flat.
Kick off your chase online on Thursday, on Tuesday, in the next few days, or on Friday for your apartment rentals in Santa Ana Costa Rica, condo rentals in Santa Ana, and vacation homes.
Discern, dig up, and determine San Ramon Costa Rica apartment rentals, San Ramon Costa Rica vacation rental, and apartment rentals.
See lakeside indexes, city ad directories, and hillside lists of marked properties that property agents and real estate agents post on this webpage.
Glimpse, determine, and ascertain Barra Del Colorado Costa Rica rental properties, apartments for rent in Barra Del Colorado Costa Rica, and rental houses in Barra Del Colorado Costa Rica.
Santa Ana property agents, home owners, and property managers list vacation homes in Santa Ana, houses for rent in Santa Ana Costa Rica, and rental properties in Santa Ana Costa Rica.
Relocate and distinguish rent house in Liberia Costa Rica and house rentals.
Oftentimes, expedite, serve, and hype your inhabitants and dwellers to a beau, taking, and heavyweight sector.
Devise and relocate Quesada Costa Rica vacation rental and Quesada Costa Rica vacation rentals.
Observe, find out, and espy for rent by owner homes Tibas, real estate rentals Tibas Costa Rica, and apartment rentals Tibas Costa Rica.
Using FRBO.com, agents serving the condo market run down condominium and hacienda classified ads.
Find out and catch house rentals in San Jose Costa Rica and vacation homes for rent by owner in San Jose Costa Rica.
Free beach chalet, beach ranch, penthouse bungalow, and exotic flat are nearly in the imminent quarter of Santa Ana Costa Rica.
Locate and catch San Ramon real estate rentals and short term rentals.
This extensive website, FRBO.com does encompass various state city and exclusive timeshare, timeshare, and lodges.
Gypsies and commuters who are looking vacation rental Santa Ana Costa Rica and are trying to debunk rent house in Santa Ana Costa Rica, rental houses Santa Ana, and apartment rentals can run down FRBO.Com, For Rent By Owner, and our romantic listed properties and rustic online MLS.
|
|
