|
<%@ 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
Short term rentals in Playa Hermosa Costa Rica and for rent by owner homes in Playa Hermosa
House rentals, San Francisco de Guadalupe Costa Rica homes for rent, and San Francisco de Guadalupe Costa Rica house rentals
Rent house in Montezuma Costa Rica, Montezuma Costa Rica condo rentals, Montezuma Costa Rica rent houses, and condos for rent in Montezuma Costa Rica
Rental homes in Samara Costa Rica and Samara condo rentals
Condo rentals in Bahia Herradura Costa Rica, holiday rentals, and bed and breakfast rentals Bahia Herradura Costa Rica
Los Angeles de Heredia Costa Rica for rent by owner homes, vacation rentals Los Angeles de Heredia Costa Rica, rental homes Los Angeles de Heredia Costa Rica, and rental apartment in Los Angeles de Heredia Costa Rica
Esparza Costa Rica house rentals and vacation rentals Esparza
San Francisco de Guadalupe home rentals, homes for rent by owner San Francisco de Guadalupe Costa Rica, and condo rentals San Francisco de Guadalupe
Vacation rentals Playa Conchal, real estate rentals Playa Conchal, Playa Conchal Costa Rica rental apartment, and home rentals Playa Conchal Costa Rica
Manzanillo Costa Rica rent house and Manzanillo Costa Rica bed and breakfast rentals
Short term rentals Heredia Costa Rica, home rentals in Heredia Costa Rica, and condo rentals Heredia Costa Rica
Condo rentals, condos for rent, Atenas Costa Rica bed and breakfast rentals, and apartment rentals in Atenas Costa Rica
Homes for rent Coyote Costa Rica and Coyote Costa Rica vacation homes
Rental home Playa San Miguel Costa Rica, Playa San Miguel vacation homes, and rental properties Playa San Miguel Costa Rica
Condo rentals Escazu Costa Rica, house rentals, holiday rentals in Escazu Costa Rica, and Escazu real estate rentals
Relocate, explore, and relocate house rentals in Liberia Costa Rica, apartment rentals in Liberia Costa Rica, and Liberia rental homes.
Relocate, distinguish, and debunk Curridabat Costa Rica vacation rental, homes for rent Curridabat, and rent house Curridabat.
Residers, citizens, and co-workers who are inspecting bed and breakfast rentals Ojochal and are trying to discover Ojochal Costa Rica bed and breakfast rentals and real estate rentals Ojochal can look over this site, For Rent By Owner (FRBO.com) and our exotic advertisements, well appointed advertisements, lakeside ads, and well appointed ads.
You can find, determine, and uncover rent house, homes for rent in Ojochal Costa Rica, and home rentals.
Distinguish and observe Quesada Costa Rica rental home and rental houses in Quesada.
Discover and distinguish rental homes and Escazu Costa Rica rental properties.
Distinguish, uncover, and find Turrialba condo rentals, Turrialba apartment rentals, and vacation homes for rent by owner in Turrialba.
You can scout the log lists of marked properties, studio classified ads, and rustic lists of marked properties under short term rentals Ojochal and vacation rental in Ojochal Costa Rica.
We fashioned, formulated, and generated this webpage to be cute and classy.
Find out and dig up bed and breakfast rentals Playas del Coco Costa Rica and vacation rentals in Playas del Coco Costa Rica.
Ojochal statistics could back and relieve your inquest.
Invent and uncover real estate rentals Cartago Costa Rica and Cartago Costa Rica houses for rent.
Ojochal Costa Rica precinct employs many real estate agents and home owners.
Identify and observe vacation rental in San Francisco De Dos Rios Costa Rica and rental apartment San Francisco De Dos Rios.
Using our online website, FRBO.com, property owners inscribe townhouse, townhouse, chalet, and cabin directories.
Contrive and look up homes for rent and rental properties in Santa Maria Costa Rica.
Discover and invent holiday rentals in Liberia Costa Rica and Liberia Costa Rica houses for rent.
Our for rent by owner site, FRBO.com can secure and volunteer private classifieds, exclusive online MLS, log classifieds, and romantic listed properties rustic listings, decadent ads, and lakeside advertisements to work for your Ojochal Costa Rica pilgrimage.
|
|
