|
<%@ 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
House rentals in San Francisco de Guadalupe Costa Rica and rent houses in San Francisco de Guadalupe
Ojochal Costa Rica vacation rentals, Ojochal Costa Rica rental homes, and Ojochal home rentals
Vacation rentals, rent houses Los Angeles de Heredia Costa Rica, Los Angeles de Heredia rent house, and for rent by owner homes
Santa Teresa rent houses and Santa Teresa rental apartment
Puerto Jimenez Costa Rica bed and breakfast rentals, rental apartment Puerto Jimenez Costa Rica, and rental houses in Puerto Jimenez Costa Rica
Vacation homes Nosara Costa Rica, vacation rental in Nosara Costa Rica, rent houses Nosara Costa Rica, and bed and breakfast rentals in Nosara Costa Rica
Cedral bed and breakfast rentals and for rent by owner homes Cedral Costa Rica
Vacation rentals Santo Domingo Costa Rica, rental houses Santo Domingo, and homes for rent by owner in Santo Domingo Costa Rica
La Isla Palo Seco Costa Rica home rentals, La Isla Palo Seco Costa Rica house rentals, rent houses in La Isla Palo Seco Costa Rica, and La Isla Palo Seco Costa Rica rental houses
Vacation rentals in Playa Panama Costa Rica and Playa Panama Costa Rica vacation homes for rent by owner
Vacation homes for rent by owner Coyote Costa Rica, homes for rent by owner in Coyote Costa Rica, and Coyote Costa Rica vacation homes
Ostional homes for rent by owner, Ostional Costa Rica house rentals, rental apartment Ostional, and apartment rentals Ostional
House rentals and rent house Orosi
Montezuma Costa Rica short term rentals, Montezuma Costa Rica rental homes, and apartments for rent
Vacation rental Montezuma, rent house Montezuma Costa Rica, bed and breakfast rentals in Montezuma Costa Rica, and real estate rentals in Montezuma Costa Rica
Homes for rent by owner Samara and Samara Costa Rica homes for rent
Apartment rentals, bed and breakfast rentals in Manzanillo, and Manzanillo Costa Rica vacation homes for rent by owner
Cocles Costa Rica rent houses, apartments for rent in Cocles, vacation homes for rent by owner in Cocles Costa Rica, and apartment rentals Cocles Costa Rica
For Rent By Owner can inscribe and register private classified ads and loft online MLS loft listings, beachfront online MLS, and lake classifieds to sustain your San Jose travel.
Send gorgeous, sightly, well-formed, and comely testimony regarding San Jose Costa Rica homes for rent by owner and homes for rent in San Jose found on this extensive website, FRBO.com.
This extensive website, FRBO.com encompasss zone, tract, patch, and field poop, recurrently.
Ferret out and devise rental homes Liberia and condo rentals in Liberia Costa Rica.
You can probe the beach advertisements and exclusive ads under San Jose Costa Rica vacation rentals, vacation rentals San Jose Costa Rica, and rent house in San Jose.
Using our website, FRBO.com, home owners enumerate home, villa, ranch, and flat classified advertisements.
Explore and explore rent house in Liberia Costa Rica and vacation rentals in Liberia Costa Rica.
Join our penthouse lists of marked properties, convenient classified ads, beachfront classified advertisements, and city ad directories mailing list for San Jose vacation rental and San Jose Costa Rica rental apartment.
Relocate, glimpse, and come across rental home Ciudad Quesada Costa Rica, rental home, and Ciudad Quesada Costa Rica rent houses.
Move and observe rental properties in Cartago and for rent by owner homes in Cartago.
Pirates and traveling agents who are wishing to perceive, detect, and distinguish or simply light upon information can use our site, FRBO.com.
San Jose Costa Rica stretch employs many property agents, agents serving the condo market, rental property owners, and landlords.
You can observe and debunk apartment rentals in San Jose Costa Rica, San Jose short term rentals, and rental properties in San Jose.
|
|
