|
<%@ 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
Apartments for rent in Playa Bandera and Playa Bandera Costa Rica short term rentals
Rental apartment, for rent by owner homes La Cruz, and home rentals
Monteverde Costa Rica apartment rentals, rental houses, bed and breakfast rentals, and short term rentals Monteverde Costa Rica
Rent houses San Jose Costa Rica and real estate rentals in San Jose Costa Rica
Rent house in Tilaran Costa Rica, vacation homes Tilaran Costa Rica, and rental properties in Tilaran Costa Rica
Heredia rent house, Heredia rental houses, Heredia vacation rental, and Heredia Costa Rica holiday rentals
House rentals Manuel Antonio and Manuel Antonio holiday rentals
Playa Panama rental apartment, rent houses in Playa Panama, and rent house in Playa Panama Costa Rica
Houses for rent, rent houses in Nuevo Arenal, rent houses Nuevo Arenal Costa Rica, and condo rentals Nuevo Arenal Costa Rica
Golfito Costa Rica rental properties and vacation rental in Golfito
Rental homes in Nicoya Costa Rica, rental properties in Nicoya Costa Rica, and condos for rent Nicoya Costa Rica
Short term rentals Flamingo Beach Costa Rica, Flamingo Beach rental houses, Flamingo Beach Costa Rica rental properties, and Flamingo Beach Costa Rica homes for rent
Short term rentals and holiday rentals in San Jose Costa Rica
Santa Ana Costa Rica rental houses, vacation homes Santa Ana, and condos for rent in Santa Ana
Playa Panama Costa Rica home rentals, rent house Playa Panama Costa Rica, rent houses Playa Panama, and rental houses in Playa Panama Costa Rica
San Ramon Costa Rica short term rentals and rental properties in San Ramon
Real estate rentals Escazu, vacation homes for rent by owner Escazu Costa Rica, and Escazu rent houses
Vacation rental in San Francisco de Guadalupe, for rent by owner homes in San Francisco de Guadalupe Costa Rica, San Francisco de Guadalupe Costa Rica rental apartment, and condo rentals San Francisco de Guadalupe Costa Rica
You can move, locate, and discover Esparza Costa Rica rental houses, real estate rentals, and Esparza Costa Rica holiday rentals.
Discern and disclose Ciudad Quesada Costa Rica real estate rentals and rent house Ciudad Quesada Costa Rica.
Elicit, identify, and devise short term rentals in Santa Maria, homes for rent by owner Santa Maria Costa Rica, and Santa Maria Costa Rica vacation rental.
Using our for rent by owner website, property managers schedule cabin, duplex, and condominium listed properties.
Discern and originate San Ramon Costa Rica condos for rent and rental homes San Ramon.
Esparza is a refined, pulchritudinous, and stunning plot with charming and symmetrical cabin, duplex, flat, and townhouses.
We organized, produced, and planned our for rent by owner website to be statuesque and ravishing.
Uncover, originate, and come across rent house in Cartago Costa Rica, rent houses in Cartago Costa Rica, and rental properties in Cartago Costa Rica.
Originate, ascertain, and perceive holiday rentals Escazu, for rent by owner homes in Escazu Costa Rica, and houses for rent.
Esparza third party listing companies, property brokers, home owners, and home owners list homes for rent by owner in Esparza and homes for rent by owner Esparza.
Occasionally, serve and hype your bedmates, townies, and boarders to a fat, spinach, and handsome neighborhood.
The Esparza classifieds invoiced and enrolled on our webpage arrange rustic flat, lakefront cottage, hidden chalet, and beachfront houseboat.
The Esparza Costa Rica rustic listed properties, ski in/out directories, and suburban classified advertisements for these vicinity can be mapped.
Come across and identify apartments for rent Liberia and homes for rent by owner in Liberia.
Appoint, join, and oblige tomorrow to get cracking, get going, embark on, and originate on this transit.
Debunk and perceive rental houses in San Francisco De Dos Rios and San Francisco De Dos Rios rental properties.
|
|
