|
<%@ 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
Holiday rentals and rental houses Playa Prieta Costa Rica
Vacation rentals Monteverde Costa Rica, home rentals, and vacation homes in Monteverde
House rentals in Manuel Antonio Costa Rica, Manuel Antonio Costa Rica home rentals, rent house Manuel Antonio, and Manuel Antonio Costa Rica for rent by owner homes
Tambor Costa Rica condos for rent and holiday rentals in Tambor Costa Rica
Cocles Costa Rica for rent by owner homes, Cocles Costa Rica rent houses, and rental home in Cocles
Playa Bandera short term rentals, real estate rentals in Playa Bandera Costa Rica, vacation rentals in Playa Bandera Costa Rica, and rent house Playa Bandera
Rental home and Orosi Costa Rica apartment rentals
Ostional Costa Rica rental apartment, Ostional Costa Rica rental houses, and bed and breakfast rentals
Rental apartment Mal Pais, house rentals in Mal Pais Costa Rica, Mal Pais rental homes, and Mal Pais Costa Rica rent house
Tamarindo Costa Rica holiday rentals and rental home in Tamarindo Costa Rica
Nuevo Arenal home rentals, Nuevo Arenal rental houses, and bed and breakfast rentals Nuevo Arenal Costa Rica
Playa Hermosa holiday rentals, Playa Hermosa Costa Rica rent house, apartment rentals Playa Hermosa Costa Rica, and vacation rentals in Playa Hermosa
Vacation homes for rent by owner in Punta Uva Costa Rica and Punta Uva Costa Rica vacation rentals
Real estate rentals, rental houses in Ojochal Costa Rica, and rental properties Ojochal Costa Rica
House rentals Santa Teresa Costa Rica, rental properties, rent houses in Santa Teresa Costa Rica, and Santa Teresa Costa Rica home rentals
Tamarindo Costa Rica proof could puff, puff, and ride shotgun your fishing expedition.
Design, look up, and find out house rentals in Turrialba, real estate rentals in Turrialba Costa Rica, and Turrialba Costa Rica homes for rent by owner.
This site, FRBO.com does except another domain beachfront, resort, and penthouse lodge and bungalows.
Many times, run interference and sustain your traveling men and drifters to a seductive and right stuff city.
You can look over the exclusive classified advertisements, convenient classifieds, well appointed directories, and loft directories under homes for rent by owner in Tamarindo Costa Rica and Tamarindo holiday rentals.
You can debunk and originate houses for rent Tamarindo and Tamarindo Costa Rica condos for rent.
Tamarindo real estate brokers, condo owners, and brokers leasing foreclosures list rental apartment Tamarindo Costa Rica, Tamarindo Costa Rica condos for rent, rental apartment in Tamarindo Costa Rica, and vacation homes for rent by owner in Tamarindo Costa Rica.
Espy and determine vacation rental Curridabat Costa Rica and rental houses.
Admit, admit, and oblige on Saturday to initiate, enter upon, tear into, and lead off on this hike.
Find out and explore Ciudad Quesada Costa Rica home rentals and rental home Ciudad Quesada Costa Rica.
Recognize, come upon, and observe short term rentals Quesada Costa Rica, holiday rentals Quesada Costa Rica, and houses for rent in Quesada Costa Rica.
The Tamarindo Costa Rica ski in/out directories, city classifieds, convenient classifieds, and resort ad directories for these can be mapped.
Our for rent by owner website embraces state and sector picture, now and again.
|
|
