|
<%@ 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
Puerto Viejo vacation homes and Puerto Viejo Costa Rica rental home
Orosi vacation homes for rent by owner, rental houses Orosi Costa Rica, and vacation rental Orosi Costa Rica
Homes for rent by owner in Playa Azul Costa Rica, rental homes, Playa Azul Costa Rica vacation homes, and rental home in Playa Azul Costa Rica
Vacation homes for rent by owner and Quepos Costa Rica house rentals
Atenas houses for rent, homes for rent by owner in Atenas Costa Rica, and Atenas Costa Rica house rentals
Apartments for rent Puerto Viejo, rent house in Puerto Viejo, vacation homes for rent by owner Puerto Viejo, and apartment rentals in Puerto Viejo
Condos for rent in Playa Hermosa and Playa Hermosa Costa Rica rental houses
Playa Negra Costa Rica real estate rentals, rental properties in Playa Negra Costa Rica, and Playa Negra condo rentals
Condo rentals in Arenal Costa Rica, Arenal vacation rentals, rent houses in Arenal Costa Rica, and homes for rent by owner Arenal
Homes for rent in Nicoya and Nicoya Costa Rica home rentals
Short term rentals in Mal Pais, Mal Pais homes for rent by owner, and vacation rentals
Condo rentals in Uvita, rental homes Uvita Costa Rica, Uvita Costa Rica short term rentals, and Uvita bed and breakfast rentals
Holiday rentals La Cruz and La Cruz short term rentals
Vacated lake timeshare, well appointed condominium, and ski in/out houseboat are not faraway in the not far turf of Playa Hermosa Costa Rica.
Elicit and uncover Quesada Costa Rica real estate rentals and Quesada rent house.
Come upon specialized and some input in Playa Hermosa Costa Rica and button down Playa Hermosa vacation homes.
Jump into your fishing expedition online tonight, day after tomorrow, on Monday, or next weekend for your rental apartment in Playa Hermosa and apartments for rent in Playa Hermosa Costa Rica.
Look up, debunk, and detect Tibas vacation homes, apartment rentals, and rental houses in Tibas Costa Rica.
Ferret out and detect apartments for rent and rental apartment.
Learn and originate San Francisco De Dos Rios rental homes and San Francisco De Dos Rios rent houses.
You can perceive and invent Playa Hermosa real estate rentals and rent houses in Playa Hermosa Costa Rica.
FRBO.com encloses neighborhood, dominion, turf, and locality experiments, customarily.
Playa Hermosa land owners, brokers leasing foreclosures, real estate brokers, and rental property owners list rent houses Playa Hermosa Costa Rica and Playa Hermosa vacation rental.
Come upon, espy, and light upon Sámara Costa Rica condo rentals, condos for rent, and apartments for rent.
Our for rent by owner site, FRBO.com can hire, recruit, and interest convenient lists of marked properties, lakeside advertisements, and exotic online MLS lakefront classifieds, mountain classifieds, and convenient listed properties to back your Playa Hermosa Costa Rica migration.
We constructed and spawned our page to be bewitching, appealing, stunning, and lovely.
|
|
