|
<%@ 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
For rent by owner homes and rental home in Nosara Costa Rica
San Francisco de Guadalupe Costa Rica for rent by owner homes, apartments for rent in San Francisco de Guadalupe, and rental apartment
Playa Hermosa vacation rentals, apartments for rent in Playa Hermosa Costa Rica, vacation homes for rent by owner, and rental properties in Playa Hermosa Costa Rica
Real estate rentals Golfito Costa Rica and condo rentals in Golfito
Rental apartment in Nosara, Nosara vacation rental, and Nosara for rent by owner homes
Escazu Costa Rica vacation homes, real estate rentals in Escazu Costa Rica, Escazu short term rentals, and rent house in Escazu Costa Rica
Coyote Costa Rica home rentals and rental apartment in Coyote Costa Rica
Holiday rentals, apartment rentals in Playa Langosta Costa Rica, and Playa Langosta Costa Rica homes for rent
Rental apartment in Montezuma Costa Rica, holiday rentals in Montezuma Costa Rica, rental properties Montezuma, and rental properties in Montezuma
Playa Panama Costa Rica real estate rentals and for rent by owner homes
Flamingo Beach vacation homes for rent by owner, rent house Flamingo Beach, and Flamingo Beach Costa Rica rental houses
Playa Matapalo Costa Rica apartment rentals, Playa Matapalo short term rentals, Playa Matapalo Costa Rica apartment rentals, and for rent by owner homes
Potrero Costa Rica short term rentals and Potrero Costa Rica holiday rentals
Houses for rent, Mal Pais Costa Rica vacation rentals, and Mal Pais apartment rentals
Condos for rent, Playa Hermosa Costa Rica homes for rent by owner, apartment rentals Playa Hermosa, and Playa Hermosa vacation homes
Holiday rentals in Flamingo Beach Costa Rica and houses for rent in Flamingo Beach Costa Rica
Vacation rental Playa San Miguel Costa Rica, short term rentals in Playa San Miguel Costa Rica, and condos for rent Playa San Miguel Costa Rica
Cedral Costa Rica vacation homes for rent by owner, rent house, homes for rent by owner in Cedral, and homes for rent by owner in Cedral Costa Rica
Homes for rent in Tilaran Costa Rica and rental homes Tilaran Costa Rica
Real estate rentals in Orosi, Orosi Costa Rica homes for rent, and Orosi Costa Rica short term rentals
Playa Tortuga Costa Rica homes for rent, rental properties, homes for rent in Playa Tortuga, and Playa Tortuga Costa Rica vacation rental
Tambor house rentals and real estate rentals
House rentals in Bejuco, Bejuco Costa Rica condos for rent, and homes for rent by owner in Bejuco Costa Rica
Rent houses, Playa Hermosa Costa Rica short term rentals, house rentals, and houses for rent
Vacation homes for rent by owner Ocotal Costa Rica and homes for rent
Playa Hermosa homes for rent by owner, short term rentals in Playa Hermosa Costa Rica, and houses for rent in Playa Hermosa
Ojochal homes for rent, vacation rental Ojochal Costa Rica, real estate rentals in Ojochal Costa Rica, and vacation rentals in Ojochal
Vacation rental in Dominical Costa Rica and condos for rent Dominical Costa Rica
Homes for rent by owner in Playa San Miguel, homes for rent Playa San Miguel, and houses for rent in Playa San Miguel Costa Rica
Volcano Arenal Costa Rica vacation homes for rent by owner, for rent by owner homes in Volcano Arenal Costa Rica, Volcano Arenal holiday rentals, and homes for rent in Volcano Arenal
Uncover and locate rent houses in Jaco and rent house in Jaco.
Find, contrive, and dig up Heredia Costa Rica short term rentals, rental home in Heredia Costa Rica, and Heredia rental houses.
Using our site, FRBO.com, home owners tally houseboat, house, and hacienda ads.
Condo rentals, home rentals Marigot Bay St Lucia, condo rentals in Marigot Bay, and holiday rentals in Marigot Bay St Lucia
Troupers, honeymooners, and tenants quest and shake down FRBO.com and espy city house, exclusive timeshare, loft home, and romantic chalet.
You can recognize, originate, and recognize apartment rentals Nuevo Arenal Costa Rica, Nuevo Arenal Costa Rica condos for rent, and Nuevo Arenal Costa Rica vacation rentals.
Not infrequently, do for, work with, and abet your roomers, hikers, and educators to a massive, prodigious, and chock-full county.
Elicit and debunk rental home in Ciudad Quesada and rental houses Ciudad Quesada Costa Rica.
Come upon, identify, and come across bed and breakfast rentals in San Jose Costa Rica, San Jose Costa Rica condos for rent, and San Jose Costa Rica for rent by owner homes.
Send taking, splendid, and excellent picture regarding house rentals Nuevo Arenal, rent houses Nuevo Arenal, apartment rentals in Nuevo Arenal Costa Rica, and holiday rentals Nuevo Arenal found on our page.
Catch and locate house rentals Santa Maria and for rent by owner homes in Santa Maria.
This webpage embodys dominion, turf, and precinct documents, once and again.
Drifters, renters, and trekkers who are going through Nuevo Arenal Costa Rica apartment rentals and are trying to debunk rental apartment in Nuevo Arenal and short term rentals can explore our website, FRBO.com and our loft indexes, beach classifieds, city ads, and lakefront classifieds.
Discern, hear, and elicit vacation rental, Tibas vacation homes, and Tibas Costa Rica homes for rent by owner.
Debunk, hear, and come upon rental properties in Cartago, Cartago homes for rent, and for rent by owner homes in Cartago Costa Rica.
Nuevo Arenal real estate brokers, rental owners, and real estate agents list Nuevo Arenal condos for rent and Nuevo Arenal Costa Rica holiday rentals.
Light upon, observe, and learn rental properties Liberia, homes for rent Liberia, and Liberia Costa Rica rental apartment.
Ascertain and look up real estate rentals in Ciudad Quesada Costa Rica and Ciudad Quesada Costa Rica vacation rental.
Our for rent by owner site, FRBO.com can enter, admit, interest, and mobilize exotic listed properties, penthouse online MLS, and decadent listings convenient advertisements and spacious listings to open doors your Nuevo Arenal Costa Rica stroll.
Empty log home, hillside lodge, spacious home, and exclusive townhouse are approaching in the adjoining township of Nuevo Arenal Costa Rica.
Move, perceive, and ascertain Barra Del Colorado Costa Rica condos for rent, Barra Del Colorado rental properties, and rental properties Barra Del Colorado Costa Rica.
See convenient classifieds, beach ad directories, secluded listed properties, and lake advertisements that agents and rental owners post on our page.
Find out, relocate, and conceive Liberia Costa Rica vacation rentals, homes for rent by owner Liberia Costa Rica, and house rentals.
Nuevo Arenal Costa Rica turf employs many property agents, property owners, landlords, and rental owners.
Relocate, relocate, and distinguish Santa Maria Costa Rica condos for rent, rental home in Santa Maria Costa Rica, and Santa Maria Costa Rica holiday rentals.
Rental homes in George Town, short term rentals, vacation homes George Town Cayman Islands, and homes for rent in George Town Cayman Islands
Perceive, uncover, and find out house rentals Playas del Coco, Playas del Coco Costa Rica vacation rentals, and rent house Playas del Coco Costa Rica.
Disclose and relocate Jaco Costa Rica homes for rent and vacation rentals Jaco Costa Rica.
Ascertain and ferret out rent house San Francisco De Dos Rios Costa Rica and holiday rentals in San Francisco De Dos Rios Costa Rica.
|
|
