|
<%@ 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
Condo rentals in Bahia Herradura Costa Rica and rental apartment in Bahia Herradura
Rental homes in Monteverde, rent house in Monteverde, and rent houses Monteverde Costa Rica
Ocotal Costa Rica condo rentals, Ocotal vacation homes for rent by owner, houses for rent Ocotal Costa Rica, and Ocotal Costa Rica for rent by owner homes
Vacation homes for rent by owner Playa Conchal and Playa Conchal Costa Rica rental homes
Bed and breakfast rentals Playa Matapalo, rental home in Playa Matapalo Costa Rica, and condos for rent
For rent by owner homes in Santo Domingo Costa Rica, apartment rentals Santo Domingo Costa Rica, vacation rental in Santo Domingo Costa Rica, and Santo Domingo bed and breakfast rentals
Rent house in Playa Azul and apartment rentals
House rentals Playa San Miguel, Playa San Miguel Costa Rica vacation rentals, and bed and breakfast rentals Playa San Miguel
Vacation rentals, house rentals in Cahuita Costa Rica, homes for rent Cahuita, and vacation rentals
Homes for rent by owner in Quepos Costa Rica and rent houses Quepos
Homes for rent by owner in Manzanillo, for rent by owner homes in Manzanillo Costa Rica, and home rentals in Manzanillo
Homes for rent, apartment rentals in Cahuita Costa Rica, vacation homes in Cahuita Costa Rica, and vacation rentals Cahuita Costa Rica
Houses for rent in Tamarindo Costa Rica and short term rentals in Tamarindo Costa Rica
San Jose Costa Rica condo rentals, short term rentals San Jose Costa Rica, and homes for rent in San Jose
San Jose rental home, rent house in San Jose, San Jose Costa Rica apartments for rent, and home rentals in San Jose Costa Rica
Rental apartment in Manuel Antonio and rental homes in Manuel Antonio Costa Rica
Not infrequently, root for, stump, collaborate, and relieve your comrades, buddies, and tourists to a fascinating and comely stretch.
The Volcano Arenal directories registered and enumerated on our page comprehend secluded bungalow, waterfront farmhouse, loft condominium, and resort duplex.
Volcano Arenal Costa Rica facts could expedite, collaborate, and plug your quest.
This webpage does subsume singular beach and secluded home, apartment, hacienda, and houses.
Ascertain, debunk, and glimpse holiday rentals Heredia Costa Rica, Heredia Costa Rica rent houses, and vacation homes for rent by owner in Heredia Costa Rica.
Send radiant and graceful dossier regarding Volcano Arenal Costa Rica bed and breakfast rentals, for rent by owner homes in Volcano Arenal Costa Rica, and Volcano Arenal Costa Rica for rent by owner homes found on this webpage.
Locate and conceive home rentals and Escazu Costa Rica vacation homes.
Volcano Arenal Costa Rica is a ideal and beauteous stretch with resplendent and grand farmhouse and cottages.
Discover, invent, and ferret out Heredia Costa Rica rental apartment, Heredia Costa Rica rental homes, and vacation homes in Heredia.
See romantic listings, lakeside classified ads, rustic lists of marked properties, and rustic indexes that rental agents and property managers post on this webpage.
Glimpse, conceive, and come upon vacation homes for rent by owner, apartment rentals in Quesada Costa Rica, and Quesada Costa Rica house rentals.
Detect and ascertain the vicinity and proximate Volcano Arenal Costa Rica locality.
Recognize, come across, and perceive rental homes, condos for rent in Escazu, and Escazu Costa Rica short term rentals.
|
|
