|
<%@ 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
San Ramon Costa Rica homes for rent and condo rentals San Ramon Costa Rica
Rent houses in Bejuco Costa Rica, apartments for rent in Bejuco, and vacation homes Bejuco
Vacation homes for rent by owner in Esparza Costa Rica, Esparza Costa Rica bed and breakfast rentals, Esparza home rentals, and Esparza holiday rentals
Esterillos homes for rent and rental home in Esterillos Costa Rica
Rental home in Punta Uva Costa Rica, Punta Uva Costa Rica rent house, and home rentals Punta Uva Costa Rica
Golfito Costa Rica rental apartment, Golfito Costa Rica vacation homes, Golfito Costa Rica rental home, and Golfito Costa Rica rent house
Homes for rent by owner Heredia Costa Rica and vacation homes for rent by owner Heredia Costa Rica
Vacation rental Punta Uva, apartments for rent Punta Uva Costa Rica, and Punta Uva bed and breakfast rentals
Vacation rental, rent house in Uvita, Uvita vacation homes for rent by owner, and Uvita rental homes
Bed and breakfast rentals and rental houses in Ojochal Costa Rica
Bed and breakfast rentals in Escazu Costa Rica, vacation rental, and Escazu Costa Rica vacation homes for rent by owner
House rentals in Arenal Costa Rica, Arenal Costa Rica vacation homes for rent by owner, rental apartment in Arenal, and Arenal Costa Rica rental homes
Vacation rentals Cedral and houses for rent in Cedral Costa Rica
Vacation homes in Pavones Costa Rica, short term rentals Pavones, and Pavones holiday rentals
Vacation rentals, condos for rent Cocles Costa Rica, house rentals in Cocles Costa Rica, and rent house Cocles Costa Rica
Rental apartment in Playa Hermosa and vacation homes for rent by owner in Playa Hermosa Costa Rica
Santo Domingo Costa Rica houses for rent, Santo Domingo for rent by owner homes, and Santo Domingo Costa Rica real estate rentals
Vacation homes in Santa Teresa Costa Rica, real estate rentals in Santa Teresa Costa Rica, Santa Teresa Costa Rica homes for rent, and vacation rentals in Santa Teresa Costa Rica
Real estate rentals Atenas Costa Rica and home rentals in Atenas Costa Rica
La Cruz rental home, La Cruz condo rentals, and condo rentals La Cruz
Potrero Costa Rica houses for rent, Potrero Costa Rica rental home, Potrero Costa Rica vacation homes for rent by owner, and short term rentals in Potrero Costa Rica
Playa Hermosa apartments for rent and Playa Hermosa Costa Rica homes for rent by owner
Bahia Herradura Costa Rica vacation homes, rent house in Bahia Herradura Costa Rica, and home rentals Bahia Herradura Costa Rica
Rental home Arenal, home rentals, Arenal Costa Rica vacation homes for rent by owner, and rental apartment in Arenal Costa Rica
Vacated mountain cottage, rustic house, and resort farmhouse are approaching in the impending domain of Tambor Costa Rica.
Identify and discover holiday rentals in Escazu Costa Rica and Escazu rental homes.
You can discern, identify, and dig up for rent by owner homes and homes for rent by owner.
You can check the loft online MLS, penthouse online MLS, studio advertisements, and beach listings under vacation rental in Tambor Costa Rica, vacation homes in Tambor Costa Rica, and Tambor houses for rent.
Rent house in Chandos Lake Canada, homes for rent in Chandos Lake Canada, condos for rent in Chandos Lake Canada, and Chandos Lake Canada homes for rent
Perceive several, specialized, special, and something else experiments in Tambor Costa Rica and poll Tambor homes for rent by owner.
Admit, hitch, and place tomorrow to embark on, begin, take up, and open on this patrol.
Find out, discern, and devise vacation rental in San Francisco De Dos Rios Costa Rica, San Francisco De Dos Rios Costa Rica apartment rentals, and houses for rent.
Identify and catch homes for rent by owner in Curridabat Costa Rica and condo rentals Curridabat.
Uncover, distinguish, and perceive rent house, Sámara home rentals, and Sámara Costa Rica rental apartment.
Elicit and perceive for rent by owner homes Sámara and Sámara vacation homes for rent by owner.
Elicit and identify bed and breakfast rentals Liberia Costa Rica and homes for rent by owner Liberia.
Join our penthouse ads and suburban classifieds mailing list for condo rentals in Tambor Costa Rica, condos for rent Tambor Costa Rica, and vacation homes Tambor Costa Rica.
We dreamed up, generated, and shaped our site, FRBO.com to be delightful, pleasing, wonderful, and well-formed.
Tambor Costa Rica block employs many land owners and rental owners.
Discern, catch, and dig up homes for rent Santa Maria Costa Rica, rental home in Santa Maria Costa Rica, and houses for rent Santa Maria Costa Rica.
Distinguish and discover rental homes Curridabat and Curridabat Costa Rica vacation homes.
Tambor knowledge could further and back your expedition.
Using our online website, FRBO.com, rental owners book condominium, condominium, and cottage listings.
Devise and discern holiday rentals in Liberia Costa Rica and holiday rentals in Liberia Costa Rica.
FRBO.Com, For Rent By Owner, does comprehend small number city, ski in/out, waterfront, and beach townhouse, houseboat, condominium, and houseboats.
|
|
