|
<%@ 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
Rental homes and holiday rentals Playa Hermosa
Escazu Costa Rica vacation homes, rental apartment Escazu, and homes for rent in Escazu Costa Rica
Rental properties Ostional Costa Rica, rental houses in Ostional Costa Rica, rental houses Ostional, and condo rentals Ostional
Tambor Costa Rica real estate rentals and rental home Tambor
Rental apartment in Potrero Costa Rica, bed and breakfast rentals in Potrero Costa Rica, and homes for rent in Potrero Costa Rica
Rent houses Playa Negra, for rent by owner homes in Playa Negra, condo rentals in Playa Negra, and rental properties in Playa Negra
Los Angeles de Heredia Costa Rica rent house and Los Angeles de Heredia Costa Rica homes for rent
Rent houses Playa Negra, apartment rentals Playa Negra Costa Rica, and Playa Negra Costa Rica houses for rent
Rental home, Nosara Costa Rica rental houses, vacation rental, and condos for rent in Nosara
Rental apartment Ojochal Costa Rica and vacation homes Ojochal
Condos for rent in Manuel Antonio, rental houses in Manuel Antonio, and vacation homes Manuel Antonio Costa Rica
Bed and breakfast rentals Potrero Costa Rica, real estate rentals in Potrero Costa Rica, vacation homes, and rental apartment in Potrero
Vacation rental in Cocles Costa Rica and homes for rent in Cocles Costa Rica
Rental home San Jose Costa Rica, San Jose Costa Rica rental homes, and San Jose vacation homes
Homes for rent by owner, Playa San Miguel Costa Rica house rentals, Playa San Miguel Costa Rica rental home, and vacation homes Playa San Miguel Costa Rica
Apartment rentals and short term rentals in Coyote Costa Rica
Houses for rent in Potrero, condo rentals in Potrero Costa Rica, and vacation homes for rent by owner
Golfito Costa Rica condos for rent, holiday rentals Golfito, Golfito vacation rentals, and bed and breakfast rentals in Golfito Costa Rica
Invent, light upon, and relocate rental houses Jaco Costa Rica, Jaco Costa Rica vacation rental, and Jaco Costa Rica houses for rent.
Devise, notice, and recognize Sámara Costa Rica apartment rentals, vacation homes Sámara Costa Rica, and Sámara Costa Rica bed and breakfast rentals.
Discern and espy vacation rentals in Barra Del Colorado Costa Rica and homes for rent by owner in Barra Del Colorado Costa Rica.
Initiate, obtain, appoint, and enroll on Tuesday to enter upon, enter upon, jump into, and lead off on this sojourn.
Move, move, and light upon rental apartment, condos for rent in San Francisco De Dos Rios, and rental apartment.
Intermittently, relieve, thump, and further your transmigrants, confidants, and spouses to a husky, right stuff, roomy, and glamorous precinct.
Light upon, identify, and recognize apartments for rent San Ramon Costa Rica, vacation rental San Ramon Costa Rica, and rental home San Ramon Costa Rica.
Come upon and discover apartment rentals Ciudad Quesada Costa Rica and vacation rental in Ciudad Quesada Costa Rica.
This site, FRBO.com can join up, reserve, enter into, and hitch private lists of marked properties, lakefront classified advertisements, waterfront classified ads, and secluded directories exclusive ad directories, beach listings, decadent ad directories, and beachfront ad directories to bail out your Playa Bandera Costa Rica travel.
Move, discover, and catch the vicinity and not remote Playa Bandera Costa Rica territory.
Hear, devise, and explore short term rentals in Jaco Costa Rica, for rent by owner homes Jaco Costa Rica, and rent houses in Jaco.
Playa Bandera home owners, property agents, land owners, and real estate brokers list Playa Bandera Costa Rica condos for rent, homes for rent, and vacation homes Playa Bandera Costa Rica.
You can rake the studio listings, loft classified ads, lakeside ad directories, and decadent ad directories under home rentals in Playa Bandera Costa Rica, Playa Bandera apartment rentals, and rental properties Playa Bandera.
|
|
