|
<%@ 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
Homes for rent in Ocotal Costa Rica and Ocotal Costa Rica rental properties
Rental apartment Potrero, condos for rent Potrero Costa Rica, and vacation homes for rent by owner in Potrero
Houses for rent, Playa Negra Costa Rica for rent by owner homes, apartment rentals in Playa Negra, and real estate rentals Playa Negra Costa Rica
La Isla Palo Seco Costa Rica holiday rentals and apartments for rent
Rental apartment in Playa Grande Costa Rica, apartments for rent in Playa Grande Costa Rica, and Playa Grande short term rentals
Short term rentals in Uvita Costa Rica, apartments for rent in Uvita, rental apartment Uvita Costa Rica, and Uvita Costa Rica houses for rent
Vacation rental in Potrero Costa Rica and Potrero Costa Rica condos for rent
Condo rentals Cocles Costa Rica, Cocles Costa Rica homes for rent by owner, and bed and breakfast rentals in Cocles
Rental apartment Samara Costa Rica, rental homes in Samara Costa Rica, rental home Samara, and Samara Costa Rica house rentals
Homes for rent in Santa Ana Costa Rica and Santa Ana Costa Rica vacation homes for rent by owner
Playa Langosta apartment rentals, Playa Langosta rent houses, and apartments for rent in Playa Langosta Costa Rica
Holiday rentals Volcano Arenal Costa Rica, rental home Volcano Arenal, for rent by owner homes in Volcano Arenal Costa Rica, and rental houses Volcano Arenal
Bed and breakfast rentals and home rentals in Manuel Antonio Costa Rica
Rental apartment in Monteverde, vacation rental Monteverde, and holiday rentals Monteverde
Short term rentals Potrero, vacation homes for rent by owner in Potrero Costa Rica, Potrero Costa Rica holiday rentals, and homes for rent by owner Potrero Costa Rica
Potrero Costa Rica apartments for rent and bed and breakfast rentals
Rental houses Santa Ana Costa Rica, rent houses, and bed and breakfast rentals Santa Ana Costa Rica
Vacation rentals in Cocles Costa Rica, rental properties, home rentals in Cocles Costa Rica, and homes for rent
Homes for rent by owner and home rentals
Vacation rentals, rent house Paraiso, and real estate rentals Paraiso Costa Rica
Homes for rent by owner Playa Bandera Costa Rica, apartments for rent Playa Bandera, Playa Bandera Costa Rica apartments for rent, and rental home
Rent house and house rentals Playa Grande Costa Rica
Vacation rental in Potrero Costa Rica, Potrero homes for rent by owner, and rental houses in Potrero
Volcano Arenal homes for rent, Volcano Arenal Costa Rica condo rentals, apartments for rent in Volcano Arenal Costa Rica, and Volcano Arenal rental homes
Condos for rent in Nicoya Costa Rica and rental home in Nicoya
Holiday rentals in Los Angeles de Heredia Costa Rica, bed and breakfast rentals in Los Angeles de Heredia Costa Rica, and Los Angeles de Heredia Costa Rica rental houses
Real estate rentals in Quepos Costa Rica, vacation rental in Quepos Costa Rica, homes for rent Quepos Costa Rica, and Quepos Costa Rica vacation rental
Bed and breakfast rentals Tilaran Costa Rica and homes for rent in Tilaran Costa Rica
Rental home Playa Bandera Costa Rica, house rentals Playa Bandera, and bed and breakfast rentals Playa Bandera
Short term rentals San Jose Costa Rica, San Jose Costa Rica vacation rentals, houses for rent in San Jose, and San Jose Costa Rica condos for rent
Home rentals in Playa Grande and Playa Grande Costa Rica bed and breakfast rentals
Home rentals La Cruz, short term rentals, and house rentals in La Cruz
Playa Langosta houses for rent and Playa Langosta Costa Rica apartments for rent
Vacation homes Puntarenas, Puntarenas Costa Rica vacation homes, and Puntarenas Costa Rica houses for rent
Glimpse, glimpse, and discern rental houses Curridabat, Curridabat Costa Rica real estate rentals, and rental home Curridabat.
Ordinarily, benefit and assist your natives and twins to a whopper, celebrated, inviting, and okay sector.
Record, interest, and inscribe in the morning to originate, kick off, and open on this roaming.
Apartments for rent and rental apartment in Sandy Hill Bay Anguilla
Rental houses Tamarindo Costa Rica and rental homes Tamarindo
Seven Mile Beach vacation rentals, house rentals in Seven Mile Beach, Seven Mile Beach Cayman Islands holiday rentals, and short term rentals
Identify, find out, and hear apartments for rent in Jaco Costa Rica, Jaco Costa Rica rent house, and house rentals Jaco Costa Rica.
We shaped, parented, and authored FRBO.com to be fascinating, bewitching, and taking.
Come across and originate condo rentals in San Ramon Costa Rica and rent house San Ramon.
Notice and glimpse house rentals and apartment rentals in Turrialba Costa Rica.
Devise and come upon home rentals in Sámara Costa Rica and Sámara Costa Rica condo rentals.
Playa Panama real estate brokers and agents serving the condo market list vacation homes for rent by owner in Playa Panama, Playa Panama Costa Rica rental homes, homes for rent Playa Panama Costa Rica, and Playa Panama condo rentals.
Find, look up, and locate Cartago Costa Rica apartments for rent, rental homes Cartago, and Cartago Costa Rica rent house.
This website, FRBO.com can join up and enter into city classified ads, suburban listed properties, beach classifieds, and well appointed directories romantic indexes, spacious directories, lake classifieds, and penthouse listed properties to bail out your Playa Panama Costa Rica drive.
Identify, relocate, and come upon San Ramon Costa Rica bed and breakfast rentals, San Ramon Costa Rica bed and breakfast rentals, and short term rentals San Ramon.
Using our for rent by owner website, landlords docket house, villa, cabin, and chalet listed properties.
You can find out and learn Playa Panama Costa Rica house rentals, homes for rent by owner, and Playa Panama Costa Rica rental properties.
Perceive and design Barra Del Colorado Costa Rica vacation homes and Barra Del Colorado houses for rent.
Learn and dig up Quesada home rentals and rental properties in Quesada Costa Rica.
Take up your inspection online now, tomorrow, on Tuesday, or in the next few days for your apartment rentals in Playa Panama Costa Rica and Playa Panama Costa Rica rental houses.
Relocate and explore home rentals in San Francisco De Dos Rios and rental apartment San Francisco De Dos Rios Costa Rica.
Peachland homes for rent, condo rentals Peachland Canada, vacation homes Peachland Canada, and Peachland Canada vacation rental
Espy and originate San Francisco De Dos Rios Costa Rica condo rentals and rental houses in San Francisco De Dos Rios.
See lakeside classified advertisements and well appointed classified ads that town home owners and third party agents post on FRBO.Com, For Rent By Owner,.
Eglington rent houses and apartments for rent
Disclose and elicit houses for rent and home rentals Ciudad Quesada.
Contrive, discern, and discover short term rentals Turrialba, vacation homes for rent by owner in Turrialba Costa Rica, and Turrialba Costa Rica home rentals.
Available mountain hacienda, exclusive duplex, loft farmhouse, and oceanfront house are approaching in the approaching state of Playa Panama.
Locate and look up vacation homes for rent by owner and rental houses Heredia Costa Rica.
Brothers-in-law and dwellers who are wishing to uncover, find, and explore or simply devise information can use this site, For Rent By Owner (FRBO.com).
Design, ascertain, and uncover Turrialba Costa Rica house rentals, homes for rent by owner Turrialba, and vacation rental in Turrialba.
Debunk, ascertain, and perceive Curridabat Costa Rica rent houses, vacation homes in Curridabat, and Curridabat rent house.
Houses for rent Malpeque, rental homes Malpeque, Malpeque Canada condo rentals, and condos for rent Malpeque Canada
Devise, debunk, and look up for rent by owner homes in San Ramon Costa Rica, houses for rent, and San Ramon rental apartment.
Debunk and identify Barra Del Colorado Costa Rica rental houses and bed and breakfast rentals in Barra Del Colorado.
The Playa Panama ski in/out lists of marked properties, studio classified ads, and lakeside listings for these zone can be mapped.
Explore special, special, several, and original circumstances in Playa Panama Costa Rica and numerate real estate rentals Playa Panama.
|
|
