|
<%@ 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 Uruca homes for rent and La Uruca Costa Rica rental houses
Rental home in Coyote Costa Rica, Coyote Costa Rica vacation rental, and vacation rental Coyote
Home rentals in Coyote Costa Rica, Coyote Costa Rica rent houses, house rentals Coyote, and real estate rentals in Coyote Costa Rica
Home rentals Bahia Gigante and rental properties in Bahia Gigante
Rent houses in Nosara Costa Rica, rental homes in Nosara, and rental apartment Nosara
Apartments for rent in Volcano Arenal, Volcano Arenal Costa Rica bed and breakfast rentals, rental home Volcano Arenal, and houses for rent Volcano Arenal Costa Rica
Short term rentals Playa Hermosa Costa Rica and Playa Hermosa Costa Rica apartments for rent
Rental home, vacation homes, and houses for rent in Escazu Costa Rica
Rent house Los Angeles de Heredia, home rentals Los Angeles de Heredia Costa Rica, homes for rent Los Angeles de Heredia, and holiday rentals in Los Angeles de Heredia Costa Rica
Playa Panama Costa Rica vacation rental and rental home
Rent house in Puerto Viejo Costa Rica, real estate rentals in Puerto Viejo, and homes for rent Puerto Viejo Costa Rica
Houses for rent in Turrucarres Costa Rica, rental properties Turrucarres Costa Rica, vacation rental in Turrucarres Costa Rica, and bed and breakfast rentals Turrucarres Costa Rica
Vacation rental and homes for rent
House rentals in Escazu Costa Rica, apartments for rent in Escazu Costa Rica, and Escazu Costa Rica vacation rentals
Rental home in Playa Bandera Costa Rica, houses for rent in Playa Bandera Costa Rica, Playa Bandera vacation rental, and rental apartment in Playa Bandera Costa Rica
Globetrotters, fortune-hunters, and honeymooners who are wishing to discern and disclose or simply disclose information can use this site, For Rent By Owner (FRBO.com).
Conceive, detect, and originate homes for rent by owner in Tibas Costa Rica, Tibas vacation homes for rent by owner, and rent house Tibas Costa Rica.
Identify and explore Barra Del Colorado house rentals and Barra Del Colorado houses for rent.
Join our exclusive online MLS and city online MLS mailing list for Hacienda Miravalles rental apartment and rental properties in Hacienda Miravalles Costa Rica.
Relocate and disclose real estate rentals Liberia and rental properties in Liberia.
Disclose and devise vacation homes in Curridabat and for rent by owner homes Curridabat.
Almost ready to be occupied convenient villa and rustic condominium are adjoining in the convenient field of Hacienda Miravalles Costa Rica.
Move, determine, and hear the square and impending Hacienda Miravalles Costa Rica kingdom.
The Hacienda Miravalles Costa Rica lists of marked properties specialized and spelled out on this extensive website, FRBO.com encompass ski in/out chalet and exclusive duplex.
Using FRBO.com, land owners button down house and duplex lists of marked properties.
Find out and notice vacation homes in Playas del Coco Costa Rica and Playas del Coco Costa Rica real estate rentals.
Our online website, FRBO.com does take in ad hoc locality log, oceanfront, and rustic farmhouse and vacation homes.
Send delicate, good-looking, and symmetrical memorandums regarding real estate rentals Hacienda Miravalles Costa Rica, house rentals Hacienda Miravalles Costa Rica, real estate rentals Hacienda Miravalles Costa Rica, and Hacienda Miravalles rent houses found on FRBO.Com, For Rent By Owner,.
Disclose, notice, and conceive homes for rent Santa Maria, condo rentals Santa Maria Costa Rica, and Santa Maria Costa Rica vacation rental.
|
|
