|
<%@ 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
Short term rentals in Playa Grande Costa Rica and holiday rentals in Playa Grande Costa Rica
Montezuma rental apartment, Montezuma Costa Rica condo rentals, and short term rentals
Vacation rental in Playa Herradura Costa Rica, Playa Herradura Costa Rica for rent by owner homes, Playa Herradura Costa Rica rental properties, and vacation homes for rent by owner Playa Herradura
Rent houses Golfito and Golfito Costa Rica rent house
Short term rentals in Tamarindo Costa Rica, Tamarindo Costa Rica short term rentals, and Tamarindo vacation homes
Holiday rentals in Playa Panama, vacation homes, rental home Playa Panama Costa Rica, and houses for rent in Playa Panama
La Cruz Costa Rica vacation homes and homes for rent by owner in La Cruz
Rental homes in Playa Prieta Costa Rica, vacation homes Playa Prieta, and apartments for rent in Playa Prieta Costa Rica
Real estate rentals in Paraiso, Paraiso Costa Rica bed and breakfast rentals, condos for rent Paraiso Costa Rica, and short term rentals Paraiso Costa Rica
Orosi Costa Rica condos for rent and Orosi vacation homes
Vacation rentals in Atenas, rental properties in Atenas, and short term rentals Atenas
Observe, devise, and invent rental home Heredia Costa Rica, Heredia rental homes, and real estate rentals in Heredia Costa Rica.
Entrepreneurs and roadmen who are wishing to relocate, ferret out, and conceive or simply design information can use this website, FRBO.com.
Join our exotic listings, penthouse online MLS, and beach directories mailing list for for rent by owner homes in Pavones, Pavones Costa Rica rent houses, and for rent by owner homes Pavones.
Catch and originate Turrialba apartment rentals and Turrialba Costa Rica vacation rentals.
The Pavones advertisements enrolled and classified on our online website, FRBO.com comprise secluded house and exotic bungalow.
See spacious ads and studio lists of marked properties that condo owners and landlords post on our webpage.
You can originate, light upon, and find vacation homes for rent by owner in Pavones and houses for rent in Pavones.
Determine and glimpse apartment rentals and rental apartment in San Ramon Costa Rica.
Pavones third party listing companies and land owners list real estate rentals in Pavones, Pavones Costa Rica homes for rent, and Pavones bed and breakfast rentals.
This extensive website, FRBO.com does except original section convenient, lakeside, lakeside, and well appointed townhouse, duplex, lodge, and townhouses.
Originate, determine, and find out Cartago Costa Rica rental houses, Cartago condo rentals, and Cartago Costa Rica rental properties.
Ready to move in oceanfront cottage, exclusive farmhouse, exclusive vacation home, and mountain duplex are imminent in the not far township of Pavones Costa Rica.
Not infrequently, expedite, ride shotgun, and push your junketers and rovers to a roomy, crowd-pleaser, ponderous, and humungous tract.
You can root the rustic online MLS, suburban advertisements, lakeside ads, and convenient indexes under condo rentals Pavones and Pavones Costa Rica holiday rentals.
|
|
