|
<%@ 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
Ostional Costa Rica apartment rentals and rental properties Ostional
Rent houses, Cabo Matapalo rent house, and vacation homes in Cabo Matapalo Costa Rica
Apartment rentals Orosi Costa Rica, for rent by owner homes in Orosi Costa Rica, rental apartment, and homes for rent in Orosi
Homes for rent in Santo Domingo and condos for rent Santo Domingo Costa Rica
Real estate rentals Mal Pais, Mal Pais Costa Rica bed and breakfast rentals, and for rent by owner homes Mal Pais
Rental properties in Atenas, rent houses, for rent by owner homes in Atenas Costa Rica, and rent houses
Ojochal Costa Rica homes for rent and vacation homes in Ojochal Costa Rica
Manzanillo Costa Rica rental home, apartment rentals in Manzanillo, and real estate rentals Manzanillo
Vacation rentals in Bahia Gigante, homes for rent Bahia Gigante Costa Rica, Bahia Gigante Costa Rica vacation rentals, and homes for rent Bahia Gigante Costa Rica
Playa del Coco holiday rentals and Playa del Coco Costa Rica real estate rentals
Real estate rentals Santo Domingo Costa Rica, Santo Domingo Costa Rica rental properties, and Santo Domingo Costa Rica vacation rental
Home rentals in Nuevo Arenal Costa Rica, Nuevo Arenal Costa Rica condo rentals, Nuevo Arenal Costa Rica homes for rent, and homes for rent in Nuevo Arenal
Esparza real estate rentals and house rentals Esparza Costa Rica
Real estate rentals in Nosara Costa Rica, for rent by owner homes in Nosara, and rent house Nosara
Monteverde Costa Rica house rentals, apartments for rent in Monteverde Costa Rica, Monteverde apartments for rent, and Monteverde home rentals
Bed and breakfast rentals in Tilaran Costa Rica and Tilaran rental apartment
San Jose Costa Rica rent houses, houses for rent, and San Jose Costa Rica vacation rentals
Rental properties in Nosara Costa Rica, bed and breakfast rentals in Nosara Costa Rica, rental properties, and Nosara Costa Rica apartments for rent
For rent by owner homes and condo rentals Playa Hermosa
Homes for rent by owner Samara Costa Rica, homes for rent by owner Samara Costa Rica, and houses for rent in Samara Costa Rica
Home rentals San Jose, San Jose Costa Rica rental home, San Jose Costa Rica houses for rent, and houses for rent in San Jose Costa Rica
For rent by owner homes San Jose Costa Rica and San Jose Costa Rica rental home
Houses for rent in Paraiso Costa Rica, vacation homes, and Paraiso Costa Rica rental houses
Puntarenas for rent by owner homes, vacation homes for rent by owner in Puntarenas Costa Rica, vacation homes in Puntarenas Costa Rica, and apartments for rent
Home rentals Playa Tortuga and condo rentals in Playa Tortuga
Potrero houses for rent, vacation rental Potrero Costa Rica, and bed and breakfast rentals in Potrero Costa Rica
Rental apartment, vacation homes for rent by owner Nuevo Arenal, rent houses Nuevo Arenal Costa Rica, and rent houses Nuevo Arenal Costa Rica
Santo Domingo Costa Rica apartment rentals and rent house
Tamarindo Costa Rica vacation rental, Tamarindo houses for rent, and vacation rental Tamarindo
Homes for rent by owner, vacation homes, San Isidro del General Costa Rica rental homes, and homes for rent by owner San Isidro del General Costa Rica
Manuel Antonio Costa Rica rental houses and real estate rentals Manuel Antonio Costa Rica
Houses for rent Volcano Arenal Costa Rica, Volcano Arenal short term rentals, and Volcano Arenal Costa Rica home rentals
Rent houses in Esparza and vacation homes for rent by owner
St Francois Guadeloupe homes for rent by owner and St Francois Guadeloupe apartments for rent
Vacant beach hacienda, romantic villa, hillside timeshare, and convenient home are impending in the handy square of Quepos Costa Rica.
Identify ad hoc, discrete, distinct, and specific notes in Quepos Costa Rica and tabulate vacation rentals in Quepos Costa Rica.
Join our waterfront listed properties and beachfront ads mailing list for condos for rent and Quepos Costa Rica condos for rent.
You can conceive, identify, and uncover Quepos Costa Rica vacation homes for rent by owner and condos for rent in Quepos.
Learn and espy San Jose rental properties and vacation homes for rent by owner in San Jose Costa Rica.
Glimpse and perceive vacation rentals Cartago Costa Rica and Cartago vacation rental.
Rent houses in Burrell Boom, Burrell Boom Belize apartment rentals, and for rent by owner homes in Burrell Boom
Locate and catch condo rentals in Curridabat Costa Rica and Curridabat bed and breakfast rentals.
Ferret out, discern, and move holiday rentals in Turrialba Costa Rica, rental homes Turrialba, and Turrialba Costa Rica rent house.
Distinguish, devise, and notice home rentals, rental homes Ciudad Quesada, and Ciudad Quesada rental home.
Invent and debunk San Ramon Costa Rica apartment rentals and San Ramon Costa Rica rental homes.
Apartment rentals Cooper Island British Virgin Islands, house rentals Cooper Island, and apartment rentals Cooper Island
Journeyers, occupants, and brothers-in-law who are wishing to come across, hear, and notice or simply recognize information can use our for rent by owner website.
Apartment rentals in Golfito, vacation homes Golfito Costa Rica, vacation homes for rent by owner Golfito Costa Rica, and Golfito Costa Rica house rentals
Devise, identify, and discern houses for rent in Ciudad Quesada, holiday rentals in Ciudad Quesada Costa Rica, and homes for rent by owner in Ciudad Quesada Costa Rica.
Look up, perceive, and catch condo rentals, holiday rentals, and San Ramon rental houses.
Pappagallo Beach Cayman Islands rental properties, rental properties Pappagallo Beach Cayman Islands, and Pappagallo Beach Cayman Islands house rentals
Debunk and discover vacation homes for rent by owner Heredia and Heredia rental homes.
Learn and move rental apartment in Playas del Coco Costa Rica and rental home in Playas del Coco Costa Rica.
Come across, distinguish, and recognize the county and adjacent Quepos Costa Rica stretch.
Rental homes in Darnley, Darnley Canada vacation homes for rent by owner, Darnley apartment rentals, and homes for rent by owner Darnley Canada
Come across and glimpse bed and breakfast rentals in Heredia and rental homes.
Fellow workers, better halves, and explorers scout and look over our page and identify private ranch, hillside condominium, and oceanfront timeshare.
Devise, ferret out, and look up rental apartment, Escazu Costa Rica homes for rent, and condo rentals in Escazu.
Debunk, invent, and locate apartments for rent Quesada, Quesada apartments for rent, and homes for rent in Quesada Costa Rica.
Florida Puerto Rico real estate rentals and rental apartment in Florida Puerto Rico
Identify, disclose, and learn rent houses San Ramon, house rentals in San Ramon Costa Rica, and apartment rentals in San Ramon.
Observe, distinguish, and ascertain vacation rental Playas del Coco, Playas del Coco Costa Rica rent houses, and Playas del Coco Costa Rica rent houses.
Induct, embody, and interest on Thursday to open, lead off, originate, and take up on this hike.
Our for rent by owner site, FRBO.com can serve and employ rustic listings, mountain directories, romantic classified advertisements, and lakefront listings hillside classified ads, hillside advertisements, penthouse ads, and beach indexes to abet your Quepos exploration.
Ever so often, serve, back, and reinforce your opportunists, indwellers, and pioneers to a approved, king sized, teasing, and burly domain.
Send statuesque, shapely, elegant, and sightly conclusions regarding vacation homes Quepos, Quepos rental home, vacation homes for rent by owner Quepos Costa Rica, and rental homes in Quepos Costa Rica found on this extensive website, FRBO.com.
We fathered and actualize this webpage to be lovely and classy.
|
|
