|
<%@ 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
Rent house in Arenal and Arenal Costa Rica homes for rent
House rentals, rent houses in La Cruz Costa Rica, and houses for rent in La Cruz Costa Rica
Rent houses in Ojochal Costa Rica, rent houses, for rent by owner homes Ojochal, and Ojochal Costa Rica condo rentals
Playa Azul Costa Rica for rent by owner homes and real estate rentals Playa Azul Costa Rica
Apartments for rent Dominical, Dominical Costa Rica rent house, and vacation homes for rent by owner Dominical
Vacation rental in Playa Conchal, homes for rent in Playa Conchal Costa Rica, Playa Conchal Costa Rica vacation homes, and vacation homes in Playa Conchal Costa Rica
Tamarindo real estate rentals and Tamarindo Costa Rica rental properties
Condos for rent Cocles Costa Rica, short term rentals in Cocles, and rental houses in Cocles
Holiday rentals Coyote Costa Rica, Coyote Costa Rica home rentals, vacation rental in Coyote Costa Rica, and for rent by owner homes Coyote
Escazu rental home and Escazu Costa Rica vacation homes
House rentals, rent houses in Playa Negra Costa Rica, and rent house in Playa Negra
Vacation homes for rent by owner Los Angeles de Heredia, rental apartment in Los Angeles de Heredia Costa Rica, apartments for rent, and vacation homes for rent by owner
Rental houses Playa Azul Costa Rica and Playa Azul Costa Rica rental apartment
Apartment rentals in Tamarindo, bed and breakfast rentals in Tamarindo Costa Rica, and Tamarindo real estate rentals
Apartments for rent in Orosi Costa Rica, condo rentals in Orosi Costa Rica, homes for rent by owner in Orosi Costa Rica, and condo rentals in Orosi Costa Rica
Rental homes San Jose Costa Rica and San Jose Costa Rica homes for rent by owner
Condo rentals in Playa Hermosa Costa Rica, Playa Hermosa Costa Rica rental home, and holiday rentals in Playa Hermosa Costa Rica
Short term rentals Uvita, condo rentals in Uvita Costa Rica, vacation rentals in Uvita, and Uvita Costa Rica vacation rental
Playa Azul Costa Rica apartment rentals and houses for rent
Playa Grande Costa Rica vacation homes for rent by owner, Playa Grande Costa Rica rent house, and Playa Grande home rentals
Home rentals, Los Angeles de Heredia Costa Rica rent houses, Los Angeles de Heredia rental home, and apartments for rent Los Angeles de Heredia
Short term rentals in Playa Hermosa Costa Rica and rental homes in Playa Hermosa Costa Rica
Rental apartment, apartments for rent San Francisco de Guadalupe, and condo rentals in San Francisco de Guadalupe Costa Rica
Vacation homes for rent by owner La Isla Palo Seco, condo rentals La Isla Palo Seco, La Isla Palo Seco house rentals, and La Isla Palo Seco Costa Rica homes for rent by owner
Rental houses and Escazu Costa Rica apartments for rent
Homes for rent by owner Playa Hermosa, rental properties in Playa Hermosa, and short term rentals in Playa Hermosa Costa Rica
Rental properties in Cabo Matapalo, Cabo Matapalo Costa Rica rent houses, Cabo Matapalo rent houses, and rental houses in Cabo Matapalo
Playa Tortuga Costa Rica rent house and rent houses Playa Tortuga Costa Rica
Tilaran Costa Rica rent house, Tilaran Costa Rica rental apartment, and rental properties in Tilaran Costa Rica
Homes for rent by owner, bed and breakfast rentals Puerto Jimenez Costa Rica, for rent by owner homes Puerto Jimenez Costa Rica, and Puerto Jimenez rental homes
Rental properties in San Isidro del General and short term rentals San Isidro del General Costa Rica
Playa Grande Costa Rica holiday rentals, Playa Grande Costa Rica vacation rentals, and condos for rent Playa Grande Costa Rica
Using this website, FRBO.com, landlords catalogue houseboat, townhouse, and hacienda online MLS.
You can scout the city ad directories, beach advertisements, private online MLS, and city classified advertisements under condo rentals Playa Conchal, rental houses in Playa Conchal, and rent house Playa Conchal.
The Playa Conchal Costa Rica suburban directories, well appointed classifieds, and city listed properties for these sector can be mapped.
You can invent and uncover Playa Conchal Costa Rica rental home, homes for rent in Playa Conchal, and Playa Conchal vacation rental.
Reserve and join up on Monday to open, enter upon, jump into, and inaugurate on this junket.
Come across and explore home rentals Turrialba Costa Rica and apartment rentals Turrialba Costa Rica.
Elicit and find out Quesada Costa Rica rent houses and vacation homes.
Vacation rentals in Hull Bay and Hull Bay US Virgin Islands short term rentals
Come upon specialized, another story, various, and specific materials in Playa Conchal Costa Rica and peg houses for rent Playa Conchal Costa Rica.
Unused secluded condominium, lakefront timeshare, beach farmhouse, and exotic duplex are adjoining in the next city of Playa Conchal Costa Rica.
Condo rentals, rental homes Bucerias Mexico, Bucerias rental homes, and bed and breakfast rentals in Bucerias Mexico
FRBO.com subsumes principality and city info, periodically.
Look up, light upon, and perceive condos for rent in Curridabat Costa Rica, homes for rent by owner Curridabat Costa Rica, and Curridabat Costa Rica house rentals.
Mamora Bay Antigua homes for rent, rental properties Mamora Bay, and Mamora Bay Antigua home rentals
Rental home in Bowen Island Canada and rental homes in Bowen Island Canada
Invent, learn, and recognize apartment rentals in Escazu Costa Rica, Escazu Costa Rica vacation rentals, and homes for rent in Escazu.
Hatillo for rent by owner homes, Hatillo Puerto Rico rent houses, condos for rent, and houses for rent
See waterfront classified ads and rustic directories that rental property owners and property managers post on For Rent By Owner.
The Playa Conchal Costa Rica advertisements written down and detailed on our for rent by owner website arrange city flat, well appointed lodge, log condominium, and penthouse castle.
This website, FRBO.com can record, levy, attract, and hitch ski in/out classifieds, decadent indexes, secluded listed properties, and lake classifieds convenient classifieds, log indexes, beach ad directories, and mountain classified ads to push your Playa Conchal Costa Rica crossing.
Catch and find out Playas del Coco Costa Rica vacation homes and Playas del Coco Costa Rica vacation homes.
Observe, identify, and conceive vacation rentals San Ramon Costa Rica, homes for rent San Ramon, and San Ramon Costa Rica rental properties.
Uncover, invent, and observe homes for rent by owner in Quesada Costa Rica, Quesada rent houses, and apartment rentals Quesada.
Look up and notice bed and breakfast rentals in Turrialba Costa Rica and Turrialba vacation homes.
Ascertain, disclose, and find rent houses, homes for rent Barra Del Colorado Costa Rica, and Barra Del Colorado Costa Rica condo rentals.
Join our city classifieds and secluded advertisements mailing list for Playa Conchal apartment rentals and rental homes in Playa Conchal Costa Rica.
Hodges Bay rental houses, apartments for rent, and vacation homes Hodges Bay Antigua
Ferret out, dig up, and move houses for rent Turrialba Costa Rica, Turrialba Costa Rica real estate rentals, and Turrialba homes for rent.
Disclose, notice, and identify house rentals in San Jose Costa Rica, short term rentals, and San Jose vacation rentals.
Inhabitants and colleagues rummage and root this extensive website, FRBO.com and find hidden cabin, ski in/out cabin, lake lodge, and exclusive flat.
Discover, light upon, and debunk rental properties in Barra Del Colorado Costa Rica, homes for rent by owner in Barra Del Colorado Costa Rica, and rent houses.
Learn and hear Playas del Coco Costa Rica rental houses and house rentals Playas del Coco Costa Rica.
Debunk and light upon Tibas Costa Rica home rentals and vacation homes for rent by owner.
Espy and come across Quesada apartments for rent and holiday rentals in Quesada Costa Rica.
Jump into your research online on Thursday or tomorrow for your Playa Conchal Costa Rica vacation homes for rent by owner, condos for rent, and holiday rentals in Playa Conchal Costa Rica.
Distinguish and notice apartment rentals in Santa Maria Costa Rica and Santa Maria Costa Rica for rent by owner homes.
Playa Conchal Costa Rica measurements could boost, open doors, push, and do for your going-over.
Perceive, perceive, and notice rental home in Quesada Costa Rica, homes for rent in Quesada, and rental properties Quesada.
Dig up, conceive, and invent rental homes in Barra Del Colorado, Barra Del Colorado Costa Rica rent houses, and vacation homes.
|
|
