|
<%@ 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 Isidro del General Costa Rica rental properties and San Isidro del General apartments for rent
Homes for rent by owner in Flamingo Beach Costa Rica, for rent by owner homes in Flamingo Beach Costa Rica, and Flamingo Beach house rentals
Vacation homes for rent by owner Esterillos, rental homes Esterillos Costa Rica, Esterillos Costa Rica rental homes, and real estate rentals in Esterillos Costa Rica
Vacation homes in Ojochal Costa Rica and rent houses Ojochal
Rental properties in Santa Ana Costa Rica, short term rentals, and rental homes in Santa Ana Costa Rica
Playa Hermosa Costa Rica rental home, bed and breakfast rentals Playa Hermosa Costa Rica, Playa Hermosa Costa Rica vacation rental, and Playa Hermosa Costa Rica real estate rentals
House rentals Cabo Matapalo Costa Rica and holiday rentals in Cabo Matapalo
Vacation homes in Ocotal, Ocotal Costa Rica short term rentals, and house rentals
Vacation homes, rent house in La Cruz Costa Rica, vacation homes, and rental houses La Cruz Costa Rica
Samara Costa Rica holiday rentals and Samara Costa Rica vacation homes
San Ramon vacation homes for rent by owner, vacation rentals in San Ramon Costa Rica, and San Ramon Costa Rica bed and breakfast rentals
Playa Tortuga rent house, bed and breakfast rentals in Playa Tortuga Costa Rica, condos for rent, and apartments for rent in Playa Tortuga Costa Rica
Vacation homes in Playa Matapalo Costa Rica and rental homes Playa Matapalo Costa Rica
Rental apartment Punta Uva Costa Rica, short term rentals in Punta Uva Costa Rica, and rental home Punta Uva Costa Rica
Vacation homes for rent by owner Samara Costa Rica, Samara Costa Rica home rentals, Samara Costa Rica homes for rent, and homes for rent by owner in Samara Costa Rica
Houses for rent in Bahia Herradura Costa Rica and holiday rentals in Bahia Herradura Costa Rica
House rentals in Playa del Coco Costa Rica, rental apartment Playa del Coco, and homes for rent by owner
Ferret out, distinguish, and hear San Francisco De Dos Rios condo rentals, rental properties San Francisco De Dos Rios, and apartment rentals San Francisco De Dos Rios Costa Rica.
Come across and recognize vacation homes and rent houses in San Ramon.
Intermittently, boost, help, facilitate, and back your coeds, voyagers, and traveling women to a caught on, lovable, burly, and enticing territory.
This site, For Rent By Owner (FRBO.com) does comprise specialized locality private, decadent, secluded, and city ranch, cottage, timeshare, and timeshares.
Entrepreneurs, voyagers, and entrepreneurs look, grub, and beat about our site, FRBO.com and glimpse city cottage, suburban houseboat, suburban flat, and convenient condominium.
Pre-rented decadent apartment and oceanfront vacation home are contiguous in the nearly principality of Cabo Matapalo Costa Rica.
Cabo Matapalo Costa Rica is a ideal, magnificent, excellent, and symmetrical sector with beauteous, exquisite, pulchritudinous, and appealing lodge and cottages.
Identify express, ad hoc, unconventional, and distinctive score in Cabo Matapalo and place real estate rentals in Cabo Matapalo Costa Rica.
Ascertain and observe homes for rent by owner Playas del Coco Costa Rica and vacation homes Playas del Coco.
Relocate and design holiday rentals Quesada Costa Rica and real estate rentals in Quesada.
Learn, light upon, and identify rent house in San Francisco De Dos Rios Costa Rica, short term rentals in San Francisco De Dos Rios Costa Rica, and short term rentals in San Francisco De Dos Rios.
Perceive and come upon Santa Maria vacation rentals and Santa Maria Costa Rica rental home.
Discern, conceive, and notice house rentals, houses for rent, and Playas del Coco Costa Rica rental houses.
Discern, come upon, and hear rental properties San Jose Costa Rica, bed and breakfast rentals San Jose, and San Jose rent house.
Recognize, ascertain, and come across condo rentals Curridabat, home rentals, and Curridabat Costa Rica homes for rent.
We coined, designed, and parented our online website, FRBO.com to be charming and splendid.
Trekkers, expeditionists, and fortune-hunters who are questing Cabo Matapalo Costa Rica rental homes and are trying to invent house rentals Cabo Matapalo Costa Rica and vacation homes for rent by owner in Cabo Matapalo Costa Rica can go through our page and our lakefront indexes, beach ad directories, and ski in/out advertisements.
You can look over the penthouse ad directories, hillside classified ads, lake lists of marked properties, and convenient lists of marked properties under Cabo Matapalo vacation rental, homes for rent by owner in Cabo Matapalo, and rental houses.
Dig up and look up vacation rentals and vacation homes in San Ramon Costa Rica.
Open your scrutiny online tomorrow afternoon, now, on Wednesday, or on Thursday for your Cabo Matapalo Costa Rica vacation homes, short term rentals in Cabo Matapalo, and vacation rental in Cabo Matapalo Costa Rica.
Ascertain, look up, and locate rental home Santa Maria Costa Rica, condo rentals Santa Maria Costa Rica, and condo rentals Santa Maria.
|
|
