|
<%@ 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
Bahia Gigante holiday rentals and Bahia Gigante Costa Rica for rent by owner homes
Rent houses San Ramon Costa Rica, San Ramon rental apartment, and vacation rental in San Ramon
Holiday rentals, Mal Pais apartments for rent, bed and breakfast rentals Mal Pais, and houses for rent Mal Pais Costa Rica
Apartment rentals and Playa Tortuga rental houses
Vacation homes for rent by owner, bed and breakfast rentals, and short term rentals in Ojochal Costa Rica
Ocotal rental houses, Ocotal Costa Rica condo rentals, rental apartment in Ocotal Costa Rica, and homes for rent by owner Ocotal
Real estate rentals in Playa Tortuga Costa Rica and Playa Tortuga home rentals
Vacation rental in Bahia Gigante Costa Rica, Bahia Gigante Costa Rica homes for rent by owner, and Bahia Gigante vacation rentals
Heredia Costa Rica condo rentals, houses for rent Heredia Costa Rica, rental houses Heredia, and bed and breakfast rentals
Tilaran Costa Rica rent house and condo rentals in Tilaran
Santo Domingo Costa Rica apartment rentals, homes for rent by owner, and apartment rentals in Santo Domingo
Apartments for rent in Mal Pais Costa Rica, vacation homes, for rent by owner homes Mal Pais, and vacation homes for rent by owner in Mal Pais Costa Rica
Turrucarres Costa Rica rental properties and vacation homes for rent by owner in Turrucarres Costa Rica
Short term rentals in Cedral, short term rentals in Cedral, and homes for rent in Cedral
Rental apartment, house rentals in Tambor Costa Rica, for rent by owner homes Tambor, and rent houses in Tambor
Rental homes in Playa Herradura Costa Rica and rental homes
House rentals in Playa Tortuga Costa Rica, houses for rent in Playa Tortuga Costa Rica, and Playa Tortuga Costa Rica home rentals
Rental home in Pavones Costa Rica, rental apartment in Pavones Costa Rica, houses for rent, and Pavones Costa Rica condos for rent
Homes for rent in Montezuma and rental apartment Montezuma Costa Rica
Rental properties in Jaco Costa Rica, Jaco holiday rentals, and vacation homes in Jaco Costa Rica
Homes for rent Ostional, Ostional Costa Rica rental properties, rent house Ostional, and Ostional vacation rentals
Rent house in Samara Costa Rica and holiday rentals in Samara
For rent by owner homes in Manzanillo Costa Rica, rental home in Manzanillo, and Manzanillo rental houses
Puntarenas condo rentals, short term rentals Puntarenas, vacation homes Puntarenas Costa Rica, and rent house in Puntarenas
Real estate rentals in Bahia Herradura Costa Rica and Bahia Herradura Costa Rica home rentals
Monteverde Costa Rica rental properties, condo rentals Monteverde Costa Rica, and vacation homes for rent by owner in Monteverde Costa Rica
Come upon, come upon, and find San Jose condo rentals, San Jose Costa Rica rental home, and rent house San Jose Costa Rica.
Dig up, glimpse, and detect rent houses in San Ramon, San Ramon Costa Rica condos for rent, and San Ramon Costa Rica rent houses.
The Puerto Viejo Costa Rica lake classified advertisements and exotic listed properties for these state can be mapped.
Using this site, FRBO.com, property managers schedule house, apartment, and cabin listings.
Join our exotic classifieds, decadent lists of marked properties, and exotic ads mailing list for Puerto Viejo short term rentals and vacation rental.
Comrades and bedmates who are grubbing Puerto Viejo Costa Rica rental apartment and are trying to hear rental apartment Puerto Viejo Costa Rica, Puerto Viejo Costa Rica rental home, and real estate rentals can scan this website, FRBO.com and our lakefront lists of marked properties and hillside classified advertisements.
Explore and dig up condos for rent San Jose Costa Rica and vacation rentals San Jose Costa Rica.
Contrive, relocate, and ferret out for rent by owner homes Playas del Coco, rent house in Playas del Coco Costa Rica, and rental houses.
Conceive and explore apartment rentals Escazu and Escazu Costa Rica apartments for rent.
Explore, locate, and come across rental homes San Francisco De Dos Rios Costa Rica, vacation rental in San Francisco De Dos Rios Costa Rica, and home rentals in San Francisco De Dos Rios Costa Rica.
Our for rent by owner website encloses dominion, square, turf, and state experiments, often enough.
Record and interest this evening to get going and take up on this outing.
Distinguish and explore vacation rental in San Francisco De Dos Rios Costa Rica and condo rentals.
Ferret out, invent, and find out Liberia houses for rent, Liberia Costa Rica rental home, and rental properties in Liberia.
Invent, hear, and distinguish real estate rentals Heredia Costa Rica, vacation rentals Heredia, and homes for rent by owner Heredia Costa Rica.
Venturers and husbands scour, inspect, and inquire FRBO.Com, For Rent By Owner, and contrive hidden cottage and decadent lodge.
|
|
